View source for TraCS Form and Case Definable Field Codes

===Form Definable Fields===

In SQL Prd_Header Table

Submission Date = Definable1

Form Type = Definable2

AutoExport XML Date = Definable3

AutoExport PDF Date = Definable4

AutoExport TIFF Date = Definable5

IsFormNumbered = Definable6

IsDOTProperty = Definable7

Submitted as Voided = Definable8

Hold for Investigation = Definable9

AutoExport Base64 Date = Definable10

Incident Date = Definable11


===Case Definable Fields===

In SQL FolderInfo Table

1003 - Inactive

1004 - Referred To CID

1005 - SAO Final Disposition

1006 - Non-Pros Signed

1007 - No File SAO

1008 - Filed Charges by SAO

1009 - Capias Request SAO

1010 - Arrest Warrant Obtained

1011 - Cleared By Arrest


===Case/Folder Types===

Support.mdb/Codes - Folder Types

PrimeKey CodeValue	 CodeText

1	     1000	     General

2	     1001	     None

3	     09A	     Murder and Nonnegligent Manslaughter - 09A

4	     09B	     Negligent Manslaughter - 09B

5	     09C	     Justifiable Homicide - 09C

6	     100	     Kidnapping/Abduction - 100

7	     11A	     Forcible Rape - 11A

8	     11B	     Forcible Sodomy - 11B

9	     11C	     Sexual Assault with an Object - 11C

10	     11D	     Forcible Fondling - 11D

11	     120	     Robbery - 120

12	     13A	     Aggravated Assault - 13A

13	     13B	     Simple Assault - 13B

14	     13C	     Intimidation - 13C

15	     200	     Arson - 200

16	     210	     Extortion/Blackmail - 210

17	     220	     Burglary/Breaking and Entering - 220

18	     23A	     Pocket-picking - 23A

19	     23B	     Purse-snatching - 23B

20	     23C	     Shoplifting - 23C

21	     23D	     Theft from Building - 23D

22	     23E	     Theft from Coin-Oper. Machine or Device - 23E

23	     23F	     Theft from Motor Vehicle - 23F

24	     23G	     Theft of Motor Vehicle Parts or Access. - 23G

25	     23H	     All Other Larceny - 23H

26	     240	     Motor Vehicle Theft - 240

27	     250	     Counterfeiting/Forgery - 250

28	     26A	     False Pretenses/Swindle/Con Game - 26A

29	     26B	     Credit Card/Automatic Teller Mach. Fraud - 26B

30	     26C	     Impersonation - 26C

31	     26D	     Welfare Fraud - 26D

32	     26E	     Wire Fraud - 26E

33	     270	     Embezzlement - 270

34	     280	     Stolen Property Offenses - 280

35	     290	     Destruction/Damage/Vandalism of Property - 290

36	     35A	     Drug/Narcotic Violation - 35A

37	     36A	     Incest - 36A

38	     36B	     Statutory Rape - 36B

39	     370	     Pornography/Obscene Material - 370

40	     39A	     Betting/Wagering - 39A

41	     39B	     Operating/Promoting/Assisting Gambling - 39B

42	     39C	     Gambling Equipment Violations - 39C

43	     39D	     Sports Tampering - 39D

44	     40A	     Prostitution - 40A

45	     40B	     Assisting or Promoting Prostitution - 40B

46	     510	     Bribery - 510

47	     520	     Weapon Law Violations - 520

48	     90A	     Bad Checks - 90A

49	     90B	     Curfew/Loitering/Vagrancy Violations - 90B

50	     90C	     Disorderly Conduct - 90C

51	     90D	     Driving Under the Influence - 90D

52	     90E	     Drunkenness - 90E

53	     90F	     Family Offenses, Nonviolent - 90F

54	     90G	     Liquor Law Violations - 90G

55	     90H	     Peeping Tom - 90H

56	     90I	     Runaway - 90I

57	     90J	     Trespass of Real Property - 90J

58	     90Z	     All Other Offenses - 90Z

59	     35B	     Drug Equipment Violations - 35B

60	     1004	     Unattended Death

61	     1002	     Information Report

62	     1003	     Found Property

63	     1005	     Other

64	     1006	     Hit and Run

65	     26F	     Identity Theft - 26F

66	     26G	     Hacking/Computer Invasion - 26G

67	     1007	     Fatality/SBI