******************************************************
Table name - GS_AGENT
Number of records imported:                   4007465
Marked and sealed civil records deleted:      0
Number of records written to file:            4007465
 
******************************************************
Table name - GS_ALSO_KNOWN
Number of records imported:                   1667348
Marked and sealed civil records deleted:      0
Number of records written to file:            1667348
 
******************************************************
Table name - GS_ARCHIVE_CASE 
Number of records imported:                   14331
Marked and sealed civil records deleted:      0
Number of records written to file:            14331
 
******************************************************
Table name - GS_ARCHIVE_PART 
Number of records imported:                   34225
Marked and sealed civil records deleted:      0
Number of records written to file:            34225
 
******************************************************
Table name - GS_ASSIGNMENT
Number of records imported:                   15418349
Marked and sealed civil records deleted:      0
Number of records written to file:            15418349
 
******************************************************
Table name - GS_CASE
Number of records imported:                   7779264
Marked and sealed civil records deleted:      0
Number of records written to file:            7779264
 
******************************************************
Table name - GS_CASE_CAUSE_ACT
Number of records imported:                   3192363
Marked and sealed civil records deleted:      0
Number of records written to file:            3192363
 
******************************************************
Table name - GS_CASE_DOJ_DIV
Number of records imported:                   507141
Marked and sealed civil records deleted:      0
Number of records written to file:            507141
 
******************************************************
Table name - GS_CASE_DOM_TERR_IND
Number of records imported:                   148071
Marked and sealed civil records deleted:      0
Number of records written to file:            148071
 
******************************************************
Table name - GS_CASE_PROG_CAT
Number of records imported:                   4855443
Marked and sealed civil records deleted:      0
Number of records written to file:            4855443
 
******************************************************
Table name - GS_CASE_SPECIAL_PROJ
Number of records imported:                   3777185
Marked and sealed civil records deleted:      0
Number of records written to file:            3777185
 
******************************************************
Table name - GS_COMMENT
Number of records imported:                   42788747
Marked and sealed civil records deleted:      0
Number of records written to file:            42788747
 
******************************************************
Table name - GS_CONT_SERVICES
Number of records imported:                   107
Marked and sealed civil records deleted:      0
Number of records written to file:            107
 
******************************************************
Table name - GS_CONTACT_LOG
Number of records imported:                   191141
Marked and sealed civil records deleted:      0
Number of records written to file:            191141
 
******************************************************
Table name - GS_CONTROL_SUB
Number of records imported:                   732532
Marked and sealed civil records deleted:      0
Number of records written to file:            732532
 
******************************************************
Table name - GS_COUNT
Number of records imported:                   9670222
Marked and sealed civil records deleted:      0
Number of records written to file:            9670222
 
******************************************************
Table name - GS_COURT_HIST
Number of records imported:                   10707766
Marked and sealed civil records deleted:      0
Number of records written to file:            10707766
 
******************************************************
Table name - GS_COURT_JUDGE
Number of records imported:                   6434574
Marked and sealed civil records deleted:      0
Number of records written to file:            6434574
 
******************************************************
Table name - GS_COURT_ORDER_DISP
Number of records imported:                   1875
Marked and sealed civil records deleted:      0
Number of records written to file:            314
 
******************************************************
Table name - GS_DEFEND_STAT
Number of records imported:                   2245204
Marked and sealed civil records deleted:      0
Number of records written to file:            2245204
 
******************************************************
Table name - GS_DNA
Number of records imported:                   14
Marked and sealed civil records deleted:      0
Number of records written to file:            14
 
******************************************************
Table name - GS_EVENT
Number of records imported:                   50846913
Marked and sealed civil records deleted:      0
Number of records written to file GS_EVENT (AK)         :             174105
Number of records written to file GS_EVENT (ALM)        :             203096
Number of records written to file GS_EVENT (ALN)        :             933201
Number of records written to file GS_EVENT (ALS)        :             182719
Number of records written to file GS_EVENT (ARE)        :             256498
Number of records written to file GS_EVENT (ARW)        :             226330
Number of records written to file GS_EVENT (AZ)         :             1970454
Number of records written to file GS_EVENT (CAC)        :             1627885
Number of records written to file GS_EVENT (CAE)        :             311133
Number of records written to file GS_EVENT (CAN)        :             988753
Number of records written to file GS_EVENT (CAS)        :             1464282
Number of records written to file GS_EVENT (CO)         :             477268
Number of records written to file GS_EVENT (CT)         :             450776
Number of records written to file GS_EVENT (DC)         :             1429985
Number of records written to file GS_EVENT (DE)         :             111775
Number of records written to file GS_EVENT (FLM)        :             1289418
Number of records written to file GS_EVENT (FLN)        :             590633
Number of records written to file GS_EVENT (FLS)        :             1044535
Number of records written to file GS_EVENT (GAM)        :             395539
Number of records written to file GS_EVENT (GAN)        :             277938
Number of records written to file GS_EVENT (GAS)        :             294208
Number of records written to file GS_EVENT (GU)         :             87739
Number of records written to file GS_EVENT (HI)         :             239540
Number of records written to file GS_EVENT (IAN)        :             521099
Number of records written to file GS_EVENT (IAS)        :             270577
Number of records written to file GS_EVENT (ID)         :             405208
Number of records written to file GS_EVENT (ILC)        :             161624
Number of records written to file GS_EVENT (ILN)        :             523367
Number of records written to file GS_EVENT (ILS)        :             505161
Number of records written to file GS_EVENT (INN)        :             407476
Number of records written to file GS_EVENT (INS)        :             278361
Number of records written to file GS_EVENT (KS)         :             953693
Number of records written to file GS_EVENT (KYE)        :             461463
Number of records written to file GS_EVENT (KYW)        :             590677
Number of records written to file GS_EVENT (LAE)        :             302738
Number of records written to file GS_EVENT (LAM)        :             141815
Number of records written to file GS_EVENT (LAW)        :             334381
Number of records written to file GS_EVENT (MA)         :             457270
Number of records written to file GS_EVENT (MD)         :             324163
Number of records written to file GS_EVENT (ME)         :             279438
Number of records written to file GS_EVENT (MIE)        :             529213
Number of records written to file GS_EVENT (MIW)        :             273144
Number of records written to file GS_EVENT (MN)         :             286911
Number of records written to file GS_EVENT (MOE)        :             399728
Number of records written to file GS_EVENT (MOW)        :             946408
Number of records written to file GS_EVENT (MSN)        :             265555
Number of records written to file GS_EVENT (MSS)        :             492402
Number of records written to file GS_EVENT (MT)         :             312075
Number of records written to file GS_EVENT (NCE)        :             728256
Number of records written to file GS_EVENT (NCM)        :             219920
Number of records written to file GS_EVENT (NCW)        :             503535
Number of records written to file GS_EVENT (ND)         :             327903
Number of records written to file GS_EVENT (NE)         :             376746
Number of records written to file GS_EVENT (NH)         :             263909
Number of records written to file GS_EVENT (NJ)         :             707499
Number of records written to file GS_EVENT (NM)         :             1813514
Number of records written to file GS_EVENT (NV)         :             853314
Number of records written to file GS_EVENT (NYE)        :             894912
Number of records written to file GS_EVENT (NYN)        :             295362
Number of records written to file GS_EVENT (NYS)        :             1207433
Number of records written to file GS_EVENT (NYW)        :             684780
Number of records written to file GS_EVENT (OHN)        :             982711
Number of records written to file GS_EVENT (OHS)        :             772214
Number of records written to file GS_EVENT (OKE)        :             153843
Number of records written to file GS_EVENT (OKN)        :             398179
Number of records written to file GS_EVENT (OKW)        :             323572
Number of records written to file GS_EVENT (OR)         :             388341
Number of records written to file GS_EVENT (PAE)        :             596810
Number of records written to file GS_EVENT (PAM)        :             547603
Number of records written to file GS_EVENT (PAW)        :             740903
Number of records written to file GS_EVENT (PR)         :             339351
Number of records written to file GS_EVENT (RI)         :             82605
Number of records written to file GS_EVENT (SC)         :             455547
Number of records written to file GS_EVENT (SD)         :             505781
Number of records written to file GS_EVENT (TNE)        :             444537
Number of records written to file GS_EVENT (TNM)        :             210495
Number of records written to file GS_EVENT (TNW)        :             477153
Number of records written to file GS_EVENT (TXE)        :             514387
Number of records written to file GS_EVENT (TXN)        :             864275
Number of records written to file GS_EVENT (TXS)        :             2318652
Number of records written to file GS_EVENT (TXW)        :             1272723
Number of records written to file GS_EVENT (UT)         :             486940
Number of records written to file GS_EVENT (VAE)        :             849566
Number of records written to file GS_EVENT (VAW)        :             339265
Number of records written to file GS_EVENT (VI)         :             201646
Number of records written to file GS_EVENT (VT)         :             211590
Number of records written to file GS_EVENT (WAE)        :             290212
Number of records written to file GS_EVENT (WAW)        :             333422
Number of records written to file GS_EVENT (WIE)        :             195256
Number of records written to file GS_EVENT (WIW)        :             308242
Number of records written to file GS_EVENT (WVN)        :             268866
Number of records written to file GS_EVENT (WVS)        :             485067
Number of records written to file GS_EVENT (WY)         :             158319
Total number of records written to file:                         50846913
 
******************************************************
Table name - GS_EVIDENCE
Number of records imported:                   5621
Marked and sealed civil records deleted:      0
Number of records written to file:            5621
 
******************************************************
Table name - GS_EXPERT_CASE
Number of records imported:                   1564
Marked and sealed civil records deleted:      0
Number of records written to file:            1564
 
******************************************************
Table name - GS_INST_CHARGE
Number of records imported:                   6865942
Marked and sealed civil records deleted:      0
Number of records written to file:            6865942
 
******************************************************
Table name - GS_INSTRUMENT
Number of records imported:                   4905589
Marked and sealed civil records deleted:      0
Number of records written to file:            4905589
 
******************************************************
Table name - GS_OPPOSE_COUN
Number of records imported:                   2347317
Marked and sealed civil records deleted:      0
Number of records written to file:            2347317
 
******************************************************
Table name - GS_ORDER_TYPE
Number of records imported:                   4
Marked and sealed civil records deleted:      0
Number of records written to file:            4
 
******************************************************
Table name - GS_PART_COUNT
Number of records imported:                   12888499
Marked and sealed civil records deleted:      0
Number of records written to file:            12888499
 
******************************************************
Table name - GS_PART_COURT
Number of records imported:                   16298855
Marked and sealed civil records deleted:      0
Number of records written to file:            16298855
 
******************************************************
Table name - GS_PART_EVENT
Number of records imported:                   67893850
Marked and sealed civil records deleted:      0
Number of records written to file GS_PART_EVENT (AK)         :             215772
Number of records written to file GS_PART_EVENT (ALM)        :             261744
Number of records written to file GS_PART_EVENT (ALN)        :             910633
Number of records written to file GS_PART_EVENT (ALS)        :             252663
Number of records written to file GS_PART_EVENT (ARE)        :             289947
Number of records written to file GS_PART_EVENT (ARW)        :             271420
Number of records written to file GS_PART_EVENT (AZ)         :             2389919
Number of records written to file GS_PART_EVENT (CAC)        :             2849564
Number of records written to file GS_PART_EVENT (CAE)        :             500044
Number of records written to file GS_PART_EVENT (CAN)        :             1178817
Number of records written to file GS_PART_EVENT (CAS)        :             1704571
Number of records written to file GS_PART_EVENT (CO)         :             925416
Number of records written to file GS_PART_EVENT (CT)         :             496207
Number of records written to file GS_PART_EVENT (DC)         :             1773830
Number of records written to file GS_PART_EVENT (DE)         :             128116
Number of records written to file GS_PART_EVENT (FLM)        :             1718563
Number of records written to file GS_PART_EVENT (FLN)        :             745575
Number of records written to file GS_PART_EVENT (FLS)        :             1665992
Number of records written to file GS_PART_EVENT (GAM)        :             530471
Number of records written to file GS_PART_EVENT (GAN)        :             308887
Number of records written to file GS_PART_EVENT (GAS)        :             322847
Number of records written to file GS_PART_EVENT (GU)         :             113015
Number of records written to file GS_PART_EVENT (HI)         :             299842
Number of records written to file GS_PART_EVENT (IAN)        :             607210
Number of records written to file GS_PART_EVENT (IAS)        :             316758
Number of records written to file GS_PART_EVENT (ID)         :             596599
Number of records written to file GS_PART_EVENT (ILC)        :             164670
Number of records written to file GS_PART_EVENT (ILN)        :             492694
Number of records written to file GS_PART_EVENT (ILS)        :             1034727
Number of records written to file GS_PART_EVENT (INN)        :             436292
Number of records written to file GS_PART_EVENT (INS)        :             493294
Number of records written to file GS_PART_EVENT (KS)         :             1307408
Number of records written to file GS_PART_EVENT (KYE)        :             598986
Number of records written to file GS_PART_EVENT (KYW)        :             671478
Number of records written to file GS_PART_EVENT (LAE)        :             348662
Number of records written to file GS_PART_EVENT (LAM)        :             175685
Number of records written to file GS_PART_EVENT (LAW)        :             447622
Number of records written to file GS_PART_EVENT (MA)         :             585334
Number of records written to file GS_PART_EVENT (MD)         :             296824
Number of records written to file GS_PART_EVENT (ME)         :             398569
Number of records written to file GS_PART_EVENT (MIE)        :             694321
Number of records written to file GS_PART_EVENT (MIW)        :             389502
Number of records written to file GS_PART_EVENT (MN)         :             355435
Number of records written to file GS_PART_EVENT (MOE)        :             514659
Number of records written to file GS_PART_EVENT (MOW)        :             1099928
Number of records written to file GS_PART_EVENT (MSN)        :             332279
Number of records written to file GS_PART_EVENT (MSS)        :             717035
Number of records written to file GS_PART_EVENT (MT)         :             381525
Number of records written to file GS_PART_EVENT (NCE)        :             840712
Number of records written to file GS_PART_EVENT (NCM)        :             239499
Number of records written to file GS_PART_EVENT (NCW)        :             821559
Number of records written to file GS_PART_EVENT (ND)         :             460614
Number of records written to file GS_PART_EVENT (NE)         :             557121
Number of records written to file GS_PART_EVENT (NH)         :             382974
Number of records written to file GS_PART_EVENT (NJ)         :             841522
Number of records written to file GS_PART_EVENT (NM)         :             2177141
Number of records written to file GS_PART_EVENT (NV)         :             1588675
Number of records written to file GS_PART_EVENT (NYE)        :             1469871
Number of records written to file GS_PART_EVENT (NYN)        :             291461
Number of records written to file GS_PART_EVENT (NYS)        :             2165638
Number of records written to file GS_PART_EVENT (NYW)        :             942647
Number of records written to file GS_PART_EVENT (OHN)        :             1375497
Number of records written to file GS_PART_EVENT (OHS)        :             1394738
Number of records written to file GS_PART_EVENT (OKE)        :             180483
Number of records written to file GS_PART_EVENT (OKN)        :             487217
Number of records written to file GS_PART_EVENT (OKW)        :             312505
Number of records written to file GS_PART_EVENT (OR)         :             399079
Number of records written to file GS_PART_EVENT (PAE)        :             851236
Number of records written to file GS_PART_EVENT (PAM)        :             605428
Number of records written to file GS_PART_EVENT (PAW)        :             741693
Number of records written to file GS_PART_EVENT (PR)         :             542054
Number of records written to file GS_PART_EVENT (RI)         :             91817
Number of records written to file GS_PART_EVENT (SC)         :             742268
Number of records written to file GS_PART_EVENT (SD)         :             613931
Number of records written to file GS_PART_EVENT (TNE)        :             574276
Number of records written to file GS_PART_EVENT (TNM)        :             257907
Number of records written to file GS_PART_EVENT (TNW)        :             581494
Number of records written to file GS_PART_EVENT (TXE)        :             849184
Number of records written to file GS_PART_EVENT (TXN)        :             1507585
Number of records written to file GS_PART_EVENT (TXS)        :             2879049
Number of records written to file GS_PART_EVENT (TXW)        :             1495032
Number of records written to file GS_PART_EVENT (UT)         :             638322
Number of records written to file GS_PART_EVENT (VAE)        :             1052736
Number of records written to file GS_PART_EVENT (VAW)        :             466346
Number of records written to file GS_PART_EVENT (VI)         :             276587
Number of records written to file GS_PART_EVENT (VT)         :             274030
Number of records written to file GS_PART_EVENT (WAE)        :             316973
Number of records written to file GS_PART_EVENT (WAW)        :             411976
Number of records written to file GS_PART_EVENT (WIE)        :             278708
Number of records written to file GS_PART_EVENT (WIW)        :             450996
Number of records written to file GS_PART_EVENT (WVN)        :             347038
Number of records written to file GS_PART_EVENT (WVS)        :             619152
Number of records written to file GS_PART_EVENT (WY)         :             187728
Total number of records written to file:                         67893850
 
******************************************************
Table name - GS_PART_RELIEF
Number of records imported:                   7257535
Marked and sealed civil records deleted:      0
Number of records written to file:            7257535
 
******************************************************
Table name - GS_PART_VICTIM
Number of records imported:                   508526
Marked and sealed civil records deleted:      0
Number of records written to file:            508526
 
******************************************************
Table name - GS_PARTICIPANT
Number of records imported:                   20908249
Marked and sealed civil records deleted:      0
Number of records written to file GS_PARTICIPANT (AK)         :             47447
Number of records written to file GS_PARTICIPANT (ALM)        :             66710
Number of records written to file GS_PARTICIPANT (ALN)        :             160244
Number of records written to file GS_PARTICIPANT (ALS)        :             82867
Number of records written to file GS_PARTICIPANT (ARE)        :             131164
Number of records written to file GS_PARTICIPANT (ARW)        :             70403
Number of records written to file GS_PARTICIPANT (AZ)         :             1217296
Number of records written to file GS_PARTICIPANT (CAC)        :             630601
Number of records written to file GS_PARTICIPANT (CAE)        :             265133
Number of records written to file GS_PARTICIPANT (CAN)        :             270429
Number of records written to file GS_PARTICIPANT (CAS)        :             509296
Number of records written to file GS_PARTICIPANT (CO)         :             191750
Number of records written to file GS_PARTICIPANT (CT)         :             171388
Number of records written to file GS_PARTICIPANT (DC)         :             363940
Number of records written to file GS_PARTICIPANT (DE)         :             57215
Number of records written to file GS_PARTICIPANT (FLM)        :             744851
Number of records written to file GS_PARTICIPANT (FLN)        :             123157
Number of records written to file GS_PARTICIPANT (FLS)        :             507155
Number of records written to file GS_PARTICIPANT (GAM)        :             111930
Number of records written to file GS_PARTICIPANT (GAN)        :             231138
Number of records written to file GS_PARTICIPANT (GAS)        :             124737
Number of records written to file GS_PARTICIPANT (GU)         :             24357
Number of records written to file GS_PARTICIPANT (HI)         :             113134
Number of records written to file GS_PARTICIPANT (IAN)        :             101528
Number of records written to file GS_PARTICIPANT (IAS)        :             94115
Number of records written to file GS_PARTICIPANT (ID)         :             91335
Number of records written to file GS_PARTICIPANT (ILC)        :             101667
Number of records written to file GS_PARTICIPANT (ILN)        :             449970
Number of records written to file GS_PARTICIPANT (ILS)        :             122315
Number of records written to file GS_PARTICIPANT (INN)        :             134631
Number of records written to file GS_PARTICIPANT (INS)        :             183584
Number of records written to file GS_PARTICIPANT (KS)         :             187197
Number of records written to file GS_PARTICIPANT (KYE)        :             160885
Number of records written to file GS_PARTICIPANT (KYW)        :             158815
Number of records written to file GS_PARTICIPANT (LAE)        :             111834
Number of records written to file GS_PARTICIPANT (LAM)        :             46889
Number of records written to file GS_PARTICIPANT (LAW)        :             136861
Number of records written to file GS_PARTICIPANT (MA)         :             184484
Number of records written to file GS_PARTICIPANT (MD)         :             210554
Number of records written to file GS_PARTICIPANT (ME)         :             87012
Number of records written to file GS_PARTICIPANT (MIE)        :             274575
Number of records written to file GS_PARTICIPANT (MIW)        :             112150
Number of records written to file GS_PARTICIPANT (MN)         :             141499
Number of records written to file GS_PARTICIPANT (MOE)        :             185541
Number of records written to file GS_PARTICIPANT (MOW)        :             182999
Number of records written to file GS_PARTICIPANT (MSN)        :             59382
Number of records written to file GS_PARTICIPANT (MSS)        :             121601
Number of records written to file GS_PARTICIPANT (MT)         :             84069
Number of records written to file GS_PARTICIPANT (NCE)        :             172492
Number of records written to file GS_PARTICIPANT (NCM)        :             102430
Number of records written to file GS_PARTICIPANT (NCW)        :             150051
Number of records written to file GS_PARTICIPANT (ND)         :             75146
Number of records written to file GS_PARTICIPANT (NE)         :             114081
Number of records written to file GS_PARTICIPANT (NH)         :             54547
Number of records written to file GS_PARTICIPANT (NJ)         :             426022
Number of records written to file GS_PARTICIPANT (NM)         :             424575
Number of records written to file GS_PARTICIPANT (NV)         :             194171
Number of records written to file GS_PARTICIPANT (NYE)        :             513365
Number of records written to file GS_PARTICIPANT (NYN)        :             185528
Number of records written to file GS_PARTICIPANT (NYS)        :             554096
Number of records written to file GS_PARTICIPANT (NYW)        :             231519
Number of records written to file GS_PARTICIPANT (OHN)        :             416810
Number of records written to file GS_PARTICIPANT (OHS)        :             366195
Number of records written to file GS_PARTICIPANT (OKE)        :             64586
Number of records written to file GS_PARTICIPANT (OKN)        :             106982
Number of records written to file GS_PARTICIPANT (OKW)        :             142580
Number of records written to file GS_PARTICIPANT (OR)         :             176387
Number of records written to file GS_PARTICIPANT (PAE)        :             236859
Number of records written to file GS_PARTICIPANT (PAM)        :             140909
Number of records written to file GS_PARTICIPANT (PAW)        :             185136
Number of records written to file GS_PARTICIPANT (PR)         :             159544
Number of records written to file GS_PARTICIPANT (RI)         :             40932
Number of records written to file GS_PARTICIPANT (SC)         :             338079
Number of records written to file GS_PARTICIPANT (SD)         :             120926
Number of records written to file GS_PARTICIPANT (TNE)        :             149001
Number of records written to file GS_PARTICIPANT (TNM)        :             81548
Number of records written to file GS_PARTICIPANT (TNW)        :             149457
Number of records written to file GS_PARTICIPANT (TXE)        :             203936
Number of records written to file GS_PARTICIPANT (TXN)        :             352775
Number of records written to file GS_PARTICIPANT (TXS)        :             1459232
Number of records written to file GS_PARTICIPANT (TXW)        :             1134481
Number of records written to file GS_PARTICIPANT (UT)         :             135795
Number of records written to file GS_PARTICIPANT (VAE)        :             514244
Number of records written to file GS_PARTICIPANT (VAW)        :             122898
Number of records written to file GS_PARTICIPANT (VI)         :             31741
Number of records written to file GS_PARTICIPANT (VT)         :             58251
Number of records written to file GS_PARTICIPANT (WAE)        :             96779
Number of records written to file GS_PARTICIPANT (WAW)        :             246520
Number of records written to file GS_PARTICIPANT (WIE)        :             157488
Number of records written to file GS_PARTICIPANT (WIW)        :             115431
Number of records written to file GS_PARTICIPANT (WVN)        :             62403
Number of records written to file GS_PARTICIPANT (WVS)        :             124166
Number of records written to file GS_PARTICIPANT (WY)         :             76321
Total number of records written to file:                         20908249
 
******************************************************
Table name - GS_PROP_VALUE
Number of records imported:                   170430
Marked and sealed civil records deleted:      0
Number of records written to file:            170430
 
******************************************************
Table name - GS_REGION
Number of records imported:                   681
Marked and sealed civil records deleted:      0
Number of records written to file:            681
 
******************************************************
Table name - GS_RELATE_APPEAL
Number of records imported:                   22779
Marked and sealed civil records deleted:      0
Number of records written to file:            22779
 
******************************************************
Table name - GS_RELATE_CASE
Number of records imported:                   1395066
Marked and sealed civil records deleted:      0
Number of records written to file:            1395066
 
******************************************************
Table name - GS_RELATE_PART
Number of records imported:                   934665
Marked and sealed civil records deleted:      0
Number of records written to file:            934665
 
******************************************************
Table name - GS_RELIEF
Number of records imported:                   6120889
Marked and sealed civil records deleted:      0
Number of records written to file:            6120889
 
******************************************************
Table name - GS_REQUEST
Number of records imported:                   20919
Marked and sealed civil records deleted:      0
Number of records written to file:            20919
 
******************************************************
Table name - GS_RESTITUTION
Number of records imported:                   243086
Marked and sealed civil records deleted:      0
Number of records written to file:            243086
 
******************************************************
Table name - GS_SENTENCE
Number of records imported:                   3465564
Marked and sealed civil records deleted:      0
Number of records written to file:            3465564
 
******************************************************
Table name - GS_STAFF
Number of records imported:                   62845
Marked and sealed civil records deleted:      0
Number of records written to file:            62845
 
******************************************************
Table name - GS_TRIGGERLOCK
Number of records imported:                   2097118
Marked and sealed civil records deleted:      0
Number of records written to file:            2097118
 
  
  
README.TXT FILES DISK01.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  05:22 PM       436,845,176 gs_also_known.txt
07/21/2026  06:20 PM         6,448,954 gs_archive_case.txt
07/21/2026  06:20 PM         7,905,979 gs_archive_part.txt
07/21/2026  05:26 PM     2,995,016,640 gs_case.txt
07/21/2026  05:27 PM       376,698,834 gs_case_cause_act.txt
07/21/2026  05:27 PM        77,592,573 gs_case_doj_div.txt
07/21/2026  05:43 PM        18,656,946 gs_case_dom_terr_ind.txt
               7 File(s)  3,919,165,102 bytes
               0 Dir(s)  2,801,908,252,672 bytes free
  
Table Layouts:

GS_ALSO_KNOWN - 260 Characters                        

| FieldName        | FieldType    | Position (From:To) |
| ---------------- | ------------ | ------------------ |
| **DISTRICT**     | VARCHAR2(10) | (001:010)          |
| **CASEID**       | VARCHAR2(10) | (011:020)          |
| **TR1_UNIQUEID** | VARCHAR2(10) | (021:030)          |
| **PARTID**       | VARCHAR2(10) | (031:040)          |
| **ID**           | VARCHAR2(10) | (041:050)          |
| **LAST_NAME**    | VARCHAR2(60) | (051:110)          |
| **FIRST_NAME**   | VARCHAR2(60) | (111:170)          |
| **LAST_SOUNDS**  | VARCHAR2(4)  | (171:174)          |
| **FIRST_SOUNDS** | VARCHAR2(4)  | (175:178)          |
| **CREATE_DATE**  | DATE(11)     | (179:189)          |
| **CREATE_USER**  | VARCHAR2(30) | (190:219)          |
| **UPDATE_DATE**  | DATE(11)     | (220:230)          |
| **UPDATE_USER**  | VARCHAR2(30) | (231:260)          |



GS_ARCHIVE_CASE - 448 Characters                        

Name              Null?      Type           Position
DISTRICT          NOT NULL   VARCHAR2(10)   (1:10)
ID                NOT NULL   VARCHAR2(10)   (11:20)
CLASS             NOT NULL   VARCHAR2(1)    (21:21)
NAME                         VARCHAR2(50)   (22:71)
RECVD_DATE        NOT NULL   DATE           (72:82)
US_ROLE                      VARCHAR2(2)    (83:84)
LEAD_CHARGE                  VARCHAR2(25)   (85:109)
PROG_CAT                     VARCHAR2(3)    (110:112)
CAUSE_ACT                    VARCHAR2(4)    (113:116)
BRANCH                       VARCHAR2(3)    (117:119)
COMMENTS                     VARCHAR2(60)   (120:179)
COURT                        VARCHAR2(2)    (180:181)
LOCATION                     VARCHAR2(2)    (182:183)
COURT_NUMBER                 VARCHAR2(25)   (184:208)
FILING_DATE                  DATE           (209:219)
SERVICE_DATE                 DATE           (220:230)
DISPOSITION       NOT NULL   VARCHAR2(2)    (231:232)
DISP_REASON                  VARCHAR2(4)    (233:236)
DISP_DATE         NOT NULL   DATE           (237:247)
INST_TYPE                    VARCHAR2(2)    (248:249)
INST_FILE_DATE               DATE           (250:260)
AUSA_LAST_NAME               VARCHAR2(30)   (261:290)
AUSA_FIRST_NAME              VARCHAR2(30)   (291:320)
AGENCY            NOT NULL   VARCHAR2(4)    (321:324)
APPEALS_FILED                NUMBER(11)     (325:335)
STORE_NUM                    VARCHAR2(20)   (336:355)
DEST_DATE                    DATE           (356:366)
CREATE_DATE                  DATE           (367:377)
CREATE_USER                  VARCHAR2(30)   (378:407)
UPDATE_DATE                  DATE           (408:418)
UPDATE_USER                  VARCHAR2(30)   (419:448)


GS_ARCHIVE_PART - 229 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)
LAST_NAME      NOT NULL   VARCHAR2(60)   (31:90)
FIRST_NAME                VARCHAR2(30)   (91:120)
LAST_SOUNDS    NOT NULL   VARCHAR2(4)    (121:124)
FIRST_SOUNDS              VARCHAR2(4)    (125:128)
ROLE           NOT NULL   VARCHAR2(2)    (129:130)
DISPOSITION               VARCHAR2(2)    (131:132)
DISP_REASON               VARCHAR2(4)    (133:136)
DISP_DATE                 DATE           (137:147)
CREATE_DATE               DATE           (148:158)
CREATE_USER               VARCHAR2(30)   (159:188)
UPDATE_DATE               DATE           (189:199)
UPDATE_USER               VARCHAR2(30)   (200:229)


GS_CASE - 383 Characters    

| FieldName            | FieldType    | Position (From:To) |
| -------------------- | ------------ | ------------------ |
| **DISTRICT**         | VARCHAR2(10) | (001:010)          |
| **CASEID**           | VARCHAR2(10) | (011:020)          |
| **TR1_UNIQUEID**     | VARCHAR2(10) | (021:030)          |
| **CLASS**            | VARCHAR2(1)  | (031:031)          |
| **NAME**             | VARCHAR2(50) | (032:081)          |
| **RECVD_DATE**       | DATE(11)     | (082:092)          |
| **SECURITY**         | VARCHAR2(1)  | (093:093)          |
| **PRIORITY**         | VARCHAR2(1)  | (094:094)          |
| **TYPE**             | VARCHAR2(4)  | (095:098)          |
| **US_ROLE**          | VARCHAR2(2)  | (099:100)          |
| **LIT_RESP**         | VARCHAR2(2)  | (101:102)          |
| **LIT_TRACK**        | VARCHAR2(1)  | (103:103)          |
| **WEIGHT**           | VARCHAR2(2)  | (104:105)          |
| **BRANCH**           | VARCHAR2(3)  | (106:108)          |
| **GRAND_JURY_NUM**   | VARCHAR2(15) | (109:123)          |
| **UNIT**             | VARCHAR2(4)  | (124:127)          |
| **DCMNS_NUMBER**     | VARCHAR2(11) | (128:138)          |
| **TRIBE**            | VARCHAR2(4)  | (139:142)          |
| **RESERVATION**      | VARCHAR2(4)  | (143:146)          |
| **SPEC_PROJ**        | VARCHAR2(2)  | (147:148)          |
| **VIC_WIT**          | VARCHAR2(1)  | (149:149)          |
| **ADR_MODE**         | VARCHAR2(2)  | (150:151)          |
| **COLLECT_IND**      | VARCHAR2(1)  | (152:152)          |
| **OFFENSE_FROM**     | DATE(11)     | (153:163)          |
| **OFFENSE_TO**       | DATE(11)     | (164:174)          |
| **LEAD_CHARGE**      | VARCHAR2(25) | (175:199)          |
| **PHYSICAL_LOC**     | VARCHAR2(20) | (200:219)          |
| **STORE_NUM**        | VARCHAR2(20) | (220:239)          |
| **CIVIL_POTEN**      | VARCHAR2(1)  | (240:240)          |
| **SYS_INIT_DATE**    | DATE(11)     | (241:251)          |
| **ACCESS_DATE**      | DATE(11)     | (252:262)          |
| **STATUS**           | VARCHAR2(1)  | (263:263)          |
| **CLOSE_DATE**       | DATE(11)     | (264:274)          |
| **DEST_DATE**        | DATE(11)     | (275:285)          |
| **PERMANENT**        | VARCHAR2(1)  | (286:286)          |
| **CASE_RESTRICTED**  | VARCHAR2(1)  | (287:287)          |
| **CRIMINAL_POTEN**   | VARCHAR2(1)  | (288:288)          |
| **TOT_VICTIMS**      | VARCHAR2(11) | (289:299)          |
| **RELATED_FLU_FLAG** | VARCHAR2(1)  | (300:300)          |
| **QUI_TAM**          | VARCHAR2(1)  | (301:301)          |
| **CREATE_DATE**      | DATE(11)     | (302:312)          |
| **CREATE_USER**      | VARCHAR2(30) | (313:342)          |
| **UPDATE_DATE**      | DATE(11)     | (343:353)          |
| **UPDATE_USER**      | VARCHAR2(30) | (354:383)          |


GS_CASE_CAUSE_ACT - 116 Characters                        

| FieldName       | FieldType    | Position (From:To) |
| --------------- | ------------ | ------------------ |
| **DISTRICT**    | VARCHAR2(10) | (001:010)          |
| **CASEID**      | VARCHAR2(10) | (011:020)          |
| **CAUSE_ACT**   | VARCHAR2(4)  | (021:024)          |
| **ID**          | VARCHAR2(10) | (025:034)          |
| **CREATE_DATE** | DATE(11)     | (035:045)          |
| **CREATE_USER** | VARCHAR2(30) | (046:075)          |
| **UPDATE_DATE** | DATE(11)     | (076:086)          |
| **UPDATE_USER** | VARCHAR2(30) | (087:116)          |


GS_CASE_DOJ_DIV - 151 Characters                        

| FieldName        | FieldType    | Position (From:To) |
| ---------------- | ------------ | ------------------ |
| **DISTRICT**     | VARCHAR2(10) | (001:010)          |
| **CASEID**       | VARCHAR2(10) | (011:020)          |
| **TR1_UNIQUEID** | VARCHAR2(10) | (021:030)          |
| **ID**           | VARCHAR2(10) | (031:040)          |
| **DOJ_DIV**      | VARCHAR2(4)  | (041:044)          |
| **DOJ_NUMBER**   | VARCHAR2(25) | (045:069)          |
| **CREATE_DATE**  | DATE(11)     | (070:080)          |
| **CREATE_USER**  | VARCHAR2(30) | (081:110)          |
| **UPDATE_DATE**  | DATE(11)     | (111:121)          |
| **UPDATE_USER**  | VARCHAR2(30) | (122:151)          |


GS_CASE_DOM_TERR_IND - 114 Characters                        

| FieldName        | FieldType    | Position (From:To) |
| ---------------- | ------------ | ------------------ |
| **DISTRICT**     | VARCHAR2(10) | (001:010)          |
| **ID**           | VARCHAR2(10) | (011:020)          |
| **CASEID**       | VARCHAR2(10) | (021:030)          |
| **TR1_UNIQUEID** | VARCHAR2(10) | (031:040)          |
| **DOM_TERR_IND** | VARCHAR2(2)  | (041:042)          |
| **CREATE_DATE**  | DATE(11)     | (043:053)          |
| **CREATE_USER**  | VARCHAR2(30) | (054:083)          |
| **UPDATE_DATE**  | DATE(11)     | (084:094)          |
| **UPDATE_USER**  | VARCHAR2(30) | (095:124)          |


  
  
README.TXT FILES DISK02.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  05:27 PM       616,641,261 gs_case_prog_cat.txt
07/21/2026  05:43 PM       475,925,310 gs_case_special_proj.txt
07/21/2026  05:47 PM            17,762 gs_cont_services.txt
07/21/2026  05:47 PM        31,347,124 gs_contact_log.txt
07/21/2026  05:27 PM       124,530,440 gs_control_sub.txt
07/21/2026  05:47 PM         1,141,063 gs_evidence.txt
07/21/2026  05:47 PM           211,140 gs_expert_case.txt
07/21/2026  05:32 PM                 0 gs_inst_charge.txt
07/21/2026  05:48 PM        98,145,518 gs_part_victim.txt
07/21/2026  05:38 PM       231,580,956 gs_relate_case.txt
07/21/2026  05:38 PM       127,114,440 gs_relate_part.txt
              11 File(s)  1,706,655,014 bytes
               0 Dir(s)  2,801,908,244,480 bytes free
  
Table Layouts:


GS_CASE_PROG_CAT - 125 Characters                        

| FieldName        | FieldType    | Position (From:To) |
| ---------------- | ------------ | ------------------ |
| **DISTRICT**     | VARCHAR2(10) | (001:010)          |
| **CASEID**       | VARCHAR2(10) | (011:020)          |
| **TR1_UNIQUEID** | VARCHAR2(10) | (021:030)          |
| **PROG_CAT**     | VARCHAR2(3)  | (031:033)          |
| **ID**           | VARCHAR2(10) | (034:043)          |
| **CREATE_DATE**  | DATE(11)     | (044:054)          |
| **CREATE_USER**  | VARCHAR2(30) | (055:084)          |
| **UPDATE_DATE**  | DATE(11)     | (085:095)          |
| **UPDATE_USER**  | VARCHAR2(30) | (096:125)          |


GS_CASE_SPECIAL_PROJ - 124 Characters                        

| FieldName        | FieldType    | Position (From:To) |
| ---------------- | ------------ | ------------------ |
| **DISTRICT**     | VARCHAR2(10) | (001:010)          |
| **CASEID**       | VARCHAR2(10) | (011:020)          |
| **TR1_UNIQUEID** | VARCHAR2(10) | (021:030)          |
| **ID**           | VARCHAR2(10) | (031:040)          |
| **SPECIAL_PROJ** | VARCHAR2(2)  | (041:042)          |
| **CREATE_DATE**  | DATE(11)     | (043:053)          |
| **CREATE_USER**  | VARCHAR2(30) | (054:083)          |
| **UPDATE_DATE**  | DATE(11)     | (084:094)          |
| **UPDATE_USER**  | VARCHAR2(30) | (095:124)          |


GS_EVIDENCE - 201 Characters                        

| Field Name         | Field Type  | Position (From:To) |
| ------------------ | ----------- | ------------------ |
| **DISTRICT**       | VARCHAR(10) | (001:010)          |
| **CASEID**         | VARCHAR(10) | (011:020)          |
| **TR1_UNIQUEID**   | VARCHAR(10) | (021:030)          |
| **ID**             | VARCHAR(10) | (031:040)          |
| **LOCATION**       | VARCHAR(4)  | (041:044)          |
| **TYPE**           | VARCHAR(2)  | (045:046)          |
| **DISPOSITION**    | VARCHAR(1)  | (047:047)          |
| **STORE_DATE**     | DATE(11)    | (048:058)          |
| **DISP_DATE**      | DATE(11)    | (059:069)          |
| **DC_EXHIBIT_NUM** | VARCHAR(25) | (070:094)          |
| **GJ_EXHIBIT_NUM** | VARCHAR(25) | (095:119)          |
| **CREATE_DATE**    | DATE(11)    | (120:130)          |
| **CREATE_USER**    | VARCHAR(30) | (131:160)          |
| **UPDATE_DATE**    | DATE(11)    | (161:171)          |
| **UPDATE_USER**    | VARCHAR(30) | (172:201)          |


GS_EXPERT_CASE - 133 Characters                        

| Field Name       | Field Type  | Position (From:To) |
| ---------------- | ----------- | ------------------ |
| **DISTRICT**     | VARCHAR(10) | (001:010)          |
| **CASEID**       | VARCHAR(10) | (011:020)          |
| **TR1_UNIQUEID** | VARCHAR(10) | (021:030)          |
| **ID**           | VARCHAR(10) | (031:040)          |
| **EXP_SIDE**     | VARCHAR(1)  | (041:041)          |
| **EXPERTID**     | VARCHAR(10) | (042:051)          |
| **CREATE_DATE**  | DATE(11)    | (052:062)          |
| **CREATE_USER**  | VARCHAR(30) | (063:092)          |
| **UPDATE_DATE**  | DATE(11)    | (093:103)          |
| **UPDATE_USER**  | VARCHAR(30) | (104:133)          |


GS_INST_CHARGE - 183 Characters                        

| Field Name      | Field Type  | Position (From:To) |
| --------------- | ----------- | ------------------ |
| **DISTRICT**    | VARCHAR(10) | (001:010)          |
| **CASEID**      | VARCHAR(10) | (011:020)          |
| **CRTHISID**    | VARCHAR(10) | (021:030)          |
| **INSTID**      | VARCHAR(10) | (031:040)          |
| **CHARGE**      | VARCHAR(25) | (041:065)          |
| **CATEGORY**    | VARCHAR(1)  | (066:066)          |
| **PENT_PROV**   | VARCHAR(25) | (067:091)          |
| **CREATE_DATE** | DATE(11)    | (092:102)          |
| **CREATE_USER** | VARCHAR(30) | (103:132)          |
| **UPDATE_DATE** | DATE(11)    | (133:143)          |
| **UPDATE_USER** | VARCHAR(30) | (144:173)          |
| **ID**          | VARCHAR(10) | (174:183)          |


GS_PART_VICTIM - 191 Characters                        

| Field Name             | Field Type  | Position (From:To) |
| ---------------------- | ----------- | ------------------ |
| **DISTRICT**           | VARCHAR(10) | (001:010)          |
| **CASEID**             | VARCHAR(10) | (011:020)          |
| **TR1_UNIQUEID**       | VARCHAR(10) | (021:030)          |
| **PARTID**             | VARCHAR(10) | (031:040)          |
| **ID**                 | VARCHAR(10) | (041:050)          |
| **VICTIM_TYPE**        | VARCHAR(1)  | (051:051)          |
| **PROSECUTION**        | VARCHAR(1)  | (052:052)          |
| **VICTIM_TIMES**       | VARCHAR(11) | (053:063)          |
| **THREATS**            | VARCHAR(1)  | (064:064)          |
| **ELDERLY**            | VARCHAR(1)  | (065:065)          |
| **VICTIM_IDENTIFIER**  | VARCHAR(25) | (066:090)          |
| **STATE_COMP_RECVD**   | VARCHAR(14) | (091:104)          |
| **SERVICES_REQUESTED** | VARCHAR(1)  | (105:105)          |
| **VIOLENT_CRIME**      | VARCHAR(1)  | (106:106)          |
| **DISABILITY**         | VARCHAR(1)  | (107:107)          |
| **NOTIFICAT_REQSTD**   | VARCHAR(1)  | (108:108)          |
| **NOTIFICAT_RECVD**    | VARCHAR(1)  | (109:109)          |
| **CREATE_DATE**        | DATE(11)    | (110:120)          |
| **CREATE_USER**        | VARCHAR(30) | (121:150)          |
| **UPDATE_DATE**        | DATE(11)    | (151:161)          |
| **UPDATE_USER**        | VARCHAR(30) | (162:191)          |


GS_RELATE_CASE - 164 Characters                        

| Field Name       | Field Type  | Position (From:To) |
| ---------------- | ----------- | ------------------ |
| **DISTRICT**     | VARCHAR(10) | (001:010)          |
| **CASEID1**      | VARCHAR(10) | (011:020)          |
| **CASEID2**      | VARCHAR(10) | (021:030)          |
| **TR1_UNIQUEID** | VARCHAR(10) | (031:040)          |
| **TR2_UNIQUEID** | VARCHAR(10) | (041:050)          |
| **CRTHISID1**    | VARCHAR(10) | (051:060)          |
| **CRTHISID2**    | VARCHAR(10) | (061:070)          |
| **REASON**       | VARCHAR(2)  | (071:072)          |
| **CREATE_DATE**  | DATE(11)    | (073:083)          |
| **CREATE_USER**  | VARCHAR(30) | (084:113)          |
| **UPDATE_DATE**  | DATE(11)    | (114:124)          |
| **UPDATE_USER**  | VARCHAR(30) | (125:154)          |
| **ID**           | VARCHAR(10) | (155:164)          |


GS_RELATE_PART - 134 Characters                        

| Field Name       | Field Type  | Position (From:To) |
| ---------------- | ----------- | ------------------ |
| **DISTRICT**     | VARCHAR(10) | (1:10)             |
| **CASEID**       | VARCHAR(10) | (11:20)            |
| **TR1_UNIQUEID** | VARCHAR(10) | (21:30)            |
| **PARTID1**      | VARCHAR(10) | (31:40)            |
| **PARTID2**      | VARCHAR(10) | (41:50)            |
| **REASON**       | VARCHAR(2)  | (51:52)            |
| **CREATE_DATE**  | DATE(11)    | (53:63)            |
| **CREATE_USER**  | VARCHAR(30) | (64:93)            |
| **UPDATE_DATE**  | DATE(11)    | (94:104)           |
| **UPDATE_USER**  | VARCHAR(30) | (105:134)          |


GS_CONT_SERVICES - 164 Characters                        

| Field Name        | Field Type  | Position (From:To) |
| ----------------- | ----------- | ------------------ |
| **DISTRICT**      | VARCHAR(10) | (1:10)             |
| **CASEID**        | VARCHAR(10) | (11:20)            |
| **TR1_UNIQUEID**  | VARCHAR(10) | (21:30)            |
| **PARTID**        | VARCHAR(10) | (31:40)            |
| **CONTID**        | VARCHAR(10) | (41:50)            |
| **ID**            | VARCHAR(10) | (51:60)            |
| **SERV_AGENCY**   | VARCHAR(11) | (61:71)            |
| **SERV_TYPE**     | VARCHAR(4)  | (72:75)            |
| **SERV_LANGUAGE** | VARCHAR(3)  | (76:78)            |
| **SERV_SPECIAL**  | VARCHAR(4)  | (79:82)            |
| **CREATE_DATE**   | DATE(11)    | (83:93)            |
| **CREATE_USER**   | VARCHAR(30) | (94:123)           |
| **UPDATE_DATE**   | DATE(11)    | (124:134)          |
| **UPDATE_USER**   | VARCHAR(30) | (135:164)          |


GS_CONTACT_LOG - 162 Characters                        

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **CASEID**       | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID** | VARCHAR(10)    | (21:30)      |
| **PARTID**       | VARCHAR(10)    | (31:40)      |
| **ID**           | VARCHAR(10)    | (41:50)      |
| **CONT_DATE**    | DATE (11)      | (51:61)      |
| **PURPOSE**      | VARCHAR(2)     | (62:63)      |
| **TYPE**         | VARCHAR(2)     | (64:65)      |
| **INITIATOR**    | VARCHAR(2)     | (66:67)      |
| **STAFFID**      | VARCHAR(10)    | (68:77)      |
| **DOC_CODE**     | VARCHAR(3)     | (78:80)      |
| **CREATE_DATE**  | DATE (11)      | (81:91)      |
| **CREATE_USER**  | VARCHAR(30)    | (92:121)     |
| **UPDATE_DATE**  | DATE (11)      | (122:132)    |
| **UPDATE_USER**  | VARCHAR(30)    | (133:162)    |


GS_CONTROL_SUB - 168 Characters                        

| **Field Name**    | **Field Type** | **Position** |
| ----------------- | -------------- | ------------ |
| **DISTRICT**      | VARCHAR(10)    | (01:10)      |
| **CASEID**        | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**  | VARCHAR(10)    | (21:30)      |
| **ID**            | VARCHAR(10)    | (31:40)      |
| **TYPE**          | VARCHAR(1)     | (41:41)      |
| **QUANTITY**      | VARCHAR(14)    | (42:55)      |
| **MEASURE**       | VARCHAR(1)     | (56:56)      |
| **OTHER_DESCRIP** | VARCHAR(30)    | (57:86)      |
| **CREATE_DATE**   | DATE (11)      | (87:97)      |
| **CREATE_USER**   | VARCHAR(30)    | (98:127)     |
| **UPDATE_DATE**   | DATE (11)      | (128:138)    |
| **UPDATE_USER**   | VARCHAR(30)    | (139:168)    |


  
  
README.TXT FILES DISK03.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  05:28 PM     1,885,693,290 gs_count.txt
               1 File(s)  1,885,693,290 bytes
               0 Dir(s)  2,801,908,232,192 bytes free
  
Table Layouts:

GS_COUNT - 193 Characters                        

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **CASEID**       | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID** | VARCHAR(10)    | (21:30)      |
| **CRTHISID**     | VARCHAR(10)    | (31:40)      |
| **INSTID**       | VARCHAR(10)    | (41:50)      |
| **CHARGE**       | VARCHAR(25)    | (51:75)      |
| **CATEGORY**     | VARCHAR(1)     | (76:76)      |
| **ID**           | VARCHAR(10)    | (77:86)      |
| **CREATE_DATE**  | DATE (11)      | (87:97)      |
| **CREATE_USER**  | VARCHAR(30)    | (98:127)     |
| **UPDATE_DATE**  | DATE (11)      | (128:138)    |
| **UPDATE_USER**  | VARCHAR(30)    | (139:168)    |
| **PENT_PROV**    | VARCHAR(25)    | (169:193)    |
  
  
README.TXT FILES DISK04.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  05:31 PM     2,955,343,416 gs_court_hist.txt
07/21/2026  05:31 PM     1,093,877,580 gs_court_judge.txt
07/21/2026  05:32 PM             1,638 gs_dna.txt
07/21/2026  05:48 PM               916 gs_order_type.txt
07/21/2026  05:48 PM        27,439,230 gs_prop_value.txt
07/21/2026  05:38 PM            81,720 gs_region.txt
07/21/2026  05:48 PM         3,553,524 gs_relate_appeal.txt
               7 File(s)  4,080,298,024 bytes
               0 Dir(s)  2,801,908,232,192 bytes free
  
Table Layouts:

GS_COURT_HIST - 274 Characters                        

| **Field Name**      | **Field Type** | **Position** |
| ------------------- | -------------- | ------------ |
| **DISTRICT**        | VARCHAR(10)    | (01:10)      |
| **CASEID**          | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**    | VARCHAR(10)    | (21:30)      |
| **ID**              | VARCHAR(10)    | (31:40)      |
| **COURT**           | VARCHAR(2)     | (41:42)      |
| **LOCATION**        | VARCHAR(2)     | (43:44)      |
| **US_ROLE**         | VARCHAR(2)     | (45:46)      |
| **COURT_NUMBER**    | VARCHAR(50)    | (47:96)      |
| **FILING_DATE**     | DATE (11)      | (97:107)     |
| **SERVICE_DATE**    | DATE (11)      | (108:118)    |
| **TRIAL_DAYS**      | VARCHAR(14)    | (119:132)    |
| **NOAP_DATE**       | DATE (11)      | (133:143)    |
| **APPEAL_TYPE**     | VARCHAR(1)     | (144:144)    |
| **SENT_APPEAL**     | VARCHAR(1)     | (145:145)    |
| **DISPOSITION**     | VARCHAR(2)     | (146:147)    |
| **DISP_DATE**       | DATE (11)      | (148:158)    |
| **DISP_REASON1**    | VARCHAR(4)     | (159:162)    |
| **DISP_REASON2**    | VARCHAR(4)     | (163:166)    |
| **DISP_REASON3**    | VARCHAR(4)     | (167:170)    |
| **SYS_DISP_DATE**   | DATE (11)      | (171:181)    |
| **SYS_FILING_DATE** | DATE (11)      | (182:192)    |
| **CREATE_DATE**     | DATE (11)      | (193:203)    |
| **CREATE_USER**     | VARCHAR(30)    | (204:233)    |
| **UPDATE_DATE**     | DATE (11)      | (234:244)    |
| **UPDATE_USER**     | VARCHAR(30)    | (245:274)    |


GS_COURT_JUDGE - 168 Characters                        

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **CASEID**       | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID** | VARCHAR(10)    | (21:30)      |
| **CRTHISID**     | VARCHAR(10)    | (31:40)      |
| **ID**           | VARCHAR(10)    | (41:50)      |
| **JUDGEID**      | VARCHAR(10)    | (51:60)      |
| **DECISION**     | VARCHAR(4)     | (61:64)      |
| **START_DATE**   | DATE (11)      | (65:75)      |
| **END_DATE**     | DATE (11)      | (76:86)      |
| **CREATE_DATE**  | DATE (11)      | (87:97)      |
| **CREATE_USER**  | VARCHAR(30)    | (98:127)     |
| **UPDATE_DATE**  | DATE (11)      | (128:138)    |
| **UPDATE_USER**  | VARCHAR(30)    | (139:168)    |


GS_DNA - 115 Characters

| **Field Name**                     | **Field Type** | **Position** |
| ---------------------------------- | -------------- | ------------ |
| **DISTRICT**                       | VARCHAR(3)     | (01:03)      |
| **ID**                             | VARCHAR(10)    | (04:13)      |
| **CASEID**                         | VARCHAR(10)    | (14:23)      |
| **PROCEEDINGS_AFT_RELIEF_GRANTED** | VARCHAR(1)     | (24:24)      |
| **NEW_TRIAL_ORD**                  | VARCHAR(1)     | (25:25)      |
| **CHARGE_DISMISSED**               | VARCHAR(1)     | (26:26)      |
| **FOUND_GUILTY**                   | VARCHAR(1)     | (27:27)      |
| **GUILTY_PLEA_ENTERED**            | VARCHAR(1)     | (28:28)      |
| **ACQUITTED**                      | VARCHAR(1)     | (29:29)      |
| **RESENTENCING_CAP_CASE**          | VARCHAR(1)     | (30:30)      |
| **TESTING_ORDERED**                | VARCHAR(1)     | (31:31)      |
| **RELIEF_GRANTED**                 | VARCHAR(1)     | (32:32)      |
| **COMMENTS**                       | VARCHAR(1)     | (33:33)      |
| **CREATE_DATE**                    | DATE (11)      | (34:44)      |
| **CREATE_USER**                    | VARCHAR(30)    | (45:74)      |
| **UPDATE_DATE**                    | DATE (11)      | (75:85)      |
| **UPDATE_USER**                    | VARCHAR(30)    | (86:115)     |


GS_PROP_VALUE - 159 Characters                        

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **CASEID**       | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID** | VARCHAR(10)    | (21:30)      |
| **PARTID**       | VARCHAR(10)    | (31:40)      |
| **ID**           | VARCHAR(10)    | (41:50)      |
| **TYPE**         | VARCHAR(2)     | (51:52)      |
| **VALUE**        | VARCHAR(14)    | (53:66)      |
| **PROP_DATE**    | DATE (11)      | (67:77)      |
| **CREATE_DATE**  | DATE (11)      | (78:88)      |
| **CREATE_USER**  | VARCHAR(30)    | (89:118)     |
| **UPDATE_DATE**  | DATE (11)      | (119:129)    |
| **UPDATE_USER**  | VARCHAR(30)    | (130:159)    |


GS_REGION - 118 Characters                        

| **Field Name**  | **Field Type** | **Position** |
| --------------- | -------------- | ------------ |
| **DISTRICT**    | VARCHAR(3)     | (01:03)      |
| **BRANCH**      | VARCHAR(3)     | (04:06)      |
| **DESCRIPTION** | VARCHAR(30)    | (07:36)      |
| **CREATE_DATE** | DATE (11)      | (37:47)      |
| **CREATE_USER** | VARCHAR(30)    | (48:77)      |
| **UPDATE_DATE** | DATE (11)      | (78:88)      |
| **UPDATE_USER** | VARCHAR(30)    | (89:118)     |


GS_RELATE_APPEAL - 154 Characters                        

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **CASEID1**      | VARCHAR(10)    | (11:20)      |
| **CASEID2**      | VARCHAR(10)    | (21:30)      |
| **TR1_UNIQUEID** | VARCHAR(10)    | (31:40)      |
| **TR2_UNIQUEID** | VARCHAR(10)    | (41:50)      |
| **CRTHISID1**    | VARCHAR(10)    | (51:60)      |
| **CRTHISID2**    | VARCHAR(10)    | (61:70)      |
| **REASON**       | VARCHAR(2)     | (71:72)      |
| **CREATE_DATE**  | DATE (11)      | (73:83)      |
| **CREATE_USER**  | VARCHAR(30)    | (84:113)     |
| **UPDATE_DATE**  | DATE (11)      | (114:124)    |
| **UPDATE_USER**  | VARCHAR(30)    | (125:154)    |


  
  
README.TXT FILES DISK05.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  05:42 PM     1,244,137,476 gs_sentence.txt
07/21/2026  06:03 PM        72,601,785 gs_event_AK.txt
07/21/2026  06:03 PM        84,691,032 gs_event_ALM.txt
07/21/2026  06:03 PM       389,144,817 gs_event_ALN.txt
07/21/2026  06:03 PM        76,193,823 gs_event_ALS.txt
07/21/2026  06:03 PM       106,959,666 gs_event_ARE.txt
07/21/2026  06:03 PM        94,379,610 gs_event_ARW.txt
07/21/2026  06:04 PM       821,679,318 gs_event_AZ.txt
07/21/2026  06:04 PM       678,828,045 gs_event_CAC.txt
07/21/2026  06:04 PM       129,742,461 gs_event_CAE.txt
              10 File(s)  3,698,358,033 bytes
               0 Dir(s)  2,801,908,224,000 bytes free
  
Table Layouts:

GS_SENTENCE - 357 Characters                        

| **Field Name**           | **Field Type** | **Position** |
| ------------------------ | -------------- | ------------ |
| **DISTRICT**             | VARCHAR(10)    | (01:10)      |
| **CASEID**               | VARCHAR(10)    | (11:20)      |
| **PARTID**               | VARCHAR(10)    | (21:30)      |
| **SENT_DATE**            | DATE (11)      | (31:41)      |
| **GUIDE_DEPART**         | VARCHAR(1)     | (42:42)      |
| **INCAR_TYPE**           | VARCHAR(3)     | (43:45)      |
| **JUDGEID**              | VARCHAR(10)    | (46:55)      |
| **PROB_DAYS**            | VARCHAR(11)    | (56:66)      |
| **PROB_MONTHS**          | VARCHAR(11)    | (67:77)      |
| **PROB_YEARS**           | VARCHAR(11)    | (78:88)      |
| **SUPER_REL_DAYS**       | VARCHAR(11)    | (89:99)      |
| **SUPER_REL_MONTHS**     | VARCHAR(11)    | (100:110)    |
| **SUPER_REL_YEARS**      | VARCHAR(11)    | (111:121)    |
| **INCAR_DAYS**           | VARCHAR(11)    | (122:132)    |
| **INCAR_MONTHS**         | VARCHAR(11)    | (133:143)    |
| **INCAR_YEARS**          | VARCHAR(11)    | (144:154)    |
| **FINE**                 | VARCHAR(14)    | (155:168)    |
| **SPEC_ASSESSMENT**      | VARCHAR(14)    | (169:182)    |
| **DEBARRED**             | VARCHAR(1)     | (183:183)    |
| **SPEC_CONDITION**       | VARCHAR(4)     | (184:187)    |
| **PROBATION_REVOKED**    | VARCHAR(1)     | (188:188)    |
| **SUPER_REL_REVOKED**    | VARCHAR(1)     | (189:189)    |
| **TOTAL_REVOKED_DAYS**   | VARCHAR(11)    | (190:200)    |
| **TOTAL_REVOKED_MONTHS** | VARCHAR(11)    | (201:211)    |
| **TOTAL_REVOKED_YEARS**  | VARCHAR(11)    | (212:222)    |
| **RELATED_FLU_USAO**     | VARCHAR(10)    | (223:232)    |
| **RELATED_FLU_SEQ**      | VARCHAR(3)     | (233:235)    |
| **COMM_SERV_HOURS**      | VARCHAR(12)    | (236:247)    |
| **SYS_SENT_DATE**        | DATE (11)      | (248:258)    |
| **RESTITUTION_AMT**      | VARCHAR(16)    | (259:274)    |
| **CREATE_DATE**          | DATE (11)      | (275:285)    |
| **CREATE_USER**          | VARCHAR(30)    | (286:315)    |
| **UPDATE_DATE**          | DATE (11)      | (316:326)    |
| **UPDATE_USER**          | VARCHAR(30)    | (327:356)    |
| **SUPV_REL_INCAR_TYPE**  | VARCHAR(1)     | (357:357)    |


GS_EVENT - 415 Characters                        

| **Field Name**       | **Field Type** | **Position** |
| -------------------- | -------------- | ------------ |
| **DISTRICT**         | VARCHAR(10)    | (01:10)      |
| **CASEID**           | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**     | VARCHAR(10)    | (21:30)      |
| **CRTHISID**         | VARCHAR(10)    | (31:40)      |
| **ID**               | VARCHAR(10)    | (41:50)      |
| **TYPE**             | VARCHAR(4)     | (51:54)      |
| **ACTION**           | VARCHAR(2)     | (55:56)      |
| **EVENT_DATE**       | DATE (11)      | (57:67)      |
| **SCHED_DATE**       | DATE (11)      | (68:78)      |
| **SCHED_TIME**       | TIME (11)      | (79:89)      |
| **SCHED_LOC**        | VARCHAR(200)   | (90:289)     |
| **STAFFID**          | VARCHAR(10)    | (290:299)    |
| **JUDGEID**          | VARCHAR(10)    | (300:309)    |
| **DOCUMENT_CODE**    | VARCHAR(3)     | (310:312)    |
| **DOCUMENT_STAFFID** | VARCHAR(10)    | (313:322)    |
| **DOCUMENT_DATE**    | DATE (11)      | (323:333)    |
| **CREATE_DATE**      | DATE (11)      | (334:344)    |
| **CREATE_USER**      | VARCHAR(30)    | (345:374)    |
| **UPDATE_DATE**      | DATE (11)      | (375:385)    |
| **UPDATE_USER**      | VARCHAR(30)    | (386:415)    |  
  
README.TXT FILES DISK06.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  06:05 PM       412,310,001 gs_event_CAN.txt
07/21/2026  06:05 PM       610,605,594 gs_event_CAS.txt
07/21/2026  06:05 PM       199,020,756 gs_event_CO.txt
07/21/2026  06:05 PM       187,973,592 gs_event_CT.txt
07/21/2026  06:05 PM       596,303,745 gs_event_DC.txt
07/21/2026  06:05 PM        46,610,175 gs_event_DE.txt
07/21/2026  06:06 PM       537,687,306 gs_event_FLM.txt
07/21/2026  06:06 PM       246,293,961 gs_event_FLN.txt
07/21/2026  06:06 PM       435,571,095 gs_event_FLS.txt
07/21/2026  06:06 PM       164,939,763 gs_event_GAM.txt
07/21/2026  06:06 PM       115,900,146 gs_event_GAN.txt
07/21/2026  06:06 PM       122,684,736 gs_event_GAS.txt
07/21/2026  06:06 PM        36,587,163 gs_event_GU.txt
07/21/2026  06:06 PM        99,888,180 gs_event_HI.txt
07/21/2026  06:06 PM       217,298,283 gs_event_IAN.txt
              15 File(s)  4,029,674,496 bytes
               0 Dir(s)  2,801,908,219,904 bytes free
  
Table Layouts:

GS_EVENT - 415 Characters                        

| **Field Name**       | **Field Type** | **Position** |
| -------------------- | -------------- | ------------ |
| **DISTRICT**         | VARCHAR(10)    | (01:10)      |
| **CASEID**           | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**     | VARCHAR(10)    | (21:30)      |
| **CRTHISID**         | VARCHAR(10)    | (31:40)      |
| **ID**               | VARCHAR(10)    | (41:50)      |
| **TYPE**             | VARCHAR(4)     | (51:54)      |
| **ACTION**           | VARCHAR(2)     | (55:56)      |
| **EVENT_DATE**       | DATE (11)      | (57:67)      |
| **SCHED_DATE**       | DATE (11)      | (68:78)      |
| **SCHED_TIME**       | TIME (11)      | (79:89)      |
| **SCHED_LOC**        | VARCHAR(200)   | (90:289)     |
| **STAFFID**          | VARCHAR(10)    | (290:299)    |
| **JUDGEID**          | VARCHAR(10)    | (300:309)    |
| **DOCUMENT_CODE**    | VARCHAR(3)     | (310:312)    |
| **DOCUMENT_STAFFID** | VARCHAR(10)    | (313:322)    |
| **DOCUMENT_DATE**    | DATE (11)      | (323:333)    |
| **CREATE_DATE**      | DATE (11)      | (334:344)    |
| **CREATE_USER**      | VARCHAR(30)    | (345:374)    |
| **UPDATE_DATE**      | DATE (11)      | (375:385)    |
| **UPDATE_USER**      | VARCHAR(30)    | (386:415)    |

  
  
README.TXT FILES DISK07.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  06:06 PM       112,830,609 gs_event_IAS.txt
07/21/2026  06:06 PM       168,971,736 gs_event_ID.txt
07/21/2026  06:06 PM        67,397,208 gs_event_ILC.txt
07/21/2026  06:06 PM       218,244,039 gs_event_ILN.txt
07/21/2026  06:06 PM       210,652,137 gs_event_ILS.txt
07/21/2026  06:06 PM       169,917,492 gs_event_INN.txt
07/21/2026  06:06 PM       116,076,537 gs_event_INS.txt
07/21/2026  06:07 PM       397,689,981 gs_event_KS.txt
07/21/2026  06:07 PM       192,430,071 gs_event_KYE.txt
07/21/2026  06:07 PM       246,312,309 gs_event_KYW.txt
07/21/2026  06:07 PM       126,241,746 gs_event_LAE.txt
07/21/2026  06:07 PM        59,136,855 gs_event_LAM.txt
07/21/2026  06:07 PM       139,436,877 gs_event_LAW.txt
07/21/2026  06:07 PM       190,681,590 gs_event_MA.txt
07/21/2026  06:07 PM       135,175,971 gs_event_MD.txt
07/21/2026  06:07 PM       116,525,646 gs_event_ME.txt
07/21/2026  06:07 PM       220,681,821 gs_event_MIE.txt
07/21/2026  06:07 PM       113,901,048 gs_event_MIW.txt
07/21/2026  06:07 PM       119,641,887 gs_event_MN.txt
07/21/2026  06:07 PM       166,686,576 gs_event_MOE.txt
07/21/2026  06:07 PM       394,652,136 gs_event_MOW.txt
07/21/2026  06:07 PM       110,736,435 gs_event_MSN.txt
07/21/2026  06:07 PM       205,331,634 gs_event_MSS.txt
              23 File(s)  3,999,352,341 bytes
               0 Dir(s)  2,801,908,219,904 bytes free
  
Table Layouts:

GS_EVENT - 415 Characters                        

| **Field Name**       | **Field Type** | **Position** |
| -------------------- | -------------- | ------------ |
| **DISTRICT**         | VARCHAR(10)    | (01:10)      |
| **CASEID**           | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**     | VARCHAR(10)    | (21:30)      |
| **CRTHISID**         | VARCHAR(10)    | (31:40)      |
| **ID**               | VARCHAR(10)    | (41:50)      |
| **TYPE**             | VARCHAR(4)     | (51:54)      |
| **ACTION**           | VARCHAR(2)     | (55:56)      |
| **EVENT_DATE**       | DATE (11)      | (57:67)      |
| **SCHED_DATE**       | DATE (11)      | (68:78)      |
| **SCHED_TIME**       | TIME (11)      | (79:89)      |
| **SCHED_LOC**        | VARCHAR(200)   | (90:289)     |
| **STAFFID**          | VARCHAR(10)    | (290:299)    |
| **JUDGEID**          | VARCHAR(10)    | (300:309)    |
| **DOCUMENT_CODE**    | VARCHAR(3)     | (310:312)    |
| **DOCUMENT_STAFFID** | VARCHAR(10)    | (313:322)    |
| **DOCUMENT_DATE**    | DATE (11)      | (323:333)    |
| **CREATE_DATE**      | DATE (11)      | (334:344)    |
| **CREATE_USER**      | VARCHAR(30)    | (345:374)    |
| **UPDATE_DATE**      | DATE (11)      | (375:385)    |
| **UPDATE_USER**      | VARCHAR(30)    | (386:415)    |

  
  
README.TXT FILES DISK08.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  06:07 PM       130,135,275 gs_event_MT.txt
07/21/2026  06:08 PM       303,682,752 gs_event_NCE.txt
07/21/2026  06:08 PM        91,706,640 gs_event_NCM.txt
07/21/2026  06:08 PM       209,974,095 gs_event_NCW.txt
07/21/2026  06:08 PM       136,735,551 gs_event_ND.txt
07/21/2026  06:08 PM       157,103,082 gs_event_NE.txt
07/21/2026  06:08 PM       110,050,053 gs_event_NH.txt
07/21/2026  06:08 PM       295,027,083 gs_event_NJ.txt
07/21/2026  06:08 PM       756,235,338 gs_event_NM.txt
07/21/2026  06:08 PM       355,831,938 gs_event_NV.txt
07/21/2026  06:08 PM       373,178,304 gs_event_NYE.txt
07/21/2026  06:09 PM       123,165,954 gs_event_NYN.txt
07/21/2026  06:09 PM       503,499,561 gs_event_NYS.txt
07/21/2026  06:09 PM       285,553,260 gs_event_NYW.txt
              14 File(s)  3,831,878,886 bytes
               0 Dir(s)  2,801,908,215,808 bytes free
  
Table Layouts:

GS_EVENT - 415 Characters                        

| **Field Name**       | **Field Type** | **Position** |
| -------------------- | -------------- | ------------ |
| **DISTRICT**         | VARCHAR(10)    | (01:10)      |
| **CASEID**           | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**     | VARCHAR(10)    | (21:30)      |
| **CRTHISID**         | VARCHAR(10)    | (31:40)      |
| **ID**               | VARCHAR(10)    | (41:50)      |
| **TYPE**             | VARCHAR(4)     | (51:54)      |
| **ACTION**           | VARCHAR(2)     | (55:56)      |
| **EVENT_DATE**       | DATE (11)      | (57:67)      |
| **SCHED_DATE**       | DATE (11)      | (68:78)      |
| **SCHED_TIME**       | TIME (11)      | (79:89)      |
| **SCHED_LOC**        | VARCHAR(200)   | (90:289)     |
| **STAFFID**          | VARCHAR(10)    | (290:299)    |
| **JUDGEID**          | VARCHAR(10)    | (300:309)    |
| **DOCUMENT_CODE**    | VARCHAR(3)     | (310:312)    |
| **DOCUMENT_STAFFID** | VARCHAR(10)    | (313:322)    |
| **DOCUMENT_DATE**    | DATE (11)      | (323:333)    |
| **CREATE_DATE**      | DATE (11)      | (334:344)    |
| **CREATE_USER**      | VARCHAR(30)    | (345:374)    |
| **UPDATE_DATE**      | DATE (11)      | (375:385)    |
| **UPDATE_USER**      | VARCHAR(30)    | (386:415)    |

  
  
README.TXT FILES DISK09.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  06:09 PM       409,790,487 gs_event_OHN.txt
07/21/2026  06:09 PM       322,013,238 gs_event_OHS.txt
07/21/2026  06:09 PM        64,152,531 gs_event_OKE.txt
07/21/2026  06:09 PM       166,040,643 gs_event_OKN.txt
07/21/2026  06:09 PM       134,929,524 gs_event_OKW.txt
07/21/2026  06:09 PM       161,938,197 gs_event_OR.txt
07/21/2026  06:09 PM       248,869,770 gs_event_PAE.txt
07/21/2026  06:09 PM       228,350,451 gs_event_PAM.txt
07/21/2026  06:10 PM       308,956,551 gs_event_PAW.txt
07/21/2026  06:10 PM       141,509,367 gs_event_PR.txt
07/21/2026  06:10 PM        34,446,285 gs_event_RI.txt
07/21/2026  06:10 PM       189,963,099 gs_event_SC.txt
07/21/2026  06:10 PM       210,910,677 gs_event_SD.txt
07/21/2026  06:10 PM       185,371,929 gs_event_TNE.txt
07/21/2026  06:10 PM        87,776,415 gs_event_TNM.txt
07/21/2026  06:10 PM       198,972,801 gs_event_TNW.txt
07/21/2026  06:10 PM       214,499,379 gs_event_TXE.txt
07/21/2026  06:10 PM       360,402,675 gs_event_TXN.txt
              18 File(s)  3,668,894,019 bytes
               0 Dir(s)  2,801,908,211,712 bytes free
  
Table Layouts:

GS_EVENT - 415 Characters                        

| **Field Name**       | **Field Type** | **Position** |
| -------------------- | -------------- | ------------ |
| **DISTRICT**         | VARCHAR(10)    | (01:10)      |
| **CASEID**           | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**     | VARCHAR(10)    | (21:30)      |
| **CRTHISID**         | VARCHAR(10)    | (31:40)      |
| **ID**               | VARCHAR(10)    | (41:50)      |
| **TYPE**             | VARCHAR(4)     | (51:54)      |
| **ACTION**           | VARCHAR(2)     | (55:56)      |
| **EVENT_DATE**       | DATE (11)      | (57:67)      |
| **SCHED_DATE**       | DATE (11)      | (68:78)      |
| **SCHED_TIME**       | TIME (11)      | (79:89)      |
| **SCHED_LOC**        | VARCHAR(200)   | (90:289)     |
| **STAFFID**          | VARCHAR(10)    | (290:299)    |
| **JUDGEID**          | VARCHAR(10)    | (300:309)    |
| **DOCUMENT_CODE**    | VARCHAR(3)     | (310:312)    |
| **DOCUMENT_STAFFID** | VARCHAR(10)    | (313:322)    |
| **DOCUMENT_DATE**    | DATE (11)      | (323:333)    |
| **CREATE_DATE**      | DATE (11)      | (334:344)    |
| **CREATE_USER**      | VARCHAR(30)    | (345:374)    |
| **UPDATE_DATE**      | DATE (11)      | (375:385)    |
| **UPDATE_USER**      | VARCHAR(30)    | (386:415)    |

  
  
README.TXT FILES DISK10.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  06:11 PM       966,877,884 gs_event_TXS.txt
07/21/2026  06:11 PM       530,725,491 gs_event_TXW.txt
07/21/2026  06:11 PM       203,053,980 gs_event_UT.txt
07/21/2026  06:11 PM       354,269,022 gs_event_VAE.txt
07/21/2026  06:11 PM       141,473,505 gs_event_VAW.txt
07/21/2026  06:11 PM        84,086,382 gs_event_VI.txt
07/21/2026  06:11 PM        88,233,030 gs_event_VT.txt
07/21/2026  06:11 PM       121,018,404 gs_event_WAE.txt
07/21/2026  06:11 PM       139,036,974 gs_event_WAW.txt
07/21/2026  06:11 PM        81,421,752 gs_event_WIE.txt
07/21/2026  06:11 PM       128,536,914 gs_event_WIW.txt
07/21/2026  06:11 PM       112,117,122 gs_event_WVN.txt
07/21/2026  06:11 PM       202,272,939 gs_event_WVS.txt
07/21/2026  06:11 PM        66,019,023 gs_event_WY.txt
07/21/2026  05:48 PM       394,349,256 gs_oppose_coun.txt
07/21/2026  05:40 PM        39,136,846 gs_restitution.txt
07/21/2026  05:48 PM        56,034,907 gs_participant_AK.txt
07/21/2026  05:48 PM        78,784,510 gs_participant_ALM.txt
07/21/2026  05:48 PM       189,248,164 gs_participant_ALN.txt
07/21/2026  05:48 PM        97,865,927 gs_participant_ALS.txt
              20 File(s)  4,074,562,032 bytes
               0 Dir(s)  2,801,908,211,712 bytes free
  
Table Layouts:

GS_EVENT - 415 Characters                        

| **Field Name**       | **Field Type** | **Position** |
| -------------------- | -------------- | ------------ |
| **DISTRICT**         | VARCHAR(10)    | (01:10)      |
| **CASEID**           | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**     | VARCHAR(10)    | (21:30)      |
| **CRTHISID**         | VARCHAR(10)    | (31:40)      |
| **ID**               | VARCHAR(10)    | (41:50)      |
| **TYPE**             | VARCHAR(4)     | (51:54)      |
| **ACTION**           | VARCHAR(2)     | (55:56)      |
| **EVENT_DATE**       | DATE (11)      | (57:67)      |
| **SCHED_DATE**       | DATE (11)      | (68:78)      |
| **SCHED_TIME**       | TIME (11)      | (79:89)      |
| **SCHED_LOC**        | VARCHAR(200)   | (90:289)     |
| **STAFFID**          | VARCHAR(10)    | (290:299)    |
| **JUDGEID**          | VARCHAR(10)    | (300:309)    |
| **DOCUMENT_CODE**    | VARCHAR(3)     | (310:312)    |
| **DOCUMENT_STAFFID** | VARCHAR(10)    | (313:322)    |
| **DOCUMENT_DATE**    | DATE (11)      | (323:333)    |
| **CREATE_DATE**      | DATE (11)      | (334:344)    |
| **CREATE_USER**      | VARCHAR(30)    | (345:374)    |
| **UPDATE_DATE**      | DATE (11)      | (375:385)    |
| **UPDATE_USER**      | VARCHAR(30)    | (386:415)    |


GS_OPPOSE_COUN - 166 Characters                        

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **CASEID**       | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID** | VARCHAR(10)    | (21:30)      |
| **PARTID**       | VARCHAR(10)    | (31:40)      |
| **ID**           | VARCHAR(10)    | (41:50)      |
| **ATTORNEYID**   | VARCHAR(10)    | (51:60)      |
| **TYPE**         | VARCHAR(2)     | (61:62)      |
| **START_DATE**   | DATE (11)      | (63:73)      |
| **END_DATE**     | DATE (11)      | (74:84)      |
| **CREATE_DATE**  | DATE (11)      | (85:95)      |
| **CREATE_USER**  | VARCHAR(30)    | (96:125)     |
| **UPDATE_DATE**  | DATE (11)      | (126:136)    |
| **UPDATE_USER**  | VARCHAR(30)    | (137:166)    |


GS_RESTITUTION - 159 Characters                 

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **CASEID**       | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID** | VARCHAR(10)    | (21:30)      |
| **PARTID**       | VARCHAR(10)    | (31:40)      |
| **ID**           | VARCHAR(10)    | (41:50)      |
| **VICTIMID**     | VARCHAR(10)    | (51:60)      |
| **TYPE**         | VARCHAR(1)     | (61:61)      |
| **RECIPIENT**    | VARCHAR(1)     | (62:62)      |
| **AMOUNT**       | VARCHAR(14)    | (63:76)      |
| **LIABILITY**    | VARCHAR(1)     | (77:77)      |
| **CREATE_DATE**  | DATE (11)      | (78:88)      |
| **CREATE_USER**  | VARCHAR(30)    | (89:118)     |
| **UPDATE_DATE**  | DATE (11)      | (119:129)    |
| **UPDATE_USER**  | VARCHAR(30)    | (130:159)    |



* 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 - 1180 Characters                        

| **Field Name**             | **Field Type** | **Position** |
| -------------------------- | -------------- | ------------ |
| **DISTRICT**               | VARCHAR(10)    | (01:10)      |
| **CASEID**                 | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**           | VARCHAR(10)    | (21:30)      |
| **ID**                     | VARCHAR(10)    | (31:40)      |
| **TYPE**                   | VARCHAR(1)     | (41:41)      |
| **ROLE**                   | VARCHAR(2)     | (42:43)      |
| **SECURITY**               | VARCHAR(1)     | (44:44)      |
| **DEFEND_NUM**             | VARCHAR(11)    | (45:55)      |
| **SALUTATION**             | VARCHAR(20)    | (56:75)      |
| **LAST_NAME**              | VARCHAR(60)    | (76:135)     |
| **FIRST_NAME**             | VARCHAR(30)    | (136:165)    |
| **TITLE**                  | VARCHAR(30)    | (166:195)    |
| **LAST_SOUNDS**            | VARCHAR(4)     | (196:199)    |
| **FIRST_SOUNDS**           | VARCHAR(4)     | (200:203)    |
| **BUSINESS_TYPE**          | VARCHAR(2)     | (204:205)    |
| **EIN**                    | VARCHAR(20)    | (206:225)    |
| **PROP_TYPE**              | VARCHAR(2)     | (226:227)    |
| **TOTAL_TRACTS**           | VARCHAR(11)    | (228:238)    |
| **CATS_ASSET_ID**          | VARCHAR(15)    | (239:253)    |
| **AGENCY**                 | VARCHAR(4)     | (254:257)    |
| **AGENCY_NUM**             | VARCHAR(30)    | (258:287)    |
| **JOB_POSITION**           | VARCHAR(4)     | (288:291)    |
| **SSN**                    | VARCHAR(11)    | (292:302)    |
| **BIRTH_DATE**             | VARCHAR(11)    | (303:313)    |
| **GENDER**                 | VARCHAR(1)     | (314:314)    |
| **JUVENILE**               | VARCHAR(1)     | (315:315)    |
| **RACE**                   | VARCHAR(2)     | (316:317)    |
| **RACE_DESCRIP**           | VARCHAR(30)    | (318:347)    |
| **IMMIG_STAT**             | VARCHAR(2)     | (348:349)    |
| **COUNTRY**                | VARCHAR(2)     | (350:351)    |
| **TRIBE**                  | VARCHAR(4)     | (352:355)    |
| **RESERVATION**            | VARCHAR(4)     | (356:359)    |
| **ARREST_DATE**            | VARCHAR(11)    | (360:370)    |
| **PDID**                   | VARCHAR(12)    | (371:382)    |
| **FBI_NUMBER**             | VARCHAR(15)    | (383:397)    |
| **CRIM_HIST**              | VARCHAR(1)     | (398:398)    |
| **EST_LOSS**               | VARCHAR(14)    | (399:412)    |
| **ACT_LOSS**               | VARCHAR(14)    | (413:426)    |
| **HOME_ADDRESS1**          | VARCHAR(30)    | (427:456)    |
| **HOME_ADDRESS2**          | VARCHAR(30)    | (457:486)    |
| **HOME_ADDRESS3**          | VARCHAR(30)    | (487:516)    |
| **HOME_CITY**              | VARCHAR(20)    | (517:536)    |
| **HOME_STATE**             | VARCHAR(2)     | (537:538)    |
| **HOME_COUNTY**            | VARCHAR(20)    | (539:558)    |
| **HOME_ZIPCODE**           | VARCHAR(20)    | (559:578)    |
| **HOME_PHONE**             | VARCHAR(15)    | (579:593)    |
| **HOME_FAX**               | VARCHAR(15)    | (594:608)    |
| **OFF_ADDRESS1**           | VARCHAR(30)    | (609:638)    |
| **OFF_ADDRESS2**           | VARCHAR(30)    | (639:668)    |
| **OFF_ADDRESS3**           | VARCHAR(30)    | (669:698)    |
| **OFF_CITY**               | VARCHAR(20)    | (699:718)    |
| **OFF_STATE**              | VARCHAR(2)     | (719:720)    |
| **OFF_COUNTY**             | VARCHAR(20)    | (721:740)    |
| **OFF_ZIPCODE**            | VARCHAR(10)    | (741:750)    |
| **OFF_PHONE**              | VARCHAR(15)    | (751:765)    |
| **OFF_FAX**                | VARCHAR(15)    | (766:780)    |
| **MARSHALS_NUM**           | VARCHAR(9)     | (781:789)    |
| **AGCYOFFID**              | VARCHAR(10)    | (790:799)    |
| **LOWER_CRT_TRIAL_NBR**    | VARCHAR(25)    | (800:824)    |
| **BUSINESS_CONTACT_LNAME** | VARCHAR(30)    | (825:854)    |
| **BUSINESS_CONTACT_FNAME** | VARCHAR(30)    | (855:884)    |
| **COLLECT_IND**            | VARCHAR(1)     | (885:885)    |
| **SYS_INIT_DATE**          | VARCHAR(11)    | (886:896)    |
| **WEIGHT**                 | VARCHAR(2)     | (897:898)    |
| **EMPLOYER_NAME**          | VARCHAR(40)    | (899:938)    |
| **EMPLOYER_TYPE**          | VARCHAR(3)     | (939:941)    |
| **EMPLOYER_DESC**          | VARCHAR(40)    | (942:981)    |
| **NPI**                    | VARCHAR(10)    | (982:991)    |
| **OCCUPATION**             | VARCHAR(3)     | (992:994)    |
| **OCCUP_DESC**             | VARCHAR(60)    | (995:1054)   |
| **HCARE_BUSN_TYPE**        | VARCHAR(3)     | (1055:1057)  |
| **HCARE_BUSN_DESC**        | VARCHAR(40)    | (1058:1097)  |
| **CREATE_DATE**            | VARCHAR(11)    | (1098:1108)  |
| **CREATE_USER**            | VARCHAR(30)    | (1109:1138)  |
| **UPDATE_DATE**            | VARCHAR(11)    | (1139:1149)  |
| **UPDATE_USER**            | VARCHAR(30)    | (1150:1180)  |
  
  
README.TXT FILES DISK11.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  05:48 PM       154,904,684 gs_participant_ARE.txt
07/21/2026  05:48 PM        83,145,943 gs_participant_ARW.txt
07/21/2026  05:50 PM       744,739,781 gs_participant_CAC.txt
07/21/2026  05:50 PM       313,122,073 gs_participant_CAE.txt
07/21/2026  05:50 PM       319,376,649 gs_participant_CAN.txt
07/21/2026  05:51 PM       601,478,576 gs_participant_CAS.txt
07/21/2026  05:51 PM       226,456,750 gs_participant_CO.txt
07/21/2026  05:51 PM       202,409,228 gs_participant_CT.txt
07/21/2026  05:51 PM       429,813,140 gs_participant_DC.txt
07/21/2026  05:51 PM        67,570,915 gs_participant_DE.txt
07/21/2026  05:52 PM       879,669,031 gs_participant_FLM.txt
              11 File(s)  4,022,686,770 bytes
               0 Dir(s)  2,801,908,199,424 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 - 1180 Characters                        

| **Field Name**             | **Field Type** | **Position** |
| -------------------------- | -------------- | ------------ |
| **DISTRICT**               | VARCHAR(10)    | (01:10)      |
| **CASEID**                 | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**           | VARCHAR(10)    | (21:30)      |
| **ID**                     | VARCHAR(10)    | (31:40)      |
| **TYPE**                   | VARCHAR(1)     | (41:41)      |
| **ROLE**                   | VARCHAR(2)     | (42:43)      |
| **SECURITY**               | VARCHAR(1)     | (44:44)      |
| **DEFEND_NUM**             | VARCHAR(11)    | (45:55)      |
| **SALUTATION**             | VARCHAR(20)    | (56:75)      |
| **LAST_NAME**              | VARCHAR(60)    | (76:135)     |
| **FIRST_NAME**             | VARCHAR(30)    | (136:165)    |
| **TITLE**                  | VARCHAR(30)    | (166:195)    |
| **LAST_SOUNDS**            | VARCHAR(4)     | (196:199)    |
| **FIRST_SOUNDS**           | VARCHAR(4)     | (200:203)    |
| **BUSINESS_TYPE**          | VARCHAR(2)     | (204:205)    |
| **EIN**                    | VARCHAR(20)    | (206:225)    |
| **PROP_TYPE**              | VARCHAR(2)     | (226:227)    |
| **TOTAL_TRACTS**           | VARCHAR(11)    | (228:238)    |
| **CATS_ASSET_ID**          | VARCHAR(15)    | (239:253)    |
| **AGENCY**                 | VARCHAR(4)     | (254:257)    |
| **AGENCY_NUM**             | VARCHAR(30)    | (258:287)    |
| **JOB_POSITION**           | VARCHAR(4)     | (288:291)    |
| **SSN**                    | VARCHAR(11)    | (292:302)    |
| **BIRTH_DATE**             | VARCHAR(11)    | (303:313)    |
| **GENDER**                 | VARCHAR(1)     | (314:314)    |
| **JUVENILE**               | VARCHAR(1)     | (315:315)    |
| **RACE**                   | VARCHAR(2)     | (316:317)    |
| **RACE_DESCRIP**           | VARCHAR(30)    | (318:347)    |
| **IMMIG_STAT**             | VARCHAR(2)     | (348:349)    |
| **COUNTRY**                | VARCHAR(2)     | (350:351)    |
| **TRIBE**                  | VARCHAR(4)     | (352:355)    |
| **RESERVATION**            | VARCHAR(4)     | (356:359)    |
| **ARREST_DATE**            | VARCHAR(11)    | (360:370)    |
| **PDID**                   | VARCHAR(12)    | (371:382)    |
| **FBI_NUMBER**             | VARCHAR(15)    | (383:397)    |
| **CRIM_HIST**              | VARCHAR(1)     | (398:398)    |
| **EST_LOSS**               | VARCHAR(14)    | (399:412)    |
| **ACT_LOSS**               | VARCHAR(14)    | (413:426)    |
| **HOME_ADDRESS1**          | VARCHAR(30)    | (427:456)    |
| **HOME_ADDRESS2**          | VARCHAR(30)    | (457:486)    |
| **HOME_ADDRESS3**          | VARCHAR(30)    | (487:516)    |
| **HOME_CITY**              | VARCHAR(20)    | (517:536)    |
| **HOME_STATE**             | VARCHAR(2)     | (537:538)    |
| **HOME_COUNTY**            | VARCHAR(20)    | (539:558)    |
| **HOME_ZIPCODE**           | VARCHAR(20)    | (559:578)    |
| **HOME_PHONE**             | VARCHAR(15)    | (579:593)    |
| **HOME_FAX**               | VARCHAR(15)    | (594:608)    |
| **OFF_ADDRESS1**           | VARCHAR(30)    | (609:638)    |
| **OFF_ADDRESS2**           | VARCHAR(30)    | (639:668)    |
| **OFF_ADDRESS3**           | VARCHAR(30)    | (669:698)    |
| **OFF_CITY**               | VARCHAR(20)    | (699:718)    |
| **OFF_STATE**              | VARCHAR(2)     | (719:720)    |
| **OFF_COUNTY**             | VARCHAR(20)    | (721:740)    |
| **OFF_ZIPCODE**            | VARCHAR(10)    | (741:750)    |
| **OFF_PHONE**              | VARCHAR(15)    | (751:765)    |
| **OFF_FAX**                | VARCHAR(15)    | (766:780)    |
| **MARSHALS_NUM**           | VARCHAR(9)     | (781:789)    |
| **AGCYOFFID**              | VARCHAR(10)    | (790:799)    |
| **LOWER_CRT_TRIAL_NBR**    | VARCHAR(25)    | (800:824)    |
| **BUSINESS_CONTACT_LNAME** | VARCHAR(30)    | (825:854)    |
| **BUSINESS_CONTACT_FNAME** | VARCHAR(30)    | (855:884)    |
| **COLLECT_IND**            | VARCHAR(1)     | (885:885)    |
| **SYS_INIT_DATE**          | VARCHAR(11)    | (886:896)    |
| **WEIGHT**                 | VARCHAR(2)     | (897:898)    |
| **EMPLOYER_NAME**          | VARCHAR(40)    | (899:938)    |
| **EMPLOYER_TYPE**          | VARCHAR(3)     | (939:941)    |
| **EMPLOYER_DESC**          | VARCHAR(40)    | (942:981)    |
| **NPI**                    | VARCHAR(10)    | (982:991)    |
| **OCCUPATION**             | VARCHAR(3)     | (992:994)    |
| **OCCUP_DESC**             | VARCHAR(60)    | (995:1054)   |
| **HCARE_BUSN_TYPE**        | VARCHAR(3)     | (1055:1057)  |
| **HCARE_BUSN_DESC**        | VARCHAR(40)    | (1058:1097)  |
| **CREATE_DATE**            | VARCHAR(11)    | (1098:1108)  |
| **CREATE_USER**            | VARCHAR(30)    | (1109:1138)  |
| **UPDATE_DATE**            | VARCHAR(11)    | (1139:1149)  |
| **UPDATE_USER**            | VARCHAR(30)    | (1150:1180)  |  
  
README.TXT FILES DISK12.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  05:52 PM       145,448,417 gs_participant_FLN.txt
07/21/2026  05:52 PM       598,950,055 gs_participant_FLS.txt
07/21/2026  05:52 PM       132,189,330 gs_participant_GAM.txt
07/21/2026  05:53 PM       272,973,978 gs_participant_GAN.txt
07/21/2026  05:53 PM       147,314,397 gs_participant_GAS.txt
07/21/2026  05:53 PM        28,765,617 gs_participant_GU.txt
07/21/2026  05:53 PM       133,611,254 gs_participant_HI.txt
07/21/2026  05:53 PM       119,904,568 gs_participant_IAN.txt
07/21/2026  05:53 PM       111,149,815 gs_participant_IAS.txt
07/21/2026  05:53 PM       107,866,635 gs_participant_ID.txt
07/21/2026  05:53 PM       120,068,727 gs_participant_ILC.txt
07/21/2026  05:53 PM       531,414,570 gs_participant_ILN.txt
07/21/2026  05:53 PM       144,454,015 gs_participant_ILS.txt
07/21/2026  05:53 PM       158,999,211 gs_participant_INN.txt
07/21/2026  05:54 PM       216,812,704 gs_participant_INS.txt
07/21/2026  05:54 PM       221,079,657 gs_participant_KS.txt
07/21/2026  05:54 PM       190,005,185 gs_participant_KYE.txt
07/21/2026  05:54 PM       187,560,515 gs_participant_KYW.txt
07/21/2026  05:54 PM       132,075,954 gs_participant_LAE.txt
07/21/2026  05:54 PM        55,375,909 gs_participant_LAM.txt
07/21/2026  05:54 PM       161,632,841 gs_participant_LAW.txt
              21 File(s)  3,917,653,354 bytes
               0 Dir(s)  2,801,908,195,328 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 - 1180 Characters                        

| **Field Name**             | **Field Type** | **Position** |
| -------------------------- | -------------- | ------------ |
| **DISTRICT**               | VARCHAR(10)    | (01:10)      |
| **CASEID**                 | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**           | VARCHAR(10)    | (21:30)      |
| **ID**                     | VARCHAR(10)    | (31:40)      |
| **TYPE**                   | VARCHAR(1)     | (41:41)      |
| **ROLE**                   | VARCHAR(2)     | (42:43)      |
| **SECURITY**               | VARCHAR(1)     | (44:44)      |
| **DEFEND_NUM**             | VARCHAR(11)    | (45:55)      |
| **SALUTATION**             | VARCHAR(20)    | (56:75)      |
| **LAST_NAME**              | VARCHAR(60)    | (76:135)     |
| **FIRST_NAME**             | VARCHAR(30)    | (136:165)    |
| **TITLE**                  | VARCHAR(30)    | (166:195)    |
| **LAST_SOUNDS**            | VARCHAR(4)     | (196:199)    |
| **FIRST_SOUNDS**           | VARCHAR(4)     | (200:203)    |
| **BUSINESS_TYPE**          | VARCHAR(2)     | (204:205)    |
| **EIN**                    | VARCHAR(20)    | (206:225)    |
| **PROP_TYPE**              | VARCHAR(2)     | (226:227)    |
| **TOTAL_TRACTS**           | VARCHAR(11)    | (228:238)    |
| **CATS_ASSET_ID**          | VARCHAR(15)    | (239:253)    |
| **AGENCY**                 | VARCHAR(4)     | (254:257)    |
| **AGENCY_NUM**             | VARCHAR(30)    | (258:287)    |
| **JOB_POSITION**           | VARCHAR(4)     | (288:291)    |
| **SSN**                    | VARCHAR(11)    | (292:302)    |
| **BIRTH_DATE**             | VARCHAR(11)    | (303:313)    |
| **GENDER**                 | VARCHAR(1)     | (314:314)    |
| **JUVENILE**               | VARCHAR(1)     | (315:315)    |
| **RACE**                   | VARCHAR(2)     | (316:317)    |
| **RACE_DESCRIP**           | VARCHAR(30)    | (318:347)    |
| **IMMIG_STAT**             | VARCHAR(2)     | (348:349)    |
| **COUNTRY**                | VARCHAR(2)     | (350:351)    |
| **TRIBE**                  | VARCHAR(4)     | (352:355)    |
| **RESERVATION**            | VARCHAR(4)     | (356:359)    |
| **ARREST_DATE**            | VARCHAR(11)    | (360:370)    |
| **PDID**                   | VARCHAR(12)    | (371:382)    |
| **FBI_NUMBER**             | VARCHAR(15)    | (383:397)    |
| **CRIM_HIST**              | VARCHAR(1)     | (398:398)    |
| **EST_LOSS**               | VARCHAR(14)    | (399:412)    |
| **ACT_LOSS**               | VARCHAR(14)    | (413:426)    |
| **HOME_ADDRESS1**          | VARCHAR(30)    | (427:456)    |
| **HOME_ADDRESS2**          | VARCHAR(30)    | (457:486)    |
| **HOME_ADDRESS3**          | VARCHAR(30)    | (487:516)    |
| **HOME_CITY**              | VARCHAR(20)    | (517:536)    |
| **HOME_STATE**             | VARCHAR(2)     | (537:538)    |
| **HOME_COUNTY**            | VARCHAR(20)    | (539:558)    |
| **HOME_ZIPCODE**           | VARCHAR(20)    | (559:578)    |
| **HOME_PHONE**             | VARCHAR(15)    | (579:593)    |
| **HOME_FAX**               | VARCHAR(15)    | (594:608)    |
| **OFF_ADDRESS1**           | VARCHAR(30)    | (609:638)    |
| **OFF_ADDRESS2**           | VARCHAR(30)    | (639:668)    |
| **OFF_ADDRESS3**           | VARCHAR(30)    | (669:698)    |
| **OFF_CITY**               | VARCHAR(20)    | (699:718)    |
| **OFF_STATE**              | VARCHAR(2)     | (719:720)    |
| **OFF_COUNTY**             | VARCHAR(20)    | (721:740)    |
| **OFF_ZIPCODE**            | VARCHAR(10)    | (741:750)    |
| **OFF_PHONE**              | VARCHAR(15)    | (751:765)    |
| **OFF_FAX**                | VARCHAR(15)    | (766:780)    |
| **MARSHALS_NUM**           | VARCHAR(9)     | (781:789)    |
| **AGCYOFFID**              | VARCHAR(10)    | (790:799)    |
| **LOWER_CRT_TRIAL_NBR**    | VARCHAR(25)    | (800:824)    |
| **BUSINESS_CONTACT_LNAME** | VARCHAR(30)    | (825:854)    |
| **BUSINESS_CONTACT_FNAME** | VARCHAR(30)    | (855:884)    |
| **COLLECT_IND**            | VARCHAR(1)     | (885:885)    |
| **SYS_INIT_DATE**          | VARCHAR(11)    | (886:896)    |
| **WEIGHT**                 | VARCHAR(2)     | (897:898)    |
| **EMPLOYER_NAME**          | VARCHAR(40)    | (899:938)    |
| **EMPLOYER_TYPE**          | VARCHAR(3)     | (939:941)    |
| **EMPLOYER_DESC**          | VARCHAR(40)    | (942:981)    |
| **NPI**                    | VARCHAR(10)    | (982:991)    |
| **OCCUPATION**             | VARCHAR(3)     | (992:994)    |
| **OCCUP_DESC**             | VARCHAR(60)    | (995:1054)   |
| **HCARE_BUSN_TYPE**        | VARCHAR(3)     | (1055:1057)  |
| **HCARE_BUSN_DESC**        | VARCHAR(40)    | (1058:1097)  |
| **CREATE_DATE**            | VARCHAR(11)    | (1098:1108)  |
| **CREATE_USER**            | VARCHAR(30)    | (1109:1138)  |
| **UPDATE_DATE**            | VARCHAR(11)    | (1139:1149)  |
| **UPDATE_USER**            | VARCHAR(30)    | (1150:1180)  |  
  
README.TXT FILES DISK13.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  05:54 PM       217,875,604 gs_participant_MA.txt
07/21/2026  05:54 PM       248,664,274 gs_participant_MD.txt
07/21/2026  05:54 PM       102,761,172 gs_participant_ME.txt
07/21/2026  05:54 PM       324,273,075 gs_participant_MIE.txt
07/21/2026  05:55 PM       132,449,150 gs_participant_MIW.txt
07/21/2026  05:55 PM       167,110,319 gs_participant_MN.txt
07/21/2026  05:55 PM       219,123,921 gs_participant_MOE.txt
07/21/2026  05:55 PM       216,121,819 gs_participant_MOW.txt
07/21/2026  05:55 PM        70,130,142 gs_participant_MSN.txt
07/21/2026  05:55 PM       143,610,781 gs_participant_MSS.txt
07/21/2026  05:55 PM        99,285,489 gs_participant_MT.txt
07/21/2026  05:55 PM       203,713,052 gs_participant_NCE.txt
07/21/2026  05:55 PM       120,969,830 gs_participant_NCM.txt
07/21/2026  05:55 PM       177,210,231 gs_participant_NCW.txt
07/21/2026  05:55 PM       134,729,661 gs_participant_NE.txt
07/21/2026  05:55 PM        64,420,007 gs_participant_NH.txt
07/21/2026  05:56 PM       503,131,982 gs_participant_NJ.txt
07/21/2026  05:56 PM       501,423,075 gs_participant_NM.txt
07/21/2026  05:56 PM       229,315,951 gs_participant_NV.txt
              19 File(s)  3,876,319,535 bytes
               0 Dir(s)  2,801,908,187,136 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 - 1180 Characters                        

| **Field Name**             | **Field Type** | **Position** |
| -------------------------- | -------------- | ------------ |
| **DISTRICT**               | VARCHAR(10)    | (01:10)      |
| **CASEID**                 | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**           | VARCHAR(10)    | (21:30)      |
| **ID**                     | VARCHAR(10)    | (31:40)      |
| **TYPE**                   | VARCHAR(1)     | (41:41)      |
| **ROLE**                   | VARCHAR(2)     | (42:43)      |
| **SECURITY**               | VARCHAR(1)     | (44:44)      |
| **DEFEND_NUM**             | VARCHAR(11)    | (45:55)      |
| **SALUTATION**             | VARCHAR(20)    | (56:75)      |
| **LAST_NAME**              | VARCHAR(60)    | (76:135)     |
| **FIRST_NAME**             | VARCHAR(30)    | (136:165)    |
| **TITLE**                  | VARCHAR(30)    | (166:195)    |
| **LAST_SOUNDS**            | VARCHAR(4)     | (196:199)    |
| **FIRST_SOUNDS**           | VARCHAR(4)     | (200:203)    |
| **BUSINESS_TYPE**          | VARCHAR(2)     | (204:205)    |
| **EIN**                    | VARCHAR(20)    | (206:225)    |
| **PROP_TYPE**              | VARCHAR(2)     | (226:227)    |
| **TOTAL_TRACTS**           | VARCHAR(11)    | (228:238)    |
| **CATS_ASSET_ID**          | VARCHAR(15)    | (239:253)    |
| **AGENCY**                 | VARCHAR(4)     | (254:257)    |
| **AGENCY_NUM**             | VARCHAR(30)    | (258:287)    |
| **JOB_POSITION**           | VARCHAR(4)     | (288:291)    |
| **SSN**                    | VARCHAR(11)    | (292:302)    |
| **BIRTH_DATE**             | VARCHAR(11)    | (303:313)    |
| **GENDER**                 | VARCHAR(1)     | (314:314)    |
| **JUVENILE**               | VARCHAR(1)     | (315:315)    |
| **RACE**                   | VARCHAR(2)     | (316:317)    |
| **RACE_DESCRIP**           | VARCHAR(30)    | (318:347)    |
| **IMMIG_STAT**             | VARCHAR(2)     | (348:349)    |
| **COUNTRY**                | VARCHAR(2)     | (350:351)    |
| **TRIBE**                  | VARCHAR(4)     | (352:355)    |
| **RESERVATION**            | VARCHAR(4)     | (356:359)    |
| **ARREST_DATE**            | VARCHAR(11)    | (360:370)    |
| **PDID**                   | VARCHAR(12)    | (371:382)    |
| **FBI_NUMBER**             | VARCHAR(15)    | (383:397)    |
| **CRIM_HIST**              | VARCHAR(1)     | (398:398)    |
| **EST_LOSS**               | VARCHAR(14)    | (399:412)    |
| **ACT_LOSS**               | VARCHAR(14)    | (413:426)    |
| **HOME_ADDRESS1**          | VARCHAR(30)    | (427:456)    |
| **HOME_ADDRESS2**          | VARCHAR(30)    | (457:486)    |
| **HOME_ADDRESS3**          | VARCHAR(30)    | (487:516)    |
| **HOME_CITY**              | VARCHAR(20)    | (517:536)    |
| **HOME_STATE**             | VARCHAR(2)     | (537:538)    |
| **HOME_COUNTY**            | VARCHAR(20)    | (539:558)    |
| **HOME_ZIPCODE**           | VARCHAR(20)    | (559:578)    |
| **HOME_PHONE**             | VARCHAR(15)    | (579:593)    |
| **HOME_FAX**               | VARCHAR(15)    | (594:608)    |
| **OFF_ADDRESS1**           | VARCHAR(30)    | (609:638)    |
| **OFF_ADDRESS2**           | VARCHAR(30)    | (639:668)    |
| **OFF_ADDRESS3**           | VARCHAR(30)    | (669:698)    |
| **OFF_CITY**               | VARCHAR(20)    | (699:718)    |
| **OFF_STATE**              | VARCHAR(2)     | (719:720)    |
| **OFF_COUNTY**             | VARCHAR(20)    | (721:740)    |
| **OFF_ZIPCODE**            | VARCHAR(10)    | (741:750)    |
| **OFF_PHONE**              | VARCHAR(15)    | (751:765)    |
| **OFF_FAX**                | VARCHAR(15)    | (766:780)    |
| **MARSHALS_NUM**           | VARCHAR(9)     | (781:789)    |
| **AGCYOFFID**              | VARCHAR(10)    | (790:799)    |
| **LOWER_CRT_TRIAL_NBR**    | VARCHAR(25)    | (800:824)    |
| **BUSINESS_CONTACT_LNAME** | VARCHAR(30)    | (825:854)    |
| **BUSINESS_CONTACT_FNAME** | VARCHAR(30)    | (855:884)    |
| **COLLECT_IND**            | VARCHAR(1)     | (885:885)    |
| **SYS_INIT_DATE**          | VARCHAR(11)    | (886:896)    |
| **WEIGHT**                 | VARCHAR(2)     | (897:898)    |
| **EMPLOYER_NAME**          | VARCHAR(40)    | (899:938)    |
| **EMPLOYER_TYPE**          | VARCHAR(3)     | (939:941)    |
| **EMPLOYER_DESC**          | VARCHAR(40)    | (942:981)    |
| **NPI**                    | VARCHAR(10)    | (982:991)    |
| **OCCUPATION**             | VARCHAR(3)     | (992:994)    |
| **OCCUP_DESC**             | VARCHAR(60)    | (995:1054)   |
| **HCARE_BUSN_TYPE**        | VARCHAR(3)     | (1055:1057)  |
| **HCARE_BUSN_DESC**        | VARCHAR(40)    | (1058:1097)  |
| **CREATE_DATE**            | VARCHAR(11)    | (1098:1108)  |
| **CREATE_USER**            | VARCHAR(30)    | (1109:1138)  |
| **UPDATE_DATE**            | VARCHAR(11)    | (1139:1149)  |
| **UPDATE_USER**            | VARCHAR(30)    | (1150:1180)  |  
  
README.TXT FILES DISK14.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  05:57 PM       606,284,065 gs_participant_NYE.txt
07/21/2026  05:57 PM       219,108,568 gs_participant_NYN.txt
07/21/2026  05:57 PM       654,387,376 gs_participant_NYS.txt
07/21/2026  05:57 PM       273,423,939 gs_participant_NYW.txt
07/21/2026  05:58 PM       492,252,610 gs_participant_OHN.txt
07/21/2026  05:58 PM       432,476,295 gs_participant_OHS.txt
07/21/2026  05:58 PM        76,276,066 gs_participant_OKE.txt
07/21/2026  05:58 PM       126,345,742 gs_participant_OKN.txt
07/21/2026  05:58 PM       168,386,980 gs_participant_OKW.txt
07/21/2026  05:58 PM       208,313,047 gs_participant_OR.txt
07/21/2026  05:58 PM       279,730,479 gs_participant_PAE.txt
07/21/2026  05:58 PM       166,413,529 gs_participant_PAM.txt
07/21/2026  05:58 PM       218,645,616 gs_participant_PAW.txt
              13 File(s)  3,922,044,312 bytes
               0 Dir(s)  2,801,908,178,944 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 - 1180 Characters                        

| **Field Name**             | **Field Type** | **Position** |
| -------------------------- | -------------- | ------------ |
| **DISTRICT**               | VARCHAR(10)    | (01:10)      |
| **CASEID**                 | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**           | VARCHAR(10)    | (21:30)      |
| **ID**                     | VARCHAR(10)    | (31:40)      |
| **TYPE**                   | VARCHAR(1)     | (41:41)      |
| **ROLE**                   | VARCHAR(2)     | (42:43)      |
| **SECURITY**               | VARCHAR(1)     | (44:44)      |
| **DEFEND_NUM**             | VARCHAR(11)    | (45:55)      |
| **SALUTATION**             | VARCHAR(20)    | (56:75)      |
| **LAST_NAME**              | VARCHAR(60)    | (76:135)     |
| **FIRST_NAME**             | VARCHAR(30)    | (136:165)    |
| **TITLE**                  | VARCHAR(30)    | (166:195)    |
| **LAST_SOUNDS**            | VARCHAR(4)     | (196:199)    |
| **FIRST_SOUNDS**           | VARCHAR(4)     | (200:203)    |
| **BUSINESS_TYPE**          | VARCHAR(2)     | (204:205)    |
| **EIN**                    | VARCHAR(20)    | (206:225)    |
| **PROP_TYPE**              | VARCHAR(2)     | (226:227)    |
| **TOTAL_TRACTS**           | VARCHAR(11)    | (228:238)    |
| **CATS_ASSET_ID**          | VARCHAR(15)    | (239:253)    |
| **AGENCY**                 | VARCHAR(4)     | (254:257)    |
| **AGENCY_NUM**             | VARCHAR(30)    | (258:287)    |
| **JOB_POSITION**           | VARCHAR(4)     | (288:291)    |
| **SSN**                    | VARCHAR(11)    | (292:302)    |
| **BIRTH_DATE**             | VARCHAR(11)    | (303:313)    |
| **GENDER**                 | VARCHAR(1)     | (314:314)    |
| **JUVENILE**               | VARCHAR(1)     | (315:315)    |
| **RACE**                   | VARCHAR(2)     | (316:317)    |
| **RACE_DESCRIP**           | VARCHAR(30)    | (318:347)    |
| **IMMIG_STAT**             | VARCHAR(2)     | (348:349)    |
| **COUNTRY**                | VARCHAR(2)     | (350:351)    |
| **TRIBE**                  | VARCHAR(4)     | (352:355)    |
| **RESERVATION**            | VARCHAR(4)     | (356:359)    |
| **ARREST_DATE**            | VARCHAR(11)    | (360:370)    |
| **PDID**                   | VARCHAR(12)    | (371:382)    |
| **FBI_NUMBER**             | VARCHAR(15)    | (383:397)    |
| **CRIM_HIST**              | VARCHAR(1)     | (398:398)    |
| **EST_LOSS**               | VARCHAR(14)    | (399:412)    |
| **ACT_LOSS**               | VARCHAR(14)    | (413:426)    |
| **HOME_ADDRESS1**          | VARCHAR(30)    | (427:456)    |
| **HOME_ADDRESS2**          | VARCHAR(30)    | (457:486)    |
| **HOME_ADDRESS3**          | VARCHAR(30)    | (487:516)    |
| **HOME_CITY**              | VARCHAR(20)    | (517:536)    |
| **HOME_STATE**             | VARCHAR(2)     | (537:538)    |
| **HOME_COUNTY**            | VARCHAR(20)    | (539:558)    |
| **HOME_ZIPCODE**           | VARCHAR(20)    | (559:578)    |
| **HOME_PHONE**             | VARCHAR(15)    | (579:593)    |
| **HOME_FAX**               | VARCHAR(15)    | (594:608)    |
| **OFF_ADDRESS1**           | VARCHAR(30)    | (609:638)    |
| **OFF_ADDRESS2**           | VARCHAR(30)    | (639:668)    |
| **OFF_ADDRESS3**           | VARCHAR(30)    | (669:698)    |
| **OFF_CITY**               | VARCHAR(20)    | (699:718)    |
| **OFF_STATE**              | VARCHAR(2)     | (719:720)    |
| **OFF_COUNTY**             | VARCHAR(20)    | (721:740)    |
| **OFF_ZIPCODE**            | VARCHAR(10)    | (741:750)    |
| **OFF_PHONE**              | VARCHAR(15)    | (751:765)    |
| **OFF_FAX**                | VARCHAR(15)    | (766:780)    |
| **MARSHALS_NUM**           | VARCHAR(9)     | (781:789)    |
| **AGCYOFFID**              | VARCHAR(10)    | (790:799)    |
| **LOWER_CRT_TRIAL_NBR**    | VARCHAR(25)    | (800:824)    |
| **BUSINESS_CONTACT_LNAME** | VARCHAR(30)    | (825:854)    |
| **BUSINESS_CONTACT_FNAME** | VARCHAR(30)    | (855:884)    |
| **COLLECT_IND**            | VARCHAR(1)     | (885:885)    |
| **SYS_INIT_DATE**          | VARCHAR(11)    | (886:896)    |
| **WEIGHT**                 | VARCHAR(2)     | (897:898)    |
| **EMPLOYER_NAME**          | VARCHAR(40)    | (899:938)    |
| **EMPLOYER_TYPE**          | VARCHAR(3)     | (939:941)    |
| **EMPLOYER_DESC**          | VARCHAR(40)    | (942:981)    |
| **NPI**                    | VARCHAR(10)    | (982:991)    |
| **OCCUPATION**             | VARCHAR(3)     | (992:994)    |
| **OCCUP_DESC**             | VARCHAR(60)    | (995:1054)   |
| **HCARE_BUSN_TYPE**        | VARCHAR(3)     | (1055:1057)  |
| **HCARE_BUSN_DESC**        | VARCHAR(40)    | (1058:1097)  |
| **CREATE_DATE**            | VARCHAR(11)    | (1098:1108)  |
| **CREATE_USER**            | VARCHAR(30)    | (1109:1138)  |
| **UPDATE_DATE**            | VARCHAR(11)    | (1139:1149)  |
| **UPDATE_USER**            | VARCHAR(30)    | (1150:1180)  |  
  
README.TXT FILES DISK15.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  05:59 PM       188,421,464 gs_participant_PR.txt
07/21/2026  05:59 PM        48,340,692 gs_participant_RI.txt
07/21/2026  05:59 PM       399,271,299 gs_participant_SC.txt
07/21/2026  05:59 PM       142,813,606 gs_participant_SD.txt
07/21/2026  05:59 PM       175,970,181 gs_participant_TNE.txt
07/21/2026  05:59 PM        96,308,188 gs_participant_TNM.txt
07/21/2026  05:59 PM       176,508,717 gs_participant_TNW.txt
07/21/2026  05:59 PM       240,848,416 gs_participant_TXE.txt
07/21/2026  05:59 PM       416,627,275 gs_participant_TXN.txt
07/21/2026  06:01 PM     1,723,352,992 gs_participant_TXS.txt
              10 File(s)  3,608,462,830 bytes
               0 Dir(s)  2,801,908,174,848 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 - 1180 Characters                        

| **Field Name**             | **Field Type** | **Position** |
| -------------------------- | -------------- | ------------ |
| **DISTRICT**               | VARCHAR(10)    | (01:10)      |
| **CASEID**                 | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**           | VARCHAR(10)    | (21:30)      |
| **ID**                     | VARCHAR(10)    | (31:40)      |
| **TYPE**                   | VARCHAR(1)     | (41:41)      |
| **ROLE**                   | VARCHAR(2)     | (42:43)      |
| **SECURITY**               | VARCHAR(1)     | (44:44)      |
| **DEFEND_NUM**             | VARCHAR(11)    | (45:55)      |
| **SALUTATION**             | VARCHAR(20)    | (56:75)      |
| **LAST_NAME**              | VARCHAR(60)    | (76:135)     |
| **FIRST_NAME**             | VARCHAR(30)    | (136:165)    |
| **TITLE**                  | VARCHAR(30)    | (166:195)    |
| **LAST_SOUNDS**            | VARCHAR(4)     | (196:199)    |
| **FIRST_SOUNDS**           | VARCHAR(4)     | (200:203)    |
| **BUSINESS_TYPE**          | VARCHAR(2)     | (204:205)    |
| **EIN**                    | VARCHAR(20)    | (206:225)    |
| **PROP_TYPE**              | VARCHAR(2)     | (226:227)    |
| **TOTAL_TRACTS**           | VARCHAR(11)    | (228:238)    |
| **CATS_ASSET_ID**          | VARCHAR(15)    | (239:253)    |
| **AGENCY**                 | VARCHAR(4)     | (254:257)    |
| **AGENCY_NUM**             | VARCHAR(30)    | (258:287)    |
| **JOB_POSITION**           | VARCHAR(4)     | (288:291)    |
| **SSN**                    | VARCHAR(11)    | (292:302)    |
| **BIRTH_DATE**             | VARCHAR(11)    | (303:313)    |
| **GENDER**                 | VARCHAR(1)     | (314:314)    |
| **JUVENILE**               | VARCHAR(1)     | (315:315)    |
| **RACE**                   | VARCHAR(2)     | (316:317)    |
| **RACE_DESCRIP**           | VARCHAR(30)    | (318:347)    |
| **IMMIG_STAT**             | VARCHAR(2)     | (348:349)    |
| **COUNTRY**                | VARCHAR(2)     | (350:351)    |
| **TRIBE**                  | VARCHAR(4)     | (352:355)    |
| **RESERVATION**            | VARCHAR(4)     | (356:359)    |
| **ARREST_DATE**            | VARCHAR(11)    | (360:370)    |
| **PDID**                   | VARCHAR(12)    | (371:382)    |
| **FBI_NUMBER**             | VARCHAR(15)    | (383:397)    |
| **CRIM_HIST**              | VARCHAR(1)     | (398:398)    |
| **EST_LOSS**               | VARCHAR(14)    | (399:412)    |
| **ACT_LOSS**               | VARCHAR(14)    | (413:426)    |
| **HOME_ADDRESS1**          | VARCHAR(30)    | (427:456)    |
| **HOME_ADDRESS2**          | VARCHAR(30)    | (457:486)    |
| **HOME_ADDRESS3**          | VARCHAR(30)    | (487:516)    |
| **HOME_CITY**              | VARCHAR(20)    | (517:536)    |
| **HOME_STATE**             | VARCHAR(2)     | (537:538)    |
| **HOME_COUNTY**            | VARCHAR(20)    | (539:558)    |
| **HOME_ZIPCODE**           | VARCHAR(20)    | (559:578)    |
| **HOME_PHONE**             | VARCHAR(15)    | (579:593)    |
| **HOME_FAX**               | VARCHAR(15)    | (594:608)    |
| **OFF_ADDRESS1**           | VARCHAR(30)    | (609:638)    |
| **OFF_ADDRESS2**           | VARCHAR(30)    | (639:668)    |
| **OFF_ADDRESS3**           | VARCHAR(30)    | (669:698)    |
| **OFF_CITY**               | VARCHAR(20)    | (699:718)    |
| **OFF_STATE**              | VARCHAR(2)     | (719:720)    |
| **OFF_COUNTY**             | VARCHAR(20)    | (721:740)    |
| **OFF_ZIPCODE**            | VARCHAR(10)    | (741:750)    |
| **OFF_PHONE**              | VARCHAR(15)    | (751:765)    |
| **OFF_FAX**                | VARCHAR(15)    | (766:780)    |
| **MARSHALS_NUM**           | VARCHAR(9)     | (781:789)    |
| **AGCYOFFID**              | VARCHAR(10)    | (790:799)    |
| **LOWER_CRT_TRIAL_NBR**    | VARCHAR(25)    | (800:824)    |
| **BUSINESS_CONTACT_LNAME** | VARCHAR(30)    | (825:854)    |
| **BUSINESS_CONTACT_FNAME** | VARCHAR(30)    | (855:884)    |
| **COLLECT_IND**            | VARCHAR(1)     | (885:885)    |
| **SYS_INIT_DATE**          | VARCHAR(11)    | (886:896)    |
| **WEIGHT**                 | VARCHAR(2)     | (897:898)    |
| **EMPLOYER_NAME**          | VARCHAR(40)    | (899:938)    |
| **EMPLOYER_TYPE**          | VARCHAR(3)     | (939:941)    |
| **EMPLOYER_DESC**          | VARCHAR(40)    | (942:981)    |
| **NPI**                    | VARCHAR(10)    | (982:991)    |
| **OCCUPATION**             | VARCHAR(3)     | (992:994)    |
| **OCCUP_DESC**             | VARCHAR(60)    | (995:1054)   |
| **HCARE_BUSN_TYPE**        | VARCHAR(3)     | (1055:1057)  |
| **HCARE_BUSN_DESC**        | VARCHAR(40)    | (1058:1097)  |
| **CREATE_DATE**            | VARCHAR(11)    | (1098:1108)  |
| **CREATE_USER**            | VARCHAR(30)    | (1109:1138)  |
| **UPDATE_DATE**            | VARCHAR(11)    | (1139:1149)  |
| **UPDATE_USER**            | VARCHAR(30)    | (1150:1180)  |  
  
README.TXT FILES DISK16.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  06:02 PM     1,339,822,061 gs_participant_TXW.txt
07/21/2026  06:02 PM       160,373,895 gs_participant_UT.txt
07/21/2026  06:02 PM       145,142,538 gs_participant_VAW.txt
07/21/2026  06:02 PM        37,486,121 gs_participant_VI.txt
07/21/2026  06:02 PM        68,794,431 gs_participant_VT.txt
07/21/2026  06:02 PM       114,295,999 gs_participant_WAE.txt
07/21/2026  06:02 PM       291,140,120 gs_participant_WAW.txt
07/21/2026  06:03 PM       185,993,328 gs_participant_WIE.txt
07/21/2026  06:03 PM        73,697,943 gs_participant_WVN.txt
07/21/2026  06:03 PM       146,640,046 gs_participant_WVS.txt
07/21/2026  06:03 PM        90,135,101 gs_participant_WY.txt
07/21/2026  06:11 PM        31,071,168 gs_part_event_AK.txt
07/21/2026  06:11 PM        37,691,136 gs_part_event_ALM.txt
07/21/2026  06:12 PM       131,131,152 gs_part_event_ALN.txt
07/21/2026  06:12 PM        36,383,472 gs_part_event_ALS.txt
07/21/2026  06:12 PM        41,752,368 gs_part_event_ARE.txt
07/21/2026  06:12 PM        39,084,480 gs_part_event_ARW.txt
07/21/2026  06:12 PM       344,148,336 gs_part_event_AZ.txt
07/21/2026  06:13 PM       410,337,216 gs_part_event_CAC.txt
07/21/2026  06:13 PM        72,006,336 gs_part_event_CAE.txt
07/21/2026  06:13 PM       169,749,648 gs_part_event_CAN.txt
              21 File(s)  3,966,876,895 bytes
               0 Dir(s)  2,801,908,166,656 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 - 1180 Characters                        

| **Field Name**             | **Field Type** | **Position** |
| -------------------------- | -------------- | ------------ |
| **DISTRICT**               | VARCHAR(10)    | (01:10)      |
| **CASEID**                 | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**           | VARCHAR(10)    | (21:30)      |
| **ID**                     | VARCHAR(10)    | (31:40)      |
| **TYPE**                   | VARCHAR(1)     | (41:41)      |
| **ROLE**                   | VARCHAR(2)     | (42:43)      |
| **SECURITY**               | VARCHAR(1)     | (44:44)      |
| **DEFEND_NUM**             | VARCHAR(11)    | (45:55)      |
| **SALUTATION**             | VARCHAR(20)    | (56:75)      |
| **LAST_NAME**              | VARCHAR(60)    | (76:135)     |
| **FIRST_NAME**             | VARCHAR(30)    | (136:165)    |
| **TITLE**                  | VARCHAR(30)    | (166:195)    |
| **LAST_SOUNDS**            | VARCHAR(4)     | (196:199)    |
| **FIRST_SOUNDS**           | VARCHAR(4)     | (200:203)    |
| **BUSINESS_TYPE**          | VARCHAR(2)     | (204:205)    |
| **EIN**                    | VARCHAR(20)    | (206:225)    |
| **PROP_TYPE**              | VARCHAR(2)     | (226:227)    |
| **TOTAL_TRACTS**           | VARCHAR(11)    | (228:238)    |
| **CATS_ASSET_ID**          | VARCHAR(15)    | (239:253)    |
| **AGENCY**                 | VARCHAR(4)     | (254:257)    |
| **AGENCY_NUM**             | VARCHAR(30)    | (258:287)    |
| **JOB_POSITION**           | VARCHAR(4)     | (288:291)    |
| **SSN**                    | VARCHAR(11)    | (292:302)    |
| **BIRTH_DATE**             | VARCHAR(11)    | (303:313)    |
| **GENDER**                 | VARCHAR(1)     | (314:314)    |
| **JUVENILE**               | VARCHAR(1)     | (315:315)    |
| **RACE**                   | VARCHAR(2)     | (316:317)    |
| **RACE_DESCRIP**           | VARCHAR(30)    | (318:347)    |
| **IMMIG_STAT**             | VARCHAR(2)     | (348:349)    |
| **COUNTRY**                | VARCHAR(2)     | (350:351)    |
| **TRIBE**                  | VARCHAR(4)     | (352:355)    |
| **RESERVATION**            | VARCHAR(4)     | (356:359)    |
| **ARREST_DATE**            | VARCHAR(11)    | (360:370)    |
| **PDID**                   | VARCHAR(12)    | (371:382)    |
| **FBI_NUMBER**             | VARCHAR(15)    | (383:397)    |
| **CRIM_HIST**              | VARCHAR(1)     | (398:398)    |
| **EST_LOSS**               | VARCHAR(14)    | (399:412)    |
| **ACT_LOSS**               | VARCHAR(14)    | (413:426)    |
| **HOME_ADDRESS1**          | VARCHAR(30)    | (427:456)    |
| **HOME_ADDRESS2**          | VARCHAR(30)    | (457:486)    |
| **HOME_ADDRESS3**          | VARCHAR(30)    | (487:516)    |
| **HOME_CITY**              | VARCHAR(20)    | (517:536)    |
| **HOME_STATE**             | VARCHAR(2)     | (537:538)    |
| **HOME_COUNTY**            | VARCHAR(20)    | (539:558)    |
| **HOME_ZIPCODE**           | VARCHAR(20)    | (559:578)    |
| **HOME_PHONE**             | VARCHAR(15)    | (579:593)    |
| **HOME_FAX**               | VARCHAR(15)    | (594:608)    |
| **OFF_ADDRESS1**           | VARCHAR(30)    | (609:638)    |
| **OFF_ADDRESS2**           | VARCHAR(30)    | (639:668)    |
| **OFF_ADDRESS3**           | VARCHAR(30)    | (669:698)    |
| **OFF_CITY**               | VARCHAR(20)    | (699:718)    |
| **OFF_STATE**              | VARCHAR(2)     | (719:720)    |
| **OFF_COUNTY**             | VARCHAR(20)    | (721:740)    |
| **OFF_ZIPCODE**            | VARCHAR(10)    | (741:750)    |
| **OFF_PHONE**              | VARCHAR(15)    | (751:765)    |
| **OFF_FAX**                | VARCHAR(15)    | (766:780)    |
| **MARSHALS_NUM**           | VARCHAR(9)     | (781:789)    |
| **AGCYOFFID**              | VARCHAR(10)    | (790:799)    |
| **LOWER_CRT_TRIAL_NBR**    | VARCHAR(25)    | (800:824)    |
| **BUSINESS_CONTACT_LNAME** | VARCHAR(30)    | (825:854)    |
| **BUSINESS_CONTACT_FNAME** | VARCHAR(30)    | (855:884)    |
| **COLLECT_IND**            | VARCHAR(1)     | (885:885)    |
| **SYS_INIT_DATE**          | VARCHAR(11)    | (886:896)    |
| **WEIGHT**                 | VARCHAR(2)     | (897:898)    |
| **EMPLOYER_NAME**          | VARCHAR(40)    | (899:938)    |
| **EMPLOYER_TYPE**          | VARCHAR(3)     | (939:941)    |
| **EMPLOYER_DESC**          | VARCHAR(40)    | (942:981)    |
| **NPI**                    | VARCHAR(10)    | (982:991)    |
| **OCCUPATION**             | VARCHAR(3)     | (992:994)    |
| **OCCUP_DESC**             | VARCHAR(60)    | (995:1054)   |
| **HCARE_BUSN_TYPE**        | VARCHAR(3)     | (1055:1057)  |
| **HCARE_BUSN_DESC**        | VARCHAR(40)    | (1058:1097)  |
| **CREATE_DATE**            | VARCHAR(11)    | (1098:1108)  |
| **CREATE_USER**            | VARCHAR(30)    | (1109:1138)  |
| **UPDATE_DATE**            | VARCHAR(11)    | (1139:1149)  |
| **UPDATE_USER**            | VARCHAR(30)    | (1150:1180)  |


GS_PART_EVENT - 142 Characters                        

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **CASEID**       | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID** | VARCHAR(10)    | (21:30)      |
| **PARTID**       | VARCHAR(10)    | (31:40)      |
| **CRTHISID**     | VARCHAR(10)    | (41:50)      |
| **EVENTID**      | VARCHAR(10)    | (51:60)      |
| **CREATE_DATE**  | DATE (11)      | (61:71)      |
| **CREATE_USER**  | VARCHAR(30)    | (72:101)     |
| **UPDATE_DATE**  | DATE (11)      | (102:112)    |
| **UPDATE_USER**  | VARCHAR(30)    | (113:142)    |
  
  
README.TXT FILES DISK17.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  06:13 PM       245,458,224 gs_part_event_CAS.txt
07/21/2026  06:13 PM       133,259,904 gs_part_event_CO.txt
07/21/2026  06:13 PM        71,453,808 gs_part_event_CT.txt
07/21/2026  06:13 PM       255,431,520 gs_part_event_DC.txt
07/21/2026  06:13 PM        18,448,704 gs_part_event_DE.txt
07/21/2026  06:14 PM       247,473,072 gs_part_event_FLM.txt
07/21/2026  06:14 PM       107,362,800 gs_part_event_FLN.txt
07/21/2026  06:14 PM       239,902,848 gs_part_event_FLS.txt
07/21/2026  06:14 PM        76,387,824 gs_part_event_GAM.txt
07/21/2026  06:14 PM        44,479,728 gs_part_event_GAN.txt
07/21/2026  06:14 PM        46,489,968 gs_part_event_GAS.txt
07/21/2026  06:14 PM        16,274,160 gs_part_event_GU.txt
07/21/2026  06:14 PM        43,177,248 gs_part_event_HI.txt
07/21/2026  06:14 PM        87,438,240 gs_part_event_IAN.txt
07/21/2026  06:14 PM        45,613,152 gs_part_event_IAS.txt
07/21/2026  06:14 PM        85,910,256 gs_part_event_ID.txt
07/21/2026  06:14 PM        23,712,480 gs_part_event_ILC.txt
07/21/2026  06:14 PM        70,947,936 gs_part_event_ILN.txt
07/21/2026  06:14 PM       149,000,688 gs_part_event_ILS.txt
07/21/2026  06:14 PM        62,826,048 gs_part_event_INN.txt
07/21/2026  06:14 PM        71,034,336 gs_part_event_INS.txt
07/21/2026  06:14 PM       188,266,752 gs_part_event_KS.txt
07/21/2026  06:14 PM        86,253,984 gs_part_event_KYE.txt
07/21/2026  06:14 PM        96,692,832 gs_part_event_KYW.txt
07/21/2026  06:15 PM        50,207,328 gs_part_event_LAE.txt
07/21/2026  06:15 PM        25,298,640 gs_part_event_LAM.txt
07/21/2026  06:15 PM        64,457,568 gs_part_event_LAW.txt
07/21/2026  06:15 PM        84,288,096 gs_part_event_MA.txt
07/21/2026  06:15 PM        42,742,656 gs_part_event_MD.txt
07/21/2026  06:15 PM        57,393,936 gs_part_event_ME.txt
07/21/2026  06:15 PM        99,982,224 gs_part_event_MIE.txt
07/21/2026  06:15 PM        56,088,288 gs_part_event_MIW.txt
07/21/2026  06:15 PM        51,182,640 gs_part_event_MN.txt
07/21/2026  06:15 PM        74,110,896 gs_part_event_MOE.txt
07/21/2026  06:15 PM       158,389,632 gs_part_event_MOW.txt
07/21/2026  06:15 PM        47,848,176 gs_part_event_MSN.txt
07/21/2026  06:15 PM       103,253,040 gs_part_event_MSS.txt
07/21/2026  06:15 PM        54,939,600 gs_part_event_MT.txt
07/21/2026  06:15 PM       121,062,528 gs_part_event_NCE.txt
07/21/2026  06:15 PM        34,487,856 gs_part_event_NCM.txt
07/21/2026  06:15 PM       118,304,496 gs_part_event_NCW.txt
07/21/2026  06:15 PM        66,328,416 gs_part_event_ND.txt
07/21/2026  06:15 PM        80,225,424 gs_part_event_NE.txt
07/21/2026  06:15 PM        55,148,256 gs_part_event_NH.txt
07/21/2026  06:15 PM       121,179,168 gs_part_event_NJ.txt
              45 File(s)  4,080,215,376 bytes
               0 Dir(s)  2,801,908,158,464 bytes free
  
Table Layouts:

GS_PART_EVENT - 142 Characters                        

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **CASEID**       | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID** | VARCHAR(10)    | (21:30)      |
| **PARTID**       | VARCHAR(10)    | (31:40)      |
| **CRTHISID**     | VARCHAR(10)    | (41:50)      |
| **EVENTID**      | VARCHAR(10)    | (51:60)      |
| **CREATE_DATE**  | DATE (11)      | (61:71)      |
| **CREATE_USER**  | VARCHAR(30)    | (72:101)     |
| **UPDATE_DATE**  | DATE (11)      | (102:112)    |
| **UPDATE_USER**  | VARCHAR(30)    | (113:142)    |
  
  
README.TXT FILES DISK18.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  06:16 PM       313,508,304 gs_part_event_NM.txt
07/21/2026  06:16 PM       228,769,200 gs_part_event_NV.txt
07/21/2026  06:16 PM       211,661,424 gs_part_event_NYE.txt
07/21/2026  06:16 PM        41,970,384 gs_part_event_NYN.txt
07/21/2026  06:16 PM       311,851,872 gs_part_event_NYS.txt
07/21/2026  06:16 PM       135,741,168 gs_part_event_NYW.txt
07/21/2026  06:17 PM       198,071,568 gs_part_event_OHN.txt
07/21/2026  06:17 PM       200,842,272 gs_part_event_OHS.txt
07/21/2026  06:17 PM        25,989,552 gs_part_event_OKE.txt
07/21/2026  06:17 PM        70,159,248 gs_part_event_OKN.txt
07/21/2026  06:17 PM        45,000,720 gs_part_event_OKW.txt
07/21/2026  06:17 PM        57,467,376 gs_part_event_OR.txt
07/21/2026  06:17 PM       122,577,984 gs_part_event_PAE.txt
07/21/2026  06:17 PM        87,181,632 gs_part_event_PAM.txt
07/21/2026  06:17 PM       106,803,792 gs_part_event_PAW.txt
07/21/2026  06:17 PM        78,055,776 gs_part_event_PR.txt
07/21/2026  06:17 PM        13,221,648 gs_part_event_RI.txt
07/21/2026  06:17 PM       106,886,592 gs_part_event_SC.txt
07/21/2026  06:17 PM        88,406,064 gs_part_event_SD.txt
07/21/2026  06:17 PM        82,695,744 gs_part_event_TNE.txt
07/21/2026  06:17 PM        37,138,608 gs_part_event_TNM.txt
07/21/2026  05:31 PM           541,875 gs_court_order_disp.txt
07/21/2026  05:32 PM       464,757,228 gs_defend_stat.txt
07/21/2026  05:32 PM       775,083,062 gs_instrument.txt
              24 File(s)  3,804,383,093 bytes
               0 Dir(s)  2,801,908,154,368 bytes free
  
Table Layouts:

GS_PART_EVENT - 142 Characters                        

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **CASEID**       | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID** | VARCHAR(10)    | (21:30)      |
| **PARTID**       | VARCHAR(10)    | (31:40)      |
| **CRTHISID**     | VARCHAR(10)    | (41:50)      |
| **EVENTID**      | VARCHAR(10)    | (51:60)      |
| **CREATE_DATE**  | DATE (11)      | (61:71)      |
| **CREATE_USER**  | VARCHAR(30)    | (72:101)     |
| **UPDATE_DATE**  | DATE (11)      | (102:112)    |
| **UPDATE_USER**  | VARCHAR(30)    | (113:142)    |


GS_COURT_ORDER_DISP - 287 Characters                        

| **Field Name**    | **Field Type** | **Position** |
| ----------------- | -------------- | ------------ |
| **DISTRICT**      | VARCHAR(10)    | (01:10)      |
| **CASEID**        | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**  | VARCHAR(10)    | (21:30)      |
| **CRTHISID**      | VARCHAR(10)    | (31:40)      |
| **PARTID**        | VARCHAR(10)    | (41:50)      |
| **CODE**          | VARCHAR(4)     | (51:54)      |
| **SYSTEM_DATE**   | DATE (11)      | (55:65)      |
| **DATE_OF_ORDER** | VARCHAR(11)    | (66:76)      |
| **LAST_NAME**     | VARCHAR(60)    | (77:136)     |
| **FIRST_NAME**    | VARCHAR(30)    | (137:166)    |
| **COURT**         | VARCHAR(4)     | (167:170)    |
| **COURT_NUMBER**  | VARCHAR(25)    | (171:195)    |
| **PARTID2**       | VARCHAR(10)    | (196:205)    |
| **CREATE_DATE**   | DATE (11)      | (206:216)    |
| **CREATE_USER**   | VARCHAR(30)    | (217:246)    |
| **UPDATE_DATE**   | DATE (11)      | (247:257)    |
| **UPDATE_USER**   | VARCHAR(30)    | (258:287)    |


GS_DEFEND_STAT - 205 Characters                        

| **Field Name**    | **Field Type** | **Position** |
| ----------------- | -------------- | ------------ |
| **DISTRICT**      | VARCHAR(10)    | (01:10)      |
| **CASEID**        | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**  | VARCHAR(10)    | (21:30)      |
| **PARTID**        | VARCHAR(10)    | (31:40)      |
| **ID**            | VARCHAR(10)    | (41:50)      |
| **TYPE**          | VARCHAR(2)     | (51:52)      |
| **START_DATE**    | DATE (11)      | (53:63)      |
| **CUSTODY_LOC**   | VARCHAR(2)     | (64:65)      |
| **DETEN_REASON**  | VARCHAR(4)     | (66:69)      |
| **BOND_TYPE**     | VARCHAR(2)     | (70:71)      |
| **BOND_AMOUNT**   | VARCHAR(14)    | (72:85)      |
| **BOND_PROVIDER** | VARCHAR(25)    | (86:110)     |
| **TERM_REASON**   | VARCHAR(2)     | (111:112)    |
| **END_DATE**      | DATE (11)      | (113:123)    |
| **CREATE_DATE**   | DATE (11)      | (124:134)    |
| **CREATE_USER**   | VARCHAR(30)    | (135:164)    |
| **UPDATE_DATE**   | DATE (11)      | (165:175)    |
| **UPDATE_USER**   | VARCHAR(30)    | (176:205)    |


GS_INSTRUMENT - 156 Characters                        

| **Field Name**      | **Field Type** | **Position** |
| ------------------- | -------------- | ------------ |
| **DISTRICT**        | VARCHAR(10)    | (01:10)      |
| **CASEID**          | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**    | VARCHAR(10)    | (21:30)      |
| **CRTHISID**        | VARCHAR(10)    | (31:40)      |
| **ID**              | VARCHAR(10)    | (41:50)      |
| **TYPE**            | VARCHAR(2)     | (51:52)      |
| **FILING_DATE**     | DATE (11)      | (53:63)      |
| **SYS_FILING_DATE** | DATE (11)      | (64:74)      |
| **CREATE_DATE**     | DATE (11)      | (75:85)      |
| **CREATE_USER**     | VARCHAR(30)    | (86:115)     |
| **UPDATE_DATE**     | DATE (11)      | (116:126)    |
| **UPDATE_USER**     | VARCHAR(30)    | (127:156)    |


  
  
README.TXT FILES DISK19.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  05:43 PM     1,534,859,095 gs_agent.txt
               1 File(s)  1,534,859,095 bytes
               0 Dir(s)  2,801,908,150,272 bytes free
  
Table Layouts:

GS_AGENT - 381 Characters                        

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **CASEID**       | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID** | VARCHAR(10)    | (21:30)      |
| **PARTID**       | VARCHAR(10)    | (31:40)      |
| **ID**           | VARCHAR(10)    | (41:50)      |
| **SALUTATION**   | VARCHAR(8)     | (51:58)      |
| **LAST_NAME**    | VARCHAR(30)    | (59:88)      |
| **FIRST_NAME**   | VARCHAR(30)    | (89:118)     |
| **TITLE**        | VARCHAR(30)    | (119:148)    |
| **PHONE**        | VARCHAR(20)    | (149:168)    |
| **FAX**          | VARCHAR(15)    | (169:183)    |
| **PAGER**        | VARCHAR(15)    | (184:198)    |
| **LEAD_AGENT**   | VARCHAR(1)     | (199:199)    |
| **EMAIL**        | VARCHAR(100)   | (200:299)    |
| **CREATE_DATE**  | DATE (11)      | (300:310)    |
| **CREATE_USER**  | VARCHAR(30)    | (311:340)    |
| **UPDATE_DATE**  | DATE (11)      | (341:351)    |
| **UPDATE_USER**  | VARCHAR(30)    | (352:381)    |  
  
README.TXT FILES DISK20.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  05:36 PM     2,852,299,625 gs_part_court.txt
07/21/2026  06:17 PM        83,735,136 gs_part_event_TNW.txt
07/21/2026  06:17 PM       122,282,496 gs_part_event_TXE.txt
07/21/2026  06:17 PM       217,092,240 gs_part_event_TXN.txt
07/21/2026  06:18 PM       414,583,056 gs_part_event_TXS.txt
07/21/2026  06:18 PM       215,284,608 gs_part_event_TXW.txt
07/21/2026  06:18 PM        91,918,368 gs_part_event_UT.txt
07/21/2026  06:18 PM       151,593,984 gs_part_event_VAE.txt
07/21/2026  06:18 PM        67,153,824 gs_part_event_VAW.txt
07/21/2026  06:18 PM        39,828,528 gs_part_event_VI.txt
07/21/2026  06:18 PM        39,460,320 gs_part_event_VT.txt
07/21/2026  06:18 PM        45,644,112 gs_part_event_WAE.txt
              12 File(s)  4,340,876,297 bytes
               0 Dir(s)  2,801,908,150,272 bytes free
  
Table Layouts:

GS_PART_COURT - 173 Characters                        

| **Field Name**    | **Field Type** | **Position** |
| ----------------- | -------------- | ------------ |
| **DISTRICT**      | VARCHAR(10)    | (01:10)      |
| **CASEID**        | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**  | VARCHAR(10)    | (21:30)      |
| **PARTID**        | VARCHAR(10)    | (31:40)      |
| **CRTHISID**      | VARCHAR(10)    | (41:50)      |
| **APPEAL_ROLE**   | VARCHAR(2)     | (51:52)      |
| **DISPOSITION**   | VARCHAR(2)     | (53:54)      |
| **DISP_REASON**   | VARCHAR(4)     | (55:58)      |
| **DISP_DATE**     | DATE (11)      | (59:69)      |
| **SYS_DISP_DATE** | DATE (11)      | (70:80)      |
| **SYS_INIT_DATE** | DATE (11)      | (81:91)      |
| **CREATE_DATE**   | DATE (11)      | (92:102)     |
| **CREATE_USER**   | VARCHAR(30)    | (103:132)    |
| **UPDATE_DATE**   | DATE (11)      | (133:143)    |
| **UPDATE_USER**   | VARCHAR(30)    | (144:173)    |


GS_PART_EVENT - 142 Characters                        

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **CASEID**       | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID** | VARCHAR(10)    | (21:30)      |
| **PARTID**       | VARCHAR(10)    | (31:40)      |
| **CRTHISID**     | VARCHAR(10)    | (41:50)      |
| **EVENTID**      | VARCHAR(10)    | (51:60)      |
| **CREATE_DATE**  | DATE (11)      | (61:71)      |
| **CREATE_USER**  | VARCHAR(30)    | (72:101)     |
| **UPDATE_DATE**  | DATE (11)      | (102:112)    |
| **UPDATE_USER**  | VARCHAR(30)    | (113:142)    |
  
  
README.TXT FILES DISK21.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  06:18 PM        59,324,544 gs_part_event_WAW.txt
07/21/2026  06:18 PM        40,133,952 gs_part_event_WIE.txt
07/21/2026  06:18 PM        64,943,424 gs_part_event_WIW.txt
07/21/2026  06:18 PM        49,973,472 gs_part_event_WVN.txt
07/21/2026  06:18 PM        89,157,888 gs_part_event_WVS.txt
07/21/2026  06:18 PM        27,032,832 gs_part_event_WY.txt
07/21/2026  05:49 PM     1,437,626,576 gs_participant_AZ.txt
07/21/2026  05:55 PM        88,747,426 gs_participant_ND.txt
07/21/2026  06:02 PM       607,322,164 gs_participant_VAE.txt
07/21/2026  06:03 PM       136,324,011 gs_participant_WIW.txt
              10 File(s)  2,600,586,289 bytes
               0 Dir(s)  2,801,908,146,176 bytes free
  
Table Layouts:

GS_PART_EVENT - 142 Characters                        

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **CASEID**       | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID** | VARCHAR(10)    | (21:30)      |
| **PARTID**       | VARCHAR(10)    | (31:40)      |
| **CRTHISID**     | VARCHAR(10)    | (41:50)      |
| **EVENTID**      | VARCHAR(10)    | (51:60)      |
| **CREATE_DATE**  | DATE (11)      | (61:71)      |
| **CREATE_USER**  | VARCHAR(30)    | (72:101)     |
| **UPDATE_DATE**  | DATE (11)      | (102:112)    |
| **UPDATE_USER**  | VARCHAR(30)    | (113:142)    |

* 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 - 1180 Characters                        

| **Field Name**             | **Field Type** | **Position** |
| -------------------------- | -------------- | ------------ |
| **DISTRICT**               | VARCHAR(10)    | (01:10)      |
| **CASEID**                 | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**           | VARCHAR(10)    | (21:30)      |
| **ID**                     | VARCHAR(10)    | (31:40)      |
| **TYPE**                   | VARCHAR(1)     | (41:41)      |
| **ROLE**                   | VARCHAR(2)     | (42:43)      |
| **SECURITY**               | VARCHAR(1)     | (44:44)      |
| **DEFEND_NUM**             | VARCHAR(11)    | (45:55)      |
| **SALUTATION**             | VARCHAR(20)    | (56:75)      |
| **LAST_NAME**              | VARCHAR(60)    | (76:135)     |
| **FIRST_NAME**             | VARCHAR(30)    | (136:165)    |
| **TITLE**                  | VARCHAR(30)    | (166:195)    |
| **LAST_SOUNDS**            | VARCHAR(4)     | (196:199)    |
| **FIRST_SOUNDS**           | VARCHAR(4)     | (200:203)    |
| **BUSINESS_TYPE**          | VARCHAR(2)     | (204:205)    |
| **EIN**                    | VARCHAR(20)    | (206:225)    |
| **PROP_TYPE**              | VARCHAR(2)     | (226:227)    |
| **TOTAL_TRACTS**           | VARCHAR(11)    | (228:238)    |
| **CATS_ASSET_ID**          | VARCHAR(15)    | (239:253)    |
| **AGENCY**                 | VARCHAR(4)     | (254:257)    |
| **AGENCY_NUM**             | VARCHAR(30)    | (258:287)    |
| **JOB_POSITION**           | VARCHAR(4)     | (288:291)    |
| **SSN**                    | VARCHAR(11)    | (292:302)    |
| **BIRTH_DATE**             | VARCHAR(11)    | (303:313)    |
| **GENDER**                 | VARCHAR(1)     | (314:314)    |
| **JUVENILE**               | VARCHAR(1)     | (315:315)    |
| **RACE**                   | VARCHAR(2)     | (316:317)    |
| **RACE_DESCRIP**           | VARCHAR(30)    | (318:347)    |
| **IMMIG_STAT**             | VARCHAR(2)     | (348:349)    |
| **COUNTRY**                | VARCHAR(2)     | (350:351)    |
| **TRIBE**                  | VARCHAR(4)     | (352:355)    |
| **RESERVATION**            | VARCHAR(4)     | (356:359)    |
| **ARREST_DATE**            | VARCHAR(11)    | (360:370)    |
| **PDID**                   | VARCHAR(12)    | (371:382)    |
| **FBI_NUMBER**             | VARCHAR(15)    | (383:397)    |
| **CRIM_HIST**              | VARCHAR(1)     | (398:398)    |
| **EST_LOSS**               | VARCHAR(14)    | (399:412)    |
| **ACT_LOSS**               | VARCHAR(14)    | (413:426)    |
| **HOME_ADDRESS1**          | VARCHAR(30)    | (427:456)    |
| **HOME_ADDRESS2**          | VARCHAR(30)    | (457:486)    |
| **HOME_ADDRESS3**          | VARCHAR(30)    | (487:516)    |
| **HOME_CITY**              | VARCHAR(20)    | (517:536)    |
| **HOME_STATE**             | VARCHAR(2)     | (537:538)    |
| **HOME_COUNTY**            | VARCHAR(20)    | (539:558)    |
| **HOME_ZIPCODE**           | VARCHAR(20)    | (559:578)    |
| **HOME_PHONE**             | VARCHAR(15)    | (579:593)    |
| **HOME_FAX**               | VARCHAR(15)    | (594:608)    |
| **OFF_ADDRESS1**           | VARCHAR(30)    | (609:638)    |
| **OFF_ADDRESS2**           | VARCHAR(30)    | (639:668)    |
| **OFF_ADDRESS3**           | VARCHAR(30)    | (669:698)    |
| **OFF_CITY**               | VARCHAR(20)    | (699:718)    |
| **OFF_STATE**              | VARCHAR(2)     | (719:720)    |
| **OFF_COUNTY**             | VARCHAR(20)    | (721:740)    |
| **OFF_ZIPCODE**            | VARCHAR(10)    | (741:750)    |
| **OFF_PHONE**              | VARCHAR(15)    | (751:765)    |
| **OFF_FAX**                | VARCHAR(15)    | (766:780)    |
| **MARSHALS_NUM**           | VARCHAR(9)     | (781:789)    |
| **AGCYOFFID**              | VARCHAR(10)    | (790:799)    |
| **LOWER_CRT_TRIAL_NBR**    | VARCHAR(25)    | (800:824)    |
| **BUSINESS_CONTACT_LNAME** | VARCHAR(30)    | (825:854)    |
| **BUSINESS_CONTACT_FNAME** | VARCHAR(30)    | (855:884)    |
| **COLLECT_IND**            | VARCHAR(1)     | (885:885)    |
| **SYS_INIT_DATE**          | VARCHAR(11)    | (886:896)    |
| **WEIGHT**                 | VARCHAR(2)     | (897:898)    |
| **EMPLOYER_NAME**          | VARCHAR(40)    | (899:938)    |
| **EMPLOYER_TYPE**          | VARCHAR(3)     | (939:941)    |
| **EMPLOYER_DESC**          | VARCHAR(40)    | (942:981)    |
| **NPI**                    | VARCHAR(10)    | (982:991)    |
| **OCCUPATION**             | VARCHAR(3)     | (992:994)    |
| **OCCUP_DESC**             | VARCHAR(60)    | (995:1054)   |
| **HCARE_BUSN_TYPE**        | VARCHAR(3)     | (1055:1057)  |
| **HCARE_BUSN_DESC**        | VARCHAR(40)    | (1058:1097)  |
| **CREATE_DATE**            | VARCHAR(11)    | (1098:1108)  |
| **CREATE_USER**            | VARCHAR(30)    | (1109:1138)  |
| **UPDATE_DATE**            | VARCHAR(11)    | (1139:1149)  |
| **UPDATE_USER**            | VARCHAR(30)    | (1150:1180)  |

  
  
README.TXT FILES DISK22.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  05:24 PM     2,574,864,283 gs_assignment.txt
               1 File(s)  2,574,864,283 bytes
               0 Dir(s)  2,801,908,137,984 bytes free
  
Table Layouts:

GS_ASSIGNMENT - 165 Characters                        

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **CASEID**       | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID** | VARCHAR(10)    | (21:30)      |
| **CRTHISID**     | VARCHAR(10)    | (31:40)      |
| **ID**           | VARCHAR(10)    | (41:50)      |
| **STAFFID**      | VARCHAR(10)    | (51:60)      |
| **POSITION**     | VARCHAR(1)     | (61:61)      |
| **START_DATE**   | DATE (11)      | (62:72)      |
| **END_DATE**     | DATE (11)      | (73:83)      |
| **CREATE_DATE**  | DATE (11)      | (84:94)      |
| **CREATE_USER**  | VARCHAR(30)    | (95:124)     |
| **UPDATE_DATE**  | DATE (11)      | (125:135)    |
| **UPDATE_USER**  | VARCHAR(30)    | (136:165)    |


  
  
README.TXT FILES DISK23.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  05:34 PM     2,551,922,802 gs_part_count.txt
07/21/2026  05:38 PM       899,934,340 gs_part_relief.txt
               2 File(s)  3,451,857,142 bytes
               0 Dir(s)  2,801,908,137,984 bytes free
  
Table Layouts:

GS_PART_COUNT - 196 Characters                

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **CASEID**       | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID** | VARCHAR(10)    | (21:30)      |
| **PARTID**       | VARCHAR(10)    | (31:40)      |
| **CRTHISID**     | VARCHAR(10)    | (41:50)      |
| **INSTID**       | VARCHAR(10)    | (51:60)      |
| **CHARGE**       | VARCHAR(25)    | (61:85)      |
| **CATEGORY**     | VARCHAR(1)     | (86:86)      |
| **COUNTID**      | VARCHAR(10)    | (87:96)      |
| **DISPOSITION**  | VARCHAR(2)     | (97:98)      |
| **DISP_REASON**  | VARCHAR(4)     | (99:102)     |
| **DISP_DATE**    | DATE (11)      | (103:113)    |
| **SEALED**       | VARCHAR(1)     | (114:114)    |
| **CREATE_DATE**  | DATE (11)      | (115:125)    |
| **CREATE_USER**  | VARCHAR(30)    | (126:155)    |
| **UPDATE_DATE**  | DATE (11)      | (156:166)    |
| **UPDATE_USER**  | VARCHAR(30)    | (167:196)    |


GS_PART_RELIEF - 122 Characters                        

| **Field Name**  | **Field Type** | **Position** |
| --------------- | -------------- | ------------ |
| **DISTRICT**    | VARCHAR(10)    | (01:10)      |
| **CASEID**      | VARCHAR(10)    | (11:20)      |
| **PARTID**      | VARCHAR(10)    | (21:30)      |
| **RELIEFID**    | VARCHAR(10)    | (31:40)      |
| **CREATE_DATE** | DATE (11)      | (41:51)      |
| **CREATE_USER** | VARCHAR(30)    | (52:81)      |
| **UPDATE_DATE** | DATE (11)      | (82:92)      |
| **UPDATE_USER** | VARCHAR(30)    | (93:122)     |


  
  
README.TXT FILES DISK24.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  05:40 PM     1,028,309,352 gs_relief.txt
07/21/2026  05:42 PM       673,174,878 gs_triggerlock.txt
               2 File(s)  1,701,484,230 bytes
               0 Dir(s)  2,801,908,137,984 bytes free
  
Table Layouts:


GS_RELIEF - 166 Characters                        

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **CASEID**       | VARCHAR(10)    | (11:20)      |
| **ID**           | VARCHAR(10)    | (21:30)      |
| **TYPE**         | VARCHAR(1)     | (31:31)      |
| **STAGE**        | VARCHAR(1)     | (32:32)      |
| **REQUESTED_BY** | VARCHAR(1)     | (33:33)      |
| **LIABILITY**    | VARCHAR(1)     | (34:34)      |
| **AMOUNT**       | VARCHAR(16)    | (35:50)      |
| **NONMONETARY**  | VARCHAR(30)    | (51:80)      |
| **AGENCY**       | VARCHAR(4)     | (81:84)      |
| **CREATE_DATE**  | DATE (11)      | (85:95)      |
| **CREATE_USER**  | VARCHAR(30)    | (96:125)     |
| **UPDATE_DATE**  | DATE (11)      | (126:136)    |
| **UPDATE_USER**  | VARCHAR(30)    | (137:166)    |


GS_TRIGGERLOCK - 319 Characters                        

| **Field Name**                 | **Field Type** | **Position** |
| ------------------------------ | -------------- | ------------ |
| **DISTRICT**                   | VARCHAR(10)    | (01:10)      |
| **CASEID**                     | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID**               | VARCHAR(10)    | (21:30)      |
| **PARTID**                     | VARCHAR(10)    | (31:40)      |
| **BRADY_OFFENSE**              | VARCHAR(1)     | (41:41)      |
| **NOTICE_3_STRIKES**           | VARCHAR(1)     | (42:42)      |
| **DATE_NOTICE_FILED**          | DATE (11)      | (43:53)      |
| **DATE_NOTICE_WITHDRAWN**      | DATE (11)      | (54:64)      |
| **WITHDRAWAL_REASON**          | VARCHAR(78)    | (65:142)     |
| **CONVICTION_3_STRIKES**       | VARCHAR(1)     | (143:143)    |
| **LIFE_3_STRIKES**             | VARCHAR(1)     | (144:144)    |
| **NO_LIFE_REASON**             | VARCHAR(78)    | (145:222)    |
| **THIRD_PROSEC_TRIGG_OFFENSE** | VARCHAR(1)     | (223:223)    |
| **TRIGGERLOCK_DEF**            | VARCHAR(1)     | (224:224)    |
| **BAILEY_SENTENCE_CHANGE**     | VARCHAR(1)     | (225:225)    |
| **SENTENCE_PRIOR_BAILEY**      | VARCHAR(11)    | (226:236)    |
| **ARMED_CAREER_CRIMINAL**      | VARCHAR(1)     | (237:237)    |
| **CREATE_DATE**                | DATE (11)      | (238:248)    |
| **CREATE_USER**                | VARCHAR(30)    | (249:278)    |
| **UPDATE_DATE**                | DATE (11)      | (279:289)    |
| **UPDATE_USER**                | VARCHAR(30)    | (290:319)    |


  
  
README.TXT FILES DISK25.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  05:47 PM     5,819,269,592 gs_comment.txt
               1 File(s)  5,819,269,592 bytes
               0 Dir(s)  2,801,908,133,888 bytes free
  
Table Layouts:


GS_COMMENT - 134 Characters                        

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **CASEID**       | VARCHAR(10)    | (11:20)      |
| **TR1_UNIQUEID** | VARCHAR(10)    | (21:30)      |
| **ID1**          | VARCHAR(10)    | (31:40)      |
| **ID2**          | VARCHAR(10)    | (41:50)      |
| **CATEGORY**     | VARCHAR(1)     | (51:51)      |
| **TEXT**         | VARCHAR(1)     | (52:52)      |
| **CREATE_DATE**  | DATE (11)      | (53:63)      |
| **CREATE_USER**  | VARCHAR(30)    | (64:93)      |
| **UPDATE_DATE**  | DATE (11)      | (94:104)     |
| **UPDATE_USER**  | VARCHAR(30)    | (105:134)    |


  
  
README.TXT FILES DISK26.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  05:48 PM         3,890,934 gs_request.txt
07/21/2026  05:42 PM        30,228,445 gs_staff.txt
               2 File(s)     34,119,379 bytes
               0 Dir(s)  2,801,908,133,888 bytes free
  
Table Layouts:

GS_REQUEST - 184 Characters                        

| **Field Name**   | **Field Type** | **Position** |
| ---------------- | -------------- | ------------ |
| **DISTRICT**     | VARCHAR(10)    | (01:10)      |
| **ID**           | VARCHAR(10)    | (11:20)      |
| **CASEID**       | VARCHAR(10)    | (21:30)      |
| **STAFFID**      | VARCHAR(10)    | (31:40)      |
| **REQUEST_DATE** | DATE (11)      | (41:51)      |
| **RECEIVE_DATE** | DATE (11)      | (52:62)      |
| **RETURN_DATE**  | DATE (11)      | (63:73)      |
| **STORE_NUM**    | VARCHAR(20)    | (74:93)      |
| **BOXID**        | VARCHAR(9)     | (94:102)     |
| **CREATE_DATE**  | DATE (11)      | (103:113)    |
| **CREATE_USER**  | VARCHAR(30)    | (114:143)    |
| **UPDATE_DATE**  | DATE (11)      | (144:154)    |
| **UPDATE_USER**  | VARCHAR(30)    | (155:184)    |


GS_STAFF - 479 Characters                        

| **Field Name**     | **Field Type** | **Position** |
| ------------------ | -------------- | ------------ |
| **DISTRICT**       | VARCHAR(3)     | (01:03)      |
| **ID**             | VARCHAR(10)    | (04:13)      |
| **USERNAME**       | VARCHAR(18)    | (14:31)      |
| **INITIALS**       | VARCHAR(8)     | (32:39)      |
| **INIT_STAT**      | VARCHAR(1)     | (40:40)      |
| **STAFF_TITLE**    | VARCHAR(3)     | (41:43)      |
| **SALUTATION**     | VARCHAR(8)     | (44:51)      |
| **LAST_NAME**      | VARCHAR(30)    | (52:81)      |
| **FIRST_NAME**     | VARCHAR(30)    | (82:111)     |
| **OFFICE_LOC**     | VARCHAR(30)    | (112:141)    |
| **PHONE**          | VARCHAR(15)    | (142:156)    |
| **ISSUED_DATE**    | DATE (11)      | (157:167)    |
| **DEFAULT_DIR**    | VARCHAR(40)    | (168:207)    |
| **DEFAULT_PRINT**  | VARCHAR(40)    | (208:247)    |
| **DEFAULT_DC_LOC** | VARCHAR(2)     | (248:249)    |
| **DEFAULT_BRANCH** | VARCHAR(3)     | (250:252)    |
| **NAME_SEARCH**    | VARCHAR(1)     | (253:253)    |
| **STAFF_SEC_TYPE** | VARCHAR(1)     | (254:254)    |
| **STAFF_SECTION**  | VARCHAR(8)     | (255:262)    |
| **CREATE_DATE**    | DATE (11)      | (263:273)    |
| **CREATE_USER**    | VARCHAR(30)    | (274:303)    |
| **UPDATE_DATE**    | DATE (11)      | (304:314)    |
| **UPDATE_USER**    | VARCHAR(30)    | (315:344)    |
| **AD_USERNAME**    | VARCHAR(30)    | (345:374)    |
| **LCMS_POSITION**  | VARCHAR(25)    | (375:399)    |
| **CASE_TYPE**      | VARCHAR(10)    | (400:409)    |
| **ACTION_STAGE**   | VARCHAR(10)    | (410:419)    |
| **DR_USERNAME**    | VARCHAR(30)    | (420:449)    |
| **GUID**           | VARCHAR(30)    | (450:479)    |

  
  
README.TXT FILES DISK27.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  06:18 PM           495,037 JUNFY2026_code_base.sql
07/21/2026  06:18 PM            15,646 JUNFY2026_compare_file_sizes.log
07/21/2026  06:18 PM            33,847 JUNFY2026_detailed_log.log
07/21/2026  06:20 PM            47,950 JUNFY2026_nl_monthly_counts.log
07/21/2026  06:19 PM        17,972,548 JUNFY2026_nl_redacted_cases_log.log
07/21/2026  06:19 PM       261,847,739 JUNFY2026_nl_redacted_participants_log.log
               6 File(s)    280,412,767 bytes
               0 Dir(s)  2,801,908,129,792 bytes free
  
  
README.TXT FILES DISK28.ZIP 
This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary). 
  
File Listing:
  
07/21/2026  06:20 PM         1,617,722 global_LIONS.txt
07/21/2026  05:21 PM           320,111 table_gs_action.txt
07/21/2026  05:22 PM         1,604,819 table_gs_agency_off.txt
07/21/2026  05:22 PM            71,329 table_gs_business_type.txt
07/21/2026  05:22 PM           516,172 table_gs_case_type.txt
07/21/2026  05:22 PM            73,843 table_gs_case_weight.txt
07/21/2026  05:21 PM           134,888 table_gs_counsel_type.txt
07/21/2026  05:21 PM            95,210 table_gs_court_loc.txt
07/21/2026  05:21 PM         1,585,369 table_gs_custody_loc.txt
07/21/2026  05:21 PM           143,108 table_gs_deten_reason.txt
07/21/2026  05:21 PM         5,595,388 table_gs_event_type.txt
07/21/2026  05:21 PM            40,732 table_gs_evid_disp.txt
07/21/2026  05:21 PM            22,036 table_gs_evid_location.txt
07/21/2026  05:21 PM            14,203 table_gs_evid_type.txt
07/21/2026  05:21 PM           613,621 table_gs_expert.txt
07/21/2026  05:21 PM           181,440 table_gs_expert_type.txt
07/21/2026  05:21 PM           246,855 table_gs_immig_stat.txt
07/21/2026  05:21 PM           409,361 table_gs_job_position.txt
07/21/2026  05:21 PM         1,909,417 table_gs_judge.txt
07/21/2026  05:21 PM            27,654 table_gs_judge_type.txt
07/21/2026  05:22 PM             1,900 table_gs_lit_track.txt
07/21/2026  05:21 PM            73,692 table_gs_location.txt
07/21/2026  05:21 PM       137,149,144 table_gs_oppose_attorn.txt
07/21/2026  05:21 PM           105,648 table_gs_position.txt
07/21/2026  05:21 PM           345,410 table_gs_prop_type.txt
07/21/2026  05:21 PM            78,939 table_gs_prop_value_type.txt
07/21/2026  05:21 PM           238,879 table_gs_relate_case_reason.txt
07/21/2026  05:21 PM           210,159 table_gs_relate_part_reason.txt
07/21/2026  05:22 PM            86,551 table_gs_reservation.txt
07/21/2026  05:21 PM            57,653 table_gs_security.txt
07/21/2026  05:21 PM           157,668 table_gs_staff_section.txt
07/21/2026  05:21 PM           371,918 table_gs_staff_title.txt
07/21/2026  05:21 PM           158,294 table_gs_unit.txt
              33 File(s)    154,259,133 bytes
               0 Dir(s)  2,801,908,129,792 bytes free
  
