The
V1DCHFLF table is used for
ANURDFLF and
ANDCHFLF views. The following table describes the columns in the
V1DCHFLF table:
| Column
|
Type
|
Length
|
Decimal
|
Domain
|
| MCRECID
|
BINARY
|
4
|
0
|
machine/company ID
|
| FILRECID
|
BINARY
|
9
|
0
|
file ID
|
| FLDRECID
|
BINARY
|
9
|
0
|
field ID
|
| FLDDISPL
|
BINARY
|
5
|
0
|
field displacement
|
| FLDNAME
|
CHARACTER
|
128
|
0
|
field name
|
| FLDLEN
|
BINARY
|
5
|
0
|
field length
|
| FLDINT
|
BINARY
|
3
|
0
|
field integer
|
| FLDDEC
|
BINARY
|
3
|
0
|
field decimal
|
| FLDSIGN
|
CHARACTER
|
1
|
0
|
field sign
|
| FLDTYPE
|
CHARACTER
|
1
|
0
|
field type:
- F = floating-point field
- 1 = bit field
- B = binary field
- N = decimal field
- P = packed-decimal field
- A = alphanumeric field
- E = edited field
|
| TYPNAME
|
CHARACTER
|
128
|
0
|
ODBC Data Type Name
|
| TYPNUM
|
DECIMAL
|
5
|
0
|
ODBC Data Type Number
|
| FLDNAT
|
CHARACTER
|
1
|
0
|
field nature
|
| FLJUSTIFY
|
CHARACTER
|
1
|
0
|
justify flag
|
| CLATYPE
|
BINARY
|
3
|
0
|
field class
|
| INFOPROV
|
CHARACTER
|
3
|
0
|
information origin
|
| MINVAL
|
CHARACTER
|
33
|
0
|
minimum value
|
| MAXVAL
|
CHARACTER
|
33
|
0
|
maximum value
|
| AVGVAL
|
DECIMAL
|
18
|
0
|
average value
|
| SPEDIFVAL
|
BINARY
|
5
|
0
|
number of different values
|
| USERPGM
|
CHARACTER
|
10
|
0
|
user program
|
| HASSPE
|
CHARACTER
|
1
|
0
|
spectrum presence flag
|
| FLSPE
|
CHARACTER
|
1
|
0
|
spectrum calculation flag
|
| LOGMON
|
CHARACTER
|
1
|
0
|
logging enabled
|
| DCMON
|
CHARACTER
|
1
|
0
|
data corruption enabled
|
| LOGALARM
|
CHARACTER
|
1
|
0
|
logging alarm
|
| DCALARM
|
CHARACTER
|
1
|
0
|
data corruption alarm
|
| NULLCAP
|
CHARACTER
|
1
|
0
|
null capable field
|
| VARLEN
|
CHARACTER
|
1
|
0
|
field with variable length
|
| ISANAG
|
CHARACTER
|
1
|
0
|
demographic field
|
| ESTCARD
|
BINARY
|
9
|
0
|
estimated cardinality
|
| ESTCLA
|
BINARY
|
3
|
0
|
estimated class
|
| SAMPVAL
|
CHARACTER
|
33
|
0
|
sample value
|
| SAMPNBR
|
BINARY
|
9
|
0
|
sample OCCURS
|
| FLDTXT
|
CHARACTER
|
50
|
0
|
text
|
| ISKEY
|
CHARACTER
|
1
|
0
|
primary key
|
| FLCLAVAL
|
CHARACTER
|
1
|
0
|
use class value
|
| ANAGPRO
|
CHARACTER
|
3
|
0
|
demographic provider
|
| CHGFLG
|
CHARACTER
|
1
|
0
|
Data Changer active
|
| CHGPGM
|
CHARACTER
|
8
|
0
|
Data Changer program
|
| METHOD
|
CHARACTER
|
10
|
0
|
Method
|
