PAT_ENC_CLAIMS
Description:
This table stores claim-related information for the patient encounter.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1

Column Information
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