Banner Database Access

Record Updates

During the record comparison, section records are identified using the combination of term and CRN. Section meeting records are identified using the combination of term, CRN, and Oracle row ID. The Row ID is required for section meeting identification because the Banner SSRMEET table does not have a unique record ID.

Database User Access

The Astra database user must have access to the tables listed below.  Additionally, synonyms must be created for each table as the Astra user to facilitate direct queries against the database. Details related to the queries used, including specific SIS fields involved, will be provided upon request.

Table Astra  Schedule Monitor & Align Predict HESI Use
GOREMAL X X X X

Sections, Faculty

SCBCRKY   X X X Courses
SCBCRSE X X X X Courses, Sections, Faculty
SCRATTR       X Courses
SCRCORQ       X Courses
SCREQIV   X X X Courses
SCRLEVL       X Courses
SCRRCAM       X Courses
SCRRCLS       X Courses
SCRRCOL       X Courses
SCRRDEG       X Courses
SCRRLVL       X Courses
SCRRMAJ       X Courses
SCRRPRG       X Courses
SCRRTST       X Courses
SCRSCHD   X X X Courses
SFRSTCR     X   Students
SGBSTDN     X   Lookups, Students
SGRCLSR       X Lookups
SHRGRDE     X   Students
SHRTCKG     X X Course, Students
SHRTCKL     X   Students
SHRTCKN     X X Course, Students
SHRTRCE     X X Course, Students
SIBINST   X X   Faculty
SIBTERM   X X   Faculty
SIRASGN

X X X X Sections (Import and export), Faculty
SIRDPCL   X X   Faculty
SIRFLCT   X X   Faculty
SIRFLRC   X X   Faculty
SIRFLRT   X X   Faculty
SIRNIST   X X   Faculty
SLBBLDG X X X X Sections,  CampusBuildingRoom
SLBRDEF   X X   CampusBuildingRoom
SMRACAA X       Lookups,Pgm Rules, SSIS Rules
SMRARUL X       Lookups, Pgm Rules, SSIS Rules
SMRPRLE     X   Pgm Rules, SSIS Rules
SOBPTRM X X X X Sections, Terms
SPRIDEN X X X X Sections, Students, Faculty
SSBSECT X X X X Courses, Sections (Import and export), Students, Faculty
SSBXLST X X X X Sections
SSBDESC*   X X   Sections comment (Banner)
SSRMEET select and update(for building and room assignment) X X X Section (Import and export)
SSRXLST X X X X Sections
STVASTY   X X   Faculty
STVATTR       X Lookups
STVATTS       X Lookups
STVCAMP   X X X Courses, CampusBuildingRoom
STVCLAS       X Lookups
STVCNTR   X X   Faculty
STVCOLL   X X X Lookups, Students, Faculty
STVCSTA   X X X Courses
STVDEGC     X   Lookups
STVDEPT   X X X Lookups, Faculty
STVDIVS   X X X Lookups
STVFCNT   X X   Faculty
STVFCST   X X   Faculty
STVFCTG   X X   Faculty
STVFSTP   X X   Faculty
STVLEVL     X X Lookups
STVMAJR     X   Lookups
STVNIST   X X   Faculty
STVPTRM       X Terms
STVRSTS     X   Students
STVSAPR * (optional)   X X   Section
STVSCHD X X X X Sections, Lookups
STVSUBJ       X Lookups
STVTERM   X X X Courses, Terms, Pgm Rules, Student Pgm Rules
STVWKLD   X X   Faculty
All tables are read-only access unless specified.

*SSBDESC: Optional for viewing and editing the section comments within Banner from our apps

*STVSAPR: Optional for editing the section special approval code, when this table is not provided we will create a default list based on the current values used in the section data pulled.


Was this article helpful?
2 out of 3 found this helpful

Comments

0 comments

Please sign in to leave a comment.