Reporting View Target: ROOM

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: ROOM_ASSIGNMENT

Description Contains data on all room assignments made to institution residence halls and other tracked housing facilities. Details are included for student academic period assignments as well as specialized room assignments for a conference or a day, etc.
Key & Frequency One row per person per academic period per building and room number.
Recommended Search Columns PERSON_UID, ACADEMIC_YEAR, ACADEMIC_PERIOD, SUB_ACADEMIC_PERIOD

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ACADEMIC_PERIOD Academic Period Academic period or time frame this housing assignment is active. VARCHAR2(63)
SLRRASG
STVTERM

SLRRASG_TERM_CODE
STVTERM_CODE

ACADEMIC_PERIOD_DESC Academic Period Description Academic period description. VARCHAR2(255)
STVTERM

STVTERM_DESC

ACADEMIC_YEAR Academic Year Academic year associated with the academic period on this record. VARCHAR2(4)
FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_DESC Academic Year Description Academic year description. VARCHAR2(255)
STVACYR

STVACYR_DESC

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

BUILDING Building Building code for the room assignment. VARCHAR2(63)
SLRRASG

SLRRASG_BLDG_CODE

BUILDING_CAPACITY Building Capacity Maximum number of persons that may be in the building at time. NUMBER
SLBBLDG

SLBBLDG_MAXIMUM_CAPACITY

BUILDING_DESC Building Description Name of the building. VARCHAR2(255)
STVBLDG

STVBLDG_DESC

BUILDING_PHONE_AREA Building Phone Area Area code for the phone number for the building. VARCHAR2(63)
SLBBLDG

SLBBLDG_PHONE_AREA

BUILDING_PHONE_EXT Building Phone Extension Phone extension for the building. VARCHAR2(63)
SLBBLDG

SLBBLDG_PHONE_EXTENSION

BUILDING_PHONE_NUMBER Building Phone Number Building phone number for current room assignment. VARCHAR2(63)
SLBBLDG

SLBBLDG_PHONE_NUMBER

BUILDING_PHONE_NUM_COMBINED Building Phone Number Combined Complete telephone number for the building which combines the area code, phone number, and extension recorded for the building. VARCHAR2(63)
CALCULATION

SLBBLDG_PHONE_AREA||SLBBLDG_PHONE_NUMBER||SLBBLDG_PHONE_EXTENSION

ID ID Person's or organization's current identification number. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

NAME Name Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER
SLRRASG

SLRRASG_PIDM

PREFERRED_BUILDING Preferred Building Preferred housing building code. VARCHAR2(63)
SLBRMAP

SLBRMAP_PREFERED_BUILDING

PREFERRED_BUILDING_DESC Preferred Building Description Building description associated with the building code. VARCHAR2(255)
STVBLDG

STVBLDG_DESC

PREFERRED_CAMPUS Preferred Campus Applicant's preferred campus for housing room assignment. VARCHAR2(63)
SLBRMAP

SLBRMAP_PREFERED_CAMP_CODE

PREFERRED_CAMPUS_DESC Preferred Campus Description Institution campus description. VARCHAR2(255)
STVCAMP

STVCAMP_DESC

PREFERRED_CATEGORY Preferred Category Applicant's preferred category for housing. VARCHAR2(63)
SLBRMAP

SLBRMAP_PREFERED_BCAT_CODE

PREFERRED_CATEGORY_DESC Preferred Category Description Category code description. VARCHAR2(255)
SLRBCAT

SLRBCAT_DESC

PREFERRED_ROOM Preferred Room Applicant's preferred room for housing. VARCHAR2(63)
SLBRMAP

SLBRMAP_PREFERED_ROOM

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

ROOM_APPLICATION_DATE_ADDED Room Application Date Added Date the room application was added to the system. DATE
SLBRMAP

SLBRMAP_ADD_DATE

ROOM_APPLICATION_FROM_PERIOD Room Application From Period Beginning academic period for this room application. VARCHAR2(63)
SLBRMAP

SLBRMAP_FROM_TERM

ROOM_APPLICATION_STATUS Room Application Status Current room application status for this applicant. VARCHAR2(63)
SLBRMAP

SLBRMAP_HAPS_CODE

ROOM_APPLICATION_STATUS_DATE Room Application Status Date Date the room application status was last updated. DATE
SLBRMAP

SLBRMAP_HAPS_DATE

ROOM_APPLICATION_STATUS_DESC Room Application Status Description Current room application status description. VARCHAR2(255)
STVHAPS

STVHAPS_DESC

ROOM_APPLICATION_TO_PERIOD Room Application To Period End academic period for this room application. VARCHAR2(63)
SLBRMAP

SLBRMAP_TO_TERM

ROOM_APPLICATION_TYPE Room Application Type Type of room requested in this application and whether an associated meal plan is requested. VARCHAR2(63)
SLBRMAP

SLBRMAP_ARTP_CODE

ROOM_APPLICATION_TYPE_DESC Room Application Type Description Requested type of room and or meal plan description. VARCHAR2(255)
STVARTP

STVARTP_DESC

ROOM_ASSESSMENT_IND Room Assessment Indicator Indicates whether charges must be processed for the room assignment. VARCHAR2(1)
SLRRASG

SLRRASG_ASSESS_NEEDED

ROOM_CAPACITY Room Capacity Identifies the current room capacity. NUMBER
SLBRDEF

SLBRDEF_MAXIMUM_CAPACITY

ROOM_CHARGES_IND Room Charges Indicator Indicates whether room charges have been processed to the accounts receivable account. VARCHAR2(1)
SLRRASG

SLRRASG_AR_IND

ROOM_END_DATE Room End Date End date for current room assignment. DATE
SLRRASG

SLRRASG_END_DATE

ROOM_NUMBER Room Number Current room number assigned. VARCHAR2(10)
SLBRDEF

SLBRDEF_ROOM_NUMBER

ROOM_OVERLOAD_IND Room Overload Indicator Indicates whether an overload condition exists based on the current assignments to this room. VARCHAR2(1)
SLRRASG

SLRRASG_OVERLOAD_IND

ROOM_OVERRIDE_IND Room Override Indicator Indicates whether an overload condition exists based on the current assignments to this room. VARCHAR2(1)
SLRRASG

SLRRASG_OVERRIDE_ERROR

ROOM_PHONE_AREA Room Phone Area Telephone area code for this room. VARCHAR2(63)
SLBRDEF

SLBRDEF_PHONE_AREA

ROOM_PHONE_EXT Room Phone Extension Telephone extension number for this room. VARCHAR2(63)
SLBRDEF

SLBRDEF_PHONE_EXTENSION

ROOM_PHONE_NUMBER Room Phone Number Telephone number for this room. VARCHAR2(63)
SLBRDEF

SLBRDEF_PHONE_NUMBER

ROOM_PHONE_NUM_COMBINED Room Phone Number Combined Combined area code, phone number, and extension of the room. VARCHAR2(63)
CALCULATION

SLBRDEF_PHONE_AREA||SLBRDEF_PHONE_NUMBER||SLBRDEF_PHONE_EXTENSION

ROOM_RATE Room Rate Identifies the rate code for current room assignment. VARCHAR2(63)
SLRRASG

SLRRASG_RRCD_CODE

ROOM_RATE_DESC Room Rate Description Room rate code description. VARCHAR2(255)
STVRRCD

STVRRCD_DESC

ROOM_RATE_TIME Room Rate Time Describes whether the time is monthly, daily or academic period basis for the room rate charges. VARCHAR2(63)
CALCULATION

DECODE(STVRRCD_MONTHLY_IND,'Y','MONTHLY',DECODE(STVRRCD_DAILY_IND,'Y','DAILY','TERMLY'))

ROOM_ROLL_IND Room Roll Indicator Controls whether the current room assignment can be rolled forward to the next academic period through automated processing. VARCHAR2(1)
SLRRASG

SLRRASG_ROLL_IND

ROOM_START_DATE Room Start Date Start date for current room assignment. DATE
SLRRASG

SLRRASG_BEGIN_DATE

ROOM_STATUS Room Status Identifies current room assignment status. For example, active or inactive, etc. VARCHAR2(63)
SLRRASG

SLRRASG_ASCD_CODE

ROOM_STATUS_DATE Room Status Date Date the room assignment status was last updated. DATE
SLRRASG

SLRRASG_ASCD_DATE

ROOM_STATUS_DESC Room Status Description Current room assignment status description. VARCHAR2(255)
STVASCD

STVASCD_DESC

ROOM_TOTAL_DAYS Room Total Days Total number of days in the current room assignment. NUMBER
SLRRASG

SLRRASG_TOTAL_DAYS

ROOM_TOTAL_MONTHS Room Total Months Total number of months in the current room assignment. NUMBER
SLRRASG

SLRRASG_TOTAL_MONTHS

ROOM_TOTAL_PERIODS Room Total Periods Total number of academic periods in the current room assignment. NUMBER
SLRRASG

SLRRASG_TOTAL_TERMS

ROOM_TYPE Room Type Identifies the current type of room assigned. VARCHAR2(63)
SLBRDEF

SLBRDEF_ROOM_TYPE

ROOM_TYPE_DESC Room Type Description Current room type description. VARCHAR2(255)
CALCULATION

DECODE(SLBRDEF_ROOM_TYPE,'D','DORM','C','CLASS','OTHER')

SUB_ACADEMIC_PERIOD Sub Academic Period A session, portion or part of the academic period. VARCHAR2(63)
NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub Academic Period Description Sub academic period description. VARCHAR2(255)
NA

NA

Ver: 9.0

Description	Contains data on all room assignments made to institution residence halls and other tracked housing facilities. Details are included for student academic period assignments as well as specialized room assignments for a conference or a day, etc.
Key & Frequency	One row per person per academic period per building and room number.
Recommended Search Columns	PERSON_UID, ACADEMIC_YEAR, ACADEMIC_PERIOD, SUB_ACADEMIC_PERIOD

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic Period	Academic period or time frame this housing assignment is active.	VARCHAR2(63)	SLRRASG STVTERM	SLRRASG_TERM_CODE STVTERM_CODE
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic Year	Academic year associated with the academic period on this record.	VARCHAR2(4)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR_DESC	Academic Year Description	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
BUILDING	Building	Building code for the room assignment.	VARCHAR2(63)	SLRRASG	SLRRASG_BLDG_CODE
BUILDING_CAPACITY	Building Capacity	Maximum number of persons that may be in the building at time.	NUMBER	SLBBLDG	SLBBLDG_MAXIMUM_CAPACITY
BUILDING_DESC	Building Description	Name of the building.	VARCHAR2(255)	STVBLDG	STVBLDG_DESC
BUILDING_PHONE_AREA	Building Phone Area	Area code for the phone number for the building.	VARCHAR2(63)	SLBBLDG	SLBBLDG_PHONE_AREA
BUILDING_PHONE_EXT	Building Phone Extension	Phone extension for the building.	VARCHAR2(63)	SLBBLDG	SLBBLDG_PHONE_EXTENSION
BUILDING_PHONE_NUMBER	Building Phone Number	Building phone number for current room assignment.	VARCHAR2(63)	SLBBLDG	SLBBLDG_PHONE_NUMBER
BUILDING_PHONE_NUM_COMBINED	Building Phone Number Combined	Complete telephone number for the building which combines the area code, phone number, and extension recorded for the building.	VARCHAR2(63)	CALCULATION	SLBBLDG_PHONE_AREA\|\|SLBBLDG_PHONE_NUMBER\|\|SLBBLDG_PHONE_EXTENSION
ID	ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SLRRASG	SLRRASG_PIDM
PREFERRED_BUILDING	Preferred Building	Preferred housing building code.	VARCHAR2(63)	SLBRMAP	SLBRMAP_PREFERED_BUILDING
PREFERRED_BUILDING_DESC	Preferred Building Description	Building description associated with the building code.	VARCHAR2(255)	STVBLDG	STVBLDG_DESC
PREFERRED_CAMPUS	Preferred Campus	Applicant's preferred campus for housing room assignment.	VARCHAR2(63)	SLBRMAP	SLBRMAP_PREFERED_CAMP_CODE
PREFERRED_CAMPUS_DESC	Preferred Campus Description	Institution campus description.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC
PREFERRED_CATEGORY	Preferred Category	Applicant's preferred category for housing.	VARCHAR2(63)	SLBRMAP	SLBRMAP_PREFERED_BCAT_CODE
PREFERRED_CATEGORY_DESC	Preferred Category Description	Category code description.	VARCHAR2(255)	SLRBCAT	SLRBCAT_DESC
PREFERRED_ROOM	Preferred Room	Applicant's preferred room for housing.	VARCHAR2(63)	SLBRMAP	SLBRMAP_PREFERED_ROOM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ROOM_APPLICATION_DATE_ADDED	Room Application Date Added	Date the room application was added to the system.	DATE	SLBRMAP	SLBRMAP_ADD_DATE
ROOM_APPLICATION_FROM_PERIOD	Room Application From Period	Beginning academic period for this room application.	VARCHAR2(63)	SLBRMAP	SLBRMAP_FROM_TERM
ROOM_APPLICATION_STATUS	Room Application Status	Current room application status for this applicant.	VARCHAR2(63)	SLBRMAP	SLBRMAP_HAPS_CODE
ROOM_APPLICATION_STATUS_DATE	Room Application Status Date	Date the room application status was last updated.	DATE	SLBRMAP	SLBRMAP_HAPS_DATE
ROOM_APPLICATION_STATUS_DESC	Room Application Status Description	Current room application status description.	VARCHAR2(255)	STVHAPS	STVHAPS_DESC
ROOM_APPLICATION_TO_PERIOD	Room Application To Period	End academic period for this room application.	VARCHAR2(63)	SLBRMAP	SLBRMAP_TO_TERM
ROOM_APPLICATION_TYPE	Room Application Type	Type of room requested in this application and whether an associated meal plan is requested.	VARCHAR2(63)	SLBRMAP	SLBRMAP_ARTP_CODE
ROOM_APPLICATION_TYPE_DESC	Room Application Type Description	Requested type of room and or meal plan description.	VARCHAR2(255)	STVARTP	STVARTP_DESC
ROOM_ASSESSMENT_IND	Room Assessment Indicator	Indicates whether charges must be processed for the room assignment.	VARCHAR2(1)	SLRRASG	SLRRASG_ASSESS_NEEDED
ROOM_CAPACITY	Room Capacity	Identifies the current room capacity.	NUMBER	SLBRDEF	SLBRDEF_MAXIMUM_CAPACITY
ROOM_CHARGES_IND	Room Charges Indicator	Indicates whether room charges have been processed to the accounts receivable account.	VARCHAR2(1)	SLRRASG	SLRRASG_AR_IND
ROOM_END_DATE	Room End Date	End date for current room assignment.	DATE	SLRRASG	SLRRASG_END_DATE
ROOM_NUMBER	Room Number	Current room number assigned.	VARCHAR2(10)	SLBRDEF	SLBRDEF_ROOM_NUMBER
ROOM_OVERLOAD_IND	Room Overload Indicator	Indicates whether an overload condition exists based on the current assignments to this room.	VARCHAR2(1)	SLRRASG	SLRRASG_OVERLOAD_IND
ROOM_OVERRIDE_IND	Room Override Indicator	Indicates whether an overload condition exists based on the current assignments to this room.	VARCHAR2(1)	SLRRASG	SLRRASG_OVERRIDE_ERROR
ROOM_PHONE_AREA	Room Phone Area	Telephone area code for this room.	VARCHAR2(63)	SLBRDEF	SLBRDEF_PHONE_AREA
ROOM_PHONE_EXT	Room Phone Extension	Telephone extension number for this room.	VARCHAR2(63)	SLBRDEF	SLBRDEF_PHONE_EXTENSION
ROOM_PHONE_NUMBER	Room Phone Number	Telephone number for this room.	VARCHAR2(63)	SLBRDEF	SLBRDEF_PHONE_NUMBER
ROOM_PHONE_NUM_COMBINED	Room Phone Number Combined	Combined area code, phone number, and extension of the room.	VARCHAR2(63)	CALCULATION	SLBRDEF_PHONE_AREA\|\|SLBRDEF_PHONE_NUMBER\|\|SLBRDEF_PHONE_EXTENSION
ROOM_RATE	Room Rate	Identifies the rate code for current room assignment.	VARCHAR2(63)	SLRRASG	SLRRASG_RRCD_CODE
ROOM_RATE_DESC	Room Rate Description	Room rate code description.	VARCHAR2(255)	STVRRCD	STVRRCD_DESC
ROOM_RATE_TIME	Room Rate Time	Describes whether the time is monthly, daily or academic period basis for the room rate charges.	VARCHAR2(63)	CALCULATION	DECODE(STVRRCD_MONTHLY_IND,'Y','MONTHLY',DECODE(STVRRCD_DAILY_IND,'Y','DAILY','TERMLY'))
ROOM_ROLL_IND	Room Roll Indicator	Controls whether the current room assignment can be rolled forward to the next academic period through automated processing.	VARCHAR2(1)	SLRRASG	SLRRASG_ROLL_IND
ROOM_START_DATE	Room Start Date	Start date for current room assignment.	DATE	SLRRASG	SLRRASG_BEGIN_DATE
ROOM_STATUS	Room Status	Identifies current room assignment status. For example, active or inactive, etc.	VARCHAR2(63)	SLRRASG	SLRRASG_ASCD_CODE
ROOM_STATUS_DATE	Room Status Date	Date the room assignment status was last updated.	DATE	SLRRASG	SLRRASG_ASCD_DATE
ROOM_STATUS_DESC	Room Status Description	Current room assignment status description.	VARCHAR2(255)	STVASCD	STVASCD_DESC
ROOM_TOTAL_DAYS	Room Total Days	Total number of days in the current room assignment.	NUMBER	SLRRASG	SLRRASG_TOTAL_DAYS
ROOM_TOTAL_MONTHS	Room Total Months	Total number of months in the current room assignment.	NUMBER	SLRRASG	SLRRASG_TOTAL_MONTHS
ROOM_TOTAL_PERIODS	Room Total Periods	Total number of academic periods in the current room assignment.	NUMBER	SLRRASG	SLRRASG_TOTAL_TERMS
ROOM_TYPE	Room Type	Identifies the current type of room assigned.	VARCHAR2(63)	SLBRDEF	SLBRDEF_ROOM_TYPE
ROOM_TYPE_DESC	Room Type Description	Current room type description.	VARCHAR2(255)	CALCULATION	DECODE(SLBRDEF_ROOM_TYPE,'D','DORM','C','CLASS','OTHER')
SUB_ACADEMIC_PERIOD	Sub Academic Period	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub Academic Period Description	Sub academic period description.	VARCHAR2(255)	NA	NA