# DW_ABS_ACRL_ENTRY_D

Stores Accrual header information

## Details

Module: Absence Management

## Key Columns

ACCRUAL_ENTRY_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ACCRUAL_ENTRY_ID | NUMBER | 38 | 0 | True | Accrual Entry Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. Functional key of records. Per Accrual Entry Id |  |
WORK_TERM_ASG_ID | NUMBER | 38 | 0 |  | Work Term Assignment Identifier |  |
ENTERPRISE_ID | NUMBER | 38 | 0 |  | Enterprise Identifier |  |
ACCRUAL_PERIOD | DATE |  |  |  | Accrual Period |  |
PERIOD_OF_SERVICE_ID | NUMBER | 38 | 0 |  | Period of Service Identifier |  |
PLAN_ID | NUMBER | 38 | 0 |  | Plan Identifier | DW_ABS_PLAN_D_TL | ABSENCE_PLAN_ID
BEGIN_BAL | NUMBER |  |  |  | Begin Balance |  |
ACCRUED_VALUE | NUMBER |  |  |  | Accrued Value |  |
USED_VALUE | NUMBER |  |  |  | Used Value |  |
END_BAL | NUMBER |  |  |  | End Balance |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier |  |
PLAN_ENRT_ID | NUMBER | 38 | 0 |  | Plan Enrollment Identifier |  |

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