fct_contract_term_dates


Description

Each individual contract term of a customer.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contract_term_id int8 19 null

The primary key of this table. System column calculated by the source System.
contract_id int8 19 √ null
fct_contract.contract_id erp_v2_fct_contract_term_dates_contract_id__erp_v2_fct_contract_contract_id_fkey_212b7c43ac65 R

Contract connected to this term
customer_id int8 19 √ null
dim_customer.customer_id erp_v2_fct_contract_term_dates_customer_id__erp_v2_dim_customer_customer_id_fkey_62bfcf6248f3 R

Customer that holds this contract
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id erp_v2_fct_contract_term_dates_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_e13a283163ac R

The gym (organization_unit) for which contract was generated.
start_date date 13 √ null

The date at which this contract term started.
end_date date 13 √ null

The date at which this contract term ended.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).
data_landing_time timestamptz 35 getdate()

System column. UTC timestamp assigned when a table batch is applied on Redshift. It represents warehouse landing order at table-batch granularity, not source event order. Usable to filter for incremental extractions.

Relationships

Close relationships within degrees of separation