ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACADEMIC_PERIOD	Academic period or time frame this housing assignment is active.			SLRRASG	SLRRASG_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.			STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.			STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.			STVACYR	STVACYR_DESC
BUILDING	Building code for the room assignment.			SLRRASG	SLRRASG_BLDG_CODE
BUILDING_CAPACITY	Maximum number of persons that may be in the building at time.			SLBBLDG	SLBBLDG_MAXIMUM_CAPACITY
BUILDING_DESC	Name of the building.			STVBLDG	STVBLDG_DESC
BUILDING_PHONE_AREA	Area code for the phone number for the building.			SLBBLDG	SLBBLDG_PHONE_AREA
BUILDING_PHONE_EXT	Phone extension for the building.			SLBBLDG	SLBBLDG_PHONE_EXTENSION
BUILDING_PHONE_NUM	Building phone number.			SLBBLDG	SLBBLDG_PHONE_NUMBER
BUILDING_PHONE_NUM_COMBINED	Complete telephone number for the building which combines the area code, phone number, and extension recorded for the building.			CALCULATION	SLBBLDG_PHONE_AREA||SLBBLDG_PHONE_NUMBER||SLBBLDG_PHONE_EXTENSION
CURRENT_DATE	System current date (sysdate) or date the data was extracted.			NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.			NA	NA
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
PERSON_UID	System generated, unique, internal identification number assigned to this person.			SLRRASG	SLRRASG_PIDM
PREFERRED_BUILDING	Preferred housing building code.			SLBRMAP	SLBRMAP_PREFERED_BUILDING
PREFERRED_BUILDING_DESC	Building associated with the building code.			STVBLDG	STVBLDG_DESC
PREFERRED_CAMPUS	Applicant's preferred campus for housing room assignment.			SLBRMAP	SLBRMAP_PREFERED_CAMP_CODE
PREFERRED_CAMPUS_DESC	Institution campus description.			STVCAMP	STVCAMP_DESC
PREFERRED_CATEGORY	Applicant's preferred category for housing.			SLBRMAP	SLBRMAP_PREFERED_BCAT_CODE
PREFERRED_CATEGORY_DESC	Category code description.			SLRBCAT	SLRBCAT_DESC
PREFERRED_ROOM	Applicant's preferred room for housing.			SLBRMAP	SLBRMAP_PREFERED_ROOM
ROOM_APPLICATION_DATE_ADDED	Date the room application was added to the system.			SLBRMAP	SLBRMAP_ADD_DATE
ROOM_APPLICATION_FROM_PERIOD	Beginning academic period for this room application.			SLBRMAP	SLBRMAP_FROM_TERM
ROOM_APPLICATION_STATUS	Current room application status for this applicant.			SLBRMAP	SLBRMAP_HAPS_CODE
ROOM_APPLICATION_STATUS_DATE	Date the room application status was last updated.			SLBRMAP	SLBRMAP_HAPS_DATE
ROOM_APPLICATION_STATUS_DESC	Current room application status description.			STVHAPS	STVHAPS_DESC
ROOM_APPLICATION_TO_PERIOD	End academic period for this room application.			SLBRMAP	SLBRMAP_TO_TERM
ROOM_APPLICATION_TYPE	Identifies the type of room requested in this application, and whether an associated meal plan is requested.			SLBRMAP	SLBRMAP_ARTP_CODE
ROOM_APPLICATION_TYPE_DESC	Requested type of room and or meal plan description.			STVARTP	STVARTP_DESC
ROOM_ASSESSMENT_IND	Indicates whether charges must be processed for the room assignment.			SLRRASG	SLRRASG_ASSESS_NEEDED
ROOM_CAPACITY	Identifies the current room capacity.			SLBRDEF	SLBRDEF_MAXIMUM_CAPACITY
ROOM_CHARGES_IND	Indicates whether room charges have been processed to the accounts receivable account.			SLRRASG	SLRRASG_AR_IND
ROOM_END_DATE	End date for current room assignment.			SLRRASG	SLRRASG_END_DATE
ROOM_NUMBER	Current room number assigned.			SLBRDEF	SLBRDEF_ROOM_NUMBER
ROOM_OVERLOAD_IND	Indicates whether an overload condition exists based on the current assignments to this room.			SLRRASG	SLRRASG_OVERLOAD_IND
ROOM_OVERRIDE_IND	Indicates whether an overload condition exists based on the current assignments to this room.			SLRRASG	SLRRASG_OVERRIDE_ERROR
ROOM_PHONE_AREA	Telephone area code for this room.			SLBRDEF	SLBRDEF_PHONE_AREA
ROOM_PHONE_EXT	Telephone extension number for this room.			SLBRDEF	SLBRDEF_PHONE_EXTENSION
ROOM_PHONE_NUM	Telephone number for this room.			SLBRDEF	SLBRDEF_PHONE_NUMBER
ROOM_PHONE_NUM_COMBINED	Combined area code, phone number, and extension of the room.			CALCULATION	SLBRDEF_PHONE_AREA||SLBRDEF_PHONE_NUMBER||SLBRDEF_PHONE_EXTENSION
ROOM_RATE	Identifies the rate code for current room assignment.			SLRRASG	SLRRASG_RRCD_CODE
ROOM_RATE_DESC	Room rate code description.			STVRRCD	STVRRCD_DESC
ROOM_RATE_TIME	Description of time basis relative to the room rate.			CALCULATION	DECODE(STVRRCD_MONTHLY_IND,'Y','MONTHLY',DECODE(STVRRCD_DAILY_IND,'Y','DAILY','TERMLY'))
ROOM_ROLL_IND	Controls whether the current room assignment can be rolled forward to the next academic period through automated processing.			SLRRASG	SLRRASG_ROLL_IND
ROOM_START_DATE	Start date for current room assignment.			SLRRASG	SLRRASG_BEGIN_DATE
ROOM_STATUS	Identifies current room assignment status. For example, active or inactive, etc.			SLRRASG	SLRRASG_ASCD_CODE
ROOM_STATUS_DATE	Date the room assignment status was last updated.			SLRRASG	SLRRASG_ASCD_DATE
ROOM_STATUS_DESC	Current room assignment status description.			STVASCD	STVASCD_DESC
ROOM_TOTAL_DAYS	Total number of days in the current room assignment.			SLRRASG	SLRRASG_TOTAL_DAYS
ROOM_TOTAL_MONTHS	Total number of months in the current room assignment.			SLRRASG	SLRRASG_TOTAL_MONTHS
ROOM_TOTAL_PERIODS	Total number of academic periods in the current room assignment.			SLRRASG	SLRRASG_TOTAL_TERMS
ROOM_TYPE	C+G7383urrent type of room assigned.			SLBRDEF	SLBRDEF_ROOM_TYPE
ROOM_TYPE_DESC	Current room type description.			CALCULATION	DECODE(SLBRDEF_ROOM_TYPE,'D','DORM','C','CLASS','OTHER')
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.			NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.			NA	NA
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA

Ver: 8.3