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 |