Every pay adjustment on work that already has a calculated price — where the volume, the money and the office time go, and the ranked list of what actually moves them.
The biggest number in this analysis is not an automation opportunity. It is that Paper/Wire and insulation are priced wrong, and that $97,161 a year is paid on requests the office already judged invalid or grasping. Software is rank 3 and below.
Ranked by impact. Every prize below is computed on this report’s population; per-year figures are the 24-month figure halved. Jared, 2026-09-10: "please make suggestions for course of action - what will make the biggest impact and how you would suggest tackling them."
Paper/Wire generates an adjustment on 54.0% of its task rows against a 23.0% population rate - 2,084 adjustments, 18.1% of everything in the report, $179,714 over 24 months. Its dominant request theme is windows / flashing / trim: 674 requests, $63,316, median $100. The rate is 62.9% in Orem and 66.1% in Salt Lake against 25.1% in Ogden - a 2.5x spread on the same task, which is a price difference, not a difficulty difference. Separately, the insulation family has no working base rate at all: Insl Attic 100.0%, Insl Walls 98.5%, Insl Pre 1 94.7% - 382 adjustments on 391 task rows. One crew, Segundo Heriberto Torres, is 505 adjustments at an 85.2% rate across Insl Pre 1 / Insl Walls / Insl Attic / Insl Foam 1 / Shutters, and 331 of his requests read as "extra scope". He is not grasping; he is being paid through the wrong channel.
The pattern. 21 teams sit above a 60% adjustment rate on 30+ task rows. Eight of them have Paper/Wire as their top task type and the top one is an insulation crew. Chronic adjusters are not spread across trades - they cluster on two price lists.
Basis: 598/yr if Paper/Wire ran at the 23.0% population rate, plus 823/yr if the 21 chronic teams did
This is money that stops flowing through the ADJUSTMENT channel, not money saved. Most of it is work the crews really did and would be paid for in the base rate instead. The genuinely recoverable slice is the grasping premium - see rank 2. Treat the $ as "volume that leaves the office queue".
High-rate teams and Paper/Wire overlap on 1,264 adjustments / $103,770. The union is 3,179 adjustments = 27.7% of the whole population, $287,783 over 24 months.
$153,997 over 24 months - $76,999/yr - was paid on requests the office itself categorised GRASPING. 1,214 of 1,900 grasping requests were paid, 63.9%, median $100. A further $40,323 ($20,162/yr) was paid on requests marked "Not a Valid Request" - 408 of 629, 64.9%. And $345,198 ($172,599/yr) was paid on the 4,131 requests that carry no evaluation at all, 63.1% of them. In total $192,760/yr leaves the company with no valid recorded approval, and $97,161/yr of that is explicitly labelled invalid or grasping by the reviewer who looked at it.
The pattern. The evaluation field is advice, not a control. Nothing in the schema connects a decision to a payment.
Basis: $76,999/yr paid on Grasping + $20,162/yr paid on Not a Valid Request. Both are decisions the office already made and then did not enforce.
"Never evaluated but paid" may partly be requests reviewed verbally or in the free-text results box. Treat the $172,599/yr as uncontrolled rather than wrong.
1,668 adjustments - 14.5% of the population, $161,662 over 24 months, $80,831/yr - are one of four reasons that recur at a stable price: material not ready / waiting / access (917, $97,343), return trip / second visit (715, $62,277), small job / minimum (178, $15,290) and weather (83, $9,895). They price themselves: the ten most common amounts are 66-81% of each theme's paid rows, 92.4% of every paid adjustment in the file is a multiple of $5, and the top twenty amounts alone cover 77.4% of all paid rows. The office is re-deciding $50, $60, $80 and $100 several hundred times a year.
Basis: 1,668 adjustments over 24 months that a crew could self-serve from a priced menu instead of writing a sentence for someone to read.
Collapses the amount variance on these four reasons, which is what makes them auditable afterwards.
Payroll Adjustment Category (6491) is BLANK on 53.0% of the population - 6,090 adjustments, 4,065 of them paid, $542,073 over 24 months ($271,037/yr) with no category at all. And its 14 choices are outcome labels - Valid Request, Grasping, Standard Adjustment - not reasons. Tipo de Ajuste (4589), the crew-facing field, has exactly FOUR choices: Dificultad extremo 44.4%, Viaje extra 25.8%, Reparaciones 25.4%, Diferencias con los planos 16.3% [~600 requests from one pay period, read live 2026-09-10]. There is no choice for ladder or height, none for material, none for weather, none for small job, and no "other". A crew with a height complaint has to file it as "extreme difficulty" or leave it blank. That is why the category is blank on half the file and why the office reads 10,457 free-text sentences a year.
Basis: Nothing in ranks 2, 3, 5 or 6 can be targeted, measured or audited while the reason is a Spanish sentence. This is the cheapest change with the widest reach.
1,228 adjustments (10.7% of the population, $150,362 over 24 months) sit on jobs built without scaffold; 749 of them ($95,198) are on trades the existing 4365 footage switch already covers. Annual adjustment spend on no-scaff jobs is $75,181, of which $36,473 is EXCESS over what the same trades generate on scaffold jobs. On measured footage - now available for 70.0% of no-scaff jobs, up from 33.6% - the budget-neutral rate is $0.0281/sq ft per covered task (excess-neutral) or $0.0538 all-in; on the strict stucco-only cut, $0.0129 and $0.0291.
The pattern. The rate moved 6.2x from the v3 figure and NOT because the money changed. v3 could only see 187 no-scaff jobs, on view 2807, and those were the big ones - ~2,047 ft each against a 671 ft measured median across all no-scaff jobs. No-scaff houses are small: only 31.1% carry any stucco footage at all, against 67% of scaffold jobs. Do not put $0.0453 on Additional Pay Per Foot (3645).
Basis: All no-scaff adjustments / the excess over the scaffold benchmark. Combined with the fuel build this covers 23.0% of the population by count and 25.0% by dollars.
Fuel / travel / distance plus return trip is 1,583 adjustments, 13.8% of the population, $126,341 over 24 months ($63,170/yr). Roughly 41% clear the 30-mile crow-flies gate (Sep 1 measurement), so ~$26,000/yr and ~324 requests/yr would auto-pay. It also carries the highest defer-to-office rate of any theme at 45.8% - it is the single biggest generator of "unclear, ask the office".
Basis: Half the 24-month union auto-triaged; the qualifying 41% auto-paid.
68.3% of Ogden's evaluated requests come back "Unclear - defer to office", against 19.4% in the rest of the company. Ogden is 9.9% of adjustments and 35.7% of all defers - 685 of 1,919. It is not disengagement: Ogden has the BEST evaluation coverage in the company (88.4% of requests evaluated, against 62.0% in Orem and 50.3% in St. George) and marks only 1.8% not-valid and 0.7% too-high. The division looks at everything and forwards it.
Basis: If Ogden deferred at the 19.4% non-Ogden rate it would send 195 requests to the office instead of 685 - 490 fewer over 24 months.
Tipo de Ajuste (4589), Request Completed Date (4269), Hours Late (4270), Review Date (9480) and Adjustment Request AI Summary (6409) exist on EVERY Jobs Tasks record but sit only on the table default view (view 58), which carries ~360 fields and times out on every read. Adding them to MCP Jobs Tasks Pay Info FULL (view 2827) makes reason, lateness and request-to-decision turnaround reportable for the whole population from the next nightly export onward. That is a VIEW EDIT, not a schema change. Retyping 4269 from paragraph to date IS a schema change - it currently holds a date as text, so TrackVia cannot sort or subtract it - and needs a migration of the existing values.
What it unlocks. Median 5.3 days from request to review, p90 8.4 days, 19.0% over a week [216 request/review pairs, one pay period, read live 2026-09-10]. Nobody has had this number before. It is a floor, because unreviewed requests - the ones that sit longest - have no review date to measure.
Basis: Turns a 2.8%-coverage 600-row sample into a full 24-month series, and removes the "turnaround cannot be computed" caveat from every future report.
Payroll Adjustment Results is a short-answer text field with 2,842 distinct values across 10,021 filled rows. Reviewers sign with initials - AS 1,552, MP 503, Ron 416, SH 253, KW 201, RO 159 - and that is the ONLY trace of who decided anything in the entire payroll-adjustment process. Six people carry the whole review load and the system does not know their names. The approved amount is also not stored separately, which is why "Valid, but too high" (1,010 requests, 81.4% paid, $124,556) cannot be audited: there is no record of what it was reduced FROM.
Basis: No $ of its own. It is what makes rank 2 enforceable, rank 7 measurable and reviewer workload visible for the first time.
| Group | Items, in rank order |
|---|---|
| Quick wins — view and field edits, weeks | 8. Add five fields to view 2827 and retype 4269. Then this analysis reruns itself. 4. Fix the reason vocabulary. Neither reason field answers "why". 7. Ogden evaluates everything and decides nothing. |
| Builds — scripts and fields, 1 to 2 months | 3. A fixed-amount menu on the request form for the four repeat reasons. 2. Make review a payment gate, and decide what "Grasping" is worth. 5. Ship the ladder per-foot adder - but settle the no-scaff definition before setting any rate. 6. Ship the fuel gate as designed. 9. Replace the free-text results box with a decision, an amount and a reviewer. |
| Policy — no software | 1. Two trade price lists are wrong. Fix the price, not the workflow. 7. Ogden evaluates everything and decides nothing. the Grasping ruling inside 2 |
Like for like — the two 12-month halves of the same window, so neither side is flattered by which months it contains — adjustments went from 4,285 to 7,196 (1.68×), and trimmed dollars from $354,487 to $677,701 (1.91×). Task-pay rows themselves only grew 1.41×, so this is not just more work: the share of rows carrying an adjustment rose from 20.69% to 24.63%, +3.94 points. The median adjustment moved from $80 to $100.
| Like-for-like half | Adjustments | Task-pay rows | Rate | Trimmed $ | Adjustments / month | Median |
|---|---|---|---|---|---|---|
| Year 1 — Sep 10, 2024 to Sep 10, 2025 | 4,285 | 20,715 | 20.69% | $354,487 | 357.1 | $80 |
| Year 2 — Sep 10, 2025 to Sep 9, 2026 | 7,196 | 29,215 | 24.63% | $677,701 | 599.7 | $100 |
| Change | 1.68× | 1.41× | +3.94 pp | 1.91× | 1.68× | $20 |
Day-based halves of the window, so both sides are the same length (year 2 is 2 days short). This is the honest year-on-year comparison; the calendar-year averages above are skewed by which months each side contains.
■ bars: the selected measure per month · ━ line: adjustment rate, that type’s adjustments divided by its task-pay rows in that month · the last month (Sep 26) is partial and is drawn pale.
Section 8 of findings.md ("The ladder question, quantified both ways"). Reading A (ladder = the height/scaffold text theme) and Reading B (ladder = a tiered fee schedule) are both wrong. It is a per-foot adder gated on the absence of scaffold, so it is sized off no-scaff JOBS and FOOTAGE, not off request text.
A job is SCAFF if its lifetime task list (MCP Jobs Tasks General Data FULL, view 2805, 69,112 task rows) contains any of Set Scaff / Fix Scaff / Remove Scaff / Set Brick Scaff / Scaff Pickup. It is NO-SCAFF if it has none of those AND has reached at least one post-scaffold production milestone task (Stucco Color, Paint, Stucco Brown, Scratch Coat, Siding, Rock, Brick, Gutters, Soffit/Fascia, 4-Way Pass, QC Walk, Base Install Complete, Watering, Cleanup). Jobs with no scaff task and no milestone task are IMMATURE (not yet built) and are excluded from both sides rather than counted as no-scaff.
Source: Jobs :: Scaff Footage (field 5513), recovered 2026-09-10 for 535 jobs as a Job lookup on COO All Payroll Adjustments (view 2941). It is an ESTIMATE written at bid time. These 535 jobs are the jobs sitting in the LIVE adjustment queue, i.e. recent jobs that generated an adjustment. It is not a random sample of the 24-month job universe. Overall agreement across 541 testable jobs is 88.2%, but agreement on the no-scaff side alone is 1.6%.
No-scaff task rows generate $38.73 of adjustment per task row against $19.94 on scaffold jobs — $18.79 of excess per task, $36,473/yr, inside $75,181/yr of total no-scaff adjustment spend. The adder is meant to replace the excess, not the whole figure.
| Trade | No-scaff task rows | $ / task, no-scaff | $ / task, scaff | Excess $ / task | Excess $ / yr | In the 4365 footage switch? |
|---|---|---|---|---|---|---|
| Soffit/Fascia | 366 | $87.21 | $18.37 | $68.84 | $12,598.33 | yes |
| Siding | 537 | $55.19 | $18.99 | $36.20 | $9,719.00 | yes |
| Paint | 232 | $97.67 | $27.72 | $69.95 | $8,114.72 | no |
| Vinyl | 199 | $47.17 | $17.50 | $29.67 | $2,952.28 | no |
| Housewrap | 329 | $28.03 | $17.25 | $10.78 | $1,773.95 | yes |
| Gutters | 423 | $5.62 | $1.59 | $4.04 | $854.22 | no |
| Rock | 187 | $19.32 | $11.39 | $7.94 | $741.93 | yes |
| Stucco Brown | 190 | $18.32 | $13.05 | $5.27 | $500.85 | yes |
| Stucco Color | 192 | $34.55 | $30.49 | $4.06 | $389.57 | yes |
| Return/Fix | 65 | $23.31 | $13.53 | $9.78 | $317.84 | no |
| Cleanup | 72 | $3.89 | $0.00 | $3.89 | $140.00 | no |
| Brick | 48 | $29.52 | $25.09 | $4.42 | $106.20 | yes |
| Insl Walls | 44 | $171.02 | $167.62 | $3.41 | $74.95 | no |
| Scratch Coat | 191 | $2.23 | $1.57 | $0.66 | $63.09 | yes |
| Watering | 111 | $0.99 | $1.51 | $-0.52 | $-28.66 | no |
| Porch OSB | 79 | $0.63 | $3.80 | $-3.16 | $-124.97 | no |
| Insl Attic | 42 | $68.81 | $86.28 | $-17.47 | $-366.94 | no |
| Foundation Plaster | 85 | $20.56 | $31.35 | $-10.79 | $-458.55 | no |
| Insl Pre 1 | 42 | $47.86 | $90.23 | $-42.37 | $-889.85 | no |
| Paper/Wire | 298 | $29.70 | $45.78 | $-16.07 | $-2,395.17 | yes |
| All trades | 3,882 | $38.73 | $19.94 | $18.79 | $36,473 |
Soffit/Fascia, Siding, Paint and Vinyl are the four trades carrying the effect. Negative excess — the trade generates less adjustment on no-scaff jobs than on scaffold jobs — on Watering, Porch OSB, Insl Attic, Foundation Plaster, Insl Pre 1, Paper/Wire, so they are excluded from any adder. Additional Work and Back Charge sit inside the population but outside this table, because they carry no footage. Trades with fewer than 150 classified task rows are omitted.
The request text is the wrong population to size from. Only 28.9% of ladder/height/scaffold-theme adjustments land on no-scaff jobs; 71.1% land on jobs that DID have scaffold. The theme is therefore mostly about scaffold pay - erecting, fixing, moving and striking scaffold - not about working off ladders. It is still a real signal: 28.9% against a 12.6% baseline share is a 2.29x concentration, and the no-scaff median is $200.0 against $100.0 on scaff jobs. An adder sized off the text theme would be sized off the wrong population.
Footage is now measured on 389 of 556 no-scaff jobs (70.0%), up from 25.7% when the only readable footage sat on the 1,341-record RECENT jobs view. Coverage of no-scaff jobs went from 25.7% to 70.0%. But only 31.1% of no-scaff jobs carry Stucco Footage above zero at all, against 67% of scaff jobs, and the no-scaff median is 708 ft against 2,965 ft on scaff jobs. No-scaff jobs are disproportionately small and non-stucco - siding, vinyl and low elevations. That is a fact about WHO the adder pays, not a data gap.
| Basis | Jobs | Footage | Excess-neutral $/ft | All-in $/ft | What it means |
|---|---|---|---|---|---|
| Per covered task — what the live chain does | 389 | 2,594,432 ft | $0.0281 | $0.0538 | USE THIS ONE for a rate that goes on Additional Pay Per Foot (3645). A house with 8 covered tasks receives the adder 8 times. |
| Per house — footage counted once per job | 389 | 260,970 ft | $0.2791 | $0.5346 | Comparable to the v3 figure, which also counted footage once per job. Only meaningful if the adder were a single per-house payment, which the existing chain is not. |
| Strict stucco-only, real wall area | 173 | 2,346,843 ft | $0.0129 | $0.0291 | USE THIS for the stucco-family trades (Stucco Brown, Stucco Color, Scratch Coat, Paper/Wire), whose 4365 footage fields are stucco areas. |
| v3, for comparison | 187 | — | $0.0453 | $0.0848 | Superseded. 6.2x higher below the same-basis v4 figure, because it was sized on the 187 biggest no-scaff jobs. |
Footage is NOT one unit. Stucco / Paint / Housewrap footage is wall square footage in the thousands per house; Soffit/Fascia, Siding, Gutters, Rock and Brick footage are linear or small-area figures in the hundreds. A single company-wide $/ft rate would therefore pay a soffit crew ~12x less than a paint crew for the same house. The adder must be set per trade in that trade's own footage unit, or applied to one common wall-footage figure.
| Trade | Task rows with footage | Measured footage | Median ft / task | Adjustment $, 24 mo | Excess-neutral $/ft | All-in $/ft | In 4365 switch? |
|---|---|---|---|---|---|---|---|
| Soffit/Fascia | 337 | 82,285 | 163 | $31,319 | $0.3054 | $0.3806 | yes |
| Siding | 483 | 223,676 | 197 | $28,199 | $0.0851 | $0.1261 | yes |
| Paint | 210 | 148,163 | 195 | $21,025 | $0.1026 | $0.1419 | no |
| Vinyl | 194 | 43,255 | 167 | $9,207 | $0.1344 | $0.2129 | no |
| Housewrap | 287 | 171,220 | 223 | $8,918 | $0.0232 | $0.0521 | yes |
| Insl Walls | 44 | 10,555 | 197 | $7,525 | $0.0142 | $0.7130 | no |
| Paper/Wire | 234 | 260,749 | 391 | $7,148 | $-0.0137 | $0.0274 | yes |
| Stucco Color | 173 | 243,875 | 909 | $6,183 | $0.0037 | $0.0254 | yes |
| Stucco Brown | 169 | 227,565 | 1,393 | $3,031 | $0.0036 | $0.0133 | yes |
| Insl Attic | 42 | 10,005 | 197 | $2,890 | $-0.0734 | $0.2889 | no |
| Gutters | 348 | 214,401 | 204 | $2,379 | $0.0085 | $0.0111 | no |
| Insl Pre 1 | 42 | 10,005 | 197 | $2,010 | $-0.1779 | $0.2009 | no |
| Foundation Plaster | 81 | 14,102 | 163 | $1,658 | $-0.0625 | $0.1175 | no |
| Return/Fix | 58 | 36,109 | 230 | $1,435 | $0.0180 | $0.0397 | no |
| Brick | 43 | 42,051 | 600 | $1,417 | $0.0080 | $0.0337 | yes |
| Rock | 123 | 177,600 | 1,711 | $359 | $-0.0059 | $0.0020 | yes |
| Watering | 93 | 176,542 | 2,060 | $110 | $-0.0002 | $0.0006 | no |
| Porch OSB | 63 | 137,596 | 2,087 | $50 | $-0.0014 | $0.0004 | no |
| Cleanup | 50 | 27,865 | 197 | $40 | $0.0014 | $0.0014 | no |
| Scratch Coat | 128 | 173,657 | 1,693 | $0 | $-0.0012 | $0.0000 | yes |
Company-wide cost at a flat rate, on 1,297,216 ft of annual covered footage: $0.0050/ft = $6,486/yr · $0.0100/ft = $12,972/yr · $0.0200/ft = $25,944/yr · $0.0500/ft = $64,861/yr · $0.1000/ft = $129,722/yr · $0.1500/ft = $194,582/yr · $0.2500/ft = $324,304/yr.
The per-foot adder mechanism already exists and is live. This is not a new build - it is a new trigger condition on an existing chain.
| Step | TrackVia object | What it does today |
|---|---|---|
| 1 | Task Team Additional Task Pay (table) :: Additional Pay Per Foot (field 3645) | One record per Task Team x Task carrying a $/ft rate and a When To Apply choice (Always / Only Buildings / Only SF). |
| 2 | Jobs Tasks :: Before Update (BEFORE_UPDATE), lines 78-94 | On any unpaid task with a Task Team, find()s the matching Task Team Additional Task Pay record, applies the When To Apply test against Job.Building Flag, and writes the rate to Additional Team Pay Per Foot (4367). Sets it to null when no rule matches. |
| 3 | Jobs Tasks :: Additional Team Pay Per Foot (field 4367, currency) | The per-task rate slot. 8 usages. On 2 forms (Job Task Office Form, Payroll View Job Task Form) where it drives a show/hide rule, and on MCP Jobs Tasks Pay Info FULL (view 2827). |
| 4 | Jobs Tasks :: Additional Team Pay Amount (field 4365, calculated currency) | rate x the job footage for that task type, plus Additional Team Pay Fixed Amount. This is the per-foot multiplication, already written. |
| 5 | Jobs Tasks :: Task Pay Amount (field 682, calculated currency, 212 usages) | Sums Calculated Pay Amount + Additional Pay Amount + Additional Team Pay Amount - Amount to Pay Later + Backcharge Amount, with a Final Pay Amount override and a Minimum Task Pay Amount floor. |
| Task type | Footage field the 4365 formula reads |
|---|---|
| Stucco Brown | Jobs :: Stucco Brown Pay Footage |
| Stucco Color | Jobs :: Stucco Color Pay Footage |
| Scratch Coat | Jobs :: Scratch Extra Pay Footage |
| Paper/Wire | Jobs :: Paper/Wire Extra Pay Footage |
| Rock | Jobs :: Rock Pay Footage |
| Housewrap | Jobs :: Housewrap Footage |
| Siding | Net Vertical Lap + Net Siding + Net Shake + Net Batten Footage (on the task) |
| Set Tarps | Jobs :: Tarp Footage |
| Soffit/Fascia | Jobs :: Soffit Extra Pay Footage |
| Brick | Jobs :: Brick Footage |
| Set Scaff | Jobs :: Scaff Footage (+ Brick Footage when Thin Brick? or Brick Wainscot Only?) |
| Remove Scaff | Jobs :: Scaff Footage + Brick Footage |
Half of these adjustments have no recorded reason at all. 6,090 of 11,481 (53.0%) carry a blank Payroll Adjustment Category (6491), and 4,514 of those were paid anyway — $542,073 over 24 months, $271,037/yr with no category on the record. 3,426 have neither a category nor an evaluation.
| Division | Adjustments | Blank category | Blank % |
|---|---|---|---|
| Orem | 5,878 | 3,000 | 51.0% |
| Salt Lake | 2,427 | 1,383 | 57.0% |
| St. George | 1,798 | 1,117 | 62.1% |
| Ogden | 1,134 | 392 | 34.6% |
| Commercial | 244 | 198 | 81.1% |
| All | 11,481 | 6,090 | 53.0% |
Tipo de Ajuste (4589) unavailable in the full export, so "Tipo set but 6491 blank" cannot be measured over the 24-month window.
| Payroll Adjustment Category (6491) | Adjustments | Paid rows | Trimmed $ | Median |
|---|---|---|---|---|
| (blank) | 6,090 | 4,065 | $542,073 | $100 |
| Valid Request | 2,207 | 1,988 | $243,914 | $100 |
| Grasping | 1,900 | 1,214 | $153,997 | $100 |
| Standard Adjustment | 1,551 | 1,232 | $182,935 | $120 |
| Low Pay Adjustment | 543 | 539 | $31,625 | $50 |
| Return Trip | 242 | 232 | $16,252 | $60 |
| No Details | 122 | 22 | $1,916 | $76 |
| Estimation Error | 103 | 80 | $14,658 | $155 |
| VPO | 75 | 22 | $4,492 | $170 |
| Shared Task | 45 | 7 | $870 | $120 |
“Valid Request”, “Grasping” and “Standard Adjustment” describe what the office decided, not what the crew asked for. The crew-facing field that should carry the reason — Tipo de Ajuste (4589) — has four choices and none of them is ladder, material, weather or small job (see section 10).
7,350 of 11,481 adjustments were evaluated by a CM (64.0%); 4,131 were not. Of those evaluated, 1,919 (26.1%) came back “Unclear — defer to office”, which is ~80 requests a month landing on somebody’s desk in corporate.
| Outcome | Adjustments | Paid rows | Paid % | Trimmed $ | Median |
|---|---|---|---|---|---|
| (not evaluated) paid anyway | 4,131 | 2,605 | 63.1% | $345,198 | $90 |
| Valid Request | 3,665 | 2,941 | 80.2% | $340,380 | $80 |
| Unclear - Defer to Office | 1,919 | 1,334 | 69.5% | $173,108 | $100 |
| Valid, but too high | 965 | 785 | 81.3% | $119,055 | $120 |
| Not a Valid Request paid anyway | 612 | 394 | 64.4% | $38,398 | $70 |
| Needs Additional Info | 189 | 122 | 64.6% | $16,050 | $90 |
Ogden evaluates almost everything and decides almost nothing. 68.3% of its evaluated requests come back “defer to office” against 19.4% everywhere else. Ogden is 9.9% of adjustments and 35.7% of every defer in the company (685 of 1,919). It is not disengagement — Ogden has the best evaluation coverage anywhere (88.4% evaluated) and marks only 1.8% not-valid and 0.7% too-high. It looks at everything and forwards it.
| Division | Adjustments | Evaluated | Evaluated % | Defer | Defer % of evaluated | Not valid % | Too high % |
|---|---|---|---|---|---|---|---|
| Orem | 5,878 | 3,644 | 62.0% | 535 | 14.7% | 11.8% | 17.4% |
| Salt Lake | 2,427 | 1,689 | 69.6% | 437 | 25.9% | 5.0% | 8.8% |
| St. George | 1,798 | 905 | 50.3% | 246 | 27.2% | 10.6% | 23.8% |
| Ogden | 1,134 | 1,003 | 88.4% | 685 | 68.3% | 1.8% | 0.7% |
| Commercial | 244 | 109 | 44.7% | 16 | 14.7% | 0.0% | 6.4% |
| All divisions | 11,481 | 7,350 | 64.0% | 1,919 | 26.1% | 8.6% | 13.7% |
10,458 of 11,481 adjustments carry request text (1,023 do not). Those sentences were mined for recurring themes; a request can carry more than one, and 3,004 (28.7% of the text rows) match no theme at all.
| Theme | Adjustments | Share of text | Trimmed $ | Median | Top-10 amount share | Deferred % | Blank category % |
|---|---|---|---|---|---|---|---|
| Extra scope / added work | 1,744 | 16.7% | $160,558 | $90 | 64.7% | 22.9% | 47.6% |
| Ladder / height / scaffold | 1,428 | 13.7% | $166,620 | $120 | 54.5% | 22.2% | 54.3% |
| Windows / flashing / trim | 1,289 | 12.3% | $128,288 | $105 | 53.8% | 15.1% | 39.3% |
| Fuel / travel / distance | 1,054 | 10.1% | $78,922 | $60 | 67.8% | 45.8% | 32.0% |
| Hours claimed (time-based) | 1,010 | 9.7% | $99,400 | $100 | 67.8% | 21.5% | 54.0% |
| Material not ready / waiting / access | 917 | 8.8% | $97,343 | $100 | 66.4% | 23.1% | 53.0% |
| Stone / block / mix / lath | 845 | 8.1% | $74,113 | $90 | 64.5% | 18.9% | 48.4% |
| Return trip / second visit | 715 | 6.8% | $62,277 | $80 | 72.5% | 20.1% | 41.8% |
| Difficulty / hard conditions | 493 | 4.7% | $60,957 | $120 | 63.3% | 22.9% | 41.8% |
| Paint / color / texture | 473 | 4.5% | $60,702 | $120 | 54.0% | 25.6% | 35.7% |
| Repairs / rework | 467 | 4.5% | $38,636 | $85 | 58.4% | 16.2% | 52.5% |
| Footage / measurement dispute | 372 | 3.6% | $38,365 | $125 | 53.9% | 33.2% | 51.3% |
| Says supervisor authorized it | 273 | 2.6% | $26,810 | $100 | 60.1% | 18.3% | 40.7% |
| Cleanup | 180 | 1.7% | $21,294 | $100 | 64.6% | 23.1% | 80.0% |
| Small job / minimum | 178 | 1.7% | $15,290 | $60 | 80.8% | 21.6% | 38.8% |
| Bare dollar amount, no reason given | 173 | 1.7% | $18,355 | $135 | 70.7% | 41.5% | 53.2% |
| Plan discrepancy | 171 | 1.6% | $12,926 | $120 | 52.3% | 29.2% | 43.3% |
| Crew size claimed | 137 | 1.3% | $18,283 | $150 | 61.4% | 24.7% | 51.8% |
| Helper / extra crew | 108 | 1.0% | $10,330 | $80 | 68.2% | 32.2% | 27.8% |
| Weather | 83 | 0.8% | $9,895 | $120 | 70.6% | 28.3% | 55.4% |
| Equipment / rental | 53 | 0.5% | $6,416 | $120 | 77.5% | 28.6% | 47.2% |
| Patching / fix scaff | 42 | 0.4% | $5,290 | $100 | 71.4% | 11.1% | 54.8% |
| Per-unit rate claimed | 24 | 0.2% | $3,762 | $146 | 70.0% | 30.0% | 45.8% |
| Duplicate / already paid | 6 | 0.1% | $380 | $80 | 100.0% | 0.0% | 50.0% |
Theme counts per request: 0 → 3,004 · 1 → 4,264 · 2 → 2,045 · 3 → 805 · 4 → 251 · 5 → 72 · 6 → 17. The unmatched residual is 3,004 requests, $229,279 paid, median $80 — short, specific, one-off sentences.
The twenty most common amounts account for 77.4% of every paid adjustment. 92.4% are a multiple of $5, 81.5% a multiple of $10, 43.1% a multiple of $25; only 7.6% are anything else. These are not calculations. They are a price list that lives in people’s heads, re-agreed one request at a time.
Themes ranked by how mechanisable they look: volume, how tightly the amounts cluster, how much office time they consume, and how small the typical payment is. A high score means the reason repeats at a stable price — the conditions for a fixed amount or a formula. It is not a recommendation on its own; the ranked course of action in section 1 is.
| # | Theme | Score | Adjustments | Trimmed $ | Median | Amount spread (cv) | Top-10 share | Deferred % |
|---|---|---|---|---|---|---|---|---|
| 1 | Extra scope / added work | 67.1 | 1,744 | $160,558 | $90 | 0.80 | 64.7% | 22.9% |
| 2 | Ladder / height / scaffold | 59.9 | 1,428 | $166,620 | $120 | 0.69 | 54.5% | 22.2% |
| 3 | Fuel / travel / distance | 59.2 | 1,054 | $78,922 | $60 | 0.88 | 67.8% | 45.8% |
| 4 | Windows / flashing / trim | 56.9 | 1,289 | $128,288 | $105 | 0.70 | 53.8% | 15.1% |
| 5 | Hours claimed (time-based) | 55.3 | 1,010 | $99,400 | $100 | 0.77 | 67.8% | 21.5% |
| 6 | Material not ready / waiting / access | 52.7 | 917 | $97,343 | $100 | 0.81 | 66.4% | 23.1% |
| 7 | Stone / block / mix / lath | 51.5 | 845 | $74,113 | $90 | 0.76 | 64.5% | 18.9% |
| 8 | Return trip / second visit | 50.8 | 715 | $62,277 | $80 | 0.81 | 72.5% | 20.1% |
| 9 | Difficulty / hard conditions | 45.3 | 493 | $60,957 | $120 | 0.69 | 63.3% | 22.9% |
| 10 | Paint / color / texture | 42.9 | 473 | $60,702 | $120 | 0.72 | 54.0% | 25.6% |
| 11 | Repairs / rework | 42.6 | 467 | $38,636 | $85 | 0.82 | 58.4% | 16.2% |
| 12 | Small job / minimum | 42.4 | 178 | $15,290 | $60 | 0.90 | 80.8% | 21.6% |
| 13 | Footage / measurement dispute | 42.3 | 372 | $38,365 | $125 | 0.74 | 53.9% | 33.2% |
| 14 | Duplicate / already paid | 42.3 | 6 | $380 | $80 | 0.75 | 100.0% | 0.0% |
| 15 | Bare dollar amount, no reason given | 41.4 | 173 | $18,355 | $135 | 0.82 | 70.7% | 41.5% |
Lower cv means the amounts on that theme sit closer together; a high top-10 share means a handful of prices cover most of the payouts. Both are what make a fixed amount defensible.
Read against the request-text themes, fuel/travel and ladder/height together touch 2,834 adjustments (24.7% of the population), 177 of them in both. That leaves 8,647 adjustments and $758,750 untouched by anything currently being built.
| Population | Adjustments | Share | Paid rows | Trimmed $ | Median |
|---|---|---|---|---|---|
| Fuel / travel / distance | 1,583 | 13.8% | 1,310 | $126,341 | $70 |
| Ladder / height text theme | 1,428 | 12.4% | 1,077 | $166,620 | $120 |
| Everything else | 8,647 | 75.3% | 5,929 | $758,750 | $100 |
Fuel tier gate is >=30 crow-flies one-way miles from the team leader home; that distance is NOT stored on Jobs Tasks, so this file cannot re-apply the gate. Sep 1 measured 59% of travel adjustments inside a 30-mile radius, i.e. roughly 41% of the fuel/travel population would qualify for a non-zero tier.
Sized the way the ladder adder is actually going to be built — off no-scaff jobs rather than off request text (section 3) — the picture changes: the no-scaff population on trades the 4365 footage switch already covers is 749 adjustments ($95,198), and across all trades 1,228 ($150,362). Fuel plus the all-trades no-scaff population is 2,640 adjustments, 23.0% of the population and 25.0% of the dollars — leaving a remaining pool of 8,841 adjustments and $774,188.
The fuel build pays $0 below 30 crow-flies one-way miles; only ~41% of the fuel/travel/return union clears that gate (Sep 1 measurement, not recomputed here). The ladder adder has no equivalent gate.
Over the 24-month window, request-to-decision turnaround cannot be computed. Not because TrackVia does not hold the timestamps — it does — but because they are not on the export view.
Turnaround CANNOT be computed from this dataset, but not because the timestamps are missing from TrackVia - they are missing from the EXPORT. Jobs Tasks does carry Payroll Adjustment Request Completed Date (field 4269, stored as a PARAGRAPH not a date), Payroll Adjustment Request - Hours Late (field 4270, number, already computed) and Payroll Adjustment Review Date (field 9480, date, only 3 usages so effectively unused). None of the three is on MCP Jobs Tasks Pay Info FULL (view 2827) or RECENT (view 2828), so no history of them is reachable. Complete->Pay Date below is a payroll-calendar artefact, not review speed.
Complete-to-pay latency is not turnaround. That interval is the payroll calendar — when the pay run falls — and says nothing about how fast a request was reviewed. It is deliberately not reported here as a review-speed figure.
| Choice | Requests | % of rows with a value |
|---|---|---|
| Dificultad extremo | 264 | 44.4% |
| Viaje extra | 153 | 25.8% |
| Reparaciones | 151 | 25.4% |
| Diferencias con los planos | 97 | 16.3% |
| Rows with a value | 594 | of 601 rows · 66 carry two or more |
Field 4589, multi-select, Spanish. FOUR choices only - there is no ladder, height, scaffold, material, weather or small-job choice, and no "other". A crew with a height complaint has to file it as Dificultad extremo or leave it blank. This is why 4589 and Payroll Adjustment Category (6491) do not agree and why 53.8% of the 24-month population has a blank 6491. [~600 payroll-adjustment requests from one pay period (Sep 2026), read live on 2026-09-10 read-only through the beta TrackVia MCP. Not the 24-month window.]
~600 payroll-adjustment requests from one pay period (Sep 2026), read live on 2026-09-10 read-only through the beta TrackVia MCP. Not the 24-month window. FIRST REAL REQUEST-TO-DECISION NUMBER. Turnaround = Payroll Adjustment Review Date (9480, a real date field) MINUS Payroll Adjustment Request Completed Date (4269, stored as a PARAGRAPH - a date held as text, which is why TrackVia itself cannot compute this). Nothing else in TrackVia measures it. It is NOT the complete-to-pay gap in d["turnaround"], which is the payroll calendar.
Read the median as a floor. 9480 is populated on only 289 of the 998 rows and 216 of the matched 601, and it was added recently, so the pairs skew to requests that HAVE been reviewed. Unreviewed requests - the ones that sit longest - are structurally missing from this measure. Read the median as a floor. 9480 is date-only and 4269 carries a time, so a same-day review can compute as a small negative. Negatives are reported and excluded from the stats.
The AI summary field is already populated on 816 of 998 live-queue records (81.8%). Adjustment Request AI Summary (6409) - an AI translation + summary of the crew request already exists and is already populated on most of the live queue. Any triage build extends this, it does not start from scratch. [~600 payroll-adjustment requests from one pay period (Sep 2026), read live on 2026-09-10 read-only through the beta TrackVia MCP. Not the 24-month window.]
Tipo de Ajuste (4589), Payroll Adjustment Request Completed Date (4269), Hours Late (4270), Review Date (9480) and Adjustment Request AI Summary (6409) all exist on the Jobs Tasks default view (view 58) for every record. View 58 carries ~360 fields over the whole table and times out at 30 s on every read, so history is unreachable through the connector. Adding these five fields to MCP Jobs Tasks Pay Info FULL (view 2827) makes them reportable from the next nightly export onward - a view edit, not a schema change.
258 task teams appear in the window. The top 20 by count carry 45.9% of all adjustments and 42.6% of the dollars.
| Task team | Adjustments | Task rows | Rate | Paid rows | Trimmed $ | Median | Pre-trim $ |
|---|---|---|---|---|---|---|---|
| Hector Moreta | 540 | 1,567 | 34.5% | 394 | $37,275 | $60 | $49,568 |
| Segundo Heriberto Torres | 505 | 593 | 85.2% | 457 | $50,949 | $80 | $62,749 |
| Juan Pablo Moreno | 436 | 1,746 | 25.0% | 311 | $25,123 | $60 | $29,008 |
| Ernesto Ramirez | 395 | 1,371 | 28.8% | 347 | $37,717 | $80 | $41,897 |
| Javier Vazquez | 377 | 1,949 | 19.3% | 299 | $39,090 | $80 | $67,230 |
| Sergio Aguilar | 277 | 673 | 41.2% | 104 | $12,257 | $80 | $21,288 |
| Rodrigo Alcantar | 274 | 473 | 57.9% | 238 | $16,881 | $50 | $16,881 |
| Armando Segundo-Garcia | 261 | 559 | 46.7% | 213 | $28,922 | $100 | $38,495 |
| Juan Perez | 238 | 342 | 69.6% | 195 | $17,303 | $75 | $18,003 |
| Alan Gonzalez | 225 | 630 | 35.7% | 175 | $13,950 | $60 | $15,378 |
| Reynaldo Martinez | 222 | 286 | 77.6% | 169 | $16,981 | $86 | $18,048 |
| Rafael Moguel | 212 | 1,050 | 20.2% | 159 | $26,865 | $120 | $61,519 |
| Ricardo Anastacio Mejia | 206 | 258 | 79.8% | 164 | $16,232 | $82 | $16,232 |
| Cristian Bermudes | 181 | 581 | 31.1% | 118 | $16,143 | $100 | $58,217 |
| Jorge Castro | 181 | 632 | 28.6% | 119 | $20,085 | $135 | $27,551 |
| Vicente Silva-Zavala | 169 | 246 | 68.7% | 127 | $9,464 | $60 | $10,239 |
| Daniel Rodriguez | 158 | 495 | 31.9% | 126 | $14,920 | $100 | $17,495 |
| Ariel Ramirez | 148 | 308 | 48.0% | 114 | $11,015 | $100 | $11,915 |
| Alejandro Huerta | 133 | 173 | 76.9% | 103 | $19,720 | $160 | $45,485 |
| Alfredo Chavarin Lopez | 131 | 436 | 30.1% | 110 | $8,734 | $60 | $8,734 |
| Task type | Adjustments | Task rows | Rate | Trimmed $ |
|---|---|---|---|---|
| Paper/Wire | 2,084 | 3,862 | 54.0% | $179,714 |
| Set Scaff | 1,115 | 3,348 | 33.3% | $84,187 |
| Siding | 1,106 | 4,381 | 25.2% | $99,916 |
| Stucco Color | 911 | 2,839 | 32.1% | $89,716 |
| Soffit/Fascia | 840 | 3,257 | 25.8% | $83,479 |
| Housewrap | 790 | 3,451 | 22.9% | $57,604 |
| Paint | 709 | 3,092 | 22.9% | $91,075 |
| Fix Scaff | 648 | 1,658 | 39.1% | $51,730 |
| Remove Scaff | 500 | 3,215 | 15.6% | $38,643 |
| Stucco Brown | 404 | 2,771 | 14.6% | $37,662 |
| Rock | 383 | 2,238 | 17.1% | $26,073 |
| Return/Fix | 248 | 1,023 | 24.2% | $12,435 |
| Brick | 218 | 773 | 28.2% | $19,094 |
| Insl Walls | 134 | 136 | 98.5% | $20,890 |
| Insl Pre 1 | 124 | 131 | 94.7% | $9,068 |
| Population | 11,481 | 49,930 | 22.99% | $1,032,188 |
1,796 jobs — 50.0% of the 3,589 jobs that generated any adjustment — carry three or more, and they hold 8,771 adjustments (76.4% of the population) worth $805,261. 9,332 distinct request texts cover the 10,458 requests that carry text; 37 of those texts were used five times or more, covering 370 requests (3.5% of text rows). Crews are copy-pasting a sentence that worked.
| Request text | Times used |
|---|---|
| me puede ajustar el pago al precio acordado por favor | 44 |
| instalación de soffit con escaleras $200 | 34 |
| 80 dlrs de ajuste | 27 |
| 60 dlrs de ajuste | 21 |
| trabajo terminado 60$ | 18 |
| si nos apoya con unos 80 dolares que tiene un desnivel considerable creo que estaríamos bien | 15 |
| ya he platicado con alan acerca del precio de un dólar por pie cuadrado gracias | 12 |
| 450 dólares | 12 |
| si nos apoya con unos 80 dolares que tiene un pequeño desnivel creo que estaríamos bien | 10 |
| si nos apoya con unos 100 dolares que tiene un desnivel considerable creo que estaríamos bien | 9 |
| 60 dlrs desnivel | 9 |
| gas | 8 |
| aver si me pueden dar 30 dólares para la gasolina | 8 |
| 60 dlrs de desnivel | 8 |
| solicito 70 dolares por este trabajo porqué no ajusta la paga | 7 |
| Job | Adjustments | Trimmed $ |
|---|---|---|
| 32 (Lawyer)-The Ridge at Alpine-E Builders | 23 | $3,136 |
| Bldg 60-Highridge-Edge | 20 | $1,390 |
| Bldg K-Daybreak Downtown-Sego Homes | 19 | $1,270 |
| Bldg 7-Mt. Rainier-Edge | 19 | $590 |
| Units 251-252-Paired Villas-Sego Homes | 18 | $2,797 |
| Dewsnup Mountain Home-Custom Jobs (Spanish Fork)-Spencer Edwards | 17 | $540 |
| Bldg 28-Mt. Rainier-Edge | 16 | $740 |
| 8 (Wagstaff)-Gable Ridge-E Builders | 16 | $2,155 |
| Bldg 11-Mt. Rainier-Edge | 16 | $400 |
| Bldg 24-Mt. Rainier-Edge | 15 | $1,395 |
| Bldg 12-Mt. Rainier-Edge | 15 | $740 |
| 351-Watermark Village-Sego Homes | 15 | $1,706 |
| Bldg 16-Mt. Rainier-Edge | 15 | $718 |
| Drew Armstrong PG Buildings-Custom Jobs-Battle Creek | 15 | $1,300 |
| 4-Holladay Hills Estates-Tri Pointe Homes | 14 | $965 |
Payroll Adjustment Results (shortAnswer) is free text; reviewers sign with initials. This is the ONLY trace of who decided. Not a user field, not reportable, not enforceable. 2,842 distinct values sit in that one free-text box. The initials that appear most often:
| Signature in the results text | Requests |
|---|---|
| AS | 1,552 |
| MP | 503 |
| Ron | 416 |
| SH | 253 |
| KW | 201 |
| RO | 159 |
| Alan | 14 |
| Request | 4 |
Six people carry effectively the whole review load and the system does not record any of their names in a field. That is what section 1 rank 9 fixes.
Read from the TrackVia metadata snapshot 2026-09-08, not from the pulled records. These already exist and are relevant to "what can we systematize".
| Field or workflow | What it already does |
|---|---|
Adjustment Request AI Summary (field 6409, paragraph, 20 usages) | An AI summary of the crew request already exists and is surfaced on the COO and pending-adjustment views. Any triage/auto-categorisation work should extend this, not start from scratch. |
Payroll Adjustment Request - Hours Late (field 4270, number, 33 usages) | Request lateness is already computed and drives Workato view "Workato_ payroll adjustment request more than 48 hours late" (view 1253). |
Proposed Additional Pay Amount (7640) + Proposed Payroll Adjustment Results (9542) + Approve Proposed Pay Amounts + Adjustment - More Info Needed From DM (9543) + Has Pending Payroll Adjustment Flag (9545) | A propose/approve workflow was built recently (high field ids). An auto-adjustment should write the PROPOSED field, because Jobs Tasks :: Before Update lines 19-22 restrict approval of Payroll Adjustment Results to kyle@, ed@, it@ and jared@cascade.build. |
Suspend This Team From Submitting Payroll Adjustments (7637) + Task Teams :: Payroll Adjustments Suspension End Date (7636) | A team-level suspension lever already exists - the enforcement half of any grasping policy is built. |
Additional Pay Amount (684) | HARD BLOCKER for any auto-adjustment: Jobs Tasks :: Before Update line 33 throws if the field is already set. It is ONE currency slot per task, so a ladder amount and a fuel amount cannot coexist without a new currency field that rolls into Task Pay Amount. |
Payroll Adjustment Category (6491) | 14 choices, none of them fuel, travel, ladder or height. Adding a choice touches 19 views, 3 forms, 1 filter and 1 calc (Adjustment Category Text). |
Every headline figure benchmarked against the TrackVia view its readers would open. For this report the honest answer is that no such view exists, so the source is cited instead.
| Report figure | Report value | TrackVia reference | Its count | Status |
|---|---|---|---|---|
| Pay adjustments, 24 months (this report’s population) | 11,481 adjustments · $1,032,188 trimmed | no view reproduces this population | not available no view in the account counts adjustments over 24 months | no reproducing view — source view cited Pulled from the cached nightly export of MCP Jobs Tasks Pay Info FULL (view 2827), joined to MCP Jobs Tasks General Data FULL (view 2805) and MCP Jobs General Data FULL (view 2803), covering Sep 10, 2024 to Sep 8, 2026. The narrowing makes the tie-out problem WORSE, not better: no TrackVia view filters out VPO / Misc. / Warranty / Custom task types or warehouse-overhead jobs, and the 2026-09-10 beta-MCP sweep confirmed no view anywhere in the account counts adjustments over 24 months. Every payroll-adjustment view is a live queue of 82-958 records. Do not imply any screen reproduces this number. |
| Closest tie-out a reader can open | 5,391 adjustments carry a category in this window | Payroll Adjustments By Category (view 1993), Cascade Task Tracking | not read the read-only reports connector has no count-only call; a human reads it off the screen | differs — expected, and in a known direction Payroll Adjustment Category is not blank. No date bound - all time. Expect this view to read HIGHER than 5,391, because it is not date-bounded and this report is, and it shows only the 47.0% of adjustments that carry a category at all. |
| Live queue depth (not a historical count) | — | COO All Payroll Adjustments (view 2941), Cascade Task Tracking | 958 records read live 2026-09-10, read-only, through the beta TrackVia MCP | not an anchor — queue depth This is what is open on the desk right now, not a 24-month history. A live work queue, not a history. Counts open/unresolved items only; does not tie to any historical total. |
| Job footage behind the ladder rates (section 3) | 389 no-scaff jobs with a measured area (70.0% coverage) | Scraper Job Footages (view 2377), Jobs | 17,519 job records paged in full read live 2026-09-10, read-only, through the beta TrackVia MCP | source view cited — derived population No TrackVia view lists jobs built without scaffold; the concept is not stored, so the no-scaff population is derived from the lifetime task list on MCP Jobs Tasks General Data FULL (view 2805) and cannot be read off a screen. Stucco Footage (field 467) is populated on 89.3% of the referenced jobs. |
| Current pay period sample (section 10) | 998 records read, 601 matched to the export | COO All Payroll Adjustments (2941), Workato All Payroll Adjustments (1958), Payroll Adjustments In My Division (2648), Current Payroll Adjustments Not Inspected (2132) | 998 records read live 2026-09-10, read-only, through the beta TrackVia MCP | one pay period — labelled as a sample throughout These are live work queues covering roughly the current pay period. Every figure taken from them is labelled as a ~600-row one-pay-period sample and is never presented as a 24-month figure. |
Beta TrackVia MCP, read-only, superadmin: no connector-produced 24-month count exists. The only defensible connector-sourced figure is COO All Payroll Adjustments (view 2941) = 958 records, which is LIVE QUEUE DEPTH as of 2026-09-10, not a historical count. trendRecords on MCP Jobs Tasks Pay Info FULL (view 2827) caps at a 10,000-row scan and reaches back only ~4 months, under-counting every month it does reach (2026-07: 1,156 vs the export 1,372). Do not use it.
Beta TrackVia MCP use on 2026-09-10: READ-ONLY. Tools used: whoAmI, getViews, describeView, resolveField, queryRecords, getViewRecords, exportAppSchema, trendRecords. Nothing was created, updated or deleted. No record in the 24-month population was changed, re-pulled or re-derived from the connector. The population itself still comes entirely from the cached nightly exports.
Field divisions only (Orem, Salt Lake, St. George, Ogden, Commercial), MINUS task types VPO Work / Misc. Work / Warranty Work / Custom Work, MINUS every warehouse / manufacturing / internal-overhead row (Corporate division, builder = "Overhead", or an Overhead Projects / warehouse job name), MINUS rows whose division could not be resolved. Every task type left in the population has calculated pay, so an adjustment on it is a crew asking for MORE than the calculated amount - not the pay mechanism itself.
Applied in this order, each row counted once. Start = 61,742 task-pay rows / 21,405 adjustment-signal rows in the 2024-09-10 .. 2026-09-08 window. Percentages elsewhere in this file are all computed on what is left.
| Excluded population | Task rows | Adjustments | Pre-trim $ | Trimmed $ | Why |
|---|---|---|---|---|---|
| Corporate division (warehouse / cleanings / overhead projects) | 2,398 | 2,304 | $374,014 | $209,587 | Warehouse / internal-overhead hourly labour — Additional Pay Amount is the pay mechanism on these rows, not a crew asking for more. |
| No division resolved | 160 | 122 | $33,130 | $12,376 | No division could be resolved, so the row cannot be attributed to a field division. |
| Overhead-billed jobs sitting inside a field division | 53 | 34 | $40,447 | $3,187 | Warehouse / internal-overhead hourly labour — Additional Pay Amount is the pay mechanism on these rows, not a crew asking for more. |
| VPO Work | 4,250 | 3,390 | $810,316 | $392,400 | Always-adjusted task type — no calculated pay, so the adjustment IS the pay mechanism. |
| Misc. Work | 2,917 | 2,485 | $673,783 | $298,343 | Always-adjusted task type — no calculated pay, so the adjustment IS the pay mechanism. |
| Warranty Work | 1,655 | 1,262 | $190,522 | $118,303 | Always-adjusted task type — no calculated pay, so the adjustment IS the pay mechanism. |
| Custom Work | 379 | 327 | $694,980 | $27,972 | Always-adjusted task type — no calculated pay, so the adjustment IS the pay mechanism. |
| Excluded, total | 11,812 | 9,924 | $2,817,192 | $1,062,169 | |
| This report’s population | 49,930 | 11,481 | $2,074,347 | $1,032,188 |
Reconciliation: 9,924 excluded + 11,481 in the population = 21,405 adjustment-signal rows, which is every signal row in the window (21,405). On task rows: 11,812 + 49,930 = 61,742 of 61,742.
Population from the cached nightly TrackVia exports (Task Pay Info full, view 2827, 2026-09-08) joined to Tasks General full (view 2805) and Jobs General full (view 2803). Job footage and the current-period gap fields read live 2026-09-10 through the beta TrackVia MCP, read-only. Analysis 2026-09-10, v4.