auditor.actor_usr_lifecycle (view)
|
This is a database view, not a base table. It has no triggers, indexes, or FK constraints of its own. Querying this view may be more efficient than joining the underlying tables directly. |
Columns
| Column | Type | Nullable | Notes |
|---|---|---|---|
audit_id |
|
Yes |
|
audit_time |
|
Yes |
|
audit_action |
|
Yes |
|
audit_user |
|
Yes |
|
audit_ws |
|
Yes |
|
id |
|
Yes |
|
card |
|
Yes |
|
profile |
|
Yes |
|
usrname |
|
Yes |
|
|
Yes |
||
passwd |
|
Yes |
|
standing |
|
Yes |
|
ident_type |
|
Yes |
|
ident_value |
|
Yes |
|
ident_type2 |
|
Yes |
|
ident_value2 |
|
Yes |
|
net_access_level |
|
Yes |
|
photo_url |
|
Yes |
|
prefix |
|
Yes |
|
first_given_name |
|
Yes |
|
second_given_name |
|
Yes |
|
family_name |
|
Yes |
|
suffix |
|
Yes |
|
guardian |
|
Yes |
|
pref_prefix |
|
Yes |
|
pref_first_given_name |
|
Yes |
|
pref_second_given_name |
|
Yes |
|
pref_family_name |
|
Yes |
|
pref_suffix |
|
Yes |
|
name_keywords |
|
Yes |
|
name_kw_tsvector |
|
Yes |
|
alias |
|
Yes |
|
day_phone |
|
Yes |
|
evening_phone |
|
Yes |
|
other_phone |
|
Yes |
|
mailing_address |
|
Yes |
|
billing_address |
|
Yes |
|
home_ou |
|
Yes |
|
dob |
|
Yes |
|
active |
|
Yes |
|
master_account |
|
Yes |
|
super_user |
|
Yes |
|
barred |
|
Yes |
|
deleted |
|
Yes |
|
juvenile |
|
Yes |
|
usrgroup |
|
Yes |
|
claims_returned_count |
|
Yes |
|
credit_forward_balance |
|
Yes |
|
last_xact_id |
|
Yes |
|
create_date |
|
Yes |
|
expire_date |
|
Yes |
|
claims_never_checked_out_count |
|
Yes |
|
last_update_time |
|
Yes |
|
locale |
|
Yes |
View Definition
SELECT '-1'::integer AS audit_id,
now() AS audit_time,
'-'::text AS audit_action,
'-1'::integer AS audit_user,
'-1'::integer AS audit_ws,
usr.id,
usr.card,
usr.profile,
usr.usrname,
usr.email,
usr.passwd,
usr.standing,
usr.ident_type,
usr.ident_value,
usr.ident_type2,
usr.ident_value2,
usr.net_access_level,
usr.photo_url,
usr.prefix,
usr.first_given_name,
usr.second_given_name,
usr.family_name,
usr.suffix,
usr.guardian,
usr.pref_prefix,
usr.pref_first_given_name,
usr.pref_second_given_name,
usr.pref_family_name,
usr.pref_suffix,
usr.name_keywords,
usr.name_kw_tsvector,
usr.alias,
usr.day_phone,
usr.evening_phone,
usr.other_phone,
usr.mailing_address,
usr.billing_address,
usr.home_ou,
usr.dob,
usr.active,
usr.master_account,
usr.super_user,
usr.barred,
usr.deleted,
usr.juvenile,
usr.usrgroup,
usr.claims_returned_count,
usr.credit_forward_balance,
usr.last_xact_id,
usr.create_date,
usr.expire_date,
usr.claims_never_checked_out_count,
usr.last_update_time,
usr.locale
FROM actor.usr
UNION ALL
SELECT actor_usr_history.audit_id,
actor_usr_history.audit_time,
actor_usr_history.audit_action,
actor_usr_history.audit_user,
actor_usr_history.audit_ws,
actor_usr_history.id,
actor_usr_history.card,
actor_usr_history.profile,
actor_usr_history.usrname,
actor_usr_history.email,
actor_usr_history.passwd,
actor_usr_history.standing,
actor_usr_history.ident_type,
actor_usr_history.ident_value,
actor_usr_history.ident_type2,
actor_usr_history.ident_value2,
actor_usr_history.net_access_level,
actor_usr_history.photo_url,
actor_usr_history.prefix,
actor_usr_history.first_given_name,
actor_usr_history.second_given_name,
actor_usr_history.family_name,
actor_usr_history.suffix,
actor_usr_history.guardian,
actor_usr_history.pref_prefix,
actor_usr_history.pref_first_given_name,
actor_usr_history.pref_second_given_name,
actor_usr_history.pref_family_name,
actor_usr_history.pref_suffix,
actor_usr_history.name_keywords,
actor_usr_history.name_kw_tsvector,
actor_usr_history.alias,
actor_usr_history.day_phone,
actor_usr_history.evening_phone,
actor_usr_history.other_phone,
actor_usr_history.mailing_address,
actor_usr_history.billing_address,
actor_usr_history.home_ou,
actor_usr_history.dob,
actor_usr_history.active,
actor_usr_history.master_account,
actor_usr_history.super_user,
actor_usr_history.barred,
actor_usr_history.deleted,
actor_usr_history.juvenile,
actor_usr_history.usrgroup,
actor_usr_history.claims_returned_count,
actor_usr_history.credit_forward_balance,
actor_usr_history.last_xact_id,
actor_usr_history.create_date,
actor_usr_history.expire_date,
actor_usr_history.claims_never_checked_out_count,
actor_usr_history.last_update_time,
actor_usr_history.locale
FROM auditor.actor_usr_history;