system_note_entity - System Notes Entity

Holds system generated note information.

Column

Data Type

Column Info

Value Notes

Other

id

int(11)

The id of the system note.

entity_type

char(50)

The entity type that the system note is about. There is an entity type for each entity inside LoanPro (e.g. loan, customers, document, autopay, etc.)

E.G. Entity.Loan, Entity.Customer, Entity.Document, Entity.Autopay

entity_id

int(11)

The ID of the entity the system note is about.

reference_type

char(50)

This is similar to the entity type, but gives more information when two entities are involved in an action. The reference type usually refers to a child entity. For example, if a document is added to a loan, the entity_type would be Entity.Loan and the reference_type would be Entity.Document.

E.G. Entity.Document, Entity.PaymentAccount

reference_id

int(11)

This is the ID of the referenced entity. For example, if the system note references a document being added to a loan, the reference_id is the document ID, while the entity_id is the loan ID.

operation_type

enum

operation type

  • CREATE
  • UPDATE
  • DELETE
  • SERVICE_CALL

operation_sub_type

char(100)

operation sub type

systemNote.operationSubtype.*

create_user

int(11)

ID of the user that created the entity

create_user_name

varchar(255)

creating user name

created

timestamp

Timestamp of when the entity was created

lastUpdated

timestamp

Timestamp of when the entity was last updated

remote_addr

char(20)

IP address of the client machine

note_title

varchar(255)

note title

note_data

text

note data

deleted

tinyint(4)

Whether or not the entity was deleted

1 - yes, 0 - no


How did we do?


Powered by HelpDocs (opens in a new tab)