Technische Dokumentation Modul CARE

Inhaltsverzeichnis

Informationen

Dokumentationstyp: Endanwender (zur vollständigen 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

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.