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.