DW_ABS_ACRL_ENTRY_D

Stores Accrual header information

Details

Module: Absence Management

Key Columns

ACCRUAL_ENTRY_ID

Columns

Columns
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 This column is for Oracle Internal use only. 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