# 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 |  |

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