Home

CJRR Minimum Data Set Manual, 2015–2016

1. Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Canadian Institute for Health Information Institut canadien d information sur la sant Standards and Data Submission gt lt lt u Yan gt OT ne FO ER a BE nn Our Vision Better data Better decisions Healthier Canadians Our Mandate To lead the development and maintenance of comprehensive and integrated health information that enables sound policy and effective health system management that improve health and health care Our Values Respect Integrity Collaboration Excellence Innovation Table of Contents Changes for 2015 2016 CJRR Minimum Data Set Manual 4444ssssennnnn nn nnnnnnnnennnnnnn nn 7 Introduction re Eile 9 About the Canadian Joint Replacement Registry 4444444nnnnn nn nnnnnnnnnnnnnnnnnnnenennnnn nennen 9 Privacy and Conftidentaliyern hr einen 9 Chapter 1 Canadian Joint Replacement Registry Data Submissions 11 Chapter 2 Record Information Electronic File Submission Only 13 Field 01 Record ID Electronic File Submission Only 13 Field 02 Record Type Electronic File Submission Only 14 Field 03 Fiscal Year of Surgery Electronic File Submission Only 14 Field 04 Hospital Province Electronic File Submission Only
2. 444ssssens sn nennen 15 Field 05 Submission Type Electronic File Submission Only 16 Chapter Ss SurgeenDamegraphiesi u ran ek 17 Field 06 Surgeon ID Electronic File Submission Only 17 Field 07 Surgeon Last Name ern 17 Chapter 4 Patient Demographics ses 19 Field 08 FausntEist Name 4 ass eder 19 Field 09 Patient Last Name kne 19 Field 10 Health Card Issuing Authority Code 20 Field 11 Health Card Number as ae ee vn tn rentes te nent n 22 Feld 12 Patient Birth dater ne Re Re At cn tte AT Tr tn 24 Kieldo Gender 25 s rende anne aa ee 25 Field 14 Patient Postal Code nee 25 Field 15 Hospital Institution Number Electronic File Submission Only 27 Field 15 Hospital Name Web Submission Only 28 Field 16 Chart Number aureus su 28 Field 17 Surgery Date rekene eee EKEN AEEA RESE oS 29 Chapter 5 General Procedure Information vausssa sus a 31 Field 16 Side Location aaa eee ane a este 31 Field 19 Type of Replacement esse 32 Field 20 Type of Primary Procedure sine 33 Field 21 Diagnosis Grouping Primary Procedures Only 34 Field 22 Reason for Revision Revision Procedures Only 35 W Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Chapter 6 Knee Replacement Prosthesis Information 37 General Information anse rise nl y ia 37 Fields 23 27 31 Femoral Component Manufacturer nennen 38 Fields 24 28 32 Femoral Component Manufacturer Other 39
3. Data Element Name Error Number Error Condition Error Message Error Type System Action Side Location 18 1 Field is blank Missing value Severe Record rejected H and K 18 2 Invalid value Invalid value Type of Replacement 19 1 Field is blank Missing value Severe Record rejected Hand K 19 2 Invalid value Invalid value Type of Primary 20 1 If Type of Replacement is 1 primary Missing value Severe Record rejected Procedure H and K and this field is blank 20 2 If Type of Replacement is 2 revision Type of primary procedure is not and this field is populated applicable for revisions 20 3 Record Type is K and Type of Primary Invalid value Procedure not in 1 2 3 4 5 OTH 20 4 Record Type is H and Type of Primary Invalid value Procedure not in 6 7 8 9 OTH 20 5 If Type of Primary Procedure is 1 2 3 Femoral component sticker information 4 or 5 and femoral component sticker is missing information is missing 20 6 If Type of Primary Procedure is 1 2 3 Tibial component sticker information or 4 and tibial component sticker is missing information is missing 20 7 If Type of Primary Procedure is 1 or5 Patellar component sticker information and patellar component sticker is missing information is missing 20 8 If Type of Primary Procedure is 2 3 or Patellar component sticker information 4 and any patellar component stickers must be blank for this type of are present primary procedure 20 9 If Type of Primary Procedure is 5 Tibial
4. cedilla Joint Type Hip Definition The Acetabular Component Product Number field indicates the product reference catalogue or other number of the acetabular component used for the procedure Fields 50 54 58 Acetabular Component Lot Number Specifications Field Length 60 alphanumeric characters Field Status Applicable only if acetabular component was used Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla Joint Type Hip Definition The Acetabular Component Lot Number field indicates the lot number of the acetabular component used for the procedure Chapter 7 Hip Replacement Prosthesis Information Hil Fields 59 63 67 Acetabular Insert Liner Manufacturer Specifications Field Length 3 alphanumeric characters Field Status Applicable only if acetabular insert liner was used Valid Data 1 11 OTH Joint Type Hip Definition The Acetabular Insert Liner Manufacturer field indicates the manufacturer of the acetabular insert liner used for the procedure The Acetabular Insert Liner Manufacturer codes are the following Code Description 1 Biomet Ceraver DePuy Finsbury J amp J Zimmer Sulzer Centerpulse MicroPort Wright Medical Smith amp Nephew Stryker Osteonics Howmedica
5. Joint Type Knee and hip Definition The Femoral Component Lot Number field indicates the lot number of the femoral component used for the procedure This includes modular body stem neck combinations and monoblock implants for hemiarthroplasties Chapter 7 Hip Replacement Prosthesis Information Hil Fields 35 39 43 Femoral Head Manufacturer Specifications Field Length 3 alphanumeric characters Field Status Applicable only if femoral head was used Valid Data 1 11 OTH Joint Type Hip Definition The Femoral Head Manufacturer field indicates the manufacturer of the femoral head used for the procedure This includes bipolar heads bipolar liners and bipolar cups shells for hemiarthroplasties The Femoral Head Manufacturer codes are the following Code 1 Biomet Ceraver DePuy Finsbury J amp J Zimmer Sulzer Centerpulse MicroPort Wright Medical Smith amp Nephew Stryker Osteonics Howmedica Medacta International OI NII RO IN Link Corin O 2 I Tecres Medical Other EEE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Fields 36 40 44 Femoral Head Manufacturer Other Specifications Field Length 45 alphanumeric characters Field Status Applicable only if Femoral Head Manufacturer OTH Valid Data 0 9 A Z space hyphen period apostrophe ampersand amp
6. Medacta International Link Corin oe COIN OD oO AJOJN Tecres Medical Other O I EE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Fields 60 64 68 Acetabular Insert Liner Manufacturer Other Specifications Field Length 45 alphanumeric characters Field Status Applicable only if Acetabular Insert Liner Manufacturer OTH 0 9 A Z space hyphen period apostrophe Valid Data ampersand amp Joint Type Hip Definition The Acetabular Insert Liner Manufacturer Other field indicates the manufacturer of the acetabular insert liner if other is indicated in the Acetabular Insert Liner Manufacturer field Example The patient s hip replacement used an acetabular insert liner made by the manufacturer Smith amp Nephew Acetabular Insert Liner Manufacturer LI Te Acetabular Insert Liner Manufacturer Other LEITA Example The patient s hip replacement used an acetabular insert liner made by the manufacturer ABC Manufacturer Acetabular Insert Liner Manufacturer o t H Acetabular Insert Liner Manufacturer Other lalele mjalnfuf rfaje t ufrjefr Chapter 7 Hip Replacement Prosthesis Information Hil Fields 61 65 69 Acetabular Insert Liner Product Number Field Length 60 alphanumeric characters Field Status Applicable only if acetabular insert liner
7. 22 Reason for Revision Revision Procedures Only cont d on next page Indices Hi WE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Field Field Name Knee Replacement Prosthesis Information 23 27 31 Femoral Component Manufacturer 24 28 32 Femoral Component Manufacturer Other 25 29 33 Femoral Component Product Number 26 30 34 Femoral Component Lot Number 35 39 43 Tibial Component Manufacturer 36 40 44 Tibial Component Manufacturer Other 37 41 45 Tibial Component Product Number 38 42 46 Tibial Component Lot Number 47 51 55 Tibial Inser Manufacturer 48 52 56 Tibial Insert Manufacturer Other 49 53 57 Tibial Insert Product Number 50 54 58 Tibial Insert Lot Number 59 63 67 Patellar Component Manufacturer 60 64 68 Patellar Component Manufacturer Other 61 65 69 Patellar Component Product Number 62 66 70 Patellar Component Lot Number 71 75 Cement Details Name 72 76 Cement Details Name Other 73 77 Cement Details Product Number 74 78 Cement Details Lot Number Hip Replacement Prosthesis Information 23 27 31 Femoral Component Manufacturer 24 28 32 Femoral Component Manufacturer Other 25 29 33 Femoral Component Product Number 26 30 34 Femoral Component Lot Number 35 39 43 Femoral Head Manuf
8. Prefabricated femoral component cement spacer temporary joint prosthesis or mould Composant f moral Composant trochl en Proth se f moro patellaire Tige f morale tige femorale modulaire Composant f moral pr fabriqu moule ou dispositif d espacement en ciment Composant f moral pr fabriqu moule ou spacer en ciment Tibial component Composant tibial EN Monoblock all polyethylene tibial component Tibial component tibial baseplate tibial tray Stemmed tibial component Tibial stem modular tibial stem Modular tibial system Prefabricated tibial component cement spacer temporary joint prosthesis or mould Tibia tout poly thyl ne Embase tibiale implant tibial Plateau tibial monobloc Tige tibiale tige tibiale modulaire Composant tibial pr fabriqu moule ou dispositif d espacement en ciment Composant tibial pr fabriqu moule ou spacer en ciment Tibial insert Insert tibial EN Tibial insert tibial plateau Poly insert Articular surface Meniscal bearing FR Plateau tibial Surface articulaire Patellar component Composant rotulien EN Patellar component All poly patella FR Bouton rotulien Bouton rotulien monobloc cont d on next page EXCLUSIONS Rings Cages Screws Augments blocks wedges cones Plugs Cables Plates Centralizers Stem extenders Cement restrictors Tapers taper sleeves sleeves adapters adapt
9. Product Number N Lot Number Manufacturer select Place computer cursor in the appropriate Product Number field where you want the information to be entered Acetabular Component Involved Product Number A0 H4357133195411 Lot Number i Manufacturer select The resulting output should look like this Each scanned barcode should lead with a square bracket If this is missing it may be an indication that the AIM Code was not enabled See Step 1 Note It is acceptable for the output to look completely different than the value under the barcode Do not modify the scanned output for example do not delete characters or symbols Note Align barcode scanner to product label Be careful when scanning the barcode Scan the bottom barcode into the Lot Number field Note Lot Number 11DM09672 Value under the barcode 04211DM096721X Scan the top number into the Product Number field Note Ref Number 71331954 Value under the barcode H4357133195411 Acetabular Component Involved Product Number JA0 H4357133195411 Lot Number JA0 042111DM09672IX Manufacturer select The resulting output should look like this Each scanned barcode should lead with a square bracket If this is missing it may be an indication that the AIM Code was not enabled See Step 1 Note It is acceptable for the output to look completely different
10. s last name is O Leary Surgeon Last Name LOl ILIETATRIY Chapter 4 Patient Demographics I Chapter 4 Patient Demographics Field 08 Patient First Name Specifications Field Length 2 25 alphabetic and special characters Field Status Mandatory Valid Data A Z space hyphen period apostrophe Joint Type Knee and hip Definition Patient First Name is the first name or given name of the patient Example The patient s first name is Jean Michel Patient First Name Jjejafn m ife Hjefe Field 09 Patient Last Name Specifications Field Length 2 25 alphabetic and special characters Field Status Mandatory Valid Data A Z space hyphen period apostrophe Joint Type Knee and hip Definition Patient Last Name is the surname or family name of the patient Example The patient s last name is van der Vaart Patient Last Name EEE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Field 10 Health Card Issuing Authority Code Specifications Field Length 3 alphanumeric characters Field Status Mandatory Valid Data NL PE NS NB QC ON MB SK AB BC YT NT NU CA N A Joint Type Knee and hip Definition Health Card Issuing Authority Code is the code indicating the provincial territorial authority that issued the health card The provincial territorial authority codes are the following Co
11. 2015 2016 Field 12 Patient Birthdate Field Length 8 numeric digits Field Status Mandatory Valid Data 0 9 in date format YYYYMMDD Joint Type Knee and hip Definition Patient Birthdate is the calendar date the patient was born The year must be four digits the month and day must each be two digits Note Age at time of surgery must be in the range 13 to 130 years Example The birthdate for a patient born on March 26 1933 is recorded as 19330326 Patient Birthdate 3 s o1s121e Y Y Y M M D Y D amp Example For web The birthdate for a patient born on March 26 1933 is recorded as 1933 MAR 26 Birthdate 5 51 Imlalr 2 6 Y Y Y Y M M M D D Chapter 4 Patient Demographics Hi Field 13 Gender Field Length 2 alphanumeric characters Field Status Mandatory Valid Data 1 2 ZZ Joint Type Knee and hip Definition The Gender code describes the sex of the patient The Gender codes are the following 1 Male 2 Female ZZ Other Field 14 Patient Postal Code Field Length 6 alphanumeric digits Field Status Mandatory Valid Code Format Z9Z9Z9 Z9Z9Z Z9Z9 Z9Z Valid Data A Z 0 9 Joint Type Knee and hip EE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Definition The Patient Postal Code is the alphanumeric code assigned by Canada Post to identify the patient s place of residence The province territory specific pos
12. Error Condition Error Message Error Type System Action Tibial Component 38 1 Length of field exceeded Out of range Severe Record rejected Lot K 38 2 Field contains invalid value Invalid value 38 3 For each sticker present if lot number Missing value is missing Tibial insert sticker information G If stickers are not completed in Tibial insert stickers must be completed Severe Record rejected sequential order in sequential order Tibial Insert 47 1 Manufacturer codes for tibial Manufacturer for tibial insert and tibial Non severe None Manufacturer K component and tibial insert are not the component does not match same first stickers only 47 2 Manufacturer code is not found inthe Value not found in database Severe Record rejected manufacturer table 47 3 For each sticker present if Missing value manufacturer is missing Tibial Insert 48 1 Field contains invalid value Invalid value Severe Record rejected Manufacturer Other K 48 2 Length of field exceeded Out of range 48 3 If option OTH is selected and details Manufacturer is Other and details are missing are missing 48 4 Manufacturer not OTH but Manufacturer Other must be blank if manufacturer Other populated Other is not selected Tibial Insert 49 1 Length of field exceeded Out of range Severe Record rejected Product 4K 49 2 Field contains invalid value Invalid value 49 3 For each sticker present if product
13. Fields 25 29 33 Femoral Component Product Number 40 Fields 26 30 34 Femoral Component Lot Number cccccccccecceceesseseeeeeeeeaeaeeseeeeeees 40 Fields 35 39 43 Tibial Component Manufacturer 41 Fields 36 40 44 Tibial Component Manufacturer Other 42 Fields 37 41 45 Tibial Component Product Number 43 Fields 38 42 46 Tibial Component Lot Number 43 Fields 47 51 55 Tibial Insert Manufacturer iii 44 Fields 48 52 56 Tibial Insert Manufacturer Other 45 Fields 49 53 57 Tibial Insert Product Number rrrrrnrnnnnernnnrnnnrennrnnnnrnnnnnnnrnranenenernnnnenennnn 46 Fields 50 54 58 Tibial Insert Lot Number iii 46 Fields 59 63 67 Patellar Component Manufacturer ccccccccccccecseseeeeeceeeeeesaeaeeeeseeees 47 Fields 60 64 68 Patellar Component Manufacturer Other 48 Fields 61 65 69 Patellar Component Product Number 49 Fields 62 66 70 Patellar Component Lot Number rrrrrnrnrarnnnnnnnnnonvnrnnnnnnnnnnnennenrnrnnnnnnenr 49 Fields 71 75 Cement Details Name rmmnarnnnnnnnnnnnnnnnnnnnnnnnvnnnnnnnnnnvnnnevnnnevnnnennnnnnnnnnennnnennnner 50 Fields 72 76 Cement Details Name Other 51 Fields 73 77 Cement Details Product Number iii 52 Fields 74 78 Cement Details Lot Number iii 52 Chapter 7 Hip Replacement Prosthesis Information ss 53 General Information rennen erregen 53 Fields 23 27 31 F
14. Joint Type Hip Definition The Femoral Head Manufacturer Other field indicates the manufacturer of the femoral head if other is indicated in the Femoral Head Manufacturer field This includes bipolar heads bipolar liners and bipolar cups shells for hemiarthroplasties Example The patient s hip replacement used a femoral head made by the manufacturer DePuy Finsbury Femoral Head Manufacturer BRE Femoral Head Manufacturer Other PITT TT TITT TT TT Example The patient s hip replacement used a femoral head made by the manufacturer ABC Manufacturer Femoral Head Manufacturer o t H Femoral Head Manufacturer Other lalele mfalnfuf rfaje t ufrjefr Chapter 7 Hip Replacement Prosthesis Information Hil Fields 37 41 45 Femoral Head Product Number Specifications Field Length 60 alphanumeric characters Field Status Applicable only if femoral head was used Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla Joint Type Hip Definition The Femoral Head Product Number field indicates the product reference catalogue or other number of the femoral head used for the procedure This includes bipolar heads bipolar liners and bipolar cups shells for hemiarthroplasties Fields 38 42 46 Femoral Head Lot N
15. new records or U update updated records Resubmitted records are to be classified as updates and should use the original Record ID number Insert records submitted in one fiscal period will be rejected if they are resubmitted as inserts in the next fiscal period Ifthe Submission Type is U only clinical data can be updated not patient and surgeon data Chapter 3 Surgeon Demographics I Chapter 3 Surgeon Demographics Field 06 Surgeon ID Electronic File Submission Only Specifications Field Length 11 numeric digits Field Status Mandatory Valid Data 0 9 Joint Type Knee and hip Definition The Surgeon ID is a CIHI assigned identification number for the orthopedic surgeon who performed the hip knee replacement procedure A Surgeon ID needs to be assigned prior to sending data to CJRR Note The Surgeon ID will be provided to data providers in advance Field 07 Surgeon Last Name Specifications Field Length 25 alphabetic and special characters Field Status Mandatory Valid Data A Z space hyphen period apostrophe Joint Type Knee and hip Definition Surgeon Last Name is the surname or family name of the orthopedic surgeon who performed the hip knee replacement procedure Note The surgeon must be pre registered with CJRR The last name submitted must exactly match the last name in the CJRR database as supplied upon pre registration Example The surgeon
16. 13 3 If submission type is U and patient Record type is U but patient values do information does not match database not match database Patient Postal Code 14 1 Field lt 3 characters Out of range Severe Record rejected H and K 14 2 Field is blank Missing value 14 3 Format for postal code is incorrect Invalid value 14 4 Field has 3 4 or 5 characters Postal code is incomplete Non severe None 14 5 Postal code is Z9Z9Z9 Postal code does not match province Non severe None Hospital Institution 15 1 Field is blank Missing value Severe Record rejected Number H and K 15 2 Hospital Institution Number is not found Value not found in database in the database 15 3 If starting digit for facility does not The facility number does not belong to belong to the province QC excluded the selected province from validation Chart Number 16 1 Field is blank Missing value Severe Record rejected And 16 2 Length is less than 4 or greater than 12 Out of range 16 3 Invalid value Invalid value 16 4 Value matches Health Card Number Health Card Number is not permitted in Severe None field 11 Chart Number field Surgery Date H and K 17 1 Field is blank Missing value Severe Record rejected 17 2 Surgery date is not within the Surgery date must be within the Fiscal corresponding fiscal year of surgery Year of Surgery 17 3 Invalid date Invalid value cont d on next page HE 9p090q 1043 YYPO 3 X puaddy c6
17. Chapter 7 Hip Replacement Prosthesis Information General Information Hip replacement prosthesis information is gathered from the manufacturer s sticker for each component replaced If a sticker is present all of the following elements must be entered manufacturer product number and lot number A maximum of three stickers for each component and two stickers for cement may be entered Please refer to Appendix A for the corresponding component prosthesis information required for each type of primary procedure and to Appendix B for a reference guide on categorizing implant components As of April 2013 the CURR electronic file submission and Web Based Data Submission and Reports Tool systems were modified to accept product and lot numbers for implant components and cement that have been scanned directly from barcodes The CURR system is still able to accept manually entered implant information when scanning barcodes is not an option Refer to Appendix C for detailed instructions for both methods of data entry Note that CURR does not require sticker information for sundry pieces involved in hip replacements including augments centralizers rings tapers and cages Please contact CJRR if further details are required EEE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Fields 23 27 31 Femoral Component Manufacturer Specifications Field Length 3 alphanumeric characters Field Status Applic
18. March 31 2013 then the Fiscal Year of Surgery is 2012 Example The surgery was performed on May 18 2012 Fiscal Year of Surgery 2jol l2 Chapter 2 Record Information Electronic File Submission Only Hil Field 04 Hospital Province Electronic File Submission Only Specifications Field Length 2 alphanumeric characters Field Status Mandatory Valid Data NL PE NS NB QC ON MB SK AB BC YT NT NU Joint Type Knee and hip Definition The Hospital Province code identifies the province or territory of the institution where the joint replacement was performed The provincial territorial codes are the following Code Province Territory NL Newfoundland and Labrador PE Prince Edward Island NS Nova Scotia NB New Brunswick QC Quebec ON Ontario MB Manitoba SK Saskatchewan AB Alberta BC British Columbia YT Yukon NT Northwest Territories NU Nunavut W Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Field 05 Submission Type Electronic File Submission Only Specifications Field Length 1 alphanumeric character Field Status Mandatory Valid Data l U Joint Type Knee and hip Definition The Submission Type defines the specific operation to be performed with the record The Submission Type codes are the following Code Description I Insert U Update Note Records are classified as I insert
19. Only Fields in this chapter apply to electronic file submissions only Field 01 Record ID Electronic File Submission Only Specifications Field Length 11 numeric digits Field Status Mandatory Valid Data 0 9 Joint Type Knee and hip Definition The Record ID is an 11 digit code that uniquely identifies the record in the database The number must remain unchanged and should be referenced if the record needs to be updated Note A unique ID for each record should be supplied by the data provider Data suppliers will have to keep track of this number WE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Field 02 Record Type Electronic File Submission Only Specifications Field Length 1 alphanumeric character Field Status Mandatory Valid Data H K Joint Type Knee and hip Definition The Record Type defines whether the record refers to a hip or a knee replacement procedure The Record Type codes are the following Code Description H Hip K Knee Field 03 Fiscal Year of Surgery Electronic File Submission Only Specifications Field Length 4 numeric digits Field Status Mandatory Valid Data 0 9 Joint Type Knee and hip Definition The Fiscal Year of Surgery identifies the fiscal year to which the record should be allocated Note The value is based on the surgery date For example if the surgery date is between April 1 2012 and
20. Severe Record rejected Authority H and K 10 2 Field is blank Missing value 10 3 If submission type is U and patient Record type is U but patient values do information does not match database not match database Health Card Number 11 1 Field is blank and Health Card Missing value Severe Record rejected Hand K authority code N A 11 2 Field contains more than 12 characters Out of range 11 3 Value not valid according to Province Invalid combination Issuing Health Card rules 11 4 Health Card Authority code N A and Invalid combination field is populated 11 5 Submission type is U and patient Record type is U but patient values do information does not match database not match database cont d on next page 9LOZ GLOZ Ienue as ejeq UWNUIUIN Aus bay Jusweselday juIof UEIPEUE m o Data Element Name Error Number Error Condition Error Message Error Type System Action Patient Birth Date 12 1 Field is blank Missing value Severe Record rejected H and K 12 2 Date format is invalid month and day Invalid date combination is not valid 12 3 Patient is too old young Invalid value out of range 12 4 If submission type is U and patient Record type is U but patient values do information does not match database not match database Gender H and K 13 1 Field is blank Missing value Severe Record rejected 13 2 Invalid character Invalid value
21. and hip Definition The Cement Details Product Number field indicates the product reference catalogue or other number of the cement used for the procedure Fields 74 78 Cement Details Lot Number Specifications Field Length 60 alphanumeric characters Field Status Applicable only if cement was used if cement sticker is available Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla Joint Type Knee and hip Definition The Cement Details Lot Number field indicates the lot number of the cement used for the procedure Indices Numeric Index by Field Field Field Name Record Information 01 Record ID 02 Record Type 03 Fiscal Year of Surgery 04 Hospital Province 05 Submission Type Surgeon Demographics 06 Surgeon ID 07 Surgeon Last Name Patient Demographics 08 Patient First Name 09 Patient Last Name 10 Health Card Issuing Authority Code 11 Health Card Number 12 Patient Birthdate 13 Gender 14 Patient Postal Code 15 Hospital Institution Number Hospital Name 16 Chart Number 17 Surgery Date General Procedure Information 18 Side Location 19 Type of Replacement 20 Type of Primary Procedure 21 Diagnosis Grouping Primary Procedures Only
22. extraction of a clean product and lot number Note If the AIM Code is not enabled the CURR system will not extract the product and lot numbers from the scanned value Step 2 Verifying That the AIM Code Transmission Is Enabled Correct onscreen result C0123456789 Note French keyboard users Scan the barcode below may see 0123456789 If the AIM Code was not enabled the result would look like this 123456789 HM Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Step 3 Scanning Barcodes e With the AIM Code enabled each scanned barcode should lead with a square bracket If this is missing it may be an indication that the AIM Code was not enabled See Step 1 French keyboard users In place of the leading scanned output will lead with a cedilla either or C e The Three General Categories of Product Label Appearance A Implant Stickers With Two Barcodes 1 Is this a product sticker from the manufacturer Link e For Link products do not scan the barcode The product and lot numbers need to be manually entered exactly as they appear on the sticker e If not proceed 2 Does the sticker identify the product or lot number under each barcode e Ifso scan the applicable barcodes into the Product Number and Lot Number fields ABC MANUFACTURER by 2025 12 ABC Hip Replacement System Femoral Head er Sc
23. s o a Example The patient s surgery was performed in an Alberta facility whose code is 89546 Hospital Institution Number 81s15lale MM Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 amp Field 15 Hospital Name Web Submission Only Specifications Field Length No fixed length Field Status Mandatory Valid Data A Z 0 9 Joint Type Knee and hip Definition The Hospital Name is the name of the facility where the joint replacement was performed Field 16 Chart Number Specifications Field Length 12 alphanumeric characters Field Status Mandatory Valid Data A Z 0 9 Joint Type Knee and hip Definition The Chart Number is the unique number assigned by the admitting institution to identify the patient Note Chart Number cannot be fewer than four characters Health Card Number is not permitted in Chart Number field For instances where Chart Number is not available or Health Card Number is included in the Chart Number enter UNKNOWN Chapter 4 Patient Demographics I Field 17 Surgery Date Field Length 8 numeric digits Field Status Mandatory Valid Data 0 9 in date format YYYYMMDD Joint Type Knee and hip Definition The date of the hip or knee replacement surgery Note For electronic file submissions this date should be within the corresponding fiscal year see Field 03 Fiscal Year of Surgery Example A knee repl
24. was used Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla Joint Type Hip Definition The Acetabular Insert Liner Product Number field indicates the product reference catalogue or other number of the acetabular insert liner used for the procedure Fields 62 66 70 Acetabular Insert Liner Lot Number Field Length 60 alphanumeric characters Field Status Applicable only if acetabular insert liner was used Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla Joint Type Hip Definition The Acetabular Insert Liner Lot Number field indicates the lot number of the acetabular insert liner used for the procedure WE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Fields 71 75 Cement Details Name Specifications Field Length 3 alphanumeric characters Field Status Applicable only if cement was used if cement sticker is available Valid Data 1 8 OTH Joint Type Knee and hip Definition The Cement Details Name field indicates the name of the cement used The Cement Details Name codes are the following Code Description 1 Simplex
25. 2 Length of field exceeded Out of range 50 3 For each sticker present if lot number Missing value is missing Acetabular insert liner sticker information E If stickers are not completed in Acetabular insert liner stickers must be Severe Record rejected sequential order completed in sequential order Acetabular 59 1 Manufacturer codes for acetabular Manufacturer for acetabular component Non severe None Insert Liner component and insert liner are not the and insert liner does not match Manufacturer H same first stickers only 59 2 Manufacturer code does not exist in Value not found in database Severe Record rejected the manufacturer table 59 3 For each sticker present if Missing value manufacturer is missing cont d on next page 9L0Z SLOZ enue jes geq WNWIUIN Ays ey jusWeoe dey juior ueipeueo gg I Data Element Name Error Number Error Condition Error Message Error Type System Action Acetabular 60 1 Field contains invalid value Invalid value Severe Record rejected In einer 60 2 Length of field exceeded Out of range Manufacturer Other H 60 3 If option OTH is selected and details Manufacturer is Other and details are are missing missing 60 4 Manufacturer not OTH but Manufacturer Other must be blank if manufacturer Other populated Other is not selected Acetabular 61 1 Length of field exceeded Out of range Severe Recor
26. 4 17 OTH Joint Type Knee and hip Definition The Reason for Revision field indicates the patients most responsible reason for revision determined post operatively for the involved joint The Reason for Revision codes for knee and hip procedures are the following Code Description Joint Type 1 Aseptic loosening Knee and hip 2 Bearing wear e g poly wear Knee and hip 3 Osteolysis Knee and hip 4 Instability e g dislocation excludes patella for knee Knee and hip 5 Infection single stage revision Knee and hip 6 Infection stage 1 of two stage revision Knee and hip 7 Infection stage 2 of two stage revision Knee and hip 8 Pain of unknown origin Knee and hip 9 Patella maltracking or instability Knee 10 Peri prosthetic fracture femur or tibia Knee 11 Implant fracture any component Knee and hip 12 Implant dissociation e g stem from tibial tray Knee and hip head from trunnion 13 Arthritis in previously unresurfaced compartment e g Knee patellofemoral medial or lateral compartment 14 Peri prosthetic fracture femur Hip 15 Peri prosthetic fracture acetabulum Hip 16 Acetabular erosion e g hemiarthroplasty Hip 17 Leg length discrepancy Hip OTH Other Knee and hip Example The patient had a revision procedure due to arthritis in the previously unresurfaced patellofemoral compartment Type of Reason for Replacement Revision HEEN Chapter 6 Knee Replacement Pro
27. 9AB gt Manually enter the lot number in the Lot Number field Appendix C Entering Prosthesis and Cement Information Hi Sticker Examples for Manual Entry This section presents a sample of fictitious product labels based on actual manufacturer stickers This is not an exhaustive list it is intended for demonstration purposes only 1234 56AB LL Product number REF 1234 56AB LOT 123456789 y Lot number 123456789 ABC KNEE REPLACEMENT SYSTEM UNICOMPARTMENTAL TIBIAL INSERT SIZE E LEFT ABC MANUFACTURER Product number Lot number 123456789 123456 REF LOT z 123456789 123456 2025 12 XYZ COMPANY 40 ABC Bone Cement g XYZ Ci ser AEE City Country 123456789123456789 ABC ANTIBIOTIC CEMENT Distributed by XYZ Company Tobramycin Full Dose Product number REF 1234 5 6789 1234 5 6789 LOT AB123456 Lot number AB123456 by 2025 12 EEE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Product number 123456 123456 ABC Cement Lot number LOT 123456 gt 123456 u 2025 12 Demonstration Appendix C Entering Prosthesis and Cement Information This is an example of a product sticker with two unlabelled barcodes that are not from the manufacturer Link Acetabular Component Involved
28. Contact CURR by email cjrr cihi ca for specific instructions Do not send PHI via email or fax Oo Appendix E CJRR Error Decoder Data Element Name Error Number Error Condition Error Message Error Type System Action Record ID H and K 1 1 Field is blank Missing value Severe Record rejected 1 2 Field is not numeric Invalid value 1 3 Field length is not between 1 and Out of range 11 digits 1 4 If submission type is U and Record ID Corresponding record does not exist does not exist in the database in the database for the submitted update record 1 5 If submission type is I and Record ID Record ID already exists in database already exists in the database 1 6 More than one record with the same More than one record with the same Record ID is in the same file Record ID found in the submission file Record Type H and K 2 1 Field is blank Missing value Severe Record rejected 2 2 Value in field is not one of the Invalid value two options 2 3 Value in field doesn t match the value Record type mismatch with value in in control record control record Fiscal Year of surgery 3 1 Field is blank Missing value Severe Record rejected H and K 3 2 Fiscal year is not the same as the year Fiscal year mismatch with year in in control record control record Hospital Province 4 1 Field is blank Missing value Severe Record rejected Hand K 4 2 Invalid value Invalid value Submis
29. Hip knee 06 Surgeon Last Name Hip knee 07 Surgery Date Hip knee 17 Tibial Component Product Number Knee 37 41 45 Tibial Component Lot Number Knee 38 42 46 Tibial Component Manufacturer Knee 35 39 43 Tibial Component Manufacturer Other Knee 36 40 44 Tibial Insert Product Number Knee 49 53 57 Tibial Insert Lot Number Knee 50 54 58 Tibial Insert Manufacturer Knee 47 51 55 Tibial Insert Manufacturer Other Knee 48 52 56 Type of Primary Procedure Hip knee 20 Type of Replacement Hip knee 19 Appendix A Prosthesis Information Required by Type of Primary Procedure Hi Appendix A Prosthesis Information Required by Type of Primary Procedure Knee Type of Primary Procedure Additional Components Mandatory Components if Applicable Total knee arthroplasty TKA Femoral tibial and patellar Tibial insert including patella component Total knee arthroplasty TKA Femoral and tibial Tibial insert excluding patella component Unicompartmental arthroplasty UKA Femoral and tibial Tibial insert medial component Unicompartmental arthroplasty UKA Femoral and tibial Tibial insert lateral component Patellofemoral arthroplasty PFA Femoral and patellar component Other Any component involved at least one Knee Revision Any component involved at least one Additional Components Hip Type of Primary Procedure Total hip arthro
30. I s privacy and confidentiality policies and procedures are available on its website at www cihi ca For further information about CJRR s products and services please visit our website at www cihi ca cjrr Chapter 1 Canadian Joint Replacement Registry Data Submissions Hil Chapter 1 Canadian Joint Replacement Registry Data Submissions There are two modes of submission to CJRR 1 Electronic file submission Electronic data is submitted directly by the physicians coordinators hospitals or third party vendors based on pre defined CJRR specifications 2 CJRR Web Based Data Submission and Reports Tool Data is submitted through this stand alone application that enables surgeons or their designated staff to submit data electronically to CJRR through a secure internet connection This tool is available in both English and French and also allows users to run and view surgeon specific summary reports Unless otherwise indicated by an exclamation point amp the field applies to all methods of submission Paper form submissions have been phased out CJRR no longer accepts paper based data submissions Note When communicating with CJRR about specific records do not send personal health information PHI via email or fax For details on deleting or correcting CJRR records refer to Appendix D Chapter 2 Record Information Electronic File Submission Only E Chapter 2 Record Information Electronic File Submission
31. Missing value number is missing Tibial Insert Lot K 50 1 Length of field exceeded Out of range Severe Record rejected 50 2 Field contains invalid value Invalid value 50 3 For each sticker present if lot number Missing value is missing cont d on next page 9L0Z SLOZ jenuey jes geq WNWIUIN Ays ey JUSWaoejday juior ueipeueo gg co Data Element Name Error Number Error Condition Error Message Patellar component sticker information Error Type System Action H If stickers are not completed in Patellar component stickers must be Severe Record rejected sequential order completed in sequential order Patellar Component 59 1 Manufacturer not found in database Value not found in database Severe Record rejected Manufacturer K 59 2 For each sticker present if Missing value manufacturer is missing Patellar Component 60 1 Field contains invalid value Invalid value Severe Record rejected Manufacturer 60 2 Length of field exceeded Out of range Other K 60 3 If option OTH is selected and details Manufacturer is Other and details are are missing missing 60 4 Manufacturer not OTH but Manufacturer Other must be blank if manufacturer Other populated Other is not selected Patellar Component 61 1 Field contains invalid value Invalid value Severe Record rejected Product K 61 2 Length of field exceeded Out of range 61 3 For each sticker pre
32. Palacos CMW Cerafix SmartSet Refobacin Versabond Osteobond OTH Mix other OINI RO IN Chapter 7 Hip Replacement Prosthesis Information Fields 72 76 Cement Details Name Other Specifications Field Length 45 alphanumeric characters Field Status Applicable only if Cement Details Name OTH Valid Data 0 9 A Z space hyphen period apostrophe ampersand amp Joint Type Knee and hip Definition The Cement Details Name Other field indicates the name of the cement if other is indicated in the Cement Details Name field Example The patient s hip replacement was performed using CMW cement Cement Details Name BRE Cement Details Name Other CITITITITITITITITITIT Example The patient s hip replacement was performed using ABC Cement Cement Details Name jo T H Cement Details Name Other TT TT TT Afsjef Telelmfelnit EEE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Fields 73 77 Cement Details Product Number Specifications Field Length 60 alphanumeric characters Field Status Applicable only if cement was used if cement sticker is available Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla Joint Type Knee
33. able only if femoral component was used Valid Data 1 11 OTH Joint Type Knee and hip Definition The Femoral Component Manufacturer field indicates the manufacturer of the femoral component used for the procedure This includes modular body stem neck combinations and monoblock implants for hemiarthroplasties The Femoral Component Manufacturer codes are the following Code Description 1 Biomet Ceraver DePuy Finsbury J amp J Zimmer Sulzer Centerpulse MicroPort Wright Medical Smith amp Nephew Stryker Osteonics Howmedica Medacta International Link Corin OI NII RO IN Tecres Medical Other O I Chapter 7 Hip Replacement Prosthesis Information Fields 24 28 32 Femoral Component Manufacturer Other Specifications Field Length 45 alphanumeric characters Field Status Applicable only if Femoral Component Manufacturer OTH Valid Data 0 9 A Z space hyphen period apostrophe ampersand amp Joint Type Knee and hip Definition The Femoral Component Manufacturer Other field indicates the manufacturer of the femoral component if other is indicated in the Femoral Component Manufacturer field This includes modular body stem neck combinations and monoblock implants for hemiarthroplasties Example The patient s hip replacement used a femoral component made by the manufacturer Biomet Femoral Component Manu
34. acement surgery that was performed on November 4 2012 is recorded as 20121104 with Fiscal Year of Surgery recorded as 2012 Fiscal Year Surgery Date of Surgery 2jolsl2lelslole 2lol l2 Y Y Y Y M M D D amp Example For web A knee replacement surgery that was performed on November 4 2012 is recorded as 2012 NOV 04 Surgery Date 2 ol1l2 Inlolv 0 4 Y Y Y Y M M M D D Chapter 5 General Procedure Information I Chapter 5 General Procedure Information Field 18 Side Location Specifications Field Length 1 numeric digit Field Status Mandatory Valid Data 1 4 Joint Type Knee and hip Definition The Side Location indicates whether a unilateral or a bilateral right left joint replacement surgery was performed Bilateral procedures are cases where both joints are done under the same anesthesia The Side Location codes are the following Code Description 1 Unilateral right 2 Unilateral left 3 Bilateral right 4 Bilateral left Note If bilateral submit one record per side WE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Field 19 Type of Replacement Specifications Field Length 1 numeric digit Field Status Mandatory Valid Data 1 2 Joint Type Knee and hip Definition The Type of Replacement field indicates the replacement type primary or revision The Type of Replacement codes are the following Code Descriptio
35. acturer 36 40 44 Femoral Head Manufacturer Other 37 41 45 Femoral Head Product Number 38 42 46 Femoral Head Lot Number 47 51 55 Acetabular Component Manufacturer 48 52 56 Acetabular Component Manufacturer Other 49 53 57 Acetabular Component Product Number cont d on next page Indices I Field Field Name 50 54 58 Acetabular Component Lot Number 59 63 67 Acetabular Insert Liner Manufacturer 60 64 68 Acetabular Insert Liner Manufacturer Other 61 65 69 Acetabular Insert Liner Product Number 62 66 70 Acetabular Insert Liner Lot Number 71 75 Cement Details Name 72 76 Cement Details Name Other 73 77 Cement Details Product Number 74 78 Cement Details Lot Number Alphabetic Index by Field Name Field Name Joint Type Field Acetabular Component Product Number Hip 49 53 57 Acetabular Component Lot Number Hip 50 54 58 Acetabular Component Manufacturer Hip 47 51 55 Acetabular Component Manufacturer Other Hip 48 52 56 Acetabular Insert Liner Product Number Hip 61 65 69 Acetabular Insert Liner Lot Number Hip 62 66 70 Acetabular Insert Liner Manufacturer Hip 59 63 67 Acetabular Insert Liner Manufacturer Other Hip 60 64 68 Cement Details Product Number Hip knee 73 77 Cement Details Lot Number Hip knee 74 78 Cement Details Name Hip knee 71 75 C
36. acturer field Example The patient s knee replacement used a patellar component made by the manufacturer Zimmer Patellar Component Manufacturer RARE Patellar Component Manufacturer Other PITT TT iti titi Example The patient s knee replacement used a patellar component made by the manufacturer ABC Manufacturer Patellar Component Manufacturer o r H Patellar Component Manufacturer Other Talslel mlalnfu ffafe t u rje r Chapter 6 Knee Replacement Prosthesis Information Hi Fields 61 65 69 Patellar Component Product Number Field Length 60 alphanumeric characters Field Status Applicable only if patellar component was used Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla Joint Type Knee Definition The Patellar Component Product Number field indicates the product reference catalogue or other number of the patellar component used for the procedure Fields 62 66 70 Patellar Component Lot Number Field Length 60 alphanumeric characters Field Status Applicable only if patellar component was used Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square
37. ade by the manufacturer ABC Manufacturer Femoral Component Manufacturer ejti Femoral Component Manufacturer Other I TT Talslel IMJAINIUIETAIGITIUIRIEIR EEE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Fields 25 29 33 Femoral Component Product Number Field Length 60 alphanumeric characters Field Status Applicable only if femoral component was used Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla Joint Type Knee and hip Definition The Femoral Component Product Number field indicates the product reference catalogue or other number of the femoral component used for the procedure Fields 26 30 34 Femoral Component Lot Number Field Length 60 alphanumeric characters Field Status Applicable only if femoral component was used Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla Joint Type Knee and hip Definition The Femoral Component Lot Number field indicates the lot number of the femoral component used for the procedure Chapter 6 Knee Replacement Prosthesis Information Hi Fields 35 39 43 Tibial Compon
38. alue at position value of 2nd digit of HCN 1 Table A value at position value of 4th digit of HCN 1 Table A value at position value of 7th digit of HCN 1 Table A value at position value of 9th digit of HCN 1 Divide that total by 10 giving a remainder The 5th digit of HCN must Table B value at position remainder 1 BC 10 numeric the validation is done using the first 10 digits only with the 10th digit as the check digit Add together these values 2nd digit of HCN times 2 3rd digit of HCN times 4 Ath digit of HCN times 8 5th digit of HCN times 5 6th digit of HCN times 10 7th digit of HCN times 9 8th digit of HCN times 7 9th digit of HCN times 3 Divide the total by 11 giving a remainder The 10th digit of HCN must 11 remainder YT 9 numeric a valid MOD 10 check digited number NT 8 digits 1 alpha N M T D H 7 numeric MOD 10 validation applied on first 8 digits with a 0 inserted as the first digit NU 9 numeric first digit must be1 last digit must be in 3 4 5 6 7 8 and the 2nd through 8th digits of the HCN must be a valid MOD 10 check digited number Notes Leave blank when the HCN is not available In this case Health Card Issuing Authority Code must be N A For details on MOD 10 calculation refer to Appendix F Example Please see the examples for Field 10 EEE Canadian Joint Replacement Registry Minimum Data Set Manual
39. an into KANNE DL gt Product Number field X34 5 6789 OAO Scan into 23456789 Lot Number field e If not scan the top barcode into the Product Number field and the bottom barcode into the Lot Number field REF 12 3456 LOT 123546 y 2025 12 ABC Knee Replacement System Scan into Tibial Stem Cemented 100mm Product Number field lt NIMM MN A ABC123456XYZ i NIE 0 Scan into 14 325121234123456ABC Lot Number field ABC MANUFACTURER B Implant Stickers With One Barcode 1 Appendix C Entering Prosthesis and Cement Information Hi Is this a product sticker from the manufacturer Zimmer For Zimmer products with only one barcode scan the same barcode into both the Product Number and Lot Number fields For all other manufacturers manually enter the catalogue reference number in the Product Number field and the lot number in the Lot Number field Zimmer products Scan here for both product number AND lot number All other manufacturers Manually enter product number AND lot number C in the Lot Number field 123456789 EDI 001234506789 123 4567 89 ABC KNEE REPLACEMENT SYSTEM POSTERIOR STABILIZED FEMORAL COMPONENT SIZE A RIGHT BD LL LU XYZ001234506789 201299123456879ABC 2 2025 12 XYZ MANUFACTURER Implant Stickers Without a Barcode or Manual Entry Option Enter the catalogue referen
40. bracket cedilla Joint Type Knee Definition The Patellar Component Lot Number field indicates the lot number of the patellar component used for the procedure WE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Fields 71 75 Cement Details Name Specifications Field Length 3 alphanumeric characters Field Status Applicable only if cement was used if cement sticker is available Valid Data 1 8 OTH Joint Type Knee and hip Definition The Cement Details Name field indicates the name of the cement used The Cement Details Name codes are the following Code Description 1 Simplex Palacos CMW Cerafix SmartSet Refobacin Versabond Osteobond OTH Mix other OINI RO IN Chapter 6 Knee Replacement Prosthesis Information Fields 72 76 Cement Details Name Other Specifications Field Length 45 alphanumeric characters Field Status Applicable only if Cement Details Name OTH Valid Data 0 9 A Z space hyphen period apostrophe ampersand amp Joint Type Knee and hip Definition The Cement Details Name Other field indicates the name of the cement if other is indicated in the Cement Details Name field Example The patient s knee replacement was performed using Palacos cement Cement Details Name ERA Cement Details Name Other CITITITITITITITITITIT Example Th
41. ce number in the Product Number field and the lot number e All information should be entered exactly as it appears on the sticker Manually enter in the Product Number field 1234 56AB Manually enter in the Lot Number field 123456789 REF 1234 56AB LOT 123456789 ABC KNEE REPLACEMENT SYSTEM UNICOMPARTMENTAL TIBIAL INSERT SIZE E LEFT ABC MANUFACTURER MM Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 For Zimmer products the product number is often referred to as the EDI number If there is an EDI number manually enter it in the implant Product Number field If there is no EDI number manually enter the catalogue number also known as the reference number in the implant Product Number field EDI 001234506789 123 4567 89 p ABC KNEE REPLACEMENT SYSTEM POSTERIOR STABILIZED FEMORAL COMPONENT RIGHT i gt CLEO 0 DLL LE XYZ001234 01299123456879ABC z 20022 XYZ MANUFACTURER Manually enter the EDI number in the implant Product Number field XYZ MANUFACTURER CAT NO 123 4567 89 Manually enter the lot number in the Lot Number field Manually enter the catalogue A ABC KNEE REPLACEMENT SYSTEM POSTERIOR STABILIZED FEMORAL COMPONENT SIZE A reference number in the implant Product Number field RIGHT EEE XYZ001234506789C OR RA IT ee 20129912345678
42. component sticker information and any tibial component stickers must be blank for this type of are present primary procedure 20 10 If Type of Primary Procedure is 5 and Tibial insert sticker information must be any tibial insert stickers are present blank for this type of primary procedure 20 11 If Type of Primary Procedure is 6 8 or Femoral component sticker information 9 and femoral component sticker information is missing is missing cont d on next page 9LOZ GLOZ Ienue Jes ejeq UWNUIUIN Aus bay Jusweselday juIof UEIPEUE m co Data Element Name Error Number Error Condition Error Message Error Type System Action Type of Primary 20 12 If Type of Primary Procedure is 6 7 or Femoral head sticker information Procedure H and K 9 and femoral head sticker information is missing cont d is missing 20 13 If Type of Primary Procedure is 6 Acetabular component sticker information and acetabular component sticker is missing information is missing 20 14 If Type of Primary Procedure is 7 and Femoral component sticker information any femoral component stickers are must be blank for this type of present primary procedure 20 15 If Type of Primary Procedure is 7 8 or Acetabular insert liner sticker information 9 and any acetabular insert liner must be blank for this type of stickers are present primary procedure 20 16 If Type of Primary Procedure is 8 or9 Acetabula
43. d rejected Me 61 2 Field contains invalid value Invalid value Product H 61 3 For each sticker present if product Missing value number is missing Acetabular 62 1 Length of field exceeded Out of range Severe Record rejected ert slag 62 2 Field contains invalid value Invalid value 62 3 For each sticker present if lot number Missing value is missing Tibial component sticker information F If stickers are not completed in Tibial component stickers must be Severe Record rejected sequential order completed in sequential order Tibial Component 35 1 Manufacturer code not found in the Value not found in database Severe Record rejected Manufacturer K manufacturer table 35 2 For each sticker present if Missing value manufacturer is missing Tibial Component 36 1 Field contains invalid value Invalid value Severe Record rejected Manufacturer Other K 36 2 Length of field exceeded Out of range 36 3 If option OTH is selected and details Manufacturer is Other and details are missing are missing 36 4 Manufacturer not OTH but Manufacturer Other must be blank if manufacturer Other populated Other is not selected Tibial Component 37 1 Length of field exceeded Out of range Severe Record rejected ROAGE 37 2 Field contains invalid value Invalid value 37 3 For each sticker present if product Missing value number is missing cont d on next page EE 2p02 q 1043 YYPO 3 X puaddy 86 Data Element Name Error Number
44. de Province Territory NL Government of Newfoundland and Labrador PE Government of Prince Edward Island NS Government of Nova Scotia NB Government of New Brunswick QC Government of Quebec ON Government of Ontario MB Government of Manitoba SK Government of Saskatchewan AB Government of Alberta BC Government of British Columbia YT Government of Yukon NT Government of the Northwest Territories NU Government of Nunavut CA Government of Canada N A Not applicable Note Chapter 4 Patient Demographics I Use N A when the HCN is not available is blank Example Example Example An Alberta resident had knee replacement surgery in a British Columbia facility The patient s nine digit Alberta HCN is recorded in the Health Card Number field and the Health Card Issuing Authority Code is recorded as AB Alberta in the data file from the facility in British Columbia Health Card Number Province Code 1jefsfafsfe rfa o An RCMP officer who has federal insurance coverage had knee replacement surgery in a Nova Scotia facility Health Card Number Province Code ITITI 1 leppa The patient is a resident of Saskatchewan but does not have provincial territorial health coverage Health Card Number Province Code ITITI TTT NT EEE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Field 11 Health Card Number Specifications Fie
45. de by the manufacturer MicroPort Wright Medical Tibial Insert Manufacturer I 15 Tibial Insert Manufacturer Other EEEEEEEEEEEEEEEEERENE The patient s knee replacement used a tibial insert made by the manufacturer ABC Manufacturer Tibial Insert Manufacturer o t H Tibial Insert Manufacturer Other lalele mfalnfuf rfaje t ufrjefr EEE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Fields 49 53 57 Tibial Insert Product Number Specifications Field Length 60 alphanumeric characters Field Status Applicable only if tibial insert was used Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla Joint Type Knee Definition The Tibial Insert Product Number field indicates the product reference catalogue or other number of the tibial insert used for the procedure Fields 50 54 58 Tibial Insert Lot Number Specifications Field Length 60 alphanumeric characters Field Status Applicable only if tibial insert was used Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla Joint Type Knee Definition The Tibial I
46. do not necessarily represent the views of Health Canada or any provincial or territorial government All rights reserved The contents of this publication may be reproduced unaltered in whole or in part and by any means solely for non commercial purposes provided that the Canadian Institute for Health Information is properly and fully acknowledged as the copyright owner Any reproduction or use of this publication or its contents for any commercial purpose requires the prior written authorization of the Canadian Institute for Health Information Reproduction or use that suggests endorsement by or affiliation with the Canadian Institute for Health Information is prohibited For permission or information please contact CIHI Canadian Institute for Health Information 495 Richmond Road Suite 600 Ottawa Ontario K2A 4H6 Phone 613 241 7860 Fax 613 241 8120 www cihi ca copyright cihi ca 2015 Canadian Institute for Health Information Cette publication est aussi disponible en frangais sous le titre Manuel du fichier minimal du Registre canadien des remplacements articulaires 2015 2016 Talk to Us CIHI Ottawa 495 Richmond Road Suite 600 Ottawa Ontario K2A 4H6 Phone 613 241 7860 CIHI Toronto 4110 Yonge Street Suite 300 Toronto Ontario M2P 2B7 Phone 416 481 2002 CIHI Victoria 880 Douglas Street Suite 600 Victoria British Columbia V8W 2B7 Phone 250 220 4100 9402 0115 CIHI Montreal 1010 Sherbroo
47. e patient s knee replacement was performed using ABC Cement Cement Details Name o t H Cement Details Name Other PETE TT TT TT lalele Jefe mfe n r EEE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Fields 73 77 Cement Details Product Number Specifications Field Length 60 alphanumeric characters Field Status Applicable only if cement was used if cement sticker is available Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla Joint Type Knee and hip Definition The Cement Details Product Number field indicates the product reference catalogue or other number of the cement used for the procedure Fields 74 78 Cement Details Lot Number Specifications Field Length 60 alphanumeric characters Field Status Applicable only if cement was used if cement sticker is available Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla Joint Type Knee and hip Definition The Cement Details Lot Number field indicates the lot number of the cement used for the procedure Chapter 7 Hip Replacement Prosthesis Information Hil
48. eld Status Applicable only if femoral component was used Valid Data 1 11 OTH Joint Type Knee and hip Definition The Femoral Component Manufacturer field indicates the manufacturer of the femoral component used for the procedure The Femoral Component Manufacturer codes are the following Code Description 1 Biomet Ceraver DePuy Finsbury J amp J Zimmer Sulzer Centerpulse MicroPort Wright Medical Smith amp Nephew Stryker Osteonics Howmedica Medacta International Link Corin oe COIN OD oO AJOJN Tecres Medical Other O per I Chapter 6 Knee Replacement Prosthesis Information Fields 24 28 32 Femoral Component Manufacturer Other Specifications Field Length 45 alphanumeric characters Field Status Applicable only if Femoral Component Manufacturer OTH Valid Data 0 9 A Z space hyphen period apostrophe ampersand amp Joint Type Knee and hip Definition The Femoral Component Manufacturer Other field indicates the manufacturer of the femoral component if other is indicated in the Femoral Component Manufacturer field Example The patient s knee replacement used a femoral component made by the manufacturer Stryker Femoral Component Manufacturer I 17 Femoral Component Manufacturer Other PITT TT TT TT TT Example The patient s knee replacement used a femoral component m
49. ement Details Name Other Hip knee 72 76 Chart Number Hip knee 16 Diagnosis Grouping Primary Procedures Only Hip knee 21 Femoral Component Product Number Hip knee 25 29 33 Femoral Component Lot Number Hip knee 26 30 34 Femoral Component Manufacturer Hip knee 23 27 31 Femoral Component Manufacturer Other Hip knee 24 28 32 Femoral Head Product Number Hip 37 41 45 Femoral Head Lot Number Hip 38 42 46 Femoral Head Manufacturer Hip 35 39 43 cont d on next page EEE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Field Name Joint Type Femoral Head Manufacturer Other Hip 36 40 44 Fiscal Year of Surgery Hip knee 03 Gender Hip knee 13 Health Card Number Hip knee 11 Hospital Institution Number Hospital Name Hip knee 15 Hospital Province Hip knee 04 Patellar Component Product Number Knee 61 65 69 Patellar Component Lot Number Knee 62 66 70 Patellar Component Manufacturer Knee 59 64 67 Patellar Component Manufacturer Other Knee 60 64 68 Patient Birthdate Hip knee 12 Patient First Name Hip knee 08 Patient Last Name Hip knee 09 Patient Postal Code Hip knee 14 Health Card Issuing Authority Code Hip knee 10 Reason for Revision Revision Procedures Only Hip knee 22 Record ID Hip knee 01 Record Type Hip knee 02 Side Location Hip knee 18 Submission Type Hip knee 05 Surgeon ID
50. emoral Component Manufacturer cccccccccccceceeseeeeeeeeeseaeaeeseeeeeeees 54 Fields 24 28 32 Femoral Component Manufacturer Other 55 Fields 25 29 33 Femoral Component Product Number 56 Fields 26 30 34 Femoral Component Lot Number ccccccccceecceceesseeeeeeeeesaeaeeeeeeeeeees 56 Fields 35 39 43 Femoral Head Manufacturer 57 Fields 36 40 44 Femoral Head Manufacturer Other 58 Fields 37 41 45 Femoral Head Product Number 59 Fields 38 42 46 Femoral Head Lot Number rrrrnnnnnnnnnnnnrnnnnnnerennrnnnnennrnnnnenrrnsnernrnnenerennne 59 Fields 47 51 55 Acetabular Component Manufacturer cccccccccsseeseceeeeeeeeaeaeesseeeees 60 Fields 48 52 56 Acetabular Component Manufacturer Other 61 Fields 49 53 57 Acetabular Component Product Number 62 Fields 50 54 58 Acetabular Component Lot Number rrrrrrrnnrnnnnnnrnnnvnrnnrnnnnnnnnrnnrrrnnnnnnnne 62 Table of Contents Hi Fields 59 63 67 Acetabular Insert Liner Manufacturer 63 Fields 60 64 68 Acetabular Insert Liner Manufacturer Other 64 Fields 61 65 69 Acetabular Insert Liner Product Number nenne nnnnennn 65 Fields 62 66 70 Acetabular Insert Liner Lot Number 65 Fields 71 75 Cement Details Name rnmunnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnvnnenvnr 66 Fields 72 76 Ce
51. ent Manufacturer Specifications Field Length 3 alphanumeric characters Field Status Applicable only if tibial component was used Valid Data 1 11 OTH Joint Type Knee Definition The Tibial Component Manufacturer field indicates the manufacturer of the tibial component used for the procedure This includes all poly tibias The Tibial Component Manufacturer codes are the following Code Description 1 Biomet Ceraver DePuy Finsbury J amp J Zimmer Sulzer Centerpulse MicroPort Wright Medical Smith amp Nephew Stryker Osteonics Howmedica Medacta International Link Corin oe COIN OD oO AJOJN Tecres Medical Other O I EEE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Fields 36 40 44 Tibial Component Manufacturer Other Specifications Field Length 45 alphanumeric characters Field Status Applicable only if Tibial Component Manufacturer OTH Valid Data 0 9 A Z space hyphen period apostrophe ampersand amp Joint Type Knee Definition The Tibial Component Manufacturer Other field indicates the manufacturer of the tibial component if other is indicated in the Tibial Component Manufacturer field This includes all poly tibias Example The patient s knee replacement used a tibial component made by the manufacturer Ceraver Tibial Component Manufact
52. er sleeves Appendix B Component Information Categorization Hi Bagues Cages Vis Blocs d augmentation c nes Bouchons obturateurs Cables Plaques Centreurs Tiges d extension Obturateurs en ciment C nes manchons de c nes Appendix C Entering Prosthesis and Cement Information Appendix C Entering Prosthesis and Cement Information Data submitters are provided with two options when entering product or cement information barcode scanning and manual entry This appendix presents instructions for both methods of entry along with samples of fictitious product labels based on actual manufacturer stickers Note that this is not an exhaustive list and is intended for demonstration purposes only If you notice any discrepancies or new sticker variations please inform CJRR by email at cjrr cihi ca The following guidelines apply to the entry of implant sticker information for manual entry of data skip to Step 3C Step 1 Setting Up a Barcode Scanner The first step is to enable transmission of the Automatic Identification and Mobility AIM Code Refer to the scanner s user manual for more information Scanner settings are often enabled or disabled by scanning special barcodes provided in the user manual Enabling the AIM Code is necessary for the CJRR internal system to recognize the entry as a scanned barcode rather than a manually entered value Without the AIM Code the CURR system will not trigger the
53. exceeded Out of range 38 3 For each sticker present if lot number Missing value is missing cont d on next page EE 2p02 q 1043 YYPO 3 X puaddy 96 Data Element Name Error Number Error Condition Error Message Acetabular component sticker information Error Type System Action D If stickers are not completed in Acetabular component stickers must be Severe Record rejected sequential order completed in sequential order Acetabular 47 1 Manufacturer code does not exist in Value not found in database Severe Record rejected Component the manufacturer table Manufacturer H 47 2 For each sticker present if Missing value manufacturer is missing Acetabular 48 1 Field contains invalid value Invalid value Severe Record rejected Component 48 2 Length of field exceeded Out of range Manufacturer Other H 48 3 If option OTH is selected and details Manufacturer is Other and details are are missing missing 48 4 Manufacturer not OTH but Manufacturer Other must be blank if manufacturer Other populated Other is not selected Acetabular 49 1 Field contains invalid value Invalid value Severe Record rejected Component 5 Product H 49 2 Length of field exceeded Out of range 49 3 For each sticker present if product Missing value number is missing Acetabular 50 1 Field contains invalid value Invalid value Severe Record rejected Component Let 50
54. facturer TT Femoral Component Manufacturer Other TITT TT TITT TITT TITT Example The patient s hip replacement used a femoral component made by the manufacturer ABC Manufacturer Femoral Component Manufacturer o T 1H Femoral Component Manufacturer Other TT Talele IMJAINIUIFIATCITIUIR ER EEE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Fields 25 29 33 Femoral Component Product Number Field Length 60 alphanumeric characters Field Status Applicable only if femoral component was used Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla Joint Type Knee and hip Definition The Femoral Component Product Number field indicates the product reference catalogue or other number of the femoral component used for the procedure This includes modular body stem neck combinations and monoblock implants for hemiarthroplasties Fields 26 30 34 Femoral Component Lot Number Specifications Field Length 60 alphanumeric characters Field Status Applicable only if femoral component was used Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla
55. for the procedure This includes all poly tibias BE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Fields 47 51 55 Tibial Inser Manufacturer Specifications Field Length 3 alphanumeric characters Field Status Applicable only if tibial insert was used Valid Data 1 11 OTH Joint Type Knee Definition The Tibial Insert Manufacturer field indicates the manufacturer of the tibial insert used for the procedure The Tibial Inser Manufacturer codes are the following Code Description 1 Biomet Ceraver DePuy Finsbury J amp J Zimmer Sulzer Centerpulse MicroPort Wright Medical Smith amp Nephew Stryker Osteonics Howmedica Medacta International Link Corin oe COIN OD oO AJOJN Tecres Medical Other O per I Fields 48 Chapter 6 Knee Replacement Prosthesis Information 52 56 Tibial Insert Manufacturer Other Specifications Field Length 45 alphanumeric characters Field Status Applicable only if Tibial Insert Manufacturer OTH Valid Data 0 9 A Z space hyphen period apostrophe ampersand amp Joint Type Knee Definition The Tibial Inser Manufacturer Other field indicates the manufacturer of the tibial insert if other is indicated in the Tibial Insert Manufacturer field Example Example The patient s knee replacement used a tibial insert ma
56. ion Fields 48 52 56 Acetabular Component Manufacturer Other Specifications Field Length 45 alphanumeric characters Field Status Applicable only if Acetabular Component Manufacturer OTH 0 9 A Z space hyphen period apostrophe Valid Data ampersand amp Joint Type Hip Definition The Acetabular Component Manufacturer Other field indicates the manufacturer of the acetabular component if other is indicated in the Acetabular Component Manufacturer field Example The patient s hip replacement used an acetabular component made by the manufacturer Medacta International Acetabular Component Manufacturer Acetabular Component Manufacturer Other CITITITITITITITITITIT Example The patient s hip replacement used an acetabular component made by the manufacturer ABC Manufacturer Acetabular Component Manufacturer O T H Acetabular Component Manufacturer Other lalele IMJAINIUIFTAICITIUIRIER EEE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Fields 49 53 57 Acetabular Component Product Number Specifications Field Length 60 alphanumeric characters Field Status Applicable only if acetabular component was used Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket
57. ke Street West Suite 300 Montr al Quebec H3A 2R7 Phone 514 842 2226 CIHI St John s 140 Water Street Suite 701 St John s Newfoundland and Labrador A1C 6H6 Phone 709 576 7006 Canadian Institute for Health Information www cihi ca Institut canadien At the heart of data d information sur la sant
58. ld Length 12 alphanumeric characters Field Status Mandatory Valid Data 0 9 A Z blank Joint Type Knee and hip Definition Health Card Number is the patient s health care card number The Health Card Number will be validated according to the provincial territorial algorithm This field must be completed in conjunction with the Health Card Issuing Authority Code field A federal Health Card Number RCMP veterans etc will not be validated by CIHI The province territory specific HCN value details are the following Province Territory Value Details NL 12 numeric a valid MOD 10 check digited number PE 8 numeric a valid MOD 10 check digited number NS 10 numeric a valid MOD 10 check digited number NB 9 numeric a valid MOD 10 check digited number Qc 12 digits 4 alpha 8 numeric ON 10 digits record an additional one or two alpha characters for version codes if applicable a valid MOD 10 check digited number MB 9 numeric SK 9 numeric validation is done via a lookup table provided to CIHI by Saskatchewan Health cont d on next page Chapter 4 Patient Demographics I Province Territory Value Details AB 9 numeric the 5th digit is the check digit The algorithm for validating the HCN involves two tables Table A and Table B Table A is 0246813579 Table B is 0987654321 Add together these values 1st digit of HCN 3rd digit of HCN 6h digit of HCN 8th digit of HCN Table A v
59. ment Details Name Other Rn nnnnnnnnan nenne 67 Fields 73 77 Cement Details Product Number nnnrannnrrunnnrnnnnrnnnnrnnnnrrnnnnrnnnevnnnervnnnnvnnenvnnr 68 Fields 74 78 Cement Details Lot Number rarunrunnnrunnnrrnnnnrunnnrnnnernnnnrrnnenrnnnevnnnevnnnevvnnenvnnr 68 late ME TF 69 Numeric Index by Field ur eier 69 Alphabetic Index by Field Name u 71 Appendix A Prosthesis Information Required by Type of Primary Procedure 73 Appendix B Component Information Categorization 75 Appendix C Entering Prosthesis and Cement Information cccecceecceeeeeeeeeeeeteeeeeeeeeneeees 79 Appendix D Deleting and Correcting CURR Records nennen 87 Appendix E CJRR Error Decoder nn Rn n nn nn non ennnnnnnennnnnnnnnnnennnene 89 Appendix F MOD 10 Calculation sise 101 Changes for 2015 2016 CJRR Minimum Data Set Manual Hi Changes for 2015 2016 CJRR Minimum Data Set Manual There are no changes from the Canadian Joint Replacement Registry Minimum Data Set Manual 2014 2015 Introduction Hi Introduction About the Canadian Joint Replacement Registry The Canadian Joint Replacement Registry CJRR is a pan Canadian information system for hip and knee replacement operations Its mandate is to record and analyze clinical parameters and outcomes of primary and revision hip and knee replacement operations over time The registry was devel
60. n 1 Primary 2 Revision Chapter 5 General Procedure Information I Field 20 Type of Primary Procedure Specifications Field Length 3 alphanumeric characters Field Status Mandatory if Type of Replacement 1 Valid Data Knee 1 5 OTH Hip 6 9 OTH Joint Type Knee and hip Definition The Type of Primary Procedure indicates the primary procedure type performed on the patient Refer to Appendix A for the corresponding component prosthesis information required for each type of primary procedure The Type of Primary Procedure codes for knee and hip procedures are the following Code Description Joint Type 1 Total knee arthroplasty TKA including patella Knee 2 Total knee arthroplasty TKA excluding patella Knee 3 Unicompartmental arthroplasty UKA medial Knee 4 Unicompartmental arthroplasty UKA lateral Knee 5 Patellofemoral arthroplasty PFA Knee 6 Total hip arthroplasty Hip 7 Resurfacing Hip 8 Monopolar unipolar hemiarthroplasty Hip 9 Bipolar hemiarthroplasty Hip OTH Other Knee and hip Example The patient had a primary knee procedure specifically a total knee arthroplasty Example excluding patella Type of Type of Primary Replacement Procedure The patient had a revision procedure Type of Type of Primary Replacement Procedure L JTI EEE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Field 21 Diagnosis Grouping Primary P
61. ns invalid value Invalid value Severe Record rejected Lot Pandi K 26 2 Length of field exceeded Out of range 26 3 For each sticker present if lot number Missing value is missing Femoral head sticker information C If stickers are not completed in Femoral head stickers must be Severe Record rejected sequential order completed in sequential order Femoral Head 35 1 Manufacturer codes for femoral head Manufacturer for femoral component and Non severe None Manufacturer H and femoral component hip are not femoral head does not match the same first stickers only 35 2 Manufacturer code does not exist in Value not found in database Severe Record rejected the manufacturer table 35 3 For each sticker present if Missing value manufacturer is missing Femoral Head 36 1 Field contains invalid value Invalid value Severe Record rejected Manufacturer Other H 36 2 Length of field exceeded Out of range 36 3 If option OTH is selected and details Manufacturer is Other and details are are missing missing 36 4 Manufacturer not OTH but Manufacturer Other must be blank if manufacturer Other populated Other is not selected Femoral Head 37 1 Field contains invalid value Invalid value Severe Record rejected Product q 37 2 Length of field exceeded Out of range 37 3 For each sticker present if product Missing value number is missing Femoral Head 38 1 Field contains invalid value Invalid value Severe Record rejected Lot H 38 2 Length of field
62. nsert Lot Number field indicates the lot number of the tibial insert used for the procedure Chapter 6 Knee Replacement Prosthesis Information Hi Fields 59 63 67 Patellar Component Manufacturer Specifications Field Length 3 alphanumeric characters Field Status Applicable only if patellar component was used Valid Data 1 11 OTH Joint Type Knee Definition The Patellar Component Manufacturer field indicates the manufacturer of the patellar component used for the procedure The Patellar Component Manufacturer codes are the following Code Description 1 Biomet Ceraver DePuy Finsbury J amp J Zimmer Sulzer Centerpulse MicroPort Wright Medical Smith amp Nephew Stryker Osteonics Howmedica Medacta International Link Corin oe COIN OD oO AJOJN Tecres Medical Other O I EEE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Fields 60 64 68 Patellar Component Manufacturer Other Specifications Field Length 45 alphanumeric characters Field Status Applicable only if Patellar Component Manufacturer OTH Valid Data 0 9 A Z space hyphen period apostrophe ampersand amp Joint Type Knee Definition The Patellar Component Manufacturer Other field indicates the manufacturer of the patellar component if other is indicated in the Patellar Component Manuf
63. oped through a joint effort between the Canadian Institute for Health Information CIHI and orthopedic surgeons in Canada The goal of CJRR is to provide information to help improve the quality of care and clinical outcomes of joint replacement recipients CIHI captures administrative including diagnoses and procedure codes and demographic information on all discharges from acute care facilities in Canada including hip and knee joint replacements and revisions through the Hospital Morbidity Database HMDB CJRR was developed to provide a rich set of additional patient clinical surgical and prosthesis information to complement what is captured in the HMDB to enable more in depth analysis of hip and knee replacements and revisions The goal of CJRR is to provide information that is designed to help improve the quality of care and clinical outcomes of joint replacement recipients In addition to the partnership between CIHI and orthopedic surgeons across the country several key partners have greatly contributed to the successful development and implementation of CJRR including the Canadian Orthopaedic Association orthopedic patients the Arthritis Society of Canada and federal provincial and territorial ministries of health Privacy and Confidentiality As a custodian of numerous registries and databases CIHI has stringent policies to ensure that the privacy confidentiality and security of its data holdings are protected Information on CIH
64. plasty Mandatory Components Femoral component femoral head and acetabular component if Applicable Acetabular insert liner Resurfacing Femoral head Acetabular component Femoral head Monopolar unipolar hemiarthroplasty Femoral component Bipolar hemiarthroplasty Femoral component and femoral head Other Any component involved at least one Hip Revision Any component involved at least one Appendix B Component Information Categorization Hi Appendix B Component Information Categorization Femoral component Composant f moral EN e Modular body stem neck combinations e Femoral component femoral stem e Monoblock implant for hemiarthroplasty for example Austin Moore Thompson implants e Endoprosthesis e Prefabricated femoral component cement spacer temporary joint prosthesis or mould FR je Combinaisons de corps tige col modulaires e Composant f moral proth se f morale tige femorale implant f moral e Proth se monobloc pour les h miarthroplasties p ex proth se d Austin Moore ou proth se de Thompson e Composant f moral pr fabriqu moule ou dispositif d espacement en ciment e Composant f moral pr fabriqu moule ou spacer en ciment Femoral head T te f morale EN Bipolar head bipolar cup and bipolar liner bipolar shell Monopolar head Femoral head Resurfacing head Prefabricated femoral head cement spacer temporar
65. pulated 22 5 The field contains an invalid value Invalid value A If no component is present At least one component must Severe Record rejected be completed Femoral component sticker information B If stickers are not completed in Femoral component stickers must be Severe Record rejected sequential order completed in sequential order Femoral Component 23 1 The value in this field is not found in Value not found in database Severe Record rejected Manufacturer H and K the manufacturer table 23 2 For each sticker present if Missing value manufacturer is missing Femoral Component 24 1 Field contains invalid value Invalid value Severe Record rejected ee i Other 24 2 Length of field exceeded Out of range 24 3 If option OTH is selected and details Manufacturer Other and details are are missing missing 24 4 Manufacturer not OTH but Manufacturer Other must be blank if manufacturer Other populated Other is not selected Femoral Component 25 1 Field contains invalid value Invalid value Severe Record rejected Product hand K 25 2 Length of field exceeded Out of range 25 3 For each sticker present if product Missing value number is missing cont d on next page 9L0Z SLOZ enue jes BJEG WNWIUIN Aysi Boy Juewssejdey juior ueipeueo gg Ke ol Data Element Name Error Number Error Condition Error Message Error Type System Action Femoral Component 26 1 Field contai
66. r component sticker information and any acetabular component stickers must be blank for this type of are present primary procedure Diagnosis Grouping 21 1 If Record Type is K and Type of Invalid value Severe Record rejected primary procedures Replacement is equal to 1 and this field only H and K does not have a valid value from the list of valid values 21 2 If Record Type is H and Type of Invalid value Replacement is equal to 1 and this field does not have a valid value from the list of valid values 21 3 If Type of Replacement is 1 and this Missing value field is blank 21 4 If Type of Replacement is 2 and this Invalid combination field is populated 21 5 The field contains an invalid value Invalid value cont d on next page HE 9p090q 1043 YYPO 3 X puaddy v6 Data Element Name Error Number Error Condition Error Message Error Type System Action Reason for Revision 22 1 If Record Type is K and Type of Invalid value Severe Record rejected revision procedures Replacement is equal to 2 and this field only H and K does not have a valid value from the list of valid values 22 2 If Record Type is H and Type of Invalid value Replacement is equal to 2 and this field does not have a valid value from the list of valid values 22 3 If Type of Replacement is 2 and this Missing value field is blank 22 4 If Type of Replacement is 1 and this Invalid combination field is po
67. rocedures Only Specifications Field Length 2 alphanumeric characters Field Status Mandatory if Type of Replacement 1 Valid Data Knee 1 6 ZZ Hip 1 5 7 9 ZZ Joint Type Knee and hip Definition The Diagnosis Grouping field indicates the patients most responsible diagnosis grouping as determined post operatively for the involved joint The Diagnosis Grouping codes for knee and hip procedures are the following Code Description Joint Type 1 Degenerative arthritis e g OA Knee and hip 2 Inflammatory arthritis e g RA AS SLE Knee and hip 3 Osteonecrosis e g AVN Knee and hip 4 Infection Knee and hip 5 Tumour primary and metastatic including synovial Knee and hip 6 Fracture femur or tibia Knee 7 Acute hip fracture femur Hip 8 Childhood hip problem e g hip dysplasia Hip 9 Old hip fracture e g non union hardware failure Hip ZZ Other Knee and hip Example The patient s most responsible diagnosis for a primary hip replacement was an acute hip fracture Type of Diagnosis Replacement Grouping Example The patient had a revision procedure Type of Diagnosis Replacement Grouping 2 I Field 22 Reason for Revision Revision Procedures Only Specifications Chapter 5 General Procedure Information I Field Length 3 alphanumeric characters Field Status Mandatory if Type of Replacement 2 Valid Data Knee 1 13 OTH Hip 1 8 11 12 1
68. sent if product Missing value number is missing Patellar Component 62 1 Field contains invalid value Invalid value Severe Record rejected Lot K 62 2 Length of field exceeded Out of range 62 3 For each sticker present if lot number Missing value is missing Cement sticker information l If stickers are not completed in Cement stickers must be completed in Severe Record rejected sequential order sequential order Cement Details 71 1 Cement code does not exist in the Value not found in database Severe Record rejected Name H and K cement table 71 2 For each sticker present if name Missing value is missing cont d on next page EE 2p02 q 1043 YYPO 3 xipueddy 001 Data Element Name Error Number Error Condition Error Message Error Type System Action Cement Details 72 1 Field contains invalid value Invalid value Severe Record rejected en 2 72 2 Length of field exceeded Out of range 72 3 If option OTH is selected and details Cement name is Other and details are are missing missing 72 4 Cement not OTH but cement Other Cement name Other must be blank if populated Other is not selected Cement Details 73 1 Field contains invalid value Invalid value Severe Record rejected add onde 73 2 Length of field exceeded Out of range 73 3 For each sticker present if product Missing value number is missing Cement Details 74 1 Field contains invalid value Invalid value Se
69. sion Type 5 1 Field is blank Missing value Severe Record rejected H and K 5 2 Invalid value Invalid value Surgeon ID H and K 6 1 Field is blank Missing value Severe Record rejected 6 2 Surgeon ID not found in database Value not found in database 6 3 If submission type is U and Surgeon ID Surgeon ID cannot be updated is not the same cont d on next page EE 9p090q 1043 YYPO 3 xipueddy 06 Data Element Name Error Number Error Condition Error Message Error Type System Action Surgeon Last Name 7 1 Surgeon last name not found Value not found in database Severe Record rejected Hand K in database 7 2 Field is blank Missing value 7 3 Surgeon last name and surgeon ID do Surgeon last name and surgeon ID do not match not match Patient First Name 8 1 Field is blank Missing value Severe Record rejected H and K 8 2 Field length is outside range Out of range 8 3 Invalid format Invalid value 8 4 If submission type is U and patient Record type is U but patient values do information does not match database not match database Patient Last Name 9 1 Field is blank Missing value Severe Record rejected H and K 9 2 Field length is outside range Out of range 9 3 Invalid format Invalid value 9 4 If submission type is U and patient Record type is U but patient values do information does not match database not match database Health Card Issuing 10 1 Code is invalid Invalid value
70. sthesis Information Hi Chapter 6 Knee Replacement Prosthesis Information General Information Knee replacement prosthesis information is gathered from the manufacturer s sticker for each component replaced If a sticker is present all of the following elements must be entered manufacturer product number and lot number A maximum of three stickers for each component and two stickers for cement may be entered Refer to Appendix A for the corresponding component prosthesis information required for each type of primary procedure and to Appendix B for a reference guide on categorizing implant components As of April 2013 the CURR electronic file submission and Web Based Data Submission and Reports Tool systems were modified to accept product and lot numbers for implant components and cement that have been scanned directly from barcodes The CURR system is still able to accept manually entered implant information when scanning barcodes is not an option Refer to Appendix C for detailed instructions for both methods of data entry Note that CJRR does not require sticker information for sundry pieces involved in knee replacements including augments centralizers rings tapers and cages Please contact CJRR if further details are required W Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Fields 23 27 31 Femoral Component Manufacturer Specifications Field Length 3 alphanumeric characters Fi
71. tal code details are the following Province Territory Value Details NL Starts with A PE Starts with C NS Starts with B NB Starts with E Qc Starts with G H J ON Starts with K L M N P MB Starts with R SK Starts with S AB Starts with T BC Starts with V YT Starts with Y NT Starts with XOE X1A X0G NU Starts with XOA XOB X0C Note If the patient does not have a postal code if the postal code is unknown or if the patient has an international postal code record Patient Postal Code as Z9Z9Z9 If the postal code is incomplete that is in format Z9Z9Z Z9Z9 Z9Z a non severe error warning will be issued Refer to Appendix E for details Example The patient s postal code is V6T 5A9 Patient Postal Code vjeft s a o Z 9 Z 9 Z 9 Chapter 4 Patient Demographics I Field 15 Hospital Institution Number Electronic File Submission Only Specifications Field Length 5 alphanumeric characters Field Status Mandatory Valid Data A Z 0 9 Joint Type Knee and hip Definition The Hospital Institution Number is a unique number that identifies the institution where the joint replacement was performed The first digit specifies the provincelterritory The province territory codes are as follows Province Territory Code NL 0 PE 1 NS NB QC T ON SK AB BC YT NT NU lt Z lt o mb
72. than the value under the barcode Do not modify the scanned output French keyboard users In place of the leading scanned output will lead with a cedilla either or C 85 Appendix D Deleting and Correcting CJRR Records Hi Appendix D Deleting and Correcting CJRR Records When communicating with CJRR about specific records do not send personal health information PHI via email or fax as these are not secure methods of data transmission To delete a patient or procedure record or to update existing patient information contact CURR by email cjrr cihi ca and provide the information listed below 1 For the CURR Web Based Data Submission and Reports Tool a To delete a patient provide this information Surgeon_patient_id Surgeon name b To delete a procedure provide this information Joint_replacement_id Surgery date Surgeon_patient_id c To correct existing patient information follow this process Contact CJRR by email cjrr cihi ca for specific instructions Do not send PHI via email or fax 2 For electronic file submission a To delete a patient follow this process Contact CJRR by email cjrr cihi ca for specific instructions Do not send PHI via email or fax b To delete a procedure provide this information Record_id Surgery date Joint type Side location Type of replacement Surgeon_id c To correct existing patient information follow this process
73. umber Specifications Field Length 60 alphanumeric characters Field Status Applicable only if femoral head was used Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla Joint Type Hip Definition The Femoral Head Lot Number field indicates the lot number of the femoral head used for the procedure This includes bipolar heads bipolar liners and bipolar cups shells for hemiarthroplasties HM Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 Fields 47 51 55 Acetabular Component Manufacturer Specifications Field Length 3 alphanumeric characters Field Status Applicable only if acetabular component was used Valid Data 1 11 OTH Joint Type Hip Definition The Acetabular Component Manufacturer field indicates the manufacturer of the acetabular component used for the procedure The Acetabular Component Manufacturer codes are the following Code Description 1 Biomet Ceraver DePuy Finsbury J amp J Zimmer Sulzer Centerpulse MicroPort Wright Medical Smith amp Nephew Stryker Osteonics Howmedica Medacta International Link Corin oe COIN OD oO AJOJN Tecres Medical Other O per I Chapter 7 Hip Replacement Prosthesis Informat
74. urer lel Tibial Component Manufacturer Other LEITT Example The patient s knee replacement used a tibial component made by the manufacturer ABC Manufacturer Tibial Component Manufacturer o t H Tibial Component Manufacturer Other Talslel IMJAINIUIETAIGITIUIRIEIR Chapter 6 Knee Replacement Prosthesis Information Hi Fields 37 41 45 Tibial Component Product Number Field Length 60 alphanumeric characters Field Status Applicable only if tibial component was used Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla Joint Type Knee Definition The Tibial Component Product Number field indicates the product reference catalogue or other number of the tibial component used for the procedure This includes all poly tibias Fields 38 42 46 Tibial Component Lot Number Field Length 60 alphanumeric characters Field Status Applicable only if tibial component was used Valid Data 0 9 A Z underscore _ space hyphen period apostrophe percent sign ampersand amp plus sign forward slash dollar sign right square bracket cedilla Joint Type Knee Definition The Tibial Component Lot Number field indicates the lot number of the tibial component used
75. vere Record rejected Lot H and K 74 2 Length of field exceeded Out of range 74 3 For each sticker present if lot number Missing value is missing 9LOZ GLOZ Jenue as ejeq UWNUIUIN AnsIBoy Jusweselday juIof ueipeueg m Appendix F MOD 10 Calculation Hi Appendix F MOD 10 Calculation MOD 10 Calculation Add together these values Rightmost digit of HCN excluding the check digit times 2 Next rightmost digit of HCN excluding the check digit times 1 Next rightmost digit of HCN excluding the check digit times 2 Next rightmost digit of HCN excluding the check digit times 1 Next rightmost digit of HCN excluding the check digit times 2 Next rightmost digit of HCN excluding the check digit times 1 Next rightmost digit of HCN excluding the check digit times 2 Next rightmost digit of HCN excluding the check digit times 1 Next rightmost digit of HCN excluding the check digit times 2 And so on until all digits are accounted for Where the result of the multiplication is more than 1 digit add the digits together Add the results of each multiplication together Divide the total by 10 giving a remainder The check digit of the HCN must 10 the remainder Production of this document is made possible by financial contributions from Health Canada and provincial and territorial governments The views expressed herein
76. y joint prosthesis or mould FR T te bipolaire et cupule bipolaire T te f morale t te sph rique Proth se de resurfa age T te f morale pr fabriqu e moule ou dispositif d espacement en ciment T te f morale pr fabriqu e moule ou spacer en ciment Acetabular component Composant ac tabulaire EN Acetabular component acetabular shell acetabular cup hemispherical shell Cluster acetabular shell Monoblock acetabular cup one piece cup All polyethylene acetabular cup Prefabricated acetabular component cement spacer temporary joint prosthesis or mould FR Composant ac tabulaire Cotyle cotyle en poly thyl ne Proth se cotyloidienne Proth se de cupule ac tabulaire Cupule h misph rique Coque ac tabulaire Renfort ac tabulaire Composant ac tabulaire pr fabriqu moule ou dispositif d espacement en ciment Composant ac tabulaire pr fabriqu moule ou spacer en ciment cont d on next page EEE Canadian Joint Replacement Registry Minimum Data Set Manual 2015 2016 HIP HANCHE cont d Acetabular liner insert Insert ac tabulaire EN Acetabular liner acetabular insert Polyethylene metal ceramic insert FR Noyau noyau en poly thyl ne Insert insert ac tabulaire Insert en poly thyl ne m tal c ramique KNEE GENOU Femoral component Composant f moral EN Femoral component Trochlear component Femoral stem modular femoral stem

CJRR Minimum Data Set Manual, 2015–2016

Contents

Download Pdf Manuals

Related Search

Related Contents

CJRR Minimum Data Set Manual, 2015&ndash;2016

Contents

Download Pdf Manuals

Related Search

Related Contents

CJRR Minimum Data Set Manual, 2015–2016