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    Platinum HESI Use
PS_AA_OVERRIDE     X X   Student Pgm Rule,Students
PS_AA_OVRD_CRSDATA     X X   Student Pgm Rule,Students
PS_AA_OVRD_DATA       X   Student Pgm Rule
PS_AA_OVRD_WHERE       X   Student Pgm Rule
PS_ACAD_GROUP_TBL   X X X X Lookups,Rule Work Table
PS_ACAD_LEVEL_TBL       X X Lookups
PS_ACAD_ORG_TBL   X X X X Lookups
PS_ACAD_PLAN     X X   Lookups,Rule Work Table,Students
PS_ACAD_PLAN_TBL     X X   Lookups,Rule Work Table,Planner,Students
PS_ACAD_PROG     X X   Lookups,Rule Work Table,Students
PS_ACAD_PROG_TBL     X X   Lookups,Rule Work Table
PS_ACAD_SUBPLAN     X X   Students
PS_ACAD_SUBPLN_TBL     X X   Lookups,Rule Work Table,Students
PS_CAMPUS_EVENT read, insert, update and delete (for Campus Calendar update only)     X   Section export
PS_CAMPUS_LOC_TBL X     X   CampusBuildingRoomSection export
PS_CAMPUS_MTG read, insert, update and delete (for Campus Calendar update only)     X   Section export
PS_CAMPUS_TBL X 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 X Sections
PS_CLASS_MTG_PAT read and update X X X X Section import and export
PS_CLASS_TBL read and update X X X X Course,Section import and export,Students
PS_CLST_DETL_TBL       X   Rule Work Table,Planner
PS_CLST_MAIN_TBL       X   Rule Work Table,Planner
PS_CRSE_ATTR_TBL       X X Lookups
PS_CRSE_ATTRIBUTES       X X Courses
PS_CRSE_CATALOG X X X X X Courses,Sections,Rule Work Table,Students,Planner
PS_CRSE_COMPONENT X     X X Courses
PS_CRSE_OFFER X X X X X Courses,Sections,Student Pgm Rules,Rule Work Table,Students,Planner
PS_CRSE_EQUIV_TBL   X X      
PS_DEGREE_TBL     X X   Lookups
PS_EMAIL_ADDRESSES X     X X Sections
PS_EVENT_LAST_TBL read, insert and update(for Campus Calendar only)     X   Section export
PS_FACILITY_TBL X X X X X CampusBuildingRoom, Section import and export, Section details
PS_INSTRUCT_MODE   X X     Viewing section details
PS_MILESTONE_TBL       X X Lookups
PS_NAMES X X X X X Sections,Students
PS_ROOM_CHRSTC_TBL X         Section import, only if Importing Room Feature Preferences
PS_RQ_COND_LINE       X   Rule Work Table
PS_RQ_COND_LN_DETL       X   Rule Work Table
PS_RQ_CONDITION       X   Rule Work Table
PS_RQ_ENT_GRP_DETL       X   Rule Work Table
PS_RQ_ENTITY_GROUP       X   Rule Work Table
PS_RQ_GRP_DETL_TBL       X   Rule Work Table, Planner
PS_RQ_GRP_TBL       X   Rule Work Table, SDA,Planner
PS_RQ_LINE_TBL       X   Rule Work Table, SDA,Planner
PS_RQ_LN_DETL_TBL       X   Rule Work Table, Planner
PS_RQ_MAIN_TBL       X   Rule Work Table, SDA,Planner
PS_RQMNT_DESIG_TBL       X X Lookups
PS_SAA_ADB_COURSES       X   SDA/Batch Audit Import
PS_SAA_ADB_CRSEAVL       X   SDA/Batch Audit Import
PS_SAA_ADB_CRSEUSE       X   SDA/Batch Audit Import
PS_SAA_ADB_RESULTS       X   SDA/Batch Audit Import
PS_SCTN_CMBND X X X X X Section import and export
PS_SCTN_CMBND_TBL X X X X X Section import and export
PS_SESSION_TBL   X X     Viewing section details
PS_STDNT_CAR_MLSTN       X   Students
PS_STDNT_CAR_TERM     X X   Lookups,Students
PS_STDNT_CRS_SUBS       X   Student Pgm Rule
PS_STDNT_ENRL     X X X Courses,Students
PS_STDNT_GROUP_TBL       X   Lookups
PS_STDNT_GRPS_HIST       X   Lookups,Students
PS_STDNT_TEST_COMP       X   Lookups,Students
PS_SUBJECT_TBL       X X Lookups
PS_TERM_TBL X X X X X Courses,Sections,Terms,Students
PS_TRNS_CRSE_DTL     X X X Courses,Students
PS_TRNS_CRSE_SCH     X X   Students
PS_TRNS_CRSE_TERM     X 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 X   Students
PS_TRNS_TEST_TERM X   X     Students, Academic History
PS_UA_DT_SEQ *       X   Smart Planner only
PS_UA_DT_STD_RSLT *       X   Smart Planner only
PSXLATITEM   X 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.