MASTER DEPT DCODE PARENT Table
View exposing parent-child relationships between master departments and D-codes used for organizational hierarchy and rollup reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DEPT_ID |
Business identifier for the dept. |
NUMBER |
10 |
D_CODE |
Code identifying d. |
VARCHAR2 |
180 |
D_NAME |
D name associated with the record. |
VARCHAR2 |
840 |
PARENT_D_CODE |
Code identifying parent d. |
VARCHAR2 |
180 |
PARENT_D_NAME |
Parent d name associated with the record. |
VARCHAR2 |
840 |
PARENT_ID |
Business identifier for the parent. |
NUMBER |
10 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |