Reference Library

Rate Area Group + Lane Exception Handoff (Business-Readable)

Prepared: 2026-03-13 (live pull from RVDatabase)

What this package gives you

• •A direct raw copy of Roadvision zone group data (no 5-character trimming applied).
• •Today's rebuilt CLI-ready rate-area and lane files from live RV data.
• •A confidence readout showing which groups are safest and which need review.
• •A top-15-customer focused package based on last 12 months of shipment revenue.
• •Example import rows and gap examples with plain-language action notes.
• •A current CLI FACTS export comparison package using grp_area_import_20260313_150435.csv.

Headline numbers (today)

• •Raw RV zone groups in dbo.zone: 645
• •Raw RV zone detail rows in dbo.zone_dtl: 2,872
• •CLI-ready group rows emitted: 9,532
• •CLI-ready unique groups emitted: 719
• •Lane exception rows emitted: 5,936
• •Lane rows quarantined (not auto-imported): 21
• •Group codes marked unquestionably accurate: 155
• •Top 15 customer window: 2025-03-13 through 2026-03-13
• •Current CLI export rows: 10,565 (vs 9,532 in this handoff build)
• •Current CLI export unique groups: 738 (vs 719 in this handoff build)
• •Net row delta (CLI minus handoff): +1,033

Start here

1. 02_raw_live_rv_extracts/rv_group_list_raw_distinct.csv
2. 03_group_code_analysis/group_confidence_analysis.csv
3. 04_top15_customer_focus_12mo/top15_lane_exception_summary.csv
4. 05_import_examples_and_rules/import_rules_plain_language.md
5. 04_ZIP_TO_ZIP_AND_ALIAS_GUIDE.md + 03_group_code_analysis/zip_alias_implementation_matrix.csv
6. 06_cli_facts_current_export_compare/COMPARE_REPORT.md

Confidence tiers in simple terms

• •HIGH: direct live RV group code or evidence-backed alias; safest for launch.
• •MEDIUM-HIGH: live-backed, but renamed to fit 5-character CLI limit.
• •MEDIUM: usable, but there is a known caveat that should be reviewed.
• •LOW: not safe to assume; review before launch.

Tier counts

• •HIGH: 155 groups
• •MEDIUM-HIGH: 439 groups
• •MEDIUM: 30 groups
• •LOW: 95 groups