Composite View Source: FRBPROP

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

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

Ver: 8.3