Claim


Description

Medical claims and billing transactions that represent individual service claims submitted for reimbursement. Each claim contains detailed information about services provided, billing codes, patient information, and processing status for insurance reimbursement.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
AuthorizationNumber Unknown 0 null

Authorization number - Prior authorization number if required for the service

BilledAmount Unknown 0 null

Billed amount - Total amount billed for the services

ClaimID int 4 null

Primary key - Claim unique identifier for each medical claim

ClaimStatus Unknown 0 null

Claim status - Current processing status (Submitted, Pending, Paid, Denied, etc.)

DateEntered datetime 16,3 null

Entry date - Date when the claim was entered into the system

DateService datetime 16,3 null

Service date - Date when the medical service was actually provided

DateCycle datetime 16,3 null

Billing cycle date - Date indicating which billing cycle this claim belongs to for processing and reporting

DateUpdate datetime 16,3 null

Last update date - Date when the claim record was last modified or updated

AmountCharged money 21,4 null

Amount charged - Total amount charged for the services provided on this claim

BillingUnit int 4 null

Billing unit - Unit of measurement for billing calculations (hours, sessions, visits, etc.)

AgencyID int 4 null

Agency reference - Reference to the healthcare agency that submitted this claim

InvoiceID nvarchar 20 null

Invoice identifier - Reference to the invoice that includes this claim for billing purposes

PatientID int 4 null

Patient reference - Reference to the patient who received the services

ClaimTypeID int 4 null

Claim type reference - Reference to the type of claim (evaluation, therapy, consultation, etc.)

SiteID int 4 null

Service site reference - Reference to the location where services were provided

ICN varchar 13 null

Internal control number - Unique tracking number assigned by the clearinghouse for claim processing

LineNumber varchar 3 null

Line number - Sequential line number for claims with multiple service lines

Enteredby int 4 null

Entry user reference - Reference to the user who entered this claim into the system

StatusID int 4 null

Status reference - Reference to the current processing status of the claim

AmountPaid money 21,4 null

Amount paid - Actual amount paid by the insurance or payer for this claim

DatePaid datetime 16,3 null

Payment date - Date when payment was received for this claim

DateBilled datetime 16,3 null

Billing date - Date when this claim was submitted for billing

ActionID int 4 null

Action reference - Reference to the last action performed on this claim

DiagnosisCode Unknown 0 null

Diagnosis code - Medical diagnosis code (ICD-10) supporting the medical necessity

ModifierID int 4 null

Modifier reference - Reference to billing modifiers applied to this claim

PaidAmount Unknown 0 null

Paid amount - Amount actually paid by the insurance or payer

PayerID Unknown 0 null

Payer reference - Reference to the insurance company or payer organization

PlaceOfService Unknown 0 null

Place of service - Code indicating where the service was provided

ProcedureCode Unknown 0 null

Procedure code - Medical procedure code (CPT, HCPCS) for the service provided

ProcedureID int 4 null

Procedure reference - Reference to the procedure code for services provided

ServiceTypeID int 4 null

Service type reference - Reference to the type of service provided

ClearingHouseErrorID int 4 null

Clearinghouse error reference - Reference to any errors reported by the billing clearinghouse

RuleError varchar 10 null

Rule error code - Error code indicating business rule violations or validation failures

Comments varchar 500 null

Claim comments - Free-text comments or notes about this claim

ClaimBy int 4 null

Claim submitter reference - Reference to the user who submitted this claim for processing

DateAction datetime 16,3 null

Action date - Date when the last action was performed on this claim

PriorAuth varchar 50 null

Prior authorization - Prior authorization number or reference if required for this service

ProviderID Unknown 0 null

Provider reference - Reference to the healthcare provider who delivered the services

RemittIDNumber int 4 null

Remittance ID - Reference to the remittance advice document for payment details

CheckNumber int 4 null

Check number - Check number for payment received for this claim

RA_ID int 4 null

Remittance advice ID - Reference to the electronic remittance advice record

DateOriginalBilled smalldatetime 16 null

Original billing date - Date when this claim was first submitted for billing

ActivePayroll int 4 null

Active payroll reference - Reference to the payroll period when services were provided

ppdID int 4 null

PPD reference - Reference to provider payment data or payment processing details

Borough int 4 null

Borough code - Geographic borough or district code for service location

ServiceUnits Unknown 0 null

Service units - Quantity or duration of services provided

SubmissionDate Unknown 0 null

Submission date - Date when the claim was submitted to the payer

UpdateBy int 4 null

Update user reference - Reference to the user who last updated this claim

TransType int 4 null

Transaction type - Type of transaction (Original, Adjustment, Void, etc.)

VoidID int 4 null

Void reference - Reference to the voiding transaction if this claim was voided

Source varchar 2 null

Source system - Code indicating the source system or method used to create this claim

TransmitType int 4 null

Transmission type - Method used to transmit this claim (Electronic, Paper, etc.)

Relationships