Account Purge

Job type: Java A widely used object-oriented programming language that is designed for use in the distributed environment of the internet. It is the most popular programming language for Android smartphone applications

Archive: None

For more information on this job, see the Job Details in the Administration Console An operations web console that allows batch jobs to be scheduled, run manually and monitored. The console also provides for viewing and modification of business and user applicable system configuration.: In the console, navigate to System Maintenance > Jobs. In the Job List, click the name of job to open its Job Details screen.

Selection criteria

Sets the Delivery Address Number (GDCACD) to zero and the Account In the Cloud Monetisation Platform, a billing entity that can be used to manage payments on one or more subscriptions or payments for services. An account can hold details such as payments or invoices. Contact Name (GDIBNA), For Attention of Name (GDNJNA), Account Password (GDY9TX) and Account PIN Number (GDTSNB) fields to all asterisks only if the following rules are ALL true:

Rule	Criteria
Last changed over X months ago.	Date Changed (GDEKDT) >0 and <= incoming date parameter, derived as (job date – number of months) from the batch job scheduler.
No workflows.	No records in table COFNREP (Diary Event) where FNAN8X = GDAN8X.
No subscriptions.	No records in table COCXREP (Subscription) where CXAN8X = GDAN8X.
No invoices.	No records in table COGJREP (Invoice Header) where GJAN8X = GDAN8X.
No pending invoices.	No records in table COGNREP (Pending Invoice Header) where GNAN8X = GDAN8X.
No open sales ledger transactions.	No records in Accounts Receivable Ledger where ACCOUNTNUMBER = GDAN8X and OPENAMOUNT <> 0.
No open bonds.	No records in table COF1REP (Account Bond) where F1AN8X = GDAN8X and F1NUSU (Bond Status) <> ‘6’ (refunded) or ‘7’ (cancelled).
No account services.	No records in table CWAZREP (Account Service) where AZAN8X = GDAN8X and AZCBST (Invoice this Service) = ‘1’.
No agreements.	No records in table COEDREP (Agreement) where EDAN8X = GDAN8X.
No orders.	No records in table CSOQREP (Order) where OQAN8X = GDAN8X.
No account payment plans	No records in the accountpaymentplan table where accountnumber = GDAN8X -- Account Payment Plan
No sales ledger transactions	No records in the salesledgertransaction table where accountnumber = GDAN8X -- Sales Ledger Transaction
No direct debits	No records in the directdebitmaster table where accountnumber = GDAN8X -- Direct Debit Master
No direct debit amendments	No records in the directdebitmasteramendment table where accountnumber = GDAN8X -- Direct Debit Master Amendment
No statement headers	No records in the statementheader table where accountnumber = GDAN8X -- Statement Header
No statement details	No records in the statementdetail table where accountnumber = GDAN8X -- Statement Detail
No statement transaction details	No records in the statementtransactiondetail table where accountnumber = GDAN8X -- Statement Transaction Detail
No payments	No records in the payment table where accountnumber = GDAN8X AND paymentsource = 'R' and (paymentstatus <> 'S' or paymentstatus <> 'F')) -- Payment

For every obfuscated account in the table, the job:

Deletes every record from table CXGDREP (Customer In the context of the Cloud Monetisation Platform, an individual or organisation who has signed an agreement to take goods and services from a service provider. A customer receives a bill associated with one or more subscriptions, and can be a single end user or a large company with many subscriptions assigned to one agreement. E-Mail Address) where OAM Customer Level (GDQ4SU) = ‘30’ and Customer Reference ID (GDAKCD) = GDAN8X.

Tables Impacted
Name	Description
CXGDREP	Customer E-Mail Address

Running the purge job

In the Administration Console, you can create a schedule for the purge job or run it as needed.

To run a job:

Navigate to Daily Operations > Jobs.
In the Job List, select the checkbox for the job that you want run.
Click Run Now.