Field Activity Remark Upload Staging

You must create a field activity remark upload staging record for each remark that you would like to link to the field activity. The name of this table is CI_​FA_​STGUP_​REM. The following table describes each column on this file.

Column Name

Length

Req'd

Data Type

Comments

FA_​ID

10

Y

A/N

This is the ID of the field activity whose completion details are being supplied.

FA_​REM_​CD

12

Y

A/N

This must correspond with a field activity remark code. Refer to Setting Up Field Activity Remarks for more information.