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.