Reporting View Source: SSBSECT

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: SSBSECT Student Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
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	MAX_BILLING MIN_BILLING	NA
SSBSECT_CAMP_CODE	SSASECT	REPORTING VIEW	SCHEDULE_OFFERING STUDENT_COURSE	CAMPUS CAMPUS	NA
SSBSECT_CENSUS_2_DATE	SSASECT	REPORTING VIEW	GOVERNMENT_COURSE SCHEDULE_OFFERING	CENSUS_ENROLLMENT_DATE2 CENSUS_ENROLLMENT_DATE2	NA
SSBSECT_CENSUS_2_ENRL	SSASECT	REPORTING VIEW	GOVERNMENT_COURSE SCHEDULE_OFFERING	CENSUS_ENROLLMENT2 CENSUS_ENROLLMENT2	NA
SSBSECT_CENSUS_ENRL	SSASECT	REPORTING VIEW	GOVERNMENT_COURSE SCHEDULE_OFFERING	CENSUS_ENROLLMENT1 CENSUS_ENROLLMENT1	NA
SSBSECT_CENSUS_ENRL_DATE	SSASECT	REPORTING VIEW	GOVERNMENT_COURSE SCHEDULE_OFFERING	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	COURSE_LEVEL_SLOT MEETING_TIME OFFERING_COREQ OFFERING_COREQ OFFERING_GRADE_TYPE OFFERING_PREREQ SCHEDULE_OFFERING STUDENT_COURSE STUDENT_COURSE_REG_AUDIT	COURSE_NUMBER COURSE_NUMBER COREQ_COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER	NA
SSBSECT_CRSE_TITLE	SSASECT	REPORTING VIEW	MEETING_TIME STUDENT_COURSE	TITLE_SHORT_DESC COURSE_TITLE_SHORT	NA
SSBSECT_DUNT_CODE	SSASECT	REPORTING VIEW	SCHEDULE_OFFERING SCHEDULE_OFFERING	DURATION DURATION_UNITS	NA
SSBSECT_ENRL	SSASECT	REPORTING VIEW	GOVERNMENT_COURSE GOVERNMENT_COURSE SCHEDULE_OFFERING	ACTUAL_ENROLLMENT SEATS_AVAILABLE ACTUAL_ENROLLMENT	NA
SSBSECT_GMOD_CODE	SSASECT	REPORTING VIEW	OFFERING_GRADE_TYPE SCHEDULE_OFFERING	GRADE_TYPE GRADE_TYPE	NA
SSBSECT_GRADABLE_IND	SSASECT	REPORTING VIEW	SCHEDULE_OFFERING STUDENT_COURSE	GRADABLE_IND GRADABLE_IND	NA
SSBSECT_INSM_CODE	SSASECT	REPORTING VIEW	GOVERNMENT_COURSE MEETING_TIME	INSTRUCTION_METHOD INSTRUCTION_DELIVERY_MODE	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	MAX_OTHER_HOURS MIN_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	INSTRUCTIONAL_ASSIGNMENT MEETING_TIME OFFERING_COREQ 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	NA
SSBSECT_PTRM_END_DATE	SSASECT	REPORTING VIEW	SCHEDULE_OFFERING STUDENT_COURSE	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	GOVERNMENT_COURSE SCHEDULE_OFFERING STUDENT_COURSE	SCHEDULE SCHEDULE SCHEDULE_TYPE	NA
SSBSECT_SEATS_AVAIL	SSASECT	REPORTING VIEW	SCHEDULE_OFFERING	SEATS_AVAILABLE	NA
SSBSECT_SEQ_NUMB	SSASECT	REPORTING VIEW	GOVERNMENT_COURSE MEETING_TIME SCHEDULE_OFFERING STUDENT_COURSE STUDENT_COURSE_REG_AUDIT	OFFERING_NUMBER SECTION OFFERING_NUMBER COURSE_SECTION_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	COURSE_LEVEL_SLOT MEETING_TIME OFFERING_COREQ OFFERING_COREQ OFFERING_GRADE_TYPE OFFERING_GRADE_TYPE OFFERING_PREREQ SCHEDULE_OFFERING STUDENT_COURSE STUDENT_COURSE_REG_AUDIT	SUBJECT SUBJECT COREQ_SUBJECT SUBJECT COURSE_IDENTIFICATION 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	OFFERING_GRADE_TYPE SCHEDULE_OFFERING	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	GOVERNMENT_COURSE SCHEDULE_OFFERING	EXEMPT_TUITION_SECTION EXEMPT_TUITION_SECTION	NA
SSBSECT_VOICE_AVAIL	SSASECT	REPORTING VIEW	SCHEDULE_OFFERING	VOICE_WEB_AVAILABLE_IND	NA

Ver: 8.1