Composite View Source: SSBSECT

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: SSBSECT Student

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
SSBSECT_ACCT_CODE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	ACCOUNTING_METHOD	NA
SSBSECT_BILL_HRS	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_COURSE_OFFERING	MAX_BILLING MIN_BILLING	NA
SSBSECT_CAMP_CODE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_STUDENT_COURSE_IN_PROGRESS	CAMPUS COURSE_CAMPUS	NA
SSBSECT_CENSUS_2_DATE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	CENSUS_ENROLLMENT_DATE2	NA
SSBSECT_CENSUS_2_ENRL	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	CENSUS_ENROLLMENT2	NA
SSBSECT_CENSUS_ENRL	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	CENSUS_ENROLLMENT1	NA
SSBSECT_CENSUS_ENRL_DATE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	CENSUS_ENROLLMENT_DATE1	NA
SSBSECT_CONT_HR	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_COURSE_OFFERING	MAX_CONTACT_HOURS MIN_CONTACT_HOURS	NA
SSBSECT_CREDIT_HRS	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_COURSE_OFFERING	MAX_CREDITS MIN_CREDITS	NA
SSBSECT_CRN	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_OFFERING_GRADE_TYPE	COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER	NA
SSBSECT_CRSE_NUMB	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_MEETING_TIME AS_OFFERING_COREQ AS_OFFERING_COREQ AS_OFFERING_GRADE_TYPE AS_OFFERING_PREREQ AS_STUDENT_COURSE_IN_PROGRESS	COURSE_NUMBER COURSE_NUMBER COREQ_COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER	NA
SSBSECT_CRSE_TITLE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_MEETING_TIME	TITLE_SHORT_DESC TITLE_SHORT_DESC	NA
SSBSECT_DUNT_CODE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_COURSE_OFFERING	DURATION DURATION_UNITS	NA
SSBSECT_ENRL	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	ACTUAL_ENROLLMENT	NA
SSBSECT_GMOD_CODE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_OFFERING_GRADE_TYPE	GRADE_TYPE GRADE_TYPE	NA
SSBSECT_GRADABLE_IND	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS	GRADABLE_IND GRADABLE_IND GRADABLE_IND	NA
SSBSECT_INSM_CODE	SSASECT	COMPOSITE VIEW	AS_MEETING_TIME AS_STUDENT_COURSE_IN_PROGRESS	INSTRUCTION_DELIVERY_MODE INSTRUCTION_METHOD	NA
SSBSECT_LAB_HR	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_COURSE_OFFERING	MAX_LAB_HOURS MIN_LAB_HOURS	NA
SSBSECT_LEC_HR	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_COURSE_OFFERING	MAX_LECTURE_HOURS MIN_LECTURE_HOURS	NA
SSBSECT_LINK_IDENT	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	LINK_IDENTIFIER	NA
SSBSECT_MAX_ENRL	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	MAXIMUM_ENROLLMENT	NA
SSBSECT_NUMBER_OF_EXTENSIONS	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	EXTENSIONS_PERMITTED	NA
SSBSECT_OTH_HR	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_COURSE_OFFERING	MAX_OTHER_HOURS MIN_OTHER_HOURS	NA
SSBSECT_PRIOR_ENRL	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	PRIOR_ENROLLMENT	NA
SSBSECT_PROJ_ENRL	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	TARGET_ENROLLMENT	NA
SSBSECT_PTRM_CODE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_COURSE_OFFERING AS_MEETING_TIME AS_OFFERING_COREQ AS_OFFERING_GRADE_TYPE AS_OFFERING_PREREQ	PART_OF_TERM SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD	NA
SSBSECT_PTRM_END_DATE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_COURSE_OFFERING	END_DATE PART_OF_TERM_END_DATE	NA
SSBSECT_PTRM_START_DATE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_COURSE_OFFERING	PART_OF_TERM_START_DATE START_DATE	NA
SSBSECT_PTRM_WEEKS	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	ACADEMIC_PERIOD_WEEKS	NA
SSBSECT_REG_FROM_DATE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	REGISTRATION_START_DATE	NA
SSBSECT_REG_TO_DATE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	REGISTRATION_END_DATE	NA
SSBSECT_SAPR_CODE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	SPECIAL_APPROVAL	NA
SSBSECT_SCHD_CODE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_STUDENT_COURSE_IN_PROGRESS	SCHEDULE SCHEDULE_TYPE	NA
SSBSECT_SEATS_AVAIL	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	SEATS_AVAILABLE	NA
SSBSECT_SEQ_NUMB	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_MEETING_TIME AS_STUDENT_COURSE_IN_PROGRESS	OFFERING_NUMBER SECTION COURSE_SECTION_NUMBER	NA
SSBSECT_SESS_CODE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	STUDENT_MEETING_TIME	NA
SSBSECT_SSTS_CODE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	STATUS	NA
SSBSECT_SUBJ_CODE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_MEETING_TIME AS_OFFERING_COREQ AS_OFFERING_COREQ AS_OFFERING_GRADE_TYPE AS_OFFERING_PREREQ AS_STUDENT_COURSE_IN_PROGRESS	SUBJECT SUBJECT COREQ_SUBJECT SUBJECT SUBJECT SUBJECT SUBJECT	NA
SSBSECT_SUBJ_CODE\|\|SSBSECT_CRSE_NUMB	SSASECT				Subject and course number concatenated together.
SSBSECT_TERM_CODE	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING AS_OFFERING_GRADE_TYPE AS_VALIDATION	ACADEMIC_PERIOD ACADEMIC_PERIOD QUALIFIER	NA
SSBSECT_TITLE	SSASECT				NA
SSBSECT_TOT_CREDIT_HRS	SSASECT				NA
SSBSECT_TUIW_IND	SSASECT	COMPOSITE VIEW	AS_COURSE_OFFERING	EXEMPT_TUITION_SECTION	NA
SSBSECT_VOICE_AVAIL	SSASECT				NA

Ver: 8.1