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

Model Cross Product Tables


Model Label : Tables used in Banner Student Cross Product

List of Objects

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

Comments

Model View

''

Table SOBCACT

Schema Name SATURN
Label SOBCACT
Server name S4B70
Creation Date 01/14/2004 11:08:03:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SOBCACT_CACT_CODE SOBCACT_CACT_CODE VARCHAR2(15) No * *
SOBCACT_ACTIVE_IND SOBCACT_ACTIVE_IND VARCHAR2(1) No
SOBCACT_SYS_REQ_IND SOBCACT_SYS_REQ_IND VARCHAR2(1) No
SOBCACT_USER_ID SOBCACT_USER_ID VARCHAR2(30) No
SOBCACT_ACTIVITY_DATE SOBCACT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SOBCACT_CACT_CODE STVCACT_CODE STVCACT
SOBCACT_CACT_CODE SORLCUR_CACT_CODE SORLCUR
SOBCACT_CACT_CODE SORLFOS_CACT_CODE SORLFOS

Index

Index Name Index Type Column Name
PK_SOBCACT Unique SOBCACT_CACT_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SOBCACT SYNONYM S4B70.PUBLIC Rely on ()
SOVLCUR VIEW S4B70.BANINST1 Use(select )
SOVLFOS VIEW S4B70.BANINST1 Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.STVCACT.STVCACT Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.STVCACT.STVCACT Use(select )
CURRICSTATUS_REC Package Type S4B70.BANINST1.SB_CURRICSTATUS Rely on ()
GMWCURRICSTATUS_REC Package Type S4B70.BANINST1.SB_GMWCURRICSTATUS Rely on ()
GMWGMWCURRICSTATUS_REC Package Type S4B70.BANINST1.SB_GMWGMWCURRICSTATUS Rely on ()
GMWGMWGCURRICSTATUS_REC Package Type S4B70.BANINST1.SB_GMWGMWGCURRICSTATUS Rely on ()
LEARNERCURRICSTATUS_REC Package Type S4B70.BANINST1.SB_LEARNERCURRICSTATUS Rely on ()
P_OVERLAY_VALIDATION_REC Package procedure S4B70.BANINST1.SB_GMWGMWGCURRICSTATUS Rely on ()
P_OVERLAY_VALIDATION_REC Package procedure S4B70.BANINST1.SB_CURRICSTATUS Rely on ()
P_OVERLAY_VALIDATION_REC Package procedure S4B70.BANINST1.SB_LEARNERCURRICSTATUS Rely on ()
P_OVERLAY_VALIDATION_REC Package procedure S4B70.BANINST1.SB_GMWGMWCURRICSTATUS Rely on ()
P_OVERLAY_VALIDATION_REC Package procedure S4B70.BANINST1.SB_GMWCURRICSTATUS Rely on ()
F_BUILD_SOBCACT_REC Package function S4B70.BANINST1.SB_GMWGMWGCURRICSTATUS Rely on ()
F_BUILD_SOBCACT_REC Package function S4B70.BANINST1.SB_LEARNERCURRICSTATUS Rely on ()
F_BUILD_SOBCACT_REC Package function S4B70.BANINST1.SB_GMWCURRICSTATUS Rely on ()
F_BUILD_SOBCACT_REC Package function S4B70.BANINST1.SB_LEARNERCURRICSTATUS Rely on ()
F_BUILD_SOBCACT_REC Package function S4B70.BANINST1.SB_GMWGMWCURRICSTATUS Rely on ()
F_BUILD_SOBCACT_REC Package function S4B70.BANINST1.SB_CURRICSTATUS Rely on ()
F_BUILD_SOBCACT_REC Package function S4B70.BANINST1.SB_CURRICSTATUS Rely on ()
P_CREATE Package procedure S4B70.BANINST1.SB_GMWGMWGCURRICSTATUS Rely on ()
P_CREATE Package procedure S4B70.BANINST1.SB_GMWGMWCURRICSTATUS Rely on ()
P_CREATE Package procedure S4B70.BANINST1.SB_GMWCURRICSTATUS Rely on ()
P_CREATE Package procedure S4B70.BANINST1.SB_LEARNERCURRICSTATUS Rely on ()
P_CREATE Package procedure S4B70.BANINST1.SB_CURRICSTATUS Rely on ()
P_CREATE Package procedure S4B70.BANINST1.SB_CURRICSTATUS Rely on ()
P_CREATE Package procedure S4B70.BANINST1.SB_LEARNERCURRICSTATUS Rely on ()
P_DELETE Package procedure S4B70.BANINST1.SB_GMWGMWGCURRICSTATUS Rely on ()
P_DELETE Package procedure S4B70.BANINST1.DML_SOBCACT Use(delete )
P_DELETE Package procedure S4B70.BANINST1.SB_CURRICSTATUS Rely on ()
P_DELETE Package procedure S4B70.BANINST1.SB_GMWGMWCURRICSTATUS Rely on ()
P_DELETE Package procedure S4B70.BANINST1.SB_GMWCURRICSTATUS Rely on ()
P_DELETE Package procedure S4B70.BANINST1.SB_LEARNERCURRICSTATUS Rely on ()
P_INSERT Package procedure S4B70.BANINST1.DML_SOBCACT Rely on () Use(insert )
P_LOCK Package procedure S4B70.BANINST1.SB_GMWGMWGCURRICSTATUS Rely on ()
P_LOCK Package procedure S4B70.BANINST1.SB_LEARNERCURRICSTATUS Use(select )
P_LOCK Package procedure S4B70.BANINST1.SB_CURRICSTATUS Rely on ()
P_LOCK Package procedure S4B70.BANINST1.SB_CURRICSTATUS Use(select )
P_LOCK Package procedure S4B70.BANINST1.SB_GMWCURRICSTATUS Rely on ()
P_LOCK Package procedure S4B70.BANINST1.SB_GMWGMWCURRICSTATUS Rely on ()
P_LOCK Package procedure S4B70.BANINST1.SB_LEARNERCURRICSTATUS Rely on ()
P_REGISTER_ENTITY Package procedure S4B70.BANINST1.SB_GMWGMWCURRICSTATUS_RULES Rely on ()
P_REGISTER_ENTITY Package procedure S4B70.BANINST1.SB_LEARNERCURRICSTATUS_RULES Rely on ()
P_REGISTER_ENTITY Package procedure S4B70.BANINST1.SB_GMWCURRICSTATUS_RULES Rely on ()
P_REGISTER_ENTITY Package procedure S4B70.BANINST1.SB_GMWGMWGCURRICSTATUS_RULES Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.SB_GMWGMWGCURRICSTATUS Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.SB_LEARNERCURRICSTATUS Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.SB_CURRICSTATUS Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.SB_CURRICSTATUS Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.DML_SOBCACT Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.SB_LEARNERCURRICSTATUS Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.SB_GMWGMWCURRICSTATUS Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.SB_GMWCURRICSTATUS Rely on ()
P_VALIDATE Package procedure S4B70.BANINST1.SB_GMWGMWCURRICSTATUS_RULES Rely on ()
P_VALIDATE Package procedure S4B70.BANINST1.SB_GMWGMWGCURRICSTATUS_RULES Rely on ()
P_VALIDATE Package procedure S4B70.BANINST1.SB_LEARNERCURRICSTATUS_RULES Rely on ()
P_VALIDATE Package procedure S4B70.BANINST1.SB_GMWCURRICSTATUS_RULES Rely on ()
P_VALIDATE_INSERT Package procedure S4B70.BANINST1.SB_CURRICULUM_RULES Rely on ()
P_VALIDATE_INSERT Package procedure S4B70.BANINST1.SB_CURRICULUM_RULES Rely on ()
P_VALIDATE_INSERT Package procedure S4B70.BANINST1.SB_FIELDOFSTUDY_RULES Rely on ()
P_VALIDATE_INSERT Package procedure S4B70.BANINST1.SB_FIELDOFSTUDY_RULES Rely on ()
F_CURRENT_LCUR Package function S4B70.BANINST1.SOKLCUR Rely on ()
F_CURRENT_LFOS Package function S4B70.BANINST1.SOKLCUR Rely on ()
F_EXISTS Package function S4B70.BANINST1.SB_GMWGMWGCURRICSTATUS Rely on ()
F_EXISTS Package function S4B70.BANINST1.SB_CURRICSTATUS Rely on ()
F_EXISTS Package function S4B70.BANINST1.SB_LEARNERCURRICSTATUS Use(select )
F_EXISTS Package function S4B70.BANINST1.SB_CURRICSTATUS Use(select )
F_EXISTS Package function S4B70.BANINST1.SB_LEARNERCURRICSTATUS Rely on ()
F_EXISTS Package function S4B70.BANINST1.SB_GMWGMWCURRICSTATUS Rely on ()
F_EXISTS Package function S4B70.BANINST1.SB_GMWCURRICSTATUS Rely on ()
F_QUERY_ALL Package function S4B70.BANINST1.SB_GMWGMWGCURRICSTATUS Rely on ()
F_QUERY_ALL Package function S4B70.BANINST1.SB_LEARNERCURRICSTATUS Use(select )
F_QUERY_ALL Package function S4B70.BANINST1.SB_CURRICSTATUS Rely on ()
F_QUERY_ALL Package function S4B70.BANINST1.SB_CURRICSTATUS Use(select )
F_QUERY_ALL Package function S4B70.BANINST1.SB_GMWGMWCURRICSTATUS Rely on ()
F_QUERY_ALL Package function S4B70.BANINST1.SB_LEARNERCURRICSTATUS Rely on ()
F_QUERY_ALL Package function S4B70.BANINST1.SB_GMWCURRICSTATUS Rely on ()
F_QUERY_BY_ROWID Package function S4B70.BANINST1.SB_CURRICSTATUS Use(select )
F_QUERY_BY_ROWID Package function S4B70.BANINST1.SB_LEARNERCURRICSTATUS Use(select )
F_QUERY_CURRENT Package function S4B70.BANINST1.SB_FIELDOFSTUDY Rely on ()
F_QUERY_CURRENT Package function S4B70.BANINST1.SB_FIELDOFSTUDY Use(select )
F_QUERY_CURRENT Package function S4B70.BANINST1.SB_CURRICULUM Rely on ()
F_QUERY_CURRENT Package function S4B70.BANINST1.SB_CURRICULUM Use(select )
F_QUERY_ONE Package function S4B70.BANINST1.SB_GMWGMWGCURRICSTATUS Rely on ()
F_QUERY_ONE Package function S4B70.BANINST1.SB_LEARNERCURRICSTATUS Use(select )
F_QUERY_ONE Package function S4B70.BANINST1.SB_CURRICSTATUS Rely on ()
F_QUERY_ONE Package function S4B70.BANINST1.SB_CURRICSTATUS Use(select )
F_QUERY_ONE Package function S4B70.BANINST1.SB_LEARNERCURRICSTATUS Rely on ()
F_QUERY_ONE Package function S4B70.BANINST1.SB_GMWGMWCURRICSTATUS Rely on ()
F_QUERY_ONE Package function S4B70.BANINST1.SB_GMWCURRICSTATUS Rely on ()
F_QUERY_ONE_LOCK Package function S4B70.BANINST1.SB_GMWGMWGCURRICSTATUS Rely on ()
F_QUERY_ONE_LOCK Package function S4B70.BANINST1.SB_LEARNERCURRICSTATUS Rely on ()
F_QUERY_ONE_LOCK Package function S4B70.BANINST1.SB_GMWGMWCURRICSTATUS Rely on ()
F_QUERY_ONE_LOCK Package function S4B70.BANINST1.SB_CURRICSTATUS Rely on ()
F_QUERY_ONE_LOCK Package function S4B70.BANINST1.SB_LEARNERCURRICSTATUS Use(select )
F_QUERY_ONE_LOCK Package function S4B70.BANINST1.SB_CURRICSTATUS Use(select )
F_QUERY_ONE_LOCK Package function S4B70.BANINST1.SB_GMWCURRICSTATUS Rely on ()
SOBCACT Forms DataBlock BANNER7_FORMS.SORCACT Rely on () Use(insert,update,delete,select )
SOBCACT Forms DataBlock BANNER7_FORMS_10G.SORCACT Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SOBCACT INDEX S4B70.SATURN Rely on ()
SORLCUR TABLE S4B70.SATURN Join
SORLFOS TABLE S4B70.SATURN Join
STVCACT TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Student curriculum activity status rules table.

Columns Comments for SOBCACT_CACT_CODE (1)

Source Code Comments

CURRICULUM ACTIVITY STATUS CODE: Activity status code for the curriculum.

Columns Comments for SOBCACT_ACTIVE_IND (2)

Source Code Comments

ACTIVE IND: Y/N indicator if the curriculum is active or not.

Columns Comments for SOBCACT_SYS_REQ_IND (3)

Source Code Comments

SYSTEM REQUIRED IND: Y/N indicator if the curriculum active status rule is required.

Columns Comments for SOBCACT_USER_ID (4)

Source Code Comments

USER ID: The most recent user to create or update a record.

Columns Comments for SOBCACT_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: The most recent date a record was created or updated

Table SOBCALD

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

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
selmacro C/C++ Function [F:\BANNER\C\SERCCRC.PC] Use(select )
selmacro2 C/C++ Function [F:\BANNER\C\SERCCRC.PC] Use(select )
SOBCALD SYNONYM S4B70.PUBLIC Rely on ()
CREATE_SOBCALD Forms Trigger BANNER7_FORMS.SOACALD.SOBCALD Use(insert,select )
CREATE_SOBCALD Forms Trigger BANNER7_FORMS_10G.SOACALD.SOBCALD Use(insert,select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SOACALD.SOBCALD Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SOACALD.SOBCALD Use(select )
SELECT_SOBCALD_1 Forms Function BANNER7_FORMS.SOACALD Use(select )
SELECT_SOBCALD_1 Forms Function BANNER7_FORMS_10G.SOACALD Use(select )
SOBCALD Forms DataBlock BANNER7_FORMS.SOACALD Rely on () Use(insert,update,delete,select )
SOBCALD Forms DataBlock BANNER7_FORMS_10G.SOACALD Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SOBCALD INDEX S4B70.SATURN Rely on ()
STVATRA TABLE S4B70.SATURN Refer( No Action )
STVATRB TABLE S4B70.SATURN Refer( No Action )
STVATRC TABLE S4B70.SATURN Refer( No Action )
STVATRD TABLE S4B70.SATURN Refer( No Action )
STVATRE TABLE S4B70.SATURN Refer( No Action )
STVCAMP TABLE S4B70.SATURN Refer( No Action )
STVDAYT TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

College Calendar Day Information Table

Columns Comments for SOBCALD_YEAR (1)

Source Code Comments

Calendar Year Code

Columns Comments for SOBCALD_CAMP_CODE (2)

Source Code Comments

Campus Code

Columns Comments for SOBCALD_DATE (3)

Source Code Comments

Calendar Date

Columns Comments for SOBCALD_ACTIVITY_DATE (4)

Source Code Comments

The Activity Date

Columns Comments for SOBCALD_DAYT_CODE (5)

Source Code Comments

Day Type Code

Columns Comments for SOBCALD_ATRA_CODE (6)

Source Code Comments

Day Attribute One Code.

Columns Comments for SOBCALD_ATRB_CODE (7)

Source Code Comments

Day Attribute Two Code.

Columns Comments for SOBCALD_ATRC_CODE (8)

Source Code Comments

Day Attribute Three Code.

Columns Comments for SOBCALD_ATRD_CODE (9)

Source Code Comments

Day Attribute Four Code.

Columns Comments for SOBCALD_ATRE_CODE (10)

Source Code Comments

Day Attribute Five Code.

Table SOBCNVT

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

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
convert_check_gpa C/C++ Function [F:\BANNER\C\SRTLOAD.PC] Use(select )
find_default C/C++ Function [F:\BANNER\C\SRTLOAD.PC] Use(select )
find_sobcnvt C/C++ Function [F:\BANNER\C\SRTLOAD.PC] Use(select )
SOBCNVT SYNONYM S4B70.PUBLIC Rely on ()
SOBCNVT_RG Forms Record Group BANNER7_FORMS.SOTCNVT Use(select )
SOBCNVT_RG Forms Record Group BANNER7_FORMS_10G.SOTCNVT Use(select )
SOTCNVT Forms DataBlock BANNER7_FORMS.SOTCNVT Rely on () Use(insert,update,delete,select )
SOTCNVT Forms DataBlock BANNER7_FORMS_10G.SOTCNVT Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SOBCNVT INDEX S4B70.SATURN Rely on ()
SOBCNVT_KEY_INDEX1 INDEX S4B70.SATURN Rely on ()
STVINFC TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Tape Code Conversion Base Table

Columns Comments for SOBCNVT_INFC_CODE (1)

Source Code Comments

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

Columns Comments for SOBCNVT_TNAME (2)

Source Code Comments

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

Columns Comments for SOBCNVT_TAPE_CODE (3)

Source Code Comments

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

Columns Comments for SOBCNVT_CONV_CODE (4)

Source Code Comments

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

Columns Comments for SOBCNVT_ACTIVITY_DATE (5)

Source Code Comments

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

Table SOBCPLN

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

Table Columns information

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

Foreign Key information

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

Index

Index Name Index Type Column Name
SOBCPLN_KEY_INDEX SOBCPLN_PIDM
SOBCPLN_KEY_INDEX SOBCPLN_TYPE_IND

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
check_plan C/C++ Function [F:\BANNER\C\SHRTYPE.PC] Use(select )
delcomm C/C++ Function [F:\BANNER\C\SRRINQR.PC] Use(delete )
delcpln C/C++ Function [F:\BANNER\C\SGPSTDN.PC] Use(delete )
delcpln C/C++ Function [F:\BANNER\C\SAPADMS.PC] Use(delete )
delete_a_student_plan C/C++ Function [F:\BANNER\C\SORCPLN.PC] Use(delete )
delete_admissions_plans C/C++ Function [F:\BANNER\C\SORCPLN.PC] Use(delete )
delete_recr_admt_plan C/C++ Function [F:\BANNER\C\SORCPLN.PC] Use(delete )
delete_recruiting_plans C/C++ Function [F:\BANNER\C\SORCPLN.PC] Use(delete )
find_old_plan C/C++ Function [F:\BANNER\C\SORCPLN.PC] Use(select )
inactivate_a_student_plan C/C++ Function [F:\BANNER\C\SORCPLN.PC] Use(update )
inactivate_admissions_plans C/C++ Function [F:\BANNER\C\SORCPLN.PC] Use(update )
inactivate_recr_admt_plan C/C++ Function [F:\BANNER\C\SORCPLN.PC] Use(update )
inactivate_recruiting_plans C/C++ Function [F:\BANNER\C\SORCPLN.PC] Use(update )
insert_sobcpln C/C++ Function [F:\BANNER\C\SORCPLN.PC] Use(insert,select )
lock_sobcpln C/C++ Function [F:\BANNER\C\SORCPLN.PC] Use()
SOBCPLN SYNONYM S4B70.PUBLIC Rely on ()
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS.SAAACKL Use(insert,select )
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS.SAAQUIK Use(insert,select )
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS.SGASTDN Use(insert,select )
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS.SAAADMS Use(insert,select )
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS.SAADCRV Use(insert,select )
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS_10G.SRARECR Use(insert,select )
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS_10G.SRAQUIK Use(insert,select )
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS_10G.SOACCOL Use(insert,select )
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS_10G.SGASTDN Use(insert,select )
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS_10G.SAAQUIK Use(insert,select )
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS_10G.SOQOLIB Use(insert,select )
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS_10G.SAAACKL Use(insert,select )
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS_10G.SAAADMS Use(insert,select )
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS_10G.SAADCRV Use(insert,select )
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS.SRARECR Use(insert,select )
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS.SRAQUIK Use(insert,select )
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS.SOACCOL Use(insert,select )
INSERT_NEW_COMM_PLAN Forms Trigger BANNER7_FORMS.SOQOLIB Use(insert,select )
TEST_COMM_PROCESS Forms Trigger BANNER7_FORMS.SAAACKL Use(select )
TEST_COMM_PROCESS Forms Trigger BANNER7_FORMS.SAAQUIK Use(select )
TEST_COMM_PROCESS Forms Trigger BANNER7_FORMS.SGASTDN Use(select )
TEST_COMM_PROCESS Forms Trigger BANNER7_FORMS.SAAADMS Use(select )
TEST_COMM_PROCESS Forms Trigger BANNER7_FORMS.SAADCRV Use(select )
TEST_COMM_PROCESS Forms Trigger BANNER7_FORMS_10G.SRARECR Use(select )
TEST_COMM_PROCESS Forms Trigger BANNER7_FORMS_10G.SRAQUIK Use(select )
TEST_COMM_PROCESS Forms Trigger BANNER7_FORMS_10G.SOACCOL Use(select )
TEST_COMM_PROCESS Forms Trigger BANNER7_FORMS_10G.SGASTDN Use(select )
TEST_COMM_PROCESS Forms Trigger BANNER7_FORMS_10G.SAAQUIK Use(select )
TEST_COMM_PROCESS Forms Trigger BANNER7_FORMS_10G.SOQO