NIPO Fieldwork System Version 1.14
LookupReferences
Links several multiple coded fields with the LookupValues table. For internal use by the NIPO FMS.
LookupReferences table
|
|
Fieldname
|
Description
|
Type
|
Length
|
NOT NULL
|
|
LookupReference
|
Lookup reference
|
int
|
|
NOT NULL
|
|
MultiIndex
|
Multi index
|
int
|
|
NOT NULL
|
|
SourceInt
|
Source integer
|
int
|
|
|
|
SourceInt2
|
Source integer 2
|
int
|
|
|
|
SourceStr
|
Source string
|
varchar
|
50
|
|
|
SourceStr2
|
Source string 2
|
varchar
|
50
|
|
|
|
|
|
|
|
Note: Primary key field MultiIndex is either linked with SourceInt or SourceStr, depending on use.
|
