Attachment D - DREAMS - LWDBPC BPC01 Manual Form BPC99 Keying Instructions.xlsx
XLSX spreadsheet 417 KB Posted
- Solicitation number
- 18DPP00190
- Issued by
- Mercer County, New Jersey
About this file
The provided document is an excerpt from the Attachment D - DREAMS - LWDBPC BPC01 Manual Form BPC99 Keying Instructions.xlsx file, which details the keying instructions for the New Jersey Division of Revenue and Enterprise Services' data entry/verification services contract opportunity (T2775). This contract opportunity involves services for Mercer County and Trenton City jurisdictions. The file outlines the required data fields, data formats, and business rules for keying information such as applied dates, agency codes, claimant IDs, address sources, installment amounts, balance due, and remitted amounts. Additionally, the instructions provide guidance on handling incomplete or missing data, such as entering the current month and year if the month and year are blank on the manual write-up.
The contract term, pricing details, set-asides, incumbent information, funding requirements, and other salient details are not included in the provided document. The focus of this excerpt is solely on the data entry and verification requirements for the contract.
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 | |
| T2775 Subcontractor Utilization Form.pdf | ||
| Attachment J - DCR - NJ1065G.doc | DOC document | |
| T2775 Ownership Disclosure Form.pdf | ||
| Attachment E - DREAMS - MVCRR keying instructions.xlsx | XLSX spreadsheet |
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
LWDPBC
| Reference Name | Keyed Order | Data Width | Min Data | Business Rule | Character Set | Permit Negatives | Over Rideable | Force Key |
| LWDBPC - BPC01 | ||||||||
| Applied Date | 1 | 8 | 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 | N | |||||
| Agency Code | 2 | 5 | 5 | BPC01 | A-Z | ||||
| 0-9 | N | N | N | ||||||
| Claimant ID | 3 | 9 | 9 | 9 digits, Never all zeros | 0-9 | N | N | N | |
| Claimant ID CD | 4 | 1 | 1 | 0-9 | N | Y | N | ||
| NCTL | 5 | 4 | 4 | Alpha Only | A-Z | N | N | N | |
| Month | 6 | 2 | 2 | Month can be 01 - 12 | 0-9 | N | N | N | |
| Year | 7 | 2 | 2 | Year should be current Year or Current Year plus 1 | 0-9 | N | Y | N | |
| Address Source | 8 | 1 | 1 | '0' or '1' | 0-9 | N | N | N | |
| Scan Lin CD | 9 | 1 | 1 | 0-9 | N | Y | N | ||
| Install Amt | 10 | 10 | 10 | If field = 0 or blank, output 10 space | 0-9 | N | N | N | |
| Balance Due | 11 | 10 | 10 | 0-9 | N | N | N | ||
| Install Agree | 12 | 1 | 1 | '0' or '1' | 0-9 | N | N | N | |
| Address Change | 13 | 1 | 1 | '0' or '1' | 0-9 | N | N | N | |
| Remitted Amt | 13 | 1 | Amount Enclosed' on form | 0-9 | N | N | N |
| LWDBPC Manual Form- BPC99 | ||||
| Applied Date | 1 | 8 | 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 | N | |||||
| Agency Code | 2 | 5 | 5 | BPC99 - Hide from key | A-Z | ||||
| 0-9 | N | N | N | ||||||
| Claimant ID | 8 | 9 | 9 | 9 digits, Never all zeros | 0-9 | N | N | Y | |
| NCTL | 7 | 4 | 4 | Alpha Only | A-Z | N | N | Y | |
| Month | 3 | 2 | 2 | Month can be 01 - 12 | 0-9 | N | N | Y | |
| Year | 4 | 2 | 2 | Year should be current Year or Current Year plus 1 | 0-9 | N | Y | Y | |
| Address Source | 1 | 1 | Hide from key, output zero | 0-9 | N | N | Y | ||
| Install Amt | 10 | 10 | Hide from key, output spaces | 0-9 | N | N | Y | ||
| Install Agree | 5 | 1 | 1 | 0-9 | N | N | Y | ||
| Address Change | 6 | 1 | 1 | '0' or '1' | 0-9 | N | N | Y | |
| Remitted Amt | 12 | 1 | Amount Enclosed' on form | 0-9 | N | N | N | ||
| Balance Remitted Amount to either Installment Amount or Balance Due | |||||||||
| The Manual Form only has 1 field for Amount Paid. The Keying order is the left column, then the right. SSN is not captured. | |||||||||
| If there is no FID or social security number on either the coupon or check, key in all 7s. | |||||||||
| Year should be current Year or Current Year Plus or Minus 1. If it falls outside this rule, you will need to override. | |||||||||
| There are batches in Labor Bill Review because the month and year are blank on the manual write up. |
Looking at the normal bill, the month and year in the scan line are for when the money is due. Let’s add the following rule for manual payments:
If the Month or year is missing, please enter the current month and year.
For the items sent to review, the operator would be entering 11 15.
Sample Images image1.png image2.emf
File details come from the government source that posted it. Updated .