Routines
| Name | Type | Language | Deterministic | Return Type | Security Restriction | Comments |
|---|---|---|---|---|---|---|
| org_unit_full_path(integer) | FUNCTION | sql | false | SETOF actor.org_unit | INVOKER | |
| set_passwd(pw_usr integer, pw_type text, new_pass text, new_salt text DEFAULT NULL::text) | FUNCTION | plpgsql | false | boolean | INVOKER | |
| org_unit_proximity(integer, integer) | FUNCTION | sql | false | integer | INVOKER | |
| calculate_system_penalties(match_user integer, context_org integer) | FUNCTION | plpgsql | false | SETOF actor.usr_standing_penalty | INVOKER | |
| usr_delete(src_usr integer, dest_usr integer) | FUNCTION | plpgsql | false | void | INVOKER | Logically deletes a user. Removes personally identifiable information, and purges associated data in other tables. |
| create_salt(pw_type text) | FUNCTION | plpgsql | false | text | INVOKER | |
| org_unit_full_path(integer, integer) | FUNCTION | sql | false | SETOF actor.org_unit | INVOKER | |
| org_unit_descendants(integer) | FUNCTION | sql | false | SETOF actor.org_unit | INVOKER | |
| org_unit_ancestor_at_depth(integer, integer) | FUNCTION | sql | false | actor.org_unit | INVOKER | |
| org_unit_ancestors(integer) | FUNCTION | sql | false | SETOF actor.org_unit | INVOKER | |
| get_cascade_setting_batch(setting_names text[], org_id integer, user_id integer, workstation_id integer) | FUNCTION | plpgsql | false | SETOF actor.cascade_setting_summary | INVOKER | |
| restrict_usr_message_limited() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| org_unit_combined_ancestors(integer, integer) | FUNCTION | sql | false | SETOF actor.org_unit | INVOKER | |
| org_unit_ancestor_setting_batch_by_org(setting_name text, org_ids integer[]) | FUNCTION | plpgsql | false | SETOF actor.org_unit_setting | INVOKER | |
| permit_remoteauth(profile_name text, userid bigint) | FUNCTION | plpgsql | false | text | INVOKER | |
| org_unit_descendants_distance(integer) | FUNCTION | sql | false | TABLE(id integer, distance integer) | INVOKER | |
| usr_activity_get_type(ewho text, ewhat text, ehow text) | FUNCTION | sql | false | SETOF config.usr_activity_type | INVOKER | |
| org_unit_ancestor_setting(setting_name text, org_id integer) | FUNCTION | plpgsql | false | SETOF actor.org_unit_setting | INVOKER | Search “up” the org_unit tree until we find the first occurrence of an org_unit_setting with the given name. |
| org_unit_ancestors_distance(integer) | FUNCTION | sql | false | TABLE(id integer, distance integer) | INVOKER | |
| address_alert_matches(org_unit integer, street1 text, street2 text, city text, county text, state text, country text, post_code text, mailing_address boolean DEFAULT false, billing_address boolean DEFAULT false) | FUNCTION | sql | false | SETOF actor.address_alert | INVOKER | |
| get_salt(pw_usr integer, pw_type text) | FUNCTION | plpgsql | false | text | INVOKER | |
| org_unit_ancestor_setting_batch(org_id integer, setting_names text[]) | FUNCTION | plpgsql | false | SETOF actor.org_unit_setting | INVOKER | For each setting name passed, search “up” the org_unit tree until we find the first occurrence of an org_unit_setting with the given name. |
| usr_merge(src_usr integer, dest_usr integer, del_addrs boolean, del_cards boolean, deactivate_cards boolean) | FUNCTION | plpgsql | false | void | INVOKER | Merges all user date from src_usr to dest_usr. When collisions occur, keep dest_usr’s data and delete src_usr’s data. |
| usr_purge_data(src_usr integer, specified_dest_usr integer) | FUNCTION | plpgsql | false | void | INVOKER | Finds rows dependent on a given row in actor.usr and either deletes them or reassigns them to a different user. |
| au_updated() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| migrate_passwd(pw_usr integer) | FUNCTION | plpgsql | false | text | INVOKER | |
| stat_cat_check() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| purge_usr_activity_by_type(act_type integer) | FUNCTION | plpgsql | false | void | INVOKER | |
| get_cascade_setting(setting_name text, org_id integer, user_id integer, workstation_id integer) | FUNCTION | plpgsql | false | actor.cascade_setting_summary | INVOKER | |
| usr_activity_transient_trg() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| usr_merge_rows(table_name text, col_name text, src_usr integer, dest_usr integer) | FUNCTION | plpgsql | false | void | INVOKER | Attempts to move each row of the specified table from src_user to dest_user. |
| crypt_pw_update() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| crypt_pw_insert() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| insert_usr_activity(usr integer, ewho text, ewhat text, ehow text) | FUNCTION | plpgsql | false | SETOF actor.usr_activity | INVOKER | |
| verify_passwd(pw_usr integer, pw_type text, test_passwd text) | FUNCTION | plpgsql | false | boolean | INVOKER | |
| approve_pending_address(pending_id integer) | FUNCTION | plpgsql | false | bigint | INVOKER | Replaces an address with a pending address. This is done by giving the pending address the ID of the old address. The replaced address is retained with -id. |
| org_unit_descendants(integer, integer) | FUNCTION | sql | false | SETOF actor.org_unit | INVOKER | |
| org_unit_simple_path(integer, integer) | FUNCTION | sql | false | integer[] | INVOKER | |
| org_unit_common_ancestors(integer, integer) | FUNCTION | sql | false | SETOF actor.org_unit | INVOKER | |
| org_unit_prox_update() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| user_ingest_name_keywords() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| change_password(user_id integer, new_pw text, pw_type text DEFAULT 'main'::text) | FUNCTION | plpgsql | false | void | INVOKER | Allows setting a salted password for a user by passing actor.usr id and the text of the password. |
| org_unit_parent_protect() | FUNCTION | plpgsql | false | trigger | INVOKER |