DW_ABS_ACRL_ENTRY_D
Stores Accrual header information
Details
Module: Absence Management
Key Columns
ACCRUAL_ENTRY_ID
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 |