FUND CENTER HIERARCHY Table
Fund Center Hierarchy
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FUND_CENTER_ID |
Six-digit number identifying the fund center (example: 100088 Music, 100152 Division of Toxicology). |
VARCHAR2 |
6 |
FUND_CENTER_ID_LEVEL1 |
XXX |
VARCHAR2 |
6 |
FUND_CENTER_ID_LEVEL10 |
XXX |
VARCHAR2 |
6 |
FUND_CENTER_ID_LEVEL2 |
XXX |
VARCHAR2 |
6 |
FUND_CENTER_ID_LEVEL3 |
XXX |
VARCHAR2 |
6 |
FUND_CENTER_ID_LEVEL4 |
XXX |
VARCHAR2 |
6 |
FUND_CENTER_ID_LEVEL5 |
XXX |
VARCHAR2 |
6 |
FUND_CENTER_ID_LEVEL6 |
XXX |
VARCHAR2 |
6 |
FUND_CENTER_ID_LEVEL7 |
XXX |
VARCHAR2 |
6 |
FUND_CENTER_ID_LEVEL8 |
XXX |
VARCHAR2 |
6 |
FUND_CENTER_ID_LEVEL9 |
XXX |
VARCHAR2 |
6 |
FUND_CENTER_KEY |
Key used only for joining the FINANCIAL_DETAIL table with other tables, NOT for reporting. |
VARCHAR2 |
16 |
FUND_CENTER_NAME |
Name of the Fund Center/source of revenue. |
VARCHAR2 |
40 |
FUND_CENTER_NAME_LEVEL1 |
XXX |
VARCHAR2 |
50 |
FUND_CENTER_NAME_LEVEL10 |
XXX |
VARCHAR2 |
50 |
FUND_CENTER_NAME_LEVEL2 |
XXX |
VARCHAR2 |
50 |
FUND_CENTER_NAME_LEVEL3 |
XXX |
VARCHAR2 |
50 |
FUND_CENTER_NAME_LEVEL4 |
XXX |
VARCHAR2 |
50 |
FUND_CENTER_NAME_LEVEL5 |
XXX |
VARCHAR2 |
50 |
FUND_CENTER_NAME_LEVEL6 |
XXX |
VARCHAR2 |
50 |
FUND_CENTER_NAME_LEVEL7 |
XXX |
VARCHAR2 |
50 |
FUND_CENTER_NAME_LEVEL8 |
XXX |
VARCHAR2 |
50 |
FUND_CENTER_NAME_LEVEL9 |
XXX |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |