Composite View Source: FRBPROP

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
FRBPROP_AGENCY_PIDM	NA	COMPOSITE VIEW	AF_PROPOSAL	AGENCY_UID	NA
FRBPROP_CATEGORY	FRAPROP	COMPOSITE VIEW	AF_PROPOSAL	CATEGORY	NA
FRBPROP_CFDA_INTERNAL_ID_NO	FRAPROP	COMPOSITE VIEW	AF_PROPOSAL AF_PROPOSAL	FEDERAL_IDENTIFICATION FEDERAL_IDENTIFICATION_UID	NA
FRBPROP_COAS_CODE	FRAPROP	COMPOSITE VIEW	AF_PROPOSAL	CHART_OF_ACCOUNTS	NA
FRBPROP_CODE	FRAPROP	COMPOSITE VIEW	AF_PROPOSAL	PROPOSAL_CODE	NA
FRBPROP_GRNT_CODE	FRAPROP	COMPOSITE VIEW	AF_PROPOSAL	GRANT_ID	NA
FRBPROP_LONG_TITLE	FRAPROP	COMPOSITE VIEW	AF_GRANT AF_GRANT_FUND AF_PROPOSAL	PROPOSAL_LONG_TITLE PROPOSAL_LONG_TITLE PROPOSAL_LONG_TITLE	NA
FRBPROP_ORGN_CODE_RESP_OFFICE	FRAPROP	COMPOSITE VIEW	AF_PROPOSAL	ORGANIZATION_CODE	NA
FRBPROP_PI_PIDM	NA	COMPOSITE VIEW	AF_PROPOSAL	PRINCIPAL_INVESTIGATOR_UID	NA
FRBPROP_PROPOSAL_TYPE	FRAPROP	COMPOSITE VIEW	AF_PROPOSAL	PROPOSAL_TYPE	NA
FRBPROP_REQUESTED_AMT	FRAPROP	COMPOSITE VIEW	AF_PROPOSAL	REQUESTED_AMOUNT	NA
FRBPROP_SPONSOR_ID	FRAPROP	COMPOSITE VIEW	AF_PROPOSAL	SPONSOR_NUMBER	NA
FRBPROP_STATUS_CODE	FRAPROP	COMPOSITE VIEW	AF_PROPOSAL	CURRENT_STATUS	NA
FRBPROP_STATUS_DATE	FRAPROP	COMPOSITE VIEW	AF_PROPOSAL	CURRENT_STATUS_DATE	NA
FRBPROP_SUB_CATEGORY	FRAPROP	COMPOSITE VIEW	AF_PROPOSAL	SUBCATEGORY	NA
FRBPROP_TITLE	FRAPROP	COMPOSITE VIEW	AF_GRANT AF_GRANT_FUND AF_PROPOSAL	PROPOSAL_SHORT_TITLE PROPOSAL_SHORT_TITLE PROPOSAL_SHORT_TITLE	NA

Ver: 8.1