Technische Dokumentation Modul CARE
Inhaltsverzeichnis
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. |