Claim Administrator table (tblClaimAdmin)

Diagram

Fields

Name

Type

Mandatory

Default

Explanation

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/