Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: FTVORGN Finance Reporting View Meta Data Reports
SGHE Banner Operational Data Store Reporting View Source: FTVORGN - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
FTVORGN_ACTV_CODE_DEF FTMORGN

REPORTING VIEW

ORGANIZATION_HIERARCHY_FISCAL

ORGANIZATION_HIERARCHY

ACTIVITY_DEFAULT

ACTIVITY_DEFAULT

 
FTVORGN_COAS_CODE FTMORGN

REPORTING VIEW

FOAPAL_NO_ATTRIBUTES

ORGANIZATION_HIERARCHY

ORGANIZATION_HIERARCHY_FISCAL

CHART_OF_ACCOUNTS

CHART_OF_ACCOUNTS

CHART_OF_ACCOUNTS

NA
FTVORGN_DATA_ENTRY_IND FTMORGN

REPORTING VIEW

ORGANIZATION_HIERARCHY_FISCAL

ORGANIZATION_HIERARCHY

VALIDATION

DATA_ENTRY_PERMITTED

DATA_ENTRY_PERMITTED

DATA_ENTRY_IND

NA
FTVORGN_DESC FTMORGN

REPORTING VIEW

FACULTY_APPOINTMENT_HISTORY

FACULTY_RANK_HISTORY

FACULTY_TRACKING

FACULTY_SABBATICAL_HISTORY

FACULTY_TRACKING

ORGANIZATION_DESC

ORGANIZATION_DESC

SABBATICAL_ORGANIZATION_DESC

ORGANIZATION_DESC

APPOINTMENT_ORGANIZATION_DESC

NA
FTVORGN_EFF_DATE FTMORGN

REPORTING VIEW

ORGANIZATION_HIERARCHY_FISCAL

EFFECTIVE_DATE

 
FTVORGN_FMGR_CODE_PIDM NA

REPORTING VIEW

GRANT_DEFERRED_COST

TRANSACTION_HISTORY

OPERATING_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

GRANT_VIEW

ORGANIZATION_HIERARCHY

FIXED_ASSET_FUNDING_SOURCE

INVOICE_ACCOUNTING

FIXED_ASSET_ACCOUNTING_SOURCE

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ITEM_ACCOUNTING

REIMBURSEMENT_ACCOUNTING

INVOICE_ITEM_ACCOUNTING

ORGANIZATION_HIERARCHY_FISCAL

AUTHORIZATION_ACCOUNTING

ORGN_FINANCIAL_MANAGER_UID

ORGN_FINANCIAL_MANAGER_UID

ORGN_FINANCIAL_MANAGER_UID

ORGN_FINANCIAL_MANAGER_UID

ORGN_FINANCIAL_MANAGER_UID

ORGN_FINANCIAL_MANAGER_UID

FINANCIAL_MANAGER_UID

ORGN_FINANCIAL_MANAGER_UID

ORGN_FINANCIAL_MANAGER_UID

ORGN_FINANCIAL_MANAGER_UID

ORGN_FINANCIAL_MANAGER_UID

ORGN_FINANCIAL_MANAGER_UID

ORGN_FINANCIAL_MANAGER_UID

ORGN_FINANCIAL_MANAGER_UID

FINANCIAL_MANAGER_UID

ORGN_FINANCIAL_MANAGER_UID

NA
FTVORGN_FUND_CODE_DEF FTMORGN

REPORTING VIEW

ORGANIZATION_HIERARCHY_FISCAL

ORGANIZATION_HIERARCHY

FUND_DEFAULT

FUND_DEFAULT

 
FTVORGN_LOCN_CODE_DEF FTMORGN

REPORTING VIEW

ORGANIZATION_HIERARCHY

ORGANIZATION_HIERARCHY_FISCAL

LOCATION_DEFAULT

LOCATION_DEFAULT

 
FTVORGN_NCHG_DATE FTMORGN

REPORTING VIEW

ORGANIZATION_HIERARCHY_FISCAL

NEXT_CHANGE_DATE

NA
FTVORGN_ORGN_CODE FTMORGN

REPORTING VIEW

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

FOAPAL_NO_ATTRIBUTES

TRANSACTION_HISTORY

ORGANIZATION_HIERARCHY

TRANSACTION_HISTORY

ORGANIZATION_HIERARCHY_FISCAL

ACTUAL_ORGANIZATION_LEVEL_4

ACTUAL_ORGANIZATION_LEVEL_2

ACTUAL_ORGANIZATION_LEVEL_5

ACTUAL_ORGANIZATION_LEVEL_7

ACTUAL_ORGANIZATION_LEVEL_6

ACTUAL_ORGANIZATION_LEVEL_8

FOAPAL_ELEMENT

ACTUAL_ORGANIZATION_LEVEL_3

ORGANIZATION_CODE

ACTUAL_ORGANIZATION_LEVEL_1

ORGANIZATION_CODE

NA
FTVORGN_STATUS_IND FTMORGN

REPORTING VIEW

BUDGET_AVAILABILITY_LEDGER

FOAPAL_NO_ATTRIBUTES

GRANT_DEFERRED_COST

GRANT_PERSONNEL

OPERATING_LEDGER

GRANT_DEFERRED_COST

ORGANIZATION_ATTRIBUTES

TRANSACTION_HISTORY

TRANSACTION_HISTORY

GRANT_LEDGER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PROPOSAL

PURCHASE_ORDER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

FIXED_ASSET_ITEM

ORGANIZATION_HIERARCHY

TRANSACTION_HISTORY

ENDOWMENT_UNITS

ORGANIZATION_HIERARCHY_FISCAL

ORGANIZATION_STATUS

FOAPAL_ELEMENT_STATUS

ORGANIZATION_STATUS

ORGANIZATION_STATUS

ORGANIZATION_STATUS

ORIG_ORGANIZATION_STATUS

ORGANIZATION_STATUS

ACTUAL_ORGANIZATION_STATUS_6

ACTUAL_ORGANIZATION_STATUS_7

ORGANIZATION_STATUS

ACTUAL_ORGANIZATION_STATUS_1

ACTUAL_ORGANIZATION_STATUS_2

ACTUAL_ORGANIZATION_STATUS_3

ORGANIZATION_STATUS

ORGANIZATION_STATUS

ACTUAL_ORGANIZATION_STATUS_5

ACTUAL_ORGANIZATION_STATUS_8

ORGANIZATION_STATUS

ORGANIZATION_STATUS

ACTUAL_ORGANIZATION_STATUS_4

ORGANIZATION_STATUS

ORGANIZATION_STATUS

NA
FTVORGN_TERM_DATE FTMORGN

REPORTING VIEW

ORGANIZATION_HIERARCHY_FISCAL

ORGANIZATION_HIERARCHY

TERMINATION_DATE

TERMINATION_DATE

NA
FTVORGN_TITLE FTMORGN

REPORTING VIEW

LABOR_COST_DISTRIBUTION

REIMBURSEMENT_ACCOUNTING

FUND_HIERARCHY

PAYROLL_DISTRIBUTION

PROFILE_DEFAULT_ACCOUNTING

FUND_HIERARCHY_FISCAL

GRANT_DEFERRED_COST

GRANT_PERSONNEL

OPERATING_LEDGER

ORGANIZATION_HIERARCHY_FISCAL

PAYROLL_LABOR_DIST_OVERRIDE

PERSONNEL_ACTION_LABOR_DIST

BUDGET_AVAILABILITY_LEDGER

FOAPAL_NO_ATTRIBUTES

LABOR_COST_DISTRIBUTION

GRANT_DEFERRED_COST

ORGANIZATION_ATTRIBUTES

ORGANIZATION_HIERARCHY

AUTHORIZATION_ACCOUNTING

FRINGE_ORGANIZATION_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

ORGANIZATION_DEFAULT_DESC

ORGANIZATION_DEFAULT_DESC

ORIG_ORGANIZATION_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

POSITION_ORGANIZATION_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

FOAPAL_ELEMENT_DESC

ASSIGNMENT_ORGANIZATION_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

NA
MGKFUNC.F_GET_PERSON_INFO FTMORGN

REPORTING VIEW

GRANT_DEFERRED_COST

ORIG_ORGANIZATION_FMGR_ID

 


Ver: 9.0