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