| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Domain Value | 
Source Name | 
Source Column | 
| 
ACCOUNT
 | 
Account 
 | 
Code representing an account, such as revenue, labor, expenditure or transfer.
 | 
VARCHAR2(63)
 | 
 
 | 
 FRRGRNL
 
 | 
 FRRGRNL_ACCT_CODE
 
 | 
| 
ACCOUNT_CLASS
 | 
Account Class 
 | 
Class defines major accounting groups used in the system for fixed assets, endowments, sponsored research.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVACCT
 
 | 
 FTVACCT_ACCT_CLASS_CODE
 
 | 
| 
ACCOUNT_CLASS_DESC
 | 
Account Class Description 
 | 
Account class description.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_SDAT_TITLE
 
 | 
| 
ACCOUNT_DESC
 | 
Account Description 
 | 
Account code description or title.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 F_GET_FINANCE_DESC
 
 | 
| 
ACCOUNT_DESC_1
 | 
Account Description  1 
 | 
Description or title level 1 within this account hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ACCOUNT_DESC_2
 | 
Account Description  2 
 | 
Description or title level 2 within this account hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ACCOUNT_DESC_3
 | 
Account Description  3 
 | 
Description or title level 3 within this account hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ACCOUNT_DESC_4
 | 
Account Description  4 
 | 
Description or title level 4 within this account hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ACCOUNT_LEVEL_1
 | 
Account Level  1 
 | 
Level 1 account within this account hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ACCOUNT_LEVEL_2
 | 
Account Level  2 
 | 
Level 2 account within this account hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ACCOUNT_LEVEL_3
 | 
Account Level  3 
 | 
Level 3 account within this account hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ACCOUNT_LEVEL_4
 | 
Account Level  4 
 | 
Level 4 account within this account hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ACCOUNT_POOL
 | 
Account Pool
 | 
Account used for budgeting purposes.  If the account pool does not exist, it is replaced with account for available balance checking.
 | 
VARCHAR2(63)
 | 
 
 | 
 CALCULATION
 
 | 
 NVL(FTVACCT_ACCT_CODE_POOL,FTVACCT_ACCT_CODE)
 
 | 
| 
ACCOUNT_POOL_DESC
 | 
Account Pool Description
 | 
Account pool description. If the account pool is not found, then its description is replaced with account description, for available balance checking.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 F_GET_FINANCE_DESC
 
 | 
| 
ACCOUNT_STATUS
 | 
Account Status
 | 
Status of the account.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVACCT
 
 | 
 FTVACCT_STATUS_IND
 
 | 
| 
ACCOUNT_STATUS_1
 | 
Account Status  1 
 | 
Status of level 1 account within this account hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ACCOUNT_STATUS_2
 | 
Account Status  2 
 | 
Status of level 2 account within this account hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ACCOUNT_STATUS_3
 | 
Account Status  3 
 | 
Status of level 3 account within this account hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ACCOUNT_STATUS_4
 | 
Account Status  4 
 | 
Status of level 4 account within this account hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ACCOUNT_TYPE_DESC_1
 | 
Account Type Description  1 
 | 
Description or title level 1 within this account type hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FTVATYP
 
 | 
 FTVATYP_TITLE
 
 | 
| 
ACCOUNT_TYPE_DESC_2
 | 
Account Type Description  2 
 | 
Description or title level 2 within this account type hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FTVATYP
 
 | 
 FTVATYP_TITLE
 
 | 
| 
ACCOUNT_TYPE_LEVEL_1
 | 
Account Type Level  1 
 | 
Level 1 account type grouping within this account type hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVATYP
 
 | 
 FTVATYP_ATYP_CODE
 
 | 
| 
ACCOUNT_TYPE_LEVEL_2
 | 
Account Type Level  2 
 | 
Level 2 account type grouping within this account type hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVATYP
 
 | 
 FTVATYP_ATYP_CODE
 
 | 
| 
ACCOUNT_TYPE_STATUS_1
 | 
Account Type Status  1 
 | 
Status of level 1 account type within this account type hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVATYP
 
 | 
 FTVATYP_STATUS_IND
 
 | 
| 
ACCOUNT_TYPE_STATUS_2
 | 
Account Type Status  2 
 | 
Status of level 2 account type within this account type hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVATYP
 
 | 
 FTVATYP_STATUS_IND
 
 | 
| 
ACTIVITY
 | 
Activity 
 | 
Code used to identify accounting data by activity.
 | 
VARCHAR2(63)
 | 
 
 | 
 FRRGRNL
 
 | 
 FRRGRNL_ACTV_CODE
 
 | 
| 
ACTIVITY_DESC
 | 
Activity Description 
 | 
Activity code title or description.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 F_GET_FINANCE_DESC
 
 | 
| 
ACTIVITY_STATUS
 | 
Activity Status
 | 
Status of the activity.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVACTV
 
 | 
 FTVACTV_STATUS_IND
 
 | 
| 
ADMINISTRATIVE_GROUP
 | 
Administrative Group 
 | 
Organization-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)
 | 
 
 | 
 FRRGRNL
 
 | 
 FRRGRNL_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
 
 | 
| 
CURR_ACCOUNTED_BUDGET
 | 
Curr Accounted Budget 
 | 
Current period accounted budget.
 | 
NUMBER
 | 
 
 | 
 CALCULATION
 
 | 
 FRRGRNL_XX_ACCTD_BUD - FRRGRNL_XX-1_ACCTD_BUD
 
 | 
| 
CURR_ADOPTED_BUDGET
 | 
Curr Adopted Budget 
 | 
Current period adopted budget.
 | 
NUMBER
 | 
 
 | 
 CALCULATION
 
 | 
 FRRGRNL_XX_ADOPT_BUD - FRRGRNL_XX-1_ADOPT_BUD
 
 | 
| 
CURR_BUDGET_ADJUSTMENTS
 | 
Curr Budget Adjustments 
 | 
Current period budget adjustments.
 | 
NUMBER
 | 
 
 | 
 CALCULATION
 
 | 
 FRRGRNL_XX_BUD_ADJT - FRRGRNL_XX-1_BUD_ADJT
 
 | 
| 
CURR_BUDGET_RESERVATIONS
 | 
Curr Budget Reservations 
 | 
Current period budget reservations that typically represents requisition encumbrances.
 | 
NUMBER
 | 
 
 | 
 CALCULATION
 
 | 
 FRRGRNL_XX_BUD_RSRV - FRRGRNL_XX-1_BUD_RSRV
 
 | 
| 
CURR_ENCUMBRANCES
 | 
Curr Encumbrances 
 | 
Current period encumbrances that typically represent purchase order, labor and general encumbrances.
 | 
NUMBER
 | 
 
 | 
 CALCULATION
 
 | 
 FRRGRNL_XX_ENCUMB - FRRGRNL_XX-1_ENCUMB
 
 | 
| 
CURR_MEMO_COSTS
 | 
Curr Memo Costs 
 | 
Current period memo costs which typically represents expenses, labor, revenue and transfers.
 | 
NUMBER
 | 
 
 | 
 CALCULATION
 
 | 
 FRRMEML_XX_YTD_ACTV - FRRMEML_XX-1_YTD_ACTV
 
 | 
| 
CURR_REMAINING_BALANCE
 | 
Curr Remaining Balance 
 | 
Calculated current period remaining balance as: adopted budget plus budget adjustments minus year to date activity - encumbrances - budget reservations.
 | 
NUMBER
 | 
 
 | 
 CALCULATION
 
 | 
 (FRRGRNL_XX_ADOPT_BUD + FRRGRNL_XX_BUD_ADJT) - (FRRGRNL_XX_YTD_ACTV + FRRGRNL_XX_ENCUMB + FRRGRNL_XX_BUD_RSRV) - (FRRGRNL_XX-1_ADOPT_BUD + FRRGRNL_XX-1_BUD_ADJT) - (FRRGRNL_XX-1_YTD_ACTV + FRRGRNL_XX-1_ENCUMB + FRRGRNL_XX-1_BUD_RSRV)
 
 | 
| 
CURR_TEMPORARY_BUDGET
 | 
Curr Temporary Budget 
 | 
Current period temporary budget.
 | 
NUMBER
 | 
 
 | 
 CALCULATION
 
 | 
 FRRGRNL_XX_TEMP_BUD - FRRGRNL_XX-1_TEMP_BUD
 
 | 
| 
CURR_YEAR_TO_DATE_ACTIVITY
 | 
Curr Year To Date Activity 
 | 
Current period activity which typically represents expenses, labor, revenue and transfers.
 | 
NUMBER
 | 
 
 | 
 CALCULATION
 
 | 
 FRRGRNL_XX_YTD_ACTV - FRRGRNL_XX-1_YTD_FRRGRNL
 
 | 
| 
FISCAL_PERIOD
 | 
Fiscal Period 
 | 
Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14.
 | 
VARCHAR2(252)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GRANT_TO_FISCAL_YEAR
 
 | 
| 
FISCAL_YEAR
 | 
Fiscal Year 
 | 
Unique identifier or code for the fiscal year.
 | 
VARCHAR2(252)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GRANT_TO_FISCAL_YEAR
 
 | 
| 
FUND
 | 
Fund 
 | 
Unique fiscal entity code.
 | 
VARCHAR2(63)
 | 
 
 | 
 FRRGRNL
 
 | 
 FRRGRNL_FUND_CODE
 
 | 
| 
FUND_DESC
 | 
Fund Description 
 | 
Description or title of the associated fund.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 F_GET_FINANCE_DESC
 
 | 
| 
FUND_DESC_1
 | 
Fund Description  1 
 | 
Description or title level 1 within this fund hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
FUND_DESC_2
 | 
Fund Description  2 
 | 
Description or title level 2 within this fund hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
FUND_DESC_3
 | 
Fund Description  3 
 | 
Description or title level 3 within this fund hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
FUND_DESC_4
 | 
Fund Description  4 
 | 
Description or title level 4 within this fund hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
FUND_DESC_5
 | 
Fund Description  5 
 | 
Description or title level 5 within this fund hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
FUND_LEVEL_1
 | 
Fund Level  1 
 | 
Level 1 fund within this fund hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
FUND_LEVEL_2
 | 
Fund Level  2 
 | 
Level 2 fund within this fund hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
FUND_LEVEL_3
 | 
Fund Level  3 
 | 
Level 3 fund within this fund hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
FUND_LEVEL_4
 | 
Fund Level  4 
 | 
Level 4 fund within this fund hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
FUND_LEVEL_5
 | 
Fund Level  5 
 | 
Level 5 fund within this fund hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
FUND_POOL
 | 
Fund Pool
 | 
Fund used for budgeting purposes.  If the fund pool does not exist, it is replaced with fund for available balance checking.
 | 
VARCHAR2(63)
 | 
 
 | 
 CALCULATION
 
 | 
 NVL(FTVFUND_FUND_CODE_BAVL,FTVFUND_FUND_CODE)
 
 | 
| 
FUND_POOL_DESC
 | 
Fund Pool Description
 | 
Fund pool description. If the fund pool is not found, then its description is replaced with fund description, for available balance checking.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 F_GET_FINANCE_DESC
 
 | 
| 
FUND_STATUS
 | 
Fund Status
 | 
Status of the fund.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVFUND
 
 | 
 FTVFUND_STATUS_IND
 
 | 
| 
FUND_STATUS_1
 | 
Fund Status  1 
 | 
Status of level 1 fund within this fund hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
FUND_STATUS_2
 | 
Fund Status  2 
 | 
Status of level 2 fund within this fund hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
FUND_STATUS_3
 | 
Fund Status  3 
 | 
Status of level 3 fund within this fund hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
FUND_STATUS_4
 | 
Fund Status  4 
 | 
Status of level 4 fund within this fund hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
FUND_STATUS_5
 | 
Fund Status  5 
 | 
Status of level 5 fund within this fund hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
FUND_TYPE_DESC_1
 | 
Fund Type Description  1 
 | 
Description or title level 1 within this fund type hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FTVFTYP
 
 | 
 FTVFTYP_TITLE
 
 | 
| 
FUND_TYPE_DESC_2
 | 
Fund Type Description  2 
 | 
Description or title level 2 within this fund type hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FTVFTYP
 
 | 
 FTVFTYP_TITLE
 
 | 
| 
FUND_TYPE_LEVEL_1
 | 
Fund Type Level  1 
 | 
Level 1 fund type grouping within this fund type hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVFTYP
 
 | 
 FTVFTYP_FTYP_CODE
 
 | 
| 
FUND_TYPE_LEVEL_2
 | 
Fund Type Level  2 
 | 
Level 2 fund type grouping within this fund type hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVFTYP
 
 | 
 FTVFTYP_FTYP_CODE
 
 | 
| 
FUND_TYPE_STATUS_1
 | 
Fund Type Status  1 
 | 
Status of level 1 fund type within this fund type hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVFTYP
 
 | 
 FTVFTYP_STATUS_IND
 
 | 
| 
FUND_TYPE_STATUS_2
 | 
Fund Type Status  2 
 | 
Status of level 2 fund type within this fund type hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVFTYP
 
 | 
 FTVFTYP_STATUS_IND
 
 | 
| 
GRANT_ID
 | 
Grant ID 
 | 
Unique user defined or system generated one-up number for this grant.
 | 
VARCHAR2(63)
 | 
 
 | 
 FRRGRNL
 
 | 
 FRRGRNL_GRNT_CODE
 
 | 
| 
GRANT_PERIOD
 | 
Grant Period 
 | 
Unique two-digit identifier of a period within a grant year. Generally this contains values between 00 and 14.
 | 
VARCHAR2(63)
 | 
 
 | 
 CONSTANT
 
 | 
 HARD CODED VALUES '00' THROUGH '14'
 
 | 
| 
GRANT_TITLE
 | 
Grant Title 
 | 
Shortened name or title for the grant.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FRKIDEN.F_GET_FRBGRNT_TITLE
 
 | 
| 
GRANT_YEAR
 | 
Grant Year 
 | 
Converted unique two-digit identifier code for the grant year to a four-digit year.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOFYCNV
 
 | 
| 
INTERNAL_ACCOUNT_TYPE
 | 
Internal Account Type
 | 
Predefined values that represent account types linked to level one account types. Used to identify transactional data for processing and reporting purposes.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVATYP
 
 | 
 FTVATYP_INTERNAL_ATYP_CODE
 
 | 
| 
INTERNAL_ACCOUNT_TYPE_DESC
 | 
Internal Account Type Description
 | 
Description for system account type.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_SDAT_TITLE
 
 | 
| 
INTERNAL_FUND_TYPE
 | 
Internal Fund Type
 | 
Predefined values representing fund types linked to level one fund types and are used to identify transactional data for processing and reporting purposes.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVFTYP
 
 | 
 FTVFTYP_INTERNAL_FTYP_CODE
 
 | 
| 
INTERNAL_FUND_TYPE_DESC
 | 
Internal Fund Type Description
 | 
Description or title of the system fund grouping code.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_SDAT_TITLE
 
 | 
| 
LOCATION
 | 
Location 
 | 
Identification accounting code of the physical location the grant has been assigned to.
 | 
VARCHAR2(63)
 | 
 
 | 
 FRRGRNL
 
 | 
 FRRGRNL_LOCN_CODE
 
 | 
| 
LOCATION_DESC
 | 
Location Description 
 | 
Description or title of the associated location.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 F_GET_FINANCE_DESC
 
 | 
| 
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_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
 | 
Status of the 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
 
 | 
| 
NORMAL_BALANCE
 | 
Normal Balance
 | 
Usual balance in the account as established by GAAP. For example, asset-debit, liability-credit, control-zero fund balance credit, revenues-credit, and expenditure-debit.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVACCT
 
 | 
 FTVACCT_NORMAL_BAL
 
 | 
| 
ORGANIZATION_CODE
 | 
Organization Code 
 | 
Identification accounting code used for the department.
 | 
VARCHAR2(63)
 | 
 
 | 
 FRRGRNL
 
 | 
 FRRGRNL_ORGN_CODE
 
 | 
| 
ORGANIZATION_DESC
 | 
Organization Description 
 | 
Description or title associated with the organization code.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 F_GET_FINANCE_DESC
 
 | 
| 
ORGANIZATION_DESC_1
 | 
Organization Description  1 
 | 
Description or title level 1 within this organization hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_DESC_2
 | 
Organization Description  2 
 | 
Description or title level 2 within this organization hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_DESC_3
 | 
Organization Description  3 
 | 
Description or title level 3 within this organization hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_DESC_4
 | 
Organization Description  4 
 | 
Description or title level 4 within this organization hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_DESC_5
 | 
Organization Description  5 
 | 
Description or title level 5 within this organization hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_DESC_6
 | 
Organization Description  6 
 | 
Description or title level 6 within this organization hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_DESC_7
 | 
Organization Description  7 
 | 
Description or title level 7 within this organization hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_DESC_8
 | 
Organization Description  8 
 | 
Description or title level 8 within this organization hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_LEVEL_1
 | 
Organization Level  1 
 | 
Level 1 organization within this organization hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_LEVEL_2
 | 
Organization Level  2 
 | 
Level 2 organization within this organization hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_LEVEL_3
 | 
Organization Level  3 
 | 
Level 3 organization within this organization hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_LEVEL_4
 | 
Organization Level  4 
 | 
Level 4 organization within this organization hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_LEVEL_5
 | 
Organization Level  5 
 | 
Level 5 organization within this organization hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_LEVEL_6
 | 
Organization Level  6 
 | 
Level 6 organization within this organization hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_LEVEL_7
 | 
Organization Level  7 
 | 
Level 7 organization within this organization hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_LEVEL_8
 | 
Organization Level  8 
 | 
Level 8 organization within this organization hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_POOL
 | 
Organization Pool
 | 
Organization used for budgeting purposes.  If the organization pool does not exist, it is replaced with organization for available balance checking.
 | 
VARCHAR2(63)
 | 
 
 | 
 CALCULATION
 
 | 
 NVL(FTVORGN_ORGN_CODE_NSF,FTVORGN_ORGN_CODE)
 
 | 
| 
ORGANIZATION_POOL_DESC
 | 
Organization Pool Description
 | 
Organization pool description.  If the organization pool is not found, then its description is replaced with organization description for available balance checking.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 F_GET_FINANCE_DESC
 
 | 
| 
ORGANIZATION_STATUS
 | 
Organization Status
 | 
Status of the organization.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVORGN
 
 | 
 FTVORGN_STATUS_IND
 
 | 
| 
ORGANIZATION_STATUS_1
 | 
Organization Status  1 
 | 
Status of level 1 organization within this organization hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_STATUS_2
 | 
Organization Status  2 
 | 
Status of level 2 organization within this organization hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_STATUS_3
 | 
Organization Status  3 
 | 
Status of level 3 organization within this organization hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_STATUS_4
 | 
Organization Status  4 
 | 
Status of level 4 organization within this organization hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_STATUS_5
 | 
Organization Status  5 
 | 
Status of level 5 organization within this organization hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_STATUS_6
 | 
Organization Status  6 
 | 
Status of level 6 organization within this organization hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_STATUS_7
 | 
Organization Status  7 
 | 
Status of level 7 organization within this organization hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORGANIZATION_STATUS_8
 | 
Organization Status  8 
 | 
Status of level 8 organization within this organization hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ACCOUNT_CLASS
 | 
Orig Account Class 
 | 
Class defines major accounting groups used in the system for fixed assets, endowments, sponsored research for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVACCT
 
 | 
 FTVACCT_ACCT_CLASS_CODE
 
 | 
| 
ORIG_ACCOUNT_CLASS_DESC
 | 
Orig Account Class Description 
 | 
Account class description for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_SDAT_TITLE
 
 | 
| 
ORIG_ACCOUNT_DESC_1
 | 
Orig Account Description  1 
 | 
Description or title level 1 within this account hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ORIG_ACCOUNT_DESC_2
 | 
Orig Account Description  2 
 | 
Description or title level 2 within this account hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ORIG_ACCOUNT_DESC_3
 | 
Orig Account Description  3 
 | 
Description or title level 3 within this account hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ORIG_ACCOUNT_DESC_4
 | 
Orig Account Description  4 
 | 
Description or title level 4 within this account hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ORIG_ACCOUNT_LEVEL_1
 | 
Orig Account Level  1 
 | 
Level 1 account within this account hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ORIG_ACCOUNT_LEVEL_2
 | 
Orig Account Level  2 
 | 
Level 2 account within this account hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ORIG_ACCOUNT_LEVEL_3
 | 
Orig Account Level  3 
 | 
Level 3 account within this account hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ORIG_ACCOUNT_LEVEL_4
 | 
Orig Account Level  4 
 | 
Level 4 account within this account hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ORIG_ACCOUNT_POOL
 | 
Original Account Pool
 | 
Account used for budgeting purposes.  If the account pool does not exist, it is replaced with account for available balance checking, for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 CALCULATION
 
 | 
 NVL(FTVACCT_ACCT_CODE_POOL,FTVACCT_ACCT_CODE)
 
 | 
| 
ORIG_ACCOUNT_POOL_DESC
 | 
Orig Account Pool Description 
 | 
Account pool description. If the account pool is not found, then its description is replaced with account description, for available balance checking, for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 F_GET_FINANCE_DESC
 
 | 
| 
ORIG_ACCOUNT_STATUS_1
 | 
Orig Account Status  1 
 | 
Dtatus of level 1 account within this account hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ORIG_ACCOUNT_STATUS_2
 | 
Orig Account Status  2 
 | 
Status of level 2 account within this account hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ORIG_ACCOUNT_STATUS_3
 | 
Orig Account Status  3 
 | 
Status of level 3 account within this account hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ORIG_ACCOUNT_STATUS_4
 | 
Orig Account Status  4 
 | 
Status of level 4 account within this account hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ACCT_HIER
 
 | 
| 
ORIG_ACCOUNT_TYPE_DESC_1
 | 
Orig Account Type Description  1 
 | 
Description or title level 1 within this account type hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FTVATYP
 
 | 
 FTVATYP_TITLE
 
 | 
| 
ORIG_ACCOUNT_TYPE_DESC_2
 | 
Orig Account Type Description  2 
 | 
Description or title level 2 within this account type hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FTVATYP
 
 | 
 FTVATYP_TITLE
 
 | 
| 
ORIG_ACCOUNT_TYPE_LEVEL_1
 | 
Orig Account Type Level  1 
 | 
Level 1 account type grouping within this account type hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVATYP
 
 | 
 FTVATYP_ATYP_CODE
 
 | 
| 
ORIG_ACCOUNT_TYPE_LEVEL_2
 | 
Orig Account Type Level  2 
 | 
Level 2 account type grouping within this account type hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVATYP
 
 | 
 FTVATYP_ATYP_CODE
 
 | 
| 
ORIG_ACCOUNT_TYPE_STATUS_1
 | 
Orig Account Type Status  1 
 | 
Status of level 1 account type within this account type hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVATYP
 
 | 
 FTVATYP_STATUS_IND
 
 | 
| 
ORIG_ACCOUNT_TYPE_STATUS_2
 | 
Orig Account Type Status  2 
 | 
Status of level 2 account type within this account type hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVATYP
 
 | 
 FTVATYP_STATUS_IND
 
 | 
| 
ORIG_FUND_DESC_1
 | 
Orig Fund Description  1 
 | 
Description or title level 1 within this fund hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
ORIG_FUND_DESC_2
 | 
Orig Fund Description  2 
 | 
Description or title level 2 within this fund hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
ORIG_FUND_DESC_3
 | 
Orig Fund Description  3 
 | 
Description or title level 3 within this fund hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
ORIG_FUND_DESC_4
 | 
Orig Fund Description  4 
 | 
Description or title level 4 within this fund hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
ORIG_FUND_DESC_5
 | 
Orig Fund Description  5 
 | 
Description or title level 5 within this fund hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
ORIG_FUND_LEVEL_1
 | 
Orig Fund Level  1 
 | 
Level 1 fund within this fund hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
ORIG_FUND_LEVEL_2
 | 
Orig Fund Level  2 
 | 
Level 2 fund within this fund hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
ORIG_FUND_LEVEL_3
 | 
Orig Fund Level  3 
 | 
Level 3 fund within this fund hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
ORIG_FUND_LEVEL_4
 | 
Orig Fund Level  4 
 | 
Level 4 fund within this fund hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
ORIG_FUND_LEVEL_5
 | 
Orig Fund Level  5 
 | 
Level 5 fund within this fund hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
ORIG_FUND_POOL
 | 
Orig Fund Pool 
 | 
Fund used for budgeting purposes.  If the fund pool does not exist, it is replaced with fund for available balance checking for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 CALCULATION
 
 | 
 NVL(FTVFUND_FUND_CODE_BAVL,FTVFUND_FUND_CODE)
 
 | 
| 
ORIG_FUND_POOL_DESC
 | 
Orig Fund Pool Description 
 | 
Fund pool description. If the fund pool is not found, then its description is replaced with fund description, for available balance checking for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 F_GET_FINANCE_DESC
 
 | 
| 
ORIG_FUND_STATUS_1
 | 
Orig Fund Status  1 
 | 
Status of level 1 fund within this fund hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
ORIG_FUND_STATUS_2
 | 
Orig Fund Status  2 
 | 
Status of level 2 fund within this fund hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
ORIG_FUND_STATUS_3
 | 
Orig Fund Status  3 
 | 
Status of level 3 fund within this fund hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
ORIG_FUND_STATUS_4
 | 
Orig Fund Status  4 
 | 
Status of level 4 fund within this fund hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
ORIG_FUND_STATUS_5
 | 
Orig Fund Status  5 
 | 
Status of level 5 fund within this fund hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_FUND_HIER
 
 | 
| 
ORIG_FUND_TYPE_DESC_1
 | 
Orig Fund Type Description  1 
 | 
Description or title level 1 within this fund type hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FTVFTYP
 
 | 
 FTVFTYP_TITLE
 
 | 
| 
ORIG_FUND_TYPE_DESC_2
 | 
Orig Fund Type Description  2 
 | 
Description or title level 2 within this fund type hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FTVFTYP
 
 | 
 FTVFTYP_TITLE
 
 | 
| 
ORIG_FUND_TYPE_LEVEL_1
 | 
Orig Fund Type Level  1 
 | 
Primary fund type within this fund hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVFTYP
 
 | 
 FTVFTYP_FTYP_CODE
 
 | 
| 
ORIG_FUND_TYPE_LEVEL_2
 | 
Orig Fund Type Level  2 
 | 
Level 2 fund type grouping within this fund type hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVFTYP
 
 | 
 FTVFTYP_FTYP_CODE
 
 | 
| 
ORIG_FUND_TYPE_STATUS_1
 | 
Orig Fund Type Status  1 
 | 
Status of level 1 fund type within this fund type hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVFTYP
 
 | 
 FTVFTYP_STATUS_IND
 
 | 
| 
ORIG_FUND_TYPE_STATUS_2
 | 
Orig Fund Type Status  2 
 | 
Status of level 2 fund type within this fund type hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVFTYP
 
 | 
 FTVFTYP_STATUS_IND
 
 | 
| 
ORIG_INTERNAL_ACCOUNT_TYPE
 | 
Orig Internal Account Type 
 | 
Predefined values that represent account types linked to level one account types. Used to identify transactional data for processing and reporting purposes for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVATYP
 
 | 
 FTVATYP_INTERNAL_ATYP_CODE
 
 | 
| 
ORIG_INTERNAL_ACCT_TYPE_DESC
 | 
Orig Internal Account Type Description 
 | 
Description for system account type for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_SDAT_TITLE
 
 | 
| 
ORIG_INTERNAL_FUND_TYPE
 | 
Orig Internal Fund Type 
 | 
Predefined values representing fund types linked to level one fund types. Used to identify transactional data for processing and reporting purposes for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVFTYP
 
 | 
 FTVFTYP_INTERNAL_FTYP_CODE
 
 | 
| 
ORIG_INTERNAL_FUND_TYPE_DESC
 | 
Orig Internal Fund Type Description 
 | 
Description or title of the system fund grouping code for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_SDAT_TITLE
 
 | 
| 
ORIG_LOCATION_DESC_1
 | 
Orig Location Description  1 
 | 
Description or title level 1 within this location hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
ORIG_LOCATION_DESC_2
 | 
Orig Location Description  2 
 | 
Description or title level 2 within this location hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
ORIG_LOCATION_DESC_3
 | 
Orig Location Description  3 
 | 
Description or title level 3 within this location hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
ORIG_LOCATION_DESC_4
 | 
Orig Location Description  4 
 | 
Description or title level 4 within this location hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
ORIG_LOCATION_DESC_5
 | 
Orig Location Description  5 
 | 
Description or title level 5 within this location hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
ORIG_LOCATION_LEVEL_1
 | 
Orig Location Level  1 
 | 
Level 1 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
ORIG_LOCATION_LEVEL_2
 | 
Orig Location Level  2 
 | 
Level 2 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
ORIG_LOCATION_LEVEL_3
 | 
Orig Location Level  3 
 | 
Level 3 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
ORIG_LOCATION_LEVEL_4
 | 
Orig Location Level  4 
 | 
Level 4 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
ORIG_LOCATION_LEVEL_5
 | 
Orig Location Level  5 
 | 
Level 5 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
ORIG_LOCATION_STATUS_1
 | 
Orig Location Status  1 
 | 
Status level 1 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
ORIG_LOCATION_STATUS_2
 | 
Orig Location Status  2 
 | 
Status level 2 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
ORIG_LOCATION_STATUS_3
 | 
Orig Location Status  3 
 | 
Status level 3 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
ORIG_LOCATION_STATUS_4
 | 
Orig Location Status  4 
 | 
Status level 4 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
ORIG_LOCATION_STATUS_5
 | 
Orig Location Status  5 
 | 
Status level 5 location within this location hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_LOCN_HIER
 
 | 
| 
ORIG_ORGANIZATION_DESC_1
 | 
Orig Organization Description  1 
 | 
Description or title level 1 within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_DESC_2
 | 
Orig Organization Description  2 
 | 
Description or title level 2 within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_DESC_3
 | 
Orig Organization Description  3 
 | 
Description or title level 3 within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_DESC_4
 | 
Orig Organization Description  4 
 | 
Description or title level 4 within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_DESC_5
 | 
Orig Organization Description  5 
 | 
Description or title level 5 within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_DESC_6
 | 
Orig Organization Description  6 
 | 
Description or title level 6 within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_DESC_7
 | 
Orig Organization Description  7 
 | 
Description or title level 7 within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_DESC_8
 | 
Orig Organization Description  8 
 | 
Description or title level 8 within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_LEVEL_1
 | 
Orig Organization Level  1 
 | 
Level 1 organization within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_LEVEL_2
 | 
Orig Organization Level  2 
 | 
Level 2 organization within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_LEVEL_3
 | 
Orig Organization Level  3 
 | 
Level 3 organization within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_LEVEL_4
 | 
Orig Organization Level  4 
 | 
Level 4 organization within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_LEVEL_5
 | 
Orig Organization Level  5 
 | 
Level 5 organization within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_LEVEL_6
 | 
Orig Organization Level  6 
 | 
Level 6 organization within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_LEVEL_7
 | 
Orig Organization Level  7 
 | 
Level 7 organization within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_LEVEL_8
 | 
Orig Organization Level  8 
 | 
Level 8 organization within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_STATUS_1
 | 
Orig Organization Status  1 
 | 
Status of level 1 organization within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_STATUS_2
 | 
Orig Organization Status  2 
 | 
Status of level 2 organization within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_STATUS_3
 | 
Orig Organization Status  3 
 | 
Status of level 3 organization within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_STATUS_4
 | 
Orig Organization Status  4 
 | 
Status of level 4 organization within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_STATUS_5
 | 
Orig Organization Status  5 
 | 
Status of level 5 organization within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_STATUS_6
 | 
Orig Organization Status  6 
 | 
Status of level 6 organization within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_STATUS_7
 | 
Orig Organization Status  7 
 | 
Status of level 7 organization within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_ORGANIZATION_STATUS_8
 | 
Orig Organization Status  8 
 | 
Status of level 8 organization within this organization hierarchy for the specified fiscal year and period.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_ORGN_HIER
 
 | 
| 
ORIG_PROGRAM_DESC_1
 | 
Orig Program Description  1 
 | 
Description or title level 1 within this program hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
ORIG_PROGRAM_DESC_2
 | 
Orig Program Description  2 
 | 
Description or title level 2 within this program hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
ORIG_PROGRAM_DESC_3
 | 
Orig Program Description  3 
 | 
Description or title level 3 within this program hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
ORIG_PROGRAM_DESC_4
 | 
Orig Program Description  4 
 | 
Description or title level 4 within this program hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
ORIG_PROGRAM_DESC_5
 | 
Orig Program Description  5 
 | 
Description or title level 5 within this program hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
ORIG_PROGRAM_LEVEL_1
 | 
Orig Program Level  1 
 | 
Level 1 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
ORIG_PROGRAM_LEVEL_2
 | 
Orig Program Level  2 
 | 
Level 2 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
ORIG_PROGRAM_LEVEL_3
 | 
Orig Program Level  3 
 | 
Level 3 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
ORIG_PROGRAM_LEVEL_4
 | 
Orig Program Level  4 
 | 
Level 4 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
ORIG_PROGRAM_LEVEL_5
 | 
Orig Program Level  5 
 | 
Level 5 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
ORIG_PROGRAM_STATUS_1
 | 
Orig Program Status  1 
 | 
Status of level 1 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
ORIG_PROGRAM_STATUS_2
 | 
Orig Program Status  2 
 | 
Status of level 2 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
ORIG_PROGRAM_STATUS_3
 | 
Orig Program Status  3 
 | 
Status of level 3 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
ORIG_PROGRAM_STATUS_4
 | 
Orig Program Status  4 
 | 
Status of level 4 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
ORIG_PROGRAM_STATUS_5
 | 
Orig Program Status  5 
 | 
Status of level 5 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
PROCESS_GROUP
 | 
Process Group 
 | 
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
PROGRAM
 | 
Program 
 | 
Identification accounting code use to identify the program classification structure or a subset or that structure as defined by the national council of higher education management systems.
 | 
VARCHAR2(63)
 | 
 
 | 
 FRRGRNL
 
 | 
 FRRGRNL_PROG_CODE
 
 | 
| 
PROGRAM_DESC
 | 
Program Description 
 | 
Description or title of the associated program.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 F_GET_FINANCE_DESC
 
 | 
| 
PROGRAM_DESC_1
 | 
Program Description  1 
 | 
Description or title level 1 within this program hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
PROGRAM_DESC_2
 | 
Program Description  2 
 | 
Description or title level 2 within this program hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
PROGRAM_DESC_3
 | 
Program Description  3 
 | 
Description or title level 3 within this program hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
PROGRAM_DESC_4
 | 
Program Description  4 
 | 
Description or title level 4 within this program hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
PROGRAM_DESC_5
 | 
Program Description  5 
 | 
Description or title level 5 within this program hierarchy.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
PROGRAM_LEVEL_1
 | 
Program Level  1 
 | 
Level 1 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
PROGRAM_LEVEL_2
 | 
Program Level  2 
 | 
Level 2 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
PROGRAM_LEVEL_3
 | 
Program Level  3 
 | 
Level 3 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
PROGRAM_LEVEL_4
 | 
Program Level  4 
 | 
Level 4 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
PROGRAM_LEVEL_5
 | 
Program Level  5 
 | 
Level 5 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
PROGRAM_STATUS
 | 
Program Status
 | 
Status of the program.
 | 
VARCHAR2(63)
 | 
 
 | 
 FTVPROG
 
 | 
 FTVPROG_STATUS_IND
 
 | 
| 
PROGRAM_STATUS_1
 | 
Program Status  1 
 | 
Status of level 1 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
PROGRAM_STATUS_2
 | 
Program Status  2 
 | 
Status of level 2 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
PROGRAM_STATUS_3
 | 
Program Status  3 
 | 
Status of level 3 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
PROGRAM_STATUS_4
 | 
Program Status  4 
 | 
Status of level 4 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
PROGRAM_STATUS_5
 | 
Program Status  5 
 | 
Status of level 5 program within this program hierarchy.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_PROG_HIER
 
 | 
| 
SPONSOR_ACCOUNT
 | 
Sponsor Account 
 | 
Sponsor account known by the agency.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 FOKODSF.F_GET_SPONSOR_ACCT
 
 | 
| 
SPONSOR_ACCOUNT_DESC
 | 
Sponsor Account Description 
 | 
Sponsor account description.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 F_GET_SPONSOR_ACCT
 
 | 
| 
SUM_ACCOUNTED_BUDGET
 | 
Sum Accounted Budget 
 | 
Current cumulative accounted budget.
 | 
NUMBER
 | 
 
 | 
 FRRGRNL
 
 | 
 FRRGRNL_XX_ACCTD_BUD
 
 | 
| 
SUM_ADOPTED_BUDGET
 | 
Sum Adopted Budget 
 | 
Current cumulative adopted budget.
 | 
NUMBER
 | 
 
 | 
 FRRGRNL
 
 | 
 FRRGRNL_XX_ADOPT_BUD
 
 | 
| 
SUM_BUDGET_ADJUSTMENTS
 | 
Sum Budget Adjustments 
 | 
Current cumulative budget adjustments.
 | 
NUMBER
 | 
 
 | 
 FRRGRNL
 
 | 
 FRRGRNL_XX_BUD_ADJT
 
 | 
| 
SUM_BUDGET_RESERVATIONS
 | 
Sum Budget Reservations 
 | 
Current cumulative budget reservations.
 | 
NUMBER
 | 
 
 | 
 FRRGRNL
 
 | 
 FRRGRNL_XX_BUD_RSRV
 
 | 
| 
SUM_ENCUMBRANCES
 | 
Sum Encumbrances 
 | 
Current cumulative encumbrances.
 | 
NUMBER
 | 
 
 | 
 FRRGRNL
 
 | 
 FRRGRNL_XX_ENCUMB
 
 | 
| 
SUM_MEMO_COSTS
 | 
Sum Memo Costs 
 | 
Current cumulative memo costs which typically represents expenses, labor, revenue and transfers.
 | 
NUMBER
 | 
 
 | 
 FRRMEML
 
 | 
 FRRMEML_XX_YTD_ACTV
 
 | 
| 
SUM_REMAINING_BALANCE
 | 
Sum Remaining Balance 
 | 
Calculated cumulative remaining balance as adopted budget, plus budget adjustments, - encumbrances, - year to date activity - budget reservations.
 | 
NUMBER
 | 
 
 | 
 CALCULATION
 
 | 
 (FRRGRNL_XX_ADOPT_BUD + FRRGRNL_XX_BUD_ADJT - FRRGRNL_XX_YTD_ACTV - FRRGRNL_XX_ENCUMB - FRRGRNL_XX_BUD_RSRV)
 
 | 
| 
SUM_TEMPORARY_BUDGET
 | 
Sum Temporary Budget 
 | 
Current cumulative temporary budget.
 | 
NUMBER
 | 
 
 | 
 FRRGRNL
 
 | 
 FRRGRNL_XX_TEMP_BUD
 
 | 
| 
SUM_YEAR_TO_DATE_ACTIVITY
 | 
Sum Year To Date Activity 
 | 
Calculated cumulative year-to-date activity.
 | 
NUMBER
 | 
 
 | 
 FRRGRNL
 
 | 
 FRRGRNL_XX_YTD_ACTV
 
 |