| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| SSBSECT_ACCT_CODE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
ACCOUNTING_METHOD |
NO |
NA |
| SSBSECT_BILL_HRS |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING AS_COURSE_OFFERING |
MAX_BILLING MIN_BILLING |
NO NO |
NA |
| SSBSECT_CAMP_CODE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING AS_STUDENT_COURSE_IN_PROGRESS |
CAMPUS COURSE_CAMPUS |
NO NO |
NA |
| SSBSECT_CENSUS_2_DATE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
CENSUS_ENROLLMENT_DATE2 |
NO |
NA |
| SSBSECT_CENSUS_2_ENRL |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
CENSUS_ENROLLMENT2 |
NO |
NA |
| SSBSECT_CENSUS_ENRL |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
CENSUS_ENROLLMENT1 |
NO |
NA |
| SSBSECT_CENSUS_ENRL_DATE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
CENSUS_ENROLLMENT_DATE1 |
NO |
NA |
| SSBSECT_CONT_HR |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING AS_COURSE_OFFERING |
MAX_CONTACT_HOURS MIN_CONTACT_HOURS |
NO NO |
NA |
| SSBSECT_CREDIT_HRS |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING AS_COURSE_OFFERING |
MAX_CREDITS MIN_CREDITS |
NO NO |
NA |
| SSBSECT_CRN |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING AS_OFFERING_GRADE_TYPE |
COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER |
NO NO |
NA |
| SSBSECT_CRSE_NUMB |
SSASECT |
NO |
COMPOSITE VIEW |
AS_OFFERING_COREQ AS_MEETING_TIME AS_OFFERING_GRADE_TYPE AS_STUDENT_COURSE_IN_PROGRESS AS_FACULTY_FEEDBACK AS_COURSE_OFFERING AS_OFFERING_COREQ AS_OFFERING_PREREQ |
COREQ_COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER |
NO NO NO NO NO NO NO NO |
NA |
| SSBSECT_CRSE_TITLE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING AS_MEETING_TIME |
TITLE_SHORT_DESC TITLE_SHORT_DESC |
NO NO |
NA |
| SSBSECT_DUNT_CODE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING AS_COURSE_OFFERING |
DURATION_UNITS DURATION |
NO NO |
NA |
| SSBSECT_ENRL |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
ACTUAL_ENROLLMENT |
NO |
NA |
| SSBSECT_GMOD_CODE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING AS_OFFERING_GRADE_TYPE |
GRADE_TYPE GRADE_TYPE |
NO NO |
NA |
| SSBSECT_GRADABLE_IND |
SSASECT |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS AS_COURSE_OFFERING AS_STUDENT_COURSE_HISTORY |
GRADABLE_IND GRADABLE_IND GRADABLE_IND |
NO NO NO |
NA |
| SSBSECT_INSM_CODE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_MEETING_TIME AS_COURSE_OFFERING AS_STUDENT_COURSE_IN_PROGRESS |
INSTRUCTION_DELIVERY_MODE INSTRUCTION_METHOD INSTRUCTION_METHOD |
NO NO NO |
NA |
| SSBSECT_INTG_CDE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY AS_COURSE_OFFERING AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_TRANSFER |
INTEGRATION_PARTNER INTEGRATION_PARTNER INTEGRATION_PARTNER INTEGRATION_PARTNER |
NO NO NO NO |
|
| SSBSECT_LAB_HR |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING AS_COURSE_OFFERING |
MAX_LAB_HOURS MIN_LAB_HOURS |
NO NO |
NA |
| SSBSECT_LEC_HR |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING AS_COURSE_OFFERING |
MAX_LECTURE_HOURS MIN_LECTURE_HOURS |
NO NO |
NA |
| SSBSECT_LINK_IDENT |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
LINK_IDENTIFIER |
NO |
NA |
| SSBSECT_MAX_ENRL |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
MAXIMUM_ENROLLMENT |
NO |
NA |
| SSBSECT_NUMBER_OF_EXTENSIONS |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
EXTENSIONS_PERMITTED |
NO |
NA |
| SSBSECT_OTH_HR |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING AS_COURSE_OFFERING |
MAX_OTHER_HOURS MIN_OTHER_HOURS |
NO NO |
NA |
| SSBSECT_PRIOR_ENRL |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
PRIOR_ENROLLMENT |
NO |
NA |
| SSBSECT_PRNT_IND |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
SCHEDULE_PRINT_IND |
NO |
NA |
| SSBSECT_PROJ_ENRL |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
TARGET_ENROLLMENT |
NO |
NA |
| SSBSECT_PTRM_CODE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING AS_MEETING_TIME AS_OFFERING_COREQ AS_OFFERING_GRADE_TYPE AS_OFFERING_PREREQ AS_COURSE_OFFERING |
PART_OF_TERM SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD |
NO NO NO NO NO NO |
NA |
| SSBSECT_PTRM_END_DATE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING AS_COURSE_OFFERING |
END_DATE PART_OF_TERM_END_DATE |
NO NO |
NA |
| SSBSECT_PTRM_START_DATE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING AS_COURSE_OFFERING |
PART_OF_TERM_START_DATE START_DATE |
NO NO |
NA |
| SSBSECT_PTRM_WEEKS |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
ACADEMIC_PERIOD_WEEKS |
NO |
NA |
| SSBSECT_REG_FROM_DATE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
REGISTRATION_START_DATE |
NO |
NA |
| SSBSECT_REG_TO_DATE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
REGISTRATION_END_DATE |
NO |
NA |
| SSBSECT_RESERVED_IND |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
RESERVED_IND |
NO |
NA |
| SSBSECT_SAPR_CODE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
SPECIAL_APPROVAL |
NO |
NA |
| SSBSECT_SCHD_CODE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS AS_COURSE_OFFERING |
SCHEDULE_TYPE SCHEDULE |
NO NO |
NA |
| SSBSECT_SEATS_AVAIL |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
SEATS_AVAILABLE |
NO |
NA |
| SSBSECT_SEQ_NUMB |
SSASECT |
NO |
COMPOSITE VIEW |
AS_FACULTY_FEEDBACK AS_STUDENT_COURSE_IN_PROGRESS AS_COURSE_OFFERING AS_MEETING_TIME |
COURSE_SECTION_NUMBER COURSE_SECTION_NUMBER OFFERING_NUMBER SECTION |
NO NO NO NO |
NA |
| SSBSECT_SESS_CODE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
STUDENT_MEETING_TIME |
NO |
NA |
| SSBSECT_SSTS_CODE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
STATUS |
NO |
NA |
| SSBSECT_SUBJ_CODE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_OFFERING_COREQ AS_OFFERING_PREREQ AS_COURSE_OFFERING AS_OFFERING_COREQ AS_STUDENT_COURSE_IN_PROGRESS AS_FACULTY_FEEDBACK AS_MEETING_TIME AS_OFFERING_GRADE_TYPE |
COREQ_SUBJECT SUBJECT SUBJECT SUBJECT SUBJECT SUBJECT SUBJECT SUBJECT |
NO NO NO NO NO NO NO NO |
NA |
| SSBSECT_TERM_CODE |
SSASECT |
NO |
COMPOSITE VIEW |
AS_OFFERING_GRADE_TYPE AS_VALIDATION AS_COURSE_OFFERING |
ACADEMIC_PERIOD QUALIFIER ACADEMIC_PERIOD |
NO NO NO |
NA |
| SSBSECT_TITLE |
SSASECT |
NO |
|
|
|
|
NA |
| SSBSECT_TOT_CREDIT_HRS |
SSASECT |
NO |
|
|
|
|
NA |
| SSBSECT_TUIW_IND |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING |
EXEMPT_TUITION_SECTION |
NO |
NA |
| SSBSECT_VOICE_AVAIL |
SSASECT |
NO |
|
|
|
|
NA |
| SSBSECT_WAIT_AVAIL |
SSASECT |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS AS_COURSE_OFFERING AS_STUDENT_COURSE_HISTORY |
WAITLIST_AVAILABLE WAIT_AVAILABLE WAITLIST_AVAILABLE |
NO NO NO |
NA |
| SSBSECT_WAIT_CAPACITY |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_HISTORY |
WAIT_CAPACITY WAITLIST_CAPACITY WAITLIST_CAPACITY |
NO NO NO |
NA |
| SSBSECT_WAIT_COUNT |
SSASECT |
NO |
COMPOSITE VIEW |
AS_COURSE_OFFERING AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS |
WAIT_COUNT WAITLIST_COUNT WAITLIST_COUNT |
NO NO NO |
NA |