dim_contract_payment_frequency


Description

Defines how often and how much is paid for an individual contract.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contract_payment_frequency_id varchar 256 null
fct_contract.contract_payment_frequency_id fct_contract_contract_payment_frequency_id_fkey R

The primary key of this table.
payment_frequency_type varchar 256 √ null

Type of payment frequency. One of:

  • RECURRING: A payment has to be made every value x unit (eg 1 x Week)
  • NON_RECURRING: A payment has to be made only once.
  • FREE: No Payment has to be made.
  • MONTH_DAY_NON_RECURRING: A payment has to be made at specific pre-defined days in the year, only one year long.
  • MONTH_DAY_RECURRING: A payment has to be made at specific pre-defined days in a year. Repeating every year.
  • TERM_DAYS_NON_RECURRING: A payment has to be made at specific pre-defined days after the contract starts.
  • TERM_DAYS_RECURRING: A payment has to be made at specific pre-defined days after each term of a contract starts.
payment_frequency_price numeric 19,2 √ null

How much has to be paid by the original contract settings, which does not take adjustments into account.
payment_frequency_current_price numeric 19,2 √ null

How much has to be paid taking adjustments into account for the current date
payment_frequency_value int8 19 √ null

The interval in unit between each payment. Or: How many times a payment has to be made per unit.
payment_frequency_unit varchar 256 √ null

The unit of the interval value between each payment. One of:

  • DAY
  • WEEK
  • MONTH
  • YEAR
  • ONCE: A payment only has to be made once, so an interval is not applicable.
  • CUSTOM: The interval of payments is defined in specific dates or days after contract start / contract term start.
last_updated timestamptz 35 √ null

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

Relationships

Close relationships within degrees of separation