DW_USER_PERSON_D

It stores one record per fusion system user.

Details

Module: Global Human Resources

Key Columns

USER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
USER_ID NUMBER 38 0 True System generated primary key column
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Unique Source Record Identifier This column contains USER_ID.
USER_GUID VARCHAR2 128 The latest user Guid of the user.
USERNAME VARCHAR2 128 The latest principal username of the user
PERSON_ID NUMBER 38 0 Person ID in HCM for this user (if available)
ACTIVE_FLAG VARCHAR2 32 User is active or Inactive