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
GTVINSM   X X   Sections
SCBCRKY   X X X Courses
SCBCRSE X X X X Courses, Sections, Faculty
SCRATTR   X X 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 X Course Prerequisites
SCRSCHD   X X X Courses
SFRSTCR     X   Students
SGBSTDN     X   Lookups, Students
SGRCLSR       X Lookups
SGRSATT     X   Students, Student attributes and test codes
SHRATTC     X   Course/student history attributes
SHRATTR     X   Course/student history attributes
SHRGRDE     X   Students
SHRTATT     X   Course/student history attributes
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
SORTEST     X   Students, Student attributes and test codes
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 X X Lookups, Course/student history attributes
STVATTS     X X Lookups, Students, Student attributes and test codes
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
STVTESC     X   Students, Student attributes and test codes
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 via publishing

*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?
3 out of 3 found this helpful

Comments

0 comments

Please sign in to leave a comment.