Model Catalog

Model Label : ERD for Banner Catalog Module (SC%) Tables
Path : BANNER DEV/Student/Catalog_Erd/Catalog

List of Objects

Object Name	Object Type	Layer Name
GTVDUNT	TABLE	links
GTVINSM	TABLE	links
GTVPARS	TABLE	links
SCBCDEP	TABLE	tables
SCBCDTL	TABLE	tables
SCBCRKY	TABLE	tables
SCBCRSE	TABLE	tables
SCBDESC	TABLE	tables
SCBSUPP	TABLE	tables
SCRATTR	TABLE	tables
SCRCDTX	TABLE	tables
SCRCORQ	TABLE	tables
SCRCPRT	TABLE	tables
SCRCRDF	TABLE	tables
SCREQIV	TABLE	tables
SCRFEES	TABLE	tables
SCRGMOD	TABLE	tables
SCRLEVL	TABLE	tables
SCRRARE	TABLE	tables
SCRRCAM	TABLE	tables
SCRRCLS	TABLE	tables
SCRRCMP	TABLE	tables
SCRRCOL	TABLE	tables
SCRRDEG	TABLE	tables
SCRRLVL	TABLE	tables
SCRRMAJ	TABLE	tables
SCRRPRG	TABLE	tables
SCRRTRM	TABLE	tables
SCRRTST	TABLE	tables
SCRSBGI	TABLE	tables
SCRSCHD	TABLE	tables
SCRSECT	TABLE	tables
SCRSPRT	TABLE	tables
SCRSRDF	TABLE	tables
SCRSYLN	TABLE	tables
SCRSYLO	TABLE	tables
SCRSYRM	TABLE	tables
SCRSYTR	TABLE	tables
SCRTEXT	TABLE	tables
SHBGSCH	TABLE	links
SHRTCKN	TABLE	links
SHRTRCE	TABLE	links
SMBAGEN	TABLE	links
SMRALIB	TABLE	links
SMRPRLE	TABLE	links
SSBSECT	TABLE	links
SSRMEET	TABLE	links
STVAPRV	TABLE	links
STVATTR	TABLE	links
STVCAMP	TABLE	links
STVCCSL	TABLE	links
STVCIPC	TABLE	links
STVCLAS	TABLE	links
STVCOLL	TABLE	links
STVCSTA	TABLE	links
STVCUDA	TABLE	links
STVCUDB	TABLE	links
STVCUDC	TABLE	links
STVCUDD	TABLE	links
STVCUDE	TABLE	links
STVCUDF	TABLE	links
STVDEGC	TABLE	links
STVDEPT	TABLE	links
STVDIVS	TABLE	links
STVFTYP	TABLE	links
STVGMOD	TABLE	links
STVLEVL	TABLE	links
STVMAJR	TABLE	links
STVOCCS	TABLE	links
STVPWAV	TABLE	links
STVRDEF	TABLE	links
STVREPS	TABLE	links
STVRTRM	TABLE	links
STVSBGI	TABLE	links
STVSCHD	TABLE	links
STVTESC	TABLE	links
STVTOPS	TABLE	links
TBBDETC	TABLE	links

Comments

Model View

Table GTVDUNT

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

Table Columns informations

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
Server name MALDEV8_B60
Creation Date 02/17/2003 18:03:47:000

Table Columns informations

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 GTVPARS

Schema Name GENERAL
Server name MALDEV8_B60
Creation Date 06/11/2003 11:13:01:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL	PK	FK
GTVPARS_CODE	GTVPARS_CODE	VARCHAR2(7)	No	*
GTVPARS_DESC	GTVPARS_DESC	VARCHAR2(30)	No
GTVPARS_SCHEDULER_NUMBER	GTVPARS_SCHEDULER_NUMBER	NUMBER(2,0)	No
GTVPARS_USER_ID	GTVPARS_USER_ID	VARCHAR2(30)	No
GTVPARS_ACTIVITY_DATE	GTVPARS_ACTIVITY_DATE	DATE	No
GTVPARS_CAMP_CODE	GTVPARS_CAMP_CODE	VARCHAR2(3)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
GTVPARS_CAMP_CODE	STVCAMP_CODE	STVCAMP

Index

Index Name	Index Type	Column Name
PK_GTVPARS	Unique	GTVPARS_CODE

Comments

Source Code Comments

Validation entries for Partition codes. Partition Codes define campus zones, which are catagories or groupings of rooms.

Columns Comments for GTVPARS_CODE (1)

Source Code Comments

Partition code for campus zones for scheduling product.

Columns Comments for GTVPARS_DESC (2)

Source Code Comments

Description of partition code for scheduling product.

Columns Comments for GTVPARS_SCHEDULER_NUMBER (3)

Source Code Comments

Numeric identifying value for partition code for scheduling product.

Columns Comments for GTVPARS_USER_ID (4)

Source Code Comments

This field identifies the user wholast updated the record

Columns Comments for GTVPARS_ACTIVITY_DATE (5)

Source Code Comments

This field identifies the most recent date a record was created/updated

Columns Comments for GTVPARS_CAMP_CODE (6)

Source Code Comments

Campus code associated with partition for scheduling product.

Table SCBCDEP

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

Table Columns informations

Column Name	Label	Column Type	Allow NULL	FK
SCBCDEP_COLL_CODE	SCBCDEP_COLL_CODE	VARCHAR2(2)	No	*
SCBCDEP_DEPT_CODE	SCBCDEP_DEPT_CODE	VARCHAR2(4)	Yes	*
SCBCDEP_TERM_CODE_START	SCBCDEP_TERM_CODE_START	VARCHAR2(6)	No	*
SCBCDEP_TERM_CODE_END	SCBCDEP_TERM_CODE_END	VARCHAR2(6)	No	*
SCBCDEP_ACTIVITY_DATE	SCBCDEP_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SCBCDEP_COLL_CODE	STVCOLL_CODE	STVCOLL
SCBCDEP_DEPT_CODE	STVDEPT_CODE	STVDEPT

Index

Index Name	Index Type	Column Name
SCBCDEP_KEY_INDEX	Unique	SCBCDEP_COLL_CODE
SCBCDEP_KEY_INDEX	Unique	SCBCDEP_DEPT_CODE

Comments

Source Code Comments

College/Department Table

Columns Comments for SCBCDEP_COLL_CODE (1)

Source Code Comments

This field identifies the college code associated with the college/department test base record.

Columns Comments for SCBCDEP_DEPT_CODE (2)

Source Code Comments

This field identifies the department code associated with the college/department base record. Department code is optional.

Columns Comments for SCBCDEP_TERM_CODE_START (3)

Source Code Comments

This field identifies the From Term of the earliest version of the college/department text records.

Columns Comments for SCBCDEP_TERM_CODE_END (4)

Source Code Comments

This field identifies the To Term of the lastest version of the college/department text records.

Columns Comments for SCBCDEP_ACTIVITY_DATE (5)

Source Code Comments

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

Table SCBCDTL

Schema Name SATURN
Server name MALDEV8_B60
Creation Date 02/07/2003 10:05:51:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL	FK
SCBCDTL_COLL_CODE	SCBCDTL_COLL_CODE	VARCHAR2(2)	No	*
SCBCDTL_TERM_CODE_EFF	SCBCDTL_TERM_CODE_EFF	VARCHAR2(6)	No
SCBCDTL_ACTIVITY_DATE	SCBCDTL_ACTIVITY_DATE	DATE	No
SCBCDTL_USER_ID	SCBCDTL_USER_ID	VARCHAR2(30)	No
SCBCDTL_DEPT_CODE	SCBCDTL_DEPT_CODE	VARCHAR2(4)	Yes	*
SCBCDTL_TEXT_NARRATIVE	SCBCDTL_TEXT_NARRATIVE	CLOB	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SCBCDTL_COLL_CODE	STVCOLL_CODE	STVCOLL
SCBCDTL_DEPT_CODE	STVDEPT_CODE	STVDEPT

Index

Index Name	Index Type	Column Name
UK_SCBCDTL	Unique	SCBCDTL_COLL_CODE
UK_SCBCDTL	Unique	SCBCDTL_DEPT_CODE
UK_SCBCDTL	Unique	SCBCDTL_TERM_CODE_EFF

Comments

Source Code Comments

Course catalog description narrative text by college and department table

Columns Comments for SCBCDTL_COLL_CODE (1)

Source Code Comments

College code. This field indicates the college code of the course.

Columns Comments for SCBCDTL_TERM_CODE_EFF (2)

Source Code Comments

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

Columns Comments for SCBCDTL_ACTIVITY_DATE (3)

Source Code Comments

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

Columns Comments for SCBCDTL_USER_ID (4)

Source Code Comments

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

Columns Comments for SCBCDTL_DEPT_CODE (5)

Source Code Comments

Department Code. This field indicates the department code of the course. Text may be assigned to a course college only or a college and department.

Columns Comments for SCBCDTL_TEXT_NARRATIVE (6)

Source Code Comments

Course descriptive text is maintained here.

Table SCBCRKY

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

Table Columns informations

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
Server name MALDEV8_B60
Creation Date 06/23/2003 13:16:54:000

Table Columns informations

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 SCBDESC

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

Table Columns informations

Column Name	Label	Column Type	Allow NULL	FK
SCBDESC_SUBJ_CODE	SCBDESC_SUBJ_CODE	VARCHAR2(4)	No	*
SCBDESC_CRSE_NUMB	SCBDESC_CRSE_NUMB	VARCHAR2(5)	No
SCBDESC_TERM_CODE_EFF	SCBDESC_TERM_CODE_EFF	VARCHAR2(6)	No	*
SCBDESC_ACTIVITY_DATE	SCBDESC_ACTIVITY_DATE	DATE	No
SCBDESC_USER_ID	SCBDESC_USER_ID	VARCHAR2(30)	No
SCBDESC_TEXT_NARRATIVE	SCBDESC_TEXT_NARRATIVE	CLOB	Yes
SCBDESC_TERM_CODE_END	SCBDESC_TERM_CODE_END	VARCHAR2(6)	Yes	*

Foreign Key information

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

Index

Index Name	Index Type	Column Name
UK_SCBDESC	Unique	SCBDESC_SUBJ_CODE
UK_SCBDESC	Unique	SCBDESC_CRSE_NUMB
UK_SCBDESC	Unique	SCBDESC_TERM_CODE_EFF
UK_SCBDESC	Unique	SCBDESC_TERM_CODE_END

Comments

Source Code Comments

Course Catalog Description Narrative Text Table

Columns Comments for SCBDESC_SUBJ_CODE (1)

Source Code Comments

Subject code. This field indicates the subject code of the course.

Columns Comments for SCBDESC_CRSE_NUMB (2)

Source Code Comments

Course number. This field indicatesd the course number of the course.

Columns Comments for SCBDESC_TERM_CODE_EFF (3)

Source Code Comments

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

Columns Comments for SCBDESC_ACTIVITY_DATE (4)

Source Code Comments

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

Columns Comments for SCBDESC_USER_ID (5)

Source Code Comments

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

Columns Comments for SCBDESC_TEXT_NARRATIVE (6)

Source Code Comments

Course descriptive text is maintained here.

Columns Comments for SCBDESC_TERM_CODE_END (7)

Source Code Comments

End Term. Identifies the term that the course description effective term ends

Table SCBSUPP

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

Table Columns informations

Column Name	Label	Column Type	Allow NULL	PK	FK
SCBSUPP_SUBJ_CODE	SCBSUPP_SUBJ_CODE	VARCHAR2(4)	No	*	*
SCBSUPP_SUBJ_CODE	SCBSUPP_SUBJ_CODE	VARCHAR2(4)	No	*	*
SCBSUPP_CRSE_NUMB	SCBSUPP_CRSE_NUMB	VARCHAR2(5)	No	*	*
SCBSUPP_EFF_TERM	SCBSUPP_EFF_TERM	VARCHAR2(6)	No	*	*
SCBSUPP_TOPS_CODE	SCBSUPP_TOPS_CODE	VARCHAR2(6)	Yes		*
SCBSUPP_OCCS_CODE	SCBSUPP_OCCS_CODE	VARCHAR2(2)	Yes		*
SCBSUPP_CCSL_CODE	SCBSUPP_CCSL_CODE	VARCHAR2(2)	Yes		*
SCBSUPP_COOP_ED_IND	SCBSUPP_COOP_ED_IND	VARCHAR2(1)	Yes
SCBSUPP_ACTIVITY_DATE	SCBSUPP_ACTIVITY_DATE	DATE	No
SCBSUPP_PERM_DIST_IND	SCBSUPP_PERM_DIST_IND	VARCHAR2(12)	Yes
SCBSUPP_CUDA_CODE	SCBSUPP_CUDA_CODE	VARCHAR2(15)	Yes		*
SCBSUPP_CUDB_CODE	SCBSUPP_CUDB_CODE	VARCHAR2(15)	Yes		*
SCBSUPP_CUDC_CODE	SCBSUPP_CUDC_CODE	VARCHAR2(15)	Yes		*
SCBSUPP_CUDD_CODE	SCBSUPP_CUDD_CODE	VARCHAR2(15)	Yes		*
SCBSUPP_CUDE_CODE	SCBSUPP_CUDE_CODE	VARCHAR2(15)	Yes		*
SCBSUPP_CUDF_CODE	SCBSUPP_CUDF_CODE	VARCHAR2(15)	Yes		*
SCBSUPP_CREDIT_CATEGORY_IND	SCBSUPP_CREDIT_CATEGORY_IND	VARCHAR2(5)	Yes