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