ClaimID

int (PK)

YES

InsureeID

int

YES

FK tblInsurees

ClaimCode

nvarchar (max 8 chars)

YES

DateFrom

smalldatetime

YES

DateTo

smalldatetime

NO

ICDID

int

YES

FK tblICDCodes

ClaimStatus

tinyint

YES

2

1: Rejected | 2: Entered | 4: Checked | 8: Processed/Reviewed | 16: Valuated

Adjuster

int

NO

Adjustment

ntext

NO

Claimed

decimal (18, 2)

NO

Approved

decimal (18, 2)

NO

Reinsured

decimal (18, 2)

NO

Valuated

decimal (18, 2)

NO

DateClaimed

date

YES

Current date

DateProcessed

smalldatetime

NO

Feedback

bit

YES

0

FeedbackID

int

NO

0

FK tblFeedback

Explanation

ntext

NO

FeedbackStatus

tinyint

NO

1

ReviewStatus

tinyint

NO

1

1: Idle | 2: Not Selected | 4: Selected for Review | 8: Reviewed | 16: ByPassed

ApprovalStatus

tinyint

NO

1

RejectionReason

tinyint

NO

0

ValidityFrom

datetime

YES

Current date

ValidityTo

datetime

NO

LegacyID

int

NO

AuditUserID

int

YES

ValidityFromReview

datetime

NO

ValidityToReview

datetime

NO

AuditUserIDReview

int

NO

RowID

timestamp

NO

HFID

int

YES

FK tblHF

RunID

int

NO

FK tblBatchRun

AuditUserIDSubmit

int

NO

AuditUserIDProcess

int

NO

SubmitStamp

datetime

NO

ProcessStamp

datetime

NO

Remunerated

decimal (18, 2)

NO

GuaranteeId

nvarchar (max 50 chars)

NO

ClaimAdminId

int

NO

FK tblClaimAdmin

ICDID1

int

NO

ICDID2

int

NO

ICDID3

int

NO

ICDID4

int

NO

VisitType

char (1)

NO

Emergency, Referral, Other

ClaimCategory

char (1)

NO

Automatically defined in checking process: Surgery, Delivery, Antenatal, Hospitalisation, Consultation, Visit

ClaimUUID

uniqueidentifier

YES

New UUID