Table SIEM.public.usr_identity
User's Identity information (for example, synchronized from Novell Identity Manager or Microsoft Active Directory)

Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
identity_guid uuid 2147483647
usr_account.identity_guid fk_usridty_usracct R
usr_account_rpt_v.identity_guid Implied Constraint R
usr_identity_ext_attr.identity_guid fk_usridty_extattr R
usr_identity_ext_attr_rpt_v.identity_guid Implied Constraint R
usr_identity_rpt_v.identity_guid Implied Constraint R
Identity identifier
dn varchar 255 Distinguished name
cust_id int8 19  √  null
cust.cust_id Implied Constraint R
Customer identifier
src_identity_id varchar 255  √  null Source identity identifier
wfid varchar 100  √  null Workforce identifier
first_name varchar 255  √  null First name
last_name varchar 255  √  null Last name
full_name varchar 255  √  null Full name
job_title varchar 255  √  null Job title
department_name varchar 100  √  null Department Name
office_loc_cd varchar 100  √  null Office Location Code
primary_email varchar 255  √  null Primary e-mail address
primary_phone varchar 100  √  null Primary phone number
vault_name varchar 100  √  null Identity vault name
mgr_guid uuid 2147483647  √  null Manager identity identifier
photo text 2147483647  √  null Photo
date_created timestamptz 35,6  √  null Date the entry was created
date_modified timestamptz 35,6  √  null Date the entry was modified
created_by int4 10  √  null User who created object
modified_by int4 10  √  null User who last modified object

Table contained 0 rows at Mon Mar 26 23:24 EDT 2012

Column(s) Type Sort Constraint Name
identity_guid Primary key Asc usr_identity_pk
dn + vault_name + cust_id Must be unique Asc/Asc/Asc usr_identity_uk1

Close relationships: