ELEM_VAL_PREV

Description: |
Contains information about previous values and comments for a SmartData element value.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
HLV_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | HLV_ID | NUMERIC | No |
The unique identifier (.1 item) for the value 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 | PREV_INSTANT_DTTM | DATETIME (Local) | No |
Instant of edit of previous smartdata element value or comment
4 | PREV_USERS | VARCHAR | No |
previous user to set value or comment
5 | PREV_SRC_NOTE_ID | VARCHAR | No |
The unique ID of the note that the previous value is attached to.
6 | PREV_NOTE_STATUS_C_NAME | VARCHAR | No |
The status of the previous note.
May contain organization-specific values: Yes
Category Entries:
Incomplete
Signed
Addendum
Deleted
Revised
Cosigned
Finalized
Unsigned
Cosign Needed
Incomplete Revision
Cosign Needed Addendum
Shared
7 | PREV_UTC_DTTM | DATETIME (UTC) | No |
The previous UTC instants at which this SDE was documented
8 | PREV_VALUE_INVLD_YN | VARCHAR | No |
Indicate a previous value to be invalid.
May contain organization-specific values: No
Category Entries:
No
Yes
9 | PREV_SET_BY_C_NAME | VARCHAR | No |
How the previous value was set
May contain organization-specific values: No
Category Entries:
Manual
Macro
AI
Calculation
Autopopulation
Copy Forward