Medical Service table (tblServices)
Diagram
Fields
Name | Type | Mandatory | Default | Explanation |
|---|---|---|---|---|
ServiceID | int (PK) | YES |
|
|
ServCode | nvarchar(6) | YES |
|
|
ServName | nvarchar(100) | YES |
|
|
ServType | char(1) | YES |
| One of the values: Preventive, Curative |
ServLevel | char(1) | YES |
| One of the values: Simple Service, Visit, Day of stay, Hospital case |
ServPrice | decimal(18, 2) | YES |
|
|
ServCareType | char(1) | YES |
| One of the values: In-patient, Out-patient, Both |
ServFrequency | smallint | NO |
|
|
ServPatCat | tinyint | YES |
| Value binary codded: 1 - Valid, 0 - Not Valid |
ServCategory | char(1) | NO |
| One of the values: Surgery, Consultation, Delivery, Antenatal, Other |
ServiceUUID | uniqueidentifier | YES | New UUID |
|
ValidityFrom | datetime | YES | Current date |
|
ValidityTo | datetime | NO |
|
|
LegacyID | int | NO |
|
|
AuditUserID | int | YES |
|
|
RowID | timestamp | NO |
|
|
Did you encounter a problem or do you have a suggestion?
Please contact our Service Desk
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. https://creativecommons.org/licenses/by-sa/4.0/