Understanding Table Structures

Overview

A table is an object that has been created within the platform and that references a physical data source from which the user intends to read data using the platform. A table is used during a data element (i.e., column) registration process to specify to the source table where the data element should be read from.

Types of Tables

In the Platform, tables are mapped to the entities:

Primary Table- The records in the Primary tables are unique. Each table has a unique system key associated that is used in linking the tables.

In addition users need to register a primary table for each secondary id that they register on the platform. A secondary id that does not have a primary table will not be usable.

Helper Table- They help establish relationship between two Primary tables eg. Prosp_to_app table

Detail Table- They contain detailed data pertaining to any of the IDs in a primary table (e.g., Customer has 36-month auto loan and he has been making payments for last 7 months. Therefore, the Detail table will have monthly payment level data for all 7 months. Most detail tables will have duplicate rows for a given Id.

Structure of a table: