| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | LNRIC | IS-H: Sequence Number of Surgical Procedure Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | LFDBEW | IS-H: Sequence Number of Movement | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | ICPMK | IS-H: Identification of Surgical Procedure Coding Catalog | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | ICPML | IS-H: Surgical Procedure Code (Service) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | ICPHC | IS-H: Main Surgical Procedure Code | char | 1 | 0 | | | | Allow NULL? |
| 7 | ANZOP | IS-H: Number of Additional Surgeries | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | BGDOP | IS-H: Date when Surgical Procedure Code Performed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | BZTOP | IS-H: Time when Surg. Procedure Code Performance Begins | nvarchar | 6 | 0 | | | | Allow NULL? |
| 10 | EZTOP | IS-H: Time when Surgical Procedure was Completed | nvarchar | 6 | 0 | | | | Allow NULL? |
| 11 | LSLOK | IS-H: Localization of a Procedure | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | IDENT | Identification from External System | nvarchar | 20 | 0 | | | | Allow NULL? |
| 13 | OPART | IS-H: Type of Surgery | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | STORN | IS-H: Cancellation Indicator | char | 1 | 0 | | | | Allow NULL? |
| 17 | STUSR | IS-H: Name of User who Canceled Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 18 | STDAT | Date of Cancellation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | TCODE | IS-H: Report Control: Transaction Code for Application | nvarchar | 20 | 0 | | | | Allow NULL? |
| 20 | EINRI | Institution | nvarchar | 4 | 0 | | | | Allow NULL? |
| 21 | FALNR | IS-H: Case Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | BTEXT | IS-H: User-Defined Comment on Procedure | nvarchar | 50 | 0 | | | | Allow NULL? |
| 23 | EVENT | IS-H: Event that Triggers Creation of Procedure | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | OBJCT | IS-H: Object that Created the Procedure | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | DRG_SEQNO | IS-H: Entry Sequence of DRG-Relevant Procedure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | DRG_CATEGORY | IS-H: Category of DRG Procedure (Principal, Secondary) | char | 1 | 0 | | | | Allow NULL? |
| 27 | DRG_RELEVANT | IS-H: Indicator "Used to Determine DRG" | char | 1 | 0 | | | | Allow NULL? |
| 28 | BEMKZ | Language Key | char | 1 | 0 | | | | Allow NULL? |
| 29 | ORGFA | IS-H: Departmental Organizational Unit of Procedure | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | ORGPF | IS-H: Date when Surgical Procedure Code Was Completed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 31 | ENDOP | IS-H: Date when Surgical Procedure Code Was Completed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | PRTYP | IS-H: Procedure Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | EVTUP | IS-H: Event that Caused Procedure to Be Modified | nvarchar | 2 | 0 | | | | Allow NULL? |
| 34 | OBJUP | IS-H: Object That Caused Procedure to Be Modified | nvarchar | 10 | 0 | | | | Allow NULL? |
| 35 | TIMESTAMP | Timestamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 36 | QUANTITY | Procedure Quantity | decimal | 20 | 8 | | | | |
| 37 | UNIT | Unit of Measure for Procedure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 38 | LNRIC_REF | Sequence Number of Reference Surgical Procedure Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 39 | LNRLM | IS-H MM: Sequence Number of Material Consumption | nvarchar | 10 | 0 | | | | Allow NULL? |
| 40 | DRG_IMPACT | Impact of Procedure on DRG Determination | nvarchar | 2 | 0 | | | | Allow NULL? |
| 41 | CCL | Complication Level of Procedure (for DRGs) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 42 | OPLEBSPEN | OPS Living Donor Transplantation | char | 1 | 0 | | | | Allow NULL? |
