|
||
Database User Access
The Astra Schedule database user must have 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.
*All tables require select access unless specified
Platinum |
HESI |
Astra Schedule |
Used for… |
GOREMAL |
GOREMAL |
GOREMAL |
Sections |
GTVMTYP (*optional - for E2E section scheduling fields) |
GTVMTYP (*optional - for E2E section scheduling fields) |
GTVMTYP (*optional - for E2E section scheduling fields) |
Lookups |
SCBCRKY |
SCBCRKY |
|
Courses |
SCBCRSE |
SCBCRSE |
SCBCRSE |
Courses, Sections |
SCRATTR |
SCRATTR |
|
Courses |
SCRCORQ |
SCRCORQ |
|
Courses |
SCREQIV |
SCREQIV |
|
Courses |
SCRLEVL |
SCRLEVL |
|
Courses |
SCRRARE |
|
|
Pgm Rules |
SCRRCAM |
SCRRCAM |
|
Courses |
SCRRCLS |
SCRRCLS |
|
Courses |
SCRRCOL |
SCRRCOL |
|
Courses |
SCRRDEG |
SCRRDEG |
|
Courses |
SCRRLVL |
SCRRLVL |
|
Courses |
SCRRMAJ |
SCRRMAJ |
|
Courses |
SCRRPRG |
SCRRPRG |
|
Courses |
SCRRTST |
SCRRTST |
|
Courses |
SCRSCHD |
SCRSCHD |
|
Courses |
SFRSTCR |
|
|
Students |
SGBSTDN |
SGBSTDN |
|
Lookups, Students |
SGRCLSR |
SGRCLSR |
|
Lookups |
SGRSATT |
|
|
Students |
SHRATTC |
|
|
Students |
SHRATTR |
|
|
Students |
SHRDGMR |
|
|
Students |
SHRGRDE |
|
|
Students |
SHRTATT |
|
|
Students |
SHRTCKG |
SHRTCKG |
|
Course, Students |
SHRTCKL |
|
|
Students |
SHRTCKN |
SHRTCKN |
|
Course, Students |
SHRTGPA |
|
|
Students |
SHRTRCE |
SHRTRCE |
|
Course, Students |
SIRASGN |
SIRASGN |
SIRASGN |
Sections (Import and export) |
SLBBLDG |
SLBBLDG |
SLBBLDG |
Sections, CampusBuildingRoom |
SLBRDEF |
|
|
CampusBuildingRoom |
SMBAGEN |
|
|
Pgm Rules, Student Pgm Rules, SSIS Rules |
SMBARUL |
|
|
Pgm Rules, SSIS Rules |
SMBGGEN |
|
|
Pgm Rules, SSIS Rules |
SMBGRUL |
|
|
Pgm Rules, SSIS Rules |
SMBPGEN |
|
|
Pgm Rules, SSIS Rules |
SMBSAGN |
|
|
Student Pgm Rules, SSIS Rules |
SMBSARU |
|
|
Student Pgm Rules, SSIS Rules |
SMBSGGN |
|
|
Student Pgm Rules, SSIS Rules |
SMBSGRU |
|
|
Student Pgm Rules, SSIS Rules |
SMBSLIB |
|
|
Student Pgm Rules, SSIS Rules |
SMBSPGN |
|
|
Student Pgm Rules, SSIS Rules |
SMRACAA |
SMRACAA |
SMRACAA (*optional - for E2E section scheduling fields) |
Lookups, Pgm Rules, SSIS Rules |
SMRACCM |
|
|
Pgm Rules, SSIS Rules |
SMRACMT |
|
|
Pgm Rules, SSIS Rules |
SMRAEXL |
|
|
Pgm Rules, SSIS Rules |
SMRAGAM |
|
|
Pgm Rules, SSIS Rules |
SMRALIB |
|
|
Pgm Rules, SSIS Rules |
SMRAQUA |
|
|
Pgm Rules, SSIS Rules |
SMRAREX |
|
|
Pgm Rules, SSIS Rules |
SMRARSA |
|
|
Pgm Rules, SSIS Rules |
SMRARUL |
SMRARUL |
SMRARUL (*optional - for E2E section scheduling fields) |
Lookups, Pgm Rules, SSIS Rules |
SMRGCAA |
|
|
Pgm Rules, SSIS Rules |
SMRGCCM |
|
|
Pgm Rules, SSIS Rules |
SMRGCMT |
|
|
Pgm Rules, SSIS Rules |
SMRGEXL |
|
|
Pgm Rules, SSIS Rules |
SMRGLIB |
|
|
Pgm Rules, SSIS Rules |
SMRGRCM |
|
|
Pgm Rules, SSIS Rules |
SMRGREX |
|
|
Pgm Rules, SSIS Rules |
SMRGRSA |
|
|
Pgm Rules, SSIS Rules |
SMRGRUL |
|
|
Pgm Rules, SSIS Rules |
SMRIEAT |
|
|
Pgm Rules, SSIS Rules |
SMRIECC |
|
|
Pgm Rules, SSIS Rules |
SMRIECO |
|
|
Pgm Rules, SSIS Rules |
SMRIECP |
|
|
Pgm Rules, SSIS Rules |
SMRIEDG |
|
|
Pgm Rules, SSIS Rules |
SMRIEDP |
|
|
Pgm Rules, SSIS Rules |
SMRIEMJ |
|
|
Pgm Rules, SSIS Rules |
SMRIEMN |
|
|
Pgm Rules, SSIS Rules |
SMRPAAP |
|
|
Pgm Rules, SSIS Rules |
SMRPRLE |
SMRPRLE |
|
Lookups, SSIS Rules |
SMRPRSA |
|
|
Pgm Rules, SSIS Rules |
SMRSACA |
|
|
Student Pgm Rules, SSIS Rules |
SMRSACE |
|
|
Student Pgm Rules, SSIS Rules |
SMRSACM |
|
|
Student Pgm Rules, SSIS Rules |
SMRSACT |
|
|
Student Pgm Rules, SSIS Rules |
SMRSAGM |
|
|
Student Pgm Rules, SSIS Rules |
SMRSARE |
|
|
Student Pgm Rules, SSIS Rules |
SMRSARS |
|
|
Student Pgm Rules, SSIS Rules |
SMRSARU |
|
|
Student Pgm Rules, SSIS Rules |
SMRSGAV |
|
|
Student Pgm Rules, SSIS Rules |
SMRSGCA |
|
|
Student Pgm Rules, SSIS Rules |
SMRSGCE |
|
|
Student Pgm Rules, SSIS Rules |
SMRSGCM |
|
|
Student Pgm Rules, SSIS Rules |
SMRSGCT |
|
|
Student Pgm Rules, SSIS Rules |
SMRSGRE |
|
|
Student Pgm Rules, SSIS Rules |
SMRSGRS |
|
|
Student Pgm Rules, SSIS Rules |
SMRSGRU |
|
|
Student Pgm Rules, SSIS Rules |
SMRSPRS |
|
|
Student Pgm Rules, SSIS Rules |
SMRSSUB |
|
|
Student Pgm Rules, SSIS Rules |
SMRSTRG |
|
|
Student Pgm Rules, SSIS Rules |
SMRSWAV |
|
|
Student Pgm Rules, SSIS Rules |
SOBPTRM |
SOBPTRM |
SOBPTRM |
Sections, Terms |
SORTEST |
SORTEST |
|
Lookups, Students |
SPRIDEN |
SPRIDEN |
SPRIDEN |
Sections, Students |
SSBSECT |
SSBSECT |
SSBSECT |
Courses, Sections (Import and export), Students |
SSBXLST |
SSBXLST |
SSBXLST |
Sections |
SSRMEET |
SSRMEET |
SSRMEET (select and update (for building and room assignments)) |
Section (Import and export) |
SSRXLST |
SSRXLST |
SSRXLST |
Sections |
STVATTR |
STVATTR |
|
Lookups |
STVATTS |
STVATTS |
|
Lookups |
STVBLDG |
|
|
CampusBuildingRoom |
STVCAMP |
STVCAMP |
|
Courses, CampusBuildingRoom |
STVCLAS |
STVCLAS |
|
Lookups |
STVCOLL |
STVCOLL |
|
Lookups, Students |
STVCSTA |
STVCSTA |
|
Courses |
STVDEGC |
STVDEGC |
|
Lookups |
STVDEGS |
|
|
Students |
STVDEPT |
STVDEPT |
|
Lookups |
STVDIVS |
STVDIVS |
|
Lookups |
STVLEVL |
STVLEVL |
|
Lookups |
STVMAJR |
STVMAJR |
|
Lookups |
STVPTRM |
STVPTRM |
|
Terms |
STVRESD |
STVRESD |
|
Lookups |
STVRSTS |
|
|
Students |
STVSCHD |
STVSCHD |
STVSCHD |
Sections, Lookups |
STVSESS (*optional - for E2E section scheduling fields) |
STVSESS (*optional - for E2E section scheduling fields) |
STVSESS (*optional - for E2E section scheduling fields) |
Lookups |
STVSSTS (*optional - for E2E section scheduling fields) |
STVSSTS (*optional - for E2E section scheduling fields) |
STVSSTS (*optional - for E2E section scheduling fields) |
Lookups |
STVSTST |
STVSTST |
|
Lookups |
STVSUBJ |
STVSUBJ |
|
Lookups |
STVTERM |
STVTERM |
|
Courses, Terms, Pgm Rules, Student Pgm Rules |
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.