The Platinum Analytics database user must have read access to the following Banner tables:

 

NOTE:  Additionally, synonyms must be created for each table as the Astra Schedule user to facilitate direct queries against the database.

 

•SCBCRKY

•SCBCRSE

•SCRATTR

•SCRCORQ

•SCREQIV

•SCRLEVL

•SCRRARE

•SCRRCAM

•SCRRCLS

•SCRRCOL

•SCRRDEG

•SCRRLVL

•SCRRMAJ

•SCRRPRG

•SCRRTST

•SCRSCHD

•SFRSTCR

•SGBSTDN

•SGRCLSR

•SGRSATT

•SHRATTC

•SHRATTR

•SHRDGMR

•SHRGRDE

•SHRTATT

•SHRTCKG

•SHRTCKL

•SHRTCKN

•SHRTRCE

•SIRASGN

•SLBBLDG

•SLBRDEF

•SMBAGEN

•SMBARUL

•SMBGGEN

•SMBGRUL

•SMBPGEN

•SMBSAGN

•SMBSARU

•SMBSGGN

•SMBSGRU

•SMBSLIB

•SMBSPGN

•SMRACAA

•SMRACCM

•SMRACMT

•SMRAEXL

•SMRAGAM

•SMRALIB

•SMRAQUA

•SMRAREX

•SMRARSA

•SMRARUL

•SMRGCAA

•SMRGCCM

•SMRGCMT

•SMRGEXL

•SMRGLIB

•SMRGRCM

•SMRGREX

•SMRGRSA

•SMRGRUL

•SMRIEAT

•SMRIECC

•SMRIECO

•SMRIECP

•SMRIEDG

•SMRIEDP

•SMRIEMJ

•SMRIEMN

•SMRPAAP

•SMRPRLE

•SMRPRSA

•SMRSACA

•SMRSACE

•SMRSACM

•SMRSACT

•SMRSAGM

•SMRSARE

•SMRSARS

•SMRSARU

•SMRSGAV

•SMRSGCA

•SMRSGCE

•SMRSGCT

•SMRSGRE

•SMRSGRS

•SMRSGRU

•SMRSPRS

•SMRSSUB

•SMRSTRG

•SMRSWAV

•SOBPTRM

•SORTEST

•SPRIDEN

•SSBSECT

•SSBXLST

•SSRMEET

•SSRXLST

•STVATTR

•STVATTS

•STVBLDG

•STVCAMP

•STVCLAS

•STVCOLL

•STVCSTA

•STVDEGC

•STVDEGS

•STVDEPT

•STVDIVS

•STVLEVL

•STVMAJR

•STVPTRM

•STVRESD

•STVRSTS

•STVSCHD

•STVSTST

•STVSTYP

•STVSUBJ

•STVTERM

•GOREMAL

•SHRTGPA

 

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.