| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Patient Accounting | ||||||||||
| 1 | NCIR | IS-H: Insurance Relationships of a Case | 65 | VKPLZ | IS-H: Healthcare Smart Card - Postal Code | nvarchar | 7 | 0 | ||
| 2 | NPIR | IS-H: Insurance Relationship Proposal Pool | 64 | VKPLZ | IS-H: Healthcare Smart Card - Postal Code | nvarchar | 7 | 0 | ||
| Patient Management | ||||||||||
| 3 | NIPP | IS-H: Provisional Insurance Relationship of Preregistration | 34 | VKPLZ | IS-H: Healthcare Smart Card - Postal Code | nvarchar | 7 | 0 | ||