This file contains a listing of the files in this ZIP file, followed by file layouts (if necessary).

File Listing:

10/10/2017 02:29 PM           882,610,362 gs_part_relief.txt
10/10/2017 03:14 PM           766,101,645 gs_relief.txt
10/10/2017 03:18 PM           326,576,630 gs_triggerlock.txt

3 File(s) 1,975,288,637 bytes


Table Layouts:

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)

