tblHF

int (PK)

YES

HFCode

nvarchar(8)

YES

HFName

nvarchar(100)

YES

LegalForm

char (

YES

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

HFLevel

char(1)

YES

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

HFSublevel

char (

NO

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

HFAddress

nvarchar(100)

NO

LocationId

int (

YES

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 (

NO

FK tblPLServices)NO

PLItemID

int (

NO

FK tblPLItems)NO

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