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 ORGANIZATION_HIERARCHY_FISCAL	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_TRACKING FACULTY_SABBATICAL_HISTORY FACULTY_TRACKING FACULTY_RANK_HISTORY FACULTY_APPOINTMENT_HISTORY	APPOINTMENT_ORGANIZATION_DESC ORGANIZATION_DESC SABBATICAL_ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DESC	NA
FTVORGN_EFF_DATE	FTMORGN	REPORTING VIEW	ORGANIZATION_HIERARCHY_FISCAL	EFFECTIVE_DATE
FTVORGN_FMGR_CODE_PIDM	NA	REPORTING VIEW	BUDGET_AVAILABILITY_LEDGER INVOICE_ACCOUNTING REIMBURSEMENT_ACCOUNTING ORGANIZATION_HIERARCHY INVOICE_ITEM_ACCOUNTING FIXED_ASSET_FUNDING_SOURCE ORGANIZATION_HIERARCHY_FISCAL FIXED_ASSET_ACCOUNTING_SOURCE OPERATING_LEDGER TRANSACTION_HISTORY GRANT_DEFERRED_COST PURCHASE_ORDER_ITEM_ACCOUNTING BUDGET_DETAIL PURCHASE_ORDER_ACCOUNTING AUTHORIZATION_ACCOUNTING GRANT_VIEW	ORGN_FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID 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 ORGN_FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID	NA
FTVORGN_FUND_CODE_DEF	FTMORGN	REPORTING VIEW	ORGANIZATION_HIERARCHY ORGANIZATION_HIERARCHY_FISCAL	FUND_DEFAULT FUND_DEFAULT
FTVORGN_LOCN_CODE_DEF	FTMORGN	REPORTING VIEW	ORGANIZATION_HIERARCHY_FISCAL ORGANIZATION_HIERARCHY	LOCATION_DEFAULT LOCATION_DEFAULT
FTVORGN_NCHG_DATE	FTMORGN	REPORTING VIEW	ORGANIZATION_HIERARCHY_FISCAL	NEXT_CHANGE_DATE	NA
FTVORGN_ORGN_CODE	FTMORGN	REPORTING VIEW	FOAPAL_NO_ATTRIBUTES ORGANIZATION_HIERARCHY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY ORGANIZATION_HIERARCHY_FISCAL TRANSACTION_HISTORY	FOAPAL_ELEMENT ORGANIZATION_CODE ACTUAL_ORGANIZATION_LEVEL_7 ACTUAL_ORGANIZATION_LEVEL_8 ACTUAL_ORGANIZATION_LEVEL_5 ACTUAL_ORGANIZATION_LEVEL_2 ACTUAL_ORGANIZATION_LEVEL_3 ACTUAL_ORGANIZATION_LEVEL_1 ACTUAL_ORGANIZATION_LEVEL_4 ORGANIZATION_CODE ACTUAL_ORGANIZATION_LEVEL_6	NA
FTVORGN_STATUS_IND	FTMORGN	REPORTING VIEW	ORGANIZATION_HIERARCHY TRANSACTION_HISTORY BUDGET_AVAILABILITY_LEDGER TRANSACTION_HISTORY ORGANIZATION_ATTRIBUTES OPERATING_LEDGER GRANT_DEFERRED_COST TRANSACTION_HISTORY TRANSACTION_HISTORY FOAPAL_NO_ATTRIBUTES PURCHASE_ORDER ORGANIZATION_HIERARCHY_FISCAL ENDOWMENT_UNITS TRANSACTION_HISTORY TRANSACTION_HISTORY GRANT_LEDGER TRANSACTION_HISTORY FIXED_ASSET_ITEM GRANT_DEFERRED_COST PROPOSAL TRANSACTION_HISTORY GRANT_PERSONNEL	ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_8 ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_4 ORGANIZATION_STATUS ORGANIZATION_STATUS ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_1 ACTUAL_ORGANIZATION_STATUS_7 FOAPAL_ELEMENT_STATUS ORGANIZATION_STATUS ORGANIZATION_STATUS ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_2 ACTUAL_ORGANIZATION_STATUS_6 ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_3 ORGANIZATION_STATUS ORIG_ORGANIZATION_STATUS ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_5 ORGANIZATION_STATUS	NA
FTVORGN_TERM_DATE	FTMORGN	REPORTING VIEW	ORGANIZATION_HIERARCHY ORGANIZATION_HIERARCHY_FISCAL	TERMINATION_DATE TERMINATION_DATE	NA
FTVORGN_TITLE	FTMORGN	REPORTING VIEW	ORGANIZATION_HIERARCHY BUDGET_AVAILABILITY_LEDGER REIMBURSEMENT_ACCOUNTING LABOR_COST_DISTRIBUTION ORGANIZATION_ATTRIBUTES ORGANIZATION_HIERARCHY_FISCAL FUND_HIERARCHY_FISCAL AUTHORIZATION_ACCOUNTING GRANT_DEFERRED_COST PERSONNEL_ACTION_LABOR_DIST PAYROLL_LABOR_DIST_OVERRIDE GRANT_DEFERRED_COST PAYROLL_DISTRIBUTION PROFILE_DEFAULT_ACCOUNTING LABOR_COST_DISTRIBUTION GRANT_PERSONNEL FOAPAL_NO_ATTRIBUTES OPERATING_LEDGER FUND_HIERARCHY	ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DESC FRINGE_ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DEFAULT_DESC ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DESC POSITION_ORGANIZATION_DESC ORIG_ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DEFAULT_DESC ASSIGNMENT_ORGANIZATION_DESC ORGANIZATION_DESC FOAPAL_ELEMENT_DESC ORGANIZATION_DESC ORGANIZATION_DESC	NA
MGKFUNC.F_GET_PERSON_INFO	FTMORGN	REPORTING VIEW	GRANT_DEFERRED_COST	ORIG_ORGANIZATION_FMGR_ID

Ver: 8.5