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    

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