Stores Accrual Details information
Module: Absence Management
ACCRUAL_ENTRY_DTL_ID
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.