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	SCHEDULE_OFFERING GOVERNMENT_COURSE	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	CAMPUS	NA
SSBSECT_CENSUS_2_DATE	SSASECT	REPORTING VIEW	GOVERNMENT_COURSE GOVERNMENT_COURSE SCHEDULE_OFFERING	CENSUS_ENROLLMENT_DATE2 REGISTER_CENSUS_DATE2_IND CENSUS_ENROLLMENT_DATE2	NA
SSBSECT_CENSUS_2_ENRL	SSASECT	REPORTING VIEW	PROJECTED_SEATS_NEEDED SCHEDULE_OFFERING GOVERNMENT_COURSE	CENSUS_ENROLLMENT2 CENSUS_ENROLLMENT2 CENSUS_ENROLLMENT2	NA
SSBSECT_CENSUS_ENRL	SSASECT	REPORTING VIEW	PROJECTED_SEATS_NEEDED GOVERNMENT_COURSE GOVERNMENT_COURSE SCHEDULE_OFFERING	CENSUS_ENROLLMENT1 CENSUS_ENROLLMENT1 REGISTER_CENSUS_DATE1_IND 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	MIN_CONTACT_HOURS MAX_CONTACT_HOURS	NA
SSBSECT_CREDIT_HRS	SSASECT	REPORTING VIEW	SCHEDULE_OFFERING SCHEDULE_OFFERING	MAX_CREDITS MIN_CREDITS	NA
SSBSECT_CRN	SSASECT	REPORTING VIEW	SCHEDULE_OFFERING OFFERING_GRADE_TYPE	COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER	NA
SSBSECT_CRSE_NUMB	SSASECT	REPORTING VIEW	FACULTY_FEEDBACK OFFERING_COREQ OFFERING_GRADE_TYPE OFFERING_COREQ BLOCK_REGISTRATION_COURSE STUDENT_COURSE OFFERING_PREREQ SCHEDULE_OFFERING FACULTY_FEEDBACK_DETAIL STUDENT_COURSE_REG_AUDIT COURSE_LEVEL_SLOT MEETING_TIME	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	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 DURATION_UNITS	NA
SSBSECT_ENRL	SSASECT	REPORTING VIEW	GOVERNMENT_COURSE GOVERNMENT_COURSE PROJECTED_SEATS_NEEDED SCHEDULE_OFFERING	ACTUAL_ENROLLMENT SEATS_AVAILABLE ACTUAL_ENROLLMENT 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	STUDENT_COURSE SCHEDULE_OFFERING	GRADABLE_IND GRADABLE_IND	NA
SSBSECT_INSM_CODE	SSASECT	REPORTING VIEW	GOVERNMENT_COURSE SCHEDULE_OFFERING MEETING_TIME	INSTRUCTION_METHOD INSTRUCTION_METHOD INSTRUCTION_DELIVERY_MODE	NA
SSBSECT_INTG_CDE	SSASECT	REPORTING VIEW	STUDENT_COURSE GOVERNMENT_COURSE SCHEDULE_OFFERING	INTEGRATION_PARTNER INTEGRATION_PARTNER INTEGRATION_PARTNER
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	MIN_LECTURE_HOURS MAX_LECTURE_HOURS	NA
SSBSECT_LINK_IDENT	SSASECT	REPORTING VIEW	SCHEDULE_OFFERING	LINK_IDENTIFIER	NA
SSBSECT_MAX_ENRL	SSASECT	REPORTING VIEW	PROJECTED_SEATS_NEEDED GOVERNMENT_COURSE SCHEDULE_OFFERING	MAXIMUM_ENROLLMENT 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 PROJECTED_SEATS_NEEDED	PRIOR_ENROLLMENT PRIOR_ENROLLMENT	NA
SSBSECT_PROJ_ENRL	SSASECT	REPORTING VIEW	PROJECTED_SEATS_NEEDED SCHEDULE_OFFERING	TARGET_ENROLLMENT TARGET_ENROLLMENT	NA
SSBSECT_PTRM_CODE	SSASECT	REPORTING VIEW	OFFERING_GRADE_TYPE OFFERING_PREREQ BLOCK_REGISTRATION_COURSE MEETING_TIME PROJECTED_SEATS_NEEDED INSTRUCTIONAL_ASSIGNMENT OFFERING_COREQ SCHEDULE_OFFERING REGISTRATION_PLAN_COURSE	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	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	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	MEETING_TIME FACULTY_FEEDBACK FACULTY_FEEDBACK_DETAIL STUDENT_COURSE SCHEDULE_OFFERING GOVERNMENT_COURSE STUDENT_COURSE_REG_AUDIT	SECTION COURSE_SECTION_NUMBER COURSE_SECTION_NUMBER COURSE_SECTION_NUMBER OFFERING_NUMBER 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	FACULTY_FEEDBACK_DETAIL OFFERING_GRADE_TYPE STUDENT_COURSE_REG_AUDIT FACULTY_FEEDBACK BLOCK_REGISTRATION_COURSE COURSE_LEVEL_SLOT OFFERING_GRADE_TYPE MEETING_TIME OFFERING_COREQ OFFERING_COREQ SCHEDULE_OFFERING STUDENT_COURSE OFFERING_PREREQ	SUBJECT SUBJECT SUBJECT SUBJECT SUBJECT SUBJECT COURSE_IDENTIFICATION SUBJECT SUBJECT COREQ_SUBJECT SUBJECT SUBJECT SUBJECT	NA
SSBSECT_SUBJ_CODE\|\|SSBSECT_CRSE_NUMB	SSASECT				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: 9.0