Diagram
Fields
Name | Type | Mandatory | Explanation |
---|---|---|---|
ClaimID | int | YES | |
InsureeID | int | YES | |
ClaimCode | nvarchar (max 8 chars) | YES | |
DateFrom | smalldatetime | YES | |
DateTo | smalldatetime | NO | |
ICDID | int | YES | |
ClaimStatus | tinyint | YES | |
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 | |
DateProcessed | smalldatetime | NO | |
Feedback | bit | YES | |
FeedbackID | int | NO | |
Explanation | ntext | NO | |
FeedbackStatus | tinyint | NO | |
ReviewStatus | tinyint | NO | |
ApprovalStatus | tinyint | NO | |
RejectionReason | tinyint | NO | |
ValidityFrom | datetime | YES | |
ValidityTo | datetime | NO | |
LegacyID | int | NO | |
AuditUserID | int | YES | |
ValidityFromReview | datetime | NO | |
ValidityToReview | datetime | NO | |
AuditUserIDReview | int | NO | |
RowID | timestamp | NO | |
HFID | int | YES | |
RunID | int | 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 | |
ICDID1 | int | NO | |
ICDID2 | int | NO | |
ICDID3 | int | NO | |
ICDID4 | int | NO | |
VisitType | char (1) | NO | |
ClaimCategory | char (1) | NO | |
ClaimUUID | uniqueidentifier | YES |
Forms
The following forms/pages are displaying or edit Claim related data: