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

Source Column Source Form Local Source Target Type Target Target Column Local Target Calculation Formula
SSBSECT_ACCT_CODE SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

ACCOUNTING_METHOD

NO

NA
SSBSECT_BILL_HRS SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

AS_COURSE_OFFERING

MAX_BILLING

MIN_BILLING

NO

NO

NA
SSBSECT_CAMP_CODE SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

AS_STUDENT_COURSE_IN_PROGRESS

CAMPUS

COURSE_CAMPUS

NO

NO

NA
SSBSECT_CENSUS_2_DATE SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

CENSUS_ENROLLMENT_DATE2

NO

NA
SSBSECT_CENSUS_2_ENRL SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

CENSUS_ENROLLMENT2

NO

NA
SSBSECT_CENSUS_ENRL SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

CENSUS_ENROLLMENT1

NO

NA
SSBSECT_CENSUS_ENRL_DATE SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

CENSUS_ENROLLMENT_DATE1

NO

NA
SSBSECT_CONT_HR SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

AS_COURSE_OFFERING

MAX_CONTACT_HOURS

MIN_CONTACT_HOURS

NO

NO

NA
SSBSECT_CREDIT_HRS SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

AS_COURSE_OFFERING

MAX_CREDITS

MIN_CREDITS

NO

NO

NA
SSBSECT_CRN SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

AS_OFFERING_GRADE_TYPE

COURSE_REFERENCE_NUMBER

COURSE_REFERENCE_NUMBER

NO

NO

NA
SSBSECT_CRSE_NUMB SSASECT NO COMPOSITE VIEW

AS_OFFERING_COREQ

AS_MEETING_TIME

AS_OFFERING_GRADE_TYPE

AS_STUDENT_COURSE_IN_PROGRESS

AS_FACULTY_FEEDBACK

AS_COURSE_OFFERING

AS_OFFERING_COREQ

AS_OFFERING_PREREQ

COREQ_COURSE_NUMBER

COURSE_NUMBER

COURSE_NUMBER

COURSE_NUMBER

COURSE_NUMBER

COURSE_NUMBER

COURSE_NUMBER

COURSE_NUMBER

NO

NO

NO

NO

NO

NO

NO

NO

NA
SSBSECT_CRSE_TITLE SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

AS_MEETING_TIME

TITLE_SHORT_DESC

TITLE_SHORT_DESC

NO

NO

NA
SSBSECT_DUNT_CODE SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

AS_COURSE_OFFERING

DURATION_UNITS

DURATION

NO

NO

NA
SSBSECT_ENRL SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

ACTUAL_ENROLLMENT

NO

NA
SSBSECT_GMOD_CODE SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

AS_OFFERING_GRADE_TYPE

GRADE_TYPE

GRADE_TYPE

NO

NO

NA
SSBSECT_GRADABLE_IND SSASECT NO COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

AS_COURSE_OFFERING

AS_STUDENT_COURSE_HISTORY

GRADABLE_IND

GRADABLE_IND

GRADABLE_IND

NO

NO

NO

NA
SSBSECT_INSM_CODE SSASECT NO COMPOSITE VIEW

AS_MEETING_TIME

AS_COURSE_OFFERING

AS_STUDENT_COURSE_IN_PROGRESS

INSTRUCTION_DELIVERY_MODE

INSTRUCTION_METHOD

INSTRUCTION_METHOD

NO

NO

NO

NA
SSBSECT_INTG_CDE SSASECT NO COMPOSITE VIEW

AS_STUDENT_COURSE_HISTORY

AS_COURSE_OFFERING

AS_STUDENT_COURSE_IN_PROGRESS

AS_STUDENT_COURSE_TRANSFER

INTEGRATION_PARTNER

INTEGRATION_PARTNER

INTEGRATION_PARTNER

INTEGRATION_PARTNER

NO

NO

NO

NO

 
SSBSECT_LAB_HR SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

AS_COURSE_OFFERING

MAX_LAB_HOURS

MIN_LAB_HOURS

NO

NO

NA
SSBSECT_LEC_HR SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

AS_COURSE_OFFERING

MAX_LECTURE_HOURS

MIN_LECTURE_HOURS

NO

NO

NA
SSBSECT_LINK_IDENT SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

LINK_IDENTIFIER

NO

NA
SSBSECT_MAX_ENRL SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

MAXIMUM_ENROLLMENT

NO

NA
SSBSECT_NUMBER_OF_EXTENSIONS SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

EXTENSIONS_PERMITTED

NO

NA
SSBSECT_OTH_HR SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

AS_COURSE_OFFERING

MAX_OTHER_HOURS

MIN_OTHER_HOURS

NO

NO

NA
SSBSECT_PRIOR_ENRL SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

PRIOR_ENROLLMENT

NO

NA
SSBSECT_PRNT_IND SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

SCHEDULE_PRINT_IND

NO

NA
SSBSECT_PROJ_ENRL SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

TARGET_ENROLLMENT

NO

NA
SSBSECT_PTRM_CODE SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

AS_MEETING_TIME

AS_OFFERING_COREQ

AS_OFFERING_GRADE_TYPE

AS_OFFERING_PREREQ

AS_COURSE_OFFERING

PART_OF_TERM

SUB_ACADEMIC_PERIOD

SUB_ACADEMIC_PERIOD

SUB_ACADEMIC_PERIOD

SUB_ACADEMIC_PERIOD

SUB_ACADEMIC_PERIOD

NO

NO

NO

NO

NO

NO

NA
SSBSECT_PTRM_END_DATE SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

AS_COURSE_OFFERING

END_DATE

PART_OF_TERM_END_DATE

NO

NO

NA
SSBSECT_PTRM_START_DATE SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

AS_COURSE_OFFERING

PART_OF_TERM_START_DATE

START_DATE

NO

NO

NA
SSBSECT_PTRM_WEEKS SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

ACADEMIC_PERIOD_WEEKS

NO

NA
SSBSECT_REG_FROM_DATE SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

REGISTRATION_START_DATE

NO

NA
SSBSECT_REG_TO_DATE SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

REGISTRATION_END_DATE

NO

NA
SSBSECT_RESERVED_IND SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

RESERVED_IND

NO

NA
SSBSECT_SAPR_CODE SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

SPECIAL_APPROVAL

NO

NA
SSBSECT_SCHD_CODE SSASECT NO COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

AS_COURSE_OFFERING

SCHEDULE_TYPE

SCHEDULE

NO

NO

NA
SSBSECT_SEATS_AVAIL SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

SEATS_AVAILABLE

NO

NA
SSBSECT_SEQ_NUMB SSASECT NO COMPOSITE VIEW

AS_FACULTY_FEEDBACK

AS_STUDENT_COURSE_IN_PROGRESS

AS_COURSE_OFFERING

AS_MEETING_TIME

COURSE_SECTION_NUMBER

COURSE_SECTION_NUMBER

OFFERING_NUMBER

SECTION

NO

NO

NO

NO

NA
SSBSECT_SESS_CODE SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

STUDENT_MEETING_TIME

NO

NA
SSBSECT_SSTS_CODE SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

STATUS

NO

NA
SSBSECT_SUBJ_CODE SSASECT NO COMPOSITE VIEW

AS_OFFERING_COREQ

AS_OFFERING_PREREQ

AS_COURSE_OFFERING

AS_OFFERING_COREQ

AS_STUDENT_COURSE_IN_PROGRESS

AS_FACULTY_FEEDBACK

AS_MEETING_TIME

AS_OFFERING_GRADE_TYPE

COREQ_SUBJECT

SUBJECT

SUBJECT

SUBJECT

SUBJECT

SUBJECT

SUBJECT

SUBJECT

NO

NO

NO

NO

NO

NO

NO

NO

NA
SSBSECT_TERM_CODE SSASECT NO COMPOSITE VIEW

AS_OFFERING_GRADE_TYPE

AS_VALIDATION

AS_COURSE_OFFERING

ACADEMIC_PERIOD

QUALIFIER

ACADEMIC_PERIOD

NO

NO

NO

NA
SSBSECT_TITLE SSASECT NO         NA
SSBSECT_TOT_CREDIT_HRS SSASECT NO         NA
SSBSECT_TUIW_IND SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

EXEMPT_TUITION_SECTION

NO

NA
SSBSECT_VOICE_AVAIL SSASECT NO         NA
SSBSECT_WAIT_AVAIL SSASECT NO COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

AS_COURSE_OFFERING

AS_STUDENT_COURSE_HISTORY

WAITLIST_AVAILABLE

WAIT_AVAILABLE

WAITLIST_AVAILABLE

NO

NO

NO

NA
SSBSECT_WAIT_CAPACITY SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

AS_STUDENT_COURSE_IN_PROGRESS

AS_STUDENT_COURSE_HISTORY

WAIT_CAPACITY

WAITLIST_CAPACITY

WAITLIST_CAPACITY

NO

NO

NO

NA
SSBSECT_WAIT_COUNT SSASECT NO COMPOSITE VIEW

AS_COURSE_OFFERING

AS_STUDENT_COURSE_HISTORY

AS_STUDENT_COURSE_IN_PROGRESS

WAIT_COUNT

WAITLIST_COUNT

WAITLIST_COUNT

NO

NO

NO

NA


Ver: