Claim

Primary key - Unique identifier for each service claim

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

Service date - Date when the healthcare service was actually delivered

Billing cycle date - Date associated with the billing cycle for this claim

Last update date - Timestamp of the most recent claim modification

Charged amount - Total amount charged for the service

Agency reference - Links to iCS2.dbo.Agency for centralized healthcare provider organization management and multi-tenant data segregation

Invoice reference - Links to Invoice table if claim is part of an invoice

Patient reference - Links to Patient table for the client receiving services

Claim type - Links to iCS2.dbo.ClaimType for centralized claim type classification (Initial, Corrected, Void, etc.)

Site reference - Links to AgencySite table for the service delivery location

Internal Control Number - Unique claim tracking number for clearinghouse processing

Line number - Line item number for multi-line claims

Entered by user - UserID of the person who entered the claim

Claim status - Current processing status of the claim referencing iCS2.dbo.StatusType for centralized status management across all healthcare billing processes

Paid amount - Amount actually paid by insurance or payer

Payment date - Date when payment was received

Billing date - Date when claim was submitted to payer

Action reference - Links to action taken on the claim

Procedure reference - Links to procedures table for the CPT/HCPCS code

Modifier reference - Links to iCS2.dbo.Modifier for centralized billing modifier definitions and standardized modifier codes used across all healthcare billing processes

Service type - Links to iCS2.dbo.ServiceType for centralized service type definitions and standardized service codes across the multi-tenant healthcare system

Clearinghouse error - Reference to clearinghouse rejection or error codes

Rule error code - Internal business rule validation error code

Claim comments - Notes about the claim processing or issues

Updated by user - UserID of the person who last modified the claim

Claimed by user - UserID of the person responsible for the claim

Action date - Date when last action was taken on the claim

Transaction type - Type of financial transaction for this claim

Prior authorization - Prior authorization number from insurance

Remittance ID - Reference to remittance advice document

Check number - Check number for payment received

Remittance advice ID - Links to remittance advice record

Void reference - Reference to void transaction if claim was voided

Data source - Source of claim data entry (manual, import, etc.)

Original billing date - Date when claim was first billed

Transmission type - Method of claim transmission (Electronic, Paper, etc.)

PPD reference - Reference to payment processing document

Borough - Geographic borough for reporting and processing

Active payroll - Flag indicating if claim affects active payroll

Adjusted amount - Amount of any adjustments made to the claim

Voided amount - Amount voided if claim was cancelled

Adjustment date - Date when claim adjustment was made

Void date - Date when claim was voided

Case reference - Links to PatientAdministration table for the case

Payment source - Identifier for the payment source or payer

Attendance code - Code indicating attendance or participation status

Authorization reference - Links to Authorize table for service authorization

Hold status - Flag indicating if claim is on hold for processing

Original charged amount - Original amount before any adjustments

Outstanding balance - Remaining unpaid amount on the claim

Service minutes - Duration of service in minutes

Import identifier - Reference ID for data migration and import tracking

Care plan reference - Links to care plan identifier

Service start time - Time when service began

Service end time - Time when service ended

Billing units - Number of billable units for the service

Department reference - Links to department providing the service

Import date - Date when claim data was imported

Original billing units - Original number of units before adjustments

CPT code - Current Procedural Terminology code for the service

Updated date - Most recent update timestamp

Form completed - Flag indicating if required forms are completed

Waiver reference - Links to waiver program if applicable