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