Stores Absence Plan Enrollment Details
Module: Absence Management
PLAN_ENRT_ID
| 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, 2024, Oracle and/or its affiliates.