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