Data Access

Database User Access

The Astra Schedule database user must have access to the following PeopleSoft tables:

 

•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 write)

 

•PS_CLASS_MTG_PAT (read and write)

 

For Campus Calendar:

 

•PS_CAMPUS_MTG (read, write, insert and delete)

 

•PS_CAMPUS_EVENT (read, write, insert and delete)

 

•PS_CAMPUS_EVNT_LNG (read, write, insert and delete)

 

•PS_EVENT_LAST_TBL (read, write and insert)

 

For Audit Table:

 

•PS_AUDIT_AD_ASTRA7 (read, write, insert and delete)

Page url: ?peoplesoftsisinterfaceaddendum_2.htm