Field Activity Step Upload Staging
You must create a field activity step upload staging record for each step that was completed. The name of this table is CI_​FA_​STP_​STG_​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.
STEP_​SEQ_​NBR
3
Y
N
This is the sequence number of the field activity step whose completion details are being supplied.
FA_​STP_​UP_​STAT_​FLG
2
Y
A/N
This is the status of the upload record. This must be set to P for Pending.
FA_​STEP_​TY_​ACT_​FLG
2
Y
A/N
This is the type of step whose completion details are being supplied. This must be one of the following values:
NS - Connect Service Point, DS - Disconnect Service Point, IM - Install Meter, NM - Turn On Meter, FM - Turn Off Meter, MR - Read Meter, RM - Remove Meter, II - Install Item, NI - Turn On Item, FI - Turn Off Item, RI - Remove Item
BADGE_​NBR
30
See note
A/N
Badge Number is the badge number of the meter or item involved with the field activity step. It is required for the following step types: Install Meter, Turn On Meter, Turn Off Meter, Read Meter, Remove Meter, Install Item, Turn On Item, Turn Off Item, Remove Item
READ_​DT
10
See note
Date
This must correspond with a read date on one of the meter read upload staging records. It is required for the following step types: Install Meter, Turn On Meter, Turn Off Meter, Read Meter, Remove Meter
READ_​TIME
15
See note
Time
This must correspond with a read time on one of the meter read upload staging records. It is required for the following step types: Install Meter, Turn On Meter, Turn Off Meter, Read Meter, Remove Meter
DISCON_​LOC_​CD
4
See note
A/N
This is the disconnect location code that identifies where a service point has been disconnected. It is required for the Disconnect Service Point step type.
ON_​OFF_​FLG
2
See note
A/N
Set this to 0 if the meter / item was turned off.
Set this to 1 if the meter / item was turned on.
It is required for the following step types: Install Meter, Install Item.
EVENT_​DTTM
26
See note
Date / Time
This the date and time an item was installed, removed, turned on or off. It is required for the following step types: Install Item, Turn On Item, Turn Off Item, Remove Item
STK_​LOC_​CD
12
See note
A/N
This is the stock location where the meter / item is stored upon removal from a service point. This is required for the following step types if the meter's meter type or the item's item type tracks location: Remove Item, Remove Meter. Refer to The Big Picture Of Asset Inventory for more information.