Quote Information

Global Extract Information (0010) Record Definition

This is a "header" record that contains information about the extract run as a whole.

Note:

Please be aware that if you do not sort your extract file by CIS Sort Key after it is produced, this record will physically be the last record on the extract file.

Field Name Format Source/Value/Description

BATCH_CD

A8

Batch Control Code of the extract process.

BATCH_NBR

N10

Batch Number of the extract process

BATCH_RERUN_NBR

N10

Batch Rerun number of the extract process.

QTE_CNT

N10

Count of quotes on this extract.

EXTRACT_DTTM

A26

System time of extraction.

QUOTE_ID_START

A12

This is only used when a quote is produced as a result of an online request (from Quote - Main). It contains the Quote Id to extract.

QUOTE_ID_END

A12

This is only used when a quote is produced as a result of an online request (from Quote - Main). It contains the Quote Id to extract.

THREAD_NBR

N10

This field is only used if quotes are extracted in batch. It contains the thread number in which the quote was extracted.

THREAD_CNT

N10

This field is only used if quotes are extracted in batch. It contains the total number of threads that were extracted.

Top of Page

Quote (0100) Record Definition

Field Name Format Source/Value/Description

QUOTE_ID

A12

CI_QUOTE

ACCT_ID

A10

CI_QUOTE

EXPIRE_DTTM

A26

CI_QUOTE

QUOTE_STAT_FLG

A2

CI_QUOTE

CURRENCY_CD

A3

CI_ACCT

CUR_SYMBOL

A4

CI_CURRENCY_CD

ENTITY_NAME1

A64

CI_QUOTE_RTG. Mailing Entity Name1.

ENTITY_NAME2

A64

CI_QUOTE_RTG. Mailing Entity Name2.

ENTITY_NAME3

A64

CI_QUOTE_RTG. Mailing Entity Name3.

ADDRESS_SBR

A361

CI_QUOTE_RTG. Refer to its components in a later section.

EMAILID

A254

CI_QUOTE_RTG

PHONE-FAX

A64

CI_QUOTE_RTG

Top of Page

Quote Detail (0200) Record Definition

Field Name Format Source/Value/Description

QUOTE_DTL_ID

A12

CI_QUOTE_DTL

SA_ID

A10

CI_QUOTE_DTL

TOTAL_AMT

N13.2

CI_BSEG_CALC. Sum of all calculation amounts (quote detail's bill segments).

PREMISE_ID

A10

CI_SA (Characteristic Premise)

ADDRESS_SBR

A361

CI_PREM. Refer to its components in a later section.

SA_TYPE_DESCR

A60

CI_SA_TYPE_L

SVC_TYPE_CD

A30

CI_SVC_TYPE_L

SA_VERSION

N5

CI_QUOTE_DTL

QTE_DTL_SA_VERSION

N5

CI_QUOTE_DTL

RS_DESCR

A60

CI_RS_L. Description of Rate effective on SA start date.

Top of Page

SA Terms and Conditions (0300) Record Definition

Field Name Format Source/Value/Description

START_DT

A10

CI_SA_TC

END_DT

A10

CI_SA_TC

TC_TYPE_CD

A12

CI_TC

DESCR

A60

CI_TC_L

TC_TYPE_TXT

A2000

CI_TC_L

Top of Page

Bill Segment (0400) Record Definition

Field Name Format Source/Value/Description

START_DT

A10

CI_BSEG

END_DT

A10

CI_BSEG

BSEG_STAT_FLG

A2

CI_BSEG

BSEG_AMT

S13.2

CI_BSEG_CALC_LN

Top of Page

Bill Calculation Header (0500) Record Definition

Field Name Format Source/Value/Description

START_DT

A10

CI_BSEG_CALC

END_DT

A10

CI_BSEG_CALC

RS_CD

A8

CI_BSEG_CALC

CALC_AMT

S13.2

CI_BSEG_CALC

DESCR_ON_BILL

A254

CI_BSEG_CALC

Top of Page

Bill Calculation Line (0600) Record Definition

Field Name Format Source/Value/Description

APP_IN_SUMM_SW

A1

CI_BSEG_CALC_LN

CALC_AMT

S13.2

CI_BSEG_CALC_LN

EXEMPT_AMT

S13.2

CI_BSEG_CALC_LN

UOM_CD

A30

CI_BSEG_CALC_LN

TOU_CD

A30

CI_BSEG_CALC_LN

SQI_CD

A30

CI_BSEG_CALC_LN

BILL_SQ

S12.6

CI_BSEG_CALC_LN

DESCR_ON_BILL

A254

CI_BSEG_CALC_LN

Top of Page

End of Bill Calculation Header (0700) Record Definition

Field Name Format Source/Value/Description

Dummy field

Top of Page

Bill Segment Read (0800) Record Definition

Note:

The Bill Segment Read (0800) Record is not applicable for Customer to Meter (C2M). A quote detail bill segment doesn’t have read details.

Top of Page

Bill Segment SQ (0900) Record Definition

Field Name Format Source/Value/Description

UOM_CD

A30

CI_BSEG_SQ

TOU_CD

A30

CI_BSEG_SQ

SQI_CD

A30

CI_BSEG_SQ

SQ_DEC_POS

N1

CI_BSEG_SQ

BILL_SQ

S12.6

CI_BSEG_SQ

Top of Page

End of Bill Segment (1000) Record Definition

Field Name Format Source/Value/Description

Dummy field

Top of Page

End of Quote Detail (1100) Record Definition

Field Name Format Source/Value/Description

Dummy field

Top of Page

End of Quote (9999) Record Definition

Field Name Format Source/Value/Description

Dummy field

Top of Page

Address Sub-Record Definition

The address that appears in both the quote record (0100) and the quote detail record (0200) is composed of the following:

Field Name Format Description

COUNTRY

A3

ADDRESS1

A64

Refer to Completing A Quote Creates Quote Routings for a description of conditions when this field will contain a fax number or an Email address rather than the first line of a postal address (this only occurs for a bill record (0100)).

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

Top of Page