| 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 | T000 | MANDT | Allow NULL? |
| 2 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | No | TN01 | EINRI | Allow NULL? |
| 3 | ORGID | Identification Key of Organizational Unit | nvarchar | 8 | 0 | CHAR | (N' ') | No | NORG | ORGID | Allow NULL? |
| 4 | DOKART_KA | IS-H: Document Type in DMS for 'Medical Record' Document | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TDWA | DOKART_KA | Allow NULL? |
| 5 | ORGFORM | IS-H: Organization Form of Med. Rec. Mgmt. for OP/IP Area | char | 1 | 0 | CHAR | (N' ') | Yes | | ORGFORM_SA | Allow NULL? |
| 6 | ORGFORM_S | IS-H: Organization Form of Inpatient Medical Record Mgmt. | char | 1 | 0 | CHAR | (N' ') | Yes | | ORGFORM_S | Allow NULL? |
| 7 | ORGFORM_A | IS-H: Organization Form of Outpatient Medical Record Mgmt. | char | 1 | 0 | CHAR | (N' ') | Yes | | ORGFORM_A | Allow NULL? |
| 8 | ANLAGE_AUT | IS-H: Create Medical Record Automatically at Admiss./Trans. | char | 1 | 0 | CHAR | (N' ') | Yes | | ANLAGE_AUT | Allow NULL? |
| 9 | ANLAGE_AUF | IS-H: Create Medical Record at Admission/Transfer | char | 1 | 0 | CHAR | (N' ') | Yes | | ANLAGE_AUF | Allow NULL? |
| 10 | ANLAGE_LI | IS-H: Create Medical Record via Movements Made | char | 1 | 0 | CHAR | (N' ') | Yes | | ANLAGE_LI | Allow NULL? |
| 11 | ENTLEI_ANL | IS-H: Simultaneous Borrowing at Medical Record Creation | char | 1 | 0 | CHAR | (N' ') | Yes | | ENTLEI_ANL | Allow NULL? |
| 12 | ENTLEI_AUT | IS-H: Borrow Automatically at Admission/Transfer | char | 1 | 0 | CHAR | (N' ') | Yes | | ENTLEI_AUT | Allow NULL? |
| 13 | ANFORD_AUT | IS-H: Automatic Borrowing Request at Admission/Transfer | char | 1 | 0 | CHAR | (N' ') | Yes | | ANFORD_AUT | Allow NULL? |
| 14 | ENTLEI_LI | IS-H: Borrow Medical Records via List of Movements Made | char | 1 | 0 | CHAR | (N' ') | Yes | | ENTLEI_LI | Allow NULL? |
| 15 | UEBERG_AUT | IS-H: Transfer Med. Records Automatically when Pat. Transfrd | char | 1 | 0 | CHAR | (N' ') | Yes | | UEBERG_AUT | Allow NULL? |
| 16 | UEBERG_LI | IS-H: Transfer Med. Records via List of Borrowed Records | char | 1 | 0 | CHAR | (N' ') | Yes | | UEBERG_LI | Allow NULL? |
| 17 | ARCHIV | IS-H: Organizational ID of the medical record archive | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | NORG | ARCHIV_ID | Allow NULL? |
| 18 | MDR_TMP | IS-H: Creation Variant for Temporary Medical Record | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_MDRTMP | Allow NULL? |
| 19 | DOKAR_TMP | IS-H: Document Type in DMS for 'Medical Record' Document | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TDWA | DOKART_KA | Allow NULL? |