DARTS : On-campus Housing all Four Years

Report Purpose

This report is used by Institutional Research to determine how many students live on campus all 4 years of their undergraduate career. Two queries are required to encompass all institutions.  They are designed to pull in students who live on campus as of a specific effective date, so may need to be used with an additional query or run multiple times to get the data for all four years.

Report Location

MyCampus > MaineStreet > Enterprise Applications > Campus Solutions-92-Reporting > PS Query tile > Query Manager or Query Viewer

Note - If your CSRPT Reporting Homepage dashboard does not have a PS Query tile, contact the UMS - Campus Solutions Security Liaisons for your institution.

Report Name

1. UMS_IR_RESH - Pulls in students from the RL_STDNT_ROOM table which contains the residence hall information for all students in the UMS with the exception of UM), and is effective-dated and term-based. 

2. UMS_IR_RESH_V2- UMS05 Students in Res. Halls - Pulls in students from the ADDRESSES table who had an active, effective-dated "RESH" address-type (Residence Hall). This is specifically for UM as they do not appear to populate RL_STDNT_ROOM.

Report Type

Query

Prompts Required

For information on field values to enter, click the name of the prompt.

1. Term
2. None

Data Fields Generated

1.

2.

Tables Used

1. RL_STDNT_ROOM - ResLife - Student Room Assignm
2. ADDRESSES - Address Type