• SQL: <Dokumente> <TxtOrt>Birsfelden</TxtOrt> <TxtPlz>4127</TxtPlz> </Dokumente>
1 2 1 Hugo Basel 4051 29 Aeschenplatz Manntest 1 1 1 1 1 3 0000000200_Lang 2 0 0 1 0 0 OE 1 0 2 0 0 Ausgewählte Attribute der Pkat 1 2 0 1 0 0 Name, Vorname 1 1 1 2 0 2 0 0 Policennummer 0 0 0 2 0 3 0 0 AHV-Nummer 0 0 0 2 0 4 0 0 Interne Personalnummer des Kunden 1 0 0 2 0 5 0 0 Organisationseinheit 1 0 0 2 0 6 0 0 Geschlecht 1 0 0 2 0 7 0 0 Zivilstand 1 0 0 2 0 8 0 0 U-Pflicht 1 0 0 2 0 9 0 0 Branche 1 0 0 2 0 10 0 0 Bezeichnung 1 0 0 2022-06-01 54 rothweim 0 1 11 1 0 0 0 0 rothweim 5034 54 0 0 41 42 9 1 1 2 1 1 0 1 2022-01-01 2022-01-01 9999-12-31 2023-01-01 1001-01-01 1001-01-01 1001-01-01 1001-01-01 1001-01-01 0 10004 9999-12-31 0.00000 1001-01-01 0 0 1 1 2 0.00000 2.00000 0 0 0 0 0 1 1001-01-01 0 0 1001-01-01 0 0 1001-01-01 0 0 0 0 0 0 0 0 0 1 10001 0 1001-01-01 1001-01-01 2 3 2 0 0 0 2 0 1 Alle versicherten Personen 1 9999-12-31 0 0 0 0 0 0 9999-12-31 2 12 0 0 -9999.99999 9999.99999 -99999999999.99 99999999999.99 0 1 1 Helvetia Teilautonom Vors./Vers. Prevo System AG Helvetia Teilautonom Vors./Vers. 5 0 0 0 1 1001-01-01 1001-01-01 0 rothweim 0 Aeschenplatz 29 4051 Basel 1 1 Firma Helvetia Teilautonom Vors./Vers. Aeschenplatz 29 4051 Basel 4668 2 0000000025_Lang 0000000025 1 0000000025_Lang 25 1 1 204 0 3 1 1 1 2 2 0 2022-01-01 2022-01-01 9999-12-31 2022-01-01 1001-01-01 127000.00 100.00000 100.00000 0.00000 0 -99999999999.99 -99999999999.99 -99999999999.99 -99999999999.99 -99999999999.99 -99999999999.99 22051.50 1784792.00 81053.00 1784792.00 81053.00 1330112.00 81053.00 1330112.00 81053.00 61143.00 0.00 245433.50 0 0 0 0 0 1001-01-01 1 0 1 0 0 1 0 0 0 0 -99999999999.99 -99999999999.99 -99999999999.99 -99999999999.99 -99999999999.99 -99999999999.99 0 1 0.00 43632.00 0.00 0.00000 194 3 1 1 1 568 3 228 1 1 127000.00 1 1 1 100.00000 SPe_obl_a 60945.00 0.00 0.00 0.00 2539.40 226715.40 280767.20 6094.50 0 0 1 0 EeSPe_obl -99999999999.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 ARs_offen -99999999999.99 19092.00 19092.00 19092.00 0.00 0.00 0.00 0.00 0 0 0 0 ERs_xy_of -99999999999.99 11455.00 0.00 11455.00 0.00 0.00 0.00 0.00 0 1 0 3 PKRs_offen -99999999999.99 3818.00 0.00 3818.00 0.00 0.00 0.00 0.00 0 0 0 0 SPe_a 101905.00 0.00 0.00 0.00 4588.10 403121.55 499802.00 11209.60 0 0 1 0 EeSPe -99999999999.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 EeSPe -99999999999.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 EeSPe -99999999999.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 EeSPe -99999999999.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 EeSPe -99999999999.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 ARs_offen -99999999999.99 24540.00 24540.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 ERs_xy_of -99999999999.99 14724.00 0.00 0.00 0.00 0.00 0.00 0.00 0 1 0 3 PKRs_offen -99999999999.99 4908.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 IR_offen 101905.00 61143.00 0.00 15417.00 0.00 0.00 0.00 975.10 24 0 0 1 IKR_offen 101905.00 20381.00 0.00 3083.00 0.00 0.00 0.00 164.90 24 0 0 1 ER_offen 101905.00 40762.00 0.00 9250.00 0.00 0.00 0.00 930.40 0 1 0 1 WaiR_offen 101905.00 20381.00 0.00 3083.00 0.00 0.00 0.00 260.90 0 4 0 1 UK_offen -99999999999.99 60945.00 0.00 0.00 0.00 0.00 0.00 60.90 0 0 0 0 KOF_offen -99999999999.99 1.00 0.00 0.00 0.00 0.00 0.00 400.00 0 0 0 0 BR_offen -99999999999.99 2229.80 0.00 0.00 0.00 0.00 0.00 133.40 3 0 0 3 BSe -99999999999.99 17117.90 0.00 0.00 0.00 0.00 0.00 1217.60 3 0 0 3 BK_offen -99999999999.99 400.00 0.00 0.00 0.00 0.00 0.00 27.80 3 0 0 3 KOR_offen -99999999999.99 3155.10 0.00 0.00 0.00 0.00 0.00 320.50 0 0 0 0 TA_offen -99999999999.99 60945.00 0.00 0.00 0.00 0.00 0.00 182.80 0 0 0 0 SIF1_offen -99999999999.99 60945.00 0.00 0.00 0.00 0.00 0.00 73.10 0 0 0 0 SIF2_offen -99999999999.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 US -99999999999.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 3771.00 12 918.80 1 2 1 Hugo Basel 4051 29 Aeschenplatz Manntest 1 1 1 1 1 3 0000000200_Lang 2 1 0 1 0 0 OE 1 0 2 0 0 Ausgewählte Attribute der Pkat 1 0 3 0 0 Individueller Text von Verbund 1 0 4 0 0 Individueller Text von Vertrag 1 0 5 0 0 Individueller Text von OE 1 0 6 0 0 Individueller Text von PKat 0 0 7 0 0 Interne Personalnummer 1 2 0 1 0 0 Name, Vorname 1 1 1 2 0 2 0 0 Policennummer 0 0 0 2 0 4 0 0 Interne Personalnummer des Kunden 1 0 0 2 0 5 0 0 Organisationseinheit 1 0 0 2022-05-01 54 rothweim 0 0 11 1 0 0 0 0 rothweim 5032 54 0 0 41 42 9 1 1 2 1 1 0 1 2022-01-01 2022-01-01 9999-12-31 2023-01-01 1001-01-01 1001-01-01 1001-01-01 1001-01-01 1001-01-01 0 10004 9999-12-31 0.00000 1001-01-01 0 0 1 1 2 0.00000 2.00000 0 0 0 0 0 1 1001-01-01 0 0 1001-01-01 0 0 1001-01-01 0 0 0 0 0 0 0 0 0 1 10001 0 1001-01-01 1001-01-01 2 3 2 0 0 0 2 0 25 1 1 204 0 3 1 1 1 2 2 0 2022-01-01 2022-01-01 9999-12-31 2022-01-01 1001-01-01 126000.00 100.00000 100.00000 0.00000 0 -99999999999.99 -99999999999.99 -99999999999.99 -99999999999.99 -99999999999.99 -99999999999.99 21910.00 1767174.00 80323.00 1767174.00 80323.00 1316954.00 80323.00 1316954.00 80323.00 60543.00 0.00 243794.30 0 0 0 0 0 1001-01-01 1 0 1 0 0 1 0 0 0 0 -99999999999.99 -99999999999.99 -99999999999.99 -99999999999.99 -99999999999.99 -99999999999.99 0 1 0.00 43395.00 0.00 0.00000 194 2 1 1 1 568 2 228 1 1 126000.00 1 1 1 100.00000 SPe_obl_a 60945.00 0.00 0.00 0.00 2031.50 226715.40 280767.20 6094.50 0 0 1 0 EeSPe_obl -99999999999.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 ARs_offen -99999999999.99 19092.00 19092.00 19092.00 0.00 0.00 0.00 0.00 0 0 0 0 ERs_xy_of -99999999999.99 11455.00 0.00 11455.00 0.00 0.00 0.00 0.00 0 1 0 3 PKRs_offen -99999999999.99 3818.00 0.00 3818.00 0.00 0.00 0.00 0.00 0 0 0 0 SPe_a 100905.00 0.00 0.00 0.00 3663.20 399210.80 494968.05 11099.60 0 0 1 0 EeSPe -99999999999.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 EeSPe -99999999999.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 EeSPe -99999999999.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 EeSPe -99999999999.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 EeSPe -99999999999.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 ARs_offen -99999999999.99 24303.00 24303.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 ERs_xy_of -99999999999.99 14582.00 0.00 0.00 0.00 0.00 0.00 0.00 0 1 0 3 PKRs_offen -99999999999.99 4861.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 IR_offen 100905.00 60543.00 0.00 15417.00 0.00 0.00 0.00 966.90 24 0 0 1 IKR_offen 100905.00 20181.00 0.00 3083.00 0.00 0.00 0.00 163.40 24 0 0 1 ER_offen 100905.00 40362.00 0.00 9250.00 0.00 0.00 0.00 921.10 0 1 0 1 WaiR_offen 100905.00 20181.00 0.00 3083.00 0.00 0.00 0.00 258.30 0 4 0 1 UK_offen -99999999999.99 60945.00 0.00 0.00 0.00 0.00 0.00 60.90 0 0 0 0 KOF_offen -99999999999.99 1.00 0.00 0.00 0.00 0.00 0.00 400.00 0 0 0 0 BR_offen -99999999999.99 2208.60 0.00 0.00 0.00 0.00 0.00 132.30 3 0 0 3 BSe -99999999999.99 17009.00 0.00 0.00 0.00 0.00 0.00 1211.20 3 0 0 3 BK_offen -99999999999.99 400.00 0.00 0.00 0.00 0.00 0.00 27.80 3 0 0 3 KOR_offen -99999999999.99 3128.30 0.00 0.00 0.00 0.00 0.00 318.10 0 0 0 0 TA_offen -99999999999.99 60945.00 0.00 0.00 0.00 0.00 0.00 182.80 0 0 0 0 SIF1_offen -99999999999.99 60945.00 0.00 0.00 0.00 0.00 0.00 73.10 0 0 0 0 SIF2_offen -99999999999.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 US -99999999999.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 3741.90 12 912.90 1 2 1 0 0 0 1 0 0 1 1 2022-01-01 54 rothweim 0 1 11 1 0 0 0 0 rothweim 5034 54 0 0 1131