SAP ABAP Table RNPA1 (IS-H: Screen fields patient master/case)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ NPVS (Package) Application development patient management system
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ NPVS (Package) Application development patient management system
Basic Data
Table Category | INTTAB | Structure |
Structure | RNPA1 | Table Relationship Diagram |
Short Description | IS-H: Screen fields patient master/case |
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 | ABVON | ISH_ABVON | RI_DATUM | DATS | 8 | 0 | IS-H: Start date of absence | ||
2 | ABBIS | ISH_ABBIS | RI_DATUM | DATS | 8 | 0 | IS-H: End Date of Absence | ||
3 | ABVZT | BWIZT | UHRZT | TIMS | 6 | 0 | IS-H: Time of Movement | ||
4 | ABBZT | BWIZT | UHRZT | TIMS | 6 | 0 | IS-H: Time of Movement | ||
5 | ABVPL | PLANB | ISH_PLAN | CHAR | 1 | 0 | IS-H: Planned Indicator for Date of Movement | ||
6 | ABBPL | PLANB | ISH_PLAN | CHAR | 1 | 0 | IS-H: Planned Indicator for Date of Movement | ||
7 | ABAGR | ISH_ABAGR | RI_BWART | CHAR | 2 | 0 | IS-H: Absence Type | TN14B | |
8 | ABRGR | ISH_ABRGR | RI_BWART | CHAR | 2 | 0 | IS-H: Return Type | TN14B | |
9 | ABAGT | BEWARTXT | TEXT15 | CHAR | 15 | 0 | IS-H: Text for Movement Type | ||
10 | ABRGT | BEWARTXT | TEXT15 | CHAR | 15 | 0 | IS-H: Text for Movement Type | ||
11 | ABAG1 | ISH_ABW_BWGR1 | ISH_BGRUND | CHAR | 2 | 0 | IS-H: Absence Reason - 1st and 2nd Position | TN14G | |
12 | ABAG2 | ISH_ABW_BWGR2 | ISH_BGRUND | CHAR | 2 | 0 | IS-H: Absence Reason 3rd and 4th Position | TN14G | |
13 | ABAGL | ISH_BGTXTL | TEXT30 | CHAR | 30 | 0 | Long Text for Movement Reason | ||
14 | ABRG1 | ISH_ABR_BWGR1 | ISH_BGRUND | CHAR | 2 | 0 | IS-H: Return Reason - 1st and 2nd Positions | TN14G | |
15 | ABRG2 | ISH_ABR_BWGR2 | ISH_BGRUND | CHAR | 2 | 0 | IS-H: Return Reason - 3rd and 4th Position | TN14G | |
16 | ABRGL | ISH_BGTXTL | TEXT30 | CHAR | 30 | 0 | Long Text for Movement Reason | ||
17 | ADRES | ISH_PADRES | TEXT50 | CHAR | 50 | 0 | IS-H: Patient address | ||
18 | ALTXT | ISH_ALTXT | TEXT15 | CHAR | 15 | 0 | IS-H: Text for Employer's Country | ||
19 | ANLX2 | ANLX2 | TEXT15 | CHAR | 15 | 0 | IS-H: Country text for 2nd contact person | ||
20 | ANLX1 | ANLX1 | TEXT15 | CHAR | 15 | 0 | IS-H: Country text for 1st contact person | ||
21 | ANREX | ISH_AKURZ | TEXT5 | CHAR | 5 | 0 | IS-H: Form-of-Address Short Text | ||
22 | ANTXT | ISH_AKURZ | TEXT5 | CHAR | 5 | 0 | IS-H: Form-of-Address Short Text | ||
23 | ANZSC | NCH_ANZSCH | NCH_ANZSCH | NUMC | 2 | 0 | IS-H CH: Number of Previous Pregnancies | ||
24 | ANZTD | NCH_ANZTOT | NCH_ANZSCH | NUMC | 2 | 0 | IS-H CH: Number of Previous Miscarriages or Stillbirths | ||
25 | ANZAB | NCH_ANZABB | NCH_ANZSCH | NUMC | 2 | 0 | IS-H CH: Number of Previous Terminations of Pregnancy | ||
26 | AGNAM | AGNAM | TEXT30 | CHAR | 30 | 0 | IS-H: Employer Name | ||
27 | AGLAN | AGLAN | LAND1 | CHAR | 3 | 0 | IS-H: Employer Country | T005 | |
28 | AGPLZ | AGPLZ | PSTLZ | CHAR | 10 | 0 | IS-H: Employer Postal Code | ||
29 | AGORT | AGORT | TEXT25 | CHAR | 25 | 0 | IS-H: Employer City | ||
30 | AGSTR | AGSTR | STRAS | CHAR | 30 | 0 | IS-H: Employer Street | ||
31 | AGTEL | AGTEL | TEXT16 | CHAR | 16 | 0 | IS-H: Employer Telephone Number | ||
32 | AUFDV | AUFDV | RI_DATUM | DATS | 8 | 0 | IS-H: Admission Date (From) | ||
33 | AUFSW | AUFSW | TEXT40 | CHAR | 40 | 0 | IS-H: Date of First Contact | ||
34 | AUFDT | ISH_AUFDT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of First Contact | ||
35 | AUFDB | AUFDB | RI_DATUM | DATS | 8 | 0 | IS-H: Admission Date (To) | ||
36 | AUFKB | AUFKB | TEXT12 | CHAR | 12 | 0 | IS-H: Short Text for Admitting Facility | ||
37 | BARTX | KS_KBEZA | TEXT10 | CHAR | 10 | 0 | IS-H: S.Text for IV/Certificate Type per IV/Certif. Category | ||
38 | BETT | BETTID | BAUID | CHAR | 8 | 0 | IS-H: Building ID of Bed Location | * | |
39 | BEKURZ | BEKURZ | CHAR8 | CHAR | 8 | 0 | IS-H: Bed Identifier | ||
40 | BGTXT | ISH_BGTXTL | TEXT30 | CHAR | 30 | 0 | Long Text for Movement Reason | ||
41 | BHUEB | ISH_BHUEB | TEXT79 | CHAR | 79 | 0 | IS-H: Variable Heading | ||
42 | BINPT | ISH_BINPT | XFELD | CHAR | 1 | 0 | IS-H: Active Batch Input | ||
43 | BITCD | ISH_BITCD | TCODE | CHAR | 20 | 0 | IS-H: Calling transaction for CALL TRANSACTION USING | * | |
44 | BNKN1 | BNKNA | TEXT19 | CHAR | 19 | 0 | IS-H: Name of Bank | ||
45 | BNKN2 | BNKNA | TEXT19 | CHAR | 19 | 0 | IS-H: Name of Bank | ||
46 | BNKL1 | BNKLA | TEXT15 | CHAR | 15 | 0 | IS-H: Bank country | ||
47 | BNKL2 | BNKLA | TEXT15 | CHAR | 15 | 0 | IS-H: Bank country | ||
48 | BLTXT | ISH_BLBEZ | TEXT20 | CHAR | 20 | 0 | IS-H: Short text for federal state, state, region | ||
49 | BSTTX | BS_TXT | TEXT15 | CHAR | 15 | 0 | IS-H: Text for Treatment Certificate Status | ||
50 | BTYTX | KS_KBEZ | TEXT10 | CHAR | 10 | 0 | IS-H: Short Text for IV Document/Treatment Certificate | ||
51 | BWATX | BEWARTXT | TEXT15 | CHAR | 15 | 0 | IS-H: Text for Movement Type | ||
52 | BWBEG | BWIDT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Movement | ||
53 | BWEND | BWIDT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Movement | ||
54 | CHILD | ISH_CHILD | ISH_CHILD | CHAR | 2 | 0 | IS-H: Number of Children | ||
55 | DIAK1 | KATKB | TEXT10 | CHAR | 10 | 0 | IS-H: Short Text for Catalog | ||
56 | DIAK2 | KATKB | TEXT10 | CHAR | 10 | 0 | IS-H: Short Text for Catalog | ||
57 | DIAT1 | DIATXT | TEXT40 | CHAR | 40 | 0 | IS-H: Diagnosis Text | ||
58 | DIAT2 | DIATXT | TEXT40 | CHAR | 40 | 0 | IS-H: Diagnosis Text | ||
59 | EINRI | EINRI | EINRI | CHAR | 4 | 0 | IS-H: Institution | TN01 | |
60 | EZTXT | EINZGTEXT | TEXT25 | CHAR | 25 | 0 | IS-H: Name of Geographical Area | ||
61 | ENDAT | ENTDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Delivery | ||
62 | ENTIM | ENTZEIT | UHRZT | TIMS | 6 | 0 | IS-H: Time of Delivery | ||
63 | ENTDV | ENTDV | RI_DATUM | DATS | 8 | 0 | Discharge Date (From) | ||
64 | ENTDB | ENTDB | RI_DATUM | DATS | 8 | 0 | Discharge Date (To) | ||
65 | ENTSW | ENTSW | TEXT40 | CHAR | 40 | 0 | IS-H: Date of Last Contact | ||
66 | ENTDT | ENTDT | RI_DATUM | DATS | 8 | 0 | Date of Last Contact | ||
67 | ERBES | ERBES | RI_DATUM | DATS | 8 | 0 | IS-H: Date of First Contact | ||
68 | EXTKH | EXTKH | RI_KUNNR | CHAR | 10 | 0 | IS-H: Identification of an External Hospital | * | |
69 | EXTNR | EXT_PATNR | EXT_PATNR | CHAR | 20 | 0 | IS-H: External Patient Identification | ||
70 | FALNR | FALNR | FALNR | CHAR | 10 | 0 | IS-H: Case Number | NFAL | |
71 | FALAE | FALLARTE | FALLARTE | CHAR | 1 | 0 | IS-H: Case Type - User-Specific | TN15A | |
72 | FALAR | FALLARTE | FALLARTE | CHAR | 1 | 0 | IS-H: Case Type - User-Specific | * | |
73 | FATXT | RI_FATXT | FATXT | CHAR | 6 | 0 | Marital Status Designation | ||
74 | FZIFF | PZIFF_FALL | PZIFF | CHAR | 1 | 0 | IS-H: Check Digit for Case | ||
75 | FGTYP | GEBTYP | GEBTYP | CHAR | 1 | 0 | Delivery Category | * | |
76 | GBNAM | GBNAM | TEXT30 | CHAR | 30 | 0 | IS-H: Birthname | ||
77 | APPEL | GBNAM | TEXT30 | CHAR | 30 | 0 | IS-H: Birthname | ||
78 | GBDAT | RI_GBDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Birthdate | ||
79 | GBDAV | ISH_GBDATV | RI_DATUM | DATS | 8 | 0 | IS-H: "From" Date of Birth for Interval | ||
80 | GBDAB | ISH_GBDATB | RI_DATUM | DATS | 8 | 0 | IS-H: "To" Date of Birth for Interval | ||
81 | GLAND | LANDX | TEXT15 | CHAR | 15 | 0 | Country Name | ||
82 | GSCHL | GSCHL | GSCHL | CHAR | 1 | 0 | IS-H: Sex Indicator - Internal | ||
83 | GSCHLE | GSCHLE | GSCHLE | CHAR | 1 | 0 | IS-H: Sex Indicator - User-Specific | TN17G | |
84 | GSCHLE2 | GSCHLE | GSCHLE | CHAR | 1 | 0 | IS-H: Sex Indicator - User-Specific | * | |
85 | GSTA1 | NCH_GESTA1 | NCH_GESTA | NUMC | 3 | 0 | IS-H CH: Gestational Age 1 | ||
86 | GSTA2 | NCH_GESTA2 | NCH_GESTA | NUMC | 3 | 0 | IS-H CH: Gestational Age 2 | ||
87 | ISTB | ISTB | XFELD | CHAR | 1 | 0 | IS-H: Indicator for Actual Movement | ||
88 | ICON | ICON_D | ICON | CHAR | 4 | 0 | Icon in text fields (substitute display, alias) | * | |
89 | KNAME | ISH_KNAME | TEXT50 | CHAR | 50 | 0 | IS-H: Insurance Provider Name | ||
90 | KADDR | KTADR | TEXT40 | CHAR | 40 | 0 | IS-H: Insurance Provider Address | ||
91 | KOABK | KITXT | KITXT | CHAR | 4 | 0 | Religious Denomination | ||
92 | KOSTR | KH_KOSTR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Insurance Provider | * | |
93 | KOTXT | KNFTX | TEXT25 | CHAR | 25 | 0 | Religious Denomination Long Text | ||
94 | KUZUZ | ISH_BTRZZ | WERT6 | CURR | 11 | 2 | IS-H: Amount of Copayment Request | ||
95 | KZKOM | ISH_KZKOM | XFELD | CHAR | 1 | 0 | IS-H: Indicator that Complications Arose | ||
96 | KOMTX | TEXT_ENTB | TEXT50 | CHAR | 50 | 0 | IS-H: Comment on Delivery | ||
97 | LANDX | LANDX | TEXT15 | CHAR | 15 | 0 | Country Name | ||
98 | LEBES | LBES | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Last Contact | ||
99 | LFDNR | LFDKZ | CHAR2 | CHAR | 2 | 0 | IS-H: Sequence Number of Line | ||
100 | LFDBW | LFDBEW | LFDBEW | NUMC | 5 | 0 | IS-H: Sequence Number of Movement | * | |
101 | LGTXT | ISH_LGTX03 | ISH_ICON | CHAR | 30 | 0 | Screen Field for Displaying Dynamic Icon | ||
102 | LGTX2 | ISH_LGTX03 | ISH_ICON | CHAR | 30 | 0 | Screen Field for Displaying Dynamic Icon | ||
103 | LGTX3 | ISH_LGTX03 | ISH_ICON | CHAR | 30 | 0 | Screen Field for Displaying Dynamic Icon | ||
104 | LGTX4 | ISH_LGTX03 | ISH_ICON | CHAR | 30 | 0 | Screen Field for Displaying Dynamic Icon | ||
105 | LGTX5 | ISH_LGTX03 | ISH_ICON | CHAR | 30 | 0 | Screen Field for Displaying Dynamic Icon | ||
106 | LGTX6 | ISH_LGTX03 | ISH_ICON | CHAR | 30 | 0 | Screen Field for Displaying Dynamic Icon | ||
107 | LGTX7 | ISH_LGTX03 | ISH_ICON | CHAR | 30 | 0 | Screen Field for Displaying Dynamic Icon | ||
108 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
109 | MARK | RI_MARK | XFELD | CHAR | 1 | 0 | IS-H: Checkbox to Select a Row | ||
110 | MBEGR | ISH_MBTEXT | TEXT72 | CHAR | 72 | 0 | IS-H: Text of medical grounds | ||
111 | MBANF | ISH_MBANFO | TEXT72 | CHAR | 72 | 0 | IS-H: Text of request for medical grounds | ||
112 | MESS1 | ISH_MESS | TEXT50 | CHAR | 50 | 0 | IS-H: Half of the Message to Be Output | ||
113 | MESS2 | ISH_MESS | TEXT50 | CHAR | 50 | 0 | IS-H: Half of the Message to Be Output | ||
114 | NAME1 | GPNAM1 | NAME | CHAR | 35 | 0 | IS-H: Last Name/ 1st Name | ||
115 | NNAME | NNAME_PAT | TEXT30 | CHAR | 30 | 0 | IS-H: Patient Last Name | ||
116 | NATIO | NATIO | TEXT15 | CHAR | 15 | 0 | Nationality | ||
117 | ORGID | ORGID | ORGID | CHAR | 8 | 0 | IS-H: Organizational Unit Identification Key | * | |
118 | ORGTY | ORGTYP | ORGTYP | CHAR | 2 | 0 | IS-H: Category of Organizational Unit | * | |
119 | ORGKB | ORGKB | TEXT12 | CHAR | 12 | 0 | IS-H: Organizational Unit Short Text | ||
120 | ORGPKB | ORGKB | TEXT12 | CHAR | 12 | 0 | IS-H: Organizational Unit Short Text | ||
121 | ORGFKB | ORGKB | TEXT12 | CHAR | 12 | 0 | IS-H: Organizational Unit Short Text | ||
122 | ORGK1 | ISH_HEADLINE | TEXT255 | CHAR | 255 | 0 | IS-H: Header | ||
123 | ORGK2 | ISH_HEADLINE | TEXT255 | CHAR | 255 | 0 | IS-H: Header | ||
124 | ORT | ORT_GP | TEXT25 | CHAR | 25 | 0 | IS-H: City of Business Partner | ||
125 | PASSNR | ISH_PASSNR | ISH_PASSNR | CHAR | 15 | 0 | IS-H: Identification Document Number | ||
126 | PATNR | PATNR | PATNR | CHAR | 10 | 0 | IS-H: Patient Number | ||
127 | PZIFF | PZIFF_PAT | PZIFF | CHAR | 1 | 0 | IS-H: Check Digit for Patient | ||
128 | PNAME | RI_NAME | TEXT30 | CHAR | 30 | 0 | IS-H: Patient Name | ||
129 | PLANAUF | PLANAUF | ISH_PLAN | CHAR | 1 | 0 | Planned/Actual Admission Indicator | ||
130 | PLANENT | PLANENT | ISH_PLAN | CHAR | 1 | 0 | Planned/Actual Discharge Indicator | ||
131 | PLANB | PLANB | ISH_PLAN | CHAR | 1 | 0 | IS-H: Planned Indicator for Date of Movement | ||
132 | POAKT | AKT_POS | ISH_POS | NUMC | 3 | 0 | IS-H: Current Item Number | ||
133 | POGES | GES_POS | ISH_POS | NUMC | 3 | 0 | IS-H: Number of Total Items | ||
134 | POAKT05 | AKT_POS05 | ISH_POS05 | NUMC | 5 | 0 | IS-H: Current Item Number | ||
135 | POGES05 | GES_POS05 | ISH_POS05 | NUMC | 5 | 0 | IS-H: Number of Total Items | ||
136 | QUART | ISH_PERIOD | ISH_PERIOD | CHAR | 8 | 0 | IS-H: Period for Time Interval Input Help | TN01Z | |
137 | REFKZ | VERWEISKZ | XFELD | CHAR | 1 | 0 | IS-H: Indicator that Reference to Another Case Exists | ||
138 | RVNUM | ISH_RVNUM | ISH_SVNUM | CHAR | 20 | 0 | IS-H: Social Insurance Number | ||
139 | SEARCH | ISH_SEARCH | TEXT10 | CHAR | 10 | 0 | IS-H: 'Find Patient' Pushbutton | ||
140 | SPTXT | SPTXT | SPTXT16 | CHAR | 16 | 0 | Name of Language | ||
141 | STATB | ISH_ABSTEX | ISH_ABSTEX | CHAR | 2 | 0 | IS-H: External Status of Outpatient Visit | TN14E | |
142 | SUCHS | ISH_SSTAND | XFELD | CHAR | 1 | 0 | IS-H: Indicator that Standardized Search Will Be Used | ||
143 | SUCHP | ISH_SPHON | XFELD | CHAR | 1 | 0 | IS-H: Indicator that Phonetic Search Will Be Used | ||
144 | THOME | ISH_THOME | TEXT10 | CHAR | 10 | 0 | IS-H: Screen Button for "First Page" | ||
145 | TUP | ISH_TUP | TEXT10 | CHAR | 10 | 0 | IS-H: "Previous page" screen button | ||
146 | TDOWN | ISH_TDOWN | TEXT10 | CHAR | 10 | 0 | IS-H: "Next Page" Screen Button | ||
147 | TEND | ISH_TEND | TEXT10 | CHAR | 10 | 0 | IS-H: "Last page" Screen Button | ||
148 | TDELE | ISH_TDELE | ICON | CHAR | 4 | 0 | IS-H: Pushbutton 'Delete' | * | |
149 | TPOSI | ISH_TPOSIT | TEXT20 | CHAR | 20 | 0 | IS-H: Position Pushbutton | ||
150 | TWART | ISH_TWARTE | ICON | CHAR | 4 | 0 | IS-H: Waiting List Info Pushbutton | * | |
151 | TDISP | ISH_TDISPO | TEXT5 | CHAR | 5 | 0 | IS-H: Bed Scheduling Pushbutton | ||
152 | TODDT | TODDT | RI_DATUM | DATS | 8 | 0 | Date of Death From | ||
153 | TODZT | TODZT | UHRZT | TIMS | 6 | 0 | Time of Death From | ||
154 | TODDB | TODDT | RI_DATUM | DATS | 8 | 0 | Date of Death From | ||
155 | TODZB | TODZT | UHRZT | TIMS | 6 | 0 | Time of Death From | ||
156 | TODUR | TODUR | TODUR | CHAR | 3 | 0 | IS-H: Cause of Death | * | |
157 | UNFKZ | UNFART | UNFART | CHAR | 3 | 0 | IS-H: Accident Type | TN14C | |
158 | UNFNR | UNFNR | UNFNR | CHAR | 12 | 0 | IS-H: File Number / Processing Number for Accident | ||
159 | UNFOR | ORT01_UNF | TEXT25 | CHAR | 25 | 0 | IS-H: Accident Location | ||
160 | UNFDT | UNFDT | RI_DATUM | DATS | 8 | 0 | IS-H: Accident date | ||
161 | UNFZT | UNFZT | UHRZT | TIMS | 6 | 0 | IS-H: Time of Accident | ||
162 | UNFTX | TEXT_UNF | TEXT50 | CHAR | 50 | 0 | IS-H: Comment on Accident | ||
163 | UNLTX | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
164 | UNFRN | ISH_RETTNR | ISH_RETTNR | CHAR | 15 | 0 | IS-H: Number of the Emergency Service for Accident | ||
165 | UNFVS | N1FVS | XFELD | CHAR | 1 | 0 | IS-H: Third-Party Responsibility | ||
166 | UNFRT | ISH_RESCTY | ISH_RESCTY | CHAR | 4 | 0 | IS-H: Emergency Services | TN14I | |
167 | UNFAV | ISH_ARRIVE | ISH_ARRIVE | CHAR | 2 | 0 | IS-H: Mode of Arrival | TN14K | |
168 | VCODE | ISH_VCODE | ISH_VCODE | CHAR | 3 | 0 | IS-H: Processing Mode | ||
169 | VNAME | VNAME_PAT | TEXT30 | CHAR | 30 | 0 | IS-H: Patient First Name | ||
170 | VVTXT1 | TEXT_VER | TEXT15 | CHAR | 15 | 0 | IS-H: Text for Relationship | ||
171 | VVTXT2 | TEXT_VER | TEXT15 | CHAR | 15 | 0 | IS-H: Text for Relationship | ||
172 | ZIMME | ISH_ZIMMID | BAUID | CHAR | 8 | 0 | IS-H: Building ID of Room | * | |
173 | ZIKURZ | NZIKURZ | CHAR8 | CHAR | 8 | 0 | IS-H: Room Identifier | ||
174 | ZUOBK | ISH_ZUOBK | XFELD | CHAR | 1 | 0 | IS-H: Indicator whether Movement Assigned to Certificate | ||
175 | ZUOLK | ISH_ZUOLK | XFELD | CHAR | 1 | 0 | IS-H: Indicator whether Service Assigned to Certificate | ||
176 | EARZT | FALPEREXT | FALPEREXT | CHAR | 1 | 0 | IS-H: Function of Case-to-Person Assignment - External | * | |
177 | AARNR | ISH_AARNR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Pesonnel Number of Anesthetist | NGPA | |
178 | BARNR | BARNR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Personnel Number of Attending Physician | NGPA | |
179 | DARNR | DARNR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Personnel Number of Discharging Physician | * | |
180 | EARNR | EARNR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Personnel Number of Referring Physician | NGPA | |
181 | FARNR | FARNR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Personnel Number of Admitting Physician | * | |
182 | GARNR | GARNR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Personnel Number of Physician Approving Absence | NGPA | |
183 | HARNR | HARNR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Personnel Number of Family Physician | NGPA | |
184 | NARNR | NARNR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Number of Postdischarge Physician | NGPA | |
185 | OARNR | OARNR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Personnel Number of Operating Surgeon | * | |
186 | UARNR | UARNR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Personnel Number of Referring Physician | NGPA | |
187 | AANAM | ISH_AANAM | TEXT40 | CHAR | 40 | 0 | IS-H: Last name and first name of anesthesiologist | ||
188 | ARNAM | ARNAM | TEXT40 | CHAR | 40 | 0 | IS-H: Last name and first name of physician | ||
189 | BANAM | BARNAM | TEXT40 | CHAR | 40 | 0 | IS-H: Last and first name of attending physician | ||
190 | DANAM | DANAM | TEXT40 | CHAR | 40 | 0 | IS-H: First and Last Name of Discharge Physician | ||
191 | EANAM | EANAM | TEXT40 | CHAR | 40 | 0 | IS-H: Last name and first name of referring physician | ||
192 | FANAM | FANAM | TEXT40 | CHAR | 40 | 0 | IS-H: Last name and first name of the admitting physician | ||
193 | GANAM | GANAM | TEXT40 | CHAR | 40 | 0 | IS-H: Last name and first name of authorizing physician | ||
194 | HANAM | HANAM | TEXT40 | CHAR | 40 | 0 | IS-H: Last and first name of the family physician | ||
195 | KHNAM | KHNAM | TEXT40 | CHAR | 40 | 0 | IS-H: Name of the hospital | ||
196 | NANAM | NANAM | TEXT40 | CHAR | 40 | 0 | IS-H: First and last name of post discharge physician | ||
197 | OANAM | OANAM | TEXT40 | CHAR | 40 | 0 | IS-H: Last name and first name of the operating physician | ||
198 | UANAM | UANAM | TEXT40 | CHAR | 40 | 0 | IS-H: First and last name of referring physician | ||
199 | VANAM | VANAM | TEXT40 | CHAR | 40 | 0 | IS-H: First and last name of phys. to whom pat. is referred | ||
200 | WANAM | WANAM | TEXT40 | CHAR | 40 | 0 | IS-H: 1st and last name of physician providing cont. treat. | ||
201 | ARADR | ARADR | TEXT40 | CHAR | 40 | 0 | IS-H: Physician's Address | ||
202 | DAADR | DAADR | TEXT40 | CHAR | 40 | 0 | IS-H: Physician address - discharge physician | ||
203 | EAADR | EAADR | TEXT40 | CHAR | 40 | 0 | IS-H: Physician Address - Referring Physician | ||
204 | EAANS | EAADR_50 | TEXT80 | CHAR | 80 | 0 | IS-H: Text field name & address of referring physician | ||
205 | FAANS | ISH_FAADR | TEXT40 | CHAR | 40 | 0 | IS-H: Physician Address - Admitting Physician | ||
206 | HAADR | HAADR | TEXT40 | CHAR | 40 | 0 | IS-H: Physician Address - Family Physician | ||
207 | HAANS | HAADR_50 | TEXT80 | CHAR | 80 | 0 | IS-H: Text Field Name and Address of Family Physician | ||
208 | KHADR | KHADR | TEXT40 | CHAR | 40 | 0 | IS-H: Hospital Address | ||
209 | KHANS | KHADR_50 | TEXT50 | CHAR | 50 | 0 | IS-H: Hospital Name & Address | ||
210 | NAADR | NAADR | TEXT40 | CHAR | 40 | 0 | IS-H: Address of post-discharge physician | ||
211 | NAANS | ISH_NAANS | TEXT80 | CHAR | 80 | 0 | IS-H: Text Field Physican Name & Address Postdischarge Phy. | ||
212 | UAADR | UAADR | TEXT40 | CHAR | 40 | 0 | IS-H: Physician Address - Referring Physician | ||
213 | UAANS | UAADR_50 | TEXT80 | CHAR | 80 | 0 | IS-H: Text field name and address of referring physician | ||
214 | VAADR | VAADR | TEXT40 | CHAR | 40 | 0 | IS-H: Physician Address - Physician to whom Patient Referred | ||
215 | WAADR | WAADR | TEXT40 | CHAR | 40 | 0 | IS-H: Address of Post-Discharge Physician | ||
216 | FZFAL | FALNR | FALNR | CHAR | 10 | 0 | IS-H: Case Number | NFAL | |
217 | FZEND | RI_ENDDT | RI_DATUM | DATS | 8 | 0 | IS-H: Valid-To Date of Record | ||
218 | FZBEG | RI_BEGDT | RI_DATUM | DATS | 8 | 0 | IS-H: Valid-From Date of Record | ||
219 | FZREF | REFTE | REFTE | CHAR | 1 | 0 | IS-H: External Function of Case-to-Case Assignment | TN15B | |
220 | FZKZT | TEXT_FFZ | TEXT50 | CHAR | 50 | 0 | IS-H: Comment on case-to-case assignment | ||
221 | FZPNM | RI_NAME | TEXT30 | CHAR | 30 | 0 | IS-H: Patient Name | ||
222 | FZGSCH | GSCHLE | GSCHLE | CHAR | 1 | 0 | IS-H: Sex Indicator - User-Specific | * | |
223 | FZENM | EINKB | TEXT15 | CHAR | 15 | 0 | IS-H: Short Text for Institution | ||
224 | FZGEB | RI_GBDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Birthdate | ||
225 | FZASW | AUFSW | TEXT40 | CHAR | 40 | 0 | IS-H: Date of First Contact | ||
226 | FZADT | ISH_AUFDT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of First Contact | ||
227 | FZPLAUF | PLANAUF | ISH_PLAN | CHAR | 1 | 0 | Planned/Actual Admission Indicator | ||
228 | FZESW | ENTSW | TEXT40 | CHAR | 40 | 0 | IS-H: Date of Last Contact | ||
229 | FZEDT | ENTDT | RI_DATUM | DATS | 8 | 0 | Date of Last Contact | ||
230 | FZPLENT | PLANENT | ISH_PLAN | CHAR | 1 | 0 | Planned/Actual Discharge Indicator | ||
231 | FZOK1 | ISH_OKURZ | TEXT38 | CHAR | 38 | 0 | Organizational Unit Identifier | ||
232 | FZOK2 | ISH_OKURZ | TEXT38 | CHAR | 38 | 0 | Organizational Unit Identifier | ||
233 | OFSW01 | ORGSW | TEXT4 | CHAR | 4 | 0 | IS-H: Key word for organizational units | ||
234 | OFKZ01 | OFKURZ | CHAR5 | CHAR | 5 | 0 | IS-H: OU to which Patient Assigned on a Dept. Basis (ID) | ||
235 | OFSW02 | ORGSW | TEXT4 | CHAR | 4 | 0 | IS-H: Key word for organizational units | ||
236 | OFKZ02 | OFKURZ | CHAR5 | CHAR | 5 | 0 | IS-H: OU to which Patient Assigned on a Dept. Basis (ID) | ||
237 | OFSW03 | ORGSW | TEXT4 | CHAR | 4 | 0 | IS-H: Key word for organizational units | ||
238 | OFKZ03 | OFKURZ | CHAR5 | CHAR | 5 | 0 | IS-H: OU to which Patient Assigned on a Dept. Basis (ID) | ||
239 | OFSW04 | ORGSW | TEXT4 | CHAR | 4 | 0 | IS-H: Key word for organizational units | ||
240 | OFKZ04 | OFKURZ | CHAR5 | CHAR | 5 | 0 | IS-H: OU to which Patient Assigned on a Dept. Basis (ID) | ||
241 | OFSW05 | ORGSW | TEXT4 | CHAR | 4 | 0 | IS-H: Key word for organizational units | ||
242 | OFKZ05 | OFKURZ | CHAR5 | CHAR | 5 | 0 | IS-H: OU to which Patient Assigned on a Dept. Basis (ID) | ||
243 | OPSW01 | ORGSW | TEXT4 | CHAR | 4 | 0 | IS-H: Key word for organizational units | ||
244 | OPKZ01 | OPKURZ | CHAR5 | CHAR | 5 | 0 | IS-H: OU to which Patient Assigned for Nrs. Care (Identif.) | ||
245 | OPSW02 | ORGSW | TEXT4 | CHAR | 4 | 0 | IS-H: Key word for organizational units | ||
246 | OPKZ02 | OPKURZ | CHAR5 | CHAR | 5 | 0 | IS-H: OU to which Patient Assigned for Nrs. Care (Identif.) | ||
247 | OPSW03 | ORGSW | TEXT4 | CHAR | 4 | 0 | IS-H: Key word for organizational units | ||
248 | OPKZ03 | OPKURZ | CHAR5 | CHAR | 5 | 0 | IS-H: OU to which Patient Assigned for Nrs. Care (Identif.) | ||
249 | OPSW04 | ORGSW | TEXT4 | CHAR | 4 | 0 | IS-H: Key word for organizational units | ||
250 | OPKZ04 | OPKURZ | CHAR5 | CHAR | 5 | 0 | IS-H: OU to which Patient Assigned for Nrs. Care (Identif.) | ||
251 | OPSW05 | ORGSW | TEXT4 | CHAR | 4 | 0 | IS-H: Key word for organizational units | ||
252 | OPKZ05 | OPKURZ | CHAR5 | CHAR | 5 | 0 | IS-H: OU to which Patient Assigned for Nrs. Care (Identif.) | ||
253 | BSNR_EDOC | ISH_BSNR_EDOC | ISH_BSNR | CHAR | 9 | 0 | Betriebsstättennummer des ein-/überweisenden Arztes | ||
254 | LANR_EDOC | ISH_LANR_EDOC | ISH_LANR | CHAR | 9 | 0 | Lebenslange Arztnummer des ein-/überweisenden Arztes | ||
255 | LANR_BA | ISH_LANR_BA | ISH_LANR | CHAR | 9 | 0 | Lebenslange Arztnummer des behandelnden Arztes | ||
256 | INSID | ISH_VERS_NR | CHAR | 10 | 0 | DE: Eindeutige Versichertennummer (EGK) | |||
257 | POAKT08 | AKT_POS08 | NUMC08 | NUMC | 8 | 0 | IS-H: Current Item Number | ||
258 | POGES08 | GES_POS08 | NUMC08 | NUMC | 8 | 0 | IS-H: Number of Total Items |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RNPA1 | AARNR | NGPA | GPART | REF | 1 | CN |
2 | RNPA1 | ABAG1 | TN14G | GRUND | REF | 1 | CN |
3 | RNPA1 | ABAG2 | TN14G | GRUND | REF | 1 | CN |
4 | RNPA1 | ABAGR | TN14B | BWART | |||
5 | RNPA1 | ABRG1 | TN14G | GRUND | REF | 1 | CN |
6 | RNPA1 | ABRG2 | TN14G | GRUND | REF | 1 | CN |
7 | RNPA1 | ABRGR | TN14B | BWART | |||
8 | RNPA1 | AGLAN | T005 | LAND1 | |||
9 | RNPA1 | BARNR | NGPA | GPART | |||
10 | RNPA1 | EARNR | NGPA | GPART | |||
11 | RNPA1 | EINRI | TN01 | EINRI | |||
12 | RNPA1 | FALAE | TN15A | FALAE | |||
13 | RNPA1 | FALNR | NFAL | FALNR | |||
14 | RNPA1 | FZFAL | NFAL | FALNR | |||
15 | RNPA1 | FZREF | TN15B | REFTA | |||
16 | RNPA1 | GARNR | NGPA | GPART | |||
17 | RNPA1 | GSCHLE | TN17G | GSCHLE | |||
18 | RNPA1 | HARNR | NGPA | GPART | |||
19 | RNPA1 | NARNR | NGPA | GPART | |||
20 | RNPA1 | QUART | TN01Z | PERID | |||
21 | RNPA1 | STATB | TN14E | STATUS_EX | |||
22 | RNPA1 | UARNR | NGPA | GPART | |||
23 | RNPA1 | UNFAV | TN14K | ARRIVE | REF | 1 | CN |
24 | RNPA1 | UNFKZ | TN14C | UNFAR | REF | 1 | CN |
25 | RNPA1 | UNFRT | TN14I | RESCTY | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |