Model Location Management

Model Label : ERD For Banner Student Location Management Module ( SL% Tables )
Path : BANNER DEV/Student/Location_Management/Location Management

List of Objects

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

Comments

Model View

Table SLBBLDG

Schema Name SATURN
Label SLBBLDG
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:10:000

Table Columns information

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

Foreign Key information

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

Index

Index Name	Index Type	Column Name
PK_SLBBLDG	Unique	SLBBLDG_BLDG_CODE

Comments

Source Code Comments

Location/Building Description Table

Columns Comments for SLBBLDG_BLDG_CODE (1)

Source Code Comments

This column identifies the building code associated with the building record

Columns Comments for SLBBLDG_CAMP_CODE (2)

Source Code Comments

This column identifies the campus in which the building is located

Columns Comments for SLBBLDG_CAPACITY (3)

Source Code Comments

This column identifies the capacity of the building

Columns Comments for SLBBLDG_MAXIMUM_CAPACITY (4)

Source Code Comments

This column identifies the maximum capacity of the building

Columns Comments for SLBBLDG_RRCD_CODE (5)

Source Code Comments

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

Columns Comments for SLBBLDG_PRCD_CODE (6)

Source Code Comments

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

Columns Comments for SLBBLDG_SITE_CODE (7)

Source Code Comments

This column identifies the site of the building

Columns Comments for SLBBLDG_STREET_LINE1 (8)

Source Code Comments

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

Columns Comments for SLBBLDG_STREET_LINE2 (9)

Source Code Comments

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

Columns Comments for SLBBLDG_STREET_LINE3 (10)

Source Code Comments

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

Columns Comments for SLBBLDG_CITY (11)

Source Code Comments

This column identifies the city where the building is located

Columns Comments for SLBBLDG_STAT_CODE (12)

Source Code Comments

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

Columns Comments for SLBBLDG_ZIP (13)

Source Code Comments

This column identifies the zip code of the building

Columns Comments for SLBBLDG_CNTY_CODE (14)

Source Code Comments

This column identifies the county code of the building

Columns Comments for SLBBLDG_PHONE_AREA (15)

Source Code Comments

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

Columns Comments for SLBBLDG_PHONE_NUMBER (16)

Source Code Comments

This column identifies the phone number for the building

Columns Comments for SLBBLDG_PHONE_EXTENSION (17)

Source Code Comments

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

Columns Comments for SLBBLDG_ACTIVITY_DATE (18)

Source Code Comments

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

Columns Comments for SLBBLDG_SEX (19)

Source Code Comments

This column identifies the gender associated with the building

Columns Comments for SLBBLDG_COLL_CODE (20)

Source Code Comments

This column identifies the college that is associated with the building

Columns Comments for SLBBLDG_DEPT_CODE (21)

Source Code Comments

This column identifies the department that is associated with the building

Columns Comments for SLBBLDG_KEY_NUMBER (22)

Source Code Comments

This column identifies the number of the key to the building

Columns Comments for SLBBLDG_PARS_CODE (23)

Source Code Comments

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

Table SLBEVNT

Schema Name SATURN
Label SLBEVNT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:10:000

Table Columns information

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

Foreign Key information

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

Index

Index Name	Index Type	Column Name
PK_SLBEVNT	Unique	SLBEVNT_CRN

Comments

Source Code Comments

Event Base Table

Columns Comments for SLBEVNT_CRN (1)

Source Code Comments

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

Columns Comments for SLBEVNT_ETYP_CODE (2)

Source Code Comments

This field defines type associated with the event

Columns Comments for SLBEVNT_DESC (3)

Source Code Comments

This field identifies the description of the event

Columns Comments for SLBEVNT_AGENCY_PIDM (4)

Source Code Comments

This field identifies the agency pidm associated with the event

Columns Comments for SLBEVNT_CONTACT_NAME (5)

Source Code Comments

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

Columns Comments for SLBEVNT_CAMP_CODE (6)

Source Code Comments

This field identifies the campus that is associated with the event

Columns Comments for SLBEVNT_SITE_CODE (7)

Source Code Comments

This field identifies the site that is associated with the event

Columns Comments for SLBEVNT_COLL_CODE (8)

Source Code Comments

This field identifies the college that is associated with the event

Columns Comments for SLBEVNT_DEPT_CODE (9)

Source Code Comments

This field identifies the department that is associated with the event

Columns Comments for SLBEVNT_ACTIVITY_DATE (10)

Source Code Comments

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

Columns Comments for SLBEVNT_PHONE_AREA (11)

Source Code Comments

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

Columns Comments for SLBEVNT_PHONE (12)

Source Code Comments

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

Columns Comments for SLBEVNT_PHONE_EXT (13)

Source Code Comments

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

Columns Comments for SLBEVNT_CONTACT_PIDM (14)

Source Code Comments

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

Columns Comments for SLBEVNT_ATYP_CODE (15)

Source Code Comments

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

Columns Comments for SLBEVNT_SYSI_CODE (16)

Source Code Comments

Code indicating the product that created the event.

Columns Comments for SLBEVNT_COMM_IND (17)

Source Code Comments

Committee/Service Indicator.

Columns Comments for SLBEVNT_DICD_CODE (18)

Source Code Comments

District/Division Code.

Table SLBRDEF

Schema Name SATURN
Label SLBRDEF
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:10:000

Table Columns information

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

Foreign Key information

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

Index

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

Comments

Source Code Comments

Room Description Table

Columns Comments for SLBRDEF_BLDG_CODE (1)

Source Code Comments

This field identifies the building code associated with the room

Columns Comments for SLBRDEF_ROOM_NUMBER (2)

Source Code Comments

This field identifies the room number associated with the room

Columns Comments for SLBRDEF_ACTIVITY_DATE (3)

Source Code Comments

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

Columns Comments for SLBRDEF_DESC (4)

Source Code Comments

This field identifies the description associated with the room

Columns Comments for SLBRDEF_CAPACITY (5)

Source Code Comments

This field defines the capacity of the room

Columns Comments for SLBRDEF_MAXIMUM_CAPACITY (6)

Source Code Comments

This field defines the maximum capacity of the room

Columns Comments for SLBRDEF_RMST_CODE (7)

Source Code Comments

This field defines the status code associated with the room

Columns Comments for SLBRDEF_RRCD_CODE (8)

Source Code Comments

This field defines the room rate code associated with the room

Columns Comments for SLBRDEF_PRCD_CODE (9)

Source Code Comments

This field defines the phone rate code associated with the room

Columns Comments for SLBRDEF_UTILITY_RATE (10)

Source Code Comments

This field defines the utility rate associated with the room, this field is inf ormational only

Columns Comments for SLBRDEF_UTILITY_RATE_PERIOD (11)

Source Code Comments

This field defines the time period the utility rate is associated with the room

Columns Comments for SLBRDEF_PHONE_AREA (12)

Source Code Comments

This field identifies the area code of the room

Columns Comments for SLBRDEF_PHONE_NUMBER (13)

Source Code Comments

This field identifies the phone number of the room

Columns Comments for SLBRDEF_PHONE_EXTENSION (14)

Source Code Comments

This field identifies the phone extension number of the room

Columns Comments for SLBRDEF_BCAT_CODE (15)

Source Code Comments

This field identifies the building category associated with the room

Columns Comments for SLBRDEF_SEX (16)

Source Code Comments

This field identifies the gender associated with the room

Columns Comments for SLBRDEF_ROOM_TYPE (17)

Source Code Comments

This field defines the room type of the building, is it a Dorm, Class, or Other Room

Columns Comments for SLBRDEF_PRIORITY (18)

Source Code Comments

This field defines the priority of the room, it is used by the scheduler to det ermine which rooms are used first

Columns Comments for SLBRDEF_COLL_CODE (19)

Source Code Comments

This field identifies the college that is associated with the room

Columns Comments for SLBRDEF_DEPT_CODE (20)

Source Code Comments

This field identifies the department that is associated with the room

Columns Comments for SLBRDEF_KEY_NUMBER (21)

Source Code Comments

This field identifies the number of the key to the room

Columns Comments for SLBRDEF_WIDTH (22)

Source Code Comments

This field shows the width, in feet, of the the room

Columns Comments for SLBRDEF_LENGTH (23)

Source Code Comments

This field shows the length, in feet, of the the room

Columns Comments for SLBRDEF_AREA (24)

Source Code Comments

This field shows the area, in square feet, of the room

Columns Comments for SLBRDEF_TERM_CODE_EFF (25)

Source Code Comments

Term code effective date.

Columns Comments for SLBRDEF_PARS_CODE (26)

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.

Table SLBRMAP

Schema Name SATURN
Label SLBRMAP
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:10:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SLBRMAP_PIDM	SLBRMAP_PIDM	NUMBER(8,0)	No	*	*
SLBRMAP_ACTIVITY_DATE	SLBRMAP_ACTIVITY_DATE	DATE	No
SLBRMAP_ARTP_CODE	SLBRMAP_ARTP_CODE	VARCHAR2(4)	No		*
SLBRMAP_FROM_TERM	SLBRMAP_FROM_TERM	VARCHAR2(6)	No	*	*
SLBRMAP_FROM_TERM	SLBRMAP_FROM_TERM	VARCHAR2(6)	No	*	*
SLBRMAP_TO_TERM	SLBRMAP_TO_TERM	VARCHAR2(6)	No		*
SLBRMAP_APPL_PRIORITY	SLBRMAP_APPL_PRIORITY	VARCHAR2(8)	Yes
SLBRMAP_PREFERED_BUILDING	SLBRMAP_PREFERED_BUILDING	VARCHAR2(6)	Yes		*
SLBRMAP_PREFERED_ROOM	SLBRMAP_PREFERED_ROOM	VARCHAR2(10)	Yes
SLBRMAP_PREFERED_BCAT_CODE	SLBRMAP_PREFERED_BCAT_CODE	VARCHAR2(4)	Yes		*
SLBRMAP_PREFERED_CAMP_CODE	SLBRMAP_PREFERED_CAMP_CODE	VARCHAR2(3)	Yes		*
SLBRMAP_MRCD_CODE	SLBRMAP_MRCD_CODE	VARCHAR2(4)	Yes		*
SLBRMAP_PR_PIDM	SLBRMAP_PR_PIDM	NUMBER(8,0)	Yes
SLBRMAP_CONFID_IND	SLBRMAP_CONFID_IND	VARCHAR2(1)	Yes
SLBRMAP_HAPS_CODE	SLBRMAP_HAPS_CODE	VARCHAR2(2)	Yes		*
SLBRMAP_HAPS_DATE	SLBRMAP_HAPS_DATE	DATE	Yes
SLBRMAP_ADD_DATE	SLBRMAP_ADD_DATE	DATE	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_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

Comments

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

Table SLBRMPF

Schema Name SATURN
Label SLBRMPF
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:10:000

Table Columns information

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

Foreign Key information

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

Index

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

Comments

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

Schema Name SATURN
Label SLBTERM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:10:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SLBTERM_TERM_CODE	SLBTERM_TERM_CODE	VARCHAR2(6)	No	*	*
SLBTERM_ACTIVITY_DATE	SLBTERM_ACTIVITY_DATE	DATE	No
SLBTERM_HOUS_ALLOWED	SLBTERM_HOUS_ALLOWED	VARCHAR2(1)	No
SLBTERM_FEE_ASSESSMENT	SLBTERM_FEE_ASSESSMENT	VARCHAR2(1)	No
SLBTERM_FEE_ASSESSMNT_EFF_DATE	SLBTERM_FEE_ASSESSMNT_EFF_DATE	DATE	Yes
SLBTERM_ONEUP	SLBTERM_ONEUP	NUMBER(5,0)	Yes
SLBTERM_MNTH_CUTOFF	SLBTERM_MNTH_CUTOFF	NUMBER(2,0)	Yes
SLBTERM_CUTOFF_DATE	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

Comments

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

Schema Name SATURN
Label SLRASCD
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:11:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SLRASCD_TERM_CODE	SLRASCD_TERM_CODE	VARCHAR2(6)	No	*	*
SLRASCD_TERM_CODE	SLRASCD_TERM_CODE	VARCHAR2(6)	No	*	*
SLRASCD_ASCD_CODE	SLRASCD_ASCD_CODE	VARCHAR2(2)	No	*	*
SLRASCD_START_DATE	SLRASCD_START_DATE	DATE	Yes
SLRASCD_END_DATE	SLRASCD_END_DATE	DATE	Yes
SLRASCD_ACTIVITY_DATE	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

Comments

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

Schema Name SATURN
Label SLRBCAT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:11:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
SLRBCAT_BLDG_CODE	SLRBCAT_BLDG_CODE	VARCHAR2(6)	No	*
SLRBCAT_CODE	SLRBCAT_CODE	VARCHAR2(4)	No	*
SLRBCAT_DESC	SLRBCAT_DESC	VARCHAR2(30)	No
SLRBCAT_ACTIVITY_DATE	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

Comments

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

Schema Name SATURN
Label SLRBCMT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:11:000

Table Columns information

Column Name	Label	Column Type	Allow NULL
SLRBCMT_BLDG_CODE	SLRBCMT_BLDG_CODE	VARCHAR2(6)	No
SLRBCMT_SEQNO	SLRBCMT_SEQNO	NUMBER(23,20)	No
SLRBCMT_COMMENTS	SLRBCMT_COMMENTS	VARCHAR2(60)	No
SLRBCMT_ACTIVITY_DATE	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

Comments

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

Schema Name SATURN
Label SLRBDEF
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:11:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
SLRBDEF_BLDG_CODE	SLRBDEF_BLDG_CODE	VARCHAR2(6)	No	*
SLRBDEF_RDEF_CODE	SLRBDEF_RDEF_CODE	VARCHAR2(5)	No	*
SLRBDEF_ACTIVITY_DATE	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

Comments

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

Schema Name SATURN
Label SLRCMNT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:11:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
SLRCMNT_BLDG_CODE	SLRCMNT_BLDG_CODE	VARCHAR2(6)	No	*
SLRCMNT_ROOM_NUMBER	SLRCMNT_ROOM_NUMBER	VARCHAR2(10)	No	*
SLRCMNT_COMMENTS	SLRCMNT_COMMENTS	VARCHAR2(60)	No
SLRCMNT_SEQNO	SLRCMNT_SEQNO	NUMBER(23,20)	No	*
SLRCMNT_ACTIVITY_DATE	SLRCMNT_ACTIVITY_DATE	DATE	No
SLRCMNT_TERM_CODE_EFF	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

Comments

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

Schema Name SATURN
Label SLRCOLC
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:11:000

Table Columns information

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