FUND_HIERARCHY - Report
Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
CHART_OF_ACCOUNTS |
INSTITUTIONAL DEFINED VALUE FOR THE CHART OF ACCOUNTS. |
|
FTVFUND |
FTVFUND_COAS_CODE |
UNKNOWN |
CHART_OF_ACCOUNTS_DESC |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVCOAS |
FTVCOAS_TITLE |
UNKNOWN |
FUND |
"FUND CODE ASSOCIATED WITH THE LOAN APPLICATION. ONCE THE LOAN APPLICATION IS ESTABLISHED |
|
FTVFUND |
FTVFUND_FUND_CODE |
UNKNOWN |
FUND_DESC |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVFUND |
FTVFUND_TITLE |
UNKNOWN |
FUND_STATUS |
CURRENT STATUS OF THE ASSOCIATED FUND . |
|
FTVFUND |
FTVFUND_STATUS_IND |
UNKNOWN |
FUND_LEVEL |
|
|
FTVFUND |
FTVFUND_FUND_CODE |
UNKNOWN |
FUND_TYPE |
CLASSIFIES AN ACCOUNT TYPE I.E. |
|
FTVFUND |
FTVFUND_FTYP_CODE |
UNKNOWN |
FUND_TYPE_DESC |
DESCRIBES THE FUND TYPE CODE AND IDENTIFIES WHAT IT REPRESENTS. |
|
FTVFTYP |
FTVFTYP_TITLE |
UNKNOWN |
INTERNAL_FUND_TYPE |
|
|
FTVFTYP |
FTVFTYP_INTERNAL_FTYP_CODE |
UNKNOWN |
INTERNAL_FUND_TYPE_DESC |
|
|
FTVFTYP |
FTVFTYP_TITLE |
UNKNOWN |
FUND_LEVEL_1 |
PRIMARY FUND WITHIN THE FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_FUND_CODE |
UNKNOWN |
FUND_DESC_1 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVFUND |
FTVFUND_TITLE |
UNKNOWN |
FUND_STATUS_1 |
STATUS OF THE PRIMARY FUND WITHIN THE FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_STATUS_IND |
UNKNOWN |
FUND_LEVEL_2 |
LEVEL 2FUND WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_FUND_CODE |
UNKNOWN |
FUND_DESC_2 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVFUND |
FTVFUND_TITLE |
UNKNOWN |
FUND_STATUS_2 |
STATUS OF THE LEVEL 2FUND WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_STATUS_IND |
UNKNOWN |
FUND_LEVEL_3 |
LEVEL 3FUND WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_FUND_CODE |
UNKNOWN |
FUND_DESC_3 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVFUND |
FTVFUND_TITLE |
UNKNOWN |
FUND_STATUS_3 |
STATUS OF THE LEVEL 3FUND WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_STATUS_IND |
UNKNOWN |
FUND_LEVEL_4 |
LEVEL 4FUND WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_FUND_CODE |
UNKNOWN |
FUND_DESC_4 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVFUND |
FTVFUND_TITLE |
UNKNOWN |
FUND_STATUS_4 |
STATUS OF THE LEVEL 4FUND WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_STATUS_IND |
UNKNOWN |
FUND_LEVEL_5 |
LEVEL 5FUND WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_FUND_CODE |
UNKNOWN |
FUND_DESC_5 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVFUND |
FTVFUND_TITLE |
UNKNOWN |
FUND_STATUS_5 |
STATUS OF THE LEVEL 5FUND WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_STATUS_IND |
UNKNOWN |
FUND_TYPE_LEVEL |
|
|
FTVFUND |
FTVFUND_FTYP_CODE |
UNKNOWN |
FINANCIAL_MANAGER_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
FTVFUND |
FTVFUND_FMGR_CODE_PIDM |
UNKNOWN |
FINANCIAL_MANAGER_ID |
PERSON'S ID NUMBER USED TO ACCESS THE RECORDS ASSOCIATED WITH THE PERSON |
|
SPRIDEN |
SPRIDEN_ID |
UNKNOWN |
FMGR_LAST_NAME |
PERSON'S LAST NAME OR SURNAME. |
|
SPRIDEN |
SPRIDEN_LAST_NAME |
UNKNOWN |
FMGR_FIRST_NAME |
PERSON'S FIRST OR GIVEN NAME. |
|
SPRIDEN |
SPRIDEN_FIRST_NAME |
UNKNOWN |
FMGR_MIDDLE_NAME |
PERSON'S MIDDLE NAME |
|
SPRIDEN |
SPRIDEN_MI |
UNKNOWN |
STREET_LINE1 |
FIRST LINE OF THE PERSON'S ADDRESS. |
|
SPRADDR |
SPRADDR_STREET_LINE1 |
UNKNOWN |
STREET_LINE2 |
SECOND LINE OF THE PERSON'S ADDRESS. |
|
SPRADDR |
SPRADDR_STREET_LINE2 |
UNKNOWN |
STREET_LINE3 |
THIRD LINE OF THE PERSON'S ADDRESS. |
|
SPRADDR |
SPRADDR_STREET_LINE3 |
UNKNOWN |
STREET_LINE4 |
FOURTH LINE OF THE PERSON'S ADDRESS. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
CITY |
CITY IN THE ADDRESS FOR A PERSON OR ENTITY. |
|
SPRADDR |
SPRADDR_CITY |
UNKNOWN |
COUNTY |
COUNTY CODE FOR THIS ADDRESS. |
|
SPRADDR |
SPRADDR_CNTY_CODE |
UNKNOWN |
COUNTY_DESC |
NAME OF THE COUNTY FROM THE ADDRESS. |
|
STVCNTY |
STVCNTY_DESC |
UNKNOWN |
STATE_PROVINCE |
STATE/PROVINCE CODE OF THE ADDRESS. |
|
SPRADDR |
SPRADDR_STAT_CODE |
UNKNOWN |
STATE_PROVINCE_DESC |
DESCRIPTION ASSOCIATED WITH THE PERSON'S PREFERRED ADDRESS STATE/PROVINCE CODE. |
|
STVSTAT |
STVSTAT_DESC |
UNKNOWN |
POSTAL_CODE |
ADDRESS POST CODE OR ZIP CODE. |
|
SPRADDR |
SPRADDR_ZIP |
UNKNOWN |
NATION |
CODE WHICH IDENTIFIES A PARTICULAR COUNTRY. |
|
SPRADDR |
SPRADDR_NATN_CODE |
UNKNOWN |
NATION_DESC |
DESCRIPTION ASSOCIATED WITH THE PERSON'S PREFERRED ADDRESS NATION/COUNTRY CODE. |
|
STVNATN |
STVNATN_NATION |
UNKNOWN |
GRANT_ID |
GRANT CODE. |
|
FTVFUND |
FTVFUND_GRNT_CODE |
UNKNOWN |
GRANT_DESC |
NAME GIVEN TO IDENTIFY THIS GRANT. |
|
FRBGRNT |
FRBGRNT_TITLE |
UNKNOWN |
GRANT_STATUS |
|
|
FTVGRNT |
FTVGRNT_STATUS_IND |
UNKNOWN |
FUND_TYPE_LEVEL_1 |
PRIMARY FUND TYPE WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_FTYP_CODE |
UNKNOWN |
FUND_TYPE_DESC_1 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVFTYP |
FTVFTYP_TITLE |
UNKNOWN |
FUND_TYPE_STATUS_1 |
STATUS OF THE PRIMARY FUND TYPE WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFTYP_STATUS_IND |
UNKNOWN |
FUND_TYPE_LEVEL_2 |
LEVEL 2FUND TYPE WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_FTYP_CODE |
UNKNOWN |
FUND_TYPE_DESC_2 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVFTYP |
FTVFTYP_TITLE |
UNKNOWN |
FUND_TYPE_STATUS_2 |
STATUS OF THE LEVEL 2FUND TYPE WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFTYP_STATUS_IND |
UNKNOWN |
TERMINATION_DATE |
TERMINATION DATE OF THE EMPLOYEE. |
|
FTVFUND |
FTVFUND_TERM_DATE |
UNKNOWN |
EXPEND_END_DATE |
EXPENDITURE END DATE OF THE FUND CODE. |
|
FTVFUND |
FTVFUND_EXPEND_END_DATE |
UNKNOWN |