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

Generated by
SchemaSpy
Legend:
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  √  null
usr_identity.identity_guid Implied Constraint R
Identity identifier
dn varchar 255  √  null 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

Analyzed at Mon Mar 26 23:24 EDT 2012


Close relationships: