RESULT_AUDIT_ITEMS

Description:

This table contains the items that were changed during a finding record audit action. For one audit action there can be multiple items that were changed; this corresponds to the third primary key in this table, VALUE_LINE. This table will likely be joined to from RESULT_AUDIT, which holds the majority of the finding audit information.

Primary Key

Column Name	Ordinal Position
FINDING_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	FINDING_ID	NUMERIC	No
	The unique ID of the finding record.
2	GROUP_LINE	INTEGER	No
	The line number of the associated audit information in this finding record. Together with FINDING_ID, this forms the foreign key to the RESULT_AUDIT table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple items that are associated with the finding audit information from the RESULT_AUDIT table.
4	ITEM_CHANGED	VARCHAR	No
	The items that were changed during the particular action being audited.