Technische Dokumentation Modul CARE
Inhaltsverzeichnis
Dokumentationstyp: |
Vollständig (zur Endanwender Dokumentation) |
Erstellt am: |
25.04.2024 |
Modulversion: |
7 |
Modultyp: |
Basismodul |
Beschreibung: |
Modul für Leistungsabrechnung und Belegungszahlen in der Sozialwirtschaft |
Benötigt Administrator Rechte: |
Nein |
Ab OCT Version: |
5.10.11 |
Tabellen
integration.tCARE_Belegungszahlen
Tabelle für die Belegungszahlen des Moduls CARE.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
Technical primary Key for row identity. |
2 |
DataSourceKey |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
CompanyID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
EinrichtungsID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
5 |
KlientenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
6 |
KostenstellenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
KostentraegerID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
LeistungsID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
10 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
Status |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
12 |
DatumVon |
DATETIME |
check_circle |
highlight_off |
highlight_off |
|
|
13 |
DatumBis |
DATETIME |
check_circle |
highlight_off |
highlight_off |
|
|
14 |
Tage |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
15 |
Stunden |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
16 |
Pflegegrad |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
17 |
Pflegestufe |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
18 |
Abrechnung |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
19 |
Pflegeklasse |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
20 |
Sonderstatus |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
21 |
Leistungstyp |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
22 |
Zeittyp |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
23 |
CustomValuesJSON |
NVARCHAR(MAX) |
check_circle |
highlight_off |
highlight_off |
|
|
Referenziert von
integration.tCARE_Einrichtungen
Tabelle für die Einrichtungen des Moduls CARE.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
Technischer Primary Key des Datensatzes. |
2 |
DataSourceKey |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
CompanyID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
EinrichtungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
EinrichtungsName |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
EinrichtungsNameKuerzel |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
Parent_EinrichtungsID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
KostenstellenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
KostentraegerID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
EinrichtungsTypCODE |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
FiBuMandantenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
12 |
IstGruppe |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
13 |
IstAbrechenbar |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
14 |
IstWohnbereich |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
15 |
Platzzahl |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
16 |
Zeittyp |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
17 |
CustomValuesJSON |
NVARCHAR(MAX) |
check_circle |
highlight_off |
highlight_off |
|
|
Referenziert von
integration.tCARE_Klienten
Tabelle für die Klienten des Moduls CARE.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
Technischer Primary Key des Datensatzes. |
2 |
DataSourceKey |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
CompanyID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
KlientenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
KlientenName |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
Klientenvorname |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
EinrichtungsID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
Geburtsdatum |
DATE |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
GeschlechtCODE |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
KonfessionCODE |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
11 |
Strasse |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
12 |
PLZ |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
13 |
Pflegestufe |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
14 |
Eintrittsdatum |
DATE |
check_circle |
highlight_off |
highlight_off |
|
|
15 |
Austrittsdatum |
DATE |
check_circle |
highlight_off |
highlight_off |
|
|
16 |
DebitorKto |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
17 |
Zahlungsmodalitaet |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
18 |
CustomValuesJSON |
NVARCHAR(MAX) |
check_circle |
highlight_off |
highlight_off |
|
|
Referenziert von
integration.tCARE_Klientenbereichszuordnung
Tabelle für die Klientenbereichszuordnung des Moduls CARE_VIVENDI.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
Technical primary Key for row identity. |
2 |
DataSourceKey |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
CompanyID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
EinrichtungsID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
5 |
KlientenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
6 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
DatumVon |
DATETIME |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
DatumBis |
DATETIME |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
Tage |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
11 |
Zimmer |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
12 |
CustomValuesJSON |
NVARCHAR(MAX) |
check_circle |
highlight_off |
highlight_off |
|
|
Referenziert von
integration.tCARE_Leistungen
Tabelle für die Leistungen des Moduls CARE.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
Technischer Primary Key des Datensatzes. |
2 |
DataSourceKey |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
CompanyID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
LeistungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
Parent_LeistungsID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
6 |
LeistungsName |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
Preis |
MONEY |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
LeistungsArt |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
Kuerzel |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
Beschreibung |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
11 |
Ertragskonto |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
12 |
Abrechenbar |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
13 |
Preisgruppe |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
14 |
GueltigVon |
DATE |
check_circle |
highlight_off |
highlight_off |
|
|
15 |
CustomValuesJSON |
NVARCHAR(MAX) |
check_circle |
highlight_off |
highlight_off |
|
|
Referenziert von
integration.tCARE_Leistungsabrechnung
Tabelle für die Leistungsabrechnung des Moduls CARE.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
Technical primary Key for row identity. |
2 |
DataSourceKey |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
CompanyID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
EinrichtungsID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
5 |
KlientenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
6 |
KostenstellenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
KostentraegerID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
KontenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
LeistungsID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
12 |
Rechnungsnummer |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
13 |
DatumVon |
DATETIME |
check_circle |
highlight_off |
highlight_off |
|
|
14 |
DatumBis |
DATETIME |
check_circle |
highlight_off |
highlight_off |
|
|
15 |
Tage |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
16 |
Stunden |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
17 |
Minuten |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
18 |
Preis |
BIGINT |
check_circle |
highlight_off |
highlight_off |
|
|
19 |
Betrag |
BIGINT |
check_circle |
highlight_off |
highlight_off |
|
|
20 |
Anzahl |
BIGINT |
check_circle |
highlight_off |
highlight_off |
|
|
21 |
Rechnungsempfänger |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
22 |
LeistungsKuerzel |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
23 |
LeistungName |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
24 |
Status |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
25 |
Datum |
DATE |
check_circle |
highlight_off |
highlight_off |
|
|
26 |
Wohngruppe |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
27 |
Kostenzusage_von |
DATE |
check_circle |
highlight_off |
highlight_off |
|
|
28 |
Kostenzusage_bis |
DATE |
check_circle |
highlight_off |
highlight_off |
|
|
29 |
Hilfbedarfsgruppe |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
30 |
Preisgruppe |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
31 |
KostentraegerName |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
32 |
KostentraegerArtID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
33 |
KostentraegerArtName |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
34 |
CustomValuesJSON |
NVARCHAR(MAX) |
check_circle |
highlight_off |
highlight_off |
|
|
Referenziert von
integration.tCARE_Leistungserbringung
Tabelle für die Leistungserbringung des Moduls CARE.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
Technical primary Key for row identity. |
2 |
DataSourceKey |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
CompanyID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
EinrichtungsID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
5 |
KlientenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
6 |
KostenstellenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
KostentraegerID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
KontenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
LeistungsID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
12 |
Rechnungsnummer |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
13 |
DatumVon |
DATETIME |
check_circle |
highlight_off |
highlight_off |
|
|
14 |
DatumBis |
DATETIME |
check_circle |
highlight_off |
highlight_off |
|
|
15 |
Tage |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
16 |
Stunden |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
17 |
Minuten |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
18 |
Preis |
BIGINT |
check_circle |
highlight_off |
highlight_off |
|
|
19 |
Betrag |
BIGINT |
check_circle |
highlight_off |
highlight_off |
|
|
20 |
Anzahl |
BIGINT |
check_circle |
highlight_off |
highlight_off |
|
|
21 |
Solldauer |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
22 |
MitarbeiterID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
23 |
OrganisationsEinheit |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
24 |
CustomValuesJSON |
NVARCHAR(MAX) |
check_circle |
highlight_off |
highlight_off |
|
|
Referenziert von
result.tCARE_Belegungszahlen
Tabelle für die Belegungszahlen des Moduls CARE.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
CompanyKey |
NVARCHAR(53) |
highlight_off |
highlight_off |
highlight_off |
|
|
2 |
MandantenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
EinrichtungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
KlientenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
KostenstellenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
KostentraegerID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
LeistungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
9 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
10 |
Status |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
DatumVon |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
12 |
DatumBis |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
13 |
Tage |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
14 |
Stunden |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
15 |
Pflegegrad |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
16 |
Pflegestufe |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
17 |
Abrechnung |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
18 |
Pflegeklasse |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
19 |
Sonderstatus |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
20 |
Leistungstyp |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
21 |
Zeittyp |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
22 |
RowKey |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
Technical primary Key for row identity. |
result.tCARE_Einrichtungen
Tabelle für die Einrichtungen des Moduls CARE.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
CompanyKey |
NVARCHAR(53) |
highlight_off |
highlight_off |
highlight_off |
|
|
2 |
MandantenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
EinrichtungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
EinrichtungsName |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
EinrichtungsNameKuerzel |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
Parent_EinrichtungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
KostenstellenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
KostentraegerID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
9 |
EinrichtungsTyp |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
10 |
FiBuMandantenID |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
IstGruppe |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
12 |
IstAbrechenbar |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
13 |
IstWohnbereich |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
14 |
Platzzahl |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
15 |
Zeittyp |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
16 |
RowKey |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
Technischer Primary Key des Datensatzes. |
result.tCARE_Klienten
Tabelle für die Klienten des Moduls CARE.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
CompanyKey |
NVARCHAR(53) |
highlight_off |
highlight_off |
highlight_off |
|
|
2 |
MandantenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
KlientenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
KlientenName |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
Klientenvorname |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
EinrichtungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
Geburtsdatum |
DATE |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
Geschlecht |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
9 |
Konfession |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
10 |
Strasse |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
PLZ |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
12 |
Pflegestufe |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
13 |
Eintrittsdatum |
DATE |
highlight_off |
highlight_off |
highlight_off |
|
|
14 |
Austrittsdatum |
DATE |
highlight_off |
highlight_off |
highlight_off |
|
|
15 |
Austrittsgrund |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
16 |
DebitorKto |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
17 |
Zahlungsmodalitaet |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
18 |
RowKey |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
Technischer Primary Key des Datensatzes. |
result.tCARE_Klientenbereichszuordnung
Tabelle für die Klientenbereichszuordnung des Moduls CARE_VIVENDI.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
CompanyKey |
NVARCHAR(53) |
highlight_off |
highlight_off |
highlight_off |
|
|
2 |
MandantenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
EinrichtungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
KlientenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
DatumVon |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
DatumBis |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
9 |
Tage |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
10 |
Zimmer |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
RowKey |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
Technical primary Key for row identity. |
result.tCARE_Leistungen
Tabelle für die Leistungen des Moduls CARE.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
CompanyKey |
NVARCHAR(53) |
highlight_off |
highlight_off |
highlight_off |
|
|
2 |
MandantenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
LeistungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
Parent_LeistungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
LeistungsName |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
Preis |
MONEY |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
LeistungsArt |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
Kuerzel |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
9 |
Beschreibung |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
10 |
Ertragskonto |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
Abrechenbar |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
12 |
Preisgruppe |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
13 |
GueltigVon |
DATE |
highlight_off |
highlight_off |
highlight_off |
|
|
14 |
RowKey |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
Technischer Primary Key des Datensatzes. |
result.tCARE_Leistungsabrechnung
Tabelle für die Leistungsabrechnung des Moduls CARE.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
CompanyKey |
NVARCHAR(53) |
highlight_off |
highlight_off |
highlight_off |
|
|
2 |
MandantenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
EinrichtungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
KlientenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
KostenstellenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
KostentraegerID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
KontenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
LeistungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
9 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
10 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
Rechnungsnummer |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
12 |
DatumVon |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
13 |
DatumBis |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
14 |
Tage |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
15 |
Stunden |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
16 |
Minuten |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
17 |
Preis |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
|
18 |
Betrag |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
|
19 |
Anzahl |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
|
20 |
Rechnungsempfänger |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
21 |
LeistungsKuerzel |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
22 |
LeistungName |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
23 |
Status |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
24 |
Datum |
DATE |
highlight_off |
highlight_off |
highlight_off |
|
|
25 |
Wohngruppe |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
26 |
Kostenzusage_von |
DATE |
highlight_off |
highlight_off |
highlight_off |
|
|
27 |
Kostenzusage_bis |
DATE |
highlight_off |
highlight_off |
highlight_off |
|
|
28 |
Hilfbedarfsgruppe |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
29 |
Preisgruppe |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
30 |
KostentraegerName |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
31 |
KostentraegerArtID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
32 |
KostentraegerArtName |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
33 |
RowKey |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
Technical primary Key for row identity. |
result.tCARE_Leistungserbringung
Tabelle für die Leistungserbringung des Moduls CARE.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
CompanyKey |
NVARCHAR(53) |
highlight_off |
highlight_off |
highlight_off |
|
|
2 |
MandantenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
EinrichtungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
KlientenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
KostenstellenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
KostentraegerID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
KontenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
LeistungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
9 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
10 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
Rechnungsnummer |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
12 |
DatumVon |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
13 |
DatumBis |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
14 |
Tage |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
15 |
Stunden |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
16 |
Minuten |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
17 |
Preis |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
|
18 |
Betrag |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
|
19 |
Anzahl |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
|
20 |
SollDauer |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
21 |
MitarbeiterID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
22 |
OrganisationsEinheit |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
23 |
RowKey |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
Technical primary Key for row identity. |
Sichten
agent.vJSON_integration_tCARE_Belegungszahlen
This view resolves the CustomValuesJSON column in table integration.tCARE_Belegungszahlen to actual columns.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
RowKey |
Referenzierte Objekte
Referenziert von
agent.vJSON_integration_tCARE_Einrichtungen
This view resolves the CustomValuesJSON column in table integration.tCARE_Einrichtungen to actual columns.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
RowKey |
Referenzierte Objekte
Referenziert von
agent.vJSON_integration_tCARE_Klienten
This view resolves the CustomValuesJSON column in table integration.tCARE_Klienten to actual columns.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
RowKey |
Referenzierte Objekte
Referenziert von
agent.vJSON_integration_tCARE_Klientenbereichszuordnung
This view resolves the CustomValuesJSON column in table integration.tCARE_Klientenbereichszuordnung to actual columns.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
RowKey |
Referenzierte Objekte
Referenziert von
agent.vJSON_integration_tCARE_Leistungen
This view resolves the CustomValuesJSON column in table integration.tCARE_Leistungen to actual columns.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
RowKey |
Referenzierte Objekte
Referenziert von
agent.vJSON_integration_tCARE_Leistungsabrechnung
This view resolves the CustomValuesJSON column in table integration.tCARE_Leistungsabrechnung to actual columns.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
RowKey |
Referenzierte Objekte
Referenziert von
agent.vJSON_integration_tCARE_Leistungserbringung
This view resolves the CustomValuesJSON column in table integration.tCARE_Leistungserbringung to actual columns.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
RowKey |
Referenzierte Objekte
Referenziert von
result.vCARE_Belegungszahlen
View stellt die Belegungszahlen bereit.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
CompanyKey |
NVARCHAR(53) |
check_circle |
highlight_off |
highlight_off |
|
CompanyKey |
2 |
MandantenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
EinrichtungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
KlientenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
KostenstellenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
KostentraegerID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
LeistungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
9 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
10 |
Status |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
DatumVon |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
12 |
DatumBis |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
13 |
Tage |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
14 |
Stunden |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
15 |
Pflegegrad |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
16 |
Pflegestufe |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
17 |
Abrechnung |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
18 |
Pflegeklasse |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
19 |
Sonderstatus |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
20 |
Leistungstyp |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
21 |
Zeittyp |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
22 |
RowKey |
BIGINT |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
Referenziert von
result.vCARE_Einrichtungen
View stellt die Einrichtungen bereit.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
CompanyKey |
NVARCHAR(53) |
check_circle |
highlight_off |
highlight_off |
|
CompanyKey |
2 |
MandantenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
EinrichtungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
EinrichtungsName |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
EinrichtungsNameKuerzel |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
Parent_EinrichtungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
KostenstellenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
KostentraegerID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
9 |
EinrichtungsTyp |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
10 |
FiBuMandantenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
IstGruppe |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
12 |
IstAbrechenbar |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
13 |
IstWohnbereich |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
14 |
Platzzahl |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
15 |
Zeittyp |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
16 |
RowKey |
BIGINT |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
Referenziert von
result.vCARE_Klienten
View stellt die Klienten bereit.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
CompanyKey |
NVARCHAR(53) |
check_circle |
highlight_off |
highlight_off |
|
CompanyKey |
2 |
MandantenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
KlientenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
KlientenName |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
Klientenvorname |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
EinrichtungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
Geburtsdatum |
DATE |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
Geschlecht |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
9 |
Konfession |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
10 |
Strasse |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
PLZ |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
12 |
Pflegestufe |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
13 |
Eintrittsdatum |
DATE |
highlight_off |
highlight_off |
highlight_off |
|
|
14 |
Austrittsdatum |
DATE |
highlight_off |
highlight_off |
highlight_off |
|
|
15 |
DebitorKto |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
16 |
Zahlungsmodalitaet |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
17 |
RowKey |
BIGINT |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
Referenziert von
result.vCARE_Klientenbereichszuordnung
vCARE_Klientenbereichszuordnung
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
CompanyKey |
NVARCHAR(53) |
check_circle |
highlight_off |
highlight_off |
|
|
2 |
MandantenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
EinrichtungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
KlientenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
DatumVon |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
DatumBis |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
9 |
Tage |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
10 |
Zimmer |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
RowKey |
BIGINT |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
Referenziert von
result.vCARE_Leistungen
View stellt die Leistungen bereit.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
CompanyKey |
NVARCHAR(53) |
check_circle |
highlight_off |
highlight_off |
|
CompanyKey |
2 |
MandantenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
LeistungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
Parent_LeistungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
LeistungsName |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
Preis |
MONEY |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
LeistungsArt |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
Kuerzel |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
9 |
Beschreibung |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
10 |
Ertragskonto |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
Abrechenbar |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
12 |
Preisgruppe |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
13 |
GueltigVon |
DATE |
highlight_off |
highlight_off |
highlight_off |
|
|
14 |
RowKey |
BIGINT |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
Referenziert von
result.vCARE_Leistungsabrechnung
View stellt die Leistungsabrechnung bereit.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
CompanyKey |
NVARCHAR(53) |
check_circle |
highlight_off |
highlight_off |
|
CompanyKey |
2 |
MandantenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
EinrichtungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
KlientenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
KostenstellenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
KostentraegerID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
KontenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
LeistungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
9 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
10 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
Rechnungsnummer |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
12 |
DatumVon |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
13 |
DatumBis |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
14 |
Tage |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
15 |
Stunden |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
16 |
Minuten |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
17 |
Preis |
MONEY |
check_circle |
highlight_off |
highlight_off |
|
|
18 |
Betrag |
MONEY |
check_circle |
highlight_off |
highlight_off |
|
|
19 |
Anzahl |
MONEY |
check_circle |
highlight_off |
highlight_off |
|
|
20 |
Rechnungsempfänger |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
21 |
LeistungsKuerzel |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
22 |
LeistungName |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
23 |
Status |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
24 |
Datum |
DATE |
highlight_off |
highlight_off |
highlight_off |
|
|
25 |
Wohngruppe |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
26 |
Kostenzusage_von |
DATE |
highlight_off |
highlight_off |
highlight_off |
|
|
27 |
Kostenzusage_bis |
DATE |
highlight_off |
highlight_off |
highlight_off |
|
|
28 |
Hilfbedarfsgruppe |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
29 |
Preisgruppe |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
30 |
KostentraegerName |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
31 |
KostentraegerArtID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
32 |
KostentraegerArtName |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
33 |
RowKey |
BIGINT |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
Referenziert von
result.vCARE_Leistungserbringung
View stellt die Leistungserbringung bereit.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
CompanyKey |
NVARCHAR(53) |
check_circle |
highlight_off |
highlight_off |
|
CompanyKey |
2 |
MandantenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
EinrichtungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
KlientenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
KostenstellenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
KostentraegerID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
KontenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
LeistungsID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
9 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
10 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
Rechnungsnummer |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
12 |
DatumVon |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
13 |
DatumBis |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
14 |
Tage |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
15 |
Stunden |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
16 |
Minuten |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
17 |
Preis |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
|
18 |
Betrag |
MONEY |
check_circle |
highlight_off |
highlight_off |
|
|
19 |
Anzahl |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
|
20 |
Solldauer |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
21 |
MitarbeiterID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
22 |
OrganisationsEinheit |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
23 |
RowKey |
BIGINT |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
Referenziert von
Prozeduren
agent.pDeleteIntegrationValuesCARE
This stored procedure is used to delete data from all tables of the module "CARE".
# |
Parameter |
Datentyp |
1 |
@DataSourceKey |
INT |
|
DataSourceKey |
2 |
@CompanyID |
NVARCHAR(50) |
|
OCT identifier for the company. Part of AccountKey. |
3 |
@PeriodFrom |
INT |
|
PeriodFrom |
4 |
@PeriodTo |
INT |
|
PeriodTo |
5 |
@MasterDataOnly |
BIT |
|
MasterDataOnly |
6 |
@Username |
NVARCHAR(255) |
|
Username |
7 |
@ProcessID |
NVARCHAR(50) |
|
ProcessID |
8 |
@SubProcessID |
NVARCHAR(50) |
|
SubProcessID |
9 |
@IsDeltaloadBool |
BIT |
|
IsDeltaloadBool |
10 |
@Solution |
NVARCHAR(50) |
|
Solution |
Referenzierte Objekte
agent.pSyncCARE
This stored procedure is used to sync data from all tables of the module "CARE".
# |
Parameter |
Datentyp |
1 |
@Username |
NVARCHAR(255) |
|
Username |
2 |
@ResultOnly |
INT |
|
ResultOnly |
3 |
@CompanyKeys |
NVARCHAR(MAX) |
|
CompanyKeys |
4 |
@ProcessID |
NVARCHAR(50) |
|
ProcessID |
5 |
@SubProcessID |
NVARCHAR(50) |
|
SubProcessID |
Referenzierte Objekte