Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
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
|
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
|
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
|
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
|
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
|
SLRRASG
|
SLRRASG_TOTAL_DAYS
|
ROOM_TOTAL_MONTHS
|
Total number of months in the current room assignment.
|
NUMBER
|
SLRRASG
|
SLRRASG_TOTAL_MONTHS
|
ROOM_TOTAL_PERIODS
|
Total number of academic periods in the current room assignment.
|
NUMBER
|
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
|