Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ActionRequired | Unknown | 0 | null |
|
|
Action required - Boolean indicating if action is required for this status |
||
| ClaimID | Unknown | 0 | null |
|
|
Claim reference - Links to the claim associated with this status code |
||
| pk_STC_ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each status code record |
|
| fkEDIClaimEditsID | int | 4 | √ | null |
|
|
EDI claim edit reference - Links to EDIClaimEdits table for the associated claim |
|
| ClaimStatusCode | varchar | 50 | √ | null |
|
|
Claim status code - Status code from EDI processing |
|
| ClaimStatusDate | varchar | 50 | √ | null |
|
|
Status date - Date associated with the claim status |
|
| ClaimStatusAmount | varchar | 50 | √ | null |
|
|
Status amount - Amount associated with the claim status |
|
| ClaimStatusMessage | varchar | 1000 | √ | null |
|
|
Status message - Message or description for the claim status |
|
| CACategoryCode | varchar | 50 | √ | null |
|
|
CA category code - Claim adjustment category code |
|
| CAStatusCode | varchar | 50 | √ | null |
|
|
CA status code - Claim adjustment status code |
|
| CAEntityCode | varchar | 50 | √ | null |
|
|
CA entity code - Claim adjustment entity code |
|
| EffectiveDate | Unknown | 0 | null |
|
|
Effective date - Date when this status became effective |
||
| PayerResponse | Unknown | 0 | null |
|
|
Payer response - Response from the payer regarding this status |
||
| pk_ID | Unknown | 0 | null |
|
|
Primary key - Unique identifier for each status tracking code record |
||
| ProcessedDate | Unknown | 0 | null |
|
|
Processed date - Date when the status was processed |
||
| ResolutionNotes | Unknown | 0 | null |
|
|
Resolution notes - Notes about resolving issues related to this status |
||
| StatusCategory | Unknown | 0 | null |
|
|
Status category - Category classification for the status code |
||
| StatusCode | Unknown | 0 | null |
|
|
Status code - EDI status tracking code |
||
| StatusDescription | Unknown | 0 | null |
|
|
Status description - Description of the status code meaning |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IX_EDIClaimSTC_fkEDIClaimEditsID | Performance | Asc | fkEDIClaimEditsID |
Relationships
Close relationships within degrees of separation
