This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
10/09/2024  04:30 PM       536,187,483 gs_case_prog_cat.txt
10/09/2024  05:04 PM       427,274,748 gs_case_special_proj.txt
10/09/2024  05:16 PM            16,692 gs_cont_services.txt
10/09/2024  05:17 PM        29,435,714 gs_contact_log.txt
10/09/2024  04:30 PM       111,928,320 gs_control_sub.txt
10/09/2024  05:17 PM         1,084,081 gs_evidence.txt
10/09/2024  05:17 PM           193,875 gs_expert_case.txt
10/09/2024  04:44 PM     1,193,457,940 gs_inst_charge.txt
10/09/2024  05:18 PM        92,947,896 gs_part_victim.txt
10/09/2024  04:53 PM       188,444,536 gs_relate_case.txt
10/09/2024  04:53 PM       115,423,056 gs_relate_part.txt
              11 File(s)  2,696,394,341 bytes
               0 Dir(s)  2,103,341,174,784 bytes free
  
Table Layouts:

GS_CASE_PROG_CAT - 115 Characters                        

Name          Null?      Type           Position
DISTRICT      NOT NULL   VARCHAR2(10)   (1:10)
CASEID        NOT NULL   VARCHAR2(10)   (11:20)
PROG_CAT      NOT NULL   VARCHAR2(3)    (21:23)
ID            NOT NULL   NUMBER(10)     (24:33)
CREATE_DATE              DATE           (34:44)
CREATE_USER              VARCHAR2(30)   (45:74)
UPDATE_DATE              DATE           (75:85)
UPDATE_USER              VARCHAR2(30)   (86:115)


GS_CASE_SPECIAL_PROJ - 114 Characters                        

Name           Null?      Type           Position
DISTRICT       NOT NULL   VARCHAR2(10)   (1:10)
ID             NOT NULL   NUMBER(10)     (11:20)
CASEID         NOT NULL   VARCHAR2(10)   (21:30)
SPECIAL_PROJ   NOT NULL   VARCHAR2(2)    (31:32)
CREATE_DATE               DATE           (33:43)
CREATE_USER               VARCHAR2(30)   (44:73)
UPDATE_DATE               DATE           (74:84)
UPDATE_USER               VARCHAR2(30)   (85:114)


GS_EVIDENCE - 191 Characters                        

Name             Null?      Type           Position
DISTRICT         NOT NULL   VARCHAR2(10)   (1:10)
CASEID           NOT NULL   VARCHAR2(10)   (11:20)
ID               NOT NULL   NUMBER(10)     (21:30)
LOCATION         NOT NULL   VARCHAR2(4)    (31:34)
TYPE             NOT NULL   VARCHAR2(2)    (35:36)
DISPOSITION                 VARCHAR2(1)    (37:37)
STORE_DATE                  DATE           (38:48)
DISP_DATE                   DATE           (49:59)
DC_EXHIBIT_NUM              VARCHAR2(25)   (60:84)
GJ_EXHIBIT_NUM              VARCHAR2(25)   (85:109)
CREATE_DATE                 DATE           (110:120)
CREATE_USER                 VARCHAR2(30)   (121:150)
UPDATE_DATE                 DATE           (151:161)
UPDATE_USER                 VARCHAR2(30)   (162:191)


GS_EXPERT_CASE - 123 Characters                        

Name          Null?      Type           Position
DISTRICT      NOT NULL   VARCHAR2(10)   (1:10)
CASEID        NOT NULL   VARCHAR2(10)   (11:20)
ID            NOT NULL   NUMBER(10)     (21:30)
EXP_SIDE      NOT NULL   VARCHAR2(1)    (31:31)
EXPERTID      NOT NULL   NUMBER(10)     (32:41)
CREATE_DATE              DATE           (42:52)
CREATE_USER              VARCHAR2(30)   (53:82)
UPDATE_DATE              DATE           (83:93)
UPDATE_USER              VARCHAR2(30)   (94:123)


GS_INST_CHARGE - 183 Characters                        

Name          Null?      Type           Position
DISTRICT      NOT NULL   VARCHAR2(10)   (1:10)
CASEID        NOT NULL   VARCHAR2(10)   (11:20)
CRTHISID      NOT NULL   NUMBER(10)     (21:30)
INSTID        NOT NULL   NUMBER(10)     (31:40)
CHARGE        NOT NULL   VARCHAR2(25)   (41:65)
CATEGORY      NOT NULL   VARCHAR2(1)    (66:66)
PENT_PROV                VARCHAR2(25)   (67:91)
CREATE_DATE              DATE           (92:102)
CREATE_USER              VARCHAR2(30)   (103:132)
UPDATE_DATE              DATE           (133:143)
UPDATE_USER              VARCHAR2(30)   (144:173)
ID            NOT NULL   NUMBER         (174:183)


GS_PART_VICTIM - 181 Characters                        

Name                 Null?      Type           Position
DISTRICT             NOT NULL   VARCHAR2(10)   (1:10)
CASEID               NOT NULL   VARCHAR2(10)   (11:20)
PARTID               NOT NULL   NUMBER(10)     (21:30)
ID                   NOT NULL   NUMBER(10)     (31:40)
VICTIM_TYPE                     VARCHAR2(1)    (41:41)
PROSECUTION                     VARCHAR2(1)    (42:42)
VICTIM_TIMES                    NUMBER(11)     (43:53)
THREATS                         VARCHAR2(1)    (54:54)
ELDERLY                         VARCHAR2(1)    (55:55)
VICTIM_IDENTIFIER               VARCHAR2(25)   (56:80)
STATE_COMP_RECVD                NUMBER(12,2)   (81:94)
SERVICES_REQUESTED              VARCHAR2(1)    (95:95)
VIOLENT_CRIME                   VARCHAR2(1)    (96:96)
DISABILITY                      VARCHAR2(1)    (97:97)
NOTIFICAT_REQSTD                VARCHAR2(1)    (98:98)
NOTIFICAT_RECVD                 VARCHAR2(1)    (99:99)
CREATE_DATE                     DATE           (100:110)
CREATE_USER                     VARCHAR2(30)   (111:140)
UPDATE_DATE                     DATE           (141:151)
UPDATE_USER                     VARCHAR2(30)   (152:181)


GS_RELATE_CASE - 144 Characters                        

Name          Null?      Type           Position
DISTRICT      NOT NULL   VARCHAR2(10)   (1:10)
CASEID1       NOT NULL   VARCHAR2(10)   (11:20)
CASEID2       NOT NULL   VARCHAR2(10)   (21:30)
CRTHISID1                NUMBER(10)     (31:40)
CRTHISID2                NUMBER(10)     (41:50)
REASON        NOT NULL   VARCHAR2(2)    (51:52)
CREATE_DATE              DATE           (53:63)
CREATE_USER              VARCHAR2(30)   (64:93)
UPDATE_DATE              DATE           (94:104)
UPDATE_USER              VARCHAR2(30)   (105:134)
ID            NOT NULL   FLOAT(*)       (135:144)


GS_RELATE_PART - 124 Characters                        

Name          Null?      Type           Position
DISTRICT      NOT NULL   VARCHAR2(10)   (1:10)
CASEID        NOT NULL   VARCHAR2(10)   (11:20)
PARTID1       NOT NULL   NUMBER(10)     (21:30)
PARTID2       NOT NULL   NUMBER(10)     (31:40)
REASON        NOT NULL   VARCHAR2(2)    (41:42)
CREATE_DATE              DATE           (43:53)
CREATE_USER              VARCHAR2(30)   (54:83)
UPDATE_DATE              DATE           (84:94)
UPDATE_USER              VARCHAR2(30)   (95:124)


GS_CONT_SERVICES - 154 Characters                        

Name            Null?      Type           Position
DISTRICT        NOT NULL   VARCHAR2(10)   (1:10)
CASEID          NOT NULL   VARCHAR2(10)   (11:20)
PARTID          NOT NULL   NUMBER(10)     (21:30)
CONTID          NOT NULL   NUMBER(10)     (31:40)
ID              NOT NULL   NUMBER(10)     (41:50)
SERV_AGENCY     NOT NULL   NUMBER(11)     (51:61)
SERV_TYPE                  VARCHAR2(4)    (62:65)
SERV_LANGUAGE              VARCHAR2(3)    (66:68)
SERV_SPECIAL               VARCHAR2(4)    (69:72)
CREATE_DATE                DATE           (73:83)
CREATE_USER                VARCHAR2(30)   (84:113)
UPDATE_DATE                DATE           (114:124)
UPDATE_USER                VARCHAR2(30)   (125:154)


GS_CONTACT_LOG - 152 Characters                        

Name          Null?      Type           Position
DISTRICT      NOT NULL   VARCHAR2(10)   (1:10)
CASEID        NOT NULL   VARCHAR2(10)   (11:20)
PARTID        NOT NULL   NUMBER(10)     (21:30)
ID            NOT NULL   NUMBER(10)     (31:40)
CONT_DATE     NOT NULL   DATE           (41:51)
PURPOSE       NOT NULL   VARCHAR2(2)    (52:53)
TYPE          NOT NULL   VARCHAR2(2)    (54:55)
INITIATOR     NOT NULL   VARCHAR2(2)    (56:57)
STAFFID       NOT NULL   NUMBER(10)     (58:67)
DOC_CODE                 VARCHAR2(3)    (68:70)
CREATE_DATE              DATE           (71:81)
CREATE_USER              VARCHAR2(30)   (82:111)
UPDATE_DATE              DATE           (112:122)
UPDATE_USER              VARCHAR2(30)   (123:152)


GS_CONTROL_SUB - 158 Characters                        

Name            Null?      Type           Position
DISTRICT        NOT NULL   VARCHAR2(10)   (1:10)
CASEID          NOT NULL   VARCHAR2(10)   (11:20)
ID              NOT NULL   NUMBER(10)     (21:30)
TYPE            NOT NULL   VARCHAR2(1)    (31:31)
QUANTITY                   NUMBER(12,2)   (32:45)
MEASURE                    VARCHAR2(1)    (46:46)
OTHER_DESCRIP              VARCHAR2(30)   (47:76)
CREATE_DATE                DATE           (77:87)
CREATE_USER                VARCHAR2(30)   (88:117)
UPDATE_DATE                DATE           (118:128)
UPDATE_USER                VARCHAR2(30)   (129:158)

  
