|
Name |
Type |
Discontinued? |
|
| 1 |
PAT_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table. |
|
|
| 2 |
LINE |
INTEGER |
No |
|
|
|
| The line number for the information associated with this record. Multiple pieces of information can be associated with this record. |
|
|
| 3 |
EXT_REQ_PAYER_NAME |
VARCHAR |
No |
|
|
|
| This item stores the free-text payer name, used when an external payer organization (DXO) is not available. |
|
|
| 4 |
EXT_REQ_PAYER_ORGANIZATION_ID |
NUMERIC |
No |
|
|
|
| This item stores the external payer organization (DXO). |
|
|
| 5 |
EXT_REQ_PAYER_ORGANIZATION_ID_EXTERNAL_NAME |
VARCHAR |
No |
|
|
|
| Organization's external name used as the display name on forms and user interfaces. |
|
|
| 6 |
OUTSIDE_COVERAGE_MEM_IDENT |
VARCHAR |
No |
|
|
|
| This item stores the member ID for the coverage. |
|
|
| 7 |
EXT_DATA_REQ_STAT_C_NAME |
VARCHAR |
No |
|
|
|
| This item tracks the current state of the data request for the line-level external coverage. |
| May contain organization-specific values: No |
| Category Entries: |
| Needs manual review |
| Waiting for payer connection |
| Queued for member match |
| Request completed |
| Unable to connect |
| Member match failed |
| Abandoned (Do not retry) |
| Waiting for response |
| No data returned |
|
|
| 8 |
EXT_REQ_GROUP_IDENT |
VARCHAR |
No |
|
|
|
| This item stores the payer-assigned group ID. |
|
|
| 9 |
LST_COMP_REQ_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| This item stores the time of the last completed Payer-to-Payer data exchange request. |
|
|
| 10 |
LNK_COVERAGE_ID |
NUMERIC |
No |
|
|
|
| This item stores the coverage ID. |
|
|
