The Astra database user must have access to the following PeopleSoft tables.
- 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.
- All tables require select access unless specified from select access to read access
| Table |
Astra Schedule |
Monitor w/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 | Lookups,Rule Work Table | |||
| PS_ACAD_LEVEL_TBL | X | X | Lookups | |||
| PS_ACAD_ORG_TBL | 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 | 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_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 | Section import and export | ||
| PS_SCTN_CMBND_TBL | 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 | Students, Academic History | ||||
| PS_TRNS_OTHR_TERM | X | Students, Academic History | ||||
| PS_TRNS_TEST_DTL | X | X | Students | |||
| PS_TRNS_TEST_TERM | 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
0 comments
Please sign in to leave a comment.