Group Billing_Data Intake (DI)
The Group Billing Data intake functionality deals with storing, reading and processing the incoming payment information. Data Intake activity will process the reconciliation and generate the required policy level activities to ensure the monies are adjusted to the policy.
OIPA will use Data Intake method to get the payment and billing reconciliation related information.Data Intake functionality is enhanced to receive a Data Intake Payment File and corresponding Payment records, and executing the file as set of changes in the system
Files & Records Payment information will come in Data Intake file.
Data Intake payment file can have one or more Data intake record.
Prototype Configuration Detail Overview Each payment and related information will represent a record in data intake payment file.
![]()
Once a Group Bill is generated to a Group Customer, when monies are received from the payer, the same will be adjusted against the Bill Line entries and reconciled through this feature where DI deals with storing, reading and processing the incoming payment information.
Prerequisites1. PAS user should be associated to a security group where the access is given for 'Prototype' company.
2. Bill Detail records should exists at either of these entities Policy/Segment/Client.
3. Bill record should exists for GroupCustomer which groups the above bill detail records.
4. Data Intake profile against 'Payment Prototype' intake profile definition should exists for a GroupCustomer.
5. Data Intake file for 'Payment Prototype' intake profile definition should exists.
6. PAS user should be associated to a security group where the access is given for 'Prototype' company.
7. PAS user should have access to 'GenerateBillDetail' & 'Reconciliation' product level transactions.
8. PAS user should have access to 'GenerateBill','PaymentFilePrototype' & 'PaymentRecordPrototype' transactions present at 'Customer Plan' level.
9. PAS user should have access to 'Reconciliation' transaction present at 'Client Plan' level.
New Items
Intake Profile Definition:New intake profile definition 'Payment Prototype' is added for 'Prototype' company.
Below is the sample DI file template for 'Paymnet Prototype' intake profile definition:PaymentPrototype-DIFileTemplate.txt
PaymentFilePrototype transaction:Plan Name - Customer Plan
Company Name - Prototype
Transaction Type - IntakeFile
Processing Order - 200
With this transaction the Data Intake file gets validated by Data Intake engine and then returns the count of received payment records to intake file screen by using 'CopyToIntakeFileFields' business rule.
PaymentRecordPrototype transaction:Plan Name - Customer Plan
Company Name - Prototype
Transaction Type - Intake-Record
Processing Order - 201
With the execution of this transaction the 'Reconciliation' activity will be added along with the suspense details at respective entity level (Policy / Client) against the processed Payment Reference record.
Note: There will be separate 'Reconciliation' activity added for each processed Payment Reference record, If the Payment Reference Record is associated to either Policy/Segment entity type then the 'Reconciliation' occurs at Policy level and if the record is associated to 'Client' then the 'Reconciliation' occurs at Client level.
GenerateSuspense Business RuleThis attached business rule will create a suspense record (With the amount as sum of all the payment reference records amount) and then pass the created suspense information to activity math section.
Test Scenario:1. Consider a policy associated to a GroupCustomer plan.
2. Access the policy and then create a Bill Detail against the Policy entity by using 'GenerateBillDetail' transaction.
3. Access the GroupCustomer (where the above policy belongs to) and then create a Bill (Such that the above bill detail record is grouped) against the GroupCustomer by using 'GenerateBill' transaction.
4. Prepare the DI (Data intake) file based on above generated Bill detail record.
5. Using DI utility execute the above DI file.
Changes to Existing Items6. With the successful execution of DI file the Bill detail record should be in reconciled state.
None