VAPS DEPT Table
View exposing legacy VAPS department reference records including department numbers, department name components, department head, and department address.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DEPT_ADDRESS |
Department address. |
VARCHAR2 |
30 |
DEPT_HEAD |
Name of the department head. |
VARCHAR2 |
30 |
DEPT_NAME_KEY |
Key value used to identify the department name grouping. |
VARCHAR2 |
15 |
DEPT_NAME_REST |
Remaining or extended department name text. |
VARCHAR2 |
45 |
DEPT_NUM_2 |
Two-digit department grouping code. |
VARCHAR2 |
2 |
DEPT_NUM_4 |
Four-digit department number. |
VARCHAR2 |
4 |