GUAR_ADDR_HX

Description:

This table holds the Accounts Receivable (EAR) related group 5000 pertaining to Guarantor Address Change History.

Primary Key

Column Name	Ordinal Position
ACCOUNT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ACCOUNT_ID	NUMERIC	No
	The unique identifier for the account record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	ADDR_CHANGE_DATE	DATETIME	No
	This column specifies the date on which the address change described on the rest of the row was performed.
4	ADDR_HX_1	VARCHAR	No
	This column contains the first line of a previous guarantor address.
5	ADDR_HX_2	VARCHAR	No
	This column contains the second line of a previous guarantor address.
6	ADDR_HX_EXTRA	VARCHAR	No
	This contains any additional lines for a previous guarantor address.
7	CITY_HX	VARCHAR	No
	This column contains the city for a previous address for this guarantor.
8	STATE_HX_C_NAME	VARCHAR	No
	This column contains the state for a previous address for this guarantor. May contain organization-specific values: Yes
9	ZIP_HX	VARCHAR	No
	This column contains the ZIP code for a previous address for this guarantor.
10	ADDR_CHANGE_SRC_C_NAME	VARCHAR	No
	This column contains the context from which the address change was performed. May contain organization-specific values: No Category Entries: Bridges EpicCare Cadence Professional Billing ManagedCare Chronicles