SOO Appendix E_Current Database Field Descriptions_2182021v1.docx

DOCX document 75 KB Posted

Attached to
2021 eSafety Recompete Federal contract opportunity
Solicitation number
12760421Q0122
Issued by
Department of Agriculture Forest Service

About this file

This document contains field specifications for an integrated Workers' Compensation and Safety and Occupational Health case management, recording and reporting software as a service solution. Key details include that the solicitation is for a software as a service licensing solution that will be all-inclusive and include regular maintenance and training. The solution will support incident and employee records, motor vehicle accidents, human factors, corrective actions, aviation mishaps, and other related modules. The federal agency involved is the Department of Agriculture Forest Service.

View the file

Other files for this federal contract opportunity

Show all 17

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Albuquerque Service Center-Human Capital Management

Solicitation: AG-XXXX

ATTACHMENT E: FIELD SPECIFICATIONS

Data Library
Field
Options
Additional Information
Incident Folder
Incident Type
1. Injury

1. Illness

1. Fatalities

1. Safety Story

· Incident records are indexed by:

· The user’s name

· Social Security Number

· Date of accident

· Organization Code

· Zip code of the accident location

· Non-traditional employees in Incident reports will fall into several categories, including:

· Employee of another government agency

· Volunteer

· Job Corp worker

· Contractor

· Administratively Determined employee

· Concessionaire

· Cooperator

· Emergency worker

· General public

Employee Folder
Type of Employee
1. Permanent Full-Time Employees

2. Part-Time Employees

3. Seasonal Employees

4. Call When Needed

5. Volunteers

6. Records for employees who are no longer with the agency

Motor Vehicle Accident (MVA) Module

Date of Incident

= Accident Date

Incident Time

= Accident Time

Road Type
1. FS Paved

2. FS High Clearance

3. FS Gravel or Dirt

4. FS Parking Lot

5. FS Motorized Trail

6. Non-FS

Motor Vehicle Accident (MVA) Module
Number of Vehicles Involved

Non-motorized vehicle persons involved (if any)

Incident formally investigated
1. None

2. FS

3. State Patrol

4. Other Law Enforcement

Vehicle Type
1. Sedan/Station Wagon

2. SUV

3. ½ to 1-ton truck

4. >1 ton truck

5. Motorcycle

6. Van

7. Boat

8. Snowmobile

9. Forklift

Estimated and Actual Costs for Damaged Vehicle

= Repair Costs

Citation Issued, Citation Type
1. None

2. Seat Belt

3. Alcohol or Drug

4. Speeding

5. Distraction

6. Fail to Yield

7. Other = Was there a citation?

Driver’s Age

From employee record

Driver’s Sex

From employee record

Ownership
1. FS

2. Cooperator

3. Contractor

4. Private

5. Visitor

Motor Vehicle Accident (MVA) Module
Indication of driver’s Optional Form 346

Was the driver trained in Defensive Driving record

Seat belt use

Driver duty status

Start Time, End Time

FS Driver Status
1. Permanent

2. Term

3. Seasonal

4. Volunteer

Number of non-driving occupants

Driver outcome?
1. Injury

2. No Injury

3. Fatal

Causal Factors
1. Alcohol

2. Drugs

3. Weather

4. Road/Trail Surface

5. Backing this vehicle

6. Distraction

7. Cell Phone

8. FS Radio

9. Other Passengers

10. Wildlife

11. Excess Speed

12. Fatigue

13. Driving After 12 hour shift

Screen Header

1.

Passenger Information
Passenger Name

Passenger Address

Type of Passenger

Injury Type

Total Number of Passengers

Total Number of Crew Members

Total Number of Souls on Board

Additional Information Folder
General Latent Condition

Specific Latent Condition

Comments

General Programmatic Weakness

Specific Programmatic Weakness

Comments

Supervisor Name

Role

Weather Information Folder Name
Source of weather information

Method of briefing

Restriction to visibility

Type of turbulence

Severity of turbulence

Type of precipitation

Briefing type/completeness

Light condition

Sky/lowest cloud condition

Ceiling

Icing forecast

Icing actual

Wind direction

Wind speed

Weather observation facility name

Observation time

Observation time zone

Distance from accident site

Direction from accident site

Weather Information Folder Name
Visibility in miles

Lowest cloud condition height

Ceiling height

Temperature

Altimeter setting

Density altitude

Dew point

Human Factors Folder Name
General Human Factor

Sub-Human Factor

Comments

Corrective Actions Folder
Corrective Action Number

Facility Name

Responsible Party

Short Description

Images Folder

Documents Folder

Notes Folder

Vendor Screen
Header
Details Folder: Contact Information
Address

City

State

Zip

Phone Number

Fax Number

Email

Details Folder: Staff/ Contacts Grid (Administrative Personnel)
Name

Type

Phone

Email

History Folder
Aviation Mishap Number

Date

Event Name

Description

Images Folder

Documents Folder

Notes Folder

Header
First Name

Last Name

Details Folder
Social Security Number
Details Folder: Contact Information
Address

City

State

Zip

Phone Number

Fax Number

Email

Details Folder: Certificate Frame
Certificate Number

Pilot Certificate(s)

Medical Certificate

Medical Certificate Limitations

Medical Certificate Waivers

History Folder
Aviation Mishap Number

Date

Event Name

Description

Vendor

Images Folder

Documents Folder

Notes Folder

Header
Manufacturer Name
Details Folder
Model

Type

History Folder
Aviation Mishap Number

Date

Event Name

Description

Vendor

Images Folder

Documents Folder

Notes Folder

Header
General Human Factor
Details Folder
Specific Human Factor

Additional Information

History Folder
Aviation Mishap Number

Date

Event Name

Description

Images Folder

Documents Folder

Notes Folder

Header
Latent Condition
Details Folder
Specific latent condition
History Folder
Aviation Mishap Number

Date

Event Name

Description

Images Folder

Documents Folder

Notes Folder

WC_SH_Draft_Business_Process_Standardization_v0 93_20121128Page 2 of 1
Created on [Insert Creation Date]Last Updated on [Insert Date]

Attachment I: Field Specifications Page 13 of 13 image2.jpeg image1.png

File details come from the government source that posted it. Updated .