| 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 | ENDDT | IS-H: Valid-To Date of Record | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | RI_ENDDT | Allow NULL? |
| 4 | BEGDT | IS-H: Valid-From Date of Record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_BEGDT | Allow NULL? |
| 5 | DOCINP | IS-H: Form of Diagnosis Documentation for Inpatient Cases | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_DOCINP | Allow NULL? |
| 6 | DOCOUT | IS-H: Form of Diagnosis Documentation for Outpatient Cases | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_DOCOUT | Allow NULL? |
| 7 | BASKAS | IS-H: Basic Catalog for Diagnosis Entry in Inpatient Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK00 | ISH_BASKAS | Allow NULL? |
| 8 | BASKAA | IS-H: Basic Catalog for Diagnosis Entry in Outpatient Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK00 | ISH_BASKAA | Allow NULL? |
| 9 | STAKAS | IS-H: Diagnosis Coding Catalog for Statistics in Inpat. Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK00 | ISH_STAKAS | Allow NULL? |
| 10 | STAKAA | IS-H: Diagnosis Coding Catalog for Statistics in Outpat Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK00 | ISH_STAKAA | Allow NULL? |
| 11 | EXCLEWS | IS-H: No Referral Diagnosis in Diagnosis Documentation | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXCLEW | Allow NULL? |
| 12 | EXCLAFS | IS-H: No Admission Diagnosis in Diagnosis Documentation | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXCLAF | Allow NULL? |
| 13 | EXCLENS | IS-H: No Discharge Diagnosis in Diagnosis Documentation | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXCLEN | Allow NULL? |
| 14 | EXCLOPS | IS-H: No Surgery Diagnosis in Diagnosis Documentation | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXCLOP | Allow NULL? |
| 15 | EXCLTOS | IS-H: No Cause of Death Diagnosis in Diagnosis Documentation | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXCLTO | Allow NULL? |
| 16 | EXCLFAS | IS-H: No Department Main Diagnosis in Diagnosis Documentat. | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXCLFA | Allow NULL? |
| 17 | EXCLKHS | IS-H: No Hopsital Main Diagnosis in Diagnosis Documentation | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXCLKH | Allow NULL? |
| 18 | EXCLEWA | IS-H: No Referral Diagnosis in Diagnosis Documentation | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXCLEW | Allow NULL? |
| 19 | EXCLAFA | IS-H: No Admission Diagnosis in Diagnosis Documentation | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXCLAF | Allow NULL? |
| 20 | EXCLENA | IS-H: No Discharge Diagnosis in Diagnosis Documentation | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXCLEN | Allow NULL? |
| 21 | EXCLOPA | IS-H: No Surgery Diagnosis in Diagnosis Documentation | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXCLOP | Allow NULL? |
| 22 | EXCLTOA | IS-H: No Cause of Death Diagnosis in Diagnosis Documentation | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXCLTO | Allow NULL? |
| 23 | EXCLFAA | IS-H: No Department Main Diagnosis in Diagnosis Documentat. | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXCLFA | Allow NULL? |
| 24 | EXCLKHA | IS-H: No Hopsital Main Diagnosis in Diagnosis Documentation | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXCLKH | Allow NULL? |
| 25 | EWKAS | IS-H: Catalog for Referral Diagnoses in Inpatient Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK00 | ISH_EWKAS | Allow NULL? |
| 26 | EWKAA | IS-H: Catalog for Referral Diagnoses in Outpatient Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK00 | ISH_EWKAA | Allow NULL? |
| 27 | DRG_KAS | IS-H: Diagnosis Catalog for DRG Diagnosis in Inpatient Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK00 | ISH_DRG_KAS | Allow NULL? |
| 28 | DRG_SEPARAT | IS-H: DRG Diagnoses Managed Separately | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_DRG_SEPARAT | Allow NULL? |
| 29 | ENDIA_BILL | IS-H: Discharge Diagnosis Required | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_ENDIA_BILL | Allow NULL? |
| 30 | KHDIA_BILL | IS-H: Hospital Main Diagnosis Required | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_KHDIA_BILL | Allow NULL? |
