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