DW_ABS_ACRL_ENTRY_DETAIL_F

Stores Accrual Details information

Details

Module: Absence Management

Key Columns

ACCRUAL_ENTRY_DTL_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ACCRUAL_ENTRY_DTL_ID NUMBER 38 0 True Accrual Entry Detail Identifier    
SOURCE_RECORD_ID VARCHAR2 512     Functional key of records. Per Accrual Entry Detail Id    
ACCRUAL_ENTRY_ID NUMBER 38 0   Accrual Entry Identifier DW_ABS_ACRL_ENTRY_D ACCRUAL_ENTRY_ID
ENTERPRISE_ID NUMBER 38 0   Enterprise Identifier    
VALUE NUMBER       Value    
TYPE VARCHAR2 32     Type    
ADJUSTMENT_REASON VARCHAR2 32     Adjustment Reason    
PERSON_ID NUMBER 38 0   Person Identifier DW_PERSON_D PERSON_ID
PLAN_ID NUMBER 38 0   Plan Identifier DW_ABS_PLAN_D ABSENCE_PLAN_ID
PROCD_DATE DATE       Processed Date    
ASSIGNMENT_ID NUMBER 38 0   Assignment Identifier    
ABSENCE_ENTRY_ID NUMBER 38 0   Absence Entry Identifier DW_ABS_ENTRY_D ABSENCE_ENTRY_ID
PLAN_ENRT_ID NUMBER 38 0   Plan Enrollment Identifier DW_ABS_PLAN_ENROLLMENT_D PLAN_ENRT_ID
WORK_TERM_ASG_ID NUMBER 38 0   Work Term Assignment Identifier    
EVENT_SOURCE VARCHAR2 16     Accrual Event Source    
EXPIRATION_DT DATE       Expiration Date    
ADJ_EXP_DT DATE       Adjustment Expiration Date    
ADJ_EXP_DT_REASON_CD VARCHAR2 32     Adjustment Expiration Reason Code    
REFERENCE_DATE DATE       Reference Date    
COMP_ADJ_REASON_CD VARCHAR2 999     Compensatory Adjustment Reason Code    
APPROVAL_STATUS_CD VARCHAR2 32     Approval Status Code    
RECIPIENT_PLAN_ENRT_ID NUMBER 38 0   Recipient Plan Enrollment Identifier DW_ABS_PLAN_ENROLLMENT_D PLAN_ENRT_ID
PROC_STATUS_CODE VARCHAR2 32     Process Status Code    

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