xmlQuelle
admin
Uncategorised
Zugriffe: 92
- 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