Composite View Source: FRRGRPI

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
FRRGRPI_ACTIVITY_DATE	TBD	COMPOSITE VIEW	AF_GRANT_PERSONNEL	PERSONNEL_ACTIVITY DATE
FRRGRPI_ADDR_SEQNO	FRAGRNT	COMPOSITE VIEW	AF_GRANT_PERSONNEL	ADDRESS NUMBER
FRRGRPI_ADDR_TYPE	FRAGRNT	COMPOSITE VIEW	AF_GRANT_PERSONNEL	ADDRESS_TYPE
FRRGRPI_BFRM_CODE	FRAGRNT	COMPOSITE VIEW	AF_GRANT_PERSONNEL	BILL_FORMAT
FRRGRPI_EMAIL	FRAGRNT	COMPOSITE VIEW	AF_GRANT_PERSONNEL	EMAIL_ADDRESS
FRRGRPI_EMPLOYEE_IND	FRAGRNT	COMPOSITE VIEW	AF_GRANT_PERSONNEL	EMPLOYEE_IND
FRRGRPI_FTE	FRAGRNT	COMPOSITE VIEW	AF_GRANT_PERSONNEL	FULL_TIME_EQUIVALENCY_PCT
FRRGRPI_GRNT_CODE	FRAGRNT	COMPOSITE VIEW	AF_GRANT_PERSONNEL	GRANT_ID
FRRGRPI_ID_IND	FRAGRNT	COMPOSITE VIEW	AF_GRANT_PERSONNEL	PERSONNEL_TYPE
FRRGRPI_ID_PIDM	FRAGRNT	COMPOSITE VIEW	AF_GRANT_PERSONNEL	PERSONNEL_UID
FRRGRPI_ORGN_CODE	FRAGRNT	COMPOSITE VIEW	AF_GRANT_PERSONNEL	ORGANIZATION_CODE
FRRGRPI_PHONE_TYPE	FRAGRNT	COMPOSITE VIEW	AF_GRANT_PERSONNEL	PHONE_TYPE
FRRGRPI_SALUTATION	FRAGRNT	COMPOSITE VIEW	AF_GRANT_PERSONNEL	PERSONNEL_SALUTATION
FRRGRPI_TELE_SEQNO	FRAGRNT	COMPOSITE VIEW	AF_GRANT_PERSONNEL	PHONE_SEQ_NUMBER
FRRGRPI_TITLE	FRAGRNT	COMPOSITE VIEW	AF_GRANT AF_GRANT_PERSONNEL	PRINCIPAL_INVESTIGATOR_TITLE PERSONNEL_TITLE	NA
FRRGRPI_USER_ID	TBD	COMPOSITE VIEW	AF_GRANT_PERSONNEL	PERSONNEL_USER_ID

Ver: