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