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 | X | Lookups |
Comments
Please sign in to leave a comment.