Stores Accrual header information
Module: Absence Management
ACCRUAL_ENTRY_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
ACCRUAL_ENTRY_ID | NUMBER | 38 | 0 | True | Accrual Entry Identifier | ||
SOURCE_RECORD_ID | VARCHAR2 | 512 | Functional key of records. Per Accrual Entry Id | ||||
WORK_TERM_ASG_ID | NUMBER | 38 | 0 | Work Term Assignment Identifier | |||
ENTERPRISE_ID | NUMBER | 38 | 0 | Enterprise Identifier | |||
ACCRUAL_PERIOD | DATE | Accrual Period | |||||
PERIOD_OF_SERVICE_ID | NUMBER | 38 | 0 | Period of Service Identifier | |||
PLAN_ID | NUMBER | 38 | 0 | Plan Identifier | DW_ABS_PLAN_D_TL | ABSENCE_PLAN_ID | |
BEGIN_BAL | NUMBER | Begin Balance | |||||
ACCRUED_VALUE | NUMBER | Accrued Value | |||||
USED_VALUE | NUMBER | Used Value | |||||
END_BAL | NUMBER | End Balance | |||||
PERSON_ID | NUMBER | 38 | 0 | Person Identifier | |||
PLAN_ENRT_ID | NUMBER | 38 | 0 | Plan Enrollment Identifier |
Copyright © 2019, 2022, Oracle and/or its affiliates.