Diagram
Fields
Name | Type | Mandatory | Default | Explanation | |
---|---|---|---|---|---|
ClaimID | int (PK) | YES | |||
InsureeID | int (FK tblInsuree) | YES | FK tblInsurees | ||
ClaimCode | nvarchar (max 8 chars) | YES | |||
DateFrom | smalldatetime | YES | |||
DateTo | smalldatetime | NO | |||
ICDID | int ( | YES | FK tblICDCodes) | YES | |
ClaimStatus | tinyint | YES | 2 | ||
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 (FK tblFeedback) | NO | 0 | FK tblFeedback | |
Explanation | ntext | NO | |||
FeedbackStatus | tinyint | NO | 1 | ||
ReviewStatus | tinyint | NO | 1 | ||
ApprovalStatus | tinyint | NO | 1 | ||
RejectionReason | tinyint | NO | 0 | ||
ValidityFrom | datetime | YES | Current date | ||
ValidityTo | datetime | NO |
Name | Type | Mandatory | Default | Explanation | |
---|---|---|---|---|---|
LegacyID | int | NO | |||
AuditUserID | int | YES | |||
ValidityFromReview | datetime | NO | |||
ValidityToReview | datetime | NO | |||
AuditUserIDReview | int | NO | |||
RowID | timestamp | NO | |||
HFID | int ( | YES | FK tblHF) | YES | |
RunID | int ( | NO | FK tblBatchRun) | NO | |
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)NO | ||
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 |
Forms
The following forms/pages are displaying or edit Claim related data: