Claim Administrator table (tblClaimAdmin)
Diagram
Fields
Name | Type | Mandatory | Default | Explanation |
|---|---|---|---|---|
ClaimAdminId | int (PK) | YES |
|
|
ClaimAdminCode | nvarchar(8) | NO |
|
|
LastName | nvarchar(100) | NO |
|
|
OtherNames | nvarchar(100) | NO |
|
|
DOB | date | NO |
|
|
Phone | nvarchar(50) | NO |
|
|
HFId | int | NO |
| FK tblHF |
EmailId | nvarchar(200) | NO |
|
|
HasLogin | bit | NO |
|
|
ClaimAdminUUID | uniqueidentifier | YES | newid() |
|
ValidityFrom | datetime | NO |
|
|
ValidityTo | datetime | NO |
|
|
LegacyID | int | NO |
|
|
AuditUserID | int | NO |
|
|
RowID | timestamp | NO |
|
|
Did you encounter a problem or do you have a suggestion?
Please contact our Service Desk
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. https://creativecommons.org/licenses/by-sa/4.0/