ORDER_FIRST_DOSE_EDU_PTR

Description:

This table contains pointers for first-dose medication education for this ordered medication.

Primary Key

Column Name	Ordinal Position
ORDER_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ORDER_ID	NUMERIC	No
	The unique identifier (.1 item) for the order 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	FIRST_DOSE_EDU_MEDICATION_ID	NUMERIC	No
	The unique ID of the medication record associated with a first-dose education point for this medication. Similar medications in the same encounter hold identical values for this column. This is typically used to join to CL_PAT_EDU_POINT (overall point information), CL_PAT_EDU_HISTORY (audit trail of changes to points), CL_PATEDU_CNTCT_PT (encounter-specific point information), or CL_PAT_EDU_LEARNER (point learner documentation). To associate the point information with a patient, use the patient ID to join with the PAT_ID column in CL_PAT_EDU_NS, and then use the PED_ID column in CL_PAT_EDU_NS to join with the PED_ID column in one of the tables from above. To associate the point information with a patient encounter, use the patient CSN to join with the PAT_CSN column in CL_PAT_EDU_OS, and then use the PED_ID and CONTACT_DATE_REAL columns in CL_PAT_EDU_OS to join with the PED_ID and CONTACT_DATE_REAL columns in CL_PATEDU_CNTCT_PT or CL_PAT_EDU_LEARNER.