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 STVTERM	SLRRASG_TERM_CODE STVTERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.			STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.			FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR_DESC	Academic year description.			STVACYR	STVACYR_DESC
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
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_NUMBER	Building phone number for current room assignment.			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
ID	Person's or organization's current identification number.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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 description 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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
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	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_NUMBER	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	Describes whether the time is monthly, daily or academic period basis for the room rate charges.			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	Identifies the current 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

Ver: 8.3