| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Source Name | 
Source Column | 
| 
ADMINISTRATIVE_GROUP
 | 
Administrative Group 
 | 
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 NA
 
 | 
 NA
 
 | 
| 
CHART_OF_ACCOUNTS
 | 
Chart Of Accounts 
 | 
Identifies the chart from other charts in a multi-chart environment.
 | 
VARCHAR2(63)
 | 
 FTVLOCN
 
 | 
 FTVLOCN_COAS_CODE
 
 | 
| 
CHART_OF_ACCOUNTS_DESC
 | 
Chart Of Accounts Description 
 | 
Chart of accounts code description or title.
 | 
VARCHAR2(255)
 | 
 FUNCTION
 
 | 
 F_GET_FINANCE_DESC
 
 | 
| 
CHART_OF_ACCOUNTS_STATUS
 | 
Chart Of Accounts Status
 | 
Status of the chart of accounts.
 | 
VARCHAR2(63)
 | 
 FTVCOAS
 
 | 
 FTVCOAS_STATUS_IND
 
 | 
| 
LOCATION
 | 
Location 
 | 
Identification accounting code for the physical location to which the grant has been assigned.
 | 
VARCHAR2(63)
 | 
 FTVLOCN
 
 | 
 FTVLOCN_LOCN_CODE
 
 | 
| 
LOCATION_DESC
 | 
Location Description 
 | 
Location code description or title.
 | 
VARCHAR2(255)
 | 
 FTVLOCN
 
 | 
 FTVLOCN_TITLE
 
 | 
| 
LOCATION_DESC_1
 | 
Location Description  1 
 | 
Description or title level 1 within this location hierarchy.
 | 
VARCHAR2(255)
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
LOCATION_DESC_2
 | 
Location Description  2 
 | 
Description or title level 2 within this location hierarchy.
 | 
VARCHAR2(255)
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
LOCATION_DESC_3
 | 
Location Description  3 
 | 
Description or title level 3 within this location hierarchy.
 | 
VARCHAR2(255)
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
LOCATION_DESC_4
 | 
Location Description  4 
 | 
Description or title level 4 within this location hierarchy.
 | 
VARCHAR2(255)
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
LOCATION_DESC_5
 | 
Location Description  5 
 | 
Description or title level 5 within this location hierarchy.
 | 
VARCHAR2(255)
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
LOCATION_LEVEL
 | 
Location Level 
 | 
Hierarchy description or title appropriate for this level.
 | 
NUMBER
 | 
 CALCULATION
 
 | 
 LEVEL
 
 | 
| 
LOCATION_LEVEL_1
 | 
Location Level  1 
 | 
Level 1 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
LOCATION_LEVEL_2
 | 
Location Level  2 
 | 
Level 2 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
LOCATION_LEVEL_3
 | 
Location Level  3 
 | 
Level 3 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
LOCATION_LEVEL_4
 | 
Location Level  4 
 | 
Level 4 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
LOCATION_LEVEL_5
 | 
Location Level  5 
 | 
Level 5 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
LOCATION_STATUS
 | 
Location Status 
 | 
Current status for the associated location.
 | 
VARCHAR2(63)
 | 
 FTVLOCN
 
 | 
 FTVLOCN_STATUS_IND
 
 | 
| 
LOCATION_STATUS_1
 | 
Location Status  1 
 | 
Status level 1 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
LOCATION_STATUS_2
 | 
Location Status  2 
 | 
Status level 2 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
LOCATION_STATUS_3
 | 
Location Status  3 
 | 
Status level 3 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
LOCATION_STATUS_4
 | 
Location Status  4 
 | 
Status level 4 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
LOCATION_STATUS_5
 | 
Location Status  5 
 | 
Status level 5 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
MULTI_SOURCE
 | 
Multi Source 
 | 
Institution value for the record when the optional multi-institution facility feature has been applied.
 | 
VARCHAR2(63)
 | 
 NA
 
 | 
 NA
 
 | 
| 
MULTI_SOURCE_DESC
 | 
Multi Source Description 
 | 
Institution description when the optional multi-institution facility feature has been applied.
 | 
VARCHAR2(255)
 | 
 NA
 
 | 
 NA
 
 | 
| 
PROCESS_GROUP
 | 
Process Group 
 | 
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 NA
 
 | 
 NA
 
 | 
| 
TERMINATION_DATE
 | 
Termination Date 
 | 
Date when this location is no longer in effect.
 | 
DATE
 | 
 FTVLOCN
 
 | 
 FTVLOCN_TERM_DATE
 
 |