HSP_LETTER_MYC_VIEW_HX
Description:
This table stores the history of when billing letters were viewed in MyChart.

Primary Key
Column Name Ordinal Position
NOTE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 NOTE_ID VARCHAR No
The unique identifier (.1 item) for the note 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 VIEW_DTTM DATETIME (UTC) No
Stores the date and time the letter was viewed in MyChart.
4 MYPT_ID VARCHAR No
Stores the MyChart account ID that viewed the letter.