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.