Field_name Access_type MySQL_type Length Field Description Notes Related Area on Medwatch Form Codes Old_name MDRREPT number int MDR report no. MDRREPT evkey number int Event key EVKEY REPNO text varchar 22 Report Number REPNO SCECDE text varchar 1 Report Source Code "P=Voluntary U=User facility report D=Distributor report M=Manufacturer report" SCECDE MANFLG text varchar 1 Manufacturer Link Flag - internal information flag Y/N MANFLG NOOFDEV text varchar 5 Number Devices in Event NOOFDEV NOOFPAT text varchar 5 Number Patients in Event NOOFPAT DATEREC text varchar 11 Date Received DATEREC ADVEV text varchar 1 Adverse Event Flag (B1) "Y=Yes N=No *=Not Provided" ADVEV PROPROB text varchar 1 Product Problem Flag (B1) "Y=Yes N=No *=Not Provided" PROPROB RPTDT text varchar 11 Date Report (B4) RPTDT EVDTE text varchar 11 Date of Event added in 2006 (B3) EVDTE SGLUSEFG text varchar 5 Single Use Flag (Reprocessor Flag) added in 2006 (D8) Y/N SGLUSEFG REPOCC text varchar 5 Reporter Occupation Code added in 2006 (E3) we are pursuing the codes to this field with the FDA� please contact us REPOCC HLTHPRO text varchar 5 Health Professional "according to FDA, if SCECDE = 'P', field should be null" (E2) "Y=Yes N=No U=Unknown A=Not Applicable I=No Information *=Not Provided" HLTHPRO INITRPT text varchar 5 Initial Report to FDA "according to FDA, if SCECDE = 'P', field should be null" (E4) "Y=Yes N=No U=Unknown A=Not Applicable I=No Information *=Not Provided" INITRPT DISTNME text varchar 80 Distributor Name "blank, unused" (F3) DISTNME DISTADRS text varchar 30 Distributor Address "blank, unused" (F3) DISTADRS DISADD2 text varchar 30 Distributor Address "blank, unused" (F3) DISADD2 DISCITY text varchar 30 Distributor City "blank, unused" (F3) DISCITY DISSTCDE text varchar 2 Distributor State Code "blank, unused" (F3) DISSTCDE DISZIP text varchar 5 Distributor Zip Code "blank, unused" (F3) DISZIP ZIPEXT text varchar 4 Distributor Zip Code Extension "blank, unused" (F3) ZIPEXT FACDT text varchar 11 Date Facility Aware "according to FDA, if SCECDE = 'P', field should be null" (F6) FACDT RPTTYP text varchar 3 Type of Report "multiple submissions possible, separated by ','" (F7) "I =Initial Submission F=Followup X=Extra Copy Received O=Other Information Submitted" RPTTYP RPTDT2 text varchar 11 Report Date "according to FDA, if SCECDE = 'P', field should be null" (F8) RPTDT2 FDARPT text varchar 1 Report to FDA "according to FDA, if SCECDE = 'P', field should be null" (F11) "Y=Yes N=No U=Unknown A=Not Applicable I=No Information *=Not Provided" FDARPT FDARPTDT text varchar 11 Date Report to FDA "according to FDA, if SCECDE = 'P', field should be null" (F11) FDARPTDT EVLOC text varchar 40 Event Location "according to FDA, if SCECDE = 'P', field should be null" (F12) EVLOC MNURPT text varchar 1 Report to Manufacturer "according to FDA, if SCECDE = 'P', field should be null" (F13) "Y=Yes N=No U=Unknown *=Not Provided" MNURPT MANRPTDT text varchar 11 Date Report to Manufacturer "according to FDA, if SCECDE = 'P', field should be null" (F13) MANRPTDT MANUNME text varchar 80 Maufacturer Name (F14) MANUNME MANADD text varchar 60 Manufacturer Address (F14) MANADD MANADD2 text varchar 45 Manufacturer Address (F14) MANADD2 MANCITY text varchar 40 Manufacturer City (F14) MANCITY MANST text varchar 2 Manufacturer State (F14) MANST MANZIP text varchar 5 Manufacturer Zip Code (F14) MANZIP MANZIPEXT text varchar 4 Manufacturer Zip Code Ext. (F14) MANZIPEXT MANCTRY text varchar 2 Manufacturer Country Code (F14) MANCTRY MANPOST text varchar 10 Manufacturer Postal Code (F14) MANPOST MANTITLE text varchar 4 Manufacturer Contact Title "according to FDA, only relevant where SCECDE = 'M'" (G1) MANTITLE MANFIRST text varchar 15 Manufacturer Contact First Name "according to FDA, only relevant where SCECDE = 'M'" (G1) MANFIRST MANLAST text varchar 25 Manufacturer Contact Last Name "according to FDA, only relevant where SCECDE = 'M'" (G1) MANLAST MANSTRT text varchar 60 Manufacturer Contact Street 1 "according to FDA, only relevant where SCECDE = 'M'" (G1) MANSTRT MANSTRT2 text varchar 60 Manufacturer Contact Street 2 "according to FDA, only relevant where SCECDE = 'M'" (G1) MANSTRT2 MANCITY2 text varchar 60 Manufacturer Contact City "according to FDA, only relevant where SCECDE = 'M'" (G1) MANCITY2 MANST2 text varchar 2 Manufacturer Contact State Code "according to FDA, only relevant where SCECDE = 'M'" (G1) MANST2 MANZIP2 text varchar 5 Manufacturer Contact Zip Code "according to FDA, only relevant where SCECDE = 'M'" (G1) MANZIP2 ZIPEXT2 text varchar 4 Manufacturer Contact Zip Code Ext. "according to FDA, only relevant where SCECDE = 'M'" (G1) ZIPEXT2 CTRYCODE text varchar 2 Manufacturer Contact Country Code "according to FDA, only relevant where SCECDE = 'M'" (G1) CTRYCODE POSTCODE text varchar 10 Manufacturer Contact Postal Code "according to FDA, only relevant where SCECDE = 'M'" (G1) POSTCODE AREACODE text varchar 3 Manufacturer Contact Phone No. Area CodE "according to FDA, only relevant where SCECDE = 'M'" (G1) AREACODE PHNEFRST text varchar 3 Manufacturer Contact Phone No. Exchange "according to FDA, only relevant where SCECDE = 'M'" (G2) PHNEFRST PHNELAST text varchar 4 Manufacturer Contact Phone No. "according to FDA, only relevant where SCECDE = 'M'" (G2) PHNELAST PHNEEXT text varchar 5 Manufacturer Contact Phone Ext. "according to FDA, only relevant where SCECDE = 'M'" (G2) PHNEEXT PHNECDE text varchar 3 Manufacturer Contact Phone No. Country Code "according to FDA, only relevant where SCECDE = 'M'" PHNECDE CITYCDE text varchar 6 Manufacturer Contact Phone No. City Code "according to FDA, only relevant where SCECDE = 'M'" CITYCDE LOCPHNE text varchar 10 Manufacturer Contact Phone No. Local "according to FDA, only relevant where SCECDE = 'M'" LOCPHNE MANNME text varchar 80 Manufacturer G1 Name "according to FDA, only relevant where SCECDE = 'M'" (G1) MANNME MANSTRT3 text varchar 50 Manufacturer G1 Street 1 "according to FDA, only relevant where SCECDE = 'M'" (G1) MANSTRT3 MANSTRT4 text varchar 50 Manufacturer G1 Street 2 "according to FDA, only relevant where SCECDE = 'M'" (G1) MANSTRT4 MANCITY3 text varchar 40 Manufacturer G1 City "according to FDA, only relevant where SCECDE = 'M'" (G1) MANCITY3 MANST3 text varchar 2 Manufacturer G1 State Code "according to FDA, only relevant where SCECDE = 'M'" (G1) MANST3 MANZIP3 text varchar 5 Manufacturer G1 Zip Code "according to FDA, only relevant where SCECDE = 'M'" (G1) MANZIP3 ZIPEXT3 text varchar 4 Manufacturer G1 Zip Code Ext. "according to FDA, only relevant where SCECDE = 'M'" (G1) ZIPEXT3 CTRYCDE text varchar 2 Manufacturer G1 Country Code "according to FDA, only relevant where SCECDE = 'M'" CTRYCDE POSTCDE text varchar 10 Manufacturer G1 Postal Code "according to FDA, only relevant where SCECDE = 'M'" POSTCDE SOURCE text varchar 30 Source Type "according to FDA, only relevant where SCECDE = 'M'" (G3) "00 Other 01 Foreign 02 Study 03 Literature 04 Consumer 05 Health Professional 06 User Facility 07 Company Rep. 08 Distributor 99 Unknown * Invalid Data" SOURCE DTEREC text varchar 11 Date Manufacturer Received "according to FDA, only relevant where SCECDE = 'M'" (G4) DTEREC MANDTE text varchar 10 Device Date of Manufacture "according to FDA, if SCECDE = 'P', field should be null" (H4) MANDTE SGLUSE text varchar 1 Single Use Flag "according to FDA, if SCECDE = 'P', field should be null" (H5) "Y=Yes N=No *=Not Provided" SGLUSE REMACT text varchar 2 Remedial Action "multiple source type, separated by ',' according to FDA, if SCECDE = 'P', field should be null" (H7) "RC=Recall RP=Repair RL=Replace RB=Relabeling OT=Other NO=Notification IN=Inspection PM=Patient Monitoring MA=Modification/Adjustment *=Invalid Data" REMACT PREVCDE text varchar 1 Previous Use Code "according to FDA, if SCECDE = 'P', field should be null" (H8) PREVCDE REMNO text varchar 24 Removal/Correction Number "according to FDA, if SCECDE = 'P', field should be null" (H9) REMNO EVTYPE text varchar 15 Event Type "according to FDA, only relevant where SCECDE = 'M'" (H1) "D=Death IN=Injury IL=Injury IJ=Injury M=Malfunction O=Other *=No Answer Provided" EVTYPE NICAR_DEVNO number int "NICAR created field (""number of devices"" from character to numeric)" NDEVNO NICAR_PATNO number int "NICAR created field (""number of patients"" from character to numeric)" NPATNO NICAR_DATEREC date date "NICAR Created (""date received"" from character to date/time)" NDATEREC NICAR_RPTDT date date "NICAR Created (""date report"" from character to date/time)" NRPTDT NICAR_FACDT date date "NICAR Created (""date facility aware"" from character to date/time)" NFACDT NICAR_RPTDT2 date date "NICAR Created (""report date"" from character to date/time)" NRPTDT2 NICAR_FDARPT date date "NICAR Created (""report date to FDA"" from character to date/time)" NFDARPT NICAR_MANDT date date "NICAR Created (""report date to manu."" from character to date/time)" NMANDT NICAR_DTEREC date date "NICAR created (""date manu. received"" from character to date/time)" NDTEREC NICAR_MANDTE date date "NICAR created (""device date of manu."" from character to date/time)" NMANDTE NICAR_EVDTE date date "NICAR created (""date of event"" from character to date/time)" NICARID number mediumint