tblHF

int (PK)

YES

HFCode

nvarchar(8)

YES

HFName

nvarchar(100)

YES

LegalForm

char (FK tblLegalForms)

YES

HFLevel

char(1)

YES

one of the values ['H', ‘C', 'D'] corresponding to ['hospital’, ‘hospital center’, ‘dispensary’]

HFSublevel

char (FK tblHFSublevel)

NO

HFAddress

nvarchar(100)

NO

LocationId

int (FK tblLocation)

YES

District level

Phone

nvarchar(50)

NO

Fax

nvarchar(50)

NO

eMail

nvarchar(50)

NO

HFCareType

char(1)

YES

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

PLServiceID

int (FK tblPLServices)

NO

PLItemID

int (FK tblPLItems)

NO

AccCode

nvarchar(25)

NO

OffLine

bit

YES

ValidityFrom

datetime

YES

ValidityTo

datetime

NO

LegacyID

int

NO

AuditUserID

int

YES

RowID

timestamp

NO

HfUUID

uniqueidentifier

YES

New UUID