...
We need to create a table to keep all loan provision categories.The table name is 'm_loan_product_provision_category''. The table definition is defined below. The category names will vary based customer to customer.
| Name | Datatype | Length | Remarks |
|---|---|---|---|
| id | BIGINT | 20 | Primary Key & Auto Increment |
| category_name | VARCHAR | 100 | Not Null |
| Description | VARCHAR | 200 |
...
| id | category_name | Description |
|---|---|---|
| 1 | STANDARD | Punctual Payment without any dues |
| 2 | SUB-STANDARD | Principal and/or Interest overdue by x days |
| 3 | DOUBTFUL | Principal and/or Interest overdue by y days with 1 year original term (or) Principal and/or Interest overdue by z days with more than 1 year term
|
| 4 | LOSS | Principal and/or Interest overdue by t1 days with 1 year original term (or) Principal and/or Interest overdue by t2 days with more than 1 year term |
Note: We can provide a GUI in client to add these categories into this table which is not covered in this specification.