Marine Safety Management System,,,,
Attribute Definition View,,,,
"December 13, 2001",,,,
Developed by Harold Krevait,,,,
(202)267-6833,,,,
,,,,
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 ,char(1)
,,,G = Garbage  U = Unknown,
,,,M = Multiple substances  ,
,,,N = Natural substances,
,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)
,employer_name,Industry Employer Name,Industry employer's name.,char(33)
,nec_accident_typ,Explan of NEC Accident,Explanation of NEC accident type.,char(20)
,sp,Filler,Filler,char(1)
cpdt,mccase,Marine Casualty Case,Marine Casualty case number.,char(10)
,subject,Subject,Subject case number.,char(10)
,chris_code,Chris Code,CHEM ID Code (based on CHRIS Code).,Char(3)
,type,Type,Single character indicating type of substance:  L = Liquid  G = Gas  S = Solid    ,char(1)
,potential_qty,Total Potential,Quantity of potential substance spilled.,Char(12)
,out_of_water_spilled,Spilled Out of Water,Quantity spilled out of water.,Char(12)
,out_of_water_qty_rec,Recovered Out of Water,Quantity recovered out of water.,Char(12)
,in_water_qty_spilled,Spilled in Waterway,Quantity spilled in water.,Char(12)
,in_water_qty_rec,Recovered in Waterway,Quantity recovered in water.,Char(12)
,units_measure,Units for Non-Liquids,Units of measure.,Char(8)
,substance_name,Name,Substance spilled name.,char(70)
,cat,Category,Category of substance.  P=Petroleum Based Products  O=Other Oil Products  C=Chemical  N=Natural Substance  M=Multiple Substances  G=Garbage  U=Unknown    ,char(1)
,spdt_rpdt,Spill Date,Date of spill (from prit).,Char(10)
,sp,Filler,Filler,char(1)
csft,mccase,Marine Casualty Case,Marine Casualty case number.,char(10)
,subject,Subject,Subject case number.,char(10)
,class,Class,Classification of the structural failure.,char(1)
,type,Type,Type of structural failure.,char(15)
,patt_typ,Pattern Type,Y/N - Structure failure pattern type.,char(1)
,port,Port,"""X"" - failure port.",char(1)
,stbd,STBD,"""X"" - failure starboard.",char(1)
,ctr,Center,"""X"" - failure center.",char(1)
,deck,Deck,"""X"" - failure on deck.",char(1)
,bott,Bottom,"""X"" - failure on bottom.",char(1)
,side,Side Shell,"""X"" - failure on side.",char(1)
,intern,Internal,"""X"" - failure internal.",char(1)
,bow,Bow,"""X"" - failure on bow.",char(1)
,strn,Stern,"""X"" - failure on stern.",char(1)
,spec_attn,Special Atten Vsl,Structural failure special attention vessel indicator.,char(1)
,sp,Filler,Filler,char(1)
cwxt,mccase,Marine Casualty Case,Marine Casualty case number,char(10)
,pre_time,Pre Time,Pre time,char(8)
,pre_wx,Pre Weather,Pre weather,char(5)
,pre_vis_con,Pre Visibility Condition,Pre visibility condition,char(4)
,pre_vis_dist,Pre Visibility Distance,Pre visibility distance,char(5)
,pre_vis_dis_units,Pre Visibility Distance Units,Pre visibility distance units,char(2)
,pre_ex_other,Pre Explanation of Other,Pre explanation of other,char(20)
,pre_air_temp,Pre Air Temp,Pre air temp,char(3)
,pre_wind_spe,Pre Wind Speed,Pre wind speed,char(3)
,pre_wind_dir,Pre Wind Direction,Pre wind direction,char(3)
,pre_wind_dir_units,Pre Wind Direction Units,Pre wind direction units,char(1)
,pre_wave_hts,Pre Wave Height,Pre wave height,char(3)
,pre_wave_dir,Pre Wave Direction,Pre wave direction,char(3)
,pre_wave_dir_units,Pre Wave Direction Units,Pre wave direction units,char(1)
,pre_swell_hts,Pre Swell Height,Pre swell height,char(3)
,pre_well_dir,Pre Swell Direction,Pre swell direction,char(3)
,pre_swell_dir_units,Pre Swell Direction Units,Pre swell direction units,char(1)
,pre_crnt_spe,Pre Current Speed,Pre current speed,char(3)
,pre_crnt_dir,Pre Current Direction,Pre current direction,char(3)
,pre_crnt_dir_units,Pre Current Direction Units,Pre current direction units,char(1)
,pre_river_stage,Pre River Stage,Pre river stage,char(6)
,pre_tide,Pre Tide,Pre tide,char(8)
,post_wx_sig,Post Weather Significant,Post weather significant,char(1)
,post_wx,Post Weather,Post weather,char(5)
,post_wx_trend,Post Weather Trend,Post weather trend,char(20)
,post_vis_con_sig,Post Visibility Condition Significant,Post visibility condition significant,char(1)
,post_vis_con,Post Visibility Condition,Post visibility condition,char(4)
,post_vis_con_trend,Post Visibility Condition Trend,Post visibility condition trend,char(20)
,post_vis_dis_sig,Post Visibility Distance Significant,Post visibility distance significant,char(1)
,post_vis_dis,Post Visibility Distance,Post visibility distance,char(5)
,post_vis_dis_units,Post Visibility Distance Units,Post visibility distance units,char(2)
,post_vis_dis_trend,Post Visibility Distance Trend,Post visibility distance trend,char(20)
,post_air_temp_sig,Post Air Temp Significant,Post air temp significant,char(1)
,post_air_temp,Post Air Temp,Post air temp,char(3)
,post_air_temp_trend,Post Air Temp Trend,Post air temp trend,char(20)
,post_wind_spe,Post Wind Speed,Post wind speed,char(3)
,post_wind_spe_trend,Post Wind Speed Trend,Post wind speed trend,char(20)
,post_wave_hts,Post Wave Height,Post wave height,char(3)
,post_wave_hts_trend,Post Wave Height Trend,Post wave height trend,char(20)
,post_swell_hts,Post Swell Height,Post swell height,char(3)
,post_swell_hts_trend,Post Swell Height Trend,Post swell height trend,char(20)
,post_crnt_spe,Post Current Speed,Post current speed,char(3)
,post_crnt_spe_trend,Post Current Speed Trend,Post current speed trend,char(20)
,post_wind_dir,Post Wind Direction,Post wind direction,char(3)
,post_wind_dir_units,Post Wind Direction Units,Post wind direction units,char(1)
,post_wind_dir_trend,Post Wind Direction Trend,Post wind direction trend,char(20)
,post_wave_dir,Post Wave Direction,Post wave direction,char(3)
,post_wave_dir_units,Post Wave Direction Units,Post wave direction units,char(1)
,post_wave_dir_trend,Post Wave Direction Trend,Post wave direction trend,char(20)
,post_swell_dir,Post Swell Direction,Post swell direction,char(3)
,post_swell_dir_inits,Post Swell Direction Units,Post swell direction units,char(1)
,post_swell_dir_trend,Post Swell Direction Trend,Post swell direction trend,char(20)
,post_crnt_dir,Post Current Direction,Post current direction,char(3)
,post_crnt_dir_units,Post Current Direction Units,Post current direction units,char(1)
,post_crnt_dir_trend,Post Current Direction Trend,Post current direction trend,char(20)
,post_river_stage,Post River Stage,Post river stage,char(6)
,post_river_stage_trend,Post River Stage Trend,Post river stage trend,char(20)
,post_tide,Post Tide,Post tide,char(8)
,post_tide_trend,Post Tide Trend,Post tide trend,char(20)
,post_wind_spe_sig,Post Wind Speed Significant,Post wind speed significant,char(1)
,post_wave_hts_sig,Post Wave Height Significant,Post wave height significant,char(1)
,post_swell_hts_sig,Post Swell Height Significant,Post swell height significant,char(1)
,post_crnt_spe_sig,Post Current Speed Significant,Post current speed significant,char(1)
,post_wind_dir_sig,Post Wind Direction Significant,Post wind direction significant,char(1)
,post_wave_dir_sig,Post Wave Direction Significant,Post wave direction significant,char(1)
,post_swell_dir_sig,Post Swell Direction Significant,Post swell direction significant,char(1)
,post_crnt_dir_sig,Post Current Direction Significant,Post current direction significant,char(1)
,post_river_stage_sig,Post River Stage Significant,Post river stage significant,char(1)
,post_tide_sig,Post Tide Significant,Post tide significant,char(1)
,sp,Filler,Filler,char(1)
fidt,fkey,Facility Key,Primary key to identify a facility.,Char(10)
,port_zone,Port Zone,Unit zone.,Char(10)
,unit,Unit,Unit.,Char(8)
,unit_cat,Unit Category,Unit category.,Char(8)
,fin,Primary FIN,Primary facility identification number,char(8)
,fin1,1st Alternate FIN,First Alternate FIN,char(8)
,fin2,2nd Alternate FIN,Second Alternate FIN.,Char(8)
,fin3,3rd Alternate FIN,Third Alternate FIN.,Char(8)
,fname,Facility Name,Name of the Facility.,Char(33)
,lcl_id,Local ID,Local identification.,Char(10)
,category,Category,Type of category.,Char(20)
,fuse,Use,Facility use.,Char(15)
,ownership,Ownership,Ownership.,Char(15)
,nec_cat,Description for NEC,Not else classified description.,Char(25)
,inact_ind,Facility Inactive Ind,Facility inactive indicator.,Char(1)
,contact,Contact,Point of contact.,Char(33)
,day_phone,Day Phone Number,Day phone number.,char(12)
,night_phone,Night Phone Number,Night phone number.,char(12)
,emergency,Emergency Number,Emergency number.,char(12)
,inspect_dt,Last Inspection Date,Last inspection date.,Char(10)
,marpol_solo_ind,Marpol Solo Ind,"""X"" - Marpol Solo indicator.",Char(1)
,marpol_super_ind,Marpol Super Ind,"""X"" - Marpol super indicator.",Char(1)
,marpol_fkey,Marpol Parent Fkey,Marpol facility number.,char(10)
,sp,Filler,Filler,char(1)
pcas,mccase,Marine Casualty,Case number of vessel casualty.,char(10)
,lname,Last Name,First ten letters of persons last name.,Char(10)
,fname,First Name,First ten letters of persons first name.,Char(10)
,birth_date,Birth Date,Birth date.,Char(8)
,status,Status,Position person held on vessel.,Char(10)
,acc_id,Accident,Nature personnel accident.,Char(10)
,injury,Injury,Nature of injury.,Char(10)
,body_part,Body Part,Part of body injured.,Char(10)
,result,Result,Result injury/death:  missing-NVC.,Char(10)
,cause1,Cause 1,Primary cause of injury/death.,Char(10)
,cause2,Cause 2,Secondary cause of injury/death.,Char(10)
,office,Office,MSO office investigating.,Char(3)
,p_location,Person Location,Location of person on vessel.,Char(4)
,activity,Activity,Type of activity person undertaking.,Char(2)
,wbody,Waterbody,Body water casualty occurred.,Char(10)
,yr_built,Year Built,Year vessel was built.,Char(4)
,case_date,Casualty Date,Date personnel casualty occurred.,Char(10)
,oper_co,Operating Company,Name of company operating vessel.,Char(10)
,vin,Vessel Identification,Vessel identification number.,char(10)
,vkey,Vessel Key,Primary key to identify a vessel and to join records.,Char(10)
,flag,Flag,Flag of vessel.,Char(10)
,service,Service,Service of vessel.,Char(10)
,v_use,Vessel Use,How vessel was used.,Char(4)
,design,Design,Design of vessel.,Char(10)
,length,Length,Length of vessel.,Char(7)
,gr_tons,Gross Tons,Gross tons of vessel.,Char(6)
,vslname,Vessel Name,Name of vessel.,Char(40)
,numcas,Number of Casualties,Number of casualties.,Char(3)
,sp,Filler,Filler,char(1)
post,mpcase,Marine Pollution Case,Marine Pollution Case Number.  Primary join path to cases supplements (not implemented) and violation products.,char(10)
,supplement_id,Supplement ID,Each supplement associated with a case is uniquely identified by this element.  Join path to violation tables with vrcase.,Char(4)
,verify_ind,Verify Indicator,,char(1)
,source,Source Name,Suspected or actual source of spill.,Char(33)
,nr_pollutants,No Pollutants Spilled,Number of substances spilled.,Char(3)
,operation,Operation,Vessel operation at time of the spill.,char(26)
,vrcase,Violation Report No,Violation Report Case number.,char(10)
,lcl_source_id,Local Source ID,Local Source Identification number.,char(10)
,own_class,Ownership Class,"Describes Government, Commercial, military or other facility type.",char(14)
,source_typ,Source Type,Identifies the facility type - see table 17.,char(21)
,source_use,Source Use,Describes the use of the facility.,char(14)
,pen_action,Penalty Action,Was action taken.,char(1)
,pri_cause,Primary Cause,Primary cause of spill.,char(23)
,sec_cause,Secondary Cause,Secondary cause of spill.,char(18)
,contri_factor_1,Contributing Factor 1,First contributing factor of spill.,char(18)
,contri_factor_2,Contributing Factor 2,Second contributing factor of spill.,char(18)
,fin,Facility FIN,Facility Identification.,Char(8)
,fkey,Facility Key,Key for joining facility records.,char(10)
,sp,Filler,Filler,char(1)
prit,mpcase,Marine Pollution Case,Marine Pollution Case Number.  Primary join path to cases supplements (not implemented) and violation products.,char(10)
,unit,Unit,MSIS port code (parent units only).,char(5)
,osc,On Scene Coord Agency,On Scene Coordinator for incident - see table 30.,char(4)
,spdt,Occurrence Date,Spill Date.,Char(10)
,city,City Nearest OCC,City spill occurred in.,char(25)
,state,State of OCC,State spill occurred in.,char(2)
,region,EPA Region,EPA region spill occurred in - see table 27.,char(2)
,water,Waterbody Affected,Water body affected – see table 56.,char(29)
,mccase,Casualty Ref,Marine Casualty Incident Report case number associated with spill case (if any).,char(10)
,rpdt,Date Case Reported,Date spill reported.,Char(10)
,status,Clean-up Status,Case status - see table 6.,Char(14)
,num_ves,Num of Vessels Inv,Number of vessels associated with spill case.,Char(3)
,num_nonves,Num NonVes SRC Inv,Number of non-vessels (facilities) associated with case.,Char(3)
,cldt,Date Case Closed,Case closed date.,Char(10)
,sptime,Time of Spill,Time spill occurred (if known).,char(4)
,ri_mile,River Mile,River mile spill occurred at (if applicable).,Char(4)
,lat_dir,Latitude Direction,Direction where spill occurred.,char(1)
,latitude,Spill Latitude,Latitude where spill occurred.,char(5)
,long_dir,Longitude Direction,Direction where spill occurred.,char(1)
,longitude,Spill Longitude,Longitude where spill occurred.,Char(6)
,rem_party,Spill Removal Party,Party that conducted removal operations - see table 18.,char(3)
,val_ind,Inv Rep Validated,"Case validated indicator (""X"" or ""NULL"").",Char(1)
,ctf_ind,Report Close to File,"""X"" - Case closed to file.",char(1)
,pro_num,Project No,Federal project number (if any).,char(10)
,pro_typ,Project Type,Project type.,char(6)
,known_dt,M Spill Date Know/Est,Spill date/time known.,char(1)
,auth_ceil,Auth Ceiling Cost,Authorized ceiling (Federal projects).,Char(12)
,ttl_cost,Total Cost of Spill,Total cost of spill cleanup.,Char(12)
,funds_exp,Funds Expended,Pollution fund expenditures.,Char(12)
,num_cg,No OPFAC Res Rep,Number of CG response reports (supplements filed).,Char(3)
,rptime,Time Spill Reported,Time spill reported.,char(4)
,num_noncg,No NONCG Res Rep,Number of non-CG response reports (supplements filed).,Char(3)
,rptdby,Reported by,Spill reported by.,char(12)
,subject,Subject,Cause of spill.,char(26)
,nrc,NRC Notification,NRC notified unit (Y/N/NULL).,char(1)
,nrccase,NRC Ref Case,NRC case number (if any).,char(12)
,sp,Filler,Filler,char(1)
psst,mpcase,Marine Pollution Case,Marine Pollution Case Number.  Primary join path to case supplements and violation products.,char(10)
,supplement_id,Supplement ID,Each supplement associated with a case is uniquely identified by this element.,char(4)
,chris_code,Substance CHRIS Code,CHEM ID Code (based on CHRIS Code).,char(3)
,potential_qty,Total Potential Qty,Quantity in gallons of potential substance spilled.,Char(12)
,out_of_water_spilled,Out of Wtr Qty Spilled,Quantity in gallons of spill out of water.,Char(12)
,out_of_water_qty_rec,Out of Wtr Qty Rec,Quantity in gallons of spill recovered out of water.,Char(12)
,in_water_qty_spilled,In Water Qty Spilled,Quantity in gallons of spill in the water.,Char(12)
,in_water_qty_rec,In Wtr Qty Rec,Quantity in gallons of spill recovered in the water.,Char(12
,units_measure,Units of Measure,Units of measure.,char(7)
,substance_name,Substance Name,Substance spilled name.,char(55)
,type,Type of Substance,Single character indicating Type of Substance  ,char(1)
,,,P=Petroleum Based Oils  C=Chemicals  ,
,,,N=Natural Substance  M=Multiple Substances   O=Other Oil Products  G=Garbage  U=Unknown,
,spdt_rpdt,Spill Date/Report Date,Date of Spill or when Unknown Date Spill Reported,char(10)
,sp,Filler,Filler,char(1)
pvst,mpcase,Marine Pollution Case,Marine Pollution Case Number.  Primary join path to case supplements and violation products.,char(10)
,vname,Vessel Name,Name of vessel at the time of the spill.,char(33)
,vin,Vessel Identification,VIN of the vessel at the time of the spill.,Char(10)
,flag,Vessel Flag,Flag code for vessel at time of spill.,Char(2)
,num_pollutants,No Pollutants Spilled,Number of substances spilled.,Char(3)
,p_operation,Operation,Vessel operation at the time of the spill.,char(26)
,vrcase,Viol Report No,Violation Report case number.  Join path to OLD violation products.,char(10)
,vkey,Vessel Key,Primary key to identify a vessel and joining records.,char(10)
,penalty_action,Penalty Action,"Legal action taken (""Y"" or ""N"").",char(1)
,primary_cause,Primary Cause,Primary cause of spill.,char(23)
,secondary_cause,Secondary Cause,Secondary cause of spill.,char(18)
,contributing_factor_1,Contributing Factor 1,First contributing factor of spill.,char(18)
,contributing_factor_2,Contributing Factor 2,Second contributing factor of spill.,char(18)
,supplement_id,Supplement ID,Each supplement associated with a case is uniquely identified by this element.  Join path to psst.,char(4)
,service,Service,Vessel service.,char(19)
,sp,Filler,Filler,char(1)
tcet,tknumber,TK Number,Ticket number,char(10)
,cas_event,Casualty Event,Casualty Event Number,char(2)
,type,Casualty Event Type,Nature of Incident,char(15)
,class,Casualty Event Class,Further Modifies Nature,char(20)
,state,Casualty Event State,Modifies Class,char(22)
,cas_causal_event,Casualty Causal Event,Casualty Event -  Casual Event Number,char(2)
,causal_cat,Causal Category,Cause of the Event  EF=EQUIPMENT FAILURE  HF=HUMAN FACTOR  HM=HAZARDOUS MATERIAL  WX=WEATHER,char(2)
,causal_class,Causal Class,Details of the Category,char(15)
,causal_subclass,Causal Subclass,Details of the Class,char(20)
,causal_state,Causal State,Circumstances of the Class,char(16)
,causal_party,Causal Party,Role of the Party,char(5)
,causal_event,Causal Event,Event Sequence,char(2)
,sp,Filler,Filler,char(1)
vcas,mccase,Marine Casualty,Case number of vessel casualty.,char(10)
,vin,Vessel Identification Number,Vessel documentation number.,char(10)
,vkey,Vessel Key,Primary key to identify a vessel and joining to other tables.,Char(10)
,numvsdam,Number Vessels Damaged,Number of vessels damaged.,Char(3)
,cas_date,Casualty Date,Date of casualty.,char(10)
,period_day,Period of Day,"Day, night, etc.",Char(1)
,weather,Weather,Weather.,Char(2)
,water,Body Water,Body of water casualty occurred in.,Char(7)
,lat_hemisphere,Latitude Hemisphere,Latitude hemisphere.,Char(1)
,latitude,Latitude,Latitude.,Char(9)
,long_hemisphere,Longitude Hemisphere,Longitude hemisphere.,Char(1)
,longitude,Longitude,Longitude.,Char(9)
,rep_type,Report Type,"Routine letter XMIT, Form 2692.",Char(6)
,total_dam,Total Damage,Total damage entire casualty case.,Char(13)
,unit,Unit,MSO Office investigating case.,Char(3)
,milepost,Milepost,River milepost.,Char(7)
,enter_by,Entered By,USCG employee recording case.,Char(10)
,wind_dir,Wind Direction,Wind direction.,Char(3)
,wind,Wind,Wind speed.,Char(3)
,inv_vsl,Involved Vessels,Number of vessels involved.,char(5)
,nature1,Primary Nature,First nature of casualty.,char(6)
,nature2,Second Nature,Second nature of casualty.,char(6)
,nature3,Third Nature,Third nature of casualty.,char(6)
,cause1,Primary Cause,First cause of nature 1.,Char(7)
,cause2,Second Cause,Second cause of nature 1.,Char(7)
,cause3,Third Cause,Third cause of nature 1.,Char(7)
,cause4,Fourth Cause,First cause of nature 2.,Char(7)
,cause5,Fifth Cause,Second cause of nature 2.,Char(7)
,cause6,Sixth Cause,First cause of nature 3.,Char(7)
,sea_con,Sea Condition,Sea condition.,char(4)
,config,Configuration,Tow configuration.,char(3)
,vname,Vessel Name,Vessel name.,char(33)
,flag,Flag,Flag of vessel.,char(2)
,yr_built,Year Built,Year vessel built.,char(4)
,service,Service,Service of vessel.,char(4)
,abc,ABC,How seaworthiness was affected.,char(1)
,v_use,Vessel Use,How vessel was being used.,char(4)
,length,Length,Vessel length.,Char(7)
,gr_tons,Gross Tons,Gross tonnage of vessel.,Char(6)
,hull,Hull,Hull material.,char(2)
,prop,Propulsion,Type of propulsion.,char(2)
,hp,Horse Power,Horsepower.,Char(6)
,design,Design,Hull design.,char(4)
,vess_dam,Vessel Damage,Vessel damage.,Char(13)
,cargo_dam,Cargo Damage,Cargo damage.,Char(13)
,crew_death,Crew Death,Crew death.,Char(3)
,pass_death,Passenger Death,Passenger death.,Char(3)
,total_death,Total Death,Total count of deaths in case.,Char(3)
,crew_injury,Crew Injury,Crew injury.,Char(3)
,pass_injury,Passenger Injury,Passenger injury.,Char(3)
,total_injury,Total Injury,Total count of injuries in case.,Char(3)
,vsl_state,Vessel Status,Status of vessel.,char(3)
,person_ic,Person In Charge,Person in charge of vessel movement.,char(4)
,society,Society,Vessel society classing vessels.,char(3)
,oper_co,Operating Company,Name of company operating vessel.,char(10)
,pilot,Pilot,Verification of licensed pilot.,char(4)
,sp,Filler,Filler,char(1)
vidt,vkey,Vessel Key,Primary key to identify a vessel and join records.,Char(10)
,poc,Port of Certification,Port of Certification - CG port issuing last Certification of Inspection.  Data consists of MSIS Port Code (or NULL).,Char(5)
,pod,Home Port,Port of Documentation.  The CG documentation port code.,Char(5)
,vname,Vessel Name,Vessel Name.  (Asterisk in last column of name indicates the vessel is archived).,char(33)
,vin,Primary VIN,Primary Vessel Identification Number for vessel in MSIS.,char(10)
,call_sign,Call Sign,Call sign of vessel.,char(8)
,flag,Flag,Vessel flag code - see table 29.,char(2)
,vin1,1st Alternate VIN,1st Alternate VIN.,char(8)
,vin2,2nd Alternate VIN,2nd Alternate VIN.,Char(8)
,vin3,3rd Alternate VIN,3rd Alternate VIN.,char(8)
,vin4,4th Alternate VIN,4th Alternate VIN.,char(8)
,design,Design Type,Design Code - see table 23.,char(19)
,service,Service,Service Code - see table 21. (insp vessels).,char(19)
,coi_dt,Inspect Cert Date,Date of Inspection for Certification (insp vsls).,Char(10)
,cod_ind,COD Indicator,"""X"" - vessel is documented.",char(1)
,ic_ind,Inspection Concern,"""I"" - vessel has a Certification of Inspection  ""C""  - vessel has had a Certificate of Compliance",char(1)
,psbr_ind,Port Safety Concern,"""X"" - vessel has a Port Safety Boarding history.",char(1)
,va_ind,Vessel Archive Ind,"""X"" - vessel has been archived.",char(1)
,imo_num,IMO Number,Lloyd's Registry number (less the 'L' prefix).,char(7)
,subchap,Inspection Subchapter,Subchapter (46 CFR) that vessel is inspected under.,char(2)
,v_use,Use,Vessel use code - see table 25.,char(19)
,dwt,Deadweight Tons,Deadweight tonnage.,Char(6)
,bld_dt,Build Date,Date of build.,Char(9)
,bld_pl,Build Place 1,Place of build.,char(36)
,keel_dt,Date Keel Laid,Date keel laid.,Char(10)
,route,Operating Route,"Route code     CC=COASTWISE  CG COASTWISE AND GREAT LAKES  GG=GREAT LAKES  LC=COASTWISE LIMITED  LG=LAKES, BAYS, SOUNDS AND GREAT LAKES  LL=LAKES, BAYS, SOUNDS  NA=NOT APPLICABLE  OO=OCEANS  RG=RIVERS AND GREAT LAKES - LIMITED  RR=RIVERS",char(2)
,min_crew,Minimum Crew,Minimum crew (insp vsls).,Char(4)
,num_pass,Passengers Permitted,Number of passengers permitted (insp vessels).,Char(4)
,max_persons,Maximum Persons Allwd,Maximum persons allowed (insp vessels).,Char(4)
,oth_crew,Other Crew Allowed,Number of other crew permitted (insp vessels).,Char(4)
,p_a_crew,Persons in Add to Crew,Number of persons in addition to crew (insp vessels).,Char(4)
,stab_status,Stability Doc Status,Stability Document Status (PERM/TEM) (insp vessels).,char(4)
,cargo_auth,Cargo Authority,Bulk dangerous cargo carrying authority.,char(60)
,hi_grd_auth,Highest Cargo Grade,"Highest grade of liquid cargo authorized for carriage. (A,B,C, LPG etc.)",char(3)
,tot_cap,Capacity in Barrels,Total cargo capacity.,Char(8)
,stab_ltr_ind,Stability Letter Ind,"""X"" - stability letter issued.",Char(1)
,stab_book_ind,Stability Book Inc,"""X"" - stability book issued.",char(1)
,stab_app_date,Stability Approval Date,Stability approval date.,Char(10)
,stab_port,Unit Issue Stab Cert,Port issuing stability approval (MSIS port code).,char(5)
,cfr_pt_11,CFR Part Used LL,CFR Part used for loadline.,char(2)
,admin_11,Vessel Loadline Type,Vessel type (for loadline) – see table 24.,char(4)
,route_11,Route Type LL,Loadline route type.,char(9)
,stab_freebrd,Freebrd Used in Stab,Freeboard used for stability analysis.,char(4)
,hazbulk_ind,Hazard Bulk Solid Ind,"""X"" - solid hazardous bulk carriage authority.",char(1)
,dk_drain,Deck Drainage Class,Deck drainage class code (T boats) see table 8.,char(12)
,cont_dt,Contract Date,Date contracted for construction.,Char(10)
,del_dt,Delivery Date,Date vessel delivered.,Char(10)
,ini_coi_dt,Init Cert Date,Date of initial Inspection for Certification.,Char(10)
,bld_yr,Build Year,Year built (e.g. 1981) - maybe 'UNKN'.,Char(4)
,cap_units,Capacity Units,"Cargo carriage capacity units (BBLS, MTONs, etc.)",char(4)
,plan_rev_unit,Plan Review Office,Unit conducting plan review (MSIS Port Code).,char(5)
,yard,Yard Built,Yard where vessel was built.,char(25)
,hull_num,Hull Number,Yard hull number.,char(12)
,bld_cty,Build Country 1,Code for country where built – see table 20.,Char(3)
,ton_calc,Calculation Method,Tonnage calculation method (documented vessels).,char(7)
,reg_gt,Gross Tons,Registered Gross Tons.,Char(6)
,itc_gt,ITC Gross Tons,ITC Gross Tons.,Char(6)
,dual_grt,Dual Gross Tons,Dual Gross Tons.,Char(6)
,reg_net,Net Tons,Registered Net Tons.,Char(6)
,itc_net,ITC Net Tons,ITC Net Tons.,Char(6)
,dual_net,Dual Net Tons,Dual Net Tons.,Char(6)
,reg_lgth,US Length,Registered Length.,Char(7)
,reg_brdth,US Breadth,Registered Breadth.,Char(7)
,reg_dpth,US Depth,Registered Depth.,Char(7)
,itc_lgth,ITC Length,ITC Length.,Char(7)
,itc_brdth,ITC Breadth,ITC Breadth.,Char(7)
,itc_dpth,ITC Depth,ITC Depth.,Char(7)
,overall_lgth,Overall Length,Length overall.,Char(7)
,disp_tons,Displacement Tons,Registered displacement tonnage.,Char(7)
,itc_ton_ind,ITC Tonnage Indicator,"""X"" - ITC tonnage used on Certification of Documentation.",Char(1)
,mes_ves_type,Vessel Type,Vessel type code used for admeasurement purposes.,char(9)
,hull_mat,Hull Material,Hull Material Code - see table 11.,char(11)
,selfprop_ind,Self Propelled Ind,"""Y""/""N"" - self propelled.",Char(1)
,t_cw,Coastwise Trade,"""X"" - Coastwise trade.",Char(1)
,t_gl,Great Lakes Trade,"""X"" - Great Lakes license.",Char(1)
,t_fish,Fisheries Trade,"""X"" - Fishing license.",Char(1)
,t_bow,Coastwise Bowater Only,"""X"" - Bowater license.",Char(1)
,t_reg,Registry,"""X"" - Registry license.",Char(1)
,t_rec,Recreation,"""X"" - Recreation license.",Char(1)
,rest_cw,Restrict-No CW/GL,"""X"" - no Coastwise or Great Lakes.",Char(18)
,rest_fish,Restrict-No Fishing,"""X"" - no Fishing.",Char(18)
,rest_reg,Restrict-No Registry,"""X"" - no Registry.",Char(18)
,rest_rec,Restrict-No Rec Lic,"""X"" - no Recreation.",Char(18)
,rest_gl,Restrict-No GL License,"""X"" - no Great Lakes.",Char(18)
,e_sl_cw,Spec Leg Coastwise,"""X"" - special legislation for coastwise trade.",Char(1)
,e_cf_cap,Captured Vessel,"""X"" - captured (in war).",Char(1)
,e_sl_fishery,Spec Leg Fishery,"""X"" - special legislation for fisheries.",Char(1)
,e_cf_forfeit,Forfeited Vessel,"""X"" - forfeited vessel.",Char(1)
,e_sl_call_hp,Spec Leg Call Home Port,"""X"" - special legislation contact home port.",Char(1)
,e_cf_wrecked,Wrecked Vessel,"""X"" - wrecked vessel.",Char(1)
,e_none,No Entitlements,"""X"" - no entitlements.",Char(1)
,us_serv_ind,US Service Ind,"""Y"" - US service indicator.",Char(1)
,cod_stat,COD Status,Certificate of Documentation Status     VALID  EXPIRED  CANCEL  DELETE  INVALID  DELETE-PM  VALID-VFY  VALID-NVFY  VD case numbers(IN PROCESS)  ,char(11)
,dblside_typ,Double Side Type,"Double side type for tank vessels.  WT = Watertight, NT = Non tight, NA = No double bottom.",Char(2)
,dblbott_typ,Double Bottom Type,"Double bottom type for tank vessels.  FULL = Full double bottoms, PART = Partial double bottoms, NONE = No double bottom.",char(4)
,prop_typ,Propulsion Type,The main propulsion type of the vessel.  (Insp vsls):  AUXILIARY SAIL  COMBINATION TYPES  DIESEL DIRECT  DIESEL ELECTRIC  DIESEL OUTDRIVE  DIESEL REDUCTION  ELECTRIC MOTOR  GASOLINE ENGINE  GAS TURBINE  NONE  NOT CLASSIFIED  SAIL  STEAM TURBOELECTRIC  STEAM RECIPROCATING  STEAM TURBINE  UNKNOWN,char(20)
,sp,Filler,Filler,char(1)
prct,mpcase,Marine Pollution Case,Marine pollution case number.,char(10)
,opfac_1,OPFAC Identification 1,Unit code.,char(7)
,opfac_2,OPFAC Identification 2,Units operating facility code.,char(7)
,num_resource,Number of Resources Utilized,Number of resources.,Char(3)
,supp_id,Supplement Identification,Supplement identification.,char(4)
,sp,Filler,Filler,char(1)
mvcttk,mvcase,Marine Violation Case,The civil penalty case identification.,char(10)
,ini_unit,Initiating Unit,Unit (port code) initiating the violation case.,char(5)
,ini_dist,Initiating District,Unit's district port code.,char(5)
,ctl_unit,Controlling Unit,Unit controlling case.,char(5)
,case_st_dt,Case Start Date,Date civil penalty case created at the district.,char(10)
,final_action,Case Status,Status of penalty case.,char(35)
,action_unit,Final Action Unit,Unit code performing last Case Action.,char(5)
,action_dt,Final Action Date,Last case action date.,char(10)
,orig_program,Originating Program,Originating Program.,char(14)
,pkey,Party Key,Primary key to identify a party.,char(10)
,rol,Party Role,Role of the party in the violation.,char(13)
,vkey,Vessel ID,Primary key to identify a vessel.,char(10)
,fkey,Facility Key,Facility Key,char(10)
,inv_subj,Involved Subject,Name of Vessel or Facility.,CHAR(33)
,settled_amt,Settled Amount,Settlement Amount.,char(12)
,paid_amt,Paid Amount,Amount paid.,char(12)
,install_pymt,Installment Payments,"Installment payments (""Y"" or ""N"").",char(1)
,board_ind,4100 Boarding Ind,4100 boarding report done.,char(1)
,case_act,Case Action Code,"Case action:  I, D, U, and S.",char(1)
,case_det,Case Detachment,Detachment's port code.,char(5)
,case_unit,Case Unit,Originating unit code.,char(5)
,assess,Total Assessed Amount,Total assessed for case.,char(12)
,distwarn_ind,Dismiss or Warning Ind,Case dismiss or warning issued.,char(1)
,case_cl_ind,Case Closed Ind,"""X"" = case closed.",char(1)
,crim_ind,Criminal Case Ind,"""X"" - criminal case.",char(1)
,prelim_assess,Previous Assessed Penalty,Total preliminary assessment for case.,char(12)
,ref_to_att,Referred to US Attorney,"""X"" = US Attorney referral",char(1)
,warn_ltr,Warning Letter,"""X"" = Warning letter issued.",char(1)
,subj_name,Case Subject Name,Case subject name.,char(33)
,vin_fin,Case Subject VIN/FIN,VIN or FIN of subject.,char(10)
,flag,Case Subject Flag,Vessel's flag code,char(2)
,service,Service,Vessel's service type.,char(19)
,sp,Filler,Filler,char(1)
prittk,mpcase,Marine Pollution Case,Marine Pollution Case Number.  Primary join path to cases supplements (not implemented) and violation products.,char(10)
,unit,Unit,MSIS port code (parent units only).,char(5)
,osc,On Scene Coord Agency,On Scene Coordinator for incident - see table 30.,char(4)
,spdt,Occurrence Date,Spill Date.,Char(10)
,city,City Nearest OCC,City spill occurred in.,char(25)
,state,State of OCC,State spill occurred in.,char(2)
,region,EPA Region,EPA region spill occurred in - see table 27.,char(2)
,water,Waterbody Affected,Water body affected - see table 56.,char(29)
,mccase,Casualty Ref,Marine Casualty Incident Report case number associated with spill case (if any).,char(10)
,rpdt,Date Case Reported,Date spill reported.,Char(10)
,status,Clean-up Status,Case status - see table 6.,Char(14)
,num_ves,Num of Vessels Inv,Number of vessels associated with spill case.,Char(3)
,num_nonves,Num NonVes SRC Inv,Number of non-vessels (facilities) associated with case.,Char(3)
,cldt,Date Case Closed,Case closed date.,Char(10)
,sptime,Time of Spill,Time spill occurred (if known).,char(4)
,ri_mile,River Mile,River mile spill occurred at (if applicable).,Char(4)
,lat_dir,Latitude Direction,Direction where spill occurred.,char(1)
,latitude,Spill Latitude,Latitude where spill occurred.,char(5)
,long_dir,Longitude Direction,Direction where spill occurred.,char(1)
,longitude,Spill Longitude,Longitude where spill occurred.,Char(6)
,rem_party,Spill Removal Party,Party that conducted removal operations - see table 18.,char(3)
,val_ind,Inv Rep Validated,"Case validated indicator (""X"" or ""NULL"").",Char(1)
,ctf_ind,Report Close to File,"""X"" - Case closed to file.",char(1)
,pro_num,Project No,Federal project number (if any).,char(10)
,pro_typ,Project Type,Project type.,char(6)
,known_dt,M Spill Date Know/Est,Spill date/time known.,char(1)
,auth_ceil,Auth Ceiling Cost,Authorized ceiling (Federal projects).,Char(12)
,ttl_cost,Total Cost of Spill,Total cost of spill cleanup.,Char(12)
,funds_exp,Funds Expended,Pollution fund expenditures.,Char(12)
,num_cg,No OPFAC Res Rep,Number of CG response reports (supplements filed).,Char(3)
,rptime,Time Spill Reported,Time spill reported.,char(4)
,num_noncg,No NONCG Res Rep,Number of non-CG response reports (supplements filed).,Char(3)
,rptdby,Reported by,Spill reported by.,char(12)
,subject,Subject,Cause of spill.,char(26)
,nrc,NRC Notification,NRC notified unit (Y/N/NULL).,char(1)
,nrccase,NRC Ref Case,NRC case number (if any).,char(12)
,sp,Filler,Filler,char(1)
mtkt,tknumber,TK Number,Ticket number,char(10)
,ref_case,Reference Case,Reference Case Number,char(10)
,unit,Port,Port Code of Controlling Unit,char(5)
,subject,Subject,"Freeform Subject that appears on   Units Log(includes party, vessel name, etc.)",char(30)
,val_ctf_ind,Val/Close To File Ind,Indicator that shows if a case is validated/closed to file,char(1)
,val_ctf_dt,Val/Close To File Date,Validated/Closed to File Date,char(10)
,forward_ind,Forward Ind,Indicator for a case forwarded from a detachment   to a parent command,char(1)
,forward_dt,Forward Dt,Forward Date,char(10)
,appealed_ind,Appealed Ind,Indicator Marked if the Ticket was declined,char(1)
,appealed_dt,Appealed Dt,Date the Decline was Received,char(10)
,type,Type FWPCA or Poll  Prev Regs,Indicator of type of ticket that was issued  F=FWPCA  P=POLLUTION PREVENTION  B=BOTH  M=MARINE SANITATION DEVICE,char(1)
,nrc_notification,Notification From NRC,Notification from NRC,char(1)
,nrc_case_num,NRC Case No,NRC Case Number,char(10)
,employer,Person Rec Ticket Employer,Person Receiving Ticket - Employer,char(40)
,issue_dt,Issue Dt,Date Ticket Issued,char(10)
,pursued_via,Pursued Via MC PS or NO Action,An Indicator Used to Determine Further Action   on a Close to File Case,char(1)
,ctf_brief,CFT Brief FFKEY,Closed to File Brief(FFKEY),char(10)
,ver_ind,Party Verified Ind,Party Verified Indicator,char(1)
,vin_fin_ver,Vin/Fin Verified Ind,VIN/FIN  Verified Indicator,char(1)
,num_cities,Number of Cites,Number of Cites,char(1)
,num_pollutants,Number of Pollutants,Number of Pollutants,char(2)
,address_ind,Resp Party US Or Foreign Address,Responsible Party U.S.  or Foreign Address  F=FOREIGN ADDRESS  NULL=U.S. ADDRESS  ,char(1)
,convert_now,Convert NOW Ind,An Indicator set by CG Headquarters  to convert a ticket to a Marine Violation Case,char(1)
,spec,Specification Edit/Map List Holder,Specification Edit/Map List Holder,char(1)
,fwpca_cat,FWPCA Category,An Indicator that determines if ticket  was issued to   A=NON-COMMERCIAL  C=COMMERCIAL  D=NON-COMMERCIAL/REPEAT OFFENDER  E=COMMERCIAL/REPEAT OFENDER  F=REPEAT OFFENDER,char(1)
,warn_ind,Warning Ind,Warning Indicator,char(1)
,sp,Filler,Filler,char(1)
pssttk,mpcase,Marine Pollution Case,Marine Pollution Case Number.  Primary join path to case supplements and violation products.,char(10)
,supplement_id,Supplement ID,Each supplement associated with a case is uniquely identified by this element.,char(4)
,chris_code,Substance CHRIS Code,CHEM ID Code (based on CHRIS Code).,char(3)
,potential_qty,Total Potential Qty,Quantity in gallons of potential substance spilled.,Char(12)
,out_of_water_spilled,Out of Wtr Qty Spilled,Quantity in gallons of spill out of water.,Char(12)
,out_of_water_qty_rec,Out of Wtr Qty Rec,Quantity in gallons of spill recovered out of water.,Char(12)
,in_water_qty_spilled,In Water Qty Spilled,Quantity in gallons of spill in the water.,Char(12)
,in_water_qty_rec,In Wtr Qty Rec,Quantity in gallons of spill recovered in the water.,Char(12
,units_measure,Units of Measure,Units of measure.,char(7)
,substance_name,Substa,Substance spilled name.,char(55)
,,nce Name,,
,type,Type of Substance,Single character indicating Type of Substance ,char(1)
,,,P=Petroleum Based Oils  C=Chemicals ,
,,,N=Natural Substance ,
,,,M=Muliple Substances   ,
,,,O=Other Oil Products  G=Garbage  U=Unknown,
,spdt_rpdt,Spill Date/Report Date,Date of Spill or when Unknown Date Spill Reported,char(10)
,sp,Filler,Filler,char(1)
,,,,
,,,,