Report Title Report Name or Query Name Report Type Data
Source
Business Process Reporting Area
Facilities Definition History UCCS_R_CONFIG_FACILITIES_HIST PS Query   Create and Manage Curriculum Room Scheduling
 

Query Name: UCCS_R_CONFIG_FACILITIES_HIST
Report Title: Facilities Definition History
Purpose: Reporting on Facilities Table history data (showing changes over time)
Description: Rows: One row per Facility ID, per effective date, filtered by optional user-entered prompts

Columns: Broad set of data elements from Facilities Table
 
Required prompts: None

Optional Prompts: General Assignment (Y/N), Facility Type, Owning Org, Building,
Facility ID, Status

Records Used: FACILITIES_TBL, BLDG_TBL

User Access Group: SR Registrar Course Catalog
Process: Create and Manage Curriculum
Usage Notes:  Use to view history of changes to Facility definitions as defined in Campus solutions. Shows all effective dates for each Facility ID returned.
Report Elements: For description of elements visit the Custom Fields Table