Laserfiche WebLink
Table 2 Field information for cntrltbl.dbf. <br />cntrltbl.dbf <br />Field Names <br />Field <br />Type <br />Field <br />Width <br />Decimal <br />Precision <br />Field <br />Definition <br />FIELDNAME <br />C <br />10 <br />N/A <br />Name of a field found in Historical Data Table. <br />STRUCTNAME <br />C <br />38 <br />N/A <br />Full structure name corresponding to FIELDNAME. <br />STRUCCODE <br />C <br />7 <br />N/A <br />Structure code resembling STRUCTNAME. <br />STRUCTYPE <br />C <br />9 <br />N/A <br />Structure type (i.e. diversion, inflow, or gauge). <br />QUARTER <br />C <br />3 <br />N/A <br />' /a- section location of structure (NE, SE, SW, NW). <br />SECTION <br />C <br />3 <br />N/A <br />Section number (1 -36). <br />TWN <br />C <br />3 <br />N/A <br />Township. <br />RANGE <br />C <br />3 <br />N/A <br />Range. <br />RIVERMILE <br />C <br />5 <br />N/A <br />River mile location of structure with respect to Kersey 0.0. <br />FLDTYPE <br />C <br />9 <br />N/A <br />FIELDNAME type (logical, character, date, numerical). <br />FLDLOCAL <br />C <br />12 <br />N/A <br />Name of the table in which FIELDNAME is located. <br />UTILIZE <br />L <br />1 <br />N/A <br />True/False flag signify utilization of FIELDNAME. <br />DEFINITION <br />C <br />60 <br />N/A <br />Brief description of FIELDNAME. <br />As discussed above, the characters comprising the FIELDNAME fields define the name of all <br />fields found in each of the Historical Data Tables. The majority of the defined field names <br />correspond to a particular river structure. To enable a user to distinguish river structure <br />information directly from the FIELDNAME field, code letters have been incorporated within. <br />This codification process was also necessary since FoxPro field names are limited to 10 <br />characters. Figure 5 illustrates the FIELDNAME codes and how such codes are to be <br />deciphered. <br />Character Postion <br />00oao0E <br />FY-.Tr.-,T iyw-M.M <br />8 9 10 <br />a 0 I _ rnflow <br />It O: Total Outflow <br />Information e G = Gauge <br />R = Remark <br />D Drying Point <br />V : Rive Water <br />S Reservoir Water <br />Information Source C - oomm - <br />dbf <br />D a histdiv.dbf <br />G - histg —a. dbf <br />Structure Type I - a Inflow <br />D Diversion <br />Cr s Gauge <br />Seven character STRUCCODE <br />Resembles key characters in <br />full structure + <br />Figure 5 - Code letters used in FIELDNAME field of cntrltbl.dbf. <br />15 ptflguid.wpd <br />