Claim Services table (tblClaimServices)
Diagram
Fields
Name | Type | Mandatory | Default | Explanation |
|---|---|---|---|---|
ClaimServiceID | int (PK) | YES |
|
|
ClaimID | int | YES |
| FK tblClaim |
ItemID | int | YES |
| FK tblServices |
ProdID | int | NO |
| FK tblProduct |
ClaimServiceStatus | tinyint | YES | 1 | 1: Accepted | 2: Rejected |
QtyProvided | decimal(18, 2) | YES |
|
|
QtyApproved | decimal(18, 2) | NO |
|
|
PriceAsked | decimal(18, 2) | YES |
|
|
PriceAdjusted | decimal(18, 2) | NO |
|
|
PriceApproved | decimal(18, 2) | NO |
|
|
PriceValuated | decimal(18, 2) | NO |
|
|
Explanation | ntext | NO |
|
|
Justification | ntext | NO |
|
|
RejectionReason | smallint | NO | 0 |
|
ValidityFromReview | datetime | NO |
|
|
ValidityToReview | datetime | NO |
|
|
AuditUserIDReview | int | NO |
|
|
LimitationValue | decimal(18, 2) | NO |
|
|
Limitation | char(1) | NO |
|
|
PolicyID | int | NO |
|
|
RemuneratedAmount | decimal(18, 2) | NO |
|
|
DeductableAmount | decimal(18, 2) | NO |
|
|
ExceedCeilingAmount | decimal(18, 2) | NO |
|
|
PriceOrigin | char(1) | NO |
|
|
ExceedCeilingAmountCategory | decimal(18, 2) | NO |
|
|
ValidityFrom | datetime | YES | Current date |
|
ValidityTo | datetime | NO |
|
|
LegacyID | int | NO |
|
|
AuditUserID | int | YES |
|
|
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/