Module: derived

Module Contents

  1. d_MSI_IHC


1PERSON_IDstring (12)Required:TRUE
Number that Uniquely Identifies an Individual.

2IHC_STATUS_PERSONnumber (1,0)Required:TRUE
IHC status of person tested.

Considers IHC results only for colon cancer tumor types. Excludes all other malignancies, adenomas, metastases and in situ carcinomas. Does not restrict to qualifying tumors.
If at least one test is abnormal, then IHC_STATUS_PERSON is abnormal. If there are no abnormal results and at least one normal result, then IHC_STATUS_PERSON is normal.
Colon cancer is defined by ICDO3 site codes C180, C181, C182, C183, C184, C185, C186, C187, C188, C189, C199, C209, C218, C260, and a malignant tumor (BEHAV=3).
On 1/4/2008 the SITE codes used in deriving this variable were expanded to include C218 and C260.
Allowable Values
-8 No data transmitted from centers
-7 NA/Out of scope: Individual has IHC record, but no markers having values 0,1,2, or 4.
1 Normal MMR protein expression
2 Absence of MMR protein expression


3MSI_STATUS_PERSONnumber (1,0)Required:TRUE
MSI status of person tested.

Considers MSI results only for colon cancer tumor types. Excludes all other malignancies, adenomas, metastases and in situ carcinomas. Does not restrict to qualifying tumors.
If at least one MSI_STATUS_TISSUE result is high, then MSI_STATUS_PERSON is high. If no MSI_STATUS_TISSUE result is high but at least one is low, then MSI_STATUS_PERSON is low. If no MSI_STATUS_TISSUE results are high or low, but at least one is stable, then MSI_STATUS_PERSON is stable.
Colon cancer is defined by ICDO3 site codes C180, C181, C182, C183, C184, C185, C186, C187, C188, C189, C199, C209, C218, C260, and a malignant tumor (BEHAV=3).
On 1/4/2008 the SITE codes used in deriving this variable were expanded to include C218 and C260.
Allowable Values
-8 No data transmitted from centers
-7 NA/Out of scope - An MSI record, but no Stable, Low, or High tissue-level result recorded.
1 Stable - No High or Low tissue-level results, but at least one Stable.
2 Low - No High tissue-level results, but at least one Low.
3 High - At least one High tissue-level result


4MSIIHC_STATUS_PERSONnumber (1,0)Required:TRUE
MMR status for person tested.

Considers MSI and IHC results only for colon cancer tumor types. Excludes all other malignancies, adenomas, metastases and in situ carcinomas. Does not restrict to qualifying tumors.
MSIIHC_STATUS_PERSON has a value for each each tissue that has an MSI and/or IHC result within a given block.
MSIIHC_STATUS_PERSON is defective 2 if MSI_STATUS_PERSON is High and IHC_STATUS_PERSON is Abnormal.
MSIIHC_STATUS_PERSON is defective 1 if it does not qualify as defective 2 and MSI_STATUS_PERSON is High or IHC_STATUS_PERSON is Abnormal.
MSIIHC_STATUS_PERSON is proficient 2 if MSI_STATUS_PERSON is Stable or Low and IHC_STATUS_PERSON is Normal.
MSIIHC_STATUS_PERSON is proficient 1 if it does not qualify as proficient 2 or as defective, and MSI_STATUS_PERSON is Stable or Low or IHC_STATUS_PERSON is Normal.
MSIIHC_STATUS_PERSON otherwise equals -7, corresponding to both MSI_STATUS_PERSON and IHC_STATUS_PERSON equaling -7 or one them equaling -7 with no record available to merge to on the other table.
Allowable Values
-8 No data transmitted from centers
-7 NA/Out of Scope - Both source variables out of scope
1 Proficient MMR 1
2 Proficient MMR 2
3 Defective MMR 1
4 Defective MMR 2