ra_EiMedicaid


Description

Early Intervention Medicaid remittance data storing detailed remittance information from Medicaid for Early Intervention services. This table captures Medicaid-specific remittance data including patient information, authorization numbers, service dates, billing amounts, payment amounts, and claim adjustment reason codes to support Medicaid claims processing, payment reconciliation, and compliance reporting for Early Intervention services.

Columns

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

Check or trace number - Medicaid check number or electronic trace number for payment identification
MedicaidCycle varchar 50 √ null

Medicaid cycle - Medicaid processing cycle identifier for the payment
LastName varchar 50 √ null

Patient last name - Last name of the patient who received services
FirstName varchar 50 √ null

Patient first name - First name of the patient who received services
PatientControlNumber varchar 50 √ null

Patient control number - Medicaid patient control number for claim identification
AuthorizationNumber varchar 30 √ null

Authorization number - Medicaid authorization number for the services provided
ServiceDate smalldatetime 16 √ null

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

Amount billed - Total amount billed to Medicaid for the services
AmountPaid money 21,4 √ null

Amount paid - Amount paid by Medicaid for the services
TCN varchar 50 √ null

Transaction control number - Medicaid transaction control number for tracking
Status varchar 50 √ null

Claim status - Status of the Medicaid claim (Paid, Denied, Pending, etc.)
CARGroupCode varchar 10 √ null

CAR group code - Claim Adjustment Reason group code from Medicaid
CARCode varchar 10 √ null

CAR code - Specific Claim Adjustment Reason code from Medicaid
CARDescription varchar 500 √ null

CAR description - Description of the Claim Adjustment Reason
RemarkCode varchar 10 √ null

Remark code - Additional remark codes from Medicaid remittance
RemarkDescription varchar 500 √ null

Remark description - Detailed description of the remark codes from Medicaid remittance
InvoiceNumber varchar 50 √ null

Invoice number - Invoice number associated with the Medicaid claim
EIDataSource varchar 50 √ null

EI data source - Early Intervention data source identifier for the claim
PatientAccountNumber varchar 50 √ null

Patient account number - Patient account number in the Medicaid system
fkFileID int 4 √ null

File reference - Links to raFiles table for the source remittance file
DateImported smalldatetime 16 √ (getdate())

Import date - Date when the Medicaid remittance data was imported
pkEiMedicaidID int identity 4 √ null

Primary key - Unique identifier for each Early Intervention Medicaid remittance record

Indexes

Constraint Name Type Sort Column(s)
PK_ra_EIMedicaidId Primary key Asc pkEiMedicaidID

Relationships

Close relationships within degrees of separation