Field Activity Characteristic Upload Staging
You must create a field activity characteristic upload staging record for each characteristic that you would like to link to the field activity. The name of this table is CI_​FA_​STGUP_​CHAR. The following table describes each column on this file.
Column Name
Length
Req'd
Data Type
Comments
FA_​ID
10
Y
A/N
This must correspond with the prime key of the related CI_​FA_​STAGE_​UP record.
CHAR_​TYPE_​CD
8
Y
A/N
This must correspond with a characteristic type that is defined as valid for the field activity type for this field activity.
SEQ_​NUM
3
Y
N
This should be set to 10 unless you have multiple values for a given field activity and characteristic type.
CHAR_​VAL
16
See note
A/N
Populate this field if your characteristic type is predefined.
ADHOC_​CHAR_​VAL
254
See note
A/N
Populate this field if your characteristic type is ad-hoc or file location.
CHAR_​VAL_​FK1 - CHAR_​VAL_​FK5
50 each
See note
A/N
Populate these fields if your characteristic type is foreign key reference. Up to five columns of 50 bytes each are provided to accommodate compound keys.