Reporting View Source: FTVORGN

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

**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	ORGANIZATION_HIERARCHY ORGANIZATION_HIERARCHY_FISCAL FOAPAL_NO_ATTRIBUTES	CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS	NA
FTVORGN_DATA_ENTRY_IND	FTMORGN	REPORTING VIEW	ORGANIZATION_HIERARCHY ORGANIZATION_HIERARCHY_FISCAL VALIDATION	DATA_ENTRY_PERMITTED DATA_ENTRY_PERMITTED DATA_ENTRY_IND	NA
FTVORGN_DESC	FTMORGN	REPORTING VIEW	FACULTY_RANK_HISTORY FACULTY_SABBATICAL_HISTORY FACULTY_TRACKING FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	ORGANIZATION_DESC ORGANIZATION_DESC APPOINTMENT_ORGANIZATION_DESC SABBATICAL_ORGANIZATION_DESC ORGANIZATION_DESC	NA
FTVORGN_EFF_DATE	FTMORGN	REPORTING VIEW	ORGANIZATION_HIERARCHY_FISCAL	EFFECTIVE_DATE
FTVORGN_FMGR_CODE_PIDM	NA	REPORTING VIEW	FIXED_ASSET_FUNDING_SOURCE AUTHORIZATION_ACCOUNTING GRANT_VIEW PURCHASE_ORDER_ACCOUNTING BUDGET_AVAILABILITY_LEDGER INVOICE_ACCOUNTING TRANSACTION_HISTORY GRANT_DEFERRED_COST ORGANIZATION_HIERARCHY_FISCAL PURCHASE_ORDER_ITEM_ACCOUNTING BUDGET_DETAIL REIMBURSEMENT_ACCOUNTING INVOICE_ITEM_ACCOUNTING OPERATING_LEDGER FIXED_ASSET_ACCOUNTING_SOURCE ORGANIZATION_HIERARCHY	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 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	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 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 FOAPAL_NO_ATTRIBUTES ORGANIZATION_HIERARCHY_FISCAL TRANSACTION_HISTORY TRANSACTION_HISTORY ORGANIZATION_HIERARCHY TRANSACTION_HISTORY TRANSACTION_HISTORY	ACTUAL_ORGANIZATION_LEVEL_4 ACTUAL_ORGANIZATION_LEVEL_1 ACTUAL_ORGANIZATION_LEVEL_6 ACTUAL_ORGANIZATION_LEVEL_8 FOAPAL_ELEMENT ORGANIZATION_CODE ACTUAL_ORGANIZATION_LEVEL_2 ACTUAL_ORGANIZATION_LEVEL_3 ORGANIZATION_CODE ACTUAL_ORGANIZATION_LEVEL_5 ACTUAL_ORGANIZATION_LEVEL_7	NA
FTVORGN_STATUS_IND	FTMORGN	REPORTING VIEW	TRANSACTION_HISTORY FOAPAL_NO_ATTRIBUTES TRANSACTION_HISTORY BUDGET_AVAILABILITY_LEDGER FIXED_ASSET_ITEM GRANT_PERSONNEL ORGANIZATION_ATTRIBUTES OPERATING_LEDGER ENDOWMENT_UNITS GRANT_DEFERRED_COST PROPOSAL TRANSACTION_HISTORY ORGANIZATION_HIERARCHY_FISCAL TRANSACTION_HISTORY GRANT_DEFERRED_COST ORGANIZATION_HIERARCHY TRANSACTION_HISTORY GRANT_LEDGER PURCHASE_ORDER TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY	ACTUAL_ORGANIZATION_STATUS_5 FOAPAL_ELEMENT_STATUS ACTUAL_ORGANIZATION_STATUS_1 ORGANIZATION_STATUS ORGANIZATION_STATUS ORGANIZATION_STATUS ORGANIZATION_STATUS ORGANIZATION_STATUS ORGANIZATION_STATUS ORGANIZATION_STATUS ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_8 ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_6 ORIG_ORGANIZATION_STATUS ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_3 ORGANIZATION_STATUS ORGANIZATION_STATUS ACTUAL_ORGANIZATION_STATUS_2 ACTUAL_ORGANIZATION_STATUS_4 ACTUAL_ORGANIZATION_STATUS_7	NA
FTVORGN_TERM_DATE	FTMORGN	REPORTING VIEW	ORGANIZATION_HIERARCHY ORGANIZATION_HIERARCHY_FISCAL	TERMINATION_DATE TERMINATION_DATE	NA
FTVORGN_TITLE	FTMORGN	REPORTING VIEW	FUND_HIERARCHY LABOR_COST_DISTRIBUTION PERSONNEL_ACTION_LABOR_DIST ORGANIZATION_HIERARCHY LABOR_COST_DISTRIBUTION AUTHORIZATION_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING PAYROLL_DISTRIBUTION ORGANIZATION_HIERARCHY_FISCAL FUND_HIERARCHY_FISCAL GRANT_PERSONNEL PAYROLL_LABOR_DIST_OVERRIDE BUDGET_AVAILABILITY_LEDGER GRANT_DEFERRED_COST OPERATING_LEDGER FOAPAL_NO_ATTRIBUTES GRANT_DEFERRED_COST ORGANIZATION_ATTRIBUTES	ORGANIZATION_DESC FRINGE_ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DESC ASSIGNMENT_ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DEFAULT_DESC ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DEFAULT_DESC ORGANIZATION_DESC POSITION_ORGANIZATION_DESC ORGANIZATION_DESC ORIG_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: 9.2