This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
10/09/2024  07:07 PM       267,307,220 gs_part_event_NM.txt
10/09/2024  07:08 PM       206,897,742 gs_part_event_NV.txt
10/09/2024  07:08 PM       185,304,580 gs_part_event_NYE.txt
10/09/2024  07:09 PM        37,221,448 gs_part_event_NYN.txt
10/09/2024  07:10 PM       278,693,334 gs_part_event_NYS.txt
10/09/2024  07:10 PM       120,238,066 gs_part_event_NYW.txt
10/09/2024  07:11 PM       170,832,714 gs_part_event_OHN.txt
10/09/2024  07:12 PM       176,684,762 gs_part_event_OHS.txt
10/09/2024  07:12 PM        21,744,448 gs_part_event_OKE.txt
10/09/2024  07:12 PM        61,571,258 gs_part_event_OKN.txt
10/09/2024  07:13 PM        39,361,964 gs_part_event_OKW.txt
10/09/2024  07:13 PM        49,034,084 gs_part_event_OR.txt
10/09/2024  07:13 PM       100,934,026 gs_part_event_PAE.txt
10/09/2024  07:14 PM        78,964,324 gs_part_event_PAM.txt
10/09/2024  07:14 PM        92,291,294 gs_part_event_PAW.txt
10/09/2024  07:14 PM        70,450,232 gs_part_event_PR.txt
10/09/2024  07:14 PM         9,811,346 gs_part_event_RI.txt
10/09/2024  07:15 PM        92,818,450 gs_part_event_SC.txt
10/09/2024  07:15 PM        78,560,448 gs_part_event_SD.txt
10/09/2024  07:15 PM        72,331,592 gs_part_event_TNE.txt
10/09/2024  07:15 PM        31,934,746 gs_part_event_TNM.txt
10/09/2024  04:40 PM            56,400 gs_court_order_disp.txt
10/09/2024  04:41 PM       436,090,626 gs_defend_stat.txt
10/09/2024  04:43 PM       683,129,964 gs_instrument.txt
              24 File(s)  3,362,265,068 bytes
               0 Dir(s)  2,101,182,324,736 bytes free
  
Table Layouts:

GS_PART_EVENT - 132 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)
CRTHISID      NOT NULL   NUMBER(10)     (31:40)
EVENTID       NOT NULL   NUMBER(10)     (41:50)
CREATE_DATE              DATE           (51:61)
CREATE_USER              VARCHAR2(30)   (62:91)
UPDATE_DATE              DATE           (92:102)
UPDATE_USER              VARCHAR2(30)   (103:132)

GS_COURT_ORDER_DISP - 280 Characters                        

Name            Null?      Type           Position
DISTRICT        NOT NULL   VARCHAR2(3)    (1:3) 
ID              NOT NULL   VARCHAR2(10)   (4:13)
CASEID          NOT NULL   VARCHAR2(10)   (14:23) 
CRTHISID        NOT NULL   NUMBER(10)     (24:33)
PARTID          NOT NULL   NUMBER(10)     (34:43)
CODE                       VARCHAR2(4)    (44:47)
SYSTEM_DATE                DATE           (48:58)
DATE_OF_ORDER              DATE           (59:69)
LAST_NAME                  VARCHAR2(60)   (70:129)
FIRST_NAME                 VARCHAR2(30)   (130:159)
COURT                      VARCHAR2(4)    (160:163)
COURT_NUMBER               VARCHAR2(25)   (164:188)
PARTID2                    NUMBER(10)     (189:198)
CREATE_DATE                DATE           (199:209)
CREATE_USER                VARCHAR2(30)   (210:239)
UPDATE_DATE                DATE           (240:250)
UPDATE_USER                VARCHAR2(30)   (251:280)


GS_DEFEND_STAT - 195 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)
TYPE            NOT NULL   VARCHAR2(2)      (41:42)
START_DATE      NOT NULL   DATE             (43:53)
CUSTODY_LOC                VARCHAR2(2)      (54:55)
DETEN_REASON               VARCHAR2(4)      (56:59)
BOND_TYPE                  VARCHAR2(2)      (60:61)
BOND_AMOUNT                NUMBER(12,2)     (62:75)
BOND_PROVIDER              VARCHAR2(25)     (76:100)
TERM_REASON                VARCHAR2(2)      (101:102)
END_DATE                   DATE             (103:113)
CREATE_DATE                DATE             (114:124)
CREATE_USER                VARCHAR2(30)     (125:154)
UPDATE_DATE                DATE             (155:165)
UPDATE_USER                VARCHAR2(30)     (166:195)


GS_INSTRUMENT - 146 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(2)    (41:42)
FILING_DATE       NOT NULL   DATE           (43:53)
SYS_FILING_DATE              DATE           (54:64)
CREATE_DATE                  DATE           (65:75)
CREATE_USER                  VARCHAR2(30)   (76:105)
UPDATE_DATE                  DATE           (106:116)
UPDATE_USER                  VARCHAR2(30)   (117:146)

  
