LinkFlow Tables

The LinkFlow tables describe all of the transactions in your dataset, with each record representing one or more transactions between a specific source and destination entity. There are six different Transaction Flow tables, each of which has a different time-based aggregation scheme:

For a diagram illustrating how the LinkFlow tables relate to your raw data source and the other Influent tables, see the Entity Relationships section.

LinkFlow

Each record in the LinkFlow table represents an aggregation of all transactions between a source and destination entity. Records are calculated from the information inserted into LinkFlowDaily.

Column Data Type Nullable? Description
FromEntityId varchar(100) No Unique identifier of the entity that sent the transaction.
FromEntityType varchar(1) Yes Type of entity that sent the transaction:
  • O = Owner summary
  • A = Account
  • S = Cluster summary entity
ToEntityId varchar(100) No Unique identifier of the entity that received the transaction.
ToEntityType varchar(1) Yes Type of entity that received the transaction:
  • O = owner summary
  • A = account
  • S = cluster summary entity
FirstTransaction datetime Yes Date and time (YYYY-MM-DD hh:mm:ss.fff) at which the corresponding entities first participated in a transaction.
LastTransaction datetime Yes Date and time at which the corresponding entities last participated in a transaction.
Amount float Yes Aggregate value of the transactions between the entities.

LinkFlowDaily

Each record in the LinkFlowDaily table represents an aggregation of all transactions between a source and destination entity on a single day. Records are calculated directly from the information in your source database.

Column Data Type Nullable? Description
FromEntityId varchar(100) No Unique identifier of the entity that sent the transaction.
FromEntityType varchar(1) Yes Type of entity that sent the transaction:
  • O = Owner summary
  • A = Account
  • S = Cluster summary entity
ToEntityId varchar(100) No Unique identifier of the entity that received the transaction.
ToEntityType varchar(1) Yes Type of entity that received the transaction:
  • O = owner summary
  • A = account
  • S = cluster summary entity
Amount float Yes Aggregate value of the transactions between the entities on the corresponding day.
PeriodDate datetime Yes Date (YYYY-MM-DD hh:mm:ss.fff) on which the transactions were executed.

LinkFlowWeekly

Each record in the LinkFlowWeekly table represents an aggregation of all transactions between a source and destination entity in a single week (each of which starts on a Sunday). Records are calculated from the information inserted into LinkFlowDaily.

Column Data Type Nullable? Description
FromEntityId varchar(100) No Unique identifier of the entity that sent the transaction.
FromEntityType varchar(1) Yes Type of entity that sent the transaction:
  • O = Owner summary
  • A = Account
  • S = Cluster summary entity
ToEntityId varchar(100) No Unique identifier of the entity that received the transaction.
ToEntityType varchar(1) Yes Type of entity that received the transaction:
  • O = owner summary
  • A = account
  • S = cluster summary entity
Amount float Yes Aggregate value of the transactions between the entities during the corresponding week.
PeriodDate datetime Yes First date (YYYY-MM-DD hh:mm:ss.fff) in the week over which the transactions were executed. Always corresponds to a Sunday.

LinkFlowMonthly

Each record in the LinkFlowMonthly table represents an aggregation of all transactions between a source and destination entity in a single calendar month. Records are calculated from the information inserted into LinkFlowDaily.

Column Data Type Nullable? Description
FromEntityId varchar(100) No Unique identifier of the entity that sent the transaction.
FromEntityType varchar(1) Yes Type of entity that sent the transaction:
  • O = Owner summary
  • A = Account
  • S = Cluster summary entity
ToEntityId varchar(100) No Unique identifier of the entity that received the transaction.
ToEntityType varchar(1) Yes Type of entity that received the transaction:
  • O = owner summary
  • A = account
  • S = cluster summary entity
Amount float Yes Aggregate value of the transactions between the entities during the corresponding month.
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.

LinkFlowQuarterly

Each record in the LinkFlowQuarterly table represents an aggregation of all transactions between a source and destination 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 LinkFlowMonthly.

Column Data Type Nullable? Description
FromEntityId varchar(100) No Unique identifier of the entity that sent the transaction.
FromEntityType varchar(1) Yes Type of entity that sent the transaction:
  • O = Owner summary
  • A = Account
  • S = Cluster summary entity
ToEntityId varchar(100) No Unique identifier of the entity that received the transaction.
ToEntityType varchar(1) Yes Type of entity that received the transaction:
  • O = owner summary
  • A = account
  • S = cluster summary entity
Amount float Yes Aggregate value of the transactions between the entities during the corresponding quarter.
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.

LinkFlowYearly

Each record in the LinkFlowYearly table represents an aggregation of all transactions between a source and destination entity in a single calendar year. Records are calculated from the information inserted into LinkFlowMonthly.

Column Data Type Nullable? Description
FromEntityId varchar(100) No Unique identifier of the entity that sent the transaction.
FromEntityType varchar(1) Yes Type of entity that sent the transaction:
  • O = Owner summary
  • A = Account
  • S = Cluster summary entity
ToEntityId varchar(100) No Unique identifier of the entity that received the transaction.
ToEntityType varchar(1) Yes Type of entity that received the transaction:
  • O = owner summary
  • A = account
  • S = cluster summary entity
Amount float Yes Aggregate value of the transactions between the entities during the corresponding year.
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.

Entity Relationships

The following entity relationship diagram illustrates the order in which the LinkFlow 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.

LinkFlow Tables