Skip to main content
EMS Software, LLC

PowerCampus Views Data Model

EMS Software will code a set of views specific to your organization’s use of PowerCampus to allow for integration between EMS and PowerCampus. Outlined are the baseline tables/columns accessed in the views.

You will be provided a Campus Technical Environment Questionnaire which allows for identification of specific fields used by EMS that tend to vary in individual PowerCampus implementations. Following return of the questionnaire, EMS Views will be coded for your organization and a final review done in EMS. Your Implementation Consultant can assist in more detailed explanations or demonstrations of how the information will be used in EMS to support the Academic Scheduling process, as needed for completion of the questionnaire.  Once reviewed and accepted, further view modifications will be subject to EMS Professional Services time and materials fees.

Note: Optionally and on a custom basis, up to 10 User Defined Fields can be added to the set of views for each organization to support desired workflow. Detailed business requirements are needed to provide a quote for customization of the views for this purpose. 

Modification of views by the customer is unsupported and voids the Annual Service Agreement for the integration with PowerCampus.

Fields highlighted in BLUE are required to be unique.

Buildings

EMS View: EMS_vwBuildings

View Permissions: Read Only

PowerCampus Tables: BUILDING

Purpose: Used to define buildings list in EMS. Required for buildings that host academic courses; additional buildings can be added manually to EMS if used only for non-academic purposes.

EMS Field

PowerCampus Field

SISID

BUILDING_CODE

BuildingCode

BUILDING_CODE

BuildingDescription

BUILD_NAME_1

Room Types

EMS View: EMS_vwRoomTypes

View Permissions: Read Only

PowerCampus Tables: CODE_ROOMTYPE

Purpose: Used to define room type list in EMS. Room Types classify each room and allows for searching, sorting, and reporting by classification. Additional room types can be added to EMS manually.

EMS Field

PowerCampus Field

SISID

CODE_VALUE_KEY

RoomTypeDescription

LONG_DESC

Rooms

EMS View: EMS_vwRooms

View Permissions: Read Only

PowerCampus Tables: ROOM

Purpose: Used to define list of rooms and their capacities for academic purposes in EMS; related to Buildings and Room Types. Required for rooms that host academic courses; additional rooms can be added manually to EMS if used only for non-academic purposes.

EMS Field

PowerCampus Field

SISID

BUILDING_CODE + ROOM_ID

SISBuildingID

BUILDING_CODE

SISRoomTypeID

ROOM_TYPE

RoomCode

ROOM_ID

RoomDescription

ROOM_NAME

Capacity

MAX_OCCUPANCY

Instructors

EMS View: EMS_vwInstructors

View Permissions: Read Only

PowerCampus Tables: PEOPLE, SECTIONPER

Purpose: Used to define list of instructors in EMS; related to Courses.

EMS Field

PowerCampus Field

SISID

PEOPLE_CODE_ID

InstructorDescription

LAST_NAME + FIRST_NAME

*uses SIRASGN to determine primary instructor (SIRASGN_PRIMARY_IND)

Terms

EMS View: EMS_vwTerms

View Permissions: Read Only

PowerCampus Tables: SECTIONS, ACADEMICCALENDAR, CODE_ACASESSION

Purpose: Used to define list of terms in EMS; related to Courses.  In conjunction with Domains, terms separate courses into distinct lists that will go through the academic planning process (synching, optimizing, publishing, reporting) as a unit. 

EMS Field

PowerCampus Field

SISID

ACADEMIC_YEAR + ACADEMIC_TERM + ACADEMIC_SESSION

TermCode

ACADEMIC_YEAR + ACADEMIC_TERM + ACADEMIC_SESSION

TermDescription

ACADEMIC_YEAR + ACADEMIC_TERM + CODE_ACASESSION.LONG_DESC

StartDate

ACADEMICCALENDAR.START_DATE

EndDate

ACADEMICCALENDAR.END_DATE

Subjects

EMS View: EMS_vwSubjects

View Permissions: Read Only

PowerCampus Tables: CODE_DEPARTMENT, SECTIONS, ORGANIZATION

Purpose: Used to define list of subjects in EMS. Within EMS, subjects are divided into Domains in order to create distinct lists of courses per term that will go through the academic planning process (synching, optimizing, publishing, reporting) as a unit, managed by the academic central scheduler.

EMS Field

PowerCampus Field

SISID

CODE_VALUE_KEY

SubjectCode

CODE_VALUE_KEY

SubjectDescription

LONG_DESC

CampusCode

ORGANIZATION.ORG_IDENTIFIER*

DivisionCode

NULL

DepartmentCode

NULL

LevelCode

NULL

CustomCode1

NULL

CustomCode2

NULL

*NULL if not using Campus Codes

Course Types

EMS View: EMS_vwCourseTypes

View Permissions: Read Only

PowerCampus Tables: CODE_EVENTSUBTYPE

Purpose: Used to define the course type list in EMS; related to coursedates. Course Types are used to classify coursedates for purposes of searching, sorting, optimizing, and reporting.

EMS Field

PowerCampus Field

SISID

CODE_VALUE_KEY

Description

LONG_DESC

Courses

EMS View: EMS_vwCourses

View Permissions: Read Only

PowerCampus Tables: SECTIONS, SECTIONPER, ORGANIZATION, SECTIONCROSSTALLY

Purpose: Used to define the list of courses per term; related to subjects, instructors, terms.

EMS Field

PowerCampus Field

SISID

ACADEMIC_YEAR + ACADEMIC_TERM + ACADEMIC_SESSION + EVENT_ID + EVENT_SUB_TYPE + SECTION

SISTermID

ACADEMIC_YEAR + ACADEMIC_TERM + ACADEMIC_SESSION

SISSubjectID

DEPARTMENT

CampusCode

ORGANIZATION.ORG_IDENTIFIER*

DepartmentCode

NULL

LevelCode

NULL

CustomCode1

NULL

CustomCode2

NULL

CRN

SECTIONID

Course

EVENT_ID

Section

SECTION

CourseTitle

EVENT_LONG_NAME

SISInstructorID

SECTIONPER.PERSON_CODE_ID

EstimatedEnrollment

MAX_PARTICIPANT

CrosslistParentID

SECTIONCROSSTALLY .ACADEMIC_YEAR + SECTIONCROSSTALLY .ACADEMIC_TERM + SECTIONCROSSTALLY .ACADEMIC_SESSION + SECTIONCROSSTALLY .EVENT_ID + SECTIONCROSSTALLY .EVENT_SUB_TYPE + SECTIONCROSSTALLY .SECTION **

ActualEnrollment

ADDS

CreditHours

CREDITS

*NULL if not using Campus Codes
**’0’ if not crosslisted. Uses EMS_vwCrosslistings (definition below)

Course Dates

EMS View: EMS_vwCourseDates

View Permissions: Update if allowing EMS to update room locations in PowerCampus

PowerCampus Tables: SECTIONSCHEDULE, SECTIONS, CODE_DAY

Purpose: Used to define the list of meeting patterns per course; related to courses, coursetypes, buildings, rooms.

EMS Field

PowerCampus Field

SISID

SECTIONSCHEDULE_ID

SISTermID

ACADEMIC_YEAR + ACADEMIC_TERM + ACADEMIC_SESSION

SISCourseID

ACADEMIC_YEAR + ACADEMIC_TERM + ACADEMIC_SESSION + EVENT_ID + EVENT_SUB_TYPE + SECTION

StartDate

SECTIONS.START_DATE

EndDate

SECTIONS.END_DATE

StartTime

START_TIME

EndTime

END_TIME

SISBuildingID

BUILDING_CODE

SISRoomID

BUILDING_CODE + ROOM_ID

RoomID

ROOM_ID

Sunday

CODE_DAY.DAY_SUNDAY

Monday

CODE_DAY.DAY_MONDAY

Tuesday

CODE_DAY.DAY_TUESDAY

Wednesday

CODE_DAY.DAY_WEDNESDAY

Thursday

CODE_DAY.DAY_THURSDAY

Friday

CODE_DAY.DAY_FRIDAY

Saturday

CODE_DAY.DAY_SATURDAY

SISCourseTypeID

EVENT_SUB_TYPE

Course Crosslistings

EMS View: EMS_vwCrosslistings

View Permissions: Read Only

PowerCampus Tables: SECTIONCROSSTALLY

Purpose: Used to identify a cross list parent child relationship for crosslistings to work in EMS.

EMS Field

PowerCampus Field

Crosslist1

ACADEMIC_YEAR + ACADEMIC_TERM + ACADEMIC_SESSION + EVENT_ID + EVENT_SUB_TYPE + SECTION

Crosslist2

ACADEMIC_YEAR + ACADEMIC_TERM + ACADEMIC_SESSION + EVENT_ID + EVENT_SUB_TYPE + SECTION