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.