Transaction Set The N1 loop is used to identify the transaction sender and receiver. Data Dictionary for Generation Services (LIN05=CE) Generation Services (CE) Request and Response Data Dictionary Appl Field Field Name Description EDI Segment / Related EDI Qualifier Data Type 1 Transaction Set Purpose Code Request = 13 Response = 11 BGN01 X(2) 2 Transaction Reference Number A unique transaction identification number assigned by the originator of this transaction. This number must be unique over time. BGN02 X(30) 3 System Date Date that the data was processed by the sender’s application system. 9(8) 4 Original Transaction Reference Number Transaction Reference Number echoed from the Original Request Transaction X(30) 5 LDC Name LDC’s Name N102 N1: N101 = 8S X(60) 6 LDC Duns LDC’s DUNS Number or DUNS+4 Number N104 N1: N101 = 8S N103 = 1 or 9 N106 = 40 or 41 X(13) 7 ESP Name ESP’s Name N102 N1: N101 = SJ X(60) 8 ESP Duns ESP’s DUNS Number or DUNS+4 Number N104 N1: N101 = SJ N103 = 1 or 9 N106 = 40 or 41 X(13) 8.1 Renewable Energy Provider Name Renewable Energy Provider 's Name N102 N1: N101 = G7 X(60) 8.2 Renewable Energy Provider Duns Renewable Energy Provider 's DUNS Number or DUNS+4 Number N104 N1: N101 = G7 N103 = 1 or 9 N106 = 40 or 41 X(13) 9 Customer Name Customer Name as it appears on the Customer’s Bill N102 N1: N101 = 8R X(35) Note: X(60) for MD 10 Customer Reference Number A reference number assigned by and meaningful to the customer. An example would be Store number N104 N1: N101 = 8R N103 = 1 or 9 X(30) 11 Service Address Customer Service Address N301 & N302 N1: N101 = 8R X(55) 12 City Customer Service Address N401 N1: N101 = 8R X(30)
77 Loss Factor Loss factor REF02 X(30) 78 Profile Group A code for the Load Profile used for this customer. Differs by LDC. Codes posted on LDC’s Web site. REF02 NM1: REF01= LO X(30) 79 LDC Rate Code Code indicating the rate a customer is being charged by LDC per tariff. Codes posted on LDC’s Web site REF02 NM1: REF01= NH X(30) 80 LDC Rate Subclass Code Used to provide further classification of a rate. NM1: REF01= PR X(30) 81 ESP Rate Code ESP rate code for customer NM1: REF01= RB X(30) 82 Service Voltage Service voltage REF02 X(30) 83 LDC Meter Cycle LDC Cycle on which the meter will be read NM1: REF01= TZ X(2) 84 Meter Type Type of Meter REF02 NM1: REF01= MT X(5) 85 Meter Type Additional Information Additional information for the type REF03 NM1: REF01= MT X(80) The following three fields each require that the Meter Type be shown in REF03: 86 Constant/Meter Multiplier Some factor multiplied by the meter reading to give billed usage. NM1: 4P = Meter Type (See REF*MT) 9(9).99 87 Number of Dials / Digits and related decimal positions Needed to determine usage if meter reading rolls over during the billing period. Number of dials on the meter displayed as the number of dials to the left of the decimal, a decimal point, and number of dials to the right of the decimal. REF02 NM1: REF01= IX REF03 = Meter Type (See REF*MT) 9.9 88 Type of metering used for billing Indicates the type of metering information that will be sent on the 867 transaction. REF02= 41 (on peak) or 42 (off peak) 43 (intermediate) or 51 (totalizer) NM1: REF01 = TU REF03 = Meter Type (See REF*MT) X(2) Data Dictionary for Historical Usage Requests (LIN05=HU, HI) Request for Historical Usage (HU) Request and Response Data Dictionary Appl Field Field Name Description EDI Segment / Related EDI Qualifier Data Type 1 Transaction Set Purpose Code Request = 13 Response = 11 X(2) SV
MD ONLY 9.13 Billing Telephone # Contact Telephone Number related to this billing address PER04 N1: N101 = BT PER01 = IC PER03 = TE MD ONLY X(10) 10 Line Item Transaction Reference Number Unique Tracking Number for each line item in this transaction. This number must be unique over time. LIN01 X(20) 11 Historical Usage Indicates an ESP request to obtain historical information for this customer. Historical Usage will be returned on an EDI 867 transaction. LIN05 = HU or HI or HG LIN02 = SH LIN03 = EL LIN04 = SH X(2) 12 Action Code Indicates that the transaction is a request, or whether this transaction has been accepted or rejected. ASI01= Request: 7 Accept Response: WQ Reject Response: U LIN: ASI02= 029 X(2) 13 Rejection Reason Code Code explaining reason for rejection. LIN: REF01= 7G X(3) 14 Rejection Reason Text Text explaining rejection. REF03 LIN: REF01= 7G X(80) 15 Status Reason Code Code to provide status information for a secondary service. REF02 LIN: REF01= 1P X(3) 16 Status Reason Text Text to provide status information. LIN: REF01= 1P X(80) 17 ESP Account Number ESP Customer Account Number REF02 LIN: REF01= 11 X(30) 18 LDC Account Number LDC Customer Account Number REF02 LIN: REF01= 12 X(30) 19 Old Account Number Previous LDC Customer Account Number REF02 LIN: REF01= 45 X(30) Data Dictionary for Summary Interval Request for Summary Interval Information (SI) Request and Response Data Dictionary Appl Field Field Name Description EDI Segment / Related EDI Qualifier Data Type 1 Transaction Set Purpose Code Request = 13 Response = 11 BGN01 X(2) 2 Transaction Reference Number A unique transaction identification number assigned by the originator of this transaction. This number must be unique over time. BGN02 X(30) 3 System Date Date that the data was processed by the sender’s application system. BGN03 9(8)
Consultant managing the aggregation. Segment: REF Reference Identification (PC=Bill Calculator) Position: 030 : LIN Level: Detail Usage: Optional Max Use: >1 Purpose: To specify identifying information Syntax Notes: 1 At least one of REF02 or REF03 is required. 2 If either C04003 or C04004 is present, then the is required. 3 If either C04005 or C04006 is present, then the other is required. Semantic REF04 contains data relating to the value cited in REF02. Comments: PA Use: CE Request: CE Accept Response: CE Reject Response: All other Requests: All Accept Responses: All Reject Responses: Required Required Return on the response if it was provided on the request Not Used Not Used Not Used NJ Use: Same as PA DE Use: Same as PA MD Use: Same as PA Example: REF*PC*LDC Data Element Summary Ref. Data Des. Element Name X12 Attributes Must Use REF01 128 Reference Identification Qualifier M ID 2/3 Code qualifying the Reference Identification PC Production Code Identifies the party that is to calculate the charges on the bill. Must Use REF02 127 Reference Identification X AN 1/30 Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier When REF01 is PC, valid values for REF02 are: LDC - The LDC calculates the charges on the bill (Rate DUAL - Each party calculates its portion of the bill (Dual or Bill Ready) IF … THEN… Bills the Calculates Billing Calc. Party Customer LDC Portion ESP Portion REF*BLT REF*PC LDC LDC LDC LDC LDC LDC LDC ESP LDC DUAL ESP LDC ESP ESP DUAL DUAL LDC ESP DUAL DUAL
Segment: AMT Monetary Amount (5J=Load Management Device – Air Conditioner) Position: 060 : LIN Level: Detail Usage: Optional Max Use: >1 Purpose: To indicate the monetary amount Syntax Notes: Semantic Notes: Comments: PA Use: Not Used NJ Use: Not Used DE Use: Same as MD Use: This field is used on an enrollment response to indicate this account has some air conditioners that are part of the load management program. Note: If account does not have any air conditioners on the load management program, this segment will not be sent. All Requests: Not Used CE Accept Response: Required if are any air conditioners on the account that are part of the load management program All other Accept Responses: Not Used All Reject Responses: Not Used Examples: AMT*5J*2 (Indicates there are two air conditioners on account in load management program) Data Element Summary Ref. Data Des. Element Name X12 Attributes Must Use AMT01 522 Amount Qualifier Code M ID 1/3 Code to qualify amount 5J Equipment Air conditioners that are part of load management program Must Use AMT02 782 Monetary Amount M R 1/18 Monetary amount Whole number that indicates number of devices that are part of load management program. Segment: AMT Monetary Amount (L0=Load Management Device – Water Heater) Position: 060 : LIN Level: Detail Usage: Optional Max Use: >1 Purpose: To indicate the total monetary amount Syntax Notes: Semantic Notes: Comments: PA Use: Not Used NJ Use: Not Used DE Use: Same as MD Use: This field is used on an enrollment response to indicate this account has some water heaters
Segment: REF Reference Identification (LO=Load Profile) Position: 130 : NM1 Level: Detail Usage: Optional Max Use: >1 Purpose: To specify identifying information Syntax Notes: 1 At least one of REF02 or REF03 is required. 2 If either C04003 or C04004 is present, then the other is required. 3 If either C04005 or C04006 is present, then the other is required. Semantic Notes: 1 REF04 contains data relating to the value cited in REF02. Comments: PA Use: Request: CE Accept Response: All other Accept Responses: Reject Response: Not Used Required for each non-interval meter that is used for billing purposes. This segment must also be sent when account has UNMETERED services available for generation service. If a Load Profile does not exist for this customer, this segment will not be sent. Not Used Not Used NJ Use: Same as PA DE Use: Same as PA MD Use: Same as PA Example: REF*LO*GS Data Element Summary Ref. Data Des. Element Name X12 Attributes Must Use REF01 128 Reference Identification Qualifier M ID 2/3 Code qualifying the Reference Identification LO Load Planning Number Load profile Must Use 127 Reference Identification X AN 1/30 Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier Segment: REF Reference Identification (NH=LDC Rate Class) Position: 130 : NM1 Level: Detail Usage: Optional Max Use: >1 Purpose: To specify identifying information Syntax Notes: 1 At least one of REF02 or REF03 is required. 2 If either C04003 or C04004 is present, then the other is required.