| 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 | 62 | VKGBDAT | IS-H: Healthcare Smart Card - Date of Birth | nvarchar | 8 | 0 | ||
| 2 | NPIR | IS-H: Insurance Relationship Proposal Pool | 61 | VKGBDAT | IS-H: Healthcare Smart Card - Date of Birth | nvarchar | 8 | 0 | ||
| Patient Management | ||||||||||
| 3 | NIPP | IS-H: Provisional Insurance Relationship of Preregistration | 31 | VKGBDAT | IS-H: Healthcare Smart Card - Date of Birth | nvarchar | 8 | 0 | ||