Database – System Notes Entity (system_note_entity)
Holds system generated note information.
The id of the system note.
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
The ID of the entity the system note is about.
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
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 sub type
ID of the user that created the entity
creating user name
Timestamp of when the entity was created
Timestamp of when the entity was last updated
IP address of the client machine
Whether or not the entity was deleted
1 - yes, 0 - no