SSBACRL SSBDESC SSBDFEE SSBFSEC SSBOVRR SSBSECT SSBSSEC SSBXLST SSRATTR SSRBLCK SSRCORQ SSRCTRL SSREVAL SSREXCL SSREXTN SSRFEES SSRLINK SSRMEET SSRMPRT SSRMRDF SSRRARE SSRRCLS SSRRCMP SSRRCOL SSRRDEG SSRRESV SSRRFND SSRRLVL SSRRMAJ SSRRPRG SSRRSTS SSRRTST SSRSCCD SSRSPRT SSRSRDF SSRSYLN SSRSYLO SSRSYRM SSRSYTR SSRTEXT SSRXLST SSTSCHW

Model Schedule


Model Label : ERD For Banner Student Schedule Module ( SS% Tables)
Path : BANNER DEV/Student/Schedule/Schedule

List of Objects

Object Name Object Type Layer Name
SSBACRL TABLE Default
SSBDESC TABLE Default
SSBDFEE TABLE Default
SSBFSEC TABLE Default
SSBOVRR TABLE Default
SSBSECT TABLE Default
SSBSSEC TABLE Default
SSBXLST TABLE Default
SSRATTR TABLE Default
SSRBLCK TABLE Default
SSRCORQ TABLE Default
SSRCTRL TABLE Default
SSREVAL TABLE Default
SSREXCL TABLE Default
SSREXTN TABLE Default
SSRFEES TABLE Default
SSRLINK TABLE Default
SSRMEET TABLE Default
SSRMPRT TABLE Default
SSRMRDF TABLE Default
SSRRARE TABLE Default
SSRRCLS TABLE Default
SSRRCMP TABLE Default
SSRRCOL TABLE Default
SSRRDEG TABLE Default
SSRRESV TABLE Default
SSRRFND TABLE Default
SSRRLVL TABLE Default
SSRRMAJ TABLE Default
SSRRPRG TABLE Default
SSRRSTS TABLE Default
SSRRTST TABLE Default
SSRSCCD TABLE Default
SSRSPRT TABLE Default
SSRSRDF TABLE Default
SSRSYLN TABLE Default
SSRSYLO TABLE Default
SSRSYRM TABLE Default
SSRSYTR TABLE Default
SSRTEXT TABLE Default
SSRXLST TABLE Default
SSTSCHW TABLE Default

Comments

Model View

''

Table SSBACRL

Schema Name SATURN
Label SSBACRL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:39:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SSBACRL_TERM_CODE SSBACRL_TERM_CODE VARCHAR2(6) No * *
SSBACRL_ACCL_CODE SSBACRL_ACCL_CODE VARCHAR2(2) No * *
SSBACRL_DAYS_TO_CENSUS_1 SSBACRL_DAYS_TO_CENSUS_1 NUMBER(3,0) Yes
SSBACRL_PERCENT_TO_CENSUS_1 SSBACRL_PERCENT_TO_CENSUS_1 NUMBER(5,2) Yes
SSBACRL_CENSUS_1_DATE SSBACRL_CENSUS_1_DATE DATE Yes
SSBACRL_DAYS_TO_CENSUS_2 SSBACRL_DAYS_TO_CENSUS_2 NUMBER(3,0) Yes
SSBACRL_PERCENT_TO_CENSUS_2 SSBACRL_PERCENT_TO_CENSUS_2 NUMBER(5,2) Yes
SSBACRL_CENSUS_2_DATE SSBACRL_CENSUS_2_DATE DATE Yes
SSBACRL_DAYS_TO_ENRL SSBACRL_DAYS_TO_ENRL NUMBER(3,0) Yes
SSBACRL_PERCENT_TO_ENRL SSBACRL_PERCENT_TO_ENRL NUMBER(5,2) Yes
SSBACRL_ENRL_CUT_OFF_DATE SSBACRL_ENRL_CUT_OFF_DATE DATE Yes
SSBACRL_DAYS_TO_ACAD SSBACRL_DAYS_TO_ACAD NUMBER(3,0) Yes
SSBACRL_PERCENT_TO_ACAD SSBACRL_PERCENT_TO_ACAD NUMBER(5,2) Yes
SSBACRL_ACAD_CUT_OFF_DATE SSBACRL_ACAD_CUT_OFF_DATE DATE Yes
SSBACRL_DAYS_TO_DROP SSBACRL_DAYS_TO_DROP NUMBER(3,0) Yes
SSBACRL_PERCENT_TO_DROP SSBACRL_PERCENT_TO_DROP NUMBER(5,2) Yes
SSBACRL_DROP_CUT_OFF_DATE SSBACRL_DROP_CUT_OFF_DATE DATE Yes
SSBACRL_ACTIVITY_DATE SSBACRL_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SSBACRL_ACCL_CODE STVACCL_CODE STVACCL
SSBACRL_TERM_CODE STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SSBACRL Unique SSBACRL_TERM_CODE
PK_SSBACRL Unique SSBACRL_ACCL_CODE

Comments

Source Code Comments

Census Information Base Table

Columns Comments for SSBACRL_TERM_CODE (1)

Source Code Comments

Term Code for Academic Rule

Columns Comments for SSBACRL_ACCL_CODE (2)

Source Code Comments

Academic calendar type

Columns Comments for SSBACRL_DAYS_TO_CENSUS_1 (3)

Source Code Comments

The number of days into the term for the academic calendar type when the first census date occurs

Columns Comments for SSBACRL_PERCENT_TO_CENSUS_1 (4)

Source Code Comments

The percentage of days into the term for the academic calendar type when the first census date occurs

Columns Comments for SSBACRL_CENSUS_1_DATE (5)

Source Code Comments

The census one date for the term and academic calendar year

Columns Comments for SSBACRL_DAYS_TO_CENSUS_2 (6)

Source Code Comments

The number of days into the term for the academic calendar type when the second census date occurs

Columns Comments for SSBACRL_PERCENT_TO_CENSUS_2 (7)

Source Code Comments

The percentage of days into the term for the academic calendar type when the second census date occurs

Columns Comments for SSBACRL_CENSUS_2_DATE (8)

Source Code Comments

The census two date for the term and academic calendar year

Columns Comments for SSBACRL_DAYS_TO_ENRL (9)

Source Code Comments

The number of days into the term for the academic calendar type and registration status for which the student may enroll

Columns Comments for SSBACRL_PERCENT_TO_ENRL (10)

Source Code Comments

The percentage of days into the term for the academic calendar type and registration status for which the student may enroll

Columns Comments for SSBACRL_ENRL_CUT_OFF_DATE (11)

Source Code Comments

The last date on which students may enroll for the academic calendar type and registration status

Columns Comments for SSBACRL_DAYS_TO_ACAD (12)

Source Code Comments

The number of days into the term for the academic calendar type and registration status for which the course will not be recorded in academic history

Columns Comments for SSBACRL_PERCENT_TO_ACAD (13)

Source Code Comments

The percentage of days into the term for the academic calendar type and registration status for which the course will not be recorded in academic history

Columns Comments for SSBACRL_ACAD_CUT_OFF_DATE (14)

Source Code Comments

The last date when student may process a course without it appearing on their academic history information

Columns Comments for SSBACRL_DAYS_TO_DROP (15)

Source Code Comments

The number of days into the term for the academic calendar type and registration status for which the course may be dropped without assessing a penalty

Columns Comments for SSBACRL_PERCENT_TO_DROP (16)

Source Code Comments

The percentage of days into the term for the academic calendar type and registration status for which the course may be dropped without assessing a penalty

Columns Comments for SSBACRL_DROP_CUT_OFF_DATE (17)

Source Code Comments

The last date on which students may drop a course without assessing a penalty

Columns Comments for SSBACRL_ACTIVITY_DATE (18)

Source Code Comments

The activity date

Table SSBDESC

Schema Name SATURN
Label SSBDESC
Server name MALDEV8_B60
Creation Date 02/07/2003 10:08:55:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SSBDESC_TERM_CODE SSBDESC_TERM_CODE VARCHAR2(6) No * *
SSBDESC_CRN SSBDESC_CRN VARCHAR2(5) No *
SSBDESC_TEXT_NARRATIVE SSBDESC_TEXT_NARRATIVE CLOB No
SSBDESC_ACTIVITY_DATE SSBDESC_ACTIVITY_DATE DATE No
SSBDESC_USER_ID SSBDESC_USER_ID VARCHAR2(30) No

Foreign Key information

Column name is Foreign Key For Column on Table
SSBDESC_TERM_CODE STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SSBDESC Unique SSBDESC_TERM_CODE
PK_SSBDESC Unique SSBDESC_CRN

Comments

Source Code Comments

Section Description Table

Columns Comments for SSBDESC_TERM_CODE (1)

Source Code Comments

Term Code. This field identifies the term for which you are creating descriptive text for a course section.

Columns Comments for SSBDESC_CRN (2)

Source Code Comments

CRN. This field identifies the course Reference Number for which you are creating descriptive text.

Columns Comments for SSBDESC_TEXT_NARRATIVE (3)

Source Code Comments

Course section descriptive text is maintained here.

Columns Comments for SSBDESC_ACTIVITY_DATE (4)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the SSBDESC table.

Columns Comments for SSBDESC_USER_ID (5)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user who changed the record.

Table SSBDFEE

Schema Name SATURN
Label SSBDFEE
Server name MALDEV8_B60
Creation Date 02/06/2003 12:14:01:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SSBDFEE_TERM_CODE SSBDFEE_TERM_CODE VARCHAR2(6) No *
SSBDFEE_SCHD_CODE SSBDFEE_SCHD_CODE VARCHAR2(3) No *
SSBDFEE_LEVL_CODE SSBDFEE_LEVL_CODE VARCHAR2(2) No *
SSBDFEE_DETL_CODE SSBDFEE_DETL_CODE VARCHAR2(4) No *
SSBDFEE_FEE_IND SSBDFEE_FEE_IND VARCHAR2(1) Yes
SSBDFEE_AMOUNT SSBDFEE_AMOUNT NUMBER(12,2) No
SSBDFEE_ACTIVITY_DATE SSBDFEE_ACTIVITY_DATE DATE No
SSBDFEE_DEPT_CODE SSBDFEE_DEPT_CODE VARCHAR2(4) Yes *
SSBDFEE_COLL_CODE SSBDFEE_COLL_CODE VARCHAR2(2) Yes *
SSBDFEE_CAMP_CODE SSBDFEE_CAMP_CODE VARCHAR2(3) Yes *
SSBDFEE_INSM_CODE SSBDFEE_INSM_CODE VARCHAR2(5) Yes *
SSBDFEE_FTYP_CODE SSBDFEE_FTYP_CODE VARCHAR2(4) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
SSBDFEE_INSM_CODE GTVINSM_CODE GTVINSM
SSBDFEE_SCHD_CODE STVSCHD_CODE STVSCHD
SSBDFEE_FTYP_CODE STVFTYP_CODE STVFTYP
SSBDFEE_COLL_CODE STVCOLL_CODE STVCOLL
SSBDFEE_DEPT_CODE STVDEPT_CODE STVDEPT
SSBDFEE_CAMP_CODE STVCAMP_CODE STVCAMP
SSBDFEE_LEVL_CODE STVLEVL_CODE STVLEVL
SSBDFEE_TERM_CODE STVTERM_CODE STVTERM
SSBDFEE_DETL_CODE TBBDETC_DETAIL_CODE TBBDETC

Index

Index Name Index Type Column Name
UK_SSBDFEE Unique SSBDFEE_TERM_CODE
UK_SSBDFEE Unique SSBDFEE_SCHD_CODE
UK_SSBDFEE Unique SSBDFEE_LEVL_CODE
UK_SSBDFEE Unique SSBDFEE_DETL_CODE
UK_SSBDFEE Unique SSBDFEE_INSM_CODE
UK_SSBDFEE Unique SSBDFEE_COLL_CODE
UK_SSBDFEE Unique SSBDFEE_DEPT_CODE
UK_SSBDFEE Unique SSBDFEE_CAMP_CODE

Comments

Source Code Comments

Tuition Fee Assessment by Status

Columns Comments for SSBDFEE_TERM_CODE (1)

Source Code Comments

This field defines the term for which you are creating the course section fee.

Columns Comments for SSBDFEE_SCHD_CODE (2)

Source Code Comments

This field defines the schedule type for which you are creating the course section fee.

Columns Comments for SSBDFEE_LEVL_CODE (3)

Source Code Comments

This field defines the level for which you are creating the course section fee.

Columns Comments for SSBDFEE_DETL_CODE (4)

Source Code Comments

This field defines the detail code of the specific fee you are creating for the course section.

Columns Comments for SSBDFEE_FEE_IND (5)

Source Code Comments

This field is used to specify whether the course fee will be assessed on a per-credit hour basis (C) or on a flat basis (F). "C" and "F" are the only valid values.

Columns Comments for SSBDFEE_AMOUNT (6)

Source Code Comments

This field defines the amount of the fee you are creating for the course section.

Columns Comments for SSBDFEE_ACTIVITY_DATE (7)

Source Code Comments

This field contains the most current date the record was added or changed.

Columns Comments for SSBDFEE_DEPT_CODE (8)

Source Code Comments

Department code: this field identifies the optional department code assigned to the default fee rule.

Columns Comments for SSBDFEE_COLL_CODE (9)

Source Code Comments

College code: this field identifies the optional college code assigned to the default fee rule.

Columns Comments for SSBDFEE_CAMP_CODE (10)

Source Code Comments

Campus code: this field identifies the optional campus code assigned to the default fee rule.

Columns Comments for SSBDFEE_INSM_CODE (11)

Source Code Comments

Instructional method code: this field identifies the optional instructional method code assigned to the default fee rule.

Columns Comments for SSBDFEE_FTYP_CODE (12)

Source Code Comments

Fee Type code: this field is used to identify the type of fee to fee assessment.

Table SSBFSEC

Schema Name SATURN
Label SSBFSEC
Server name MALDEV8_B60
Creation Date 02/07/2003 10:08:59:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SSBFSEC_TERM_CODE SSBFSEC_TERM_CODE VARCHAR2(6) No * *
SSBFSEC_TERM_CODE SSBFSEC_TERM_CODE VARCHAR2(6) No * *
SSBFSEC_TERM_CODE SSBFSEC_TERM_CODE VARCHAR2(6) No * *
SSBFSEC_CRN SSBFSEC_CRN VARCHAR2(5) No * *
SSBFSEC_WAIT_LIST_DISP_IND SSBFSEC_WAIT_LIST_DISP_IND VARCHAR2(1) No
SSBFSEC_MID_GRD_DISP_IND SSBFSEC_MID_GRD_DISP_IND VARCHAR2(1) No
SSBFSEC_FIN_GRD_DISP_IND SSBFSEC_FIN_GRD_DISP_IND VARCHAR2(1) No
SSBFSEC_ACTIVITY_DATE SSBFSEC_ACTIVITY_DATE DATE No
SSBFSEC_USER_ID SSBFSEC_USER_ID VARCHAR2(30) No

Foreign Key information

Column name is Foreign Key For Column on Table
SSBFSEC_TERM_CODE STVTERM_CODE STVTERM
SSBFSEC_TERM_CODE SHRTTRM_TERM_CODE SHRTTRM
SSBFSEC_TERM_CODE SFRSTCR_TERM_CODE SFRSTCR
SSBFSEC_CRN SFRSTCR_CRN SFRSTCR

Index

Index Name Index Type Column Name
PK_SSBFSEC Unique SSBFSEC_TERM_CODE
PK_SSBFSEC Unique SSBFSEC_CRN

Comments

Source Code Comments

This table provides the capability to set faculty self-service display controls by term and section.

Columns Comments for SSBFSEC_TERM_CODE (1)

Source Code Comments

Term code: used to specify the term that the data is associated with.

Columns Comments for SSBFSEC_CRN (2)

Source Code Comments

Course Reference number: used to specify the section that the data is associated with.

Columns Comments for SSBFSEC_WAIT_LIST_DISP_IND (3)

Source Code Comments

Wait List display indicator: This column identifies whther or not wait lists will be displayed on the faculty self-service product.

Columns Comments for SSBFSEC_MID_GRD_DISP_IND (4)

Source Code Comments

Mid term grade code display indicator: The column identifies whether or not mid term grades will be displayed on the faculty self-service product.

Columns Comments for SSBFSEC_FIN_GRD_DISP_IND (5)

Source Code Comments

Final grade code display indicator: The column identifies whether or not final grade codes will be displayed on the faculty self-service product.

Columns Comments for SSBFSEC_ACTIVITY_DATE (6)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the SSBFSEC table.

Columns Comments for SSBFSEC_USER_ID (7)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user who changed the record.

Table SSBOVRR

Schema Name SATURN
Label SSBOVRR
Server name MALDEV8_B60
Creation Date 04/28/2003 16:17:58:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SSBOVRR_TERM_CODE SSBOVRR_TERM_CODE VARCHAR2(6) No * *
SSBOVRR_TERM_CODE SSBOVRR_TERM_CODE VARCHAR2(6) No * *
SSBOVRR_TERM_CODE SSBOVRR_TERM_CODE VARCHAR2(6) No * *
SSBOVRR_CRN SSBOVRR_CRN VARCHAR2(5) No * *
SSBOVRR_CRN SSBOVRR_CRN VARCHAR2(5) No * *
SSBOVRR_COLL_CODE SSBOVRR_COLL_CODE VARCHAR2(2) Yes *
SSBOVRR_TOPS_CODE SSBOVRR_TOPS_CODE VARCHAR2(6) Yes *
SSBOVRR_DIVS_CODE SSBOVRR_DIVS_CODE VARCHAR2(4) Yes *
SSBOVRR_DEPT_CODE SSBOVRR_DEPT_CODE VARCHAR2(4) Yes *
SSBOVRR_ACTIVITY_DATE SSBOVRR_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SSBOVRR_COLL_CODE STVCOLL_CODE STVCOLL
SSBOVRR_DEPT_CODE STVDEPT_CODE STVDEPT
SSBOVRR_DIVS_CODE STVDIVS_CODE STVDIVS
SSBOVRR_TOPS_CODE STVTOPS_CODE STVTOPS
SSBOVRR_TERM_CODE STVTERM_CODE STVTERM
SSBOVRR_TERM_CODE SSBSECT_TERM_CODE SSBSECT
SSBOVRR_CRN SSBSECT_CRN SSBSECT
SSBOVRR_TERM_CODE SFRAREG_TERM_CODE SFRAREG
SSBOVRR_CRN SFRAREG_CRN SFRAREG

Index

Index Name Index Type Column Name
PK_SSBOVRR Unique SSBOVRR_TERM_CODE
PK_SSBOVRR Unique SSBOVRR_CRN

Comments

Source Code Comments

Schedule Override Table

Columns Comments for SSBOVRR_TERM_CODE (1)

Source Code Comments

Schedule Override Term Code

Columns Comments for SSBOVRR_CRN (2)

Source Code Comments

Schedule Override Course Reference Number

Columns Comments for SSBOVRR_COLL_CODE (3)

Source Code Comments

Schedule Override College Code

Columns Comments for SSBOVRR_TOPS_CODE (4)

Source Code Comments

Schedule Override Taxonomy of Program Code

Columns Comments for SSBOVRR_DIVS_CODE (5)

Source Code Comments

Schedule Override Division Code

Columns Comments for SSBOVRR_DEPT_CODE (6)

Source Code Comments

Schedule Override Department Code

Columns Comments for SSBOVRR_ACTIVITY_DATE (7)

Source Code Comments

The Activity Date

Table SSBSECT

Schema Name SATURN
Label SSBSECT
Server name MALDEV8_B60
Creation Date 07/30/2003 16:04:05:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SSBSECT_TERM_CODE SSBSECT_TERM_CODE VARCHAR2(6) No * *
SSBSECT_TERM_CODE SSBSECT_TERM_CODE VARCHAR2(6) No * *
SSBSECT_TERM_CODE SSBSECT_TERM_CODE VARCHAR2(6) No * *
SSBSECT_TERM_CODE SSBSECT_TERM_CODE VARCHAR2(6) No * *
SSBSECT_TERM_CODE SSBSECT_TERM_CODE VARCHAR2(6) No * *
SSBSECT_TERM_CODE SSBSECT_TERM_CODE VARCHAR2(6) No * *
SSBSECT_TERM_CODE SSBSECT_TERM_CODE VARCHAR2(6) No * *
SSBSECT_CRN SSBSECT_CRN VARCHAR2(5) No * *
SSBSECT_CRN SSBSECT_CRN VARCHAR2(5) No * *
SSBSECT_CRN SSBSECT_CRN VARCHAR2(5) No * *
SSBSECT_CRN SSBSECT_CRN VARCHAR2(5) No * *
SSBSECT_PTRM_CODE SSBSECT_PTRM_CODE VARCHAR2(3) Yes *
SSBSECT_SUBJ_CODE SSBSECT_SUBJ_CODE VARCHAR2(4) No *
SSBSECT_SUBJ_CODE SSBSECT_SUBJ_CODE VARCHAR2(4) No *
SSBSECT_SUBJ_CODE SSBSECT_SUBJ_CODE VARCHAR2(4) No *
SSBSECT_SUBJ_CODE SSBSECT_SUBJ_CODE VARCHAR2(4) No *
SSBSECT_CRSE_NUMB SSBSECT_CRSE_NUMB VARCHAR2(5) No *
SSBSECT_CRSE_NUMB SSBSECT_CRSE_NUMB VARCHAR2(5) No *
SSBSECT_CRSE_NUMB SSBSECT_CRSE_NUMB VARCHAR2(5) No *
SSBSECT_SEQ_NUMB SSBSECT_SEQ_NUMB VARCHAR2(3) No
SSBSECT_SSTS_CODE SSBSECT_SSTS_CODE VARCHAR2(1) No *
SSBSECT_SCHD_CODE SSBSECT_SCHD_CODE VARCHAR2(3) No *
SSBSECT_CAMP_CODE SSBSECT_CAMP_CODE VARCHAR2(3) No *
SSBSECT_CRSE_TITLE SSBSECT_CRSE_TITLE VARCHAR2(30) Yes
SSBSECT_CREDIT_HRS SSBSECT_CREDIT_HRS NUMBER(7,3) Yes
SSBSECT_BILL_HRS SSBSECT_BILL_HRS NUMBER(7,3) Yes
SSBSECT_GMOD_CODE SSBSECT_GMOD_CODE VARCHAR2(1) Yes *
SSBSECT_SAPR_CODE SSBSECT_SAPR_CODE VARCHAR2(2) Yes *
SSBSECT_SESS_CODE SSBSECT_SESS_CODE VARCHAR2(1) Yes *
SSBSECT_LINK_IDENT SSBSECT_LINK_IDENT VARCHAR2(2) Yes
SSBSECT_PRNT_IND SSBSECT_PRNT_IND VARCHAR2(1) Yes
SSBSECT_GRADABLE_IND SSBSECT_GRADABLE_IND VARCHAR2(1) Yes
SSBSECT_TUIW_IND SSBSECT_TUIW_IND VARCHAR2(1) Yes
SSBSECT_REG_ONEUP SSBSECT_REG_ONEUP NUMBER(4,0) No
SSBSECT_PRIOR_ENRL SSBSECT_PRIOR_ENRL NUMBER(4,0) No
SSBSECT_PROJ_ENRL SSBSECT_PROJ_ENRL NUMBER(4,0) No
SSBSECT_MAX_ENRL SSBSECT_MAX_ENRL NUMBER(4,0) No
SSBSECT_ENRL SSBSECT_ENRL NUMBER(4,0) No
SSBSECT_SEATS_AVAIL SSBSECT_SEATS_AVAIL NUMBER(4,0) No
SSBSECT_TOT_CREDIT_HRS SSBSECT_TOT_CREDIT_HRS NUMBER(9,3) Yes
SSBSECT_CENSUS_ENRL SSBSECT_CENSUS_ENRL NUMBER(4,0) Yes
SSBSECT_CENSUS_ENRL_DATE SSBSECT_CENSUS_ENRL_DATE DATE No
SSBSECT_ACTIVITY_DATE SSBSECT_ACTIVITY_DATE DATE No
SSBSECT_PTRM_START_DATE SSBSECT_PTRM_START_DATE DATE Yes
SSBSECT_PTRM_END_DATE SSBSECT_PTRM_END_DATE DATE Yes
SSBSECT_PTRM_WEEKS SSBSECT_PTRM_WEEKS NUMBER(3,0) Yes
SSBSECT_RESERVED_IND SSBSECT_RESERVED_IND VARCHAR2(1) Yes
SSBSECT_WAIT_CAPACITY SSBSECT_WAIT_CAPACITY NUMBER(4,0) Yes
SSBSECT_WAIT_COUNT SSBSECT_WAIT_COUNT NUMBER(4,0) Yes
SSBSECT_WAIT_AVAIL SSBSECT_WAIT_AVAIL NUMBER(4,0) Yes
SSBSECT_LEC_HR SSBSECT_LEC_HR NUMBER(9,3) Yes
SSBSECT_LAB_HR SSBSECT_LAB_HR NUMBER(9,3) Yes
SSBSECT_OTH_HR SSBSECT_OTH_HR NUMBER(9,3) Yes
SSBSECT_CONT_HR SSBSECT_CONT_HR NUMBER(9,3) Yes
SSBSECT_ACCT_CODE SSBSECT_ACCT_CODE VARCHAR2(2) Yes *
SSBSECT_ACCL_CODE SSBSECT_ACCL_CODE VARCHAR2(2) Yes *
SSBSECT_CENSUS_2_DATE SSBSECT_CENSUS_2_DATE DATE Yes
SSBSECT_ENRL_CUT_OFF_DATE SSBSECT_ENRL_CUT_OFF_DATE DATE Yes
SSBSECT_ACAD_CUT_OFF_DATE SSBSECT_ACAD_CUT_OFF_DATE DATE Yes
SSBSECT_DROP_CUT_OFF_DATE SSBSECT_DROP_CUT_OFF_DATE DATE Yes
SSBSECT_CENSUS_2_ENRL SSBSECT_CENSUS_2_ENRL NUMBER(4,0) Yes
SSBSECT_VOICE_AVAIL SSBSECT_VOICE_AVAIL VARCHAR2(1) No
SSBSECT_CAPP_PREREQ_TEST_IND SSBSECT_CAPP_PREREQ_TEST_IND VARCHAR2(1) No
SSBSECT_GSCH_NAME SSBSECT_GSCH_NAME VARCHAR2(10) Yes
SSBSECT_BEST_OF_COMP SSBSECT_BEST_OF_COMP NUMBER(3,0) Yes
SSBSECT_SUBSET_OF_COMP SSBSECT_SUBSET_OF_COMP NUMBER(3,0) Yes
SSBSECT_INSM_CODE SSBSECT_INSM_CODE VARCHAR2(5) Yes *
SSBSECT_REG_FROM_DATE SSBSECT_REG_FROM_DATE DATE Yes
SSBSECT_REG_TO_DATE SSBSECT_REG_TO_DATE DATE Yes
SSBSECT_LEARNER_REGSTART_FDATE SSBSECT_LEARNER_REGSTART_FDATE DATE Yes
SSBSECT_LEARNER_REGSTART_TDATE SSBSECT_LEARNER_REGSTART_TDATE DATE Yes
SSBSECT_DUNT_CODE SSBSECT_DUNT_CODE VARCHAR2(4) Yes *
SSBSECT_NUMBER_OF_UNITS SSBSECT_NUMBER_OF_UNITS NUMBER(7,2) Yes
SSBSECT_NUMBER_OF_EXTENSIONS SSBSECT_NUMBER_OF_EXTENSIONS NUMBER(3,0) No

Foreign Key information

Column name is Foreign Key For Column on Table
SSBSECT_DUNT_CODE GTVDUNT_CODE GTVDUNT
SSBSECT_INSM_CODE GTVINSM_CODE GTVINSM
SSBSECT_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SSBSECT_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SSBSECT_ACCL_CODE STVACCL_CODE STVACCL
SSBSECT_ACCT_CODE STVACCT_CODE STVACCT
SSBSECT_CAMP_CODE STVCAMP_CODE STVCAMP
SSBSECT_GMOD_CODE STVGMOD_CODE STVGMOD
SSBSECT_PTRM_CODE STVPTRM_CODE STVPTRM
SSBSECT_SCHD_CODE STVSCHD_CODE STVSCHD
SSBSECT_SESS_CODE STVSESS_CODE STVSESS
SSBSECT_SSTS_CODE STVSSTS_CODE STVSSTS
SSBSECT_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SSBSECT_TERM_CODE STVTERM_CODE STVTERM
SSBSECT_SAPR_CODE STVSAPR_CODE STVSAPR
SSBSECT_TERM_CODE SFTREGS_TERM_CODE SFTREGS
SSBSECT_CRN SFTREGS_CRN SFTREGS
SSBSECT_TERM_CODE SFRENRL_TERM_CODE SFRENRL
SSBSECT_TERM_CODE TBRACCD_TERM_CODE TBRACCD
SSBSECT_CRN TBRACCD_CRN TBRACCD
SSBSECT_TERM_CODE SSRRSTS_TERM_CODE SSRRSTS
SSBSECT_CRN SSRRSTS_CRN SSRRSTS
SSBSECT_TERM_CODE SOBTERM_TERM_CODE SOBTERM
SSBSECT_CRN SFRAREG_CRN SFRAREG
SSBSECT_TERM_CODE SFRAREG_TERM_CODE SFRAREG
SSBSECT_SUBJ_CODE SCREQIV_SUBJ_CODE SCREQIV
SSBSECT_CRSE_NUMB SCREQIV_CRSE_NUMB SCREQIV
SSBSECT_SUBJ_CODE SCREQIV_SUBJ_CODE_EQIV SCREQIV
SSBSECT_CRSE_NUMB SCREQIV_CRSE_NUMB_EQIV SCREQIV

Index

Index Name Index Type Column Name
PK_SSBSECT Unique SSBSECT_TERM_CODE
PK_SSBSECT Unique SSBSECT_CRN
SSBSECT_DATE_INDEX SSBSECT_REG_FROM_DATE
SSBSECT_DATE_INDEX SSBSECT_REG_TO_DATE
SSBSECT_DATE_INDEX SSBSECT_TERM_CODE
SSBSECT_GSCH_INDEX SSBSECT_GSCH_NAME
SSBSECT_INDEX_SUBJ Unique SSBSECT_SUBJ_CODE
SSBSECT_INDEX_SUBJ Unique SSBSECT_CRSE_NUMB
SSBSECT_INDEX_SUBJ Unique SSBSECT_TERM_CODE
SSBSECT_INDEX_SUBJ Unique SSBSECT_CRN
SSBSECT_PTRM_DATE_INDEX SSBSECT_PTRM_START_DATE

Comments

Source Code Comments

Section General Information Base Table

Impact job : GradableInd New Job

Columns Comments for SSBSECT_TERM_CODE (1)

Source Code Comments

This field is not displayed on the form (page 0). It defines the Term code for the course section information. It is derived from the Key Block Term.

Columns Comments for SSBSECT_CRN (2)

Source Code Comments

This field is not displayed on the form (page 0). It will display the Course Reference Number (CRN) assigned to this course section when it was initially added.

Columns Comments for SSBSECT_PTRM_CODE (3)

Source Code Comments

This field is used to specify the part-of-term in which the section is offered. The value entered here must be valid as defined for the term on the Term Control Form - SOATERM. The default is "1".

Columns Comments for SSBSECT_SUBJ_CODE (4)

Source Code Comments

This field is required in order to add a section. In addition, the combina- tion of Subject, Course Number and Key Block Term must identify a valid course version as maintained in the Catalog Module.

Columns Comments for SSBSECT_CRSE_NUMB (5)

Source Code Comments

This field, the Key Block Term and Subject must identify a valid course ver- sion from the Catalog Module. If you try to schedule a section for a term restricted on the Schedule Restrictions Form - SCARRES,
an error occurs.

Columns Comments for SSBSECT_SEQ_NUMB (6)

Source Code Comments

This field identifies the section number of a course. A Section number can only be used once to identify a Subject/Course Number combination in a term, however, multiple sections of a course can share a 0 se
ction number.

Columns Comments for SSBSECT_SSTS_CODE (7)

Source Code Comments

This field maintains the status of a section. The "Allow Registration" switch on the Section Status Validation Form - STVSSTS determines whether the status entered will prevent or allow registration for thi
s section.

Columns Comments for SSBSECT_SCHD_CODE (8)

Source Code Comments

This field identifies the instructional type of the section being scheduled. It is a required field on an add. Use the LIST FIELD VALUES key to display the Schedule Type Validation Form - STVSCHD.

Columns Comments for SSBSECT_CAMP_CODE (9)

Source Code Comments

This field defines the campus on which the section is scheduled. If you attempt to schedule a course for a campus which is restricted on the Course Schedule Restrictions Form - SCASRES, an error will occur.

Columns Comments for SSBSECT_CRSE_TITLE (10)

Source Code Comments

This field will display the title of the course as defined on the Basic Course Information Form - SCACRSE.

Columns Comments for SSBSECT_CREDIT_HRS (11)

Source Code Comments

This field can be used to restrict a section to a single credit hr. value when the course was defined with variable credit hrs. on the Basic Course Info. Form - SCACRSE. This value must fall between the
variable values.

Columns Comments for SSBSECT_BILL_HRS (12)

Source Code Comments

This field can be used to restrict a section to a single billing hr. value when the course was defined with variable billing hrs. on the Basic Course Info. Form - SCACRSE. This value must fall between the
variable values.

Columns Comments for SSBSECT_GMOD_CODE (13)

Source Code Comments

This field can be used to specify one grading mode for this section from the grading mode(s) defined for the course on the Basic Course Information Form - SCACRSE. This field is optional.

Columns Comments for SSBSECT_SAPR_CODE (14)

Source Code Comments

This field can be used to specify the type of special approval a student must have to register. The Special Approval Severity switch on the Term Control Form - SOATERM, determines how this is checked at reg
istration.

Columns Comments for SSBSECT_SESS_CODE (15)

Source Code Comments

This field can be used to identify the session in which the section is scheduled. This is an optional field. Use the LIST FIELD VALUES key to display the Session Code Validation Form - STVSESS.

Columns Comments for SSBSECT_LINK_IDENT (16)

Source Code Comments

This field can be used to link other sections of the same course which must be taken concurrently. Enter a code in this field, then enter same code in Link connector field for linked section on Schedule De
tail Form - SSADETL.

Columns Comments for SSBSECT_PRNT_IND (17)

Source Code Comments

This field is used to specify whether the section should be printed in the Schedule Report - SSRSECT. "Y" - Yes, print section is the default value.

Columns Comments for SSBSECT_GRADABLE_IND (18)

Source Code Comments

This field is used to specify whether or not the section is gradable. It is a required field and "Y" - Yes, Gradable, is the default value.

Columns Comments for SSBSECT_TUIW_IND (19)

Source Code Comments

This field can be used to specify that this section be exempt from the assessment of tuition and fees as defined on the Registration Fees Process Control Form - SFARGFE (See Field Usage Notes).

Columns Comments for SSBSECT_REG_ONEUP (20)

Source Code Comments

This field is not displayed on the form (page 0). It displays the count associated with the last student registered for the course section.

Columns Comments for SSBSECT_PRIOR_ENRL (21)

Source Code Comments

This field is system maintained. When the Section Roll Process - SSRROLL, is used to create section entries based on a previous term"s sections, the Prior enrollment field is set to the enrollment from the
prior term.

Columns Comments for SSBSECT_PROJ_ENRL (22)

Source Code Comments

This field is used to record the anticipated enrollment in the section for the term. It is an optional field which defaults to "0" when a section is added, and it controls no system processing.

Columns Comments for SSBSECT_MAX_ENRL (23)

Source Code Comments

This field is used to set the maximum enrollment for a section. When the Capacity severity switch is set to "W" or "F" on the Term Control Form - SOATERM, the system issues warnings when enrollment exceeds t
his number.

Columns Comments for SSBSECT_ENRL (24)

Source Code Comments

This field is system maintained. It displays a running total of enrollments in the section which have a course status with a "Count in Enroll" flag of "Y" on the Registration Status Code Validation Form - STVRST
S.

Columns Comments for SSBSECT_SEATS_AVAIL (25)

Source Code Comments

This field is system maintained. It will display a running total of remain- ing avaialable seats in the section by subtracting the Actual enrollment field from the Maximum enrollment field defined for thi
s section.

Columns Comments for SSBSECT_TOT_CREDIT_HRS (26)

Source Code Comments

This field is system maintained. It will display a running total of all enrolled credit hours in the section.

Columns Comments for SSBSECT_CENSUS_ENRL (27)

Source Code Comments

This field is system maintained. It will display the running total of students registered for the section prior to the census date defined for the part of term.

Columns Comments for SSBSECT_CENSUS_ENRL_DATE (28)

Source Code Comments

This field is defined in the Census field in the Base Part of Term Block on the Term Control Form - SOATERM, and will default to this field based on the Key Block Term and Part/Term field in the Secti
on Block of this form.

Columns Comments for SSBSECT_ACTIVITY_DATE (29)

Source Code Comments

This field specifies the most current date record was created or updated.

Columns Comments for SSBSECT_PTRM_START_DATE (30)

Source Code Comments

This field is defined in the Start field in the Base Part of Term Block on the Term Control Form - SOATERM, and will default to this field based on the Key Block Term and Part/Term field in the Section
Block of this form.

Columns Comments for SSBSECT_PTRM_END_DATE (31)

Source Code Comments

This field is defined in the End field in the Base Part of Term Block on the Term Control Form - SOATERM, and will default to this field based on the Key Block Term and Part/Term field in the Section Blo
ck of this form.

Columns Comments for SSBSECT_PTRM_WEEKS (32)

Source Code Comments

This field is defined in the "Wks" field in the Base Part of Term Block on the Term Control Form - SOATERM, and will default to this field based on the Key Block Term and Part/Term field in the Section Bloc
k of this form.

Columns Comments for SSBSECT_RESERVED_IND (33)

Source Code Comments

This f