Field Activity Upload Staging
You must create a field activity upload staging record for each field activity whose completion details are being uploaded. The name of this table is CI_​FA_​STAGE_​UP. 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_​UP_​STATUS_​FLG
2
Y
A/N
This must be set to P for Pending.
WORK_​DTTM
26
Y
Date/Time
The date and time the work was done.
WORKED_​BY
8
Y
A/N
The unique ID of the representative who performed the activity.
DESCR254
254
N
A/N
Optional comments about the field activity.