Model Location Management Tables

Model Label : Tables used for Banner Student Location Management

List of Objects

Object Name	Object Type	Layer Name
SLBBLDG	TABLE	Default
SLBEVNT	TABLE	Default
SLBRDEF	TABLE	Default
SLBRMAP	TABLE	Default
SLBRMPF	TABLE	Default
SLBTERM	TABLE	Default
SLRASCD	TABLE	Default
SLRBCAT	TABLE	Default
SLRBCMT	TABLE	Default
SLRBDEF	TABLE	Default
SLRCMNT	TABLE	Default
SLRCOLC	TABLE	Default
SLRCOLR	TABLE	Default
SLRDCOL	TABLE	Default
SLRECMT	TABLE	Default
SLRLMFE	TABLE	Default
SLRMASG	TABLE	Default
SLRMFCR	TABLE	Default
SLRMSCD	TABLE	Default
SLRPASG	TABLE	Default
SLRPFCR	TABLE	Default
SLRPREQ	TABLE	Default
SLRPSCD	TABLE	Default
SLRRASG	TABLE	Default
SLRRDEF	TABLE	Default
SLRRFCR	TABLE	Default
SLRRMAT	TABLE	Default
SLRRMDF	TABLE	Default
SLRRUSE	TABLE	Default
SLRTASG	TABLE	Default
SLTFTRN	TABLE	Default

Comments

Model View

Table SLBBLDG

Schema Name SATURN
Label SLBBLDG
Server name S4B70
Creation Date 11/03/2003 13:06:21:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SLBBLDG_BLDG_CODE	SLBBLDG_BLDG_CODE	VARCHAR2(6)	No	*	*
SLBBLDG_CAMP_CODE	SLBBLDG_CAMP_CODE	VARCHAR2(3)	No
SLBBLDG_CAPACITY	SLBBLDG_CAPACITY	NUMBER(5,0)	No
SLBBLDG_MAXIMUM_CAPACITY	SLBBLDG_MAXIMUM_CAPACITY	NUMBER(5,0)	Yes
SLBBLDG_RRCD_CODE	SLBBLDG_RRCD_CODE	VARCHAR2(4)	Yes
SLBBLDG_PRCD_CODE	SLBBLDG_PRCD_CODE	VARCHAR2(4)	Yes
SLBBLDG_SITE_CODE	SLBBLDG_SITE_CODE	VARCHAR2(3)	Yes
SLBBLDG_STREET_LINE1	SLBBLDG_STREET_LINE1	VARCHAR2(30)	Yes
SLBBLDG_STREET_LINE2	SLBBLDG_STREET_LINE2	VARCHAR2(30)	Yes
SLBBLDG_STREET_LINE3	SLBBLDG_STREET_LINE3	VARCHAR2(30)	Yes
SLBBLDG_CITY	SLBBLDG_CITY	VARCHAR2(20)	Yes
SLBBLDG_STAT_CODE	SLBBLDG_STAT_CODE	VARCHAR2(3)	Yes
SLBBLDG_ZIP	SLBBLDG_ZIP	VARCHAR2(10)	Yes
SLBBLDG_CNTY_CODE	SLBBLDG_CNTY_CODE	VARCHAR2(5)	Yes
SLBBLDG_PHONE_AREA	SLBBLDG_PHONE_AREA	VARCHAR2(3)	Yes
SLBBLDG_PHONE_NUMBER	SLBBLDG_PHONE_NUMBER	VARCHAR2(7)	Yes
SLBBLDG_PHONE_EXTENSION	SLBBLDG_PHONE_EXTENSION	VARCHAR2(4)	Yes
SLBBLDG_ACTIVITY_DATE	SLBBLDG_ACTIVITY_DATE	DATE	No
SLBBLDG_SEX	SLBBLDG_SEX	VARCHAR2(1)	Yes
SLBBLDG_COLL_CODE	SLBBLDG_COLL_CODE	VARCHAR2(2)	Yes
SLBBLDG_DEPT_CODE	SLBBLDG_DEPT_CODE	VARCHAR2(4)	Yes
SLBBLDG_KEY_NUMBER	SLBBLDG_KEY_NUMBER	VARCHAR2(5)	Yes
SLBBLDG_PARS_CODE	SLBBLDG_PARS_CODE	VARCHAR2(7)	Yes		*
SLBBLDG_DATA_ORIGIN	SLBBLDG_DATA_ORIGIN	VARCHAR2(30)	Yes
SLBBLDG_USER_ID	SLBBLDG_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLBBLDG_BLDG_CODE	STVBLDG_CODE	STVBLDG
SLBBLDG_PARS_CODE	GTVPARS_CODE	GTVPARS

Index

Index Name	Index Type	Column Name
PK_SLBBLDG	Unique	SLBBLDG_BLDG_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
BAA3	Cobol Paragraph	[F:\banner\cobol].SLRSCHE.AAA	Use(select )
create_roomsFile	C/C++ Function	[F:\BANNER\C\SSRSCRM.PC]	Use(select )
selname	C/C++ Function	[F:\BANNER\C\SLRDADD.PC]	Use(select )
update_work_table	C/C++ Function	[F:\BANNER\C\SSRSCRM.PC]	Use(select )
SLBRDEF	TABLE	S4B70.SATURN	Join
SLRRASG	TABLE	S4B70.SATURN	Join
SSRMEET	TABLE	S4B70.SATURN	Join
AS_ROOM_ASSIGNMENT	VIEW	S4B70.BANINST1	Use(select )
SLVRES2	VIEW	S4B70.BANINST1	Use(select )
SLVRSM2	VIEW	S4B70.BANINST1	Use(select )
SLVRUSE	VIEW	S4B70.BANINST1	Use(select )
SSVMEET	VIEW	S4B70.BANINST1	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GEAFUNC.SSRMEET.SSRMEET_BLDG_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SLARDEF.KEY_BLOCK.SLARDEF_BLDG_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SLAEVNT.SSRMEET.SSRMEET_BLDG_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SLARMAP.SLBRMAP.SLBRMAP_PREFERED_BUILDING	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SLARDEF.SLBRDEF.SLBRDEF_SEX	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SLARMAT.SLBRMPF.SLBRMPF_BLDG_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GEAFUNC.SSRMEET.SSRMEET_BLDG_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SSASECT.SSRMEET.SSRMEET_BLDG_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SLABLDG.KEY_BLOCK.SLABLDG_BLDG_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SLARMAP.SLBRMAP.SLBRMAP_PREFERED_BUILDING	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SLARDEF.KEY_BLOCK.SLARDEF_BLDG_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SLARMAT.SLBRMPF.SLBRMPF_BLDG_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SLAEVNT.SSRMEET.SSRMEET_BLDG_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SLARDEF.SLBRDEF.SLBRDEF_SEX	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SLABLDG.KEY_BLOCK.SLABLDG_BLDG_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SSASECT.SSRMEET.SSRMEET_BLDG_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.SSASCHW.SSTSCHW.SSTSCHW_BLDG_CODE	Use(select )
GET_DEFAULTS	Forms Trigger	BANNER7_FORMS.SLARDEF	Use(select )
GET_DEFAULTS	Forms Trigger	BANNER7_FORMS_10G.SLARDEF	Use(select )
CHECK_BLDG_BCAT	Forms Trigger	BANNER7_FORMS.SLARMAP.SLBRMAP	Use(select )
GET_CAMP_SITE	Forms Trigger	BANNER7_FORMS.SLASGNQ.SLBRDEF	Use(select )
GET_CAMP_SITE	Forms Trigger	BANNER7_FORMS_10G.SLASGNQ.SLBRDEF	Use(select )
GET_CAMP_SITE	Forms Trigger	BANNER7_FORMS_10G.SLQMEET.SLBRDEF	Use(select )
GET_CAMP_SITE	Forms Trigger	BANNER7_FORMS_10G.SLIAEVN.SLBRDEF	Use(select )
GET_CAMP_SITE	Forms Trigger	BANNER7_FORMS.SLIAEVN.SLBRDEF	Use(select )
GET_CAMP_SITE	Forms Trigger	BANNER7_FORMS.SLQMEET.SLBRDEF	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.SLASGNQ.SLBRDEF	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.SLASGNQ.SLBRDEF	Use(select )
WHEN-NEW-RECORD-INSTANCE	Forms Trigger	BANNER7_FORMS.SLARDEF.SLBRDEF	Use(select )
WHEN-NEW-RECORD-INSTANCE	Forms Trigger	BANNER7_FORMS_10G.SLARDEF.SLBRDEF	Use(select )
GET_BLDG	Forms Procedure	BANNER7_FORMS.SLARASG	Use(select )
GET_BLDG	Forms Procedure	BANNER7_FORMS_10G.SLARASG	Use(select )
GET_RATE	Forms Procedure	BANNER7_FORMS.SLARASG	Use(select )
GET_RATE	Forms Procedure	BANNER7_FORMS_10G.SLARASG	Use(select )
POSTQUERY	Forms Procedure	BANNER7_FORMS.SLASGNQ	Use(select )
POSTQUERY	Forms Procedure	BANNER7_FORMS_10G.SLASGNQ	Use(select )
F_GET_MULT_SLBBLDG_ROWID	FUNCTION	S4B70.BANINST1	Use(select )
F_GET_SLBBLDG_ROWID	FUNCTION	S4B70.BANINST1	Use(select )
SELECT_SLBBLDG_1	Forms Function	BANNER7_FORMS_10G.SHACRMY	Use(select )
SELECT_SLBBLDG_1	Forms Function	BANNER7_FORMS.SHACRMY	Use(select )
BLDGDEFINITION_REC	Package Type	S4B70.BANINST1.GB_BLDGDEFINITION	Rely on ()
BLDGDEFINITION_REC	Package Type	S4B70.BANINST1.SB_BLDGDEFINITION	Rely on ()
P_OVERLAY_VALIDATION_REC	Package procedure	S4B70.BANINST1.GB_BLDGDEFINITION	Rely on ()
P_OVERLAY_VALIDATION_REC	Package procedure	S4B70.BANINST1.SB_BLDGDEFINITION	Rely on ()
F_BUILD_SLBBLDG_REC	Package function	S4B70.BANINST1.GB_BLDGDEFINITION	Rely on ()
F_BUILD_SLBBLDG_REC	Package function	S4B70.BANINST1.SB_BLDGDEFINITION	Rely on ()
F_BUILD_SLBBLDG_REC	Package function	S4B70.BANINST1.GB_BLDGDEFINITION	Rely on ()
P_CHECK_COMBINATIONS	Package procedure	S4B70.BANINST1.SB_ROOMPREFERENCE_RULES	Rely on ()
P_CREATE	Package procedure	S4B70.BANINST1.GB_BLDGDEFINITION	Rely on ()
P_CREATE	Package procedure	S4B70.BANINST1.GB_BLDGDEFINITION	Rely on ()
P_CREATE	Package procedure	S4B70.BANINST1.SB_BLDGDEFINITION	Rely on ()
P_DELETE	Package procedure	S4B70.BANINST1.GB_BLDGDEFINITION	Rely on ()
P_DELETE	Package procedure	S4B70.BANINST1.SB_BLDGDEFINITION	Rely on ()
P_DELETE	Package procedure	S4B70.BANINST1.GB_BLDGDEFINITION	Rely on ()
P_DELETE	Package procedure	S4B70.BANINST1.DML_SLBBLDG	Use(delete )
P_INSERT	Package procedure	S4B70.BANINST1.DML_SLBBLDG	Rely on () Use(insert )
P_LOCK	Package procedure	S4B70.BANINST1.GB_BLDGDEFINITION	Rely on ()
P_LOCK	Package procedure	S4B70.BANINST1.SB_BLDGDEFINITION	Rely on ()
P_LOCK	Package procedure	S4B70.BANINST1.GB_BLDGDEFINITION	Use(select )
P_REGISTER_ENTITY	Package procedure	S4B70.BANINST1.GB_BLDGDEFINITION_RULES	Rely on ()
P_REGISTER_ENTITY	Package procedure	S4B70.BANINST1.SB_BLDGDEFINITION_RULES	Rely on ()
P_UPDATE	Package procedure	S4B70.BANINST1.DML_SLBBLDG	Rely on ()
P_UPDATE	Package procedure	S4B70.BANINST1.GB_BLDGDEFINITION	Rely on ()
P_UPDATE	Package procedure	S4B70.BANINST1.SB_BLDGDEFINITION	Rely on ()
P_UPDATE	Package procedure	S4B70.BANINST1.GB_BLDGDEFINITION	Rely on ()
P_VALIDATE	Package procedure	S4B70.BANINST1.GB_BLDGDEFINITION_RULES	Rely on ()
P_VALIDATE	Package procedure	S4B70.BANINST1.SB_ROOMPREFERENCE_RULES	Rely on ()
P_VALIDATE	Package procedure	S4B70.BANINST1.SB_ROOMMATE_RULES	Use(select )
P_VALIDATE	Package procedure	S4B70.BANINST1.SB_ROOMPREFERENCE_RULES	Use(select )
P_VALIDATE	Package procedure	S4B70.BANINST1.SB_BLDGDEFINITION_RULES	Rely on ()
UT_SETUP	Package procedure	S4B70.BANINST1.UT_SB_ROOMPREFERENCE	Use(select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_GB_BLDGDEFINITION	Use(insert,select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_SB_BLDGDEFINITION	Use(insert,select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_GB_CLASSTIMES	Use(insert,select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_GB_ROOMASSIGNMENT	Use(select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_SB_ROOMMATE	Use(select )
UT_TEARDOWN	Package procedure	S4B70.BANINST1.UT_SB_BLDGDEFINITION	Use(delete )
F_EXISTS	Package function	S4B70.BANINST1.GB_BLDGDEFINITION	Rely on ()
F_EXISTS	Package function	S4B70.BANINST1.GB_BLDGDEFINITION	Use(select )
F_EXISTS	Package function	S4B70.BANINST1.SB_BLDGDEFINITION	Rely on ()
F_GET_RATE	Package function	S4B70.BANINST1.GB_ROOMASSIGNMENT	Use(select )
F_QUERY_ALL	Package function	S4B70.BANINST1.GB_BLDGDEFINITION	Rely on ()
F_QUERY_ALL	Package function	S4B70.BANINST1.GB_BLDGDEFINITION	Use(select )
F_QUERY_ALL	Package function	S4B70.BANINST1.SB_BLDGDEFINITION	Rely on ()
F_QUERY_BY_ROWID	Package function	S4B70.BANINST1.GB_BLDGDEFINITION	Use(select )
F_QUERY_ONE	Package function	S4B70.BANINST1.GB_BLDGDEFINITION	Rely on ()
F_QUERY_ONE	Package function	S4B70.BANINST1.SB_BLDGDEFINITION	Rely on ()
F_QUERY_ONE	Package function	S4B70.BANINST1.GB_BLDGDEFINITION	Use(select )
F_QUERY_ONE_LOCK	Package function	S4B70.BANINST1.GB_BLDGDEFINITION	Rely on ()
F_QUERY_ONE_LOCK	Package function	S4B70.BANINST1.GB_BLDGDEFINITION	Use(select )
F_QUERY_ONE_LOCK	Package function	S4B70.BANINST1.SB_BLDGDEFINITION	Rely on ()
SLBBLDG	SYNONYM	S4B70.PUBLIC	Rely on ()
SLBBLDG	Forms DataBlock	BANNER7_FORMS.SLABQRY	Rely on () Use(insert,update,delete,select )
SLBBLDG	Forms DataBlock	BANNER7_FORMS_10G.SLABLDG	Rely on () Use(insert,update,delete,select )
SLBBLDG	Forms DataBlock	BANNER7_FORMS_10G.SLABQRY	Rely on () Use(insert,update,delete,select )
SLBBLDG	Forms DataBlock	BANNER7_FORMS.SLABLDG	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SLBBLDG	INDEX	S4B70.SATURN	Rely on ()
GTVPARS	TABLE	S4B70."GENERAL"	Refer( No Action )
STVBLDG	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Location/Building Description Table

Columns Comments for SLBBLDG_BLDG_CODE (1)

Source Code Comments

This column identifies the building code associated with the building record

Columns Comments for SLBBLDG_CAMP_CODE (2)

Source Code Comments

This column identifies the campus in which the building is located

Columns Comments for SLBBLDG_CAPACITY (3)

Source Code Comments

This column identifies the capacity of the building

Columns Comments for SLBBLDG_MAXIMUM_CAPACITY (4)

Source Code Comments

This column identifies the maximum capacity of the building

Columns Comments for SLBBLDG_RRCD_CODE (5)

Source Code Comments

This column identifies the default room rate for all rooms defined for the building.

Columns Comments for SLBBLDG_PRCD_CODE (6)

Source Code Comments

This column identifies the default phone rate for all rooms defined for the building.

Columns Comments for SLBBLDG_SITE_CODE (7)

Source Code Comments

This column identifies the site of the building

Columns Comments for SLBBLDG_STREET_LINE1 (8)

Source Code Comments

This column identifies the first street line for the address of the building

Columns Comments for SLBBLDG_STREET_LINE2 (9)

Source Code Comments

This column identifies the second street line of the address of the building

Columns Comments for SLBBLDG_STREET_LINE3 (10)

Source Code Comments

This column identifies the third street line of the address of the building

Columns Comments for SLBBLDG_CITY (11)

Source Code Comments

This column identifies the city where the building is located

Columns Comments for SLBBLDG_STAT_CODE (12)

Source Code Comments

This column is used to store the state or province code of the building's address.Validated against STVSTAT.

Columns Comments for SLBBLDG_ZIP (13)

Source Code Comments

This column identifies the zip code of the building

Columns Comments for SLBBLDG_CNTY_CODE (14)

Source Code Comments

This column identifies the county code of the building

Columns Comments for SLBBLDG_PHONE_AREA (15)

Source Code Comments

This column identifies the area code of the phone number for the building

Columns Comments for SLBBLDG_PHONE_NUMBER (16)

Source Code Comments

This column identifies the phone number for the building

Columns Comments for SLBBLDG_PHONE_EXTENSION (17)

Source Code Comments

This column identifies the phone extension of the phone number for the building

Columns Comments for SLBBLDG_ACTIVITY_DATE (18)

Source Code Comments

This column identifies the date the record was created or last updated

Columns Comments for SLBBLDG_SEX (19)

Source Code Comments

This column identifies the gender associated with the building

Columns Comments for SLBBLDG_COLL_CODE (20)

Source Code Comments

This column identifies the college that is associated with the building

Columns Comments for SLBBLDG_DEPT_CODE (21)

Source Code Comments

This column identifies the department that is associated with the building

Columns Comments for SLBBLDG_KEY_NUMBER (22)

Source Code Comments

This column identifies the number of the key to the building

Columns Comments for SLBBLDG_PARS_CODE (23)

Source Code Comments

Pars Codes define campus zones, which are catagories or groupings of rooms. Partitions can be defined on buildings, rooms, subjects, courses and sections.

Columns Comments for SLBBLDG_DATA_ORIGIN (24)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SLBBLDG_USER_ID (25)

Source Code Comments

USER ID: User who inserted or last update the data

Table SLBEVNT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SLBEVNT_CRN	SLBEVNT_CRN	VARCHAR2(5)	No	*
SLBEVNT_ETYP_CODE	SLBEVNT_ETYP_CODE	VARCHAR2(4)	No
SLBEVNT_DESC	SLBEVNT_DESC	VARCHAR2(30)	Yes
SLBEVNT_AGENCY_PIDM	SLBEVNT_AGENCY_PIDM	NUMBER(8,0)	Yes
SLBEVNT_CONTACT_NAME	SLBEVNT_CONTACT_NAME	VARCHAR2(35)	Yes
SLBEVNT_CAMP_CODE	SLBEVNT_CAMP_CODE	VARCHAR2(3)	Yes
SLBEVNT_SITE_CODE	SLBEVNT_SITE_CODE	VARCHAR2(3)	Yes		*
SLBEVNT_COLL_CODE	SLBEVNT_COLL_CODE	VARCHAR2(2)	Yes
SLBEVNT_DEPT_CODE	SLBEVNT_DEPT_CODE	VARCHAR2(4)	Yes
SLBEVNT_ACTIVITY_DATE	SLBEVNT_ACTIVITY_DATE	DATE	Yes
SLBEVNT_PHONE_AREA	SLBEVNT_PHONE_AREA	VARCHAR2(3)	Yes
SLBEVNT_PHONE	SLBEVNT_PHONE	VARCHAR2(7)	Yes
SLBEVNT_PHONE_EXT	SLBEVNT_PHONE_EXT	VARCHAR2(4)	Yes
SLBEVNT_CONTACT_PIDM	SLBEVNT_CONTACT_PIDM	NUMBER(8,0)	Yes
SLBEVNT_ATYP_CODE	SLBEVNT_ATYP_CODE	VARCHAR2(2)	Yes
SLBEVNT_SYSI_CODE	SLBEVNT_SYSI_CODE	VARCHAR2(2)	Yes
SLBEVNT_COMM_IND	SLBEVNT_COMM_IND	VARCHAR2(1)	No
SLBEVNT_DICD_CODE	SLBEVNT_DICD_CODE	VARCHAR2(3)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLBEVNT_DICD_CODE	GTVDICD_CODE	GTVDICD
SLBEVNT_SITE_CODE	STVSITE_CODE	STVSITE

Index

Index Name	Index Type	Column Name
PK_SLBEVNT	Unique	SLBEVNT_CRN

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
get_site_1	C/C++ Function	[F:\BANNER\C\SHRCATT.PC]	Use(select )
get_site_2	C/C++ Function	[F:\BANNER\C\SHRCATT.PC]	Use(select )
SLBEVNT	SYNONYM	S4B70.PUBLIC	Rely on ()
GTVSYSI	TABLE	S4B70."GENERAL"	Join
SPRIDEN	TABLE	S4B70.SATURN	Join
AG_EVENT	VIEW	S4B70.BANINST1	Use(select )
GEVEVN2	VIEW	S4B70.BANINST1	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GEISUBJ.KEY_BLOCK.EVENT_CRN	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GEAATTD.KEY_BLOCK.EVENT_CRN	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GEIATTD.ATTENDEE_INQUIRY.QUERY_EVENT	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GEAFCOM.KEY_BLOCK.EVENT_CRN	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GEATASK.KEY_BLOCK.EVENT_CRN	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GEAATTD.KEY_BLOCK.EVENT_CRN	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GEATASK.KEY_BLOCK.EVENT_CRN	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GEAFCOM.KEY_BLOCK.EVENT_CRN	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GEISUBJ.KEY_BLOCK.EVENT_CRN	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GEIATTD.ATTENDEE_INQUIRY.QUERY_EVENT	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.AEAAFIL.KEY_BLOCK.EVENT_CRN	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GEAPART.KEY_BLOCK.EVENT_CRN	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GEAPART.KEY_BLOCK.EVENT_CRN	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GEAATID.KEY_BLOCK.EVENT_CRN	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GEAATID.KEY_BLOCK.EVENT_CRN	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.AEAAFIL.KEY_BLOCK.EVENT_CRN	Use(select )
CHECK_SLBEVNT	Forms Trigger	BANNER7_FORMS.SLAEVNT	Use(select )
CHECK_SLBEVNT	Forms Trigger	BANNER7_FORMS_10G.SLAEVNT	Use(select )
FILLEVENT	Forms Trigger	BANNER7_FORMS.SHACATQ	Use(select )
FILLEVENT	Forms Trigger	BANNER7_FORMS_10G.SHACATQ	Use(select )
VALIDATE_CRN	Forms Trigger	BANNER7_FORMS.GEIFUNC	Use(select )
VALIDATE_CRN	Forms Trigger	BANNER7_FORMS_10G.GEIFUNC	Use(select )
VALIDATE_CRN	Forms Trigger	BANNER7_FORMS.GEAFUNC	Use(select )
VALIDATE_CRN	Forms Trigger	BANNER7_FORMS_10G.SLAEVNT	Use(select )
VALIDATE_CRN	Forms Trigger	BANNER7_FORMS.SLAEVNT	Use(select )
VALIDATE_CRN	Forms Trigger	BANNER7_FORMS_10G.GEAFUNC	Use(select )
FIND_DATES	Forms Trigger	BANNER7_FORMS.GEAFUNC.SSRMEET	Use(select )
FIND_DATES	Forms Trigger	BANNER7_FORMS_10G.SLAEVNT.SSRMEET	Use(select )
FIND_DATES	Forms Trigger	BANNER7_FORMS_10G.GEAFUNC.SSRMEET	Use(select )
FIND_DATES	Forms Trigger	BANNER7_FORMS.SLAEVNT.SSRMEET	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.GEIIDFN.GERATTD	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.GEIIDFN.GERPART	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.GEIIDFN.GERATTD	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.SHACRMQ.SHBCRMY	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.SHACRMQ.SHBCRMY	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.GEIIDFN.GERPART	Use(select )
SELECT_SLBEVNT_2	Forms Function	BANNER7_FORMS_10G.SHACRMY	Use(select )
SELECT_SLBEVNT_2	Forms Function	BANNER7_FORMS.SHACRMY	Use(select )
SELECT_SLBEVNT_3	Forms Function	BANNER7_FORMS_10G.SHACRMY	Use(select )
SELECT_SLBEVNT_3	Forms Function	BANNER7_FORMS.SHACRMY	Use(select )
SELECT_SLBEVNT_5	Forms Function	BANNER7_FORMS.SLAEVNT	Use(select )
SELECT_SLBEVNT_5	Forms Function	BANNER7_FORMS_10G.SLAEVNT	Use(select )
F_SLBEVNT_CRN_EXISTS	Package function	S4B70.BANINST1.GB_CLASSTIMES_RULES	Use(select )
F_SLBEVNT_CRN_EXISTS	Package function	S4B70.BANINST1.GB_CLASSTIMES_RULES	Rely on ()
UT_SETUP	Package procedure	S4B70.BANINST1.UT_GB_CLASSTIMES	Use(insert,select )
SLBEVNT	Forms DataBlock	BANNER7_FORMS.SLAEVNT	Rely on () Use(insert,update,delete,select )
SLBEVNT	Forms DataBlock	BANNER7_FORMS_10G.SLAEVNT	Rely on () Use(insert,update,delete,select )
SLBEVNT	Forms DataBlock	BANNER7_FORMS_10G.SLQEVNT	Rely on () Use(insert,update,delete,select )
SLBEVNT	Forms DataBlock	BANNER7_FORMS.SLQEVNT	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SLBEVNT	INDEX	S4B70.SATURN	Rely on ()
GTVDICD	TABLE	S4B70."GENERAL"	Refer( No Action )
STVSITE	TABLE	S4B70.SATURN	Join

Comments

Source Code Comments

Event Base Table

Columns Comments for SLBEVNT_CRN (1)

Source Code Comments

This field is the oneup number that identifies the event to the system

Columns Comments for SLBEVNT_ETYP_CODE (2)

Source Code Comments

This field defines type associated with the event

Columns Comments for SLBEVNT_DESC (3)

Source Code Comments

This field identifies the description of the event

Columns Comments for SLBEVNT_AGENCY_PIDM (4)

Source Code Comments

This field identifies the agency pidm associated with the event

Columns Comments for SLBEVNT_CONTACT_NAME (5)

Source Code Comments

This field identifies the name of the person to contact within the agency associated with the event

Columns Comments for SLBEVNT_CAMP_CODE (6)

Source Code Comments

This field identifies the campus that is associated with the event

Columns Comments for SLBEVNT_SITE_CODE (7)

Source Code Comments

This field identifies the site that is associated with the event

Columns Comments for SLBEVNT_COLL_CODE (8)

Source Code Comments

This field identifies the college that is associated with the event

Columns Comments for SLBEVNT_DEPT_CODE (9)

Source Code Comments

This field identifies the department that is associated with the event

Columns Comments for SLBEVNT_ACTIVITY_DATE (10)

Source Code Comments

This field identifies the date the record was created or last updated

Columns Comments for SLBEVNT_PHONE_AREA (11)

Source Code Comments

This field identifies the area code of the contact or agency associated with the event

Columns Comments for SLBEVNT_PHONE (12)

Source Code Comments

This field identifies the phone number of the contact or agency associated with the event

Columns Comments for SLBEVNT_PHONE_EXT (13)

Source Code Comments

This field identifies the phone extension number of the contact or agency associated with the event

Columns Comments for SLBEVNT_CONTACT_PIDM (14)

Source Code Comments

Internal Person Identification Number of the ID representing the Contact assigned to the event.

Columns Comments for SLBEVNT_ATYP_CODE (15)

Source Code Comments

Address type of the Contact assigned to the event. Only populated if Contact Pidm is not null.

Columns Comments for SLBEVNT_SYSI_CODE (16)

Source Code Comments

Code indicating the product that created the event.

Columns Comments for SLBEVNT_COMM_IND (17)

Source Code Comments

Committee/Service Indicator.

Columns Comments for SLBEVNT_DICD_CODE (18)

Source Code Comments

District/Division Code.

Table SLBRDEF

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SLBRDEF_BLDG_CODE	SLBRDEF_BLDG_CODE	VARCHAR2(6)	No	*	*
SLBRDEF_ROOM_NUMBER	SLBRDEF_ROOM_NUMBER	VARCHAR2(10)	No	*
SLBRDEF_ACTIVITY_DATE	SLBRDEF_ACTIVITY_DATE	DATE	No
SLBRDEF_DESC	SLBRDEF_DESC	VARCHAR2(50)	Yes
SLBRDEF_CAPACITY	SLBRDEF_CAPACITY	NUMBER(5,0)	No
SLBRDEF_MAXIMUM_CAPACITY	SLBRDEF_MAXIMUM_CAPACITY	NUMBER(5,0)	Yes
SLBRDEF_RMST_CODE	SLBRDEF_RMST_CODE	VARCHAR2(2)	Yes		*
SLBRDEF_RRCD_CODE	SLBRDEF_RRCD_CODE	VARCHAR2(4)	Yes
SLBRDEF_PRCD_CODE	SLBRDEF_PRCD_CODE	VARCHAR2(4)	Yes
SLBRDEF_UTILITY_RATE	SLBRDEF_UTILITY_RATE	NUMBER(7,2)	Yes
SLBRDEF_UTILITY_RATE_PERIOD	SLBRDEF_UTILITY_RATE_PERIOD	VARCHAR2(2)	Yes
SLBRDEF_PHONE_AREA	SLBRDEF_PHONE_AREA	VARCHAR2(3)	Yes
SLBRDEF_PHONE_NUMBER	SLBRDEF_PHONE_NUMBER	VARCHAR2(7)	Yes
SLBRDEF_PHONE_EXTENSION	SLBRDEF_PHONE_EXTENSION	VARCHAR2(4)	Yes
SLBRDEF_BCAT_CODE	SLBRDEF_BCAT_CODE	VARCHAR2(4)	Yes
SLBRDEF_SEX	SLBRDEF_SEX	VARCHAR2(1)	Yes
SLBRDEF_ROOM_TYPE	SLBRDEF_ROOM_TYPE	VARCHAR2(1)	No
SLBRDEF_PRIORITY	SLBRDEF_PRIORITY	VARCHAR2(8)	Yes
SLBRDEF_COLL_CODE	SLBRDEF_COLL_CODE	VARCHAR2(2)	Yes
SLBRDEF_DEPT_CODE	SLBRDEF_DEPT_CODE	VARCHAR2(4)	Yes
SLBRDEF_KEY_NUMBER	SLBRDEF_KEY_NUMBER	VARCHAR2(5)	Yes
SLBRDEF_WIDTH	SLBRDEF_WIDTH	NUMBER(6,2)	Yes
SLBRDEF_LENGTH	SLBRDEF_LENGTH	NUMBER(6,2)	Yes
SLBRDEF_AREA	SLBRDEF_AREA	NUMBER(10,2)	Yes
SLBRDEF_TERM_CODE_EFF	SLBRDEF_TERM_CODE_EFF	VARCHAR2(6)	No	*
SLBRDEF_PARS_CODE	SLBRDEF_PARS_CODE	VARCHAR2(7)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLBRDEF_PARS_CODE	GTVPARS_CODE	GTVPARS
SLBRDEF_RMST_CODE	STVRMST_CODE	STVRMST
SLBRDEF_BLDG_CODE	SLBBLDG_BLDG_CODE	SLBBLDG

Index

Index Name	Index Type	Column Name
PK_SLBRDEF	Unique	SLBRDEF_BLDG_CODE
PK_SLBRDEF	Unique	SLBRDEF_ROOM_NUMBER
PK_SLBRDEF	Unique	SLBRDEF_TERM_CODE_EFF

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
find_bldg_room	C/C++ Function	[F:\BANNER\C\SSRSCUP.PC]	Use(select )
BAA3	Cobol Paragraph	[F:\banner\cobol].SLRSCHE.AAA	Use(select )
check_room	C/C++ Function	[F:\BANNER\C\SLRROLL.PC]	Use(select )
create_roomsFile	C/C++ Function	[F:\BANNER\C\SSRSCRM.PC]	Use(select )
ins_rasg	C/C++ Function	[F:\BANNER\C\SLRSCHD.PC]	Use(select )
selid	C/C++ Function	[F:\BANNER\C\SLRHLST.PC]	Use(select )
selid_nopop	C/C++ Function	[F:\BANNER\C\SLRHLST.PC]	Use(select )
selname	C/C++ Function	[F:\BANNER\C\SLRDADD.PC]	Use(select )
selname	C/C++ Function	[F:\BANNER\C\SLRHLST.PC]	Use(select )
selroom	C/C++ Function	[F:\BANNER\C\SLRHLST.PC]	Use(select )
selroom_nopop	C/C++ Function	[F:\BANNER\C\SLRHLST.PC]	Use(select )
update_work_table	C/C++ Function	[F:\BANNER\C\SSRSCRM.PC]	Use(select )
SLRSCHE	Cobol Program	F:\banner\cobol	Use()
SLRRASG	TABLE	S4B70.SATURN	Join
AS_ROOM_ASSIGNMENT	VIEW	S4B70.BANINST1	Use(select )
ROVRASG	VIEW	S4B70.BANINST1	Use(select )
SLVRES2	VIEW	S4B70.BANINST1	Use(select )
SLVRSM2	VIEW	S4B70.BANINST1	Use(select )
CHECK_ROOM	Forms Trigger	BANNER7_FORMS.SSASECT.SSRMEET.SSRMEET_BLDG_CODE	Use(select )
CHECK_ROOM	Forms Trigger	BANNER7_FORMS_10G.SSASECT.SSRMEET.SSRMEET_BLDG_CODE	Use(select )
CHECK_ROOM	Forms Trigger	BANNER7_FORMS.SSASCHW.SSTSCHW.SSTSCHW_BLDG_CODE	Use(select )
KEY-CQUERY	Forms Trigger	BANNER7_FORMS.SLARASG.SLRRASG.SLRRASG_ROOM_NUMBER	Use(select )
KEY-CQUERY	Forms Trigger	BANNER7_FORMS_10G.SLARASG.SLRRASG.SLRRASG_ROOM_NUMBER	Use(select )
POST-CHANGE