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