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