Purging Claims Data
Oracle Health Insurance applications store a significant amount of information. This page describes the integration point that enables the user to purge data from the operational claims tables. The two primary scenarios for using this integration point are to purge information that is beyond its retention period on a production environment, and to reduce the size of non-production environments.
This integration point removes claims and all related details, taking a number of criteria to control the scope of the purge process. Claims that match on all specified criteria are purged.
Claims that have the Exempt from Purging indicator as Yes on the related external Claims data records are exempt from purging. They do not purge even if they match the specified parameters.
Note that claims purge regardless of their status. So, purging is also possible for claims that are not in completed status.
Request
This integration point is available via the following path:
http://[hostName]:[portNumber]/[api-context-root]/purgeclaims
This integration point exposes a POST method. The payload for this request contains the selection criteria for the claims to be purged.
The request message has the following structure:
{
"periodUom" : "",
"periodLength" : "",
"includeFinancialData" : "",
"includeLimitConsumptions" : "",
"formCode" : "",
"formTypeCode" : "",
"brandCode" : "",
"claimDynUsageName1" : "",
"claimDynValue1" : "",
"claimDynUsageName2" : "",
"claimDynValue2" : "",
"claimDynUsageName3" : "",
"claimDynValue3" : "",
"extClaimDataDynUsageName" : "",
"extClaimDataDynValue" : "",
"currentDate" : ""
}
Parameter | Description |
---|---|
periodUom |
This required parameter specifies, together witch period length, the retention period. Specify the unit of measure as D (days), M (months) or Y (years) |
periodLength |
Required parameter that specifies the length of the retention period |
includeFinancialData |
This required parameter controls whether financial data is included in the purge process. Note that the base financial objects that resulted from claims that have been purged earlier are also removed regardless of the retention period if this parameter is |
includeLimitConsumptions |
This required parameter controls whether the adjudication limit consumptions and provider limit consumptions are included in the purge process. Note that the consumptions that resulted from claims that have been purged earlier are also removed if this parameter is |
formCode |
This optional parameter specifies the claims form. Only Claims with the specified form purge. |
formTypeCode |
This optional parameter specifies the Claim form type. Only Claims with the specified form type purge. |
brandCode |
This optional parameter specifies the brand. Only Claims with the specified brand (excludes Claims without a specified brand) purge. |
claimDynUsageName1 |
|
claimDynValue1 |
|
claimDynUsageName2 |
|
claimDynValue2 |
|
claimDynUsageName3 |
|
claimDynValue3 |
|
extClaimDataDynUsageName |
This optional parameter provides the ability to use a dynamic field that is available on the external Claims data table as parameter for the purging process. Only use single-value dynamic fields as parameters. Specifying a dynamic field usage name and value (specify both) purges only Claims that have the specified value for the specified dynamic field on their external claims data record. |
extClaimDataDynValue |
This optional parameter holds the value for the specified extClaimDataDynUsageName (previous parameter). Use the following format for dynamic fields of type date: |
currentDate |
This is an optional parameter. Use it in test environments only. Calculate the retention period as if today is |
Retention Period
The retention period is derived from the system date. The age of a claim is determined by the last updated date on the claim header.
For example, a retention period of ten years purges all Claims that have not been updated in 10 years as of the day the user calls this integration point.
Dynamic fields as Selection Criteria
It is possible to specify up to three single-value dynamic fields on the claims table as criteria for the purging process.
Use the following format for dynamic fields of type date: YYYY-MM-DD
.
Example
The following example purges all claims with form type code INST and product line (dynamic field on the claims table) HMO
that are older than ten years together with their financial data, adjudication limit, and provider limit consumptions.
{
"periodUom" : "Y",
"periodLength" : "10",
"includeFinancialData" : "Y",
"includeLimitConsumptions" : "Y",
"formTypeCode : "INST",
"claimDynUsageName1" : "productLine",
"claimDynValue1" : "HMO"
}
Response Messages
This service can respond with the following messages:
Code | Message |
---|---|
CLA-IP-PUCL-001 |
Period UoM must be D (days), M (months) or Y (years) |
CLA-IP-PUCL-002 |
Period length must be a positive number without decimals |
CLA-IP-PUCL-003 |
The request must include both Period UoM and Period Length |
CLA-IP-PUCL-004 |
Claim Form Code is unknown |
CLA-IP-PUCL-005 |
Claim Form Type Code is unknown |
CLA-IP-PUCL-006 |
Brand Code is unknown |
CLA-IP-PUCL-007 |
Dynamic Field Usage Name is unknown |
CLA-IP-PUCL-007 |
Dynamic Field Usage Name and Value must both be provided |