Key Benefits and Features

When you use this feature, you gain:

• Centralized data staging for multiple systems
• Standardized data transformations
• Consistent data delivery across systems
• Simplified integration maintenance
• Regular data synchronization
• Built-in data quality rules
• Historical tracking of changes
• Compliance-ready data structure

AccessIT Housing System

• Purpose: Populates housing and residence life data from Colleague
• Refresh Schedule: Daily updates
• Schema: accessit
• Views:
  • accessit.Housing - Comprehensive housing assignments and status
  • accessit.LiveStudentCards - Active student card information
• Source Tables:
  • [DW-IWUDATA].dbo.STUDENTS
  • [DW-IWUDATA].dbo.PEOPLE
  • [RP-COLLEAGUE].dbo.ROOM_ASSIGNMENT
  • [RP-COLLEAGUE].dbo.BUILDINGS
  • [RP-COLLEAGUE].dbo.STUDENT_TERMS

Entrust ID Card System

• Purpose: Manages student and employee ID card data
• Refresh Schedule: Daily updates
• Schema: entrust
• Tables:
  • entrust.Enrollment - Card enrollment and status information
• Source Tables:
  • [DW-IWUDATA].dbo.STUDENTS
  • [DW-IWUDATA].dbo.PEOPLE

MedProctor Health Database

• Purpose: Synchronizes student health information
• Refresh Schedule: Daily updates
• Schema: dbo
• Tables:
  • dbo.MedProctorUsers - Core user information
  • dbo.MedProctorUserDetail - Detailed user information
  • dbo.MedProctorStagedUsers - Staging table for user data
• Source Tables:
  • [DW-IWUDATA].dbo.STUDENTS
  • [DW-IWUDATA].dbo.PEOPLE

Papercut Printing System

• Purpose: Manages student printing allocations and usage
• Refresh Schedule: Daily updates
• Schema: Papercut
• Tables:
  • Papercut.People - User information for printing system
• Source Tables:
  • [DW-IWUDATA].dbo.STUDENTS
  • [DW-IWUDATA].dbo.PEOPLE

Pharos Advising System

• Purpose: Synchronizes academic advising data
• Refresh Schedule: Daily updates
• Schema: pharos
• Views:
  • pharos.Student_Data - Core student information
  • pharos.Employee_Data - Employee information
  • pharos.Class_List - Course enrollment information
  • pharos.Class_Information - Course details
  • pharos.Enrollment_Data_Extended - Extended enrollment information
  • pharos.Enrollment_Data_Grades - Grade information
  • pharos.Extended_Student_Data_Academics - Academic information
  • pharos.Extended_Student_Data_Academics_Expanded - Detailed academic data
  • pharos.Extended_Student_Data_Admissions - Admissions information
  • pharos.Extended_Student_Data_Campus_Involvement - Campus activities
  • pharos.Extended_Student_Data_Demographics - Student demographics
  • pharos.Extended_Student_Data_FERPA - FERPA-related information
  • pharos.Extended_Student_Data_Financial - Financial information
  • pharos.Extended_Student_Data_Peer_View - Peer comparison data
  • pharos.Extended_Student_Data_Retention_Intelligence - Retention metrics
  • pharos.Extended_Data_Relationships_All - Relationship information
  • pharos.uStudentSelection - Student selection utility
  • pharos.uStaffSelection - Staff selection utility
  • pharos.uApplicantSelection - Applicant selection utility
  • pharos.uTermSelection - Term selection utility
• Source Tables:
  • [DW-IWUDATA].dbo.STUDENTS
  • [DW-IWUDATA].dbo.PEOPLE
  • [DW-IWUDATA].dbo.DEPARTMENTS
  • [DW-IWUDATA].dbo.COURSES
  • [DW-IWUDATA].dbo.ENROLLMENTS

Terradotta

• Purpose: Manages Terradotta program data
• Refresh Schedule: Daily updates
• Schema: terradotta
• Views:
  • terradotta.BaseUserData - Core user information
  • Study Abroad - Study abroad program details
  • Travel Registry - Travel registration information
  • terradotta.EmergencyContacts - Emergency contact information
  • ISSS - International Student and Scholar Services data
• Integration
  • Terradotta Integration - Indiana Wesleyan University Support Knowledge Base
• Source Tables:
  • [DW-IWUDATA].dbo.STUDENTS
  • [DW-IWUDATA].dbo.PEOPLE
  • [DW-IWUDATA].dbo.[STUDENTS-ACADEMIC_PROGRAMS]
  • [DW-IWUDATA].dbo.EMERGENCY_CONTACTS
  • [DW-IWUDATA].dbo.INTERNATIONAL_STUDENTS