Banner Schema Search

Banner Schema Search

6750 tables · 134935 columns · 19476 relationships

Type:

Module:

Press / to search · Understands Banner abbreviations

Loading Banner schema data...

Esc

↑↓ navigate Enter open Esc close

Tables · Reports · Modules · Cases · Actions

Search Examples & Help

Smart Search: This tool understands Banner abbreviations. Type natural English like employee hire date and it automatically expands to search EMPL, EMP, PEBEMPL and related terms. Click any example below to try it.

🔒 Security & Access Reviews: This tool has a full Banner Security (BANSECR) module. Three ways to use it:

Click ☰ REPORTS (shortcut ~) to open 11 ready-to-run audit reports: dormant accounts, terminated-with-access, PII access, super users, violation dashboard, and more.
Type an English question like Banner Student security classes in the search bar — the tool auto-generates the SQL answer.
Press Ctrl+Shift+F for the command palette: instant fuzzy search across tables, reports, modules, cases, and actions.

🔒 Security & Access

Banner Student security classesAsk Banner → GTVCLAS query for Student module finance security classesFinance-module class catalog HR payroll classesHR/Payroll class catalog Banner Lego (query builder)Visual block-based SQL builder — Scratch for Banner joins Security Posture ScorecardDashboard view → 8 traffic-light gauges (paste SR014 row) list banner modules→ SR013 — discover every Banner module on your site (8-card grid) finance user access inventory→ SR012 — users + Finance forms (Argos-ready) Student user access inventoryAsk Banner → same query scoped to Student HR user access inventoryAsk Banner → same query scoped to HR/Payroll dormant accounts→ SR001 — never logged in 180+ days terminated with access→ SR002 — the #1 auditor finding super users→ SR008 — top _M grant holders unused classes→ SR006 — classes with no users (cleanup) most populated classes→ SR007 — biggest attack surfaces PII access→ SR011 — SSN/DOB access (FERPA) violations last 30 days→ SR005 — GURALOG violation dashboard recent access changes→ SR009 — 30-day audit trail object concentration→ SR010 — most-exposed Banner objects access to SHAINSTAsk Banner → who can access a specific form users in class SFAREGSAsk Banner → class membership GURACLSModern user-class assignments GUVUACCPre-joined effective-access view (415K rows at WCC) GURALOGSecurity violation log GURLOGNLogin history — Oracle / INB / Web

🌐 Community Resources

Argos webinars (Evisions)10 curated webinars + product pages + the annual Evisions Conference Ellucian Banner trainingCustomer Center, Training Portal, "Get to Know Banner" series, Ellucian Live 2026 Banner User Groups (BUGs)Regional groups: ALBUG / FLBUG / PABUG / BUGMI / UMBUG — peer-driven sessions

📝 Found something missing? Open an issue or PR at the repo. The resources list is hand-curated and welcomes additions from the community.

📋 Argos / Oracle Reference

Argos parameter cheatsheet:main_* / :lcl_* / :dbn_* conventions + accessors Argos SQL patterns7 copy-ready snippets: CONNECT BY split, LISTAGG OVERFLOW, multi-checkbox IN, "show all" toggle, week-of-date, optional date, Y/N flag

🔎 SQL Server → Oracle: paste any SQL Server query into the SQL Explainer — the validator detects TOP, [brackets], ISNULL, LEN, GETDATE, CHARINDEX, IIF, STRING_AGG, DATEDIFF/DATEADD, CONVERT, WITH (NOLOCK), + concat, @variables, CROSS/OUTER APPLY, SELECT INTO #temp and surfaces each one with its Oracle equivalent + a Copy-fix snippet.

⌨ Keyboard Shortcuts

Ctrl+Shift+F — Command palette (search everything)
/ — Focus the main search bar
` (backtick) — Open SQL Explainer
~ (tilde) — Open Reports
? — Open this Help panel
Esc — Close the current panel / return home

👤 Person / Identity

employee hire dateFinds PEBEMPL hire date columns person nameExpands to PERS, PIDM, SPRIDEN student identificationStudent ID related tables PIDMCross-references all tables with PIDM date of birthBirth date fields across modules gender ethnicityDemographic data fields citizenship immigrationI-9, visa, citizenship data

💰 HR / Payroll

salary compensationExpands to WAGE, PAY, EARNINGS payroll deductionsExpands to PAY, PHR, DEDN, BDCA benefit enrollmentBenefits and deduction rules tax withholdingW2, 1042, 1099, 1095 related W2 tax informationW-2 state/federal tax data direct deposit bankBank routing, deposit info earnings historyPay history tables gross net payGross/net amount fields leave accrualLeave balance and accrual employee status terminatedEmployment status fields position budgetExpands to POSN, NBBPOSN job classificationPosition class/employee class FLSA overtimeFair Labor Standards data

🎓 Student / Academic

course registrationExpands to CRSE, CLASS, SECTION student enrollmentRegistration/enrollment tables grade point averageGPA, GRDE related fields degree majorExpands to DGRE, MAJR, PROGRAM transcript academicAcademic record/history admission applicantAdmissions and recruit data class scheduleSchedule/section information transfer creditsTransfer credit evaluation academic standingStanding, probation, dean's list

💵 Financial Aid

financial aid awardAid packages and awards scholarshipScholarship/award data loan disbursementLoan tracking and disbursement Pell grantFederal Pell grant data

📈 Finance

purchase orderPO/procurement tables invoice paymentAP invoice and payment budget accountBudget/account/FOAPAL grant fundResearch/sponsored programs FOAPALFund/Org/Acct/Prog/Activity/Location

📍 Address / Contact

address city state zipExpands to ADDR, SPRADDR telephone phoneExpands to TELE, SPRTELE email contactExpands to MAIL, GOREMAL

📋 Real-World Integration Queries

These are actual data questions from production Banner integrations (ADP SmartCompliance, NSC). Proven search patterns that find the right tables.

employee hire date terminationPEBEMPL hire/term dates for HR feeds SSN social security numberSPBPERS SSN for employee matching PHRHIST gross wages quarterlyQuarterly wage totals from pay history PHRDEDN employer deductionEmployer vs employee deduction amounts federal income tax FEDFederal tax withholding code mapping medicare social security FIO FIMFICA codes - employee & employer portions state income tax ILL MCH NYTMulti-state tax codes (IL, MI, NY) state unemployment SUI wagesSUI taxable wages with quarterly caps W2 box 12 retirement 403b 457bPXRW2CD retirement plan contributions PXRW2ST state tax W2W-2 state-level tax data HSA employer health savingsHSA contributions (Box 12 Code W) PPO HMO health plan employerMedical plan costs (Box 12 Code DD) PTRBDCA benefit deduction rulesDeduction code definitions and calc rules SURS retirement exemptIL state retirement system exemptions pay calendar check date PTRCALNPayroll calendar and check dates address HR mailing SPRADDREmployee HR addresses by type code PXRTXCD tax code validationTax code validation table life insurance imputed incomeGroup term life >$50K (Box 12C) employee status active leavePEBEMPL status codes (A/B/L/F/P/T) position class employee groupECLS/EGRP classification codes

🔗 Cross-Reference Power Queries

Search for column suffixes to find all tables that share a key column. This reveals data relationships across the entire Banner schema.

_PIDMAll tables linked by Person ID _TERM_CODEAll term-related tables _ACTIVITY_DATEAudit trail columns _SURROGATE_IDSurrogate primary keys _CODEAll validation code references _INDAll Yes/No indicator flags

💡 Fuzzy / Typo Tolerance

Made a typo? The search uses trigram matching to find similar terms even when you misspell a word.

employyFinds "employee" despite the typo addresFinds "address" despite missing 's' payrolFinds "payroll" despite missing 'l' registratonFinds "registration" with a typo

⌨ Keyboard Shortcuts

/ Focus search bar
Enter Search immediately
? Toggle this help panel

⚙ How It Works

BM25 Ranking: The same algorithm used by Elasticsearch and Apache Lucene. Ranks results by relevance considering term frequency and document length.

Banner Synonyms: Automatically expands your query with Banner abbreviations. "employee" also searches for EMPL, EMP, PEBEMPL.

Fuzzy Matching: Uses trigram similarity to handle typos and partial matches.

Column Patterns: Recognizes common Banner column types: _PIDM (Person ID), _CODE (Validation), _IND (Flag), _DATE, _AMT (Amount), _SURROGATE_ID (Key).

Banner Schema Search · Built 2026-06-02 00:53:31 · Powered by BM25 ranking + Banner synonym expansion · 4640 tables, 2110 views, 134935 columns