...
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 |
...