Model Catalog

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

List of Objects

Object Name	Object Type	Layer Name
SCBCDEP	TABLE	Default
SCBCDTL	TABLE	Default
SCBCRKY	TABLE	Default
SCBCRSE	TABLE	Default
SCBDESC	TABLE	Default
SCBSUPP	TABLE	Default
SCRATTR	TABLE	Default
SCRCDTX	TABLE	Default
SCRCORQ	TABLE	Default
SCRCPRT	TABLE	Default
SCRCRDF	TABLE	Default
SCREQIV	TABLE	Default
SCRFEES	TABLE	Default
SCRGMOD	TABLE	Default
SCRLEVL	TABLE	Default
SCRRARE	TABLE	Default
SCRRCAM	TABLE	Default
SCRRCLS	TABLE	Default
SCRRCMP	TABLE	Default
SCRRCOL	TABLE	Default
SCRRDEG	TABLE	Default
SCRRLVL	TABLE	Default
SCRRMAJ	TABLE	Default
SCRRPRG	TABLE	Default
SCRRTRM	TABLE	Default
SCRRTST	TABLE	Default
SCRSBGI	TABLE	Default
SCRSCHD	TABLE	Default
SCRSECT	TABLE	Default
SCRSPRT	TABLE	Default
SCRSRDF	TABLE	Default
SCRSYLN	TABLE	Default
SCRSYLO	TABLE	Default
SCRSYRM	TABLE	Default
SCRSYTR	TABLE	Default
SCRTEXT	TABLE	Default

Comments

Model View

Table SCBCDEP

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

Table Columns information

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
Label SCBCDTL
Server name MALDEV8_B60
Creation Date 02/07/2003 10:05:51:000

Table Columns information

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
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 SCBDESC

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

Table Columns information

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
Label SCBSUPP
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
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

Foreign Key information

Column name	is Foreign Key For Column	on Table
SCBSUPP_CUDA_CODE	STVCUDA_CODE	STVCUDA
SCBSUPP_CUDB_CODE	STVCUDB_CODE	STVCUDB
SCBSUPP_CUDC_CODE	STVCUDC_CODE	STVCUDC
SCBSUPP_CUDD_CODE	STVCUDD_CODE	STVCUDD
SCBSUPP_CUDE_CODE	STVCUDE_CODE	STVCUDE
SCBSUPP_CUDF_CODE	STVCUDF_CODE	STVCUDF
SCBSUPP_TOPS_CODE	STVTOPS_CODE	STVTOPS
SCBSUPP_SUBJ_CODE	STVSUBJ_CODE	STVSUBJ
SCBSUPP_OCCS_CODE	STVOCCS_CODE	STVOCCS
SCBSUPP_SUBJ_CODE	SCBCRKY_SUBJ_CODE	SCBCRKY
SCBSUPP_CRSE_NUMB	SCBCRKY_CRSE_NUMB	SCBCRKY
SCBSUPP_EFF_TERM	STVTERM_CODE	STVTERM
SCBSUPP_CCSL_CODE	STVCCSL_CODE	STVCCSL

Index

Index Name	Index Type	Column Name
PK_SCBSUPP	Unique	SCBSUPP_SUBJ_CODE
PK_SCBSUPP	Unique	SCBSUPP_CRSE_NUMB
PK_SCBSUPP	Unique	SCBSUPP_EFF_TERM

Comments

Source Code Comments

Supplemental Course Data Table

Columns Comments for SCBSUPP_SUBJ_CODE (1)

Source Code Comments

This is the subject code from the scbcrse table. Combined with the course number

Columns Comments for SCBSUPP_CRSE_NUMB (2)

Source Code Comments

This is the course number from the scbcrse table. Combined with the subject code

Columns Comments for SCBSUPP_EFF_TERM (3)

Source Code Comments

This is the effective term. Combined with subject code and course number

Columns Comments for SCBSUPP_TOPS_CODE (4)

Source Code Comments

Taxonomy of Program code

Columns Comments for SCBSUPP_OCCS_CODE (5)

Source Code Comments

Occupational Course Indicator code

Columns Comments for SCBSUPP_CCSL_CODE (6)

Source Code Comments

Classification Code

Columns Comments for SCBSUPP_COOP_ED_IND (7)

Source Code Comments

Cooperative Education Indicator

Columns Comments for SCBSUPP_ACTIVITY_DATE (8)

Source Code Comments

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

Columns Comments for SCBSUPP_PERM_DIST_IND (9)

Source Code Comments

Permanent District Identifier

Columns Comments for SCBSUPP_CUDA_CODE (10)

Source Code Comments

Course Institutional Reporting Element 1 Code

Columns Comments for SCBSUPP_CUDB_CODE (11)

Source Code Comments

Course Institutional Reporting Element 2 Code

Columns Comments for SCBSUPP_CUDC_CODE (12)

Source Code Comments

Course Institutional Reporting Element 3 Code

Columns Comments for SCBSUPP_CUDD_CODE (13)

Source Code Comments

Course Institutional Reporting Element 4 Code

Columns Comments for SCBSUPP_CUDE_CODE (14)

Source Code Comments

Course Institutional Reporting Element 5 Code

Columns Comments for SCBSUPP_CUDF_CODE (15)

Source Code Comments

Course Institutional Reporting Element 6 Code.

Columns Comments for SCBSUPP_CREDIT_CATEGORY_IND (16)

Source Code Comments

Code for California MIS process for field CB22.

Table SCRATTR

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SCRATTR_SUBJ_CODE	SCRATTR_SUBJ_CODE	VARCHAR2(4)	No	*
SCRATTR_SUBJ_CODE	SCRATTR_SUBJ_CODE	VARCHAR2(4)	No	*
SCRATTR_CRSE_NUMB	SCRATTR_CRSE_NUMB	VARCHAR2(5)	No	*
SCRATTR_EFF_TERM	SCRATTR_EFF_TERM	VARCHAR2(6)	No	*
SCRATTR_ATTR_CODE	SCRATTR_ATTR_CODE	VARCHAR2(4)	Yes	*
SCRATTR_ACTIVITY_DATE	SCRATTR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SCRATTR_SUBJ_CODE	SCBCRKY_SUBJ_CODE	SCBCRKY
SCRATTR_CRSE_NUMB	SCBCRKY_CRSE_NUMB	SCBCRKY
SCRATTR_ATTR_CODE	STVATTR_CODE	STVATTR
SCRATTR_SUBJ_CODE	STVSUBJ_CODE	STVSUBJ
SCRATTR_EFF_TERM	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
SCRATTR_KEY_INDEX	Unique	SCRATTR_SUBJ_CODE
SCRATTR_KEY_INDEX	Unique	SCRATTR_CRSE_NUMB
SCRATTR_KEY_INDEX	Unique	SCRATTR_EFF_TERM
SCRATTR_KEY_INDEX	Unique	SCRATTR_ATTR_CODE

Comments

Source Code Comments

Course Attribute Repeating Table

Columns Comments for SCRATTR_SUBJ_CODE (1)

Source Code Comments

This field defines the subject area of the course

Columns Comments for SCRATTR_CRSE_NUMB (2)

Source Code Comments

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

Columns Comments for SCRATTR_EFF_TERM (3)

Source Code Comments

This field identifies the term this version of the course attributes become effective

Columns Comments for SCRATTR_ATTR_CODE (4)

Source Code Comments

This field defines the attribute code of the course

Columns Comments for SCRATTR_ACTIVITY_DATE (5)

Source Code Comments

This field identifies the date the record was created or updated

Table SCRCDTX

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SCRCDTX_COLL_CODE	SCRCDTX_COLL_CODE	VARCHAR2(2)	No	*
SCRCDTX_DEPT_CODE	SCRCDTX_DEPT_CODE	VARCHAR2(4)	Yes	*
SCRCDTX_EFF_TERM	SCRCDTX_EFF_TERM	VARCHAR2(6)	No	*
SCRCDTX_SEQNO	SCRCDTX_SEQNO	NUMBER(23,20)	Yes
SCRCDTX_TEXT	SCRCDTX_TEXT	VARCHAR2(60)	Yes
SCRCDTX_TEXT_CODE	SCRCDTX_TEXT_CODE	VARCHAR2(1)	Yes
SCRCDTX_ACTIVITY_DATE	SCRCDTX_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SCRCDTX_COLL_CODE	STVCOLL_CODE	STVCOLL
SCRCDTX_DEPT_CODE	STVDEPT_CODE	STVDEPT
SCRCDTX_EFF_TERM	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
SCRCDTX_KEY_INDEX		SCRCDTX_COLL_CODE
SCRCDTX_KEY_INDEX		SCRCDTX_DEPT_CODE
SCRCDTX_KEY_INDEX		SCRCDTX_EFF_TERM
SCRCDTX_KEY_INDEX		SCRCDTX_SEQNO

Comments

Source Code Comments

College/Department Text Table

Columns Comments for SCRCDTX_COLL_CODE (1)

Source Code Comments

This field identifies the college code associated with the text.

Columns Comments for SCRCDTX_DEPT_CODE (2)

Source Code Comments

This field identifies the department code associated with the text. This field is optional.

Columns Comments for SCRCDTX_EFF_TERM (3)

Source Code Comments

This field identifies the term this version of the college/department text becomes effective.

Columns Comments for SCRCDTX_SEQNO (4)

Source Code Comments

This field identifies the internal sequence number associated with the line of text. Does not display on form.

Columns Comments for SCRCDTX_TEXT (5)

Source Code Comments

This field is used to enter or display college or college/department text. Each line is an individual record and an unlimited number of records may be maintained. No word processing functions are provided.

Columns Comments for SCRCDTX_TEXT_CODE (6)

Source Code Comments

This field is used to internally resequence text when a new line has been added. Valid value is: "A".

Columns Comments for SCRCDTX_ACTIVITY_DATE (7)

Source Code Comments

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

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 SCRCPRT

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