RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: SSBSECT Student Reporting View Meta Data Reports
SGHE Operational Data Store Reporting View Source: SSBSECT

Source Column Source Form Target Type Target Target Column Calculation Formula
SSBSECT_ACCT_CODE SSASECT

REPORTING VIEW

GOVERNMENT_COURSE

SCHEDULE_OFFERING

ACCOUNTING_METHOD

ACCOUNTING_METHOD

NA
SSBSECT_BILL_HRS SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

SCHEDULE_OFFERING

MIN_BILLING

MAX_BILLING

NA
SSBSECT_CAMP_CODE SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

STUDENT_COURSE

CAMPUS

CAMPUS

NA
SSBSECT_CENSUS_2_DATE SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

GOVERNMENT_COURSE

CENSUS_ENROLLMENT_DATE2

CENSUS_ENROLLMENT_DATE2

NA
SSBSECT_CENSUS_2_ENRL SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

GOVERNMENT_COURSE

CENSUS_ENROLLMENT2

CENSUS_ENROLLMENT2

NA
SSBSECT_CENSUS_ENRL SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

GOVERNMENT_COURSE

CENSUS_ENROLLMENT1

CENSUS_ENROLLMENT1

NA
SSBSECT_CENSUS_ENRL_DATE SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

GOVERNMENT_COURSE

CENSUS_ENROLLMENT_DATE1

CENSUS_ENROLLMENT_DATE1

NA
SSBSECT_CONT_HR SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

SCHEDULE_OFFERING

MAX_CONTACT_HOURS

MIN_CONTACT_HOURS

NA
SSBSECT_CREDIT_HRS SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

SCHEDULE_OFFERING

MAX_CREDITS

MIN_CREDITS

NA
SSBSECT_CRN SSASECT

REPORTING VIEW

OFFERING_GRADE_TYPE

SCHEDULE_OFFERING

COURSE_REFERENCE_NUMBER

COURSE_REFERENCE_NUMBER

NA
SSBSECT_CRSE_NUMB SSASECT

REPORTING VIEW

OFFERING_COREQ

OFFERING_COREQ

STUDENT_COURSE_REG_AUDIT

STUDENT_COURSE

MEETING_TIME

SCHEDULE_OFFERING

OFFERING_PREREQ

OFFERING_GRADE_TYPE

COREQ_COURSE_NUMBER

COURSE_NUMBER

COURSE_NUMBER

COURSE_NUMBER

COURSE_NUMBER

COURSE_NUMBER

COURSE_NUMBER

COURSE_NUMBER

NA
SSBSECT_CRSE_TITLE SSASECT

REPORTING VIEW

STUDENT_COURSE

MEETING_TIME

COURSE_TITLE_SHORT

TITLE_SHORT_DESC

NA
SSBSECT_DUNT_CODE SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

SCHEDULE_OFFERING

DURATION_UNITS

DURATION

NA
SSBSECT_ENRL SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

GOVERNMENT_COURSE

GOVERNMENT_COURSE

ACTUAL_ENROLLMENT

SEATS_AVAILABLE

ACTUAL_ENROLLMENT

NA
SSBSECT_GMOD_CODE SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

OFFERING_GRADE_TYPE

GRADE_TYPE

GRADE_TYPE

NA
SSBSECT_GRADABLE_IND SSASECT

REPORTING VIEW

STUDENT_COURSE

SCHEDULE_OFFERING

GRADABLE_IND

GRADABLE_IND

NA
SSBSECT_INSM_CODE SSASECT

REPORTING VIEW

MEETING_TIME

GOVERNMENT_COURSE

STUDENT_COURSE

INSTRUCTION_DELIVERY_MODE

INSTRUCTION_METHOD

INSTRUCTION_METHOD

NA
SSBSECT_LAB_HR SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

SCHEDULE_OFFERING

MAX_LAB_HOURS

MIN_LAB_HOURS

NA
SSBSECT_LEC_HR SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

SCHEDULE_OFFERING

MAX_LECTURE_HOURS

MIN_LECTURE_HOURS

NA
SSBSECT_LINK_IDENT SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

LINK_IDENTIFIER

NA
SSBSECT_MAX_ENRL SSASECT

REPORTING VIEW

GOVERNMENT_COURSE

SCHEDULE_OFFERING

MAXIMUM_ENROLLMENT

MAXIMUM_ENROLLMENT

NA
SSBSECT_NUMBER_OF_EXTENSIONS SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

EXTENSIONS_PERMITTED

NA
SSBSECT_OTH_HR SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

SCHEDULE_OFFERING

MIN_OTHER_HOURS

MAX_OTHER_HOURS

NA
SSBSECT_PRIOR_ENRL SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

PRIOR_ENROLLMENT

NA
SSBSECT_PROJ_ENRL SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

TARGET_ENROLLMENT

NA
SSBSECT_PTRM_CODE SSASECT

REPORTING VIEW

OFFERING_GRADE_TYPE

OFFERING_PREREQ

INSTRUCTIONAL_ASSIGNMENT

OFFERING_COREQ

MEETING_TIME

SCHEDULE_OFFERING

SUB_ACADEMIC_PERIOD

SUB_ACADEMIC_PERIOD

SUB_ACADEMIC_PERIOD

SUB_ACADEMIC_PERIOD

SUB_ACADEMIC_PERIOD

SUB_ACADEMIC_PERIOD

NA
SSBSECT_PTRM_END_DATE SSASECT

REPORTING VIEW

STUDENT_COURSE

SCHEDULE_OFFERING

END_DATE

END_DATE

NA
SSBSECT_PTRM_START_DATE SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

START_DATE

NA
SSBSECT_PTRM_WEEKS SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

ACADEMIC_PERIOD_WEEKS

NA
SSBSECT_REG_FROM_DATE SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

REGISTRATION_START_DATE

NA
SSBSECT_REG_TO_DATE SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

REGISTRATION_END_DATE

NA
SSBSECT_SAPR_CODE SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

SPECIAL_APPROVAL

NA
SSBSECT_SCHD_CODE SSASECT

REPORTING VIEW

STUDENT_COURSE

GOVERNMENT_COURSE

SCHEDULE_OFFERING

SCHEDULE_TYPE

SCHEDULE

SCHEDULE

NA
SSBSECT_SEATS_AVAIL SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

SEATS_AVAILABLE

NA
SSBSECT_SEQ_NUMB SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

STUDENT_COURSE

MEETING_TIME

GOVERNMENT_COURSE

STUDENT_COURSE_REG_AUDIT

OFFERING_NUMBER

COURSE_SECTION_NUMBER

SECTION

OFFERING_NUMBER

COURSE_SECTION_NUMBER

NA
SSBSECT_SESS_CODE SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

STUDENT_MEETING_TIME

NA
SSBSECT_SSTS_CODE SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

STATUS

NA
SSBSECT_SUBJ_CODE SSASECT

REPORTING VIEW

OFFERING_COREQ

OFFERING_PREREQ

OFFERING_GRADE_TYPE

MEETING_TIME

SCHEDULE_OFFERING

OFFERING_COREQ

OFFERING_GRADE_TYPE

STUDENT_COURSE

STUDENT_COURSE_REG_AUDIT

COREQ_SUBJECT

SUBJECT

COURSE_IDENTIFICATION

SUBJECT

SUBJECT

SUBJECT

SUBJECT

SUBJECT

SUBJECT

NA
SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB SSASECT

REPORTING VIEW

STUDENT_COURSE_REG_AUDIT

COURSE_IDENTIFICATION

Subject and course number concatenated together.
SSBSECT_TERM_CODE SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

OFFERING_GRADE_TYPE

ACADEMIC_PERIOD

ACADEMIC_PERIOD

NA
SSBSECT_TITLE SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

TITLE_SHORT_DESC

NA
SSBSECT_TOT_CREDIT_HRS SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

GENERATED_CREDITS

NA
SSBSECT_TUIW_IND SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

GOVERNMENT_COURSE

EXEMPT_TUITION_SECTION

EXEMPT_TUITION_SECTION

NA
SSBSECT_VOICE_AVAIL SSASECT

REPORTING VIEW

SCHEDULE_OFFERING

VOICE_WEB_AVAILABLE_IND

NA


Ver: 3.1