Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
SFRSTCR_ACTIVITY_DATE |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS |
REGISTRATION_ACT_DATE REGISTRATION_ACT_DATE |
NO NO |
NA |
SFRSTCR_ADD_DATE |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS |
SECTION_ADD_DATE SECTION_ADD_DATE |
NO NO |
NA |
SFRSTCR_APPR_RECEIVED_IND |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS |
SPECIAL_APPROVAL_IND SPECIAL_APPROVAL_IND |
NO NO |
NA |
SFRSTCR_ATTEND_HR |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_HISTORY |
HOURS_ATTENDED HOURS_ATTENDED |
NO NO |
NA |
SFRSTCR_BILL_HR |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS |
COURSE_BILLING_CREDITS COURSE_BILLING_CREDITS |
NO NO |
NA |
SFRSTCR_BILL_HR_HOLD |
NA |
NO |
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 |
NO NO NO NO |
NA |
SFRSTCR_BLCK_CODE |
SFAREGS |
NO |
|
|
|
|
|
SFRSTCR_BRDH_SEQ_NUM |
NA |
NO |
|
|
|
|
|
SFRSTCR_CAMP_CODE |
SFAREGS |
NO |
|
|
|
|
NA |
SFRSTCR_CREDIT_HR |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS |
COURSE_CREDITS |
NO |
NA |
SFRSTCR_CREDIT_HR_HOLD |
NA |
NO |
|
|
|
|
NA |
SFRSTCR_CRN |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS |
COURSE_REFERENCE_NUMBER |
NO |
NA |
SFRSTCR_ERROR_FLAG |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_HISTORY |
REGISTRATION_ERROR_FLAG REGISTRATION_ERROR_FLAG |
NO NO |
NA |
SFRSTCR_GCMT_CODE |
TBD |
NO |
|
|
|
|
|
SFRSTCR_GMOD_CODE |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS |
GRADE_TYPE |
NO |
NA |
SFRSTCR_GRDE_CODE |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS |
FINAL_GRADE |
NO |
NA |
SFRSTCR_GRDE_CODE_MID |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS |
MID_TERM_GRADE MID_TERM_GRADE |
NO NO |
NA |
SFRSTCR_GRDE_DATE |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS |
FINAL_GRADE_DATE |
NO |
NA |
SFRSTCR_LAST_ATTEND |
SFAALST |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS |
LAST_ATTEND_DATE LAST_ATTEND_DATE |
NO NO |
|
SFRSTCR_LEVL_CODE |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS |
COURSE_LEVEL |
NO |
NA |
SFRSTCR_PIDM |
NA |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS |
PERSON_UID |
NO |
NA |
SFRSTCR_PTRM_CODE |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_FACULTY_FEEDBACK AS_FACULTY_FEEDBACK_DETAIL AS_STUDENT_COURSE_IN_PROGRESS |
SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD |
NO NO NO |
NA |
SFRSTCR_REG_SEQ |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_IN_PROGRESS |
REGISTRATION_SEQUENCE_NUMBER COURSE_SEQ_NO |
NO NO |
NA |
SFRSTCR_REPT_OVER |
SFAREGS |
NO |
|
|
|
|
NA |
SFRSTCR_RSTS_CODE |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_HISTORY |
REGISTRATION_STATUS REGISTRATION_STATUS |
NO NO |
NA |
SFRSTCR_RSTS_DATE |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS |
REGISTRATION_STATUS_DATE REGISTRATION_STATUS_DATE |
NO NO |
NA |
SFRSTCR_STSP_KEY_SEQUENCE |
SFAREGS |
NO |
|
|
|
|
|
SFRSTCR_TERM_CODE |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS |
ACADEMIC_PERIOD |
NO |
NA |
SFRSTCR_USER |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS |
REGISTRATION_USER_ID REGISTRATION_USER_ID |
NO NO |
NA |
SFRSTCR_WL_PRIORITY |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_HISTORY |
WAITLIST_PRIORITY WAITLIST_PRIORITY |
NO NO |
NA |
SFRSTCR_WL_PRIORITY_ORIG |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_HISTORY |
WAITLIST_PRIORITY_ORIG WAITLIST_PRIORITY_ORIG |
NO NO |
NA |