Composite View Source: FRBGRNT

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
FRBGRNT_AGENCY_ADDR_CODE	FTMAGCY	COMPOSITE VIEW	AF_GRANT	AGENCY_ADDRESS	NA
FRBGRNT_AGENCY_ADDR_SEQ_NUM	FTMAGCY	COMPOSITE VIEW	AF_GRANT	AGENCY_ADDRESS_SEQUENCE_NUMBER	NA
FRBGRNT_AGENCY_CONTACT	FTMAGCY	COMPOSITE VIEW	AF_GRANT	AGENCY_CONTACT	NA
FRBGRNT_AGENCY_EMAIL	FTMAGCY	COMPOSITE VIEW	AF_GRANT	AGENCY_EMAIL	NA
FRBGRNT_AGENCY_PHONE_TYPE	FTMAGCY	COMPOSITE VIEW	AF_GRANT	AGENCY_PHONE_TYPE	NA
FRBGRNT_AGENCY_PIDM	NA	COMPOSITE VIEW	AF_GRANT	AGENCY_UID	NA
FRBGRNT_AGENCY_TELE_SEQNO	FTMAGCY	COMPOSITE VIEW	AF_GRANT	AGENCY_TELEPHONE_SEQ_NUMBER	NA
FRBGRNT_ALTERNATE_STATUS_DESC	FRAGRNT	COMPOSITE VIEW	AF_GRANT	ALTERNATE_STATUS_DESC	NA
FRBGRNT_BASI_CODE_CS	FRAGRNT	COMPOSITE VIEW	AF_GRANT	COST_SHARE_BASE	NA
FRBGRNT_BASI_CODE_IC	FRAGRNT	COMPOSITE VIEW	AF_GRANT	INDIRECT_COST_BASE	NA
FRBGRNT_CATEGORY	FRAGRNT	COMPOSITE VIEW	AF_GRANT	CATEGORY	NA
FRBGRNT_CFDA_INTERNAL_ID_NO	FRAGRNT	COMPOSITE VIEW	AF_GRANT AF_GRANT	FEDERAL_IDENTIFICATION FEDERAL_IDENTIFICATION_UID	NA
FRBGRNT_COAS_CODE	FRAGRNT	COMPOSITE VIEW	AF_GRANT	CHART_OF_ACCOUNTS	NA
FRBGRNT_COAS_CODE_IC_CS	FRAGRNT	COMPOSITE VIEW	AF_GRANT	CHART_OF_ACCOUNTS_COST	NA
FRBGRNT_CODE	FRAGRNT	COMPOSITE VIEW	AF_GRANT	GRANT_ID	NA
FRBGRNT_CSTA_CODE_CHARGE	FRAGRNT	COMPOSITE VIEW	AF_GRANT	COST_SHARE_CHARGE	NA
FRBGRNT_CSTD_CODE_DISTR	FRAGRNT	COMPOSITE VIEW	AF_GRANT	COST_SHARE_DISTRIBUTION	NA
FRBGRNT_CSTR_CODE_RATE	FRAGRNT	COMPOSITE VIEW	AF_GRANT	COST_SHARE_RATE	NA
FRBGRNT_CUM_FUNDING_AMT	FRAGRNT	COMPOSITE VIEW	AF_GRANT	CUMULATIVE_AMOUNT	NA
FRBGRNT_CURRENT_FUNDING_AMT	FRAGRNT	COMPOSITE VIEW	AF_GRANT	CURRENT_YEAR_AMOUNT	NA
FRBGRNT_EXPEND_END_DATE	FRAGRNT	COMPOSITE VIEW	AF_GRANT	EXPENDITURE_END_DATE	NA
FRBGRNT_GRANT_TYPE	FRAGRNT	COMPOSITE VIEW	AF_GRANT	GRANT_TYPE	NA
FRBGRNT_GRNT_CODE_RELATED	FRAGRNT	COMPOSITE VIEW	AF_GRANT	RELATED_GRANT	NA
FRBGRNT_INDA_CODE_CHARGE	FRAGRNT	COMPOSITE VIEW	AF_GRANT	INDIRECT_COST_CHARGE	NA
FRBGRNT_INDD_CODE_DISTR	FRAGRNT	COMPOSITE VIEW	AF_GRANT	INDIRECT_COST_DISTRIBUTION	NA
FRBGRNT_INDR_CODE_RATE	FRAGRNT	COMPOSITE VIEW	AF_GRANT	INDIRECT_COST_RATE	NA
FRBGRNT_LONG_TITLE	FRAGRNT	COMPOSITE VIEW	AF_FIXED_ASSET_ITEM AF_GRANT AF_GRANT_ATTRIBUTES_ODS	GRANT_LONG_TITLE LONG_TITLE LONG_TITLE	NA
FRBGRNT_MAX_FUNDING_AMT	FRAGRNT	COMPOSITE VIEW	AF_GRANT	AGENCY_COMMITMENT_AMOUNT	NA
FRBGRNT_ORGN_CODE_RESP_OFFICE	FRAGRNT	COMPOSITE VIEW	AF_GRANT	RESPONSIBLE_ORGANIZATION_CODE	NA
FRBGRNT_PI_PIDM	NA	COMPOSITE VIEW	AF_GRANT	PRINCIPAL_INVESTIGATOR_UID	NA
FRBGRNT_PROJECT_END_DATE	FRAGRNT	COMPOSITE VIEW	AF_GRANT	PROJECT_END_DATE	NA
FRBGRNT_PROJECT_START_DATE	FRAGRNT	COMPOSITE VIEW	AF_GRANT	PROJECT_START_DATE	NA
FRBGRNT_PROP_CODE	FRAGRNT	COMPOSITE VIEW	AF_GRANT	PROPOSAL	NA
FRBGRNT_SPONSOR_ID	FRAGRNT	COMPOSITE VIEW	AF_GRANT	SPONSOR_NUMBER	NA
FRBGRNT_STATUS_CODE	FRAGRNT	COMPOSITE VIEW	AF_GRANT	STATUS	NA
FRBGRNT_STATUS_DATE	FRAGRNT	COMPOSITE VIEW	AF_GRANT	STATUS_DATE	NA
FRBGRNT_SUB_CATEGORY	FRAGRNT	COMPOSITE VIEW	AF_GRANT	SUBCATEGORY	NA
FRBGRNT_TERM_DATE	FRAGRNT	COMPOSITE VIEW	AF_GRANT	TERMINATION_DATE	NA
FRBGRNT_TITLE	FRAGRNT	COMPOSITE VIEW	AF_FIXED_ASSET_ITEM AF_GRANT AF_GRANT_ATTRIBUTES_ODS	GRANT_TITLE SHORT_TITLE SHORT_TITLE	NA

Ver: 8.1