3.4 Insurance Data
This section provides information in the file related to insurance.
Parent topic: File Interface
3.4.1 Insurance Details
Entity Name: INSU
Description: This table holds insurance details data from product processor.
Data Sequence:
INSU|Entity Id|Entity Type|Insurance Type|Policy No|Insurance Id|Insured Currency|Insured Amount|Insurer Code|Insurer Name|Policy Start Date|Policy End Date|Premium Amount|Payment Frequency|Insurance Policy Name|DUA Switch|Net Borrower Premium Amount|Party Id|udf1|udf2|udf3|udf4|udf5|udf6|udf7|udf8|udf9|udf10|udf11|udf12|udf13|udf14|udf15|udf16|udf17|udf18|udf19|udf20|udf21|udf22|udf23|udf24|udf25|udf26|udf27|udf28|udf29|udf30|udf31|udf32|udf33|udf34|udf35|udf36|udf37|udf38|udf39|udf40|udf41|udf42|udf43|udf44|udf45|udf46|udf47|udf48|udf49|udf50
Table 3-18 Account Details
Field Name | Description | Possible Values / Examples | Data Type | Data Length | Required/Optional |
---|---|---|---|---|---|
Entity Id | Value of Entity Id | - | VARCHAR2 | 20 | Required |
Entity Type | Entity on which Insurance is captured. Possible Values |
COLLATERAL PERSON FACILITY |
VARCHAR2 | 30 | Required |
Insurance Type | Insurance Type |
LMI PPI |
VARCHAR2 | 30 | Required |
Policy No | Policy No of the Insurance | - | VARCHAR2 | 50 | Required |
Insurance Id | Insurance Id as stored in host | - | VARCHAR2 | 30 | Required |
Insured Currency | Currency Code of the Insured Amount | - | VARCHAR2 | 3 | Required |
Insured Amount | Insured Amount | - | NUMBER | 36,18 | Required |
Insurer Code | Insurer Code as stored in host | - | VARCHAR2 | 30 | Required |
Insurer Name | Insurer Name as stored in host | - | VARCHAR2 | 30 | Required |
Policy Start Date | Start date of Policy | - | DATE | - | Required |
Policy End Date | End date of Policy | - | DATE | - | Optional |
Premium Amount | Insurance Premium | - | NUMBER | 36,18 | Required |
Payment Frequency | Premium payment frequency | - | VARCHAR2 | 30 | Required |
Insurance Policy Name | Insurance Policy Name | - | VARCHAR2 | 100 | Required |
DUA Switch | Applicable for LMI Insurance | Y/N | CHAR | 1 | Optional |
Net Borrower Premium Amount | Applicable for LMI Insurance | - | NUMBER | 36,18 | Optional |
Party Id | Applicable for CCI Insurance which is at both Facility and Party level | - | VARCHAR2 | 30 | Optional |
Parent topic: Insurance Data