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