EXT_GUARANTOR_DATA

Description: |
Clarity table for External Guarantor data.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
EXTERNAL_CVG_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | EXTERNAL_CVG_ID | NUMERIC | No |
The unique identifier (.1 item) for the external coverage record record.
2 | ASSOCIATED_ACCT_ID | NUMERIC | No |
The guarantor record associated with this External Guarantor data. This is the guarantor record linked or created from this External Guarantor data.
3 | EXT_GUAR_PAT_ENC_CSN_ID | NUMERIC | No |
The Contact Serial Number associated with this External Guarantor record.
4 | EXT_GUAR_NAME | VARCHAR | No |
The name of the guarantor that this External Guarantor record represents.
5 | EXT_GUAR_DOB_DATE | DATETIME | No |
The date of birth for the guarantor that this External Guarantor record represents.
6 | EXT_GUAR_MOBILE | VARCHAR | No |
The mobile phone number of the guarantor that this External Guarantor record represents.
7 | EXT_GUAR_EMAIL | VARCHAR | No |
The email address of the guarantor that this External Guarantor record represents.
8 | EXT_GUAR_REL_TO_PAT_C_NAME | VARCHAR | No |
The relationship to patient category value of the guarantor that this External Guarantor record represents.
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 | EXT_GUAR_ACCT_TYPE_2_C_NAME | VARCHAR | No |
The account type category value of the guarantor that this External Guarantor record represents.
May contain organization-specific values: Yes
Category Entries:
Other
Personal/Family
Non-Employed CRNA
Case Rate
Clearing Account
Trust Account
ROI Requester
Invalid