| 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 | GENDC | IS-H SG: Daily Hospital Charge for Inpatients | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_GENDC | |
| 6 | GENAF | IS-H SG: Limit for Phy. Daily Attendance Fees (Inpatient) | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_GENAF | |
| 7 | DAYDC | IS-H SG: Daily Hospital Charge for Day Surgery | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_DAYDC | |
| 8 | DAYAF | IS-H SG: Limit for Phy. Daily Attendance Fees (Day Surgery) | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_DAYAF | |
| 9 | PSYDC | IS-H SG: Daily Hospital Charge for Psychiatric Cases | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_PSYDC | |
| 10 | PSYAF | IS-H SG: Limit for Phy. Daily Attendance Fees (Psychiatry) | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_PSYAF | |
| 11 | HEPB1 | IS-H SG: Hepatitis B vaccination | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_HEPB1 | |
| 12 | HEPB2 | IS-H SG: Hepatitis B vaccination | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_HEPB2 | |
| 13 | HEPB3 | IS-H SG: Hepatitis B vaccination | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_HEPB3 | |
| 14 | RADEX | IS-H SG: Amount for external radiotherapy | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_RADEX | |
| 15 | BRAWI | IS-H SG: Amount for brachytherapy w/o ext. radiotherapy | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_BRAWI | |
| 16 | BRANO | IS-H SG: Amount for brachytherapy with ext. radiotherapy | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_BRANO | |
| 17 | ASSCP | IS-H SG: Assisted conception procedures | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_ASSCP | |
| 18 | NOBST | IS-H SG: Number of live births for obstetrics cases | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_NOBST | Allow NULL? |
| 19 | NLIGA | IS-H SG: Number of live births prior to ligation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_NLIGA | Allow NULL? |
| 20 | MAXOP | IS-H SG: Maximum Medisave withdrawal | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_MAXOP | |
