Composite View Source: FTVORGN

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: FTVORGN Finance

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
FTVORGN_ACTV_CODE_DEF	FTMORGN	COMPOSITE VIEW	AF_ORGN_HIERARCHY_FISCAL AF_ORGANIZATION_HIERARCHY	ACTIVITY_DEFAULT ACTIVITY_DEFAULT
FTVORGN_COAS_CODE	FTMORGN	COMPOSITE VIEW	AF_ORGN_HIERARCHY_FISCAL AF_ORGANIZATION_HIERARCHY	CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS	NA
FTVORGN_DATA_ENTRY_IND	FTMORGN	COMPOSITE VIEW	AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL AF_VALIDATION	DATA_ENTRY_PERMITTED DATA_ENTRY_PERMITTED DATA_ENTRY_IND	NA
FTVORGN_DESC	FTMORGN	COMPOSITE VIEW	AP_FACULTY_SABBATICAL_HISTORY	ORGANIZATION_DESC	NA
FTVORGN_EFF_DATE	FTMORGN	COMPOSITE VIEW	AF_ORGN_HIERARCHY_FISCAL	EFFECTIVE_DATE
FTVORGN_FMGR_CODE_PIDM	NA	COMPOSITE VIEW	AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL	FINANCIAL_MANAGER_UID FINANCIAL_MANAGER_UID	NA
FTVORGN_FUND_CODE_DEF	FTMORGN	COMPOSITE VIEW	AF_ORGN_HIERARCHY_FISCAL AF_ORGANIZATION_HIERARCHY	FUND_DEFAULT FUND_DEFAULT
FTVORGN_LOCN_CODE_DEF	FTMORGN	COMPOSITE VIEW	AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL	LOCATION_DEFAULT LOCATION_DEFAULT
FTVORGN_NCHG_DATE	FTMORGN	COMPOSITE VIEW	AF_ORGN_HIERARCHY_FISCAL	NEXT_CHANGE_DATE	NA
FTVORGN_ORGN_CODE	FTMORGN	COMPOSITE VIEW	AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL	ORGANIZATION_CODE ORGANIZATION_CODE	NA
FTVORGN_STATUS_IND	FTMORGN	COMPOSITE VIEW	AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL	ORGANIZATION_STATUS ORGANIZATION_STATUS	NA
FTVORGN_TERM_DATE	FTMORGN	COMPOSITE VIEW	AF_ORGN_HIERARCHY_FISCAL AF_ORGANIZATION_HIERARCHY	TERMINATION_DATE TERMINATION_DATE	NA
FTVORGN_TITLE	FTMORGN	COMPOSITE VIEW	AF_ORGANIZATION_HIERARCHY AF_ORGANIZATION_ATTRIBUTES_ODS AF_ORGN_HIERARCHY_FISCAL AN_PERSONNEL_ACTION_LABOR_DIST AP_PAYROLL_LABOR_DIST_OVERRIDE	ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DESC ORGANIZATION_DESC POSITION_ORGANIZATION_DESC	NA
MGKFUNC.F_GET_PERSON_INFO	FTMORGN

Ver: