Data Dictionary
Back to Residue Monitoring Program
| Column | Synonym | Data Type | Description | Notes | Validation |
|---|---|---|---|---|---|
| AMOUNT OF CHEMICAL DETECTED (PPM) | See "RESIDUE_AMT" | ||||
| ANALYSIS TYPE | See "SCREEN_DESC" | ||||
| APPLIC_DT | Application Date | DATE | Actual date when a pesticide was applied, if known. | Some samples do not contain this information, it is not required. | Must be a valid month/day/year |
| BRANDNAME (OR BRAND NAME) | Brand Name | VARCHAR(50) | Brand name of commodity found on container sampled. This includes all additional information such as count, net weight, number of bunches, or other distribution characteristics (e.g. 18 lbs., 24 ct., 12 bunches, etc.) | AlphaNumeric. | |
| CHEMICAL GROUPS TESTED | Chemical groups tested | VARCHAR(50) | Indicates the types of chemical categories for which the sample was analyzed. | See "SCARBA", SCHLOR", "SORGANO" | |
| CHEMICAL DETECTED | (See "CHEMNAME") | ||||
| CHEMNAME | Chemical name | VARCHAR2(170) | Indicates the name of the chemical found during the laboratory analysis. | If no chemicals were found during the analysis, then "NO RESIDUE FOUND" is indicated. | AlphaNumeric. |
| COLLECTION SITE LOCATION | See "COL_SITE_CITY" | ||||
| COLLECTION SITE NAME | See "COL_SITE_NAME" | ||||
| COLLECTION SITE TYPE | Collection Site Type | Type of location from which the sample was gathered (for instance: Chain Store Distributor, Wholesale, Retail, Farmer's Market, etc). | See "SS_CHNDIST" thru "SS_OTHER" | ||
| COL_SITE_CITY | Collection Site location | VARCHAR2(50) | The physical location where the sample ws collected. | Required information | AlphaNumeric. |
| COL_SITE_NAME | Collection Site Name | VARCHAR2(50) | The name of the facility where the specific sample was collected. | Required information | AlphaNumeric. |
| COMMODITY | See "SITE_NAME" | ||||
| COUNTY_CD | County Code | CHAR(2) | 2 digit numeric code assigned to each county within the State of California, and who was responsible for collecting the sample, IF APPLICABLE (see Notes). | Only applies to data before 2000, when the Priority Program was still in use, and only applies to those samples taken by County Agricultural Commissioners offices. | |
| DETECT_CD | Detection Code | NUMBER(4) | This code designates what kind of detector or detection system was used during the analysis of this sample. | Each laboratory uses this field and assigns the detection code value. | |
| DETECT_LIMIT | Detection Limit | NUMBER(10.7) | The lowest reading that an instrument can give for a given compound. This detection limit can be different for every chemical. | This value depends on the type of equipment and methodology used in each laboratory. | Numeric |
| DIST_CODE | District Code | NUMBER(1) | This code is assigned to each of the Enforcement Branch's regional offices, each one given a single digit code. This is not used much in recent years (since 2002 or 2003), instead the DIST_NAME is used (see below). | Codes are: 0=County, 1=Berkeley, 2=Anaheim, 3=Fresno, 4=Sacramento, 5=Richmond | Must be a valid district code, valid values are 0 through 5. |
| DIST_NAME | District Name | The Department of Pesticide Regulation's regional office that collected the sample | NRO=Northern Regional Office; CRO=Central Regional Office; SRO=Southern Regional Office | ||
| EXTRACT_CD | Extraction Code | NUMBER(4) | This code is used as an reference for the method of extraction. The Federal Food and Drug Administration and each laboratory uses this field and assigns the proper extraction code value. For instance, "9999" means the method comes from California. | ||
| GROWER LOCATION | Grower Location | CHARACTERS | City/state/country where the grower of the commodity is located (where it originated). | ||
| HARV_DT | Harvest Date | DATE | Actual date of harvest. This information has not been used since 2001 data. | Some samples do not have this information, is not required. | Must be a valid month/day/year |
| ILLEGAL CASE NO. | Illegal Case Number, T Case Number | Number assigned to a sample when, during the analysis, the amount of a chemical found is over the legal limits, or there has been no tolerance limit established for that chemical | If a sample is found to be "illegal", an investigation begins. Number begins with a "T", which represents "Tracking" | ||
| LAB_CD | Laboratory Code | NUMBER(2) | 1 digit code assigned to each chemical lab. Designates which lab conducted the analysis (some are no longer valid in recent years) | Codes are: 1=Berkeley, 2=Anaheim, 3=Fresno, 4=Sacramento, 5=Richmond | Must be a valid laboratory code, valid values are 1 through 5. |
| LAB_NAME | Laboratory Name | CHARACTERS | Name of the laboratory that performed the analysis | NRO=Northern Regional Office lab; CRO=Central Regional Office lab; SRO=Southern Regional Office lab | |
| LAB_NO | Laboratory Number | NUMBER(8) | The Lab Number is a number assigned by each laboratory conducting the analysis. It is a unique identifier. | Each laboratory has its own consecutive numbering system. Numbers change each calendar year. | Must be numeric. |
| MINIMUM DETECTION LIMIT | See "DETECT_LIMIT" | ||||
| ORGANIC | See "ORGANIC_CD" | Indicates whether or not a sample was organically grown. | |||
| ORGANIC_CD | Organic Code | NUMBER(1) | Check box used to indicate whether the produce is organically grown. A "1" indicated is the same as a "Yes". Information for 1996 forward only. | Source is Produce Sample Analysis Report, is displayed as a check box on the data entry screen. Checked=yes, unchecked=no | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| ORIG_NAME | Origin Name | Indicates the state or foreign country in which the commodity was grown. | See: Origin Table on web site Residue Monitoring Page | ||
| PEST_APPLIED | Pesticide Applied | VARCHAR2(50) | Pesticide applied to the sample. Includes information obtained from a Pesticide Use Report or on the packed container, or from other sources. This has not been used since 1995 data. | Some samples do not have this information, usually not associated with Marketplace Surveillance Program samples. | Must contain a valid chemical found in master chemical table. |
| PROGRAM_TYPE | Program Type | The name of the Sampling Program under which the sample was gathered. | See "SP_FOLLOWUP" thru "SP_SPECSURV" for further info | ||
| RESIDUE_AMT | Residue Amount | NUMBER(10.7) | The amount of residue detected on this particular sample. | Default value is 0. Valid values are .000001 to 9999. | |
| SAMPLE DATE | See "SAMPLE_DT" | ||||
| SAMPLE_DT | Sample Date | DATE | The date which the sample was collected | Format is: dd-mo-yy. Mandatory field | Must be a valid calendar date. The Sample Date Year must be greater than 1989 |
| SAMPLE_NO | Sample Number | CHAR(9) | A unique number given to each sample by the sample collector. | Must include field inspector's initials followed by the number of this sample. | Unique identifier along with Lab. Number |
| SAMPLE_SIZE | Sample Size | VARCHAR2(20) | The required amount of produce to sample. This is the size of the sample taken. | AlphaNumeric. | |
| SAMPLE TYPE | Collection Site Type | Type of location from which the sample was gathered (for instance: Chain Store Distributor, Wholesale, Retail, Farmer's Market, etc). | See "SS_CHNDIST" thru "SS_OTHER" and (beginning with 2007 data) COLLECTION SITE TYPE | ||
| SCARBA | Carbamate screening | NUMBER(1) | Indicates whether (or not) this sample was tested for carbamates. Part of the Basic Screening process | If a "1" is noted, the sample was tested for carbamates. | Numeric |
| SCHLOR | Chlorinated Hydrocarbon screening | NUMBER(1) | Indicates whether (or not) this sample was tested for chlorinated hydrocarbons. Part of the Basic Screening process. | If a "1" is noted, the sample was tested for chlorinated hydrocarbons. | Numeric |
| SCREEN_DESC | Screen Description | The type of screening process (analysis) under which this sample was tested. | "Basic Screening": Sample run through three basic chemical screens (e.g. tested for organophosphates, chlorinated hydrocarbons and carbamates). "Specific Testing": Sample was tested for a specific chemical only. | AlphaNumeric. | |
| SITE_CD | Site Code | Type of location from which the samples was gathered (for instance, Wholesale, Chain Store Distribution Center, Retail, Point of Entry, etc.) | |||
| SITE_NAME | Commodity | Name of commodity collected for sampling | Reference used is the FDA commodity | ||
| SORGANO | Organophosphate screening | NUMBER(1) | Indicates whether (or not) this sample was tested for organophosphates. | If a "1" is noted, the sample was tested for organophosphates. | Numeric |
| SP_FOLLOWUP | Followup Program | NUMBER(1) | Type of State Program under which the particular sample falls. | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked | |
| SP_INVEST | Investigational Program | NUMBER(1) | Samples are taken because of an ongoing investigation; are followups to previous Marketplace Surv. Samples that may be a problem. A "1" indicates this is an Investigational Program Sample | Type of State Program under which the particular sample falls. | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SP_MKTSRV | Marketplace Surveillance Program | NUMBER(1) | Samples are taken from mostly channels of trade (i.e., retail markets, wholesale markets, chain store distribution centers). A "1" indicates this is a Marketplace Surv. Program sample | Type of State Program under which the particular sample falls. | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SP_OTHER | Other Program | NUMBER(1) | If a sample does not fall under any of the typical State Program sampling, then it fall under this category and a description is noted in SP_OTHERDESC, | Type of State Program under which the particular sample falls. | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SP_OTHERDESC | Description of "Other Program" | NUMBER(1) | Description of the type of SP_OTHER sampling (above). | Type of State Program under which the particular sample falls. | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SP_PREHARV | Preharvest Program | NUMBER(1) | Samples are taken prior to harvesting of the specific commodity (e.g., from the field). This program is not used after 1996 sampling and then falls under the Marketplace Surveillance Program | Type of State Program under which the particular sample falls. | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SP_PRIORITY | Priority Pesticides Program | NUMBER(1) | A sample collected by the County Agricultural Commissioner (CAC) under contract. It is usually for a specific purpose. This program has not been used since 2000 data. | Type of State Program under which the particular sample falls. | |
| SP_RESAMPLE | Resample Program | NUMBER(1) | If a previously taken sample is in question, another sample is taken and analyzed. This program has not been used since 1996 data. | Type of State Program under which the particular sample falls. | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SP_SPECSURV | Special Survey Program | NUMBER(1) | Samples collected of commodities specifically designated by DPR for data collection. This program has not been used since 1996 data. | Type of State Program under which the particular sample falls. | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SPECIFIC | Specific Analysis | NUMBER(1) | Indicates that this sample was not run through the Basic Screening process, but was analyzed for a specific chemical only. | If a "1" is noted, the sample was tested for a specific chemical. | Numeric |
| SS_CHNDIST | Chain Distribution Sample Site | NUMBER(1) | Sample was collected from a Chain Store Distributor | Type of location from which the sample was gathered (for instance: Chain Store Distributor, Wholesale, Retail, Farmer's Market, etc). | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SS_FARMSMKT | Farmers Market Sample Site | NUMBER(1) | Sample was collected from a Farmer's Market | Type of location from which the sample was gathered (for instance: Chain Store Distributor, Wholesale, Retail, Farmer's Market, etc). | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SS_FIELD | Field Sample Site | NUMBER(1) | Sample was collected in the field, before it reached channels of trade. | Type of location from which the sample was gathered (for instance: Chain Store Distributor, Wholesale, Retail, Farmer's Market, etc). | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SS_OTHERDESC | "Other" Description | NUMBER(1) | See SS_OTHERDESC | Type of location from which the sample was gathered (for instance: Chain Store Distributor, Wholesale, Retail, Farmer's Market, etc). | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SS_PACKSHED | Packing Shed Sample Site | NUMBER(1) | Sample was collected from a Packing Shed of some sort. | Type of location from which the sample was gathered (for instance: Chain Store Distributor, Wholesale, Retail, Farmer's Market, etc). | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SS_PRSPLANT | Processing Plant Sample Site | NUMBER(1) | Sample was collected from a Processing Plant (for instance, a tomato processing plant) | Type of location from which the sample was gathered (for instance: Chain Store Distributor, Wholesale, Retail, Farmer's Market, etc). | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SS_PTENTRY | Point of Entry Sample Site | NUMBER(1) | Sample was collected from where a foreign commodity first enters the U.S. through California (for example: border stations, airports, seaports) | Type of location from which the sample was gathered (for instance: Chain Store Distributor, Wholesale, Retail, Farmer's Market, etc). | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SS_PTORIGIN | Point of Origin Sample Site | NUMBER(1) | This usually applies to samples taken from a field, or a packing shed. This designation has not been used since 1996 data. | Type of location from which the sample was gathered (for instance: Chain Store Distributor, Wholesale, Retail, Farmer's Market, etc). | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SS_RETAIL | Retail Sample Site | NUMBER(1) | Sample was collected from a Retail outlet (for instance, Safeway, Albertson's) | Type of location from which the sample was gathered (for instance: Chain Store Distributor, Wholesale, Retail, Farmer's Market, etc). | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SS_ROADSTAND | Roadside Stand Sample Site | NUMBER(1) | Sample was collected from a Roadside Stand | Type of location from which the sample was gathered (for instance: Chain Store Distributor, Wholesale, Retail, Farmer's Market, etc). | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SS_WHSLE | Wholesale Sample Site | NUMBER(1) | Sample was collected from a Wholesaler | Type of location from which the sample was gathered (for instance: Chain Store Distributor, Wholesale, Retail, Farmer's Market, etc). | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| SS-OTHER | "Other" Sample Site | NUMBER(1) | Sample was collected from some "other" site that what has already been described. | Type of location from which the sample was gathered (for instance: Chain Store Distributor, Wholesale, Retail, Farmer's Market, etc). | Numeric. Must be 0 or 1(Boolean).0=Unchecked, 1=Checked |
| STATE/COUNTRY OF ORIGIN | See "ORIG_NAME" | ||||
| TOLERANCE LEVEL (PPM) | See "TOLERANT_AMT" | ||||
| TOLERANT_AMT | Tolerance | NUMBER(10.7) | Is the legal amount of chemical which can be found on a commodity and these tolerances can be found in the Code of Federal Regulations (40CFR), Section 180. | Before pesticides can be legally used on a crop, the US EPA must adopt a tolerance or grant an exemption from tolerance. The tolerance is the highest residue level of the particular pesticide which is allowed on the particular commodity. | Numeric |