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     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    

Copyright © 2019, 2023, Oracle and/or its affiliates.