TraCS Form and Case Status Codes
Form Status Codes
Database Information
Table: Prd_Header
Field: Status
Code Text and Code Value
Open = 0
Validated = 1
Rejected = 2
Voided = 3
Accepted = 5
System (Hard) Delete = 8
Temporary Storage = 12
Submitted = 13
Checked Out = 14
Purged = 15
Reviewed = 31
User Deleted = 32
Submitted as Voided = 34
Accepted Void = 36
Paid = 37
Mailed = 38
Expungement for Review = 39
Expungement Final = 40
Permanent Storage = 41
Closed = 97
Dismissed = 98
Violator Letter = 99
Administrative Hold = 100
Court = 101
FIBRS Replace Request = 102 (This is a delete in FIBRS for UAA or Offense - Note: Replace/amendments must be deleted prior to replacing)
FIBRS Replaced = 103 (This is a replace for an amendment to a UAA or Offense)
Case Status Codes
Database Information
Table: FolderInfo
Field: FolderStatus
Code Text and Code Value
Open = 1000
Pending = 1001
Closed = 1002
Inactive = 1003
Referred To CID = 1004
SAO Final Disposition = 1005
Non-Pros Signed = 1006
No File SAO = 1007
Filed Charges by SAO = 1008
Capias Request SAO = 1009
Arrest Warrant Obtained = 1010
Cleared By Arrest = 1011
Case Types
Database Information
Table: FolderInfo
Field: FolderType
Code Text and Code Value
General = 1000
None = 1001
Unattended Death = 1004
Information Report = 1002
Found Property = 1003
Other = 1005
Hit and Run = 1006
Identity Theft = 26F
Hacking/Computer Invasion = 26G
Fatality/SBI = 1007
Murder and Nonnegligent Manslaughter = 09A
Negligent Manslaughter = 09B
Justifiable Homicide = 09C
Kidnapping/Abduction = 100
Forcible Rape = 11A
Forcible Sodomy = 11B
Sexual Assault with an Object = 11C
Forcible Fondling = 11D
Robbery = 120
Aggravated Assault = 13A
Simple Assault = 13B
Intimidation = 13C
Arson = 200
Extortion/Blackmail = 210
Burglary/Breaking and Entering = 220
Pocket-picking = 23A
Purse-snatching = 23B
Shoplifting = 23C
Theft from Building = 23D
Theft from Coin-Oper. Machine or Device = 23E
Theft from Motor Vehicle = 23F
Theft of Motor Vehicle Parts or Access = 23G
All Other Larceny = 23H
Motor Vehicle Theft = 240
Counterfeiting/Forgery = 250
False Pretenses/Swindle/Con Game = 26A
Credit Card/Automatic Teller Mach. Fraud = 26B
Impersonation = 26C
Welfare Fraud = 26D
Wire Fraud = 26E
Embezzlement = 270
Stolen Property Offenses = 280
Destruction/Damage/Vandalism of Property = 290
Drug/Narcotic Violation = 35A
Incest = 36A
Statutory Rape = 36B
Pornography/Obscene Material = 370
Betting/Wagering = 39A
Operating/Promoting/Assisting Gambling = 39B
Gambling Equipment Violations = 39C
Sports Tampering = 39D
Prostitution = 40A
Assisting or Promoting Prostitution = 40B
Bribery = 510
Weapon Law Violations = 520
Bad Checks = 90A
Curfew/Loitering/Vagrancy Violations = 90B
Disorderly Conduct = 90C
Driving Under the Influence = 90D
Drunkenness = 90E
Family Offenses, Nonviolent = 90F
Liquor Law Violations = 90G
Peeping Tom = 90H
Runaway = 90I
Trespass of Real Property = 90J
All Other Offenses = 90Z
Drug Equipment Violations = 35B
Case Confidentiality Types
Database Information
Table: FolderInfo
Field: FolderConfidentialityType
Code Text and Code Value
Non-confidential
Confidential
Informant
Juvenile
Sealed