IB_PHRM_ORDER_ID

Description:

The IB_PHRM_ORDER_ID table contains Order IDs attached with an E-Prescribing Sig Map In Basket message.

Primary Key

Column Name	Ordinal Position
MSG_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	MSG_ID	VARCHAR	No
	The unique identifier of the message 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	PHRM_ORDER_ID	NUMERIC	No
	Unique identifier of an incoming order from a pharmacy that includes a free text sig with a mapping request for a discrete sig. Such requests are sent when a prescription request message is sent from an e-prescribing pharmacy interface.