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

Ver: 8.1