Model Schedule Tables

Model Label : Tables used for Banner Student Schedule

List of Objects

Object Name	Object Type	Layer Name
SSBACRL	TABLE	Default
SSBDESC	TABLE	Default
SSBDFEE	TABLE	Default
SSBFSEC	TABLE	Default
SSBOVRR	TABLE	Default
SSBSECT	TABLE	Default
SSBSSEC	TABLE	Default
SSBXLST	TABLE	Default
SSRATTR	TABLE	Default
SSRBLCK	TABLE	Default
SSRCORQ	TABLE	Default
SSRCTRL	TABLE	Default
SSREVAL	TABLE	Default
SSREXCL	TABLE	Default
SSREXTN	TABLE	Default
SSRFEES	TABLE	Default
SSRLINK	TABLE	Default
SSRMEET	TABLE	Default
SSRMPRT	TABLE	Default
SSRMRDF	TABLE	Default
SSRRARE	TABLE	Default
SSRRCLS	TABLE	Default
SSRRCMP	TABLE	Default
SSRRCOL	TABLE	Default
SSRRDEG	TABLE	Default
SSRRESV	TABLE	Default
SSRRFND	TABLE	Default
SSRRLVL	TABLE	Default
SSRRMAJ	TABLE	Default
SSRRPRG	TABLE	Default
SSRRSTS	TABLE	Default
SSRRTST	TABLE	Default
SSRSCCD	TABLE	Default
SSRSPRT	TABLE	Default
SSRSRDF	TABLE	Default
SSRSYLN	TABLE	Default
SSRSYLO	TABLE	Default
SSRSYRM	TABLE	Default
SSRSYTR	TABLE	Default
SSRTEXT	TABLE	Default
SSRXLST	TABLE	Default
SSTSCHW	TABLE	Default

Comments

Model View

Table SSBACRL

Schema Name SATURN
Label SSBACRL
Server name S4B70
Creation Date 09/29/2003 12:10:09:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SSBACRL_TERM_CODE	SSBACRL_TERM_CODE	VARCHAR2(6)	No	*	*
SSBACRL_ACCL_CODE	SSBACRL_ACCL_CODE	VARCHAR2(2)	No	*	*
SSBACRL_DAYS_TO_CENSUS_1	SSBACRL_DAYS_TO_CENSUS_1	NUMBER(3,0)	Yes
SSBACRL_PERCENT_TO_CENSUS_1	SSBACRL_PERCENT_TO_CENSUS_1	NUMBER(5,2)	Yes
SSBACRL_CENSUS_1_DATE	SSBACRL_CENSUS_1_DATE	DATE	Yes
SSBACRL_DAYS_TO_CENSUS_2	SSBACRL_DAYS_TO_CENSUS_2	NUMBER(3,0)	Yes
SSBACRL_PERCENT_TO_CENSUS_2	SSBACRL_PERCENT_TO_CENSUS_2	NUMBER(5,2)	Yes
SSBACRL_CENSUS_2_DATE	SSBACRL_CENSUS_2_DATE	DATE	Yes
SSBACRL_DAYS_TO_ENRL	SSBACRL_DAYS_TO_ENRL	NUMBER(3,0)	Yes
SSBACRL_PERCENT_TO_ENRL	SSBACRL_PERCENT_TO_ENRL	NUMBER(5,2)	Yes
SSBACRL_ENRL_CUT_OFF_DATE	SSBACRL_ENRL_CUT_OFF_DATE	DATE	Yes
SSBACRL_DAYS_TO_ACAD	SSBACRL_DAYS_TO_ACAD	NUMBER(3,0)	Yes
SSBACRL_PERCENT_TO_ACAD	SSBACRL_PERCENT_TO_ACAD	NUMBER(5,2)	Yes
SSBACRL_ACAD_CUT_OFF_DATE	SSBACRL_ACAD_CUT_OFF_DATE	DATE	Yes
SSBACRL_DAYS_TO_DROP	SSBACRL_DAYS_TO_DROP	NUMBER(3,0)	Yes
SSBACRL_PERCENT_TO_DROP	SSBACRL_PERCENT_TO_DROP	NUMBER(5,2)	Yes
SSBACRL_DROP_CUT_OFF_DATE	SSBACRL_DROP_CUT_OFF_DATE	DATE	Yes
SSBACRL_ACTIVITY_DATE	SSBACRL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SSBACRL_TERM_CODE	STVTERM_CODE	STVTERM
SSBACRL_ACCL_CODE	STVACCL_CODE	STVACCL

Index

Index Name	Index Type	Column Name
PK_SSBACRL	Unique	SSBACRL_TERM_CODE
PK_SSBACRL	Unique	SSBACRL_ACCL_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SSBACRL	SYNONYM	S4B70.PUBLIC	Rely on ()
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SSAACRL.STVACCL.STVACCL_ACCL_CODE_DEF	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SSAACRL.STVACCL.STVACCL_ACCL_CODE_DEF	Use(select )
ACAD_CALENDAR	Forms Trigger	BANNER7_FORMS.SSASECT	Use(select )
ACAD_CALENDAR	Forms Trigger	BANNER7_FORMS.SSAACCL	Use(select )
ACAD_CALENDAR	Forms Trigger	BANNER7_FORMS_10G.SSASECT	Use(select )
ACAD_CALENDAR	Forms Trigger	BANNER7_FORMS_10G.SSAACCL	Use(select )
CHECK_ACCL_RULE	Forms Trigger	BANNER7_FORMS.SSAACRL	Use(select )
CHECK_ACCL_RULE	Forms Trigger	BANNER7_FORMS_10G.SSAACRL	Use(select )
SSBACRL_RG	Forms Record Group	BANNER7_FORMS.SSAACRL	Use(select )
SSBACRL_RG	Forms Record Group	BANNER7_FORMS_10G.SSAACRL	Use(select )
POST-UPDATE	Forms Trigger	BANNER7_FORMS.SSAACRL.STVACCL	Use(insert,select )
POST-UPDATE	Forms Trigger	BANNER7_FORMS_10G.SSAACRL.STVACCL	Use(insert,select )
SSBACRL	Forms DataBlock	BANNER7_FORMS.SSAQCRL	Rely on () Use(insert,update,delete,select )
SSBACRL	Forms DataBlock	BANNER7_FORMS_10G.SSAQCRL	Rely on () Use(insert,update,delete,select )
SSBACRL	Forms DataBlock	BANNER7_FORMS_10G.SSAACRL	Rely on () Use(insert,update,delete,select )
SSBACRL	Forms DataBlock	BANNER7_FORMS.SSAACRL	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SSBACRL	INDEX	S4B70.SATURN	Rely on ()
STVACCL	TABLE	S4B70.SATURN	Refer( No Action )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Census Information Base Table

Columns Comments for SSBACRL_TERM_CODE (1)

Source Code Comments

Term Code for Academic Rule

Columns Comments for SSBACRL_ACCL_CODE (2)

Source Code Comments

Academic calendar type

Columns Comments for SSBACRL_DAYS_TO_CENSUS_1 (3)

Source Code Comments

The number of days into the term for the academic calendar type when the first census date occurs

Columns Comments for SSBACRL_PERCENT_TO_CENSUS_1 (4)

Source Code Comments

The percentage of days into the term for the academic calendar type when the first census date occurs

Columns Comments for SSBACRL_CENSUS_1_DATE (5)

Source Code Comments

The census one date for the term and academic calendar year

Columns Comments for SSBACRL_DAYS_TO_CENSUS_2 (6)

Source Code Comments

The number of days into the term for the academic calendar type when the second census date occurs

Columns Comments for SSBACRL_PERCENT_TO_CENSUS_2 (7)

Source Code Comments

The percentage of days into the term for the academic calendar type when the second census date occurs

Columns Comments for SSBACRL_CENSUS_2_DATE (8)

Source Code Comments

The census two date for the term and academic calendar year

Columns Comments for SSBACRL_DAYS_TO_ENRL (9)

Source Code Comments

The number of days into the term for the academic calendar type and registration status for which the student may enroll

Columns Comments for SSBACRL_PERCENT_TO_ENRL (10)

Source Code Comments

The percentage of days into the term for the academic calendar type and registration status for which the student may enroll

Columns Comments for SSBACRL_ENRL_CUT_OFF_DATE (11)

Source Code Comments

The last date on which students may enroll for the academic calendar type and registration status

Columns Comments for SSBACRL_DAYS_TO_ACAD (12)

Source Code Comments

The number of days into the term for the academic calendar type and registration status for which the course will not be recorded in academic history

Columns Comments for SSBACRL_PERCENT_TO_ACAD (13)

Source Code Comments

The percentage of days into the term for the academic calendar type and registration status for which the course will not be recorded in academic history

Columns Comments for SSBACRL_ACAD_CUT_OFF_DATE (14)

Source Code Comments

The last date when student may process a course without it appearing on their academic history information

Columns Comments for SSBACRL_DAYS_TO_DROP (15)

Source Code Comments

The number of days into the term for the academic calendar type and registration status for which the course may be dropped without assessing a penalty

Columns Comments for SSBACRL_PERCENT_TO_DROP (16)

Source Code Comments

The percentage of days into the term for the academic calendar type and registration status for which the course may be dropped without assessing a penalty

Columns Comments for SSBACRL_DROP_CUT_OFF_DATE (17)

Source Code Comments

The last date on which students may drop a course without assessing a penalty

Columns Comments for SSBACRL_ACTIVITY_DATE (18)

Source Code Comments

The activity date

Table SSBDESC

Schema Name SATURN
Label SSBDESC
Server name S4B70
Creation Date 06/23/2004 10:54:40:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SSBDESC_TERM_CODE	SSBDESC_TERM_CODE	VARCHAR2(6)	No	*	*
SSBDESC_CRN	SSBDESC_CRN	VARCHAR2(5)	No	*
SSBDESC_TEXT_NARRATIVE	SSBDESC_TEXT_NARRATIVE	CLOB	No
SSBDESC_ACTIVITY_DATE	SSBDESC_ACTIVITY_DATE	DATE	No
SSBDESC_USER_ID	SSBDESC_USER_ID	VARCHAR2(30)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SSBDESC_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SSBDESC	Unique	SSBDESC_TERM_CODE
PK_SSBDESC	Unique	SSBDESC_CRN

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
del_ssbdesc	C/C++ Function	[F:\BANNER\C\SSPSCHD.PC]	Use(delete )
locktbl	C/C++ Function	[F:\BANNER\C\SSPSCHD.PC]	Use()
roll_ssbdesc	C/C++ Function	[F:\BANNER\C\SSRROLL.PC]	Use(insert,select )
SSBDESC	SYNONYM	S4B70.PUBLIC	Rely on ()
CREATE_DETAILS	Forms Trigger	BANNER7_FORMS.SSASECT.STVDAYS	Use(insert,select )
CREATE_DETAILS	Forms Trigger	BANNER7_FORMS_10G.SSASECT.STVDAYS	Use(insert,select )
ON-DELETE	Forms Trigger	BANNER7_FORMS.SSASECT.SSBSECT	Use(delete )
INSERT_SSBDESC	Forms Procedure	BANNER7_FORMS.SSASECT	Use(insert )
INSERT_SSBDESC	Forms Procedure	BANNER7_FORMS_10G.SSASECT	Use(insert )
COMMENTS_EXIST	Forms Function	BANNER7_FORMS.SSASECQ	Use(select )
COMMENTS_EXIST	Forms Function	BANNER7_FORMS_10G.SSASECQ	Use(select )
F_COURSE_DESCRIPTION	Package function	S4B70.BANINST1.BWCKLIBS	Use(select )
P_DELETE	Package procedure	S4B70.BANINST1.SB_SECTION	Use(delete )
P_DELETE	Package procedure	S4B70.BANINST1.GB_SECTION	Use(delete )
P_DISP_COURSE_UNSEC	Package procedure	S4B70.BANINST1.BWCKSCHD	Use(select )
SSBDESC	Forms DataBlock	BANNER7_FORMS.SSATEXT	Rely on () Use(insert,update,delete,select )
SSBDESC	Forms DataBlock	BANNER7_FORMS_10G.SSATEXT	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SSBDESC	INDEX	S4B70.SATURN	Rely on ()
ST_SSBDESC_DELETE_ROW	TRIGGER	S4B70.SATURN	Fire(delete before each row )
ST_SSBDESC_INSERT_ROW	TRIGGER	S4B70.SATURN	Fire(insert before each row )
ST_SSBDESC_UPDATE_ROW	TRIGGER	S4B70.SATURN	Fire(update before each row )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Section Description Table

Columns Comments for SSBDESC_TERM_CODE (1)

Source Code Comments

Term Code. This field identifies the term for which you are creating descriptive text for a course section.

Columns Comments for SSBDESC_CRN (2)

Source Code Comments

CRN. This field identifies the course Reference Number for which you are creating descriptive text.

Columns Comments for SSBDESC_TEXT_NARRATIVE (3)

Source Code Comments

Course section descriptive text is maintained here.

Columns Comments for SSBDESC_ACTIVITY_DATE (4)

Source Code Comments

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

Columns Comments for SSBDESC_USER_ID (5)

Source Code Comments

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

Table SSBDFEE

Schema Name SATURN
Label SSBDFEE
Server name S4B70
Creation Date 09/29/2003 12:10:09:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SSBDFEE_TERM_CODE	SSBDFEE_TERM_CODE	VARCHAR2(6)	No	*
SSBDFEE_SCHD_CODE	SSBDFEE_SCHD_CODE	VARCHAR2(3)	No	*
SSBDFEE_LEVL_CODE	SSBDFEE_LEVL_CODE	VARCHAR2(2)	No	*
SSBDFEE_DETL_CODE	SSBDFEE_DETL_CODE	VARCHAR2(4)	No	*
SSBDFEE_FEE_IND	SSBDFEE_FEE_IND	VARCHAR2(1)	Yes
SSBDFEE_AMOUNT	SSBDFEE_AMOUNT	NUMBER(12,2)	No
SSBDFEE_ACTIVITY_DATE	SSBDFEE_ACTIVITY_DATE	DATE	No
SSBDFEE_FTYP_CODE	SSBDFEE_FTYP_CODE	VARCHAR2(4)	Yes	*
SSBDFEE_DEPT_CODE	SSBDFEE_DEPT_CODE	VARCHAR2(4)	Yes	*
SSBDFEE_COLL_CODE	SSBDFEE_COLL_CODE	VARCHAR2(2)	Yes	*
SSBDFEE_CAMP_CODE	SSBDFEE_CAMP_CODE	VARCHAR2(3)	Yes	*
SSBDFEE_INSM_CODE	SSBDFEE_INSM_CODE	VARCHAR2(5)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SSBDFEE_CAMP_CODE	STVCAMP_CODE	STVCAMP
SSBDFEE_LEVL_CODE	STVLEVL_CODE	STVLEVL
SSBDFEE_TERM_CODE	STVTERM_CODE	STVTERM
SSBDFEE_INSM_CODE	GTVINSM_CODE	GTVINSM
SSBDFEE_SCHD_CODE	STVSCHD_CODE	STVSCHD
SSBDFEE_FTYP_CODE	STVFTYP_CODE	STVFTYP
SSBDFEE_COLL_CODE	STVCOLL_CODE	STVCOLL
SSBDFEE_DEPT_CODE	STVDEPT_CODE	STVDEPT
SSBDFEE_DETL_CODE	TBBDETC_DETAIL_CODE	TBBDETC

Index

Index Name	Index Type	Column Name
UK_SSBDFEE	Unique	SSBDFEE_TERM_CODE
UK_SSBDFEE	Unique	SSBDFEE_SCHD_CODE
UK_SSBDFEE	Unique	SSBDFEE_LEVL_CODE
UK_SSBDFEE	Unique	SSBDFEE_DETL_CODE
UK_SSBDFEE	Unique	SSBDFEE_INSM_CODE
UK_SSBDFEE	Unique	SSBDFEE_COLL_CODE
UK_SSBDFEE	Unique	SSBDFEE_DEPT_CODE
UK_SSBDFEE	Unique	SSBDFEE_CAMP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
deldfee	C/C++ Function	[F:\BANNER\C\SSPSCHD.PC]	Use(delete )
lock_tables	C/C++ Function	[F:\BANNER\C\SSRROLL.PC]	Use()
locktbl	C/C++ Function	[F:\BANNER\C\SSPSCHD.PC]	Use()
upddfee	C/C++ Function	[F:\BANNER\C\SSRROLL.PC]	Use(insert,select )
SSBDFEE	SYNONYM	S4B70.PUBLIC	Rely on ()
P_CREATE_SSBDFEE_DEFAULT_FEES	Package procedure	S4B70.BANINST1.SSKOLRP	Rely on ()
P_CREATE_SSBDFEE_DEFAULT_FEES	Package procedure	S4B70.BANINST1.SSKOLRP	Rely on ()
SSBDFEEC	Package cursor	S4B70.BANINST1.SSKOLRP	Rely on () Use(select )
SSBDFEE	Forms DataBlock	BANNER7_FORMS.SSADFEE	Rely on () Use(insert,update,delete,select )
SSBDFEE	Forms DataBlock	BANNER7_FORMS_10G.SSADFEE	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
UK_SSBDFEE	INDEX	S4B70.SATURN	Rely on ()
GTVINSM	TABLE	S4B70."GENERAL"	Refer( No Action )
STVCAMP	TABLE	S4B70.SATURN	Refer( No Action )
STVCOLL	TABLE	S4B70.SATURN	Refer( No Action )
STVDEPT	TABLE	S4B70.SATURN	Refer( No Action )
STVFTYP	TABLE	S4B70.SATURN	Refer( No Action )
STVLEVL	TABLE	S4B70.SATURN	Refer( No Action )
STVSCHD	TABLE	S4B70.SATURN	Refer( No Action )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )
TBBDETC	TABLE	S4B70.TAISMGR	Refer( No Action )

Comments

Source Code Comments

Tuition Fee Assessment by Status

Columns Comments for SSBDFEE_TERM_CODE (1)

Source Code Comments

This field defines the term for which you are creating the course section fee.

Columns Comments for SSBDFEE_SCHD_CODE (2)

Source Code Comments

This field defines the schedule type for which you are creating the course section fee.

Columns Comments for SSBDFEE_LEVL_CODE (3)

Source Code Comments

This field defines the level for which you are creating the course section fee.

Columns Comments for SSBDFEE_DETL_CODE (4)

Source Code Comments

This field defines the detail code of the specific fee you are creating for the course section.

Columns Comments for SSBDFEE_FEE_IND (5)

Source Code Comments

This field is used to specify whether the course fee will be assessed on a per-credit hour basis (C) or on a flat basis (F). "C" and "F" are the only valid values.

Columns Comments for SSBDFEE_AMOUNT (6)

Source Code Comments

This field defines the amount of the fee you are creating for the course section.

Columns Comments for SSBDFEE_ACTIVITY_DATE (7)

Source Code Comments

This field contains the most current date the record was added or changed.

Columns Comments for SSBDFEE_FTYP_CODE (8)

Source Code Comments

Fee Type code: this field is used to identify the type of fee to fee assessment.

Columns Comments for SSBDFEE_DEPT_CODE (9)

Source Code Comments

Department code: this field identifies the optional department code assigned to the default fee rule.

Columns Comments for SSBDFEE_COLL_CODE (10)

Source Code Comments

College code: this field identifies the optional college code assigned to the default fee rule.

Columns Comments for SSBDFEE_CAMP_CODE (11)

Source Code Comments

Campus code: this field identifies the optional campus code assigned to the default fee rule.

Columns Comments for SSBDFEE_INSM_CODE (12)

Source Code Comments

Instructional method code: this field identifies the optional instructional method code assigned to the default fee rule.

Table SSBFSEC

Schema Name SATURN
Label SSBFSEC
Server name S4B70
Creation Date 06/23/2004 10:54:43:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SSBFSEC_TERM_CODE	SSBFSEC_TERM_CODE	VARCHAR2(6)	No	*	*
SSBFSEC_CRN	SSBFSEC_CRN	VARCHAR2(5)	No	*
SSBFSEC_WAIT_LIST_DISP_IND	SSBFSEC_WAIT_LIST_DISP_IND	VARCHAR2(1)	No
SSBFSEC_MID_GRD_DISP_IND	SSBFSEC_MID_GRD_DISP_IND	VARCHAR2(1)	No
SSBFSEC_FIN_GRD_DISP_IND	SSBFSEC_FIN_GRD_DISP_IND	VARCHAR2(1)	No
SSBFSEC_ACTIVITY_DATE	SSBFSEC_ACTIVITY_DATE	DATE	No
SSBFSEC_USER_ID	SSBFSEC_USER_ID	VARCHAR2(30)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SSBFSEC_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SSBFSEC	Unique	SSBFSEC_TERM_CODE
PK_SSBFSEC	Unique	SSBFSEC_CRN

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
del_ssbfsec	C/C++ Function	[F:\BANNER\C\SSPSCHD.PC]	Use(delete )
locktbl	C/C++ Function	[F:\BANNER\C\SSPSCHD.PC]	Use()
roll_ssbfsec	C/C++ Function	[F:\BANNER\C\SSRROLL.PC]	Use(insert,select )
SSBFSEC	SYNONYM	S4B70.PUBLIC	Rely on ()
ON-DELETE	Forms Trigger	BANNER7_FORMS.SSASECT.SSBSECT	Use(delete )
FINAL_GRADES_DISPLAY_C	Package cursor	S4B70.BANINST1.SFKCURS	Use(select )
P_DELETE	Package procedure	S4B70.BANINST1.SB_SECTION	Use(delete )
P_DELETE	Package procedure	S4B70.BANINST1.GB_SECTION	Use(delete )
P_DISP_ACTIVE_REGS	Package procedure	S4B70.BANINST1.BWCKGENS	Use(select )
P_ENROLL_COUNT	Package procedure	S4B70.BANINST1.BWLKFRMT	Use(select )
P_GET_FAC_FINAL	Package procedure	S4B70.BANINST1.BWLCBREF	Use(select )
P_GET_FAC_MIDTERM	Package procedure	S4B70.BANINST1.BWLCBREF	Use(select )
P_INSERT_SSBFSEC	Package procedure	S4B70.BANINST1.SSKOLRP	Rely on ()
P_INSERT_SSBFSEC	Package procedure	S4B70.BANINST1.SSKOLRP	Use(insert,select )
MIDTERM_DISPLAY_C	Package cursor	S4B70.BANINST1.SFKCURS	Use(select )
F_FGRD	Package function	S4B70.BANINST1.BWLKILIB	Rely on ()
F_FGRD	Package function	S4B70.BANINST1.BWLKILIB	Rely on () Use(select )
F_MGRD	Package function	S4B70.BANINST1.BWLKILIB	Use(select )
F_WAITLST	Package function	S4B70.BANINST1.BWLKILIB	Use(select )
SSBFSEC	Forms DataBlock	BANNER7_FORMS.SSAWSEC	Rely on () Use(insert,update,delete,select )
SSBFSEC	Forms DataBlock	BANNER7_FORMS_10G.SSAWSEC	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SSBFSEC	INDEX	S4B70.SATURN	Rely on ()
ST_SSBFSEC_DELETE_ROW	TRIGGER	S4B70.SATURN	Fire(delete before each row )
ST_SSBFSEC_INSERT_ROW	TRIGGER	S4B70.SATURN	Fire(insert before each row )
ST_SSBFSEC_UPDATE_ROW	TRIGGER	S4B70.SATURN	Fire(update before each row )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

This table provides the capability to set faculty self-service display controls by term and section.

Columns Comments for SSBFSEC_TERM_CODE (1)

Source Code Comments

Term code: used to specify the term that the data is associated with.

Columns Comments for SSBFSEC_CRN (2)

Source Code Comments

Course Reference number: used to specify the section that the data is associated with.

Columns Comments for SSBFSEC_WAIT_LIST_DISP_IND (3)

Source Code Comments

Wait List display indicator: This column identifies whther or not wait lists will be displayed on the faculty self-service product.

Columns Comments for SSBFSEC_MID_GRD_DISP_IND (4)

Source Code Comments

Mid term grade code display indicator: The column identifies whether or not mid term grades will be displayed on the faculty self-service product.

Columns Comments for SSBFSEC_FIN_GRD_DISP_IND (5)

Source Code Comments

Final grade code display indicator: The column identifies whether or not final grade codes will be displayed on the faculty self-service product.

Columns Comments for SSBFSEC_ACTIVITY_DATE (6)

Source Code Comments

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

Columns Comments for SSBFSEC_USER_ID (7)

Source Code Comments

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

Table SSBOVRR

Schema Name SATURN
Label SSBOVRR
Server name S4B70
Creation Date 06/23/2004 10:54:44:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SSBOVRR_TERM_CODE	SSBOVRR_TERM_CODE	VARCHAR2(6)	No	*	*
SSBOVRR_CRN	SSBOVRR_CRN	VARCHAR2(5)	No	*	*
SSBOVRR_COLL_CODE	SSBOVRR_COLL_CODE	VARCHAR2(2)	Yes		*
SSBOVRR_TOPS_CODE	SSBOVRR_TOPS_CODE	VARCHAR2(6)	Yes		*
SSBOVRR_DIVS_CODE	SSBOVRR_DIVS_CODE	VARCHAR2(4)	Yes		*
SSBOVRR_DEPT_CODE	SSBOVRR_DEPT_CODE	VARCHAR2(4)	Yes		*
SSBOVRR_ACTIVITY_DATE	SSBOVRR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SSBOVRR_TERM_CODE	SSBSECT_TERM_CODE	SSBSECT
SSBOVRR_CRN	SSBSECT_CRN	SSBSECT
SSBOVRR_TERM_CODE	STVTERM_CODE	STVTERM
SSBOVRR_COLL_CODE	STVCOLL_CODE	STVCOLL
SSBOVRR_DEPT_CODE	STVDEPT_CODE	STVDEPT
SSBOVRR_DIVS_CODE	STVDIVS_CODE	STVDIVS
SSBOVRR_TOPS_CODE	STVTOPS_CODE	STVTOPS

Index

Index Name	Index Type	Column Name
PK_SSBOVRR	Unique	SSBOVRR_TERM_CODE
PK_SSBOVRR	Unique	SSBOVRR_CRN

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ins_unused_inprogress	C/C++ Function	[F:\BANNER\C\SMRSELS.PC]	Use(select )
ins_unused_inprogress	C/C++ Function	[F:\BANNER\C\SMRCMPL.H]	Use(select )
sel_in_progress_nograde	C/C++ Function	[F:\BANNER\C\SMRSELS.PC]	Use(select )
sel_in_progress_nograde	C/C++ Function	[F:\BANNER\C\SMRCMPL.H]	Use(select )
sel_in_progress_wgrade	C/C++ Function	[F:\BANNER\C\SMRSELS.PC]	Use(select )
sel_in_progress_wgrade	C/C++ Function	[F:\BANNER\C\SMRCMPL.H]	Use(select )
sel_inprogress_sfrstcr_preq	C/C++ Function	[F:\BANNER\C\SMRSELS.PC]	Use(select )
sel_inprogress_sfrstcr_preq	C/C++ Function	[F:\BANNER\C\SMRCMPL.H]	Use(select )
sel_inprogress_sftregs_preq	C/C++ Function	[F:\BANNER\C\SMRSELS.PC]	Use(select )
sel_inprogress_sftregs_preq	C/C++ Function	[F:\BANNER\C\SMRCMPL.H]	Use(select )
altmacro	C/C++ Function	[F:\BANNER\C\SFRSLST.PC]	Use(select )
altmacroa	C/C++ Function	[F:\BANNER\C\SFRSLST.PC]	Use(select )
altmacroad	C/C++ Function	[F:\BANNER\C\SFRSLST.PC]	Use(select )
altmacroc	C/C++ Function	[F:\BANNER\C\SFRSLST.PC]	Use(select )
altmacroca	C/C++ Function	[F:\BANNER\C\SFRSLST.PC]	Use(select )
altmacrocad	C/C++ Function	[F:\BANNER\C\SFRSLST.PC]	Use(select )
altmacrocd	C/C++ Function	[F:\BANNER\C\SFRSLST.PC]	Use(select )
altmacrod	C/C++ Function	[F:\BANNER\C\SFRSLST.PC]	Use(select )
delovrr	C/C++ Function	[F:\BANNER\C\SSPSCHD.PC]	Use(delete )
lock_tables	C/C++ Function	[F:\BANNER\C\SSRROLL.PC]	Use()
locktbl	C/C++ Function	[F:\BANNER\C\SSPSCHD.PC]	Use()
rollovrr	C/C++ Function	[F:\BANNER\C\SSRROLL.PC]	Use(insert,select )
sel_pernasg_acct_code	C/C++ Function	[F:\BANNER\C\PEPAEXT.PC]	Use(select )
selmacro	C/C++ Function	[F:\BANNER\C\SSRSECT.PC]	Use(select )
selmacro	C/C++ Function	[F:\BANNER\C\SSRTALY.PC]	Use()
selmacro	C/C++ Function	[F:\BANNER\C\SFRSLST.PC]	Use(select )
selmacro1	C/C++ Function	[F:\BANNER\C\SSRSECT.PC]	Use(select )
selmacro2	C/C++ Function	[F:\BANNER\C\ISRKCRS.PC]	Use(select )
selmacro2	C/C++ Function	[F:\BANNER\C\SSRSECT.PC]	Use(select )
selmacro2	C/C++ Function	[F:\BANNER\C\SSRTALY.PC]	Use()
selmacro21	C/C++ Function	[F:\BANNER\C\SSRSECT.PC]	Use(select )
selmacro3	C/C++ Function	[F:\BANNER\C\ISRKCRS.PC]	Use(select )
selmacro3	C/C++ Function	[F:\BANNER\C\SSRTALY.PC]	Use()
selmacro4	C/C++ Function	[F:\BANNER\C\ISRKCRS.PC]	Use(select )
selmacroa	C/C++ Function	[F:\BANNER\C\SFRSLST.PC]	Use(select )
selmacroad	C/C++ Function	[F:\BANNER\C\SFRSLST.PC]	Use(select )
selmacroc	C/C++ Function	[F:\BANNER\C\SFRSLST.PC]	Use(select )
selmacroca	C/C++ Function	[F:\BANNER\C\SFRSLST.PC]	Use(select )
selmacrocad	C/C++ Function	[F:\BANNER\C\SFRSLST.PC]	Use(select )
selmacrocd	C/C++ Function	[F:\BANNER\C\SFRSLST.PC]	Use(select )
selmacrod	C/C++ Function	[F:\BANNER\C\SFRSLST.PC]	Use(select )
selsect	C/C++ Function	[F:\BANNER\C\SSRSECT.PC]	Use(select )
selsect	C/C++ Function	[F:\BANNER\C\SSRTALY.PC]	Use(select )
selsect2	C/C++ Function	[F:\BANNER\C\SSRSECT.PC]	Use(select )
SSBOVRR	SYNONYM	S4B70.PUBLIC	Rely on ()
AS_COURSE_OFFERING	VIEW	S4B70.BANINST1	Use(select )
AS_STUDENT_COURSE_IN_PROGRESS	VIEW	S4B70.BANINST1	Use(select )
SSVSEC2	VIEW	S4B70.BANINST1	Use(select )
ON-DELETE	Forms Trigger	BANNER7_FORMS.SSASECT.SSBSECT	Use(delete )
ROLL_RECORD	Package Type	S4B70.BANINST1.SHKROLS	Rely on ()
P_BUILDSOTWREG	Package procedure	S4B70.BANINST1.SOKWEXT	Use(select )
P_GET_STUDENT_COURSE	Package procedure	S4B70.BANINST1.SHKROLS	Use(select )
P_DELETE	Package procedure	S4B70.BANINST1.SB_SECTION	Use(delete )
P_DELETE	Package procedure	S4B70.BANINST1.GB_SECTION	Use(delete )
P_FACSCHED	Package procedure	S4B70.BANINST1.BWLKIFAC	Use(select )
SSBOVRR	Forms DataBlock	BANNER7_FORMS.SSAOVRR	Rely on () Use(insert,update,delete,select )
SSBOVRR	Forms DataBlock	BANNER7_FORMS_10G.SSAOVRR	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SSBOVRR	INDEX	S4B70.SATURN	Rely on ()
ST_SSBOVRR_DELETE_ROW	TRIGGER	S4B70.SATURN	Fire(delete before each row )
ST_SSBOVRR_INSERT_ROW	TRIGGER	S4B70.SATURN	Fire(insert before each row )
ST_SSBOVRR_UPDATE_ROW	TRIGGER	S4B70.SATURN	Fire(update before each row )
SSBSECT	TABLE	S4B70.SATURN	Refer( No Action )
STVCOLL	TABLE	S4B70.SATURN	Refer( No Action )
STVDEPT	TABLE	S4B70.SATURN	Refer( No Action )
STVDIVS	TABLE	S4B70.SATURN	Refer( No Action )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )
STVTOPS	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Schedule Override Table

Columns Comments for SSBOVRR_TERM_CODE (1)

Source Code Comments

Schedule Override Term Code

Columns Comments for SSBOVRR_CRN (2)

Source Code Comments

Schedule Override Course Reference Number

Columns Comments for SSBOVRR_COLL_CODE (3)

Source Code Comments

Schedule Override College Code

Columns Comments for SSBOVRR_TOPS_CODE (4)

Source Code Comments

Schedule Override Taxonomy of Program Code

Columns Comments for SSBOVRR_DIVS_CODE (5)

Source Code Comments

Schedule Override Division Code

Columns Comments for SSBOVRR_DEPT_CODE (6)

Source Code Comments

Schedule Override Department Code

Columns Comments for SSBOVRR_ACTIVITY_DATE (7)

Source Code Comments

The Activity Date

Table SSBSECT

Schema Name SATURN
Label SSBSECT
Server name S4B70
Creation Date 09/10/2004 01:06:51:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SSBSECT_TERM_CODE	SSBSECT_TERM_CODE	VARCHAR2(6)	No	*	*
SSBSECT_CRN	SSBSECT_CRN	VARCHAR2(5)	No	*	*
SSBSECT_PTRM_CODE	SSBSECT_PTRM_CODE	VARCHAR2(3)	Yes		*
SSBSECT_SUBJ_CODE	SSBSECT_SUBJ_CODE	VARCHAR2(4)	No		*
SSBSECT_CRSE_NUMB	SSBSECT_CRSE_NUMB	VARCHAR2(5)	No		*
SSBSECT_SEQ_NUMB	SSBSECT_SEQ_NUMB	VARCHAR2(3)	No
SSBSECT_SSTS_CODE	SSBSECT_SSTS_CODE	VARCHAR2(1)	No		*
SSBSECT_SCHD_CODE	SSBSECT_SCHD_CODE	VARCHAR2(3)	No		*
SSBSECT_CAMP_CODE