address_alert_matches(billing_address integer, mailing_address text, post_code text, country text, state text, county text, city text, street2 text, street1 boolean, org_unit boolean)

• Language: SQL
• Return Type: SET OF address_alert

approve_pending_address(pending_id integer)

• Language: PLPGSQL
• Return Type: bigint

au_updated()

• Language: PLPGSQL
• Return Type: trigger

calculate_system_penalties(context_org integer, match_user integer)

• Language: PLPGSQL
• Return Type: SET OF usr_standing_penalty

calculate_system_penalties_test(context_org integer, match_user integer)

• Language: PLPGSQL
• Return Type: SET OF usr_standing_penalty

crypt_pw_insert()

• Language: PLPGSQL
• Return Type: trigger

crypt_pw_update()

• Language: PLPGSQL
• Return Type: trigger

insert_usr_activity(ehow integer, ewhat text, ewho text, usr text)

• Language: PLPGSQL
• Return Type: SET OF usr_activity

org_unit_ancestor_at_depth(integer, integer)

• Language: SQL
• Return Type: org_unit

org_unit_ancestor_setting(org_id text, setting_name integer)

• Language: PLPGSQL
• Return Type: SET OF org_unit_setting

org_unit_ancestors(integer)

• Language: SQL
• Return Type: SET OF org_unit

org_unit_ancestors_distance(distance integer)

• Language: SQL
• Return Type: SET OF record

org_unit_combined_ancestors(integer, integer)

• Language: SQL
• Return Type: SET OF org_unit

org_unit_common_ancestors(integer, integer)

• Language: SQL
• Return Type: SET OF org_unit

org_unit_descendants(integer)

• Language: SQL
• Return Type: SET OF org_unit

org_unit_descendants(integer, integer)

• Language: SQL
• Return Type: SET OF org_unit

org_unit_descendants_distance(distance integer)

• Language: SQL
• Return Type: SET OF record

org_unit_full_path(integer)

• Language: SQL
• Return Type: SET OF org_unit

org_unit_full_path(integer, integer)

• Language: SQL
• Return Type: SET OF org_unit

org_unit_parent_protect()

• Language: PLPGSQL
• Return Type: trigger

org_unit_prox_update()

• Language: PLPGSQL
• Return Type: trigger

org_unit_proximity(integer, integer)

• Language: SQL
• Return Type: integer

org_unit_simple_path(integer, integer)

• Language: SQL
• Return Type: integer[]

stat_cat_check()

• Language: PLPGSQL
• Return Type: trigger

usr_activity_get_type(ehow text, ewhat text, ewho text)

• Language: SQL
• Return Type: SET OF usr_activity_type

usr_activity_transient_trg()

• Language: PLPGSQL
• Return Type: trigger

usr_delete(dest_usr integer, src_usr integer)

• Language: PLPGSQL
• Return Type: void

usr_merge(deactivate_cards integer, del_cards integer, del_addrs boolean, dest_usr boolean, src_usr boolean)

• Language: PLPGSQL
• Return Type: void

usr_merge_rows(dest_usr text, src_usr text, col_name integer, table_name integer)

• Language: PLPGSQL
• Return Type: void

usr_purge_data(specified_dest_usr integer, src_usr integer)

• Language: PLPGSQL
• Return Type: void