PK_SCBCRKY PK_SCBSUPP PK_SCRCLBD PK_SCRGMOD PK_SCRLEVL PK_SCRRATT PK_SCRRCHR PK_SCRRDEP PK_SCRSCHD PK_SCRSECT SCBCDEP SCBCDTL SCBCRKY SCBCRSE SCBDESC SCBSUPP SCRATTR SCRCDTX SCRCLBD SCRCORQ SCRCPRT SCRCRDF SCREQIV SCRFEES SCRGMOD SCRINTG SCRLEVL SCRRARE SCRRATT SCRRCAM SCRRCHR SCRRCLS SCRRCMP SCRRCOL SCRRDEG SCRRDEP SCRRLVL SCRRMAJ SCRRPRG SCRRTRM SCRRTST SCRSBGI SCRSCHD SCRSECT SCRSPRT SCRSRDF SCRSYLN SCRSYLO SCRSYRM SCRSYTR SCRTEXT

Model Catalog*


Model Label : Catalog SC% tables and some support tables

List of Objects

Object Name Object Type Layer Name
PK_SCBCRKY SQL Index Default
PK_SCBSUPP SQL Index Default
PK_SCRCLBD SQL Index Default
PK_SCRGMOD SQL Index Default
PK_SCRLEVL SQL Index Default
PK_SCRRATT SQL Index Default
PK_SCRRCHR SQL Index Default
PK_SCRRDEP SQL Index Default
PK_SCRSCHD SQL Index Default
PK_SCRSECT SQL Index Default
SCBCDEP SQL Table Default
SCBCDTL SQL Table Default
SCBCRKY SQL Table Default
SCBCRSE SQL Table Default
SCBDESC SQL Table Default
SCBSUPP SQL Table Default
SCRATTR SQL Table Default
SCRCDTX SQL Table Default
SCRCLBD SQL Table Default
SCRCORQ SQL Table Default
SCRCPRT SQL Table Default
SCRCRDF SQL Table Default
SCREQIV SQL Table Default
SCRFEES SQL Table Default
SCRGMOD SQL Table Default
SCRINTG SQL Table Default
SCRLEVL SQL Table Default
SCRRARE SQL Table Default
SCRRATT SQL Table Default
SCRRCAM SQL Table Default
SCRRCHR SQL Table Default
SCRRCLS SQL Table Default
SCRRCMP SQL Table Default
SCRRCOL SQL Table Default
SCRRDEG SQL Table Default
SCRRDEP SQL Table Default
SCRRLVL SQL Table Default
SCRRMAJ SQL Table Default
SCRRPRG SQL Table Default
SCRRTRM SQL Table Default
SCRRTST SQL Table Default
SCRSBGI SQL Table Default
SCRSCHD SQL Table Default
SCRSECT SQL Table Default
SCRSPRT SQL Table Default
SCRSRDF SQL Table Default
SCRSYLN SQL Table Default
SCRSYLO SQL Table Default
SCRSYRM SQL Table Default
SCRSYTR SQL Table Default
SCRTEXT SQL Table Default

Model View

Index PK_SCBCRKY

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SCBCRKY
Owner Name
Index Type UNIQUE

Index Columns information

Column Name Column Type Column Length Column precision
SCBCRKY_SUBJ_CODE VARCHAR2 4 0
SCBCRKY_CRSE_NUMB VARCHAR2 5 0

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCBCRKY SQL Table S10B80.SATURN Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SCBCRKY

Object Dates

Creation Date Analysis Date
04/02/2008 20:58:49:000 04/02/2008 20:58:49:000

Index PK_SCBSUPP

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SCBSUPP
Owner Name
Index Type UNIQUE

Index Columns information

Column Name Column Type Column Length Column precision
SCBSUPP_SUBJ_CODE VARCHAR2 4 0
SCBSUPP_CRSE_NUMB VARCHAR2 5 0
SCBSUPP_EFF_TERM VARCHAR2 6 0

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCBSUPP SQL Table S10B80.SATURN Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SCBSUPP

Object Dates

Creation Date Analysis Date
04/02/2008 20:45:12:000 04/02/2008 20:45:12:000

Index PK_SCRCLBD

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SCRCLBD
Owner Name
Index Type UNIQUE

Index Columns information

Column Name Column Type Column Length Column precision
SCRCLBD_SUBJ_CODE VARCHAR2 4 0
SCRCLBD_CRSE_NUMB VARCHAR2 5 0
SCRCLBD_TERM_CODE_EFF VARCHAR2 6 0
SCRCLBD_SEQ_NO NUMBER 3 3

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRCLBD SQL Table S10B80.SATURN Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SCRCLBD

Object Dates

Creation Date Analysis Date
04/02/2008 20:48:13:000 04/02/2008 20:48:13:000

Index PK_SCRGMOD

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SCRGMOD
Owner Name
Index Type UNIQUE

Index Columns information

Column Name Column Type Column Length Column precision
SCRGMOD_SUBJ_CODE VARCHAR2 4 0
SCRGMOD_CRSE_NUMB VARCHAR2 5 0
SCRGMOD_EFF_TERM VARCHAR2 6 0
SCRGMOD_GMOD_CODE VARCHAR2 1 0

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRGMOD SQL Table S10B80.SATURN Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SCRGMOD

Object Dates

Creation Date Analysis Date
04/02/2008 20:40:21:000 04/02/2008 20:40:21:000

Index PK_SCRLEVL

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SCRLEVL
Owner Name
Index Type UNIQUE

Index Columns information

Column Name Column Type Column Length Column precision
SCRLEVL_SUBJ_CODE VARCHAR2 4 0
SCRLEVL_CRSE_NUMB VARCHAR2 5 0
SCRLEVL_EFF_TERM VARCHAR2 6 0
SCRLEVL_LEVL_CODE VARCHAR2 2 0

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRLEVL SQL Table S10B80.SATURN Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SCRLEVL

Object Dates

Creation Date Analysis Date
04/02/2008 20:36:55:000 04/02/2008 20:36:55:000

Index PK_SCRRATT

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SCRRATT
Owner Name
Index Type UNIQUE

Index Columns information

Column Name Column Type Column Length Column precision
SCRRATT_PRIMARY_KEY NUMBER 9 9

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRRATT SQL Table S10B80.SATURN Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SCRRATT

Object Dates

Creation Date Analysis Date
04/02/2008 21:03:25:000 04/02/2008 21:03:25:000

Index PK_SCRRCHR

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SCRRCHR
Owner Name
Index Type UNIQUE

Index Columns information

Column Name Column Type Column Length Column precision
SCRRCHR_PRIMARY_KEY NUMBER 9 9

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRRCHR SQL Table S10B80.SATURN Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SCRRCHR

Object Dates

Creation Date Analysis Date
04/02/2008 20:37:05:000 04/02/2008 20:37:05:000

Index PK_SCRRDEP

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SCRRDEP
Owner Name
Index Type UNIQUE

Index Columns information

Column Name Column Type Column Length Column precision
SCRRDEP_PRIMARY_KEY NUMBER 9 9

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRRDEP SQL Table S10B80.SATURN Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SCRRDEP

Object Dates

Creation Date Analysis Date
04/02/2008 20:41:00:000 04/02/2008 20:41:00:000

Index PK_SCRSCHD

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SCRSCHD
Owner Name
Index Type UNIQUE

Index Columns information

Column Name Column Type Column Length Column precision
SCRSCHD_SUBJ_CODE VARCHAR2 4 0
SCRSCHD_CRSE_NUMB VARCHAR2 5 0
SCRSCHD_EFF_TERM VARCHAR2 6 0
SCRSCHD_SCHD_CODE VARCHAR2 3 0

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRSCHD SQL Table S10B80.SATURN Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SCRSCHD

Object Dates

Creation Date Analysis Date
04/02/2008 20:49:09:000 04/02/2008 20:49:09:000

Index PK_SCRSECT

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SCRSECT
Owner Name
Index Type UNIQUE

Index Columns information

Column Name Column Type Column Length Column precision
SCRSECT_SUBJ_CODE VARCHAR2 4 0
SCRSECT_CRSE_NUMB VARCHAR2 5 0
SCRSECT_TERM_CODE VARCHAR2 6 0
SCRSECT_SCHD_CODE VARCHAR2 3 0
SCRSECT_CAMP_CODE VARCHAR2 3 0

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRSECT SQL Table S10B80.SATURN Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SCRSECT

Object Dates

Creation Date Analysis Date
04/02/2008 20:57:50:000 04/02/2008 20:57:50:000

Table SCBCDEP

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCBCDEP_COLL_CODE   VARCHAR2(2) No   *
SCBCDEP_DEPT_CODE   VARCHAR2(4) Yes   *
SCBCDEP_TERM_CODE_START   VARCHAR2(6) No   *
SCBCDEP_TERM_CODE_END   VARCHAR2(6) No   *
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
SCBCDEP_TERM_CODE_START STVTERM_CODE STVTERM
SCBCDEP_TERM_CODE_END STVTERM_CODE STVTERM

Index

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCBCDEP_KEY_INDEX SQL Index S10B80.SATURN Rely On
STVCOLL SQL Table S10B80.SATURN Refer (no action)
STVDEPT SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCBCDEP

Object Dates

Creation Date Analysis Date
04/02/2008 21:03:00:000 04/02/2008 21:18:22:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCBCDTL_COLL_CODE   VARCHAR2(2) No   *
SCBCDTL_TERM_CODE_EFF   VARCHAR2(6) No    
SCBCDTL_ACTIVITY_DATE   DATE No    
SCBCDTL_USER_ID   VARCHAR2(30) No    
SCBCDTL_DEPT_CODE   VARCHAR2(4) Yes   *
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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
UK_SCBCDTL SQL Index S10B80.SATURN Rely On
STVCOLL SQL Table S10B80.SATURN Refer (no action)
STVDEPT SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCBCDTL

Object Dates

Creation Date Analysis Date
04/02/2008 21:05:18:000 04/02/2008 21:18:24:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCBCRKY_SUBJ_CODE   VARCHAR2(4) No * *
SCBCRKY_CRSE_NUMB   VARCHAR2(5) No *  
SCBCRKY_TERM_CODE_START   VARCHAR2(6) No   *
SCBCRKY_TERM_CODE_END   VARCHAR2(6) No   *
SCBCRKY_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
SCBCRKY_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCBCRKY_TERM_CODE_END STVTERM_CODE STVTERM
SCBCRKY_TERM_CODE_START STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SCBCRKY Unique SCBCRKY_SUBJ_CODE
PK_SCBCRKY Unique SCBCRKY_CRSE_NUMB

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCBCRSE SQL Table S10B80.SATURN Join
SCBSUPP SQL Table S10B80.SATURN Refer (no action)
SCRATTR SQL Table S10B80.SATURN Refer (no action)
SCRCORQ SQL Table S10B80.SATURN Refer (no action)
SCREQIV SQL Table S10B80.SATURN Refer (no action)
SCRFEES SQL Table S10B80.SATURN Refer (no action)
SCRINTG SQL Table S10B80.SATURN Refer (no action)
SCRRATT SQL Table S10B80.SATURN Refer (no action)
SCRRCAM SQL Table S10B80.SATURN Refer (no action)
SCRRCHR SQL Table S10B80.SATURN Refer (no action)
SCRRCLS SQL Table S10B80.SATURN Refer (no action)
SCRRCMP SQL Table S10B80.SATURN Refer (no action)
SCRRCOL SQL Table S10B80.SATURN Refer (no action)
SCRRDEP SQL Table S10B80.SATURN Refer (no action)
SCRRLVL SQL Table S10B80.SATURN Refer (no action)
SCRRMAJ SQL Table S10B80.SATURN Refer (no action)
SCRRTRM SQL Table S10B80.SATURN Refer (no action)
SCRRTST SQL Table S10B80.SATURN Refer (no action)
SCRSBGI SQL Table S10B80.SATURN Refer (no action)
SCRSECT SQL Table S10B80.SATURN Refer (no action)
SCRTEXT SQL Table S10B80.SATURN Refer (no action)
SSBSECT SQL Table S10B80.SATURN Refer (no action)
ST_SCBCRKY_AR_LDI SQL Trigger S10B80.SATURN Rely On
P_DELETE_ALL Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBCVAR Use (delete,select)
F_IS_STARTING_TERM Oracle Package Function S10B80.BANINST1.SB_COURSE Use (select)
SCBCRSE2C Oracle Package Cursor S10B80.BANINST1.SCKLIBS Use (select)
P_CAT_SEARCH Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Rely On
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Use (select)
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (Insert,select)
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Rely On
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Use (select)
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Rely On
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Use (select)
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.SB_COURSE_CATALOG Use (select)
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)
P_DISPLAY_INFO Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAY_INFO Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)
P_UT_GRADEROLL Oracle Package Procedure S10B80.BANINST1.UT_GRADEROLL Use (delete)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_CRSE_DEPT_RESTRICTION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SP_GRADING Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_SECTION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_CRSE_ATTS_RESTRICTION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_COURSE Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_WL_NOTIFICATION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_CRSE_CHRT_RESTRICTION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_SECTION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_SECTION_LABOR Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_FACASSIGNMENT Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_FACULTY Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_WL_COLLECTOR Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_WL_SECTION_CTRL Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_CATLG_INT_PARTNER Use (Insert,select)
UT_TEARDOWN Oracle Package Procedure S10B80.BANINST1.UT_SP_GRADING Use (delete)
UT_TEARDOWN Oracle Package Procedure S10B80.BANINST1.UT_GB_SECTION Use (delete)
F_CHECK_OFFERED Oracle Package Function S10B80.BANINST1.SB_SECTION_RULES Use (select)
F_GET_COURSE Oracle Package Function S10B80.BANINST1.ICSCKCOM Use (select)
F_GET_COURSES Oracle Package Function S10B80.BANINST1.SP_CATALOG_EXPORT Use (select)
F_PARENT_EXISTS Oracle Package Function S10B80.BANINST1.SB_CATLG_INT_PARTNER_RULES Use (select)
F_PARENT_EXISTS Oracle Package Function S10B80.BANINST1.SB_SECTION_RULES Use (select)
F_SCBCRSE_ALT Oracle Package Function S10B80.BANINST1.LM_COURSE_CATALOG Use (select)
SCBCRKY Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SCBCRKY SQL Index S10B80.SATURN Rely On
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)
ST_SCBCRKY_AR_LDI SQL Trigger S10B80.SATURN Fire (Insert,update,after,each row)
ST_SCBCRKY_AS_LDI SQL Trigger S10B80.SATURN Fire (Insert,update,after,all rows)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCBCRKY

Object Dates

Creation Date Analysis Date
04/02/2008 20:58:48:000 04/02/2008 21:18:19:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCBCRSE_SUBJ_CODE   VARCHAR2(4) No   *
SCBCRSE_CRSE_NUMB   VARCHAR2(5) No   *
SCBCRSE_EFF_TERM   VARCHAR2(6) Yes   *
SCBCRSE_COLL_CODE   VARCHAR2(2) Yes   *
SCBCRSE_DIVS_CODE   VARCHAR2(4) Yes   *
SCBCRSE_DEPT_CODE   VARCHAR2(4) Yes   *
SCBCRSE_CSTA_CODE   VARCHAR2(1) Yes   *
SCBCRSE_TITLE   VARCHAR2(30) Yes    
SCBCRSE_CIPC_CODE   VARCHAR2(6) Yes   *
SCBCRSE_CREDIT_HR_IND   VARCHAR2(2) Yes    
SCBCRSE_CREDIT_HR_LOW   NUMBER(7,3) Yes    
SCBCRSE_CREDIT_HR_HIGH   NUMBER(7,3) Yes    
SCBCRSE_LEC_HR_IND   VARCHAR2(2) Yes    
SCBCRSE_LEC_HR_LOW   NUMBER(7,3) Yes    
SCBCRSE_LEC_HR_HIGH   NUMBER(7,3) Yes    
SCBCRSE_LAB_HR_IND   VARCHAR2(2) Yes    
SCBCRSE_LAB_HR_LOW   NUMBER(7,3) Yes    
SCBCRSE_LAB_HR_HIGH   NUMBER(7,3) Yes    
SCBCRSE_OTH_HR_IND   VARCHAR2(2) Yes    
SCBCRSE_OTH_HR_LOW   NUMBER(7,3) Yes    
SCBCRSE_OTH_HR_HIGH   NUMBER(7,3) Yes    
SCBCRSE_BILL_HR_IND   VARCHAR2(2) Yes    
SCBCRSE_BILL_HR_LOW   NUMBER(7,3) Yes    
SCBCRSE_BILL_HR_HIGH   NUMBER(7,3) Yes    
SCBCRSE_APRV_CODE   VARCHAR2(1) Yes   *
SCBCRSE_REPEAT_LIMIT   NUMBER(2,0) Yes    
SCBCRSE_PWAV_CODE   VARCHAR2(1) Yes   *
SCBCRSE_TUIW_IND   VARCHAR2(1) Yes    
SCBCRSE_ADD_FEES_IND   VARCHAR2(1) Yes    
SCBCRSE_ACTIVITY_DATE   DATE Yes    
SCBCRSE_CONT_HR_LOW   NUMBER(7,3) Yes    
SCBCRSE_CONT_HR_IND   VARCHAR2(2) Yes    
SCBCRSE_CONT_HR_HIGH   NUMBER(7,3) Yes    
SCBCRSE_CEU_IND   VARCHAR2(1) Yes    
SCBCRSE_REPS_CODE   VARCHAR2(2) Yes   *
SCBCRSE_MAX_RPT_UNITS   NUMBER(9,3) Yes    
SCBCRSE_CAPP_PREREQ_TEST_IND   VARCHAR2(1) No    
SCBCRSE_DUNT_CODE   VARCHAR2(4) Yes   *
SCBCRSE_NUMBER_OF_UNITS   NUMBER(7,2) Yes    
SCBCRSE_DATA_ORIGIN   VARCHAR2(30) Yes    
SCBCRSE_USER_ID   VARCHAR2(30) 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_SUBJ_CODE SSBSECT_SUBJ_CODE SSBSECT
SCBCRSE_CRSE_NUMB SSBSECT_CRSE_NUMB SSBSECT
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_APRV_CODE STVAPRV_CODE STVAPRV
SCBCRSE_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCBCRSE_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCBCRSE_EFF_TERM SCBDESC_TERM_CODE_EFF SCBDESC
SCBCRSE_SUBJ_CODE SCBDESC_SUBJ_CODE SCBDESC
SCBCRSE_CRSE_NUMB SCBDESC_CRSE_NUMB SCBDESC

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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
ST_SCBCRSE_AR_LDI SQL Trigger S10B80.SATURN Rely On
SFVRHST SQL View S10B80.BANINST1 Use (select)
SFVSTC2 SQL View S10B80.BANINST1 Use (select)
SFVSTC2_LATEST SQL View S10B80.BANINST1 Use (select)
SFVTFAN SQL View S10B80.BANINST1 Use (select)
SOVTPC1 SQL View S10B80.BANINST1 Use (select)
SSVENR1 SQL View S10B80.BANINST1 Use (select)
SSVSEC2 SQL View S10B80.BANINST1 Use (select)
SSVSECT SQL View S10B80.BANINST1 Use (select)
TBVTPCN SQL View S10B80.BANINST1 Use (select)
F_GET_MAX_TERM_CODE SQL Function S10B80.BANINST1 Use (select)
COURSE_REC Oracle Package Type S10B80.BANINST1.SB_COURSE Rely On
COURSE_REC_TYPE Oracle Package Type S10B80.BANINST1.ICSCKCOM Rely On
CRSE_REC Oracle Package Type S10B80.BANINST1.SFKCURS Rely On
SCBRSE_REC Oracle Package Type S10B80.BANINST1.CHNLSKBL Rely On
SCBRSE_REC Oracle Package Type S10B80.BANINST1.BWLCBREF Rely On
SFTREGS_REC Oracle Package Type S10B80.BANINST1.SFKCURS Rely On
TEST_REC Oracle Package Type S10B80.BANINST1.P_TEST_XML Rely On
TITLE Oracle Package Type S10B80.BANINST1.ICSSKLIB Rely On
COURSETITLEC Oracle Package Cursor S10B80.BANINST1.SOKBEVN Rely On
COURSETITLEC Oracle Package Cursor S10B80.BANINST1.SOKBEVN Use (select)
COURSETITLEC Oracle Package Cursor S10B80.BANINST1.ICSSKBEV Rely On
COURSETITLEC Oracle Package Cursor S10B80.BANINST1.ICSSKBEV Use (select)
DF_GS_C Oracle Package Cursor S10B80.BANINST1.SHKEGRB Use (select)
P_REGISTER_ENTITY Oracle Package Procedure S10B80.BANINST1.BE_COURSE_RULES Rely On
P_REGISTER_ENTITY Oracle Package Procedure S10B80.BANINST1.BE_COURSE_RULES Rely On
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.BE_COURSE_RULES Rely On
LDICOURSE_REC_TYPE Oracle Package Type S10B80.BANINST1.ICSCKLDI Rely On
COURSE_TITLE_C Oracle Package Cursor S10B80.BANINST1.ICSSKCOM Use (select)
DEPARTMENT_C Oracle Package Cursor S10B80.BANINST1.ICSSKCOM Use (select)
GETCOURSEINFOC Oracle Package Cursor S10B80.BANINST1.BWLKEGRB Use (select)
REGCRSEC Oracle Package Cursor S10B80.BANINST1.BWCKGENS Use (select)
REGSC Oracle Package Cursor S10B80.BANINST1.BWCKFRMT Use (select)
SCBCRSE_C Oracle Package Cursor S10B80.BANINST1.BWCKSCHD Use (select)
SFRSTCR_VIEWC Oracle Package Cursor S10B80.BANINST1.BWCKOTRN Use (select)
P_BUILDSOTWREG Oracle Package Procedure S10B80.BANINST1.SOKWEXT Use (select)
P_DELETE_ALL Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBCVAR Use (delete,select)
P_GET_STUDENT_COURSE Oracle Package Procedure S10B80.BANINST1.SHKROLS Use (select)
P_ONETIMEVALUES Oracle Package Procedure S10B80.BANINST1.TS_STUDENT_OAPERF Rely On
P_OVERLAY_VALIDATION_REC Oracle Package Procedure S10B80.BANINST1.SB_COURSE Rely On
P_SEND_COURSE_SUBEVENTS Oracle Package Procedure S10B80.BANINST1.ICSCKLDI Rely On
CRSE_TITLE Oracle Package Variable S10B80.BANINST1.BWLKOCRN Rely On
DISP_TITLE Oracle Package Variable S10B80.BANINST1.BWCKSCHD Rely On
SCBCRSE_ROW Oracle Package Variable S10B80.BANINST1.BWCKGENS Rely On
SCBCRSE_ROW Oracle Package Variable S10B80.BANINST1.BWCKSAMS Rely On
SCBCRSE_ROW Oracle Package Variable S10B80.BANINST1.BWCKREGS Rely On
SCBCRSE_ROW Oracle Package Variable S10B80.BANINST1.BWCKCOMS Rely On
TEST_NUMB Oracle Package Variable S10B80.BANINST1.UT_GRADEROLL Rely On
TEST_NUMB Oracle Package Variable S10B80.BANINST1.TS_SB_GRADEROLL Rely On
TEST_NUMB Oracle Package Variable S10B80.BANINST1.TS_SB_CURRICULUM Rely On
F_BUILD_SCBCRSE_REC Oracle Package Function S10B80.BANINST1.SB_COURSE Rely On
F_CALC_COLL_SOURCEDID_ID Oracle Package Function S10B80.BANINST1.ICSCKCOM Rely On
F_CALC_COURSE_ONLINETOPIC Oracle Package Function S10B80.BANINST1.ICSCKCOM Rely On
F_CALC_COURSE_SHORT_DESC Oracle Package Function S10B80.BANINST1.ICSCKCOM Rely On
F_CALC_COURSE_SOURCEDID_ID Oracle Package Function S10B80.BANINST1.ICSCKCOM Rely On
F_CALC_DEPT_SOURCEDID_ID Oracle Package Function S10B80.BANINST1.ICSCKCOM Rely On
F_CRSESECTIONTITLE Oracle Package Function S10B80.BANINST1.BWSKRSTA Use (select)
F_GET_DASHBORD Oracle Package Function S10B80.BANINST1.CLOBPERS Use (select)
F_IS_STARTING_TERM Oracle Package Function S10B80.BANINST1.SB_COURSE Rely On
F_SSBSECT_EXISTS Oracle Package Function S10B80.BANINST1.SB_COURSE Rely On
COURSE_TITLE_C Oracle Package Cursor S10B80.BANINST1.ICSSKLIB Rely On
COURSE_TITLE_C Oracle Package Cursor S10B80.BANINST1.ICSSKLIB Use (select)
GET_COURSE_INFO_C Oracle Package Cursor S10B80.BANINST1.BWLKILIB Use (select)
SCBCRSE2C Oracle Package Cursor S10B80.BANINST1.SCKLIBS Use (select)Rely On
SCBCRSEC Oracle Package Cursor S10B80.BANINST1.SCKLIBS Use (select)Rely On
SCBCRSE_NEXT_C Oracle Package Cursor S10B80.BANINST1.SCKLIBS Use (select)Rely On
SFTREGSERRC Oracle Package Cursor S10B80.BANINST1.SFKCURS Use (select)
SFTREGSROWC Oracle Package Cursor S10B80.BANINST1.SFKCURS Use (select)
SFTREGSWATROW1C Oracle Package Cursor S10B80.BANINST1.SFKCURS Use (select)
P_ACREC_INST_COURSE_ELEMENT Oracle Package Procedure S10B80.BANINST1.SB_PESCXML_COURSE_EXP Rely On
P_ACREC_IN_PROG_COURSE_ELEMENT Oracle Package Procedure S10B80.BANINST1.SB_PESCXML_COURSE_EXP Rely On
P_ACREC_TRANS_COURSE_ELEMENT Oracle Package Procedure S10B80.BANINST1.SB_PESCXML_COURSE_EXP Rely On
P_CAT_SEARCH Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)
P_CHECK_REPT Oracle Package Procedure S10B80.BANINST1.SFKFUNC Rely On
P_CHECK_RPTH Oracle Package Procedure S10B80.BANINST1.SFKFUNC Rely On
P_COUNT_REPEAT_UNITS Oracle Package Procedure S10B80.BANINST1.SHKRPTS Rely On
P_COUNT_REPEAT_UNITS Oracle Package Procedure S10B80.BANINST1.SHKRPTS Use (select)
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Rely On
P_DECODE_SUBJ_LINK Oracle Package Procedure S10B80.BANINST1.BWCKSMLT Rely On
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Rely On
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DELETE Oracle Package Procedure S10B80.BANINST1.DML_SCBCRSE Use (delete)
P_DISPCRSESCHDDETL Oracle Package Procedure S10B80.BANINST1.BWCKGENS Rely On
P_DISPLAYAREAS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAYCOREQUISITES Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAYRTST Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.SB_COURSE_CATALOG Rely On
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.SB_COURSE_CATALOG Use (select)Rely On
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
P_DISPLAY_INFO Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPSUBC Oracle Package Procedure S10B80.BANINST1.BWSKSMRK Use (select)
P_DISP_ACTIVE_REGS Oracle Package Procedure S10B80.BANINST1.BWCKGENS Rely On
P_DISP_ACTIVE_REGS Oracle Package Procedure S10B80.BANINST1.BWCKGENS Use (select)Rely On
P_DISP_COURSE_DETAIL Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISP_COURSE_DETAIL Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)
P_DISP_FEE_AMOUNT Oracle Package Procedure S10B80.BANINST1.BWCKSCHD Rely On
P_FACACTASSIGN Oracle Package Procedure S10B80.BANINST1.BWLKASGN Use (select)
P_FACASSIGNHIST Oracle Package Procedure S10B80.BANINST1.BWLKASGN Use (select)
P_FACCRNSEL Oracle Package Procedure S10B80.BANINST1.BWLKOCRN Use (select)
P_FACMIDGRD Oracle Package Procedure S10B80.BANINST1.BWLKFMGD Use (select)
P_FACSCHED Oracle Package Procedure S10B80.BANINST1.BWLKIFAC Use (select)
P_FAC_SYLLABUS Oracle Package Procedure S10B80.BANINST1.BWLKSYBS Rely On
P_FAC_SYLLABUS Oracle Package Procedure S10B80.BANINST1.BWLKSYBS Use (select)
P_GETAREAS Oracle Package Procedure S10B80.BANINST1.BWCKCPRL Use (select)
P_GET_COURSE Oracle Package Procedure S10B80.BANINST1.SFKFUNC Rely On
P_GET_CRN Oracle Package Procedure S10B80.BANINST1.SFKFUNC Rely On
P_GET_FAC_FINAL Oracle Package Procedure S10B80.BANINST1.BWLCBREF Use (select)
P_GET_FAC_GRDEBOOK Oracle Package Procedure S10B80.BANINST1.BWLCBREF Use (select)
P_GET_FAC_MIDTERM Oracle Package Procedure S10B80.BANINST1.BWLCBREF Use (select)
P_GET_INST_CREDITS Oracle Package Procedure S10B80.BANINST1.SHKTAEQ Rely On
P_GET_REGCRSEC Oracle Package Procedure S10B80.BANINST1.BWSCBREF Use (select)
P_GET_REPEAT_DATA Oracle Package Procedure S10B80.BANINST1.SFKFUNC Rely On
P_GRADE_CHANGE Oracle Package Procedure S10B80.BANINST1.ICSHKBEV Rely On
P_GRADE_ROLL Oracle Package Procedure S10B80.BANINST1.ICSHKBEV Rely On
P_INSERT Oracle Package Procedure S10B80.BANINST1.DML_SCBCRSE Use (Insert)Rely On
P_INSERT_SFTREGS_FROM_STCR Oracle Package Procedure S10B80.BANINST1.SFKMODS Use (select)
P_LISTCRSE Oracle Package Procedure S10B80.BANINST1.BWCKGENS Rely On
P_LISTCRSE Oracle Package Procedure S10B80.BANINST1.BWCKGENS Use (select)
P_LOCK Oracle Package Procedure S10B80.BANINST1.SB_COURSE Rely On
P_LOCK Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (select)
P_PRE_EDIT Oracle Package Procedure S10B80.BANINST1.SFKEDIT Rely On
P_PROCESS_BILL_HRS Oracle Package Procedure S10B80.BANINST1.VRSKFREG Rely On
P_REGISTER_ENTITY Oracle Package Procedure S10B80.BANINST1.SB_COURSE_RULES Rely On
P_REGSUPD Oracle Package Procedure S10B80.BANINST1.BWCKGENS Rely On
P_SAVE_COURSE Oracle Package Procedure S10B80.BANINST1.ICSCKLDI Rely On
P_SCBCRSE_ADR Oracle Package Procedure S10B80.BANINST1.EOK497R Rely On
P_SCBCRSE_AIR Oracle Package Procedure S10B80.BANINST1.EOK497R Rely On
P_SCBCRSE_AUR Oracle Package Procedure S10B80.BANINST1.EOK497R Rely On
P_SECTION_CANCELLED Oracle Package Procedure S10B80.BANINST1.ICSSKBEV Rely On
P_SEND_COURSE Oracle Package Procedure S10B80.BANINST1.ICSCKLDI Rely On
P_TS_GRADEROLL Oracle Package Procedure S10B80.BANINST1.TS_SB_GRADEROLL Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.DML_SCBCRSE Use (update)Rely On
P_UPDATE_REGS Oracle Package Procedure S10B80.BANINST1.SFKEDIT Use (select)
P_UT_GRADEROLL Oracle Package Procedure S10B80.BANINST1.UT_GRADEROLL Rely On
P_UT_GRADEROLL Oracle Package Procedure S10B80.BANINST1.UT_GRADEROLL Use (delete)
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.SB_COURSE_RULES Rely On
P_VALIDATE_CHILDREN Oracle Package Procedure S10B80.BANINST1.SB_COURSE_RULES Rely On
P_VR_ADD_CLASS Oracle Package Procedure S10B80.BANINST1.VRSKFREG Rely On
P_VR_CREDIT_HOURS_OPT Oracle Package Procedure S10B80.BANINST1.VRSKFREG Rely On
P_VR_CRN_LIST Oracle Package Procedure S10B80.BANINST1.VRSKFOLR Rely On
P_VR_GRADE_MODE_OPT Oracle Package Procedure S10B80.BANINST1.VRSKFREG Rely On
P_VR_LIST_CURRENT_CLASSES Oracle Package Procedure S10B80.BANINST1.VRSKFORG Rely On
P_VR_START_DATE_OPT Oracle Package Procedure S10B80.BANINST1.VRSKFOLR Rely On
P_VR_VERIFY_START_DATE_OPT Oracle Package Procedure S10B80.BANINST1.VRSKFOLR Rely On
P_VR_WITHDRAW_FROM_TERM Oracle Package Procedure S10B80.BANINST1.VRSKFORG Rely On
P_WRITE_GRADE_DETAIL Oracle Package Procedure S10B80.BANINST1.BWSKSMRK Rely On
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_CLASSTIMES Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_TRANSCRIPT_REQ_NAME Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_SECTION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_COURSE Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_WL_NOTIFICATION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_COURSE_LABOR Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_SECTION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_CRSE_SELECT_PRI Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_SECTION_LABOR Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_FACASSIGNMENT Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_FACULTY Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_WL_COLLECTOR Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_WL_SECTION_CTRL Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_CATLG_INT_PARTNER Use (Insert,select)
UT_TEARDOWN Oracle Package Procedure S10B80.BANINST1.UT_GB_SECTION Use (delete)
F_CALC_VALID_COURSE_LDIMODE Oracle Package Function S10B80.BANINST1.ICSCKCOM Rely On
F_CHECK_BILL_HRS Oracle Package Function S10B80.BANINST1.SB_SECTION_RULES Rely On
F_CHECK_CONT_HRS Oracle Package Function S10B80.BANINST1.SB_SECTION_RULES Rely On
F_CHECK_CREDIT_HRS Oracle Package Function S10B80.BANINST1.SB_SECTION_RULES Rely On
F_CHECK_LAB_HRS Oracle Package Function S10B80.BANINST1.SB_SECTION_RULES Rely On
F_CHECK_LEC_HRS Oracle Package Function S10B80.BANINST1.SB_SECTION_RULES Rely On
F_CHECK_OTH_HRS Oracle Package Function S10B80.BANINST1.SB_SECTION_RULES Rely On
F_COURSE_TITLE Oracle Package Function S10B80.BANINST1.BWCKLIBS Rely On
F_EXISTS Oracle Package Function S10B80.BANINST1.SB_COURSE Rely On
F_EXISTS Oracle Package Function S10B80.BANINST1.SB_COURSE Use (select)
F_GETCRNCOURSETITLE Oracle Package Function S10B80.BANINST1.SSKWEVN Rely On
F_GET_COURSE Oracle Package Function S10B80.BANINST1.ICSCKLDI Rely On
F_GET_COURSE Oracle Package Function S10B80.BANINST1.ICSCKCOM Rely On
F_GET_COURSE Oracle Package Function S10B80.BANINST1.ICSCKCOM Use (select)Rely On
F_GET_COURSES Oracle Package Function S10B80.BANINST1.SP_CATALOG_EXPORT Use (select)
F_GET_COURSE_EVENT_HEADER Oracle Package Function S10B80.BANINST1.ICSCKCOM Rely On
F_GET_CRSE_TITLE Oracle Package Function S10B80.BANINST1.EOK497R Rely On
F_GET_CRSE_TITLE Oracle Package Function S10B80.BANINST1.EOK497R Use (select)
F_GET_DASHBOARD Oracle Package Function S10B80.BANINST1.CHNLSKBL Use (select)
F_GET_DASHBOARD_COUNT Oracle Package Function S10B80.BANINST1.CHNLSKBL Use (select)
F_GET_DASHBOARD_COUNT Oracle Package Function S10B80.BANINST1.BWLCBREF Use (select)
F_GET_DASHBOARD_CRN Oracle Package Function S10B80.BANINST1.CHNLSKBL Use (select)
F_GET_DASHBOARD_SUBJ Oracle Package Function S10B80.BANINST1.BWLCBREF Use (select)
F_GET_DASHBOARD_TERM Oracle Package Function S10B80.BANINST1.BWLCBREF Use (select)
F_GET_EXTRACT Oracle Package Function S10B80.BANINST1.SB_COURSE_CATALOG Use (select)
F_GET_SCBCRSE_MAX_TERM_CODE Oracle Package Function S10B80.BANINST1.SCKSELS Rely On
F_GET_SCBCRSE_MAX_TERM_CODE Oracle Package Function S10B80.BANINST1.SCKSELS Use (select)
F_GET_SCBCRSE_REC Oracle Package Function S10B80.BANINST1.SCKSELS Rely On
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.SB_COURSE Rely On
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.SB_COURSE Use (select)
F_QUERY_BY_ROWID Oracle Package Function S10B80.BANINST1.SB_COURSE Use (select)
F_QUERY_CURRENT Oracle Package Function S10B80.BANINST1.SB_COURSE Rely On
F_QUERY_CURRENT Oracle Package Function S10B80.BANINST1.SB_COURSE Use (select)
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.SB_COURSE Rely On
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.SB_COURSE Use (select)
F_QUERY_ONE_LOCK Oracle Package Function S10B80.BANINST1.SB_COURSE Rely On
F_QUERY_ONE_LOCK Oracle Package Function S10B80.BANINST1.SB_COURSE Use (select)
F_SCBCRSE_ALT Oracle Package Function S10B80.BANINST1.LM_COURSE_CATALOG Use (select)
TEST1 Oracle Package Function S10B80.BANINST1.P_TEST_XML Use (select)
TEST1 Oracle Package Function S10B80.BANINST1.TESTPACK Use (select)
SCBCRSE Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCBCRSE_KEY_INDEX SQL Index S10B80.SATURN Rely On
GTVDUNT SQL Table S10B80.GENERAL Refer (no action)
SCBCRKY SQL Table S10B80.SATURN Join
SCBDESC SQL Table S10B80.SATURN Join
SHBGSCH SQL Table S10B80.SATURN Join
SSBSECT SQL Table S10B80.SATURN Join
STVAPRV SQL Table S10B80.SATURN Refer (no action)
STVCIPC SQL Table S10B80.SATURN Refer (no action)
STVCOLL SQL Table S10B80.SATURN Refer (no action)
STVCSTA SQL Table S10B80.SATURN Refer (no action)
STVDEPT SQL Table S10B80.SATURN Refer (no action)
STVDIVS SQL Table S10B80.SATURN Refer (no action)
STVPWAV SQL Table S10B80.SATURN Refer (no action)
STVREPS SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)
ET_SCBCRSE_ADR_EXTSOL_497 SQL Trigger S10B80.BANIMGR Fire (delete,after,each row)
ET_SCBCRSE_AIR_EXTSOL_497 SQL Trigger S10B80.BANIMGR Fire (Insert,after,each row)
ET_SCBCRSE_AUR_EXTSOL_497 SQL Trigger S10B80.BANIMGR Fire (update,after,each row)
ST_SCBCRSE_AR_LDI SQL Trigger S10B80.SATURN Fire (Insert,update,delete,after,each row)
ST_SCBCRSE_AS_LDI SQL Trigger S10B80.SATURN Fire (Insert,update,delete,after,all rows)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCBCRSE

Object Dates

Creation Date Analysis Date
04/02/2008 21:00:10:000 04/02/2008 21:18:20:000

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

Columns Comments for SCBCRSE_DATA_ORIGIN (# 40)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SCBCRSE_USER_ID (# 41)

Source Code Comments

USER ID: User who inserted or last update the data

Table SCBDESC

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCBDESC_SUBJ_CODE   VARCHAR2(4) No   *
SCBDESC_CRSE_NUMB   VARCHAR2(5) No    
SCBDESC_TERM_CODE_EFF   VARCHAR2(6) No   *
SCBDESC_ACTIVITY_DATE   DATE No    
SCBDESC_USER_ID   VARCHAR2(30) No    
SCBDESC_TEXT_NARRATIVE   CLOB Yes    
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
SCBDESC_TERM_CODE_EFF STVTERM_CODE STVTERM
SCBDESC_TERM_CODE_END STVTERM_CODE STVTERM

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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCBCRSE SQL Table S10B80.SATURN Join
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DELETE Oracle Package Procedure S10B80.BANINST1.DML_SCBDESC Use (delete)
P_DISPLAY_INFO Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)
P_INSERT Oracle Package Procedure S10B80.BANINST1.DML_SCBDESC Use (Insert)Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.DML_SCBDESC Rely On
F_GETDESCCLOB Oracle Package Function S10B80.BANINST1.SCKSELS Use (select)
F_GET_SCBDESC_TEXT_NAR Oracle Package Function S10B80.BANINST1.SCKSELS Rely On
F_GET_SCBDESC_TEXT_NAR Oracle Package Function S10B80.BANINST1.SCKSELS Use (select)
F_SCBCRSE_ALT Oracle Package Function S10B80.BANINST1.LM_COURSE_CATALOG Use (select)
SCBDESC Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
UK_SCBDESC SQL Index S10B80.SATURN Rely On
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCBDESC

Object Dates

Creation Date Analysis Date
04/02/2008 20:47:50:000 04/02/2008 21:18:11:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCBSUPP_SUBJ_CODE   VARCHAR2(4) No * *
SCBSUPP_CRSE_NUMB   VARCHAR2(5) No * *
SCBSUPP_EFF_TERM   VARCHAR2(6) No * *
SCBSUPP_TOPS_CODE   VARCHAR2(6) Yes   *
SCBSUPP_OCCS_CODE   VARCHAR2(2) Yes   *
SCBSUPP_CCSL_CODE   VARCHAR2(2) Yes   *
SCBSUPP_COOP_ED_IND   VARCHAR2(1) Yes    
SCBSUPP_ACTIVITY_DATE   DATE No    
SCBSUPP_PERM_DIST_IND   VARCHAR2(12) Yes    
SCBSUPP_CUDA_CODE   VARCHAR2(15) Yes   *
SCBSUPP_CUDB_CODE   VARCHAR2(15) Yes   *
SCBSUPP_CUDC_CODE   VARCHAR2(15) Yes   *
SCBSUPP_CUDD_CODE   VARCHAR2(15) Yes   *
SCBSUPP_CUDE_CODE   VARCHAR2(15) Yes   *
SCBSUPP_CUDF_CODE   VARCHAR2(15) Yes   *
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_OCCS_CODE STVOCCS_CODE STVOCCS
SCBSUPP_SUBJ_CODE STVSUBJ_CODE STVSUBJ
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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
SCBSUPP Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SCBSUPP SQL Index S10B80.SATURN Rely On
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVCCSL SQL Table S10B80.SATURN Refer (no action)
STVCUDA SQL Table S10B80.SATURN Refer (no action)
STVCUDB SQL Table S10B80.SATURN Refer (no action)
STVCUDC SQL Table S10B80.SATURN Refer (no action)
STVCUDD SQL Table S10B80.SATURN Refer (no action)
STVCUDE SQL Table S10B80.SATURN Refer (no action)
STVCUDF SQL Table S10B80.SATURN Refer (no action)
STVOCCS SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)
STVTOPS SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCBSUPP

Object Dates

Creation Date Analysis Date
04/02/2008 20:45:11:000 04/02/2008 21:18:08:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRATTR_SUBJ_CODE   VARCHAR2(4) No   *
SCRATTR_CRSE_NUMB   VARCHAR2(5) No   *
SCRATTR_EFF_TERM   VARCHAR2(6) No   *
SCRATTR_ATTR_CODE   VARCHAR2(4) Yes   *
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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
F_GET_SCRATTR_ROWID SQL Function S10B80.BANINST1 Use (select)
F_MORE_ATTRIBUTES SQL Function S10B80.BANINST1 Use (select)
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.SB_COURSE_CATALOG Rely On
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.SB_COURSE_CATALOG Use (select)Rely On
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
P_DISPLAY_INFO Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAY_INFO Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)
F_GET_COURSES Oracle Package Function S10B80.BANINST1.SP_CATALOG_EXPORT Use (select)
F_SCBCRSE_ALT Oracle Package Function S10B80.BANINST1.LM_COURSE_CATALOG Use (select)
F_SCRATTR_VALUE Oracle Package Function S10B80.BANINST1.SCKSELS Rely On
F_SCRATTR_VALUE Oracle Package Function S10B80.BANINST1.SCKSELS Use (select)
SCRATTR Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRATTR_KEY_INDEX SQL Index S10B80.SATURN Rely On
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVATTR SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRATTR

Object Dates

Creation Date Analysis Date
04/02/2008 21:01:34:000 04/02/2008 21:18:21:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRCDTX_COLL_CODE   VARCHAR2(2) No   *
SCRCDTX_DEPT_CODE   VARCHAR2(4) Yes   *
SCRCDTX_EFF_TERM   VARCHAR2(6) No   *
SCRCDTX_SEQNO   NUMBER(23,20) Yes    
SCRCDTX_TEXT   VARCHAR2(60) Yes    
SCRCDTX_TEXT_CODE   VARCHAR2(1) Yes    
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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRCDTX_KEY_INDEX SQL Index S10B80.SATURN Rely On
STVCOLL SQL Table S10B80.SATURN Refer (no action)
STVDEPT SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRCDTX

Object Dates

Creation Date Analysis Date
04/02/2008 20:48:41:000 04/02/2008 21:18:11:000

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 SCRCLBD

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRCLBD_SUBJ_CODE   VARCHAR2(4) No * *
SCRCLBD_CRSE_NUMB   VARCHAR2(5) No *  
SCRCLBD_TERM_CODE_EFF   VARCHAR2(6) No * *
SCRCLBD_SEQ_NO   NUMBER(3,0) No *  
SCRCLBD_PERCENT   NUMBER(5,2) No    
SCRCLBD_ACTIVITY_DATE   DATE No    
SCRCLBD_USER_ID   VARCHAR2(30) No    
SCRCLBD_DATA_ORIGIN   VARCHAR2(30) Yes    
SCRCLBD_COAS_CODE   VARCHAR2(1) Yes    
SCRCLBD_ACCI_CODE   VARCHAR2(6) Yes    
SCRCLBD_FUND_CODE   VARCHAR2(6) Yes    
SCRCLBD_ORGN_CODE   VARCHAR2(6) Yes    
SCRCLBD_ACCT_CODE   VARCHAR2(6) Yes    
SCRCLBD_PROG_CODE   VARCHAR2(6) Yes    
SCRCLBD_ACTV_CODE   VARCHAR2(6) Yes    
SCRCLBD_LOCN_CODE   VARCHAR2(6) Yes    
SCRCLBD_PROJ_CODE   VARCHAR2(8) Yes    
SCRCLBD_CTYP_CODE   VARCHAR2(2) Yes    
SCRCLBD_ACCT_EXTERNAL_CDE   VARCHAR2(60) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRCLBD_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRCLBD_TERM_CODE_EFF STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SCRCLBD Unique SCRCLBD_SUBJ_CODE
PK_SCRCLBD Unique SCRCLBD_CRSE_NUMB
PK_SCRCLBD Unique SCRCLBD_TERM_CODE_EFF
PK_SCRCLBD Unique SCRCLBD_SEQ_NO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
COURSE_LABOR_REC Oracle Package Type S10B80.BANINST1.SB_COURSE_LABOR Rely On
P_OVERLAY_VALIDATION_REC Oracle Package Procedure S10B80.BANINST1.SB_COURSE_LABOR Rely On
F_BUILD_SCRCLBD_REC Oracle Package Function S10B80.BANINST1.SB_COURSE_LABOR Rely On
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_COURSE_LABOR Rely On
P_DELETE Oracle Package Procedure S10B80.BANINST1.DML_SCRCLBD Use (delete)
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE_LABOR Rely On
P_INSERT Oracle Package Procedure S10B80.BANINST1.DML_SCRCLBD Use (Insert)Rely On
P_LOCK Oracle Package Procedure S10B80.BANINST1.SB_COURSE_LABOR Rely On
P_LOCK Oracle Package Procedure S10B80.BANINST1.SB_COURSE_LABOR Use (select)
P_REGISTER_ENTITY Oracle Package Procedure S10B80.BANINST1.SB_COURSE_LABOR_RULES Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.DML_SCRCLBD Use (update)Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.SB_COURSE_LABOR Rely On
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.SB_COURSE_LABOR_RULES Rely On
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_CLASSTIMES Use (select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_COURSE_LABOR Use (select)
F_EXISTS Oracle Package Function S10B80.BANINST1.SB_COURSE_LABOR Rely On
F_EXISTS Oracle Package Function S10B80.BANINST1.SB_COURSE_LABOR Use (select)
F_PARENT_EXISTS Oracle Package Function S10B80.BANINST1.SB_COURSE_LABOR_RULES Rely On
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.SB_COURSE_LABOR Rely On
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.SB_COURSE_LABOR Use (select)
F_QUERY_BY_ROWID Oracle Package Function S10B80.BANINST1.SB_COURSE_LABOR Use (select)
F_QUERY_BY_TERM Oracle Package Function S10B80.BANINST1.SB_COURSE_LABOR Rely On
F_QUERY_BY_TERM Oracle Package Function S10B80.BANINST1.SB_COURSE_LABOR Use (select)
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.SB_COURSE_LABOR Rely On
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.SB_COURSE_LABOR Use (select)
F_QUERY_ONE_LOCK Oracle Package Function S10B80.BANINST1.SB_COURSE_LABOR Rely On
F_QUERY_ONE_LOCK Oracle Package Function S10B80.BANINST1.SB_COURSE_LABOR Use (select)
SCRCLBD Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SCRCLBD SQL Index S10B80.SATURN Rely On
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRCLBD

Object Dates

Creation Date Analysis Date
04/02/2008 20:48:13:000 04/02/2008 21:18:11:000

Source Code Comments

Course Labor Distribution Table

Columns Comments for SCRCLBD_SUBJ_CODE (# 1)

Source Code Comments

SUBJECT CODE: The subject area of the course.

Columns Comments for SCRCLBD_CRSE_NUMB (# 2)

Source Code Comments

COURSE NUMBER: The course number associated with the subject for the course.

Columns Comments for SCRCLBD_TERM_CODE_EFF (# 3)

Source Code Comments

EFFECTIVE TERM CODE: The term code when the course becomes effective.

Columns Comments for SCRCLBD_SEQ_NO (# 4)

Source Code Comments

SEQUENCE NUMBER: Sequence number of the course labor distribution information.

Columns Comments for SCRCLBD_PERCENT (# 5)

Source Code Comments

PERCENTAGE: Percent of pay to be applied to this labor distribution.

Columns Comments for SCRCLBD_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: Date of last activity (insert or update) on the record.

Columns Comments for SCRCLBD_USER_ID (# 7)

Source Code Comments

USER ID: The Oracle ID of the user who changed the record.

Columns Comments for SCRCLBD_DATA_ORIGIN (# 8)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Columns Comments for SCRCLBD_COAS_CODE (# 9)

Source Code Comments

CHART OF ACCOUNTS CODE: The primary identification code for a chart of accounts. Valued only if Banner Finance is installed.

Columns Comments for SCRCLBD_ACCI_CODE (# 10)

Source Code Comments

ACCOUNT INDEX: An index code used to default the account distribution to which the position should be charged. Valued only if Banner Finance is installed.

Columns Comments for SCRCLBD_FUND_CODE (# 11)

Source Code Comments

FUND: The fund code to which a position should be charged. Valued only if Banner Finance is installed.

Columns Comments for SCRCLBD_ORGN_CODE (# 12)

Source Code Comments

ORGANIZATION: The organization to which a position should be charged. Valued only if Banner Finance is installed.

Columns Comments for SCRCLBD_ACCT_CODE (# 13)

Source Code Comments

ACCOUNT: The account code to which a position should be charged. Valued only if Banner Finance is installed.

Columns Comments for SCRCLBD_PROG_CODE (# 14)

Source Code Comments

PROGRAM: The program code to which a position should be charged. Valued only if Banner Finance is installed.

Columns Comments for SCRCLBD_ACTV_CODE (# 15)

Source Code Comments

ACTIVITY: The activity code to which a position should be charged. Valued only if Banner Finance is installed.

Columns Comments for SCRCLBD_LOCN_CODE (# 16)

Source Code Comments

LOCATION: The location code to which a position should be charged. Valued only if Banner Finance is installed.

Columns Comments for SCRCLBD_PROJ_CODE (# 17)

Source Code Comments

PROJECT: The project code within the Finance Cost Accounting Module. Valued only if Banner Finance is installed.

Columns Comments for SCRCLBD_CTYP_CODE (# 18)

Source Code Comments

COST TYPE: The cost type within the Finance Cost Accounting Module. Valued only if Banner Finance is installed.

Columns Comments for SCRCLBD_ACCT_EXTERNAL_CDE (# 19)

Source Code Comments

EXTERNAL ACCOUNT CODE: A free-form account code to allow updates to an accounting system other than Banner Finance.

Table SCRCORQ

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRCORQ_SUBJ_CODE   VARCHAR2(4) No   *
SCRCORQ_CRSE_NUMB   VARCHAR2(5) No   *
SCRCORQ_EFF_TERM   VARCHAR2(6) No   *
SCRCORQ_SUBJ_CODE_CORQ   VARCHAR2(4) Yes   *
SCRCORQ_CRSE_NUMB_CORQ   VARCHAR2(5) Yes    
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_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRCORQ_SUBJ_CODE_CORQ STVSUBJ_CODE STVSUBJ
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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
F_CHECK_FOR_COURSE_COREQS SQL Function S10B80.BANINST1 Use (select)
SCRCORQC Oracle Package Cursor S10B80.BANINST1.SCKLIBS Use (select)Rely On
P_CHECK_CORQ_SFTREGS Oracle Package Procedure S10B80.BANINST1.SFKFUNC Use (select)
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DISPLAYCOREQUISITES Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAYCOREQUISITES Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
SCRCORQ Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRCORQ_KEY_INDEX SQL Index S10B80.SATURN Rely On
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
SSBSECT SQL Table S10B80.SATURN Join
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRCORQ

Object Dates

Creation Date Analysis Date
04/02/2008 21:04:58:000 04/02/2008 21:18:24:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRCPRT_SUBJ_CODE   VARCHAR2(4) No   *
SCRCPRT_CRSE_NUMB   VARCHAR2(5) No    
SCRCPRT_TERM_CODE_EFF   VARCHAR2(6) No   *
SCRCPRT_ACTIVITY_DATE   DATE No    
SCRCPRT_USER_ID   VARCHAR2(30) No    
SCRCPRT_PARS_CODE   VARCHAR2(7) Yes   *
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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
SCRCPRT Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
UK1_SCRCPRT SQL Index S10B80.SATURN Rely On
GTVPARS SQL Table S10B80.GENERAL Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRCPRT

Object Dates

Creation Date Analysis Date
04/02/2008 20:35:36:000 04/02/2008 21:17:59:000

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

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRCRDF_SUBJ_CODE   VARCHAR2(4) No   *
SCRCRDF_CRSE_NUMB   VARCHAR2(5) No    
SCRCRDF_TERM_CODE_EFF   VARCHAR2(6) No   *
SCRCRDF_ACTIVITY_DATE   DATE No    
SCRCRDF_USER_ID   VARCHAR2(30) No    
SCRCRDF_RDEF_CODE   VARCHAR2(4) Yes   *
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_RDEF_CODE STVRDEF_CODE STVRDEF
SCRCRDF_TERM_CODE_EFF STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
UK1_SCRCRDF Unique SCRCRDF_SUBJ_CODE
UK1_SCRCRDF Unique SCRCRDF_CRSE_NUMB
UK1_SCRCRDF Unique SCRCRDF_RDEF_CODE
UK1_SCRCRDF Unique SCRCRDF_TERM_CODE_EFF

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
SCRCRDF Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
UK1_SCRCRDF SQL Index S10B80.SATURN Rely On
STVRDEF SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRCRDF

Object Dates

Creation Date Analysis Date
04/02/2008 20:42:07:000 04/02/2008 21:18:05:000

Source Code Comments

Room definition/attribute Codes for catalog entries. This describes characteristics of rooms required for the scheduling tool.

Columns Comments for SCRCRDF_SUBJ_CODE (# 1)

Source Code Comments

Subject code for catalog course room definition/attributes.

Columns Comments for SCRCRDF_CRSE_NUMB (# 2)

Source Code Comments

Course Number for catalog course room definition/attributes.

Columns Comments for SCRCRDF_TERM_CODE_EFF (# 3)

Source Code Comments

Effective Term code for catalog course room definition/attribute code.

Columns Comments for SCRCRDF_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for SCRCRDF_USER_ID (# 5)

Source Code Comments

User ID of last person to create/update record.

Columns Comments for SCRCRDF_RDEF_CODE (# 6)

Source Code Comments

Room definition/attribute code for catalog course entry.

Columns Comments for SCRCRDF_RDEF_PREF_NUMBER (# 7)

Source Code Comments

Preference Number for room definition/attribute code for catalog course entry.

Table SCREQIV

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCREQIV_SUBJ_CODE   VARCHAR2(4) No   *
SCREQIV_CRSE_NUMB   VARCHAR2(5) No   *
SCREQIV_EFF_TERM   VARCHAR2(6) No   *
SCREQIV_SUBJ_CODE_EQIV   VARCHAR2(4) Yes   *
SCREQIV_CRSE_NUMB_EQIV   VARCHAR2(5) Yes    
SCREQIV_START_TERM   VARCHAR2(6) Yes   *
SCREQIV_END_TERM   VARCHAR2(6) Yes   *
SCREQIV_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
SCREQIV_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCREQIV_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCREQIV_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCREQIV_SUBJ_CODE_EQIV STVSUBJ_CODE STVSUBJ
SCREQIV_START_TERM STVTERM_CODE STVTERM
SCREQIV_END_TERM STVTERM_CODE STVTERM
SCREQIV_EFF_TERM STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
SCREQIV_EQIV_INDEX   SCREQIV_SUBJ_CODE_EQIV
SCREQIV_EQIV_INDEX   SCREQIV_CRSE_NUMB_EQIV
UK_SCREQIV Unique SCREQIV_SUBJ_CODE
UK_SCREQIV Unique SCREQIV_CRSE_NUMB
UK_SCREQIV Unique SCREQIV_EFF_TERM
UK_SCREQIV Unique SCREQIV_SUBJ_CODE_EQIV
UK_SCREQIV Unique SCREQIV_CRSE_NUMB_EQIV
UK_SCREQIV Unique SCREQIV_START_TERM

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCREQIV1_C Oracle Package Cursor S10B80.BANINST1.SFKFUNC Use (select)
SCREQIV2_C Oracle Package Cursor S10B80.BANINST1.SFKFUNC Use (select)
P_COUNT_REPEAT_UNITS Oracle Package Procedure S10B80.BANINST1.SHKRPTS Rely On
P_COUNT_REPEAT_UNITS Oracle Package Procedure S10B80.BANINST1.SHKRPTS Use (select)
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_GET_REPEAT_DATA Oracle Package Procedure S10B80.BANINST1.SFKFUNC Use (select)
SCREQIV Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCREQIV_EQIV_INDEX SQL Index S10B80.SATURN Rely On
UK_SCREQIV SQL Index S10B80.SATURN Rely On
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCREQIV

Object Dates

Creation Date Analysis Date
04/02/2008 21:05:05:000 04/02/2008 21:18:24:000

Source Code Comments

Equivalent Course Repeating Table

Columns Comments for SCREQIV_SUBJ_CODE (# 1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCREQIV_CRSE_NUMB (# 2)

Source Code Comments

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

Columns Comments for SCREQIV_EFF_TERM (# 3)

Source Code Comments

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

Columns Comments for SCREQIV_SUBJ_CODE_EQIV (# 4)

Source Code Comments

This field defines an equivalent course subject code for the master course. Defining equivalents for a course is optional. An unlimited number of equivalents can be authorized for a course.

Columns Comments for SCREQIV_CRSE_NUMB_EQIV (# 5)

Source Code Comments

This field defines the course number of the equivalent course. Course numbers are not validated against valid course versions.

Columns Comments for SCREQIV_START_TERM (# 6)

Source Code Comments

This field specifies the start term of the course version which is equivalent to the course entered in the Key Block.

Columns Comments for SCREQIV_END_TERM (# 7)

Source Code Comments

This field is used to specify the end term of the course version which is equivalent to the course entered in the Key Block.

Columns Comments for SCREQIV_ACTIVITY_DATE (# 8)

Source Code Comments

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

Table SCRFEES

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRFEES_SUBJ_CODE   VARCHAR2(4) No   *
SCRFEES_CRSE_NUMB   VARCHAR2(5) No   *
SCRFEES_EFF_TERM   VARCHAR2(6) No   *
SCRFEES_DETL_CODE   VARCHAR2(4) Yes    
SCRFEES_FEE_IND   VARCHAR2(1) Yes    
SCRFEES_FEE_IND_IND   NUMBER(1,0) Yes    
SCRFEES_FEE_AMOUNT   NUMBER(12,2) Yes    
SCRFEES_ACTIVITY_DATE   DATE No    
SCRFEES_FTYP_CODE   VARCHAR2(4) Yes   *
SCRFEES_LEVL_CODE_STDN   VARCHAR2(2) Yes   *
SCRFEES_COLL_CODE   VARCHAR2(2) Yes   *
SCRFEES_CAMP_CODE   VARCHAR2(3) Yes   *
SCRFEES_PROGRAM   VARCHAR2(12) Yes   *
SCRFEES_DEGC_CODE   VARCHAR2(6) Yes   *
SCRFEES_TERM_CODE_ADMIT   VARCHAR2(6) Yes   *
SCRFEES_RATE_CODE_CURRIC   VARCHAR2(5) Yes   *
SCRFEES_STYP_CODE_CURRIC   VARCHAR2(1) Yes   *
SCRFEES_LFST_CODE   VARCHAR2(15) Yes   *
SCRFEES_MAJR_CODE   VARCHAR2(4) Yes   *
SCRFEES_DEPT_CODE   VARCHAR2(4) Yes   *
SCRFEES_PRIM_SEC_CDE   VARCHAR2(1) Yes    
SCRFEES_RESD_CODE   VARCHAR2(1) Yes   *
SCRFEES_CLAS_CODE   VARCHAR2(2) Yes   *
SCRFEES_RATE_CODE   VARCHAR2(5) Yes   *
SCRFEES_STYP_CODE   VARCHAR2(1) Yes   *
SCRFEES_ATTS_CODE   VARCHAR2(4) Yes   *
SCRFEES_CHRT_CODE   VARCHAR2(10) Yes   *
SCRFEES_VTYP_CODE   VARCHAR2(2) Yes   *
SCRFEES_SEQ_NO   NUMBER(4,0) No    
SCRFEES_USER_ID   VARCHAR2(30) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRFEES_LFST_CODE GTVLFST_CODE GTVLFST
SCRFEES_ATTS_CODE STVATTS_CODE STVATTS
SCRFEES_CAMP_CODE STVCAMP_CODE STVCAMP
SCRFEES_CHRT_CODE STVCHRT_CODE STVCHRT
SCRFEES_CLAS_CODE STVCLAS_CODE STVCLAS
SCRFEES_COLL_CODE STVCOLL_CODE STVCOLL
SCRFEES_DEGC_CODE STVDEGC_CODE STVDEGC
SCRFEES_DEPT_CODE STVDEPT_CODE STVDEPT
SCRFEES_FTYP_CODE STVFTYP_CODE STVFTYP
SCRFEES_MAJR_CODE STVMAJR_CODE STVMAJR
SCRFEES_RATE_CODE_CURRIC STVRATE_CODE STVRATE
SCRFEES_RATE_CODE STVRATE_CODE STVRATE
SCRFEES_RESD_CODE STVRESD_CODE STVRESD
SCRFEES_STYP_CODE STVSTYP_CODE STVSTYP
SCRFEES_STYP_CODE_CURRIC STVSTYP_CODE STVSTYP
SCRFEES_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRFEES_VTYP_CODE STVVTYP_CODE STVVTYP
SCRFEES_LEVL_CODE_STDN STVLEVL_CODE STVLEVL
SCRFEES_PROGRAM SMRPRLE_PROGRAM SMRPRLE
SCRFEES_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCRFEES_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCRFEES_EFF_TERM STVTERM_CODE STVTERM
SCRFEES_TERM_CODE_ADMIT STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
UK_SCRFEES Unique SCRFEES_SUBJ_CODE
UK_SCRFEES Unique SCRFEES_CRSE_NUMB
UK_SCRFEES Unique SCRFEES_EFF_TERM
UK_SCRFEES Unique SCRFEES_DETL_CODE
UK_SCRFEES Unique SCRFEES_FTYP_CODE
UK_SCRFEES Unique SCRFEES_SEQ_NO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
P_DELETE_ALL Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBCVAR Use (delete,select)
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
SCRFEES Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
UK_SCRFEES SQL Index S10B80.SATURN Rely On
GTVLFST SQL Table S10B80.GENERAL Refer (no action)
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
SMRPRLE SQL Table S10B80.SATURN Refer (no action)
STVATTS SQL Table S10B80.SATURN Refer (no action)
STVCAMP SQL Table S10B80.SATURN Refer (no action)
STVCHRT SQL Table S10B80.SATURN Refer (no action)
STVCLAS SQL Table S10B80.SATURN Refer (no action)
STVCOLL SQL Table S10B80.SATURN Refer (no action)
STVDEGC SQL Table S10B80.SATURN Refer (no action)
STVDEPT SQL Table S10B80.SATURN Refer (no action)
STVFTYP SQL Table S10B80.SATURN Refer (no action)
STVLEVL SQL Table S10B80.SATURN Refer (no action)
STVMAJR SQL Table S10B80.SATURN Refer (no action)
STVRATE SQL Table S10B80.SATURN Refer (no action)
STVRESD SQL Table S10B80.SATURN Refer (no action)
STVSTYP SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)
STVVTYP SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRFEES

Object Dates

Creation Date Analysis Date
04/02/2008 20:56:37:000 04/02/2008 21:18:17:000

Source Code Comments

Course Fees Repeating Table

Columns Comments for SCRFEES_SUBJ_CODE (# 1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCRFEES_CRSE_NUMB (# 2)

Source Code Comments

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

Columns Comments for SCRFEES_EFF_TERM (# 3)

Source Code Comments

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

Columns Comments for SCRFEES_DETL_CODE (# 4)

Source Code Comments

This field defines detail codes which can be assessed for the course in the key block. Detail codes must have a type of C (charge) on the Detail Code Control Form - TSADETC.

Columns Comments for SCRFEES_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 SCRFEES_FEE_IND_IND (# 6)

Source Code Comments

This field is used to convert the fee indicator of F - flat or C - per credit to a 1 or 0. "F" is converted to a "1" and "C" is converted to a "0".

Columns Comments for SCRFEES_FEE_AMOUNT (# 7)

Source Code Comments

If Form TSADETC has a defined default amount for the detail code it will default here when the detail code is entered. If not, or the course fee is different than the default, the amount may be entered or changed here.

Columns Comments for SCRFEES_ACTIVITY_DATE (# 8)

Source Code Comments

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

Columns Comments for SCRFEES_FTYP_CODE (# 9)

Source Code Comments

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

Columns Comments for SCRFEES_LEVL_CODE_STDN (# 10)

Source Code Comments

LEVEL CODE: Level code of the curriculum.

Columns Comments for SCRFEES_COLL_CODE (# 11)

Source Code Comments

COLLEGE CODE: college code of the curriculum.

Columns Comments for SCRFEES_CAMP_CODE (# 12)

Source Code Comments

CAMPUS CODE: campus code of the curriculum.

Columns Comments for SCRFEES_PROGRAM (# 13)

Source Code Comments

PROGRAM: program of the curriculum.

Columns Comments for SCRFEES_DEGC_CODE (# 14)

Source Code Comments

DEGREE CODE: degree code of the curriculum.

Columns Comments for SCRFEES_TERM_CODE_ADMIT (# 15)

Source Code Comments

TERM ADMIT: term code learner was admitted to curriculum.

Columns Comments for SCRFEES_RATE_CODE_CURRIC (# 16)

Source Code Comments

CURRICULUM RATE CODE: This is the fee assessment rate code on the curriculum record.

Columns Comments for SCRFEES_STYP_CODE_CURRIC (# 17)

Source Code Comments

CURRICULUM STUDEN TYPE: This is the student type code on the curriculum record.

Columns Comments for SCRFEES_LFST_CODE (# 18)

Source Code Comments

FIELD OF STUDY TYPE: The field of study type the major code value should apply to.

Columns Comments for SCRFEES_MAJR_CODE (# 19)

Source Code Comments

MAJOR CODE: major code for the field of study.

Columns Comments for SCRFEES_DEPT_CODE (# 20)

Source Code Comments

DEPARTMENT CODE: department code associated with the major field of study.

Columns Comments for SCRFEES_PRIM_SEC_CDE (# 21)

Source Code Comments

PRIMARY SECONDARY CURRICULUM: A code value P(primary),S(secondary) or A(any) for choice of curriculum the rules should apply to.

Columns Comments for SCRFEES_RESD_CODE (# 22)

Source Code Comments

RESIDENCE: This field identifies the residency status of the student for the effective term

Columns Comments for SCRFEES_CLAS_CODE (# 23)

Source Code Comments

CLASS: Class code associated with the general student record and primary curriculum level code.

Columns Comments for SCRFEES_RATE_CODE (# 24)

Source Code Comments

RATE CODE: This is the fee assessment rate code on the general learner record.

Columns Comments for SCRFEES_STYP_CODE (# 25)

Source Code Comments

LEARNER TYPE: This describes the type of student on the general student record.

Columns Comments for SCRFEES_ATTS_CODE (# 26)

Source Code Comments

ATTRIBUTE: Attribute code on the general student record

Columns Comments for SCRFEES_CHRT_CODE (# 27)

Source Code Comments

COHORT: Cohort code on the general student record

Columns Comments for SCRFEES_VTYP_CODE (# 28)

Source Code Comments

VISA TYPE: Visa code for the person

Columns Comments for SCRFEES_SEQ_NO (# 29)

Source Code Comments

SEQ NUMBER: Sequence number for making a unique index.

Columns Comments for SCRFEES_USER_ID (# 30)

Source Code Comments

USER ID: ID of the user who created or last updated this record.

Table SCRGMOD

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRGMOD_SUBJ_CODE   VARCHAR2(4) No * *
SCRGMOD_CRSE_NUMB   VARCHAR2(5) No *  
SCRGMOD_EFF_TERM   VARCHAR2(6) No * *
SCRGMOD_GMOD_CODE   VARCHAR2(1) No * *
SCRGMOD_ACTIVITY_DATE   DATE No    
SCRGMOD_DEFAULT_IND   VARCHAR2(1) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRGMOD_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRGMOD_EFF_TERM STVTERM_CODE STVTERM
SCRGMOD_GMOD_CODE STVGMOD_CODE STVGMOD

Index

Index Name Index Type Column Name
PK_SCRGMOD Unique SCRGMOD_SUBJ_CODE
PK_SCRGMOD Unique SCRGMOD_CRSE_NUMB
PK_SCRGMOD Unique SCRGMOD_EFF_TERM
PK_SCRGMOD Unique SCRGMOD_GMOD_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SFRSTCR SQL Table S10B80.SATURN Join
SHRGRDO SQL Table S10B80.SATURN Join
F_DEFAULT_GMOD SQL Function S10B80.BANINST1 Use (select)
STVGMOD_SCRGMOD_RECTYPE Oracle Package Type S10B80.BANINST1.SFKCURS Rely On
SHRGRDE2C Oracle Package Cursor S10B80.BANINST1.BWLKINCG Rely On
SHRGRDE2C Oracle Package Cursor S10B80.BANINST1.BWLKINCG Use (select)
SHRGRDEC Oracle Package Cursor S10B80.BANINST1.BWLKINCG Rely On
SHRGRDEC Oracle Package Cursor S10B80.BANINST1.BWLKINCG Use (select)
P_DELETE_ALL Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBCVAR Use (delete,select)
SCRGMODC Oracle Package Cursor S10B80.BANINST1.SCKLIBS Use (select)Rely On
SCRGMODC Oracle Package Cursor S10B80.BANINST1.SFKCURS Use (select)
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Rely On
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (Insert)
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_FACFINGRD Oracle Package Procedure S10B80.BANINST1.BWLKFFGD Rely On
P_FACFINGRD Oracle Package Procedure S10B80.BANINST1.BWLKFFGD Use (select)
P_FACMIDGRD Oracle Package Procedure S10B80.BANINST1.BWLKFMGD Rely On
P_FACMIDGRD Oracle Package Procedure S10B80.BANINST1.BWLKFMGD Use (select)
P_GET_CRSE_GMOD_CODES Oracle Package Procedure S10B80.BANINST1.SCKSELS Rely On
P_GET_CRSE_GMOD_CODES Oracle Package Procedure S10B80.BANINST1.SCKSELS Use (select)
P_GET_MIN_GMOD Oracle Package Procedure S10B80.BANINST1.SCKSELS Rely On
P_GET_MIN_GMOD Oracle Package Procedure S10B80.BANINST1.SCKSELS Use (select)
P_UT_GRADEROLL Oracle Package Procedure S10B80.BANINST1.UT_GRADEROLL Use (delete)
P_VALIDATE_CHILDREN Oracle Package Procedure S10B80.BANINST1.SB_COURSE_RULES Rely On
P_VR_ADD_CLASS Oracle Package Procedure S10B80.BANINST1.VRSKFREG Rely On
P_VR_WAITLIST_OPT Oracle Package Procedure S10B80.BANINST1.VRSKFREG Rely On
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_SECTION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_SECTION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_FACASSIGNMENT Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_FACULTY Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_WL_SECTION_CTRL Use (Insert,select)
UT_TEARDOWN Oracle Package Procedure S10B80.BANINST1.UT_GB_SECTION Use (delete)
F_CHECK_GMOD Oracle Package Function S10B80.BANINST1.SB_SECTION_RULES Use (select)
F_CHECK_SCRGMOD_GMOD_CODE Oracle Package Function S10B80.BANINST1.SCKSELS Rely On
F_CHECK_SCRGMOD_GMOD_CODE Oracle Package Function S10B80.BANINST1.SCKSELS Use (select)
F_GET_DEFAULT_GMOD Oracle Package Function S10B80.BANINST1.SCKSELS Rely On
F_GET_DEFAULT_GMOD Oracle Package Function S10B80.BANINST1.SCKSELS Use (select)
SCRGMOD Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SCRGMOD SQL Index S10B80.SATURN Rely On
STVGMOD SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRGMOD

Object Dates

Creation Date Analysis Date
04/02/2008 20:40:21:000 04/02/2008 21:18:04:000

Source Code Comments

Course Grading Modes Repeating Table

Columns Comments for SCRGMOD_SUBJ_CODE (# 1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCRGMOD_CRSE_NUMB (# 2)

Source Code Comments

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

Columns Comments for SCRGMOD_EFF_TERM (# 3)

Source Code Comments

This field identifies the term this version of course grading modes becomes effective.

Columns Comments for SCRGMOD_GMOD_CODE (# 4)

Source Code Comments

This field is used to define grading mode authorizations for a course. Each course must be authorized to be offered with at least one grading mode. A course can be authorized with an unlimited number of grading modes.

Columns Comments for SCRGMOD_ACTIVITY_DATE (# 5)

Source Code Comments

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

Columns Comments for SCRGMOD_DEFAULT_IND (# 6)

Source Code Comments

This field is used to specify the grading mode which will default for the grading mode on the Registration Form - SFAREGS. At least one grading mode must be a default (D) and it may be overridden on the SFAREGS Form.

Table SCRINTG

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRINTG_SUBJ_CODE   VARCHAR2(4) No   *
SCRINTG_CRSE_NUMB   VARCHAR2(5) No   *
SCRINTG_TERM_CODE_EFF   VARCHAR2(6) No   *
SCRINTG_USER_ID   VARCHAR2(30) No    
SCRINTG_ACTIVITY_DATE   DATE No    
SCRINTG_INTG_CDE   VARCHAR2(5) Yes   *
SCRINTG_DATA_ORIGIN   VARCHAR2(30) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRINTG_INTG_CDE GORINTG_INTEGRATION_CDE GORINTG
SCRINTG_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRINTG_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCRINTG_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCRINTG_TERM_CODE_EFF STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
UK_SCRINTG Unique SCRINTG_SUBJ_CODE
UK_SCRINTG Unique SCRINTG_CRSE_NUMB
UK_SCRINTG Unique SCRINTG_TERM_CODE_EFF
UK_SCRINTG Unique SCRINTG_INTG_CDE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
ST_SCRINTG_AR_LDI SQL Trigger S10B80.SATURN Rely On
CATLG_INT_PARTNER_REC Oracle Package Type S10B80.BANINST1.SB_CATLG_INT_PARTNER Rely On
P_OVERLAY_VALIDATION_REC Oracle Package Procedure S10B80.BANINST1.SB_CATLG_INT_PARTNER Rely On
F_BUILD_SCRINTG_REC Oracle Package Function S10B80.BANINST1.SB_CATLG_INT_PARTNER Rely On
F_CALC_DELIVERY_SYSTEM Oracle Package Function S10B80.BANINST1.ICSCKCOM Rely On
F_CALC_DELIVERY_SYSTEM Oracle Package Function S10B80.BANINST1.ICSCKCOM Use (select)
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_CATLG_INT_PARTNER Rely On
P_DELETE Oracle Package Procedure S10B80.BANINST1.DML_SCRINTG Use (delete)
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_CATLG_INT_PARTNER Rely On
P_INSERT Oracle Package Procedure S10B80.BANINST1.DML_SCRINTG Use (Insert)Rely On
P_LOCK Oracle Package Procedure S10B80.BANINST1.SB_CATLG_INT_PARTNER Rely On
P_LOCK Oracle Package Procedure S10B80.BANINST1.SB_CATLG_INT_PARTNER Use (select)
P_REGISTER_ENTITY Oracle Package Procedure S10B80.BANINST1.SB_CATLG_INT_PARTNER_RULES Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.DML_SCRINTG Use (update)Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.SB_CATLG_INT_PARTNER Rely On
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.SB_CATLG_INT_PARTNER_RULES Rely On
F_EXISTS Oracle Package Function S10B80.BANINST1.SB_CATLG_INT_PARTNER Rely On
F_EXISTS Oracle Package Function S10B80.BANINST1.SB_CATLG_INT_PARTNER Use (select)
F_PARENT_EXISTS Oracle Package Function S10B80.BANINST1.SB_CATLG_INT_PARTNER_RULES Rely On
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.SB_CATLG_INT_PARTNER Rely On
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.SB_CATLG_INT_PARTNER Use (select)
F_QUERY_BY_ROWID Oracle Package Function S10B80.BANINST1.SB_CATLG_INT_PARTNER Use (select)
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.SB_CATLG_INT_PARTNER Rely On
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.SB_CATLG_INT_PARTNER Use (select)
F_QUERY_ONE_LOCK Oracle Package Function S10B80.BANINST1.SB_CATLG_INT_PARTNER Rely On
F_QUERY_ONE_LOCK Oracle Package Function S10B80.BANINST1.SB_CATLG_INT_PARTNER Use (select)
SCRINTG Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
UK_SCRINTG SQL Index S10B80.SATURN Rely On
GORINTG SQL Table S10B80.GENERAL Refer (no action)
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)
ST_SCRINTG_AR_LDI SQL Trigger S10B80.SATURN Fire (Insert,update,after,each row)
ST_SCRINTG_AS_LDI SQL Trigger S10B80.SATURN Fire (Insert,update,after,all rows)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRINTG

Object Dates

Creation Date Analysis Date
04/02/2008 20:38:04:000 04/02/2008 21:18:02:000

Source Code Comments

Integration Partners for Courses.

Columns Comments for SCRINTG_SUBJ_CODE (# 1)

Source Code Comments

SUBJECT CODE: Identifies the subject code of the course that the learning objective is attached to.

Columns Comments for SCRINTG_CRSE_NUMB (# 2)

Source Code Comments

COURSE NUMBER: Identifies the course number of the course that the learning objective is attached to.

Columns Comments for SCRINTG_TERM_CODE_EFF (# 3)

Source Code Comments

EFFECTIVE TERM: Identifies the Term for which the learning objective is effective.

Columns Comments for SCRINTG_USER_ID (# 4)

Source Code Comments

USER ID: Most recent user to create or update the record.

Columns Comments for SCRINTG_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: Most recent date the record was created or updated.

Columns Comments for SCRINTG_INTG_CDE (# 6)

Source Code Comments

INTEGRATION PARTNER SYSTEM CODE: Code defined on GORINTG that associates with the User Integration Code.

Columns Comments for SCRINTG_DATA_ORIGIN (# 7)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Table SCRLEVL

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRLEVL_SUBJ_CODE   VARCHAR2(4) No * *
SCRLEVL_CRSE_NUMB   VARCHAR2(5) No *  
SCRLEVL_EFF_TERM   VARCHAR2(6) No * *
SCRLEVL_LEVL_CODE   VARCHAR2(2) No * *
SCRLEVL_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRLEVL_LEVL_CODE STVLEVL_CODE STVLEVL
SCRLEVL_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRLEVL_EFF_TERM STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SCRLEVL Unique SCRLEVL_SUBJ_CODE
PK_SCRLEVL Unique SCRLEVL_CRSE_NUMB
PK_SCRLEVL Unique SCRLEVL_EFF_TERM
PK_SCRLEVL Unique SCRLEVL_LEVL_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
F_GET_COURSE_LEVELS SQL Function S10B80.BANINST1 Use (select)
STVLEVL_SCRLEVL_RECTYPE Oracle Package Type S10B80.BANINST1.SFKCURS Rely On
SCRLEVL_C Oracle Package Cursor S10B80.BANINST1.BWLKASGN Rely On
SCRLEVL_C Oracle Package Cursor S10B80.BANINST1.BWLKASGN Use (select)
SCRLEVL_C Oracle Package Cursor S10B80.BANINST1.BWCKSCHD Use (select)
P_DELETE_ALL Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBCVAR Use (delete,select)
P_GET_CRN_DATA Oracle Package Procedure S10B80.BANINST1.SFKMREG Rely On
P_GET_CRN_DATA Oracle Package Procedure S10B80.BANINST1.SFKREGS Rely On
SCRLEVLC Oracle Package Cursor S10B80.BANINST1.SCKLIBS Use (select)Rely On
SCRLEVLC Oracle Package Cursor S10B80.BANINST1.SFKCURS Use (select)
SSBDFEEC Oracle Package Cursor S10B80.BANINST1.SSKOLRP Use (select)
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Rely On
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (Insert)
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.SB_COURSE_CATALOG Use (select)
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)
P_DISPLAY_INFO Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAY_INFO Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)
P_FACSCHED Oracle Package Procedure S10B80.BANINST1.BWLKIFAC Rely On
P_FACSCHED Oracle Package Procedure S10B80.BANINST1.BWLKIFAC Use (select)
P_FAC_SYLLABUS Oracle Package Procedure S10B80.BANINST1.BWLKSYBS Use (select)
P_GET_COURSE Oracle Package Procedure S10B80.BANINST1.SFKFUNC Rely On
P_LISTCRSE Oracle Package Procedure S10B80.BANINST1.BWCKGENS Rely On
P_LISTCRSE Oracle Package Procedure S10B80.BANINST1.BWCKGENS Use (select)
P_UT_GRADEROLL Oracle Package Procedure S10B80.BANINST1.UT_GRADEROLL Use (delete)
P_VALIDATE_CHILDREN Oracle Package Procedure S10B80.BANINST1.SB_COURSE_RULES Rely On
P_VR_ADD_CLASS Oracle Package Procedure S10B80.BANINST1.VRSKFREG Rely On
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_SECTION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_SECTION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_FACASSIGNMENT Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_FACULTY Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_WL_SECTION_CTRL Use (Insert,select)
UT_TEARDOWN Oracle Package Procedure S10B80.BANINST1.UT_GB_SECTION Use (delete)
F_CHECK_SCRLEVL_LEVL_CODE Oracle Package Function S10B80.BANINST1.SCKSELS Rely On
F_CHECK_SCRLEVL_LEVL_CODE Oracle Package Function S10B80.BANINST1.SCKSELS Use (select)
F_GET_COURSES Oracle Package Function S10B80.BANINST1.SP_CATALOG_EXPORT Use (select)
F_GET_MIN_SCRLEVL Oracle Package Function S10B80.BANINST1.SCKSELS Rely On
F_GET_MIN_SCRLEVL Oracle Package Function S10B80.BANINST1.SCKSELS Use (select)
F_GET_MIN_SCRLEVL_BY_MULTI Oracle Package Function S10B80.BANINST1.SCKSELS Rely On
F_GET_MIN_SCRLEVL_BY_MULTI Oracle Package Function S10B80.BANINST1.SCKSELS Use (select)
F_GET_MIN_SCRLEVL_WITH_LEVL Oracle Package Function S10B80.BANINST1.SCKSELS Rely On
F_GET_MIN_SCRLEVL_WITH_LEVL Oracle Package Function S10B80.BANINST1.SCKSELS Use (select)
F_SCBCRSE_ALT Oracle Package Function S10B80.BANINST1.LM_COURSE_CATALOG Use (select)
F_VALIDLEVL Oracle Package Function S10B80.BANINST1.BWCKREGS Use (select)
SCRLEVL Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SCRLEVL SQL Index S10B80.SATURN Rely On
STVLEVL SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRLEVL

Object Dates

Creation Date Analysis Date
04/02/2008 20:36:55:000 04/02/2008 21:18:00:000

Source Code Comments

Course Level Repeating Table

Columns Comments for SCRLEVL_SUBJ_CODE (# 1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCRLEVL_CRSE_NUMB (# 2)

Source Code Comments

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

Columns Comments for SCRLEVL_EFF_TERM (# 3)

Source Code Comments

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

Columns Comments for SCRLEVL_LEVL_CODE (# 4)

Source Code Comments

This field is used to authorize the level for which a course may be offered. Each course must be authorized to be offered for at least one level. A course can be authorized for an unlimited number of levels.

Columns Comments for SCRLEVL_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table SCRRARE

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRRARE_SUBJ_CODE   VARCHAR2(4) No   *
SCRRARE_CRSE_NUMB   VARCHAR2(5) No    
SCRRARE_TERM_CODE_EFFECTIVE   VARCHAR2(6) No   *
SCRRARE_ACTIVITY_DATE   DATE No    
SCRRARE_SEQNO   NUMBER(23,20) Yes    
SCRRARE_AREA   VARCHAR2(10) Yes   *

Foreign Key information

Column name is Foreign Key For Column on Table
SCRRARE_AREA SMRALIB_AREA SMRALIB
SCRRARE_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRRARE_TERM_CODE_EFFECTIVE STVTERM_CODE STVTERM
SCRRARE_AREA SMBAGEN_AREA SMBAGEN

Index

Index Name Index Type Column Name
SCRRARE_KEY_INDEX Unique SCRRARE_SUBJ_CODE
SCRRARE_KEY_INDEX Unique SCRRARE_CRSE_NUMB
SCRRARE_KEY_INDEX Unique SCRRARE_TERM_CODE_EFFECTIVE
SCRRARE_KEY_INDEX Unique SCRRARE_SEQNO
SCRRARE_KEY_INDEX Unique SCRRARE_AREA

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DISPLAYAREAS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAYAREAS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
P_GETAREAREQUIREMENTS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_GETAREARULEREQUIREMENTS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_GETAREARWRREQ Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_GETATTACHEDGROUPS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_GETATTACHEDRULEREQ Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_GETATTACHEDRWRREQ Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
SCRRARE Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRRARE_KEY_INDEX SQL Index S10B80.SATURN Rely On
SMBAGEN SQL Table S10B80.SATURN Join
SMRALIB SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRRARE

Object Dates

Creation Date Analysis Date
04/02/2008 21:02:56:000 04/02/2008 21:18:22:000

Source Code Comments

Course Area Restriction Table.

Columns Comments for SCRRARE_SUBJ_CODE (# 1)

Source Code Comments

Course subject code

Columns Comments for SCRRARE_CRSE_NUMB (# 2)

Source Code Comments

Course number

Columns Comments for SCRRARE_TERM_CODE_EFFECTIVE (# 3)

Source Code Comments

Identifies the term this version of the course registration Area restriction becomes effective

Columns Comments for SCRRARE_ACTIVITY_DATE (# 4)

Source Code Comments

Date of last update or insert

Columns Comments for SCRRARE_SEQNO (# 5)

Source Code Comments

The sequence number is used to insure the record will be in the correct order

Columns Comments for SCRRARE_AREA (# 6)

Source Code Comments

This field defines the Area(s) of students for which course registration restrictions exist. The Include/Exclude field will determine how the Area is restricted. An unlimited number of Areas maybe defined.

Table SCRRATT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRRATT_PRIMARY_KEY   NUMBER(9,0) No *  
SCRRATT_SUBJ_CODE   VARCHAR2(4) No   *
SCRRATT_CRSE_NUMB   VARCHAR2(5) No   *
SCRRATT_EFF_TERM   VARCHAR2(6) No   *
SCRRATT_REC_TYPE   VARCHAR2(1) No    
SCRRATT_ACTIVITY_DATE   DATE No    
SCRRATT_USER_ID   VARCHAR2(30) No    
SCRRATT_ATTS_IE_CDE   VARCHAR2(1) Yes    
SCRRATT_ATTS_CODE   VARCHAR2(4) Yes   *
SCRRATT_DATA_ORIGIN   VARCHAR2(30) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRRATT_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCRRATT_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCRRATT_ATTS_CODE STVATTS_CODE STVATTS
SCRRATT_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRRATT_EFF_TERM STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SCRRATT Unique SCRRATT_PRIMARY_KEY
SCRRATT_KEY_INDEX Unique SCRRATT_SUBJ_CODE
SCRRATT_KEY_INDEX Unique SCRRATT_CRSE_NUMB
SCRRATT_KEY_INDEX Unique SCRRATT_EFF_TERM
SCRRATT_KEY_INDEX Unique SCRRATT_REC_TYPE
SCRRATT_KEY_INDEX Unique SCRRATT_ATTS_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
CRSE_ATTS_RESTRICTION_REC Oracle Package Type S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Rely On
P_OVERLAY_VALIDATION_REC Oracle Package Procedure S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Rely On
GV_PK_2_1 Oracle Package Variable S10B80.BANINST1.UT_SB_SECT_CHRT_RESTRICTION Rely On
GV_PK_2_1 Oracle Package Variable S10B80.BANINST1.UT_SB_CRSE_ATTS_RESTRICTION Rely On
GV_PK_3_1 Oracle Package Variable S10B80.BANINST1.UT_SB_SECT_CHRT_RESTRICTION Rely On
GV_PK_3_1 Oracle Package Variable S10B80.BANINST1.UT_SB_CRSE_ATTS_RESTRICTION Rely On
GV_PK_4_1 Oracle Package Variable S10B80.BANINST1.UT_SB_SECT_CHRT_RESTRICTION Rely On
GV_PK_4_1 Oracle Package Variable S10B80.BANINST1.UT_SB_CRSE_ATTS_RESTRICTION Rely On
GV_PRIMARY_KEY Oracle Package Variable S10B80.BANINST1.UT_SB_CRSE_ATTS_RESTRICTION Rely On
F_BUILD_SCRRATT_REC Oracle Package Function S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Rely On
P_COPY_RESTRICTIONS Oracle Package Procedure S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Rely On
P_COPY_RESTRICTIONS Oracle Package Procedure S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Use (select)
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Rely On
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Rely On
P_DELETE Oracle Package Procedure S10B80.BANINST1.DML_SCRRATT Use (delete)
P_DELETE_ALL Oracle Package Procedure S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Rely On
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
P_INSERT Oracle Package Procedure S10B80.BANINST1.DML_SCRRATT Use (Insert)Rely On
P_LOCK Oracle Package Procedure S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Rely On
P_LOCK Oracle Package Procedure S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Use (select)
P_REGISTER_ENTITY Oracle Package Procedure S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION_RULES Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.DML_SCRRATT Use (update)Rely On
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION_RULES Rely On
F_EXISTS Oracle Package Function S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Rely On
F_EXISTS Oracle Package Function S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Use (select)
F_QUERY_ACTIVE_MAX_TERM Oracle Package Function S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Rely On
F_QUERY_ACTIVE_MAX_TERM Oracle Package Function S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Use (select)
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Rely On
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Use (select)
F_QUERY_ALL_MAX_TERM Oracle Package Function S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Rely On
F_QUERY_ALL_MAX_TERM Oracle Package Function S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Use (select)
F_QUERY_BY_ROWID Oracle Package Function S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Use (select)
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Rely On
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Use (select)
F_QUERY_ONE_LOCK Oracle Package Function S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Rely On
F_QUERY_ONE_LOCK Oracle Package Function S10B80.BANINST1.SB_CRSE_ATTS_RESTRICTION Use (select)
SCRRATT Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SCRRATT SQL Index S10B80.SATURN Rely On
SCRRATT_KEY_INDEX SQL Index S10B80.SATURN Rely On
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVATTS SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRRATT

Object Dates

Creation Date Analysis Date
04/02/2008 21:03:25:000 04/02/2008 21:18:22:000

Source Code Comments

Course Student Attribute Restriction Repeating Table

Columns Comments for SCRRATT_PRIMARY_KEY (# 1)

Source Code Comments

PRIMARY KEY: Unique sequence number that identifies the record.

Columns Comments for SCRRATT_SUBJ_CODE (# 2)

Source Code Comments

SUBJECT CODE: Code of the subject area of the course.

Columns Comments for SCRRATT_CRSE_NUMB (# 3)

Source Code Comments

COURSE NUMBER: Number associated with the course.

Columns Comments for SCRRATT_EFF_TERM (# 4)

Source Code Comments

EFFECTIVE TERM: Term in which this version of the course registration student attribute restriction becomes effective.

Columns Comments for SCRRATT_REC_TYPE (# 5)

Source Code Comments

RECORD TYPE: Indicator for whether the record contains a student attribute indicator or a student attribute code. Valid values are: 1 - Student attribute indicator, 2 - Student attribute code.

Columns Comments for SCRRATT_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: Date that the information for the row was inserted or updated in the SCRRATT table.

Columns Comments for SCRRATT_USER_ID (# 7)

Source Code Comments

USER ID: ID of the user who last changed the record.

Columns Comments for SCRRATT_ATTS_IE_CDE (# 8)

Source Code Comments

STUDENT ATTRIBUTE INCLUDE/EXCLUDE: Indicator for whether the student attribute codes entered should be included or excluded in restricting the course. Valid values are: I - Include, E - Exclude.

Columns Comments for SCRRATT_ATTS_CODE (# 9)

Source Code Comments

STUDENT ATTRIBUTE CODE: Code of a student attribute for which registration restrictions exist. The Include/Exclude field specifies how the attribute is restricted. An unlimited number of attribute restrictions may be defined.

Columns Comments for SCRRATT_DATA_ORIGIN (# 10)

Source Code Comments

DATA SOURCE: Source system that generated the data.

Table SCRRCAM

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRRCAM_SUBJ_CODE   VARCHAR2(4) No   *
SCRRCAM_CRSE_NUMB   VARCHAR2(5) No   *
SCRRCAM_EFF_TERM   VARCHAR2(6) No   *
SCRRCAM_REC_TYPE   VARCHAR2(1) No    
SCRRCAM_CAMP_IND   VARCHAR2(1) Yes    
SCRRCAM_CAMP_CODE   VARCHAR2(3) Yes   *
SCRRCAM_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRRCAM_CAMP_CODE STVCAMP_CODE STVCAMP
SCRRCAM_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRRCAM_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCRRCAM_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCRRCAM_EFF_TERM STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
SCRRCAM_KEY_INDEX Unique SCRRCAM_SUBJ_CODE
SCRRCAM_KEY_INDEX Unique SCRRCAM_CRSE_NUMB
SCRRCAM_KEY_INDEX Unique SCRRCAM_EFF_TERM
SCRRCAM_KEY_INDEX Unique SCRRCAM_REC_TYPE
SCRRCAM_KEY_INDEX Unique SCRRCAM_CAMP_IND
SCRRCAM_KEY_INDEX Unique SCRRCAM_CAMP_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
SCRRCAM Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRRCAM_KEY_INDEX SQL Index S10B80.SATURN Rely On
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVCAMP SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRRCAM

Object Dates

Creation Date Analysis Date
04/02/2008 20:36:08:000 04/02/2008 21:18:00:000

Source Code Comments

Catalog Campus Restriction Table

Columns Comments for SCRRCAM_SUBJ_CODE (# 1)

Source Code Comments

Catalog campus restriction subject code

Columns Comments for SCRRCAM_CRSE_NUMB (# 2)

Source Code Comments

Catalog campus restriction course number

Columns Comments for SCRRCAM_EFF_TERM (# 3)

Source Code Comments

Catalog campus restriction effective term

Columns Comments for SCRRCAM_REC_TYPE (# 4)

Source Code Comments

Catalog campus restriction record type

Columns Comments for SCRRCAM_CAMP_IND (# 5)

Source Code Comments

Catalog campus restriction inclusion or exclusion indicator

Columns Comments for SCRRCAM_CAMP_CODE (# 6)

Source Code Comments

Catalog campus restriction campus code

Columns Comments for SCRRCAM_ACTIVITY_DATE (# 7)

Source Code Comments

The Activity Date

Table SCRRCHR

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRRCHR_PRIMARY_KEY   NUMBER(9,0) No *  
SCRRCHR_SUBJ_CODE   VARCHAR2(4) No   *
SCRRCHR_CRSE_NUMB   VARCHAR2(5) No   *
SCRRCHR_EFF_TERM   VARCHAR2(6) No   *
SCRRCHR_REC_TYPE   VARCHAR2(1) No    
SCRRCHR_ACTIVITY_DATE   DATE No    
SCRRCHR_USER_ID   VARCHAR2(30) No    
SCRRCHR_CHRT_IE_CDE   VARCHAR2(1) Yes    
SCRRCHR_CHRT_CODE   VARCHAR2(10) Yes   *
SCRRCHR_DATA_ORIGIN   VARCHAR2(30) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRRCHR_CHRT_CODE STVCHRT_CODE STVCHRT
SCRRCHR_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRRCHR_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCRRCHR_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCRRCHR_EFF_TERM STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SCRRCHR Unique SCRRCHR_PRIMARY_KEY
SCRRCHR_KEY_INDEX Unique SCRRCHR_SUBJ_CODE
SCRRCHR_KEY_INDEX Unique SCRRCHR_CRSE_NUMB
SCRRCHR_KEY_INDEX Unique SCRRCHR_EFF_TERM
SCRRCHR_KEY_INDEX Unique SCRRCHR_REC_TYPE
SCRRCHR_KEY_INDEX Unique SCRRCHR_CHRT_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
CRSE_CHRT_RESTRICTION_REC Oracle Package Type S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Rely On
P_OVERLAY_VALIDATION_REC Oracle Package Procedure S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Rely On
GV_PK_2_1 Oracle Package Variable S10B80.BANINST1.UT_SB_CRSE_CHRT_RESTRICTION Rely On
GV_PK_3_1 Oracle Package Variable S10B80.BANINST1.UT_SB_CRSE_CHRT_RESTRICTION Rely On
GV_PRIMARY_KEY Oracle Package Variable S10B80.BANINST1.UT_SB_CRSE_CHRT_RESTRICTION Rely On
F_BUILD_SCRRCHR_REC Oracle Package Function S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Rely On
P_COPY_RESTRICTIONS Oracle Package Procedure S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Rely On
P_COPY_RESTRICTIONS Oracle Package Procedure S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Use (select)
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Rely On
P_DELETE Oracle Package Procedure S10B80.BANINST1.DML_SCRRCHR Use (delete)
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Rely On
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DELETE_ALL Oracle Package Procedure S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Rely On
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
P_INSERT Oracle Package Procedure S10B80.BANINST1.DML_SCRRCHR Use (Insert)Rely On
P_LOCK Oracle Package Procedure S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Rely On
P_LOCK Oracle Package Procedure S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Use (select)
P_REGISTER_ENTITY Oracle Package Procedure S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION_RULES Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.DML_SCRRCHR Use (update)Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Rely On
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION_RULES Rely On
F_EXISTS Oracle Package Function S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Rely On
F_EXISTS Oracle Package Function S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Use (select)
F_QUERY_ACTIVE_MAX_TERM Oracle Package Function S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Rely On
F_QUERY_ACTIVE_MAX_TERM Oracle Package Function S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Use (select)
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Rely On
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Use (select)
F_QUERY_ALL_MAX_TERM Oracle Package Function S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Rely On
F_QUERY_ALL_MAX_TERM Oracle Package Function S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Use (select)
F_QUERY_BY_ROWID Oracle Package Function S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Use (select)
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Rely On
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Use (select)
F_QUERY_ONE_LOCK Oracle Package Function S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Rely On
F_QUERY_ONE_LOCK Oracle Package Function S10B80.BANINST1.SB_CRSE_CHRT_RESTRICTION Use (select)
SCRRCHR Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SCRRCHR SQL Index S10B80.SATURN Rely On
SCRRCHR_KEY_INDEX SQL Index S10B80.SATURN Rely On
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVCHRT SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRRCHR

Object Dates

Creation Date Analysis Date
04/02/2008 20:37:05:000 04/02/2008 21:18:01:000

Source Code Comments

Course Cohort Restriction Repeating Table

Columns Comments for SCRRCHR_PRIMARY_KEY (# 1)

Source Code Comments

PRIMARY KEY: Unique sequence number that identifies the record.

Columns Comments for SCRRCHR_SUBJ_CODE (# 2)

Source Code Comments

SUBJECT CODE: Code of the subject area of the course.

Columns Comments for SCRRCHR_CRSE_NUMB (# 3)

Source Code Comments

COURSE NUMBER: Number associated with the course.

Columns Comments for SCRRCHR_EFF_TERM (# 4)

Source Code Comments

EFFECTIVE TERM: Term in which this version of the course registration cohort restriction becomes effective.

Columns Comments for SCRRCHR_REC_TYPE (# 5)

Source Code Comments

RECORD TYPE: Indicator for whether the record contains an cohort indicator or a cohort code. Valid values are: 1 - Cohort indicator, 2 - Cohort code.

Columns Comments for SCRRCHR_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: Date that the information for the row was inserted or updated in the SCRRCHR table.

Columns Comments for SCRRCHR_USER_ID (# 7)

Source Code Comments

USER ID: ID of the user who last changed the record.

Columns Comments for SCRRCHR_CHRT_IE_CDE (# 8)

Source Code Comments

COHORT INCLUDE/EXCLUDE: Indicator for whether the cohort codes entered should be included or excluded in restricting the course. Valid values are: I - Include, E - Exclude.

Columns Comments for SCRRCHR_CHRT_CODE (# 9)

Source Code Comments

COHORT CODE: Code of a cohort for which registration restrictions exist. The Include/Exclude field specifies how the cohort is restricted. An unlimited number of cohort registration restrictions may be defined.

Columns Comments for SCRRCHR_DATA_ORIGIN (# 10)

Source Code Comments

DATA SOURCE: Source system that generated the data.

Table SCRRCLS

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRRCLS_SUBJ_CODE   VARCHAR2(4) No   *
SCRRCLS_CRSE_NUMB   VARCHAR2(5) No   *
SCRRCLS_EFF_TERM   VARCHAR2(6) No   *
SCRRCLS_REC_TYPE   VARCHAR2(1) No    
SCRRCLS_CLASS_IND   VARCHAR2(1) Yes    
SCRRCLS_CLAS_CODE   VARCHAR2(2) Yes   *
SCRRCLS_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRRCLS_CLAS_CODE STVCLAS_CODE STVCLAS
SCRRCLS_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRRCLS_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCRRCLS_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCRRCLS_EFF_TERM STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
SCRRCLS_KEY_INDEX Unique SCRRCLS_SUBJ_CODE
SCRRCLS_KEY_INDEX Unique SCRRCLS_CRSE_NUMB
SCRRCLS_KEY_INDEX Unique SCRRCLS_EFF_TERM
SCRRCLS_KEY_INDEX Unique SCRRCLS_REC_TYPE
SCRRCLS_KEY_INDEX Unique SCRRCLS_CLASS_IND
SCRRCLS_KEY_INDEX Unique SCRRCLS_CLAS_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
SCRRCLS Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRRCLS_KEY_INDEX SQL Index S10B80.SATURN Rely On
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVCLAS SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRRCLS

Object Dates

Creation Date Analysis Date
04/02/2008 20:37:47:000 04/02/2008 21:18:01:000

Source Code Comments

Course Class Restriction Repeating Table

Columns Comments for SCRRCLS_SUBJ_CODE (# 1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCRRCLS_CRSE_NUMB (# 2)

Source Code Comments

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

Columns Comments for SCRRCLS_EFF_TERM (# 3)

Source Code Comments

This field identifies the term this version of the course registration classification restrictions becomes effective.

Columns Comments for SCRRCLS_REC_TYPE (# 4)

Source Code Comments

This field defines if the record contains a class indicator or a class code. Valid values are: 1 - Class indicator, 2 - Class code.

Columns Comments for SCRRCLS_CLASS_IND (# 5)

Source Code Comments

This field indicates if the classification codes entered should be included or excluded in restricting the course. Valid values are: I - Include, E - Exclude.

Columns Comments for SCRRCLS_CLAS_CODE (# 6)

Source Code Comments

This field defines the classification codes of students for which registration restrictions exist. The Include/Exclude field will determine how the classification is restricted.

Columns Comments for SCRRCLS_ACTIVITY_DATE (# 7)

Source Code Comments

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

Table SCRRCMP

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRRCMP_SUBJ_CODE   VARCHAR2(4) No   *
SCRRCMP_CRSE_NUMB   VARCHAR2(5) No   *
SCRRCMP_EFF_TERM   VARCHAR2(6) No   *
SCRRCMP_REC_TYPE   VARCHAR2(1) No    
SCRRCMP_CAMP_IND   VARCHAR2(1) Yes    
SCRRCMP_CAMP_CODE   VARCHAR2(3) Yes   *
SCRRCMP_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRRCMP_CAMP_CODE STVCAMP_CODE STVCAMP
SCRRCMP_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRRCMP_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCRRCMP_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCRRCMP_EFF_TERM STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
SCRRCMP_KEY_INDEX Unique SCRRCMP_SUBJ_CODE
SCRRCMP_KEY_INDEX Unique SCRRCMP_CRSE_NUMB
SCRRCMP_KEY_INDEX Unique SCRRCMP_EFF_TERM
SCRRCMP_KEY_INDEX Unique SCRRCMP_REC_TYPE
SCRRCMP_KEY_INDEX Unique SCRRCMP_CAMP_IND
SCRRCMP_KEY_INDEX Unique SCRRCMP_CAMP_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
UT_SB_SECTIONCREATEAPI Oracle Package Procedure S10B80.BANINST1.UT_SB_SECTION Use (Insert,select)
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_SECTION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_SECTION Use (Insert,select)
UT_TEARDOWN Oracle Package Procedure S10B80.BANINST1.UT_GB_SECTION Use (delete)
F_CHECK_CAMPUS Oracle Package Function S10B80.BANINST1.SB_SECTION_RULES Use (select)
SCRRCMP Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRRCMP_KEY_INDEX SQL Index S10B80.SATURN Rely On
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVCAMP SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRRCMP

Object Dates

Creation Date Analysis Date
04/02/2008 20:37:57:000 04/02/2008 21:18:02:000

Source Code Comments

Course Campus Restriction Repeating Table

Columns Comments for SCRRCMP_SUBJ_CODE (# 1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCRRCMP_CRSE_NUMB (# 2)

Source Code Comments

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

Columns Comments for SCRRCMP_EFF_TERM (# 3)

Source Code Comments

This field identifies the term this version of the course restrictions on campus becomes effective.

Columns Comments for SCRRCMP_REC_TYPE (# 4)

Source Code Comments

This field is defines if the record contains a campus indicator or a campus code. Valid values are: 1 - Campus indicator, 2 - Campus code.

Columns Comments for SCRRCMP_CAMP_IND (# 5)

Source Code Comments

This field indicates if the campus codes entered should be included or excluded for restricting the scheduling of the course. Valid values are: I - Include, E - Exclude.

Columns Comments for SCRRCMP_CAMP_CODE (# 6)

Source Code Comments

This field defines the campus codes for which campus schedule restrictions exist. The Include/Exclude field will determine how the campus is restricted. An unlimited number of campuses may be defined.

Columns Comments for SCRRCMP_ACTIVITY_DATE (# 7)

Source Code Comments

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

Table SCRRCOL

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRRCOL_SUBJ_CODE   VARCHAR2(4) No   *
SCRRCOL_CRSE_NUMB   VARCHAR2(5) No   *
SCRRCOL_EFF_TERM   VARCHAR2(6) No   *
SCRRCOL_REC_TYPE   VARCHAR2(1) No    
SCRRCOL_COLL_IND   VARCHAR2(1) Yes    
SCRRCOL_COLL_CODE   VARCHAR2(2) Yes   *
SCRRCOL_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRRCOL_COLL_CODE STVCOLL_CODE STVCOLL
SCRRCOL_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRRCOL_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCRRCOL_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCRRCOL_EFF_TERM STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
SCRRCOL_KEY_INDEX Unique SCRRCOL_SUBJ_CODE
SCRRCOL_KEY_INDEX Unique SCRRCOL_CRSE_NUMB
SCRRCOL_KEY_INDEX Unique SCRRCOL_EFF_TERM
SCRRCOL_KEY_INDEX Unique SCRRCOL_REC_TYPE
SCRRCOL_KEY_INDEX Unique SCRRCOL_COLL_IND
SCRRCOL_KEY_INDEX Unique SCRRCOL_COLL_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
SCRRCOL Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRRCOL_KEY_INDEX SQL Index S10B80.SATURN Rely On
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVCOLL SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRRCOL

Object Dates

Creation Date Analysis Date
04/02/2008 20:38:18:000 04/02/2008 21:18:02:000

Source Code Comments

Course College Restriction Repeating Table

Columns Comments for SCRRCOL_SUBJ_CODE (# 1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCRRCOL_CRSE_NUMB (# 2)

Source Code Comments

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

Columns Comments for SCRRCOL_EFF_TERM (# 3)

Source Code Comments

This field identifies the term this version of the course registration college restrictions becomes effective.

Columns Comments for SCRRCOL_REC_TYPE (# 4)

Source Code Comments

This field defines if the record contains a college indicator or a college code. Valid values are: 1 - College indicator, 2 - College code.

Columns Comments for SCRRCOL_COLL_IND (# 5)

Source Code Comments

This field indicates if the college codes entered should be included or excluded in restricting the course. Valid values are: I - Include, E -Exclude.

Columns Comments for SCRRCOL_COLL_CODE (# 6)

Source Code Comments

This field defines the college(s) of students for which course registration restrictions exist. The Include/Exclude field will determine how the college is restricted. An unlimited number of colleges may be defined.

Columns Comments for SCRRCOL_ACTIVITY_DATE (# 7)

Source Code Comments

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

Table SCRRDEG

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRRDEG_SUBJ_CODE   VARCHAR2(4) No   *
SCRRDEG_CRSE_NUMB   VARCHAR2(5) No    
SCRRDEG_TERM_CODE_EFFECTIVE   VARCHAR2(6) No   *
SCRRDEG_REC_TYPE   VARCHAR2(1) No    
SCRRDEG_ACTIVITY_DATE   DATE No    
SCRRDEG_DEGC_IND   VARCHAR2(1) Yes    
SCRRDEG_DEGC_CODE   VARCHAR2(6) Yes   *

Foreign Key information

Column name is Foreign Key For Column on Table
SCRRDEG_DEGC_CODE STVDEGC_CODE STVDEGC
SCRRDEG_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRRDEG_TERM_CODE_EFFECTIVE STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
SCRRDEG_KEY_INDEX Unique SCRRDEG_SUBJ_CODE
SCRRDEG_KEY_INDEX Unique SCRRDEG_CRSE_NUMB
SCRRDEG_KEY_INDEX Unique SCRRDEG_TERM_CODE_EFFECTIVE
SCRRDEG_KEY_INDEX Unique SCRRDEG_REC_TYPE
SCRRDEG_KEY_INDEX Unique SCRRDEG_DEGC_IND
SCRRDEG_KEY_INDEX Unique SCRRDEG_DEGC_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
SCRRDEG Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRRDEG_KEY_INDEX SQL Index S10B80.SATURN Rely On
STVDEGC SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRRDEG

Object Dates

Creation Date Analysis Date
04/02/2008 20:40:55:000 04/02/2008 21:18:04:000

Source Code Comments

Course Degree Restriction Table.

Columns Comments for SCRRDEG_SUBJ_CODE (# 1)

Source Code Comments

Course subject area code

Columns Comments for SCRRDEG_CRSE_NUMB (# 2)

Source Code Comments

Course number

Columns Comments for SCRRDEG_TERM_CODE_EFFECTIVE (# 3)

Source Code Comments

Identifies the term this version of the course registration degree restriction becomes effective

Columns Comments for SCRRDEG_REC_TYPE (# 4)

Source Code Comments

Defines if the record contains a degree indicator or a degree code. Valid values (1) Degree indicator, (2) Degree code.

Columns Comments for SCRRDEG_ACTIVITY_DATE (# 5)

Source Code Comments

Date of last update or insert

Columns Comments for SCRRDEG_DEGC_IND (# 6)

Source Code Comments

Indicates if the degree codes entered should be included or excluded in restriction the course. Valid values (I) Include, (E) Exclude

Columns Comments for SCRRDEG_DEGC_CODE (# 7)

Source Code Comments

This field defines the degree(s) of students for which course registration restrictions exist. The Include/Exclude field will determine how the degree is restricted. An unlimited number of degrees may be defined.

Table SCRRDEP

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRRDEP_PRIMARY_KEY   NUMBER(9,0) No *  
SCRRDEP_SUBJ_CODE   VARCHAR2(4) No   *
SCRRDEP_CRSE_NUMB   VARCHAR2(5) No   *
SCRRDEP_EFF_TERM   VARCHAR2(6) No   *
SCRRDEP_REC_TYPE   VARCHAR2(1) No    
SCRRDEP_ACTIVITY_DATE   DATE No    
SCRRDEP_USER_ID   VARCHAR2(30) No    
SCRRDEP_DEPT_IE_CDE   VARCHAR2(1) Yes    
SCRRDEP_DEPT_CODE   VARCHAR2(4) Yes   *
SCRRDEP_DATA_ORIGIN   VARCHAR2(30) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRRDEP_DEPT_CODE STVDEPT_CODE STVDEPT
SCRRDEP_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRRDEP_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCRRDEP_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCRRDEP_EFF_TERM STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SCRRDEP Unique SCRRDEP_PRIMARY_KEY
SCRRDEP_KEY_INDEX Unique SCRRDEP_SUBJ_CODE
SCRRDEP_KEY_INDEX Unique SCRRDEP_CRSE_NUMB
SCRRDEP_KEY_INDEX Unique SCRRDEP_EFF_TERM
SCRRDEP_KEY_INDEX Unique SCRRDEP_REC_TYPE
SCRRDEP_KEY_INDEX Unique SCRRDEP_DEPT_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
CRSE_DEPT_RESTRICTION_REC Oracle Package Type S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Rely On
P_OVERLAY_VALIDATION_REC Oracle Package Procedure S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Rely On
GV_PK_1_11 Oracle Package Variable S10B80.BANINST1.UT_SB_CRSE_DEPT_RESTRICTION Rely On
GV_PK_2_1 Oracle Package Variable S10B80.BANINST1.UT_SB_CRSE_DEPT_RESTRICTION Rely On
GV_PK_2_11 Oracle Package Variable S10B80.BANINST1.UT_SB_CRSE_DEPT_RESTRICTION Rely On
GV_PK_3_1 Oracle Package Variable S10B80.BANINST1.UT_SB_CRSE_DEPT_RESTRICTION Rely On
F_BUILD_SCRRDEP_REC Oracle Package Function S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Rely On
P_COPY_RESTRICTIONS Oracle Package Procedure S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Rely On
P_COPY_RESTRICTIONS Oracle Package Procedure S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Use (select)
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Rely On
P_DELETE Oracle Package Procedure S10B80.BANINST1.DML_SCRRDEP Use (delete)
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Rely On
P_DELETE_ALL Oracle Package Procedure S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Rely On
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
P_INSERT Oracle Package Procedure S10B80.BANINST1.DML_SCRRDEP Use (Insert)Rely On
P_LOCK Oracle Package Procedure S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Rely On
P_LOCK Oracle Package Procedure S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Use (select)
P_REGISTER_ENTITY Oracle Package Procedure S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION_RULES Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.DML_SCRRDEP Use (update)Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Rely On
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION_RULES Rely On
F_EXISTS Oracle Package Function S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Rely On
F_EXISTS Oracle Package Function S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Use (select)
F_QUERY_ACTIVE_MAX_TERM Oracle Package Function S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Rely On
F_QUERY_ACTIVE_MAX_TERM Oracle Package Function S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Use (select)
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Rely On
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Use (select)
F_QUERY_ALL_MAX_TERM Oracle Package Function S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Rely On
F_QUERY_ALL_MAX_TERM Oracle Package Function S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Use (select)
F_QUERY_BY_ROWID Oracle Package Function S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Use (select)
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Rely On
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Use (select)
F_QUERY_ONE_LOCK Oracle Package Function S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Rely On
F_QUERY_ONE_LOCK Oracle Package Function S10B80.BANINST1.SB_CRSE_DEPT_RESTRICTION Use (select)
SCRRDEP Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SCRRDEP SQL Index S10B80.SATURN Rely On
SCRRDEP_KEY_INDEX SQL Index S10B80.SATURN Rely On
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVDEPT SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRRDEP

Object Dates

Creation Date Analysis Date
04/02/2008 20:40:59:000 04/02/2008 21:18:04:000

Source Code Comments

Course Department Restriction Repeating Table

Columns Comments for SCRRDEP_PRIMARY_KEY (# 1)

Source Code Comments

PRIMARY KEY: Unique sequence number that identifies the record.

Columns Comments for SCRRDEP_SUBJ_CODE (# 2)

Source Code Comments

SUBJECT CODE: Code of the subject area of the course.

Columns Comments for SCRRDEP_CRSE_NUMB (# 3)

Source Code Comments

COURSE NUMBER: Number associated with the course.

Columns Comments for SCRRDEP_EFF_TERM (# 4)

Source Code Comments

EFFECTIVE TERM: Term in which this version of the course registration department restriction becomes effective.

Columns Comments for SCRRDEP_REC_TYPE (# 5)

Source Code Comments

RECORD TYPE: Indicator for whether the record contains a department indicator or a department code. Valid values are: 1 - Department indicator, 2 - Department code.

Columns Comments for SCRRDEP_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: Date that the information for the row was inserted or updated in the SCRRDEP table.

Columns Comments for SCRRDEP_USER_ID (# 7)

Source Code Comments

USER ID: ID of the user who last changed the record.

Columns Comments for SCRRDEP_DEPT_IE_CDE (# 8)

Source Code Comments

DEPARTMENT INCLUDE/EXCLUDE: Indicator for whether the department codes entered should be included or excluded in restricting the course. Valid values are: I - Include, E - Exclude.

Columns Comments for SCRRDEP_DEPT_CODE (# 9)

Source Code Comments

DEPARTMENT CODE: Code of a department for which registration restrictions exist. The Include/Exclude field specifies how the department is restricted. An unlimited number of department registration restrictions may be defined.

Columns Comments for SCRRDEP_DATA_ORIGIN (# 10)

Source Code Comments

DATA SOURCE: Source system that generated the data.

Table SCRRLVL

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRRLVL_SUBJ_CODE   VARCHAR2(4) No   *
SCRRLVL_CRSE_NUMB   VARCHAR2(5) No   *
SCRRLVL_EFF_TERM   VARCHAR2(6) No   *
SCRRLVL_REC_TYPE   VARCHAR2(1) No    
SCRRLVL_LEVL_IND   VARCHAR2(1) Yes    
SCRRLVL_LEVL_CODE   VARCHAR2(4) Yes    
SCRRLVL_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRRLVL_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRRLVL_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCRRLVL_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCRRLVL_EFF_TERM STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
SCRRLVL_KEY_INDEX Unique SCRRLVL_SUBJ_CODE
SCRRLVL_KEY_INDEX Unique SCRRLVL_CRSE_NUMB
SCRRLVL_KEY_INDEX Unique SCRRLVL_EFF_TERM
SCRRLVL_KEY_INDEX Unique SCRRLVL_REC_TYPE
SCRRLVL_KEY_INDEX Unique SCRRLVL_LEVL_IND
SCRRLVL_KEY_INDEX Unique SCRRLVL_LEVL_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
SCRRLVL Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRRLVL_KEY_INDEX SQL Index S10B80.SATURN Rely On
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRRLVL

Object Dates

Creation Date Analysis Date
04/02/2008 20:44:41:000 04/02/2008 21:18:08:000

Source Code Comments

Course Level Restriction Repeating Table

Columns Comments for SCRRLVL_SUBJ_CODE (# 1)

Source Code Comments

Course Level Restriction Subject Code

Columns Comments for SCRRLVL_CRSE_NUMB (# 2)

Source Code Comments

Course Level Restriction Course Number

Columns Comments for SCRRLVL_EFF_TERM (# 3)

Source Code Comments

Course Level Restriction Effective Term

Columns Comments for SCRRLVL_REC_TYPE (# 4)

Source Code Comments

Course Level Restriction Record Type.

Columns Comments for SCRRLVL_LEVL_IND (# 5)

Source Code Comments

Course Level Restriction Indicator

Columns Comments for SCRRLVL_LEVL_CODE (# 6)

Source Code Comments

Course Level Restriction Level Code

Columns Comments for SCRRLVL_ACTIVITY_DATE (# 7)

Source Code Comments

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

Table SCRRMAJ

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRRMAJ_SUBJ_CODE   VARCHAR2(4) No   *
SCRRMAJ_CRSE_NUMB   VARCHAR2(5) No   *
SCRRMAJ_EFF_TERM   VARCHAR2(6) No   *
SCRRMAJ_REC_TYPE   VARCHAR2(1) No    
SCRRMAJ_MAJOR_IND   VARCHAR2(1) Yes    
SCRRMAJ_MAJR_CODE   VARCHAR2(4) Yes   *
SCRRMAJ_ACTIVITY_DATE   DATE No    
SCRRMAJ_LFST_CODE   VARCHAR2(15) Yes   *

Foreign Key information

Column name is Foreign Key For Column on Table
SCRRMAJ_LFST_CODE GTVLFST_CODE GTVLFST
SCRRMAJ_MAJR_CODE STVMAJR_CODE STVMAJR
SCRRMAJ_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRRMAJ_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCRRMAJ_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCRRMAJ_EFF_TERM STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
SCRRMAJ_KEY_INDEX Unique SCRRMAJ_SUBJ_CODE
SCRRMAJ_KEY_INDEX Unique SCRRMAJ_CRSE_NUMB
SCRRMAJ_KEY_INDEX Unique SCRRMAJ_EFF_TERM
SCRRMAJ_KEY_INDEX Unique SCRRMAJ_REC_TYPE
SCRRMAJ_KEY_INDEX Unique SCRRMAJ_MAJOR_IND
SCRRMAJ_KEY_INDEX Unique SCRRMAJ_LFST_CODE
SCRRMAJ_KEY_INDEX Unique SCRRMAJ_MAJR_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
SCRRMAJ Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRRMAJ_KEY_INDEX SQL Index S10B80.SATURN Rely On
GTVLFST SQL Table S10B80.GENERAL Refer (no action)
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVMAJR SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRRMAJ

Object Dates

Creation Date Analysis Date
04/02/2008 20:46:00:000 04/02/2008 21:18:09:000

Source Code Comments

Course Major Restriction Repeating Table

Columns Comments for SCRRMAJ_SUBJ_CODE (# 1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCRRMAJ_CRSE_NUMB (# 2)

Source Code Comments

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

Columns Comments for SCRRMAJ_EFF_TERM (# 3)

Source Code Comments

This field identifies the term this version of the course registration major restrictions becomes effective.

Columns Comments for SCRRMAJ_REC_TYPE (# 4)

Source Code Comments

This field defines if the record contains a major indicator or a major code. Valid values are: 1 - Major indicator, 2 - Major code.

Columns Comments for SCRRMAJ_MAJOR_IND (# 5)

Source Code Comments

This field indicates if the major codes entered should be included or excluded in restricting the course. Valid values are: I - Include, E - Exclude.

Columns Comments for SCRRMAJ_MAJR_CODE (# 6)

Source Code Comments

This field defines the majors of students for which registration restrictions exist. The Include/Exclude field will determine how the major is restricted. An unlimited number of majors may be defined.

Columns Comments for SCRRMAJ_ACTIVITY_DATE (# 7)

Source Code Comments

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

Columns Comments for SCRRMAJ_LFST_CODE (# 8)

Source Code Comments

FIELD OF STUDY CODE: Field of study type code; examples are MAJOR, MINOR, CONCENTRATION.

Table SCRRPRG

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRRPRG_SUBJ_CODE   VARCHAR2(4) No   *
SCRRPRG_CRSE_NUMB   VARCHAR2(5) No    
SCRRPRG_TERM_CODE_EFFECTIVE   VARCHAR2(6) No   *
SCRRPRG_REC_TYPE   VARCHAR2(1) No    
SCRRPRG_ACTIVITY_DATE   DATE No    
SCRRPRG_PROGRAM_IND   VARCHAR2(1) Yes    
SCRRPRG_PROGRAM   VARCHAR2(12) Yes   *

Foreign Key information

Column name is Foreign Key For Column on Table
SCRRPRG_PROGRAM SMRPRLE_PROGRAM SMRPRLE
SCRRPRG_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRRPRG_TERM_CODE_EFFECTIVE STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
SCRRPRG_KEY_INDEX Unique SCRRPRG_SUBJ_CODE
SCRRPRG_KEY_INDEX Unique SCRRPRG_CRSE_NUMB
SCRRPRG_KEY_INDEX Unique SCRRPRG_TERM_CODE_EFFECTIVE
SCRRPRG_KEY_INDEX Unique SCRRPRG_REC_TYPE
SCRRPRG_KEY_INDEX Unique SCRRPRG_PROGRAM_IND
SCRRPRG_KEY_INDEX Unique SCRRPRG_PROGRAM

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAYRESTRICTIONS Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
SCRRPRG Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRRPRG_KEY_INDEX SQL Index S10B80.SATURN Rely On
SMRPRLE SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRRPRG

Object Dates

Creation Date Analysis Date
04/02/2008 21:02:48:000 04/02/2008 21:18:22:000

Source Code Comments

Course Program Restriction Table.

Columns Comments for SCRRPRG_SUBJ_CODE (# 1)

Source Code Comments

Course subject area code

Columns Comments for SCRRPRG_CRSE_NUMB (# 2)

Source Code Comments

Course number

Columns Comments for SCRRPRG_TERM_CODE_EFFECTIVE (# 3)

Source Code Comments

Identifies the term this version of the course registration Program restriction becomes effective

Columns Comments for SCRRPRG_REC_TYPE (# 4)

Source Code Comments

Defines if the record contains a Program indicator or a Program code. Valid values (1) Program indicator, (2) Program code.

Columns Comments for SCRRPRG_ACTIVITY_DATE (# 5)

Source Code Comments

Date of last update or insert

Columns Comments for SCRRPRG_PROGRAM_IND (# 6)

Source Code Comments

Indicates if the Program codes entered should be included or excluded in restriction the course. Valid values (I) Include, (E) Exclude

Columns Comments for SCRRPRG_PROGRAM (# 7)

Source Code Comments

This field defines the Program(s) of students for which course registration restrictions exist. The Include/Exclude field will determine how the Program is restricted. An unlimited number of Programs may be defined.

Table SCRRTRM

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRRTRM_SUBJ_CODE   VARCHAR2(4) No   *
SCRRTRM_CRSE_NUMB   VARCHAR2(5) No   *
SCRRTRM_EFF_TERM   VARCHAR2(6) No   *
SCRRTRM_REC_TYPE   VARCHAR2(1) No    
SCRRTRM_TERM_IND   VARCHAR2(1) Yes    
SCRRTRM_RTRM_CODE   VARCHAR2(2) Yes   *
SCRRTRM_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRRTRM_RTRM_CODE STVRTRM_CODE STVRTRM
SCRRTRM_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRRTRM_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCRRTRM_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCRRTRM_EFF_TERM STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
SCRRTRM_KEY_INDEX Unique SCRRTRM_SUBJ_CODE
SCRRTRM_KEY_INDEX Unique SCRRTRM_CRSE_NUMB
SCRRTRM_KEY_INDEX Unique SCRRTRM_EFF_TERM
SCRRTRM_KEY_INDEX Unique SCRRTRM_REC_TYPE
SCRRTRM_KEY_INDEX Unique SCRRTRM_TERM_IND
SCRRTRM_KEY_INDEX Unique SCRRTRM_RTRM_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_SECTION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_SECTION Use (Insert,select)
UT_TEARDOWN Oracle Package Procedure S10B80.BANINST1.UT_GB_SECTION Use (delete)
F_CHECK_TERM_RESTRICT Oracle Package Function S10B80.BANINST1.SB_SECTION_RULES Use (select)
SCRRTRM Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRRTRM_KEY_INDEX SQL Index S10B80.SATURN Rely On
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVRTRM SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRRTRM

Object Dates

Creation Date Analysis Date
04/02/2008 20:45:58:000 04/02/2008 21:18:09:000

Source Code Comments

Course Term Restriction Repeating Table

Columns Comments for SCRRTRM_SUBJ_CODE (# 1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCRRTRM_CRSE_NUMB (# 2)

Source Code Comments

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

Columns Comments for SCRRTRM_EFF_TERM (# 3)

Source Code Comments

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

Columns Comments for SCRRTRM_REC_TYPE (# 4)

Source Code Comments

This field defines if the recod contains a term indicator or a term code. Valid values are: 1 - Term indicator, 2 - Term code.

Columns Comments for SCRRTRM_TERM_IND (# 5)

Source Code Comments

This field indicates if the term codes entered should be included or excluded in restricting the scheduling of the course. Valid values are: I - Include, E - Exclude.

Columns Comments for SCRRTRM_RTRM_CODE (# 6)

Source Code Comments

This field defines the term codes for which term scheduling restrictions exist. The Include/Exclude field will determine how the term is restricted. An unlimited number of terms may be defined.

Columns Comments for SCRRTRM_ACTIVITY_DATE (# 7)

Source Code Comments

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

Table SCRRTST

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRRTST_SUBJ_CODE   VARCHAR2(4) No   *
SCRRTST_CRSE_NUMB   VARCHAR2(5) No   *
SCRRTST_TERM_CODE_EFF   VARCHAR2(6) No   *
SCRRTST_SEQNO   NUMBER(23,20) Yes    
SCRRTST_TESC_CODE   VARCHAR2(4) Yes   *
SCRRTST_TEST_SCORE   VARCHAR2(5) Yes    
SCRRTST_SUBJ_CODE_PREQ   VARCHAR2(4) Yes   *
SCRRTST_CRSE_NUMB_PREQ   VARCHAR2(5) Yes    
SCRRTST_LEVL_CODE   VARCHAR2(2) Yes   *
SCRRTST_MIN_GRDE   VARCHAR2(6) Yes    
SCRRTST_CONCURRENCY_IND   VARCHAR2(1) Yes    
SCRRTST_CONNECTOR   VARCHAR2(1) Yes    
SCRRTST_LPAREN   VARCHAR2(1) Yes    
SCRRTST_RPAREN   VARCHAR2(1) Yes    
SCRRTST_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRRTST_LEVL_CODE STVLEVL_CODE STVLEVL
SCRRTST_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRRTST_SUBJ_CODE_PREQ STVSUBJ_CODE STVSUBJ
SCRRTST_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCRRTST_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCRRTST_TERM_CODE_EFF STVTERM_CODE STVTERM
SCRRTST_TESC_CODE STVTESC_CODE STVTESC

Index

Index Name Index Type Column Name
SCRRTST_KEY_INDEX1 Unique SCRRTST_SUBJ_CODE
SCRRTST_KEY_INDEX1 Unique SCRRTST_CRSE_NUMB
SCRRTST_KEY_INDEX1 Unique SCRRTST_TERM_CODE_EFF
SCRRTST_KEY_INDEX1 Unique SCRRTST_SEQNO
SCRRTST_KEY_INDEX1 Unique SCRRTST_TESC_CODE
SCRRTST_KEY_INDEX2 Unique SCRRTST_SUBJ_CODE
SCRRTST_KEY_INDEX2 Unique SCRRTST_CRSE_NUMB
SCRRTST_KEY_INDEX2 Unique SCRRTST_TERM_CODE_EFF
SCRRTST_KEY_INDEX2 Unique SCRRTST_SEQNO
SCRRTST_KEY_INDEX2 Unique SCRRTST_SUBJ_CODE_PREQ
SCRRTST_KEY_INDEX2 Unique SCRRTST_CRSE_NUMB_PREQ

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
F_CHECK_FOR_COURSE_PREREQS SQL Function S10B80.BANINST1 Use (select)
SCRRTSTC Oracle Package Cursor S10B80.BANINST1.SCKLIBS Use (select)Rely On
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DISPLAYRTST Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAYRTST Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
SCRRTST Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRRTST_KEY_INDEX1 SQL Index S10B80.SATURN Rely On
SCRRTST_KEY_INDEX2 SQL Index S10B80.SATURN Rely On
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVLEVL SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)
STVTESC SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRRTST

Object Dates

Creation Date Analysis Date
04/02/2008 20:46:11:000 04/02/2008 21:18:09:000

Source Code Comments

The course test score restriction and course pre-requisites table

Columns Comments for SCRRTST_SUBJ_CODE (# 1)

Source Code Comments

The subject code that the test score restriction and pre-requisite associated with

Columns Comments for SCRRTST_CRSE_NUMB (# 2)

Source Code Comments

The course number that the test score restriction and pre-requisite associated with

Columns Comments for SCRRTST_TERM_CODE_EFF (# 3)

Source Code Comments

The effective term associated with the test score restriction and pre-requisite

Columns Comments for SCRRTST_SEQNO (# 4)

Source Code Comments

The sequence number is used to insure the record will be in the correct order

Columns Comments for SCRRTST_TESC_CODE (# 5)

Source Code Comments

The test code associated with the restriction

Columns Comments for SCRRTST_TEST_SCORE (# 6)

Source Code Comments

The minimum score of the test code

Columns Comments for SCRRTST_SUBJ_CODE_PREQ (# 7)

Source Code Comments

This field defines the subject area for course pre-requisite requirements.

Columns Comments for SCRRTST_CRSE_NUMB_PREQ (# 8)

Source Code Comments

This field defines the course number for course pre-requisite requirements.

Columns Comments for SCRRTST_LEVL_CODE (# 9)

Source Code Comments

The level code for grade

Columns Comments for SCRRTST_MIN_GRDE (# 10)

Source Code Comments

The minimum grade required

Columns Comments for SCRRTST_CONCURRENCY_IND (# 11)

Source Code Comments

This field specifies that the pre-requisite course requirement can be taken at the same time as the Key Block course."Y" indicates that the pre-req. course may be taken at the same time

Columns Comments for SCRRTST_CONNECTOR (# 12)

Source Code Comments

The AND/OR connector used when restriction for the subject/course/term can have an AND/OR relationship

Columns Comments for SCRRTST_LPAREN (# 13)

Source Code Comments

Left parenthesis

Columns Comments for SCRRTST_RPAREN (# 14)

Source Code Comments

Right parenthesis

Columns Comments for SCRRTST_ACTIVITY_DATE (# 15)

Source Code Comments

The date the record was created or last updated

Table SCRSBGI

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRSBGI_SUBJ_CODE   VARCHAR2(4) No   *
SCRSBGI_CRSE_NUMB   VARCHAR2(5) No   *
SCRSBGI_EFF_TERM   VARCHAR2(6) No   *
SCRSBGI_SBGI_CODE   VARCHAR2(6) Yes   *
SCRSBGI_AGREEMENT_DATE   DATE No    
SCRSBGI_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRSBGI_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRSBGI_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCRSBGI_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCRSBGI_EFF_TERM STVTERM_CODE STVTERM
SCRSBGI_SBGI_CODE STVSBGI_CODE STVSBGI

Index

Index Name Index Type Column Name
SCRSBGI_KEY_INDEX Unique SCRSBGI_SUBJ_CODE
SCRSBGI_KEY_INDEX Unique SCRSBGI_CRSE_NUMB
SCRSBGI_KEY_INDEX Unique SCRSBGI_EFF_TERM
SCRSBGI_KEY_INDEX Unique SCRSBGI_SBGI_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
SCRSBGI Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRSBGI_KEY_INDEX SQL Index S10B80.SATURN Rely On
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVSBGI SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRSBGI

Object Dates

Creation Date Analysis Date
04/02/2008 20:44:32:000 04/02/2008 21:18:08:000

Source Code Comments

Source background institution agreements table

Columns Comments for SCRSBGI_SUBJ_CODE (# 1)

Source Code Comments

Source background institution agreement subject code

Columns Comments for SCRSBGI_CRSE_NUMB (# 2)

Source Code Comments

Source background institution agreement course number

Columns Comments for SCRSBGI_EFF_TERM (# 3)

Source Code Comments

Source background institution agreement effective term

Columns Comments for SCRSBGI_SBGI_CODE (# 4)

Source Code Comments

Source background institution code

Columns Comments for SCRSBGI_AGREEMENT_DATE (# 5)

Source Code Comments

Source background institution agreement date

Columns Comments for SCRSBGI_ACTIVITY_DATE (# 6)

Source Code Comments

The Activity Date

Table SCRSCHD

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRSCHD_SUBJ_CODE   VARCHAR2(4) No * *
SCRSCHD_CRSE_NUMB   VARCHAR2(5) No * *
SCRSCHD_EFF_TERM   VARCHAR2(6) No * *
SCRSCHD_SCHD_CODE   VARCHAR2(3) No * *
SCRSCHD_ACTIVITY_DATE   DATE No    
SCRSCHD_WORKLOAD   NUMBER(9,3) Yes    
SCRSCHD_MAX_ENRL   NUMBER(3,0) Yes    
SCRSCHD_ADJ_WORKLOAD   NUMBER(9,3) Yes    
SCRSCHD_INSM_CODE   VARCHAR2(5) Yes   *

Foreign Key information

Column name is Foreign Key For Column on Table
SCRSCHD_INSM_CODE GTVINSM_CODE GTVINSM
SCRSCHD_SCHD_CODE STVSCHD_CODE STVSCHD
SCRSCHD_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRSCHD_EFF_TERM STVTERM_CODE STVTERM
SCRSCHD_SUBJ_CODE SSBSECT_SUBJ_CODE SSBSECT
SCRSCHD_CRSE_NUMB SSBSECT_CRSE_NUMB SSBSECT

Index

Index Name Index Type Column Name
PK_SCRSCHD Unique SCRSCHD_SUBJ_CODE
PK_SCRSCHD Unique SCRSCHD_CRSE_NUMB
PK_SCRSCHD Unique SCRSCHD_EFF_TERM
PK_SCRSCHD Unique SCRSCHD_SCHD_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SSRMEET SQL Table S10B80.SATURN Join
SIVCALC SQL View S10B80.BANINST1 Use (select)
SIVCONT SQL View S10B80.BANINST1 Use (select)
SIVPFAC SQL View S10B80.BANINST1 Use (select)
F_GET_SCRSCHD_ROWID SQL Function S10B80.BANINST1 Use (select)
BASE_WORKLOAD_C Oracle Package Cursor S10B80.BANINST1.SIKLOAD Rely On
BASE_WORKLOAD_C Oracle Package Cursor S10B80.BANINST1.SIKLOAD Use (select)
P_DELETE_ALL Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBCVAR Use (delete,select)
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Rely On
P_CREATE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (Insert)
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.SB_COURSE_CATALOG Rely On
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.SB_COURSE_CATALOG Use (select)Rely On
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
P_DISPLAY_INFO Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)
P_UT_GRADEROLL Oracle Package Procedure S10B80.BANINST1.UT_GRADEROLL Use (delete)
P_VALIDATE_CHILDREN Oracle Package Procedure S10B80.BANINST1.SB_COURSE_RULES Rely On
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_ROOMDEFINITION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_SECTION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_WL_NOTIFICATION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_SECTION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_SECTION_LABOR Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_FACASSIGNMENT Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_FACULTY Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_WL_COLLECTOR Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_WL_SECTION_CTRL Use (Insert,select)
UT_TEARDOWN Oracle Package Procedure S10B80.BANINST1.UT_GB_SECTION Use (delete)
F_CALC_WORKLOAD Oracle Package Function S10B80.BANINST1.SB_FACASSIGNMENT Rely On
F_CALC_WORKLOAD Oracle Package Function S10B80.BANINST1.SB_FACASSIGNMENT Use (select)
F_CALC_WORKLOAD_BASE Oracle Package Function S10B80.BANINST1.SIKLOAD Rely On
F_CHECK_SCHD Oracle Package Function S10B80.BANINST1.SB_SECTION_RULES Use (select)
F_FTE_FACTOR Oracle Package Function S10B80.BANINST1.SIKLOAD Rely On
F_GET_COURSES Oracle Package Function S10B80.BANINST1.SP_CATALOG_EXPORT Use (select)
F_SCBCRSE_ALT Oracle Package Function S10B80.BANINST1.LM_COURSE_CATALOG Use (select)
F_SCRSCHD_VALUE Oracle Package Function S10B80.BANINST1.SCKSELS Rely On
F_SCRSCHD_VALUE Oracle Package Function S10B80.BANINST1.SCKSELS Use (select)Rely On
SCRSCHD Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SCRSCHD SQL Index S10B80.SATURN Rely On
GTVINSM SQL Table S10B80.GENERAL Refer (no action)
SSBSECT SQL Table S10B80.SATURN Join
STVSCHD SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRSCHD

Object Dates

Creation Date Analysis Date
04/02/2008 20:49:09:000 04/02/2008 21:18:12:000

Source Code Comments

Course Schedule Type Repeating Table

Columns Comments for SCRSCHD_SUBJ_CODE (# 1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCRSCHD_CRSE_NUMB (# 2)

Source Code Comments

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

Columns Comments for SCRSCHD_EFF_TERM (# 3)

Source Code Comments

This field identifies the term this version of the course schedule types becomes effective.

Columns Comments for SCRSCHD_SCHD_CODE (# 4)

Source Code Comments

This field defines the schedule type codes which can be authorized for a course. Each course must be authorized to be offered for at least one schedule type. An unlimited number of schedule types can be authorized for a course.

Columns Comments for SCRSCHD_ACTIVITY_DATE (# 5)

Source Code Comments

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

Columns Comments for SCRSCHD_WORKLOAD (# 6)

Source Code Comments

Instructional workload value for the schedule type

Columns Comments for SCRSCHD_MAX_ENRL (# 7)

Source Code Comments

Maximum student enrollment for workload

Columns Comments for SCRSCHD_ADJ_WORKLOAD (# 8)

Source Code Comments

Adjust instructional workload value for the schedule type

Columns Comments for SCRSCHD_INSM_CODE (# 9)

Source Code Comments

Instructional Method code: This field indicates how the course is delivered to the learner. Examples are Web based, mixed media, face to face

Table SCRSECT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRSECT_SUBJ_CODE   VARCHAR2(4) No * *
SCRSECT_CRSE_NUMB   VARCHAR2(5) No * *
SCRSECT_CAMP_CODE   VARCHAR2(3) No * *
SCRSECT_SCHD_CODE   VARCHAR2(3) No * *
SCRSECT_TERM_CODE   VARCHAR2(6) No * *
SCRSECT_SECT_OFFER   NUMBER(3,0) No    
SCRSECT_ENRL   NUMBER(6,0) No    
SCRSECT_CENSUS_ENRL   NUMBER(6,0) No    
SCRSECT_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRSECT_CAMP_CODE STVCAMP_CODE STVCAMP
SCRSECT_SCHD_CODE STVSCHD_CODE STVSCHD
SCRSECT_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRSECT_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCRSECT_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCRSECT_TERM_CODE STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SCRSECT Unique SCRSECT_SUBJ_CODE
PK_SCRSECT Unique SCRSECT_CRSE_NUMB
PK_SCRSECT Unique SCRSECT_TERM_CODE
PK_SCRSECT Unique SCRSECT_SCHD_CODE
PK_SCRSECT Unique SCRSECT_CAMP_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SCRSECT SQL Index S10B80.SATURN Rely On
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVCAMP SQL Table S10B80.SATURN Refer (no action)
STVSCHD SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRSECT

Object Dates

Creation Date Analysis Date
04/02/2008 20:57:50:000 04/02/2008 21:18:18:000

Source Code Comments

Schedule History Table

Columns Comments for SCRSECT_SUBJ_CODE (# 1)

Source Code Comments

Course subject of the schedule that has been deleted from data base by scheduling purge

Columns Comments for SCRSECT_CRSE_NUMB (# 2)

Source Code Comments

Course number of the schedule that has been deleted from data base by scheduling purge

Columns Comments for SCRSECT_CAMP_CODE (# 3)

Source Code Comments

Campus of the course schedule that has been deleted from data base by scheduling purge

Columns Comments for SCRSECT_SCHD_CODE (# 4)

Source Code Comments

Schedule type of the course schedule that has been deleted from data base by scheduling purge

Columns Comments for SCRSECT_TERM_CODE (# 5)

Source Code Comments

Term of the course schedule that has been deleted from data base by scheduling purge

Columns Comments for SCRSECT_SECT_OFFER (# 6)

Source Code Comments

Number of the sections for the deleted schedule with same campus, same schedule type and same term has been offered

Columns Comments for SCRSECT_ENRL (# 7)

Source Code Comments

The actual enrollment for the deleted schedule

Columns Comments for SCRSECT_CENSUS_ENRL (# 8)

Source Code Comments

The census enrollment for the deleted schedule

Columns Comments for SCRSECT_ACTIVITY_DATE (# 9)

Source Code Comments

The date when the record was added or last updated

Table SCRSPRT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRSPRT_SUBJ_CODE   VARCHAR2(4) No   *
SCRSPRT_TERM_CODE_EFF   VARCHAR2(6) No   *
SCRSPRT_ACTIVITY_DATE   DATE No    
SCRSPRT_USER_ID   VARCHAR2(30) No    
SCRSPRT_PARS_CODE   VARCHAR2(7) Yes   *
SCRSPRT_PARS_PREF_NUMBER   NUMBER(2,0) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRSPRT_PARS_CODE GTVPARS_CODE GTVPARS
SCRSPRT_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRSPRT_TERM_CODE_EFF STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
UK1_SCRSPRT Unique SCRSPRT_SUBJ_CODE
UK1_SCRSPRT Unique SCRSPRT_PARS_CODE
UK1_SCRSPRT Unique SCRSPRT_TERM_CODE_EFF

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
UK1_SCRSPRT SQL Index S10B80.SATURN Rely On
GTVPARS SQL Table S10B80.GENERAL Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRSPRT

Object Dates

Creation Date Analysis Date
04/02/2008 20:41:56:000 04/02/2008 21:18:05:000

Source Code Comments

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

Columns Comments for SCRSPRT_SUBJ_CODE (# 1)

Source Code Comments

Subject code for catalog subject partitions.

Columns Comments for SCRSPRT_TERM_CODE_EFF (# 2)

Source Code Comments

Effective Term code for catalog subject partition code.

Columns Comments for SCRSPRT_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for SCRSPRT_USER_ID (# 4)

Source Code Comments

User ID of last person to create/update record.

Columns Comments for SCRSPRT_PARS_CODE (# 5)

Source Code Comments

Partition code for catalog subject entry.

Columns Comments for SCRSPRT_PARS_PREF_NUMBER (# 6)

Source Code Comments

Preference Number for Partition code for catalog subject entry.

Table SCRSRDF

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRSRDF_SUBJ_CODE   VARCHAR2(4) No   *
SCRSRDF_TERM_CODE_EFF   VARCHAR2(6) No   *
SCRSRDF_ACTIVITY_DATE   DATE No    
SCRSRDF_USER_ID   VARCHAR2(30) No    
SCRSRDF_RDEF_CODE   VARCHAR2(4) Yes   *
SCRSRDF_RDEF_PREF_NUMBER   NUMBER(2,0) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRSRDF_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRSRDF_RDEF_CODE STVRDEF_CODE STVRDEF
SCRSRDF_TERM_CODE_EFF STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
UK1_SCRSRDF Unique SCRSRDF_SUBJ_CODE
UK1_SCRSRDF Unique SCRSRDF_RDEF_CODE
UK1_SCRSRDF Unique SCRSRDF_TERM_CODE_EFF

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
UK1_SCRSRDF SQL Index S10B80.SATURN Rely On
STVRDEF SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRSRDF

Object Dates

Creation Date Analysis Date
04/02/2008 20:48:23:000 04/02/2008 21:18:11:000

Source Code Comments

Room definition/attribute Codes for catalog subject entries. This describes characteristics of rooms required for the scheduling tool.

Columns Comments for SCRSRDF_SUBJ_CODE (# 1)

Source Code Comments

Subject code for catalog subject room definition/attributes.

Columns Comments for SCRSRDF_TERM_CODE_EFF (# 2)

Source Code Comments

Effective Term code for catalog subject room definition/attribute code.

Columns Comments for SCRSRDF_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for SCRSRDF_USER_ID (# 4)

Source Code Comments

User ID of last person to create/update record.

Columns Comments for SCRSRDF_RDEF_CODE (# 5)

Source Code Comments

room definition/attribute code for catalog subject entry.

Columns Comments for SCRSRDF_RDEF_PREF_NUMBER (# 6)

Source Code Comments

Preference Number for room definition/attribute code for catalog subject entry.

Table SCRSYLN

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRSYLN_SUBJ_CODE   VARCHAR2(4) No   *
SCRSYLN_CRSE_NUMB   VARCHAR2(5) No    
SCRSYLN_TERM_CODE_EFF   VARCHAR2(6) No   *
SCRSYLN_ACTIVITY_DATE   DATE No    
SCRSYLN_USER_ID   VARCHAR2(30) No    
SCRSYLN_TERM_CODE_END   VARCHAR2(6) Yes   *
SCRSYLN_LONG_COURSE_TITLE   VARCHAR2(100) Yes    
SCRSYLN_COURSE_URL   VARCHAR2(100) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRSYLN_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRSYLN_TERM_CODE_EFF STVTERM_CODE STVTERM
SCRSYLN_TERM_CODE_END STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
UK_SCRSYLN Unique SCRSYLN_SUBJ_CODE
UK_SCRSYLN Unique SCRSYLN_CRSE_NUMB
UK_SCRSYLN Unique SCRSYLN_TERM_CODE_EFF
UK_SCRSYLN Unique SCRSYLN_TERM_CODE_END

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRSYLNC Oracle Package Cursor S10B80.BANINST1.BWCKCTLG Rely On
SCRSYLNC Oracle Package Cursor S10B80.BANINST1.BWCKCTLG Use (select)
SCRSYLNC Oracle Package Cursor S10B80.BANINST1.SCKLIBS Use (select)Rely On
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
F_CHECK_CATALOG_LONG_TITLE Oracle Package Function S10B80.BANINST1.SCKSELS Rely On
F_COURSE_TITLE Oracle Package Function S10B80.BANINST1.BWCKLIBS Use (select)
SCRSYLN Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
UK_SCRSYLN SQL Index S10B80.SATURN Rely On
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRSYLN

Object Dates

Creation Date Analysis Date
04/02/2008 20:46:51:000 04/02/2008 21:18:10:000

Source Code Comments

Course Syllabus course long name table

Columns Comments for SCRSYLN_SUBJ_CODE (# 1)

Source Code Comments

Identifies the subject code of the course that the long name is attached to

Columns Comments for SCRSYLN_CRSE_NUMB (# 2)

Source Code Comments

Identifies the course number of the course that the long name is attached to

Columns Comments for SCRSYLN_TERM_CODE_EFF (# 3)

Source Code Comments

Identifies the Start Term for which the long name is applicable to

Columns Comments for SCRSYLN_ACTIVITY_DATE (# 4)

Source Code Comments

Date this record entered or last updated

Columns Comments for SCRSYLN_USER_ID (# 5)

Source Code Comments

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

Columns Comments for SCRSYLN_TERM_CODE_END (# 6)

Source Code Comments

Identifies the term that the course long name effective term ends

Columns Comments for SCRSYLN_LONG_COURSE_TITLE (# 7)

Source Code Comments

The long title of the course

Columns Comments for SCRSYLN_COURSE_URL (# 8)

Source Code Comments

The URL of the course

Table SCRSYLO

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRSYLO_SUBJ_CODE   VARCHAR2(4) No   *
SCRSYLO_CRSE_NUMB   VARCHAR2(5) No    
SCRSYLO_TERM_CODE_EFF   VARCHAR2(6) No   *
SCRSYLO_ACTIVITY_DATE   DATE No    
SCRSYLO_USER_ID   VARCHAR2(30) No    
SCRSYLO_TERM_CODE_END   VARCHAR2(6) Yes   *
SCRSYLO_LEARNING_OBJECTIVES   CLOB Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRSYLO_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRSYLO_TERM_CODE_EFF STVTERM_CODE STVTERM
SCRSYLO_TERM_CODE_END STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
UK_SCRSYLO Unique SCRSYLO_SUBJ_CODE
UK_SCRSYLO Unique SCRSYLO_CRSE_NUMB
UK_SCRSYLO Unique SCRSYLO_TERM_CODE_EFF
UK_SCRSYLO Unique SCRSYLO_TERM_CODE_END

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRSYLOC Oracle Package Cursor S10B80.BANINST1.SCKLIBS Use (select)Rely On
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
F_CHECK_CATALOG_SYLLABUS Oracle Package Function S10B80.BANINST1.SCKSELS Rely On
SCRSYLO Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
UK_SCRSYLO SQL Index S10B80.SATURN Rely On
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRSYLO

Object Dates

Creation Date Analysis Date
04/02/2008 20:46:54:000 04/02/2008 21:18:10:000

Source Code Comments

Course Syllabus course learning objective table

Columns Comments for SCRSYLO_SUBJ_CODE (# 1)

Source Code Comments

Identifies the subject code of the course that the learning objective is attached to

Columns Comments for SCRSYLO_CRSE_NUMB (# 2)

Source Code Comments

Identifies the course number of the course that the learning objective is attached to

Columns Comments for SCRSYLO_TERM_CODE_EFF (# 3)

Source Code Comments

Identifies the Start Term for which the learning objective is applicable to

Columns Comments for SCRSYLO_ACTIVITY_DATE (# 4)

Source Code Comments

Date this record entered or last updated

Columns Comments for SCRSYLO_USER_ID (# 5)

Source Code Comments

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

Columns Comments for SCRSYLO_TERM_CODE_END (# 6)

Source Code Comments

Identifies the Term that the learning objective effective term ends

Columns Comments for SCRSYLO_LEARNING_OBJECTIVES (# 7)

Source Code Comments

The Learning Objective of the course

Table SCRSYRM

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRSYRM_SUBJ_CODE   VARCHAR2(4) No   *
SCRSYRM_CRSE_NUMB   VARCHAR2(5) No    
SCRSYRM_TERM_CODE_EFF   VARCHAR2(6) No   *
SCRSYRM_ACTIVITY_DATE   DATE No    
SCRSYRM_USER_ID   VARCHAR2(30) No    
SCRSYRM_TERM_CODE_END   VARCHAR2(6) Yes   *
SCRSYRM_REQUIRED_MATERIALS   CLOB Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRSYRM_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRSYRM_TERM_CODE_EFF STVTERM_CODE STVTERM
SCRSYRM_TERM_CODE_END STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
UK_SCRSYRM Unique SCRSYRM_SUBJ_CODE
UK_SCRSYRM Unique SCRSYRM_CRSE_NUMB
UK_SCRSYRM Unique SCRSYRM_TERM_CODE_EFF
UK_SCRSYRM Unique SCRSYRM_TERM_CODE_END

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRSYRMC Oracle Package Cursor S10B80.BANINST1.SCKLIBS Use (select)Rely On
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
SCRSYRM Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
UK_SCRSYRM SQL Index S10B80.SATURN Rely On
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRSYRM

Object Dates

Creation Date Analysis Date
04/02/2008 20:47:54:000 04/02/2008 21:18:11:000

Source Code Comments

Course Syllabus course required materials table

Columns Comments for SCRSYRM_SUBJ_CODE (# 1)

Source Code Comments

Identifies the subject code of the course that the required material is attached to

Columns Comments for SCRSYRM_CRSE_NUMB (# 2)

Source Code Comments

Identifies the course number of the course that the required material is attached to

Columns Comments for SCRSYRM_TERM_CODE_EFF (# 3)

Source Code Comments

Identifies the Start Term for which the required material is applicable to

Columns Comments for SCRSYRM_ACTIVITY_DATE (# 4)

Source Code Comments

Date this record entered or last updated

Columns Comments for SCRSYRM_USER_ID (# 5)

Source Code Comments

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

Columns Comments for SCRSYRM_TERM_CODE_END (# 6)

Source Code Comments

Identifies the Term that the required material effective term ends

Columns Comments for SCRSYRM_REQUIRED_MATERIALS (# 7)

Source Code Comments

The Required Materials for the course

Table SCRSYTR

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRSYTR_SUBJ_CODE   VARCHAR2(4) No   *
SCRSYTR_CRSE_NUMB   VARCHAR2(5) No    
SCRSYTR_TERM_CODE_EFF   VARCHAR2(6) No   *
SCRSYTR_ACTIVITY_DATE   DATE No    
SCRSYTR_USER_ID   VARCHAR2(30) No    
SCRSYTR_TERM_CODE_END   VARCHAR2(6) Yes   *
SCRSYTR_TECHNICAL_REQUIREMENT   CLOB Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRSYTR_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRSYTR_TERM_CODE_EFF STVTERM_CODE STVTERM
SCRSYTR_TERM_CODE_END STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
UK_SCRSYTR Unique SCRSYTR_SUBJ_CODE
UK_SCRSYTR Unique SCRSYTR_CRSE_NUMB
UK_SCRSYTR Unique SCRSYTR_TERM_CODE_EFF
UK_SCRSYTR Unique SCRSYTR_TERM_CODE_END

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRSYTRC Oracle Package Cursor S10B80.BANINST1.SCKLIBS Use (select)Rely On
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
SCRSYTR Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
UK_SCRSYTR SQL Index S10B80.SATURN Rely On
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRSYTR

Object Dates

Creation Date Analysis Date
04/02/2008 20:48:16:000 04/02/2008 21:18:11:000

Source Code Comments

Course Syllabus course technical requirements table

Columns Comments for SCRSYTR_SUBJ_CODE (# 1)

Source Code Comments

Identifies the subject code of the course that the technical requirement is attached to

Columns Comments for SCRSYTR_CRSE_NUMB (# 2)

Source Code Comments

Identifies the course number of the course that the technical requirement is attached to

Columns Comments for SCRSYTR_TERM_CODE_EFF (# 3)

Source Code Comments

Identifies the Start Term for which the long name is applicable to

Columns Comments for SCRSYTR_ACTIVITY_DATE (# 4)

Source Code Comments

Date this record entered or last updated

Columns Comments for SCRSYTR_USER_ID (# 5)

Source Code Comments

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

Columns Comments for SCRSYTR_TERM_CODE_END (# 6)

Source Code Comments

Identifies the term that the course technical requirement effective term ends

Columns Comments for SCRSYTR_TECHNICAL_REQUIREMENT (# 7)

Source Code Comments

The Technical Requirements for the course

Table SCRTEXT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRTEXT_SUBJ_CODE   VARCHAR2(4) No   *
SCRTEXT_CRSE_NUMB   VARCHAR2(5) No   *
SCRTEXT_EFF_TERM   VARCHAR2(6) No   *
SCRTEXT_TEXT_CODE   VARCHAR2(1) Yes    
SCRTEXT_SEQNO   NUMBER(23,20) Yes    
SCRTEXT_TEXT   VARCHAR2(60) Yes    
SCRTEXT_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
SCRTEXT_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRTEXT_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCRTEXT_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY
SCRTEXT_EFF_TERM STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
SCRTEXT_KEY_INDEX   SCRTEXT_SUBJ_CODE
SCRTEXT_KEY_INDEX   SCRTEXT_CRSE_NUMB
SCRTEXT_KEY_INDEX   SCRTEXT_EFF_TERM
SCRTEXT_KEY_INDEX   SCRTEXT_TEXT_CODE
SCRTEXT_KEY_INDEX   SCRTEXT_SEQNO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRTEXTC Oracle Package Cursor S10B80.BANINST1.SCKLIBS Use (select)Rely On
P_DELETE Oracle Package Procedure S10B80.BANINST1.SB_COURSE Use (delete)
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.SB_COURSE_CATALOG Rely On
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAY_INFO Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAY_INFO Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
SCRTEXT Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SCRTEXT_KEY_INDEX SQL Index S10B80.SATURN Rely On
SCBCRKY SQL Table S10B80.SATURN Refer (no action)
STVSUBJ SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SCRTEXT

Object Dates

Creation Date Analysis Date
04/02/2008 20:40:33:000 04/02/2008 21:18:04:000

Source Code Comments

Course Descriptive Text Repeating Table

Columns Comments for SCRTEXT_SUBJ_CODE (# 1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCRTEXT_CRSE_NUMB (# 2)

Source Code Comments

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

Columns Comments for SCRTEXT_EFF_TERM (# 3)

Source Code Comments

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

Columns Comments for SCRTEXT_TEXT_CODE (# 4)

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 SCRTEXT_SEQNO (# 5)

Source Code Comments

This field identifies an internal sequence number associated with each line of text. This field is not displayed.

Columns Comments for SCRTEXT_TEXT (# 6)

Source Code Comments

Course text is maintained in these records. Text will be reproduced in the Bulletin Report - SCRBULT, exactly as keyed here. An unlimited number of text records can be maintained in this block.

Columns Comments for SCRTEXT_ACTIVITY_DATE (# 7)

Source Code Comments

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

Link between SCBCRSE and SCBCRKY


Join Information

Objects list
scope-cursor : S10B80.BANINST1.SP_COURSE_CATALOG.SCBCRSE_C
scope-cursor : S10B80.BANINST1.SCKLIBS.SCBCRSE2C
scope-procedure : S10B80.BANINST1.SB_COURSE_CATALOG.P_DISPLAY_COURSES
scope-procedure : S10B80.BANINST1.BWCKCTLG.P_CAT_SEARCH
scope-procedure : S10B80.BANINST1.BWCKCTLG.P_DISPLAY_COURSES
scope-function : S10B80.BANINST1.LM_COURSE_CATALOG.F_SCBCRSE_ALT
scope-function : S10B80.BANINST1.SP_CATALOG_EXPORT.F_GET_COURSES
scope-function : S10B80.BANINST1.ICSCKCOM.F_GET_COURSE

Link List

Link Type Link Project
Join Link Between SCBCRSE and SCBCRKY SATURN

List of Real links

Link type Between And
Join SCBCRSE SCBCRKY

Link between SCBCRSE and SCBDESC


Join Information

Objects list
scope-cursor : S10B80.BANINST1.SP_COURSE_CATALOG.SCBCRSE_C
scope-function : S10B80.BANINST1.LM_COURSE_CATALOG.F_SCBCRSE_ALT

Link List

Link Type Link Project
Join Link Between SCBCRSE and SCBDESC SATURN

List of Real links

Link type Between And
Join SCBCRSE SCBDESC

Link between SCRLEVL and PK_SCRLEVL


Link List

Link Type Link Project
Rely On Link Between SCRLEVL and PK_SCRLEVL SATURN

List of Real links

Link type Between And
Rely On SCRLEVL PK_SCRLEVL

Link between SCRRCHR and PK_SCRRCHR


Link List

Link Type Link Project
Rely On Link Between SCRRCHR and PK_SCRRCHR SATURN

List of Real links

Link type Between And
Rely On SCRRCHR PK_SCRRCHR

Link between SCRGMOD and PK_SCRGMOD


Link List

Link Type Link Project
Rely On Link Between SCRGMOD and PK_SCRGMOD SATURN

List of Real links

Link type Between And
Rely On SCRGMOD PK_SCRGMOD

Link between SCRRDEP and PK_SCRRDEP


Link List

Link Type Link Project
Rely On Link Between SCRRDEP and PK_SCRRDEP SATURN

List of Real links

Link type Between And
Rely On SCRRDEP PK_SCRRDEP

Link between SCBSUPP and PK_SCBSUPP


Link List

Link Type Link Project
Rely On Link Between SCBSUPP and PK_SCBSUPP SATURN

List of Real links

Link type Between And
Rely On SCBSUPP PK_SCBSUPP

Link between SCRCLBD and PK_SCRCLBD


Link List

Link Type Link Project
Rely On Link Between SCRCLBD and PK_SCRCLBD SATURN

List of Real links

Link type Between And
Rely On SCRCLBD PK_SCRCLBD

Link between SCRSCHD and PK_SCRSCHD


Link List

Link Type Link Project
Rely On Link Between SCRSCHD and PK_SCRSCHD SATURN

List of Real links

Link type Between And
Rely On SCRSCHD PK_SCRSCHD

Link between SCRSECT and PK_SCRSECT


Link List

Link Type Link Project
Rely On Link Between SCRSECT and PK_SCRSECT SATURN

List of Real links

Link type Between And
Rely On SCRSECT PK_SCRSECT

Link between SCBCRKY and PK_SCBCRKY


Link List

Link Type Link Project
Rely On Link Between SCBCRKY and PK_SCBCRKY SATURN

List of Real links

Link type Between And
Rely On SCBCRKY PK_SCBCRKY

Link between SCBSUPP and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCBSUPP and SCBCRKY (FK1_SCBSUPP_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCBSUPP SCBSUPP_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCBSUPP SCBSUPP_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRFEES and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRFEES and SCBCRKY (FK1_SCRFEES_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRFEES SCRFEES_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRFEES SCRFEES_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRINTG and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRINTG and SCBCRKY (FK1_SCRINTG_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRINTG SCRINTG_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRINTG SCRINTG_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRRCAM and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRRCAM and SCBCRKY (FK1_SCRRCAM_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRRCAM SCRRCAM_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRRCAM SCRRCAM_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRRCHR and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRRCHR and SCBCRKY (FK1_SCRRCHR_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRRCHR SCRRCHR_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRRCHR SCRRCHR_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRRCLS and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRRCLS and SCBCRKY (FK1_SCRRCLS_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRRCLS SCRRCLS_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRRCLS SCRRCLS_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRRCMP and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRRCMP and SCBCRKY (FK1_SCRRCMP_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRRCMP SCRRCMP_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRRCMP SCRRCMP_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRRCOL and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRRCOL and SCBCRKY (FK1_SCRRCOL_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRRCOL SCRRCOL_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRRCOL SCRRCOL_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRRDEP and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRRDEP and SCBCRKY (FK1_SCRRDEP_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRRDEP SCRRDEP_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRRDEP SCRRDEP_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRRLVL and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRRLVL and SCBCRKY (FK1_SCRRLVL_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRRLVL SCRRLVL_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRRLVL SCRRLVL_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRRMAJ and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRRMAJ and SCBCRKY (FK1_SCRRMAJ_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRRMAJ SCRRMAJ_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRRMAJ SCRRMAJ_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRRTRM and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRRTRM and SCBCRKY (FK1_SCRRTRM_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRRTRM SCRRTRM_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRRTRM SCRRTRM_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRRTST and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRRTST and SCBCRKY (FK1_SCRRTST_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRRTST SCRRTST_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRRTST SCRRTST_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRSBGI and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRSBGI and SCBCRKY (FK1_SCRSBGI_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRSBGI SCRSBGI_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRSBGI SCRSBGI_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRSECT and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRSECT and SCBCRKY (FK1_SCRSECT_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRSECT SCRSECT_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRSECT SCRSECT_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRTEXT and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRTEXT and SCBCRKY (FK1_SCRTEXT_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRTEXT SCRTEXT_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRTEXT SCRTEXT_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRATTR and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRATTR and SCBCRKY (FK1_SCRATTR_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRATTR SCRATTR_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRATTR SCRATTR_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRRATT and PK_SCRRATT


Link List

Link Type Link Project
Rely On Link Between SCRRATT and PK_SCRRATT SATURN

List of Real links

Link type Between And
Rely On SCRRATT PK_SCRRATT

Link between SCRRATT and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRRATT and SCBCRKY (FK1_SCRRATT_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRRATT SCRRATT_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRRATT SCRRATT_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCRCORQ and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCRCORQ and SCBCRKY (FK1_SCRCORQ_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCRCORQ SCRCORQ_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCRCORQ SCRCORQ_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)

Link between SCREQIV and SCBCRKY


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between SCREQIV and SCBCRKY (FK1_SCREQIV_INV_SCBCRKY_KEY) SATURN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SCREQIV SCREQIV_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY (1,1)-(0,n)
SCREQIV SCREQIV_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY (1,1)-(0,n)