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_CLST_DETL_TBL | X | Pre Reqs on courses in pathways | |||
PS_CLST_MAIN_TBL | X | Pre Reqs on courses in pathways | |||
PS_CRSE_ATTR_TBL | X | X | X | Lookups | |
PS_CRSE_ATTRIBUTES | X | X | 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 | X | Lookups, Student attributes, test codes | ||
PS_NAMES | X | X | X | X | Sections,Students |
PS_ROOM_CHRSTC_TBL | X | Section import, only if Importing Room Feature Preferences | |||
PS_RQ_GRP_DETL_TBL | X |
Pre Reqs on courses in pathways |
|||
PS_RQ_GRP_TBL | X |
Pre Reqs on courses in pathways |
|||
PS_RQ_LINE_TBL | X |
Pre Reqs on courses in pathways |
|||
PS_RQ_LN_DETL_TBL | X |
Pre Reqs on courses in pathways |
|||
PS_RQ_MAIN_TBL | X |
Pre Reqs on courses in pathways |
|||
PS_RQMNT_DESIG_TBL | X | X | X | Lookups | |
PS_SA_TEST_TBL | X | Student attributes, test codes | |||
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_CAR_MLSTN | X | Student attributes, test codes | |||
PS_STDNT_ENRL | X | X | Courses,Students | ||
PS_STDNT_GROUP_TBL | X | Student attributes, test codes | |||
PS_STDNT_GRPS_HIST |
X | Student attributes, test codes | |||
PS_STDNT_TEST_COMP |
X | Student attributes, test codes | |||
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 | X | Lookups |
Comments
Please sign in to leave a comment.