Model Location Management*

Model Label : Location Management SL% tables and some support tables

List of Objects

Object Name	Object Type	Layer Name
PK_SLBBLDG	SQL Index	Default
PK_SLBEVNT	SQL Index	Default
PK_SLBRMAP	SQL Index	Default
PK_SLBRMPF	SQL Index	Default
PK_SLBTERM	SQL Index	Default
PK_SLRASCD	SQL Index	Default
PK_SLRBCAT	SQL Index	Default
PK_SLRBDEF	SQL Index	Default
PK_SLRCMNT	SQL Index	Default
PK_SLRCOLC	SQL Index	Default
PK_SLRCOLR	SQL Index	Default
PK_SLRMSCD	SQL Index	Default
PK_SLRPSCD	SQL Index	Default
PK_SLRRDEF	SQL Index	Default
PK_SLRRMAT	SQL Index	Default
PK_SLRRMDF	SQL Index	Default
SLBBLDG	SQL Table	Default
SLBEVNT	SQL Table	Default
SLBRMAP	SQL Table	Default
SLBRMPF	SQL Table	Default
SLBTERM	SQL Table	Default
SLRASCD	SQL Table	Default
SLRBCAT	SQL Table	Default
SLRBCMT	SQL Table	Default
SLRBDEF	SQL Table	Default
SLRCMNT	SQL Table	Default
SLRCOLC	SQL Table	Default
SLRCOLR	SQL Table	Default
SLRDCOL	SQL Table	Default
SLRECMT	SQL Table	Default
SLRLMFE	SQL Table	Default
SLRMASG	SQL Table	Default
SLRMFCR	SQL Table	Default
SLRMSCD	SQL Table	Default
SLRPASG	SQL Table	Default
SLRPFCR	SQL Table	Default
SLRPREQ	SQL Table	Default
SLRPSCD	SQL Table	Default
SLRRASG	SQL Table	Default
SLRRDEF	SQL Table	Default
SLRRFCR	SQL Table	Default
SLRRMAT	SQL Table	Default
SLRRMDF	SQL Table	Default
SLRRUSE	SQL Table	Default
SLRTASG	SQL Table	Default
SLTFTRN	SQL Table	Default

Model View

Index PK_SLBBLDG

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SLBBLDG_BLDG_CODE	VARCHAR2	6	0

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SLBBLDG

Object Dates

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

Index PK_SLBEVNT

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SLBEVNT_CRN	VARCHAR2	5	0

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SLBEVNT

Object Dates

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

Index PK_SLBRMAP

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SLBRMAP_PIDM	NUMBER	8	8
SLBRMAP_FROM_TERM	VARCHAR2	6	0

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SLBRMAP

Object Dates

Creation Date	Analysis Date
04/02/2008 20:51:24:000	04/02/2008 20:51:24:000

Index PK_SLBRMPF

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SLBRMPF_TERM_CODE	VARCHAR2	6	0
SLBRMPF_ONEUP	VARCHAR2	5	0

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SLBRMPF

Object Dates

Creation Date	Analysis Date
04/02/2008 20:53:31:000	04/02/2008 20:53:31:000

Index PK_SLBTERM

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SLBTERM_TERM_CODE	VARCHAR2	6	0

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SLBTERM

Object Dates

Creation Date	Analysis Date
04/02/2008 20:43:59:000	04/02/2008 20:43:59:000

Index PK_SLRASCD

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SLRASCD_TERM_CODE	VARCHAR2	6	0
SLRASCD_ASCD_CODE	VARCHAR2	2	0

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SLRASCD

Object Dates

Creation Date	Analysis Date
04/02/2008 20:43:01:000	04/02/2008 20:43:01:000

Index PK_SLRBCAT

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SLRBCAT_BLDG_CODE	VARCHAR2	6	0
SLRBCAT_CODE	VARCHAR2	4	0

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SLRBCAT

Object Dates

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

Index PK_SLRBDEF

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SLRBDEF_BLDG_CODE	VARCHAR2	6	0
SLRBDEF_RDEF_CODE	VARCHAR2	5	0

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SLRBDEF

Object Dates

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

Index PK_SLRCMNT

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SLRCMNT_BLDG_CODE	VARCHAR2	6	0
SLRCMNT_ROOM_NUMBER	VARCHAR2	10	0
SLRCMNT_TERM_CODE_EFF	VARCHAR2	6	0
SLRCMNT_SEQNO	NUMBER	23	23

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SLRCMNT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:43:51:000	04/02/2008 20:43:51:000

Index PK_SLRCOLC

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SLRCOLC_SESSIONID	VARCHAR2	30	0
SLRCOLC_RDEF_CODE	VARCHAR2	4	0

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SLRCOLC

Object Dates

Creation Date	Analysis Date
04/02/2008 20:52:39:000	04/02/2008 20:52:39:000

Index PK_SLRCOLR

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

Index Columns information

Column Name	Column Type	Column Length
SLRCOLR_SESSIONID	VARCHAR2	30
SLRCOLR_TERM_CODE	VARCHAR2	6
SLRCOLR_PIDM	VARCHAR2	8

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SLRCOLR

Object Dates

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

Index PK_SLRMSCD

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SLRMSCD_TERM_CODE	VARCHAR2	6	0
SLRMSCD_MSCD_CODE	VARCHAR2	2	0

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SLRMSCD

Object Dates

Creation Date	Analysis Date
04/02/2008 21:05:31:000	04/02/2008 21:05:31:000

Index PK_SLRPSCD

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SLRPSCD_TERM_CODE	VARCHAR2	6	0
SLRPSCD_PSCD_CODE	VARCHAR2	2	0

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SLRPSCD

Object Dates

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

Index PK_SLRRDEF

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

Index Columns information

Column Name	Column Type	Column Length
SLRRDEF_BLDG_CODE	VARCHAR2	6
SLRRDEF_ROOM_NUMBER	VARCHAR2	10
SLRRDEF_TERM_CODE_EFF	VARCHAR2	6
SLRRDEF_RDEF_CODE	VARCHAR2	4

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SLRRDEF

Object Dates

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

Index PK_SLRRMAT

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SLRRMAT_TERM_CODE	VARCHAR2	6	0
SLRRMAT_ONEUP	VARCHAR2	5	0
SLRRMAT_PIDM	NUMBER	8	8

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SLRRMAT

Object Dates

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

Index PK_SLRRMDF

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

Index Columns information

Column Name	Column Type	Column Length
SLRRMDF_TERM_CODE	VARCHAR2	6
SLRRMDF_ONEUP	VARCHAR2	5
SLRRMDF_RDEF_CODE	VARCHAR2	4

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SLRRMDF

Object Dates

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

Table SLBBLDG

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLBBLDG_PARS_CODE	GTVPARS_CODE	GTVPARS
SLBBLDG_BLDG_CODE	STVBLDG_CODE	STVBLDG
SLBBLDG_BLDG_CODE	SLBRMPF_BLDG_CODE	SLBRMPF
SLBBLDG_CAMP_CODE	SLBRMPF_CAMP_CODE	SLBRMPF

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
GORSDAV	SQL Table	S10B80.GENERAL	Join
SLBRDEF	SQL Table	S10B80.SATURN	Join
SLRRASG	SQL Table	S10B80.SATURN	Join
SSRMEET	SQL Table	S10B80.SATURN	Join
SLBBLDG_ADD	SQL View	S10B80.BANINST1	Use (select)
SLBBLDG_ADS	SQL View	S10B80.BANINST1	Use (select)
SLVRUSE	SQL View	S10B80.BANINST1	Use (select)
SSVMEET	SQL View	S10B80.BANINST1	Use (select)
F_GET_MULT_SLBBLDG_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SLBBLDG_ROWID	SQL Function	S10B80.BANINST1	Use (select)
BLDGDEFINITION_REC	Oracle Package Type	S10B80.BANINST1.GB_BLDGDEFINITION	Rely On
GT_SLBBLDG	Oracle Package Type	S10B80.BANINST1.SLKSELS	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_BLDGDEFINITION	Rely On
F_BUILD_SLBBLDG_REC	Oracle Package Function	S10B80.BANINST1.GB_BLDGDEFINITION	Rely On
P_CHECK_COMBINATIONS	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_BLDGDEFINITION	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SLBBLDG	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_BLDGDEFINITION	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SLBBLDG	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_BLDGDEFINITION	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_BLDGDEFINITION	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_BLDGDEFINITION_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SLBBLDG	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_BLDGDEFINITION	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_BLDGDEFINITION_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_BLDGDEFINITION	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_BLDGDEFINITION	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ROOMPREFERENCE	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ROOMMATE	Use (select)
UT_TEARDOWN	Oracle Package Procedure	S10B80.BANINST1.UT_SB_BLDGDEFINITION	Use (delete)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_BLDGDEFINITION	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_BLDGDEFINITION	Use (select)
F_GET_MUL_SLBBLDG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKSELS	Rely On
F_GET_MUL_SLBBLDG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKSELS	Use (select)
F_GET_MUL_SLBBLDG_VALUE	Oracle Package Function	S10B80.BANINST1.SLVSELS	Rely On
F_GET_MUL_SLBBLDG_VALUE	Oracle Package Function	S10B80.BANINST1.SLVSELS	Use (select)Rely On
F_GET_MUL_SLBBLDG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKRESS	Rely On
F_GET_MUL_SLBBLDG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKRESS	Use (select)Rely On
F_GET_RATE	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_BLDGDEFINITION	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_BLDGDEFINITION	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_BLDGDEFINITION	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_BLDGDEFINITION	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_BLDGDEFINITION	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_BLDGDEFINITION	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_BLDGDEFINITION	Use (select)
SLBBLDG	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SLBBLDG	SQL Index	S10B80.SATURN	Rely On
GTVPARS	SQL Table	S10B80.GENERAL	Refer (no action)
SLBRMPF	SQL Table	S10B80.SATURN	Join
STVBLDG	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLBBLDG

Object Dates

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

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

Columns Comments for SLBBLDG_CTRY_CODE_PHONE (# 26)

Source Code Comments

COUNTRY CODE: Telephone code that designates the region and country.

Columns Comments for SLBBLDG_HOUSE_NUMBER (# 27)

Source Code Comments

HOUSE NUMBER: Building or lot number on a street or in an area.

Columns Comments for SLBBLDG_STREET_LINE4 (# 28)

Source Code Comments

STREET LINE 4: This column identifies the fourth street line of the address of the building

Table SLBEVNT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLBEVNT_DICD_CODE	GTVDICD_CODE	GTVDICD

Index

Index Name	Index Type	Column Name
PK_SLBEVNT	Unique	SLBEVNT_CRN

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GEBFUNC	SQL Table	S10B80.GENERAL	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
GEVEVN2	SQL View	S10B80.BANINST1	Use (select)
F_SLBEVNT_CRN_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CLASSTIMES_RULES	Rely On
F_SLBEVNT_CRN_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_CLASSTIMES_RULES	Use (select)
SLBEVNT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SLBEVNT	SQL Index	S10B80.SATURN	Rely On
GTVDICD	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLBEVNT

Object Dates

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

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.

Columns Comments for SLBEVNT_CTRY_CODE_PHONE (# 19)

Source Code Comments

COUNTRY CODE: Telephone code that designates the region and country.

Table SLBRMAP

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SLBRMAP_PIDM	NUMBER(8,0)	No	*	*
SLBRMAP_ACTIVITY_DATE	DATE	No
SLBRMAP_ARTP_CODE	VARCHAR2(4)	No		*
SLBRMAP_FROM_TERM	VARCHAR2(6)	No	*	*
SLBRMAP_TO_TERM	VARCHAR2(6)	No		*
SLBRMAP_APPL_PRIORITY	VARCHAR2(8)	Yes
SLBRMAP_PREFERED_BUILDING	VARCHAR2(6)	Yes		*
SLBRMAP_PREFERED_ROOM	VARCHAR2(10)	Yes
SLBRMAP_PREFERED_BCAT_CODE	VARCHAR2(4)	Yes		*
SLBRMAP_PREFERED_CAMP_CODE	VARCHAR2(3)	Yes		*
SLBRMAP_MRCD_CODE	VARCHAR2(4)	Yes		*
SLBRMAP_PR_PIDM	NUMBER(8,0)	Yes
SLBRMAP_CONFID_IND	VARCHAR2(1)	Yes
SLBRMAP_HAPS_CODE	VARCHAR2(2)	Yes		*
SLBRMAP_HAPS_DATE	DATE	Yes
SLBRMAP_ADD_DATE	DATE	Yes
SLBRMAP_DATA_ORIGIN	VARCHAR2(30)	Yes
SLBRMAP_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLBRMAP_ARTP_CODE	STVARTP_CODE	STVARTP
SLBRMAP_PREFERED_BUILDING	SLRBCAT_BLDG_CODE	SLRBCAT
SLBRMAP_PREFERED_BCAT_CODE	SLRBCAT_CODE	SLRBCAT
SLBRMAP_HAPS_CODE	STVHAPS_CODE	STVHAPS
SLBRMAP_PREFERED_CAMP_CODE	STVCAMP_CODE	STVCAMP
SLBRMAP_MRCD_CODE	STVMRCD_CODE	STVMRCD
SLBRMAP_TO_TERM	STVTERM_CODE	STVTERM
SLBRMAP_FROM_TERM	STVTERM_CODE	STVTERM
SLBRMAP_PIDM	SLRRMAT_PIDM	SLRRMAT
SLBRMAP_FROM_TERM	SLRRMAT_TERM_CODE	SLRRMAT

Index

Index Name	Index Type	Column Name
PK_SLBRMAP	Unique	SLBRMAP_PIDM
PK_SLBRMAP	Unique	SLBRMAP_FROM_TERM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLVRES2	SQL View	S10B80.BANINST1	Use (select)
SLVRES2_M	SQL View	S10B80.BANINST1	Use (select)
SLVRES3	SQL View	S10B80.BANINST1	Join
SLVRES3	SQL View	S10B80.BANINST1	Use (select)
SLVRMAT	SQL View	S10B80.BANINST1	Use (select)
SLVRSM2	SQL View	S10B80.BANINST1	Use (select)
F_STUDENT_HOUSING_IND	SQL Function	S10B80.BANINST1	Use (select)
ROOMPREFERENCE_REC	Oracle Package Type	S10B80.BANINST1.SB_ROOMPREFERENCE	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE	Rely On
F_BUILD_SLBRMAP_REC	Oracle Package Function	S10B80.BANINST1.SB_ROOMPREFERENCE	Rely On
P_CHECK_ASSIGNMENTS	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Use (select)
P_CHECK_COMBINATIONS	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_MEALASSIGNMENT	Use (select)
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SLBRMAP	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SLBRMAP	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SLBRMAP	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PHONEASSIGNMENT_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_MEALASSIGNMENT_RULES	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_MEALASSIGNMENT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_PHONEASSIGNMENT	Use (Insert,select)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_ROOMPREFERENCE	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_ROOMPREFERENCE	Use (select)
F_PARENT_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_ROOMPREFERENCE	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_ROOMPREFERENCE	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.SB_ROOMPREFERENCE	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_ROOMPREFERENCE	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_ROOMPREFERENCE	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_ROOMPREFERENCE	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_ROOMPREFERENCE	Use (select)
SLBRMAP	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SLBRMAP	SQL Index	S10B80.SATURN	Rely On
SLRBCAT	SQL Table	S10B80.SATURN	Refer (no action)
SLRRMAT	SQL Table	S10B80.SATURN	Join
STVARTP	SQL Table	S10B80.SATURN	Refer (no action)
STVCAMP	SQL Table	S10B80.SATURN	Refer (no action)
STVHAPS	SQL Table	S10B80.SATURN	Refer (no action)
STVMRCD	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLBRMAP

Object Dates

Creation Date	Analysis Date
04/02/2008 20:51:23:000	04/02/2008 21:18:13:000

Source Code Comments

Room and Meal Application Table

Columns Comments for SLBRMAP_PIDM (# 1)

Source Code Comments

Internal identifier of room/meal applicant

Columns Comments for SLBRMAP_ACTIVITY_DATE (# 2)

Source Code Comments

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

Columns Comments for SLBRMAP_ARTP_CODE (# 3)

Source Code Comments

This field identifies the type of application

Columns Comments for SLBRMAP_FROM_TERM (# 4)

Source Code Comments

This field identifies the beginning term of the application

Columns Comments for SLBRMAP_TO_TERM (# 5)

Source Code Comments

This field identifies the end term of the application

Columns Comments for SLBRMAP_APPL_PRIORITY (# 6)

Source Code Comments

This field defines the priority of the application, this is order in which applications will be processed in the batch scheduler.

Columns Comments for SLBRMAP_PREFERED_BUILDING (# 7)

Source Code Comments

This field defines the applicants preferred building for housing

Columns Comments for SLBRMAP_PREFERED_ROOM (# 8)

Source Code Comments

This field defines the applicants preferred room for housing

Columns Comments for SLBRMAP_PREFERED_BCAT_CODE (# 9)

Source Code Comments

This field defines the applicants preferred category for housing

Columns Comments for SLBRMAP_PREFERED_CAMP_CODE (# 10)

Source Code Comments

This field defines the applicants preferred campus for housing

Columns Comments for SLBRMAP_MRCD_CODE (# 11)

Source Code Comments

This identifies the meal rate code associated with the meal assignment

Columns Comments for SLBRMAP_HAPS_CODE (# 14)

Source Code Comments

This field identifies the housing application status code associated with the applicant

Columns Comments for SLBRMAP_HAPS_DATE (# 15)

Source Code Comments

This field identifies the date when the housing application status code was last changed

Columns Comments for SLBRMAP_ADD_DATE (# 16)

Source Code Comments

This field identifies the date the application was added to the system

Columns Comments for SLBRMAP_DATA_ORIGIN (# 17)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SLBRMAP_USER_ID (# 18)

Source Code Comments

USER ID: User who inserted or last update the data

Table SLBRMPF

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SLBRMPF_TERM_CODE	VARCHAR2(6)	No	*	*
SLBRMPF_ONEUP	VARCHAR2(5)	No	*
SLBRMPF_CAMP_CODE	VARCHAR2(3)	Yes		*
SLBRMPF_BLDG_CODE	VARCHAR2(6)	Yes		*
SLBRMPF_BCAT_CODE	VARCHAR2(8)	Yes
SLBRMPF_ROOM_NUMBER	VARCHAR2(10)	Yes
SLBRMPF_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLBRMPF_BLDG_CODE	STVBLDG_CODE	STVBLDG
SLBRMPF_CAMP_CODE	STVCAMP_CODE	STVCAMP
SLBRMPF_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SLBRMPF	Unique	SLBRMPF_TERM_CODE
PK_SLBRMPF	Unique	SLBRMPF_ONEUP

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLBBLDG	SQL Table	S10B80.SATURN	Join
SLBRDEF	SQL Table	S10B80.SATURN	Join
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE	Use (delete,select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE_RULES	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ROOMMATE	Use (Insert,select)
SLBRMPF	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLBRMPF

Object Dates

Creation Date	Analysis Date
04/02/2008 20:53:31:000	04/02/2008 21:18:15:000

Source Code Comments

Roommate Preference Request Table

Columns Comments for SLBRMPF_TERM_CODE (# 1)

Source Code Comments

This field identifies the term code associated with the roommates preferences

Columns Comments for SLBRMPF_ONEUP (# 2)

Source Code Comments

This fields defines the roommate sequent number of the roommate preferences

Columns Comments for SLBRMPF_CAMP_CODE (# 3)

Source Code Comments

This field defines the roommate applicants preferred campus for housing

Columns Comments for SLBRMPF_BLDG_CODE (# 4)

Source Code Comments

This field defines the roommate applicants preferred building for housing

Columns Comments for SLBRMPF_BCAT_CODE (# 5)

Source Code Comments

This field defines the roommate applicants preferred category for housing

Columns Comments for SLBRMPF_ROOM_NUMBER (# 6)

Source Code Comments

This field defines the roommate applicants preferred room for housing

Columns Comments for SLBRMPF_ACTIVITY_DATE (# 7)

Source Code Comments

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

Table SLBTERM

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SLBTERM_TERM_CODE	VARCHAR2(6)	No	*	*
SLBTERM_ACTIVITY_DATE	DATE	No
SLBTERM_HOUS_ALLOWED	VARCHAR2(1)	No
SLBTERM_FEE_ASSESSMENT	VARCHAR2(1)	No
SLBTERM_FEE_ASSESSMNT_EFF_DATE	DATE	Yes
SLBTERM_ONEUP	NUMBER(5,0)	Yes
SLBTERM_MNTH_CUTOFF	NUMBER(2,0)	Yes
SLBTERM_CUTOFF_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLBTERM_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SLBTERM	Unique	SLBTERM_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLRASCD	SQL Table	S10B80.SATURN	Refer (no action)
SLRLMFE	SQL Table	S10B80.SATURN	Refer (no action)
SLRMSCD	SQL Table	S10B80.SATURN	Refer (no action)
SLRPSCD	SQL Table	S10B80.SATURN	Refer (no action)
P_CREATE_ROOM_MEAL_STATUS	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert,select)
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE	Use (update,select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PHONEASSIGNMENT_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_MEALASSIGNMENT_RULES	Use (select)
P_VIEWACCTTERM	Oracle Package Procedure	S10B80.BANINST1.BWSKOACC	Rely On
P_VR_PROCESS_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_MEALASSIGNMENT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ROOMPREFERENCE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_PHONEASSIGNMENT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ROOMMATE	Use (Insert,select)
F_GET_ACAD_PERIODS	Oracle Package Function	S10B80.BANINST1.SP_ACADEMIC_PERIOD	Rely On
F_GET_SLBTERM_ROW	Oracle Package Function	S10B80.BANINST1.SLKSELS	Rely On
F_GET_SLBTERM_ROW	Oracle Package Function	S10B80.BANINST1.SLKSELS	Use (select)Rely On
SLBTERM	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLBTERM

Object Dates

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

Source Code Comments

Location Management Term Control Table

Columns Comments for SLBTERM_TERM_CODE (# 1)

Source Code Comments

This field identifies the term of the control data

Columns Comments for SLBTERM_ACTIVITY_DATE (# 2)

Source Code Comments

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

Columns Comments for SLBTERM_HOUS_ALLOWED (# 3)

Source Code Comments

This field determines whether on-line housing assignments are allowed for the term

Columns Comments for SLBTERM_FEE_ASSESSMENT (# 4)

Source Code Comments

This field determines whether on-line fee assessment is allowed for the term

Columns Comments for SLBTERM_FEE_ASSESSMNT_EFF_DATE (# 5)

Source Code Comments

This field identifies the default effective date for the term fee assessment

Columns Comments for SLBTERM_ONEUP (# 6)

Source Code Comments

This field defines the next roommate sequence number for the term

Columns Comments for SLBTERM_MNTH_CUTOFF (# 7)

Source Code Comments

Number of Occupied Days for Full Monthly Liability

Columns Comments for SLBTERM_CUTOFF_DATE (# 8)

Source Code Comments

Last date calculated charges are considered original

Table SLRASCD

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SLRASCD_TERM_CODE	VARCHAR2(6)	No	*	*
SLRASCD_ASCD_CODE	VARCHAR2(2)	No	*	*
SLRASCD_START_DATE	DATE	Yes
SLRASCD_END_DATE	DATE	Yes
SLRASCD_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLRASCD_ASCD_CODE	STVASCD_CODE	STVASCD
SLRASCD_TERM_CODE	SLBTERM_TERM_CODE	SLBTERM
SLRASCD_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SLRASCD	Unique	SLRASCD_TERM_CODE
PK_SLRASCD	Unique	SLRASCD_ASCD_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLRRFCR	SQL Table	S10B80.SATURN	Refer (no action)
P_CREATE_ROOM_MEAL_STATUS	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert,select)
P_VALID_STAT_DATE	Oracle Package Procedure	S10B80.BANINST1.SOKPVAL	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ROOMPREFERENCE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (Insert,select)
SLRASCD	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SLRASCD	SQL Index	S10B80.SATURN	Rely On
SLBTERM	SQL Table	S10B80.SATURN	Refer (no action)
STVASCD	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRASCD

Object Dates

Creation Date	Analysis Date
04/02/2008 20:43:01:000	04/02/2008 21:18:06:000

Source Code Comments

Room Status Table By Term

Columns Comments for SLRASCD_TERM_CODE (# 1)

Source Code Comments

This field identifies the term associated with the room status codes

Columns Comments for SLRASCD_ASCD_CODE (# 2)

Source Code Comments

This field defines the room status codes associated with the term

Columns Comments for SLRASCD_START_DATE (# 3)

Source Code Comments

This field defines the first date the room status code is valid

Columns Comments for SLRASCD_END_DATE (# 4)

Source Code Comments

This field defines the last date the room status code is valid

Columns Comments for SLRASCD_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table SLRBCAT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
SLRBCAT_BLDG_CODE	VARCHAR2(6)	No	*
SLRBCAT_CODE	VARCHAR2(4)	No	*
SLRBCAT_DESC	VARCHAR2(30)	No
SLRBCAT_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_SLRBCAT	Unique	SLRBCAT_BLDG_CODE
PK_SLRBCAT	Unique	SLRBCAT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLBRMAP	SQL Table	S10B80.SATURN	Refer (no action)
AS_RESIDENTIAL_LIFE	SQL View	S10B80.BANINST1	Use (select)
SLVRES1	SQL View	S10B80.BANINST1	Join
SLRBCAT_C	Oracle Package Cursor	S10B80.BANINST1.SOKLIBS	Rely On
SLRBCAT_C	Oracle Package Cursor	S10B80.BANINST1.SOKLIBS	Use (select)
SLRBCAT_C	Oracle Package Cursor	S10B80.BANINST1.SOKLIBS_OJ	Rely On
SLRBCAT_C	Oracle Package Cursor	S10B80.BANINST1.SOKLIBS_OJ	Use (select)
P_CHECK_COMBINATIONS	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Rely On
P_CHECK_COMBINATIONS	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_BLDGDEFINITION	Use (delete,select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_ROOMDEFINITION_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_ROOMDEFINITION	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ROOMPREFERENCE	Use (select)
F_GET_BCAT_DESC	Oracle Package Function	S10B80.BANINST1.SOKLIBS	Rely On
F_GET_BCAT_DESC	Oracle Package Function	S10B80.BANINST1.SOKLIBS_OJ	Rely On
F_PARENT_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Use (select)
SLRBCAT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SLRBCAT	SQL Index	S10B80.SATURN	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRBCAT

Object Dates

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

Source Code Comments

Room Catagory Definition Table

Columns Comments for SLRBCAT_BLDG_CODE (# 1)

Source Code Comments

This field identifies the building code associated with the category code

Columns Comments for SLRBCAT_CODE (# 2)

Source Code Comments

This field defines code used to define the category

Columns Comments for SLRBCAT_DESC (# 3)

Source Code Comments

This field identifies the description associated with the category code

Columns Comments for SLRBCAT_ACTIVITY_DATE (# 4)

Source Code Comments

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

Table SLRBCMT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
SLRBCMT_BLDG_CODE	VARCHAR2(6)	No
SLRBCMT_SEQNO	NUMBER(23,20)	No
SLRBCMT_COMMENTS	VARCHAR2(60)	No
SLRBCMT_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
SLRBCMT_KEY_INDEX		SLRBCMT_BLDG_CODE
SLRBCMT_KEY_INDEX		SLRBCMT_SEQNO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_BLDGDEFINITION	Use (delete,select)
SLRBCMT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLRBCMT_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRBCMT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:53:28:000	04/02/2008 21:18:15:000

Source Code Comments

Building Comments Table

Columns Comments for SLRBCMT_BLDG_CODE (# 1)

Source Code Comments

This field identifies the building code associated with the comments

Columns Comments for SLRBCMT_SEQNO (# 2)

Source Code Comments

This field is an internal number used to insure that the comments will display in proper order

Columns Comments for SLRBCMT_COMMENTS (# 3)

Source Code Comments

This field is where the comments for the building are stored

Columns Comments for SLRBCMT_ACTIVITY_DATE (# 4)

Source Code Comments

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

Table SLRBDEF

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
SLRBDEF_BLDG_CODE	VARCHAR2(6)	No	*
SLRBDEF_RDEF_CODE	VARCHAR2(5)	No	*
SLRBDEF_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_SLRBDEF	Unique	SLRBDEF_BLDG_CODE
PK_SLRBDEF	Unique	SLRBDEF_RDEF_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_ROOMDEFINITION	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_BLDGDEFINITION	Use (delete,select)
SLRBDEF	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SLRBDEF	SQL Index	S10B80.SATURN	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRBDEF

Object Dates

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

Source Code Comments

Building Attributes Definition Table

Columns Comments for SLRBDEF_BLDG_CODE (# 1)

Source Code Comments

This field identifies the building code associated with the attributes

Columns Comments for SLRBDEF_RDEF_CODE (# 2)

Source Code Comments

This field identifies the default attributes associated with rooms defined for the building

Columns Comments for SLRBDEF_ACTIVITY_DATE (# 3)

Source Code Comments

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

Table SLRCMNT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
SLRCMNT_BLDG_CODE	VARCHAR2(6)	No	*
SLRCMNT_ROOM_NUMBER	VARCHAR2(10)	No	*
SLRCMNT_COMMENTS	VARCHAR2(60)	No
SLRCMNT_SEQNO	NUMBER(23,20)	No	*
SLRCMNT_ACTIVITY_DATE	DATE	No
SLRCMNT_TERM_CODE_EFF	VARCHAR2(6)	No	*

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_SLRCMNT	Unique	SLRCMNT_BLDG_CODE
PK_SLRCMNT	Unique	SLRCMNT_ROOM_NUMBER
PK_SLRCMNT	Unique	SLRCMNT_TERM_CODE_EFF
PK_SLRCMNT	Unique	SLRCMNT_SEQNO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_ROOMDEFINITION	Use (delete,select)
SLRCMNT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SLRCMNT	SQL Index	S10B80.SATURN	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRCMNT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:43:51:000	04/02/2008 21:18:07:000

Source Code Comments

Building/Room Comments Table

Columns Comments for SLRCMNT_BLDG_CODE (# 1)

Source Code Comments

This field identifies the building code associated with the room comments

Columns Comments for SLRCMNT_ROOM_NUMBER (# 2)

Source Code Comments

This field identifies the room associated with the comments

Columns Comments for SLRCMNT_COMMENTS (# 3)

Source Code Comments

This field is where the comments for a room are stored

Columns Comments for SLRCMNT_SEQNO (# 4)

Source Code Comments

This field is an internal number used to insure that the comments will display in proper order

Columns Comments for SLRCMNT_ACTIVITY_DATE (# 5)

Source Code Comments

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

Columns Comments for SLRCMNT_TERM_CODE_EFF (# 6)

Source Code Comments

Term code effective date.

Table SLRCOLC

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SLRCOLC_SESSIONID		VARCHAR2(30)	No	*
SLRCOLC_RDEF_CODE		VARCHAR2(4)	No	*

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_SLRCOLC	Unique	SLRCOLC_SESSIONID
PK_SLRCOLC	Unique	SLRCOLC_RDEF_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SLRCOLC	SQL Index	S10B80.SATURN	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRCOLC

Object Dates

Creation Date	Analysis Date
04/02/2008 20:52:39:000	04/02/2008 21:18:14:000

Source Code Comments

Room Attributes Collector Table

Columns Comments for SLRCOLC_SESSIONID (# 1)

Source Code Comments

This field identifies the sessionid associated with the attributes

Columns Comments for SLRCOLC_RDEF_CODE (# 2)

Source Code Comments

This field identifies the attributes which are stored and used in the available room query forms in the location management module

Table SLRCOLR

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SLRCOLR_SESSIONID	VARCHAR2(30)	No	*
SLRCOLR_TERM_CODE	VARCHAR2(6)	No	*	*
SLRCOLR_PIDM	VARCHAR2(8)	No	*
SLRCOLR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLRCOLR_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SLRCOLR	Unique	SLRCOLR_SESSIONID
PK_SLRCOLR	Unique	SLRCOLR_TERM_CODE
PK_SLRCOLR	Unique	SLRCOLR_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLVCOLR	SQL View	S10B80.BANINST1	Use (select)
SLVMNTH	SQL View	S10B80.BANINST1	Use (select)
P_INSERT_SLRCOLR	Oracle Package Procedure	S10B80.BANINST1.SLKMODS	Use (Insert)Rely On
P_UPDATE_SLRCOLR	Oracle Package Procedure	S10B80.BANINST1.SLKMODS	Use (update)Rely On
P_VIEWACCTTERM	Oracle Package Procedure	S10B80.BANINST1.BWSKOACC	Rely On
P_VR_PROCESS_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
F_GET_SLRCOLR_ROW	Oracle Package Function	S10B80.BANINST1.SLKSELS	Rely On
F_GET_SLRCOLR_ROW	Oracle Package Function	S10B80.BANINST1.SLKSELS	Use (select)Rely On
SLRCOLR	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRCOLR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:52:41:000	04/02/2008 21:18:14:000

Source Code Comments

Location Management Assessment View Collector Table

Columns Comments for SLRCOLR_SESSIONID (# 1)

Source Code Comments

This field identifies the sessionid associated with the fee assessment process in location management

Columns Comments for SLRCOLR_TERM_CODE (# 2)

Source Code Comments

This field identifies the term code associated with the fee assessment process in location management

Columns Comments for SLRCOLR_PIDM (# 3)

Source Code Comments

This field defines the internal identifier number of the person for whom the fee assessment is being processed

Columns Comments for SLRCOLR_ACTIVITY_DATE (# 4)

Source Code Comments

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

Table SLRDCOL

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SLRDCOL_SESSIONID	VARCHAR2(10)	No
SLRDCOL_PIDM	NUMBER(8,0)	No
SLRDCOL_RDEF_CODE	VARCHAR2(4)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLRDCOL_RDEF_CODE	STVRDEF_CODE	STVRDEF

Index

Index Name	Index Type	Column Name
SLRDCOL_KEY_INDEX	Unique	SLRDCOL_SESSIONID
SLRDCOL_KEY_INDEX	Unique	SLRDCOL_PIDM
SLRDCOL_KEY_INDEX	Unique	SLRDCOL_RDEF_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRDCOL

Object Dates

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

Source Code Comments

Dorm Room Attributes Collector Table

Columns Comments for SLRDCOL_SESSIONID (# 1)

Source Code Comments

This field identifies the sessionid associated with the default attributes used in the dorm room look-up query form

Columns Comments for SLRDCOL_PIDM (# 2)

Source Code Comments

This field defines the internal identifier number of the person associated with the default attributes

Columns Comments for SLRDCOL_RDEF_CODE (# 3)

Source Code Comments

This field contains the person attributes used in the dorm room query look-up form

Table SLRECMT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
SLRECMT_CRN	VARCHAR2(6)	No
SLRECMT_SEQNO	NUMBER(23,20)	No
SLRECMT_COMMENTS	VARCHAR2(60)	No
SLRECMT_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
SLRECMT_KEY_INDEX		SLRECMT_CRN
SLRECMT_KEY_INDEX		SLRECMT_SEQNO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLRECMT_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRECMT

Object Dates

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

Source Code Comments

Events Comments Table

Columns Comments for SLRECMT_CRN (# 1)

Source Code Comments

This field is the internal identifier of the event associated with the comments

Columns Comments for SLRECMT_SEQNO (# 2)

Source Code Comments

This field is an internal number used to insure that the comments will display in proper order

Columns Comments for SLRECMT_COMMENTS (# 3)

Source Code Comments

This field is where the comments for an event are stored

Columns Comments for SLRECMT_ACTIVITY_DATE (# 4)

Source Code Comments

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

Table SLRLMFE

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SLRLMFE_TERM_CODE	VARCHAR2(6)	No	*
SLRLMFE_RATE_CODE	VARCHAR2(4)	No	*
SLRLMFE_M_D_T	VARCHAR2(1)	No
SLRLMFE_DETAIL_CODE	VARCHAR2(4)	No
SLRLMFE_BASE_RATE	NUMBER(9,4)	No
SLRLMFE_MIN_CHARGE	NUMBER(7,2)	No
SLRLMFE_MAX_CHARGE	NUMBER(7,2)	No
SLRLMFE_TYPE	VARCHAR2(7)	No
SLRLMFE_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLRLMFE_TERM_CODE	SLBTERM_TERM_CODE	SLBTERM
SLRLMFE_TERM_CODE	STVTERM_CODE	STVTERM
SLRLMFE_RATE_CODE	SLRRASG_RRCD_CODE	SLRRASG
SLRLMFE_RATE_CODE	SLRMASG_MRCD_CODE	SLRMASG
SLRLMFE_RATE_CODE	SLRPASG_PRCD_CODE	SLRPASG
SLRLMFE_RATE_CODE	STVPRCD_CODE	STVPRCD
SLRLMFE_RATE_CODE	STVMRCD_CODE	STVMRCD

Index

Index Name	Index Type	Column Name
SLRLMFE_KEY_INDEX		SLRLMFE_TERM_CODE
SLRLMFE_KEY_INDEX		SLRLMFE_TYPE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLVCOLR	SQL View	S10B80.BANINST1	Join
SLVMREF	SQL View	S10B80.BANINST1	Use (select)
SLVPREF	SQL View	S10B80.BANINST1	Use (select)
SLVPREF_EXP	SQL View	S10B80.BANINST1	Use (select)
SLVRREF	SQL View	S10B80.BANINST1	Use (select)
SLVRREF_OJ	SQL View	S10B80.BANINST1	Use (select)
P_BUILDING	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert,select)
P_CALC_DAYS_MONTHS_TERMS	Oracle Package Procedure	S10B80.BANINST1.SB_PHONEASSIGNMENT	Use (select)
P_CALC_DAYS_MONTHS_TERMS	Oracle Package Procedure	S10B80.BANINST1.SB_MEALASSIGNMENT	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_MEALASSIGNMENT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ROOMPREFERENCE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_PHONEASSIGNMENT	Use (Insert,select)
SLRLMFE	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLRLMFE_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
SLBTERM	SQL Table	S10B80.SATURN	Refer (no action)
SLRMASG	SQL Table	S10B80.SATURN	Join
SLRPASG	SQL Table	S10B80.SATURN	Join
SLRRASG	SQL Table	S10B80.SATURN	Join
STVMRCD	SQL Table	S10B80.SATURN	Join
STVPRCD	SQL Table	S10B80.SATURN	Join
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRLMFE

Object Dates

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

Source Code Comments

Housing/Meal/Phone Rate Code Rules Table

Columns Comments for SLRLMFE_TERM_CODE (# 1)

Source Code Comments

This field defines the term for which you are creating assessment rules

Columns Comments for SLRLMFE_RATE_CODE (# 2)

Source Code Comments

This field is the rate code which corresponds to the assignment

Columns Comments for SLRLMFE_M_D_T (# 3)

Source Code Comments

This field indicates if the rate code is applied on a monthly, daily or termly basis

Columns Comments for SLRLMFE_DETAIL_CODE (# 4)

Source Code Comments

This field contains the detail code used when creating assessments

Columns Comments for SLRLMFE_BASE_RATE (# 5)

Source Code Comments

This field contains the base rate (multiplier) used in the assessment

Columns Comments for SLRLMFE_MIN_CHARGE (# 6)

Source Code Comments

This field contains the minimum charge which will be assessed for this rule

Columns Comments for SLRLMFE_MAX_CHARGE (# 7)

Source Code Comments

This field contains the maximum charge which may be assessed for this rule

Columns Comments for SLRLMFE_TYPE (# 8)

Source Code Comments

This is a system maintained field indicating if this is a room, meal or phone rule

Columns Comments for SLRLMFE_ACTIVITY_DATE (# 9)

Source Code Comments

This is a system maintained field which contains the date this row was added or last modified

Table SLRMASG

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SLRMASG_PIDM	NUMBER(8,0)	No
SLRMASG_TERM_CODE	VARCHAR2(6)	No	*
SLRMASG_MRCD_CODE	VARCHAR2(4)	No	*
SLRMASG_BEGIN_DATE	DATE	No
SLRMASG_END_DATE	DATE	No
SLRMASG_TOTAL_DAYS	NUMBER(9,5)	No
SLRMASG_TOTAL_MONTHS	NUMBER(7,5)	No
SLRMASG_TOTAL_TERMS	NUMBER(7,5)	No
SLRMASG_MSCD_CODE	VARCHAR2(2)	No	*
SLRMASG_MSCD_DATE	DATE	No
SLRMASG_ONL_OR_BAT	VARCHAR2(1)	No
SLRMASG_ACTIVITY_DATE	DATE	No
SLRMASG_AR_IND	VARCHAR2(1)	No
SLRMASG_ROLL_IND	VARCHAR2(1)	Yes
SLRMASG_ASSESS_NEEDED	VARCHAR2(1)	No
SLRMASG_DATA_ORIGIN	VARCHAR2(30)	Yes
SLRMASG_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLRMASG_MRCD_CODE	STVMRCD_CODE	STVMRCD
SLRMASG_TERM_CODE	STVTERM_CODE	STVTERM
SLRMASG_MSCD_CODE	STVMSCD_CODE	STVMSCD

Index

Index Name	Index Type	Column Name
SLRMASG_KEY_INDEX		SLRMASG_PIDM
SLRMASG_KEY_INDEX		SLRMASG_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLRLMFE	SQL Table	S10B80.SATURN	Join
SLRMFCR	SQL Table	S10B80.SATURN	Join
ROVMASG	SQL View	S10B80.BANINST1	Use (select)
SLVCOLR	SQL View	S10B80.BANINST1	Join
SLVMREF	SQL View	S10B80.BANINST1	Use (select)
F_GET_MULT_SLRMASG_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SLRMASG_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_MEAL_THIS_TERM	SQL Function	S10B80.BANINST1	Use (select)
MEALASSIGNMENT_REC	Oracle Package Type	S10B80.BANINST1.SB_MEALASSIGNMENT	Rely On
GT_SLRMASG	Oracle Package Type	S10B80.BANINST1.SLKSELS	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.SB_MEALASSIGNMENT	Rely On
F_BUILD_SLRMASG_REC	Oracle Package Function	S10B80.BANINST1.SB_MEALASSIGNMENT	Rely On
P_ASSESS_MEAL	Oracle Package Procedure	S10B80.BANINST1.SFKMODS	Rely On
P_CALC_DAYS_MONTHS_TERMS	Oracle Package Procedure	S10B80.BANINST1.SB_MEALASSIGNMENT	Rely On
P_CHECK_ASSIGNMENTS	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Use (select)
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_PHONEASSIGNMENT	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_MEALASSIGNMENT	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_MEALASSIGNMENT	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SLRMASG	Use (delete)
P_FH_CREDITS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_GET_SLRMASG_ASSESS_DATA	Oracle Package Procedure	S10B80.BANINST1.SLKSELS	Rely On
P_GET_SLRMASG_ASSESS_DATA	Oracle Package Procedure	S10B80.BANINST1.SLKSELS	Use (select)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SLRMASG	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_MEALASSIGNMENT	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.SB_MEALASSIGNMENT_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PHONEASSIGNMENT	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_MEALASSIGNMENT	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SLRMASG	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE	Use (select)
P_UPDATE_SLRMASG_AR_IND	Oracle Package Procedure	S10B80.BANINST1.SLKMODS	Rely On
P_UPDATE_SLRMASG_ASSESS	Oracle Package Procedure	S10B80.BANINST1.SLKMODS	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_MEALASSIGNMENT_RULES	Rely On
P_VIEWACCTTERM	Oracle Package Procedure	S10B80.BANINST1.BWSKOACC	Rely On
P_VR_PROCESS_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_MEALASSIGNMENT	Use (select)
F_GET_MUL_SLRMASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKSELS	Rely On
F_GET_MUL_SLRMASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKSELS	Use (select)Rely On
F_GET_MUL_SLRMASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLVSELS	Rely On
F_GET_MUL_SLRMASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLVSELS	Use (select)Rely On
F_GET_MUL_SLRMASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKRESS	Rely On
F_GET_MUL_SLRMASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKRESS	Use (select)Rely On
F_HOUSINGASSIGNMENT	Oracle Package Function	S10B80.BANINST1.SLKWEVN	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_MEALASSIGNMENT	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_MEALASSIGNMENT	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.SB_MEALASSIGNMENT	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_MEALASSIGNMENT	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_MEALASSIGNMENT	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_MEALASSIGNMENT	Use (select)
SLRMASG	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLRMASG_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVMRCD	SQL Table	S10B80.SATURN	Refer (no action)
STVMSCD	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRMASG

Object Dates

Creation Date	Analysis Date
04/02/2008 20:54:12:000	04/02/2008 21:18:15:000

Source Code Comments

Meal Assignment Table

Columns Comments for SLRMASG_PIDM (# 1)

Source Code Comments

This field defines the internal identifier associated with the meal assignments

Columns Comments for SLRMASG_TERM_CODE (# 2)

Source Code Comments

This field defines the term code associated with the meal assignments

Columns Comments for SLRMASG_MRCD_CODE (# 3)

Source Code Comments

This field defines the meal plan code

Columns Comments for SLRMASG_BEGIN_DATE (# 4)

Source Code Comments

This field identifies the first day of the meal assignment

Columns Comments for SLRMASG_END_DATE (# 5)

Source Code Comments

This field identifies the last day of the meal assignment

Columns Comments for SLRMASG_TOTAL_DAYS (# 6)

Source Code Comments

This field identifies the total number of days of the meal assignment

Columns Comments for SLRMASG_TOTAL_MONTHS (# 7)

Source Code Comments

This field identifies the total number of months of the meal assignment

Columns Comments for SLRMASG_TOTAL_TERMS (# 8)

Source Code Comments

This field identifies the total number of terms of the meal assignment

Columns Comments for SLRMASG_MSCD_CODE (# 9)

Source Code Comments

This field identifies the meal plan status code of the meal assignment

Columns Comments for SLRMASG_MSCD_DATE (# 10)

Source Code Comments

This field defines the date the meal plan status code was last updated

Columns Comments for SLRMASG_ONL_OR_BAT (# 11)

Source Code Comments

This field identifies whether the meal assignment was created on-line or batch using the batch scheduler

Columns Comments for SLRMASG_ACTIVITY_DATE (# 12)

Source Code Comments

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

Columns Comments for SLRMASG_AR_IND (# 13)

Source Code Comments

This field identifies whether the meal assignment charges have been processed

Columns Comments for SLRMASG_ROLL_IND (# 14)

Source Code Comments

This field controls whether the meal assignment can be rolled using the roll forward process

Columns Comments for SLRMASG_ASSESS_NEEDED (# 15)

Source Code Comments

This field identifies whether fee assessment is needed for the meal assignment

Columns Comments for SLRMASG_DATA_ORIGIN (# 16)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SLRMASG_USER_ID (# 17)

Source Code Comments

USER ID: User who inserted or last update the data

Table SLRMFCR

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SLRMFCR_TERM_CODE	VARCHAR2(6)	No	*
SLRMFCR_MSCD_CODE	VARCHAR2(2)	No	*
SLRMFCR_FROM_DATE	DATE	Yes
SLRMFCR_TO_DATE	DATE	Yes
SLRMFCR_REFUND	NUMBER(3,0)	No
SLRMFCR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLRMFCR_TERM_CODE	STVTERM_CODE	STVTERM
SLRMFCR_TERM_CODE	SLRMASG_TERM_CODE	SLRMASG
SLRMFCR_MSCD_CODE	SLRMASG_MSCD_CODE	SLRMASG
SLRMFCR_MSCD_CODE	STVMSCD_CODE	STVMSCD
SLRMFCR_TERM_CODE	SLRMSCD_TERM_CODE	SLRMSCD
SLRMFCR_MSCD_CODE	SLRMSCD_MSCD_CODE	SLRMSCD

Index

Index Name	Index Type	Column Name
SLRMFCR_KEY_INDEX	Unique	SLRMFCR_TERM_CODE
SLRMFCR_KEY_INDEX	Unique	SLRMFCR_MSCD_CODE
SLRMFCR_KEY_INDEX	Unique	SLRMFCR_FROM_DATE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLVMREF	SQL View	S10B80.BANINST1	Use (select)
SLRMFCR	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLRMFCR_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
SLRMASG	SQL Table	S10B80.SATURN	Join
SLRMSCD	SQL Table	S10B80.SATURN	Refer (no action)
STVMSCD	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRMFCR

Object Dates

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

Source Code Comments

Meal Refund Percentage Table

Columns Comments for SLRMFCR_TERM_CODE (# 1)

Source Code Comments

This field contains the term code for which these refund rules apply

Columns Comments for SLRMFCR_MSCD_CODE (# 2)

Source Code Comments

This field contains the assignment status code

Columns Comments for SLRMFCR_FROM_DATE (# 3)

Source Code Comments

This field contains the beginning date that this particular rule applies

Columns Comments for SLRMFCR_TO_DATE (# 4)

Source Code Comments

This field contains the last date that this refund rule applies

Columns Comments for SLRMFCR_REFUND (# 5)

Source Code Comments

This field contains the refund percentage which will be used when an assessment is processed for this rate code during the corresponding from/to dates

Columns Comments for SLRMFCR_ACTIVITY_DATE (# 6)

Source Code Comments

This field contains the date that this row was added or last modified

Table SLRMSCD

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SLRMSCD_TERM_CODE	VARCHAR2(6)	No	*	*
SLRMSCD_MSCD_CODE	VARCHAR2(2)	No	*	*
SLRMSCD_START_DATE	DATE	Yes
SLRMSCD_END_DATE	DATE	Yes
SLRMSCD_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLRMSCD_TERM_CODE	SLBTERM_TERM_CODE	SLBTERM
SLRMSCD_MSCD_CODE	STVMSCD_CODE	STVMSCD
SLRMSCD_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SLRMSCD	Unique	SLRMSCD_TERM_CODE
PK_SLRMSCD	Unique	SLRMSCD_MSCD_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLRMFCR	SQL Table	S10B80.SATURN	Refer (no action)
P_CREATE_ROOM_MEAL_STATUS	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert,select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_MEALASSIGNMENT_RULES	Use (select)
P_VALID_STAT_DATE	Oracle Package Procedure	S10B80.BANINST1.SOKPVAL	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_MEALASSIGNMENT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ROOMPREFERENCE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (Insert,select)
SLRMSCD	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SLRMSCD	SQL Index	S10B80.SATURN	Rely On
SLBTERM	SQL Table	S10B80.SATURN	Refer (no action)
STVMSCD	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRMSCD

Object Dates

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

Source Code Comments

Meal Status Table By Term

Columns Comments for SLRMSCD_TERM_CODE (# 1)

Source Code Comments

This field identifies the term associated with the meal status code

Columns Comments for SLRMSCD_MSCD_CODE (# 2)

Source Code Comments

This field defines the meal status codes associated with the term

Columns Comments for SLRMSCD_START_DATE (# 3)

Source Code Comments

This field defines the first date the meal status code is valid

Columns Comments for SLRMSCD_END_DATE (# 4)

Source Code Comments

This field defines the last date the meal status code is valid

Columns Comments for SLRMSCD_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table SLRPASG

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SLRPASG_PIDM	NUMBER(8,0)	No
SLRPASG_TERM_CODE	VARCHAR2(6)	No	*
SLRPASG_PRCD_CODE	VARCHAR2(4)	No	*
SLRPASG_PHONE_ACCOUNT_NUMBER	VARCHAR2(20)	Yes
SLRPASG_PHONE_AREA	VARCHAR2(6)	Yes
SLRPASG_PHONE_EXT	VARCHAR2(10)	Yes
SLRPASG_PHONE_NUMBER	VARCHAR2(12)	No
SLRPASG_BEGIN_DATE	DATE	No
SLRPASG_END_DATE	DATE	No
SLRPASG_TOTAL_DAYS	NUMBER(9,5)	No
SLRPASG_TOTAL_MONTHS	NUMBER(7,5)	No
SLRPASG_TOTAL_TERMS	NUMBER(7,5)	No
SLRPASG_PSCD_CODE	VARCHAR2(2)	No	*
SLRPASG_PSCD_DATE	DATE	No
SLRPASG_ONL_OR_BAT	VARCHAR2(1)	No
SLRPASG_ACTIVITY_DATE	DATE	No
SLRPASG_AR_IND	VARCHAR2(1)	No
SLRPASG_ROLL_IND	VARCHAR2(1)	Yes
SLRPASG_ASSESS_NEEDED	VARCHAR2(1)	No
SLRPASG_DATA_ORIGIN	VARCHAR2(30)	Yes
SLRPASG_USER_ID	VARCHAR2(30)	Yes
SLRPASG_CTRY_CODE_PHONE	VARCHAR2(4)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLRPASG_PSCD_CODE	STVPSCD_CODE	STVPSCD
SLRPASG_TERM_CODE	STVTERM_CODE	STVTERM
SLRPASG_PRCD_CODE	STVPRCD_CODE	STVPRCD

Index

Index Name	Index Type	Column Name
SLRPASG_KEY_INDEX		SLRPASG_PIDM
SLRPASG_KEY_INDEX		SLRPASG_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLRLMFE	SQL Table	S10B80.SATURN	Join
SLRPFCR	SQL Table	S10B80.SATURN	Join
SLVCOLR	SQL View	S10B80.BANINST1	Join
SLVPREF	SQL View	S10B80.BANINST1	Use (select)
SLVPREF_EXP	SQL View	S10B80.BANINST1	Use (select)
F_GET_MULT_SLRPASG_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SLRPASG_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_PHONE_THIS_TERM	SQL Function	S10B80.BANINST1	Use (select)
PHONEASSIGNMENT_REC	Oracle Package Type	S10B80.BANINST1.SB_PHONEASSIGNMENT	Rely On
GT_SLRPASG	Oracle Package Type	S10B80.BANINST1.SLKSELS	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.SB_PHONEASSIGNMENT	Rely On
F_BUILD_SLRPASG_REC	Oracle Package Function	S10B80.BANINST1.SB_PHONEASSIGNMENT	Rely On
P_ASSESS_PHONE	Oracle Package Procedure	S10B80.BANINST1.SFKMODS	Rely On
P_CALC_DAYS_MONTHS_TERMS	Oracle Package Procedure	S10B80.BANINST1.SB_PHONEASSIGNMENT	Rely On
P_CHECK_ASSIGNMENTS	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Use (select)
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_PHONEASSIGNMENT	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_PHONEASSIGNMENT	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SLRPASG	Use (delete)
P_FH_CREDITS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_GET_SLRPASG_ASSESS_DATA	Oracle Package Procedure	S10B80.BANINST1.SLKSELS	Rely On
P_GET_SLRPASG_ASSESS_DATA	Oracle Package Procedure	S10B80.BANINST1.SLKSELS	Use (select)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SLRPASG	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_PHONEASSIGNMENT	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.SB_PHONEASSIGNMENT_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PHONEASSIGNMENT	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE	Use (select)
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SLRPASG	Use (update)Rely On
P_UPDATE_SLRPASG_AR_IND	Oracle Package Procedure	S10B80.BANINST1.SLKMODS	Rely On
P_UPDATE_SLRPASG_ASSESS	Oracle Package Procedure	S10B80.BANINST1.SLKMODS	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PHONEASSIGNMENT_RULES	Rely On
P_VIEWACCTTERM	Oracle Package Procedure	S10B80.BANINST1.BWSKOACC	Rely On
P_VR_PROCESS_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_PHONEASSIGNMENT	Use (select)
F_GET_MUL_SLRPASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKSELS	Rely On
F_GET_MUL_SLRPASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKSELS	Use (select)Rely On
F_GET_MUL_SLRPASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLVSELS	Rely On
F_GET_MUL_SLRPASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLVSELS	Use (select)Rely On
F_GET_MUL_SLRPASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKRESS	Rely On
F_GET_MUL_SLRPASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKRESS	Use (select)Rely On
F_HOUSINGASSIGNMENT	Oracle Package Function	S10B80.BANINST1.SLKWEVN	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_PHONEASSIGNMENT	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_PHONEASSIGNMENT	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.SB_PHONEASSIGNMENT	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_PHONEASSIGNMENT	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_PHONEASSIGNMENT	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_PHONEASSIGNMENT	Use (select)
SLRPASG	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLRPASG_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVPRCD	SQL Table	S10B80.SATURN	Refer (no action)
STVPSCD	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRPASG

Object Dates

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

Source Code Comments

Phone Assignment Table

Columns Comments for SLRPASG_PIDM (# 1)

Source Code Comments

This field defines the internal identifier associated with the phone assignments

Columns Comments for SLRPASG_TERM_CODE (# 2)

Source Code Comments

This field defines the term associated with the phone assignments

Columns Comments for SLRPASG_PRCD_CODE (# 3)

Source Code Comments

This identifies the phone rate code associated with the phone assignment

Columns Comments for SLRPASG_PHONE_ACCOUNT_NUMBER (# 4)

Source Code Comments

This field identifies the phone account number associated with the phone assignment

Columns Comments for SLRPASG_PHONE_AREA (# 5)

Source Code Comments

This field defines the area code of the phone number associated with the phone assignment

Columns Comments for SLRPASG_PHONE_EXT (# 6)

Source Code Comments

This field defines the extension of the phone number associated with the phone assignment

Columns Comments for SLRPASG_PHONE_NUMBER (# 7)

Source Code Comments

This field defines the phone number associated with the phone assignment

Columns Comments for SLRPASG_BEGIN_DATE (# 8)

Source Code Comments

This field identifies the first day of the phone assignment

Columns Comments for SLRPASG_END_DATE (# 9)

Source Code Comments

This field identifies the last day of the phone assignment

Columns Comments for SLRPASG_TOTAL_DAYS (# 10)

Source Code Comments

This field identifies the total number of days of the phone assignment

Columns Comments for SLRPASG_TOTAL_MONTHS (# 11)

Source Code Comments

This field identifies the total number of months of the phone assignment

Columns Comments for SLRPASG_TOTAL_TERMS (# 12)

Source Code Comments

This field identifies the total number of terms of the phone assignment

Columns Comments for SLRPASG_PSCD_CODE (# 13)

Source Code Comments

This field identifies the phone plan status code of the meal assignment

Columns Comments for SLRPASG_PSCD_DATE (# 14)

Source Code Comments

This field defines the date the phone plan status code was last updated

Columns Comments for SLRPASG_ONL_OR_BAT (# 15)

Source Code Comments

This field identifies whether the phone assignment was created on-line or batch using the batch scheduler

Columns Comments for SLRPASG_ACTIVITY_DATE (# 16)

Source Code Comments

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

Columns Comments for SLRPASG_AR_IND (# 17)

Source Code Comments

This field identifies whether the phone assignment charges have been processes

Columns Comments for SLRPASG_ROLL_IND (# 18)

Source Code Comments

This field controls whether the phone assignment can be rolled using the roll forward process

Columns Comments for SLRPASG_ASSESS_NEEDED (# 19)

Source Code Comments

This field identifies whether fee assessment is needed for the phone assignment

Columns Comments for SLRPASG_DATA_ORIGIN (# 20)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SLRPASG_USER_ID (# 21)

Source Code Comments

USER ID: User who inserted or last update the data

Columns Comments for SLRPASG_CTRY_CODE_PHONE (# 22)

Source Code Comments

COUNTRY CODE: Telephone code that designates the region and country.

Table SLRPFCR

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SLRPFCR_TERM_CODE	VARCHAR2(6)	No	*
SLRPFCR_PSCD_CODE	VARCHAR2(2)	No	*
SLRPFCR_FROM_DATE	DATE	Yes
SLRPFCR_TO_DATE	DATE	Yes
SLRPFCR_REFUND	NUMBER(3,0)	No
SLRPFCR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLRPFCR_TERM_CODE	SLRPSCD_TERM_CODE	SLRPSCD
SLRPFCR_PSCD_CODE	SLRPSCD_PSCD_CODE	SLRPSCD
SLRPFCR_PSCD_CODE	STVPSCD_CODE	STVPSCD
SLRPFCR_TERM_CODE	STVTERM_CODE	STVTERM
SLRPFCR_TERM_CODE	SLRPASG_TERM_CODE	SLRPASG
SLRPFCR_PSCD_CODE	SLRPASG_PSCD_CODE	SLRPASG

Index

Index Name	Index Type	Column Name
SLRPFCR_KEY_INDEX	Unique	SLRPFCR_TERM_CODE
SLRPFCR_KEY_INDEX	Unique	SLRPFCR_PSCD_CODE
SLRPFCR_KEY_INDEX	Unique	SLRPFCR_FROM_DATE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLVPREF	SQL View	S10B80.BANINST1	Use (select)
SLVPREF_EXP	SQL View	S10B80.BANINST1	Use (select)
SLRPFCR	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLRPFCR_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
SLRPASG	SQL Table	S10B80.SATURN	Join
SLRPSCD	SQL Table	S10B80.SATURN	Refer (no action)
STVPSCD	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRPFCR

Object Dates

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

Source Code Comments

Phone Refund Percentage Table

Columns Comments for SLRPFCR_TERM_CODE (# 1)

Source Code Comments

This field contains the term code for which these refund rules apply

Columns Comments for SLRPFCR_PSCD_CODE (# 2)

Source Code Comments

This field contains the assignment status code

Columns Comments for SLRPFCR_FROM_DATE (# 3)

Source Code Comments

This field contains the beginning date that this particular rule applies

Columns Comments for SLRPFCR_TO_DATE (# 4)

Source Code Comments

This field contains the last date that this refund rule applies

Columns Comments for SLRPFCR_REFUND (# 5)

Source Code Comments

This field contains the refund percentage which will be used when an assessment is processed for this rate code during the corresponding from/to dates

Columns Comments for SLRPFCR_ACTIVITY_DATE (# 6)

Source Code Comments

This field contains the date that this row was added or last modified

Table SLRPREQ

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SLRPREQ_PIDM	NUMBER(8,0)	No
SLRPREQ_TERM_CODE	VARCHAR2(6)	No	*
SLRPREQ_RDEF_CODE	VARCHAR2(4)	No	*
SLRPREQ_MUST_MATCH	VARCHAR2(1)	Yes
SLRPREQ_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLRPREQ_RDEF_CODE	STVRDEF_CODE	STVRDEF
SLRPREQ_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
SLRPREQ_KEY_INDEX		SLRPREQ_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ROVPREQ	SQL View	S10B80.BANINST1	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE	Use (update,delete,select)
SLRPREQ	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRPREQ

Object Dates

Creation Date	Analysis Date
04/02/2008 21:06:27:000	04/02/2008 21:18:25:000

Source Code Comments

Housing Special Requirements Table

Columns Comments for SLRPREQ_PIDM (# 1)

Source Code Comments

This field is the internal identifier of the student associated with the attributes

Columns Comments for SLRPREQ_TERM_CODE (# 2)

Source Code Comments

This field defines the term associated with the attributes

Columns Comments for SLRPREQ_RDEF_CODE (# 3)

Source Code Comments

This fields defines the attributes associated with a persons housing application

Columns Comments for SLRPREQ_MUST_MATCH (# 4)

Source Code Comments

This field determines whether the attribute entered for the student requires a matching attribute for the room the person is to be scheduled in

Columns Comments for SLRPREQ_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table SLRPSCD

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SLRPSCD_TERM_CODE	VARCHAR2(6)	No	*	*
SLRPSCD_PSCD_CODE	VARCHAR2(2)	No	*	*
SLRPSCD_START_DATE	DATE	Yes
SLRPSCD_END_DATE	DATE	Yes
SLRPSCD_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLRPSCD_PSCD_CODE	STVPSCD_CODE	STVPSCD
SLRPSCD_TERM_CODE	SLBTERM_TERM_CODE	SLBTERM
SLRPSCD_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SLRPSCD	Unique	SLRPSCD_TERM_CODE
PK_SLRPSCD	Unique	SLRPSCD_PSCD_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLRPFCR	SQL Table	S10B80.SATURN	Refer (no action)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PHONEASSIGNMENT_RULES	Use (select)
P_VALID_STAT_DATE	Oracle Package Procedure	S10B80.BANINST1.SOKPVAL	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ROOMPREFERENCE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_PHONEASSIGNMENT	Use (Insert,select)
SLRPSCD	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SLRPSCD	SQL Index	S10B80.SATURN	Rely On
SLBTERM	SQL Table	S10B80.SATURN	Refer (no action)
STVPSCD	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRPSCD

Object Dates

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

Source Code Comments

Phone Status Table By Term

Columns Comments for SLRPSCD_TERM_CODE (# 1)

Source Code Comments

This field identifies the term associated with the phone status code

Columns Comments for SLRPSCD_PSCD_CODE (# 2)

Source Code Comments

This field defines the phone status codes associated with the term

Columns Comments for SLRPSCD_START_DATE (# 3)

Source Code Comments

This field defines the first date the phone status code is valid

Columns Comments for SLRPSCD_END_DATE (# 4)

Source Code Comments

This field defines the last date the phone status code is valid

Columns Comments for SLRPSCD_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table SLRRASG

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SLRRASG_PIDM	NUMBER(8,0)	No	*
SLRRASG_BLDG_CODE	VARCHAR2(6)	No	*
SLRRASG_ROOM_NUMBER	VARCHAR2(10)	No	*
SLRRASG_TERM_CODE	VARCHAR2(6)	No	*
SLRRASG_RRCD_CODE	VARCHAR2(4)	No	*
SLRRASG_BEGIN_DATE	DATE	No
SLRRASG_END_DATE	DATE	No
SLRRASG_TOTAL_DAYS	NUMBER(9,5)	No
SLRRASG_TOTAL_MONTHS	NUMBER(7,5)	No
SLRRASG_TOTAL_TERMS	NUMBER(7,5)	No
SLRRASG_ASCD_CODE	VARCHAR2(2)	No	*
SLRRASG_ASCD_DATE	DATE	No
SLRRASG_ONL_OR_BAT	VARCHAR2(1)	No
SLRRASG_ACTIVITY_DATE	DATE	No
SLRRASG_AR_IND	VARCHAR2(1)	No
SLRRASG_OVERLOAD_IND	VARCHAR2(1)	Yes
SLRRASG_ROLL_IND	VARCHAR2(1)	Yes
SLRRASG_OVERRIDE_ERROR	VARCHAR2(1)	Yes
SLRRASG_ASSESS_NEEDED	VARCHAR2(1)	No
SLRRASG_DATA_ORIGIN	VARCHAR2(30)	Yes
SLRRASG_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLRRASG_RRCD_CODE	STVRRCD_CODE	STVRRCD
SLRRASG_BLDG_CODE	STVBLDG_CODE	STVBLDG
SLRRASG_ASCD_CODE	STVASCD_CODE	STVASCD
SLRRASG_TERM_CODE	STVTERM_CODE	STVTERM
SLRRASG_BLDG_CODE	SLBRDEF_BLDG_CODE	SLBRDEF
SLRRASG_ROOM_NUMBER	SLBRDEF_ROOM_NUMBER	SLBRDEF
SLRRASG_BLDG_CODE	SLBBLDG_BLDG_CODE	SLBBLDG
SLRRASG_PIDM	SPBPERS_PIDM	SPBPERS

Index

Index Name	Index Type	Column Name
SLRRASG_BLDG_INDEX		SLRRASG_BLDG_CODE
SLRRASG_BLDG_INDEX		SLRRASG_ROOM_NUMBER
SLRRASG_KEY_INDEX		SLRRASG_PIDM
SLRRASG_KEY_INDEX		SLRRASG_BLDG_CODE
SLRRASG_KEY_INDEX		SLRRASG_ROOM_NUMBER

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLRLMFE	SQL Table	S10B80.SATURN	Join
SLRRFCR	SQL Table	S10B80.SATURN	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
ROVRASG	SQL View	S10B80.BANINST1	Use (select)
SLVCOLR	SQL View	S10B80.BANINST1	Join
SLVRREF	SQL View	S10B80.BANINST1	Use (select)
SLVRREF_OJ	SQL View	S10B80.BANINST1	Use (select)
SLVRUSE	SQL View	S10B80.BANINST1	Use (select)
F_GET_MULT_SLBBLDG_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_MULT_SLBRDEF_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_MULT_SLRRASG_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_MULT_SLRRASG_ROWID_M	SQL Function	S10B80.BANINST1	Use (select)Rely On
F_GET_SLBBLDG_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SLBRDEF_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SLRRASG_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_HOUS_THIS_TERM	SQL Function	S10B80.BANINST1	Use (select)
F_SLBRDEF_VALUE	SQL Function	S10B80.BANINST1	Use (select)
ROOMASSIGNMENT_REC	Oracle Package Type	S10B80.BANINST1.GB_ROOMASSIGNMENT	Rely On
GT_SLRRASG	Oracle Package Type	S10B80.BANINST1.SLKSELS	Rely On
P_GETHOUSINGIND	Oracle Package Procedure	S10B80.BANINST1.ROKWEXT	Rely On
P_GETHOUSINGIND	Oracle Package Procedure	S10B80.BANINST1.ROKWEXT	Use (select)
P_GETHOUSINGIND	Oracle Package Procedure	S10B80.BANINST1.SOKWEXT	Rely On
P_GETHOUSINGIND	Oracle Package Procedure	S10B80.BANINST1.SOKWEXT	Use (select)
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_ROOMASSIGNMENT	Rely On
F_BUILD_SLRRASG_REC	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT	Rely On
P_ASSESS_ROOM	Oracle Package Procedure	S10B80.BANINST1.SFKMODS	Rely On
P_CALC_DAYS_MONTHS_TERMS	Oracle Package Procedure	S10B80.BANINST1.GB_ROOMASSIGNMENT	Rely On
P_CHECK_ASSIGNMENTS	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Use (select)
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_ROOMASSIGNMENT	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_ROOMDEFINITION	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SLRRASG	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_ROOMASSIGNMENT	Rely On
P_FH_CREDITS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_GET_SLRRASG_ASSESS_DATA	Oracle Package Procedure	S10B80.BANINST1.SLKSELS	Rely On
P_GET_SLRRASG_ASSESS_DATA	Oracle Package Procedure	S10B80.BANINST1.SLKSELS	Use (select)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SLRRASG	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_ROOMASSIGNMENT	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_ROOMASSIGNMENT_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SLRRASG	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE	Use (select)
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_ROOMASSIGNMENT	Rely On
P_UPDATE_SLRRASG_AR_IND	Oracle Package Procedure	S10B80.BANINST1.SLKMODS	Rely On
P_UPDATE_SLRRASG_ASSESS	Oracle Package Procedure	S10B80.BANINST1.SLKMODS	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_ROOMASSIGNMENT_RULES	Rely On
P_VIEWACCTTERM	Oracle Package Procedure	S10B80.BANINST1.BWSKOACC	Rely On
P_VR_PROCESS_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
F_CHECK_BLDG	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT_RULES	Rely On
F_CHECK_CAPACITY	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT_RULES	Rely On
F_CHECK_CAPACITY	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT_RULES	Use (select)
F_CHECK_RESTRICTIONS	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT_RULES	Rely On
F_CHECK_ROOM	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT	Use (select)
F_GET_MUL_SLBBLDG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKSELS	Use (select)
F_GET_MUL_SLBBLDG_VALUE	Oracle Package Function	S10B80.BANINST1.SLVSELS	Use (select)
F_GET_MUL_SLBBLDG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKRESS	Use (select)
F_GET_MUL_SLBRDEF_VALUE	Oracle Package Function	S10B80.BANINST1.SLKSELS	Use (select)
F_GET_MUL_SLBRDEF_VALUE	Oracle Package Function	S10B80.BANINST1.SLVSELS	Use (select)
F_GET_MUL_SLBRDEF_VALUE	Oracle Package Function	S10B80.BANINST1.SLKRESS	Use (select)
F_GET_MUL_SLRRASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKSELS	Rely On
F_GET_MUL_SLRRASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKSELS	Use (select)Rely On
F_GET_MUL_SLRRASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLVSELS	Rely On
F_GET_MUL_SLRRASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLVSELS	Use (select)Rely On
F_GET_MUL_SLRRASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKRESS	Rely On
F_GET_MUL_SLRRASG_VALUE	Oracle Package Function	S10B80.BANINST1.SLKRESS	Use (select)Rely On
F_GET_RATE	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT	Rely On
F_HOUSINGASSIGNMENT	Oracle Package Function	S10B80.BANINST1.SLKWEVN	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT	Use (select)
SLRRASG	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLRRASG_BLDG_INDEX	SQL Index	S10B80.SATURN	Rely On
SLRRASG_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
SLBBLDG	SQL Table	S10B80.SATURN	Join
SLBRDEF	SQL Table	S10B80.SATURN	Join
SPBPERS	SQL Table	S10B80.SATURN	Join
STVASCD	SQL Table	S10B80.SATURN	Refer (no action)
STVBLDG	SQL Table	S10B80.SATURN	Refer (no action)
STVRRCD	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRRASG

Object Dates

Creation Date	Analysis Date
04/02/2008 20:51:48:000	04/02/2008 21:18:14:000

Source Code Comments

Room Assignment Table

Columns Comments for SLRRASG_PIDM (# 1)

Source Code Comments

This field defines the internal identifier associated with the room assignments

Columns Comments for SLRRASG_BLDG_CODE (# 2)

Source Code Comments

This field identifies the building code of the room assignment

Columns Comments for SLRRASG_ROOM_NUMBER (# 3)

Source Code Comments

This field identifies the room number of the room assignment

Columns Comments for SLRRASG_TERM_CODE (# 4)

Source Code Comments

This field defines the term associated with the room assignments

Columns Comments for SLRRASG_RRCD_CODE (# 5)

Source Code Comments

This field defines the room rate code associated with the assignment

Columns Comments for SLRRASG_BEGIN_DATE (# 6)

Source Code Comments

This field identifies the first day of the room assignment

Columns Comments for SLRRASG_END_DATE (# 7)

Source Code Comments

This field identifies the last day of the room assignment

Columns Comments for SLRRASG_TOTAL_DAYS (# 8)

Source Code Comments

This field identifies the total number of days of the room assignment

Columns Comments for SLRRASG_TOTAL_MONTHS (# 9)

Source Code Comments

This field identifies the total number of months of the room assignment

Columns Comments for SLRRASG_TOTAL_TERMS (# 10)

Source Code Comments

This field identifies the total number of terms of the room assignment

Columns Comments for SLRRASG_ASCD_CODE (# 11)

Source Code Comments

This field identifies the status code of the room assignment

Columns Comments for SLRRASG_ASCD_DATE (# 12)

Source Code Comments

This field defines the date the room plan status code was last updated

Columns Comments for SLRRASG_ONL_OR_BAT (# 13)

Source Code Comments

This field identifies whether the room assignment was created on-line or batch using the batch scheduler

Columns Comments for SLRRASG_ACTIVITY_DATE (# 14)

Source Code Comments

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

Columns Comments for SLRRASG_AR_IND (# 15)

Source Code Comments

This field identifies whether the room assignment charges have been processed

Columns Comments for SLRRASG_OVERLOAD_IND (# 16)

Source Code Comments

This field identifies whether an overload condition existed to allow the room assignment

Columns Comments for SLRRASG_ROLL_IND (# 17)

Source Code Comments

This field controls whether the room assignment can be rolled using the roll forward process

Columns Comments for SLRRASG_OVERRIDE_ERROR (# 18)

Source Code Comments

This field identifies whether an error override condition existed to allow the room assignment

Columns Comments for SLRRASG_ASSESS_NEEDED (# 19)

Source Code Comments

This field identifies whether fee assessment is needed for the room assignment

Columns Comments for SLRRASG_DATA_ORIGIN (# 20)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SLRRASG_USER_ID (# 21)

Source Code Comments

USER ID: User who inserted or last update the data

Table SLRRDEF

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SLRRDEF_BLDG_CODE	VARCHAR2(6)	No	*
SLRRDEF_ROOM_NUMBER	VARCHAR2(10)	No	*
SLRRDEF_RDEF_CODE	VARCHAR2(4)	No	*	*
SLRRDEF_MUST_MATCH	VARCHAR2(1)	Yes
SLRRDEF_ACTIVITY_DATE	DATE	No
SLRRDEF_TERM_CODE_EFF	VARCHAR2(6)	No	*
SLRRDEF_DATA_ORIGIN	VARCHAR2(30)	Yes
SLRRDEF_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLRRDEF_RDEF_CODE	STVRDEF_CODE	STVRDEF

Index

Index Name	Index Type	Column Name
PK_SLRRDEF	Unique	SLRRDEF_BLDG_CODE
PK_SLRRDEF	Unique	SLRRDEF_ROOM_NUMBER
PK_SLRRDEF	Unique	SLRRDEF_TERM_CODE_EFF
PK_SLRRDEF	Unique	SLRRDEF_RDEF_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_ROOMDEFINITION	Use (Insert,select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_ROOMDEFINITION	Use (delete,select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SLRRDEF	Use (delete)Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SLRRDEF	Use (Insert)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SLRRDEF	Rely On
SLRRDEF	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRRDEF

Object Dates

Creation Date	Analysis Date
04/02/2008 21:03:53:000	04/02/2008 21:18:23:000

Source Code Comments

Room Attributes Definition Table

Columns Comments for SLRRDEF_BLDG_CODE (# 1)

Source Code Comments

This field identifies the building code of the room attributes

Columns Comments for SLRRDEF_ROOM_NUMBER (# 2)

Source Code Comments

This field identifies the room number of the attributes

Columns Comments for SLRRDEF_RDEF_CODE (# 3)

Source Code Comments

This field identifies the attributes associated with the rooms

Columns Comments for SLRRDEF_MUST_MATCH (# 4)

Source Code Comments

This field determines whether the attribute entered for the room requires a matching attribute for the people scheduled in the room

Columns Comments for SLRRDEF_ACTIVITY_DATE (# 5)

Source Code Comments

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

Columns Comments for SLRRDEF_TERM_CODE_EFF (# 6)

Source Code Comments

Term code effective date.

Columns Comments for SLRRDEF_DATA_ORIGIN (# 7)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SLRRDEF_USER_ID (# 8)

Source Code Comments

USER ID: User who inserted or last update the data

Table SLRRFCR

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SLRRFCR_TERM_CODE	VARCHAR2(6)	No	*
SLRRFCR_ASCD_CODE	VARCHAR2(2)	No	*
SLRRFCR_FROM_DATE	DATE	Yes
SLRRFCR_TO_DATE	DATE	Yes
SLRRFCR_REFUND	NUMBER(3,0)	No
SLRRFCR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLRRFCR_ASCD_CODE	STVASCD_CODE	STVASCD
SLRRFCR_TERM_CODE	SLRASCD_TERM_CODE	SLRASCD
SLRRFCR_ASCD_CODE	SLRASCD_ASCD_CODE	SLRASCD
SLRRFCR_TERM_CODE	STVTERM_CODE	STVTERM
SLRRFCR_TERM_CODE	SLRRASG_TERM_CODE	SLRRASG
SLRRFCR_ASCD_CODE	SLRRASG_ASCD_CODE	SLRRASG

Index

Index Name	Index Type	Column Name
SLRRFCR_KEY_INDEX	Unique	SLRRFCR_TERM_CODE
SLRRFCR_KEY_INDEX	Unique	SLRRFCR_ASCD_CODE
SLRRFCR_KEY_INDEX	Unique	SLRRFCR_FROM_DATE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLVRREF	SQL View	S10B80.BANINST1	Use (select)
SLVRREF_OJ	SQL View	S10B80.BANINST1	Use (select)
SLRRFCR	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLRRFCR_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
SLRASCD	SQL Table	S10B80.SATURN	Refer (no action)
SLRRASG	SQL Table	S10B80.SATURN	Join
STVASCD	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRRFCR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:39:11:000	04/02/2008 21:18:03:000

Source Code Comments

Housing Refund Percentage Table

Columns Comments for SLRRFCR_TERM_CODE (# 1)

Source Code Comments

This field contains the term code for which these refund rules apply

Columns Comments for SLRRFCR_ASCD_CODE (# 2)

Source Code Comments

This field contains the assignment status code

Columns Comments for SLRRFCR_FROM_DATE (# 3)

Source Code Comments

This field contains the beginning date that this particular rule applies

Columns Comments for SLRRFCR_TO_DATE (# 4)

Source Code Comments

This field contains the last date that this refund rule applies

Columns Comments for SLRRFCR_REFUND (# 5)

Source Code Comments

This field contains the refund percentage which will be used when an assessment is processed for this rate code during the corresponding from/to dates

Columns Comments for SLRRFCR_ACTIVITY_DATE (# 6)

Source Code Comments

This field contains the date that this row was added or last modified

Table SLRRMAT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SLRRMAT_TERM_CODE	VARCHAR2(6)	No	*	*
SLRRMAT_ONEUP	VARCHAR2(5)	No	*
SLRRMAT_PIDM	NUMBER(8,0)	No	*
SLRRMAT_ACCEPT_IND	VARCHAR2(1)	Yes
SLRRMAT_ACTIVITY_DATE	DATE	No
SLRRMAT_DATA_ORIGIN	VARCHAR2(30)	Yes
SLRRMAT_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLRRMAT_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SLRRMAT	Unique	SLRRMAT_TERM_CODE
PK_SLRRMAT	Unique	SLRRMAT_ONEUP
PK_SLRRMAT	Unique	SLRRMAT_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLBRMAP	SQL Table	S10B80.SATURN	Join
SPBPERS	SQL Table	S10B80.SATURN	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
SLVRMAT	SQL View	S10B80.BANINST1	Use (select)
ROOMMATE_REC	Oracle Package Type	S10B80.BANINST1.SB_ROOMMATE	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE	Rely On
F_BUILD_SLRRMAT_REC	Oracle Package Function	S10B80.BANINST1.SB_ROOMMATE	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE	Use (select)Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SLRRMAT	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SLRRMAT	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SLRRMAT	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_ROOMMATE	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_ROOMMATE	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_ROOMMATE	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_ROOMMATE	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.SB_ROOMMATE	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_ROOMMATE	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_ROOMMATE	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_ROOMMATE	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_ROOMMATE	Use (select)
SLRRMAT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRRMAT

Object Dates

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

Source Code Comments

Roommate Application Request Table

Columns Comments for SLRRMAT_TERM_CODE (# 1)

Source Code Comments

This field identifies the term code associated with the roommate application

Columns Comments for SLRRMAT_ONEUP (# 2)

Source Code Comments

This field defines the roommate sequence number of the roommate application

Columns Comments for SLRRMAT_PIDM (# 3)

Source Code Comments

This field identifies the internal identifier of the person who has a roommate application

Columns Comments for SLRRMAT_ACCEPT_IND (# 4)

Source Code Comments

This field defines where the person and/or institution has accepted the person as a roommate

Columns Comments for SLRRMAT_ACTIVITY_DATE (# 5)

Source Code Comments

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

Columns Comments for SLRRMAT_DATA_ORIGIN (# 6)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SLRRMAT_USER_ID (# 7)

Source Code Comments

USER ID: User who inserted or last update the data

Table SLRRMDF

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SLRRMDF_TERM_CODE	VARCHAR2(6)	No	*	*
SLRRMDF_ONEUP	VARCHAR2(5)	No	*
SLRRMDF_RDEF_CODE	VARCHAR2(4)	No	*	*
SLRRMDF_MUST_MATCH	VARCHAR2(1)	Yes
SLRRMDF_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLRRMDF_RDEF_CODE	STVRDEF_CODE	STVRDEF
SLRRMDF_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SLRRMDF	Unique	SLRRMDF_TERM_CODE
PK_SLRRMDF	Unique	SLRRMDF_ONEUP
PK_SLRRMDF	Unique	SLRRMDF_RDEF_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE	Use (delete,select)
SLRRMDF	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRRMDF

Object Dates

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

Source Code Comments

Roommate Attributes Definition Table

Columns Comments for SLRRMDF_TERM_CODE (# 1)

Source Code Comments

This field defines the term associated with the roommates attributes

Columns Comments for SLRRMDF_ONEUP (# 2)

Source Code Comments

This field defines the roommate sequence number of the roommate attributes

Columns Comments for SLRRMDF_RDEF_CODE (# 3)

Source Code Comments

This fields defines the attributes associated with a roommate housing application

Columns Comments for SLRRMDF_MUST_MATCH (# 4)

Source Code Comments

This field determines whether the attribute entered for the roommate requires a matching attribute for the room the roommates are to be scheduled in

Columns Comments for SLRRMDF_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table SLRRUSE

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
SLRRUSE_BLDG_CODE	VARCHAR2(6)	No
SLRRUSE_ROOM_NUMBER	VARCHAR2(10)	No
SLRRUSE_START_DATE	DATE	No
SLRRUSE_END_DATE	DATE	Yes
SLRRUSE_ACTIVITY_DATE	DATE	No
SLRRUSE_BEGIN_TIME	VARCHAR2(4)	Yes
SLRRUSE_END_TIME	VARCHAR2(4)	Yes
SLRRUSE_SUN_DAY	VARCHAR2(1)	Yes
SLRRUSE_MON_DAY	VARCHAR2(1)	Yes
SLRRUSE_TUE_DAY	VARCHAR2(1)	Yes
SLRRUSE_WED_DAY	VARCHAR2(1)	Yes
SLRRUSE_THU_DAY	VARCHAR2(1)	Yes
SLRRUSE_FRI_DAY	VARCHAR2(1)	Yes
SLRRUSE_SAT_DAY	VARCHAR2(1)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
SLRRUSE_KEY_INDEX		SLRRUSE_BLDG_CODE
SLRRUSE_KEY_INDEX		SLRRUSE_ROOM_NUMBER

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_CHECK_ROOM_RESTRICTION	Oracle Package Function	S10B80.BANINST1.GB_CLASSTIMES_RULES	Rely On
F_CHECK_ROOM_RESTRICTION	Oracle Package Function	S10B80.BANINST1.GB_CLASSTIMES_RULES	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_ROOMDEFINITION	Use (delete,select)
F_CHECK_ROOM	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT_RULES	Use (select)
SLRRUSE	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SLRRUSE_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRRUSE

Object Dates

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

Source Code Comments

Room Usage Restriction Table

Columns Comments for SLRRUSE_BLDG_CODE (# 1)

Source Code Comments

This field identifies the building code of the room usage restriction

Columns Comments for SLRRUSE_ROOM_NUMBER (# 2)

Source Code Comments

This field identifies the room number of the room usage restriction

Columns Comments for SLRRUSE_START_DATE (# 3)

Source Code Comments

This field identifies the starting date of the room usage restriction

Columns Comments for SLRRUSE_END_DATE (# 4)

Source Code Comments

This field identifies the ending date of the room usage restriction

Columns Comments for SLRRUSE_ACTIVITY_DATE (# 5)

Source Code Comments

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

Columns Comments for SLRRUSE_BEGIN_TIME (# 6)

Source Code Comments

Begin time for room usage. Used by 3rd party scheduling tool.

Columns Comments for SLRRUSE_END_TIME (# 7)

Source Code Comments

End time for room usage. Used by 3rd party scheduling tools.

Columns Comments for SLRRUSE_SUN_DAY (# 8)

Source Code Comments

Field defining to room usage on Sunday. Used is U Unused is NULL.

Columns Comments for SLRRUSE_MON_DAY (# 9)

Source Code Comments

Field defining to room usage on Monday. Used is M Unused is NULL.

Columns Comments for SLRRUSE_TUE_DAY (# 10)

Source Code Comments

Field defining to room usage on Tuesday. Used is T Unused is NULL.

Columns Comments for SLRRUSE_WED_DAY (# 11)

Source Code Comments

Field defining to room usage on Wednesday. Used is W Unused is NULL.

Columns Comments for SLRRUSE_THU_DAY (# 12)

Source Code Comments

Field defining to room usage on Thursday. Used is R Unused is NULL.

Columns Comments for SLRRUSE_FRI_DAY (# 13)

Source Code Comments

Field defining to room usage on Friday. Used is F Unused is NULL.

Columns Comments for SLRRUSE_SAT_DAY (# 14)

Source Code Comments

Field defining to room usage on Saturday. Used is S Unused is NULL.

Table SLRTASG

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SLRTASG_TERM_CODE	VARCHAR2(6)	No	*
SLRTASG_PIDM	NUMBER(8,0)	No
SLRTASG_PRIORITY	VARCHAR2(8)	Yes
SLRTASG_BLDG_CODE	VARCHAR2(6)	Yes	*
SLRTASG_ROOM_NUMBER	VARCHAR2(10)	Yes
SLRTASG_BCAT_CODE	VARCHAR2(8)	Yes
SLRTASG_CAMP_CODE	VARCHAR2(3)	Yes	*
SLRTASG_ONEUP	VARCHAR2(5)	Yes
SLRTASG_RMATE_OK	VARCHAR2(1)	Yes
SLRTASG_MESSAGE	VARCHAR2(45)	Yes
SLRTASG_MESSAGE_SEQ	NUMBER(2,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SLRTASG_BLDG_CODE	STVBLDG_CODE	STVBLDG
SLRTASG_CAMP_CODE	STVCAMP_CODE	STVCAMP
SLRTASG_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
SLRTASG_KEY_INDEX		SLRTASG_TERM_CODE
SLRTASG_KEY_INDEX		SLRTASG_PIDM

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLRTASG

Object Dates

Creation Date	Analysis Date
04/02/2008 20:44:11:000	04/02/2008 21:18:07:000

Source Code Comments

Temporary Room Assignment Table

Columns Comments for SLRTASG_TERM_CODE (# 1)

Source Code Comments

This field identifies the term code associated with the temporary room assignment

Columns Comments for SLRTASG_PIDM (# 2)

Source Code Comments

This field identifies the internal identifier of the person who has the temporary room assignment

Columns Comments for SLRTASG_PRIORITY (# 3)

Source Code Comments

This field identifies the priority of the person who has the temporary room assignment

Columns Comments for SLRTASG_BLDG_CODE (# 4)

Source Code Comments

This field identifies the building code of the temporary room assignment

Columns Comments for SLRTASG_ROOM_NUMBER (# 5)

Source Code Comments

This field identifies the room number of the temporary room assignment

Columns Comments for SLRTASG_BCAT_CODE (# 6)

Source Code Comments

This field identifies the category code of the temporary room assignment

Columns Comments for SLRTASG_CAMP_CODE (# 7)

Source Code Comments

This field identifies the campus code of the temporary room assignment

Columns Comments for SLRTASG_ONEUP (# 8)

Source Code Comments

This field identifies the roommate sequence number of the person who has the temporary room assignment

Columns Comments for SLRTASG_RMATE_OK (# 9)

Source Code Comments

This field identifies whether the persons roommate assignment was processed

Columns Comments for SLRTASG_MESSAGE (# 10)

Source Code Comments

This field identifies the messages associated with the temporary room assignment

Columns Comments for SLRTASG_MESSAGE_SEQ (# 11)

Source Code Comments

This field contains a sequence number to insure that the messages associated with the temporary room assignment will be processed in order

Table SLTFTRN

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
SLTFTRN_PIDM	NUMBER(8,0)	No
SLTFTRN_TERM_CODE	VARCHAR2(6)	No
SLTFTRN_DETAIL_CODE	VARCHAR2(4)	No
SLTFTRN_EFF_DATE	DATE	No
SLTFTRN_SRCE_CODE	VARCHAR2(1)	No
SLTFTRN_AMOUNT	NUMBER(12,2)	No

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SLTFTRN

Object Dates

Creation Date	Analysis Date
04/02/2008 21:06:44:000	04/02/2008 21:18:25:000

Source Code Comments

Location Management Fee Assessment Transactions

Columns Comments for SLTFTRN_PIDM (# 1)

Source Code Comments

Student PIDM Value

Columns Comments for SLTFTRN_TERM_CODE (# 2)

Source Code Comments

Assignment Term Code

Columns Comments for SLTFTRN_DETAIL_CODE (# 3)

Source Code Comments

Transaction Detail Code

Columns Comments for SLTFTRN_EFF_DATE (# 4)

Source Code Comments

Transaction Effective Date of Charge

Columns Comments for SLTFTRN_SRCE_CODE (# 5)

Source Code Comments

Transaction Source Code

Columns Comments for SLTFTRN_AMOUNT (# 6)

Source Code Comments

Transaction Amount

Link between SLRLMFE and SLRRASG

Join Information

Objects list
schema-view : S10B80.BANINST1.SLVRREF schema-view : S10B80.BANINST1.SLVRREF_OJ

Link List

Link Type	Link	Project
Join	Link Between SLRLMFE and SLRRASG	SATURN

List of Real links

Link type	Between	And
Join	SLRLMFE	SLRRASG

Link between SLRRFCR and SLRRASG

Join Information

Objects list
schema-view : S10B80.BANINST1.SLVRREF schema-view : S10B80.BANINST1.SLVRREF_OJ

Link List

Link Type	Link	Project
Join	Link Between SLRRFCR and SLRRASG	SATURN

List of Real links

Link type	Between	And
Join	SLRRFCR	SLRRASG

Link between SLRLMFE and SLRMASG

Join Information

Objects list
schema-view : S10B80.BANINST1.SLVMREF

Link List

Link Type	Link	Project
Join	Link Between SLRLMFE and SLRMASG	SATURN

List of Real links

Link type	Between	And
Join	SLRLMFE	SLRMASG

Link between SLRMFCR and SLRMASG

Join Information

Objects list
schema-view : S10B80.BANINST1.SLVMREF

Link List

Link Type	Link	Project
Join	Link Between SLRMFCR and SLRMASG	SATURN

List of Real links

Link type	Between	And
Join	SLRMFCR	SLRMASG

Link between SLRLMFE and SLRPASG

Join Information

Objects list
schema-view : S10B80.BANINST1.SLVPREF schema-view : S10B80.BANINST1.SLVPREF_EXP

Link List

Link Type	Link	Project
Join	Link Between SLRLMFE and SLRPASG	SATURN

List of Real links

Link type	Between	And
Join	SLRLMFE	SLRPASG

Link between SLRPFCR and SLRPASG

Join Information

Objects list
schema-view : S10B80.BANINST1.SLVPREF schema-view : S10B80.BANINST1.SLVPREF_EXP

Link List

Link Type	Link	Project
Join	Link Between SLRPFCR and SLRPASG	SATURN

List of Real links

Link type	Between	And
Join	SLRPFCR	SLRPASG

Link between SLBRMAP and SLRRMAT

Join Information

Objects list
schema-view : S10B80.BANINST1.SLVRMAT

Link List

Link Type	Link	Project
Join	Link Between SLBRMAP and SLRRMAT	SATURN

List of Real links

Link type	Between	And
Join	SLBRMAP	SLRRMAT

Link between SLRRASG and SLBBLDG

Join Information

Objects list
schema-view : S10B80.BANINST1.SLVRUSE

Link List

Link Type	Link	Project
Join	Link Between SLRRASG and SLBBLDG	SATURN

List of Real links

Link type	Between	And
Join	SLRRASG	SLBBLDG

Link between SLBBLDG and SLBRMPF

Join Information

Objects list
scope-procedure : S10B80.BANINST1.SB_ROOMMATE_RULES.P_VALIDATE

Link List

Link Type	Link	Project
Join	Link Between SLBBLDG and SLBRMPF	SATURN

List of Real links

Link type	Between	And
Join	SLBBLDG	SLBRMPF

Link between SLRRMAT and PK_SLRRMAT

Link List

Link Type	Link	Project
Rely On	Link Between SLRRMAT and PK_SLRRMAT	SATURN

List of Real links

Link type	Between	And
Rely On	SLRRMAT	PK_SLRRMAT

Link between SLRRMDF and PK_SLRRMDF

Link List

Link Type	Link	Project
Rely On	Link Between SLRRMDF and PK_SLRRMDF	SATURN

List of Real links

Link type	Between	And
Rely On	SLRRMDF	PK_SLRRMDF

Link between SLRPSCD and PK_SLRPSCD

Link List

Link Type	Link	Project
Rely On	Link Between SLRPSCD and PK_SLRPSCD	SATURN

List of Real links

Link type	Between	And
Rely On	SLRPSCD	PK_SLRPSCD

Link between SLBBLDG and PK_SLBBLDG

Link List

Link Type	Link	Project
Rely On	Link Between SLBBLDG and PK_SLBBLDG	SATURN

List of Real links

Link type	Between	And
Rely On	SLBBLDG	PK_SLBBLDG

Link between SLRASCD and PK_SLRASCD

Link List

Link Type	Link	Project
Rely On	Link Between SLRASCD and PK_SLRASCD	SATURN

List of Real links

Link type	Between	And
Rely On	SLRASCD	PK_SLRASCD

Link between SLRRFCR and SLRASCD

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SLRRFCR and SLRASCD (FK1_SLRRFCR_INV_SLRASCD_KEY)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SLRRFCR	SLRRFCR_TERM_CODE	SLRASCD_TERM_CODE	SLRASCD	(1,1)-(0,n)
SLRRFCR	SLRRFCR_ASCD_CODE	SLRASCD_ASCD_CODE	SLRASCD	(1,1)-(0,n)

Link between SLRCMNT and PK_SLRCMNT

Link List

Link Type	Link	Project
Rely On	Link Between SLRCMNT and PK_SLRCMNT	SATURN

List of Real links

Link type	Between	And
Rely On	SLRCMNT	PK_SLRCMNT

Link between SLBTERM and PK_SLBTERM

Link List

Link Type	Link	Project
Rely On	Link Between SLBTERM and PK_SLBTERM	SATURN

List of Real links

Link type	Between	And
Rely On	SLBTERM	PK_SLBTERM

Link between SLRASCD and SLBTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SLRASCD and SLBTERM (FK1_SLRASCD_INV_SLBTERM_KEY)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SLRASCD	SLRASCD_TERM_CODE	SLBTERM_TERM_CODE	SLBTERM	(1,1)-(0,n)

Link between SLRPSCD and SLBTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SLRPSCD and SLBTERM (FK1_SLRPSCD_INV_SLBTERM_KEY)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SLRPSCD	SLRPSCD_TERM_CODE	SLBTERM_TERM_CODE	SLBTERM	(1,1)-(0,n)

Link between SLRPFCR and SLRPSCD

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SLRPFCR and SLRPSCD (FK1_SLRPFCR_INV_SLRPSCD_KEY)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SLRPFCR	SLRPFCR_TERM_CODE	SLRPSCD_TERM_CODE	SLRPSCD	(1,1)-(0,n)
SLRPFCR	SLRPFCR_PSCD_CODE	SLRPSCD_PSCD_CODE	SLRPSCD	(1,1)-(0,n)

Link between SLBRMAP and PK_SLBRMAP

Link List

Link Type	Link	Project
Rely On	Link Between SLBRMAP and PK_SLBRMAP	SATURN

List of Real links

Link type	Between	And
Rely On	SLBRMAP	PK_SLBRMAP

Link between SLRBCAT and PK_SLRBCAT

Link List

Link Type	Link	Project
Rely On	Link Between SLRBCAT and PK_SLRBCAT	SATURN

List of Real links

Link type	Between	And
Rely On	SLRBCAT	PK_SLRBCAT

Link between SLBRMAP and SLRBCAT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SLBRMAP and SLRBCAT (FK1_SLBRMAP_INV_SLRBCAT_KEY)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SLBRMAP	SLBRMAP_PREFERED_BUILDING	SLRBCAT_BLDG_CODE	SLRBCAT	(0,1)-(0,n)
SLBRMAP	SLBRMAP_PREFERED_BCAT_CODE	SLRBCAT_CODE	SLRBCAT	(0,1)-(0,n)

Link between SLRCOLC and PK_SLRCOLC

Link List

Link Type	Link	Project
Rely On	Link Between SLRCOLC and PK_SLRCOLC	SATURN

List of Real links

Link type	Between	And
Rely On	SLRCOLC	PK_SLRCOLC

Link between SLRCOLR and PK_SLRCOLR

Link List

Link Type	Link	Project
Rely On	Link Between SLRCOLR and PK_SLRCOLR	SATURN

List of Real links

Link type	Between	And
Rely On	SLRCOLR	PK_SLRCOLR

Link between SLBRMPF and PK_SLBRMPF

Link List

Link Type	Link	Project
Rely On	Link Between SLBRMPF and PK_SLBRMPF	SATURN

List of Real links

Link type	Between	And
Rely On	SLBRMPF	PK_SLBRMPF

Link between SLRBDEF and PK_SLRBDEF

Link List

Link Type	Link	Project
Rely On	Link Between SLRBDEF and PK_SLRBDEF	SATURN

List of Real links

Link type	Between	And
Rely On	SLRBDEF	PK_SLRBDEF

Link between SLBEVNT and PK_SLBEVNT

Link List

Link Type	Link	Project
Rely On	Link Between SLBEVNT and PK_SLBEVNT	SATURN

List of Real links

Link type	Between	And
Rely On	SLBEVNT	PK_SLBEVNT

Link between SLRLMFE and SLBTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SLRLMFE and SLBTERM (FK1_SLRLMFE_INV_SLBTERM_KEY)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SLRLMFE	SLRLMFE_TERM_CODE	SLBTERM_TERM_CODE	SLBTERM	(1,1)-(0,n)

Link between SLRRDEF and PK_SLRRDEF

Link List

Link Type	Link	Project
Rely On	Link Between SLRRDEF and PK_SLRRDEF	SATURN

List of Real links

Link type	Between	And
Rely On	SLRRDEF	PK_SLRRDEF

Link between SLRMSCD and PK_SLRMSCD

Link List

Link Type	Link	Project
Rely On	Link Between SLRMSCD and PK_SLRMSCD	SATURN

List of Real links

Link type	Between	And
Rely On	SLRMSCD	PK_SLRMSCD

Link between SLRMFCR and SLRMSCD

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SLRMFCR and SLRMSCD (FK1_SLRMFCR_INV_SLRMSCD_KEY)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SLRMFCR	SLRMFCR_TERM_CODE	SLRMSCD_TERM_CODE	SLRMSCD	(1,1)-(0,n)
SLRMFCR	SLRMFCR_MSCD_CODE	SLRMSCD_MSCD_CODE	SLRMSCD	(1,1)-(0,n)

Link between SLRMSCD and SLBTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SLRMSCD and SLBTERM (FK1_SLRMSCD_INV_SLBTERM_KEY)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SLRMSCD	SLRMSCD_TERM_CODE	SLBTERM_TERM_CODE	SLBTERM	(1,1)-(0,n)