tblHF

int (PK)

YES

HFCode

nvarchar(8)

YES

HFName

nvarchar(100)

YES

LegalForm

char

YES

FK tblLegalForms
C: Charity
D: District organization
G: Government
P: Private organization

HFLevel

char(1)

YES

one One of the values
H: Hospital
C: Hospital center
D: Dispensary

HFSublevel

char

NO

FK tblHFSublevel
I: Integrated
N: No Sublevel
R: Reference

HFAddress

nvarchar(100)

NO

LocationId

int

YES

FK tblLocation
District level

Phone

nvarchar(50)

NO

Fax

nvarchar(50)

NO

eMail

nvarchar(50)

NO

HFCareType

char(1)

YES

one One of the values ['I', ‘O', 'B'] corresponding to ['in-patient’, ‘out-patient’, ‘both’]
I: In-patient
O: Out-patient
B: Both

PLServiceID

int

NO

FK tblPLServices

PLItemID

int

NO

FK tblPLItems

AccCode

nvarchar(25)

NO

OffLine

bit

YES

0

ValidityFrom

datetime

YES

current date and time

ValidityTo

datetime

NO

LegacyID

int

NO

AuditUserID

int

YES

RowID

timestamp

NO

HfUUID

uniqueidentifier

YES

New UUID