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.
EMS Software has created a set of views for
Your Implementation Consultant can further assist you with the use of information in EMS supporting the Academic Scheduling process.
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 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 |