LDA_DESCRIPTION_HISTORY
Description:
Holds the history of the various LDA descriptions that have been generated for this LDA overtime.

Primary Key
Column Name Ordinal Position
IP_LDA_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 IP_LDA_ID VARCHAR No
The unique identifier (.1 item) for the line/drain 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 DESCRIPTION_CREATED_UTC_DTTM DATETIME (UTC) No
Stores the instant an LDA name was updated. To be used with LDA 106 which stores the name that was generated at the instant stored in this item.
4 LDA_DESCRIPTION_HISTORY VARCHAR No
Stores the LDA description at a specific instant. To be used with LDA 105 which stores the instant that the description was generated.