| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TNPEPP | IS-H: PEPP Billing Parameters for Psychiatry/Psychosomatics | 5 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
TOPBasic Data |
2 | NLSU | IS-H: Totals File for Service Statistics | 8 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
TOPClinical System |
3 | N1ABWMSG | IS-H*MED: Assignment of service/check/message | 3 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
4 | N1DWSWL_SUGSURG | i.s.h.med DWS: Active Surgery Proposal Criteria | 6 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
5 | N1DWSWL_SUGSURG1 | i.s.h.med DWS: Inactive Surgery Proposal Criteria | 6 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
6 | N1KGTPL | IS-H*MED: Service quota of the performer for the requester | 3 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
7 | N1LAPP | services without case or movement reference | 8 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
8 | N1LSTGSPLIT | IS-H*MED: Surgical service split | 3 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
9 | N1NURSHIFT | IS-H*MED: Nurse shift times | 3 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
10 | N1OEA | IS-H*MED: Involved org.units dependent on task | 3 | ERBOE | Performing/Documenting Organizational Unit | nvarchar | 8 | 0 | | |
11 | N1PREFETCHSPOOL | IS-H*MED: RAD Prefetching Tasks | 6 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
12 | N1PRLEM | IS-H*MED: PATREG: Leistungen | 10 | ERBOE | IS-H: Hizmeti gerçeklestiren organizasyon brm.taniticisi | nvarchar | 8 | 0 | | |
13 | N1ROLZUO | IS-H*MED: Function assignment IS-H -> IS-H*MED | 3 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
14 | N1STAAL | IS-H*MED: Statuses for cost breakdown | 3 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
15 | N1URL | IS-H*MED: Addresses of files for browser | 6 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
16 | NLEM | IS-H*MED: Medical Service | 30 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
17 | TN1ROUTING | IS-H*MED: Routing Rules | 6 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
18 | TN2ERFABT | Cardiological Departments with Separate Number Ranges | 2 | ERBOE | Cardiology: Department Which Performs Service | nvarchar | 6 | 0 | | |
TOPDocuments |
19 | N1IM_STUDY | Meta Data of Image Study | 11 | ERBOE | Organizational Unit Which Performs the Service | nvarchar | 8 | 0 | | |
TOPPatient Accounting |
20 | NGLT | IS-H: Intermediate table for service statistics | 18 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
21 | NLCO | IS-HCO: Transfer information | 13 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
22 | NLEV | IS-H: Preliminary entered services | 33 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
23 | NMATP | IS-H: Material planned for case | 14 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
24 | NMATV | IS-H: Material Entered for Case | 15 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
25 | NSL2 | IS-H: Online error records of service statistics | 18 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
26 | NSLF | IS-H: Error records of service statistics | 18 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
27 | TNVSL | IS-H: Rules for Determining Multiplication Factors | 10 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
TOPPatient Management |
28 | NLEI | IS-H: Services Performed | 12 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
29 | NWPLACE_001 | IS-H / IS-H*MED: Work Environment (Specialization) | 7 | ERBOE | Performing OU in Work Environment | nvarchar | 8 | 0 | | |
TOPRadiology |
30 | N1PREFSPOOL | IS-H*MED: RAD Prefetching Tasks | 9 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
31 | /ISHFR/TNGAPH | IS-H FR: Supplements (Header Data) | 8 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
32 | /ISHFR/TNGAPP | IS-H FR: Supplements (Item Data) | 8 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
33 | NAH01 | IS-H AT: Umschlüsselung Sachkontonummer auf Kreditor | 4 | ERBOE | IS-H: ID der Organisationeinheit, die die Leistung erbringt | nvarchar | 8 | 0 | | |
34 | NCH42 | IS-H CH: Service Rules Service Maximum Values | 10 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
35 | NCH43 | IS-H CH: Leistungsregeln Zuschlagsleistungen | 7 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
36 | NCH43A | IS-H CH: Rollenumschlüsselung für Arztzuordnungen | 7 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
37 | NKLP | IS-H: Individual outpatient srv / ins.providers (AT) | 8 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
38 | NWATAGBA | IS-H AT: Ambulanzgebühren - Ergebnisse / zu verteilen | 9 | ERBOE | IS-H: ID der Organisationeinheit, die die Leistung erbringt | nvarchar | 8 | 0 | | |
39 | NWATALSE | IS-H AT: Amb. Leistungsstatistik - Ergebnisse | 6 | ERBOE | IS-H: ID der Organisationeinheit, die die Leistung erbringt | nvarchar | 8 | 0 | | |
40 | NWCHLCOEA | IS-HCO: Überleitungsinformationen | 14 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
41 | NWCHLS_RNLSR | IS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR) | 33 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
42 | TN1OEPR | IS-H*MED: Physician-OU Relatshp for Expanding Med.Basic Srvs | 2 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
43 | TNA40Z | IS-H AT: Zeiten für Zuschlagsleistungen | 6 | ERBOE | IS-H: ID der Organisationeinheit, die die Leistung erbringt | nvarchar | 8 | 0 | | |
44 | TNAUMLEI | IS-H AT: Umschlüsselung Leistung | 9 | ERBOE | IS-H: ID der Organisationeinheit, die die Leistung erbringt | nvarchar | 8 | 0 | | |
45 | TNCH51 | IS-H CH: Billing Agreement Items | 10 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
46 | TNCH52 | IS-h CH: Determination of Billing Agreements | 13 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
47 | TNCH60 | IS-H CH: Times for Surcharge Services | 6 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
48 | TNEO_BILLTYP_DET | IS-H: External Orders - Billing Type Determination | 4 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
49 | TNEO_CHARFAC_DET | IS-H: Charge Factor Value Determination for External Orders | 8 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
50 | TNEO_FEEDIST_DET | IS-H: External Orders - Determine Fee Breakdown Code | 10 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
51 | TNWAT_LEIKOM_HDR | IS-H AT: Leistungskombinationen umschlüsseln - Header | 7 | ERBOE | IS-H: ID der Organisationeinheit, die die Leistung erbringt | nvarchar | 8 | 0 | | |
52 | TNWCH103 | Fees: Determination of Breakdown Code | 12 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
53 | TNWCH80 | IS-H CH: Charge Factor Value Determination | 7 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
54 | TNWCH82 | IS-H CH: Punktwertermittlung für TARMED-Leistungen | 7 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
55 | TNWCH83 | Ermittlung der Baserate | 9 | ERBOE | IS-H: ID der Organisationeinheit, die die Leistung erbringt | nvarchar | 8 | 0 | | |
56 | TNWCHCO | IS-H: Aufträge bestimmen für Überleitung ins CO | 7 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
57 | TNWCHEA10 | IS-H CH: Abrechnungsartenermittlung für Externe Aufträge | 4 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
58 | TNWCHEA11 | IS-H CH: Punktwertermittlung für Externe Aufträge | 7 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
59 | TNWCHEA12 | Determine Fee Breakdown Code for Transfer of Ext. Order | 10 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
60 | TNWCHFEEPHYS | Service Rule Fee Physician for Fee-Based Services | 9 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
61 | TNWCHTMABRMAT | IS-H CH: TARMED - Leistungsregel Abrechenbarkeit Materialien | 9 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
62 | TNWCH_AL_EXTRA | IS-H CH: ANALYSE - Leistungsregeln Zuschlagsleistungen | 8 | ERBOE | IS-H : ID de l'unité org. réalisant la prestation | nvarchar | 8 | 0 | | |
63 | TNWCH_DRG_ACC | Swiss-DRG - Bewertungsrelation für Erlösabgrenzung | 4 | ERBOE | IS-H: ID der Organisationeinheit, die die Leistung erbringt | nvarchar | 8 | 0 | | |