This file contains the directory listing of the data files on this DVD, followed by the file layouts.

Directory Listing:

11/13/2007  09:04 PM        72,561,513 gs_participant_MSS.txt
11/13/2007  09:06 PM        67,489,729 gs_participant_NCE.txt
11/13/2007  09:07 PM        73,348,474 gs_participant_NCW.txt
11/13/2007  09:08 PM        35,087,566 gs_participant_ND.txt
11/13/2007  09:08 PM        60,767,529 gs_participant_NE.txt
11/13/2007  09:09 PM        27,380,216 gs_participant_NH.txt
11/13/2007  09:12 PM       220,034,991 gs_participant_NJ.txt
11/13/2007  09:13 PM       140,278,406 gs_participant_NM.txt
11/13/2007  09:14 PM        86,580,777 gs_participant_NV.txt
11/13/2007  09:18 PM       279,700,311 gs_participant_NYE.txt
11/13/2007  09:19 PM        93,506,961 gs_participant_NYN.txt
11/13/2007  09:22 PM       254,589,417 gs_participant_NYS.txt
11/13/2007  09:24 PM       112,460,088 gs_participant_NYW.txt
11/13/2007  09:26 PM       181,148,223 gs_participant_OHN.txt
11/13/2007  09:28 PM       143,248,923 gs_participant_OHS.txt
11/13/2007  09:28 PM        23,594,922 gs_participant_OKE.txt
11/13/2007  09:28 PM        45,053,807 gs_participant_OKN.txt
11/13/2007  09:29 PM        67,970,714 gs_participant_OKW.txt
11/13/2007  09:30 PM        96,054,443 gs_participant_OR.txt
11/13/2007  09:32 PM       127,768,160 gs_participant_PAE.txt
11/13/2007  09:33 PM        77,746,879 gs_participant_PAM.txt
11/13/2007  09:34 PM        89,918,697 gs_participant_PAW.txt
11/13/2007  09:35 PM        87,626,195 gs_participant_PR.txt
11/13/2007  09:35 PM        20,772,757 gs_participant_RI.txt
11/13/2007  09:38 PM       177,499,691 gs_participant_SC.txt
11/13/2007  09:38 PM        68,109,794 gs_participant_SD.txt
11/13/2007  09:39 PM        78,532,681 gs_participant_TNE.txt
11/13/2007  09:40 PM        41,333,417 gs_participant_TNM.txt
11/13/2007  09:41 PM        85,757,887 gs_participant_TNW.txt
11/13/2007  09:42 PM       102,396,491 gs_participant_TXE.txt
11/13/2007  09:44 PM       174,222,039 gs_participant_TXN.txt
11/13/2007  09:50 PM       414,606,752 gs_participant_TXS.txt
11/13/2007  09:54 PM       326,430,032 gs_participant_TXW.txt
11/13/2007  09:54 PM        62,835,185 gs_participant_UT.txt
11/13/2007  09:58 PM       267,653,665 gs_participant_VAE.txt
11/13/2007  09:58 PM        64,468,216 gs_participant_VAW.txt
11/13/2007  09:59 PM        21,228,244 gs_participant_VI.txt
11/13/2007  09:59 PM        23,853,379 gs_participant_VT.txt
11/13/2007  10:00 PM        46,256,849 gs_participant_WAE.txt
11/13/2007  10:02 PM        77,385,271 gs_participant_WIE.txt
11/13/2007  10:03 PM        26,252,509 gs_participant_WVN.txt
11/13/2007  10:04 PM        85,664,008 gs_participant_WVS.txt
11/13/2007  10:05 PM        30,317,122 gs_participant_WY.txt
              43 File(s)  4,659,492,930 bytes

File 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 - 1158 Characters			

Name		Null?		Type		Position
DISTRICT	NOT NULL	VARCHAR2(10)	(1:10)
CASEID		NOT NULL	VARCHAR2(10)	(11:20)
ID		NOT NULL	NUMBER(10)	(21:30)
TYPE		NOT NULL	VARCHAR2(1)	(31:31)
ROLE		NOT NULL	VARCHAR2(2)	(32:33)
SECURITY			VARCHAR2(1)	(34:34)
DEFEND_NUM			NUMBER(11)	(35:45)
SALUTATION			VARCHAR2(20)	(46:65)
LAST_NAME	NOT NULL	VARCHAR2(60)	(66:125)
FIRST_NAME			VARCHAR2(30)	(126:155)
TITLE				VARCHAR2(30)	(156:185)
LAST_SOUNDS			VARCHAR2(4)	(186:189)
FIRST_SOUNDS			VARCHAR2(4)	(190:193)
BUSINESS_TYPE			VARCHAR2(2)	(194:195)
EIN				VARCHAR2(20)	(196:215)
PROP_TYPE			VARCHAR2(2)	(216:217)
TOTAL_TRACTS			NUMBER(11)	(218:228)
CATS_ASSET_ID			VARCHAR2(15)	(229:243)
AGENCY				VARCHAR2(4)	(244:247)
AGENCY_NUM			VARCHAR2(30)	(248:277)
JOB_POSITION			VARCHAR2(4)	(278:281)
SSN				VARCHAR2(11)	(282:292)
BIRTH_DATE			DATE		(293:303)
GENDER				VARCHAR2(1)	(304:304)
JUVENILE			VARCHAR2(1)	(305:305)
RACE				VARCHAR2(2)	(306:307)
RACE_DESCRIP			VARCHAR2(30)	(308:337)
IMMIG_STAT			VARCHAR2(1)	(338:338)
COUNTRY				VARCHAR2(2)	(339:340)
TRIBE				VARCHAR2(4)	(341:344)
RESERVATION			VARCHAR2(4)	(345:348)
ARREST_DATE			DATE		(349:359)
PDID				VARCHAR2(12)	(360:371)
FBI_NUMBER			VARCHAR2(15)	(372:386)
CRIM_HIST			VARCHAR2(1)	(387:387)
EST_LOSS			NUMBER(12,2)	(388:401)
ACT_LOSS			NUMBER(12,2)	(402:415)
HOME_ADDRESS1			VARCHAR2(30)	(416:445)
HOME_ADDRESS2			VARCHAR2(30)	(446:475)
HOME_ADDRESS3			VARCHAR2(30)	(476:505)
HOME_CITY			VARCHAR2(20)	(506:525)
HOME_STATE			VARCHAR2(2)	(526:527)
HOME_COUNTY			VARCHAR2(20)	(528:547)
HOME_ZIPCODE			VARCHAR2(10)	(548:557)
HOME_PHONE			VARCHAR2(15)	(558:572)
HOME_FAX			VARCHAR2(15)	(573:587)
OFF_ADDRESS1			VARCHAR2(30)	(588:617)
OFF_ADDRESS2			VARCHAR2(30)	(618:647)
OFF_ADDRESS3			VARCHAR2(30)	(648:677)
OFF_CITY			VARCHAR2(20)	(678:697)
OFF_STATE			VARCHAR2(2)	(698:699)
OFF_COUNTY			VARCHAR2(20)	(700:719)
OFF_ZIPCODE			VARCHAR2(10)	(720:729)
OFF_PHONE			VARCHAR2(15)	(730:744)
OFF_FAX				VARCHAR2(15)	(745:759)
MARSHALS_NUM			VARCHAR2(9)	(760:768)
AGCYOFFID			NUMBER(10)	(769:778)
LOWER_CRT_TRIAL_NBR		VARCHAR2(25)	(779:803)
BUSINESS_CONTACT_LNAME		VARCHAR2(30)	(804:833)
BUSINESS_CONTACT_FNAME		VARCHAR2(30)	(834:863)
COLLECT_IND			VARCHAR2(1)	(864:864)
SYS_INIT_DATE	NOT NULL	DATE		(865:875)
WEIGHT				VARCHAR2(2)	(876:877)
EMPLOYER_NAME			VARCHAR2(40)	(878:917)
EMPLOYER_TYPE			VARCHAR2(3)	(918:920)
EMPLOYER_DESC			VARCHAR2(40)	(921:960)
NPI				VARCHAR2(10)	(961:970)
OCCUPATION			VARCHAR2(3)	(971:973)
OCCUP_DESC			VARCHAR2(60)	(974:1033)
HCARE_BUSN_TYPE			VARCHAR2(3)	(1034:1036)
HCARE_BUSN_DESC			VARCHAR2(40)	(1037:1076)
CREATE_DATE                   	DATE           	(1077:1087)
CREATE_USER                   	VARCHAR2(30)   	(1088:1117)
UPDATE_DATE                   	DATE           	(1118:1128)
UPDATE_USER                   	VARCHAR2(30)   	(1129:1158)



