Entity Tables

The Entity tables describe all of the entities in your dataset. Entities are stored in six different tables, each of which has a different time-based aggregation scheme.

For a diagram illustrating how the Entity tables relate to other Influent tables, see the Entity Relationships section.

EntitySummary

Each record in the EntitySummary table represents a unique entity in your transaction data. Records are calculated directly from the information in your source database.

NOTE
  • To incorporate additional entity details in Influent (e.g., locations, images, occupations, etc.), insert them as new columns in the EntitySummary table.
  • For applications with multiple entity types, you must create separate EntitySummary tables for each, where the name of the table includes the entity type (e.g., EntitySummaryLender and EntitySummaryBorrower).
Column Data Type Nullable? Description
EntityId varchar(100) Yes Unique entity identifier.
IncomingLinks int Yes Total number of transactions received by the corresponding entity.
UniqueIncomingLinks int Yes Total number of unique entities from which the corresponding entity received transactions.
OutgoingLinks int Yes Total number of transactions sent by the corresponding entity.
UniqueOutgoingLinks int Yes Total number of unique entities to which the corresponding entity sent transactions.
NumLinks int Yes Total number of transactions involving the corresponding entity.
MaxTransaction float Yes Value of the largest transaction in which the corresponding entity participated.
AvgTransaction float Yes Average value of all the transactions in which the corresponding entity participated.
StartDate datetime Yes First date on which the corresponding entity sent or received a transaction.
EndDate datetime Yes Most recent date on which the corresponding entity sent or received a transaction.

EntityDaily

Each record in the EntityDaily table represents all of the transactions involving a unique entity on a single day. Records are calculated from the information inserted into LinkFlowYearly and LinkFlowDaily.

Column Data Type Nullable? Description
EntityId varchar(100) Yes Unique entity identifier.
PeriodDate datetime Yes Date (YYYY-MM-DD hh:mm:ss.fff) on which the transactions were executed.
InboundAmount float Yes Aggregate value of the transactions received by the entity on the corresponding day.
IncomingLinks int Yes Total number of transactions received by the entity on the corresponding day.
OutboundAmount float Yes Aggregate value of the transactions sent by the entity on the corresponding day.
OutgoingLinks int Yes Total number of transactions sent by the entity on the corresponding day.

EntityWeekly

Each record in the EntityWeekly table represents all of the transactions involving a unique entity in a single week (each of which starts on a Sunday). Records are calculated from the information inserted into EntityDaily.

Column Data Type Nullable? Description
EntityId varchar(100) Yes Unique entity identifier.
PeriodDate datetime Yes First date (YYYY-MM-DD hh:mm:ss.fff) in the month over which the transactions were executed. Always corresponds to the first of the month.
InboundAmount float Yes Aggregate value of the transactions received by the entity in the corresponding week.
IncomingLinks int Yes Total number of transactions received by the entity in the corresponding week.
OutboundAmount float Yes Aggregate value of the transactions sent by the entity in the corresponding week.
OutgoingLinks int Yes Total number of transactions sent by the entity in the corresponding week.

EntityMonthly

Each record in the EntityMonthly table represents all of the transactions involving a unique entity in a single calendar month. Records are calculated from the information inserted into EntityDaily.

Column Data Type Nullable? Description
EntityId varchar(100) Yes Unique entity identifier.
PeriodDate datetime Yes First date (YYYY-MM-DD hh:mm:ss.fff) in the month over which the transactions were executed. Always corresponds to the first of the month.
InboundAmount float Yes Aggregate value of the transactions received by the entity in the corresponding month.
IncomingLinks int Yes Total number of transactions received by the entity in the corresponding month.
OutboundAmount float Yes Aggregate value of the transactions sent by the entity in the corresponding month.
OutgoingLinks int Yes Total number of transactions sent by the entity in the corresponding month.

EntityQuarterly

Each record in the EntityQuarterly table represents all of the transactions involving a unique entity in a single quarter, where:

  • Q1 = Jan 1 - Mar 31
  • Q2 = Apr 1 - Jun 30
  • Q3 = Jul 1 - Sep 30
  • Q4 = Oct 1 - Dec 31

Records are calculated from the information inserted into EntityMonthly.

Column Data Type Nullable? Description
EntityId varchar(100) Yes Unique entity identifier.
PeriodDate datetime Yes First date (YYYY-MM-DD hh:mm:ss.fff) in the quarter over which the transactions were executed. Always corresponds to Jan 1, Apr 1, Jul 1 or Oct 1.
InboundAmount float Yes Aggregate value of the transactions received by the entity in the corresponding quarter.
IncomingLinks int Yes Total number of transactions received by the entity in the corresponding quarter.
OutboundAmount float Yes Aggregate value of the transactions sent by the entity in the corresponding quarter.
OutgoingLinks int Yes Total number of transactions sent by the entity in the corresponding quarter.

EntityYearly

Each record in the EntityYearly table represents all of the transactions involving a unique entity in a single calendar year. Records are calculated from the information inserted into EntityQuarterly.

Column Data Type Nullable? Description
EntityId varchar(100) Yes Unique entity identifier.
PeriodDate datetime Yes First date (YYYY-MM-DD hh:mm:ss.fff) in the year over which the transactions were executed. Always corresponds to Jan 1.
InboundAmount float Yes Aggregate value of the transactions received by the entity in the corresponding year.
IncomingLinks int Yes Total number of transactions received by the entity in the corresponding year.
OutboundAmount float Yes Aggregate value of the transactions sent by the entity in the corresponding year.
OutgoingLinks int Yes Total number of transactions sent by the entity in the corresponding year.

Entity Relationships

The following entity relationship diagram illustrates the order in which the Entity tables are built using the information in your source dataset. As each table is essentially a summary of your original data, each table is linked to every other table through the unique entity IDs in your dataset.

Entity Tables