Astra Schedule Help (8.0)

PeopleSoft Database Access

Hide Navigation Pane

PeopleSoft Database Access

Previous topic Next topic  

PeopleSoft Database Access

Previous topic Next topic JavaScript is required for the print function  

Data Access

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

 

noteNOTE:  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

Section import, only if Importing Room Feature Preferences

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

Section import, only if Importing Room Feature Preferences

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

 

 

SDA/Batch Audit Import

PS_SAA_ADB_CRSEAVL

 

 

SDA/Batch Audit Import

PS_SAA_ADB_CRSEUSE

 

 

SDA/Batch Audit Import

PS_SAA_ADB_RESULTS

 

 

SDA/Batch Audit Import

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