Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
SHRTCKN_CAMP_CODE |
SHATCKC |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY |
COURSE_CAMPUS |
NO |
NA |
SHRTCKN_COLL_CODE |
SHATCKC |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY |
COURSE_COLLEGE |
NO |
NA |
SHRTCKN_COURSE_COMMENT |
SHATCKC |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY |
COURSE_COMMENT |
NO |
NA |
SHRTCKN_CRN |
SHATCKC |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_GRADE_CHG |
COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER |
NO NO |
NA |
SHRTCKN_CRSE_NUMB |
SHATCKC |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_GRADE_CHG AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_ATTRIBUTE |
COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER |
NO NO NO |
NA |
SHRTCKN_CRSE_TITLE |
SHATCKC |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY |
COURSE_TITLE_SHORT |
NO |
NA |
SHRTCKN_DEPT_CODE |
SHATCKC |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY |
COURSE_DEPARTMENT |
NO |
NA |
SHRTCKN_DIVS_CODE |
SHATCKC |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY |
COURSE_DIVISION |
NO |
NA |
SHRTCKN_LONG_COURSE_TITLE |
SCASYLB |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY |
COURSE_TITLE_LONG |
NO |
NA |
SHRTCKN_PIDM |
NA |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_ATTRIBUTE |
PERSON_UID PERSON_UID |
NO NO |
NA |
SHRTCKN_PTRM_CODE |
SHATCKC |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_GRADE_CHG |
SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD |
NO NO NO |
NA |
SHRTCKN_REG_SEQ |
NA |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY |
REGISTRATION_SEQUENCE_NUMBER |
NO |
NA |
SHRTCKN_REPEAT_COURSE_IND |
SHATCKC |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY |
REPEAT_COURSE_IND |
NO |
NA |
SHRTCKN_SCHD_CODE |
SHATCKC |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY |
SCHEDULE_TYPE |
NO |
NA |
SHRTCKN_SEQ_NO |
NA |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_HISTORY |
COURSE_SEQUENCE_NUMBER COURSE_SEQ_NO |
NO NO |
NA |
SHRTCKN_SEQ_NUMB |
SHATCKC |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY |
COURSE_SECTION_NUMBER |
NO |
NA |
SHRTCKN_SUBJ_CODE |
SHATCKC |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_GRADE_CHG AS_STUDENT_COURSE_ATTRIBUTE |
SUBJECT SUBJECT SUBJECT |
NO NO NO |
NA |
SHRTCKN_TERM_CODE |
SHATCKC |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_HISTORY |
ACADEMIC_PERIOD ACADEMIC_PERIOD |
NO NO |
NA |