DW_ABS_ACRL_PERIOD_D

Stores accrual period information for period type

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
PLAN_ID NUMBER 38 0 Plan Identifier
ACCRUAL_PERIOD DATE Accrual Period
ASSIGNMENT_ID NUMBER 38 0 Assignment Identifier
PERIOD_END_DATE DATE Period End Date
ACCRUAL_PERIOD_TYPE VARCHAR2 32 Period type of the accrual enteries
PAYROLL_ID NUMBER 38 0 Payroll identifier
RESOLVED_TIME_PERIOD_ID NUMBER 38 0 Resolved time period identifier