Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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	Building Phone Area	Area code for the phone number for the building.	VARCHAR2(6)		SLBBLDG	SLBBLDG_PHONE_AREA
BUILDING_PHONE_EXT	Building Phone Extension	Phone extension for the building.	VARCHAR2(10)		SLBBLDG	SLBBLDG_PHONE_EXTENSION
BUILDING_PHONE_NUM	Building Phone Number	Building phone number.	VARCHAR2(12)		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(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	Room Phone Area	Telephone area code for this room.	VARCHAR2(6)		SLBRDEF	SLBRDEF_PHONE_AREA
ROOM_PHONE_EXT	Room Phone Extension	Telephone extension number for this room.	VARCHAR2(10)		SLBRDEF	SLBRDEF_PHONE_EXTENSION
ROOM_PHONE_NUM	Room Phone Number	Telephone number for this room.	VARCHAR2(12)		SLBRDEF	SLBRDEF_PHONE_NUMBER
ROOM_PHONE_NUM_COMBINED	Room Phone Number 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: