|
Name |
Type |
Discontinued? |
|
1 |
PAT_ENC_CSN_ID |
NUMERIC |
No |
|
|
|
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI). |
|
|
2 |
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. |
|
|
3 |
CONTACT_DATE |
DATETIME |
No |
|
|
|
The date of this contact in calendar format. |
|
|
4 |
CM_CT_OWNER_ID |
VARCHAR |
No |
|
|
|
The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect. |
|
|
5 |
EXPRESS_CLAIM_TRIGGERED_YN |
VARCHAR |
No |
|
|
|
Indicates whether express claims were triggered. "Y" indicates that Express Claims Processing was initiated for the patient encounter. "N" or NULL indicates that Express Claims Processing was not initiated for the patient encounter. |
May contain organization-specific values: No |
Category Entries: |
No |
Yes |
|
|
6 |
EC_TRIGGERED_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
the instant of the most recent attempt to trigger Express Claims |
|
|
7 |
EXPR_CLM_NOT_TRGR_RSN_C_NAME |
VARCHAR |
No |
|
|
|
the most recent reason that Express Claims were not triggered |
May contain organization-specific values: No |
Category Entries: |
Encounter not closed |
Claim already created |
Encounter does not meet criteria |
Pended charge not yet triggered |
Charge in router review workqueue |
Charge in holding pool |
Charge in processing pool |
Charge in error pool |
Charge in batch |
Charge in PB filer |
Charge in PB charge review workqueue |
Level of Service charges not triggered |
E/M charges not triggered |
Charge Capture, Flowsheet, or Immunization charges not triggered |
Orders awaiting transmittal |
Orders charges not triggered |
|
|
8 |
NO_TRGR_INVOICE_ID |
NUMERIC |
No |
|
|
|
the invoice that was previously created |
|
|
9 |
NO_TRGR_UCL_ID |
VARCHAR |
No |
|
|
|
the charge that was not ready for claim creation |
|
|
10 |
NO_TRGR_WORKQUEUE_ID |
VARCHAR |
No |
|
|
|
the workqueue that held the charge |
|
|
11 |
NO_TRGR_WORKQUEUE_ID_WORKQUEUE_NAME |
VARCHAR |
No |
|
|
|
The name of the workqueue |
|
|
12 |
NO_TRGR_TAR_ID |
NUMERIC |
No |
|
|
|
the charge session that was not ready for claim creation |
|
|
13 |
NO_TRGR_ORDER_ID |
NUMERIC |
No |
|
|
|
the order that needed charges triggered or that was awaiting transmittal |
|
|
14 |
NO_TRIG_RECORD_ID |
NUMERIC |
No |
|
|
|
the unprocessed charge entry batch |
|
|