SAP ABAP Table RNWCH_SDRG_BFS_DIA (Struktur Swiss-DRG - BFS-Daten - Diagnosen)
Hierarchy
☛
IS-H (Software Component) SAP Healthcare
⤷ IS-H (Application Component) SAP Healthcare - Industry-Specific Components for Hospitals
⤷ NCH1 (Package) IS-H: Landesversion Schweiz
⤷ IS-H (Application Component) SAP Healthcare - Industry-Specific Components for Hospitals
⤷ NCH1 (Package) IS-H: Landesversion Schweiz
Basic Data
Table Category | INTTAB | Structure |
Structure | RNWCH_SDRG_BFS_DIA | Table Relationship Diagram |
Short Description | Struktur Swiss-DRG - BFS-Daten - Diagnosen |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CODEDIA | NWCH_SDRG_CODE_DIA | CHAR6 | CHAR | 6 | 0 | Swiss DRG - Code der Diagnose | ||
2 | SEITDIA | NWCH_SDRG_SIDE_DIA | CHAR1 | CHAR | 1 | 0 | Swiss DRG - Seitigkeit der Diagnose | ||
3 | TUMDIA | NWCH_SDRG_TUM_DIA | CHAR1 | CHAR | 1 | 0 | Swiss DRG - Tumoraktivität der Diagnose | ||
4 | NDIA | NDIA | STRU | 0 | 0 | ||||
5 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
6 | EINRI | EINRI | EINRI | CHAR | 4 | 0 | IS-H: Institution | ||
7 | FALNR | FALNR | FALNR | CHAR | 10 | 0 | IS-H: Case Number | ||
8 | LFDNR | LFDDIA | LFDDIA | NUMC | 3 | 0 | IS-H: Sequence Number of Diagnosis | ||
9 | LFDBEW | LFDBEW | LFDBEW | NUMC | 5 | 0 | IS-H: Sequence Number of Movement | ||
10 | BELNR | KS_BELNR | KS_BELNR | CHAR | 10 | 0 | IS-H: Document Number of IV Document/Treatment Certificate | ||
11 | DKAT1 | DIAKAT | KATID | CHAR | 2 | 0 | IS-H: Identification Key of Diagnosis Coding Catalog | ||
12 | DKEY1 | DIAID | DIAID | CHAR | 30 | 0 | IS-H: Diagnosis Code | ||
13 | DKAT2 | DIAKAT | KATID | CHAR | 2 | 0 | IS-H: Identification Key of Diagnosis Coding Catalog | ||
14 | DKEY2 | DIAID | DIAID | CHAR | 30 | 0 | IS-H: Diagnosis Code | ||
15 | DKAT_REF | REF_DIAKAT | KATID | CHAR | 2 | 0 | IS-H: Catalog ID of Reference Catalog for Statistics | ||
16 | DKEY_REF | REF_DIAID | DIAID | CHAR | 30 | 0 | IS-H: Reference Diagnosis Code for Statistics | ||
17 | DITXT | ISH_DITEXT | TEXT50 | CHAR | 50 | 0 | IS-H: Free-Text Diagnosis | ||
18 | DILTX | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
19 | DIADT | DIADT | RI_DATUM | DATS | 8 | 0 | IS-H: Date on which Diagnosis Was Created | ||
20 | DIAZT | DIAZT | UHRZT | TIMS | 6 | 0 | IS-H: Time at which Diagnosis Created | ||
21 | DIAPE | DIA_PERS | RI_KUNNR | CHAR | 10 | 0 | IS-H: Identification of Diagnosing Person | ||
22 | ANZOP | ANZOP | NUM02 | NUMC | 2 | 0 | IS-H: Number of Surgeries Occasioned by Dept. Main Diagnosis | ||
23 | EWDIA | KZ_EINWD | XFELD | CHAR | 1 | 0 | IS-H: Referral Diagnosis Indicator | ||
24 | BHDIA | KZ_BEHLD | XFELD | CHAR | 1 | 0 | IS-H: Treatment Diagnosis Indicator | ||
25 | AFDIA | KZ_AUFND | XFELD | CHAR | 1 | 0 | IS-H: Admission Diagnosis Indicator | ||
26 | ENDIA | KZ_ENTLD | XFELD | CHAR | 1 | 0 | IS-H: "Discharge Diagnosis" Indicator | ||
27 | FHDIA | KZ_FAHPD | XFELD | CHAR | 1 | 0 | IS-H: "Department Main Diagnosis" Indicator | ||
28 | KHDIA | KZ_KHHPD | XFELD | CHAR | 1 | 0 | IS-H: Hospital Main Diagnosis Indicator | ||
29 | OPDIA | KZ_OPERD | XFELD | CHAR | 1 | 0 | IS-H: Surgery Diagnosis Indicator | ||
30 | SPERR | RI_SPERR | XFELD | CHAR | 1 | 0 | Blocking Indicator | ||
31 | KZTXT | TEXT_DIA | TEXT50 | CHAR | 50 | 0 | IS-H: Comment on Diagnosis | ||
32 | LGTXT | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
33 | DIASI | DIASI | DIASI | CHAR | 1 | 0 | IS-H: Diagnostic Certainty | ||
34 | ERDAT | RI_ERDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Record Created | ||
35 | ERTIM | RI_ERTIM | UHRZT | TIMS | 6 | 0 | IS-H: Time Record Created | ||
36 | ERUSR | RI_ERNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Employee who Created Record | ||
37 | UPDAT | RI_UPDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Last Change | ||
38 | UPUSR | RI_UPNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Person who Last Changed Data | ||
39 | STORN | RI_STORN | XFELD | CHAR | 1 | 0 | IS-H: Cancellation Indicator | ||
40 | STUSR | STORN_USER | USNAM | CHAR | 12 | 0 | IS-H: Name of User who Canceled Data Record | ||
41 | STDAT | STORN_DAT | RI_DATUM | DATS | 8 | 0 | Date of Cancellation | ||
42 | ARDIA | N2_KZARDIA | XFELD | CHAR | 1 | 0 | Working Diagnosis Indicator | ||
43 | PODIA | N2_KZPODIA | XFELD | CHAR | 1 | 0 | Preoperative Diagnosis Indicator | ||
44 | TUDIA | N2_KZTUDIA | XFELD | CHAR | 1 | 0 | IS-H: Cause of Death Indicator | ||
45 | DIABZ | N2_DIABZ | XFELD | CHAR | 1 | 0 | Diagnosis Reference | ||
46 | DIAPR | N2_DIAPR | N2_DIAPR | CHAR | 1 | 0 | Medical Secondary Diagnosis Indicator | ||
47 | DIAGW | N2_DIASI | N2_DIASI | CHAR | 2 | 0 | Diagnostic Certainty | ||
48 | DIAZS | N2_DIAZS | N2_DIAZS | CHAR | 2 | 0 | Diagnostic Suppl. | ||
49 | DIALO | N2_DIALO | N2_DIALO | CHAR | 2 | 0 | IS-H: Localization of Diagnosis | ||
50 | EXTID | N2_EXTID | N2_EXTID | CHAR | 8 | 0 | Internal Identifier of the Diagnosis Coding Tool | ||
51 | DIAFP | N2_DIAFP | N2_DIAFP | CHAR | 8 | 0 | Flat Rate per Case | ||
52 | REFKY | DIA_REFKEY | ISH_REFKY | CHAR | 20 | 0 | IS-H: Reference Code of Diagnosis from External System | ||
53 | DRG_DIA_SEQNO | ISH_DRG_DIA_NB | LFD_NR_DRG_DIA | NUMC | 6 | 0 | IS-H: Consecutive Numbering of DRG Diagnosis | ||
54 | DRG_CATEGORY | ISH_DRG_DIA_CATEGORY | ISH_DRG_DIA_CAT_TYPE | CHAR | 1 | 0 | IS-H: Category of DRG Diagnosis (Principal, Secondary) | ||
55 | DRG_CC | ISH_DRG_DIA_CC | ISH_ON_OFF | CHAR | 1 | 0 | IS-H: Comorbidity and Complication (DRG Diagnosis) | ||
56 | DRG_RELVANT | ISH_DRG_DIA_RELEVANT | ISH_ON_OFF | CHAR | 1 | 0 | IS-H: Used to Determine DRG | ||
57 | DTYP1 | ISH_ICD10_DIATYP | ISH_DIATYP | CHAR | 1 | 0 | Type for ICD-10 Diagnoses | ||
58 | DTYP2 | ISH_ICD10_DIATYP | ISH_DIATYP | CHAR | 1 | 0 | Type for ICD-10 Diagnoses | ||
59 | DTYP_REF | ISH_ICD10_DIATYP | ISH_DIATYP | CHAR | 1 | 0 | Type for ICD-10 Diagnoses | ||
60 | ALTERN_DIATXT | ISH_ALTERN_DIATXT | TXT132 | CHAR | 132 | 0 | IS-H: Alternative Diagnosis Text (from External System) | ||
61 | TCODE | ISH_TCODE | TCODE | CHAR | 20 | 0 | IS-H: Report Control: Transaction Code for Application | ||
62 | DIA_LINK | ISH_DIA_LINK | LFDDIA | NUMC | 3 | 0 | IS-H: Link to Another Diagnosis | ||
63 | CCL | ISH_CCL | ISH_CCL_TYPE | NUMC | 3 | 0 | IS-H: Complication Level of Diagnoses (for DRGs) | ||
64 | TIMESTAMP | ISH_TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | IS-H: Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
65 | DIAG_EXCF | ISH_DIA_EXCEPTION_FACTS | TEXT240 | CHAR | 240 | 0 | IS-H: Diagnosenausnahmetatbestand | ||
66 | QUALF | ISH_DIA_QUALF | ISH_DIA_QUALF | CHAR | 5 | 0 | Diagnosis Qualifier | ||
67 | DRG_IMPACT | ISH_DIA_DRG_IMPACT | ISH_DRG_IMPACT | CHAR | 2 | 0 | Impact of Diagnosis on DRG Determination |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |