Data, Academic Planning & Institutional Research

HOUS MY UW HOUSING

DATA VIEW NAME
HOUS_MY_UW_HOUSING
OVERVIEW
Progress tracking for students completing their contract on My UW Housing.
LOAD FREQUENCY
The data is replaced every night.
DATA CUSTODIAN
University Housing
Contact: Brian Ward
AUTHORIZATION
You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to the InfoAccess Home Page
SPECIAL
CONSIDERATIONS
QUESTIONS
Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357)
LAST UPDATED
06/2014 – New view created.
DATA FORMATS
Primary Key Columns are identified with an asterisk(*)
Alphanumeric Data
VARCHAR2( N) (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘ABC’ or ‘A’
Numeric Data
NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions.
X = total number of digits
Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12
Date
DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)
Column Name Format Description
PERSON_ID NUMBER (10) Identifier for a person.
*CONTRACT_ID NUMBER (10) Unique system-generated identifier for a housing contract.
PERSON_NAME VARCHAR2 (50 Byte) Full name in the following format: last, first middle.
CAMPUS_ID VARCHAR2 (10 Byte) Campus ID on the Integrated Student Information System.
ACADEMIC_YEAR VARCHAR2 (50 Byte) Term/academic year description.
SESSION_DESCR VARCHAR2 (50 Byte) An “Academic Year” or Housing term may contain multiple “sessions”. For example, Academic Year 2002-03 contains two sessions: “Academic Year” and “Spring Only”. Summer has motile housing sessions that generally correspond with the various summer class sessions (i.e. “Eight Week Summer Session’).
WELCOME_REVIEWED DATE The date and time that the student completed the welcome page.
VERIFY_REVIEWED DATE The date and time that the student completed the verification page.
ROOMMATE_TYPE VARCHAR2 (9 Byte) The type of roommate the student selected on their preference page. Values: Preferred,Random
ROOMMATE_MATCH VARCHAR2 (1 Byte) If the student selected Preferred roommate_type, then do the two roommates have matching criteria. Values: Y,N
CLASS_SECTIONS_REVIEWED DATE The date and time that the student completed the academics page.
CLASS_CONNECTIONS VARCHAR2 (1 Byte)
Did the student enroll in the class connections program. Values Y,N
AUTHORIZED_PAYER_REVIEWED DATE The date and time that the student completed the authorized payer page.
HEALTH_HISTORY_REVIEWED DATE The date and time that the student completed the health history page.
HEALTH_HISTORY_EMAIL VARCHAR2 (1 Byte) Did the student send the health history email to their contacts. Values: Y,N
QUARTERLY_BILL_REVIEWED DATE The date and time that the student completed the quarterly bill page.
QUARTERLY_BILL_EMAIL VARCHAR2 (1 Byte) Did the student send the quarterly bill email to their contacts. Values: Y,N
FOOD_ACCOUNT_REVIEWED DATE The date and time that the student completed the food account page.
FOOD_ACCOUNT_EMAIL VARCHAR2 (1 Byte) Did the student send the food account email to their contacts. Values: Y,N
EXPECTATIONS_REVIEWED DATE The date and time that the student completed the expectations section.
MOVE_IN_REVIEWED DATE The date and time that the student completed the move-in page.
MOVE_IN_EMAIL VARCHAR2 (1 Byte) Did the student send the move-in email to their contacts. Values: Y,N
EXTRACT_DATE_TIME DATE The date and time these data were extracted.
Format : YYYYMMDD HH24:MI:SS