IDENTITY_CHANGES

Description:

This table contains information regarding the identity (demographic) changes that are made to the guarantor. The identity changes include changes to a guarantor's name, sex, social security number and/or date of birth. Whenever user tries to change the identity information in Hyperspace this table will log the action.

Primary Key

Column Name	Ordinal Position
ACCT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ACCT_ID	NUMERIC	No
	The unique ID of the guarantor account record for this row. This column is frequently used to link to the ACCOUNT table.
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	ID_CHANGE_USER_ID	VARCHAR	No
	User that chose to change the guarantor's identity despite being warned by overlay detection.
4	ID_CHANGE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
5	ID_CHANGE_REASON_C_NAME	VARCHAR	No
	Reason why the user chose to change the guarantor's identity. May contain organization-specific values: Yes Category Entries: Demographic Linking Incoming Interface Demographic Change Incoming Enrollment Filer Patient Verified Demographic Change Verified Photo ID Fix Needed from Incorrect Patient Merge
6	ID_CHG_OLD_NAME	VARCHAR	No
	Guarantor name prior to the identity change.
7	ID_CHG_OLD_SEX_C_NAME	VARCHAR	No
	Guarantor sex prior to the identity change. May contain organization-specific values: Yes Category Entries: Female Male Unknown Nonbinary X Other
8	ID_CHG_OLD_DOB_DT	DATETIME	No
	Guarantor date of birth prior to the identity change.
9	ID_CHG_NEW_NAME	VARCHAR	No
	Guarantor name after the identity change.
10	ID_CHG_NEW_SEX_C_NAME	VARCHAR	No
	Guarantor sex after the identity change. The category values for this column were already listed for column: ID_CHG_OLD_SEX_C_NAME
11	ID_CHG_NEW_DOB_DT	DATETIME	No
	Guarantor date of birth after the identity change.