WRDS Library [Home]
Digital Library Publications Videos Card Catalog

APPENDIX B
SYSTEM TABLE STRUCTURE

DATA FILE NAME: SYSTEMS.DBF

51 FIELDS: STARTING IN POSITION 1

 
COL	ITEM NAME		WIDTH	OPUT	TYPE	N.DEC
  1	ID			   7	  7      C	 - 
  8	NAME			  30     30      C       -
 38     ADDR1			  30	 30      C       -
 68     ADDR2                     30     30      C       -
 98     CITY                      15     15      C       -
113     COUNTY                     3      3      C       -
116     STATE			   2      2      C       -
118     ZIP_4			   5      5      C       -
123     PHONE			  12     12      C       -
135     CONTACT			  20     20      C       -
155     SALUTATION                22     22      C       -
177     C_TITLE			  10     10      C       -
187     C_ADDR                    30     30      C       -
217     C_CITY                    15     15      C       -
232     C_STATE                    2      2      C       -
234     C_ZIP                      5      5      C       -
239     C_PHONE                   12     12      C       -
251     UW_UPDATE                  2      2      C       -
253     IND_RESERV                 5      5      C       -
258     PWS_TYPE		   1      1      C       -
259     ACT_FLAG                   1      1      C       -
260     FILTERED                   1      1      C       -
261     SOURCECODE                 1      1      C       -
262     SYS_BEGIN		   5      5      C       -
267     DEACT_DATE                 5      5      C       -
272     D_REASON                   1      1      C       -
272     PCT_SURF                   4      3      B       - 
273     PCT_GRND                   4      3      B       -
281     PCT_P_SURF                 4      3      B       -
285     PCT_P_GRND                 4      3      B       -
289     OWNER_TYPE                 1      1      C       -
290     REG_ENTITY                 1      1      C       -
291     POP_SERVED                 4      7      B       -
395     SERV_CONCT                 4      5      B       -
399     SEASON_BEG                 5      5      C       -
304     SEASON_END                 5      5      C       -
309     REQD                       4      2      B       -
313     COMP_CYCLE                 1      1      C       -
314     BACT_LAB                   4      4      C       -
318     LASTUPDATE                 8     10      D       -
326     Q1                         1      1      C       -
327     Q2                         1      1      C       -
328     Q3                         1      1      C       -
329     Q4                         1      1      C       -
330     TAKEN                      4      3      B       -
334     VIO_FLAG                   1      1      C       -
335     ENF_FLAG                   4      4      C       -
339     COMMENTS                  65     65      C       -


96-13 Table of Contents
Water Resources Publications List
Water Resources Data System Library | Water Resources Data System Homepage