View source for 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


===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