Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
SSBSECT_ACCT_CODE |
SSASECT |
NO |
REPORTING VIEW |
GOVERNMENT_COURSE SCHEDULE_OFFERING |
ACCOUNTING_METHOD ACCOUNTING_METHOD |
NO NO |
NA |
SSBSECT_BILL_HRS |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING SCHEDULE_OFFERING |
MIN_BILLING MAX_BILLING |
NO NO |
NA |
SSBSECT_CAMP_CODE |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING |
CAMPUS |
NO |
NA |
SSBSECT_CENSUS_2_DATE |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING GOVERNMENT_COURSE GOVERNMENT_COURSE |
CENSUS_ENROLLMENT_DATE2 REGISTER_CENSUS_DATE2_IND CENSUS_ENROLLMENT_DATE2 |
NO NO NO |
NA |
SSBSECT_CENSUS_2_ENRL |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING GOVERNMENT_COURSE PROJECTED_SEATS_NEEDED |
CENSUS_ENROLLMENT2 CENSUS_ENROLLMENT2 CENSUS_ENROLLMENT2 |
NO NO NO |
NA |
SSBSECT_CENSUS_ENRL |
SSASECT |
NO |
REPORTING VIEW |
GOVERNMENT_COURSE SCHEDULE_OFFERING PROJECTED_SEATS_NEEDED GOVERNMENT_COURSE |
REGISTER_CENSUS_DATE1_IND CENSUS_ENROLLMENT1 CENSUS_ENROLLMENT1 CENSUS_ENROLLMENT1 |
NO NO NO NO |
NA |
SSBSECT_CENSUS_ENRL_DATE |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING GOVERNMENT_COURSE |
CENSUS_ENROLLMENT_DATE1 CENSUS_ENROLLMENT_DATE1 |
NO NO |
NA |
SSBSECT_CONT_HR |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING SCHEDULE_OFFERING |
MIN_CONTACT_HOURS MAX_CONTACT_HOURS |
NO NO |
NA |
SSBSECT_CREDIT_HRS |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING SCHEDULE_OFFERING |
MAX_CREDITS MIN_CREDITS |
NO NO |
NA |
SSBSECT_CRN |
SSASECT |
NO |
REPORTING VIEW |
OFFERING_GRADE_TYPE SCHEDULE_OFFERING |
COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER |
NO NO |
NA |
SSBSECT_CRSE_NUMB |
SSASECT |
NO |
REPORTING VIEW |
FACULTY_FEEDBACK OFFERING_COREQ SCHEDULE_OFFERING BLOCK_REGISTRATION_COURSE MEETING_TIME FACULTY_FEEDBACK_DETAIL COURSE_LEVEL_SLOT OFFERING_PREREQ OFFERING_GRADE_TYPE STUDENT_COURSE OFFERING_COREQ STUDENT_COURSE_REG_AUDIT |
COURSE_NUMBER COREQ_COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER |
NO NO NO NO NO NO NO NO NO NO NO NO |
NA |
SSBSECT_CRSE_TITLE |
SSASECT |
NO |
REPORTING VIEW |
MEETING_TIME STUDENT_COURSE |
TITLE_SHORT_DESC COURSE_TITLE_SHORT |
NO NO |
NA |
SSBSECT_DUNT_CODE |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING SCHEDULE_OFFERING |
DURATION DURATION_UNITS |
NO NO |
NA |
SSBSECT_ENRL |
SSASECT |
NO |
REPORTING VIEW |
GOVERNMENT_COURSE PROJECTED_SEATS_NEEDED SCHEDULE_OFFERING GOVERNMENT_COURSE |
SEATS_AVAILABLE ACTUAL_ENROLLMENT ACTUAL_ENROLLMENT ACTUAL_ENROLLMENT |
NO NO NO NO |
NA |
SSBSECT_GMOD_CODE |
SSASECT |
NO |
REPORTING VIEW |
OFFERING_GRADE_TYPE SCHEDULE_OFFERING |
GRADE_TYPE GRADE_TYPE |
NO NO |
NA |
SSBSECT_GRADABLE_IND |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING STUDENT_COURSE |
GRADABLE_IND GRADABLE_IND |
NO NO |
NA |
SSBSECT_INSM_CODE |
SSASECT |
NO |
REPORTING VIEW |
GOVERNMENT_COURSE MEETING_TIME SCHEDULE_OFFERING |
INSTRUCTION_METHOD INSTRUCTION_DELIVERY_MODE INSTRUCTION_METHOD |
NO NO NO |
NA |
SSBSECT_INTG_CDE |
SSASECT |
NO |
REPORTING VIEW |
GOVERNMENT_COURSE STUDENT_COURSE SCHEDULE_OFFERING |
INTEGRATION_PARTNER INTEGRATION_PARTNER INTEGRATION_PARTNER |
NO NO NO |
|
SSBSECT_LAB_HR |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING SCHEDULE_OFFERING |
MAX_LAB_HOURS MIN_LAB_HOURS |
NO NO |
NA |
SSBSECT_LEC_HR |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING SCHEDULE_OFFERING |
MAX_LECTURE_HOURS MIN_LECTURE_HOURS |
NO NO |
NA |
SSBSECT_LINK_IDENT |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING |
LINK_IDENTIFIER |
NO |
NA |
SSBSECT_MAX_ENRL |
SSASECT |
NO |
REPORTING VIEW |
GOVERNMENT_COURSE PROJECTED_SEATS_NEEDED SCHEDULE_OFFERING |
MAXIMUM_ENROLLMENT MAXIMUM_ENROLLMENT MAXIMUM_ENROLLMENT |
NO NO NO |
NA |
SSBSECT_NUMBER_OF_EXTENSIONS |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING |
EXTENSIONS_PERMITTED |
NO |
NA |
SSBSECT_OTH_HR |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING SCHEDULE_OFFERING |
MAX_OTHER_HOURS MIN_OTHER_HOURS |
NO NO |
NA |
SSBSECT_PRIOR_ENRL |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING PROJECTED_SEATS_NEEDED |
PRIOR_ENROLLMENT PRIOR_ENROLLMENT |
NO NO |
NA |
SSBSECT_PRNT_IND |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING |
SCHEDULE_PRINT_IND |
NO |
NA |
SSBSECT_PROJ_ENRL |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING PROJECTED_SEATS_NEEDED |
TARGET_ENROLLMENT TARGET_ENROLLMENT |
NO NO |
NA |
SSBSECT_PTRM_CODE |
SSASECT |
NO |
REPORTING VIEW |
REGISTRATION_PLAN_COURSE MEETING_TIME OFFERING_COREQ PROJECTED_SEATS_NEEDED BLOCK_REGISTRATION_COURSE INSTRUCTIONAL_ASSIGNMENT OFFERING_GRADE_TYPE OFFERING_PREREQ SCHEDULE_OFFERING |
SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD |
NO NO NO NO NO NO NO NO NO |
NA |
SSBSECT_PTRM_END_DATE |
SSASECT |
NO |
REPORTING VIEW |
STUDENT_COURSE SCHEDULE_OFFERING |
END_DATE END_DATE |
NO NO |
NA |
SSBSECT_PTRM_START_DATE |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING |
START_DATE |
NO |
NA |
SSBSECT_PTRM_WEEKS |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING |
ACADEMIC_PERIOD_WEEKS |
NO |
NA |
SSBSECT_REG_FROM_DATE |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING |
REGISTRATION_START_DATE |
NO |
NA |
SSBSECT_REG_TO_DATE |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING |
REGISTRATION_END_DATE |
NO |
NA |
SSBSECT_RESERVED_IND |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING |
RESERVED_IND |
NO |
NA |
SSBSECT_SAPR_CODE |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING |
SPECIAL_APPROVAL |
NO |
NA |
SSBSECT_SCHD_CODE |
SSASECT |
NO |
REPORTING VIEW |
STUDENT_COURSE GOVERNMENT_COURSE SCHEDULE_OFFERING |
SCHEDULE_TYPE SCHEDULE SCHEDULE |
NO NO NO |
NA |
SSBSECT_SEATS_AVAIL |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING |
SEATS_AVAILABLE |
NO |
NA |
SSBSECT_SEQ_NUMB |
SSASECT |
NO |
REPORTING VIEW |
MEETING_TIME FACULTY_FEEDBACK_DETAIL SCHEDULE_OFFERING STUDENT_COURSE FACULTY_FEEDBACK GOVERNMENT_COURSE STUDENT_COURSE_REG_AUDIT |
SECTION COURSE_SECTION_NUMBER OFFERING_NUMBER COURSE_SECTION_NUMBER COURSE_SECTION_NUMBER OFFERING_NUMBER COURSE_SECTION_NUMBER |
NO NO NO NO NO NO NO |
NA |
SSBSECT_SESS_CODE |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING |
STUDENT_MEETING_TIME |
NO |
NA |
SSBSECT_SSTS_CODE |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING |
STATUS |
NO |
NA |
SSBSECT_SUBJ_CODE |
SSASECT |
NO |
REPORTING VIEW |
FACULTY_FEEDBACK MEETING_TIME STUDENT_COURSE STUDENT_COURSE_REG_AUDIT OFFERING_COREQ OFFERING_COREQ SCHEDULE_OFFERING BLOCK_REGISTRATION_COURSE COURSE_LEVEL_SLOT FACULTY_FEEDBACK_DETAIL OFFERING_PREREQ OFFERING_GRADE_TYPE |
SUBJECT SUBJECT SUBJECT SUBJECT SUBJECT COREQ_SUBJECT SUBJECT SUBJECT SUBJECT SUBJECT SUBJECT SUBJECT |
NO NO NO NO NO NO NO NO NO NO NO NO |
NA |
SSBSECT_TERM_CODE |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING OFFERING_GRADE_TYPE |
ACADEMIC_PERIOD ACADEMIC_PERIOD |
NO NO |
NA |
SSBSECT_TITLE |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING |
TITLE_SHORT_DESC |
NO |
NA |
SSBSECT_TOT_CREDIT_HRS |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING |
GENERATED_CREDITS |
NO |
NA |
SSBSECT_TUIW_IND |
SSASECT |
NO |
REPORTING VIEW |
GOVERNMENT_COURSE SCHEDULE_OFFERING |
EXEMPT_TUITION_SECTION EXEMPT_TUITION_SECTION |
NO NO |
NA |
SSBSECT_VOICE_AVAIL |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING |
VOICE_WEB_AVAILABLE_IND |
NO |
NA |
SSBSECT_WAIT_AVAIL |
SSASECT |
NO |
REPORTING VIEW |
STUDENT_COURSE SCHEDULE_OFFERING |
WAITLIST_AVAILABLE WAIT_AVAILABLE |
NO NO |
NA |
SSBSECT_WAIT_CAPACITY |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING STUDENT_COURSE |
WAIT_CAPACITY WAITLIST_CAPACITY |
NO NO |
NA |
SSBSECT_WAIT_COUNT |
SSASECT |
NO |
REPORTING VIEW |
SCHEDULE_OFFERING STUDENT_COURSE |
WAIT_COUNT WAITLIST_COUNT |
NO NO |
NA |