The Platinum Analytics database user must have read 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_AA_OVERRIDE

•PS_AA_OVRD_CRSDATA

•PS_AA_OVRD_DATA

•PS_AA_OVRD_WHERE

•PS_ACAD_DEGR

•PS_ACAD_GROUP_TBL

•PS_ACAD_LEVEL_TBL

•PS_ACAD_ORG_TBL

•PS_ACAD_PLAN

•PS_ACAD_PLAN_TBL

•PS_ACAD_PROG

•PS_ACAD_PROG_TBL

•PS_ACAD_SUBPLAN

•PS_ACAD_SUBPLN_TBL

•PS_AUDIT_AD_ASTRA7

•PS_CAMPUS_EVENT

•PS_CAMPUS_EVNT_LNG

•PS_CAMPUS_LOC_TBL

•PS_CAMPUS_MTG

•PS_CAMPUS_TBL

•PS_CLASS_INSTR

•PS_CLASS_MTG_PAT

•PS_CLASS_TBL

•PS_CLST_DETL_TBL

•PS_CLST_MAIN_TBL

•PS_CRSE_ATTRIBUTES

•PS_CRSE_ATTR_TBL

•PS_CRSE_CATALOG

•PS_CRSE_COMPONENT

•PS_CRSE_OFFER

•PS_DEGREE_TBL

•PS_EMAIL_ADDRESSES

•PS_EVENT_LAST_TBL

•PS_FACILITY_TBL

•PS_MILESTONE_TBL

•PS_NAMES

•PS_RQ_COND_LINE

•PS_RQ_COND_LN_DETL

•PS_RQ_CONDITION

•PS_RQ_ENT_GRP_DETL

•PS_RQ_ENTITY_GROUP

•PS_RQ_GRP_DETL_TBL

•PS_RQ_GRP_TBL

•PS_RQ_LINE_TBL

•PS_RQ_LN_DETL_TBL

•PS_RQ_MAIN_TBL

•PS_RQMNT_DESIG_TBL

•PS_SCTN_CMBND

•PS_SCTN_CMBND_TBL

•PS_STDNT_CAR_MLSTN

•PS_STDNT_CAR_TERM

•PS_STDNT_CRS_SUBS

•PS_STDNT_ENRL

•PS_STDNT_GROUP_TBL

•PS_STDNT_GRPS_HIST

•PS_STDNT_MLSTN

•PS_STDNT_TEST_COMP

•PS_SUBJECT_TBL

•PS_TERM_TBL

•PS_TRNS_CRSE_DTL

•PS_TRNS_CRSE_SCH

•PS_TRNS_CRSE_TERM

•PS_TRNS_TEST_DTL

•PS_TST_CREDIT_COMP

•PSXLATITEM
 

•PS_SAA_ADB_RESULTS (for batch audit import)

•PS_SAA_ADB_REPORT (for batch audit import)

•PS_SAA_ADB_COURSES (for batch audit import)

•PS_SAA_ADB_CRSEUSE (for batch audit import)

•PS_SAA_ADB_CRSEAVL (for batch audit import)

 

*See PeopleSoft Batch Audit Import for more information.

 

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.