Layer: Post_Accident_Drug_and_Alcohol_Testing

View In: Map Viewer

Name: Post_Accident_Drug_and_Alcohol_Testing_Form

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Post Accident Drug and Alcohol Testing Form","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Global ID Field: globalid

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
BSD (type: esriFieldTypeString, alias: Bi-State Development, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
RSP (type: esriFieldTypeString, alias: Drug and Alcohol Testing Form, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
name (type: esriFieldTypeString, alias: Employee Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
job_title (type: esriFieldTypeString, alias: Job Title:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
badge_no (type: esriFieldTypeInteger, alias: Badge #:, SQL Type: sqlTypeOther, nullable: true, editable: true)
event_date (type: esriFieldTypeDate, alias: Event Date:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
event_time (type: esriFieldTypeString, alias: Event Time:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
facility (type: esriFieldTypeString, alias: Facility:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [29th Street Yard: 29th Street Yard], [Bi-State HQ: Bi-State HQ], [Brentwood Garage: Brentwood Garage], ... 12 more ...)
safety_sen (type: esriFieldTypeString, alias: Step 1. Is this employee safety sensitive? (Safety Sensitive Functions - select all that apply for employees who perform or will perform one of these functions.), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
acc_incident (type: esriFieldTypeString, alias: Step 2. Was the employee involved in an accident or incident? (complete A, B, & C), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes - proceed below], [No: No - proceed to Step 3])
incident_type (type: esriFieldTypeString, alias: A. Check all that apply:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
acc_def (type: esriFieldTypeString, alias: D. Does the event meet FTA/DOT Post-Accident Definitions? (mark all applicable), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
post_acc_type (type: esriFieldTypeString, alias: Question 1 - Do any of the FTA/DOT Post-Accident Types noted above apply?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
safety_sensitive (type: esriFieldTypeString, alias: Question 2 - Is the employee Safety Sensitive?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
test_req (type: esriFieldTypeString, alias: Please authorize this type of Drug and Alcohol test., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [DOT: DOT Post-Accident Drug & Alcohol Screen - Urine Drug Screen], [NonDOT: Non-DOT Post Accident and/or Rule Violation Drug & Alcohol Screen - Oral Fluid])
tsm_review (type: esriFieldTypeString, alias: Step 3. Manager/TSM completes the section below., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
two_hours (type: esriFieldTypeString, alias: Was the Drug and Alcohol Testing completed within two (2) hours of event?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
test_time1 (type: esriFieldTypeString, alias: Time of Drug Test:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
time_window (type: esriFieldTypeString, alias: Time Window:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
test_explanation (type: esriFieldTypeString, alias: If no, provide a detailed explanation., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
der_dapm (type: esriFieldTypeString, alias: DER/DAPM: Gerald Abernathy, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
der_phone (type: esriFieldTypeString, alias: Phone: 314-458-6537, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
mail_stop (type: esriFieldTypeString, alias: Mail Stop: 128, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
email (type: esriFieldTypeString, alias: Email: geabernathy@metrostlouis.org, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
suspension (type: esriFieldTypeString, alias: Employee Notification of Suspension from Duty, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
susp_text (type: esriFieldTypeString, alias: You were recently tested for drugs and/or alcohol under the Bi-State Development's Drug and Alcohol Policy. The DAPM and the DER have been notified that, as a result of this testing, you are suspended from duty without pay immediately and directed to contact the DAPM and the DER for the Metro's Drug and Alcohol Program as soon as possible. Your failure to contact the DAPM or the DER within two business days of this notification could result in discipline up to and including employment termination. You should not enter any Bi State Development building, unless you have notified your Supervisor in advance., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
emp_name2 (type: esriFieldTypeString, alias: Employee Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
badge (type: esriFieldTypeString, alias: Badge #:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
test_date (type: esriFieldTypeDate, alias: Date of Test:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
test_time2 (type: esriFieldTypeString, alias: Time of Test:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
not_date (type: esriFieldTypeDate, alias: Date of Notification:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
not_time (type: esriFieldTypeString, alias: Time of Notification:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
emp_sig_date (type: esriFieldTypeDate, alias: Date:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sup_sig_date (type: esriFieldTypeDate, alias: Date:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
completed_by (type: esriFieldTypeString, alias: Form Completed By:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
comp_date (type: esriFieldTypeDate, alias: Date:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
comp_title (type: esriFieldTypeString, alias: Tile:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
comp_phone (type: esriFieldTypeString, alias: Phone Number:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
test_note (type: esriFieldTypeString, alias: Note to Manager/TSM: BJC will require this form be completed entirely before authorizing Drug and Alcohol Services. A copy of this form shall also be e-mailed to Gerald Abernathy., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
contacts (type: esriFieldTypeString, alias: Gerald Abernathy (DER/DAPM): 314-458-6537 | Email: GEAbernathy@metrostlouis.org | D & A Mail Stop: 128, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
collectors (type: esriFieldTypeString, alias: T-Force Collectors (Includes After Hours): 888-576-7171 or 314-576-7766, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
collectors2 (type: esriFieldTypeString, alias: NEW TOX EMAILS | Maxwell Walton: maxwell.walton@tforce.com | Andrea Duncan: andrea.duncan@tforce.com, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ph_numbers (type: esriFieldTypeString, alias: BarnesCare: 314-747-5800 | Docs-on-Call: 866-303-7762, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
dapm (type: esriFieldTypeString, alias: 1. Drug and Alcohol Program Manager (DAPM) - An employee authorized by the employer to manage and monitor the drug and alcohol testing program. This person may make required decisions in the testing and evaluation process, maintain required records, update policy and procedures, and monitor contractors and vendors. The DAPM may also receive test results and other communications for the employer, consistent with the requirements of 49 CFR Part 655. The DAPM may act as the DER., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
der (type: esriFieldTypeString, alias: 2. Designated Employer Representative (DER) - An employee authorized by the employer to take immediate action(s) to remove employees from safety-sensitive duties, or cause employees to be removed from these covered duties, and to make required decisions in the testing and evaluation processes. The DER also receives the test results and other communications for the employer, consistent with the requirement of this part. Service agents cannot act as DERs., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
dot (type: esriFieldTypeString, alias: 3. DOT, The Department DOT - These terms encompass all DOT agencies, including, but not limited to the United States Coast Guard (USCG) the Federal Administration (FAA), the Federal Railroad Administration (FRA), the Federal Motor Carrier Safety Administration (FMCA), the Federal Transit Administration (FTA), the National Highway Traffic Safety Administration (NHTSA), the Research and Special Programs Administration (RSPA), and the Office of the Secretary (OST). These terms include any designee of the DOT., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
fta (type: esriFieldTypeString, alias: 4. Federal Transit Administration (FTA) - an agency within the United States Department of Transportation (DOT) that provides financial and technical assistance to local public transportation systems., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
emp_auth (type: esriFieldTypeString, alias: Employee Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
badge_auth (type: esriFieldTypeString, alias: Badge Number:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
loc_auth (type: esriFieldTypeString, alias: Location:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sup_auth (type: esriFieldTypeString, alias: Supervisor:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sup_ph_auth (type: esriFieldTypeString, alias: Supervisor Phone Number:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sup_title (type: esriFieldTypeString, alias: Title:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sup_date (type: esriFieldTypeDate, alias: Date:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
auth_by (type: esriFieldTypeString, alias: Authorized By:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
auth_title (type: esriFieldTypeString, alias: Title:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
auth_date (type: esriFieldTypeDate, alias: Date:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
auth_test (type: esriFieldTypeString, alias: Step 1., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [DOT: DOT], [NonDOT: Non-DOT])
d_a (type: esriFieldTypeString, alias: Step 2., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
calc1 (type: esriFieldTypeString, alias: calc1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
calc2 (type: esriFieldTypeString, alias: calc2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
type_test (type: esriFieldTypeString, alias: Step 3., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
screen_type (type: esriFieldTypeString, alias: Step 4., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Post Accident/Injury: Post Accident/Injury])
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
emp_injury (type: esriFieldTypeString, alias: B. Was the employee injured?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
injury_care (type: esriFieldTypeString, alias: C. Does the employee request medical care?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: Employee declines medical care], [Yes: Employee requests medical care], [Declines medical care: Employee declines medical care], ... 1 more ...)
physical_exam (type: esriFieldTypeString, alias: Physical Examination, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
exam (type: esriFieldTypeString, alias: Exam Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Workers Comp Initial Evaluation: Workers Comp Initial Evaluation], [None: N/A])
other_facility (type: esriFieldTypeString, alias: Other Facility:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
test_facility (type: esriFieldTypeString, alias: Testing Location:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [29th Street Yard: 29th Street Yard], [BarnesCare Manchester: BarnesCare Manchester], [BarnesCare St. Peters: BarnesCare St. Peters], ... 15 more ...)
other_test_facility (type: esriFieldTypeString, alias: Other Testing Facility:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
test_agency (type: esriFieldTypeString, alias: Testing Agency:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [T-Force: T-Force], [BarnesCare Midtown: BarnesCare Midtown], [BarnesCare St. Peters: BarnesCare St. Peters], ... 2 more ...)
auth_email (type: esriFieldTypeString, alias: Email Address:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
no_incident (type: esriFieldTypeString, alias: Please contact the Drug and Alcohol Dept. at 314-982-1400 ext 1576 or ext 1342. DO NOT submit this form., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
acc_def2 (type: esriFieldTypeString, alias: D. Does the event meet FTA/DOT Post-Accident Definitions? (mark all applicable), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
calc3 (type: esriFieldTypeString, alias: calc3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
hr_over (type: esriFieldTypeString, alias: Over 8 Hrs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
calc4 (type: esriFieldTypeString, alias: calc4, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
special_circumstances (type: esriFieldTypeString, alias: Special Circumstances:, SQL Type: sqlTypeOther, length: 1200, nullable: true, editable: true)
calc5 (type: esriFieldTypeString, alias: calc5, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sen_score (type: esriFieldTypeString, alias: Safety Sensitive Score, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
fta_def_score (type: esriFieldTypeString, alias: FTA Definition Score, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
total_score (type: esriFieldTypeString, alias: Total Score, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/3/2025 3:01:23 PM

Schema Last Edit Date: 9/3/2025 3:01:23 PM

Data Last Edit Date: 9/3/2025 3:01:23 PM

Supported Operations: Add Features Apply Edits Generate Renderer Validate SQL Get Estimates ConvertFormat

Layer: Post_Accident_Drug_and_Alcohol_Testing_Form (ID:0)