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

File Listing:

10/11/2015 12:44 AM         3,432,972,250 gs_comment.txt
10/11/2015 04:04 AM             2,032,595 gs_request.txt
10/11/2015 04:10 AM            20,218,560 gs_staff.txt

3 File(s) 3,455,223,405 bytes


Table Layouts:

GS_COMMENT - 124 Characters                        

Name          Null?      Type           Position
DISTRICT      NOT NULL   VARCHAR2(10)   (1:10)
CASEID        NOT NULL   VARCHAR2(10)   (11:20)
ID1           NOT NULL   NUMBER(10)     (21:30)
ID2           NOT NULL   NUMBER(10)     (31:40)
CATEGORY      NOT NULL   VARCHAR2(1)    (41:41)
TEXT          NOT NULL   VARCHAR2(1)    (42:42)
CREATE_DATE              DATE           (43:53)
CREATE_USER              VARCHAR2(30)   (54:83)
UPDATE_DATE              DATE           (84:94)
UPDATE_USER              VARCHAR2(30)   (95:124)


GS_REQUEST - 184 Characters                        

Name           Null?      Type           Position
DISTRICT       NOT NULL   VARCHAR2(10)   (1:10)
ID             NOT NULL   NUMBER(10)     (11:20)
CASEID                    VARCHAR2(10)   (21:30)
STAFFID        NOT NULL   NUMBER(10)     (31:40)
REQUEST_DATE   NOT NULL   DATE           (41:51)
RECEIVE_DATE              DATE           (52:62)
RETURN_DATE               DATE           (63:73)
STORE_NUM                 VARCHAR2(20)   (74:93)
BOXID                     VARCHAR2(9)    (94:102)
CREATE_DATE               DATE           (103:113)
CREATE_USER               VARCHAR2(30)   (114:143)
UPDATE_DATE               DATE           (144:154)
UPDATE_USER               VARCHAR2(30)   (155:184)


GS_STAFF - 479 Characters                        

Name             Null?      Type           Position
DISTRICT         NOT NULL   VARCHAR2(3)    (1:3)
ID               NOT NULL   NUMBER(10)     (4:13)
USERNAME         NOT NULL   VARCHAR2(18)   (14:31)
INITIALS         NOT NULL   VARCHAR2(8)    (32:39)
INIT_STAT        NOT NULL   VARCHAR2(1)    (40:40)
STAFF_TITLE                 VARCHAR2(3)    (41:43)
SALUTATION                  VARCHAR2(8)    (44:51)
LAST_NAME        NOT NULL   VARCHAR2(30)   (52:81)
FIRST_NAME                  VARCHAR2(30)   (82:111)
OFFICE_LOC                  VARCHAR2(30)   (112:141)
PHONE                       VARCHAR2(15)   (142:156)
ISSUED_DATE      NOT NULL   DATE           (157:167)
DEFAULT_DIR                 VARCHAR2(40)   (168:207)
DEFAULT_PRINT               VARCHAR2(40)   (208:247)
DEFAULT_DC_LOC              VARCHAR2(2)    (248:249)
DEFAULT_BRANCH   NOT NULL   VARCHAR2(3)    (250:252)
NAME_SEARCH                 VARCHAR2(1)    (253:253)
STAFF_SEC_TYPE   NOT NULL   VARCHAR2(1)    (254:254)
STAFF_SECTION               VARCHAR2(8)    (255:262)
CREATE_DATE                 DATE           (263:273)
CREATE_USER                 VARCHAR2(30)   (274:303)
UPDATE_DATE                 DATE           (304:314)
UPDATE_USER                 VARCHAR2(30)   (315:344)
AD_USERNAME                 VARCHAR2(30)   (345:374)
LCMS_POSITION               VARCHAR2(25)   (375:399)
CASE_TYPE                   VARCHAR2(10)   (400:409)
ACTION_STAGE                VARCHAR2(10)   (410:419)
DR_USERNAME                 VARCHAR2(30)   (420:449)
GUID                        VARCHAR2(30)   (450:479)
