dim_contract_term


Description

The term of the contract.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contract_term_id varchar 256 null
fct_contract.contract_term_id erp_v2_fct_contract_contract_term_id__erp_v2_dim_contract_term_contract_term_id_fkey_313196804702 R

The primary key of this table.
value int8 19 √ null

The measure of the term
unit varchar 256 √ null

The unit measure of the term value
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