Database User Access

 

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.

 

•PS_FACILITY_TBL (read only)

•PS_SCTN_CMBND (read only)

•PS_SCTN_CMBND_TBL (read only)

•PS_CLASS_INSTR (read only)

•PS_NAMES (read only)

•PS_EMAIL_ADDRESSES (read only)

•PS_CAMPUS_LOC_TBL (read only)

•PS_CAMPUS_TBL (read only)

•PS_TERM_TBL (read only)

•PS_CLASS_TBL (read and update)

•PS_CLASS_MTG_PAT (read and update)

•PS_CRSE_CATALOG (read only)

•PS_CRSE_COMPONENT (read only)

•PS_CRSE_OFFER (read only)

 

If Importing Room Feature Preferences:

 

•PS_ROOM_CHRSTC_TBL (read only)

•PS_CLASS_CHRSTC (read only)

 

For Campus Calendar:

 

•PS_CAMPUS_MTG (read, insert, update and delete)

•PS_CAMPUS_EVENT (read, insert, update and delete)

•PS_CAMPUS_EVNT_LNG (read, insert, update and delete)

•PS_EVENT_LAST_TBL (read, insert and update)

 

For Audit Table:

 

•PS_AUDIT_AD_ASTRA7 (read, insert, update and delete)

 

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.