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

Directory Listing:


11/18/2009  06:25 PM     1,128,792,588 gs_part_count.txt
11/18/2009  08:04 PM     3,962,009,222 gs_part_event.txt
11/18/2009  10:56 PM         1,200,465 gs_request.txt
11/18/2009  11:06 PM        16,278,720 gs_staff.txt
               4 File(s)  5,108,280,995 bytes


File Layouts:

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_EVENT - 132 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)
EVENTID		NOT NULL	NUMBER(10)	(41:50)
CREATE_DATE                   	DATE           	(51:61)
CREATE_USER                   	VARCHAR2(30)   	(62:91)
UPDATE_DATE                   	DATE           	(92:102)
UPDATE_USER                   	VARCHAR2(30)   	(103:132)


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)




