Stores application identity profile information.
|
ms_identity_id |
VARCHAR(32) |
The auto-generated application identity identifier |
|
first_name |
VARCHAR(4000) |
The identity first name |
|
ms_uuid |
VARCHAR(4000) |
The application UUID |
|
ms_acct_id_value |
VARCHAR(4000) |
The application account ID value |
|
identity_id |
VARCHAR(32) |
The application UUID |
|
ms_identity_identifier |
VARCHAR(128) |
application identity identifier |
|
last_name |
VARCHAR(4000) |
identity last name |
|
middle_initial |
VARCHAR(4000) |
identity middle name |
|
full_name |
VARCHAR(4000) |
identity full name |
|
job_title |
VARCHAR(4000) |
job title |
|
department |
VARCHAR(4000) |
|
|
location |
VARCHAR(4000) |
|
|
email_address |
VARCHAR(4000) |
|
|
office_phone |
VARCHAR(4000) |
|
|
cell_phone |
VARCHAR(4000) |
|
|
private_phone |
VARCHAR(4000) |
|
|
im_id |
VARCHAR(64) |
instant messanger id. |
|
photo |
TEXT(2147483647) |
|
|
idmrpt_valid_from |
TIMESTAMP WITHOUT TIME ZONE |
|
|
generational_qualifier |
VARCHAR(8) |
|
|
prefix |
VARCHAR(4000) |
|
|
preferred_name |
VARCHAR(4000) |
|
|
preferred_language |
VARCHAR(8) |
|
|
job_code |
VARCHAR(4000) |
|
|
workforce_id |
VARCHAR(4000) |
|
|
cost_center |
VARCHAR(4000) |
|
|
cost_center_description |
VARCHAR(4000) |
|
|
employee_status |
VARCHAR(4000) |
|
|
employee_type |
VARCHAR(4000) |
|
|
company |
VARCHAR(4000) |
|
|
department_number |
VARCHAR(4000) |
|
|
mailstop |
VARCHAR(4000) |
|
|
office_number |
VARCHAR(4000) |
Physical Delivery Office Name |
|
street_address |
VARCHAR(4000) |
|
|
city |
VARCHAR(4000) |
|
|
postal_code |
VARCHAR(4000) |
|
|
state |
VARCHAR(4000) |
|
|
country |
VARCHAR(4000) |
|
|
pager_number |
VARCHAR(4000) |
|
|
manager_flag |
bool |
|
|
manager_workforce_id |
VARCHAR(4000) |
|
|
hire_date |
TIMESTAMP WITH TIME ZONE |
|
|
transfer_date |
TIMESTAMP WITH TIME ZONE |
|
|
termination_date |
TIMESTAMP WITH TIME ZONE |
|
|
first_working_day |
TIMESTAMP WITH TIME ZONE |
|
|
last_working_day |
TIMESTAMP WITH TIME ZONE |
|
|
identity_desc |
VARCHAR(4000) |
|
|
idmrpt_deleted |
bool |
|
|
idmrpt_syn_state |
int2 |