FACOMPL - Upload and Complete Field Activities
FACOMPL processes Pending Field Activity Upload Staging records. For each such record, it processes the Pending Field Activity Step Upload Staging records as per the following table.
Step Type
What Happens
NS - Connect Service Point
Changes the connection status of the field activity's service point to connected and removes the disconnect location (if any). It then updates the related step to reference the service point.
DS - Disconnect Service Point
Changes the connection status of the field activity's service point to disconnected and populates the disconnect location with the supplied value. It then updates the related step to reference the service point.
IM - Install Meter
Creates a new SP / Meter record and links to it the meter read inferred from the badge number and read date/ time. Note: the meter read upload process creates this meter read. It then updates the related step to reference the SP / Meter record.
NM - Turn On Meter
Creates a new turn on event under an exist SP / Meter record. It links the meter read inferred from the badge number and read date/ time to the turn on event. Note: the meter read upload process creates this meter read. It then updates the related step to reference the SP / Meter record.
FM - Turn Off Meter
Creates a new turn off event under an exist SP / Meter record. It links the meter read inferred from the badge number and read date/ time to the turn off event. Note: the meter read upload process creates this meter read. It then updates the related step to reference the SP / Meter record.
MR - Read Meter
It's important to note that the meter read upload process creates this meter read. When this type of step is uploaded, the system simply updates the related step to reference the previously created meter read.
RM - Remove Meter
Updates an existing SP / Meter record to indicate the meter has been removed. It does this by linking the meter read inferred from the badge number and read date/ time. Note: the meter read upload process creates this meter read. It then updates the related step to reference the SP / Meter record.
II - Install Item
Creates a new SP / Item record using the supplied badge number and event date and time. It then updates the related step to reference the SP / Item record.
NI - Turn On Item
Creates a new turn on event under an exist SP / Item record. It then updates the related step to reference the SP / Item record.
FI - Turn Off Item
Creates a new turn off event under an exist SP / Item record. It then updates the related step to reference the SP / Item record.
RI - Remove Item
Updates an existing SP / Item record to indicate the item has been removed. It then updates the related step to reference the SP / Item record.
After this process updates the related step, it checks if all required steps under the parent field activity reference their appropriate foreign key. If so, it completes the field activity. It then checks if all field activities under the parent field order are complete, if so it completes the field order (note, it will also update the field order with the work done date / time and worked by information on the related Field Activity Upload Staging record).
Any errors detected during this process are written to the Field Activity Upload Exception table. You can fix errors using Field Activity Staging page (don't forget to change the record's status back to Pending ).