CATARACT_PLANNING_INFO
Description:
This table contains cataract surgery information about the status of the 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_SURG_STATUS_C_NAME VARCHAR No
Stores the status of the surgery
May contain organization-specific values: No
Category Entries:
Planned
Scheduled
Complete
3 OPH_SURG_LINK_ID VARCHAR No
Link to the case for the ophthalmology surgery
4 OPH_SURG_HX_DATE DATETIME No
Stores the date of the surgery if done historically and not linked to a case.
5 OPH_SURG_HX_SURGEON VARCHAR No
Stores the surgeon name for a historical surgery not linked to a case.
6 OPH_SURG_HX_LOC VARCHAR No
Stores the description of the location where a surgery was performed if done historically and not linked to a case.