Attachment E - DREAMS - MVCRR keying instructions.xlsx
XLSX spreadsheet 17 KB Posted
- Solicitation number
- 18DPP00190
- Issued by
- Mercer County, New Jersey
About this file
This document contains the keying instructions for the DREAMS - MVCRR (Division of Revenue and Enterprise Services - Motor Vehicle Commission Record Renewal) system. It provides detailed specifications for the various data fields to be entered, including field names, field numbers, number of digits, business rules, allowed characters, and whether negative values are allowed or the field is overridable.
The related state and local contract opportunity is for Data Entry/Verification Services for the Division of Revenue and Enterprise Services, covering the jurisdictions of Mercer County and Trenton City in New Jersey. The contract appears to be for a multi-year term, though the specific duration is not provided.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| T2775 Bid Amendment 1 06.07.19.docx | DOCX document | |
| Attachment B - DREAMS - 2018 PTR Keying Instructions - FINAL - 190227.xlsx | XLSX spreadsheet | |
| T2775 Bid Solicitation 042319.docx | DOCX document | |
| Attachment H - DCR - BLUER.DOC | DOC document | |
| Attachment I - DCR - GIT7X.doc | DOC document | |
| Attachment G - DCR - BLUEN.DOC | DOC document | |
| Attachment F - DCR - BLUEF.DOC | DOC document | |
| T2775 Offer and Acceptance Page.pdf | ||
| T2775 Price Sheet~1.xlsx | XLSX spreadsheet | |
| Attachment C - DREAMS - 2018 TGI Keying Instructions - 190123.xlsx | XLSX spreadsheet | |
| Attachment A - DREAMS - 2018 CBT-100 100S Keying Instructions FINAL - 180201.xlsx | XLSX spreadsheet | |
| T2775 Disclosure of Investments in Iran Form.pdf | ||
| T2775 Bid Solicitation Checklist.docx | DOCX document | |
| Attachment D - DREAMS - LWDBPC BPC01 Manual Form BPC99 Keying Instructions.xlsx | XLSX spreadsheet | |
| T2775 Subcontractor Utilization Form.pdf | ||
| Attachment J - DCR - NJ1065G.doc | DOC document | |
| T2775 Ownership Disclosure Form.pdf |
Show all 17
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1 Field Name Field Number Number of Digits Business Rule Characters, #s or symbols Allow Negative? Overridable?
Applied Date 49-49 8 A valid date
No future date
If header has valid date, hide this field from the keyer.
| If asterisks in the batch header (********), present the field to the keyer. Keyer will key the date from the coupon. | 0-9 | N | N | ||||
| Reg Renewal Code | 2-12 | 2 | RR | 0-9 | N | N | |
| Filler | 3-12 | 1 | Always ' /' | 0-9 | N | N | |
| Registration Code | 4-12 | 2 | 00 – 99 | 0-9 | N | N | |
| Filler | 5-12 | 1 | Always ' /' | 0-9 | N | N | |
| License Plate Number | 6-12 | 10 | First 4-character should not be 0’s. | A-Z |
0-9
| '/' | N | N | ||
| Expiration Date | 7-12 | 4 | First 2 digits must be valid month (01-12). |
Last 2 digits must be valid year (00-99).
| If Process Date is greater than the Expiration Date field plus 12 months, flag - Keyer will send the submission for review to be deleted from the batch to be handled manually. | 0-9 | N | N | |
| Plate Type | 8-12 | 2 | A-Z |
0-9
| '/' | N | N | |||||
| Gross Vehicle Weight | 9-12 | 5 | Cannot exceed 55000 | 0-9 | N | N | |
| Registration Fee Amt | 10-12 | 7 | 0-9 | N | N | ||
| Family Duplicate Fee | 11-12 | 7 | . | 0-9 | N | N | |
| CD | 12-12 | 1 | See CD 1,2 Mod 10 tab for details | 0-9 | N | Y | |
| Remitted Amount | 13 | "Pay This Amount" on form | 0-9 | N | N |
If a payment type is a money order, make check number "0"
| Balancing Rule: |
| Check amount should balance to either Registration Fee OR the Family Duplicate fee, +/- $1.00. When the difference is within +/- $1.00, operators should correct the Remitted Amount to match the Check Amount. |
| When the difference in Check Amount is GREATER THAN +/- $1.00, operators must send the submission to review. |
| For Multiples if one coupon has fees in the scanline and one doesn't, balancing the two coupons to the check will be correct. |
| Review Rule: |
| The reviewer will print the front of the check, write the scanned DLN on the copy, the submission will be deleted, the copy sent to Scanning to be pulled and sent to MVC for manual processing. |
For MVC No Money, if a transaction has an amount due (other than the family duplicate) it needs to be returned to MVC.
&"Arial,Bold"&28&F as of 6/6/14
Sheet2
Sheet3
Sheet4
Sheet5
File details come from the government source that posted it. Updated .