Diagram
...
Fields
Name | Type | Mandatory | Default | Explanation |
---|---|---|---|---|
ClaimID | int (PK) | YES | ||
InsureeID | int (FK tblInsuree) | YES | ||
ClaimCode | nvarchar (max 8 chars) | YES | ||
DateFrom | smalldatetime | YES | ||
DateTo | smalldatetime | NO | ||
ICDID | int (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 | |
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 | ||
LegacyID | int | NO | ||
AuditUserID | int | YES | ||
ValidityFromReview | datetime | NO | ||
ValidityToReview | datetime | NO | ||
AuditUserIDReview | int | NO | ||
RowID | timestamp | NO | ||
HFID | int (FK tblHF) | YES | ||
RunID | int (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 (FK tblClaimAdmin) | NO | ||
ICDID1 | int | NO | ||
ICDID2 | int | NO | ||
ICDID3 | int | NO | ||
ICDID4 | int | NO | ||
VisitType | char (1) | NO | ||
ClaimCategory | char (1) | NO | ||
ClaimUUID | uniqueidentifier | YES | New UUID |
Forms
The following forms/pages are displaying or edit Claim related data:
...