fct_payment_run


Description

This table contains all payment run bookings together with information about the payment run itself. A payment run is a scheduled event where a financial institution attempts to collect money from the customers. It consists of individual payment run bookings, those that are regular, those that failed and those that were already excluded before and therefore technically do not represent actually processed bookings

Columns

Column Type Size Nulls Auto Default Children Parents Comments
payment_run_id varchar 256 null

The primary key of this table. System column calculated by the source System.
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id erp_v2_fct_payment_run_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_6234eded60eb R

The gym (organization_unit) for which the payment run booking was executed
created_date timestamptz 35 √ null

UTC timestamp when the payment run was created.
charge_until_date date 13 √ null

Latest due date included in the payment run.
effective_collection_date_id int4 10 √ null
dim_date.date_id Implied Constraint R

The date at which the amount was actually collected
number varchar 256 √ null

The payment run number
payment_run_property_id varchar 256 √ null
dim_payment_run_property.payment_run_property_id erp_v2_fct_payment_run_payment_run_property_id__erp_v2_dim_payment_run_property_payment_run_property_id_fkey_c34472c8a249 R

ID of the payment run property
booking_type varchar 256 √ null

One of: REGULAR_BOOKING (amount was collected and can be returned later - see booking_status), FAILED_BOOKING (amount was tried to be collected and was returned - for the failure reasons see dim_payment_run_property.reason), EXCLUDED_BOOKING (amount is excluded from collection - for reasons see dim_payment_run_property table)
booking_number varchar 256 √ null

The explicit number of the booking within a payment run with the specified number
customer_id int8 19 √ null
dim_customer.customer_id erp_v2_fct_payment_run_customer_id__erp_v2_dim_customer_customer_id_fkey_8bd139378cfb R

The person related to the booking
amount numeric 19,2 √ null

The amount tried (see booking_type) to be collected from the person
currency_id varchar 256 √ null
dim_currency.currency_id erp_v2_fct_payment_run_currency_id__erp_v2_dim_currency_currency_id_fkey_3e612dd303a5 R

The system of money in which income was generated.
archived bool 1 √ null

Permanently removed but kept for historic relations
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