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.