|
||
The Astra Schedule database user must have access to the following PeopleSoft tables.
NOTE: Additionally, synonyms must be created for each table as the Astra Schedule user to facilitate direct queries against the database.
Details related to the queries used, including specific SIS fields involved, will be provided upon request. Additionally, the queries can be found in the XML import and/or export spoke files in your installation. For example, in a standard installation these files would be located in C:\Ad Astra\%YourInstance%\Files\ATEConfiguration\Spokes\SIS.
*All tables require select access unless specified
Platinum |
HESI |
Astra Schedule |
Used for… |
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 |
PS_ACAD_PLAN |
|
Lookups, Rule Work Table, Students |
PS_ACAD_PLAN_TBL |
PS_ACAD_PLAN_TBL |
|
Lookups, Rule Work Table, Planner, Students |
PS_ACAD_PROG |
PS_ACAD_PROG |
|
Lookups, Rule Work Table, Students |
PS_ACAD_PROG_TBL |
PS_ACAD_PROG_TBL |
|
Lookups, Rule Work Table |
PS_ACAD_SUBPLAN |
|
|
Students |
PS_ACAD_SUBPLN_TBL |
PS_ACAD_SUBPLN_TBL |
|
Lookups, Rule Work Table, Students |
PS_AUDIT_AD_ASTRA7 |
|
PS_AUDIT_AD_ASTRA7 (read, insert, update and delete) (for audit table only) |
Sections |
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 |
CampusBuildingRoom Section 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 |
|
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 |
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 |
|
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 |
|
|
|
PS_SAA_ADB_CRSEAVL |
|
|
|
PS_SAA_ADB_CRSEUSE |
|
|
|
PS_SAA_ADB_RESULTS |
|
|
|
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 |
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 |
PS_STDNT_GROUP_TBL |
|
Lookups |
PS_STDNT_GRPS_HIST |
PS_STDNT_GRPS_HIST |
|
Lookups, Students |
PS_STDNT_TEST_COMP |
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 |
|
|
Planner |
PS_UA_DT_STD_RSLT |
|
|
Planner |
PSXLATITEM |
PSXLATITEM |
|
Lookups |