Table: ClaimsItems

Field Size
ClaimItemRef INT (IDENTITY)
ClaimRef INT
OriginalClaimRef INT
OrderItemRef INT
ChargeType TINYINT
CreditToPayerRef INT
CreditToPatientRef INT
Rank SMALLINT
RxNumber VARCHAR(15)
Description VARCHAR(50)
ServiceFrom DATE
ServiceTo DATE
Quantity REAL
UnitCost MONEY
TotalCost MONEY
UnitPrice MONEY
TotalPrice MONEY
UnitAllowable MONEY
TotalAllowable MONEY
Tax MONEY
NDC VARCHAR(11)
PlaceOfService VARCHAR(2)
TypeOfService VARCHAR(2)
HCPC VARCHAR(5)
Modifier VARCHAR(5)
HCFAReserved VARCHAR(11)
RevenueCode VARCHAR(4)
NonCoveredCharges MONEY
UB92Box49 VARCHAR(4)
NDCReasonForService VARCHAR(2)
NDCProfessionalService VARCHAR(2)
NDCResultOfService VARCHAR(2)
NDCOtherCoverage TINYINT
Charge BIT

View All Tables