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

File Listing:

10/11/2015 03:54 AM           802,784,960 gs_participant_TXW.txt
10/11/2015 03:54 AM           101,000,040 gs_participant_UT.txt
10/11/2015 03:56 AM            94,928,600 gs_participant_VAW.txt
10/11/2015 03:56 AM            28,446,680 gs_participant_VI.txt
10/11/2015 03:56 AM            39,307,760 gs_participant_VT.txt
10/11/2015 03:56 AM            72,167,080 gs_participant_WAE.txt
10/11/2015 03:57 AM           192,978,760 gs_participant_WAW.txt
10/11/2015 03:57 AM           126,938,800 gs_participant_WIE.txt
10/11/2015 03:58 AM            46,091,440 gs_participant_WVN.txt
10/11/2015 03:58 AM           112,538,560 gs_participant_WVS.txt
10/11/2015 03:58 AM            63,991,400 gs_participant_WY.txt
10/11/2015 02:30 AM            23,031,477 gs_part_event_AK.txt
10/11/2015 02:30 AM            27,416,620 gs_part_event_ALM.txt
10/11/2015 02:31 AM            85,196,475 gs_part_event_ALN.txt
10/11/2015 02:31 AM            20,663,279 gs_part_event_ALS.txt
10/11/2015 02:31 AM            32,644,451 gs_part_event_ARE.txt
10/11/2015 02:31 AM            26,249,944 gs_part_event_ARW.txt
10/11/2015 02:32 AM           181,215,692 gs_part_event_AZ.txt
10/11/2015 02:34 AM           237,839,910 gs_part_event_CAC.txt
10/11/2015 02:34 AM            52,560,935 gs_part_event_CAE.txt
10/11/2015 02:34 AM           101,211,005 gs_part_event_CAN.txt
10/11/2015 02:35 AM           202,245,120 gs_part_event_CAS.txt
10/11/2015 02:36 AM           102,307,058 gs_part_event_CO.txt
10/11/2015 02:36 AM            45,986,745 gs_part_event_CT.txt
10/11/2015 02:37 AM           187,499,543 gs_part_event_DC.txt
10/11/2015 02:37 AM            10,792,684 gs_part_event_DE.txt
10/11/2015 02:38 AM           140,002,450 gs_part_event_FLM.txt
10/11/2015 02:38 AM            66,580,598 gs_part_event_FLN.txt
10/11/2015 02:39 AM           135,878,918 gs_part_event_FLS.txt
10/11/2015 02:39 AM            48,414,394 gs_part_event_GAM.txt
10/11/2015 02:39 AM            28,751,807 gs_part_event_GAN.txt
10/11/2015 02:39 AM            32,322,857 gs_part_event_GAS.txt
10/11/2015 02:39 AM             9,720,305 gs_part_event_GU.txt

33 File(s) 3,479,706,347 bytes


Table Layouts:

* Note:  Due to the file size, the original GS_PARTICIPANT table could not fit on
one DVD so the file was broken up programatically by district.  All GS_PARTICIPANT_ 
tables have the same layout as the original GS_PARTICIPANT file regardless of 
district suffix

GS_PARTICIPANT - 1159 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)
ROLE                     NOT NULL   VARCHAR2(2)    (32:33)
SECURITY                            VARCHAR2(1)    (34:34)
DEFEND_NUM                          NUMBER(11)     (35:45)
SALUTATION                          VARCHAR2(20)   (46:65)
LAST_NAME                NOT NULL   VARCHAR2(60)   (66:125)
FIRST_NAME                          VARCHAR2(30)   (126:155)
TITLE                               VARCHAR2(30)   (156:185)
LAST_SOUNDS                         VARCHAR2(4)    (186:189)
FIRST_SOUNDS                        VARCHAR2(4)    (190:193)
BUSINESS_TYPE                       VARCHAR2(2)    (194:195)
EIN                                 VARCHAR2(20)   (196:215)
PROP_TYPE                           VARCHAR2(2)    (216:217)
TOTAL_TRACTS                        NUMBER(11)     (218:228)
CATS_ASSET_ID                       VARCHAR2(15)   (229:243)
AGENCY                              VARCHAR2(4)    (244:247)
AGENCY_NUM                          VARCHAR2(30)   (248:277)
JOB_POSITION                        VARCHAR2(4)    (278:281)
SSN                                 VARCHAR2(11)   (282:292)
BIRTH_DATE                          DATE           (293:303)
GENDER                              VARCHAR2(1)    (304:304)
JUVENILE                            VARCHAR2(1)    (305:305)
RACE                                VARCHAR2(2)    (306:307)
RACE_DESCRIP                        VARCHAR2(30)   (308:337)
IMMIG_STAT                          VARCHAR2(2)    (338:339)
COUNTRY                             VARCHAR2(2)    (340:341)
TRIBE                               VARCHAR2(4)    (342:345)
RESERVATION                         VARCHAR2(4)    (346:349)
ARREST_DATE                         DATE           (350:360)
PDID                                VARCHAR2(12)   (361:372)
FBI_NUMBER                          VARCHAR2(15)   (373:387)
CRIM_HIST                           VARCHAR2(1)    (388:388)
EST_LOSS                            NUMBER(12,2)   (389:402)
ACT_LOSS                            NUMBER(12,2)   (403:416)
HOME_ADDRESS1                       VARCHAR2(30)   (417:446)
HOME_ADDRESS2                       VARCHAR2(30)   (447:476)
HOME_ADDRESS3                       VARCHAR2(30)   (477:506)
HOME_CITY                           VARCHAR2(20)   (507:526)
HOME_STATE                          VARCHAR2(2)    (527:528)
HOME_COUNTY                         VARCHAR2(20)   (529:548)
HOME_ZIPCODE                        VARCHAR2(10)   (549:558)
HOME_PHONE                          VARCHAR2(15)   (559:573)
HOME_FAX                            VARCHAR2(15)   (574:588)
OFF_ADDRESS1                        VARCHAR2(30)   (589:618)
OFF_ADDRESS2                        VARCHAR2(30)   (619:648)
OFF_ADDRESS3                        VARCHAR2(30)   (649:678)
OFF_CITY                            VARCHAR2(20)   (679:698)
OFF_STATE                           VARCHAR2(2)    (699:700)
OFF_COUNTY                          VARCHAR2(20)   (701:720)
OFF_ZIPCODE                         VARCHAR2(10)   (721:730)
OFF_PHONE                           VARCHAR2(15)   (731:745)
OFF_FAX                             VARCHAR2(15)   (746:760)
MARSHALS_NUM                        VARCHAR2(9)    (761:769)
AGCYOFFID                           NUMBER(10)     (770:779)
LOWER_CRT_TRIAL_NBR                 VARCHAR2(25)   (780:804)
BUSINESS_CONTACT_LNAME              VARCHAR2(30)   (805:834)
BUSINESS_CONTACT_FNAME              VARCHAR2(30)   (835:864)
COLLECT_IND                         VARCHAR2(1)    (865:865)
SYS_INIT_DATE            NOT NULL   DATE           (866:876)
WEIGHT                              VARCHAR2(2)    (877:878)
EMPLOYER_NAME                       VARCHAR2(40)   (879:918)
EMPLOYER_TYPE                       VARCHAR2(3)    (919:921)
EMPLOYER_DESC                       VARCHAR2(40)   (922:961)
NPI                                 VARCHAR2(10)   (962:971)
OCCUPATION                          VARCHAR2(3)    (972:974)
OCCUP_DESC                          VARCHAR2(60)   (975:1034)
HCARE_BUSN_TYPE                     VARCHAR2(3)    (1035:1037)
HCARE_BUSN_DESC                     VARCHAR2(40)   (1038:1077)
CREATE_DATE                         DATE           (1078:1088)
CREATE_USER                         VARCHAR2(30)   (1089:1118)
UPDATE_DATE                         DATE           (1119:1129)
UPDATE_USER                         VARCHAR2(30)   (1130:1159)


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)
