VIPOR_PAT_PHENOTYPE

Description:

This table contains the patient phenotypes associated with a Variant Interpretation Pipeline Orchestrator (VIPOr) execution. Each row represents a phenotypic term that was presented to the user when submitting a pipeline run. The table includes the standard phenotypic term, whether the phenotype was included in the run, and a link to the patient's phenotype record when the phenotype originated from the patient's chart.

Primary Key

Column Name	Ordinal Position
VIPOR_EXEC_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	VIPOR_EXEC_ID	NUMERIC	No
	The unique identifier (.1 item) for the Variant Interpretation Pipeline Orchestrator (VIPOr) record.
2	CONTACT_DATE_REAL	FLOAT	No
	A unique contact date in decimal format. The integer portion of the number indicates the date of 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	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4	CONCEPT_IDENT	VARCHAR	No
	The unique ID (CUI) of the concept record (HLX), such as HPO#HP:0000001.
5	INCLUDED_IN_RUN_YN	VARCHAR	No
	Indicates whether this phenotype was included in the Variant Interpretation Pipeline Orchestrator (VIPOr) run. 'Y' indicates the phenotype was sent to VIPOr as a pipeline argument. 'N' or NULL indicate the phenotype was excluded from the run. May contain organization-specific values: No Category Entries: No Yes