TRAC's Federal Prosecutors Database:
Data Dictionary (in alphabetic order)

ACCTFIDT: Accounting system filed date. Comparable to CASEDT but represents date case filing was entered in the accounting system.
ACCTREDT: Accounting system received date. Comparable to MATTDT but represents date this receipt was entered in the accounting system.
ACCTTEDT: Accounting system closed date. Comparable to DEFDISDT but represents date disposition was entered in the accounting system.
AGPRIOR: The priority assigned the referral by the national office or the local U.S. Attorney. See Appendix C for a detailed listing of these agency priority codes.
APPEAL: Record concerns a case that is on appeal. Coded 1 if an appeal, 0 otherwise. A record is classified as an appeal when APPEALTP is coded: A, AFJ, I or INT.
APPEALTP: An entry in this field indicates that this case is on appeal, rather than still at the trial court level. The field is blank otherwise. Typically, when an appeal occurs, a separate tracking record is included that relates only to the appeal. The specific codes indicate the type of appeal involved:

A	Appeal from final judgment
AFJ	Appeal from final judgment
I	Interlocutory appeal
INT	Interlocutory appeal
U	Underlying case in an appeal

ARRESTDT: Date of arrest, if applicable. This is an optional field which is often not recorded. For example, a code of "940316" indicates that the arrest was March 16, 1994.
AUSA: The initials of the assistant United States attorney handling the referral.
BONDAMOU: Amount of bond. Measured in dollars and cents.
BONDTYPE: Type of bond. Specific codes are:

CB	Cash bond
CD	10% case deposit
CO	Collateral (Real or personal property)
PS	Personal recognizance (Unsecured appearance bond)
SU	Surety

CASEDT: The date on which the case was filed in court. This field is blank if a case was not filed, or has not yet been filed. The Justice Department's tracking system does not treat matters brought before magistrates as "cases", and hence for these, this field will also be blank. Similar to the format for other date fields, a code of "940316" indicates that the referral was received on March 16, 1994.
CFCF: This field is coded "1" if the case was recorded as filed in court during the current fiscal year, and is blank otherwise. For referrals with multiple defendants, only the first defendant in the case is coded "1". This provides a convenient "counter" for determining the number of new case filings as distinct from the number of defendants covered by these new prosecutions. (See also CFRF). This field is used by the Justice Department in compiling its statistics. Counts reflect not the actual fiscal year in which the case was filed, but the fiscal year the case filing was entered into the Justice Department's computer accounting system. Thus, some "new" case filings may actually have occurred before the current fiscal year, but did not show up in Justice's computer system until the current year.
CFRF: Coded similarly to CFCF (see above) but for referrals with multiple defendants, each defendant in the case is coded "1". This provides a convenient "counter" for determining the number of defendants covered by these new prosecutions.
COMPLDT: Date of complaint. For example, a code of "940316" indicates that the date was March 16, 1994.
CPCF: This field is coded "1" if the case was recorded as pending at the end of the current fiscal year, and is blank otherwise. For referrals with multiple defendants, only the first defendant in the case is coded "1". This provides a convenient "counter" for determining the number of pending cases as distinct from the number of defendants covered by these prosecutions. (See also CPRF). This field is used by the Justice Department in compiling its statistics. Counts reflect not the actual dates, but the status of the matter at the end of the fiscal year as reflected in the Justice Department's computer accounting system. Thus, some "pending" cases may actually have concluded before the end of the current fiscal year, but have not yet shown up in Justice's computer system.
CPRF: Coded similarly to CPCF (see above) but for referrals with multiple defendants, each defendant in the case is coded "1". This provides a convenient "counter" for determining the number of defendants covered by these pending prosecutions.
CRICF: Criminal trial record flag. This field is coded "1" if the case was disposed of through a criminal trial during the current fiscal year, and is blank otherwise. For cases with multiple defendants, only the first defendant in the case is coded "1". This provides a convenient "counter" for determining the number of criminal trials as distinct from the number of defendants covered by these trials. (See also CRICF). This field is used by the Justice Department in compiling its statistics. Counts reflect not the actual fiscal year in which the trial occurred, but the fiscal year the event was entered into the Justice Department's computer accounting system. Thus, some trials may actually have occurred before the current fiscal year, but did not show up in Justice's computer system until the current year.
CRILDCGE: The title and section in the U.S. Code of the lead charge. May include subsections. See also STATCODE.
CRIRF: Coded similarly to CRICF (see above) but for referrals with multiple defendants, each defendant in the case is coded "1". This provides a convenient "counter" for determining the number of defendants covered by these criminal trials
CRTTYPE: The type of court in which the case was filed:

BC	Bankruptcy
CA	Court of Appeals
CC	U.S. Claims Court
DC	U.S. District Court
MG	Magistrate Court
NC	not in court
SC	U.S. Supreme Court
ST	State Court
TC	Tax Court
UN	Unknown

CTCF: This field is coded "1" if the case was completed (typically at the trial court level) during the current fiscal year, and is blank otherwise. For referrals with multiple defendants, only the first defendant in the case is coded "1". This provides a convenient "counter" for determining the number of new case completions as distinct from the number of defendants covered by these prosecutions. (See also CTRF). This field is used by the Justice Department in compiling its statistics. Counts reflect not the actual fiscal year in which the case was completed, but the fiscal year the completion status was entered into the Justice Department's computer accounting system. Thus, some "new" case completions may actually have occurred before the current fiscal year, but did not show up in Justice's computer system until the current year.
CTRF: Coded similarly to CTCF (see above) but for referrals with multiple defendants, each defendant in the case is coded "1". This provides a convenient "counter" for determining the number of defendants covered by these prosecutions.
DEC: Current Declination. Coded 1 if the referral was disposed of during the current year by means other than prosecution, 0 otherwise Derived from MTRF, except: (a) disposals after prosecutions in Magistrate Court are coded 0, and (b) records pertaining to an appeal are coded 0. This field was used in computing counts of declinations on TRAC's web sites.
DEFDISDT: The date on which the referral is finally disposed of, whether by a decision of the U.S. Attorney not to prosecute the case or by completion of the prosecution (typically at the trial court level). This field is blank if the referral has not yet been disposed of. Similar to the format for other date fields, a code of "940316" indicates that the referral was received on March 16, 1994.
DEFDISP: The type of disposition. For example, a code of "DE" indicates the referral was declined, while a code of "GT" indicates that the defendant was found guilty. See Appendix E for a detailed listing of disposition type codes.
DEFDISRS: This field in conjunction with the type of disposition provides a more detailed explanation of the nature of, or reason for, the disposition. For example, a code of "DEPO" indicates prosecution was declined because of "department policy", while a code of "LECI" indicates the matter was not prosecuted because of a "lack of evidence of criminal intent". On the other hand, a code of "PLED" indicates that the defendant entered a plea of guilty. See Appendix F for a detailed listing of disposition reason codes.
DEFNUM: Sequence number assigned to defendants within the same matter or case. The first defendant is assigned a code of "001", the second is assigned a code of "002", and so forth. Since defendants involved in the same matter or case appear next to each other in the file, this field is useful in grouping defendants that the US Attorney offices are handling as a single referral or court case. (Justice Department withheld beginning with the fiscal 1994 files).
DEFSTAT: Code indicating defendant status or activity. The specific codes are:

AF	Serving in armed forces
AS	Adult study
BO	Bond
CU	Custody
FU	Fugitive
IN	In mental institution
JS	Juvenile study
MO	Mental observation
NS	Not served
OT	Other
PD	Pretrial diversion
PG	Convicted-Deft. to pay restitution to U.S. Government
PN	Convicted-Deft. to pay restitution to non-Fed. Party
SS	Serving sentence
UN	Defendant unkown
YS	FYCA study
PR	Property in a Criminal Forfeiture

DEFSTDT: The date to which DEFSTAT pertains. For example, a code of "940316" indicates that the status was relevant to March 16, 1994.
DIS: Current Disposition. Coded 1 if the referral was disposed of during the current year. Derived from MTRF and CTRF except that records pertaining to an appeal are coded 0. This field was used in computing counts of dispositions on TRAC's web sites.
DISTRICT: Name of United States Attorney Office (federal judicial district). See Appendix A for listing.
DOJDIV: Department of Justice Division involved. Specific codes are:

ANTI	Antitrust
CIVL	Civil
CIVR	Civil Rigts Divison
CRIM	Criminal
LAND	Environmental and Natural Resources Divison
SOLG	Solicitor General
TAXD	Tax
ZBOP	Bureau of Prisons (valid for collections only)
ZNTF	Narcotics Task Force (Organized Crime Drug Enforcement Task Force)
ZCIF	Central Intake Facility

ESTLOSS: Estimated amount of loss arising from the offense. Measured in dollars and cents. Optional field which is often not entered.
EVNT: Code indicating event (status) in processing referral. Appendix G provides a listing of defined codes.
EVNTACT: Code indicating the event activity. The specific codes are:

AM	Amended
AN	Answered
CF	Case Finding
CM	Commenced
CN	Continued
CP	Completed
DI	Dismissed, Involuntary
DN	Denined
DV	Dismissed, Voluntary
FI	Filed
GR	Granted
LO	Local Use (for mapping purposed only)
RV	Received
SD	Sentence Decision
ST	Sent
SV	Served
TK	Tickler (collection ONLY)
TS	Trail sentence

EVNTDATE: The date to which EVNT pertains. For example, a code of "940316" indicates that the event was relevant as of March 16, 1994.
FIL: Current Prosecution. Coded 1 if the prosecution was filed during the current year, 0 otherwise. Derived from CFRF except: (a) disposals after prosecution in Magistrate Court are included (coded 1), and (b) records pertaining to an appeal are coded 0. This field was used in computing counts of prosecutions on TRAC's web sites.
FINE: Amount of fine imposed if current conviction , measured in dollars. A value of 0 is assigned if no fine was imposed. This field is left missing if it is not a current conviction, or if sentence information was not recorded. This field was used in computing average and median fine amounts on TRAC's web sites.
FINEAMNT: Amount of fine. Character field measured in dollars and cents.
FINESUSP: Amount of suspended fine. Measured in dollars and cents.
FY: Fiscal year. For example, fiscal year 1994 is coded "94".
GUI: Current Conviction. Coded 1 if defendant convicted during the current year, 0 otherwise. Derived from combination of DEFDISP, MTRF and CTRF fields. Records pertaining to an appeal are always coded 0. This field was used in computing counts of convictions on TRAC's web sites.
ICF: Indictment record flag. This field is coded "1" if an indictment was returned during the current fiscal year, and is blank otherwise. For cases with multiple defendants, only the first defendant in the case is coded "1". This provides a convenient "counter" for determining the number of new cases where indictments were brought as distinct from the number of defendants covered by these new indictments. (See also IRF.) This field is used by the Justice Department in compiling its statistics. Counts reflect not the actual fiscal year in which the indictment was returned, but the fiscal year the event was entered into the Justice Department¹s computer accounting system. Thus, some "new" indictments may actually have occurred before the current fiscal year, but did not show up in Justice's computer system until the current year.
INCARC: Length of prison sentence. May be coded in months or years. Letter code following the number indicates which: M for months, Y for years. See also TIME.
INCARCSU: Length of suspended prison sentence. May be coded in months or years. Letter code following the number indicates which: M for months, Y for years.
INVEAGEN: A code indicating the investigating agency which referred the matter to the U.S. Attorney. For example, the FBI within the Justice Department, is coded JUFB. See Appendix D for a detailed listing of these agency codes.
IRF: Coded similarly to ICF (see above) but for referrals with multiple defendants, each defendant in the case is coded "1". This provides a convenient "counter" for determining the number of defendants covered by these new indictments.
JDG: The initials of the judge who has been assigned the case.
LITRESP: The office that has responsibility for handling the case:

AG	case handled by other federal agency or non-DOJ
DJ	case handled exclusively by Department of Justice
OC	case handled exclusively by Organized Crime Strike Force
SA	case shared by other federal agency or non-DOJ organization
SD	case shared by DOJ and U.S. Attorney¹s Office
SO	case shared by U.S. Attorney¹s Office and Organized Crime Strike Force
SU	criminal matters and cases involving stolen and counterfeit securities; DOJ supervision
US	case handled exclusively by U.S. Attorney¹s Office

LITTYPE: Code indicating litigant type. For example, a code of "D" indicates "Defendant". Defined codes are as follows:

A	Amicus
B	Bankrupt
C	Class
CD	Cross Claimant Defendant
CL	Claimant
CP	Cross Claimant Plaintiff
D	Defendant (Debtor)
FB	Filing on behalf of
GA	Guardian AD Litem
I	Intervenor
LD	Counter Claimant Defendant
LP	Counter Claimant Plaintiff
MW	Material Witness
OT	Other
P	Plaintiff
PR	Property
TD	Third Party Defendant
TP	Third Party Plaintiff
VI	Victim

MATTDT: The date on which the referral was received by the U.S. Attorney's office. For example, a code of "940316" indicates that the referral was received on March 16, 1994.
MPMF: This field is coded "1" if the matter was recorded as pending at the end of the current fiscal year and is blank otherwise. For referrals with multiple defendants, only the first defendant in the matter is coded "1". This provides a convenient "counter" for determining the number of pending referrals as distinct from the number of defendants covered by these referrals. (See also MPRF.) This field is used by the Justice Department in compiling its statistics. Counts reflect not the actual dates, but the status of the matter at the end of the fiscal year as reflected in the Justice Department¹s computer accounting system. Thus, some "pending" matters may actually have been concluded by the end of the current fiscal year but did not yet show up in their computer system.
MPRF: Coded similarly to MPMF (see above) but for referrals with multiple defendants, each defendant in the matter is coded "1". This provides a convenient "counter" for determining the number of defendants covered by these pending referrals.
MRMF: This field is coded "1" if the matter was recorded as received during the current fiscal year and is blank otherwise. For referrals with multiple defendants, only the first defendant in the matter is coded "1". This provides a convenient "counter" for determining the number of new referrals as distinct from the number of defendants covered by these new referrals. (See also MRRF.) This field is used by the Justice Department in compiling its statistics. Counts reflect not the actual fiscal year in which the matter was received, but the fiscal year the matter was entered into the Justice Department's computer accounting system. Thus, some "new" matters may actually have been received before the current fiscal year but did not show up in their computer system until the current year.
MRRF: Coded similarly to MRMF (see above) but for referrals with multiple defendants, each defendant in the matter is coded "1". This provides a convenient "counter" for determining the number of defendants covered by these new referrals.
MTMF: This field is coded "1" if the matter was recorded as terminated during the current fiscal year, and is blank otherwise. For referrals with multiple defendants, only the first defendant in the matter is coded "1". This provides a convenient "counter" for determining the number of new matter terminations as distinct from the number of defendants covered by these terminations. (See also MTRF.) This field is used by the Justice Department in compiling its statistics. Counts reflect not the actual fiscal year in which the matter was terminated, but the fiscal year the termination status was entered into the Justice Department's computer accounting system. Thus, some "new" terminations may actually have occurred before the current fiscal year but did not show up in Justice's computer system until the current year.
MTRF: Coded similarly to MTMF (see above) but for referrals with multiple defendants, each defendant in the matter is coded "1". This provides a convenient "counter" for determining the number of defendants covered by matters terminated during that fiscal year.
NGUI: Current disposition after prosecution where defendant was not convicted. Coded 1 if not guilty, 0 otherwise. Derived from combination of DEFDISP, MTRF and CTRF fields. Records pertaining to an appeal are always coded 0. This field was used in computing the number of defendants not guilty after prosecution on TRAC's web sites.
OFFENSDT: Date of the offense. This is an optional field which is often not recorded. For example, a code of "940316" indicates that the offense occurred March 16, 1994.
PRI: Current conviction sentenced to prison. Coded 1 if prison sentence was received, 0 otherwise. Derived from combination of MTRF, CTRF, and prison sentence information. Records pertaining to an appeal are always coded 0. This field was used in computing the number of defendants sentenced to prison terms on TRAC's web sites.
PROB: Probation sentence months if current conviction. A value of 0 is assigned if no probation sentence was given. This field is left missing if it is not a current conviction, or if no sentence information was recorded. This field was used in computing average and median probation sentence on TRAC's web sites.
PROBATIO: Length of probation sentence. May be coded in months or years. Letter code following the number indicates which: M for months, Y for years. See also PROB.
PROG: The general program category of the lead charge:

Civil rights

Civil rights violations, including those under Title 18 USC 241 and 242 and the Civil Rights Act of 1968.

Drug addendum

Project Triggerlock prosecutions (OCDETF) which would otherwise be classified as a Narcotics Task Force case under the narcotics/drugs general program category. [The Federal Prosecutors Criminal Core Series groups this category with narcotics/drugs.]

Government regulation

Counterfeiting of U.S. currency or securities, customs violations relating to payment of a duty, currency customs violations, energy pricing and related fraud, federal health and safety violations affecting the work place and employees, federal health and safety violations affecting the general public and individual citizens, illegal discharge of toxic, hazardous or carcinogenic waste, copyright violations, trafficking in contraband cigarettes, and other government regulatory offenses.

Internal security

Treason, espionage, sedition, sabotage, and other national internal security violations including those involving the Neutrality Act, Trading with the Enemy, Munitions Control and Fishery Conservation and Management Acts, Foreign Agents Registration Act and Military Selective Service Act.

Labor management

Union official corruption involving pension benefit funds, union official corruption involving bribery or kickbacks, labor racketeering, other labor/management offenses.

Narcotics/drugs

Covers drug dealing and drug possession, including Narcotics Task Force cases.

Official corruption

Corruption of any federal official or employee relating to the procurement of goods and services, corruption of any federal official or employee relating to federal programs, corruption of any official or employee relating to law enforcement, other federal corruption, corruption of any state government official or employee, corruption of any local government official or employee, other official corruption.

Organized crime

Violation of statutes relating to gambling, extortion, alcoholic beverages, infiltration of legitimate business by organized criminal elements, and related offenses.

Other

Immigration violations, offenses by or against Indians in Indian country for which the U.S. has jurisdiction, interstate theft, checks/postal, bank robbery, assimilated crimes, theft of government property, and other criminal prosecutions not classified elsewhere.

White collar crime

federal procurement fraud, federal program fraud, tax fraud, arson for profit, other insurance fraud, financial institution and credit card fraud and embezzlement, bankruptcy fraud, advance fee schemes (fraud against businesses or individuals involving the payment of a fee in advance for goods, services or other things of value), other fraud against businesses, consumer fraud, securities fraud, commodities fraud, other investment fraud, antitrust violations, computer fraud, health care fraud, other white collar crime/fraud.

PROGAGCY

Program agency associated with referral where applicable. Agency codes used are found in Appendix D.

PROGCAT

A code assigned by US Attorney offices to indicate the program category the referral concerns. A detailed listing of these codes is found in Appendix B. For example, a code of "040" indicates drug dealing, while a code of "045" indicates drug possession. If multiple charges are involved, program category codes are assigned according to the lead charge.

REASON2

Second reason given for declining to prosecute. First reason recorded in the field, DEFDISRS. Codes used are found in Appendix E. Field is valid only for immediate declinations.

REASON3

Third reason given for declining to prosecute. First reason recorded in the field, DEFDISRS. Codes used are found in Appendix E. Field is valid only for immediate declinations.

REF

Current Referral. Coded 1 if this referral was received in current year, 0 otherwise. Derived from MRRF but if record pertains to an appeal it is coded 0. This field was used in computing counts of referrals on TRAC's web sites.

RRRDIST

Numerical code for United States Attorney Office. See Appendix A for listing.

SENTDATE

Date of sentencing. This is an optional field which is often not recorded. For example, a code of "940316" indicates that sentencing occurred on March 16, 1994.

SOURCE

Indicates source of the information:

cri Justice criminal matter/case file

imm Justice immediate declination files

Source is important since available information items in this file differ, depending upon where they came from the matter/case files or the immediate declination files. An individual referral or court case often involves multiple defendants. A separate record is maintained for each potential defendant in the Referral Detail Files covering matters and cases. For immediate declinations a separate record is included in the original Justice files for each referral although a field indicates the total number of suspects involved.

STATCODE

U.S. Title and Code Section for lead charge. Differs from CRILDCGE in not including subsections. Thus CRILDCGE may indicate 18: 1273(a)(2), while STATCODE would be coded: 18: 1273.

TBMF

No true bill record flag. This field is coded "1" if no true bill was returned during the current fiscal year, and is blank otherwise. For matters with multiple defendants, only the first defendant in the matter is coded "1". This provides a convenient "counter" for determining the number of matters where indictments were not brought as distinct from the number of defendants involved. (See also TBRF.) This field is used by the Justice Department in compiling its statistics. Counts reflect not the actual fiscal year in which the indictment was not returned, but the fiscal year the event was entered into the Justice Department's computer accounting system. Thus, some events recorded as current may actually have occurred before the current fiscal year, but did not show up in Justice's computer system until the current year.

TBRF

Coded similarly to TBMF (see above) but for referrals with multiple defendants, each defendant in the matter is coded "1". This provides a convenient "counter" for determining the number of defendants in a single matter in which no true bill was returned.

TCRT

Number of days between when the prosecution was filed and when the case was completed at the trial court level for current dispositions. Calculated as the elapsed time between CASEDT and DEFDISDT. Because information on when prosecutions before U.S. Magistrates are filed is not available, this field is missing for these records. The field is also left missing if not a current court disposition, or an invalid date field was entered. This field was used to compute the average and median processing times for after court filing on TRAC's web sites.

TDEC

Number of days between when the referral was received and when it was disposed of for current declinations. Calculated as the elapsed time between MATTDT and DEFDISDT. Immediate declinations have an elapsed time of 0 days. This field is left missing if not a current declination, or an invalid date field was entered. This field was used to compute the average and median processing time for declinations on TRAC's web sites.

TFIL

Number of days between when the referral was received and when a prosecution was filed for current prosecutions. Calculated as the elapsed time between MATTDT and CASEDT. Because information on when prosecutions before U.S. Magistrates are filed is not available, this field is missing for these records. The field is also left missing if not a current prosecution, or an invalid date field was entered. This field was used to compute the average and median processing times before court filing on TRAC's web sites.

TIME

Prison sentence months if current conviction. A value of 0 is assigned if no prison sentence was given and 600 (50 years) if a life sentence was imposed. This field is left missing if it is not a current conviction, or if no sentence information was recorded. This field was used in computing average and median prison sentence on TRAC's web sites.

TOTCOUNT

The total number of counts involved in the matter or case for a given defendant.

TOTSUSP

Total number of suspects involved in referral. Field is valid only for immediate declinations.

TPRO

Number of days between when a referral was received and when the case was completed at the trial court level for current dispositions. Calculated as the elapsed time between MATTDT and DEFDISDT. Information on processing times for prosecutions before U.S. Magistrates are included. This field is left missing if not a current court disposition, or an invalid date field was entered. This field was used to computer average and median processing times for prosecution on TRAC's web sites.

List of Appendices Appendix A:  U.S. Attorney District and Headquarters City
Appendix B:  Program Category
Appendix C:  Agency Priority
Appendix D:  Agency
Appendix E:  Disposition Type
Appendix F:  Disposition Reason
Appendix G:  Event