Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| dim_rate_term_payment_frequency_id | varchar | 256 | null |
|
|
Primary key of the payment frequency configuration |
||
| dim_rate_term_configuration_id | varchar | 256 | √ | null |
|
|
The rate term configuration this payment frequency belongs to. |
|
| rate_id | varchar | 256 | √ | null |
|
|
The rate connected to this payment frequency. |
|
| payment_frequency_type | varchar | 256 | √ | null |
|
|
Type of payment frequency. Possible values: FREE, NON_RECURRING, RECURRING, TERM_BASED, MONTH_DAY. |
|
| payment_frequency_price | varchar | 256 | √ | null |
|
|
Standard price for this payment frequency |
|
| payment_frequency_value | varchar | 256 | √ | null |
|
|
Value associated with the frequency unit |
|
| payment_frequency_unit | varchar | 256 | √ | null |
|
|
Unit of the payment frequency. Possible values: DAY, WEEK, MONTH, YEAR. |
|
| is_recurring | bool | 1 | √ | null |
|
|
Whether the payment frequency is recurring |
|
| time_period_calculation_type | varchar | 256 | √ | null |
|
|
How the time period is calculated. Possible values: NORMALIZATION_ON_CALENDAR_UNIT, REFERENCE_DATE. |
|
| 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
