| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | EINRI | Institution | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | TARIF | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | ENDDT | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | BEGDT | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | GVDH | IS-H: Maximum Length of Stay for Main Department in Days | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | GVDB | IS-H: Maximum Length of Stay for External Phy. Dept in Days | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | GVDIH | IS-H: Maximum Length of Stay for Intensive Care in Main Dept | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | GVDIB | IS-H: Max. LOS for Intensive Care in Ext. Physician Dept | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | NVDH | IS-H: Standard Length of Stay for FR in Main Department | decimal | 6 | 3 | | | | |
| 12 | NVDB | IS-H: Standard Length of Stay of FR/Case for Ext. Phy. Dept | decimal | 6 | 3 | | | | |
| 13 | PLANZ | IS-H: Planned Number of Flat Rates/Proc. Surcharges per Year | nvarchar | 6 | 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 | NVDIH | IS-H: Standard LOS for Intensive Care in Main Dept | decimal | 6 | 3 | | | | |
| 17 | NVDIB | IS-H: Standard LOS in Intensive Care Provided by Ext. Phy. | decimal | 6 | 3 | | | | |
| 18 | PZPE | Charge Factor for Personnel Main Department | decimal | 11 | 2 | | | | |
| 19 | PZSA | IS-H: Charge Factor for Materials Main Department | decimal | 11 | 2 | | | | |
| 20 | PZBPE | IS-H: Personnel Charge Factor for Basic Svces Main Dept | decimal | 11 | 2 | | | | |
| 21 | PZBSA | IS-H: Materials Charge Factor for Basic Svces Main Dept | decimal | 11 | 2 | | | | |
| 22 | MINVD | IS-H: Minimum LOS for Postopetative Treatment Flat Rate | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | FPACT | IS-H: Acute Treatment Flat Rate Assigned | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | MODNR | IS-H: Number of the QA FR/PS Module | nvarchar | 5 | 0 | | | | Allow NULL? |
| 25 | PPBO | IS-H: Personnel Charge Factor External Surgeon | decimal | 11 | 2 | | | | |
| 26 | PSBO | IS-H: Material charge factors external surgeon | decimal | 11 | 2 | | | | |
| 27 | PPBOA | IS-H: Personnel Charge Factors Ext. Surgeon and Ext. Aneth. | decimal | 11 | 2 | | | | |
| 28 | PSBOA | IS-H: Materials Charge Factor Ext. Surgeon, Ext. Anesth. | decimal | 11 | 2 | | | | |
| 29 | PPBHO | IS-H: Personnel charge factors ext. midwife, ext. surgeon | decimal | 11 | 2 | | | | |
| 30 | PSBHO | IS-H: Materials Charge Factor Ext. Midwife, Ext. Surgeon | decimal | 11 | 2 | | | | |
| 31 | PPHOA | IS-H: Pers. Charge Fact. for Ext. Midwife, Surgeon, Anesth. | decimal | 11 | 2 | | | | |
| 32 | PSHOA | IS-H: Materials chrg. fact. for ext. midwife, surgeon, anes. | decimal | 11 | 2 | | | | |
| 33 | PPBAB | IS-H: Pers. Charge Factor Base Svce for Care by Ext. Phy. | decimal | 11 | 2 | | | | |
| 34 | PSBAB | IS-H: Mat. Charge Factor Base Svce for Care by Ext. Phy. | decimal | 11 | 2 | | | | |
| 35 | MVDH | IS-H: DRG Average Length of Stay in Main Department in Days | decimal | 5 | 2 | | | | |
| 36 | OGVDH | IS-H: DRG Maximum Length of Stay in Main Department in Days | nvarchar | 3 | 0 | | | | Allow NULL? |
| 37 | ROGVDH | IS-H: DRG Valuation Relation Maximum LOS/Day Main Dept | decimal | 5 | 3 | | | | |
| 38 | MVDB | IS-H: DRG Average Length of Stay in Ext. Phy. Dept. in Days | decimal | 5 | 2 | | | | |
| 39 | OGVDB | IS-H: DRG Maximum Length of Stay in Ext. Phy. Dept. in Days | nvarchar | 3 | 0 | | | | Allow NULL? |
| 40 | ROGVDB | IS-H: DRG Valuation Relation Maximum LOS/Day Ext. Phy. Dept | decimal | 5 | 3 | | | | |
| 41 | UGVDH | IS-H: DRG Minimum Length of Stay in Main Department in Days | nvarchar | 3 | 0 | | | | Allow NULL? |
| 42 | RUGVDH | IS-H: DRG Valuation Relation Min. LOS/Day Main Dept | decimal | 5 | 3 | | | | |
| 43 | UGVDB | IS-H: DRG Minimum Length of Stay in Ext. Phy. Dept. in Days | nvarchar | 3 | 0 | | | | Allow NULL? |
| 44 | RUGVDB | IS-H: DRG Valuation Relation Min. LOS/Day Ext. Phy. Dept. | decimal | 5 | 3 | | | | |
| 45 | RABVH | IS-H: DRG Valuation Relation Ext. Transfer/Day Main Dept | decimal | 5 | 3 | | | | |
| 46 | RABVB | IS-H: DRG Valuation Relation Ext. Transfer/Day Ext.Phy.Dept | decimal | 5 | 3 | | | | |
| 47 | VERFPH | IS-H: DRG Indicator Transfer Case Flat Rate Main Department | char | 1 | 0 | | | | Allow NULL? |
| 48 | VERFPB | IS-H: DRG Indicator Transfer Flat Rate Ext. Phy. Dept | char | 1 | 0 | | | | Allow NULL? |
| 49 | MINVDH | IS-H: DRG Minimum Length of Stay in Main Department in Hours | nvarchar | 2 | 0 | | | | Allow NULL? |
| 50 | MINVDB | IS-H: DRG Minimum Length of Stay in Ext. Phy. Dept in Hours | nvarchar | 2 | 0 | | | | Allow NULL? |
| 51 | NOWAH | | char | 1 | 0 | | | | Allow NULL? |
| 52 | NOWAB | | char | 1 | 0 | | | | Allow NULL? |
| 53 | KATEGORIE | Service Class | nvarchar | 10 | 0 | | | | Allow NULL? |
| 54 | KATEGORIE_L | Service Class - Left-Side | nvarchar | 10 | 0 | | | | Allow NULL? |
| 55 | KATEGORIE_R | Service Class - Right-Side | nvarchar | 10 | 0 | | | | Allow NULL? |
| 56 | KATEGORIE_B | Service Class - Bilateral | nvarchar | 10 | 0 | | | | Allow NULL? |
| 57 | SHORT_PRICE | | decimal | 11 | 0 | | | | |
| 58 | SUR_PRICE | | decimal | 11 | 0 | | | | |
| 59 | DIS_PRICE | | decimal | 11 | 0 | | | | |
| 60 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
