This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
10/09/2024  06:02 PM     1,210,974,084 gs_participant_TXW.txt
10/09/2024  06:02 PM       146,266,263 gs_participant_UT.txt
10/09/2024  06:04 PM       134,610,984 gs_participant_VAW.txt
10/09/2024  06:04 PM        35,613,675 gs_participant_VI.txt
10/09/2024  06:04 PM        58,889,403 gs_participant_VT.txt
10/09/2024  06:04 PM       104,249,673 gs_participant_WAE.txt
10/09/2024  06:05 PM       261,831,042 gs_participant_WAW.txt
10/09/2024  06:05 PM       173,360,520 gs_participant_WIE.txt
10/09/2024  06:06 PM        67,386,762 gs_participant_WVN.txt
10/09/2024  06:06 PM       138,662,874 gs_participant_WVS.txt
10/09/2024  06:07 PM        84,173,661 gs_participant_WY.txt
10/09/2024  06:47 PM        27,890,626 gs_part_event_AK.txt
10/09/2024  06:47 PM        34,225,074 gs_part_event_ALM.txt
10/09/2024  06:48 PM       116,283,190 gs_part_event_ALN.txt
10/09/2024  06:48 PM        31,098,318 gs_part_event_ALS.txt
10/09/2024  06:48 PM        37,475,378 gs_part_event_ARE.txt
10/09/2024  06:48 PM        34,968,908 gs_part_event_ARW.txt
10/09/2024  06:50 PM       293,372,766 gs_part_event_AZ.txt
10/09/2024  06:52 PM       345,550,088 gs_part_event_CAC.txt
10/09/2024  06:52 PM        63,225,086 gs_part_event_CAE.txt
10/09/2024  06:53 PM       146,541,998 gs_part_event_CAN.txt
              21 File(s)  3,546,650,373 bytes
               0 Dir(s)  2,101,487,763,456 bytes free
  
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)
  
