Technische Dokumentation Modul CARE

Inhaltsverzeichnis

Informationen

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