# DW_PERSON_TYPE_USAGE_D

This dimension captures the Person Type Usage Details

## Details

Module: Recruiting

## Key Columns

EFFECTIVE_SEQUENCE, PERSON_TYPE_USAGE_ID, EFFECTIVE_LATEST_CHANGE, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PERSON_TYPE_USAGE_ID | NUMBER | 38 | 0 | True | Candidate profile usage identifier |  |
EFFECTIVE_START_DATE | DATE |  |  | True | Candidate profile effective start date |  |
EFFECTIVE_END_DATE | DATE |  |  | True | Candidate profile effective end date |  |
EFFECTIVE_SEQUENCE | NUMBER | 38 | 0 | True | Candidate profile effective sequence |  |
EFFECTIVE_LATEST_CHANGE | VARCHAR2 | 32 |  | True | Candidate profile effective latest change |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Unique Identifier |  |
PERSON_ID | NUMBER | 38 | 0 |  | Profile Identifier | DW_PERSON_D | PERSON_ID
SYSTEM_PERSON_TYPE | VARCHAR2 | 32 |  |  | Person Identifier |  |

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