CHRONIC_MEDS

Description:

This table stores chronic medication information of a problem.

Primary Key

Column Name	Ordinal Position
PROBLEM_LIST_ID	1

Column Information

	Name	Type	Discontinued?
1	PROBLEM_LIST_ID	NUMERIC	No
	The unique identifier for the problem record.
2	CHRON_MED_ID_MEDICATION_NAME	VARCHAR	No
	The name of this medication record.
3	CHRON_MED_STRT_DATE	DATETIME	No
	The start date of the chronic medication.
4	CHRON_MED_END_DATE	DATETIME	No
	The end date of the chronic medication.
5	CHRON_MED_COMMENT	VARCHAR	No
	The comment for the medication.
6	PRESCRIBING_DOCT_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
7	CHRONIC_AILMENT_C_NAME	VARCHAR	No
	The chronic ailment of the medication. May contain organization-specific values: Yes
8	QUANTITY_PER_MONTH	INTEGER	No
	The quantity of the medication per month.
9	MEDICATION_STRENGTH	VARCHAR	No
	The strength of the medication.
10	INITIAL_COST_OF_MED	NUMERIC	No
	The initial cost of the medication.
11	APPLICATION_NUMBER	VARCHAR	No
	The application number of the chronic medication.
12	PRESCRIPTION_NUMBER	VARCHAR	No
	The prescription number of the chronic medication.
13	ORIGINAL_PRESCRI_YN	VARCHAR	No
	Flag indicates if this is the original prescription of the chronic medication. May contain organization-specific values: No Category Entries: NO YES
14	CHRON_MED_STS_C_NAME	VARCHAR	No
	The chronic medication status. May contain organization-specific values: No Category Entries: Pending Approved Denied Deleted
15	CHRON_MED_EFF_DATE	DATETIME	No
	Specifies the chronic meds effective date.