applic dt

application
date

DATE

Actual date when pesticide was applied to the sample, if known.

Some samples do not have this information.

Must be a valid month/day/year.

chem code

chemical name

The chemical name of any residue detected. Designated "NONE" if none detected.

Name of chemical is based on codes from department-wide master chemical table.

Must be a valid chemical code as found in the department-wide master chemical table.

commodity

commodity

Name of commodity collected for sampling.

Reference used is the FDA commodity.

county cd

county code

CHAR(2)

2 digit numeric code assigned to each county within the State of California.

Derived from County Code Table. Indicates who is responsible for collecting sample. Not always applicable.

Must be a valid county code found in the County Code Table. Must be 01 through 58.

detect cd

detection code

NUMBER(8)

This code designates what kind of detector or detection system was used.

Each laboratory uses this field and assigns the detection code value.

Numeric 8 field.

detect limit

detection limit

DECIMAL(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.

dist cd

district code

NUMBER(1)

The District Code is assigned to each Enforcement regional office. Each region is given a single digit code.

Current district codes are: 0=County, 1=Berkeley, 2=Anaheim, 3=Fresno, 4=Sacramento, 5=Richmond

Must be a valid district code. Current valid values are 0 through 5.

extract cd

extraction code

NUMBER(8)

This extraction code is used as a 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 the California Department of Food and Agriculture's. extraction method.

harv dt

harvest date

DATE

Actual date of harvest.

Some samples do not have this information.

Must be a valid month/day/year.

lab cd

lab code

NUMBER(2)

1 digit Laboratory Code assigned to each chemical lab. Designates which lab conducted the analysis.

Current codes are: 1=Berkeley, 2=Anaheim, 3=Fresno, 4=Sacramento, 5=Richmond

Must be a valid laboratory code. Current valid values are 1 through 5.

lab no

lab 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.

organic cd

organic code

NUMBER(1)

Check box used to indicate whether the produce is organically grown. 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

origin cd

origin code

CHAR(3)

Origin code is used to indicate the state or foreign country in which the commodity was grown.

3 Position Alpha-Numeric code. Valid codes are those found only in the master Origin Table.

pest applied

pesticide applied

VARCHAR2(50)

Pesticide applied to the sample. Include information obtained from a Pesticide Use Report or on the packed container, or from other sources.

Some samples do not have this information; usually not associated with Marketplace Program samples.

Maximum of 50 alpha-numeric description. Must be a valid chemical found in master chemical table.

program

program

Indicates under what type of state program this sample was obtained.

During 1999, the Priority Program was merged with the Marketplace Program.

Check boxes in database indicating state programs (for instance, Marketplace, Priority, Investigational, Preharvest)

residue

residue amount

DECIMAL(10,7)

The amount of residue detected on this particular sample.

Default value is 0. Valid values are .0000001 to 9999.

sample dt

sample date

DATE

The date which the sample was collected.

Format is: dd-mon-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 no.

sample size

sample size

VARCHAR2(20)

The required amount of produce to sample. This is the size of the sample taken.

AlphaNumeric.

site cd

sample site

NUMBER(1)

Type of location from which the sample was gathered. For instance: Wholesale, Chain Store Distribution Center, Retail, Point of Entry, and Point of Origin.

tolerance

chemical tolerant amount

DECIMAL(10,7)

Is the legal amount of chemical which can be found on a commodity and these tolerances can be found in 40CFR180 (Code of Regulations Section 180), and at U.S. EPA's Pesticide Tolerance site.

Before a pesticide can be legally used on a crop, the US EPA must establish 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.