This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary).

File Listing:

10/11/2016 12:37 PM         1,043,669,064 gs_agent.txt
10/11/2016 02:53 PM         1,875,663,244 gs_part_court.txt
10/11/2016 03:27 PM            56,829,570 gs_part_event_TNW.txt
10/11/2016 03:28 PM            81,336,948 gs_part_event_TXE.txt
10/11/2016 03:28 PM           117,788,125 gs_part_event_TXN.txt
10/11/2016 03:30 PM           264,998,111 gs_part_event_TXS.txt

6 File(s) 3,440,285,062 bytes


Table Layouts:

GS_AGENT - 371 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)
SALUTATION               VARCHAR2(8)     (41:48)
LAST_NAME     NOT NULL   VARCHAR2(30)    (49:78)
FIRST_NAME               VARCHAR2(30)    (79:108)
TITLE                    VARCHAR2(30)    (109:138)
PHONE                    VARCHAR2(20)    (139:158)
FAX                      VARCHAR2(15)    (159:173) 
PAGER                    VARCHAR2(15)    (174:188) 
LEAD_AGENT               VARCHAR2(1)     (189:189)
EMAIL                    VARCHAR2(100)   (190:289)
CREATE_DATE              DATE            (290:300)
CREATE_USER              VARCHAR2(30)    (301:330)
UPDATE_DATE              DATE            (331:341)
UPDATE_USER              VARCHAR2(30)    (342:371)


GS_PART_COURT - 163 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)
APPEAL_ROLE                VARCHAR2(2)    (41:42)
DISPOSITION                VARCHAR2(2)    (43:44)
DISP_REASON                VARCHAR2(4)    (45:48)
DISP_DATE                  DATE           (49:59)
SYS_DISP_DATE              DATE           (60:70)
SYS_INIT_DATE   NOT NULL   DATE           (71:81)
CREATE_DATE                DATE           (82:92)
CREATE_USER                VARCHAR2(30)   (93:122)
UPDATE_DATE                DATE           (123:133)
UPDATE_USER                VARCHAR2(30)   (134:163)


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)
