| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic Data |
1 | TN14A | IS-H: Movement Categories | 3 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
2 | TN14T | IS-H: Texts of Movement Categories | 4 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
3 | TN14U | IS-H: Texts for Movement Types | 4 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
4 | TNREL | IS-H: Insurance Provider Assignments | 6 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
TOPBenefits |
5 | T5UBA | Benefit plan | 49 | BEWTY | Benefit wage type for bonus employee pre-tax amount | nvarchar | 4 | 0 | | |
TOPClinical System |
6 | N1PRBEW | IS-H*MED: PATREG: Bewegungen | 5 | BEWTY | IS-H: Islem tipi | nvarchar | 1 | 0 | | |
7 | N1STAAL | IS-H*MED: Statuses for cost breakdown | 4 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
8 | N2DOCBEWLEI | IS-H*MED: Movement and Service Data for Archived Documents | 8 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
TOPCommunication |
9 | TN14B_SE_MAP | Map Movement types | 3 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
10 | TN14G_SE_MAP | Map Movement Reasons (EDI) | 2 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
11 | TN14H_SE_MAP | Map Referral Types | 3 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
TOPPatient Accounting |
12 | TN19D | Proposal of Treatment Certificates | 5 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
13 | TNVSL | IS-H: Rules for Determining Multiplication Factors | 11 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
TOPPatient Management |
14 | N1APCN | IS-H: Appointment Defaults | 4 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
15 | N1CORDTYP | IS-H: Clinical Order Type | 13 | BEWTY | CORD/PREG: Clinical Order Type - Movement Category | nvarchar | 1 | 0 | | |
16 | N1VKG | IS-H: Item of Clinical Order (Preregistration) | 84 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
17 | NBEW | IS-H: Movements for Case | 5 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
18 | NTMN | IS-H: Patient-Specific Appointments (Header Table for NAPP) | 66 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
19 | NWPLACE_DTM | IS-H: Determination of Work Environment at Callup | 11 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
20 | TN14B | IS-H: Movement types | 3 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
21 | TN14G | IS-H: Movement Reasons (EDI) | 2 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
22 | TN14H | IS-H: Referral Types | 3 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
23 | TN14R | IS-H: Movement reasons (§301) - Text | 3 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
24 | TN14Y | IS-H: Texts for referral types | 4 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
25 | TNVRGC | IS-H: Bus.Transaction Check on Single Field Level (Customer) | 6 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
26 | TNVRGR | IS-H: Business Transaction Check on Single Field Level (SAP) | 4 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
TOPSAP Ambulatory Care Management |
27 | TNAMB_BWART2FATY | IS-H: Assignment of Movement Types to Case Categories | 4 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
28 | /ISHFR/TNWFR_F10 | IS-H FR: Per Diem Fee | 4 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
29 | /ISHFR/TNWFR_F19 | Surcharge for Care Path (CCP) | 4 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
30 | /ISHFR/TNWFR_F21 | Absence Control | 4 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
31 | N2DWSWL_SUGGEST | Criteria for Situation Template Proposal | 7 | BEWTY | Movement Category Search Criteria | nvarchar | 1 | 0 | | |
32 | N2DWSWL_SUGGEST1 | Criteria for Proposal of Situation Template / Changes | 7 | BEWTY | Movement Category Search Criteria | nvarchar | 1 | 0 | | |
33 | NLVERZF_006 | Konversion SAP bewegungsart nach VEKTIS bewegingsart | 3 | BEWTY | IS-H: Bewegingstype | nvarchar | 1 | 0 | | |
34 | NLWARTE_001 | NL - Warteliste Bewegungen zum Fall | 5 | BEWTY | IS-H: Bewegingstype | nvarchar | 1 | 0 | | |
35 | NS01 | IS-H: Statistics database - movements | 6 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
36 | TN22E | Ermittlung der Verwendung für ambulante Zuzahlung | 3 | BEWTY | IS-H: Bewegungstyp | nvarchar | 1 | 0 | | |
37 | TN48 | IS-H: Fee on Admission and Discharge Day | 3 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
38 | TN50E | Maximum Patient Contribution | 3 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
39 | TNAFD | IS-H: Outpatient Admission Fee Determination | 3 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
40 | TNCH51 | IS-H CH: Billing Agreement Items | 12 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |
41 | TNLMR5 | IS-H NL: LMR Bewegingscodes | 3 | BEWTY | IS-H: Bewegingstype | nvarchar | 1 | 0 | | |
42 | TNNL1 | IS-H NL: LMR discharge type | 3 | BEWTY | Movement Category | nvarchar | 1 | 0 | | |