product_feature

Data license: CC-BY-4.0 · Data source: bankproducts.info

1 row where product_id = "cmv:compte_salaire_non_domicilie"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ product_id feature_key feature_value note source_page
cmv:compte_salaire_non_domicilie:pf:salaire_non_domicilie_ch_separates_produkt_novel_cross_border_worker_target Compte Salaire Non domicilié en Suisse cmv:compte_salaire_non_domicilie pricing_condition CMV Compte Salaire Non-domicilie Named-Product: **Compte Salaire Non domicilie en Suisse** — separates Produkt fuer Grenzgaenger (Frontaliers, in FR wohnhaft, in CH arbeitend). Cross-Bank-Vergleich: Vallee-de-Joux-Region hat ca. 20% Grenzgaenger-Anteil aus FR. Novel: publiziertes Cross-Border-Worker-Target-Product. Novel Cross-Bank-Muster: Named-Product fuer Cross-Border-Workers (Grenzgaenger). Cross-Bank-Vergleich: die meisten Grenz-Regional-Banken haben Grenzgaenger als Klausel oder Fee-Segment (nicht Named-Product). CMV publiziert separates Produkt = signal fuer bewusste-Cross-Border-Segmentation. Cross-Bank-Vergleich: LEMAN Batch 37 hatte Grenzganger-Kohorte-Fees (aehnlich); SLT Batch 40 hatte Clientis-Verbund-Bancomat-Free-Zone (Grenzregion SH-DE). CMV geht am weitesten: eigenes Produkt-Namen = Marketing-Signal fuer diese Kunden-Cohorte. Signal: Vallee-de-Joux (Uhrenindustrie-Region) hat aktive Cross-Border-Employment-Struktur. 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE product_feature (
    id          TEXT PRIMARY KEY,
    product_id  TEXT NOT NULL REFERENCES product(id),
    feature_key TEXT NOT NULL,          -- withdrawal_limit_free, notice_period, daily_limit, monthly_limit,
                                        -- interest_late_payment, max_balance, included_services, ...
    feature_value TEXT,
    note        TEXT,
    source_page INTEGER
);
CREATE INDEX idx_product_feature_product ON product_feature(product_id);
CREATE INDEX idx_product_feature_key ON product_feature(feature_key);