| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | LNRIC | IS-H: Sequence Number of Surgical Procedure Code | nvarchar | 10 | 0 | CHAR | (N' ') | No | | ISH_LNRIC | Allow NULL? |
| 3 | LFDBEW | IS-H: Sequence Number of Movement | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | LFDBEW | Allow NULL? |
| 4 | ICPMK | IS-H: Identification of Surgical Procedure Coding Catalog | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ICPM_ID | Allow NULL? |
| 5 | ICPML | IS-H: Surgical Procedure Code (Service) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ICPM_LS | Allow NULL? |
| 6 | ICPHC | IS-H: Main Surgical Procedure Code | char | 1 | 0 | CHAR | (N' ') | Yes | | ICPM_HCODE | Allow NULL? |
| 7 | ANZOP | IS-H: Number of Additional Surgeries | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ISH_ANZOP | Allow NULL? |
| 8 | BGDOP | IS-H: Date when Surgical Procedure Code Performed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_BEGDT_ICP | Allow NULL? |
| 9 | BZTOP | IS-H: Time when Surg. Procedure Code Performance Begins | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISH_BEGZT_ICP | Allow NULL? |
| 10 | EZTOP | IS-H: Time when Surgical Procedure was Completed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISH_ENDZT_ICP | Allow NULL? |
| 11 | LSLOK | IS-H: Localization of Service | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | N1LSLOK | Allow NULL? |
| 12 | IDENT | Identification from External System | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_IDENT | Allow NULL? |
| 13 | OPART | IS-H: Type of Surgery | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ISH_OPART | Allow NULL? |
| 14 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 15 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 16 | STORN | IS-H: Cancellation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_STORN | Allow NULL? |
| 17 | STUSR | IS-H: Name of User who Canceled Data Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | STORN_USER | Allow NULL? |
| 18 | STDAT | Date of Cancellation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STORN_DAT | Allow NULL? |
| 19 | TCODE | IS-H: Report Control: Transaction Code for Application | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | ISH_TCODE | Allow NULL? |
| 20 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EINRI | Allow NULL? |
| 21 | FALNR | IS-H: Case Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FALNR | Allow NULL? |
| 22 | BTEXT | IS-H: User-Defined Comment on Procedure | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | ISH_PROCTEXT | Allow NULL? |
| 23 | EVENT | IS-H: Event that Triggers Creation of Procedure | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PROC_EVENT | Allow NULL? |
| 24 | OBJCT | IS-H: Object that Created the Procedure | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PROC_OBJECT | Allow NULL? |
| 25 | DRG_SEQNO | IS-H: Entry Sequence of DRG-Relevant Procedure | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ISH_DRG_PROC_SEQNO | Allow NULL? |
| 26 | DRG_CATEGORY | IS-H: Category of DRG Procedure (Principal, Secondary) | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_DRG_PROC_CATEGORY | Allow NULL? |
| 27 | DRG_RELEVANT | IS-H: Indicator "Used to Determine DRG" | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_DRG_PROC_RELEVANT | Allow NULL? |
| 28 | BEMKZ | Indicator that Long Text Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_LGTXT | Allow NULL? |
| 29 | ORGFA | IS-H: Departmental Organizational Unit of Procedure | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | ISH_FACHOE_PROC | Allow NULL? |
| 30 | ORGPF | IS-H: Date when Surgical Procedure Code Was Completed | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | ISH_ERBOE_PROC | Allow NULL? |
| 31 | ENDOP | IS-H: Date when Surgical Procedure Code Was Completed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_ENDDT_ICP | Allow NULL? |
