ra_EiEscrow


Description

Early Intervention escrow payment tracking managing escrow fund payments and reconciliation for Early Intervention services. This financial tracking table handles complex payment scenarios where funds are held in escrow pending insurance processing, enabling accurate financial reconciliation between multiple payment sources including insurance, Medicaid, and escrow funds.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
CheckNumber varchar 50 √ null

Check number - Reference number of the escrow payment check issued to the provider
CheckDate smalldatetime 16 √ null

Check date - Date when the escrow payment check was issued
EIDataSource varchar 50 √ null

EI data source - Source system or entity that provided the Early Intervention payment data
County varchar 50 √ null

County - Geographic county where the Early Intervention services were provided
ChildLastName varchar 50 √ null

Child last name - Last name of the child who received Early Intervention services
ChildFirstName varchar 50 √ null

Child first name - First name of the child who received Early Intervention services
ChildDOB smalldatetime 16 √ null

Child date of birth - Birth date of the child for identification and eligibility verification
AuthorizationNum varchar 30 √ null

Authorization number - Service authorization number from the funding source
ServiceDate smalldatetime 16 √ null

Service date - Date when the Early Intervention services were provided
AmountOnCheck money 21,4 √ null

Check amount - Total monetary amount of the escrow payment check
TotalClaimAmount money 21,4 √ null

Total claim amount - Total amount claimed for the services provided
AmountFromEscrow money 21,4 √ null

Escrow amount - Portion of payment that came from escrow funds
EscrowBatchDate smalldatetime 16 √ null

Escrow batch date - Date when the escrow payment was processed in batch
AmountFromInsurance money 21,4 √ null

Insurance amount - Portion of payment that came from private insurance
InsurancePaymentDate smalldatetime 16 √ null

Insurance payment date - Date when insurance payment was received
AmountFromMedicaid money 21,4 √ null

Medicaid amount - Portion of payment that came from Medicaid
MedicaidPaymentDate smalldatetime 16 √ null

Medicaid payment date - Date when Medicaid payment was received
PatientAccountNumber varchar 50 √ null

Patient account number - Internal account number for the patient receiving services
ProviderInvoiceNumber varchar 50 √ null

Provider invoice number - Invoice number submitted by the healthcare provider
TherapistFirstName varchar 100 √ null

Therapist first name - First name of the therapist who provided the services
TherapistLastName varchar 100 √ null

Therapist last name - Last name of the therapist who provided the services
TherapistNPI varchar 11 √ null

Therapist NPI - National Provider Identifier for the therapist
fkFileID int 4 √ null

File foreign key - Links to the import file that contained this escrow payment data
DateImported smalldatetime 16 √ (getdate())

Import date - Date when this escrow payment record was imported into the system
pkEibillingRemitID int identity 4 √ null

Primary key - Unique identifier for the Early Intervention billing remittance record
MedicaidDenialCode nvarchar 200 √ null

Medicaid denial code - Code indicating reason for Medicaid payment denial, if applicable
InsuranceDenialCode nvarchar 200 √ null

Insurance denial code - Code indicating reason for insurance payment denial, if applicable
CurrentStatus nvarchar 20 √ null

Current status - Current processing status of the escrow payment (Pending, Processed, Reconciled, etc.)
EscrowAmountRefund money 21,4 √ null

Escrow refund amount - Amount refunded from escrow if overpayment occurred
PaymentMethod nvarchar 30 √ null

Payment method - Method used for escrow payment (Check, ACH, Wire Transfer, etc.)

Indexes

Constraint Name Type Sort Column(s)
PK_ra_EibillingRemitId Primary key Asc pkEibillingRemitID

Relationships

Close relationships within degrees of separation