Model SGRCOOP

Model Label : Banner SGRCOOP ERD

List of Objects

Object Name	Object Type	Layer Name
SGRCOOP	TABLE	Tables
SGRDUTY	TABLE	ERD
STVCOPC	TABLE	ERD
STVEMPL	TABLE	ERD
STVLEVL	TABLE	ERD
STVTERM	TABLE	ERD

Comments

Model View

Table SGRCOOP

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SGRCOOP_PIDM	SGRCOOP_PIDM	NUMBER(8,0)	No	*
SGRCOOP_TERM_CODE	SGRCOOP_TERM_CODE	VARCHAR2(6)	No	*	*
SGRCOOP_LEVL_CODE	SGRCOOP_LEVL_CODE	VARCHAR2(2)	No	*	*
SGRCOOP_EMPL_CODE	SGRCOOP_EMPL_CODE	VARCHAR2(4)	Yes		*
SGRCOOP_COPC_CODE	SGRCOOP_COPC_CODE	VARCHAR2(6)	Yes		*
SGRCOOP_END_DATE	SGRCOOP_END_DATE	DATE	Yes
SGRCOOP_BEGIN_DATE	SGRCOOP_BEGIN_DATE	DATE	Yes
SGRCOOP_INTEREST_IND	SGRCOOP_INTEREST_IND	VARCHAR2(1)	Yes
SGRCOOP_EMPL_CONTACT_NAME	SGRCOOP_EMPL_CONTACT_NAME	VARCHAR2(30)	Yes
SGRCOOP_EMPL_CONTACT_TITLE	SGRCOOP_EMPL_CONTACT_TITLE	VARCHAR2(30)	Yes
SGRCOOP_ACTIVITY_DATE	SGRCOOP_ACTIVITY_DATE	DATE	No
SGRCOOP_PHONE_AREA	SGRCOOP_PHONE_AREA	VARCHAR2(3)	Yes
SGRCOOP_PHONE_NUMBER	SGRCOOP_PHONE_NUMBER	VARCHAR2(7)	Yes
SGRCOOP_PHONE_EXT	SGRCOOP_PHONE_EXT	VARCHAR2(4)	Yes
SGRCOOP_SEQ_NO	SGRCOOP_SEQ_NO	NUMBER(4,0)	No	*
SGRCOOP_CRN	SGRCOOP_CRN	VARCHAR2(5)	Yes
SGRCOOP_EVAL_PREPARED_DATE	SGRCOOP_EVAL_PREPARED_DATE	DATE	Yes
SGRCOOP_EVAL_RECEIVED_DATE	SGRCOOP_EVAL_RECEIVED_DATE	DATE	Yes
SGRCOOP_OVERRIDE_IND	SGRCOOP_OVERRIDE_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SGRCOOP_LEVL_CODE	STVLEVL_CODE	STVLEVL
SGRCOOP_TERM_CODE	STVTERM_CODE	STVTERM
SGRCOOP_EMPL_CODE	STVEMPL_CODE	STVEMPL
SGRCOOP_COPC_CODE	STVCOPC_CODE	STVCOPC

Index

Index Name	Index Type	Column Name
PK_SGRCOOP	Unique	SGRCOOP_PIDM
PK_SGRCOOP	Unique	SGRCOOP_TERM_CODE
PK_SGRCOOP	Unique	SGRCOOP_LEVL_CODE
PK_SGRCOOP	Unique	SGRCOOP_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
delcoed	C/C++ Function	[F:\BANNER\C\SGPCOOP.PC]	Use(delete )
delcoop	C/C++ Function	[F:\BANNER\C\SGPSTDN.PC]	Use(delete )
selcoop	C/C++ Function	[F:\BANNER\C\APPSTDI.PC]	Use(select )
selcoop	C/C++ Function	[F:\BANNER\C\SGPSTDN.PC]	Use(select )
selcoop1	C/C++ Function	[F:\BANNER\C\SGPSTDN.PC]	Use(select )
seldel	C/C++ Function	[F:\BANNER\C\SGPCOOP.PC]	Use(select )
SGRCOOP	SYNONYM	S4B70.PUBLIC	Rely on ()
SGRDUTY	TABLE	S4B70.SATURN	Refer( No Action )
OPTM_SGACOOP	Forms Trigger	BANNER7_FORMS.SHATCKC	Use(select )
OPTM_SGACOOP	Forms Trigger	BANNER7_FORMS.SHATCKS	Use(select )
OPTM_SGACOOP	Forms Trigger	BANNER7_FORMS_10G.SHATCKN	Use(select )
OPTM_SGACOOP	Forms Trigger	BANNER7_FORMS.SHATCKP	Use(select )
OPTM_SGACOOP	Forms Trigger	BANNER7_FORMS.SFAREGQ	Use(select )
OPTM_SGACOOP	Forms Trigger	BANNER7_FORMS_10G.SHATCKS	Use(select )
OPTM_SGACOOP	Forms Trigger	BANNER7_FORMS_10G.SHATCKP	Use(select )
OPTM_SGACOOP	Forms Trigger	BANNER7_FORMS_10G.SFAREGQ	Use(select )
OPTM_SGACOOP	Forms Trigger	BANNER7_FORMS_10G.SHATCKC	Use(select )
CHECK_COOP_COUNT	Forms Trigger	BANNER7_FORMS_10G.SGACOOP.SGRCOOP	Use(select )
CHECK_COOP_COUNT	Forms Trigger	BANNER7_FORMS.SGACOOP.SGRCOOP	Use(select )
GET_MAX_SEQ_NO	Forms Trigger	BANNER7_FORMS_10G.SGACOOP.SGRCOOP	Use(select )
GET_MAX_SEQ_NO	Forms Trigger	BANNER7_FORMS.SGACOOP.SGRCOOP	Use(select )
KEY_DELREC	Forms Trigger	BANNER7_FORMS_10G.SGASTDN.SGBSTDN	Use(select )
KEY_DELREC	Forms Trigger	BANNER7_FORMS.SGASTDN.SGBSTDN	Use(select )
WHEN-NEW-RECORD-INSTANCE	Forms Trigger	BANNER7_FORMS.SHATCKC.SHRTCKN	Use(select )
WHEN-NEW-RECORD-INSTANCE	Forms Trigger	BANNER7_FORMS.SHATCKS.SHRTCKN	Use(select )
WHEN-NEW-RECORD-INSTANCE	Forms Trigger	BANNER7_FORMS.SFAREGQ.SFVSTMS	Use(select )
WHEN-NEW-RECORD-INSTANCE	Forms Trigger	BANNER7_FORMS_10G.SHATCKS.SHRTCKN	Use(select )
WHEN-NEW-RECORD-INSTANCE	Forms Trigger	BANNER7_FORMS_10G.SHATCKP.SHRTCKN	Use(select )
WHEN-NEW-RECORD-INSTANCE	Forms Trigger	BANNER7_FORMS_10G.SFAREGQ.SFVSTMS	Use(select )
WHEN-NEW-RECORD-INSTANCE	Forms Trigger	BANNER7_FORMS_10G.SHATCKC.SHRTCKN	Use(select )
WHEN-NEW-RECORD-INSTANCE	Forms Trigger	BANNER7_FORMS_10G.SHATCKN.SHRTCKN	Use(select )
WHEN-NEW-RECORD-INSTANCE	Forms Trigger	BANNER7_FORMS.SHATCKP.SHRTCKN	Use(select )
SELECT_SGRCOOP_1	Forms Function	BANNER7_FORMS_10G.SGACOOP	Use(select )
SELECT_SGRCOOP_1	Forms Function	BANNER7_FORMS.SGACOOP	Use(select )
P_GET_STUDENT_COURSE	Package procedure	S4B70.BANINST1.SHKROLS	Use(select )
COOPS	Forms DataBlock	BANNER7_FORMS_10G.SGACOOP	Rely on () Use(insert,update,delete,select )
COOPS	Forms DataBlock	BANNER7_FORMS.SGACOOP	Rely on () Use(insert,update,delete,select )
SGRCOOP	Forms DataBlock	BANNER7_FORMS_10G.SGACOOP	Rely on () Use(insert,update,delete,select )
SGRCOOP	Forms DataBlock	BANNER7_FORMS.SGACOOP	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SGRCOOP	INDEX	S4B70.SATURN	Rely on ()
STVCOPC	TABLE	S4B70.SATURN	Refer( No Action )
STVEMPL	TABLE	S4B70.SATURN	Refer( No Action )
STVLEVL	TABLE	S4B70.SATURN	Refer( No Action )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Cooperative Education Repeating Table

Columns Comments for SGRCOOP_PIDM (1)

Source Code Comments

This field identifies the student internal identification number.

Columns Comments for SGRCOOP_TERM_CODE (2)

Source Code Comments

This field identifies the effective term to create or display information.

Columns Comments for SGRCOOP_LEVL_CODE (3)

Source Code Comments

This field identifies the level of the student for which the record is being created or displayed.

Columns Comments for SGRCOOP_EMPL_CODE (4)

Source Code Comments

This field identifies the cooperative education employer.

Columns Comments for SGRCOOP_COPC_CODE (5)

Source Code Comments

This field identifies the type of cooperative education experience.

Columns Comments for SGRCOOP_END_DATE (6)

Source Code Comments

This field identifies the effective end date of the cooperative education experience.

Columns Comments for SGRCOOP_BEGIN_DATE (7)

Source Code Comments

This field identifies the effective start date of the cooperative education experience.

Columns Comments for SGRCOOP_INTEREST_IND (8)

Source Code Comments

This field indicates if the cooperative education experience is a field of interest to the student. Value is Y or blank only.

Columns Comments for SGRCOOP_EMPL_CONTACT_NAME (9)

Source Code Comments

This field identifies the contact person of the cooperative education employer.

Columns Comments for SGRCOOP_EMPL_CONTACT_TITLE (10)

Source Code Comments

This field identifies the title of the contact person of the cooperative education employer.

Columns Comments for SGRCOOP_ACTIVITY_DATE (11)

Source Code Comments

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

Columns Comments for SGRCOOP_PHONE_AREA (12)

Source Code Comments

This field maintains the telephone area code of the employer contact.

Columns Comments for SGRCOOP_PHONE_NUMBER (13)

Source Code Comments

This field maintains the telephone exchange and number of the employer contact.

Columns Comments for SGRCOOP_PHONE_EXT (14)

Source Code Comments

This field maintains the telephone extension of the employer contact.

Columns Comments for SGRCOOP_SEQ_NO (15)

Source Code Comments

The Coop Assignment Sequence Number.

Columns Comments for SGRCOOP_CRN (16)

Source Code Comments

The Coop Assignment CRN.

Columns Comments for SGRCOOP_EVAL_PREPARED_DATE (17)

Source Code Comments

The Coop Assignment Evaluation Prepared Date.

Columns Comments for SGRCOOP_EVAL_RECEIVED_DATE (18)

Source Code Comments

The Coop Assignment Evaluation Received Date.

Columns Comments for SGRCOOP_OVERRIDE_IND (19)

Source Code Comments

The Coop Assignment Override Indicator.

Table SGRDUTY

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SGRDUTY_PIDM	SGRDUTY_PIDM	NUMBER(8,0)	No	*	*
SGRDUTY_LEVL_CODE	SGRDUTY_LEVL_CODE	VARCHAR2(2)	No	*	*
SGRDUTY_TERM_CODE	SGRDUTY_TERM_CODE	VARCHAR2(6)	No	*	*
SGRDUTY_EMPL_CODE	SGRDUTY_EMPL_CODE	VARCHAR2(4)	No	*	*
SGRDUTY_SEQ_NO	SGRDUTY_SEQ_NO	NUMBER(4,0)	No	*
SGRDUTY_DESC	SGRDUTY_DESC	VARCHAR2(60)	Yes
SGRDUTY_ACTIVITY_DATE	SGRDUTY_ACTIVITY_DATE	DATE	No
SGRDUTY_COOP_SEQ_NO	SGRDUTY_COOP_SEQ_NO	NUMBER(4,0)	No	*	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SGRDUTY_LEVL_CODE	STVLEVL_CODE	STVLEVL
SGRDUTY_TERM_CODE	STVTERM_CODE	STVTERM
SGRDUTY_PIDM	SGRCOOP_PIDM	SGRCOOP
SGRDUTY_TERM_CODE	SGRCOOP_TERM_CODE	SGRCOOP
SGRDUTY_LEVL_CODE	SGRCOOP_LEVL_CODE	SGRCOOP
SGRDUTY_COOP_SEQ_NO	SGRCOOP_SEQ_NO	SGRCOOP
SGRDUTY_EMPL_CODE	STVEMPL_CODE	STVEMPL

Index

Index Name	Index Type	Column Name
PK_SGRDUTY	Unique	SGRDUTY_PIDM
PK_SGRDUTY	Unique	SGRDUTY_TERM_CODE
PK_SGRDUTY	Unique	SGRDUTY_LEVL_CODE
PK_SGRDUTY	Unique	SGRDUTY_COOP_SEQ_NO
PK_SGRDUTY	Unique	SGRDUTY_EMPL_CODE
PK_SGRDUTY	Unique	SGRDUTY_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
delduty	C/C++ Function	[F:\BANNER\C\SGPSTDN.PC]	Use(delete )
delduty	C/C++ Function	[F:\BANNER\C\SGPCOOP.PC]	Use(delete )
seldut	C/C++ Function	[F:\BANNER\C\SGPCOOP.PC]	Use(select )
seldut	C/C++ Function	[F:\BANNER\C\SGPSTDN.PC]	Use(select )
SGRDUTY	SYNONYM	S4B70.PUBLIC	Rely on ()
PRE-DELETE	Forms Trigger	BANNER7_FORMS_10G.SGACOOP.SGRCOOP	Use(delete,select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS.SGACOOP.SGRCOOP	Use(delete,select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.SGACOOP.SGRDUTY	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.SGACOOP.SGRDUTY	Use(select )
SGRDUTY	Forms DataBlock	BANNER7_FORMS_10G.SGACOOP	Rely on () Use(insert,update,delete,select )
SGRDUTY	Forms DataBlock	BANNER7_FORMS.SGACOOP	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SGRDUTY	INDEX	S4B70.SATURN	Rely on ()
SGRCOOP	TABLE	S4B70.SATURN	Refer( No Action )
STVEMPL	TABLE	S4B70.SATURN	Refer( No Action )
STVLEVL	TABLE	S4B70.SATURN	Refer( No Action )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Cooperative Education Duties Repeating Table

Columns Comments for SGRDUTY_PIDM (1)

Source Code Comments

This field identifies the student internal identification number.

Columns Comments for SGRDUTY_LEVL_CODE (2)

Source Code Comments

This field identifies the level of the student for which the cooperative education duties are being created.

Columns Comments for SGRDUTY_TERM_CODE (3)

Source Code Comments

This field identifies the effective term for which the cooperative education duties are being created.

Columns Comments for SGRDUTY_EMPL_CODE (4)

Source Code Comments

This field identifies the cooperative education employer.

Columns Comments for SGRDUTY_SEQ_NO (5)

Source Code Comments

This field assigns an internal sequence number associated with each cooperative education duties being created.

Columns Comments for SGRDUTY_DESC (6)

Source Code Comments

This field identifies the description of the cooperative education duties being created.

Columns Comments for SGRDUTY_ACTIVITY_DATE (7)

Source Code Comments

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

Columns Comments for SGRDUTY_COOP_SEQ_NO (8)

Source Code Comments

The Coop Assignment Sequence N
umber. This SGRDUTY_COOP_SEQ_NO corresponds to the SGRCOOP_SEQ_NO.

Table STVCOPC

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVCOPC_CODE	STVCOPC_CODE	VARCHAR2(6)	No	*
STVCOPC_DESC	STVCOPC_DESC	VARCHAR2(30)	Yes
STVCOPC_ACTIVITY_DATE	STVCOPC_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVCOPC	Unique	STVCOPC_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
STVCOPC	SYNONYM	S4B70.PUBLIC	Rely on ()
SGRCOOP	TABLE	S4B70.SATURN	Refer( No Action )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SGACOOP.SGRCOOP.SGRCOOP_COPC_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SGACOOP.SGRCOOP.SGRCOOP_COPC_CODE	Use(select )
STVCOPC_RG	Forms Record Group	BANNER7_FORMS.SOQOLIB	Use(select )
STVCOPC_RG	Forms Record Group	BANNER7_FORMS.SGACOOP	Use(select )
STVCOPC_RG	Forms Record Group	BANNER7_FORMS_10G.SOQOLIB	Use(select )
STVCOPC_RG	Forms Record Group	BANNER7_FORMS_10G.SGACOOP	Use(select )
ON-UPDATE	Forms Trigger	BANNER7_FORMS_10G.STVCOPC.STVCOPC	Use(update )
ON-UPDATE	Forms Trigger	BANNER7_FORMS.STVCOPC.STVCOPC	Use(update )
STVCOPCC	Package cursor	S4B70.BANINST1.STKCOPC	Rely on () Use(select )
STVCOPC	Forms DataBlock	BANNER7_FORMS_10G.STVCOPC	Rely on () Use(insert,update,delete,select )
STVCOPC	Forms DataBlock	BANNER7_FORMS.STVCOPC	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_STVCOPC	INDEX	S4B70.SATURN	Rely on ()

Comments

Source Code Comments

Cooperative Education Code Validation Table.

Columns Comments for STVCOPC_CODE (1)

Source Code Comments

Cooperative education code.

Columns Comments for STVCOPC_DESC (2)

Source Code Comments

Cooperative education code description.

Columns Comments for STVCOPC_ACTIVITY_DATE (3)

Source Code Comments

The Activity date.

Table STVEMPL

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
STVEMPL_CODE	STVEMPL_CODE	VARCHAR2(4)	No	*
STVEMPL_DESC	STVEMPL_DESC	VARCHAR2(30)	Yes
STVEMPL_STREET_LINE1	STVEMPL_STREET_LINE1	VARCHAR2(30)	Yes
STVEMPL_STREET_LINE2	STVEMPL_STREET_LINE2	VARCHAR2(30)	Yes
STVEMPL_STREET_LINE3	STVEMPL_STREET_LINE3	VARCHAR2(30)	Yes
STVEMPL_CITY	STVEMPL_CITY	VARCHAR2(20)	Yes
STVEMPL_STAT_CODE	STVEMPL_STAT_CODE	VARCHAR2(3)	Yes		*
STVEMPL_ZIP	STVEMPL_ZIP	VARCHAR2(10)	Yes
STVEMPL_NATN_CODE	STVEMPL_NATN_CODE	VARCHAR2(5)	Yes		*
STVEMPL_PHONE_AREA	STVEMPL_PHONE_AREA	VARCHAR2(3)	Yes
STVEMPL_PHONE_NUMBER	STVEMPL_PHONE_NUMBER	VARCHAR2(7)	Yes
STVEMPL_PHONE_EXT	STVEMPL_PHONE_EXT	VARCHAR2(4)	Yes
STVEMPL_ACTIVITY_DATE	STVEMPL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
STVEMPL_STAT_CODE	STVSTAT_CODE	STVSTAT
STVEMPL_NATN_CODE	STVNATN_CODE	STVNATN

Index

Index Name	Index Type	Column Name
PK_STVEMPL	Unique	STVEMPL_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
selcoop	C/C++ Function	[F:\BANNER\C\APPSTDI.PC]	Use(select )
STVEMPL	SYNONYM	S4B70.PUBLIC	Rely on ()
SFRENRL	TABLE	S4B70.SATURN	Refer( No Action )
SGRCOOP	TABLE	S4B70.SATURN	Refer( No Action )
SGRDUTY	TABLE	S4B70.SATURN	Refer( No Action )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SGACOOP.SGRCOOP.SGRCOOP_EMPL_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SGACOOP.SGRCOOP.SGRCOOP_EMPL_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SGACOOP.SGRDUTY_CTRL.SGRCOOP_EMPL_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SGACOOP.SGRDUTY_CTRL.SGRCOOP_EMPL_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.SFARQST.SFRENRL.SFRENRL_EMPL_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.SFARQST.SFRENRL.SFRENRL_EMPL_CODE	Use(select )
STVEMPL_RG	Forms Record Group	BANNER7_FORMS.SOQOLIB	Use(select )
STVEMPL_RG	Forms Record Group	BANNER7_FORMS_10G.SFARQST	Use(select )
STVEMPL_RG	Forms Record Group	BANNER7_FORMS_10G.SGACOOP	Use(select )
STVEMPL_RG	Forms Record Group	BANNER7_FORMS.SGACOOP	Use(select )
STVEMPL_RG	Forms Record Group	BANNER7_FORMS_10G.SOQOLIB	Use(select )
STVEMPL_RG	Forms Record Group	BANNER7_FORMS.SFARQST	Use(select )
KEY-DUPREC	Forms Trigger	BANNER7_FORMS_10G.SFARQST.SFRENRL	Use(select )
KEY-DUPREC	Forms Trigger	BANNER7_FORMS.SFARQST.SFRENRL	Use(select )
ON-UPDATE	Forms Trigger	BANNER7_FORMS.STVEMPL.STVEMPL	Use(update )
ON-UPDATE	Forms Trigger	BANNER7_FORMS_10G.STVEMPL.STVEMPL	Use(update )
STVEMPLC	Package cursor	S4B70.BANINST1.STKEMPL	Rely on () Use(select )
STVEMPL	Forms DataBlock	BANNER7_FORMS.STVEMPL	Rely on () Use(insert,update,delete,select )
STVEMPL	Forms DataBlock	BANNER7_FORMS_10G.STVEMPL	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_STVEMPL	INDEX	S4B70.SATURN	Rely on ()
STVNATN	TABLE	S4B70.SATURN	Refer( No Action )
STVSTAT	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Employer Validation Table

Columns Comments for STVEMPL_CODE (1)

Source Code Comments

This field identifies the employer code referenced on the Cooperative Education Form (SGACOOP).

Columns Comments for STVEMPL_DESC (2)

Source Code Comments

This field specifies the name of employer associated with the employer code.

Columns Comments for STVEMPL_STREET_LINE1 (3)

Source Code Comments

This field maintains line one of the employer street address.

Columns Comments for STVEMPL_STREET_LINE2 (4)

Source Code Comments

This field maintains line two of the employer street address.

Columns Comments for STVEMPL_STREET_LINE3 (5)

Source Code Comments

This field maintains line three of the employer street address.

Columns Comments for STVEMPL_CITY (6)

Source Code Comments

This field identifies the city/town in which the employer is located.

Columns Comments for STVEMPL_STAT_CODE (7)

Source Code Comments

This field identifies the abbreviation for the state in which the employer is located.

Columns Comments for STVEMPL_ZIP (8)

Source Code Comments

This field identifies the zip code/postal code of the employer.

Columns Comments for STVEMPL_NATN_CODE (9)

Source Code Comments

This field identifies the nation/country in which the employer is located.

Columns Comments for STVEMPL_PHONE_AREA (10)

Source Code Comments

This field maintains the telephone area code of the employer.

Columns Comments for STVEMPL_PHONE_NUMBER (11)

Source Code Comments

This field maintains the telephone exchange and number of the employer.

Columns Comments for STVEMPL_PHONE_EXT (12)

Source Code Comments

This field maintains the telephone extension of the employer.

Columns Comments for STVEMPL_ACTIVITY_DATE (13)

Source Code Comments

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

Table STVLEVL

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
STVLEVL_CODE	STVLEVL_CODE	VARCHAR2(2)	No	*	*
STVLEVL_DESC	STVLEVL_DESC	VARCHAR2(30)	No
STVLEVL_ACTIVITY_DATE	STVLEVL_ACTIVITY_DATE	DATE	No
STVLEVL_ACAD_IND	STVLEVL_ACAD_IND	VARCHAR2(1)	Yes
STVLEVL_CEU_IND	STVLEVL_CEU_IND	VARCHAR2(1)	No
STVLEVL_SYSTEM_REQ_IND	STVLEVL_SYSTEM_REQ_IND	VARCHAR2(1)	Yes
STVLEVL_VR_MSG_NO	STVLEVL_VR_MSG_NO	NUMBER(6,0)	Yes
STVLEVL_EDI_EQUIV	STVLEVL_EDI_EQUIV	VARCHAR2(2)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
STVLEVL_CODE	SFTREGS_LEVL_CODE	SFTREGS

Index

Index Name	Index Type	Column Name
PK_STVLEVL	Unique	STVLEVL_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ins_levl_code	C/C++ Function	[F:\BANNER\C\TSP1098.PC]	Use(select )
ins_levl_code_jsub	C/C++ Function	[F:\BANNER\C\TSP1098.PC]	Use(select )
select_ceu_level_code	C/C++ Function	[F:\BANNER\C\SHREDIY.PC]	Use(select )
select_edi_levl_code	C/C++ Function	[F:\BANNER\C\SHREDIY.PC]	Use(select )
val_levl_code	C/C++ Function	[F:\BANNER\C\SARDCBT.PC]	Use(select )
check_grad_levl	C/C++ Function	[F:\BANNER\C\SFRNSLC.PC]	Use(select )
check_uglevl	C/C++ Function	[F:\BANNER\C\SHRIGRS.PC]	Use(select )
find_registration	C/C++ Function	[F:\BANNER\C\SGRKNOW.PC]	Use(select )
get_header_info	C/C++ Function	[F:\BANNER\C\SMRCRLT.PC]	Use(select )
get_header_info2	C/C++ Function	[F:\BANNER\C\SMRCRLT.PC]	Use(select )
get_levldesc	C/C++ Function	[F:\BANNER\C\SHRIACT.PC]	Use(select )
get_levldesc3	C/C++ Function	[F:\BANNER\C\SHRIACT.PC]	Use(select )
get_persister	C/C++ Function	[F:\BANNER\C\SHRIGRS.PC]	Use(select )
get_student_levels	C/C++ Function	[F:\BANNER\C\ISRKGRD.PC]	Use(select )
getlevl	C/C++ Function	[F:\BANNER\C\SHRTAEQ.PC]	Use(select )
getlevl_desc	C/C++ Function	[F:\BANNER\C\SHRTAEQ.PC]	Use(select )
gettmst	C/C++ Function	[F:\BANNER\C\SFRTMST.PC]	Use(select )
lvldesc	C/C++ Function	[F:\BANNER\C\ISRKTRN.PC]	Use(select )
lvldesc	C/C++ Function	[F:\BANNER\C\SHRTRTC.PC]	Use(select )
sel_level_desc	C/C++ Function	[F:\BANNER\C\ISRKGRD.PC]	Use(select )
sel_levl_desc	C/C++ Function	[F:\BANNER\C\SHRGRDE.PC]	Use(select )
sel_lgpa_i	C/C++ Function	[F:\BANNER\C\SHRASTD.PC]	Use(select )
sel_lgpa_o	C/C++ Function	[F:\BANNER\C\SHRASTD.PC]	Use(select )
sel_tgpa_i	C/C++ Function	[F:\BANNER\C\SHRASTD.PC]	Use(select )
sel_tgpa_t	C/C++ Function	[F:\BANNER\C\SHRASTD.PC]	Use(select )
selhour	C/C++ Function	[F:\BANNER\C\SFRENRL.PC]	Use(select )
selhour2	C/C++ Function	[F:\BANNER\C\SFRENRL.PC]	Use(select )
sellevl	C/C++ Function	[F:\BANNER\C\ISRKADM.PC]	Use(select )
sellevl	C/C++ Function	[F:\BANNER\C\SGRVETN.PC]	Use(select )
sellevl	C/C++ Function	[F:\BANNER\C\SGRSTDN.PC]	Use(select )
sellevl	C/C++ Function	[F:\BANNER\C\SFRWDRL.PC]	Use(select )
sellevl	C/C++ Function	[F:\BANNER\C\SARADMS.PC]	Use(select )
sellevlr	C/C++ Function	[F:\BANNER\C\SCRBULT.PC]	Use(select )
seltckl	C/C++ Function	[F:\BANNER\C\SHRGRDE.PC]	Use(select )
test_levl	C/C++ Function	[F:\BANNER\C\SFRNOWD.PC]	Use(select )
title3	C/C++ Function	[F:\BANNER\C\SFRNOWD.PC]	Use(select )
validate	C/C++ Function	[F:\BANNER\C\SFRWDRL.PC]	Use(select )
validate_incl_levl	C/C++ Function	[F:\BANNER\C\SFRSSCR.PC]	Use(select )
validate_levl	C/C++ Function	[F:\BANNER\C\SARAMXF.PC]	Use(select )
validate_levl	C/C++ Function	[F:\BANNER\C\SAPAMAL.PC]	Use(select )
validate_levl	C/C++ Function	[F:\BANNER\C\SARAMDP.PC]	Use(select )
validate_levl	C/C++ Function	[F:\BANNER\C\SFRTMST.PC]	Use(select )
STVLEVL	SYNONYM	S4B70.PUBLIC	Rely on ()
ST_SHRTRCR_INSERT_ROW	TRIGGER	S4B70.SATURN	Use(select )
ST_SHRTRCR_INSERT_ROW	TRIGGER	S4B70.BANINST1	Use(select )
ST_SHRTRCR_UPDATE_ROW	TRIGGER	S4B70.SATURN	Use(select )
ST_SHRTRCR_UPDATE_ROW	TRIGGER	S4B70.BANINST1	Use(select )
ST_SHRTRTK_INSERT_ROW	TRIGGER	S4B70.SATURN	Use(select )
ST_SHRTRTK_INSERT_ROW	TRIGGER	S4B70.BANINST1	Use(select )
ST_SHRTRTK_UPDATE_ROW	TRIGGER	S4B70.SATURN	Use(select )
ST_SHRTRTK_UPDATE_ROW	TRIGGER	S4B70.BANINST1	Use(select )
RORCRHR	TABLE	S4B70.FAISMGR	Refer( No Action )
RPRCLSS	TABLE	S4B70.FAISMGR	Refer( No Action )
SARADAP	TABLE	S4B70.SATURN	Refer( No Action )
SARCHKB	TABLE	S4B70.SATURN	Refer( No Action )
SARDCSN	TABLE	S4B70.SATURN	Refer( No Action )
SARQKER	TABLE	S4B70.SATURN	Refer( No Action )
SARRRFT	TABLE	S4B70.SATURN	Refer( No Action )
SARWAAD	TABLE	S4B70.SATURN	Refer( No Action )
SCRLEVL	TABLE	S4B70.SATURN	Refer( No Action )
SCRRTST	TABLE	S4B70.SATURN	Refer( No Action )
SDBDEGR	TABLE	S4B70.SATURN	Refer( No Action )
SFBCREQ	TABLE	S4B70.SATURN	Refer( No Action )
SFRFREQ	TABLE	S4B70.SATURN	Refer( No Action )
SFRMHRS	TABLE	S4B70.SATURN	Refer( No Action )
SFRRGFE	TABLE	S4B70.SATURN	Refer( No Action )
SFRSTCR	TABLE	S4B70.SATURN	Refer( No Action )
SFRTMSL	TABLE	S4B70.SATURN	Refer( No Action )
SFRTMST	TABLE	S4B70.SATURN	Refer( No Action )
SGBSTDN	TABLE	S4B70.SATURN	Refer( No Action )
SGRASSI	TABLE	S4B70.SATURN	Refer( No Action )
SGRCLSR	TABLE	S4B70.SATURN	Refer( No Action )
SGRCOOP	TABLE	S4B70.SATURN	Refer( No Action )
SGRDUTY	TABLE	S4B70.SATURN	Refer( No Action )
SHBGEDI	TABLE	S4B70.SATURN	Refer( No Action )
SHBGSCH	TABLE	S4B70.SATURN	Refer( No Action )
SHBRPTR	TABLE	S4B70.SATURN	Refer( No Action )
SHRASDL	TABLE	S4B70.SATURN	Refer( No Action )
SHRASGE	TABLE	S4B70.SATURN	Refer( No Action )
SHRASTR	TABLE	S4B70.SATURN	Refer( No Action )
SHRCAST	TABLE	S4B70.SATURN	Refer( No Action )
SHRCGDR	TABLE	S4B70.SATURN	Refer( No Action )
SHRDGMR	TABLE	S4B70.SATURN	Refer( No Action )
SHREGPA	TABLE	S4B70.SATURN	Refer( No Action )
SHREVNT	TABLE	S4B70.SATURN	Refer( No Action )
SHRGPAC	TABLE	S4B70.SATURN	Refer( No Action )
SHRGPAL	TABLE	S4B70.SATURN	Refer( No Action )
SHRGRDE	TABLE	S4B70.SATURN	Refer( No Action )
SHRGRDO	TABLE	S4B70.SATURN	Refer( No Action )
SHRGRDS	TABLE	S4B70.SATURN	Refer( No Action )
SHRIPED	TABLE	S4B70.SATURN	Refer( No Action )
SHRLGDR	TABLE	S4B70.SATURN	Refer( No Action )
SHRLGPA	TABLE	S4B70.SATURN	Refer( No Action )
SHRLGSC	TABLE	S4B70.SATURN	Refer( No Action )
SHRNCRS	TABLE	S4B70.SATURN	Refer( No Action )
SHRPREV	TABLE	S4B70.SATURN	Refer( No Action )
SHRPRGE	TABLE	S4B70.SATURN	Refer( No Action )
SHRRPEQ	TABLE	S4B70.SATURN	Refer( No Action )
SHRTCKL	TABLE	S4B70.SATURN	Refer( No Action )
SHRTGPA	TABLE	S4B70.SATURN	Refer( No Action )
SHRTMCM	TABLE	S4B70.SATURN	Refer( No Action )
SHRTRAM	TABLE	S4B70.SATURN	Refer( No Action )
SHRTRCE	TABLE	S4B70.SATURN	Refer( No Action )
SHRTRTA	TABLE	S4B70.SATURN	Refer( No Action )
SHRTRTK	TABLE	S4B70.SATURN	Refer( No Action )
SHRTTCM	TABLE	S4B70.SATURN	Refer( No Action )
SHTTRTC	TABLE	S4B70.SATURN	Refer( No Action )
SMRACLV	TABLE	S4B70.SATURN	Refer( No Action )
SMRALIB	TABLE	S4B70.SATURN	Refer( No Action )
SMRALVL	TABLE	S4B70.SATURN	Refer( No Action )
SMRARLV	TABLE	S4B70.SATURN	Refer( No Action )
SMRGCLV	TABLE	S4B70.SATURN	Refer( No Action )
SMRGLIB	TABLE	S4B70.SATURN	Refer( No Action )
SMRGLVL	TABLE	S4B70.SATURN	Refer( No Action )
SMRGRLV	TABLE	S4B70.SATURN	Refer( No Action )
SMRPCRS	TABLE	S4B70.SATURN	Refer( No Action )
SMRPLVL	TABLE	S4B70.SATURN	Refer( No Action )
SMRPRLE	TABLE	S4B70.SATURN	Refer( No Action )
SMRRQCM	TABLE	S4B70.SATURN	Refer( No Action )
SMRSACL	TABLE	S4B70.SATURN	Refer( No Action )
SMRSALV	TABLE	S4B70.SATURN	Refer( No Action )
SMRSARL	TABLE