SAP ABAP Table RNWCHLS_NFAL (IS-H CH: Fallstruktur für ALIS-Leistungsschnittstelle)
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 | RNWCHLS_NFAL | Table Relationship Diagram |
Short Description | IS-H CH: Fallstruktur für ALIS-Leistungsschnittstelle |
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 | .INCLUDE | 0 | 0 | IS-H: Cases | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | EINRI | EINRI | EINRI | CHAR | 4 | 0 | IS-H: Institution | TN01 | |
4 | FALNR | FALNR | FALNR | CHAR | 10 | 0 | IS-H: Case Number | * | |
5 | FALAR | FALLART | FALLART | CHAR | 1 | 0 | IS-H: Case Type | ||
6 | PATNR | PATNR | PATNR | CHAR | 10 | 0 | IS-H: Patient Number | NPAT | |
7 | BEKAT | BEKAT | BEHKATEG | CHAR | 6 | 0 | Treatment Category | TN24 | |
8 | ABRKZ | ABRKZ_FALL | ABRKZ_FALL | CHAR | 1 | 0 | IS-H: Billing Indicator for Case | ||
9 | SICHV | SICHV | XFELD | CHAR | 1 | 0 | IS-H: Indicator for Restricted Patient | ||
10 | EINZG | EINZGEBIET | EINZGEBIET | CHAR | 9 | 0 | IS-H: Geographical Area | ||
11 | KZTXT | TEXT_NFAL | RI_BEMERK | CHAR | 30 | 0 | IS-H: Comment on Case | ||
12 | KUALF | LLFDKUA | LFDKUA | CHAR | 10 | 0 | IS-H: Last IV Request Number Assigned | ||
13 | BEWLF | LLFDBEW | LFDBEW | NUMC | 5 | 0 | IS-H: Last Movement Number Assigned | * | |
14 | DGNLF | LLFDDIA | LFDDIA | NUMC | 3 | 0 | IS-H: Obsolete | ||
15 | PGRLF | LLFDPGF | LFDPGF | NUMC | 3 | 0 | IS-H: Last Sequence Number for Patient Group (NPGF) | ||
16 | INFKZ | INFKZ | XFELD | CHAR | 1 | 0 | IS-H: Infectious Disease Indicator | ||
17 | STATU | FALLSTATUS | FALLSTATUS | CHAR | 1 | 0 | IS-H: Case Status | ||
18 | FZIFF | PZIFF_FALL | PZIFF | CHAR | 1 | 0 | IS-H: Check Digit for Case | ||
19 | NOTAN | NOTAUF | XFELD | CHAR | 1 | 0 | IS-H: Emergency Admission Indicator | ||
20 | KRZAN | KURZAUF | XFELD | CHAR | 1 | 0 | IS-H: Quick Admission Indicator | ||
21 | ENDAT | ENTDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Delivery | ||
22 | ENTIM | ENTZEIT | UHRZT | TIMS | 6 | 0 | IS-H: Time of Delivery | ||
23 | FGTYP | GEBTYP | GEBTYP | CHAR | 1 | 0 | Delivery Category | TN15F | |
24 | KZKOM | ISH_KZKOM | XFELD | CHAR | 1 | 0 | IS-H: Indicator that Complications Arose | ||
25 | KOMTX | TEXT_ENTB | TEXT50 | CHAR | 50 | 0 | IS-H: Comment on Delivery | ||
26 | KOLTX | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
27 | ARBUN | ARBUN | RI_DATUM | DATS | 8 | 0 | IS-H: Work Incapacity To-Date | ||
28 | ENDDT | ENDDT_FAL | RI_DATUM | DATS | 8 | 0 | IS-H: End Date of Case | ||
29 | FSPER | FSPER | ISH_FSPER | CHAR | 1 | 0 | IS-H: Billing Block for Case | ||
30 | ERDAT | RI_ERDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Record Created | ||
31 | ERUSR | RI_ERNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Employee who Created Record | ||
32 | UPDAT | RI_UPDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Last Change | ||
33 | UPUSR | RI_UPNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Person who Last Changed Data | ||
34 | STORN | RI_STORN | XFELD | CHAR | 1 | 0 | IS-H: Cancellation Indicator | ||
35 | STUSR | STORN_USER | USNAM | CHAR | 12 | 0 | IS-H: Name of User who Canceled Data Record | ||
36 | STDAT | STORN_DAT | RI_DATUM | DATS | 8 | 0 | Date of Cancellation | ||
37 | VORPT | ISH_VORPT | ISH_VORPT | NUMC | 3 | 0 | IS-H: Number of Days of Previous Treatmt in Calendar Year | ||
38 | BEGDT | BEGDT_FAL | RI_DATUM | DATS | 8 | 0 | IS-H: Start Date of Case | ||
39 | STASP | ISH_STASP | XFELD | CHAR | 1 | 0 | IS-H: Indicator for Admission Type "Statistics Block" | ||
40 | KV_KZ | ISH_KV_KZ | XFELD | CHAR | 1 | 0 | IS-H: Relevant for Panel Physician Association Billing | ||
41 | EAUFN | ISH_EAUFN | AUFNR | CHAR | 12 | 0 | IS-HCO: Receiver (Order) | * | |
42 | KVUEB | ISH_KVUEB | KV_STATUS | CHAR | 1 | 0 | IS-H: Status of PPA Billing Case | ||
43 | VORGR | VOR_GRVER | GRVER | NUMC | 3 | 0 | IS-H: Previous Days to Be Deducted from Max. Length of Stay | ||
44 | OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
45 | RESID | ISH_RESID | XFELD | CHAR | 1 | 0 | IS-H: Indicator that Patient is Non-Resident | ||
46 | CHILD | ISH_CHILD | ISH_CHILD | CHAR | 2 | 0 | IS-H: Number of Children | ||
47 | FOREI | ISH_FOREIG | XFELD | CHAR | 1 | 0 | IS-H: Foreign Case | ||
48 | FATYP | ISH_CASETYPE | ISH_CASETYPE | CHAR | 2 | 0 | Case Category | TN15C | |
49 | EMTYP | ISH_EMTYPE | ISH_EMTYPE | CHAR | 2 | 0 | IS-H: Employee Type | TN15G | |
50 | KTTAR | NCH_TARCDE | NCH_TARCDE | CHAR | 3 | 0 | IS-H CH: Canton Tariff | TNCH12 | |
51 | KTABK | NCH_AGREEMENT | NCH_AGREEMENT | CHAR | 3 | 0 | IS-H CH: Convention (Hospital <-> Canton) | TNCH13 | |
52 | GSTA1 | NCH_GESTA1 | NCH_GESTA | NUMC | 3 | 0 | IS-H CH: Gestational Age 1 | ||
53 | GSTA2 | NCH_GESTA2 | NCH_GESTA | NUMC | 3 | 0 | IS-H CH: Gestational Age 2 | ||
54 | ANZSC | NCH_ANZSCH | NCH_ANZSCH | NUMC | 2 | 0 | IS-H CH: Number of Previous Pregnancies | ||
55 | ANZTD | NCH_ANZTOT | NCH_ANZSCH | NUMC | 2 | 0 | IS-H CH: Number of Previous Miscarriages or Stillbirths | ||
56 | ANZAB | NCH_ANZABB | NCH_ANZSCH | NUMC | 2 | 0 | IS-H CH: Number of Previous Terminations of Pregnancy | ||
57 | LGBIS | NWCH_GENBIS | DATUM | DATS | 8 | 0 | IS-H CH: Service Generation Date to | ||
58 | FPEDT | ISH_FPEDT | ISH_FPEDT | DATS | 8 | 0 | IS-H: Date of Wound Healing | ||
59 | APSTATE | ISH_APSTATE | ISH_APSTATE | CHAR | 2 | 0 | IS-H: Application Status | TNC301SA | |
60 | FACHR | FACHRTY7 | ISH_FACHR | CHAR | 4 | 0 | IS-H: Specialty for Organizational Unit | TNKFA | |
61 | ENDTYP | ISH_CASEEND | ISH_CASEEND | CHAR | 2 | 0 | IS-H: Type of Case End | TN15D | |
62 | DOCTY | ISH_LPASSTY | ISH_PASSTY | CHAR | 2 | 0 | IS-H: Subvention Document Type (Long) | TN17D | |
63 | DOCNR | ISH_LPASSNR | ISH_LPASSNR | CHAR | 30 | 0 | IS-H: Subvention Document Number (Long) | ||
64 | WKAT | ISH_WKAT | ISH_WKAT | CHAR | 1 | 0 | IS-H: Choice of Ward Class | TN15H | |
65 | DOCW | ISH_DOCWKZ | XFELD | CHAR | 1 | 0 | IS-H: Named Referral Indicator | ||
66 | PATW | ISH_PATWKZ | XFELD | CHAR | 1 | 0 | IS-H: Patient Requested Referral Indicator | ||
67 | PATGEW | ISH_PATGEW | ISH_GEWICH | QUAN | 7 | 3 | IS-H: Weight of Patient at Admission | ||
68 | GWEIN | ISH_EINGEW | MEINS | UNIT | 3 | 0 | IS-H: Unit of Measurement for Patient Weight | T006 | |
69 | PATGRO | ISH_PATGRO | ISH_GROESS | QUAN | 5 | 2 | IS-H: Height of Patient at Admission | ||
70 | GREIN | ISH_EINGRO | MEINS | UNIT | 3 | 0 | IS-H: Unit of Measurement for Patient Size | T006 | |
71 | RESPI | ISH_RESPIRATION | NUM5 | NUMC | 5 | 0 | IS-H: Duration of Mechanical Ventilation in Hours | ||
72 | FEXNR | ISH_EXTNR_FAL | ISH_EXTNR_FAL | CHAR | 20 | 0 | IS-H: External Case Identification | ||
73 | TIMESTAMP | ISH_TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | IS-H: Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
74 | TOB | ISH_TOB | NUMC | 3 | 0 | IS-H: Days Without Calculation | |||
75 | PLSNR | ISH_EXTNR_PLS | ISH_EXTNR_PLS | CHAR | 20 | 0 | IS-H: PRS Number | ||
76 | .INCLUDE | 0 | 0 | IS-H CH: Stammdaten Fall - Zusatzfelder Schweiz | |||||
77 | INV_COPY | ISH_INV_COPY | XFELD | CHAR | 1 | 0 | Kennzeichen Rechnungskopie an Patient | ||
78 | MHLS | ISH_MHLS | ISH_MHLS | CHAR | 1 | 0 | Mental Health Legal Status | ||
79 | READM | ISH_READM | ISH_ON_OFF | CHAR | 1 | 0 | Indicator for Possible Readmission Case | ||
80 | CONSENT | ISH_CONSENT | XFELD | CHAR | 1 | 0 | PKV P301: Einwilligung zur elektronischen Datenübertragung | ||
81 | SUBSYS | NWCH_SNDAPPLICATION | NWCH_APPLICATION | CHAR | 30 | 0 | IS-H CH: XML - Applikation (Sender) | ||
82 | PID | CHAR20 | CHAR20 | CHAR | 20 | 0 | Char 20 | ||
83 | PNAME | NNAME_PAT | TEXT30 | CHAR | 30 | 0 | IS-H: Patient Last Name | ||
84 | PGIVENNAME | VNAME_PAT | TEXT30 | CHAR | 30 | 0 | IS-H: Patient First Name | ||
85 | PBIRTHDATE | RI_GBDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Birthdate | ||
86 | PGENDER | GSCHLE | GSCHLE | CHAR | 1 | 0 | IS-H: Sex Indicator - User-Specific | * | |
87 | CTERMINATION | ENDDT_FAL | RI_DATUM | DATS | 8 | 0 | IS-H: End Date of Case | ||
88 | CTERMREASON | ISH_CASEEND | ISH_CASEEND | CHAR | 2 | 0 | IS-H: Type of Case End | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RNWCHLS_NFAL | APSTATE | TNC301SA | APSTATE | REF | 1 | CN |
2 | RNWCHLS_NFAL | BEKAT | TN24 | BEKAT | REF | C | CN |
3 | RNWCHLS_NFAL | DOCTY | TN17D | PASSTY | REF | 1 | CN |
4 | RNWCHLS_NFAL | EINRI | TN01 | EINRI | KEY | 1 | CN |
5 | RNWCHLS_NFAL | EMTYP | TN15G | EMTYP | REF | 1 | CN |
6 | RNWCHLS_NFAL | ENDTYP | TN15D | ENDTYP | REF | 1 | CN |
7 | RNWCHLS_NFAL | FACHR | TNKFA | FACHR | REF | 1 | CN |
8 | RNWCHLS_NFAL | FATYP | TN15C | CASETY | KEY | 1 | CN |
9 | RNWCHLS_NFAL | FGTYP | TN15F | GBTYP | REF | 1 | CN |
10 | RNWCHLS_NFAL | GREIN | T006 | MSEHI | REF | 1 | CN |
11 | RNWCHLS_NFAL | GWEIN | T006 | MSEHI | REF | 1 | CN |
12 | RNWCHLS_NFAL | KTABK | TNCH13 | AGREEMENT | KEY | 1 | CN |
13 | RNWCHLS_NFAL | KTTAR | TNCH12 | TARCDE | KEY | 1 | CN |
14 | RNWCHLS_NFAL | MANDT | T000 | MANDT | KEY | 1 | CN |
15 | RNWCHLS_NFAL | PATNR | NPAT | PATNR | REF | 1 | CN |
16 | RNWCHLS_NFAL | WKAT | TN15H | WKAT | KEY | 1 | CN |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in | 472 |