Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| EditCode | Unknown | 0 | null |
|
|
Edit code - Specific edit or error code from EDI processing |
||
| EditDescription | Unknown | 0 | null |
|
|
Edit description - Description of the edit or error |
||
| pk_ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each EDI claim edit record |
|
| fkEDIFileID | int | 4 | √ | null |
|
|
EDI file reference - Links to EDI file that contained this claim edit |
|
| PatientID | int | 4 | √ | null |
|
|
Patient reference - Links to Patient table for the claim |
|
| PatientName | varchar | 200 | √ | null |
|
|
Patient name - Name of the patient for this claim edit |
|
| ClaimTraceNumber | varchar | 200 | √ | null |
|
|
Claim trace number - Unique trace number for tracking the claim |
|
| ClaimID | int | 4 | √ | null |
|
|
Claim reference - Links to Claim table for the associated claim |
|
| ResolutionStatus | Unknown | 0 | null |
|
|
Resolution status - Status of edit resolution (Pending, Resolved, Ignored) |
||
| ServiceDate | varchar | 30 | √ | null |
|
|
Service date - Date of service for the claim |
|
| EDIClaimStatus | varchar | 30 | √ | null |
|
|
EDI claim status - Status of the claim in EDI processing |
|
| ProgramTypeID | int | 4 | √ | null |
|
|
Program type reference - Links to program type for the claim |
|
| BatchId | int | 4 | √ | null |
|
|
Batch reference - Links to billing batch for this claim |
|
| NYEISID | varchar | 100 | √ | null |
|
|
NY EIS ID - New York Early Intervention System identifier |
|
| MunicipaltyCode | varchar | 100 | √ | null |
|
|
Municipality code - Code for the municipality or local area |
|
| PayerClaimControlNumber | bigint | 8 | √ | null |
|
|
Payer control number - Payer-assigned claim control number |
|
| Severity | Unknown | 0 | null |
|
|
Edit severity - Severity level of the edit (Warning, Error, Fatal) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IX_EDIClaimEdits_ClaimID | Performance | Asc | ClaimID |
| IX_EDIClaimEdits_fkEDIFileID | Performance | Asc | fkEDIFileID |
Relationships
Close relationships within degrees of separation
