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     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)    

Copyright © 2019, 2023, Oracle and/or its affiliates.