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 |