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.