PAT_ACCT_CVG

Description:

The PAT_ACCT_CVG table contains information about a patient’s accounts and coverages. The table will contain one record for each account for a patient. The record will also contain the patient’s primary coverage for that account.

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 security utility.
2	LINE	INTEGER	No
	The line number. A patient id can be associated with multiple rows of accounts and coverages.
3	ACCOUNT_ID	NUMERIC	No
	The unique account record ID for an account associated with this patient. This ID number may be encrypted if you have elected to use enterprise reporting’s security utility.
4	ACCOUNT_TYPE_C_NAME	VARCHAR	No
	Category value associated with the type of account, such as Personal/Family, Worker’s Comp, etc. May contain organization-specific values: Yes Category Entries: Other Personal/Family Non-Employed CRNA Case Rate Clearing Account Trust Account ROI Requester Invalid
5	ACCOUNT_ACTIVE_YN	VARCHAR	No
	Is the account active at the time of the extract: Y or N. May contain organization-specific values: No Category Entries: Yes No
6	COVERAGE_ID	NUMERIC	No
	The unique ID assigned to the coverage record associated with this patient and account. This ID may be encrypted if you have elected to use enterprise reporting’s encryption utility.
7	FIN_CLASS_NAME	VARCHAR	No
	The financial class category number for the patient's primary coverage on the account. If there is no coverage, it is the account's financial class. May contain organization-specific values: Yes Category Entries: Commercial Medicare Medicaid Self-Pay Worker's Comp Tricare Champva Group Health Plan FECA Black Lung Blue Shield Medigap Other DK Regional Client Received Self-Pay Sent to Consolidated Self-Pay Patient Assistance Program
8	GUAR_PAT_REL_NAME	VARCHAR	No
	Relation between the guarantor and patient. May contain organization-specific values: Yes Category Entries: Aunt Brother Daughter Father Friend Granddaughter Grandfather Grandmother Grandson Legal Guardian Mother Other Step Father Sister Self Step Mother Son Spouse Uncle Employer Unverified Proxy Transplant Recipient Visit Contact
9	ACCT_PRIM_EPSD_ID	VARCHAR	No
	Episode associated with this account.
10	ACCT_COMMENT	VARCHAR	No
	Free text comment associated with this account.
11	ACCT_PRIM_CLAIM_ID	NUMERIC	No
	The unique system Identifier of the patient's primary Claim.