Astra Schedule Help (8.0)

Banner Database Access

Hide Navigation Pane

Banner Database Access

Previous topic Next topic  

Banner Database Access

Previous topic Next topic JavaScript is required for the print function  

Data Access

Database User Access

 

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

 

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