| 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 | 61 | VKNNAM | IS-H: Healthcare smart card - last name | nvarchar | 28 | 0 | ||
| 2 | NPIR | IS-H: Insurance Relationship Proposal Pool | 60 | VKNNAM | IS-H: Healthcare smart card - last name | nvarchar | 28 | 0 | ||
| Patient Management | ||||||||||
| 3 | NIPP | IS-H: Provisional Insurance Relationship of Preregistration | 30 | VKNNAM | IS-H: Healthcare smart card - last name | nvarchar | 28 | 0 | ||