Model Academic History Tables

Model Label : Tables used for Banner Student Academic History

List of Objects

Object Name	Object Type	Layer Name
SHBCATT	TABLE	Tables
SHBCGPA	TABLE	Tables
SHBCOMI	TABLE	Tables
SHBCRMY	TABLE	Tables
SHBDIPL	TABLE	Tables
SHBGCTL	TABLE	Tables
SHBGEDI	TABLE	Tables
SHBGRAD	TABLE	Tables
SHBGRUL	TABLE	Tables
SHBGSCH	TABLE	Tables
SHBHEAD	TABLE	Tables
SHBOGSC	TABLE	Tables
SHBRPTR	TABLE	Tables
SHBRPTS	TABLE	Tables
SHBRTYP	TABLE	Tables
SHBTATC	TABLE	Tables
SHBWTRR	TABLE	Tables
SHRASDL	TABLE	Tables
SHRASES	TABLE	Tables
SHRASGE	TABLE	Tables
SHRASTR	TABLE	Tables
SHRASUM	TABLE	Tables
SHRATTC	TABLE	Tables
SHRATTR	TABLE	Tables
SHRCAPP	TABLE	Tables
SHRCAST	TABLE	Tables
SHRCATT	TABLE	Tables
SHRCCMT	TABLE	Tables
SHRCGDR	TABLE	Tables
SHRCGPA	TABLE	Tables
SHRCHRT	TABLE	Tables
SHRCMRK	TABLE	Tables
SHRCOMC	TABLE	Tables
SHRCOMM	TABLE	Tables
SHRCRSR	TABLE	Tables
SHRDCMT	TABLE	Tables
SHRDGCM	TABLE	Tables
SHRDGDH	TABLE	Tables
SHRDGIH	TABLE	Tables
SHRDGMR	TABLE	Tables
SHRDRTM	TABLE	Tables
SHREDIS	TABLE	Tables
SHREGPA	TABLE	Tables
SHREVNT	TABLE	Tables
SHRGCOL	TABLE	Tables
SHRGCOM	TABLE	Tables
SHRGOWN	TABLE	Tables
SHRGPAC	TABLE	Tables
SHRGPAL	TABLE	Tables
SHRGRDE	TABLE	Tables
SHRGRDO	TABLE	Tables
SHRGRDS	TABLE	Tables
SHRGRSC	TABLE	Tables
SHRGRUL	TABLE	Tables
SHRHDR4	TABLE	Tables
SHRICIP	TABLE	Tables
SHRICMT	TABLE	Tables
SHRIDEN	TABLE	Tables
SHRINST	TABLE	Tables
SHRIPDS	TABLE	Tables
SHRIPED	TABLE	Tables
SHRLGDR	TABLE	Tables
SHRLGPA	TABLE	Tables
SHRLGSC	TABLE	Tables
SHRMRKA	TABLE	Tables
SHRMRKS	TABLE	Tables
SHRNCRD	TABLE	Tables
SHRNCRS	TABLE	Tables
SHROGDR	TABLE	Tables
SHRPREV	TABLE	Tables
SHRPRGE	TABLE	Tables
SHRQPND	TABLE	Tables
SHRQPNM	TABLE	Tables
SHRRDEF	TABLE	Tables
SHRRPAR	TABLE	Tables
SHRRPEQ	TABLE	Tables
SHRSCOM	TABLE	Tables
SHRSMRK	TABLE	Tables
SHRSRKA	TABLE	Tables
SHRSSUM	TABLE	Tables
SHRSUMA	TABLE	Tables
SHRSUMS	TABLE	Tables
SHRTATC	TABLE	Tables
SHRTATT	TABLE	Tables
SHRTCKD	TABLE	Tables
SHRTCKG	TABLE	Tables
SHRTCKL	TABLE	Tables
SHRTCKN	TABLE	Tables
SHRTCMT	TABLE	Tables
SHRTGPA	TABLE	Tables
SHRTGRD	TABLE	Tables
SHRTMCM	TABLE	Tables
SHRTPRT	TABLE	Tables
SHRTRAM	TABLE	Tables
SHRTRAT	TABLE	Tables
SHRTRCD	TABLE	Tables
SHRTRCE	TABLE	Tables
SHRTRCR	TABLE	Tables
SHRTREP	TABLE	Tables
SHRTRIT	TABLE	Tables
SHRTRPO	TABLE	Tables
SHRTRSS	TABLE	Tables
SHRTRTA	TABLE	Tables
SHRTRTK	TABLE	Tables
SHRTTCM	TABLE	Tables
SHRTTRM	TABLE	Tables
SHTIACT	TABLE	Tables
SHTTRAN	TABLE	Tables
SHTTRTC	TABLE	Tables

Comments

Model View

Table SHBCATT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SHBCATT_PIDM	SHBCATT_PIDM	NUMBER(8,0)	No	*
SHBCATT_TERM_CODE	SHBCATT_TERM_CODE	VARCHAR2(6)	No	*	*
SHBCATT_CERT_CODE	SHBCATT_CERT_CODE	VARCHAR2(10)	No	*	*
SHBCATT_MEAS_CODE_HEIGHT	SHBCATT_MEAS_CODE_HEIGHT	VARCHAR2(6)	Yes		*
SHBCATT_HEIGHT	SHBCATT_HEIGHT	NUMBER(6,2)	Yes
SHBCATT_MEAS_CODE_WEIGHT	SHBCATT_MEAS_CODE_WEIGHT	VARCHAR2(6)	Yes		*
SHBCATT_WEIGHT	SHBCATT_WEIGHT	NUMBER(6,2)	Yes
SHBCATT_MEAS_CODE_HEAD	SHBCATT_MEAS_CODE_HEAD	VARCHAR2(6)	Yes		*
SHBCATT_HEAD_SIZE	SHBCATT_HEAD_SIZE	NUMBER(6,2)	Yes
SHBCATT_TYPE_CODE_CAP	SHBCATT_TYPE_CODE_CAP	VARCHAR2(6)	Yes		*
SHBCATT_SIZE_CODE_CAP	SHBCATT_SIZE_CODE_CAP	VARCHAR2(6)	Yes		*
SHBCATT_CAP_DATE_ORDERED	SHBCATT_CAP_DATE_ORDERED	DATE	Yes
SHBCATT_CAP_DATE_PICKUP	SHBCATT_CAP_DATE_PICKUP	DATE	Yes
SHBCATT_CAP_DATE_RETURNED	SHBCATT_CAP_DATE_RETURNED	DATE	Yes
SHBCATT_TYPE_CODE_GOWN	SHBCATT_TYPE_CODE_GOWN	VARCHAR2(6)	Yes		*
SHBCATT_SIZE_CODE_GOWN	SHBCATT_SIZE_CODE_GOWN	VARCHAR2(6)	Yes		*
SHBCATT_GOWN_DATE_ORDERED	SHBCATT_GOWN_DATE_ORDERED	DATE	Yes
SHBCATT_GOWN_DATE_PICKUP	SHBCATT_GOWN_DATE_PICKUP	DATE	Yes
SHBCATT_GOWN_DATE_RETURNED	SHBCATT_GOWN_DATE_RETURNED	DATE	Yes
SHBCATT_TYPE_CODE_HOOD	SHBCATT_TYPE_CODE_HOOD	VARCHAR2(6)	Yes		*
SHBCATT_HOOD_DATE_ORDERED	SHBCATT_HOOD_DATE_ORDERED	DATE	Yes
SHBCATT_HOOD_DATE_PICKUP	SHBCATT_HOOD_DATE_PICKUP	DATE	Yes
SHBCATT_HOOD_DATE_RETURNED	SHBCATT_HOOD_DATE_RETURNED	DATE	Yes
SHBCATT_NO_ANNOUNCEMENTS	SHBCATT_NO_ANNOUNCEMENTS	NUMBER(3,0)	Yes
SHBCATT_NO_TICKETS	SHBCATT_NO_TICKETS	NUMBER(2,0)	Yes
SHBCATT_TICKET_ORDER_DATE	SHBCATT_TICKET_ORDER_DATE	DATE	Yes
SHBCATT_TICKET_MAILED_DATE	SHBCATT_TICKET_MAILED_DATE	DATE	Yes
SHBCATT_TICKET_PICKUP_DATE	SHBCATT_TICKET_PICKUP_DATE	DATE	Yes
SHBCATT_FEE_IND	SHBCATT_FEE_IND	VARCHAR2(1)	Yes
SHBCATT_FEE_DATE	SHBCATT_FEE_DATE	DATE	Yes
SHBCATT_NON_STUDENT	SHBCATT_NON_STUDENT	VARCHAR2(1)	Yes
SHBCATT_SBGI_CODE	SHBCATT_SBGI_CODE	VARCHAR2(6)	Yes		*
SHBCATT_ACTIVITY_DATE	SHBCATT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SHBCATT_TERM_CODE	SHBCRMY_TERM_CODE	SHBCRMY
SHBCATT_CERT_CODE	SHBCRMY_CERT_CODE	SHBCRMY
SHBCATT_CERT_CODE	STVCERT_CODE	STVCERT
SHBCATT_MEAS_CODE_HEIGHT	STVMEAS_CODE	STVMEAS
SHBCATT_TYPE_CODE_CAP	STVTYPE_CODE	STVTYPE
SHBCATT_MEAS_CODE_WEIGHT	STVMEAS_CODE	STVMEAS
SHBCATT_TYPE_CODE_GOWN	STVTYPE_CODE	STVTYPE
SHBCATT_MEAS_CODE_HEAD	STVMEAS_CODE	STVMEAS
SHBCATT_TYPE_CODE_HOOD	STVTYPE_CODE	STVTYPE
SHBCATT_TERM_CODE	STVTERM_CODE	STVTERM
SHBCATT_SBGI_CODE	STVSBGI_CODE	STVSBGI
SHBCATT_SIZE_CODE_GOWN	STVSIZE_CODE	STVSIZE
SHBCATT_SIZE_CODE_CAP	STVSIZE_CODE	STVSIZE

Index

Index Name	Index Type	Column Name
PK_SHBCATT	Unique	SHBCATT_PIDM
PK_SHBCATT	Unique	SHBCATT_TERM_CODE
PK_SHBCATT	Unique	SHBCATT_CERT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
selmacro_attendee	C/C++ Function	[F:\BANNER\C\SHRCATT.PC]	Use(select )
selmacro_attendee_apparel	C/C++ Function	[F:\BANNER\C\SHRCATT.PC]	Use(select )
selmacro_cap_totals	C/C++ Function	[F:\BANNER\C\SHRCATT.PC]	Use(select )
selmacro_gown_totals	C/C++ Function	[F:\BANNER\C\SHRCATT.PC]	Use(select )
selmacro_hood_totals	C/C++ Function	[F:\BANNER\C\SHRCATT.PC]	Use(select )
selmacro_missing_apparel	C/C++ Function	[F:\BANNER\C\SHRCATT.PC]	Use(select )
selmacro_no_pickup	C/C++ Function	[F:\BANNER\C\SHRCATT.PC]	Use(select )
selmacro_no_return	C/C++ Function	[F:\BANNER\C\SHRCATT.PC]	Use(select )
SHBCATT	SYNONYM	S4B70.PUBLIC	Rely on ()
SHRCATT	TABLE	S4B70.SATURN	Refer( No Action )
SPRIDEN	TABLE	S4B70.SATURN	Join
KEY-NEXT-ITEM	Forms Trigger	BANNER7_FORMS.SHAMDIP.SHBDIPL.ADD_ID	Use(select )
KEY-NEXT-ITEM	Forms Trigger	BANNER7_FORMS_10G.SHAMDIP.SHBDIPL.ADD_ID	Use(select )
KEY-NEXT-ITEM	Forms Trigger	BANNER7_FORMS_10G.SHAMUDI.SHBDIPL2.UPDT_ID	Use(select )
KEY-NEXT-ITEM	Forms Trigger	BANNER7_FORMS.SHAMUDI.SHBDIPL2.UPDT_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SHAMUCA.SHBCATT2.UPDT_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SHAMCAT.SHBCATT.ADD_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SHAMUCA.SHBCATT2.UPDT_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SHAMCAT.SHBCATT.ADD_ID	Use(select )
COUNT_ATTENDEES	Forms Trigger	BANNER7_FORMS.SHACATQ	Use(select )
COUNT_ATTENDEES	Forms Trigger	BANNER7_FORMS_10G.SHACATQ	Use(select )
ANY_OTHER_CATTS_CHECK	Forms Trigger	BANNER7_FORMS.SHACATT.SHBCATT	Use(select )
ANY_OTHER_CATTS_CHECK	Forms Trigger	BANNER7_FORMS_10G.SHACATT.SHBCATT	Use(select )
FILLUPDT_DATA	Forms Trigger	BANNER7_FORMS.SHAMUDI.SHBDIPL2	Use(select )
FILLUPDT_DATA	Forms Trigger	BANNER7_FORMS.SHAMUCA.SHBCATT2	Use(select )
FILLUPDT_DATA	Forms Trigger	BANNER7_FORMS_10G.SHAMUDI.SHBDIPL2	Use(select )
FILLUPDT_DATA	Forms Trigger	BANNER7_FORMS_10G.SHAMUCA.SHBCATT2	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS.SHACRMY.SHBCRMY	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS_10G.SHACRMY.SHBCRMY	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.SHACATQ.SHBCATT	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.SHAMCAT.SHRDGMR	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.SHACPRQ.SHBCRMY	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.SHACATQ.SHBCATT	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.SHAMCAT.SHRDGMR	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.SHACPRQ.SHBCRMY	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.SHACATT.SHRCATT	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.SHAMUCA.SHBCATT2	Use(update )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.SHACATT.SHRCATT	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.SHAMUCA.SHBCATT2	Use(update )
UPDT_SHBCATT	Forms Trigger	BANNER7_FORMS_10G.SHAMCAT.SHRDGMR	Use(insert,select )
UPDT_SHBCATT	Forms Trigger	BANNER7_FORMS.SHAMCAT.SHRDGMR	Use(insert,select )
INSERT_SHBCATT_6	Forms Procedure	BANNER7_FORMS.SHAMUDI	Use(insert )
INSERT_SHBCATT_6	Forms Procedure	BANNER7_FORMS_10G.SHAMUDI	Use(insert )
INSERT_SHBCATT_8	Forms Procedure	BANNER7_FORMS.SHAMDIP	Use(insert )
INSERT_SHBCATT_8	Forms Procedure	BANNER7_FORMS_10G.SHAMDIP	Use(insert )
SELECT_SHBCATT_1	Forms Function	BANNER7_FORMS_10G.SHAMCAT	Use(select )
SELECT_SHBCATT_1	Forms Function	BANNER7_FORMS.SHAMCAT	Use(select )
SELECT_SHBCATT_4	Forms Function	BANNER7_FORMS.SHAMUDI	Use(select )
SELECT_SHBCATT_4	Forms Function	BANNER7_FORMS.SHADIPL	Use(select )
SELECT_SHBCATT_4	Forms Function	BANNER7_FORMS_10G.SHADIPL	Use(select )
SELECT_SHBCATT_4	Forms Function	BANNER7_FORMS_10G.SHAMUDI	Use(select )
SELECT_SHBCATT_6	Forms Function	BANNER7_FORMS.SHAMDIP	Use(select )
SELECT_SHBCATT_6	Forms Function	BANNER7_FORMS_10G.SHAMDIP	Use(select )
SHBCATT	Forms DataBlock	BANNER7_FORMS.SHACATQ	Use(select )
SHBCATT	Forms DataBlock	BANNER7_FORMS_10G.SHACATQ	Use(select )
SHBCATT	Forms DataBlock	BANNER7_FORMS_10G.SHACATT	Rely on () Use(insert,update,delete,select )
SHBCATT	Forms DataBlock	BANNER7_FORMS.SHAMCAT	Rely on () Use(insert,update,delete,select )
SHBCATT	Forms DataBlock	BANNER7_FORMS_10G.SHAMUCA	Use(insert,update,delete,select )
SHBCATT	Forms DataBlock	BANNER7_FORMS.SHACATT	Rely on () Use(insert,update,delete,select )
SHBCATT	Forms DataBlock	BANNER7_FORMS.SHAMUCA	Use(insert,update,delete,select )
SHBCATT	Forms DataBlock	BANNER7_FORMS_10G.SHAMCAT	Rely on () Use(insert,update,delete,select )
SHBCRMY	Forms DataBlock	BANNER7_FORMS.SHACPRQ	Use(select )
SHBCRMY	Forms DataBlock	BANNER7_FORMS_10G.SHACPRQ	Use(select )
SHRDGMR	Forms DataBlock	BANNER7_FORMS_10G.SHAMCAT	Use(select )
SHRDGMR	Forms DataBlock	BANNER7_FORMS.SHAMCAT	Use(select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SHBCATT	INDEX	S4B70.SATURN	Rely on ()
SHBCRMY	TABLE	S4B70.SATURN	Refer( No Action )
STVCERT	TABLE	S4B70.SATURN	Refer( No Action )
STVMEAS	TABLE	S4B70.SATURN	Refer( No Action )
STVSBGI	TABLE	S4B70.SATURN	Refer( No Action )
STVSIZE	TABLE	S4B70.SATURN	Refer( No Action )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )
STVTYPE	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Cermony Attendance Information Table

Columns Comments for SHBCATT_PIDM (1)

Source Code Comments

Internal Identification of Student with ceremony attendance request.

Columns Comments for SHBCATT_TERM_CODE (2)

Source Code Comments

This field identifies the term for which the ceremony has been scheduled.

Columns Comments for SHBCATT_CERT_CODE (3)

Source Code Comments

This field identifies the ceremony type being held.

Columns Comments for SHBCATT_MEAS_CODE_HEIGHT (4)

Source Code Comments

This field identifies the height measurement designation. Example, inches.

Columns Comments for SHBCATT_HEIGHT (5)

Source Code Comments

This field identifies the height of the attendee.

Columns Comments for SHBCATT_MEAS_CODE_WEIGHT (6)

Source Code Comments

This field identifies the weight measurement designation. Example, pounds.

Columns Comments for SHBCATT_WEIGHT (7)

Source Code Comments

This field identifies the weight of the attendee.

Columns Comments for SHBCATT_MEAS_CODE_HEAD (8)

Source Code Comments

This field identifies the head size measurement designation. Example, inches.

Columns Comments for SHBCATT_HEAD_SIZE (9)

Source Code Comments

This field identifies the head size of the attendee.

Columns Comments for SHBCATT_TYPE_CODE_CAP (10)

Source Code Comments

This field identifies the cap type to be issued to the attendee.

Columns Comments for SHBCATT_SIZE_CODE_CAP (11)

Source Code Comments

This field describes the cap size issued to the attendee.

Columns Comments for SHBCATT_CAP_DATE_ORDERED (12)

Source Code Comments

This field contains the date the attendee ordered the cap.

Columns Comments for SHBCATT_CAP_DATE_PICKUP (13)

Source Code Comments

This field contains the date the attendee picked up the cap.

Columns Comments for SHBCATT_CAP_DATE_RETURNED (14)

Source Code Comments

This field contains the date the attendee returned the cap.

Columns Comments for SHBCATT_TYPE_CODE_GOWN (15)

Source Code Comments

This field identifies the gown type to be issued to the attendee.

Columns Comments for SHBCATT_SIZE_CODE_GOWN (16)

Source Code Comments

This field describes the gown size issued to the attendee.

Columns Comments for SHBCATT_GOWN_DATE_ORDERED (17)

Source Code Comments

This field contains the date the attendee ordered the gown.

Columns Comments for SHBCATT_GOWN_DATE_PICKUP (18)

Source Code Comments

This field contains the date the attendee picked up the gown.

Columns Comments for SHBCATT_GOWN_DATE_RETURNED (19)

Source Code Comments

This field contains the date the attendee returned the gown.

Columns Comments for SHBCATT_TYPE_CODE_HOOD (20)

Source Code Comments

This field identifies the hood type to be issued to the attendee.

Columns Comments for SHBCATT_HOOD_DATE_ORDERED (21)

Source Code Comments

This field contains the date the attendee ordered the hood.

Columns Comments for SHBCATT_HOOD_DATE_PICKUP (22)

Source Code Comments

This field contains the date the attendee picked up the hood.

Columns Comments for SHBCATT_HOOD_DATE_RETURNED (23)

Source Code Comments

This field contains the date the attendee returned the hood.

Columns Comments for SHBCATT_NO_ANNOUNCEMENTS (24)

Source Code Comments

This field contains the number of announcements the attendee has requested.

Columns Comments for SHBCATT_NO_TICKETS (25)

Source Code Comments

This field contains the number of tickets the attendee has requested.

Columns Comments for SHBCATT_TICKET_ORDER_DATE (26)

Source Code Comments

This field contains the date the attendee ordered the tickets.

Columns Comments for SHBCATT_TICKET_MAILED_DATE (27)

Source Code Comments

This field contains the date the attendee was mailed the tickets.

Columns Comments for SHBCATT_TICKET_PICKUP_DATE (28)

Source Code Comments

This field contains the date the attendee picked up the tickets.

Columns Comments for SHBCATT_FEE_IND (29)

Source Code Comments

This field identifies whether a cap and gown fee has been assessed.

Columns Comments for SHBCATT_FEE_DATE (30)

Source Code Comments

This field identifies the date cap and gown fee has been assessed.

Columns Comments for SHBCATT_NON_STUDENT (31)

Source Code Comments

This field identifies whether the attendee is a student. If not a student, N must be entered in this field.

Columns Comments for SHBCATT_SBGI_CODE (32)

Source Code Comments

This field contains the SBGI code of the attendee if attendee is a non-student.

Columns Comments for SHBCATT_ACTIVITY_DATE (33)

Source Code Comments

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

Table SHBCGPA

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SHBCGPA_CAMP_GPA_IND	SHBCGPA_CAMP_GPA_IND	VARCHAR2(1)	No
SHBCGPA_ACTIVITY_DATE	SHBCGPA_ACTIVITY_DATE	DATE	No
SHBCGPA_TPRT_CODE	SHBCGPA_TPRT_CODE	VARCHAR2(4)	Yes	*
SHBCGPA_TRMT_CODE	SHBCGPA_TRMT_CODE	VARCHAR2(1)	Yes	*
SHBCGPA_INST_FICE	SHBCGPA_INST_FICE	VARCHAR2(6)	Yes
SHBCGPA_GSCALE_WEB_IND	SHBCGPA_GSCALE_WEB_IND	VARCHAR2(1)	No
SHBCGPA_UNIT_ID	SHBCGPA_UNIT_ID	VARCHAR2(6)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SHBCGPA_TPRT_CODE	STVTPRT_CODE	STVTPRT
SHBCGPA_TRMT_CODE	STVTRMT_CODE	STVTRMT

Index

No Result

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
main	C/C++ Function	[F:\BANNER\C\SHRIETH.PC]	Use(select )
main	C/C++ Function	[F:\BANNER\C\SHRIRES.PC]	Use(select )
main	C/C++ Function	[F:\BANNER\C\SHRIAGE.PC]	Use(select )
select_campus_gpa	C/C++ Function	[F:\BANNER\C\SHREDIY.PC]	Use(select )
create_web_file	C/C++ Function	[F:\BANNER\C\SHRICIP.PC]	Use(select )
printBody	C/C++ Function	[F:\BANNER\C\ICSORIMS.PC]	Use(select )
printBody	C/C++ Function	[F:\BANNER\C\SCRRIMS.PC]	Use(select )
sel_campus_gpa	C/C++ Function	[F:\BANNER\C\ISRKGRD.PC]	Use(select )
sel_fice	C/C++ Function	[F:\BANNER\C\SFRNSLC.PC]	Use(select )
sel_fice	C/C++ Function	[F:\BANNER\C\SHRDEGV.PC]	Use(select )
selcgpa	C/C++ Function	[F:\BANNER\C\ISRKTRN.PC]	Use(select )
selcgpa	C/C++ Function	[F:\BANNER\C\SHRGPAC.PC]	Use(select )
selcgpa	C/C++ Function	[F:\BANNER\C\SHRGRDE.PC]	Use(select )
selcgpa	C/C++ Function	[F:\BANNER\C\SHRTRTC.PC]	Use(select )
updcgpa	C/C++ Function	[F:\BANNER\C\SHRCONV.PC]	Use(update )
web_summary	C/C++ Function	[F:\BANNER\C\SHRIACT.PC]	Use(select )
web_summary	C/C++ Function	[F:\BANNER\C\SHRIGRS.PC]	Use(select )
SHBCGPA	SYNONYM	S4B70.PUBLIC	Rely on ()
CAMPUS_GPA_IS_Y	Forms Function	BANNER7_FORMS.SHAPCMP	Use(select )
CAMPUS_GPA_IS_Y	Forms Function	BANNER7_FORMS_10G.SHAPCMP	Use(select )
SELECT_SHBCGPA_1	Forms Function	BANNER7_FORMS.SHATCKP	Use(select )
SELECT_SHBCGPA_1	Forms Function	BANNER7_FORMS_10G.SHATCKS	Use(select )
SELECT_SHBCGPA_1	Forms Function	BANNER7_FORMS_10G.SHATCKN	Use(select )
SELECT_SHBCGPA_1	Forms Function	BANNER7_FORMS_10G.SHATRMC	Use(select )
SELECT_SHBCGPA_1	Forms Function	BANNER7_FORMS_10G.SHATCKC	Use(select )
SELECT_SHBCGPA_1	Forms Function	BANNER7_FORMS_10G.SHATCKP	Use(select )
SELECT_SHBCGPA_1	Forms Function	BANNER7_FORMS.SHATCKC	Use(select )
SELECT_SHBCGPA_1	Forms Function	BANNER7_FORMS.SHATRMC	Use(select )
SELECT_SHBCGPA_1	Forms Function	BANNER7_FORMS.SHATCKS	Use(select )
SELECT_SHBCGPA_3	Forms Function	BANNER7_FORMS.SHARQTC	Use(select )
SELECT_SHBCGPA_3	Forms Function	BANNER7_FORMS_10G.SHARQTC	Use(select )
CGPA_IND	Package variable	S4B70.BANINST1.SHKROLS	Rely on ()
SHBCGPA_ROW	Package variable	S4B70.BANINST1.SHKROLS	Rely on ()
SHBCGPA_ROW	Package variable	S4B70.BANINST1.SHKROLS	Rely on ()
P_SELECT_SHBCGPA	Package procedure	S4B70.BANINST1.SHKSELS	Rely on ()
P_SEND_ADD_SECTION	Package procedure	S4B70.BANINST1.ICSSKEVN	Rely on ()
P_SEND_ADD_TERM	Package procedure	S4B70.BANINST1.ICSOKEVN	Rely on ()
P_SEND_DELETE_CROSS_LIST	Package procedure	S4B70.BANINST1.ICSSKEVN	Rely on ()
P_SEND_DEL_SECTION	Package procedure	S4B70.BANINST1.ICSSKEVN	Rely on ()
P_SEND_UPD_SECTION	Package procedure	S4B70.BANINST1.ICSSKEVN	Rely on ()
P_SEND_UPD_SECTION_COURSE	Package procedure	S4B70.BANINST1.ICSSKEVN	Rely on ()
P_SEND_UPD_TERM	Package procedure	S4B70.BANINST1.ICSOKEVN	Rely on ()
P_TERM_GPA	Package procedure	S4B70.BANINST1.SHKCGPA	Use(select )
SHBCGPA_C	Package cursor	S4B70.BANINST1.SHKLIBS	Rely on () Use(select )
SHBCGPA_C	Package cursor	S4B70.BANINST1.SHKSELS	Rely on () Use(select )
GRADE_SCALE_ALLOWED_ON_WEB	Package function	S4B70.BANINST1.BWSKSMRK	Rely on ()
GRADE_SCALE_ALLOWED_ON_WEB	Package function	S4B70.BANINST1.BWSKSMRK	Rely on ()
SHBCGPA	Forms DataBlock	BANNER7_FORMS.SHACTRL	Rely on () Use(insert,update,delete,select )
SHBCGPA	Forms DataBlock	BANNER7_FORMS_10G.SHACTRL	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
STVTPRT	TABLE	S4B70.SATURN	Refer( No Action )
STVTRMT	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Campus GPA Processing Base Table

Columns Comments for SHBCGPA_CAMP_GPA_IND (1)

Source Code Comments

The campus GPA indicator will show whether campus GPA processing is turned on at the institution. Y means campus GPA process is on, N no campus GPA processing

Columns Comments for SHBCGPA_ACTIVITY_DATE (2)

Source Code Comments

The date the record was lastcreated or last updated

Columns Comments for SHBCGPA_TPRT_CODE (3)

Source Code Comments

The default transcript type to use for electronic data transcripts (EDI). Valid values are defined in table STVTPRT

Columns Comments for SHBCGPA_TRMT_CODE (4)

Source Code Comments

The default term type for the institution. Valid values are defined in table STVTRMT.

Columns Comments for SHBCGPA_INST_FICE (5)

Source Code Comments

Institution FICE code.

Columns Comments for SHBCGPA_GSCALE_WEB_IND (6)

Source Code Comments

Indicates whether to allow grade scales to be displayed in student grade scale detail on the Web

Columns Comments for SHBCGPA_UNIT_ID (7)

Source Code Comments

Institution unit ID assigned by NCES for IPEDS reporting.

Table SHBCOMI

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SHBCOMI_PIDM	SHBCOMI_PIDM	NUMBER(8,0)	Yes	*
SHBCOMI_COMT_CODE	SHBCOMI_COMT_CODE	VARCHAR2(6)	No	*
SHBCOMI_COLL_CODE	SHBCOMI_COLL_CODE	VARCHAR2(2)	Yes	*
SHBCOMI_DEPT_CODE	SHBCOMI_DEPT_CODE	VARCHAR2(4)	Yes	*
SHBCOMI_INITIATED_DATE	SHBCOMI_INITIATED_DATE	DATE	Yes
SHBCOMI_DISSOLVED_IND	SHBCOMI_DISSOLVED_IND	VARCHAR2(1)	Yes
SHBCOMI_DISSOLVED_DATE	SHBCOMI_DISSOLVED_DATE	DATE	Yes
SHBCOMI_COMS_CODE	SHBCOMI_COMS_CODE	VARCHAR2(2)	Yes	*
SHBCOMI_ACTIVITY_DATE	SHBCOMI_ACTIVITY_DATE	DATE	No
SHBCOMI_TRANS_PRINT	SHBCOMI_TRANS_PRINT	VARCHAR2(1)	Yes
SHBCOMI_DICD_CODE	SHBCOMI_DICD_CODE	VARCHAR2(3)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SHBCOMI_DICD_CODE	GTVDICD_CODE	GTVDICD
SHBCOMI_COLL_CODE	STVCOLL_CODE	STVCOLL
SHBCOMI_COMS_CODE	STVCOMS_CODE	STVCOMS
SHBCOMI_COMT_CODE	STVCOMT_CODE	STVCOMT
SHBCOMI_DEPT_CODE	STVDEPT_CODE	STVDEPT
SHBCOMI_PIDM	SPRIDEN_PIDM	SPRIDEN

Index

Index Name	Index Type	Column Name
SHBCOMI_KEY_INDEX	Unique	SHBCOMI_PIDM
SHBCOMI_KEY_INDEX	Unique	SHBCOMI_COMT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
selcomi	C/C++ Function	[F:\BANNER\C\ISRKTRN.PC]	Use(select )
selcomi	C/C++ Function	[F:\BANNER\C\SHRTRTC.PC]	Use(select )
SHBCOMI	SYNONYM	S4B70.PUBLIC	Rely on ()
SHVCOMI	VIEW	S4B70.BANINST1	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SHANCRS.SHRNCRS.SHRNCRS_COMT_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SHANCRS.SHRNCRS.SHRNCRS_COMT_CODE	Use(select )