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.
- Bill Sync for DataConnect (C1-ExternalRepoPlusBillSync)
- Bill Segment Sync for DataConnect (C1-ExternalRepoPlusBillSegSync)
- Billing Sync for Legacy DataConnect (Tab-delimted) (C1-ExternalRepoPlusBillingSync)
- Billing Sync for Legacy DataConnect (C1-ExternalRepoBillingSync)
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) |
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.
-
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.
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)
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)
-
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 Meter History Final Snapshot for DataConnect (C1-CEXTRCSM) - This is the algorithm that captures the meter history 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).