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 Use
GOREMAL X X X Sections, Faculty
GTVINSM   X X Sections
SCBCRKY   X X Courses
SCBCRSE X X X Courses, Sections, Faculty
SCRATTR   X X Courses
SCREQIV   X X Courses
SCRRTST     X Course Prerequisites
SCRSCHD   X X Courses
SFRSTCR     X Students
SGBSTDN     X Lookups, Students
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 Course, Students
SHRTCKL     X Students
SHRTCKN     X Course, Students
SHRTRCE     X Course, Students
SIBINST   X X Faculty
SIBTERM   X X Faculty

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 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 Sections, Terms
SORTEST     X Students, Student attributes and test codes
SPRIDEN X X X Sections, Students, Faculty
SSBSECT X X X Courses, Sections (Import and export), Students, Faculty
SSBXLST X X X Sections
SSBDESC*   X X Sections comment (Banner)
SSRMEET select and update(for building and room assignment) X X Section (Import and export)
SSRXLST X X X Sections
STVASTY   X X Faculty
STVATTR   X X Lookups, Course/student history attributes
STVATTS     X Lookups, Students, Student attributes and test codes
STVCAMP   X X Courses, CampusBuildingRoom
STVCNTR   X X Faculty
STVCOLL   X X Lookups, Students, Faculty
STVCSTA   X X Courses
STVDEGC     X Lookups
STVDEPT   X X Lookups, Faculty
STVDIVS   X X Lookups
STVFCNT   X X Faculty
STVFCST   X X Faculty
STVFCTG   X X Faculty
STVFSTP   X X Faculty
STVLEVL     X Lookups
STVMAJR     X Lookups
STVNIST   X X Faculty
STVRSTS     X Students
STVSAPR * (optional)   X X Section
STVSCHD X X X Sections, Lookups
STVTERM   X X Courses, Terms, Pgm Rules, Student Pgm Rules
STVTESC     X Students, Student attributes and test codes
STVWKLD   X X Faculty

*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.

Benchmark & Planning Metrics





All tables required for Completion and Retention Forecasting



All tables required for Margin Modeling




All tables required for Equity Groupings





All tables are read-only access unless specified.


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



Please sign in to leave a comment.