Primary procedure

Primary procedure is the most important, the most significant procedure in specific operation. In most cases, it's the procedure with highest Basic Score.

Usage of primary procedure in database reports

The full database structure employs a model where one patient is exposed to multiple procedures during multiple operation. An example table in a relational database would look like this:

Patient ID	Procedure name
Patient1	Procedure1
Patient1	Procedure2
Patient2	Procedure3
Patient2	Procedure2
Patient3	Procedure1
Patient4	Procedure1
Patient4	Procedure2
Patient4	Procedure3

However, this model doesn't allow to perform a "mortality vs procedure" report, because mortality is a property of a patient, and one procedure has to be chosen as the "responsible" procedure. To perform a "mortality vs procedure" report, the above table has to be reduced down to this model, with no repeating "Patient ID" value:

Patient ID	Procedure name
Patient1	Procedure1
Patient2	Procedure3
Patient3	Procedure1
Patient4	Procedure1

See also

• Mortality assigned to
• Fundamental diagnosis