Database – Computation Field Entity (computation_field_entity)
Description
A computation field is a piece of data that is computed dynamically. This allows for calculations that need to be updated as loan values change (such as the remaining balance). Static field data should be stored in a custom field.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
title | varchar(100) | The name/title of the entity instance | ||
round | varchar(100) | rule rounding | computationField.round.* | |
format | varchar(100) | rule format | computationField.format.* | |
display | varchar(100) | This is the place in the loan UI where the computation field will be displayed | E.g. computationField.display.loanSummary | |
rule | text | Associated Clojure Rule used in entity evaluation | ||
state | text | This is the actual computation saved for the field along with validation properties | {"lisp":"(+ (-> setup-custom-fields :1 :value u/parse-int) (-> setup-custom-fields :20 :value u/parse-int) (-> setup-custom-fields :3 :value u/parse-int) (-> setup-custom-fields :4 :value u/parse-int))","valid":false,"editor":""} | |
entity_type | varchar(100) | Type of the associated entity | ||
active | tinyint(1) | Whether or not the entity is active | 1 - yes, 0 - no | |
deleted | tinyint(4) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated |