Billing Data Extracts: Business Objects and Algorithms

Billing generates synchronization requests when bills complete through a Customer Class – Post Bill Completion algorithm. The Change Data Capture of Billing Data for DataConnect (C1-CAPBILLEX) algorithm type provided in the base package can be used to create a Customer Class – Post Bill Completion algorithm that creates a billing synchronization request record for each of the bill’s bill segments if one does not exist in the initial state.

Billing related information extracts are supported by the following data synchronization business objects.

  • Current DataConnect

    • Bill Sync for DataConnect (C1-ExternalRepoPlusBillSync)
    • Bill Segment Sync for DataConnect (C1-ExternalRepoPlusBillSegSync)

  • Legacy DataConnect

    • Billing Sync for Legacy DataConnect (Tab-delimted) (C1-ExternalRepoPlusBillingSync)
    • Billing Sync for Legacy DataConnect (C1-ExternalRepoBillingSync)

These business objects should be defined as an algorithm parameter on the algorithm based on the Change Data Capture of Billing Data for DataConnect (C1-CAPBILLEX) algorithm type. These business object use the following Pre-Processing algorithms to take an initial data snapshot, and define the batch control used to extract data and export to a flat file. However, since billing data are always synched when it gets completed, no actual initial snapshot is taken. Instead, the parameters used for building the snapshots are taken and stored on the sync request record for later use when building the final snapshot.

Current DataConnect

Business Object

Pre-Processing Algorithm

Bill Sync for DataConnect (C1-ExternalRepoPlusBillSync)

Capture Bill Data Initial Snapshot (C1EXTCBILLI)

Bill Segment Sync for DataConnect (C1-ExternalRepoPlusBillSegSync)

Capture Bill Segment Data Initial Snapshot (C1EXTRCBSI)

Legacy DataConnect

Business Object

Pre-Processing Algorithm

Billing Sync for Legacy DataConnect (C1-ExternalRepoBillingSync)

Capture Billing Data Initial Snapshot for Legacy DataConnect (C1-EXTRCBLIP)

Billing Sync for Legacy DataConnect (Tab-delimited) (C1-ExternalRepoPlusBillingSync)

Billing Data Initial Snapshot for Legacy DataConnect (C1-EXTRCBLIP)

The Sync Request Monitor batch control (F1-SYNRQ) monitors synchronization requests in the Pending state and executes Monitor algorithms that check for 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 extract a final snapshot of the data if the billing related data is to be extracted and exported. These include:
  • Algorithms that check if there is a need to export the billing data. It will discard the synchronization request if one of the following is true:

    • The synchronization request is for a cancelled bill segment whose original usage has not been previously sent out.

    • The synchronization request has been marked for non-synchronization (such as, the bill segments related SA Type is not configured to be extracted on the Billing Data Configuration for DataConnect master configuration record).

    Business Object

    Algorithm

    Billing Sync for Legacy DataConnect (Tab—delimted) (C1-ExternalRepoPlusBillingSync)

    Determine if the Billing Sync is Needed (C1-DSCANUSNS)

    Billing Sync for Legacy DataConnect (C1-ExternalRepoBillingSync)

    Determine if the Billing Sync is Needed (C1-DSCANUSNS)

  • Algorithms that capture the billing data information and stores it on the synchronization request.

    Current DataConnect

    Business Object

    Algorithm

    Bill Sync for DataConnect (C1-ExternalRepoPlusBillSync)

    Capture Bill Data Final Snapshot (C1EXTCBILLF)

    Bill Segment Sync for DataConnect (C1-ExternalRepoPlusBillSegSync)

    Capture Bill Segment Data Final Snapshot (C1EXTRCBSF)

    Legacy DataConnect

    Business Object

    Algorithm

    Billing Sync for Legacy DataConnect (C1-ExternalRepoBillingSync)

    Capture Billing Data Final Snapshot for Legacy DataConnect (C1-CAPBILUSN)

    Billing Sync for Legacy DataConnect (Tab-delimted) (C1-ExternalRepoPlusBillingSync)

    Capture Billing Data Final Snapshot for Legacy DataConnect (C1-CAPBILUSN)
When using Legacy DataConnect, if a single extract file that combines both the billing and master data (customer and premise) information is preferred, the following algorithms can be used to capture the master data information of the bill. These algorithms should be plugged in on the Determine if Sync Needed state after the Capture Billing Data Final Snapshot for DataConnect algorithm.

  • Capture Billing’s SA Final Snapshot for DataConnect (C1-CEXTRCSA) - This is the algorithm that captures the service agreement, account and person information associated with the bill.

  • Capture Billing’s SP Final Snapshot for DataConnect (C1-CEXTRCSP) - This is the algorithm that captures the service point and premise information associated with the bill.

  • Capture Billing's Installation Event Final Snapshot for DataConnect (X1-CEXTRCIE). This is the algorithm that captures install event information associated with the bill.

When using DataConnect v1, the Prepare Delimited Extract Data (Process All) Enter algorithm (C1-PRPEXDCUS/C1-PRPTDEXDT) 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 extract batch control defined by the pre-processing algorithm).