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.
Essential Scheduling and Registration Monitoring requires the Base data.
Student Centered Scheduling and Integrated Planning require the Extended data.
| Table | Astra Schedule | Base | Extended | Optional | 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 | ||
|
SIRASGN |
X | X | X | Sections (Import and export), Faculty | |
| SIRDPCL | X | X | Faculty | ||
| SIRFLCT | X | X | Faculty, Faculty Capacity** | ||
| SIRFLRC | X | X | Faculty, Faculty Capacity** | ||
| SIRFLRT | X | X | Faculty, Faculty Capacity** | ||
| SIRNIST | X | X | Faculty, Faculty Capacity** | ||
| 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, Faculty Capacity** | ||
| STVFCST | X | X | Faculty | ||
| STVFCTG | X | X | Faculty, Faculty Capacity** | ||
| 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, Faculty Capacity** | ||
| SHRDGMR | X | Completion and Retention Forecasting | |||
|
STVDEGS |
X | Completion and Retention Forecasting | |||
|
SARADAP |
X | Completion and Retention Forecasting | |||
|
SARAPPD |
X | Completion and Retention Forecasting | |||
|
STVADMT |
X | Completion and Retention Forecasting | |||
| STVAPDC | X | Completion and Retention Forecasting | |||
|
STVAPST |
X | Completion and Retention Forecasting | |||
|
STVDEGC |
X | Completion and Retention Forecasting | |||
|
STVSTYP |
X | Completion and Retention Forecasting | |||
| STVFSTP | X | Margin Modeling Faculty Capacity** | |||
| SIBINST | X | Margin Modeling | |||
| STVFCTG | X | Margin Modeling | |||
| STVRESD | X | Margin Modeling | |||
| SPBPERS | X | Equity Groupings for Benchmark Metrics | |||
| GORRACE | X | Equity Groupings for Benchmark Metrics | |||
| GORPRAC | X | Equity Groupings for Benchmark Metrics | |||
| STVETHN | X | Equity Groupings for Benchmark Metrics | |||
| GTVGNDR | X | Equity Groupings for Benchmark Metrics | |||
| RCRESAR | X | Equity Groupings for Benchmark Metrics |
*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.
** Currently identified as required for Faculty Capacity. As this is a beta product, the requirements are subject to validation and refinement as the product matures.
Comments
Please sign in to leave a comment.