FOLLOW_UP_TOPICS

Description: |
This table contains information regarding patient outreach topics, patients for which outreach was performed on these topics, who performed the outreach and when the outreach was done. The records included in this table are LFT records that are designated as clincal outreach tracking records.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
FOLLOW_UP_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | FOLLOW_UP_ID | NUMERIC | No |
The unique identifier (.1 item) for the record.
2 | CM_PHY_OWNER_ID | VARCHAR | No |
The Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
3 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
4 | FOLLOW_UP_DTTM | DATETIME (UTC) | No |
This column displays the instant of patient outreach.
5 | FOLLOW_UP_TOPIC_C_NAME | VARCHAR | No |
This column displays patient outreach topics such as Diabetes or Hypertension.
May contain organization-specific values: Yes
Category Entries:
General
Diabetes mellitus
Hypertension
Asthma
Congestive heart failure
Chronic kidney disease
Obesity
Preventive Screening
Immunizations
Coronary artery disease
Chronic liver disease
Chronic obstructive pulmonary disease
Cystic fibrosis
HIV/AIDS
Osteoporosis
Cervical Cancer Screening
Breast Cancer Screening
Colorectal Cancer Screening
Tobacco Cessation Counseling
Tetanus, diphtheria, pertussis
Human papillomavirus
Meningococcal
Influenza
Pneumococcal
Hepatitis A
Hepatitis B
Inactivated poliovirus
Measles, mumps, rubella
Varicella
Rotavirus
Diphtheria, tetanus, pertussis
Haemophilus influenzae type b
Medication Transition
Fall Risk
Depression
Chronic Opioid Management
ADHD
Schizophrenia
Substance Use Disorder
PTSD
Lung Cancer Screening
Cancer Symptom Monitoring
All Topics
Non-Clinical Communication
6 | FOLLOW_UP_USER_ID | VARCHAR | No |
This column displays the user who performed the patient outreach action. This column is frequently used to link to the CLARITY_EMP table.
7 | FOLLOW_UP_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
8 | FOLLOW_UP_NEXT_DT | DATETIME | No |
This column displays the date when the patient will next require outreach.
9 | LINKED_CSN_ID | NUMERIC | No |
This item contains a pointer to the encounter linked with this outreach.
10 | PAT_OUT_SOURCE_C_NAME | VARCHAR | No |
Stores the source of the patient outreach
May contain organization-specific values: No
Category Entries:
Health Maintenance
11 | MAIL_LETTER_NUM | INTEGER | No |
This contains the line in SI EPT 20200 which contains the details of the letter.
12 | PHONE_MSG_ID | VARCHAR | No |
This item stores the pointer to the In Basket message that is sent out to support staff asking them to call patients.
13 | PAT_PORTAL_MESSAGE_ID | VARCHAR | No |
This item stores a pointer to the MyChart message.