This table contains information about users who created or modified records in the source system from which the rows have been extracted. It has the users' contact and location information.Person information such as Supervisor, Department, Name etc. are current.
Module:
USERNAME
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
USERNAME | VARCHAR2 | 128 | True | User name. | |||
SOURCE_RECORD_ID | VARCHAR2 | 128 | Source record identifier. Value is same as the user name. | ||||
FIRST_NAME | VARCHAR2 | 256 | First name. | ||||
MIDDLE_NAME | VARCHAR2 | 256 | Middle name. | ||||
LAST_NAME | VARCHAR2 | 256 | Last name. | ||||
FULL_NAME | VARCHAR2 | 2048 | Full name. | ||||
NAME_PREFIX | VARCHAR2 | 256 | Name prefix. | ||||
NAME_SUFFIX | VARCHAR2 | 128 | Name suffix. | ||||
NAME_EFFECTIVE_START_DATE | TIMESTAMP | Effective start date for user name. | |||||
WORK_PHONE_NUMBER | VARCHAR2 | 256 | Work phone. | ||||
MOBILE_PHONE_NUMBER | VARCHAR2 | 256 | Mobile number. | ||||
PAGER_NUMBER | VARCHAR2 | 256 | Pager number. | ||||
FAX_NUMBER | VARCHAR2 | 256 | Fax number. | ||||
PRIMARY_EMAIL_ADDRESS | VARCHAR2 | 256 | Primary email. | ||||
SUPERVISOR_NAME | VARCHAR2 | 256 | Supervisor name. | ||||
DEPARTMENT_ID | NUMBER | 38 | 0 | Department. | |||
LOGIN_ID | VARCHAR2 | 256 | Login. | ||||
USER_FORMED_DATE | TIMESTAMP | Date of user account creation. | |||||
ACTIVE_FLAG | VARCHAR2 | 32 | User active flag. | ||||
PARTY_ID | NUMBER | 38 | 0 | User party id |