OR_CASE_REVISION_REASON

Description:

This table contains information about case procedure revision reasons.

Primary Key

Column Name	Ordinal Position
CASE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CASE_ID	VARCHAR	No
	The unique identifier (.1 item) for the case request 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	REASON_REVISION_C_NAME	VARCHAR	No
	The case procedure revision reason. May contain organization-specific values: Yes Category Entries: Aseptic loosening Bearing wear Osteolysis Instability Infection - single-stage revision Infection - stage 1 of 2 Infection - stage 2 of 2 Pain of unknown origin Patella maltracking or instability Peri-prosthetic fracture (femur or tibia) Implant fracture Implant dissociation Arthritis in previously unresurfaced compartment Peri-prosthetic fracture (femur) Peri-prosthetic fracture, acetabulum Acetabular erosion Leg length discrepancy Stiffness Other