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 | Platinum | HESI | Monitor/Align | Astra Schedule | Use |
|---|---|---|---|---|---|
| PS_AA_OVERRIDE | X | Student Pgm Rule,Students | |||
| PS_AA_OVRD_CRSDATA | 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 | 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 | X | read, insert, update and delete (for Campus Calendar update only) | Section export | ||
| PS_CAMPUS_LOC_TBL | X | X | CampusBuildingRoomSection export | ||
| PS_CAMPUS_MTG | X | read, insert, update and delete (for Campus Calendar update only) | Section export | ||
| PS_CAMPUS_TBL | X | X | X | X | CampusBuildingRoom,Courses |
| X | Section import, only if Importing Room Feature Preferences | ||||
| PS_CLASS_INSTR | X | X | X | Sections | |
| PS_CLASS_MTG_PAT | X | X | read and update | Section import and export | |
| PS_CLASS_TBL | X | X | X |
read and update |
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 | Courses,Sections,Rule Work Table,Students,Planner |
| PS_CRSE_COMPONENT | X | X | X | Courses | |
| PS_CRSE_OFFER | X | X | X | X | Courses,Sections,Student Pgm Rules,Rule Work Table,Students,Planner |
| PS_DEGREE_TBL | X | Lookups | |||
| PS_EMAIL_ADDRESSES | X | X | X | Sections | |
| PS_EVENT_LAST_TBL | X | read, insert and update(for Campus Calendar only) | Section export | ||
| PS_FACILITY_TBL | X | X | X | CampusBuildingRoom,Section import and export | |
| PS_MILESTONE_TBL | X | X | Lookups | ||
| PS_NAMES | 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_STDNT_CAR_MLSTN | X | Students | |||
| PS_STDNT_CAR_TERM | X | Lookups,Students | |||
| PS_STDNT_CRS_SUBS | X | Student Pgm Rule | |||
| PS_STDNT_ENRL | 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 | 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_TEST_DTL | X | Students | |||
| PS_UA_DT_SEQ * | X | Smart Planner only | |||
| PS_UA_DT_STD_RSLT * | X | Smart Planner only | |||
| PSXLATITEM | X | X | X | Lookups |
Comments
0 comments
Please sign in to leave a comment.