Reporting View Source: FTVORGN

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: FTVORGN Finance Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
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