outsClaims_01

Claim primary key - Unique identifier for each outside claim

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

Service date - Date when the healthcare service was provided

Billing cycle date - Date of the billing cycle for this claim

Last update date - Date when the claim was last updated

Amount charged - Total amount charged for the service

Agency reference - Links to Agency table for the healthcare provider

Invoice identifier - Invoice number for billing purposes

Patient reference - Links to Patient table for the patient receiving service

Claim type reference - Links to ClaimType table for type of claim

Site reference - Links to AgencySite table for service location

Internal control number - Internal control number for claim tracking

Line number - Line number on the claim form

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

Status reference - Links to StatusType table for claim status

Amount paid - Amount paid by insurance or payer

Payment date - Date when payment was received

Billing date - Date when claim was billed

Action reference - Links to ClaimAction table for claim action

Procedure reference - Links to ProcCode table for procedure performed

Modifier reference - Links to Modifier table for procedure modifier

Service type reference - Links to ServiceType table for type of service

Clearing house error reference - Links to ClearingHouseError table for processing errors

Rule error - Business rule error code

Claim comments - Comments and notes about the claim

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

Claimed by user - UserID of the service provider who performed the service

Action date - Date when claim action was taken

Transaction type - Type of transaction for the claim

Prior authorization - Prior authorization number

Remittance ID - Remittance advice identifier

Check number - Payment check number

Remittance advice ID - Links to remittance advice record

Void reference - Links to VoidReason table if claim is voided

Claim source - Source of claim data entry

Original billing date - Date when claim was originally billed

Transmission type - Type of claim transmission (electronic, paper, etc.)

PPD reference - Links to PPD data for claim processing

Borough - Borough or administrative region for the claim

Active payroll - Indicates if claim is part of active payroll

Amount adjusted - Amount adjusted on the claim

Amount voided - Amount voided on the claim

Adjustment date - Date when claim was adjusted

Void date - Date when claim was voided

Case reference - Links to PatientAdministration table for the case

Payment source - Payment source identifier

Attendance code - Attendance code for the service

Authorization reference - Links to Authorization table for service authorization

On hold flag - Indicates if claim is on hold

Original amount charged - Original amount charged before adjustments

Outstanding amount - Outstanding amount on the claim

Service minutes - Duration of service in minutes

Import reference - Reference ID for data import tracking

Claim type program reference - Links to claim type program configuration

Service start time - Start time of the service

Service end time - End time of the service

Billing units - Number of billing units for the service

Department reference - Department identifier for the service

Import date - Date when claim data was imported

Original billing units - Original billing units before adjustments

CPT code - Current Procedural Terminology code for the service