| Insurance Data Model |
Description | A transfer of money between two |
Primary Key | |
![]() |
Dependencies | |
![]() |
Column Details |
Description | The unique identifier of the Payment |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | true |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The amount of money already paid (in the case of a payment) or to be paid (in the case of a payment due). |
Data Type | DECIMAL(14 , 2) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Any value without business meaning that uniquely distinguishes occurrences of this entity independently of its history. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A free-text statement used to explain the meaning of this payment or payment due. Descriptions are most important for payments because sometimes inbound payments are not recognised and their descriptions may be used to keep all information about the payments when investigating the reason for the payment or target of the payment. |
Data Type | VARCHAR(256) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The effective date and time that represents the beginning of the time period during which the values of all attributes of the entity occurrence are true in the business reality. |
Data Type | TIMESTAMP |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The effective date and time that represents the end of the time period during which the values of all attributes of the entity occurrence are true in the business reality. |
Data Type | TIMESTAMP |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The number or code used for identification or communication purposes. |
Data Type | VARCHAR(20) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Free format message that is used by the originator of the transaction to pass a message to the receiver of the transaction. The message is usually used to identify the reason of the transaction and often contains structured content. |
Data Type | VARCHAR(256) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The way the money has been paid by the payer to the receiver in the case of a payment or how it will be paid in the case of a payment due. e.g. Cash e.g. Cheque e.g. Credit card e.g. Direct debit e.g. Internal transfer e.g. Standing order e.g. Transfer e.g. Unit cancellation |
Data Type | VARCHAR(20) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The date at which the payment is posted in the accounting of the insurance company. |
Data Type | DATE |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Identifies the way a money transfer between financial organisations is settled. e.g. ACH e.g. BookEntry e.g. CHAPS e.g. CHIPS e.g. Concentrator e.g. Draft e.g. Epay e.g. FedNet e.g. RPS e.g. SWIFT |
Data Type | VARCHAR(20) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The position of a payment within a life-cycle model consisting of a number of statuses.The position of a financial transaction within a life-cycle model consisting of a number of statuses. |
Data Type | VARCHAR(20) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The date on which the financial transaction's latest status became effective. |
Data Type | DATE |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The additional information to explain the latest status of the financial transaction.The reason for which this payment has been rejected.Is derivable from attribute status reason in type financial transaction for the status 'rejected'. |
Data Type | VARCHAR(20) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The mutually exclusive categorisation of this Payment. |
Data Type | VARCHAR(20) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The transaction time that represents the beginning of the time period during which the values of this recorded data are true in the source system. |
Data Type | TIMESTAMP |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The transaction time that represents the end of the time period during which the values of this recorded data are true in the source system. |
Data Type | TIMESTAMP |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Primary Key Details |
Description | The unique identifier of the Payment |
Member | PAYMENT_ID [BIGINT] |
Dependency Details |
| Insurance Data Model |