HR AAP UNITS Table
Stores AAP organizational unit reference data by plan year, including unit names and change tracking.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AAP_PLAN_YEAR |
AAP plan year associated with the unit definition. |
VARCHAR2 |
4 |
AAP_UNIT |
Name/description of the AAP organizational unit. |
VARCHAR2 |
80 |
AAP_UNIT_ID |
Identifier for the AAP organizational unit. |
VARCHAR2 |
8 |
AAP_UNIT_SHORT_NAME |
Short name for the AAP organizational unit. |
VARCHAR2 |
15 |
CHANGED_BY |
User identifier indicating who last changed the record. |
VARCHAR2 |
20 |
CHANGED_ON |
Date the record was last changed. |
DATE |
|
DELETE_FLAG |
Indicator identifying whether the unit is marked deleted (Y/N). |
VARCHAR2 |
1 |
WAREHOUSE_CREATE_DATE |
Date the record was created in the warehouse. |
DATE |
|
WAREHOUSE_UPDATE_DATE |
Date the record was last updated in the warehouse. |
DATE |