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