Field Name | Format | Source/Value/Description |
Print Key | A4 | "0010" |
CIS Sort Key | A187 | Note: For the Global Record only, the Sort Key is all blanks. |
BATCH_CD | A8 | CI_BATCH_INST / The CIS Batch Process that called the FO Extract routine |
BATCH_NBR | N10 | CI_BATCH_INST / A sequence number for serial instances of a Batch Process over time |
BATCH_RERUN_NBR | N10 | CI_BATCH_INST / The number of times a particular batch has been re-run since its initial run |
FO Count [Artificial] | N10 | Total number of distinct FO record blocks in an extract |
Date/Time [Artificial] | A26 | System time of extraction. |
FO Id Start [Artificial] | A10 | The lowest valid FO ID in a particular thread in the extract. If there is only one thread, this will be '0000000000'. |
FO Id End [Artificial] | A10 | The highest valid FO ID in a particular thread in the extract. If there is only on thread, this will be '9999999999'. |
BATCH_THREAD_NBR | N10 | CI_BATCH_THD / Identifies a thread distinctly within a group of threads |
Thread Count [Artificial] | N10 | Total number of threads in the extract run |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "0100" |
CIS Sort Key | A187 | |
FO_ID | A10 | CI_FO_STG_DWN / System-assigned identifier for a Field Order |
PREM_ID | A10 | CI_FO / System-assigned identifier for the Premise at which the Field Order will be done |
SCHED_DT | D10 | CI_FO / The scheduled date of the Field Order |
SCHED_TM | T15 | CI_FO / The scheduled time of the Field Order (optional) |
DISP_GRP_CD | A8 | CI_FO / The Dispatch Group to which the Field Order has been assigned |
REP_CD | A8 | CI_FO / The Representative within the Dispatch Group |
DESCR254 | C254 | CI_FO / Free-form notes about the Field Order |
ACCT_ID | A10 | CI_SA / The Account that is/has been/will be paying for services at the Premise |
ENTITY_NAME | A64 | CI_PER_NAME / The Primary name of the Main customer on the Account identified above |
Multiple Account Message [Artificial] | A10 | A message item indicating the existence of more than one active Account associated with a Premise. |
ADDRESS_SBR | A361 | CI_PREM / A sub-record of address information (Defined in detail later in this section) |
MR_WARN_CD | A4 | CI_PREM / Meter Read Warning code |
DESCRIPTION | A60 | CI_MR_WARN / Description of the MR Warning code |
MR_INSTR_CD | A4 | CI_PREM / Meter Read Instruction code |
DESCRIPTION | A60 | CI_MR_INSTR / Description of the MR Instruction code |
MR_INSTR_DETAILS | A250 | CI_PREM / For an expanded version of the Meter Read Instruction above, or for information deemed relevant but for which no code exists. |
Telephone Info | Telephone numbers for the Main customer on the Account above. Occurs 3 times per FO Record, consisting of the following three fields: | |
PHONE_TYPE | A12 | CI_PER_PHONE / The type of telephone. Typical values are Home, Business, Dormitory, Cellular, Fax. |
PHONE | A24 | CI_PER_PHONE / Self-explanatory |
EXTENSION | A6 | CI_PER_PHONE / Self-explanatory |
LS_SL_SW | A1 | CI_PER / Life Support or Sensitive Load. Set to "Y" if any Person on any active Account associated with this Premise has this type of information on their record. |
LS_SL_DESCR | A254 | CI_PER / Description of the Life Support/Sensitive Load |
LL_ID | A10 | CI_PREM / System-assigned identifier for a Premise's landlord (if one exists) |
DESCRIPTION | A60 | CI_LANDLORD / Description of the Landlord |
ACCT_ID | A10 | CI_LANDLORD / The Landlord's account number |
Geographic Info | Geographic locator types and their values for the Premise. Occurs 3 times per FO Record, consisting of the following two fields: | |
DESCR | A60 | CI_GEO_TYPE / The description of a geographic locator type |
GEO_VAL | A50 | CI_PREM_GEO / The actual value of the above locator type at a given Premise |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "2000" |
CIS Sort Key | A187 | |
SP_ID | A10 | CI_SP / Unique system-generated identifier for the Service Point |
SP_TYPE_CD | A8 | CI_SP / The Service Point's type code |
DESCR | A60 | CI_SP_TYPE / The description of the SP Type |
SP_SUBTYPE_FLG | A2 | CI_SP_TYPE / The SP Type's sub-type code. Values: M - Meter I - Item U - Unbadged (multi-item) |
DESCR | A60 | CI_LOOKUP / The description of the sub-type |
SP_SRC_STATUS_FLG | A2 | CI_SP / The status of the source of the service delivered through a Service Point. |
DESCR | A60 | CI_LOOKUP / The description of the source status |
DISCON_LOC_CD | A4 | CI_SP / If the SP has been disconnected, a code for the location of the disconnection |
DESCR | A60 | CI_LOOKUP / The description of the disconnect location |
MTR_LOC_CD | A4 | CI_SP / A code for the location at the Premise of the Service Point's Meter |
DESCR | A60 | CI_MTR_LOC / The description of the location code |
MTR_LOC_DETAILS | A250 | CI_SP / Detailed information regarding the location of the SP's Meter |
SP_MTR_RD_CYCLE | A30 | CI_MR_CYC / Description of the SP's Service Cycle |
SP_MTR_RD_ROUTE | A30 | CI_MR_RTE / Description of the SP's Service Route |
SP_FAC_LVL_1 | A30 | CI_FAC_LVL_1 / Description of the SP's Level 1 Facility |
SP_FAC_LVL_2 | A30 | CI_FAC_LVL_2 / Description of the SP's Level 2 Facility |
SP_FAC_LVL_3 | A30 | CI_FAC_LVL_3 / Description of the SP's Level 3 Facility |
Geographic Info | Geographic locator types and their values for a Service Point. Occurs 3 times per record, consisting of the following two fields: | |
DESCR | A60 | CI_GEO_TYPE / The description of a geographic locator type |
GEO_VAL | A50 | CI_SP_GEO / The actual value of the above locator type at a given Service Point |
Characteristic Info | Occurs 15 times per record, consisting of the following two fields: | |
SP_CHAR | A30 | CI_CHAR_TYPE / The description of a Characteristic that the Service Point has been deemed to possess |
SP_CHAR_VALUE | A30 | CI_CHAR_VAL / The description of the Value of the above Characteristic for this Service Point |
MR_WARN_CD | C4 | Field Warning code |
DESCRIPTION | C30 | Description of the Field Warning code |
MR_INSTR_CD | C4 | Field Instruction code |
DESCRIPTION | C30 | Description of the Field Instruction code |
MR_INSTR_DETAILS | C250 | For an expanded version of the Field Instruction above, or for information deemed relevant but for which no code exists |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "2200" |
CIS Sort Key | A187 | |
ITEM_ID | A10 | CI_SP_ITEM_HIST / The system-generated ID of the Item currently installed at the Service Point |
BADGE_NBR | A16 | CI_ITEM / The Item's badge number |
ITEM_TYPE_CD | A8 | CI_ITEM / A code specifying the type of the Item |
DESCR | A60 | CI_ITEM_TYPE / The description of the Item type |
MFG_CD | A8 | CI_ITEM / A code for the manufacturer of the Item |
DESCR | A60 | CI_MFG / The actual name of the manufacturer |
MODEL_CD | A8 | CI_ITEM / The manufacturer's model number for the Item |
DESCR | A60 | CI_MODEL / The description of the model |
SERIAL_NBR | A16 | CI_ITEM / Self-explanatory |
RECEIVE_DT | D10 | CI_ITEM / The date on which the Item was received by the utility from its manufacturer. This is NOT the install date. |
DESCR254 | A254 | CI_ITEM / A detailed description of the Item (optional). |
EVENT_DTTM | D26 | CI_SP_ITEM_EV_I / The date and time of the installation of the Item at its current location. |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "2400" |
CIS Sort Key | A187 | |
MTR_ID | A10 | CI_MTR_CONFIG / The system-generated identifier for the Meter currently installed at the Service Point. |
BADGE_NBR | A16 | CI_MTR / The Meter's badge number |
MTR_TYPE_CD | A8 | CI_MTR / A code for the type of the Meter |
MFG_CD | A8 | CI_MTR / A code for the manufacturer of the Meter |
DESCR | A60 | CI_MFG / The actual name of the manufacturer |
MODEL_CD | A8 | CI_MTR / The manufacturer's model number for the Meter |
DESCR | A60 | CI_MODEL / A description of the model |
SERIAL_NBR | A16 | CI_MTR / Self-explanatory |
RECEIVE_DT | D10 | CI_MTR / The date on which the Meter was received by the utility from its manufacturer. This is NOT the install date. |
DESCR254 | A254 | CI_MTR / A detailed description of the Meter (optional). |
INSTALL_DTTM | D26 | CI_CFG_SPMR_VW / The date and time of the installation of the Meter at its current location. |
MTR_CONFIG_ID | A10 | CI_SP_MTR_HIST / The system-generated identifier for the Meter's current Configuration |
EFFDT | D10 | CI_MTR_CONFIG / The effective date of the current Configuration |
EFF_TM | T15 | CI_MTR_CONFIG / The effective time of the current Configuration |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "2450" |
CIS Sort Key | A187 | |
REG_ID | A10 | CI_REG / The system-generated unique identifier for the Register |
READ_SEQ | N2 | CI_REG / The read sequence of the Register |
UOM_CD | A30 | CI_REG / The Unit Of Measure in which the Register is calibrated |
TOU_CD | A30 | CI_REG / The Time Of Use period during which the Register measures consumption |
REG_CONST | N6.6 | CI_REG / The Register Constant (if any) by which the actual reading is multiplied to calculate consumption |
CONSUM_SUB_FLG | A2 | CI_REG / A flag that indicates whether the Register is a consumptive or subtractive register |
HOW_TO_USE_FLG | A2 | CI_REG / A flag that indicates whether the Register's measured consumption is to be added to, subtracted from, or used as a check against the measured consumption of other Registers (if the Register is Subtractive) or measures a peak (maximum) value (if the Register is Consumptive) |
NBR_OF_DGTS_LFT | N1 | CI_REG / The number of digits to the left of the decimal point on the Register's readout |
NBR_OF_DGTS_RGT | N1 | CI_REG / The number of digits to the right of the decimal point on the Register's readout |
FULL_SCALE | N9.5 | CI_REG / The maximum value that can be displayed on the Register's readout before it "turns over" to zero |
READ_OUT_TYPE_CD | A8 | CI_REG / A code indicating the type of physical readout (dials, digital etc.) employed on the Register |
PROTOCOL_CD | A8 | CI_REG / A code indicating the means by which the register's consumption information is collected |
TOLERANCE | N9.5 | CI_REG / Tolerance is used to warn the meter reader that a Register is approaching its maximum permitted value |
READ_DTTM | D26 | CI_MR / The date and time of the most recent Register reading that is either a Customer Read, Regular read or a Verified read |
REG_READING | N9.6 | CI_REG_READ / The actual value displayed on the Register's readout when it was most recently read |
READ_TYPE_FLG | A2 | CI_REG_READ / The type code of the Register reading |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "2490" |
CIS Sort Key | A187 |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "2600" |
CIS Sort Key | A187 | |
EFF_DT | D10 | CI_SP_MULT_ITEM |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "2620" |
CIS Sort Key | A187 | |
ITEM_TYPE_CD | A8 | CI_MULT_ITEM / A code for the type of Item |
DESCR | A60 | CI_ITEM_TYPE / The description of the Item type |
ITEM_CNT | N9.2 | CI_MULT_ITEM / The number of individual Items of a given type |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "2690" |
CIS Sort Key | A187 |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "3000" |
CIS Sort Key | A187 | |
FA_ID | A10 | CI_FA / The unique system-generated identifier for a Field Activity |
FA_TYPE_CD | A8 | CI_FA / A code specifying the Field Activity's type |
DESCR | A60 | CI_FA_TYPE / The description of the FA type |
FA_PRIORITY_FLG | A2 | CI_FA / In the case of several Activities being created for the same SP, the Priority Flag stipulates which should be done first. |
FA_CREATED_BY_FLG | A2 | CI_FA / A code indicating who or what originated this Field Activity |
XLATLONGNAME | A30 | CI_LOOKUP / The description of the Created By flag |
SCHED_DT | D10 | CI_FA / The date on which the Activity is scheduled to be done |
SCHED_TM | T15 | CI_FA / The time at which the Activity is scheduled to commence (optional). |
INSTRUCTIONS | A254 | CI_FA / Free form detailed instructions as to exactly what is to be done. |
DESCR254 | A254 | CI_FA / A more detailed description of the FA Type (optional) |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "3100" |
CIS Sort Key | A187 | |
SA_ID | A10 | CI_SEV_PROC / The Service Agreement for which a Severance Process has issued a Disconnect field activity as a result of a Severance Event |
Overdue Amount [Artificial] | N13.2 | The program calls another routine (ProgramCIPFFTBN) that calculates this amount based on the Severance Process Arrears Date |
Current Amount [Artificial] | N13.2 | The program calls another routine (ProgramCIPFFTBN) that calculates this amount using the current date. |
Past Severance Processes [Artificial] | N3 | The number of Severance Processes issued against this Service Agreement in the past, excluding the one that generated this Activity |
ACCT_ID | A10 | CI_SA / The Account associated with the Service Agreement above |
ENTITY_NAME | A64 | CI_PER_NAME / The Primary name of the Main customer on the Account above |
BILL_DT | D10 | CI_BILL / The date of the most recent bill that is charged to the Account above |
CUR_AMT | N13.2 | The dollar amount of the most recent bill. Calculated from CI_BILL_SA |
PAY_DT | D10 | CI_PAY_EVENT / The date of the most recent Frozen payment on the Account of the SA above |
PAY_AMT | N13.2 | CI_PAY / The amount of the most recent Frozen payment on the Account of the SA above |
Credit Rating [Artificial] | N5 | Calculated from the Beginning Credit Rating Base on the Installation record or the account’s CIS Division, and CR_RATING_PTS from CI_ACCT_CR_R_VW |
Cash-only Switch [Artificial] | A1 | Set to "Y" if the Cash-Only score is above the Cash Only Threshold as defined on the Installation record. Calculated from the Cash Only Base Score on the Installation record or the account’s CIS Division, and CASH_ONLY_PTS from CI_ACCT_CR_R_VW |
Deposit Amount [Artificial] | N13.2 | The program calls another routine (ProgramCIPDFDVN) to calculate this amount |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "3200" |
CIS Sort Key | A187 | |
STEP_SEQ_NBR | N3 | CI_FA_STEP / The sequence of a Step within a Field Activity |
FA_STEP_TY_ACT_FLG | A2 | CI_FA_STEP / A code indicating the FA Step Type Action. |
XLATLONGNAME | A60 | CI_LOOKUP / The description of the FA Step Type Action. |
FA_STEP_DESCR | A60 | CI_FA_STEP_TYPE / Description of the FA Step Type. |
OPTIONAL_SW | A1 | CI_FA_STEP_TYPE / "Y" indicates that a particular Step is regarded as optional for field activities of this FA Type |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "3410" |
CIS Sort Key | A187 |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "3430" |
CIS Sort Key | A187 |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "3450" |
CIS Sort Key | A187 |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "3470" |
CIS Sort Key | A187 |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "3490" |
CIS Sort Key | A187 |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "3510" |
CIS Sort Key | A187 |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "3530" |
CIS Sort Key | A187 |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "3550" |
CIS Sort Key | A187 |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "3570" |
CIS Sort Key | A187 |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "3999" |
CIS Sort Key | A187 |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "6100" |
CIS Sort Key | A187 |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "6200" |
CIS Sort Key | A187 |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "6300" |
CIS Sort Key | A187 |
Field Name | Format | Source/Value/Description |
Print Key | A4 | "9990" |
CIS Sort Key | A187 |
Field Name | Format | Description |
COUNTRY | A3 | |
ADDRESS1 | A64 | |
ADDRESS2 | A64 | |
ADDRESS3 | A64 | |
ADDRESS4 | A64 | |
CITY | A30 | |
NUM1 | A6 | |
NUM2 | A4 | |
HOUSE_TYPE | A2 | |
COUNTY | A30 | |
STATE | A6 | |
POSTAL | A12 | |
GEO_CODE | A11 | |
IN_CITY_LIMIT | A1 |