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