PAT_CVG_FILE_ORDER

Description:

The PAT_CVG_FILE_ORDER table contains information about the filing order of each member's coverages. Since members can have multiple coverages, each row of coverage filing order information in this table is identified by the patient ID and a line number.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID assigned to the patient record. This ID may be encrypted if you have elected to use enterprise reporting’s encryption utility.
2	LINE	INTEGER	No
	The line number used to identify each line of filing order information for the patient.
3	COVERAGE_ID	NUMERIC	No
	The unique ID assigned to the coverage record. This ID may be encrypted if you have elected to use enterprise reporting’s encryption utility.
4	FILING_ORDER	INTEGER	No
	The coverage filing order, as determined manually by a user or automatically using the automatic filing order rules.
5	FILING_ORDER_CAT	VARCHAR	No
	This field will contain the abbreviation Spec if the coverage has a relative filing order; for example, a worker’s comp coverage would have a filing order of Special so that coverage would be consulted first when working with worker’s comp related charges. May contain organization-specific values: No Category Entries: Special N/A N/A and Special
6	HOSP_FILE_ORD	INTEGER	No
	The coverage filing order pertaining to inpatient charges. This column only contains data if you are using Epic’s ADT or inpatient applications.
7	HOSP_FILE_ORD_CAT	VARCHAR	No
	This column only contains data if you are using Epic’s ADT or inpatient applications. The category values for this column were already listed for column: FILING_ORDER_CAT