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

Directory Listing:

11/18/2009  03:54 PM               562 gs_court_order_disp.txt
11/18/2009  03:58 PM       231,494,816 gs_defend_stat.txt
11/18/2009  06:00 PM       294,721,917 gs_instrument.txt
11/18/2009  08:29 PM       414,034,160 gs_participant_AZ.txt
11/18/2009  09:08 PM       241,231,280 gs_participant_ILN.txt
11/18/2009  09:45 PM       310,870,720 gs_participant_NYE.txt
11/18/2009  10:36 PM       311,020,360 gs_participant_VAE.txt
11/18/2009  10:40 PM       142,986,240 gs_participant_WAW.txt
11/18/2009  10:42 PM        73,898,960 gs_participant_WIW.txt
11/18/2009  06:50 PM     1,223,076,740 gs_part_court.txt
11/18/2009  08:14 PM       557,942,760 gs_part_relief.txt
11/18/2009  10:56 PM       497,499,680 gs_relief.txt
11/18/2009  11:06 PM       504,708,042 gs_sentence.txt
11/18/2009  11:09 PM       191,241,790 gs_triggerlock.txt
              14 File(s)  4,994,728,027 bytes

File Layouts:

GS_COURT_ORDER_DISP - 280 Characters			

Name		Null?		Type		Position
DISTRICT	NOT NULL	VARCHAR2(3)	(1:3) 
ID		NOT NULL	VARCHAR2(10)	(4:13)
CASEID		NOT NULL	VARCHAR2(10)	(14:23) 
CRTHISID	NOT NULL	NUMBER(10)	(24:33)
PARTID		NOT NULL	NUMBER(10)	(34:43)
CODE				VARCHAR2(4)	(44:47)
SYSTEM_DATE			DATE		(48:58)
DATE_OF_ORDER			DATE		(59:69)
LAST_NAME			VARCHAR2(60)	(70:129)
FIRST_NAME			VARCHAR2(30)	(130:159)
COURT				VARCHAR2(4)	(160:163)
COURT_NUMBER			VARCHAR2(25)	(164:188)
PARTID2				NUMBER(10)	(189:198)
CREATE_DATE                   	DATE           	(199:209)
CREATE_USER                   	VARCHAR2(30)   	(210:239)
UPDATE_DATE                   	DATE           	(240:250)
UPDATE_USER                   	VARCHAR2(30)   	(251:280)


GS_DEFEND_STAT - 195 Characters			

Name		Null?		Type		Position
DISTRICT	NOT NULL	VARCHAR2(10)	(1:10)
CASEID		NOT NULL	VARCHAR2(10)	(11:20)
PARTID		NOT NULL	NUMBER(10)	(21:30)
ID		NOT NULL	NUMBER(10)	(31:40)
TYPE		NOT NULL	VARCHAR2(2)	(41:42)
START_DATE	NOT NULL	DATE		(43:53)
CUSTODY_LOC			VARCHAR2(2)	(54:55)
DETEN_REASON			VARCHAR2(4)	(56:59)
BOND_TYPE			VARCHAR2(2)	(60:61)
BOND_AMOUNT			NUMBER(12,2)	(62:75)
BOND_PROVIDER			VARCHAR2(25)	(76:100)
TERM_REASON			VARCHAR2(2)	(101:102)
END_DATE			DATE		(103:113)
CREATE_DATE                   	DATE           	(114:124)
CREATE_USER                   	VARCHAR2(30)   	(125:154)
UPDATE_DATE                   	DATE           	(155:165)
UPDATE_USER                   	VARCHAR2(30)   	(166:195)


GS_INSTRUMENT - 146 Characters			

Name		Null?		Type		Position
DISTRICT	NOT NULL	VARCHAR2(10)	(1:10)
CASEID		NOT NULL	VARCHAR2(10)	(11:20)
CRTHISID	NOT NULL	NUMBER(10)	(21:30)
ID		NOT NULL	NUMBER(10)	(31:40)
TYPE		NOT NULL	VARCHAR2(2)	(41:42)
FILING_DATE	NOT NULL	DATE		(43:53)
SYS_FILING_DATE			DATE		(54:64)
CREATE_DATE                   	DATE           	(65:75)
CREATE_USER                   	VARCHAR2(30)   	(76:105)
UPDATE_DATE                   	DATE           	(106:116)
UPDATE_USER                   	VARCHAR2(30)   	(117:146)


GS_PARTICIPANT - 1159 Characters			

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


GS_PART_COURT - 163 Characters			

Name		Null?		Type		Position
DISTRICT	NOT NULL	VARCHAR2(10)	(1:10)
CASEID		NOT NULL	VARCHAR2(10)	(11:20)
PARTID		NOT NULL	NUMBER(10)	(21:30)
CRTHISID	NOT NULL	NUMBER(10)	(31:40)
APPEAL_ROLE			VARCHAR2(2)	(41:42)
DISPOSITION			VARCHAR2(2)	(43:44)
DISP_REASON			VARCHAR2(4)	(45:48)
DISP_DATE			DATE		(49:59)
SYS_DISP_DATE			DATE		(60:70)
SYS_INIT_DATE	NOT NULL	DATE		(71:81)
CREATE_DATE                   	DATE           	(82:92)
CREATE_USER                   	VARCHAR2(30)   	(93:122)
UPDATE_DATE                   	DATE           	(123:133)
UPDATE_USER                   	VARCHAR2(30)   	(134:163)


GS_PART_RELIEF - 122 Characters			

Name		Null?		Type		Position
DISTRICT	NOT NULL	VARCHAR2(10)	(1:10)
CASEID		NOT NULL	VARCHAR2(10)	(11:20)
PARTID		NOT NULL	NUMBER(10)	(21:30)
RELIEFID	NOT NULL	NUMBER(10)	(31:40)
CREATE_DATE                   	DATE           	(41:51)
CREATE_USER                   	VARCHAR2(30)   	(52:81)
UPDATE_DATE                   	DATE           	(82:92)
UPDATE_USER                   	VARCHAR2(30)   	(93:122)


GS_RELIEF - 166 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)
STAGE		NOT NULL	VARCHAR2(1)	(32:32)
REQUESTED_BY	NOT NULL	VARCHAR2(1)	(33:33)
LIABILITY			VARCHAR2(1)	(34:34)
AMOUNT				NUMBER(14,2)	(35:50)
NONMONETARY			VARCHAR2(30)	(51:80)
AGENCY		NOT NULL	VARCHAR2(4)	(81:84)
CREATE_DATE                   	DATE           	(85:95)
CREATE_USER                   	VARCHAR2(30)   	(96:125)
UPDATE_DATE                   	DATE           	(126:136)
UPDATE_USER                   	VARCHAR2(30)   	(137:166)


GS_SENTENCE - 357 Characters			

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


GS_TRIGGERLOCK - 309 Characters			

Name		Null?		Type		Position
DISTRICT	NOT NULL	VARCHAR2(10)	(1:10)
CASEID		NOT NULL	VARCHAR2(10)	(11:20)
PARTID		NOT NULL	NUMBER(10)	(21:30)
BRADY_OFFENSE			VARCHAR2(1)	(31:31)
NOTICE_3_STRIKES		VARCHAR2(1)	(32:32)
DATE_NOTICE_FILED		DATE		(33:43)
DATE_NOTICE_WITHDRAWN		DATE		(44:54)
WITHDRAWAL_REASON		VARCHAR2(78)	(55:132)
CONVICTION_3_STRIKES		VARCHAR2(1)	(133:133)
LIFE_3_STRIKES			VARCHAR2(1)	(134:134)
NO_LIFE_REASON			VARCHAR2(78)	(135:212)
THIRD_PROSEC_TRIGG_OFFENSE	VARCHAR2(1)	(213:213)
TRIGGERLOCK_DEF			VARCHAR2(1)	(214:214)
BAILEY_SENTENCE_CHANGE		VARCHAR2(1)	(215:215)
SENTENCE_PRIOR_BAILEY		NUMBER(11)	(216:226)
ARMED_CAREER_CRIMINAL		VARCHAR2(1)	(227:227)
CREATE_DATE                   	DATE           	(228:238)
CREATE_USER                   	VARCHAR2(30)   	(239:268)
UPDATE_DATE                   	DATE           	(269:279)
UPDATE_USER                   	VARCHAR2(30)   	(280:309)





