CATARACT_PLANNING_LENSES

Description:

This table contains information about the lens selected to have ready for cataract surgery.

Primary Key

Column Name	Ordinal Position
SUMMARY_BLOCK_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	SUMMARY_BLOCK_ID	NUMERIC	No
	This column stores the unique identifier for the episode 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	OPH_CAT_LENS_TYPE_C_NAME	VARCHAR	No
	Stores the type of lens planned for use in cataract surgery May contain organization-specific values: Yes Category Entries: Other Standard Toric Multifocal Multifocal Toric Anterior Chamber Sulcus
4	OPH_CAT_LENS_MODEL	VARCHAR	No
	Stores the selected model of intraocular lens.
5	OPH_CAT_LENS_POWER	VARCHAR	No
	Stores the selected lens power for the intraocular lens
6	OPH_CAT_LENS_AXIS	VARCHAR	No
	Stores the axis for a intraocular lens
7	OPH_CAT_LENS_SUP_ID	VARCHAR	No
	Stores the selected supply record for the intraocular lens
8	OPH_CAT_LENS_SUP_ID_SUPPLY_NAME	VARCHAR	No
	The name of the inventory item.
9	OPH_CAT_LENS_CMTS	VARCHAR	No
	Stores comments related to the intraocular lens selection
10	OPH_CAT_SPECORD_YN	VARCHAR	No
	Note on whether the lens is a special order lens May contain organization-specific values: No Category Entries: No Yes
11	OPH_LENSSEL_TARGET	NUMERIC	No
	Target refraction number for the selected lens