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

Directory Listing:

10/19/2012  05:47 PM    <DIR>          . 
10/19/2012  05:47 PM    <DIR>          .. 
10/18/2012  09:49 AM     1,262,111,292 gs_assignment.txt 
10/18/2012  11:11 AM     1,400,692,832 gs_part_count.txt 
10/18/2012  11:47 AM       690,600,105 gs_part_relief.txt 
10/18/2012  12:31 PM       594,092,480 gs_relief.txt 
10/18/2012  12:35 PM       238,943,040 gs_triggerlock.txt 
5 File(s)  4,186,439,749 bytes 
2 Dir(s)  70,427,480,064 bytes free 
 
 
File Layouts:

GS_ASSIGNMENT - 155 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)
STAFFID		NOT NULL	NUMBER(10)	(41:50)
POSITION	NOT NULL	VARCHAR2(1)	(51:51)
START_DATE			DATE		(52:62)
END_DATE			DATE		(63:73)
CREATE_DATE                   	DATE           	(74:84)
CREATE_USER                   	VARCHAR2(30)   	(85:114)
UPDATE_DATE                   	DATE           	(115:125)
UPDATE_USER                   	VARCHAR2(30)   	(126:155)


GS_PART_COUNT - 186 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)
INSTID		NOT NULL	NUMBER(10)	(41:50)
CHARGE		NOT NULL	VARCHAR2(25)	(51:75)
CATEGORY	NOT NULL	VARCHAR2(1)	(76:76)
COUNTID		NOT NULL	NUMBER(10)	(77:86)
DISPOSITION			VARCHAR2(2)	(87:88)
DISP_REASON			VARCHAR2(4)	(89:92)
DISP_DATE			DATE		(93:103)
SEALED				VARCHAR2(1)	(104:104)
CREATE_DATE                   	DATE           	(105:115)
CREATE_USER                   	VARCHAR2(30)   	(116:145)
UPDATE_DATE                   	DATE           	(146:156)
UPDATE_USER                   	VARCHAR2(30)   	(157:186)


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_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)