This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
10/09/2024  06:35 PM       370,914,973 gs_event_OHN.txt
10/09/2024  06:35 PM       296,160,876 gs_event_OHS.txt
10/09/2024  06:35 PM        56,679,227 gs_event_OKE.txt
10/09/2024  06:36 PM       148,688,089 gs_event_OKN.txt
10/09/2024  06:36 PM       122,540,781 gs_event_OKW.txt
10/09/2024  06:36 PM       147,000,667 gs_event_OR.txt
10/09/2024  06:37 PM       224,427,533 gs_event_PAE.txt
10/09/2024  06:37 PM       215,226,077 gs_event_PAM.txt
10/09/2024  06:38 PM       289,033,899 gs_event_PAW.txt
10/09/2024  06:38 PM       133,348,666 gs_event_PR.txt
10/09/2024  06:38 PM        27,813,566 gs_event_RI.txt
10/09/2024  06:38 PM       174,937,961 gs_event_SC.txt
10/09/2024  06:39 PM       194,550,477 gs_event_SD.txt
10/09/2024  06:39 PM       171,158,966 gs_event_TNE.txt
10/09/2024  06:39 PM        80,496,053 gs_event_TNM.txt
10/09/2024  06:39 PM       189,889,513 gs_event_TNW.txt
10/09/2024  06:40 PM       196,950,556 gs_event_TXE.txt
10/09/2024  06:41 PM       325,529,996 gs_event_TXN.txt
              18 File(s)  3,365,347,876 bytes
               0 Dir(s)  2,102,080,397,312 bytes free
  
Table Layouts:

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)

  
