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

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