|
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 |
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 |
|
|
7 |
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 |
|
|
8 |
ACCT_PRIM_EPSD_ID |
VARCHAR |
No |
|
|
|
Episode associated with this account. |
|
|
9 |
ACCT_COMMENT |
VARCHAR |
No |
|
|
|
Free text comment associated with this account. |
|
|
10 |
ACCT_PRIM_CLAIM_ID |
NUMERIC |
No |
|
|
|
The unique system Identifier of the patient's primary Claim. |
|
|