Model STVSUBJ

Model Label : ERD for Banner Student STVSUBJ Table
Path : BANNER DEV/Student/Common/STVSUBJ/STVSUBJ_ERD

List of Objects

Object Name	Object Type	Layer Name
SCBCRKY	TABLE	Default
SCBCRSE	TABLE	Default
SCBDESC	TABLE	Default
SCBSUPP	TABLE	Default
SCRATTR	TABLE	Default
SCRCPRT	TABLE	Default
SCRCRDF	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
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
SDBSMUC	TABLE	Default
SDRCCNU	TABLE	Default
SDRCMSR	TABLE	Default
SDRSCAD	TABLE	Default
SDRSCAJ	TABLE	Default
SDRSCSB	TABLE	Default
SDRSSSR	TABLE	Default
SFRSRPO	TABLE	Default
SHBGSCH	TABLE	Default
SHRICMT	TABLE	Default
SHRRPEQ	TABLE	Default
SHRTATC	TABLE	Default
SHRTCKN	TABLE	Default
SHRTRAT	TABLE	Default
SHRTRCE	TABLE	Default
SHRTREP	TABLE	Default
SHRTRTA	TABLE	Default
SHRTRTK	TABLE	Default
SMRACAA	TABLE	Default
SMRAEXL	TABLE	Default
SMRAREX	TABLE	Default
SMRARSA	TABLE	Default
SMRARUL	TABLE	Default
SMRGCAA	TABLE	Default
SMRGEXL	TABLE	Default
SMRGREX	TABLE	Default
SMRGRSA	TABLE	Default
SMRGRUL	TABLE	Default
SMRPCRS	TABLE	Default
SMRPRSA	TABLE	Default
SMRSACA	TABLE	Default
SMRSACE	TABLE	Default
SMRSARE	TABLE	Default
SMRSARS	TABLE	Default
SMRSARU	TABLE	Default
SMRSGCA	TABLE	Default
SMRSGCE	TABLE	Default
SMRSGRE	TABLE	Default
SMRSGRS	TABLE	Default
SMRSGRU	TABLE	Default
SMRSPRS	TABLE	Default
SMRSTRG	TABLE	Default
SMRSWAV	TABLE	Default
SSBSECT	TABLE	Default
SSRRTST	TABLE	Default
SSTSCHW	TABLE	Default
STVSUBJ	TABLE	Default

Comments

Model View

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 SCRCPRT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SCRCPRT_SUBJ_CODE	SCRCPRT_SUBJ_CODE	VARCHAR2(4)	No	*
SCRCPRT_CRSE_NUMB	SCRCPRT_CRSE_NUMB	VARCHAR2(5)	No
SCRCPRT_TERM_CODE_EFF	SCRCPRT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SCRCPRT_ACTIVITY_DATE	SCRCPRT_ACTIVITY_DATE	DATE	No
SCRCPRT_USER_ID	SCRCPRT_USER_ID	VARCHAR2(30)	No
SCRCPRT_PARS_CODE	SCRCPRT_PARS_CODE	VARCHAR2(7)	Yes	*
SCRCPRT_PARS_PREF_NUMBER	SCRCPRT_PARS_PREF_NUMBER	NUMBER(2,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SCRCPRT_PARS_CODE	GTVPARS_CODE	GTVPARS
SCRCPRT_SUBJ_CODE	STVSUBJ_CODE	STVSUBJ
SCRCPRT_TERM_CODE_EFF	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
UK1_SCRCPRT	Unique	SCRCPRT_SUBJ_CODE
UK1_SCRCPRT	Unique	SCRCPRT_CRSE_NUMB
UK1_SCRCPRT	Unique	SCRCPRT_PARS_CODE
UK1_SCRCPRT	Unique	SCRCPRT_TERM_CODE_EFF

Comments

Source Code Comments

Partition Codes define campus zones, which are catagories or groupings of rooms. This table contains course partition codes in the catalog module.

Columns Comments for SCRCPRT_SUBJ_CODE (1)

Source Code Comments

Subject code for catalog course partitions.

Columns Comments for SCRCPRT_CRSE_NUMB (2)

Source Code Comments

Course Number for catalog course partitions.

Columns Comments for SCRCPRT_TERM_CODE_EFF (3)

Source Code Comments

Effective Term code for catalog course partition code.

Columns Comments for SCRCPRT_ACTIVITY_DATE (4)

Source Code Comments

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

Columns Comments for SCRCPRT_USER_ID (5)

Source Code Comments

User ID of last person to create/update record.

Columns Comments for SCRCPRT_PARS_CODE (6)

Source Code Comments

Partition code for catalog course entry.

Columns Comments for SCRCPRT_PARS_PREF_NUMBER (7)

Source Code Comments

Preference Number for Partition code for catalog course entry.

Table SCRCRDF

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SCRCRDF_SUBJ_CODE	SCRCRDF_SUBJ_CODE	VARCHAR2(4)	No	*
SCRCRDF_CRSE_NUMB	SCRCRDF_CRSE_NUMB	VARCHAR2(5)	No
SCRCRDF_TERM_CODE_EFF	SCRCRDF_TERM_CODE_EFF	VARCHAR2(6)	No	*
SCRCRDF_ACTIVITY_DATE	SCRCRDF_ACTIVITY_DATE	DATE	No
SCRCRDF_USER_ID	SCRCRDF_USER_ID	VARCHAR2(30)	No
SCRCRDF_RDEF_CODE	SCRCRDF_RDEF_CODE	VARCHAR2(4)	Yes	*
SCRCRDF_RDEF_PREF_NUMBER	SCRCRDF_RDEF_PREF_NUMBER	NUMBER(2,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SCRCRDF_SUBJ_CODE	STVSUBJ_CODE	STVSUBJ
SCRCRDF_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SCRCRDF_RDEF_CODE	STVRDEF_CODE	STVRDEF

Index

Index Name	Index Type	Column Name
UK1_SCRCRDF	Unique