Customer and Premise Data Extracts: Business Objects and Algorithms

The maintenance object audit algorithms create data synchronization requests in the following manner:

  • If the Generic Change Data Capture (F1-GCHG-CDCP) algorithm type (provided in the base package) is used, the synchronization requests are based on the Sync Request BO maintenance object options.

  • Alternatively, if the base package supplied Maintenance Object – Audit algorithm types, which are outlined in the Customer and Premise Data Extracts: Maintenance Object Audit Algorithms section are used, the synchronization requests are based on the Sync Request BO defined in the algorithm parameters.

Customer Data

Extraction of customer data, including account, service agreement, and person information, is supported by the following data synchronization business objects.

  • Current DataConnect

    • Customer Data Extract for DataConnect (C1-ExternalRepoPlusCusDataSync): used to extract service agreement / account / person related information. This business object should be defined as a value for the Sync Request BO option on the Service Agreement maintenance object.

    • SA/SP Data Extract for DataConnect (C1-ExternalRepoPlusSASPSync): used to extract service agreement service point information. This business object should be defined as a value for the Sync Request BO option on the Service Agreement maintenance object.

    • Mailing Address Data for DataConnect (C1-ExternalRepoPlusMailAddSync): used to extract mailing address information. This business object should be defined as a value for the "Sync Request BO" options on the Person maintenance object.

    • SP/Meter Sync for DataConnect (D1-ExternalRepositorySPMtrSync): used to extract service point and meter information. This business object should be defined as a value for the "Sync Request BO" options on the Service Point, Device Configuration, and Device maintenance objects.

  • Legacy DataConnect

    • SA/Account/Person Sync for Legacy DataConnect (C1-ExternalRepoSASync): used to extract service agreement / account / person related information. This business object should be defined as a value for the Sync Request BO option on the Service Agreement maintenance object. (Used with v1)

    • SP Sync for Legacy DataConnect (D1-ExternalRepositorySPSync): used to extract service point information. This business object should be defined as a value for the "Sync Request BO" options on the Service Point maintenance object. (Used with v1)

    • Install Event Sync for Legacy DataConnect (D1-ExternalRepositoryIESync): used to extract install event information. This business object should be defined as a value for the "Sync Request BO" options on the Install Event maintenance object. (Used with v1)

These business objects use the following Pre-Processing algorithms to take initial data snapshots, and define the batch control used to extract data and export to a flat file:

  • Current DataConnect

    • Capture Customer Data's Initial Snapshot for DataConnect(C1-CEXTRCSAD)

    • Capture SA/SP Data's Initial Snapshot (C1CAPSASPI)

    • Capture Mailing Address Data Initial Snapshot (C1CAPMLADDI)

  • Legacy DataConnect

    • Capture SP/Meter Initial Snapshot for Legacy DataConnect (D1-SPMINISNP)

    • Capture SP Initial Snapshot for Legacy DataConnect (D1-SPEINISNP)

    • Capture SA-Based Initial Snapshot for Legacy DataConnect (C1-CEXTRCSAI)

    • Capture Install Event Initial Snapshot for Legacy DataConnect (D1-IEEINISNP)

These algorithms specify the batch control used for the extract process (see below).

The Sync Request Monitor batch control (F1-SYNRQ) monitors synchronization requests in the Pending state and executes Monitor algorithms that check for other pending related synchronization requests, and, if none, transitions them to the Determine if Sync Needed state.

Enter algorithms on the Determine If Sync Needed states verify if a synchronization is needed by capturing the final snapshot of the data and comparing it against the initial snapshot. If changes are detected, the final snapshots of the data are stamped on the synchronization requests for export.

  • Current DataConnect

    • Capture SA-Based Final Snapshot for DataConnect(C1-CEXTRPSAF)

    • Capture SA/SP Data's Final Snapshot (C1CAPSASPF)

    • Capture Mailing Address Data’s Final Snapshot (C1CAPMLADDF)

    • Capture SP and Meter Data's Final Snapshot for DataConnect (C1-CEXTRSPMF)

    • Capture SP/Meter Final Snapshot for DataConnect (D1-SPMFINSNP)

  • Legacy DataConnect

    • Capture SA-Based Final Snapshot for Legacy DataConnect (C1-CEXTRCSAF)

The Prepare Delimited Extract Data (Ignore Custom Sync Records) Enter algorithm (C1-PRPEXDNCU/C1-PRTBDEXDT) or the Prepare Delimited Extract Data Enter algorithm (D1-PRPEXTDTA) on the Send Request state prepares and formats the data for extraction, and creates a general process record for the synchronization request (based on the batch control defined by the pre-processing algorithm).

Premise Data

Extraction of premise data, including premise, service point, device installation, device, and measuring component informatiob, is supported by the following data synchronization business objects.

  • SP/Meter Sync for DataConnect (D1-ExternalRepositorySPMtrSync): used to extract service point and device related information. This business object should be defined as a value for the Sync Request BO option on the Service Point, Device Configuration, and Device maintenance objects.

These business objects use the following Pre-Processing algorithms to take initial data snapshots, and define the batch control used to extract data and export to a flat file:

  • Capture SP/Meter Initial Snapshot for Legacy DataConnect (D1-SPMINISNP)

These algorithms specify the batch control used for the extract process (see below).

The Sync Request Monitor batch control (F1-SYNRQ) monitors synchronization requests in the Pending state and executes Monitor algorithms that check for other pending related synchronization requests, and, if none, transitions them to the Determine if Sync Needed state.

Enter algorithms on the Determine If Sync Needed states verify if a synchronization is needed by capturing the final snapshot of the data and comparing it against the initial snapshot. If changes are detected, the final snapshots of the data are stamped on the synchronization requests for export.

  • Capture SP/Meter Final Snapshot for DataConnect (D1-SPMFINSNP)

The Prepare Delimited Extract Data (Ignore Custom Sync Records) Enter algorithm (C1-PRPEXDNCU/C1-PRTBDEXDT) or the Prepare Delimited Extract Data Enter algorithm (D1-PRPEXTDTA) on the Send Request state prepares and formats the data for extraction, and creates a general process record for the synchronization request (based on the batch control defined by the pre-processing algorithm).