FA Type information |
All fields in the main FA Type table and the corresponding language table |
FA Type Characteristics |
FA Information |
All fields in the main Field Activity table |
Status description |
Cancellation Reason description |
FA Steps collection |
FA Characteristics. Note the service limits the number of field activity characteristics that it extracts. It only extracts the first 100. |
Appointment information |
SP Type information |
All fields in the main SP Type table and the corresponding language table |
SP Type Characteristics |
SP Information |
All fields in the main Service Point table |
Status description |
Source Status description |
Disconnect Location description |
SP Location description |
Facility Level 1, 2 and 3 descriptions |
SP Operation Area and Description for the FA type's field service class |
SP Multi-Item collection |
SP Equipment collection |
SP Characteristics |
SP Geographic Data |
SP Operation Area collection |
Premise Information |
All fields in the main Premise table |
Premise Type description |
MR Warning description |
MR Instructions description |
Life Support/Sensitive Load flag description |
Alternate Address collection |
Landlord Agreement Description |
Name of Landlord's main person |
Phone Number collection of Landlord's main person |
Premise Characteristics |
Premise Geographic Data |
Meter Information for the meter currently installed at the Service Point (if applicable) |
All fields in the main Meter table |
Meter Type description |
Meter Status description |
Manufacturer description |
Model description |
Meter Id collection |
Meter Characteristics |
Meter Equipment collection |
Meter Configuration Information for the meter currently installed at the Service Point (if applicable) |
All fields in the main Meter Configuration table |
Meter Installation Date/Time |
Calculated High / Low limit for the meter on the FA schedule date |
Item Information for the badged item currently installed at the Service Point (if applicable) |
All fields in the main Item table |
Item Type description |
Item Status description |
Manufacturer description |
Model description |
Item Characteristics |
Item Equipment collection |
SA Information for the first two Service Agreements found for the service point |
SA ID |
CIS Division / SA Type |
Account ID |
SA Status |
Start Date / End Date |
Customer Read Flag |
Rate Schedule |
SA / SP collection |
Customer Information for the account(s) linked to the above service agreements |
All fields in the main Account table |
Person ID of the main person |
Name of the main person |
Person / Business flag for the main person |
Life Support / Sensitive Load flag, flag Description and Description for the main person |
Phone Number collection for main person. Note, this information may be overridden if a phone number is entered on the field activity. |
The following financial information is not extracted if the input Exclude Financial Information is set to Yes. |
Credit Rating Points. Calculated from the Beginning Credit Rating on the Installation Record or the account’s CIS Division and CR_RATING_PTS from CI_ACCT_CR_R_VW |
Cash Only Points. Cash Only Points. Calculated from the Beginning Cash-Only Score on the Installation Record or the account’s CIS Division and CASH_ONLY_PTS from CI_ACCT_CR_R_VW |
Current Amount (calculated from FT information) |
Payoff Amount (calculated from FT information) |
Disputed Amount (calculated from FT information) |
Arrears Information: Disputed Amount, New Charges, 30 days old, 60 days old, 90 days old |
Count of the number of bills generated in the last 6 Months |
For each bill: |
Bill ID |
Bill Date |
Bill Amount |
Meter Read information for the last Bill |
All fields in the main Meter Read table |
Register Read collection |
Count of the number of payments generated in the last 6 Months |
For each payment: |
Payment ID |
Payment Event ID |
Payment Date |
Payment Amount |
Cancel Reason and its Description |