Attachment B - ALARS Interface FINAL 12 10 15.docx
DOCX document 27 KB Posted
- Solicitation number
- BD-16-1030-0R100-0R001-00000006553
- Issued by
- Massachusetts
About this file
The document contains information about an Attachment B - ALARS Interface related to a state and local contract opportunity for the Massachusetts Department of Transportation (MassDOT) and Registry of Motor Vehicles (RMV) to manage and implement a Vehicle Emission and Safety Test Program. The attachment describes the interface between the RMV's Automated Licensing And Registration System (ALARS) database and the Program's current vendor's corporate servers, which uses IBM MQSeries connections. It details the specific data fields required to post vehicle inspection results to ALARS, as well as the data elements that ALARS will return in response. After contract award, the selected Contractor will work with the RMV to define the appropriate interface for the Inspection Program, which may include developing new guest/host data blocks and functions to support inspections.
The related state and local contract opportunity is for the management and implementation of the Vehicle Emission and Safety Test Program, including developing and managing the Inspection Station network, developing and implementing inspection protocols, and acquiring, providing, and maintaining Inspection Station equipment and data systems. The Contractor will also be responsible for training Program inspectors and providing communications to the public, inspectors, and repairers.
View the file
Other files
Show 40 more
Latest 50 of 80 listed here. See the rest on GovTribe.
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
RFR Attachment B: ALARS Interface RMV’s Automated Licensing And Registration System (ALARS) database has an interface that permits remote systems to submit transactions and receive responses. The current implementation uses direct IBM MQSeries connections as the communication mechanism between ALARS and the Program's current vendor’s corporate servers. MassDOT already has a specified set of IBM MQSeries messages for: authorizing inspectors, authorizing vehicles, posting vehicle inspections, and posting training updates for inspectors. This includes registration and vehicle look ups, vehicle registration status, and the ALARS unique identifiers for registrations and vehicles. Inquiries are processed in CICS in real-time against the ALARS database.
After Contract Award, the Contractor will work with the RMV to define the interface appropriate for the Inspection Program. At some level, the interface will be based upon guest/host data blocks. If necessary, RMV may develop new guest/host blocks and functions to support Inspections. This would include the capability to post inspection results to ALARS.
Additionally, after Contract Award, the Contractor will support an interface to RMV’s Violations, Investigations and Scheduling, Information and Tracking System (VISITS) with status updates on Inspection Stations and licensed Inspectors. VISITS is web based and uses an Oracle database.
After Contract Award, RMV will determine the Inspection results information that the Contractor must provide to ALARS, and RMV will work closely with the Contractor to develop an efficient and reliable exchange of data. To post a vehicle inspection, ALARS currently requires the fields from Table B-1 in the MQ message.
Table B-1: Store Test Record Request from Database
| Tag Name |
| Data Element |
| Description |
| Field Length |
| Valid Values |
| RMVH_APPL_ID |
| Transaction Type |
| Identifies the type of transaction requested by the vendor |
| 4 char |
alphanumeric INMT = Inspection Maintenance
| RMVH_TRAN_ID |
| Transaction ID |
| Identifies the transaction type |
| 2 char alphanumeric |
| VU = Vehicle Update |
| TRAN_NUMB |
| Transaction Number |
| VID generated number that uniquely identifies a transaction between the VID and ALARS |
| 11 char |
numeric
| TRAN_DATE |
| Transaction Date |
| Date of transaction recorded by the VID. |
| 8 char |
numeric Format: CCYYMMDD
| TRAN_TIME |
| Transaction Time |
| Time of transaction recorded by the VID. |
| 6 char |
numeric Format: HHMMSS
| VEH_PLATE_STATE |
| State of Record |
| The state where vehicle is registered |
| 2 char |
Alphanumeric
| VEH_PLATE_TYPE |
| License Plate Type |
| Identifies the type of license plate. |
| 3 char alphanumeric |
| VEH_PLATE |
| Vehicle License Plate number |
| License Plate or Registration Number (Section 5 vehicles) |
| 10 char alphanumeric |
| VEH_VIN |
| Vehicle Identification Number |
| Vehicle Identification Number |
| 17 char alphanumeric |
| Valid Vehicle VIN |
| INSP_NUMB |
| Inspectors license number |
| Identifies the inspector performing this inspection |
| 9 char Alphanumeric |
| INSPN_STATION |
| Inspection station number |
| Identifies the inspection station where the inspection is taking place |
| 8 char Alphanumeric |
| VEH_MODEL_YEAR |
| Vehicle Model Year |
| Vehicle Model Year |
| 4 char |
Numeric
CCYY
| VEH_MAKE |
| Vehicle Make |
| Vehicle Make |
| 5 char |
Alphanumeric
| VEH_MODEL |
| Vehicle Model |
| The model of the vehicle. |
| 6 char alphanumeric |
VEH_FUEL_TYPE
| Vehicle Fuel Type |
| Fuel Type value |
| 1 char |
Alphanumeric
· G = Gas
· E = Electric
· F = Flex
· D = Diesel
· P = Propane
· B = Hybrid
· C = Compressed Natural Gas
| ODOMETER |
| Vehicle odometer |
| The current vehicle mileage. |
| 9 char |
Numeric
| VEHC_PURCHASE_DATE |
| Vehicle Purchase Date |
| The date the vehicle was purchased. |
| 8 char |
Alphanumeric Format: CCYYMMDD
| INSPN_DATE |
| Inspection Date |
| The date the inspection occurred at the inspection station |
| 8 char alphanumeric |
| Format: CCYYMMDD |
| INSPN_TIME |
| Inspection Time |
| The time the inspection occurred at the inspection station |
| 6 char |
numeric Format: HHMMSS
| INSPN_TYPE |
| Inspection Type |
| The type of inspection that was performed. |
| 1 char alphanumeric |
| · A = AUDIT |
· C = Challenge
· I = Initial
· O = Override
· P = Program
· R = Reinspection
· W = Waiver
| INSPN_CYCLE |
| Inspection Cycle |
| The inspection cycle indicator |
| 1 char alphanumeric |
| · B = Safety & Emissions |
· S = Safety Only
| INSPN_RESULT_SAFETY |
| Safety Inspection Result |
| Result of the safety inspection. |
| 1 char |
Alphanumeric
· F = Failed
· N = N/A
· P = Passed
| INSPN_RESULT_EMISSIONS |
| Emissions Inspection Result |
| Result of the emissions inspection. |
| 1 char alphanumeric |
| · F = Failed |
· N = N/A
· P = Passed
· W = Waiver
| INSPN_STICKER_NUMB |
| Sticker Number |
| Sticker number. |
| 9 char alphanumeric |
| CONTINUE_INDC |
| Continue Indicator |
| Continue with inspection indicator |
| 1 char alphanumeric |
| · C = Continue |
· S = Stop
| MATCH_INDC |
| Vehicle Match Indicator |
| Registration/VIN matching indicator |
| 1 char |
Alphanumeric
· Y = Match
· N = No Match
| RECIP_INDC |
| Reciprocal Inspection Indicator |
| Inspection was performed on an out of state vehicle? |
| 1 char alphanumeric |
| · Y = Yes |
· N = No
| COVERT_INDC |
| Covert Inspection Indicator |
| Inspection performed on a covert vehicle? |
| 1 char alphanumeric |
| · K = Workstation |
· D = DEP
· I = VID
· N = No
| OFFLINE_INDC |
| Offline Inspection Indicator |
| Inspection performed offline? |
| 1 char alphanumeric |
| · K = Workstation off to VID |
· V = VID off to ALARS
· N = No
| TRANSFER_INDC |
| Vehicle Ownership Transfer Indicator |
| Indicates vehicle transfer of ownership |
| 1 char alphanumeric |
| · Y = Transferred |
· N = No Transfer
| FREE_INSPN_INDC |
| Free Inspection Indicator |
| Indicator, free or paid inspection |
| 1 char alphanumeric |
| · F = Free |
· P = Paid
| INIT_INSPN_DATE |
| Initial Inspection Date |
| Date of the initial inspection in the test sequence. |
| 8 char alphanumeric |
| Format: CCYYMMDD |
| ALARS_UPDATE_INDC |
| ALARS Update indicator |
| Indicator, delete inspection, update sticker number, or new inspection to be stored |
| 1 char alphabetic |
| · D = Delete inspection |
· U = Update sticker number for this inspection
· N = New inspection data (if blank, default is new inspection)
| INSPN_EXPIRATION_DATE |
| Inspection expiration date |
| The next inspection due date |
| 8 char alphanumeric |
| Format: CCYYMMDD |
| LAST_FREE_INSPN_DATE |
| Last free inspection date |
| Last day a free inspection can take place after this paid inspection |
| 8 char alphanumeric |
| Format: CCYYMMDD |
| 7D_INSPN_STICKER_NUMB |
| 7D Inspection sticker number |
| Special sticker number for 7D vehicles |
| 9 chars alphanumeric |
| COMMERCIAL_INDC |
| Commercial vehicle indicator |
| Indicates if vehicle is a commercial vehicle |
| 1 char alphabetic |
| · Y = Commercial vehicle |
· N = Not commercial
| 7D_VEH_INDC |
| 7D Vehicle indicator |
| Indicates if the vehicle is a 7D vehicle |
| 1 char alphabetic |
| · Y = 7D vehicle |
· N = Not 7D
| VEH_PLATE_PRI_STATUS |
| Primary Registration status |
| Registration/plate status (usually ACTV or active) |
| 4 char |
| VEH_PLATE_SEC_STATUS |
| Secondary Registration status |
| Registration/plate status (usually blank) |
| 4 char |
| VEHR_SURR |
| Registration table primary key |
| The primary key used to identify this record on the RMV’s registration table |
| 9 characters |
| Specifies which record on the registration table the RMV matched to this inspection |
| VEHC_SURR |
| Vehicle table primary key |
| The primary key used to identify this record on the RMV’s vehicle table |
| 9 characters |
| Specifies which record on the vehicle table the RMV matched to this inspection |
Upon receipt of a vehicle inspection record, ALARS currently sends the fields in Table B-2 in a response MQ message.
Table B-2: ALARS Response to Database
| Tag Name |
| Data Element |
| Description |
| Field Length |
| Valid Values |
| TRAN_NUMB |
| Transaction Number |
| This is the same transaction number that was sent in the request. |
| 11 char |
numeric
| ALARS_DATE_POSTED |
| ALARS Date Posted |
| Date ALARS posted fees for this inspection |
| 8 char alphanumeric |
| Format: CCYYMMDD |
| ALARS_TIME_POSTED |
| ALARS Time Posted |
| Time ALARS posted fees for this inspection |
| 6 char |
numeric Format: HHMMSS
| BATCH_NUMB |
| ALARS Batch Number |
| ALARS invoice number for this inspection |
15 char numeric
| RSLT_SURR |
| Inspection result surrogate number |
| Inspection record primary key |
| 9 characters |
| In case the VID needs to know the primary key of this inspection as stored on ALARS |
File details come from the government source that posted it. Updated .