Contains identity profile information about users that have been collected by the reporting tool
|
identity_id |
VARCHAR(32) |
Auto generated unique identity identifier |
|
first_name |
VARCHAR(4000) |
First name |
|
last_name |
VARCHAR(4000) |
Last name |
|
middle_initial |
VARCHAR(4000) |
Middle name |
|
full_name |
VARCHAR(4000) |
Full name |
|
job_title |
VARCHAR(4000) |
Job title |
|
department |
VARCHAR(4000) |
Department |
|
location |
VARCHAR(4000) |
Location |
|
email_address |
VARCHAR(4000) |
Email address |
|
office_phone |
VARCHAR(4000) |
Office phone |
|
cell_phone |
VARCHAR(4000) |
Cell phone |
|
private_phone |
VARCHAR(4000) |
Private phone |
|
im_id |
VARCHAR(64) |
Instant messanger id |
|
mgr_id |
VARCHAR(32) |
The UUID for this user's manager |
|
photo |
TEXT(2147483647) |
This users photo |
|
idmrpt_valid_from |
TIMESTAMP WITHOUT TIME ZONE |
Date the user was created |
|
generational_qualifier |
VARCHAR(8) |
|
|
prefix |
VARCHAR(4000) |
Prefix |
|
preferred_name |
VARCHAR(4000) |
The prefix name |
|
preferred_language |
VARCHAR(4000) |
The prefix language |
|
job_code |
VARCHAR(4000) |
The user's job code |
|
workforce_id |
VARCHAR(4000) |
The user's workforce ID |
|
cost_center |
VARCHAR(4000) |
The user's cost center |
|
cost_center_description |
VARCHAR(4000) |
The description of the user's cost center |
|
employee_status |
VARCHAR(4000) |
The user's employee status |
|
employee_type |
VARCHAR(4000) |
The user's employee type |
|
company |
VARCHAR(4000) |
The company |
|
department_number |
VARCHAR(4000) |
The department number |
|
mailstop |
VARCHAR(4000) |
The mailstop |
|
office_number |
VARCHAR(4000) |
Physical Delivery Office Name |
|
street_address |
VARCHAR(4000) |
The street address |
|
city |
VARCHAR(4000) |
The city |
|
postal_code |
VARCHAR(4000) |
The postal code |
|
po_box |
VARCHAR(4000) |
The PO box |
|
fax_number |
VARCHAR(4000) |
The FAX number |
|
state |
VARCHAR(4000) |
The state the user resides in |
|
country |
VARCHAR(4000) |
The country the user resides in |
|
pager_number |
VARCHAR(4000) |
The user's pager number |
|
manager_flag |
bool |
TRUE if this user is a manager and FALSE otherwise |
|
manager_workforce_id |
VARCHAR(4000) |
The workforce ID of this user's manager |
|
hire_date |
TIMESTAMP WITH TIME ZONE |
The date this user was hired |
|
transfer_date |
TIMESTAMP WITH TIME ZONE |
The date this user was transferred |
|
termination_date |
TIMESTAMP WITH TIME ZONE |
The date this user's employment was terminated |
|
first_working_day |
TIMESTAMP WITH TIME ZONE |
The user's first working day |
|
last_working_day |
TIMESTAMP WITH TIME ZONE |
The user's last working day |
|
identity_desc |
VARCHAR(4000) |
|
|
idmrpt_syn_state |
int2 |