Diagram

Fields

Name	Type	Mandatory	Default	Explanation

Name	Type	Mandatory	Explanation
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 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

Name	Type	Mandatory	Default	Explanation

Name	Type	Mandatory	Default	Explanation
HFCareType	char(1)	YES		One of the values 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

The following forms/pages are displaying or edit HF-related data: