Database – Action & Result Selection (action_result_selection_entity)

Description

This allows for the linking of an action to a result and a note. The action entity holds information on the actions created as part of LMS's Actions & Results tool. Actions and Results are a type of uniform note that can be easily searched to assess the condition of a loan or the state of loan processes. They can be set up both through the UI and the API – Actions & Results.

Table Fields

Column

Data Type

Column Info

Value Notes

id

INT(11)

The ID of the action & result selection entity

note_id

INT(11)

The ID of the associated note.

action_id

INT(11)

The ID of the action. Actions can be found in the action_entity table.

result_id

INT(11)

The ID of the result. Results can be found in the result_entity table.

action_text

VARCHAR(255)

The description of the action for an action & result.

result_text

VARCHAR(255)

The description of the result for an action & result.

created

DATETIME

This is the date that the action & result note was created.

lastUpdated

TIMESTAMP

This is the date that the action & result note was last updated.

deleted

TINYINT(1)

Whether this record has been marked as deleted.

1 - yes, 0 - no


How did we do?


Powered by HelpDocs (opens in a new tab)