SPEC_AP_RESULT

Description:

This table contains information related to results entered on a specimen's anatomic pathology result.

Primary Key

Column Name	Ordinal Position
SPECIMEN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	SPECIMEN_ID	VARCHAR	No
	The unique identifier (.1 item) for the specimen 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	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.
4	AP_RES_TYPE_C_NAME	VARCHAR	No
	The note type category ID for this AP specimen result note. May contain organization-specific values: No Category Entries: Grossing Intra-Op Final Diagnosis
5	AP_RES_NOTE_ID	VARCHAR	No
	The unique ID of this AP specimen result note.
6	AP_RES_STATUS_C_NAME	VARCHAR	No
	The status category ID for this AP specimen result note. May contain organization-specific values: No Category Entries: Not Started In Progress Complete