Model Shared or Cross Module

Model Label : ERD For Banner Student Shared or Cross Module ( SO% Tables )
Path : BANNER DEV/Student/Cross_Module/Shared or Cross Module

List of Objects

Object Name	Object Type	Layer Name
SOBCALD	TABLE	Tables
SOBCNVT	TABLE	Tables
SOBCPLN	TABLE	Tables
SOBCTRL	TABLE	Tables
SOBCURR	TABLE	Tables
SOBMATL	TABLE	Tables
SOBODTE	TABLE	Tables
SOBPROF	TABLE	Tables
SOBPTRM	TABLE	Tables
SOBROLE	TABLE	Tables
SOBSBGI	TABLE	Tables
SOBSEQN	TABLE	Tables
SOBTEQU	TABLE	Tables
SOBTERM	TABLE	Tables
SORADAS	TABLE	Tables
SORADDA	TABLE	Tables
SORAINF	TABLE	Tables
SORAPPT	TABLE	Tables
SORAROL	TABLE	Tables
SORATRM	TABLE	Tables
SORBACD	TABLE	Tables
SORBCHR	TABLE	Tables
SORBCMT	TABLE	Tables
SORBCNT	TABLE	Tables
SORBDEG	TABLE	Tables
SORBDMO	TABLE	Tables
SORBDPL	TABLE	Tables
SORBETH	TABLE	Tables
SORBTAC	TABLE	Tables
SORBTAG	TABLE	Tables
SORBTAI	TABLE	Tables
SORBTAL	TABLE	Tables
SORBTAP	TABLE	Tables
SORBTST	TABLE	Tables
SORCCOL	TABLE	Tables
SORCCON	TABLE	Tables
SORCGRP	TABLE	Tables
SORCMJR	TABLE	Tables
SORCMNR	TABLE	Tables
SORCOMM	TABLE	Tables
SORCONC	TABLE	Tables
SORCONT	TABLE	Tables
SORCRSS	TABLE	Tables
SORCTRM	TABLE	Tables
SORDEGR	TABLE	Tables
SORDPMR	TABLE	Tables
SORELTL	TABLE	Tables
SORELTR	TABLE	Tables
SOREPSC	TABLE	Tables
SOREQUI	TABLE	Tables
SOREXTN	TABLE	Tables
SORFADR	TABLE	Tables
SORFAPC	TABLE	Tables
SORFOLK	TABLE	Tables
SORFRYR	TABLE	Tables
SORGEOR	TABLE	Tables
SORGPAT	TABLE	Tables
SORHSBJ	TABLE	Tables
SORHSCH	TABLE	Tables
SORINFR	TABLE	Tables
SORINTS	TABLE	Tables
SORMADM	TABLE	Tables
SORMAJR	TABLE	Tables
SORMAPD	TABLE	Tables
SORMAPS	TABLE	Tables
SORMATT	TABLE	Tables
SORMCNT	TABLE	Tables
SORMCRL	TABLE	Tables
SORMCTZ	TABLE	Tables
SORMDPT	TABLE	Tables
SORMEPS	TABLE	Tables
SORMETH	TABLE	Tables
SORMGEO	TABLE	Tables
SORMINR	TABLE	Tables
SORMINT	TABLE	Tables
SORMLGY	TABLE	Tables
SORMMJR	TABLE	Tables
SORMRTY	TABLE	Tables
SORMSEX	TABLE	Tables
SORMSRC	TABLE	Tables
SORMSTA	TABLE	Tables
SORMSTY	TABLE	Tables
SORMTES	TABLE	Tables
SORNAME	TABLE	Tables
SORPCOL	TABLE	Tables
SORPLNG	TABLE	Tables
SORPLNM	TABLE	Tables
SORRFND	TABLE	Tables
SORRSTS	TABLE	Tables
SORRTRM	TABLE	Tables
SORT22A	TABLE	Tables
SORTBRK	TABLE	Tables
SORTEST	TABLE	Tables
SORWDSP	TABLE	Tables
SORWDSP_TEMP	TABLE	Tables
SORXREF	TABLE	Tables
SORXREF_TEMP	TABLE	Tables
SOTHSCH	TABLE	Tables
SOTINFR	TABLE	Tables
SOTINTS	TABLE	Tables
SOTPCOL	TABLE	Tables
SOTPRNT	TABLE	Tables
SOTTEST	TABLE	Tables
SOTWADA	TABLE	Tables
SOTWADE	TABLE	Tables
SOTWENR	TABLE	Tables
SOTWGRE	TABLE	Tables
SOTWREG	TABLE	Tables

Comments

Model View

Table SOBCALD

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SOBCALD_YEAR	SOBCALD_YEAR	NUMBER(4,0)	No	*
SOBCALD_CAMP_CODE	SOBCALD_CAMP_CODE	VARCHAR2(3)	No	*	*
SOBCALD_DATE	SOBCALD_DATE	DATE	No	*
SOBCALD_ACTIVITY_DATE	SOBCALD_ACTIVITY_DATE	DATE	No
SOBCALD_DAYT_CODE	SOBCALD_DAYT_CODE	VARCHAR2(4)	Yes		*
SOBCALD_ATRA_CODE	SOBCALD_ATRA_CODE	VARCHAR2(4)	Yes		*
SOBCALD_ATRB_CODE	SOBCALD_ATRB_CODE	VARCHAR2(4)	Yes		*
SOBCALD_ATRC_CODE	SOBCALD_ATRC_CODE	VARCHAR2(4)	Yes		*
SOBCALD_ATRD_CODE	SOBCALD_ATRD_CODE	VARCHAR2(4)	Yes		*
SOBCALD_ATRE_CODE	SOBCALD_ATRE_CODE	VARCHAR2(4)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SOBCALD_ATRA_CODE	STVATRA_CODE	STVATRA
SOBCALD_ATRB_CODE	STVATRB_CODE	STVATRB
SOBCALD_ATRC_CODE	STVATRC_CODE	STVATRC
SOBCALD_ATRD_CODE	STVATRD_CODE	STVATRD
SOBCALD_ATRE_CODE	STVATRE_CODE	STVATRE
SOBCALD_CAMP_CODE	STVCAMP_CODE	STVCAMP
SOBCALD_DAYT_CODE	STVDAYT_CODE	STVDAYT

Index

Index Name	Index Type	Column Name
PK_SOBCALD	Unique	SOBCALD_YEAR
PK_SOBCALD	Unique	SOBCALD_CAMP_CODE
PK_SOBCALD	Unique	SOBCALD_DATE

Comments

Source Code Comments

College Calendar Day Information Table

Columns Comments for SOBCALD_YEAR (1)

Source Code Comments

Calendar Year Code

Columns Comments for SOBCALD_CAMP_CODE (2)

Source Code Comments

Campus Code

Columns Comments for SOBCALD_DATE (3)

Source Code Comments

Calendar Date

Columns Comments for SOBCALD_ACTIVITY_DATE (4)

Source Code Comments

The Activity Date

Columns Comments for SOBCALD_DAYT_CODE (5)

Source Code Comments

Day Type Code

Columns Comments for SOBCALD_ATRA_CODE (6)

Source Code Comments

Day Attribute One Code.

Columns Comments for SOBCALD_ATRB_CODE (7)

Source Code Comments

Day Attribute Two Code.

Columns Comments for SOBCALD_ATRC_CODE (8)

Source Code Comments

Day Attribute Three Code.

Columns Comments for SOBCALD_ATRD_CODE (9)

Source Code Comments

Day Attribute Four Code.

Columns Comments for SOBCALD_ATRE_CODE (10)

Source Code Comments

Day Attribute Five Code.

Table SOBCNVT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SOBCNVT_INFC_CODE	SOBCNVT_INFC_CODE	VARCHAR2(4)	No	*	*
SOBCNVT_TNAME	SOBCNVT_TNAME	VARCHAR2(4)	No	*
SOBCNVT_TAPE_CODE	SOBCNVT_TAPE_CODE	VARCHAR2(11)	No	*
SOBCNVT_CONV_CODE	SOBCNVT_CONV_CODE	VARCHAR2(11)	No
SOBCNVT_ACTIVITY_DATE	SOBCNVT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SOBCNVT_INFC_CODE	STVINFC_CODE	STVINFC

Index

Index Name	Index Type	Column Name
PK_SOBCNVT	Unique	SOBCNVT_INFC_CODE
PK_SOBCNVT	Unique	SOBCNVT_TNAME
PK_SOBCNVT	Unique	SOBCNVT_TAPE_CODE
SOBCNVT_KEY_INDEX1		SOBCNVT_INFC_CODE
SOBCNVT_KEY_INDEX1		SOBCNVT_TNAME

Comments

Source Code Comments

Tape Code Conversion Base Table

Columns Comments for SOBCNVT_INFC_CODE (1)

Source Code Comments

This field identifies the interface type code, ie. SAT, GRE, etc.

Columns Comments for SOBCNVT_TNAME (2)

Source Code Comments

This field identifies the last four positions of the Banner validation form used to convert tape values.

Columns Comments for SOBCNVT_TAPE_CODE (3)

Source Code Comments

This field identifies the value from the particular tape you wish to convert to a Banner validation form value.

Columns Comments for SOBCNVT_CONV_CODE (4)

Source Code Comments

This field identifies the Banner validation form value you are converting the associated "tape value" to.

Columns Comments for SOBCNVT_ACTIVITY_DATE (5)

Source Code Comments

This field identifies the last date the SOBCNVT record was updated.

Table SOBCPLN

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SOBCPLN_PIDM	SOBCPLN_PIDM	NUMBER(8,0)	No
SOBCPLN_TYPE_IND	SOBCPLN_TYPE_IND	VARCHAR2(1)	No
SOBCPLN_TERM_CODE	SOBCPLN_TERM_CODE	VARCHAR2(6)	Yes	*
SOBCPLN_SEQNO	SOBCPLN_SEQNO	NUMBER(2,0)	Yes
SOBCPLN_CPLN_CODE	SOBCPLN_CPLN_CODE	VARCHAR2(4)	No	*
SOBCPLN_ACTIVE_IND	SOBCPLN_ACTIVE_IND	VARCHAR2(1)	No
SOBCPLN_ACTIVITY_DATE	SOBCPLN_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SOBCPLN_CPLN_CODE	STVCPLN_CODE	STVCPLN
SOBCPLN_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
SOBCPLN_KEY_INDEX		SOBCPLN_PIDM
SOBCPLN_KEY_INDEX		SOBCPLN_TYPE_IND

Comments

Source Code Comments

Communication Plan Assignment Base Table

Columns Comments for SOBCPLN_PIDM (1)

Source Code Comments

Internal identification number of prospect, applicant or student.

Columns Comments for SOBCPLN_TYPE_IND (2)

Source Code Comments

Type of communication plan: (R)ecruiting, (A)dmissions, (S)tudent.

Columns Comments for SOBCPLN_TERM_CODE (3)

Source Code Comments

Term code associated with recruiting record or application.

Columns Comments for SOBCPLN_SEQNO (4)

Source Code Comments

Sequence number associated with recruiting record or application.

Columns Comments for SOBCPLN_CPLN_CODE (5)

Source Code Comments

Communication plan code assigned to prospect, applicant or student.

Columns Comments for SOBCPLN_ACTIVE_IND (6)

Source Code Comments

Indicates whether communication plan is active (Y) or inactive (N).

Columns Comments for SOBCPLN_ACTIVITY_DATE (7)

Source Code Comments

The date the record was created or last updated.

Table SOBCTRL

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

Table Columns information

Column Name	Label	Column Type	Allow NULL
SOBCTRL_CURR_RULE_IND	SOBCTRL_CURR_RULE_IND	VARCHAR2(1)	No
SOBCTRL_PROGRAM_IND	SOBCTRL_PROGRAM_IND	VARCHAR2(1)	No
SOBCTRL_CONC_IND	SOBCTRL_CONC_IND	VARCHAR2(1)	No
SOBCTRL_PRIM_ROLL_IND	SOBCTRL_PRIM_ROLL_IND	VARCHAR2(1)	No
SOBCTRL_SECD_ROLL_IND	SOBCTRL_SECD_ROLL_IND	VARCHAR2(1)	No
SOBCTRL_REC_ERRLVL_IND	SOBCTRL_REC_ERRLVL_IND	VARCHAR2(1)	No
SOBCTRL_ADM_ERRLVL_IND	SOBCTRL_ADM_ERRLVL_IND	VARCHAR2(1)	No
SOBCTRL_STU_ERRLVL_IND	SOBCTRL_STU_ERRLVL_IND	VARCHAR2(1)	No
SOBCTRL_HIS_ERRLVL_IND	SOBCTRL_HIS_ERRLVL_IND	VARCHAR2(1)	No
SOBCTRL_DAU_ERRLVL_IND	SOBCTRL_DAU_ERRLVL_IND	VARCHAR2(1)	No
SOBCTRL_ACTIVITY_DATE	SOBCTRL_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

No Result

Comments

Source Code Comments

Curriculum Rules Control Table.

Columns Comments for SOBCTRL_CURR_RULE_IND (1)

Source Code Comments

Indicates whether Curriculum Rules are in Use.

Columns Comments for SOBCTRL_PROGRAM_IND (2)

Source Code Comments

Indicates whether Degree Audit is in use.

Columns Comments for SOBCTRL_CONC_IND (3)

Source Code Comments

Indicates whether Concentrations Must be Tied to Major/Department Rules.

Columns Comments for SOBCTRL_PRIM_ROLL_IND (4)

Source Code Comments

Default value for Rolling Primary Curriculum.

Columns Comments for SOBCTRL_SECD_ROLL_IND (5)

Source Code Comments

Default value for Rolling Secondary Curriculum.

Columns Comments for SOBCTRL_REC_ERRLVL_IND (6)

Source Code Comments

Recruiting Module Curriculum Error Level.

Columns Comments for SOBCTRL_ADM_ERRLVL_IND (7)

Source Code Comments

Admissions Module Curriculum Error Level.

Columns Comments for SOBCTRL_STU_ERRLVL_IND (8)

Source Code Comments

Student Module Curriculum Error Level.

Columns Comments for SOBCTRL_HIS_ERRLVL_IND (9)

Source Code Comments

Academic History Module Curriculum Error Level.

Columns Comments for SOBCTRL_DAU_ERRLVL_IND (10)

Source Code Comments

Degree Audit Module Curriculum Error Level.

Columns Comments for SOBCTRL_ACTIVITY_DATE (11)

Source Code Comments

Date of Last Modification of Record.

Table SOBCURR

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SOBCURR_CURR_RULE	SOBCURR_CURR_RULE	NUMBER(8,0)	No	*
SOBCURR_TERM_CODE_INIT	SOBCURR_TERM_CODE_INIT	VARCHAR2(6)	No		*
SOBCURR_LEVL_CODE	SOBCURR_LEVL_CODE	VARCHAR2(2)	No		*
SOBCURR_LEVL_CODE	SOBCURR_LEVL_CODE	VARCHAR2(2)	No		*
SOBCURR_ACTIVITY_DATE	SOBCURR_ACTIVITY_DATE	DATE	No
SOBCURR_PRIM_ROLL_IND	SOBCURR_PRIM_ROLL_IND	VARCHAR2(1)	No
SOBCURR_SECD_ROLL_IND	SOBCURR_SECD_ROLL_IND	VARCHAR2(1)	No
SOBCURR_LOCK_IND	SOBCURR_LOCK_IND	VARCHAR2(1)	No
SOBCURR_CAMP_CODE	SOBCURR_CAMP_CODE	VARCHAR2(3)	Yes		*
SOBCURR_COLL_CODE	SOBCURR_COLL_CODE	VARCHAR2(2)	Yes		*
SOBCURR_DEGC_CODE	SOBCURR_DEGC_CODE	VARCHAR2(6)	Yes		*
SOBCURR_PROGRAM	SOBCURR_PROGRAM	VARCHAR2(12)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SOBCURR_COLL_CODE	STVCOLL_CODE	STVCOLL
SOBCURR_DEGC_CODE	STVDEGC_CODE	STVDEGC
SOBCURR_CAMP_CODE	STVCAMP_CODE	STVCAMP
SOBCURR_LEVL_CODE	STVLEVL_CODE	STVLEVL
SOBCURR_TERM_CODE_INIT	STVTERM_CODE	STVTERM
SOBCURR_PROGRAM	SMRPRLE_PROGRAM	SMRPRLE
SOBCURR_LEVL_CODE	STVWAPP_LEVL_CODE	STVWAPP

Index

Index Name	Index Type	Column Name
PK_SOBCURR	Unique	SOBCURR_CURR_RULE
SOBCURR_KEY_INDEX	Unique	SOBCURR_LEVL_CODE
SOBCURR_KEY_INDEX	Unique	SOBCURR_CAMP_CODE
SOBCURR_KEY_INDEX	Unique	SOBCURR_COLL_CODE
SOBCURR_KEY_INDEX	Unique	SOBCURR_DEGC_CODE
SOBCURR_KEY_INDEX	Unique	SOBCURR_PROGRAM

Comments

Source Code Comments

Curriculum Base Rules.

Columns Comments for SOBCURR_CURR_RULE (1)

Source Code Comments

Base Curriculum Rule Reference

Columns Comments for SOBCURR_TERM_CODE_INIT (2)

Source Code Comments

Initial Term Associated with the Base Curriculum Rule

Columns Comments for SOBCURR_LEVL_CODE (3)

Source Code Comments

Base Curriculum Level Code

Columns Comments for SOBCURR_ACTIVITY_DATE (4)

Source Code Comments

Date of Last Base Curriculum Rule Update

Columns Comments for SOBCURR_PRIM_ROLL_IND (5)

Source Code Comments

Indicator Controlling Primary Curriculum Roll to History

Columns Comments for SOBCURR_SECD_ROLL_IND (6)

Source Code Comments

Indicator Controlling secondary Curriculum Roll to History

Columns Comments for SOBCURR_LOCK_IND (7)

Source Code Comments

Indicator Controlling updates to Base Curriculum

Columns Comments for SOBCURR_CAMP_CODE (8)

Source Code Comments

Base Curriculum Campus Code

Columns Comments for SOBCURR_COLL_CODE (9)

Source Code Comments

Base Curriculum College Code

Columns Comments for SOBCURR_DEGC_CODE (10)

Source Code Comments

Base Curriculum Degree Code

Columns Comments for SOBCURR_PROGRAM (11)

Source Code Comments

Base Curriculum Program Code

Table SOBMATL

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SOBMATL_MATL_CODE	SOBMATL_MATL_CODE	VARCHAR2(4)	No	*	*
SOBMATL_MATL_CODE	SOBMATL_MATL_CODE	VARCHAR2(4)	No	*	*
SOBMATL_MATL_CODE	SOBMATL_MATL_CODE	VARCHAR2(4)	No	*	*
SOBMATL_PUB_GEN_IND	SOBMATL_PUB_GEN_IND	VARCHAR2(1)	No
SOBMATL_LETR_CODE	SOBMATL_LETR_CODE	VARCHAR2(15)	Yes		*
SOBMATL_INIT_CODE	SOBMATL_INIT_CODE	VARCHAR2(4)	Yes		*
SOBMATL_INIT_OVERRIDE_IND	SOBMATL_INIT_OVERRIDE_IND	VARCHAR2(1)	Yes
SOBMATL_DUPL_IND	SOBMATL_DUPL_IND	VARCHAR2(1)	No
SOBMATL_ACTIVITY_DATE	SOBMATL_ACTIVITY_DATE	DATE	No
SOBMATL_DPMR_CODE	SOBMATL_DPMR_CODE	VARCHAR2(4)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SOBMATL_LETR_CODE	GTVLETR_CODE	GTVLETR
SOBMATL_DPMR_CODE	STVDPMR_CODE	STVDPMR
SOBMATL_MATL_CODE	STVMATL_CODE	STVMATL
SOBMATL_INIT_CODE	STVINIT_CODE	STVINIT
SOBMATL_MATL_CODE	SORPLNM_MATL_CODE	SORPLNM
SOBMATL_MATL_CODE	SORCGRP_MATL_CODE	SORCGRP

Index

Index Name	Index Type	Column Name
PK_SOBMATL	Unique	SOBMATL_MATL_CODE

Comments

Source Code Comments

Material Base Table

Columns Comments for SOBMATL_MATL_CODE (1)

Source Code Comments

Material Code

Columns Comments for SOBMATL_PUB_GEN_IND (2)

Source Code Comments

Identifies whether material is published (preprinted) or system generated (letters).

Columns Comments for SOBMATL_LETR_CODE (3)

Source Code Comments

The type of letter to be generated by the system.

Columns Comments for SOBMATL_INIT_CODE (4)

Source Code Comments

The signature block to be used for system generated material.

Columns Comments for SOBMATL_INIT_OVERRIDE_IND (5)

Source Code Comments

Permits override of designated signature for system generated material.

Columns Comments for SOBMATL_DUPL_IND (6)

Source Code Comments

Allow duplicate entries on the mail form (Y/N).

Columns Comments for SOBMATL_ACTIVITY_DATE (7)

Source Code Comments

The date the record was created or last updated.

Columns Comments for SOBMATL_DPMR_CODE (8)

Source Code Comments

Duplicate materials rule code.

Table SOBODTE

Schema Name SATURN
Label SOBODTE
Server name MALDEV8_B60
Creation Date 10/30/2002 11:48:50:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SOBODTE_TERM_CODE	SOBODTE_TERM_CODE	VARCHAR2(6)	No	*
SOBODTE_INSM_CODE	SOBODTE_INSM_CODE	VARCHAR2(5)	No	*
SOBODTE_REG_START_DATE	SOBODTE_REG_START_DATE	DATE	No
SOBODTE_REG_END_DATE	SOBODTE_REG_END_DATE	DATE	No
SOBODTE_CENSUS_DATE_ONE	SOBODTE_CENSUS_DATE_ONE	DATE	No
SOBODTE_OVERRIDE_IND	SOBODTE_OVERRIDE_IND	VARCHAR2(1)	No
SOBODTE_ACTIVITY_DATE	SOBODTE_ACTIVITY_DATE	DATE	No
SOBODTE_USER_ID	SOBODTE_USER_ID	VARCHAR2(30)	No
SOBODTE_DEPT_CODE	SOBODTE_DEPT_CODE	VARCHAR2(4)	Yes	*
SOBODTE_CAMP_CODE	SOBODTE_CAMP_CODE	VARCHAR2(3)	Yes	*
SOBODTE_COLL_CODE	SOBODTE_COLL_CODE	VARCHAR2(2)	Yes	*
SOBODTE_SCHD_CODE	SOBODTE_SCHD_CODE	VARCHAR2(3)	Yes	*
SOBODTE_CENSUS_DATE_TWO	SOBODTE_CENSUS_DATE_TWO	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SOBODTE_INSM_CODE	GTVINSM_CODE	GTVINSM
SOBODTE_CAMP_CODE	STVCAMP_CODE	STVCAMP
SOBODTE_COLL_CODE	STVCOLL_CODE	STVCOLL
SOBODTE_DEPT_CODE	STVDEPT_CODE	STVDEPT
SOBODTE_SCHD_CODE	STVSCHD_CODE	STVSCHD
SOBODTE_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
UK_SOBODTE	Unique	SOBODTE_TERM_CODE
UK_SOBODTE	Unique	SOBODTE_INSM_CODE
UK_SOBODTE	Unique	SOBODTE_DEPT_CODE
UK_SOBODTE	Unique	SOBODTE_CAMP_CODE
UK_SOBODTE	Unique	SOBODTE_COLL_CODE
UK_SOBODTE	Unique	SOBODTE_SCHD_CODE

Comments

Source Code Comments

Open Learning Registration Date Default table

Columns Comments for SOBODTE_TERM_CODE (1)

Source Code Comments

Term code: Indicates the term that the rule applies to

Columns Comments for SOBODTE_INSM_CODE (2)

Source Code Comments

Instructional method code: Indicates the instructional method code assigned to the rule

Columns Comments for SOBODTE_REG_START_DATE (3)

Source Code Comments

Registration start date: Indicates the first date that registration will be open to the learner

Columns Comments for SOBODTE_REG_END_DATE (4)

Source Code Comments

Registration end Date: Indicates the last date that registrations will be accepted for this section

Columns Comments for SOBODTE_CENSUS_DATE_ONE (5)

Source Code Comments

Census date one: This field indicates the census date for the rule. It defaults to the section when the new section (SSBSECT) is created.

Columns Comments for SOBODTE_OVERRIDE_IND (6)

Source Code Comments

Override Indicator: This field defines whether or not the user will be allowed to change the start and end dates established in the rule when creating new sections.

Columns Comments for SOBODTE_ACTIVITY_DATE (7)

Source Code Comments

Activity date: Date this record entered or last updated

Columns Comments for SOBODTE_USER_ID (8)

Source Code Comments

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

Columns Comments for SOBODTE_DEPT_CODE (9)

Source Code Comments

Department code: Indicates the course department code assigned to the rule

Columns Comments for SOBODTE_CAMP_CODE (10)

Source Code Comments

Campus code: Indicates the course campus code assigned to the rule

Columns Comments for SOBODTE_COLL_CODE (11)

Source Code Comments

College code: Indicates the course college code assigned to the rule

Columns Comments for SOBODTE_SCHD_CODE (12)

Source Code Comments

Schedule type code: Indicates the course schedule type code assigned to the rule

Columns Comments for SOBODTE_CENSUS_DATE_TWO (13)

Source Code Comments

Census date two: This field indicates the second census date for the rule. It defaults to the section when the new section (SSBSECT) is created.

Table SOBPROF

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SOBPROF_USERID	SOBPROF_USERID	VARCHAR2(30)	No	*
SOBPROF_CAMP_CODE	SOBPROF_CAMP_CODE	VARCHAR2(3)	No		*
SOBPROF_ACTIVITY_DATE	SOBPROF_ACTIVITY_DATE	DATE	No

Foreign Key information

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

Index

Index Name	Index Type	Column Name
PK_SOBPROF	Unique	SOBPROF_USERID

Comments

Source Code Comments

Campus Security Table

Columns Comments for SOBPROF_USERID (1)

Source Code Comments

Userid at signon.

Columns Comments for SOBPROF_CAMP_CODE (2)

Source Code Comments

Campus which has query and update capability for userid at signon. No campus record will cause user to have permission for all campuses.

Columns Comments for SOBPROF_ACTIVITY_DATE (3)

Source Code Comments

The date the record was created or last updated

Table SOBPTRM

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SOBPTRM_TERM_CODE	SOBPTRM_TERM_CODE	VARCHAR2(6)	No	*	*
SOBPTRM_TERM_CODE	SOBPTRM_TERM_CODE	VARCHAR2(6)	No	*	*
SOBPTRM_TERM_CODE	SOBPTRM_TERM_CODE	VARCHAR2(6)	No	*	*
SOBPTRM_PTRM_CODE	SOBPTRM_PTRM_CODE	VARCHAR2(3)	No	*	*
SOBPTRM_PTRM_CODE	SOBPTRM_PTRM_CODE	VARCHAR2(3)	No	*	*
SOBPTRM_DESC	SOBPTRM_DESC	VARCHAR2(30)	No
SOBPTRM_START_DATE	SOBPTRM_START_DATE	DATE	Yes
SOBPTRM_END_DATE	SOBPTRM_END_DATE	DATE	Yes
SOBPTRM_REG_ALLOWED	SOBPTRM_REG_ALLOWED	VARCHAR2(1)	Yes
SOBPTRM_WEEKS	SOBPTRM_WEEKS	NUMBER(3,0)	Yes
SOBPTRM_CENSUS_DATE	SOBPTRM_CENSUS_DATE	DATE	Yes
SOBPTRM_ACTIVITY_DATE	SOBPTRM_ACTIVITY_DATE	DATE	No
SOBPTRM_SECT_OVER_IND	SOBPTRM_SECT_OVER_IND	VARCHAR2(1)	Yes
SOBPTRM_CENSUS_2_DATE	SOBPTRM_CENSUS_2_DATE	DATE	Yes
SOBPTRM_MGRD_WEB_UPD_IND	SOBPTRM_MGRD_WEB_UPD_IND	VARCHAR2(1)	No
SOBPTRM_FGRD_WEB_UPD_IND	SOBPTRM_FGRD_WEB_UPD_IND	VARCHAR2(1)	No
SOBPTRM_WAITLST_WEB_DISP_IND	SOBPTRM_WAITLST_WEB_DISP_IND	VARCHAR2(1)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SOBPTRM_PTRM_CODE	STVPTRM_CODE	STVPTRM
SOBPTRM_TERM_CODE	STVTERM_CODE	STVTERM
SOBPTRM_TERM_CODE	SOBTERM_TERM_CODE	SOBTERM
SOBPTRM_TERM_CODE	SFRSTCR_TERM_CODE	SFRSTCR
SOBPTRM_PTRM_CODE	SFRSTCR_PTRM_CODE	SFRSTCR

Index

Index Name	Index Type	Column Name
PK_SOBPTRM	Unique	SOBPTRM_TERM_CODE
PK_SOBPTRM	Unique	SOBPTRM_PTRM_CODE

Comments

Source Code Comments

Section Part-of-Term Validation Table

Columns Comments for SOBPTRM_TERM_CODE (1)

Source Code Comments

This field identifies the term code associated with the entries on the Term Control Form (SOATERM).

Columns Comments for SOBPTRM_PTRM_CODE (2)

Source Code Comments

This field identifies the Part of Term Code for the Term in the Key Block of the Term Control Form (SOATERM). At least one Part of Term Code must have a value of 1-Full Term.

Columns Comments for SOBPTRM_DESC (3)

Source Code Comments

This field identifies the description for the Part of Term Code in the Base Part of Term Block.

Columns Comments for SOBPTRM_START_DATE (4)

Source Code Comments

This field identifies the calender start date for the Part of Term in the Base Part of Term Block.

Columns Comments for SOBPTRM_END_DATE (5)

Source Code Comments

This field identifies the calender end date for the Part of Term in the Base Part of Term Block.

Columns Comments for SOBPTRM_REG_ALLOWED (6)

Source Code Comments

This field identifies whether on-line registration is allowed for the Part of Term. This field is not displayed.

Columns Comments for SOBPTRM_WEEKS (7)

Source Code Comments

This field indicates the number of weeks for the Part of Term on the Term Control Form (SOATERM).

Columns Comments for SOBPTRM_CENSUS_DATE (8)

Source Code Comments

This field indicates the census date for the Part of Term Code. This date controls how the census date field on the Schedule Form (SSASECT) is updated.

Columns Comments for SOBPTRM_ACTIVITY_DATE (9)

Source Code Comments

This field indicates the last date the SOBPTRM record was updated.

Columns Comments for SOBPTRM_SECT_OVER_IND (10)

Source Code Comments

This field indicates whether the Start and End dates for a Part of Term can be updated on the Section Form (SSASECT).

Columns Comments for SOBPTRM_CENSUS_2_DATE (11)

Source Code Comments

The second census date

Columns Comments for SOBPTRM_MGRD_WEB_UPD_IND (12)

Source Code Comments

Field used to control access to the Mid Term Grade Worksheet page in the Faculty Web product

Columns Comments for SOBPTRM_FGRD_WEB_UPD_IND (13)

Source Code Comments

Field used to control access to the Final Grade Worksheet page in the Faculty Web product

Columns Comments for SOBPTRM_WAITLST_WEB_DISP_IND (14)

Source Code Comments

Field used to controlaccess to the Wait List Display page in the Faculty Web product

Table SOBROLE

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

Table Columns information

Column Name	Label	Column Type	Allow NULL
SOBROLE_PIDM	SOBROLE_PIDM	NUMBER(8,0)	No
SOBROLE_TERM_CODE_EFF	SOBROLE_TERM_CODE_EFF	VARCHAR2(6)	No
SOBROLE_ACTIVE_IND	SOBROLE_ACTIVE_IND	VARCHAR2(1)	No
SOBROLE_USER_ID	SOBROLE_USER_ID	VARCHAR2(30)	No
SOBROLE_ACTIVITY_DATE	SOBROLE_ACTIVITY_DATE	DATE	No
SOBROLE_ROLE_CODE	SOBROLE_ROLE_CODE	VARCHAR2(15) </