RYAN_WHITE_DX

Description:

This table contains diagnosis information from Ryan White abstractions.

Primary Key

Column Name	Ordinal Position
REGISTRY_DATA_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	REGISTRY_DATA_ID	NUMERIC	No
	The unique identifier (.1 item) for the registry data 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	RYN_WHT_DX_ID_DX_NAME	VARCHAR	No
	The name of the diagnosis.
4	RYN_WHT_DX_DATE	DATETIME	No
	Start date of a diagnosis documented on the patient for Ryan White reporting.
5	RYN_WHT_DX_RESOLVED_DATE	DATETIME	No
	End date of a diagnosis documented on the patient for Ryan White reporting.
6	RYN_WHT_DX_ASSESSMENT_C_NAME	VARCHAR	No
	Assessment detail for a diagnosis documented on the patient for Ryan White reporting. May contain organization-specific values: No Category Entries: Definitive Presumptive Unknown
7	RYN_WHT_DX_COMMENT	VARCHAR	No
	Additional comment for a diagnosis documented on the patient for Ryan White reporting.
8	RYN_WHT_DX_PROBLEM	VARCHAR	No
	Medical issue resulting in diagnosis documented on the patient for Ryan White reporting.
9	RYN_WHT_DX_STATUS_C_NAME	VARCHAR	No
	Status category for a diagnosis documented on the patient for Ryan White reporting. May contain organization-specific values: No Category Entries: Active Resolved Deleted