# DW_ABS_PLAN_ENROLLMENT_D

Stores Absence Plan Enrollment Details

## Details

Module: Absence Management

## Key Columns

PLAN_ENRT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PLAN_ENRT_ID | NUMBER | 38 | 0 | True | Plan Enrollment Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. Functional key of records. Plan Enrollment Id |  |
WORK_TERM_ASG_ID | NUMBER | 38 | 0 |  | Work Term Assignment Identifier |  |
LAST_ACCRUAL_RUN_DATE | DATE |  |  |  | Last Accrual Run Date |  |
ENTERPRISE_ID | NUMBER | 38 | 0 |  | Enterprise Identifier |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier |  |
PERIOD_OF_SERVICE_ID | NUMBER | 38 | 0 |  | Period of Service Identifier |  |
PLAN_ID | NUMBER | 38 | 0 |  | Plan Identifier |  |
ENRT_ST_DT | DATE |  |  |  | Enrollment Start Date |  |
ENRT_END_DT | DATE |  |  |  | Enrollment End Date |  |
WAIT_PERIOD_DUR_UOM | VARCHAR2 | 32 |  |  | Wait Period Duration Unit of Measure |  |
WAIT_PERIOD_DUR_UNITS | NUMBER |  |  |  | Wait Period Duration Units |  |
STATUS_CODE | VARCHAR2 | 32 |  |  | Status |  |

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