Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Clinical System | ||||||||||
1 | N1LAPP | services without case or movement reference | 4 | LNRAPP | IS-H: Sequence Number of Provisional Appointment | nvarchar | 10 | 0 | ||
2 | NLEM | IS-H*MED: Medical Service | 42 | LNRAPP | IS-H: Sequence Number of Provisional Appointment | nvarchar | 10 | 0 | ||
Patient Management | ||||||||||
3 | NAPP | IS-H: Provisional Appointments for Visit Scheduling | 2 | LNRAPP | IS-H: Sequence Number of Provisional Appointment | nvarchar | 10 | 0 |