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

Directory Listing:

11/28/2011  09:33 PM        30,735,824 gs_event_OKE.txt
11/28/2011  09:34 PM        90,832,756 gs_event_OKN.txt
11/28/2011  09:35 PM        69,113,786 gs_event_OKW.txt
11/28/2011  09:36 PM        77,412,832 gs_event_OR.txt
11/28/2011  09:37 PM       102,685,926 gs_event_PAE.txt
11/28/2011  09:38 PM       125,348,846 gs_event_PAM.txt
11/28/2011  09:40 PM       186,839,982 gs_event_PAW.txt
11/28/2011  09:41 PM        85,847,076 gs_event_PR.txt
11/28/2011  09:42 PM        14,676,494 gs_event_RI.txt
11/28/2011  09:43 PM        88,732,112 gs_event_SC.txt
11/28/2011  09:44 PM       106,057,350 gs_event_SD.txt
11/28/2011  09:45 PM        77,922,362 gs_event_TNE.txt
11/28/2011  09:45 PM        44,069,676 gs_event_TNM.txt
11/28/2011  09:46 PM       100,480,534 gs_event_TNW.txt
11/28/2011  09:48 PM       119,186,984 gs_event_TXE.txt
11/28/2011  09:49 PM       168,414,078 gs_event_TXN.txt
11/28/2011  09:54 PM       463,375,514 gs_event_TXS.txt
11/28/2011  09:57 PM       220,020,738 gs_event_TXW.txt
11/28/2011  09:58 PM       100,897,090 gs_event_UT.txt
11/28/2011  10:00 PM       158,853,184 gs_event_VAE.txt
11/28/2011  10:02 PM        66,160,136 gs_event_VAW.txt
11/28/2011  10:02 PM        40,742,912 gs_event_VI.txt
11/28/2011  10:03 PM        61,011,650 gs_event_VT.txt
11/28/2011  10:04 PM        67,059,832 gs_event_WAE.txt
11/28/2011  10:05 PM        72,157,568 gs_event_WAW.txt
11/28/2011  10:05 PM        41,645,450 gs_event_WIE.txt
11/28/2011  10:06 PM        86,465,008 gs_event_WIW.txt
11/28/2011  10:07 PM        60,619,454 gs_event_WVN.txt
11/28/2011  10:09 PM       125,204,716 gs_event_WVS.txt
11/28/2011  10:09 PM        32,215,288 gs_event_WY.txt
11/28/2011  10:33 PM       231,996,702 gs_oppose_coun.txt
11/29/2011  04:55 AM        33,648,600 gs_restitution.txt
              32 File(s)  3,350,430,460 bytes

File Layouts:

GS_EVENT - 405 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(4)	(41:44)
ACTION				VARCHAR2(2)	(45:46)
EVENT_DATE			DATE		(47:57)
SCHED_DATE			DATE		(58:68)
SCHED_TIME			DATE		(69:79)
SCHED_LOC			VARCHAR2(200)	(80:279)
STAFFID				NUMBER(10)	(280:289)
JUDGEID				NUMBER(10)	(290:299)
DOCUMENT_CODE			VARCHAR2(3)	(300:302)
DOCUMENT_STAFFID		NUMBER(10)	(303:312)
DOCUMENT_DATE			DATE		(313:323)
CREATE_DATE                   	DATE           	(324:334)
CREATE_USER                   	VARCHAR2(30)   	(335:364)
UPDATE_DATE                   	DATE           	(365:375)
UPDATE_USER                   	VARCHAR2(30)   	(376:405)


GS_OPPOSE_COUN - 156 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)
ATTORNEYID	NOT NULL	NUMBER(10)	(41:50)
TYPE				VARCHAR2(2)	(51:52)
START_DATE			DATE		(53:63)
END_DATE			DATE		(64:74)
CREATE_DATE                   	DATE           	(75:85)
CREATE_USER                   	VARCHAR2(30)   	(86:115)
UPDATE_DATE                   	DATE           	(116:126)
UPDATE_USER                   	VARCHAR2(30)   	(127:156)


GS_RESTITUTION - 149 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)
VICTIMID			NUMBER(10)	(41:50)
TYPE		NOT NULL	VARCHAR2(1)	(51:51)
RECIPIENT	NOT NULL	VARCHAR2(1)	(52:52)
AMOUNT		NOT NULL	NUMBER(12,2)	(53:66)
LIABILITY			VARCHAR2(1)	(67:67)
CREATE_DATE                   	DATE           	(68:78)
CREATE_USER                   	VARCHAR2(30)   	(79:108)
UPDATE_DATE                   	DATE           	(109:119)
UPDATE_USER                   	VARCHAR2(30)   	(120:149)















