Model SSBSECT

Model Label : ERD for Banner Student SSBSECT Table
Path : BANNER DEV/Student/Common/SSBSECT/SSBSECT_ERD

List of Objects

Object Name	Object Type	Layer Name
GTVDUNT	TABLE	Default
GTVINSM	TABLE	Default
GTVSDAX	TABLE	Default
SCBCRKY	TABLE	Default
SCBCRSE	TABLE	Default
SCRCORQ	TABLE	Default
SCREQIV	TABLE	Default
SCRSCHD	TABLE	Default
SFRAREG	TABLE	Default
SFRENRL	TABLE	Default
SFRRSTS	TABLE	Default
SFRSTCR	TABLE	Default
SFTAREA	TABLE	Default
SFTREGS	TABLE	Default
SHBGSCH	TABLE	Default
SHRTCKN	TABLE	Default
SIRASGN	TABLE	Default
SIRLVAS	TABLE	Default
SOBTERM	TABLE	Default
SORRTRM	TABLE	Default
SSBOVRR	TABLE	Default
SSBSECT	TABLE	Default
SSRATTR	TABLE	Default
SSRBLCK	TABLE	Default
SSRCORQ	TABLE	Default
SSRFEES	TABLE	Default
SSRLINK	TABLE	Default
SSRMEET	TABLE	Default
SSRRCLS	TABLE	Default
SSRRCMP	TABLE	Default
SSRRCOL	TABLE	Default
SSRRESV	TABLE	Default
SSRRLVL	TABLE	Default
SSRRMAJ	TABLE	Default
SSRRSTS	TABLE	Default
SSRRTST	TABLE	Default
SSRSCCD	TABLE	Default
SSRSPRT	TABLE	Default
SSRSRDF	TABLE	Default
SSRSYLN	TABLE	Default
SSRTEXT	TABLE	Default
SSRXLST	TABLE	Default
STVACCL	TABLE	Default
STVACCT	TABLE	Default
STVCAMP	TABLE	Default
STVGMOD	TABLE	Default
STVPTRM	TABLE	Default
STVSAPR	TABLE	Default
STVSCHD	TABLE	Default
STVSESS	TABLE	Default
STVSSTS	TABLE	Default
STVSUBJ	TABLE	Default
TBRACCD	TABLE	Default

Comments

Model View

Table GTVDUNT

Schema Name GENERAL
Label GTVDUNT
Server name MALDEV8_B60
Creation Date 02/17/2003 18:04:07:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GTVDUNT_CODE	GTVDUNT_CODE	VARCHAR2(4)	No	*
GTVDUNT_DESC	GTVDUNT_DESC	VARCHAR2(30)	No
GTVDUNT_NUMBER_OF_DAYS	GTVDUNT_NUMBER_OF_DAYS	NUMBER(7,2)	No
GTVDUNT_ACTIVITY_DATE	GTVDUNT_ACTIVITY_DATE	DATE	No
GTVDUNT_USER_ID	GTVDUNT_USER_ID	VARCHAR2(30)	No
GTVDUNT_VR_MSG_NO	GTVDUNT_VR_MSG_NO	NUMBER(6,0)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVDUNT	Unique	GTVDUNT_CODE

Comments

Source Code Comments

Duration Unit Code Validation Table

Columns Comments for GTVDUNT_CODE (1)

Source Code Comments

Duration Unit Code: The Duration Unit Code

Columns Comments for GTVDUNT_DESC (2)

Source Code Comments

Description: Description of the duration unit code

Columns Comments for GTVDUNT_NUMBER_OF_DAYS (3)

Source Code Comments

Number of Days per duration unit: Represents the number of days that one duration unit would equate to (ie 1 week equals 7 days)

Columns Comments for GTVDUNT_ACTIVITY_DATE (4)

Source Code Comments

Activity Date: Date this record entered or last updated

Columns Comments for GTVDUNT_USER_ID (5)

Source Code Comments

User ID: The username of the person who entered or last updated this record

Columns Comments for GTVDUNT_VR_MSG_NO (6)

Source Code Comments

Voice Response Message Number

Table GTVINSM

Schema Name GENERAL
Label GTVINSM
Server name MALDEV8_B60
Creation Date 02/17/2003 18:03:47:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GTVINSM_CODE	GTVINSM_CODE	VARCHAR2(5)	No	*
GTVINSM_DESC	GTVINSM_DESC	VARCHAR2(30)	No
GTVINSM_ACTIVITY_DATE	GTVINSM_ACTIVITY_DATE	DATE	No
GTVINSM_USER_ID	GTVINSM_USER_ID	VARCHAR2(30)	No
GTVINSM_VR_MSG_NO	GTVINSM_VR_MSG_NO	NUMBER(6,0)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVINSM	Unique	GTVINSM_CODE

Comments

Source Code Comments

Instructional Method Code Validation Table

Columns Comments for GTVINSM_CODE (1)

Source Code Comments

Instructional Method Code: The Instructional Method Code

Columns Comments for GTVINSM_DESC (2)

Source Code Comments

Description: Description of the instructional method code

Columns Comments for GTVINSM_ACTIVITY_DATE (3)

Source Code Comments

Activity Date: Date this record entered or last updated

Columns Comments for GTVINSM_USER_ID (4)

Source Code Comments

User ID: The username of the person who entered or last updated this record

Columns Comments for GTVINSM_VR_MSG_NO (5)

Source Code Comments

Voice Response Message Number

Table GTVSDAX

Schema Name GENERAL
Label GTVSDAX
Server name MALDEV8_B60
Creation Date 04/28/2003 16:18:08:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_INTERNAL_CODE	GTVSDAX_INTERNAL_CODE	VARCHAR2(10)	No	*
GTVSDAX_INTERNAL_CODE	GTVSDAX_INTERNAL_CODE	VARCHAR2(10)	No	*
GTVSDAX_REPORTING_DATE	GTVSDAX_REPORTING_DATE	DATE	Yes
GTVSDAX_TRANSLATION_CODE	GTVSDAX_TRANSLATION_CODE	VARCHAR2(15)	Yes
GTVSDAX_INTERNAL_CODE_SEQNO	GTVSDAX_INTERNAL_CODE_SEQNO	NUMBER(2,0)	Yes
GTVSDAX_INTERNAL_CODE_GROUP	GTVSDAX_INTERNAL_CODE_GROUP	VARCHAR2(20)	No
GTVSDAX_DESC	GTVSDAX_DESC	VARCHAR2(30)	No
GTVSDAX_SYSREQ_IND	GTVSDAX_SYSREQ_IND	VARCHAR2(1)	Yes
GTVSDAX_ACTIVITY_DATE	GTVSDAX_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GTVSDAX_EXTERNAL_CODE	SSBSECT_SSTS_CODE	SSBSECT
GTVSDAX_INTERNAL_CODE	SORPCOL_SBGI_CODE	SORPCOL
GTVSDAX_INTERNAL_CODE	SPRMEDI_MEDI_CODE	SPRMEDI
GTVSDAX_EXTERNAL_CODE	PERJTOT_EARN_CODE	PERJTOT
GTVSDAX_EXTERNAL_CODE	SRBRECR_LEVL_CODE	SRBRECR
GTVSDAX_EXTERNAL_CODE	SARADAP_LEVL_CODE	SARADAP
GTVSDAX_EXTERNAL_CODE	SFRRSTS_RSTS_CODE	SFRRSTS
GTVSDAX_EXTERNAL_CODE	SARAPPD_APDC_CODE	SARAPPD
GTVSDAX_EXTERNAL_CODE	SORBCHR_BCHR_CODE	SORBCHR
GTVSDAX_EXTERNAL_CODE	SORTEST_TESC_CODE	SORTEST

Index

Index Name	Index Type	Column Name
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_INTERNAL_CODE_GROUP
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_INTERNAL_CODE
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_EXTERNAL_CODE
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_INTERNAL_CODE_SEQNO

Comments

Source Code Comments

SDA crosswalk/conversion table

Columns Comments for GTVSDAX_EXTERNAL_CODE (1)

Source Code Comments

Banner/concept code for to be retrieved

Columns Comments for GTVSDAX_INTERNAL_CODE (2)

Source Code Comments

The pre-determined SDA retrieval code

Columns Comments for GTVSDAX_REPORTING_DATE (3)

Source Code Comments

The date column used for various reporting needs

Columns Comments for GTVSDAX_TRANSLATION_CODE (4)

Source Code Comments

The hard-coded translation of the user defined external code, eg. Freshman, PUB for Public School, etc

Columns Comments for GTVSDAX_INTERNAL_CODE_SEQNO (5)

Source Code Comments

The sequence number for internal codes requiring multiple values

Columns Comments for GTVSDAX_INTERNAL_CODE_GROUP (6)

Source Code Comments

The group typing for translated or crosswalked values to specifically identify which grouping each series of codes belongs too

Columns Comments for GTVSDAX_DESC (7)

Source Code Comments

The description of the SDA code/concept

Columns Comments for GTVSDAX_SYSREQ_IND (8)

Source Code Comments

A Y in this field indicates that this row is required for production processing

Columns Comments for GTVSDAX_ACTIVITY_DATE (9)

Source Code Comments

The last activity date for this row of data

Table SCBCRKY

Schema Name SATURN
Label SCBCRKY
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:49:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SCBCRKY_SUBJ_CODE	SCBCRKY_SUBJ_CODE	VARCHAR2(4)	No	*	*
SCBCRKY_CRSE_NUMB	SCBCRKY_CRSE_NUMB	VARCHAR2(5)	No	*
SCBCRKY_TERM_CODE_START	SCBCRKY_TERM_CODE_START	VARCHAR2(6)	No		*
SCBCRKY_TERM_CODE_END	SCBCRKY_TERM_CODE_END	VARCHAR2(6)	No		*
SCBCRKY_ACTIVITY_DATE	SCBCRKY_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SCBCRKY_SUBJ_CODE	STVSUBJ_CODE	STVSUBJ

Index

Index Name	Index Type	Column Name
PK_SCBCRKY	Unique	SCBCRKY_SUBJ_CODE
PK_SCBCRKY	Unique	SCBCRKY_CRSE_NUMB

Comments

Source Code Comments

Course Catalog Base Table

Columns Comments for SCBCRKY_SUBJ_CODE (1)

Source Code Comments

This field displays the Subject area of courses in the system. Completion of this field in query mode allows you to query all courses currently defined in the system for this Subject code.

Columns Comments for SCBCRKY_CRSE_NUMB (2)

Source Code Comments

This field displays the Course Number of courses in the system. Completion of this field in query mode allows you to query all courses currently defined in the system for this Course Number.

Columns Comments for SCBCRKY_TERM_CODE_START (3)

Source Code Comments

This is the From Term of the earliest version of the course. If changed to earlier or later term, all From Terms change for this course to begin in this term. It cannot be later than a term where sections are scheduled.

Columns Comments for SCBCRKY_TERM_CODE_END (4)

Source Code Comments

This is the To Term of the latest version of the course. If changed to an earlier or later term, all To Terms for this course will change to end in this term. It cannot be earlier than a term where sections are scheduled.

Columns Comments for SCBCRKY_ACTIVITY_DATE (5)

Source Code Comments

This field specifes the date the record was created or updated.

Table SCBCRSE

Schema Name SATURN
Label SCBCRSE
Server name MALDEV8_B60
Creation Date 06/23/2003 13:16:54:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SCBCRSE_SUBJ_CODE	SCBCRSE_SUBJ_CODE	VARCHAR2(4)	No	*
SCBCRSE_SUBJ_CODE	SCBCRSE_SUBJ_CODE	VARCHAR2(4)	No	*
SCBCRSE_SUBJ_CODE	SCBCRSE_SUBJ_CODE	VARCHAR2(4)	No	*
SCBCRSE_SUBJ_CODE	SCBCRSE_SUBJ_CODE	VARCHAR2(4)	No	*
SCBCRSE_CRSE_NUMB	SCBCRSE_CRSE_NUMB	VARCHAR2(5)	No	*
SCBCRSE_CRSE_NUMB	SCBCRSE_CRSE_NUMB	VARCHAR2(5)	No	*
SCBCRSE_CRSE_NUMB	SCBCRSE_CRSE_NUMB	VARCHAR2(5)	No	*
SCBCRSE_EFF_TERM	SCBCRSE_EFF_TERM	VARCHAR2(6)	Yes	*
SCBCRSE_COLL_CODE	SCBCRSE_COLL_CODE	VARCHAR2(2)	Yes	*
SCBCRSE_COLL_CODE	SCBCRSE_COLL_CODE	VARCHAR2(2)	Yes	*
SCBCRSE_DIVS_CODE	SCBCRSE_DIVS_CODE	VARCHAR2(4)	Yes	*
SCBCRSE_DIVS_CODE	SCBCRSE_DIVS_CODE	VARCHAR2(4)	Yes	*
SCBCRSE_DEPT_CODE	SCBCRSE_DEPT_CODE	VARCHAR2(4)	Yes	*
SCBCRSE_DEPT_CODE	SCBCRSE_DEPT_CODE	VARCHAR2(4)	Yes	*
SCBCRSE_CSTA_CODE	SCBCRSE_CSTA_CODE	VARCHAR2(1)	Yes	*
SCBCRSE_TITLE	SCBCRSE_TITLE	VARCHAR2(30)	Yes
SCBCRSE_CIPC_CODE	SCBCRSE_CIPC_CODE	VARCHAR2(6)	Yes	*
SCBCRSE_CREDIT_HR_IND	SCBCRSE_CREDIT_HR_IND	VARCHAR2(2)	Yes
SCBCRSE_CREDIT_HR_LOW	SCBCRSE_CREDIT_HR_LOW	NUMBER(7,3)	Yes
SCBCRSE_CREDIT_HR_HIGH	SCBCRSE_CREDIT_HR_HIGH	NUMBER(7,3)	Yes
SCBCRSE_LEC_HR_IND	SCBCRSE_LEC_HR_IND	VARCHAR2(2)	Yes
SCBCRSE_LEC_HR_LOW	SCBCRSE_LEC_HR_LOW	NUMBER(7,3)	Yes
SCBCRSE_LEC_HR_HIGH	SCBCRSE_LEC_HR_HIGH	NUMBER(7,3)	Yes
SCBCRSE_LAB_HR_IND	SCBCRSE_LAB_HR_IND	VARCHAR2(2)	Yes
SCBCRSE_LAB_HR_LOW	SCBCRSE_LAB_HR_LOW	NUMBER(7,3)	Yes
SCBCRSE_LAB_HR_HIGH	SCBCRSE_LAB_HR_HIGH	NUMBER(7,3)	Yes
SCBCRSE_OTH_HR_IND	SCBCRSE_OTH_HR_IND	VARCHAR2(2)	Yes
SCBCRSE_OTH_HR_LOW	SCBCRSE_OTH_HR_LOW	NUMBER(7,3)	Yes
SCBCRSE_OTH_HR_HIGH	SCBCRSE_OTH_HR_HIGH	NUMBER(7,3)	Yes
SCBCRSE_BILL_HR_IND	SCBCRSE_BILL_HR_IND	VARCHAR2(2)	Yes
SCBCRSE_BILL_HR_LOW	SCBCRSE_BILL_HR_LOW	NUMBER(7,3)	Yes
SCBCRSE_BILL_HR_HIGH	SCBCRSE_BILL_HR_HIGH	NUMBER(7,3)	Yes
SCBCRSE_APRV_CODE	SCBCRSE_APRV_CODE	VARCHAR2(1)	Yes	*
SCBCRSE_REPEAT_LIMIT	SCBCRSE_REPEAT_LIMIT	NUMBER(2,0)	Yes
SCBCRSE_PWAV_CODE	SCBCRSE_PWAV_CODE	VARCHAR2(1)	Yes	*
SCBCRSE_TUIW_IND	SCBCRSE_TUIW_IND	VARCHAR2(1)	Yes
SCBCRSE_ADD_FEES_IND	SCBCRSE_ADD_FEES_IND	VARCHAR2(1)	Yes
SCBCRSE_ACTIVITY_DATE	SCBCRSE_ACTIVITY_DATE	DATE	Yes
SCBCRSE_CONT_HR_LOW	SCBCRSE_CONT_HR_LOW	NUMBER(7,3)	Yes
SCBCRSE_CONT_HR_IND	SCBCRSE_CONT_HR_IND	VARCHAR2(2)	Yes
SCBCRSE_CONT_HR_HIGH	SCBCRSE_CONT_HR_HIGH	NUMBER(7,3)	Yes
SCBCRSE_CEU_IND	SCBCRSE_CEU_IND	VARCHAR2(1)	Yes
SCBCRSE_REPS_CODE	SCBCRSE_REPS_CODE	VARCHAR2(2)	Yes	*
SCBCRSE_MAX_RPT_UNITS	SCBCRSE_MAX_RPT_UNITS	NUMBER(9,3)	Yes
SCBCRSE_CAPP_PREREQ_TEST_IND	SCBCRSE_CAPP_PREREQ_TEST_IND	VARCHAR2(1)	No
SCBCRSE_DUNT_CODE	SCBCRSE_DUNT_CODE	VARCHAR2(4)	Yes	*
SCBCRSE_NUMBER_OF_UNITS	SCBCRSE_NUMBER_OF_UNITS	NUMBER(7,2)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SCBCRSE_DUNT_CODE	GTVDUNT_CODE	GTVDUNT
SCBCRSE_CIPC_CODE	STVCIPC_CODE	STVCIPC
SCBCRSE_COLL_CODE	STVCOLL_CODE	STVCOLL
SCBCRSE_CSTA_CODE	STVCSTA_CODE	STVCSTA
SCBCRSE_DEPT_CODE	STVDEPT_CODE	STVDEPT
SCBCRSE_DIVS_CODE	STVDIVS_CODE	STVDIVS
SCBCRSE_PWAV_CODE	STVPWAV_CODE	STVPWAV
SCBCRSE_REPS_CODE	STVREPS_CODE	STVREPS
SCBCRSE_SUBJ_CODE	STVSUBJ_CODE	STVSUBJ
SCBCRSE_EFF_TERM	STVTERM_CODE	STVTERM
SCBCRSE_APRV_CODE	STVAPRV_CODE	STVAPRV
SCBCRSE_SUBJ_CODE	SHBGSCH_SUBJ_CODE	SHBGSCH
SCBCRSE_CRSE_NUMB	SHBGSCH_CRSE_NUMB	SHBGSCH
SCBCRSE_COLL_CODE	SHBGSCH_COLL_CODE	SHBGSCH
SCBCRSE_DIVS_CODE	SHBGSCH_DIVS_CODE	SHBGSCH
SCBCRSE_DEPT_CODE	SHBGSCH_DEPT_CODE	SHBGSCH
SCBCRSE_SUBJ_CODE	SCBCRKY_SUBJ_CODE	SCBCRKY
SCBCRSE_CRSE_NUMB	SCBCRKY_CRSE_NUMB	SCBCRKY
SCBCRSE_SUBJ_CODE	SSBSECT_SUBJ_CODE	SSBSECT
SCBCRSE_CRSE_NUMB	SSBSECT_CRSE_NUMB	SSBSECT

Index

Index Name	Index Type	Column Name
SCBCRSE_KEY_INDEX	Unique	SCBCRSE_SUBJ_CODE
SCBCRSE_KEY_INDEX	Unique	SCBCRSE_CRSE_NUMB
SCBCRSE_KEY_INDEX	Unique	SCBCRSE_EFF_TERM

Comments

Source Code Comments

Course General Information Base Table

Columns Comments for SCBCRSE_SUBJ_CODE (1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCBCRSE_CRSE_NUMB (2)

Source Code Comments

This field defines the course number associated with the subject for the course.

Columns Comments for SCBCRSE_EFF_TERM (3)

Source Code Comments

This field identifies the term this version of the course becomes effective.

Columns Comments for SCBCRSE_COLL_CODE (4)

Source Code Comments

This field is used to specify the college which offers the course.

Columns Comments for SCBCRSE_DIVS_CODE (5)

Source Code Comments

This field can be used to specify the division which offers the course, if desired.

Columns Comments for SCBCRSE_DEPT_CODE (6)

Source Code Comments

This field is used to specify the department which offers the course, if desired.

Columns Comments for SCBCRSE_CSTA_CODE (7)

Source Code Comments

Course Status Code. It is a required field. It can be used to prevent creation of sections of the course based on the Active/Inactive flag associated with the status code.

Columns Comments for SCBCRSE_TITLE (8)

Source Code Comments

This field is used to specify the title of the course which will be in effect for the effective term. It is a free format field.

Columns Comments for SCBCRSE_CIPC_CODE (9)

Source Code Comments

This field can be used to record the CIP code of the course. Normally, CIP course codes are used to identify the primary subject matter of a course.

Columns Comments for SCBCRSE_CREDIT_HR_IND (10)

Source Code Comments

This field defines whether the course can be offered for variable credit. OR/TO is used to specify the relationship between low and high credit hours. values. An OR/TO value must exist to enter Credit Hours High.

Columns Comments for SCBCRSE_CREDIT_HR_LOW (11)

Source Code Comments

This field specifies the minimum number of credits for which a course may be offered. Credit hour values will control the number of credit hours for which sections can be scheduled and for which students may register.

Columns Comments for SCBCRSE_CREDIT_HR_HIGH (12)

Source Code Comments

This field is used either to define a second valid credit hour value or to define the high credit hour value within a range. A value may only be entered if the OR/TO field is complete and value must be > Credit Hours Low.

Columns Comments for SCBCRSE_LEC_HR_IND (13)

Source Code Comments

This field defines whether the course can be offered for variable lecture hours. OR/TO is used to specify the relationship between the low and high lecture hour values. An OR/TO value must exist to enter Lecture Hours High.

Columns Comments for SCBCRSE_LEC_HR_LOW (14)

Source Code Comments

This field is used to specify the minimum number of lecture hours for which a course may be offered.

Columns Comments for SCBCRSE_LEC_HR_HIGH (15)

Source Code Comments

This field is used either to define a second valid lecture hour value or to define the high lecture hour value within a range. A value may only be entered if the OR/TO field is complete and must be > Lecture Hours Low.

Columns Comments for SCBCRSE_LAB_HR_IND (16)

Source Code Comments

This field defines whether the course can be offered for variable lab hours. OR/TO is used to specify the relationship between the low and high lab hour values. An OR/TO value must exist to enter Lab Hours High.

Columns Comments for SCBCRSE_LAB_HR_LOW (17)

Source Code Comments

This field is used to specify the minimum number of lab hours for which a course may be offered.

Columns Comments for SCBCRSE_LAB_HR_HIGH (18)

Source Code Comments

This field is used either to define a second valid lab hour value or to define the high lab hour value within a range. A value may only be entered if the OR/TO field is complete and this field value must be > Lab Hours Low.

Columns Comments for SCBCRSE_OTH_HR_IND (19)

Source Code Comments

This field defines whether the course can be offered for variable other hours. OR/TO is used to specify the relationship between the low and high other hour values. An OR/TO value must exist to enter Other Hours High.

Columns Comments for SCBCRSE_OTH_HR_LOW (20)

Source Code Comments

This field is used to specify the minimum number of other hours for which the course can be offered. Other hours is defined by the institution.

Columns Comments for SCBCRSE_OTH_HR_HIGH (21)

Source Code Comments

This field is used to define a second valid other hour value or to define the high other hours value within a range. A value may only be entered if the OR/TO field is complete and this field value must be > Other Hours Low.

Columns Comments for SCBCRSE_BILL_HR_IND (22)

Source Code Comments

This field defines whether the course can be billed for variable credit. OR/TO is used to specify the relationship between the low and high billing hour values. An OR/TO value must exist to enter Billing Hours High.

Columns Comments for SCBCRSE_BILL_HR_LOW (23)

Source Code Comments

This field is used to specify the minimum number of credits for which the course can be billed based on defined assessment rules. Billing hours will default to the values defined for credit hours, but may be changed.

Columns Comments for SCBCRSE_BILL_HR_HIGH (24)

Source Code Comments

This field defines a second valid billing hours value or to define the high billing hours value within a range. A value may only be entered if the OR/TO field is complete and this field value must be > Billing Hours Low.

Columns Comments for SCBCRSE_APRV_CODE (25)

Source Code Comments

This field is used to record the type of requirements a course is approved to fulfill.

Columns Comments for SCBCRSE_REPEAT_LIMIT (26)

Source Code Comments

This field is used to record the maximum number of times the course may be repeated by a student. Zero (0) will default. Repeat Limit is used in the repeat check process in Academic History.

Columns Comments for SCBCRSE_PWAV_CODE (27)

Source Code Comments

This field is used to record the type of authorization a student must have in order to waive a pre-requisite requirement. It is informational only.

Columns Comments for SCBCRSE_TUIW_IND (28)

Source Code Comments

This field specifies whether the course is exempt from tuit. and fees defined on Reg. Fees Process Control Form - SFARGFE. If "Y", all rules on SFARGFE with "Y" in Override field ignored. If "N", rules on SFARGFE apply.

Columns Comments for SCBCRSE_ADD_FEES_IND (29)

Source Code Comments

This field is used to record that additional fees, outside of the SFARGFE assessment rules, are charged for the course. Additional course fees are defined in Fee Code Block of Course Detail Form - SCADETL. Info. only.

Columns Comments for SCBCRSE_ACTIVITY_DATE (30)

Source Code Comments

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

Columns Comments for SCBCRSE_CONT_HR_LOW (31)

Source Code Comments

This column contains the sum of low lecture, lab and others hours columns. Contact hours divided by 10 are the continuing education units for a continuing ed course. This calculated value is stored in the credit hour field when the ceu_ind = Y

Columns Comments for SCBCRSE_CONT_HR_IND (32)

Source Code Comments

This column contains the literal TO or OR to define the relationship between the low and high contact hours

Columns Comments for SCBCRSE_CONT_HR_HIGH (33)

Source Code Comments

This column contains the sum of high lecture, lab and others hours columns. It functions the same as the cont_hr_low column. A value may only be entered if the OR/TO field is entered and must be > contact hours low

Columns Comments for SCBCRSE_REPS_CODE (35)

Source Code Comments

Repeat status code used for reporting purposes.

Columns Comments for SCBCRSE_MAX_RPT_UNITS (36)

Source Code Comments

Maximum number of credits permitted.

Columns Comments for SCBCRSE_CAPP_PREREQ_TEST_IND (37)

Source Code Comments

Indicates whether CAPP areas or existing prerequisite and test score restrictions are in effect for the course for the effective term

Columns Comments for SCBCRSE_DUNT_CODE (38)

Source Code Comments

Duration Unit code indicates the type of duration the course is offered for

Columns Comments for SCBCRSE_NUMBER_OF_UNITS (39)

Source Code Comments

Duration number of units indicates the total number of times the duration unit extends

Table SCRCORQ

Schema Name SATURN
Label SCRCORQ
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:49:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SCRCORQ_SUBJ_CODE	SCRCORQ_SUBJ_CODE	VARCHAR2(4)	No	*
SCRCORQ_SUBJ_CODE	SCRCORQ_SUBJ_CODE	VARCHAR2(4)	No	*
SCRCORQ_SUBJ_CODE	SCRCORQ_SUBJ_CODE	VARCHAR2(4)	No	*
SCRCORQ_CRSE_NUMB	SCRCORQ_CRSE_NUMB	VARCHAR2(5)	No	*
SCRCORQ_CRSE_NUMB	SCRCORQ_CRSE_NUMB	VARCHAR2(5)	No	*
SCRCORQ_EFF_TERM	SCRCORQ_EFF_TERM	VARCHAR2(6)	No	*
SCRCORQ_SUBJ_CODE_CORQ	SCRCORQ_SUBJ_CODE_CORQ	VARCHAR2(4)	Yes	*
SCRCORQ_CRSE_NUMB_CORQ	SCRCORQ_CRSE_NUMB_CORQ	VARCHAR2(5)	Yes
SCRCORQ_ACTIVITY_DATE	SCRCORQ_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SCRCORQ_SUBJ_CODE	SCBCRKY_SUBJ_CODE	SCBCRKY
SCRCORQ_CRSE_NUMB	SCBCRKY_CRSE_NUMB	SCBCRKY
SCRCORQ_EFF_TERM	STVTERM_CODE	STVTERM
SCRCORQ_SUBJ_CODE	SSBSECT_SUBJ_CODE	SSBSECT
SCRCORQ_CRSE_NUMB	SSBSECT_CRSE_NUMB	SSBSECT

Index

Index Name	Index Type	Column Name
SCRCORQ_KEY_INDEX	Unique	SCRCORQ_SUBJ_CODE
SCRCORQ_KEY_INDEX	Unique	SCRCORQ_CRSE_NUMB
SCRCORQ_KEY_INDEX	Unique	SCRCORQ_EFF_TERM
SCRCORQ_KEY_INDEX	Unique	SCRCORQ_SUBJ_CODE_CORQ
SCRCORQ_KEY_INDEX	Unique	SCRCORQ_CRSE_NUMB_CORQ

Comments

Source Code Comments

Course Corequisites Repeating Table

Columns Comments for SCRCORQ_SUBJ_CODE (1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCRCORQ_CRSE_NUMB (2)

Source Code Comments

This field defines the course number associated with the subject for the course.

Columns Comments for SCRCORQ_EFF_TERM (3)

Source Code Comments

This field identifies the term this version of the course corequisites becomes effective.

Columns Comments for SCRCORQ_SUBJ_CODE_CORQ (4)

Source Code Comments

This field is used to define co-requisite subjects for a course. Co-requisites are not required to create a course. An unlimited number of co-requisites can be authorized for a course.

Columns Comments for SCRCORQ_CRSE_NUMB_CORQ (5)

Source Code Comments

This field defines the course number of the co-requisite course requirement. When registering students, the system looks for exact matches on Subject and Course, however, course number is not validated against valid courses.

Columns Comments for SCRCORQ_ACTIVITY_DATE (6)

Source Code Comments

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

Table SCREQIV

Schema Name SATURN
Label SCREQIV
Server name MALDEV8_B60
Creation Date 06/25/2002 12:37:17:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SCREQIV_SUBJ_CODE	SCREQIV_SUBJ_CODE	VARCHAR2(4)	No	*
SCREQIV_SUBJ_CODE	SCREQIV_SUBJ_CODE	VARCHAR2(4)	No	*
SCREQIV_CRSE_NUMB	SCREQIV_CRSE_NUMB	VARCHAR2(5)	No	*
SCREQIV_EFF_TERM	SCREQIV_EFF_TERM	VARCHAR2(6)	No	*
SCREQIV_SUBJ_CODE_EQIV	SCREQIV_SUBJ_CODE_EQIV	VARCHAR2(4)	Yes	*
SCREQIV_CRSE_NUMB_EQIV	SCREQIV_CRSE_NUMB_EQIV	VARCHAR2(5)	Yes
SCREQIV_START_TERM	SCREQIV_START_TERM	VARCHAR2(6)	Yes	*
SCREQIV_END_TERM	SCREQIV_END_TERM	VARCHAR2(6)	Yes	*
SCREQIV_ACTIVITY_DATE	SCREQIV_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SCREQIV_SUBJ_CODE	SCBCRKY_SUBJ_CODE	SCBCRKY
SCREQIV_CRSE_NUMB	SCBCRKY_CRSE_NUMB	SCBCRKY

Index

Index Name	Index Type	Column Name
SCREQIV_EQIV_INDEX		SCREQIV_SUBJ_CODE_EQIV
SCREQIV_EQIV_INDEX		SCREQIV_CRSE_NUMB_EQIV
UK_SCREQIV	Unique	SCREQIV_SUBJ_CODE
UK_SCREQIV	Unique	SCREQIV_CRSE_NUMB
UK_SCREQIV	Unique	SCREQIV_EFF_TERM
UK_SCREQIV	Unique	SCREQIV_SUBJ_CODE_EQIV
UK_SCREQIV	Unique	SCREQIV_CRSE_NUMB_EQIV
UK_SCREQIV	Unique	SCREQIV_START_TERM

Comments

Source Code Comments

Equivalent Course Repeating Table

Columns Comments for SCREQIV_SUBJ_CODE (1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCREQIV_CRSE_NUMB (2)

Source Code Comments

This field defines the course number associated with the subject for the course.

Columns Comments for SCREQIV_EFF_TERM (3)

Source Code Comments

This field identifies the term this version of the course equivalents becomes effective.

Columns Comments for SCREQIV_SUBJ_CODE_EQIV (4)

Source Code Comments

This field defines an equivalent course subject code for the master course. Defining equivalents for a course is optional. An unlimited number of equivalents can be authorized for a course.

Columns Comments for SCREQIV_CRSE_NUMB_EQIV (5)

Source Code Comments

This field defines the course number of the equivalent course. Course numbers are not validated against valid course versions.

Columns Comments for SCREQIV_START_TERM (6)

Source Code Comments

This field specifies the start term of the course version which is equivalent to the course entered in the Key Block.

Columns Comments for SCREQIV_END_TERM (7)

Source Code Comments

This field is used to specify the end term of the course version which is equivalent to the course entered in the Key Block.

Columns Comments for SCREQIV_ACTIVITY_DATE (8)

Source Code Comments

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

Table SCRSCHD

Schema Name SATURN
Label SCRSCHD
Server name MALDEV8_B60
Creation Date 01/24/2003 13:30:40:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SCRSCHD_SUBJ_CODE	SCRSCHD_SUBJ_CODE	VARCHAR2(4)	No	*	*
SCRSCHD_SUBJ_CODE	SCRSCHD_SUBJ_COD