,l BTS | Marine Safety Management System - Attribute Definition View
Bureau of Transportation Statistics (BTS)
BTS Home > Programs > Maritime Data Working Group > Marine Safety Management System
Printable Version

Marine Safety Management System
Attribute Definition View

December 13, 2001

Developed by Harold Krevait
(202)267-6833

Excel | CSV

Table Header Column Name Attribute Name Attribute Definition Column
Datatype
ccft Mccase MCCase Marine Casualty case number. char(10)
Event Event Event chain. char(2)
Category Category Cause of the event. char(2)
Subject Subject Vessel/facility identification number. char(3)
Class Type Details of the category. char(15)
Subclass Modifier 1 Details of the class. char(29)
state Modifier 2 Circumstances of the class. char(16)
party Party Causal party. char(5)
causal_event1 Prec Event 1 First causal event. char(2)
causal_event2 Prec Event 2 Second causal event. char(2)
supp_ind Supplement Indicator Supplement indicator. char(1)
supp_id Supplement Identifier Identifies the supplement. char(4)
hfnum Human Factor No Human factor number. char(2)
sp FILLER FILLER char(1)
ccgt Mccase Marine Casualty Case Marine Casualty case number. char(10)
Subject Subject Vessel/facility identification number. char(10)
Speed Speed Speed at time of casualty. char(3)
impact_location Impact Location Location where impact was incurred. char(30)
dbl_bott Double Bottomed Vessel 'Y/N' if doubled bottom. char(1)
dbl_hull Double Hulled Vessel 'Y/N' if doubled hull. char(1)
Sp Filler Filler char(1)
cevt Mccase Marine Casualty Case Marine Casualty Case Number. char(10)
Event Event Sequence of events of occurrence. Char(2)
subject1 First Subject Num Vessel/Facility identification number. char(3)
subject2 Second Subject Num Vessel/Facility identification number. char(3)
Type Type Nature of incident. FIRE SINK CAPSIZE REMOVED ALLISION FLOODING POLLUTION LEFT BLANK ABANDONMENT EXPLOSION-INC GROUNDING ACC GROUNDING INT PERSONNEL CAS LOSS VES CNTRL LOSS ELEC POWER STRUCTURAL FAIL char(15)
Class Class Further modifies nature of incident. Char(20)
State State Modifies class. Char(22)
causal_event1 First Prec Event The previous event of the casualty. char(2)
causal_event2 Second Prec Event The second previous event of the casualty. char(2)
subj1_sig_ind First Subject Sign First significant subject. Char(1)
subj2_sig_ind Second Subject Sign Second significant subject. Char(1)
Sp Filler Filler char(1)
cfct Mccase Marine Casualty Case Marine Casualty case number char(10)
Subject Subject Subject number char(10)
intact_dam_cond Intact Or Damage Condition Intact or damaged condition char(7)
Cause Cause of Flooding Cause of flooding char(10)
special_cir_1 Special Circumstances 1 Special circumstances 1 char(10)
special_cir_2 Special Circumstances 2 Special circumstances 2 char(10)
special_cir_3 Special Circumstances 3 Special circumstances 3 char(10)
special_cir_4 Special Circumstances 4 Special circumstances 4 char(10)
special_cir_5 Special Circumstances 5 Special circumstances 5 char(10)
req_intact_stab Required to Meet Intact Stability Required to meet intact stability char(1)
meet_intact_stab Meet Intact Stability Meet intact stability char(1)
req_dam_stab Required To Meet Damaged Stability Required to meet damaged stability char(1)
meet_dam_stab Meet Damaged Stability Meet damaged stability char(1)
special_stab_info_avail Special Stability Info Available Special stability information available char(1)
special_stab_info_fol Special Stability Info Followed Special stability information followed char(1)
per_know_how_to_use Personnel Know how to Use Info Personnel know how to use information char(1)
no_compart_flooded No of Compartments Flooded Number of compartments flooded char(3)
use_flooded_comp1 Use of Flooded Compartment 1 Use of flooded compartment 1 char(10)
use_flooded_comp2 Use of Flooded Compartment 2 Use of flooded compartment 2 char(10)
use_flooded_comp3 Use of Flooded Compartment 3 Use of flooded compartment 3 char(10)
use_flooded_comp4 Use of Flooded Compartment 4 Use of flooded compartment 4 char(10)
use_flooded_comp5 Use of Flooded Compartment 5 Use of flooded compartment 5 char(10)
use_flooded_comp6 Use of Flooded Compartment 6 Use of flooded compartment 6 char(10)
use_flooded_comp7 Use of Flooded Compartment 7 Use of flooded compartment 7 char(10)
Hours Time to Sink Hours Time to sink hours char(4)
Minutes Time to Sink Minutes Time to sink minutes char(2)
man_of_sinking Manner of Sinking Manner of sinking char(79)
pre_cas_drafts_fwd1 Pre-Casualty Drafts FWD 1 Pre-Casualty drafts FWD 1 char(3)
pre_cas_drafts_fwd2 Pre-Casualty Drafts FWD2 Pre-Casualty Drafts FWD 2 char(3)
pre_cas_fwd_units Pre-Casualty FWD Units Pre-Casualty FWD units char(1)
pre_cas_drafts_aft1 Pre-Casualty Drafts AFT 1 Pre-Casualty Drafts AFT 1 char(3)
pre_cas_drafts_aft2 Pre-Casualty Drafts AFT 2 Pre-Casualty Drafts AFT 2 char(3)
pre_cas_aft_units Pre-Casualty AFT Units Pre-Casualty AFT units char(1)
post_cas_drafts_fwd1 Post-Casualty Drafts FWD 1 Post-Casualty Drafts FWD 1 char(3)
post_cas_drafts_fwd2 Post-Casualty Drafts FWD 2 Post-Casualty Drafts FWD 2 char(3)
post_cas_fwd_units Post-Casualty FWD Units Post-Casualty FWD Units char(1)
post_cas_drafts_aft1 Post-Casualty Drafts AFT 1 Post-Casualty drafts AFT 1 char(3)
post_cas_drafts_aft2 Post-Casualty Drafts AFT 2 Post-Casualty drafts AFT 2 char(3)
post_cas_aft_units Post-Casualty AFT Units Post-Casualty AFT units char(1)
page_key Page Key Page key char(3)
sup_for_fac Supplement N/A for Facility Supplement N/A for Facility char(1)
Sp Filler Filler char(1)
cfet Mccase Marine Casualty Case Marine Casualty case number. char(10)
Subject Subject Vessel identification number. char(10)
Location Location Location of the fire. char(25)
ignition_source Source - Ignition Source of ignition. char(65)
fuel_source Source - Fuel Source of fuel. char(65)
Detection Initially Detected By Who fire was detected by. char(10)
immediate_area Fixed Fire Equip Immediate Area Fixed fire equipment immediate area char(50)
adjacent_areas Fixed Fire Adjacent Areas Fixed fire adjacent areas char(50)
Fixed Equipment Used Fixed Equipment used fixed char(50)
Portable Equipment Used Portable Equipment used portable char(50)
smoke_fact Was Smoke a Factor Was smoke a factor. Char(1)
page_key Page Key Page key char(3)
sup_ind Supplement N/A Indicator Supplement N/A indicator char(1)
sp Filler Filler char(1)
cift mccase Marine Casualty Case Marine Casualty Case number. char(10)
fin FIN Facility Identification Number. char(8)
fname Involved Name Facility name. Char(33)
category Involved Category Type of facility. Char(20)
mcpd_ind MCPD File Ind 'X' = Pollution details filed. Char(1)
mcpd_clsd MCPD Closed Ind 'X' = Pollution detail closed. Char(1)
pers_action Personnel Action Personnel Action Taken char(1)
mcpa_ind MCPA Filed Ind 'X' = Civil penalty action. Char(1)
mcpi_ind MCPI Filed Ind 'X' = Personnel involvement. Char(1)
mcsi_ind MCSI Filed Ind 'X' = SMI supplements filed. Char(1)
operation Operation FF Operation at time of casualty. char(9)
cont_stat Cont Stat Status of facility: TOWED MOORED ANCHORED UNDERWAY char(8)
verified Verified Ind Case verified. char(1)
fkey Fkey Facility key. Primary join to other facility tables. char(10)
subject Subject Subject case number. char(10)
subj_ref_num Subject Ref Number Identify the vessel involved. char(3)
sp Filler Filler char(1)
cirt mccase Marine Casualty Case MSIS MC Case. char(10)
unit Port MSIS Port code for unit. char(5)
last_updt Last Update Date record last updated. Char(10)
vsl_ind Vessel Indicator 'X' = vessel involved. char(1)
pers_ind Personnel Indicator 'X' = personnel involved. char(1)
fac_ind Facility Indicator 'X' = facility involved. char(1)
pol_ind Pollution Indicator 'X' = pollution involved. char(1)
incident_dt Incident Date Incident date. Char(10)
incident_time Incident Time Incident time. char(4)
inc_dt_known Date/Time Known 'X' = Incident Date known. char(1)
ref_case Reference Case MSIS reference case. char(10)
notify_dt Notify Date Date unit notified. Char(10)
notify_time Notify Time Time unit notified. Char(4)
reporter_typ Reporter Type Reporting Source Category Type. char(15)
subject Subject Incident Name as input by reporting unit. char(30)
location Location Incident Location. char(30)
stat_verify Status Verified 'X' = Incident Verified. char(1)
stat_not_verify Status Not Verified 'X' = Incident NOT Verified. char(1)
verify_not_rpt Verified Not Reportable 'X' = Verified, NOT reportable. char(1)
ctf_ind CTF 'X' = Incident Closed to File. char(1)
invest_dt Investigator Date Date Investigator Endorsed. Char(10)
command_endorse Unit Command End/Fwd 'X' = Command Endorsed. char(1)
command_cls Unit Command End/Cls 'X' = Command Closed Case. char(1)
command_dt Unit Command Date Date Command Endorsed/Clsd. Char(10)
dist_req Dist Required 'X' = District Action Req'd. char(1)
dist_endorse District End/Fwd 'X' = District Endorsed. char(1)
dist_cls District End/Cls 'X' = District Closed. char(1)
dist_dt District Date Date Dist Endorsed/Clsd. Char(10)
hq_req HQ Required 'X' = HQ Endorse Req'd. char(1)
hq_endorse HQ End/Cls 'X' = HQ Endorsed. char(1)
hq_dt HQ Date Date HQ Endorsed. Char(10)
city City City of Incident. char(25)
state State State (code) of Incident. char(2)
waterbody Waterbody Name of Waterbody. char(29)
river_mile River Mile River Mile and tenths. Char(4)
river_tenths River Tenth-Miles River mile and tenths. char(1)
latitude Latitude Latitude of Incident. char(6)
longitude Longitude Longitude of Incident. char(7)
pri_nature Type Primary Nature: FIRE CAPSIZE MISSING SINKING ALLISION FLOODING BREAKAWAY COLLISION EXPLOSION GROUNDING POLLUTION EQUIP FAIL PERSON CAS STRUCT FAIL char(11)
cas_class Class Casualty Class: NONE MAJOR SERIOUS SIGNIFICANT PUBLIC/NONPUBLIC char(16)
smi SMI 'X' - Significant Marine Incident Indicator. Char(1)
deaths Deaths Number of Deaths. Char(4)
missing Missing Number Persons Missing. Char(4)
injured Injured Number Persons Injured. Char(4)
total_damage Total Damage Total Damage. Char(12)
mode Mode Environmental Impact Mode: (WATER, AIR, LAND, THREAT) char(6)
severity Severity Category Incident Severity Level: (MAJOR, MEDIUM, MINOR, POTENT, NS = NO SPILL) char(6)
mat_category Material Category Spill Material Category (OIL/OILY, HAZMAT, MARPOL V). char(8)
osc OSC On Scene Coordinator Code (USCG, EPA, DOD). Char(5)
epa_reg EPA Region EPA Region Number. char(2)
epa_resp Response Required 'X' = EPA Response to spill. Char(1)
nrc_case NRC Case NRC Case Number. char(10)
dist District District Port Code. Char(5)
case_ctl_lev Case Control Level Case Control Level Code 'I' = Investigator, 'U' = Unit, 'D' = District, 'H' = Hdqtrs. Char(1)
mcpd_ind MCPD Indicator Nr of subjects that have a case mcpd filed against it. Char(2)
mcns_ind MCNS Indicator Marine Casualty narrative supplement char(1)
mcpa_ind MCPA Indicator Nr Personnel Action. Char(2)
mcts_ind MCTS Indicator Nr Towing Supplements. Char(2)
mcpi_ind MCPI Indicator Nr Personnel Involvement. Char(2)
mccr_ind MCCR Indicator X = Case Recommendation. Char(1)
mcsi_ind MCSI Indicator Nr SMI Supplements. Char(2)
mcdd_ind MCDD Indicator 'X' = Casualty Details. Char(1)
mcdr_ind MCDR Indicator Nr Deficiency Reports. Char(2)
mccg_ind MCCG Indicator Nr Collision/Grounding. Char(2)
mcfc_ind MCFC Indicator Nr Flood, Capsize, Sinking. Char(2)
mcfe_ind MCFE Indicator Nr Fire/Explosion. Char(2)
mscf_ind MSCF Indicator Nr Structural Failure. Char(2)
mchm_ind MCHM Indicator Nr Haz Material. Char(2)
mcpc_ind MCPC Indicator Nr Personnel Casualty. char(2)
mchf_ind MCHF Indicator Nr Human Factors records. Char(2)
nrc_ind NRC Indicator National Response Center Indicator. Char(1)
pub_vsl_ind Public Vessel "X" or NULL. Char(1)
boating_ind Boating "X" or NULL. Char(1)
num_vsl Number of Vsls Inv Number of vessels involved. char(2)
num_fac Number of Fac Inv Number of facilities involved. char(2)
mcls_ind MCLS Indicator Lifesaving involved. char(2)
mcwx_ind MCWX Indicator "X" = case filed. Char(2)
rec_end_ind Recomm Endorsed Inc "X" = recommendation filed with case. Char(1)
supp_comp Supplements Completed 'X' = All supplements completed. Char(1)
fwpca FWPCA FWPCA Case Number. char(9)
fwpca_amt FWPCA Amount FWPCA Ceiling. Char(7)
cercla CERCLA CERCLA Case Number. char(9)
cercla_amt CERCLA Amount CERCLA Ceiling. Char(7)
nfs_ind Response by NFS 'X' = Strike Force Response. Char(1)
mcpd_closed MCPD Closed Indicator "X" = Pollution Details Supplement Closed. Char(1)
human_fac_num Human Fac Num Nr Human Factors. Char(3)
fy Fiscal Year Fiscal year. Char(4)
closed_by Case Closed By H = Case closed by HQ D = Case closed by District U = Case closed by Unit. char(1)
sp Filler Filler char(1)
civt mccase Marine Casualty Case Marine Casualty case number. char(10)
vin Vessel Identification Vessel Identification number. char(8)
vname Name Vessel name. char(33)
flag Flag Vessel flag. char(2)
service Service Service of the vessel - see table 21. char(19)
mcpd_ind MCPD Filed Ind "X" = pollution detail was filed. Char(1)
mcpa_ind MCPA Filed Ind "X" = personnel action filed. Char(1)
mcpi_ind MCPI Filed Inc "X" = personnel inspection filed. Char(1)
mcsi_ind MCSI Filed Inc "X" = SMI filed. Char(1)
tow_supp Towing Supp - MCTS "X" = towing supplement reference. Char(1)
dam_eval Damage Evaluation Evaluation of seaworthiness of the vessel. Char(4)
operation Operation - MCDD FF operation prior to casualty. char(9)
vsl_status Control Status - MCDD Status of vessel: TOWED MOORED ANCHORED UNDERWAY char(8)
vkey VKEY Key to identify a vessel and joining record. char(10)
towed_vsl_pos Towing Supp Location Position of the tow configuration. Char(4)
tow_status Towing Supp Status Status of vessel at time of tow: ASSIST CONTROL TOWED P TOWED NP char(10)
subject Subject Key Subject case number. char(10)
subj_ref_num Subject Ref No Identifies the vessel involved. char(3)
mcpd_closed MCPD Closed Ind Marine Casualty Pollution Detail case closed. Char(1)
sp Filler Filler char(1)
converta year Year Year spilled occurred. Char(4)
chris Chris Code Chemical code. Char(3)
type Type Single character indicating type of substance: C =Chemical P = Petroleum based products O = Other oil products
G = Garbage U = Unknown
M = Multiple substances
N = Natural substances		 char(1)
cases Cases Case number associated with spill. Char(10)
pot Total Potential Quantity of potential substance spilled. Char(13)
spin In Water Qty Spilled Quantity of spill in the water. Char(13)
rein In Water Qty Rec Quantity of spill recovered in water. Char(13)
spout Out of Wtr Qty Spilled Quantity of spill out of water. Char(13)
reout Out of Wtr Qty Rec Quantity of spill recovered out of water. Char(13)
measure Unit of Measure Units of measure. Char(7)
name Substance Name Substance spilled name. Char(55)
date Spilled Date Date of spill. Char(10)
district District Investigating unit's district. Char(2)
unit Unit Unit conducting investigation. Char(5)
supid Supplement ID A value that uniquely identifies the spill source. Char(10)
sp Filler Filler char(1)
cpct mccase Marine Casualty Case Marine Casualty case number. char(10)
subject Subject Subject case number. char(13)
ipn Involved Party Number Involved party number. char(10)
lname Last Name Last name of involved party. char(20)
fname First Name First name of involved party. char(20)
dob Date of Birth Date of birth of involved party. Char(10)
status Status Position of involved party. char(15)
injury Casualty Type - Injury "X" = Involved party was injured. char(1)
dead Casualty Type - Dead "X" = Involved party died. char(1)
missing Casualty Type - Missing "X" = Involved party missing. char(1)
on_duty On Duty Y/N - was the involved party on duty. char(1)
dt_of_death Date of Death Date of death of involved party. Char(10)
incapacitated Incap Over 72 Hours Y/N - was the involved party incapacitated. char(1)
duty_hrs Hours of Duty How many hours on duty before accident. Char(2)
accident_typ Type of Accident Type of accident. char(20)
resulting_injury Resulting Injury Result of injury. char(20)
body_part Body Pt Affected Body part injured. char(20)
activity Activity Activity type before accident. char(64)
location Location Location of accident. char(64)
equip_inv Equipment Inv Type of equipment involved. char(20)
equip_part Equipment Part Part of equipment. char(20)
yrs_in_industry Years in this Industry How many years involved party been in the industry. Char(2)
mths_in_industry Months in this Industry How many months involved party been in the industry. Char(2)
yrs_with_company Years with this Company How many years involved party been with company. Char(2)
mths_with_company Months with this Company How many months involved party been with company. Char(2)
yrs_present_job Years in Present Job How many years involved party been in present job. Char(2)
mths_present_job Months in Present Job How many months involved party been in present job. Char(2)
yrs_vsl_fac Years on Present Ves/Fac How many years involved party been on the vessel or facility. Char(2)
mths_vsl_fac Months on Present Ves/Fac How many months involved party been on the vessel or facility. Char(2)
employer_ipn Industry Employer IPN Industry employer identification number. char(10)