RX_CUSTOMERS_ARCHIVE

Field Name

Description

ACCOUNT

The customer's account number.

ACCOUNT_TYPE

Indicates the type of account. Uses the Account_type domain.

METER

The customer's meter number.

FIRSTNAME

The customer's first name.

LASTNAME

The customer's last name.

STREET

The customer's street address.

CITY

The customer's city.

STATE

The customer's state.

POSTAL_CODE

The customer's zip code.

COUNTY

The customer's county.

TELEPHONE

The customer's telephone number.

TELEPHONE2

An alternate telephone number for the customer.

TELEPHONE3

An alternate telephone number for the customer.

TELEPHONE4

An alternate telephone number for the customer.

CALLBACK_NUMBER

Preferred number for contacting the customer.

DEVICE_OID

The object ID of the device to which the customer is associated (e.g., service point or transformer). This field links to the OID field in your geodatabase.

DEVICE_FCID

The feature class ID of the device to which the customer is associated (e.g., service point or transformer). This field utilizes the DEVICE_FCID domain.

REGION

The region in which the customer is located. This field uses the REGION domain.

CONNECT_STATUS

Indicates the status of the user's connection (connected/disconnected). This field uses the CONNECT_STATUS domain.

TIME_DISCONNECT

Indicates the time the customer was disconnected.

TIME_RECONNECT

Indicates the time the customer's power was reconnected.

CRITICAL

Indicates if the customer site is critical. This field uses the CRITICAL_TYPE domain.

PRIORITY

Indicates if the customer site is priority. This field uses the PRIORITY domain.

USER_CREATED

The name of the user who created the record. This field is populated automatically by Responder.

USER_UPDATED

The name of the user who updated the record. This field is populated automatically by Responder.

USER_UPDATED_ARCH

This field is not currently used by Responder. You may customize Responder to populate this field with the name of the user who updated the record.

FEATURE_CLASS_NAME

The name of the Feature Class on which the incident occurred, as it was configured/named when the Incident was archived.

CHANGE_DATE

The time and date an operation was performed on the record.

OPERATION

The operation (e.g., insert, delete, update) performed on the record.

QR code for this page

Was this helpful?