PeopleSoft Database Access

Database User Access

The Astra database user must have access to the tables listed below.  Additionally, synonyms must be created for each table as the Astra user to facilitate direct queries against the database. Details related to the queries used, including specific SIS fields involved, will be provided upon request.

Table Astra Schedule Monitor/Align Predict HESI Use
PS_AA_OVERRIDE     X   Student Pgm Rule,Students
PS_AA_OVRD_CRSDATA     X   Student Pgm Rule,Students
PS_ACAD_GROUP_TBL   X X X Lookups,Rule Work Table
PS_ACAD_LEVEL_TBL       X Lookups
PS_ACAD_ORG_TBL   X X X Lookups
PS_ACAD_PLAN     X   Lookups,Rule Work Table,Students
PS_ACAD_PLAN_TBL     X   Lookups,Rule Work Table,Planner,Students
PS_ACAD_PROG     X   Lookups,Rule Work Table,Students
PS_ACAD_PROG_TBL     X   Lookups,Rule Work Table
PS_ACAD_SUBPLAN     X   Students
PS_ACAD_SUBPLN_TBL     X   Lookups,Rule Work Table,Students
PS_CAMPUS_EVENT read, insert, update and delete (for Campus Calendar update only)       Section export
PS_CAMPUS_LOC_TBL X       CampusBuildingRoomSection export
PS_CAMPUS_MTG read, insert, update and delete (for Campus Calendar update only)       Section export
PS_CAMPUS_TBL X X X X CampusBuildingRoom,Courses
PS_CLASS_CHRSTC X   X   Section import, only if Importing Room Feature Preferences
PS_CLASS_INSTR X X X X Sections
PS_CLASS_MTG_PAT read and update X X X Section import and export
PS_CLASS_TBL read and update X X X Course,Section import and export,Students
PS_CRSE_ATTR_TBL       X Lookups
PS_CRSE_ATTRIBUTES       X Courses
PS_CRSE_CATALOG X X X X Courses,Sections,Rule Work Table,Students,Planner
PS_CRSE_COMPONENT X     X Courses
PS_CRSE_OFFER X X X X Courses,Sections,Student Pgm Rules,Rule Work Table,Students,Planner
PS_CRSE_EQUIV_TBL   X X    
PS_DEGREE_TBL     X   Lookups
PS_EMAIL_ADDRESSES X     X Sections
PS_EVENT_LAST_TBL read, insert and update(for Campus Calendar only)       Section export
PS_FACILITY_TBL X X X X CampusBuildingRoom, Section import and export, Section details
PS_INSTRUCT_MODE   X X   Viewing section details
PS_MILESTONE_TBL       X Lookups
PS_NAMES X X X X Sections,Students
PS_ROOM_CHRSTC_TBL X       Section import, only if Importing Room Feature Preferences
PS_RQMNT_DESIG_TBL       X Lookups
PS_SCTN_CMBND X X X X Section import and export
PS_SCTN_CMBND_TBL X X X X Section import and export
PS_SESSION_TBL   X X   Viewing section details
PS_STDNT_CAR_TERM     X   Lookups,Students
PS_STDNT_ENRL     X X Courses,Students
PS_SUBJECT_TBL       X Lookups
PS_TERM_TBL X X X X Courses,Sections,Terms,Students
PS_TRNS_CRSE_DTL     X X Courses,Students
PS_TRNS_CRSE_SCH     X   Students
PS_TRNS_CRSE_TERM     X   Students
PS_TRNS_OTHR_DTL X   X   Students, Academic History
PS_TRNS_OTHR_TERM X   X   Students, Academic History
PS_TRNS_TEST_DTL     X   Students
PS_TRNS_TEST_TERM X   X   Students, Academic History
PSXLATITEM   X X Lookups
All tables are read-only access unless specified.

Was this article helpful?
2 out of 2 found this helpful

Comments

0 comments

Please sign in to leave a comment.