The system will read the interface database IN.pensions_Interface table and find the records for which the value for Status is null. The system will read the EmployeeNumber, Surname and IDNumber fields and find the Membership record linked to a Client record for which the Company Reference Number, Surname and ID Number values are equal to these values respectively.
If found, the system will read the Translation Value with a Source System ID and Source System Attribute of PAYROLL and TERM REASON ID respectively and Target System ID and Target System Attribute of IN.PENSIONS and BENEFIT EVENT and find the Target System Value for the value for TermReasonID and the Interface database table and create a Benefit Request record for each Membership.
The Benefit Request record will be created with the following values:
|
FIELD |
VALUE |
|
Claim Request Type |
PENDING CLAIM |
|
Calculation Effective Date |
TerminationDate on Interface database table |
|
Notification Timestamp |
Current Date |
|
Benefit Event |
Translation Value for TerminationReasonID |
|
Claim Status |
IN PROGRESS |
A Claim Details record will be created with the following values:
|
FIELD |
VALUE |
|
Type |
PROGRESS |
|
Sub-Type |
NOTIFICATION |
A Service Request will be created with the following values and the Status on the Interface table will be updated:
|
FIELD |
VALUE |
|
Scheme Code |
Scheme Code for the Membership records found |
|
Process |
PENDING CLAIMS |
|
Activity |
SEND CLAIM FORM |
|
Start Date |
Current Date |
The Status on the IN.pensions_Interface table will be updated to indicate that the record has been processed and the Membership Status will be updated to EXIT IN PROCESS.