CATARACT_PLANNING_GOALS

Description:

This table contains information about the goals for cataract surgery.

Primary Key

Column Name	Ordinal Position
SUMMARY_BLOCK_ID	1

Column Information

	Name	Type	Discontinued?
1	SUMMARY_BLOCK_ID	NUMERIC	No
	This column stores the unique identifier for the episode record.
2	OPH_CAT_PREREF_DT	DATETIME	No
	Preoperative date of refraction information
3	OPH_PRE_REF_SPH	VARCHAR	No
	Stores the preoperative refraction for sphere power.
4	OPH_PRE_REF_CYL	VARCHAR	No
	Preoperative refraction cylinder
5	OPH_PRE_REF_AXIS	VARCHAR	No
	Preoperative refraction axis
6	OPH_CAT_PRE_ADD	VARCHAR	No
	Preoperative refraction add power
7	OPH_PREREF_VA	VARCHAR	No
	Preoperative visual acuity
8	OPH_CAT_POST_DT	DATETIME	No
	Postoperative refraction date
9	OPH_CAT_POST_SPHERE	VARCHAR	No
	Postoperative refraction sphere
10	OPH_CAT_POST_CYL	VARCHAR	No
	Postoperative refraction cylinder
11	OPH_CAT_POST_AXIS	VARCHAR	No
	Postoperative refraction axis
12	OPH_CAT_POST_ADD	VARCHAR	No
	Postoperative refraction add
13	OPH_CAT_POST_VA	VARCHAR	No
	Postoperative refraction visual acuity
14	OPH_CAT_GOAL_DIST_C_NAME	VARCHAR	No
	Goals for cataract surgery distance target May contain organization-specific values: No Category Entries: Distance Intermediate Near Multifocal
15	OPH_CAT_TARREF_NUM	VARCHAR	No
	Target refraction for cataract surgery
16	OPH_PUPIL_SIZE	NUMERIC	No
	The dilated pupil size for the patient that is used as reference when planning cataract surgery.