Diagram
Fields
Name | Type | Mandatory | Default | Explanation | ||
---|---|---|---|---|---|---|
tblHF | int (PK) | YES | ||||
HFCode | nvarchar(8) | YES | ||||
HFName | nvarchar(100) | YES | ||||
LegalForm | char ( | YES | FK tblLegalForms)YES | |||
HFLevel | char(1) | YES | One of the values | |||
HFSublevel | char ( | NO | FK tblHFSublevel)NO | |||
HFAddress | nvarchar(100) | NO | ||||
LocationId | int ( | YES | FK tblLocation) | YES | District level | |
Phone | nvarchar(50) | NO | ||||
Fax | nvarchar(50) | NO | ||||
nvarchar(50) | NO |
Name | Type | Mandatory | Default | Explanation | |
---|---|---|---|---|---|
HFCareType | char(1) | YES | One of the values | ||
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 |
Forms
The following forms/pages are displaying or edit HF-related data: