SOO_Attachment_E_Current_Database_Field_Descriptions-27Jul13-POSTED.docx
DOCX document 77 KB Posted
- Solicitation number
- AG-7604-S-13-0033
About this file
SOO Attachment E
View the file
Other files
Show all 29
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
Albuquerque Service Center-Human Capital Management
Solicitation: AG-7604-S-13-0033
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-employees in Incident reports will fall into several categories, including:
· Employee of another government agency
· Volunteer
· Job Corp worker
· Contractor
· Concessionaire
· Emergency worker
· Firefighter
· 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
Aircraft Mishap Screen
| Screen Header |
| Mishap Number |
Auto generated number which increments by one
SAFECOM Number
User is able to enter the SAFECOM number in the alphanumeric field and/or click on an icon next to the SAFECOM Number to be directed to the “Manage SAFECOM Login” page on the internet.
Date of Mishap - Date field
Time of Mishap – Time field
Agency Name
Drop down option based on data from Reference Screen with internal agency listed
Operational Control Facility
Drop down option based on the data entered within the Facility screen
Home Base Facility
Drop down option based on the data entered within the Facility screen
| Details Folder |
| Accident Location |
Free form entry field
Accident State
Drop down option based off the reference type of States from the Reference screen
Event Type
Radio button with the options of Accident or Incident with Potential
Event Name
Free form entry field
Procurement
Drop down option based on a new reference type of Procurement in the Reference screen
Type of Mission
Drop down option based on a new reference type of Type of Mission in the Reference screen
Type of Flight Profile/Phase of Flight
Drop down option based on a new reference Type of Flight in the Reference screen.
Brief Description
Free form memo field
Probably Cause as determined by NTSB
Free form memo field
Tail Number
Free form text field
Aircraft ID
Free form text field
Manufacturer
Drop down based off of manufactures listed within the new Manufacturer screen outlined below
Model
Sub-category drop down based off of the information selected for Manufacturer and information populated within the model section of the Manufacturer screen
Type
Sub-category drop down based off of the manufacturer and model information selected previously. This information is also captured within the Manufacturer screen
| Injury Incident Folder |
| Safety Incident Case Number |
A grid will be used in order to link to all the injury incidents related to a particular aviation mishap for both US Forest Service employees and contractors
Employee/ Contractor Name
Job Title at Time of Incident
Degree of Injury
Cause of Injury
| Flight Crew Information Folder Name |
| Vendor |
Drop down option based on vendors listed within the Vendor screen outlined below
Contractor Name
Drop down option based on contractors listed within the Contractor screen who are associated with the vendor selected in column 1
| Role |
| 1. Seat Occupied – Free form entry field. |
2. Seat Belt Used – Radio button with Yes/No options
3. Shoulder Harness used – Radio button with Yes/No options Drop down option based on a new Aviation Role reference type within Reference screen includes items such as pilot, co-pilot, and crew member
| Passenger Information |
| Passenger Name |
Free form entry field
Passenger Address
Free form entry field
Type of Passenger
Drop down option based on a new Passenger Role reference type within Reference screen to include items such as FAA, Crew, Non-Revenue, etc.
Injury Type
Free form entry field.
Total Number of Passengers
This field auto-populates based on the number of passengers entered within the passenger information grid. If the user would like to modify the number, he/she can do so manually
Total Number of Crew Members
This field auto-populates based on the number of crew members entered within the contractor information grid. If the user would like to modify the number, he/she do so manually
Total Number of Souls on Board
This is a calculated field summing the total number of passengers and the total number of crew members
| Additional Information Folder |
| General Latent Condition |
Drop down option based on latent conditions listed within the new Latent Condition screen outlined below
Specific Latent Condition
Drop down option based on sub-latent conditions listed within the Latent Condition screen
Comments
Free form entry field
General Programmatic Weakness
Drop down option based on programmatic weakness listed within the Programmatic Weakness screen
Specific Programmatic Weakness
Drop down option based on sub-programmatic weakness from main Programmatic Weakness screen
Comments
Free form entry field
Supervisor Name
Drop down based on employee and/or contractor/vendor databases
Role
Drop down option based on new reference type of Supervisory Role from the Reference screen
| Weather Information Folder Name |
| Source of weather information |
9 options
Method of briefing
6 options
Restriction to visibility
12 options
Type of turbulence
4 options
Severity of turbulence
5 options
Type of precipitation
14 options
Briefing type/completeness
6 options
Light condition
7 options
Sky/lowest cloud condition
7 options
Ceiling
6 options
Icing forecast
8 options
Icing actual
8 options
Wind direction
2 options with one free form entry field
Wind speed
2 options with one free form entry field
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 |
Drop down option based on human factors entered within the Human Factors screen
Sub-Human Factor
Drop down option based on sub-factors from main Human Factors screen
Comments
Free form entry field
| Corrective Actions Folder |
| Corrective Action Number |
Add/Delete buttons above the grid allow users to add or delete a corrective action association with the aviation mishap. Clicking on the Add button opens a new window with a standard Corrective Action screen. Users populate the data within this screen and upon closing/saving the record the following information appears within a read only grid
Facility Name
Responsible Party
Short Description
Images Folder
The Images folder allows the user to import images that apply to the mishap
Documents Folder
The Documents folder allows the user to link any documents/files that apply to the mishap
Notes Folder
The Notes folder is a free-form memo that allows for any notes to be recorded
Vendor Screen
| Vendor Screen |
| Header |
Free form entry; the add window and the screen header hold the Vendor Name field
| Details Folder: Contact Information |
| Address |
Free form entry
City
Free form entry
State
Drop down option; Based off of state reference type from Reference screen
Zip
Free form entry
Phone Number
Free form entry; Standard phone number formatting
Fax Number
Free form entry; Standard phone number formatting
Free form entry
| Details Folder: Staff/ Contacts Grid (Administrative Personnel) |
| Name |
Free form entry
Type
Drop down option; Based on Contact Type reference type from Reference screen
Phone
Free form entry
Free form entry
| History Folder |
| Aviation Mishap Number |
A grid is used to display aviation mishap associated with a particular vendor. Users are not able to modify any of the information located within this grid
Date
Event Name
Description
Images Folder
The Images folder allows the user to import images that apply to the vendor
Documents Folder
The Documents folder will allow the user to link any documents/files that apply to the vendor
Notes Folder
The Documents folder will allow the user to link any documents/files that apply to the vendor
Contractor Screen
| Header |
| First Name |
Free form entry
Last Name
Free form entry
| Details Folder |
| Social Security Number |
Free form entry; Standard SSN formatting
| Details Folder: Contact Information |
| Address |
Free form entry
City
Free form entry
State
Drop down option; Based off of state reference type from Reference screen
Zip
Free form entry
Phone Number
Free form entry
Fax Number
Free form entry
Free form entry
| Details Folder: Certificate Frame |
| Certificate Number |
Free form entry
Pilot Certificate(s)
Check boxes consisting of 11 options
Medical Certificate
Free form entry
Medical Certificate Limitations
Free form memo
Medical Certificate Waivers
Free form memo
| History Folder |
| Aviation Mishap Number |
A grid is used to capture aviation mishap associated with a particular contractor. Users are not able to modify any of the information located within this grid
Date
Event Name
Description
Vendor
Images Folder
The Images folder allows the user to import images that apply to the vendor
Documents Folder
The Documents folder allows the user to link any documents/files that apply to the vendor
Notes Folder
The Notes folder is a free-form memo that allows notes to be recorded
Manufacturer Screen
| Header |
| Manufacturer Name |
Free form entry
| Details Folder |
| Model |
Free form entry; A grid will be used to capture the multiple planes associated with a particular manufacturer
Type
| History Folder |
| Aviation Mishap Number |
A grid is used to capture aviation mishap history associated with a particular manufacturer. Users are not able to modify any of the information located within this grid
Date
Event Name
Description
Vendor
Images Folder
The Images folder allows the user to import images that apply to the vendor
Documents Folder
The Documents folder will allow the user to link any documents/files that apply to the vendor
Notes Folder
The Notes folder will be a free-form memo that will allow for any notes to be recorded.
Human Factors Screen
| Header |
| General Human Factor |
Free form entry
| Details Folder |
| Specific Human Factor |
Free form entry
Additional Information
Free form entry; This field will be directly related to the Sub-Factor above
| History Folder |
| Aviation Mishap Number |
A grid is used to display aviation mishaps associated with a particular human factor. Users are not able to modify any of the information located within this grid
Date
Event Name
Description
Images Folder
The Images folder allows the user to import any images that apply
Documents Folder
The Documents folder allows the user to link any documents/files that apply
Notes Folder
The Notes folder is a free-form memo that allows for any notes to be recorded
Latent Conditions Screen
| Header |
| Latent Condition |
| Details Folder |
| Specific latent condition |
Free form entry; a grid is used to capture the sub-categories associated with latent conditions with a free form entry for the specific latent condition
| History Folder |
| Aviation Mishap Number |
A grid is used to display aviation mishap associated with a particular latent conditions. Users are not able to modify any of the information located within this grid
Date
Event Name
Description
Images Folder
The Images folder allows the user to import any images that apply
Documents Folder
The Documents folder allows the user to link any documents/files that apply
Notes Folder
The Notes folder is be a free-form memo that allows for any notes to be recorded
Programmatic Weakness Screen
| Header |
| Programmatic Weakness |
Free form entry
| Details Folder |
| Specific Programmatic Weakness |
Free form entry; a grid will be used to capture the sub-categories associated with programmatic weakness with a free form entry for each Specific Weakness
| History Folder |
| Aviation Mishap Number |
A grid is used to display aviation mishaps associated with a particular programmatic weakness. Users are not able to modify any of the information located within this grid.
Date
Event Name
Description
| Images Folder |
| The Images folder will allow the user to import in any images that apply. |
The Images folder will allow the user to import in any images that apply.
| Documents Folder |
| The Documents folder allows the user to link any documents/files that apply. |
The Documents folder allows the user to link any documents/files that apply.
| Notes Folder |
| The Notes folder is a free-form memo that allows notes to be recorded. |
The Notes folder is a free-form memo that allows notes to be recorded.
| Aviation Flight Hours |
| Year |
Free form entry
Months (Jan – Dec)
Free form entry
| WC_SH_Draft_Business_Process_Standardization_v0 93_20121128 | Page 2 of 1 |
| Created on [Insert Creation Date] | Last Updated on [Insert Date] |
| Attachment I: Field Specifications | Page 13 of 13 |
| Created on: January 31, 2013 | Last Updated on: February 4, 2013 |
image2.jpeg image1.png
File details come from the government source that posted it. Updated .