RETURN TO REPORTING VIEW REPORTS LIST
Student Reporting View Reports

SGHE Operational Data Store
Reporting View Target: ROOM_ASSIGNMENT

Description Contains data on all room assignments made to institution residence halls and other tracked housing facilities. Details are included for student academic period assignments as well as specialized room assignments for a conference or a day, etc.
Key & Frequency One row per person per academic period per building and room number.
Recommended Search Columns PERSON_UID, ACADEMIC_YEAR, ACADEMIC_PERIOD, SUB_ACADEMIC_PERIOD

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period or time frame this housing assignment is active. VARCHAR2(63)

SLRRASG

STVTERM

SLRRASG_TERM_CODE

STVTERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

ACADEMIC_YEAR Academic year associated with the academic period on this record. VARCHAR2(4)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

BUILDING Building code for the room assignment. VARCHAR2(63)

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(255)

FUNCTION

GOKODSF.F_GET_DESC

BUILDING_PHONE_AREA Area code for the phone number for the building. VARCHAR2(3)

SLBBLDG

SLBBLDG_PHONE_AREA

BUILDING_PHONE_EXT Phone extension for the building. VARCHAR2(4)

SLBBLDG

SLBBLDG_PHONE_EXTENSION

BUILDING_PHONE_NUMBER Building phone number for current room assignment. VARCHAR2(7)

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(14)

CALCULATION

SLBBLDG_PHONE_AREA||SLBBLDG_PHONE_NUMBER||SLBBLDG_PHONE_EXTENSION

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(94)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

SLRRASG

SLRRASG_PIDM

PREFERRED_BUILDING Preferred housing building code. VARCHAR2(63)

SLBRMAP

SLBRMAP_PREFERED_BUILDING

PREFERRED_BUILDING_DESC Building description associated with the building code. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PREFERRED_CAMPUS Applicant's preferred campus for housing room assignment. VARCHAR2(63)

SLBRMAP

SLBRMAP_PREFERED_CAMP_CODE

PREFERRED_CAMPUS_DESC Institution campus description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PREFERRED_CATEGORY Applicant's preferred category for housing. VARCHAR2(63)

SLBRMAP

SLBRMAP_PREFERED_BCAT_CODE

PREFERRED_CATEGORY_DESC Category code description. VARCHAR2(255)

SLRBCAT

SLRBCAT_DESC

PREFERRED_ROOM Applicant's preferred room for housing. VARCHAR2(63)

SLBRMAP

SLBRMAP_PREFERED_ROOM

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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(63)

SLBRMAP

SLBRMAP_FROM_TERM

ROOM_APPLICATION_STATUS Current room application status for this applicant. VARCHAR2(63)

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(255)

FUNCTION

GOKODSF.F_GET_DESC

ROOM_APPLICATION_TO_PERIOD End academic period for this room application. VARCHAR2(63)

SLBRMAP

SLBRMAP_TO_TERM

ROOM_APPLICATION_TYPE Type of room requested in this application and whether an associated meal plan is requested. VARCHAR2(63)

SLBRMAP

SLBRMAP_ARTP_CODE

ROOM_APPLICATION_TYPE_DESC Requested type of room and or meal plan description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_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(3)

SLBRDEF

SLBRDEF_PHONE_AREA

ROOM_PHONE_EXT Telephone extension number for this room. VARCHAR2(4)

SLBRDEF

SLBRDEF_PHONE_EXTENSION

ROOM_PHONE_NUMBER Telephone number for this room. VARCHAR2(7)

SLBRDEF

SLBRDEF_PHONE_NUMBER

ROOM_PHONE_NUM_COMBINED Combined area code, phone number, and extension of the room. VARCHAR2(14)

CALCULATION

SLBRDEF_PHONE_AREA||SLBRDEF_PHONE_NUMBER||SLBRDEF_PHONE_EXTENSION

ROOM_RATE Identifies the rate code for current room assignment. VARCHAR2(63)

SLRRASG

SLRRASG_RRCD_CODE

ROOM_RATE_DESC Room rate code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ROOM_RATE_TIME Describes whether the time is monthly, daily or academic period basis for the room rate charges. VARCHAR2(63)

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(63)

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(255)

FUNCTION

GOKODSF.F_GET_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 Identifies the current type of room assigned. VARCHAR2(63)

SLBRDEF

SLBRDEF_ROOM_TYPE

ROOM_TYPE_DESC Current room type description. VARCHAR2(255)

CALCULATION

DECODE(SLBRDEF_ROOM_TYPE,'D','DORM','C','CLASS','OTHER')

SUB_ACADEMIC_PERIOD A session, portion or part of the academic period. VARCHAR2(63)

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(255)

NA

NA



Ver: 3.1