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 INVOICE_ITEM_ACCOUNTING ORGANIZATION_HIERARCHY FIXED_ASSET_FUNDING_SOURCE ORGANIZATION_HIERARCHY_FISCAL FIXED_ASSET_ACCOUNTING_SOURCE GRANT_DEFERRED_COST OPERATING_LEDGER PURCHASE_ORDER_ITEM_ACCOUNTING TRANSACTION_HISTORY BUDGET_DETAIL PURCHASE_ORDER_ACCOUNTING AUTHORIZATION_ACCOUNTING GRANT_VIEW	ORGN_FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID ORGN_FINANCIAL_MANAGER_UID 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	BUDGET_AVAILABILITY_LEDGER ORGANIZATION_HIERARCHY TRANSACTION_HISTORY GRANT_DEFERRED_COST OPERATING_LEDGER ORGANIZATION_ATTRIBUTES TRANSACTION_HISTORY FOAPAL_NO_ATTRIBUTES ORGANIZATION_HIERARCHY_FISCAL PURCHASE_ORDER TRANSACTION_HISTORY TRANSACTION_HISTORY ENDOWMENT_UNITS GRANT_LEDGER TRANSACTION_HISTORY TRANSACTION_HISTORY FIXED_ASSET_ITEM GRANT_DEFERRED_COST TRANSACTION_HISTORY PROPOSAL GRANT_PERSONNEL TRANSACTION_HISTORY	ORGANIZATION_STATUS ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_8 ORGANIZATION_STATUS ORGANIZATION_STATUS ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_4 FOAPAL_ELEMENT_STATUS ORGANIZATION_STATUS ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_1 ACTUAL_ORGANIZATION_STATUS_7 ORGANIZATION_STATUS ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_2 ACTUAL_ORGANIZATION_STATUS_6 ORGANIZATION_STATUS ORIG_ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_3 ORGANIZATION_STATUS ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_5	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 LABOR_COST_DISTRIBUTION REIMBURSEMENT_ACCOUNTING ORGANIZATION_ATTRIBUTES ORGANIZATION_HIERARCHY_FISCAL FUND_HIERARCHY_FISCAL GRANT_DEFERRED_COST PERSONNEL_ACTION_LABOR_DIST AUTHORIZATION_ACCOUNTING GRANT_DEFERRED_COST PAYROLL_LABOR_DIST_OVERRIDE GRANT_PERSONNEL LABOR_COST_DISTRIBUTION PAYROLL_DISTRIBUTION PROFILE_DEFAULT_ACCOUNTING FOAPAL_NO_ATTRIBUTES FUND_HIERARCHY OPERATING_LEDGER	ORGANIZATION_DESC ORGANIZATION_DESC FRINGE_ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DEFAULT_DESC ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DESC ORIG_ORGANIZATION_DESC POSITION_ORGANIZATION_DESC ORGANIZATION_DESC ASSIGNMENT_ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DEFAULT_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