C1-REN-DERIV

This algorithm validates the following:

• Either the policy ID or source system and policy number is specified in the record.

• Reinstatement reason is specified in the record.

If the policy ID is not specified in the record, it derives the policy ID using the respective source system and policy number combination. Once the policy ID is derived, the corresponding record is updated in the C1_​UPLOAD_​REQ_​DTLS table. If the system could not derive the policy ID using the source system and policy number combination, the status of the record in the C1_​UPLOAD_​REQ_​DTLS table is changed to Invalid. In addition, if any of the above validations fail, the status of the record in the C1_​UPLOAD_​REQ_​DTLS table is changed to Invalid.

This algorithm also derives the fields which can be used as search filters based on the mapping defined in the respective upload request type.