License Event Notification Service (LENS) Customers
State of New York
@usgov.state_of_new_york_license_event_notification_service_l_45e3255e
State of New York
@usgov.state_of_new_york_license_event_notification_service_l_45e3255e
The License Event Notification Service (LENS) is a tool that enables LENS customers to monitor a set of drivers’ qualifications, and to receive notifications of changes to drivers’ qualifications. The source for LENS drivers’ information is the New York State Department of Motor Vehicles Driving Record. LENS customers include employers of drivers, insurers of drivers and entities that regulate drivers or their employers.
Organization: State of New York
Last updated: 2020-11-12T04:00:28.641701
Tags: driver, employer, license, qualification
CREATE TABLE table_1 (
"customer" VARCHAR,
"address_line_1" VARCHAR,
"address_line_2" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip" VARCHAR,
"date_enrolled" TIMESTAMP,
"vat202_category" VARCHAR,
"status" VARCHAR,
"observation_date" TIMESTAMP,
"crash_notification" VARCHAR,
"conviction_notification" VARCHAR,
"suspension_notification" VARCHAR,
"point_insurance_reduction_course_completion_notification" VARCHAR,
"driver_status_change_notification" VARCHAR,
"license_expiration_notification" VARCHAR,
"hazardous_material_endorsement_notification" VARCHAR,
"cdl_medical_certification_status_change_notification" VARCHAR,
"ticket_notification" VARCHAR,
"drivers_monitored" BIGINT,
"latest_driver_add_date" TIMESTAMP,
"latest_driver_drop_date" TIMESTAMP,
"lens_internet_interface_users" BIGINT
);Anyone who has the link will be able to view this.