Composite View Source: SFRSTCR

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: SFRSTCR Student

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
SFRSTCR_ADD_DATE	SFAREGS	COMPOSITE VIEW	AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS	SECTION_ADD_DATE SECTION_ADD_DATE	NA
SFRSTCR_APPR_RECEIVED_IND	SFAREGS	COMPOSITE VIEW	AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS	SPECIAL_APPROVAL_IND SPECIAL_APPROVAL_IND	NA
SFRSTCR_ATTEND_HR	SFAREGS	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_HISTORY	HOURS_ATTENDED HOURS_ATTENDED	NA
SFRSTCR_BILL_HR	SFAREGS	COMPOSITE VIEW	AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS	COURSE_BILLING_CREDITS COURSE_BILLING_CREDITS	NA
SFRSTCR_BILL_HR_HOLD	NA	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_HISTORY	COURSE_CREDITS_HOLD COURSE_CREDITS_HOLD COURSE_BILLING_HOLD COURSE_BILLING_HOLD	NA
SFRSTCR_BLCK_CODE	SFAREGS
SFRSTCR_BRDH_SEQ_NUM	NA
SFRSTCR_CAMP_CODE	SFAREGS				NA
SFRSTCR_CREDIT_HR	SFAREGS	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS	COURSE_CREDITS	NA
SFRSTCR_CREDIT_HR_HOLD	NA				NA
SFRSTCR_CRN	SFAREGS	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS	COURSE_REFERENCE_NUMBER	NA
SFRSTCR_ERROR_FLAG	SFAREGS	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_HISTORY	REGISTRATION_ERROR_FLAG REGISTRATION_ERROR_FLAG	NA
SFRSTCR_GCMT_CODE	TBD
SFRSTCR_GMOD_CODE	SFAREGS	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS	GRADE_TYPE	NA
SFRSTCR_GRDE_CODE	SFAREGS	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS	FINAL_GRADE	NA
SFRSTCR_GRDE_CODE_MID	SFAREGS	COMPOSITE VIEW	AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS	MID_TERM_GRADE MID_TERM_GRADE	NA
SFRSTCR_GRDE_DATE	SFAREGS	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS	FINAL_GRADE_DATE	NA
SFRSTCR_LAST_ATTEND	SFAALST	COMPOSITE VIEW	AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS	LAST_ATTEND_DATE LAST_ATTEND_DATE
SFRSTCR_LEVL_CODE	SFAREGS	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS	COURSE_LEVEL	NA
SFRSTCR_PIDM	NA	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS	PERSON_UID	NA
SFRSTCR_PTRM_CODE	SFAREGS	COMPOSITE VIEW	AS_FACULTY_FEEDBACK AS_FACULTY_FEEDBACK_DETAIL AS_STUDENT_COURSE_IN_PROGRESS	SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD	NA
SFRSTCR_REG_SEQ	SFAREGS	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_IN_PROGRESS	REGISTRATION_SEQUENCE_NUMBER COURSE_SEQ_NO	NA
SFRSTCR_REPT_OVER	SFAREGS				NA
SFRSTCR_RSTS_CODE	SFAREGS	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_HISTORY	REGISTRATION_STATUS REGISTRATION_STATUS	NA
SFRSTCR_RSTS_DATE	SFAREGS	COMPOSITE VIEW	AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS	REGISTRATION_STATUS_DATE REGISTRATION_STATUS_DATE	NA
SFRSTCR_STSP_KEY_SEQUENCE	SFAREGS
SFRSTCR_TERM_CODE	SFAREGS	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS	ACADEMIC_PERIOD	NA
SFRSTCR_USER	SFAREGS	COMPOSITE VIEW	AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS	REGISTRATION_USER_ID REGISTRATION_USER_ID	NA

Ver: