BTS | MPRC COAST GUARD RESPONSE DATA RECORD LAYOUT

MPRC COAST GUARD RESPONSE DATA RECORD LAYOUT

FIELD NAME	FIELD DESCRIPTION	TYPE/LGTH
RAKEY (GROUP)
RACASENO	MP MSIS CASE NO	CHAR(10)
RACIF1	CIF-1 SUPPL REC TYPE	CHAR(1)
RACIF2	CIF-2 NUM SUP REC	CHAR(2)
RACIF3	CIF-3 NUM-PEN-MAT-RESP	CHAR(2)
MPRCGROUP (GROUP OF CHANGEABLE FIELDS)
YEAR	YEAR	CHAR(4)
QTR	QUARTER	CHAR(1)
DIST	OPFAC DIST (SEE PAGE 11 for VALID CODES)	CHAR(2)
UNIT	OPFAC UNIT	CHAR(5)
RCVER	VERIFICATION	CHAR(1)
RCNDATE	DATE NOTIFIED
RCNDATEDD	DAY NOTIFIED	CHAR(2)
RCNDATEMM	MONTH NOTIFIED	CHAR(3)
RCNDATEYY	YEAR NOTIFIED	CHAR(4)
RCNTIME	TIME NOTIFIED	CHAR(4)
RESPRES	RESPONDING RESOURCE CODE	CHAR(2)
MPFRES	MISSION PERFORMANCE RESOURCE FACTOR	CHAR(2)
MPFLOG	MISSION PERFORMANCE LOGISTICS FACTOR	CHAR(2)
MPFPER	MISSION PERFORMANCE PERSONNEL FACTOR	CHAR(2)
MPFENV	MISSION PERFORMANCE ENVIRONMENTAL FACTOR	CHAR(2)
ADM	ADMINISTRATION WORK HOURS	CHAR(5)
REM	REMOVAL WORK HOURS	CHAR(5)
INV	INVESTIGATION WORK HOURS	CHAR(5)
SPV	SUPERVISE WORK HOURS	CHAR(5)
MON	MONITOR WORK HOURS	CHAR(5)
PIND	PIRS POLLUTION INDICATOR	CHAR(1)

PRIMARY KEY IS RCKEY

MISSION PERFORMANCE FACTORS


RES	Addresses the qualitative performance of the responding boat, aircraft, cutter or vehicle in meeting the demands imposed by the response.
LOG	Addresses limitations on the extent of the desired response imposed by logistical factors.
PER	Details qualitative factors applicable to the Coast Guard personnel performing the response. A group rating focusing on manning, training, crew fatigue, and medical factors affecting response effectiveness of the respective resource.
ENV	Details response limitations imposed by environmental factors, primarily weather.

DURATION (HRS)


ADM	Administrative duties specifically associated with the incident, including contracting actions.
REM	Removal (actual clean-up activity)
INV	Investigation
SPV	supervise clean-up (only applicable to Federally Funded Responses)
MON	Monitor clean-up operations by responsible party