SERVICE_PLAN_HX_CHANGE

Description:

The SERVICE_PLAN_HX_CHANGE table contains details of what items were modified in a revision of a service plan. Information about the user modifying the service plan and the time of modification can be found in SERVICE_PLAN_HX_REVISION.

Primary Key

Column Name	Ordinal Position
SERVICE_PLAN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	SERVICE_PLAN_ID	NUMERIC	No
	The unique identifier (.1 item) for the service plan 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	AUDIT_TRAIL_REVISION	INTEGER	No
	The revision in which this update was made. Corresponds with a line of SERVICE_PLAN_HX_REVISION.
4	AUDIT_TRAIL_ITEM	VARCHAR	No
	The number of the item that was updated
5	AUDIT_TRAIL_LINE	INTEGER	No
	The line of the item in AUDIT_TRAIL_ITEM being updated. 1 for single response items.
6	AUDIT_TRAIL_NEW_VALUE	VARCHAR	No
	The new value of the item in AUDIT_TRAIL_ITEM at the line in AUDIT_TRAIL_LINE, after the update is made.