HR AAP ORG UNITS Table
Stores mappings between AAP organizational units and HR organizational units by AAP plan year, including titles, department abbreviations, and change tracking.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AAP_PLAN_YEAR |
AAP plan year associated with the unit mapping. |
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 |
12 |
CHANGED_ON |
Date the record was last changed. |
DATE |
|
DELETE_FLAG |
Indicator identifying whether the mapping is marked deleted (Y/N). |
VARCHAR2 |
1 |
HR_DEPARTMENT_ABBR |
HR department abbreviation associated with the organizational unit. |
VARCHAR2 |
12 |
HR_ORG_UNIT_TITLE |
HR organizational unit title. |
VARCHAR2 |
75 |
ORG_UNIT_ID |
HR organizational unit identifier associated with the AAP unit. |
VARCHAR2 |
8 |
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 |