Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

CCI Req by tyndale

VIEWS: 4 PAGES: 11

									                                                                                            Change Consumer Info Request Gas Implementation Guide for Ontario v1.1
Field Display Names                           XML names                     Definition                                Attribute /       Element Name                       Child Elements                    Parent Elements            Valid Information in Field           Data Type        Field Length    Echo / Optional/Mandatory/
                                                                                                                       Element                                                                                                                (enumeration)                                                  Refresh /   Conditional
                                                                                                                                                                                                                                                                                                               New

PIPE Document                                 PIPEDocument                  Document type name, stands for                                PIPEDocument                 MarketParticipantDirectory,                    N/A                             N/A                        N/A              N/A          N/A   1 PIPE Document per PIPE
                                                                            Participant Interface Process for                                                               PIPTransaction                                                                                                                                   Document
                                                                            Energy.
XML Name Space                                xmlns                         Uniquely identifies the XML name              E                    xmlns                               N/A                          PIPEDocument                          N/A                       String            N/A          N/A               M
                                                                            space.
XML Name Space Schema Instance                xmlns:xsi                     Defines the schema instance being             E                  xmlns:xsi                             N/A                          PIPEDocument                          N/A                       String            N/A          N/A               M
                                                                            used.
XML Schema Instance location                  xsi:schemaLocation            Associates the actual schema                  E             xsi:schemaLocation                         N/A                          PIPEDocument                          N/A                       String            N/A          N/A               M
                                                                            instance being used to the name
                                                                            space.
Version                                       Version                       Identifies the version of the                 E                   Version                              N/A                          PIPEDocument                          1.1                  Enumerated (1.1)       N/A          N/A               M
                                                                            PIPEDocument schema.
Document Reference Number                     DocumentReferenceNumber       Uniquely identifies this                      E         DocumentReferenceNumber                        N/A                          PIPEDocument                          N/A                       String             30          N/A               M
                                                                            PIPEDocument.
Creation Date and Time                        CreationDate                  System date and time stamp of when            E                CreationDate                            N/A                          PIPEDocument                          N/A                        Date              19          N/A               M
                                                                            the transaction is generated.                                                                                                                                                                 (yyyymmddhhmmssm
                                                                                                                                                                                                                                                                                 sstz)
Market Participant Directory                  MarketParticipantDirectory    Contains tags that define all the             E          MarketParticipantDirectory             Sender, Recipient                   PIPEDocument               (see Market Participant               N/A              N/A          N/A               M
                                                                            Market Participants involved in the                                                                                                                            Directory data structure)
                                                                            particular PIP transaction.
PIP Transaction                               PIPTransaction                Indicates the beginning of a PIP              E               PIPTransaction              ChangeConsumerInfoRequest                 PIPEDocument              (see PIP Transaction data              N/A              N/A          N/A           1 or more
                                                                            transaction.                                                                                                                                                          structure)

Market Participant Directory                  MarketParticipantDirectory    Contains tags that define all the                        MarketParticipantDirectory             Sender, Recipient                   PIPEDocument                          N/A                        N/A              N/A          N/A      1 Market Participant
                                                                            Market Participants involved in the                                                                                                                                                                                                          Directory per PIPE
                                                                            particular PIP transaction.                                                                                                                                                                                                                      Document
Sender                                        Sender                        Used to identify the sender of the            E                   Sender                        MarketParticipant              MarketParticipantDirectory     (see Sender data structure)            N/A              N/A          N/A               M
                                                                            PIPE document.
Recipient                                     Recipient                     Used to identify the recipient of the         E                  Recipient                      MarketParticipant              MarketParticipantDirectory    (see Recipient data structure)          N/A              N/A          N/A               M
                                                                            PIPE document.

Sender                                        Sender                        Used to identify the sender of the                                Sender                        MarketParticipant              MarketParticipantDirectory                 N/A                        N/A              N/A          N/A      1 Sender per Market
                                                                            PIPE document.                                                                                                                                                                                                                              Participant Directory
Market Participant                            MarketParticipant             Identifies the Market Participants.           E              MarketParticipant                  CompanyName,                            Sender               (see Market Participant data            N/A              N/A          N/A               M
                                                                                                                                                                        MarketParticipantIdentifier                                              structure)

Recipient                                     Recipient                     Used to identify the recipient of the                            Recipient                      MarketParticipant              MarketParticipantDirectory                 N/A                        N/A              N/A          N/A     1 Recipient per Market
                                                                            PIPE document.                                                                                                                                                                                                                              Participant Directory
Market Participant                            MarketParticipant             Identifies the Market Participants.           E              MarketParticipant                  CompanyName,                           Recipient             (see Market Participant data            N/A              N/A          N/A               M
                                                                                                                                                                        MarketParticipantIdentifier                                              structure)

Market Participant                            MarketParticipant             Identifies the Market Participants.                          MarketParticipant                  CompanyName,                       Recipient, Sender                      N/A                        N/A              N/A          N/A    1 Market Participant per
                                                                                                                                                                        MarketParticipantIdentifier                                                                                                                  Sender and 1 per Recipient

Company Name                                  CompanyName                   Tag used to define the name of the            E               CompanyName                              N/A                         MarketParticipant                      N/A                       String            100          N/A               M
                                                                            company a Consumer already has
                                                                            service with or would like to establish
                                                                            service with.
Market Participant Identifier                 MarketParticipantIdentifier   Tag used to uniquely identify a               E          MarketParticipantIdentifier                   N/A                         MarketParticipant                      N/A                       String             10          N/A               M
                                                                            company or business.

PIP Transaction                               PIPTransaction                Indicates the beginning of a PIP                              PIPTransaction              ChangeConsumerInfoRequest                 PIPEDocument                          N/A                        N/A              N/A          N/A    1 or more PIP Transaction
                                                                            transaction.                                                                                                                                                                                                                                 per PIPE Document
Version                                       Version                       Identifies the version of the PIP             E                   Version                        PIPTransaction                     PIPTransaction                        N/A                       String             5           N/A               M
                                                                            Document schema.
Transaction Reference Number                  TransactionReferenceNumber    Uniquely identifies this PIP                  E         TransactionReferenceNumber               PIPTransaction                     PIPTransaction                        N/A                       String             30          N/A               M
                                                                            transaction.
Change Consumer Info Request (purpose of      ChangeConsumerInfoRequest     Tag used to nest information about a          E         ChangeConsumerInfoRequest               ChangeInformation,                  PIPTransaction           (see Change Consumer Info               N/A               5           N/A               M
transaction)                                                                change Consumer Info Request.                                                          AccountInformation, ServiceAddress,                                     Request data structure)
                                                                                                                                                                          ConsumerInformation,
                                                                                                                                                                     ConsumerData, Billing Address
                                                                                                                                                                                Formatted,
                                                                                                                                                                       BillingAddressUnFormatted



Change Consumer Info                          ChangeConsumerInfoRequest     Tag used to nest information about a                    ChangeConsumerInfoRequest               ChangeInformation,                  PIPTransaction                        N/A                        N/A              N/A          N/A    1 Change Consumer Info
                                                                            change Consumer Info Request.                                                          AccountInformation, ServiceAddress,                                                                                                                    Request per PIP
Request                                                                                                                                                                   ConsumerInformation,                                                                                                                              Transaction
                                                                                                                                                                     ConsumerData, Billing Address
                                                                                                                                                                                Formatted,
                                                                                                                                                                       BillingAddressUnFormatted

Change Information                            ChangeInformation             Tag used to nest detail information           E             ChangeInformation             ChangeReason, EffectiveDate         ChangeConsumerInfoRequest     (see Change Information data             N/A              N/A          N/A               M
                                                                            about the change.                                                                                                                                                    structure)
Account Information                           AccountInformation            Tag used to hold all the information          E             AccountInformation              DistributorAccountNumber,         ChangeConsumerInfoRequest     (see Account Information data            N/A              N/A          N/A               M
                                                                            relevant to an account.                                                                   OldDistributorAccountNumber,                                               structure)
                                                                                                                                                                       AccountNumberSwitchDate,
                                                                                                                                                                    VendorConsumerAccountNumber
Service Address                               ServiceAddress                This is the container element for the         E               ServiceAddress           StreetNumber, StreetNumberSuffix,      ChangeConsumerInfoRequest                   N/A                        N/A              N/A          N/A    0 or 1 ServiceAddress per
                                                                            consumer’s address of service                                                                StreetName, StreetType,                                                                                                                       Change Consumer Info
                                                                            (premises address).                                                                        StreetDirection, UnitNumber,
                                                                                                                                                                   UnitType, City, Province, PostalCode




   b72c73a4-fb61-43df-9da0-c931ec4059f3.xls                                                                                                                         Page 1 of 11                                                                                                                                                   3/25/2010
                                                                                             Change Consumer Info Request Gas Implementation Guide for Ontario v1.1
Field Display Names                           XML names                     Definition                               Attribute /         Element Name                     Child Elements                    Parent Elements          Valid Information in Field         Data Type           Field Length    Echo / Optional/Mandatory/
                                                                                                                      Element                                                                                                              (enumeration)                                                   Refresh /   Conditional
                                                                                                                                                                                                                                                                                                             New
Consumer Data                                 ConsumerData                  Tag used to nest all relevant                E             ConsumerInformation         LanguagePreference, BillingCycle,     ChangeConsumerInfoRequest                N/A                        N/A                N/A          N/A    0 or 1 ConsumerData per
                                                                            Consumer information.                                                                        ServiceClass, RateClass,                                                                                                                    Change Consumer Info
                                                                                                                                                                    NewDistributorAccountNumber
Consumer Information                          ConsumerInformation           Tag used to nest all relevant                E             ConsumerInformation        LastName, FirstName, MiddleName,       ChangeConsumerInfoRequest                N/A                        N/A                N/A          N/A            0 or 1
                                                                            Consumer information.                                                                        BillingTelephoneNumber,                                                                                                                    ConsumerInformation per
                                                                                                                                                                   BillingTelephoneNumberExtension                                                                                                                   Change Consumer Info

Billing Address Formatted                     BillingAddressFormatted       Identifies the billing address of the        E            BillingAddressFormatted      AttentionLine, StreetName, Street     ChangeConsumerInfoRequest                N/A                        N/A                N/A          N/A                0 or 1
                                                                            account                                                                               Number, UnitNumber, City, Province,                                                                                                              BillingInformationFormatted
                                                                                                                                                                       PostalCode, CountryCode                                                                                                                     per Change Consumer info
                                                                                                                                                                                                                                                                                                                               Request
Billing Address Unformatted                   BillingAddressUnFormatted     Identifies the billing address of the        E           BillingAddressUnFormatted            BillingAddressLine1,           ChangeConsumerInfoRequest                N/A                        N/A                100          N/A                0 or 1
                                                                            account                                                                                       BillingAddressLine2,                                                                                                                     BillingInformationUnformatt
                                                                                                                                                                          BillingAddressLine3,                                                                                                                     ed per Change Consumer
                                                                                                                                                                          BillingAddressLine4,                                                                                                                              info Request
                                                                                                                                                                          BillingAddressLine5

Change Information                            ChangeInformation             Tag used to nest detail information                         ChangeInformation            ChangeReason, EffectiveDate         ChangeConsumerInfoRequest    (see Change Information data           N/A                N/A          N/A          1 or more
                                                                            about the change.                                                                                                                                                  structure)                                                            ChangeInformation per
                                                                                                                                                                                                                                                                                                                     ChangeConsumerInfo
                                                                                                                                                                                                                                                                                                                           request
Change Reason                                 ChangeReason                  Tag used to describe the reason for          E                ChangeReason                            N/A                        ChangeInformation                    N/A                    Enumerated:            N/A          N/A              M
                                                                            the change                                                                                                                                                                               (AccountSetupFollowi
                                                                                                                                                                                                                                                                           ngMove,
                                                                                                                                                                                                                                                                      AccountSetupROS,
                                                                                                                                                                                                                                                                           Refolio,
                                                                                                                                                                                                                                                                       ConsumerMove,
                                                                                                                                                                                                                                                                      ConsumerInitiated)
Effective Date                                EffectiveDate                 Indicates the effective date of the          E                 EffectiveDate                          N/A                        ChangeInformation                    N/A                  Date (yyyymmdd)           8           N/A               M
                                                                            Consumers Change takes effect
                                                                                                                                                                                                                                         AccountDoesNotExist,            Enumerated (
                                                                                                                                                                                                                                            DuplicateTRN             AccountDoesNotExist
                                                                                                                                                                                                                                                                       | DuplicateTRN )
Account Information                           AccountInformation            Tag used to hold all the information                        AccountInformation            DistributorAccountNumber,          ChangeConsumerInfoRequest                N/A                         N/A               N/A          N/A               M
                                                                            relevant to an account.                                                                 OldDistributorAccountNumber,
                                                                                                                                                                     AccountNumberSwitchDate,
                                                                                                                                                                   VendorConsumerAccountNumber
Distributor Account Number                    DistributorAccountNumber      The distributor’s Consumer account           E           DistributorAccountNumber                     N/A                        AccountInformation                   N/A                       String               30          N/A               M
                                                                            number as it appears on the bill

Old Distributor Account Number                OldDistributorAccountNumber   Attribute defining previous account          E          OldDistributorAccountNumber                   N/A                        AccountInformation                   N/A                       String               30          N/A               O
                                                                            number for this Consumer.
Account Number Switch Date                    AccountNumberSwitchDate       Date the account changed from the            E           AccountNumberSwitchDate                      N/A                        AccountInformation                   N/A                Date (YYYYMMDD)             8           N/A               O
                                                                            previous account number to the
                                                                            current account number.
Vendor Consumer Account Number                VendorConsumerAccountNumber   This contains Vendor’s identifier for        E         VendorConsumerAccountNumber                    N/A                        AccountInformation                   N/A                       String              100          N/A               O
                                                                            the consumer. This value is not
                                                                            validated and is returned in the
                                                                            response document.

Service Address                               ServiceAddress                This is the container element for the                         ServiceAddress          StreetNumber, StreetNumberSuffix,      ChangeConsumerInfoRequest                N/A                        N/A                N/A          N/A    0 or 1 ServiceAddress per
                                                                            consumer’s address of service                                                               StreetName, StreetType,                                                                                                                      Change Consumer Info
                                                                            (premises address). If applicable this                                                    StreetDirection, UnitNumber,
                                                                            container would contain the                                                           UnitType, City, Province, PostalCode
                                                                            consumers new service address
                                                                            when move information is being sent
                                                                            from the Vendor to the Distributor.

Street Number                                 StreetNumber                  Indicates the service street number.         E                 StreetNumber                           N/A                         ServiceAddress                      N/A                       String               10          N/A               O

Street Number Suffix                          StreetNumberSuffix            Indicates the street number for the          E              StreetNumberSuffix                        N/A                         ServiceAddress                      N/A                       String               10          N/A               O
                                                                            service address.
Street Name                                   StreetName                    Street Number could be Lot and               E                 StreetName                             N/A                         ServiceAddress                      N/A                       String               55          N/A               M
                                                                            Concession
Street Type                                   StreetType                    Ave, Street, Road                            E                  StreetType                            N/A                         ServiceAddress                      N/A                     String                10           N/A               O
Street Direction                              StreetDirection               Lists the consumer’s street direction        E                StreetDirection                         N/A                         ServiceAddress         N, S, E, W, NW, NE, SW, or SE Enumerated: N | S |          N/A          N/A               O
                                                                            of the service address.                                                                                                                                                                E | W | NW | NE |
                                                                                                                                                                                                                                                                   SW | SE
Unit Number                                   UnitNumber                    Indicates the unit (apartment)               E                  UnitNumber                            N/A                         ServiceAddress                      N/A                     String                 10          N/A               O
                                                                            number for the service address.
Unit Type                                     UnitType                      Indicates the unit type (such as APT,        E                   UnitType                             N/A                         ServiceAddress                      N/A                       String               10          N/A               O
                                                                            Suite) of the service address.
City                                          City                          Indicates the city for the service           E                     City                               N/A                         ServiceAddress                      N/A                       String               30          N/A               M
                                                                            address.
Province                                      Province                      Indicates the province for the service       E                   Province                             N/A                         ServiceAddress                      ON                   Enumerated: ON           N/A          N/A               M
                                                                            address.
Postal code                                   PostalCode                    Indicates the postal code for the            E                  PostalCode                            N/A                         ServiceAddress                      N/A                       String               6           N/A               O
                                                                            service address.

Consumer Data                                 ConsumerData                  Tag used to nest all relevant                                 ConsumerData             LanguagePreference, BillingCycle,     ChangeConsumerInfoRequest                N/A                        N/A                N/A          N/A    0 or 1 ConsumerData per
                                                                            Consumer information.                                                                      ServiceClass, RateClass,                                                                                                                      Change Consumer Info
                                                                                                                                                                    NewDistributorAccountNumber
Language Preference                           LanguagePreference            Attribute which specifies the                E              LanguagePreference                       N/A                         AccountInformation            English or French         Enumerated (English        N/A          N/A               O
                                                                            language preference for the                                                                                                                                                                  | French)
                                                                            Consumer account.
Billing Cycle                                 BillingCycle                  Indicates the billing cycle for the          E                  BillingCycle                          N/A                        AccountInformation                   N/A                       String               2           N/A               O
                                                                            specified account.
Service Class                                 ServiceClass                  Indicates the service class for the          E                 ServiceClass                           N/A                        AccountInformation          Enumerated (R | C | I )            String              N/A          N/A               O
                                                                            specified account. R=Residential C=
                                                                            Commercial I= Industrial
Rate Class                                    RateClass                     Indicates the Primary Rate class for         E                  RateClass                             N/A                        AccountInformation                  String                     String               5           N/A               O
                                                                            the specified account.




   b72c73a4-fb61-43df-9da0-c931ec4059f3.xls                                                                                                                        Page 2 of 11                                                                                                                                                  3/25/2010
                                                                                           Change Consumer Info Request Gas Implementation Guide for Ontario v1.1
Field Display Names                           XML names                     Definition                            Attribute /         Element Name                  Child Elements   Parent Elements      Valid Information in Field   Data Type   Field Length    Echo / Optional/Mandatory/
                                                                                                                   Element                                                                                      (enumeration)                                     Refresh /   Conditional
                                                                                                                                                                                                                                                                    New
New Distributor Account Number                NewDistributorAccountNumber   Tag used to define the new account        E         NewDistributorAccountNumber                  N/A     AccountInformation              N/A                 String         30          N/A            O
                                                                            number after a move or used to
                                                                            identify new account number after a
                                                                            Refolio based on change reason.




   b72c73a4-fb61-43df-9da0-c931ec4059f3.xls                                                                                                                   Page 3 of 11                                                                                                          3/25/2010
                                                                                                       Change Consumer Info Request Gas Implementation Guide for Ontario v1.1
Field Display Names                                 XML names                         Definition                                Attribute /         Element Name                        Child Elements                   Parent Elements           Valid Information in Field   Data Type   Field Length    Echo / Optional/Mandatory/
                                                                                                                                 Element                                                                                                                 (enumeration)                                     Refresh /   Conditional
                                                                                                                                                                                                                                                                                                             New

Consumer Information                                ConsumerInformation               Tag used to nest all relevant                                ConsumerInformation          LastName, FirstName, MiddleName,      ChangeConsumerInfoRequest               N/A                  N/A          N/A          N/A            0 or 1
                                                                                      Consumer information.                                                                            BillingTelephoneNumber,                                                                                                      ConsumerInformation per
                                                                                                                                                                                 BillingTelephoneNumberExtension                                                                                                     Change Consumer Info

Last Name                                           LastName                          Indicates the last name for                   E                   LastName                                N/A                      ConsumerInformation                  N/A                 String         20          N/A                M
                                                                                      Consumer information, Consumer
                                                                                      information, billing information, and
                                                                                      third party for copies of bills
                                                                                      information.
First Name                                          FirstName                         Indicates the first name for                  E                   FirstName                               N/A                      ConsumerInformation                  N/A                 String         20          N/A                 O
                                                                                      Consumer information, Consumer
                                                                                      information, billing information, and
                                                                                      third party for copies of bills
                                                                                      information.
Middle Name                                         MiddleName                        Indicates the middle name for                 E                  MiddleName                               N/A                      ConsumerInformation                  N/A                 String         20          N/A                 O
                                                                                      Consumer information, Consumer
                                                                                      information, billing information, and
                                                                                      third party for copies of bills
                                                                                      information.
Billing Telephone Number                            BillingTelephoneNumber            Tag used to contain the billing               E             BillingTelephoneNumber                        N/A                      ConsumerInformation                  N/A                Decimal         10          N/A                 O
                                                                                      telephone number
Billing Telephone Number Extension                  BillingTelephoneNumberExtension   Tag used to contain the billing               E         BillingTelephoneNumberExtension                   N/A                      ConsumerInformation                  N/A                 String         10          N/A                 O
                                                                                      telephone number extension

Billing Address Formatted                           BillingAddressFormatted           Identifies the billing address of the                       BillingAddressFormatted        AttentionLine, StreetName, Street    ChangeConsumerInfoRequest               N/A                  N/A          N/A          N/A   0 or 1 Billing Information per
                                                                                      account                                                                                   Number, UnitNumber, City, Province,                                                                                                  Change Consumer Info
                                                                                                                                                                                     PostalCode, CountryCode                                                                                                                   Request

Attention Line                                      AttentionLine                     Identifies the name of a person or            E                  AttentionLine                            N/A                     BillingAddressFormatted               N/A                 String        100          N/A                 O
                                                                                      Business that the forwarding billing
                                                                                      infromation will be going
Street Name                                         StreetName                        Service street name or Lot and                E                  StreetName                               N/A                     BillingAddressFormatted               N/A                 String         55          N/A                 O
                                                                                      Concession
Street Number                                       StreetNumber                      Indicates the billing street address.         E                 StreetAddress                             N/A                     BillingAddressFormatted               N/A                 String         10          N/A                M
Unit Number                                         UnitNumber                        Indicates the unit number for the             E                  UnitNumber                               N/A                     BillingAddressFormatted               N/A                 String         10          N/A                O
                                                                                      billing address.
City                                                City                              Indicates the city for the billing            E                      City                                 N/A                     BillingAddressFormatted               N/A                 String         30          N/A                 O
                                                                                      address.
Province                                            Province                          Indicates the state or the province for       E                    Province                               N/A                     BillingAddressFormatted               N/A                 String         20          N/A                 O
                                                                                      the service address.
Postal Code                                         PostalCode                        Indicates the zip or postal code for          E                   PostalCode                              N/A                     BillingAddressFormatted             NANANA               NANANA          6           N/A                 O
                                                                                      the billing address.
Country Code                                        CountryCode                       Indicates the country code for the            E                  CountryCode                              N/A                     BillingAddressFormatted               N/A                 String         20          N/A                 O
                                                                                      billing address. (Suggest using
                                                                                      Canada Posts standard for Country
                                                                                      Code)

Billing Address Unformatted                         BillingAddressUnFormatted         Identifies the billing address of the                      BillingAddressUnFormatted             BillingAddressLine1,           ChangeConsumerInfoRequest               N/A                  N/A          N/A          N/A   0 or 1 Billing Information per
                                                                                      account                                                                                          BillingAddressLine2,                                                                                                          Change Consumer Info
                                                                                                                                                                                       BillingAddressLine3,                                                                                                                    Request
                                                                                                                                                                                       BillingAddressLine4,
                                                                                                                                                                                       BillingAddressLine5
Billing Address Line 1                              BillingAddressLine1               This contains the first line of the           E               BillingAddressLine1                         N/A                    BillingAddressUnFormatted              N/A                 String        100          N/A                 O
                                                                                      mailing address of the consumer.
Billing Address Line 2                              BillingAddressLine2               This contains the second line of the          E               BillingAddressLine2                         N/A                    BillingAddressUnFormatted              N/A                 String        100          N/A                 O
                                                                                      mailing address of the consumer.

Billing Address Line 3                              BillingAddressLine3               This contains the third line of the           E               BillingAddressLine3                         N/A                    BillingAddressUnFormatted              N/A                 String        100          N/A                 O
                                                                                      mailing address of the consumer.
Billing Address Line 4                              BillingAddressLine4               This contains the fourth line of the          E               BillingAddressLine4                         N/A                    BillingAddressUnFormatted              N/A                 String        100          N/A                 O
                                                                                      mailing address of the consumer.
Billing Address Line 5                              BillingAddressLine5               This contains the fourth line of the          E               BillingAddressLine5                         N/A                    BillingAddressUnFormatted              N/A                 String        100          N/A                 O
                                                                                      mailing address of the consumer.

Data Type Legend:
String = Alpha Numeric (Field allows for
alphabetic values, numeric values, as well as
any combination of alphabetic and numeric
values)
N = Numeric (no decimals)
D = Decimal with total field length in parenthesis ( )
   = Illustrates the position of the decimal point
in reference to the overall length of the field.

N/A = Not applicable
Enumerated= The only valid values are listed.

Date= Date format used.




   b72c73a4-fb61-43df-9da0-c931ec4059f3.xls                                                                                                                                      Page 4 of 11                                                                                                                                     3/25/2010
                                                                                          Change Consumer Info Accept Gas Implementation Guide for Ontario v1.1
 Field Display Names                       XML names                     Definition                          Attribute /          Element Name                    Child Elements                 Parent Elements           Valid Information in Field           Data Type        Field Length    Echo / Optional/Mandatory/
                                                                                                              Element                                                                                                            (enumeration)                                                  Refresh /   Conditional
                                                                                                                                                                                                                                                                                                  New

 PIPE Document                             PIPEDocument                  Document type name, stands                                PIPEDocument                MarketParticipantDirectory,               N/A                             N/A                        N/A              N/A          N/A   1 PIPE Document per PIPE
                                                                         for Participant Interface Process                                                          PIPTransaction                                                                                                                              Document
                                                                         for Energy.
 XML Name Space                            xmlns                         Uniquely identifies the XML             E                      xmlns                             N/A                      PIPEDocument                          N/A                       String            N/A          N/A                M
                                                                         name space.
 XML Name Space Schema Instance            xmlns:xsi                     Defines the schema instance             E                    xmlns:xsi                           N/A                      PIPEDocument                          N/A                       String            N/A          N/A                M
                                                                         being used.
 XML Schema Instance location              xsi:schemaLocation            Associates the actual schema            E               xsi:schemaLocation                       N/A                      PIPEDocument                          N/A                       String            N/A          N/A                M
                                                                         instance being used to the
                                                                         name space.
 Version                                   Version                       Identifies the version of the           E                     Version                            N/A                      PIPEDocument                          1.1                  Enumerated (1.1)       N/A          N/A                M
                                                                         PIPEDocument schema.
 Document Reference Number                 DocumentReferenceNumber       Uniquely identifies this                E           DocumentReferenceNumber                      N/A                      PIPEDocument                          N/A                       String             30          N/A                M
                                                                         PIPEDocument.
 Creation Date and Time                    CreationDate                  System date and time stamp of           E                  CreationDate                          N/A                      PIPEDocument                          N/A                        Date              19          N/A                M
                                                                         when the transaction is                                                                                                                                                             (yyyymmddhhmmssm
                                                                         generated.                                                                                                                                                                                 sstz)
 Market Participant Directory              MarketParticipantDirectory    Contains tags that define all the       E            MarketParticipantDirectory           Sender, Recipient               PIPEDocument               (see Market Participant               N/A              N/A          N/A                M
                                                                         Market Participants involved in                                                                                                                      Directory data structure)
                                                                         the particular PIP transaction.

 PIP Transaction                           PIPTransaction                Indicates the beginning of a PIP        E                 PIPTransaction             ChangeConsumerInfoAccept             PIPEDocument              (see PIP Transaction data              N/A              N/A          N/A            1 or more
                                                                         transaction.                                                                                                                                                structure)

 Market Participant Directory              MarketParticipantDirectory    Contains tags that define all the                    MarketParticipantDirectory           Sender, Recipient               PIPEDocument                          N/A                        N/A              N/A          N/A       1 Market Participant
                                                                         Market Participants involved in                                                                                                                                                                                                     Directory per PIPE
                                                                         the particular PIP transaction.                                                                                                                                                                                                         Document

 Sender                                    Sender                        Used to identify the sender of          E                     Sender                      MarketParticipant          MarketParticipantDirectory     (see Sender data structure)            N/A              N/A          N/A                M
                                                                         the PIPE document.
 Recipient                                 Recipient                     Used to identify the recipient of       E                    Recipient                    MarketParticipant          MarketParticipantDirectory    (see Recipient data structure)          N/A              N/A          N/A                M
                                                                         the PIPE document.

 Sender                                    Sender                        Used to identify the sender of                                Sender                      MarketParticipant          MarketParticipantDirectory                 N/A                        N/A              N/A          N/A      1 Sender per Market
                                                                         the PIPE document.                                                                                                                                                                                                                Participant Directory
 Market Participant                        MarketParticipant             Identifies the Market                   E                MarketParticipant                CompanyName,                        Sender               (see Market Participant data            N/A              N/A          N/A               M
                                                                         Participants.                                                                         MarketParticipantIdentifier                                          structure)

 Recipient                                 Recipient                     Used to identify the recipient of                            Recipient                    MarketParticipant          MarketParticipantDirectory                 N/A                        N/A              N/A          N/A     1 Recipient per Market
                                                                         the PIPE document.                                                                                                                                                                                                                Participant Directory
 Market Participant                        MarketParticipant             Identifies the Market                   E                MarketParticipant                CompanyName,                       Recipient             (see Market Participant data            N/A              N/A          N/A               M
                                                                         Participants.                                                                         MarketParticipantIdentifier                                          structure)

 Market Participant                        MarketParticipant             Identifies the Market                                    MarketParticipant                CompanyName,                   Recipient, Sender                      N/A                        N/A              N/A          N/A    1 Market Participant per
                                                                         Participants.                                                                         MarketParticipantIdentifier                                                                                                              Sender and 1 per Recipient

 Company Name                              CompanyName                   Tag used to define the name of          E                 CompanyName                            N/A                     MarketParticipant                      N/A                       String            100          N/A                M
                                                                         the company a Consumer
                                                                         already has service with or
                                                                         would like to establish service
                                                                         with.
 Market Participant Identifier             MarketParticipantIdentifier   Tag used to uniquely identify a         E            MarketParticipantIdentifier                 N/A                     MarketParticipant                     String                      10                60          N/A                M
                                                                         company or business.

 PIP Transaction                           PIPTransaction                Indicates the beginning of a PIP                          PIPTransaction             ChangeConsumerInfoAccept             PIPEDocument                          N/A                        N/A              N/A          N/A    1 or more PIP Transaction
                                                                         transaction.                                                                                                                                                                                                                       per PIPE Document
 Version                                   Version                       Identifies the version of the PIP       E                     Version                            N/A                      PIPTransaction                        N/A                       String             5           N/A               M
                                                                         Document schema.
 Transaction Reference Number              TransactionReferenceNumber    Uniquely identifies this PIP            E          TransactionReferenceNumber                    N/A                      PIPTransaction                        N/A                       String             30          N/A                M
                                                                         transaction.
 Change Consumer Info Accept (purpose of   ChangeConsumerInfoAccept      Tag used to nest information            E           ChangeConsumerInfoAccept              ChangeInformation,              PIPTransaction           (see Change Consumer Info               N/A               5           N/A                M
 transaction)                                                            about a change Consumer Info                                                              AccountInformation,                                         Accept data structure)
                                                                         Accept.                                                                                     ServiceAddress,
                                                                                                                                                                 ConsumerInformation,
                                                                                                                                                             ConsumerData, Billing Address
                                                                                                                                                                       Formatted,
                                                                                                                                                              BillingAddressUnFormatted

 Change Consumer Info Accept               ChangeConsumerInfoAccept      Tag used to nest information                        ChangeConsumerInfoAccept              ChangeInformation,              PIPTransaction                        N/A                        N/A              N/A          N/A    1 Change Consumer Info
                                                                         about a change Consumer Info                                                              AccountInformation,                                                                                                                  Accept per PIP Transaction
                                                                         Accept.                                                                                     ServiceAddress,
                                                                                                                                                                 ConsumerInformation,
                                                                                                                                                             ConsumerData, Billing Address
                                                                                                                                                                       Formatted,
                                                                                                                                                              BillingAddressUnFormatted
 Original Transaction Reference Number     OriginalTransactionReferenceN Attribute that references the           E         OriginalTransactionReferenceNu                  N/A                ChangeConsumerInfoAccept                   N/A                       String             30          N/A                M
                                           umber                         original Change Consumer Info                     mber
                                                                         Request transaction.
 Change Information                        ChangeInformation             Tag used to nest detail                 E                ChangeInformation          ChangeReason, EffectiveDate      ChangeConsumerInfoAccept     (see Change Information data             N/A              N/A          N/A                M
                                                                         information about the change.                                                                                                                              structure)
 Account Information                       AccountInformation            Tag used to hold all the                E               AccountInformation            DistributorAccountNumber,      ChangeConsumerInfoAccept     (see Account Information data            N/A              N/A          N/A                M
                                                                         information relevant to an                                                          OldDistributorAccountNumber,                                           structure)
                                                                         account.                                                                             AccountNumberSwitchDate,
                                                                                                                                                            VendorConsumerAccountNumber

 Service Address                           ServiceAddress                This is the container element for       E                 ServiceAddress                    StreetNumber,            ChangeConsumerInfoAccept                   N/A                        N/A              N/A          N/A    0 or 1 ServiceAddress per
                                                                         the consumer’s address of                                                          StreetNumberSuffix, StreetName,                                                                                                              ChangeConsumerInfoAcce
                                                                         service (premises address).                                                           StreetType, StreetDirection,                                                                                                                           pt
                                                                                                                                                               UnitNumber, UnitType, City,
                                                                                                                                                                  Province, PostalCode




b72c73a4-fb61-43df-9da0-c931ec4059f3.xls                                                                                                                      Page 5 of 11                                                                                                                                                   3/25/2010
                                                                                           Change Consumer Info Accept Gas Implementation Guide for Ontario v1.1
 Field Display Names                       XML names                     Definition                            Attribute /         Element Name                    Child Elements                  Parent Elements         Valid Information in Field         Data Type           Field Length    Echo / Optional/Mandatory/
                                                                                                                Element                                                                                                          (enumeration)                                                   Refresh /   Conditional
                                                                                                                                                                                                                                                                                                   New
 Consumer Data                             ConsumerData                  Tag used to nest all relevant             E             ConsumerInformation        LanguagePreference, BillingCycle,   ChangeConsumerInfoAccept                N/A                        N/A                N/A          N/A    0 or 1 ServiceAddress per
                                                                         Consumer information.                                                                  ServiceClass, RateClass,                                                                                                                  ChangeConsumerInfoAcce
                                                                                                                                                             NewDistributorAccountNumber                                                                                                                               pt

 Consumer Information                      ConsumerInformation           Tag used to nest all relevant             E             ConsumerInformation               LastName, FirstName,         ChangeConsumerInfoAccept                N/A                        N/A                N/A          N/A    0 or 1 ServiceAddress per
                                                                         Consumer information.                                                                           MiddleName,                                                                                                                      ChangeConsumerInfoAcce
                                                                                                                                                                  BillingTelephoneNumber,                                                                                                                              pt
                                                                                                                                                            BillingTelephoneNumberExtension

 Billing Address Formatted                 BillingAddressFormatted       Identifies the billing address of         E            BillingAddressFormatted     AttentionLine, StreetName, Street   ChangeConsumerInfoAccept                N/A                        N/A                N/A          N/A               0 or 1
                                                                         the account                                                                           Number, UnitNumber, City,                                                                                                                 BillingInformationFormatted
                                                                                                                                                                  Province, PostalCode,                                                                                                                  per Change Consumer info
                                                                                                                                                                         CountryCode                                                                                                                                 Accept
 Billing Address Unformatted               BillingAddressUnFormatted     Identifies the billing address of         E           BillingAddressUnFormatted           BillingAddressLine1,         ChangeConsumerInfoAccept                N/A                        N/A                100          N/A               0 or 1
                                                                         the account                                                                               BillingAddressLine2,                                                                                                                  BillingInformationFormatted
                                                                                                                                                                   BillingAddressLine3,                                                                                                                  per Change Consumer info
                                                                                                                                                                   BillingAddressLine4,                                                                                                                              Accept
                                                                                                                                                                    BillingAddressLine5

 Change Information                        ChangeInformation             Tag used to nest detail                                  ChangeInformation          ChangeReason, EffectiveDate        ChangeConsumerInfoAccept    (see Change Information data           N/A                N/A          N/A           1 or more
                                                                         information about the change.                                                                                                                               structure)
 Change Reason                             ChangeReason                  Tag used to describe the                  E                ChangeReason                          N/A                       ChangeInformation                   N/A                    Enumerated:            N/A           E                M
                                                                         reason for the change                                                                                                                                                             (AccountSetupFollowi
                                                                                                                                                                                                                                                                 ngMove,
                                                                                                                                                                                                                                                            AccountSetupROS,
                                                                                                                                                                                                                                                                 Refolio,
                                                                                                                                                                                                                                                             ConsumerMove,
                                                                                                                                                                                                                                                            ConsumerInitiated)
 Effective Date                            EffectiveDate                 Indicates the effective date of           E                 EffectiveDate                        N/A                       ChangeInformation          AccountDoesNotExist,            Enumerated (            8            E                M
                                                                         the Consumers Change takes                                                                                                                               DuplicateTRN             AccountDoesNotExist
                                                                         effect                                                                                                                                                                              | DuplicateTRN )

 Account Information                       AccountInformation            Tag used to hold all the                                 AccountInformation           DistributorAccountNumber,        ChangeConsumerInfoAccept                N/A                        N/A                 10          N/A    1 Account Information per
                                                                         information relevant to an                                                          OldDistributorAccountNumber,                                                                                                                  Change Consumer Info
                                                                         account.                                                                             AccountNumberSwitchDate,                                                                                                                            Accept
                                                                                                                                                            VendorConsumerAccountNumber

 Distributor Account Number                DistributorAccountNumber      The distributor’s Consumer                E           DistributorAccountNumber                   N/A                      AccountInformation                   N/A                       String               30          N/A               M
                                                                         account number as it appears
                                                                         on the bill
 Old Distributor Account Number            OldDistributorAccountNumber   Attribute defining previous               E          OldDistributorAccountNumber                 N/A                      AccountInformation                   N/A                       String               30          N/A               O
                                                                         account number for this
                                                                         Consumer.
 Account Number Switch Date                AccountNumberSwitchDate       Date the account changed from             E           AccountNumberSwitchDate                    N/A                      AccountInformation                   N/A                Date (YYYYMMDD)             8           N/A               O
                                                                         the previous account number to
                                                                         the current account number.

 Vendor Consumer Account Number            VendorConsumerAccountNumb This contains Vendor’s identifier             E         VendorConsumerAccountNumber                  N/A                      AccountInformation                   N/A                       String              100          N/A               O
                                           er                        for the consumer. This value is
                                                                     not validated and is returned in
                                                                     the response document.



 Service Address                           ServiceAddress                This is the container element for                          ServiceAddress                   StreetNumber,              ChangeConsumerInfoAccept                N/A                        N/A                N/A          N/A               M
                                                                         the consumer’s address of                                                          StreetNumberSuffix, StreetName,
                                                                         service (premises address).                                                           StreetType, StreetDirection,
                                                                                                                                                               UnitNumber, UnitType, City,
                                                                                                                                                                  Province, PostalCode

 Street Number                             StreetNumber                  Indicates the service street              E                 StreetNumber                         N/A                        ServiceAddress                     N/A                       String               10           E                O
                                                                         number.
 Street Number Suffix                      StreetNumberSuffix            Indicates the street number for           E              StreetNumberSuffix                      N/A                        ServiceAddress                     N/A                       String               10           E                O
                                                                         the service address.
 Street Name                               StreetName                    Street Number could be Lot and            E                 StreetName                           N/A                        ServiceAddress                     N/A                       String               55           E                M
                                                                         Concession
 Street Type                               StreetType                    Ave, Street, Road                         E                  StreetType                          N/A                        ServiceAddress                     N/A                     String                10            E                O
 Street Direction                          StreetDirection               Lists the consumer’s street               E                StreetDirection                       N/A                        ServiceAddress        N, S, E, W, NW, NE, SW, or SE Enumerated: N | S |          N/A           E                O
                                                                         direction of the service address.                                                                                                                                               E | W | NW | NE |
                                                                                                                                                                                                                                                         SW | SE
 Unit Number                               UnitNumber                    Indicates the unit (apartment)            E                  UnitNumber                          N/A                        ServiceAddress                     N/A                     String                 10           E                O
                                                                         number for the service address.

 Unit Type                                 UnitType                      Indicates the unit type (such as          E                   UnitType                           N/A                        ServiceAddress                     N/A                       String               10           E                O
                                                                         APT, Suite) of the service
                                                                         address.
 City                                      City                          Indicates the city for the service        E                     City                             N/A                        ServiceAddress                     N/A                       String               30           E                M
                                                                         address.
 Province                                  Province                      Indicates the province for the            E                   Province                           N/A                        ServiceAddress                     ON                   Enumerated: ON           N/A           E                M
                                                                         service address.
 Postal code                               PostalCode                    Indicates the zip or postal code          E                  PostalCode                          N/A                        ServiceAddress                     N/A                       String               6            E                O
                                                                         for the service address.

 Consumer Data                             ConsumerData                  Tag used to nest all relevant                              ConsumerData            LanguagePreference, BillingCycle,   ChangeConsumerInfoAccept                N/A                        N/A                N/A          N/A    0 or 1 ContactInformation
                                                                         contact information.                                                                   ServiceClass, RateClass,                                                                                                                 per Change Consumer Info
                                                                                                                                                             NewDistributorAccountNumber

 Language Preference                       LanguagePreference            Attribute which specifies the             E              LanguagePreference                      N/A                        ConsumerData                English or French         Enumerated (English        N/A           E                O
                                                                         language preference for the                                                                                                                                                           | French)
                                                                         Consumer account.
 Billing Cycle                             BillingCycle                  Indicates the billing cycle for the       E                  BillingCycle                        N/A                        ConsumerData                       N/A                       String               2            E                O
                                                                         specified account.




b72c73a4-fb61-43df-9da0-c931ec4059f3.xls                                                                                                                      Page 6 of 11                                                                                                                                                   3/25/2010
                                                                                                      Change Consumer Info Accept Gas Implementation Guide for Ontario v1.1
 Field Display Names                                 XML names                       Definition                            Attribute /         Element Name                      Child Elements                 Parent Elements           Valid Information in Field   Data Type   Field Length    Echo / Optional/Mandatory/
                                                                                                                            Element                                                                                                             (enumeration)                                     Refresh /   Conditional
                                                                                                                                                                                                                                                                                                    New
 Service Class                                       ServiceClass                    Indicates the service class for           E                  ServiceClass                           N/A                       ConsumerData              Enumerated (R | C | I )     String        N/A           E                  O
                                                                                     the specified account.
                                                                                     R=Residential C= Commercial
                                                                                     I= Industrial
 Rate Class                                          RateClass                       Indicates the Primary Rate                E                   RateClass                             N/A                       ConsumerData                      String              String         5            E                  O
                                                                                     class for the specified account.

 New Distributor Account Number                      NewDistributorAccountNumber     Tag used to define the new                E         NewDistributorAccountNumber                     N/A                       ConsumerData                       N/A                String         30           E                  O
                                                                                     account number after a move or
                                                                                     used to identify new account
                                                                                     number after a Refolio based
                                                                                     on change reason.



 Consumer Information                                ConsumerInformation             Tag used to nest all relevant                            ConsumerInformation                 LastName, FirstName,       ChangeConsumerInfoRequest                N/A                 N/A          N/A          N/A            0 or 1
                                                                                     Consumer information.                                                                              MiddleName,                                                                                                        ConsumerInformation per
                                                                                                                                                                                 BillingTelephoneNumber,                                                                                                    Change Consumer Info
                                                                                                                                                                           BillingTelephoneNumberExtension

 Last Name                                           LastName                      Indicates the last name for                 E                   LastName                              N/A                    ConsumerInformation                   N/A                String         20           E                 M
                                                                                   Consumer information,
                                                                                   Consumer information, billing
                                                                                   information, and third party for
                                                                                   copies of bills information.
 First Name                                          FirstName                     Indicates the first name for                E                   FirstName                             N/A                    ConsumerInformation                   N/A                String         20           E                  O
                                                                                   Consumer information,
                                                                                   Consumer information, billing
                                                                                   information, and third party for
                                                                                   copies of bills information.
 Middle Name                                         MiddleName                    Indicates the middle name for               E                  MiddleName                             N/A                    ConsumerInformation                   N/A                String         20           E                  O
                                                                                   Consumer information,
                                                                                   Consumer information, billing
                                                                                   information, and third party for
                                                                                   copies of bills information.
 Billing Telephone Number                            BillingTelephoneNumber        Tag used to contain the billing             E             BillingTelephoneNumber                      N/A                    ConsumerInformation                   N/A               Decimal         10           E                  O
                                                                                   telephone number
 Billing Telephone Number Extension                  BillingTelephoneNumberExtensi Tag used to contain the billing             E         BillingTelephoneNumberExtension                 N/A                    ConsumerInformation                   N/A                String         10           E                  O
                                                     on                            telephone number extension

 Billing Address Formatted                           BillingAddressFormatted         Identifies the billing address of                       BillingAddressFormatted         StreetName, Street Number,      ChangeConsumerInfoAccept                 N/A                 N/A          N/A          N/A   0 or 1 Billing Information per
                                                                                     the account                                                                             UnitNumber, City, Province,                                                                                                    Change Consumer Info
                                                                                                                                                                              PostalCode, CountryCode                                                                                                                  Accept
 Attention Line                                      AttentionLine                   Identifies the name of a person           E                  AttentionLine                         N/A                    BillingAddressFormatted                N/A                String        100          N/A                  O
                                                                                     or Business that the forwarding
                                                                                     billing infromation will be going

 Street Name                                         StreetName                      Service street name or Lot and            E                  StreetName                             N/A                   BillingAddressFormatted                N/A                String         55           E                  O
                                                                                     Concession
 Street Number                                       StreetNumber                    Indicates the billing street              E                 StreetAddress                           N/A                   BillingAddressFormatted                N/A                String         10           E                 M
                                                                                     address.
 Unit Number                                         UnitNumber                      Indicates the unit number for the         E                   UnitNumber                            N/A                   BillingAddressFormatted                N/A                String         10           E                  O
                                                                                     billing address.
 City                                                City                            Indicates the city for the billing        E                      City                               N/A                   BillingAddressFormatted                N/A                String         30           E                  O
                                                                                     address.
 Province                                            Province                        Indicates the state or the                E                    Province                             N/A                   BillingAddressFormatted                ON                 String         20           E                 M
                                                                                     province for the service
                                                                                     address.
 Postal Code                                         PostalCode                      Indicates the zip or postal code          E                   PostalCode                            N/A                   BillingAddressFormatted                N/A               NANANA          6            E                  O
                                                                                     for the billing address.
 Country Code                                        CountryCode                     Indicates the country code for            E                  CountryCode                            N/A                   BillingAddressFormatted                N/A                String         20           E                  O
                                                                                     the billing address. (Suggest
                                                                                     using Canada Posts standard
                                                                                     for Country Code)

 Billing Address Unformatted                         BillingAddressUnFormatted       Identifies the billing address of                      BillingAddressUnFormatted            BillingAddressLine1,        ChangeConsumerInfoAccept                 N/A                 N/A          N/A          N/A   0 or 1 Billing Information per
                                                                                     the account                                                                                 BillingAddressLine2,                                                                                                       Change Consumer Info
                                                                                                                                                                                 BillingAddressLine3,                                                                                                                  Accept
                                                                                                                                                                                 BillingAddressLine4,
                                                                                                                                                                                 BillingAddressLine5
 Billing Address Line 1                              BillingAddressLine1             This contains the first line of the       E               BillingAddressLine1                        N/A                 BillingAddressUnFormatted               N/A                String        100           E                  O
                                                                                     mailing address of the
                                                                                     consumer.
 Billing Address Line 2                              BillingAddressLine2             This contains the second line of          E               BillingAddressLine2                       N/A                  BillingAddressUnFormatted               N/A                String        100           E                  O
                                                                                     the mailing address of the
                                                                                     consumer.
 Billing Address Line 3                              BillingAddressLine3             This contains the third line of the       E               BillingAddressLine3                       N/A                  BillingAddressUnFormatted               N/A                String        100           E                  O
                                                                                     mailing address of the
                                                                                     consumer.
 Billing Address Line 4                              BillingAddressLine4             This contains the fourth line of          E               BillingAddressLine4                       N/A                  BillingAddressUnFormatted               N/A                String        100           E                  O
                                                                                     the mailing address of the
                                                                                     consumer.
 Billing Address Line 5                              BillingAddressLine5             This contains the fourth line of          E               BillingAddressLine5                       N/A                  BillingAddressUnFormatted               N/A                String        100           E                  O
                                                                                     the mailing address of the
                                                                                     consumer.

 Data Type Legend:
 String = Alpha Numeric (Field allows for
 alphabetic values, numeric values, as well as
 any combination of alphabetic and numeric
 values)
 N = Numeric (no decimals)
 D = Decimal with total field length in parenthesis ( )




b72c73a4-fb61-43df-9da0-c931ec4059f3.xls                                                                                                                                     Page 7 of 11                                                                                                                                     3/25/2010
                                                                               Change Consumer Info Accept Gas Implementation Guide for Ontario v1.1
 Field Display Names                                  XML names   Definition           Attribute /   Element Name      Child Elements   Parent Elements   Valid Information in Field   Data Type   Field Length    Echo / Optional/Mandatory/
                                                                                        Element                                                                 (enumeration)                                     Refresh /   Conditional
                                                                                                                                                                                                                    New
    = Illustrates the position of the decimal point
 in reference to the overall length of the field.

 N/A = Not applicable
 Enumerated= The only valid values are listed.

 Date= Date format used.




b72c73a4-fb61-43df-9da0-c931ec4059f3.xls                                                                            Page 8 of 11                                                                                                       3/25/2010
                                                                                                          Change Consumer Info Reject Gas Implementation Guide for Ontario v1.1
         Field Display Names                       XML names                         Definition                           Attribute /          Element Name                     Child Elements                 Parent Elements            Valid Information in Field         Data Type            Field Length    Echo / Optional/Mandatory/Con
                                                                                                                           Element                                                                                                              (enumeration)                                                    Refresh /       ditional
                                                                                                                                                                                                                                                                                                                   New

         PIPE Document                             PIPEDocument                      Document type name, stands for                              PIPEDocument                MarketParticipantDirectory,                N/A                             N/A                       N/A                 N/A          N/A     1 PIPE Document per PIPE
                                                                                     Participant Interface Process for                                                            PIPTransaction                                                                                                                                   Document
                                                                                     Energy.
         XML Name Space                            xmlns                             Uniquely identifies the XML              E                       xmlns                             N/A                       PIPEDocument                          N/A                      String               N/A          N/A                  M
                                                                                     name space.
         XML Name Space Schema Instance            xmlns:xsi                         Defines the schema instance              E                     xmlns:xsi                           N/A                       PIPEDocument                          N/A                      String               N/A          N/A                  M
                                                                                     being used.
         XML Schema Instance location              xsi:schemaLocation                Associates the actual schema             E                xsi:schemaLocation                       N/A                       PIPEDocument                          N/A                      String               N/A          N/A                  M
                                                                                     instance being used to the name
                                                                                     space.
         Version                                   Version                           Identifies the version of the            E                      Version                            N/A                       PIPEDocument                          1.1                 Enumerated (1.1)          N/A          N/A                  M
                                                                                     PIPEDocument schema.
         Document Reference Number                 DocumentReferenceNumber           Uniquely identifies this                 E           DocumentReferenceNumber                       N/A                       PIPEDocument                          N/A                      String                30          N/A                  M
                                                                                     PIPEDocument.
         Creation Date and Time                    CreationDate                      System date and time stamp of            E                   CreationDate                          N/A                       PIPEDocument                          N/A                         Date               19          N/A                  M
                                                                                     when the transaction is                                                                                                                                                                (yyyymmddhhmmssmsst
                                                                                     generated.                                                                                                                                                                                      z)
         Market Participant Directory              MarketParticipantDirectory        Contains tags that define all the        E            MarketParticipantDirectory            Sender, Recipient                PIPEDocument            (see Market Participant Directory         N/A                19          N/A                  M
                                                                                     Market Participants involved in                                                                                                                              data structure)
                                                                                     the particular PIP transaction.

         PIP Transaction                           PIPTransaction                    Indicates the beginning of a PIP         E                  PIPTransaction             ChangeConsumerInfoReject              PIPEDocument              (see PIP Transaction data             N/A                 N/A          N/A               1 or more
                                                                                     transaction.                                                                                                                                                   structure)

         Market Participant Directory              MarketParticipantDirectory        Contains tags that define all the                     MarketParticipantDirectory            Sender, Recipient                PIPEDocument                          N/A                       N/A                 N/A          N/A     1 Market Participant Directory
                                                                                     Market Participants involved in                                                                                                                                                                                                           per PIPE Document
                                                                                     the particular PIP transaction.

         Sender                                    Sender                            Used to identify the sender of the       E                      Sender                      MarketParticipant           MarketParticipantDirectory     (see Sender data structure)           N/A                 N/A          N/A                  M
                                                                                     PIPE document.
         Recipient                                 Recipient                         Used to identify the recipient of        E                     Recipient                    MarketParticipant           MarketParticipantDirectory    (see Recipient data structure)         N/A                 N/A          N/A                  M
                                                                                     the PIPE document.

         Sender                                    Sender                            Used to identify the sender of the                              Sender                      MarketParticipant           MarketParticipantDirectory                 N/A                       N/A                 N/A          N/A    1 Sender per Market Participant
                                                                                     PIPE document.                                                                                                                                                                                                                                 Directory
         Market Participant                        MarketParticipant                 Identifies the Market                    E                 MarketParticipant                CompanyName,                         Sender                (see Market Participant data          N/A                 N/A          N/A                  M
                                                                                     Participants.                                                                           MarketParticipantIdentifier                                            structure)

         Recipient                                 Recipient                         Used to identify the recipient of                              Recipient                    MarketParticipant           MarketParticipantDirectory                 N/A                       N/A                 N/A          N/A        1 Recipient per Market
                                                                                     the PIPE document.                                                                                                                                                                                                                        Participant Directory
         Market Participant                        MarketParticipant                 Identifies the Market                    E                 MarketParticipant                CompanyName,                        Recipient              (see Market Participant data          N/A                 N/A          N/A                  M
                                                                                     Participants.                                                                           MarketParticipantIdentifier                                            structure)

         Market Participant                        MarketParticipant                 Identifies the Market                                      MarketParticipant                CompanyName,                    Recipient, Sender                      N/A                       N/A                 N/A          N/A    1 Market Participant per Sender
                                                                                     Participants.                                                                           MarketParticipantIdentifier                                                                                                                       and 1 per Recipient
         Company Name                              CompanyName                       Tag used to define the name of           E                  CompanyName                           N/A                       MarketParticipant                      N/A                      String               100          N/A                   M
                                                                                     the company a Consumer
                                                                                     already has service with or would
                                                                                     like to establish service with.

         Market Participant Identifier             MarketParticipantIdentifier       Tag used to uniquely identify a          E             MarketParticipantIdentifier                 N/A                      MarketParticipant                     String                    String                10          N/A                  M
                                                                                     company or business.

         PIP Transaction                           PIPTransaction                    Indicates the beginning of a PIP                            PIPTransaction             ChangeConsumerInfoReject              PIPEDocument                          N/A                       N/A                 N/A          N/A    1 or more PIP Transaction per
                                                                                     transaction.                                                                                                                                                                                                                                PIPE Document
         Version                                   Version                           Identifies the version of the PIP        E                      Version                            N/A                             N/A                             N/A                      String                5           N/A                 M
                                                                                     Document schema.
         Transaction Reference Number              TransactionReferenceNumber        Uniquely identifies this PIP             E           TransactionReferenceNumber                    N/A                             N/A                             N/A                      String                30          N/A                  M
                                                                                     transaction.
         Change Consumer Info Reject (purpose of   ChangeConsumerInfoReject          Tag used to nest information             E            ChangeConsumerInfoReject       OriginalTransactionReferenceNum         PIPTransaction           (see Change Consumer Info              N/A                  5           N/A                  M
         transaction)                                                                about a change Consumer Info                                                               ber, RejectInformation,                                       Reject data structure)
                                                                                     Reject.                                                                                      ChangeInformation,
                                                                                                                                                                                  AccountInformation,
                                                                                                                                                                           ServiceAddress, ConsumerData,
                                                                                                                                                                                ConsumerInformation,
                                                                                                                                                                               BillingAddressFormatted,
                                                                                                                                                                             BillingAddressUnFormatted

         Change Consumer Info Reject               ChangeConsumerInfoReject          Tag used to nest information                          ChangeConsumerInfoReject     OriginalTransactionReferenceNum           PIPTransaction                        N/A                       N/A                 N/A          N/A   1 Change Consumer Info Reject
                                                                                     about a change Consumer Info                                                             ber, RejectInformation,                                                                                                                         per PIP Transaction
                                                                                     Reject.                                                                                    ChangeInformation,
                                                                                                                                                                                AccountInformation,
                                                                                                                                                                         ServiceAddress, ConsumerData,
                                                                                                                                                                              ConsumerInformation,
                                                                                                                                                                             BillingAddressFormatted,
                                                                                                                                                                           BillingAddressUnFormatted
         Original Transaction Reference Number     OriginalTransactionReferenceNum Attribute that references the              E         OriginalTransactionReferenceNum                 N/A                             N/A                             N/A                      String                30          N/A                  M
                                                   ber                             original Change Consumer Info                        ber
                                                                                   Request transaction.
         Reject Information                        RejectInformation               Tag used to nest relevant reject           E                 RejectInformation                 ChangeReason              ChangeConsumerInfoReject                    N/A                       N/A                 N/A          N/A                  M
                                                                                   information for the account.

         Change Information                        ChangeInformation                 Tag used to nest detail                  E                ChangeInformation            ChangeReason, EffectiveDate     ChangeConsumerInfoRequest      (see Change Information data           N/A                 N/A          N/A                  M
                                                                                     information about the change.                                                                                                                                  structure)
         Account Information                       AccountInformation                Tag used to hold all the                 E                AccountInformation            DistributorAccountNumber,      ChangeConsumerInfoReject       (see Account Information data          N/A                 N/A          N/A                  M
                                                                                     information relevant to an                                                            OldDistributorAccountNumber,                                             structure)
                                                                                     account.                                                                               AccountNumberSwitchDate,
                                                                                                                                                                          VendorConsumerAccountNumber

         Service Address                           ServiceAddress                    This is the container element for        E                  ServiceAddress                    StreetNumber,            ChangeConsumerInfoReject                    N/A                       N/A                 N/A          N/A      0 or 1 ServiceAddress per
                                                                                     the consumer’s address of                                                            StreetNumberSuffix, StreetName,                                                                                                                  ChangeConsumerInfoReject
                                                                                     service (premises address).                                                             StreetType, StreetDirection,
                                                                                                                                                                             UnitNumber, UnitType, City,
                                                                                                                                                                                Province, PostalCode




b72c73a4-fb61-43df-9da0-c931ec4059f3.xls                                                                                                                                      Page 9 of 11                                                                                                                                                                  3/25/2010
                                                                                              Change Consumer Info Reject Gas Implementation Guide for Ontario v1.1
         Field Display Names               XML names                     Definition                            Attribute /        Element Name                    Child Elements                    Parent Elements            Valid Information in Field           Data Type           Field Length    Echo / Optional/Mandatory/Con
                                                                                                                Element                                                                                                              (enumeration)                                                     Refresh /       ditional
                                                                                                                                                                                                                                                                                                         New
         Consumer Data                     ConsumerData                  Tag used to nest all relevant             E             ConsumerInformation        LanguagePreference, BillingCycle,    ChangeConsumerInfoReject                   N/A                         N/A                 N/A          N/A      0 or 1 ServiceAddress per
                                                                         Consumer information.                                                                  ServiceClass, RateClass,                                                                                                                         ChangeConsumerInfoReject
                                                                                                                                                             NewDistributorAccountNumber

         Consumer Information              ConsumerInformation           Tag used to nest all relevant             E             ConsumerInformation               LastName, FirstName,          ChangeConsumerInfoReject                   N/A                         N/A                 N/A          N/A      0 or 1 ServiceAddress per
                                                                         Consumer information.                                                                           MiddleName,                                                                                                                             ChangeConsumerInfoReject
                                                                                                                                                                  BillingTelephoneNumber,
                                                                                                                                                            BillingTelephoneNumberExtension

         Billing Address Formatted         BillingAddressFormatted       Identifies the billing address of         E            BillingAddressFormatted     AttentionLine, StreetName, Street    ChangeConsumerInfoReject                   N/A                         N/A                 N/A          N/A                 0 or 1
                                                                         the account                                                                           Number, UnitNumber, City,                                                                                                                        BillingInformationFormatted per
                                                                                                                                                                  Province, PostalCode,                                                                                                                         Change Consumer info Reject
                                                                                                                                                                        CountryCode
         Billing Address Unformatted       BillingAddressUnFormatted     Identifies the billing address of         E           BillingAddressUnFormatted           BillingAddressLine1,          ChangeConsumerInfoReject                   N/A                         N/A                 100          N/A                 0 or 1
                                                                         the account                                                                               BillingAddressLine2,                                                                                                                         BillingInformationFormatted per
                                                                                                                                                                   BillingAddressLine3,                                                                                                                         Change Consumer info Reject
                                                                                                                                                                   BillingAddressLine4,
                                                                                                                                                                   BillingAddressLine5

         Reject Information                RejectInformation             Tag used to nest relevant reject                          RejectInformation                 RejectReason               ChangeConsumerLocationReject                N/A                         N/A                 N/A          N/A   1 or more Reject Information per
                                                                         information for the account.                                                                                                                                                                                                          Enrol Reject

         Reject Reason                     RejectReason                  Indicates the reason for the              E                 RejectReason                         N/A                         RejectInformation            AccountDoesNotExist,            Enumerated (             N/A           E                   M
                                                                         Change Consumer Location                                                                                                                                     DuplicateTRN             AccountDoesNotExist |
                                                                         Reject                                                                                                                                                                                   DuplicateTRN )

         Change Information                ChangeInformation             Tag used to nest detail                                   ChangeInformation          ChangeReason, EffectiveDate        ChangeConsumerInfoReject       (see Change Information data            N/A                 N/A          N/A              1 or more
                                                                         information about the change.                                                                                                                                   structure)
         Change Reason                     ChangeReason                  Tag used to describe the reason           E                ChangeReason                          N/A                        ChangeInformation                      N/A                     Enumerated:             N/A           E                   M
                                                                         for the change                                                                                                                                                                        (AccountSetupFollowing
                                                                                                                                                                                                                                                               Move,AccountSetupRO
                                                                                                                                                                                                                                                                     S, Refolio,
                                                                                                                                                                                                                                                                  ConsumerMove,
                                                                                                                                                                                                                                                                 ConsumerInitiated)
         Effective Date                    EffectiveDate                 Indicates the effective date of the       E                 EffectiveDate                        N/A                        ChangeInformation                      N/A                   Date (yyyymmdd)            8            E                   M
                                                                         Consumers Change takes effect



         Account Information               AccountInformation            Tag used to hold all the                                 AccountInformation           DistributorAccountNumber,         ChangeConsumerInfoReject                   N/A                         N/A                  10          N/A     1 Account Information per
                                                                         information relevant to an                                                          OldDistributorAccountNumber,                                                                                                                       Change Consumer Info Reject
                                                                         account.                                                                             AccountNumberSwitchDate,
                                                                                                                                                            VendorConsumerAccountNumber

         Distributor Account Number        DistributorAccountNumber      The distributor’s Consumer                E           DistributorAccountNumber                   N/A                        AccountInformation                     N/A                        String                30           E                   M
                                                                         account number as it appears on
                                                                         the bill
         Old Distributor Account Number    OldDistributorAccountNumber   Attribute defining previous               E          OldDistributorAccountNumber                 N/A                        AccountInformation                     N/A                        String                30           E                   O
                                                                         account number for this
                                                                         Consumer.
         Account Number Switch Date        AccountNumberSwitchDate       Date the account changed from             E           AccountNumberSwitchDate                    N/A                        AccountInformation                     N/A                 Date (YYYYMMDD)              8            E                   O
                                                                         the previous account number to
                                                                         the current account number.

         Vendor Consumer Account Number    VendorConsumerAccountNumber   This contains Vendor’s identifier         E         VendorConsumerAccountNumber                  N/A                        AccountInformation                     N/A                        String               100           E                   O
                                                                         for the consumer. This value is
                                                                         not validated and is returned in
                                                                         the response document.



         Service Address                   ServiceAddress                This is the container element for                          ServiceAddress                   StreetNumber,                   AccountInformation                     N/A                         N/A                 N/A          N/A                  M
                                                                         the consumer’s address of                                                          StreetNumberSuffix, StreetName,
                                                                         service (premises address).                                                           StreetType, StreetDirection,
                                                                                                                                                               UnitNumber, UnitType, City,
                                                                                                                                                                  Province, PostalCode

         Street Number                     StreetNumber                  Indicates the service street              E                 StreetNumber                         N/A                          ServiceAddress                       N/A                        String                10           E                   O
                                                                         number.
         Street Number Suffix              StreetNumberSuffix            Indicates the street number for           E              StreetNumberSuffix                      N/A                          ServiceAddress                       N/A                        String                10           E                   O
                                                                         the service address.
         Street Name                       StreetName                    Street Number could be Lot and            E                  StreetName                          N/A                          ServiceAddress                       N/A                        String                55           E                   M
                                                                         Concession
         Street Type                       StreetType                    Ave, Street, Road                         E                  StreetType                          N/A                          ServiceAddress                       N/A                      String                 10            E                   O
         Street Direction                  StreetDirection               Lists the consumer’s street               E                StreetDirection                       N/A                          ServiceAddress          N, S, E, W, NW, NE, SW, or SE Enumerated: N | S | E          N/A           E                   O
                                                                         direction of the service address.                                                                                                                                                   | W | NW | NE | SW |
                                                                                                                                                                                                                                                             SE
         Unit Number                       UnitNumber                    Indicates the unit (apartment)            E                  UnitNumber                          N/A                          ServiceAddress                       N/A                      String                  10           E                   O
                                                                         number for the service address.

         Unit Type                         UnitType                      Indicates the unit type (such as          E                   UnitType                           N/A                          ServiceAddress                       N/A                        String                10           E                   O
                                                                         APT, Suite) of the service
                                                                         address.
         City                              City                          Indicates the city for the service        E                     City                             N/A                          ServiceAddress                       N/A                        String                30           E                   M
                                                                         address.
         Province                          Province                      Indicates the province for the            E                   Province                           N/A                          ServiceAddress                       ON                    Enumerated: ON            N/A           E                   M
                                                                         service address.
         Postal code                       PostalCode                    Indicates the zip or postal code          E                  PostalCode                          N/A                          ServiceAddress                       N/A                        String                6            E                   O
                                                                         for the service address.

         Consumer Data                     ConsumerData                  Tag used to nest all relevant                              ConsumerData            FullName, LastName, FirstName,           AccountInformation                     N/A                         N/A                 N/A          N/A    0 or 1 ContactInformation per
                                                                         contact information.                                                               MiddleName, TelephoneNumber,                                                                                                                           Change Consumer Info
                                                                                                                                                                  Email, FaxNumber

         Language Preference               LanguagePreference            Attribute which specifies the             E              LanguagePreference                      N/A                        AccountInformation              English or French         Enumerated (English |        N/A           E                   O
                                                                         language preference for the                                                                                                                                                                French)
                                                                         Consumer account.




b72c73a4-fb61-43df-9da0-c931ec4059f3.xls                                                                                                                        Page 10 of 11                                                                                                                                                                     3/25/2010
                                                                                                                     Change Consumer Info Reject Gas Implementation Guide for Ontario v1.1
         Field Display Names                                  XML names                         Definition                            Attribute /         Element Name                      Child Elements                 Parent Elements           Valid Information in Field    Data Type   Field Length    Echo / Optional/Mandatory/Con
                                                                                                                                       Element                                                                                                             (enumeration)                                      Refresh /       ditional
                                                                                                                                                                                                                                                                                                                New
         Billing Cycle                                        BillingCycle                      Indicates the billing cycle for the       E                   BillingCycle                          N/A                     AccountInformation                    N/A                String         2            E                   O
                                                                                                specified account.
         Service Class                                        ServiceClass                      Indicates the service class for           E                  ServiceClass                           N/A                     AccountInformation           Enumerated (R | C | I )      N/A          N/A           E                   O
                                                                                                the specified account.
                                                                                                R=Residential C= Commercial I=
                                                                                                Industrial
         Rate Class                                           RateClass                         Indicates the Primary Rate class          E                   RateClass                             N/A                     AccountInformation                   String                5            5            E                   O
                                                                                                for the specified account.

         New Distributor Account Number                       NewDistributorAccountNumber       Tag used to define the new                E         NewDistributorAccountNumber                     N/A                     AccountInformation                    N/A                String         30           E                   O
                                                                                                account number after a move or
                                                                                                used to identify new account
                                                                                                number after a Refolio based on
                                                                                                change reason.



         Consumer Information                                 ConsumerInformation               Tag used to nest all relevant                            ConsumerInformation                 LastName, FirstName,       ChangeConsumerInfoRequest                 N/A                 N/A          N/A          N/A   0 or 1 ConsumerInformation per
                                                                                                Consumer information.                                                                              MiddleName,                                                                                                             Change Consumer Info
                                                                                                                                                                                            BillingTelephoneNumber,
                                                                                                                                                                                      BillingTelephoneNumberExtension

         Last Name                                            LastName                          Indicates the last name for               E                   LastName                              N/A                    ConsumerInformation                    N/A                String         20           E                   M
                                                                                                Consumer information,
                                                                                                Consumer information, billing
                                                                                                information, and third party for
                                                                                                copies of bills information.
         First Name                                           FirstName                         Indicates the first name for              E                   FirstName                             N/A                    ConsumerInformation                    N/A                String         20           E                   O
                                                                                                Consumer information,
                                                                                                Consumer information, billing
                                                                                                information, and third party for
                                                                                                copies of bills information.
         Middle Name                                          MiddleName                        Indicates the middle name for             E                  MiddleName                             N/A                    ConsumerInformation                    N/A                String         20           E                   O
                                                                                                Consumer information,
                                                                                                Consumer information, billing
                                                                                                information, and third party for
                                                                                                copies of bills information.
         Billing Telephone Number                             BillingTelephoneNumber            Tag used to contain the billing           E             BillingTelephoneNumber                      N/A                    ConsumerInformation                    N/A               Decimal         10           E                   O
                                                                                                telephone number
         Billing Telephone Number Extension                   BillingTelephoneNumberExtension   Tag used to contain the billing           E         BillingTelephoneNumberExtension                 N/A                    ConsumerInformation                    N/A                String         10           E                   O
                                                                                                telephone number extension

         Billing Address Formatted                            BillingAddressFormatted           Identifies the billing address of                       BillingAddressFormatted         StreetName, Street Number,          AccountInformation                    N/A                 N/A          N/A          N/A     0 or 1 Billing Information per
                                                                                                the account                                                                             UnitNumber, City, Province,                                                                                                    Change Consumer Info Reject
                                                                                                                                                                                         PostalCode, CountryCode
         Attention Line                                       AttentionLine                     Identifies the name of a person           E                  AttentionLine                         N/A                    BillingAddressFormatted                 N/A                String        100           E                   O
                                                                                                or Business that the forwarding
                                                                                                billing infromation will be going

         Street Name                                          StreetName                        Service street name or Lot and            E                   StreetName                            N/A                   BillingAddressFormatted                 N/A                String         55           E                   O
                                                                                                Concession
         Street Number                                        StreetNumber                      Indicates the billing street              E                  StreetAddress                          N/A                   BillingAddressFormatted                 N/A                String         10           E                   M
                                                                                                address.
         Unit Number                                          UnitNumber                        Indicates the unit number for the         E                   UnitNumber                            N/A                   BillingAddressFormatted                 N/A                String         10           E                   O
                                                                                                billing address.
         City                                                 City                              Indicates the city for the billing        E                      City                               N/A                   BillingAddressFormatted                 N/A                String         30           E                   O
                                                                                                address.
         Province                                             Province                          Indicates the state or the                E                    Province                             N/A                   BillingAddressFormatted                 ON                 String         20           E                   M
                                                                                                province for the service address.

         Postal Code                                          PostalCode                        Indicates the zip or postal code          E                   PostalCode                            N/A                   BillingAddressFormatted                 N/A               NANANA          6            E                   O
                                                                                                for the billing address.
         Country Code                                         CountryCode                       Indicates the country code for            E                  CountryCode                            N/A                   BillingAddressFormatted                 N/A                String         20           E                   O
                                                                                                the billing address. (Suggest
                                                                                                using Canada Posts standard for
                                                                                                Country Code)

         Billing Address Unformatted                          BillingAddressUnFormatted         Identifies the billing address of                      BillingAddressUnFormatted            BillingAddressLine1,            AccountInformation                    N/A                 N/A          N/A          N/A     0 or 1 Billing Information per
                                                                                                the account                                                                                 BillingAddressLine2,                                                                                                       Change Consumer Info Reject
                                                                                                                                                                                            BillingAddressLine3,
                                                                                                                                                                                            BillingAddressLine4,
                                                                                                                                                                                            BillingAddressLine5
         Billing Address Line 1                               BillingAddressLine1               This contains the first line of the       E               BillingAddressLine1                        N/A                 BillingAddressUnFormatted                N/A                String        100           E                   O
                                                                                                mailing address of the
                                                                                                consumer.
         Billing Address Line 2                               BillingAddressLine2               This contains the second line of          E               BillingAddressLine2                       N/A                  BillingAddressUnFormatted                N/A                String        100           E                   O
                                                                                                the mailing address of the
                                                                                                consumer.
         Billing Address Line 3                               BillingAddressLine3               This contains the third line of the       E               BillingAddressLine3                       N/A                  BillingAddressUnFormatted                N/A                String        100           E                   O
                                                                                                mailing address of the
                                                                                                consumer.
         Billing Address Line 4                               BillingAddressLine4               This contains the fourth line of          E               BillingAddressLine4                       N/A                  BillingAddressUnFormatted                N/A                String        100           E                   O
                                                                                                the mailing address of the
                                                                                                consumer.
         Billing Address Line 5                               BillingAddressLine5               This contains the fourth line of          E               BillingAddressLine5                       N/A                  BillingAddressUnFormatted                N/A                String        100           E                   O
                                                                                                the mailing address of the
                                                                                                consumer.

         Data Type Legend:
         String = Alpha Numeric (Field allows for
         alphabetic values, numeric values, as well as any
         combination of alphabetic and numeric values)

         N = Numeric (no decimals)
         D = Decimal with total field length in parenthesis ( )
            = Illustrates the position of the decimal point in
         reference to the overall length of the field.

         N/A = Not applicable
         Enumerated= The only valid values are listed.

         Date= Date format used.




b72c73a4-fb61-43df-9da0-c931ec4059f3.xls                                                                                                                                                  Page 11 of 11                                                                                                                                                  3/25/2010

								
To top