Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
SHRTTRM_ASTD_CODE_DL |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ENROLLMENT_HISTORY |
DEANS_LIST_VALUE |
NO |
NA |
SHRTTRM_ASTD_CODE_END_OF_TERM |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ACADEMIC_STANDING |
ACADEMIC_STANDING_END |
NO |
NA |
SHRTTRM_ASTD_DATE_DL |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ENROLLMENT_HISTORY |
DEANS_LIST_DATE |
NO |
NA |
SHRTTRM_ASTD_DATE_END_OF_TERM |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ACADEMIC_STANDING |
ACADEMIC_STANDING_END_DT |
NO |
NA |
SHRTTRM_CAST_CODE |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ACADEMIC_STANDING |
COMBINED_ACAD_STAND_END |
NO |
|
SHRTTRM_CAST_DATE |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ACADEMIC_STANDING |
COMBINED_ACAD_STAND_END_DATE |
NO |
|
SHRTTRM_EXAM_CODE |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ENROLLMENT_HISTORY |
SPECIAL_EXAM_CREDIT |
NO |
NA |
SHRTTRM_GRADE_MAILER_CHG_DATE |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ENROLLMENT_HISTORY |
GRADE_MAILER_CHG_DATE |
NO |
|
SHRTTRM_GRADE_MAILER_DUP |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ENROLLMENT_HISTORY |
GRADE_MAILER_DUP |
NO |
|
SHRTTRM_GRADE_MAILER_DUP_DATE |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ENROLLMENT_HISTORY |
GRADE_MAILER_DUP_DATE |
NO |
|
SHRTTRM_GRADE_MAILING_DATE |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ENROLLMENT_HISTORY |
GRADE_MAILING_DATE |
NO |
|
SHRTTRM_PIDM |
NA |
NO |
COMPOSITE VIEW |
AS_ACTIVE_TERMS AS_ACADEMIC_STANDING AS_ENROLLMENT_HISTORY |
PERSON_UID PERSON_UID PERSON_UID |
NO NO NO |
|
SHRTTRM_PREV_CODE |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ACADEMIC_STANDING |
PROGRESS_EVALUATION_END |
NO |
|
SHRTTRM_PREV_DATE |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ACADEMIC_STANDING |
PROGRESS_EVALUATION_END_DATE |
NO |
|
SHRTTRM_PRE_CATALOG_IND |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ENROLLMENT_HISTORY |
PRE_CATALOG_IND |
NO |
|
SHRTTRM_RECORD_STATUS_DATE |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ENROLLMENT_HISTORY |
RECORD_STATUS_DATE |
NO |
|
SHRTTRM_RECORD_STATUS_IND |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ENROLLMENT_HISTORY |
RECORD_STATUS_IND |
NO |
|
SHRTTRM_SBGI_CODE_TRANS |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ENROLLMENT_HISTORY |
TRANSFER_TO_INSTITUTION |
NO |
NA |
SHRTTRM_TERM_CODE |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ACADEMIC_STANDING AS_ENROLLMENT_HISTORY AS_ACTIVE_TERMS |
ACADEMIC_PERIOD ACADEMIC_PERIOD ACADEMIC_PERIOD |
NO NO NO |
|
SHRTTRM_UPDATE_SOURCE_IND |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ENROLLMENT_HISTORY |
RECORD_SOURCE_IND |
NO |
|
SHRTTRM_WRSN_CODE |
SHAINST |
NO |
COMPOSITE VIEW |
AS_ENROLLMENT_HISTORY |
WITHDRAWAL_REASON |
NO |
NA |