Scope of Work Coverage
NuVu Technologies / Volusia County Nsites — Proposed Statement of Work, September 2, 2026, Section 3. Each menu item maps one-to-one to a scope section, with the data elements required to populate it.
Scope sections
7
3.1 through 3.7
Scope requirements
37
Individual SOW bullets
Demonstrated
30
Working in the platform
Required data elements
55
Across 3.1–3.7 checklist
3.15/6 demonstrated
Foundation, Integration & Semantic Model
Source inventory, business-friendly data dictionary, documented calculation rules, refresh behavior, row-level access and traceability.
Open module →
3.24/6 demonstrated
Event Costing & Personnel Deployment
Select an event or job code and calculate participating personnel, hours, pay types, benefits and fully burdened cost with unit-level analysis.
Open module →
3.36/6 demonstrated
Contract Costing, Reconciliation & Rate Analysis
Contract register, revenue vs fully burdened cost, quarter-end cutoffs, rate scenario modeling and exception flags.
Open module →
3.44/4 demonstrated
Workforce Census & Benefits
Eligibility, enrollment, waivers, dependents, approved demographics, elections and employer cost with carrier-ready exports.
Open module →
3.54/4 demonstrated
Overtime & Cost-Center Controls
All labor charged to a cost center regardless of assignment, overtime analytics across dimensions, and miscoding detection.
Open module →
3.61/4 demonstrated
Budget & Command-Staff Insights
Command dashboards for budget, actual, commitments, remaining balance, forecast and projected variance in operational language.
Open module →
3.76/7 demonstrated
Reporting & User Experience
Standard dashboards, a governed self-service report builder, AI-assisted reporting, calculated measures, query reuse, exports and a feedback workflow.
Open module →
3.1 Foundation, Integration & Semantic Model
Source inventory, business-friendly data dictionary, documented calculation rules, refresh behavior, row-level access and traceability.
| Confirm production/sandbox connection approach for ADG and Oracle Analytics Cloud (OAC). | Semantic Model → Connections; Financial Reporting → Oracle Analytics | Illustrative |
|---|---|---|
| Inventory source schemas, tables, fields, queries, job codes, pay codes, cost centers and employee identifiers. | Semantic Model → Source Inventory; Data Sources | Demonstrated |
| Business-friendly data dictionary mapping technical fields to approved agency terminology. | Semantic Model → Data Dictionary | Demonstrated |
| Document calculation rules for regular, overtime, holiday, special assignment, benefits and fully burdened cost. | Semantic Model → Calculation Rules | Demonstrated |
| Configure refresh behavior, validation, row-level access and traceability from totals to source detail. | Semantic Model → Governance; Validation Lab | Demonstrated |
| Do not alter source databases or operational transaction logic. | Read-only semantic layer; no write-back configured | Demonstrated |
3.1.R Required Data
Data elements the source extracts must contain for the reports currently laid out in this module to populate. 8 required, 1 preferred.
| Source object inventory | schema / table / view names | ADG, Kronos, Oracle Benefits, Oracle GL, OAC | One row per source object | Semantic Model → Source Inventory; Data Sources | Required |
|---|---|---|---|---|---|
| Field catalog per object | column name, data type, nullability | All sources | One row per field | Semantic Model → Data Dictionary | Required |
| Job code master | JOB_CODE, description, activity type | Oracle Payroll (ADG) | One row per job code | Event/contract attribution across 3.2, 3.3, 3.5 | Required |
| Pay code / element master | ELEMENT_NAME, element classification, premium factor | Oracle Payroll (ADG) | One row per pay element | Pay-type splits and overtime measures | Required |
| Cost center master | COST_CENTER, description, agency/division rollup | Oracle GL (ADG) | One row per cost center | All cost-center rollups and 3.5 charged-to views | Required |
| Employee identifier crosswalk | PERSON_NUMBER ↔ Kronos badge ↔ benefits member ID | ADG / Kronos / Oracle Benefits | One row per employee per system | Joining payroll, timecard and benefits records | Required |
| Refresh metadata | last extract timestamp, row counts, load status | Integration layer | One row per load | Semantic Model → Governance; Validation Lab freshness | Required |
| Row-level access mapping | user/role → agency, division, cost center | Agency directory | One row per role scope | Restricted fields (DOB, dependents, benefit class) | Required |
| Approved terminology list | technical field → business name | Agency-provided | One row per mapped field | Business-friendly labels throughout | Preferred |
3.2 Event Costing & Personnel Deployment
Select an event or job code and calculate participating personnel, hours, pay types, benefits and fully burdened cost with unit-level analysis.
| Select event/job code and calculate personnel, dates, payroll cycles, regular/OT/holiday hours, special assignments, benefits and burdened cost. | Event Costing → event detail | Demonstrated |
|---|---|---|
| Analyze participation by unit or capability (SWAT, K-9, drone, bomb squad, communications). | Event Costing → Team Analysis cards | Demonstrated |
| Drill from event total to unit, pay type, employee, day, timecard and payroll detail. | Event Costing → KPI and team drill-downs | Demonstrated |
| Recreate two completed event-cost spreadsheets and validate against agency-approved totals. | Validation Lab → reconciliation tests | Illustrative |
| Complete one blind historical event test. | Validation Lab → blind test | Illustrative |
| Reusable views for graduations, pop-up events, security deployments and other coded activities. | Event Costing → event switcher and compare | Demonstrated |
3.2.R Required Data
Data elements the source extracts must contain for the reports currently laid out in this module to populate. 9 required, 0 preferred.
| Event / activity master | EVENT_ID, event name, type, start & end date | Application managed / job code master | One row per event | Event Costing → event switcher and detail header | Required |
|---|---|---|---|---|---|
| Payroll transaction detail | PAY_TXN_ID, PERSON_NUMBER, JOB_CODE, ELEMENT_NAME, HOURS_QTY, PAY_AMOUNT, work date | Oracle Payroll (ADG) | One row per employee / pay element / work date | All event KPIs, hours and cost totals | Required |
| Timecard daily detail | badge, work date, in/out, hours, activity code | Kronos export | One row per employee per day per code | Drill from payroll total to timecard detail | Required |
| Pay period calendar | PAY_PERIOD_ID, start date, end date, pay date | Oracle Payroll (ADG) | One row per payroll cycle | Payroll cycle grouping on event detail | Required |
| Employee assignment (effective-dated) | rank, division, unit, specialty, home cost center | Oracle HCM (ADG) | One row per employee per effective period | Team Analysis by unit/capability (SWAT, K-9, drone, bomb squad, comms) | Required |
| Special assignment premiums | premium element, rate, eligibility | Oracle Payroll (ADG) | One row per premium per employee | Special assignment pay measure | Required |
| Employer benefit rate per hour | ER_CONTRIB_AMT, effective dates | Oracle Benefits | One row per employee per benefit period | Fully burdened cost on event totals | Required |
| Other employer burden factors | uniform, equipment, admin loading % | Agency-provided | One rate per class per fiscal year | Fully burdened cost | Required |
| Completed event-cost spreadsheets | approved totals per event | Agency-provided | Two historical events | Validation Lab reconciliation and blind test | Required |
3.3 Contract Costing, Reconciliation & Rate Analysis
Contract register, revenue vs fully burdened cost, quarter-end cutoffs, rate scenario modeling and exception flags.
| Contract register with term, service model, required staffing/hours, billing methodology, rate, escalation and cost center. | Contract Costing → register | Demonstrated |
|---|---|---|
| Support actual-cost city contracts, flat-rate hospital/DOC details, school resource deputy and charter-school arrangements. | Contract Costing → contract types | Demonstrated |
| Compare revenue/reimbursement with fully burdened payroll and benefit cost at contract, employee, period and service level. | Contract detail → reconciliation | Demonstrated |
| Handle quarter-end cutoffs spanning payroll cycles and show reconciliation adjustments. | Contract detail → quarter selector | Demonstrated |
| Model rate scenarios, break-even rates, target margins and impact of proposed increases. | Contract Costing → Rate Analysis | Demonstrated |
| Flag under-recovery, excess staffing/hours, missing or incorrect job codes. | Contract Costing → exceptions; Exceptions module | Demonstrated |
3.3.R Required Data
Data elements the source extracts must contain for the reports currently laid out in this module to populate. 7 required, 1 preferred.
| Contract register | CONTRACT_ID, counterparty, term start/end, service model, cost center | Finance / Contracts | One row per contract | Contract Costing → register | Required |
|---|---|---|---|---|---|
| Billing terms | BILL_RATE, billing methodology, escalation schedule, required staffing/hours | Finance / Contracts | One row per contract per rate period | Revenue vs cost, rate analysis, break-even modeling | Required |
| Revenue / reimbursement actuals | invoice or receipt amount, period, contract | Oracle GL (ADG) / AR | One row per invoice or receipt | Recovery %, under-recovery flags | Required |
| Contract-attributed payroll | JOB_CODE or CONTRACT_ID on the payroll transaction | Oracle Payroll (ADG) | One row per payroll transaction | Fully burdened cost at contract, employee and period level | Required |
| SRD activity codes | SRD_ACTIVITY_CODE (51–54) | Kronos export | One row per employee per day | School resource deputy and charter-school billing splits | Required |
| Fiscal calendar with quarter cutoffs | fiscal year, quarter, start/end date | Budget Office | One row per fiscal period | Quarter-end cutoffs spanning payroll cycles | Required |
| Reconciliation adjustments | adjustment amount, reason, period | Finance / Contracts | One row per adjustment | Contract detail → reconciliation | Preferred |
| Flat-rate detail schedules | hospital / DOC fixed-fee amounts and coverage hours | Finance / Contracts | One row per detail per period | Flat-rate contract types | Required |
3.4 Workforce Census & Benefits
Eligibility, enrollment, waivers, dependents, approved demographics, elections and employer cost with carrier-ready exports.
| Employee census reporting for eligibility, enrollment, waivers, dependent counts, approved demographics, elections and employer cost. | Census & Benefits → Employee Census | Demonstrated |
|---|---|---|
| Drill by employee and cost center; export carrier-ready or management-ready census reports. | Census & Benefits → Census Reports | Demonstrated |
| Flag missing/inconsistent records and exceptions such as terminated employees remaining on benefits. | Census & Benefits → Exceptions | Demonstrated |
| Current-period and historical comparisons where source history is available. | Census & Benefits → Census History | Demonstrated |
3.4.R Required Data
Data elements the source extracts must contain for the reports currently laid out in this module to populate. 7 required, 1 preferred.
| Employee demographics | PERSON_NUMBER, name, DATE_OF_BIRTH, gender, home ZIP | Oracle HCM (ADG) | One row per employee | Carrier-ready census age banding (restricted fields) | Required |
|---|---|---|---|---|---|
| Employment status & dates | status, hire date, termination date, FTE | Oracle HCM (ADG) | One row per employee per status change | Eligibility and terminated-on-benefits exceptions | Required |
| Benefit eligibility | eligibility flag, eligibility date, plan group | Oracle Benefits | One row per employee per plan year | Eligibility vs enrollment counts | Required |
| Elections and waivers | plan, COVERAGE_TIER, election date, waiver reason | Oracle Benefits | One row per employee per plan | Enrollment, waiver and benefit-class breakdowns | Required |
| Dependent records | DEP_RELATION, dependent DOB, coverage start/end | Oracle Benefits | One row per dependent per plan | Dependent counts and carrier export | Required |
| Employer and employee cost | ER_CONTRIB_AMT, EE_CONTRIB_AMT, per-period rate | Oracle Benefits | One row per employee per plan per period | Employer cost totals and cost-center allocation | Required |
| Cost center attribution | HOME_COST_CENTER on the benefits record | Oracle HCM (ADG) | One row per employee | Census drill by cost center | Required |
| Prior-period census snapshots | full census extract per prior plan year/month | Oracle Benefits | One extract per period | Census History comparisons | Preferred |
3.5 Overtime & Cost-Center Controls
All labor charged to a cost center regardless of assignment, overtime analytics across dimensions, and miscoding detection.
| Show all labor charged to a cost center regardless of the employee's assigned organizational unit. | Overtime → Charged-to-cost-center view | Demonstrated |
|---|---|---|
| Analyze overtime by agency, division, cost center, event, employee, pay type and period. | Overtime → dimension analysis | Demonstrated |
| Identify likely miscoding, unusual increases, cross-unit charges and special-assignment issues. | Overtime → Controls; Exceptions module | Demonstrated |
| Simple drill-down that does not depend on precise hover targets or hierarchy knowledge. | Full-card click targets across all modules | Demonstrated |
3.5.R Required Data
Data elements the source extracts must contain for the reports currently laid out in this module to populate. 6 required, 1 preferred.
| Charged cost center on payroll | CHARGE_COST_CENTER | Oracle Payroll (ADG) | One row per payroll transaction | All labor charged to a cost center regardless of assignment | Required |
|---|---|---|---|---|---|
| Assigned (home) cost center | HOME_COST_CENTER | Oracle HCM (ADG) | One row per employee per effective period | Cross-unit charge detection | Required |
| Overtime pay elements | ELEMENT_NAME, HOURS_QTY, PAY_AMOUNT | Oracle Payroll (ADG) | One row per transaction | Overtime hours and dollars by every dimension | Required |
| Organization hierarchy | agency → division → unit → cost center | Oracle HCM (ADG) | One row per org node | Dimension analysis and drill paths | Required |
| Job code to event/contract mapping | JOB_CODE → EVENT_ID / CONTRACT_ID | Application managed | One row per job code | Overtime by event and by contract | Required |
| Historical overtime baselines | prior fiscal-year overtime by cost center and period | Oracle Payroll (ADG) | One row per cost center per period | Unusual-increase and miscoding controls | Required |
| Approved coding rules | valid job code / pay code / cost center combinations | Agency-provided | One row per valid combination | Exceptions → likely miscoding | Preferred |
3.6 Budget & Command-Staff Insights
Command dashboards for budget, actual, commitments, remaining balance, forecast and projected variance in operational language.
| Simplified command dashboards showing budget, actual, commitments, remaining balance, forecast and projected variance. | Budget & Command Insights → command dashboard | Illustrative |
|---|---|---|
| Translate object codes into operational categories (personnel, overtime, vehicles, equipment, training, supplies, other). | Budget & Command Insights → Operational Categories | Demonstrated |
| Analyze multiple fiscal years across object codes and cost centers for forecasting and allocation. | Budget & Command Insights → fiscal-year comparison | Illustrative |
| Drill to underlying transactions and highlight drivers of budget transfers or projected overruns. | Budget & Command Insights → drill-downs | Illustrative |
3.6.R Required Data
Data elements the source extracts must contain for the reports currently laid out in this module to populate. 6 required, 1 preferred.
| Adopted and amended budget | BUDGET_AMT, fiscal year, cost center, GL_OBJECT_CODE | Oracle GL (ADG) | One row per FY / cost center / object code | Command dashboard budget column | Required |
|---|---|---|---|---|---|
| Actual expenditures | actual amount, accounting period | Oracle GL (ADG) | One row per GL journal line | Actual, remaining balance and drill to transactions | Required |
| Encumbrances / commitments | ENCUMBRANCE_AMT, PO number, status | Oracle GL (ADG) | One row per open commitment | Commitments and remaining balance | Required |
| Object code translation table | GL_OBJECT_CODE → operational category | Agency-provided | One row per object code | Personnel, overtime, vehicles, equipment, training, supplies, other | Required |
| Budget transfers / amendments | transfer amount, from/to, date, reason | Oracle GL (ADG) | One row per transfer | Drivers of budget transfers | Required |
| Multi-year history | at least 3 prior fiscal years of budget and actual | Oracle GL (ADG) | One row per FY / cost center / object code | Fiscal-year comparison and forecasting | Required |
| Forecast assumptions | spend-rate method, seasonality, known one-time items | Budget Office | One row per assumption | Forecast and projected variance | Preferred |
3.7 Reporting & User Experience
Standard dashboards, a governed self-service report builder, AI-assisted reporting, calculated measures, query reuse, exports and a feedback workflow.
| Standard dashboards: approved recurring reports available when users sign in. | Reports → standard report catalog; Home | Demonstrated |
|---|---|---|
| Self-service report builder across governed dimensions (fields, filters, dates, employees, events, contracts, cost centers). | Report Builder | Demonstrated |
| AI-assisted reporting by typed or spoken question, grounded only in permitted data. | Ask bar; Ask module; Financial Reporting → AI Q&A | Demonstrated |
| Calculated measures: reusable calculations promoted into the governed semantic model. | Semantic Model → Measures; Report Builder measures | Demonstrated |
| Existing query reuse: incorporate approved SQL/manual queries as validated starting logic. | Semantic Model → Registered Queries | Illustrative |
| Export approved views to Excel, CSV, PDF and print. | Export controls on every table and drill-down | Demonstrated |
| Feedback workflow: narrated screen recordings/transcripts to request refinements. | Updates & Memos | Demonstrated |
3.7.R Required Data
Data elements the source extracts must contain for the reports currently laid out in this module to populate. 5 required, 2 preferred.
| Approved recurring report list | report name, audience, frequency, definition | Agency-provided | One row per report | Standard dashboard catalog on sign-in | Required |
|---|---|---|---|---|---|
| Governed dimension catalog | dimension id, business label, restricted flag | Semantic model | One row per dimension | Report Builder field picker and AI grounding | Required |
| Approved measure definitions | measure name, formula, owner, approval status | Semantic model | One row per measure | Calculated measures in builder and AI answers | Required |
| Existing SQL / manual queries | query text, owner, purpose, validated output | Agency-provided | One row per query | Registered Queries reuse as starting logic | Required |
| User roles and permissions | user → role → permitted data scope | Agency directory | One row per user role | AI answers and exports limited to permitted data | Required |
| Export and branding standards | header/footer, logo, disclaimers, file naming | Agency-provided | One standard set | Excel, CSV, PDF and print output | Preferred |
| Feedback routing | reviewer names, request categories, SLA | Agency-provided | One row per category | Updates & Memos refinement workflow | Preferred |
All figures in the platform are currently seeded, deterministic sample data built to the same shape as the ADG, Kronos, Oracle Benefits and Oracle GL sources named in the semantic model. Connecting live Volusia County data replaces the seed without changing module structure, calculations or reports.