# DW_PERSON_SERVICE_PERIOD_TYPE_D

This table stores the enterprise hire date per person and period type for period of service

## Details

Module: Global Human Resources

## Key Columns

PERIOD_TYPE, PERSON_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PERSON_ID | NUMBER | 38 | 0 | True | Person Identifier |  |
PERIOD_TYPE | VARCHAR2 | 32 |  | True | Determines whether it is a period of service for an Employee, or Contingent worker: E, C, or N: non-worker. |  |
SOURCE_RECORD_ID | VARCHAR2 | 32 |  |  | This column is for Oracle Internal use only. Source Record Identifier Consists of Period of Service Identifier |  |
ENTERPRISE_HIRE_DATE | DATE |  |  |  | Minimum start date of the period of employment |  |

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