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. |