TOB_PACKYEARS_DATA
Description:
Contains the tobacco history for the patient's cigarette use for their pack year history.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 TOB_HX_PACKS_PER_DAY_NUM NUMERIC No
Stores the packs per day for the current tobacco episode. Can be converted to cigarettes per day for display or entry via LQH settings.
4 TOB_HX_START_DATE DATETIME No
Start date for the tobacco episode, stored as a fuzzy date. DTE is followed with a [ followed by the precision. 1 - Year, 2 - Month, 3 - Day.
5 TOB_HX_END_DATE DATETIME No
End date for the tobacco episode, stored as a fuzzy date. DTE is followed with a [ followed by the precision. 1 - Year, 2 - Month, 3 - Day.
6 TOB_HX_YEARS_NUM NUMERIC No
Stores the years smoking for the current tobacco episode. Will not be set if TOB_HX_START_DATE and TOB_HX_END_DATE are set.