Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: SSBSECT Student
SGHE Banner Operational Data Store Composite View Source: SSBSECT - NULL

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

MIN_BILLING

MAX_BILLING

NA
SSBSECT_CAMP_CODE SSASECT COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

AS_COURSE_OFFERING

COURSE_CAMPUS

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

MIN_CONTACT_HOURS

MAX_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_OFFERING_GRADE_TYPE

AS_COURSE_OFFERING

COURSE_REFERENCE_NUMBER

COURSE_REFERENCE_NUMBER

NA
SSBSECT_CRSE_NUMB SSASECT COMPOSITE VIEW

AS_MEETING_TIME

AS_OFFERING_COREQ

AS_STUDENT_COURSE_IN_PROGRESS

AS_OFFERING_GRADE_TYPE

AS_COURSE_OFFERING

AS_OFFERING_COREQ

AS_OFFERING_PREREQ

COURSE_NUMBER

COURSE_NUMBER

COURSE_NUMBER

COURSE_NUMBER

COURSE_NUMBER

COREQ_COURSE_NUMBER

COURSE_NUMBER

NA
SSBSECT_CRSE_TITLE SSASECT COMPOSITE VIEW

AS_MEETING_TIME

AS_COURSE_OFFERING

TITLE_SHORT_DESC

TITLE_SHORT_DESC

NA
SSBSECT_DUNT_CODE SSASECT COMPOSITE VIEW

AS_COURSE_OFFERING

AS_COURSE_OFFERING

DURATION_UNITS

DURATION

NA
SSBSECT_ENRL SSASECT COMPOSITE VIEW

AS_COURSE_OFFERING

ACTUAL_ENROLLMENT

NA
SSBSECT_GMOD_CODE SSASECT COMPOSITE VIEW

AS_OFFERING_GRADE_TYPE

AS_COURSE_OFFERING

GRADE_TYPE

GRADE_TYPE

NA
SSBSECT_GRADABLE_IND SSASECT COMPOSITE VIEW

AS_STUDENT_COURSE_HISTORY

AS_COURSE_OFFERING

AS_STUDENT_COURSE_IN_PROGRESS

GRADABLE_IND

GRADABLE_IND

GRADABLE_IND

NA
SSBSECT_INSM_CODE SSASECT COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

AS_MEETING_TIME

INSTRUCTION_METHOD

INSTRUCTION_DELIVERY_MODE

NA
SSBSECT_LAB_HR SSASECT COMPOSITE VIEW

AS_COURSE_OFFERING

AS_COURSE_OFFERING

MIN_LAB_HOURS

MAX_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

MIN_OTHER_HOURS

MAX_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_OFFERING_GRADE_TYPE

AS_MEETING_TIME

AS_COURSE_OFFERING

AS_OFFERING_COREQ

AS_COURSE_OFFERING

AS_OFFERING_PREREQ

SUB_ACADEMIC_PERIOD

SUB_ACADEMIC_PERIOD

PART_OF_TERM

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_STUDENT_COURSE_IN_PROGRESS

AS_COURSE_OFFERING

SCHEDULE_TYPE

SCHEDULE

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_OFFERING_COREQ

AS_OFFERING_GRADE_TYPE

AS_MEETING_TIME

AS_STUDENT_COURSE_IN_PROGRESS

AS_OFFERING_COREQ

AS_OFFERING_PREREQ

AS_COURSE_OFFERING

COREQ_SUBJECT

SUBJECT

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_OFFERING_GRADE_TYPE

AS_VALIDATION

AS_COURSE_OFFERING

ACADEMIC_PERIOD

QUALIFIER

ACADEMIC_PERIOD

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.0