This table stores the absence plan summary details
Module: Absence Management
ABSENCE_PLAN_SUMMARY_ENTRY_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
ABSENCE_PLAN_SUMMARY_ENTRY_ID | NUMBER | 38 | 0 | True | Plan summary Identifier | ||
SOURCE_RECORD_ID | VARCHAR2 | 64 | Unique Source Record Identifier consisting of ABSENCE_PLAN_SUMMARY_ENTRY_ID | ||||
ENTERPRISE_ID | NUMBER | 38 | 0 | Enterprise identifier | |||
ABSENCE_ENTRY_ID | NUMBER | 38 | 0 | Absence header identifier | |||
PERSON_ID | NUMBER | 38 | 0 | Person Identifier | |||
PLAN_ID | NUMBER | 38 | 0 | Plan identifier | |||
ABSENCE_END_DATETIME | DATE | Absence end date | |||||
ABSENCE_START_DATETIME | DATE | Absence start date | |||||
CALCULATION_DATE | DATE | Date of calculation | |||||
ENTITLEMENT_DATE | DATE | Date of entitlement | |||||
PLAN_PERIOD_START_DATE | DATE | plan perios start date | |||||
QUALIFICATION_DATE | DATE | date of qulaification | |||||
PAY_FACTOR | NUMBER | Pay factor | |||||
UNITS | NUMBER | Units qualified | |||||
UOM_CODE | VARCHAR2 | 32 | Unit of measurement code | ||||
ACTIVITY_CODE | VARCHAR2 | 256 | Activity code | ||||
OVERRIDE_REASON_CODE | VARCHAR2 | 256 | Override reason code | ||||
SOURCE | VARCHAR2 | 256 | Source |
Copyright © 2019, 2022, Oracle and/or its affiliates.