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

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

Comments

0 comments

Please sign in to leave a comment.