RETURN TO COMPOSITE VIEW REPORTS LIST
Student Composite View Reports

SGHE Operational Data Store
Composite View Target: AS_ROOM_ASSIGNMENT

Description Source composite view contains room assignments.

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

STVTERM

SLRRASG_TERM_CODE

STVTERM_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)

FUNCTION

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

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_NUM Building phone number. 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

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)

FUNCTION

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

FUNCTION

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

FUNCTION

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

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

SLBRDEF

SLBRDEF_PHONE_AREA

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

SLBRDEF

SLBRDEF_PHONE_EXTENSION

ROOM_PHONE_NUM 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(4)

SLRRASG

SLRRASG_RRCD_CODE

ROOM_RATE_DESC Room rate code description. VARCHAR2(30)

FUNCTION

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

FUNCTION

GOKODSF.F_GET_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: 3.1