STG_TEXT_INFO

Description:

This table contains textual information about a cancer stage (STG) record, such as the staging comments, prognostic indicators, and free text stage.

Primary Key

Column Name	Ordinal Position
STAGE_ID	1
CONTACT_DATE_REAL	2

Column Information

	Name	Type	Discontinued?
1	STAGE_ID	NUMERIC	No
	The cancer stage (STG) row ID.
2	CONTACT_DATE_REAL	FLOAT	No
	A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
4	CM_CT_OWNER_ID	VARCHAR	No
	The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
5	LB_FREE_TEXT_STAGE	VARCHAR	No
	Stores general free text staging information.
6	CLIN_FREE_TEXT_STG	VARCHAR	No
	Stores the clinical free text stage for a cancer diagnosis.
7	PATH_FREE_TEXT_STG	VARCHAR	No
	Stores the pathologic free text stage for a cancer diagnosis.