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

Ver: