This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
10/09/2024  05:01 PM     1,178,467,401 gs_sentence.txt
10/09/2024  06:07 PM        68,851,376 gs_event_AK.txt
10/09/2024  06:07 PM        79,160,686 gs_event_ALM.txt
10/09/2024  06:08 PM       357,952,023 gs_event_ALN.txt
10/09/2024  06:08 PM        70,240,060 gs_event_ALS.txt
10/09/2024  06:08 PM        99,647,845 gs_event_ARE.txt
10/09/2024  06:08 PM        86,763,039 gs_event_ARW.txt
10/09/2024  06:10 PM       745,043,618 gs_event_AZ.txt
10/09/2024  06:11 PM       614,893,972 gs_event_CAC.txt
10/09/2024  06:12 PM       121,638,055 gs_event_CAE.txt
              10 File(s)  3,422,658,075 bytes
               0 Dir(s)  2,102,731,350,016 bytes free
  
Table Layouts:

GS_SENTENCE - 357 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)
SENT_DATE              NOT NULL   DATE           (31:41)
GUIDE_DEPART                      VARCHAR2(1)    (42:42)
INCAR_TYPE                        VARCHAR2(3)    (43:45)
JUDGEID                           NUMBER(10)     (46:55)
PROB_DAYS                         NUMBER(11)     (56:66)
PROB_MONTHS                       NUMBER(11)     (67:77)
PROB_YEARS                        NUMBER(11)     (78:88)
SUPER_REL_DAYS                    NUMBER(11)     (89:99)
SUPER_REL_MONTHS                  NUMBER(11)     (100:110)
SUPER_REL_YEARS                   NUMBER(11)     (111:121)
INCAR_DAYS                        NUMBER(11)     (122:132)
INCAR_MONTHS                      NUMBER(11)     (133:143)
INCAR_YEARS                       NUMBER(11)     (144:154)
FINE                              NUMBER(12,2)   (155:168)
SPEC_ASSESSMENT                   NUMBER(12,2)   (169:182)
DEBARRED                          VARCHAR2(1)    (183:183)
SPEC_CONDITION                    VARCHAR2(4)    (184:187)
PROBATION_REVOKED                 VARCHAR2(1)    (188:188)
SUPER_REL_REVOKED                 VARCHAR2(1)    (189:189)
TOTAL_REVOKED_DAYS                NUMBER(11)     (190:200)
TOTAL_REVOKED_MONTHS              NUMBER(11)     (201:211)
TOTAL_REVOKED_YEARS               NUMBER(11)     (212:222)
RELATED_FLU_USAO                  VARCHAR2(10)   (223:232)
RELATED_FLU_SEQ                   VARCHAR2(3)    (233:235)
COMM_SERV_HOURS                   NUMBER(10,2)   (236:247)
SYS_SENT_DATE                     DATE           (248:258)
RESTITUTION_AMT                   NUMBER(14,2)   (259:274)
CREATE_DATE                       DATE           (275:285)
CREATE_USER                       VARCHAR2(30)   (286:315)
UPDATE_DATE                       DATE           (316:326)
UPDATE_USER                       VARCHAR2(30)   (327:356)
SUPV_REL_INCAR_TYPE               VARCHAR2(1)    (357:357)


GS_EVENT - 405 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)
ID                 NOT NULL   NUMBER(10)     (31:40)
TYPE               NOT NULL   VARCHAR2(4)    (41:44)
ACTION                        VARCHAR2(2)    (45:46)
EVENT_DATE                    DATE           (47:57)
SCHED_DATE                    DATE           (58:68)
SCHED_TIME                    DATE           (69:79)
SCHED_LOC                     VARCHAR2(200)  (80:279)
STAFFID                       NUMBER(10)     (280:289)
JUDGEID                       NUMBER(10)     (290:299)
DOCUMENT_CODE                 VARCHAR2(3)    (300:302)
DOCUMENT_STAFFID              NUMBER(10)     (303:312)
DOCUMENT_DATE                 DATE           (313:323)
CREATE_DATE                   DATE           (324:334)
CREATE_USER                   VARCHAR2(30)   (335:364)
UPDATE_DATE                   DATE           (365:375)
UPDATE_USER                   VARCHAR2(30)   (376:405)

  
