OVC_DB_MAIN

Description:

This table contains information about specimen containers. This includes information about what specimen it belongs to and its current location. This table was originally used to store submitter information. When looking at the SQL for this table you will see some columns still have "submitter" in their name even though this table now holds container information.

Primary Key

Column Name	Ordinal Position
CONTAINER_ID	1

Column Information

	Name	Type	Discontinued?
1	CONTAINER_ID	VARCHAR	No
	The unique ID of the container record.
2	PAT_LINK_ID	VARCHAR	No
	The unique ID of the patient (EPT) who is associated with the container record.
3	CTNR_STATUS_C_NAME	VARCHAR	No
	The status category ID for the container. May contain organization-specific values: No Category Entries: Test Mode Only Active Inactive Inactive (old) Deleted
4	LINKED_RQG_RECORD_ID	NUMERIC	No
	The unique ID of the requisition grouper that is associated with the container record.
5	NETWORK_EXT_IDENT	VARCHAR	No
	The ID for a container received over the Orders and Results Anywhere network, if a non-unique container ID was sent.
6	NET_EXT_IDEN_ORG_ID	NUMERIC	No
	The unique ID of the organization who sent a container received over the Orders and Results Anywhere network, if a non-unique container ID was sent.
7	NET_EXT_IDEN_ORG_ID_EXTERNAL_NAME	VARCHAR	No
	Organization's external name used as the display name on forms and user interfaces.