Get TransactionHistory

Request/Response & Json Schema

Overview

This interface retrieves transaction history information for contract like transaction type, transaction gross amount, status, reversal indicator, effective dates & process dates for each transaction withing date range from the request. If the date range is not provided then it retrieves the records which fall under a year less than current date.The list of transactions supported by this interface is mentioned in mapping sheet. The data elements are as below.

Transaction type

Transaction completion status

Transaction reversal status

Transaction gross amount

Transaction net amount

Transaction effective date

Transaction system process date

Transaction balance amount

The below list of products are in scope for this operation.

Deferred Annuity

Immediate Annuity

Term Life Insurance

Universal Life

Whole Life Insurance

The list of transaction supported can be found in the ‘OLI_LU_FINACTTYPE’ section of the attached mapping sheet.

Technical Requirements

TR ID# Technical Requirements
TR1 ACORDv2.36 shall be used to communicate. ACORD Tx 213 “Financial Activity Inquiry Transactiontc=213” should be used to get transaction history
TR2 Interface must always return an error code and desc in the event of a processing failure in addition to HTTP response code.
TR3 For a success the response for will provide the contract transaction details.

Business Requirements

BR ID# Business Requirements
BR1 The Get Transaction History for Contract should provide the list of transactions which are executed on a contract.
BR2 The Contract should be in the below status to get the transaction details.ActiveAnnuitizedExtended free lookFree lookLapseLapse pendingTerminated SurrenderConversation pendingLate payment offer pendingPayout (supported for Deferred Annuity products only)ClaimDeath Claim PendingPending awaiting fundsPending issue
BR3 The contract with contract number specified in the request should be present in ALIP for data to be returned
BR4 Transaction details fetched should contain Transaction net amount and transaction gross amount
BR5 For ‘Rate Renewal Transaction’ Transaction Dollar Amount should be the amount, after Interest was credited but before Total Amount of source fund was redistributed.
BR6 Provide support for Partial Death Claim Transaction Type

Process Flow

Same as section 3.1.4

Impact on ALIP system

None

Assumptions

None

Dependencies

None

Request Data Elements

Request Parameters Description Mandatory Allowed values
Contract Id A number which uniquely identifies a contract number within ALIP. Y
Start Date Start Date of transaction that needs to be fetched for for a policy N
End Date End Date of transaction that needs to be fetched for for a policy N

Response Data Elements

Please refer to spreadsheet below for the Response Data elements

Success/Error Handling

Success Success Scenario Description Message Code Message Description Message Type Additional Comments
#1 The GetTransactionHistoryfor contract call was successful with details being returned in the output 1 Success Informational TXLife/TXLifeResponse/TransResult/ResultCode/@tc =1

Error Error Scenario Description Message Code Message Description Message Type Additional Comments
#1 The Get Transaction History for contract call was NOT successful due to a technical error or contract not found. 5 Error Informational TXLife/TXLifeResponse/TransResult/ResultCode/@tc =5