Appendix F - NYVIP Database Queries
NYVIP Summary of Inspections
Inputs
Start Date
End Date
NYMA Code: Choose From: Upstate, Downstate, Both
Outputs
Model Year
Total
Safety Only
LE
LD Diesel
HD Diesel
LD Gas
HD Gas
LD Flex
HD Flex
OBD
Area Change
Weight Change
Fuel Change
NYVIP Summary of OBD Inspections
Inputs
Start Date
End Date
NYMA Code: Choose From: Upstate, Downstate, Both
Outputs
VEHICLE_MODEL_YEAR
Total OBD
Init OBD
Retest OBD
Init OBD Pass
Init OBD Fail
Waiver
Waiver Rate
Init KOEO Fail
Init KOER Fail
Init MIL Cmd (no DTC)
Init MIL Cmd (DTC)
Init No MIL Cmd (DTC)
Init Readiness Fail
Init 10 Day
Retest OBD Pass
Retest OBD Fail
Retest KOEO Fail
Retest KOER Fail
Retest MIL Cmd (no DTC)
Retest MIL Cmd (DTC)
Retest No MIL Cmd (DTC)
Retest Readiness Fail
Total No Comm
Init No Comm (<8v)
Init No Comm (>8v)
Init DLC Missing
Init DLC Broken
Init NYVIP Broken
Init DLC Not Found
Retest No Comm (<8v)
Retest No Comm (>8v)
Retest DLC Missing
Retest DLC Broken
Retest NYVIP Broken
Retest DLC Not Found
Station Query
Inputs
Start Date
End Date
Facility Number
NYVIP Number
Inspection Type: Choose From: Initial, Re-test, All
Test Type: Choose From: All, OBD, Heavy Duty, Pre 1996, Motorcycle, Trailer, Safety Only
Outputs
FACILITY_NUMBER
NYVIP_NUMBER
INSPECTION_TYPE
TEST_TYPE
TOTAL
FAIL
OBD_TESTS
FAIL_OBD
FAIL_EMIS
FAIL_ECD
FAIL_SAFETY
FAIL_RATE
WAIVER
MIL_COMMANDED
MIL_KOEO_FAIL
MIL_KOER_FAIL
READINESS_FAIL
READINESS_FAIL_RATE
NO_COMM (<8v)
NO_COMM_RATE (<8v)
NO_COMM (>8v)
NO_COMM_RATE (>8v)
DLC_MISSING
DLC_MISSING_RATE
DLC_BROKEN
DLC_BROKEN_RATE
NYVIP_BROKEN
NYVIP_BROKEN_RATE
DLC_NOT_FOUND
DLC_NOT_FOUND_RATE
OVERALL_NO_COMM
OVERALL_NO_COMM_RATE
e_VIN_NO_MATCH
Station Query Data Change
Inputs
Start Date
End Date
Facility Number
NYVIP Number
Inspection Type: Choose From: Initial, Re-test, All
Test Type: Choose From: All, OBD, Heavy Duty, Pre 1996, Motorcycle, Trailer, Safety Only
Outputs
FUEL_TYPE_CHANGE
FUEL_TYPE
WEIGHT_CODE_CHANGE
DMV_VEHICLE_WT
VEHICLE_IDENTIFICATION_NUMBER
INSPECTION_DATE_TIME
INSPECTION_EXPIRATION_DATE
INSPECTION_TYPE
TRANSACTION_METHOD
FACILITY_NUMBER
ODOMETER_READING
RECALL_SATISFIED
NYMA_CHANGE
RECORD_NUMBER
INSPECTOR_CERTIFICATION_NUMBER
DATA_ENTRY_METHOD
GAS_CAP_CHECK
GAS_CAP_REPLACED
WAIVER_ISSUED
INSPECTION_CERTIFICATE_NUMBER
VEHICLE_MODEL_YEAR
VEHICLE_MAKE
VEHICLE_PLATE_NUMBER
NYMA
REG_CLASS_CODE
PUBLIC_MODEL_NAME
NON_REGISTERED_INDICATOR
NYVIP_NUMBER
TRANSMISSION_TYPE
HYBRID_VEHICLE
TEN_DAY_EXTENSION
DATE_TIME_END
DMV_RECORD_MATCH
INITIAL_EMISSIONS_RESULT
SOFTWARE_VERSION
STOPPED_TEST_REASON
TEST_TYPE
Station Query Multi PCM VIN
Inputs
Start Date
End Date
Facility Number
NYVIP Number
Inspection Type: Choose From: Initial, Re-test, All
Test Type: Choose From: All, OBD, Heavy Duty, Pre 1996, Motorcycle, Trailer, Safety Only
Outputs
PCM_VIN
VEHICLE_IDENTIFICATION_NUMBER
VEHICLE_MODEL_YEAR
VEHICLE_MAKE
VEHICLE_PLATE_NUMBER
PUBLIC_MODEL_NAME
INSPECTION_DATE_TIME
FACILITY_NUMBER
NYVIP_NUMBER
INSPECTION_TYPETEST_TYPE
OVERALL_RESULT
PCM_CODE_1
PCM_CODE_2
PID_CODE_1
PID_CODE_2
OBD_COMM_PROTOCOL
OVERALL_READINESS
COMPREHENSIVE_COMPS_READINESS
MISFIRE_READINESS
FUEL_CONTROL_READINESS
CATALYST_READINESS
O2_SENSOR_READINESS
EGR_READINESS
EVAP_EMISSIONS_READINESS
HEATED_CATALYST_READINESS
O2_SENSOR_HEATER_READINESS
SECONDARY_AIR_INJ_READINESS
AC_READINESS
Station Query NoComm
Inputs
Start Date
End Date
Facility Number
NYVIP Number
Inspection Type: Choose From: Initial, Re-test, All
Test Type: Choose From: All, OBD, Heavy Duty, Pre 1996, Motorcycle, Trailer, Safety Only
Outputs
FACILITY_NUMBER
INSPECTOR_CERTIFICATION_NUMBER
INITIAL_EMISSIONS_RESULT
VEHICLE_IDENTIFICATION_NUMBER
VEHICLE_PLATE_NUMBER
PCM_VIN
INSPECTION_DATE_TIME
DATE_TIME_END
RECORD_NUMBER
TEST_TYPE
ODOMETER_READING
NYVIP_NUMBER
INSPECTION_TYPE
STOPPED_TEST_REASON
Station Query Waiver
Inputs
Start Date
End Date
Facility Number
NYVIP Number
Inspection Type: Choose From: Initial, Re-test, All
Test Type: Choose From: All, OBD, Heavy Duty, Pre 1996, Motorcycle, Trailer, Safety Only
Outputs
FACILITY_NUMBER
INSPECTOR_CERTIFICATION_NUMBER
INITIAL_EMISSIONS_RESULT
WAIVER_ISSUED
VEHICLE_IDENTIFICATION_NUMBER
VEHICLE_PLATE_NUMBER
PCM_VIN
INSPECTION_DATE_TIME
DATE_TIME_END
RECORD_NUMBER
TEST_TYPE
ODOMETER_READING
NYVIP_NUMBER
INSPECTION_TYPE
VIN Lookup
Inputs
Start Date
End Date
VIN Number
Outputs
Full inspection record for entered VIN Number
PCM VIN Lookup
Inputs
PCM VIN Number
Outputs
Full inspection record for entered VIN Number
Vehicle VIN PCM NoMatch
Inputs
Start Date
End Date
Facility Number
NYVIP Number
Inspection Type: Choose From: Initial, Re-test, All
Test Type: Choose From: All, OBD, Heavy Duty, Pre 1996, Motorcycle, Trailer, Safety Only
Outputs
INSPECTION_DATE_TIME
FACILITY_NUMBER
VEHICLE_IDENTIFICATION_NUMBER
PCM_VIN
DATA_ENTRY_METHOD
VEHICLE_PLATE_NUMBER
DATE_TIME_END
RECORD_NUMBER
TEST_TYPE
ODOMETER_READING
NYVIP_NUMBER
INSPECTION_TYPE
OVERALL_RESULT
PCM_CODE_1
PCM_CODE_2
PID_CODE_1
PID_CODE_2
OBD_COMM_PROTOCOL
OVERALL_READINESS
COMPREHENSIVE_COMPS_READINESS
MISFIRE_READINESS
FUEL_CONTROL_READINESS
CATALYST_READINESS
O2_SENSOR_READINESS
EGR_READINESS
EVAP_EMISSIONS_READINESS
HeATED_CATALYST_READINESS
O2_SENSOR_HEATER_READINESS
SECONDARY_AIR_INJ_READINESS
AC_READINESS
Vehicle Query
Inputs
Start Date
End Date
Model Year
Vehicle Make
Model
Fuel Type: Choose From: Gas, Diesel, Either
Inspection Choose From: Type: Initial, Re-test, All
Test Type: Choose From: All, OBD, Heavy Duty, Pre 1996, Motorcycle, Trailer, Safety Only
Outputs
VEHICLE_MODEL_YEAR
VEHICLE_MAKE
PUBLIC_MODEL_NAME
FUEL_TYPE
TRANSMISSION_TYPE
INSPECTION_TYPE
TEST_TYPE
TOTAL
FAIL
OBD_TESTS
FAIL_OBD
FAIL_EMIS
FAIL_ECD
FAIL_SAFETY
FAIL_RATE
WAIVER
MIL_COMMANDED
MIL_KOEO_FAIL
MIL_KOER_FAIL
READINESS_FAIL
READINESS_FAIL_RATE
NO_COMM (<8v)
NO_COMM_RATE (<8v)
NO_COMM (>8v)
NO_COMM_RATE (>8v)
DLC_MISSING
DLC_MISSING_RATE
DLC_BROKEN
DLC_BROKEN_RATE
NYVIP_BROKEN
NYVIP_BROKEN_RATE
DLC_NOT_FOUND
DLC_NOT_FOUND_RATE
OVERALL_NO_COMM
OVERALL_NO_COMM_RATE
e_VIN_NO_MATCH
Inspection Records
Inputs
Facility Number
Start Date
End Date
Inspection Type: Choose From: Initial, Re-test, All
Test Type: Choose From: All, OBD, Heavy Duty, Pre 1996, Motorcycle, Trailer, Safety Only
Inspection Stopped Reason: Choose From: 1, 2, 3, 4, 5, Blank
OBD Check Result: Choose From: All, Pass, Fail, Blank
Fuel Type: Choose From: Gas, Diesel, Either
NYMA Code: Choose From: Upstate, Downstate, Both
Outputs
Full Inspection Records
Top 50 Stations Issuing Waivers
Inputs
Start Date
End Date
NYMA Code: Choose From: Upstate, Downstate, Both
Outputs
FACILITY_NUMBER
OBD_TESTS
INIT_OBD_TESTS
FAIL_OBD
INIT_FAIL_OBD
FAIL_RATE
WAIVER
WAIVER_RATE
WAIVER_RATE_RANK
Station Waiver Activity
Inputs
Station Number
Start Date
End Date
Outputs
FACILITY_NUMBER
OBD_TESTS
INIT_OBD_TESTS
FAIL_OBD
INIT_FAIL_OBD
FAIL_RATE
WAIVER
WAIVER_RATE
Inspector Query
Inputs
Start Date
End Date
Inspector Number
NYVIP Number
Inspection Type: Choose From: Initial, Re-test, All
Test Type: Choose From: All, OBD, Heavy Duty, Pre 1996, Motorcycle, Trailer, Safety Only
Outputs
INSPECTOR_CERTIFICATION_NUMBER
FACILITY_NUMBER
NYVIP_NUMBER
INSPECTION_TYPE
TEST_TYPE
TOTAL
FAIL
OBD_TESTS
FAIL_OBD
FAIL_EMIS
FAIL_ECD
FAIL_SAFETY
FAIL_RATE
WAIVER
MIL_COMMANDED
MIL_KOEO_FAIL
MIL_KOER_FAIL
READINESS_FAIL
READINESS_FAIL_RATE
NO_COMM (<8v)
NO_COMM_RATE (<8v)
NO_COMM (>8v)
NO_COMM_RATE (>8v)
DLC_MISSING
DLC_MISSING_RATE
DLC_BROKEN
DLC_BROKEN_RATE
NYVIP_BROKEN
NYVIP_BROKEN_RATE
DLC_NOT_FOUND
DLC_NOT_FOUND_RATE
OVERALL_NO_COMM
OVERALL_NO_COMM_RATE
e_VIN_NO_MATCH
Inspector Query Data Change
Inputs
Start Date
End Date
Inspector Number
NYVIP Number
Inspection Type: Choose From: Initial, Re-test, All
Test Type: Choose From: All, OBD, Heavy Duty, Pre 1996, Motorcycle, Trailer, Safety Only
Outputs
FUEL_TYPE_CHANGE
FUEL_TYPE
WEIGHT_CODE_CHANGE
DMV_VEHICLE_WT
VEHICLE_IDENTIFICATION_NUMBER
INSPECTION_DATE_TIME
INSPECTOR_CERTIFICATION_NUMBER
INSPECTION_EXPIRATION_DATE
INSPECTION_TYPE
TRANSACTION_METHOD
FACILITY_NUMBER
ODOMETER_READING
RECALL_SATISFIED
NYMA_CHANGE
RECORD_NUMBER
DATA_ENTRY_METHOD
GAS_CAP_CHECK
GAS_CAP_REPLACED
WAIVER_ISSUED
INSPECTION_CERTIFICATE_NUMBER
VEHICLE_MODEL_YEAR
VEHICLE_MAKE
VEHICLE_PLATE_NUMBER
NYMA
REG_CLASS_CODE
PUBLIC_MODEL_NAME
NON_REGISTERED_INDICATOR
NYVIP_NUMBER
TRANSMISSION_TYPE
HYBRID_VEHICLE
TEN_DAY_EXTENSION
DATE_TIME_END
DMV_RECORD_MATCH
INITIAL_EMISSIONS_RESULT
SOFTWARE_VERSION
STOPPED_TEST_REASON
TEST_TYPE
Inspector Query Multi PCM VIN
Inputs
Start Date
End Date
Inspector Number
NYVIP Number
Inspection Type: Choose From: Initial, Re-test, All
Test Type: Choose From: All, OBD, Heavy Duty, Pre 1996, Motorcycle, Trailer, Safety Only
Outputs
PCM_VIN
VEHICLE_IDENTIFICATION_NUMBER
VEHICLE_MODEL_YEAR
VEHICLE_MAKE
VEHICLE_PLATE_NUMBER
PUBLIC_MODEL_NAME
INSPECTION_DATE_TIME
INSPECTOR_CERTIFICATION_NUMBER
NYVIP_NUMBER
INSPECTION_TYPE
TEST_TYPE
OVERALL_RESULT
PCM_CODE_1
PCM_CODE_2
PID_CODE_1
PID_CODE_2
OBD_COMM_PROTOCOL
OVERALL_READINESS
COMPREHENSIVE_COMPS_READINESS
MISFIRE_READINESS
FUEL_CONTROL_READINESS
CATALYST_READINESS
O2_SENSOR_READINESS
EGR_READINESS
EVAP_EMISSIONS_READINESS
HEATED_CATALYST_READINESS
O2_SENSOR_HEATER_READINESS
SECONDARY_AIR_INJ_READINESS
AC_READINESS
Inspector Query NoComm
Inputs
Start Date
End Date
Inspector Number
NYVIP Number
Inspection Type: Choose From: Initial, Re-test, All
Test Type: Choose From: All, OBD, Heavy Duty, Pre 1996, Motorcycle, Trailer, Safety Only
Outputs
FACILITY_NUMBER
INSPECTOR_CERTIFICATION_NUMBER
INITIAL_EMISSIONS_RESULT
VEHICLE_IDENTIFICATION_NUMBER
VEHICLE_PLATE_NUMBER
PCM_VIN
INSPECTION_DATE_TIME
DATE_TIME_END
RECORD_NUMBER
TEST_TYPE
ODOMETER_READING
NYVIP_NUMBER I
NSPECTION_TYPE
STOPPED_TEST_REASON
Inspector Query Waiver
Inputs
Start Date
End Date
Inspector Number
NYVIP Number
Inspection Type: Choose From: Initial, Re-test, All
Test Type: Choose From: All, OBD, Heavy Duty, Pre 1996, Motorcycle, Trailer, Safety Only
Outputs
FACILITY_NUMBER
INSPECTOR_CERTIFICATION_NUMBER
INITIAL_EMISSIONS_RESULT
WAIVER_ISSUED
VEHICLE_IDENTIFICATION_NUMBER
VEHICLE_PLATE_NUMBER
PCM_VIN
INSPECTION_DATE_TIME
INSPECTION_DATE_TIME_END
RECORD_NUMBER
TEST_TYPE
ODOMETER_READING
NYVIP_NUMBER
INSPECTION_TYPE
