VARIANT_HT_AUDIT

Description:

This table contains information about changes to this variant record done as a result of Happy Together variant auto-reconciliation.

Primary Key

Column Name	Ordinal Position
VARIANT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	VARIANT_ID	NUMERIC	No
	The unique identifier for the variant 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. Each line corresponds to a happy together action taken on this variant record.
3	RESULT_KEY	VARCHAR	No
	The Reference ID of the result data to which this variant is linked. This can be used to link to result information for the result to which this variant is linked, for example, by linking to DOCS_RCVD_RSLTS and DOCS_RCVD_RSLT_VAR_INFO.
4	VAR_INFO_DOCUMENT_CSN_ID	NUMERIC	No
	The CSN of the source DXR from which this variant was reconciled
5	HT_VAR_AUDIT_ACTION_C_NAME	VARCHAR	No
	The action that was performed during variant auto-reconciliation May contain organization-specific values: No Category Entries: Created Automatically Retracted Invalidated
6	HT_VAR_AUDIT_UTC_DTTM	DATETIME (UTC)	No
	The time instant in UTC when the action was performed
7	HT_VAR_AUDIT_LOCAL_DTTM	DATETIME (Local)	No
	The time instant in local time when the action was performed