|
Name |
Type |
Discontinued? |
|
| 1 |
STAGE_ID |
NUMERIC |
No |
|
|
|
| The cancer stage (STG) row ID. |
|
|
| 2 |
CONTACT_DATE_REAL |
FLOAT |
No |
|
|
|
| A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc. |
|
|
| 3 |
CONTACT_DATE |
DATETIME |
No |
|
|
|
| The date of this contact in calendar format. |
|
|
| 4 |
CM_CT_OWNER_ID |
VARCHAR |
No |
|
|
|
| The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect. |
|
|
| 5 |
STG_CSN |
NUMERIC |
No |
|
|
|
| A unique serial number for this contact. This number is unique across all stage (STG) contacts in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI). |
|
|
| 6 |
CONTACT_NUM |
INTEGER |
No |
|
|
|
| A sequential number to identify this contact uniquely within the cancer stage (STG) row. The first contact is number 1, the second is number 2, etc. |
|
|
| 7 |
STAGE_EDIT_DATETIME |
DATETIME (Local) |
No |
|
|
|
| The instant this contact was created. |
|
|
| 8 |
STAGE_EDIT_USR_ID |
VARCHAR |
No |
|
|
|
| The user ID of the person who created this contact. |
|
|
| 9 |
STAGE_EDIT_USR_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 10 |
LATERALITY_C_NAME |
VARCHAR |
No |
|
|
|
| A category value indicating the laterality (left, right, or both) of the cancer being staged, for a disease such as lung cancer or breast cancer which might affect one or both sides of the body. This column should be empty for a disease such as colon cancer which can only affect one area of the body. |
| May contain organization-specific values: No |
| Category Entries: |
| None |
| Left |
| Right |
| Bilateral |
| Midline |
| Contralateral |
| Ipsilateral |
| Overlapping |
| Not applicable |
| Unknown |
|
|
| 11 |
TUMOR_SIZE_MM |
NUMERIC |
No |
|
|
|
| The size of the primary tumor. This value is always stored in millimeters, although the user may choose to display this value in centimeters instead. |
|
|
| 12 |
TUM_SIZ_DISP_UNIT_C_NAME |
VARCHAR |
No |
|
|
|
| The preferred unit of measurement (millimeters or centimeters) to use when displaying the primary tumor size for this contact of the cancer stage record. |
| May contain organization-specific values: No |
| Category Entries: |
| Millimeters |
| Centimeters |
|
|
| 13 |
STG_SPECMN_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| A category value indicating the type of specimen that was collected to analyze the tumor. |
| May contain organization-specific values: Yes |
|
|
| 14 |
HISTOPATH_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| A category value indicating the histopathologic type of the patient's cancer. |
| May contain organization-specific values: Yes |
|
|
| 15 |
PATH_NODES_EXAM |
INTEGER |
No |
|
|
|
| The number of regional lymph nodes examined for pathologic staging. |
|
|
| 16 |
PATH_POS_NODES |
INTEGER |
No |
|
|
|
| The number of regional lymph nodes that tested positive for cancer for pathologic staging. |
|
|
| 17 |
CLIN_NODES_EXAM |
INTEGER |
No |
|
|
|
| The number of regional lymph nodes examined for clinical staging. |
|
|
| 18 |
CLIN_POS_NODES |
INTEGER |
No |
|
|
|
| The number of regional lymph nodes that tested positive for cancer for clinical staging. |
|
|
| 19 |
PATH_CEA_LVL |
NUMERIC |
No |
|
|
|
| The patient's carcinoembryonic antigen (CEA) level, in ng/mL, entered as part of the pathologic stage for an incidence of colorectal cancer. |
|
|
| 20 |
CLIN_CEA_LVL |
NUMERIC |
No |
|
|
|
| The patient's carcinoembryonic antigen (CEA) level, in ng/mL, entered as part of the clinical stage for an incidence of colorectal cancer. |
|
|
| 21 |
PATH_PSA_LVL |
NUMERIC |
No |
|
|
|
| The patient's prostate-specific antigen (PSA) level, in ng/mL, entered as part of the pathologic stage for an incidence of prostate cancer. |
|
|
| 22 |
PATH_PRIM_GLEASON |
INTEGER |
No |
|
|
|
| The primary Gleason pattern (1-5), entered as part of the pathologic stage for an incidence of prostate cancer. |
|
|
| 23 |
PATH_SEC_GLEASON |
INTEGER |
No |
|
|
|
| The secondary Gleason pattern (1-5), entered as part of the pathologic stage for an incidence of prostate cancer. |
|
|
| 24 |
CLIN_PSA_LVL |
NUMERIC |
No |
|
|
|
| The patient's prostate-specific antigen (PSA) level, in ng/mL, entered as part of the clinical stage for an incidence of prostate cancer. |
|
|
| 25 |
CLIN_PRIM_GLEASON |
INTEGER |
No |
|
|
|
| The primary Gleason pattern (1-5), entered as part of the clinical stage for an incidence of prostate cancer. |
|
|
| 26 |
CLIN_SEC_GLEASON |
INTEGER |
No |
|
|
|
| The secondary Gleason pattern (1-5), entered as part of the clinical stage for an incidence of prostate cancer. |
|
|
| 27 |
PATH_FIBROSIS_SCORE |
INTEGER |
No |
|
|
|
| A numeric score (0-6) indicating the severity of fibrosis, entered as part of the pathologic stage for an incidence of liver cancer. |
|
|
| 28 |
PATH_FIBROSIS_C_NAME |
VARCHAR |
No |
|
|
|
| A code value (0 meaning "F0", or 1 meaning "F1") indicating the severity of fibrosis, entered as part of the pathologic stage for an incidence of liver cancer. F0 corresponds to a fibrosis score of 0 to 4, while F1 corresponds to a score of 5 or 6. |
| May contain organization-specific values: No |
| Category Entries: |
| F0 - Fibrosis score 0-4 (none to moderate fibrosis) |
| F1 - Fibrosis score 5-6 (severe fibrosis or cirrhosis) |
|
|
| 29 |
CLIN_FIBROSIS_SCORE |
INTEGER |
No |
|
|
|
| A numeric score (0-6) indicating the severity of fibrosis, entered as part of the clinical stage for an incidence of liver cancer. |
|
|
| 30 |
CLIN_FIBROSIS_C_NAME |
VARCHAR |
No |
|
|
|
| A code value (0 meaning "F0", or 1 meaning "F1") indicating the severity of fibrosis, entered as part of the clinical stage for an incidence of liver cancer. F0 corresponds to a fibrosis score of 0 to 4, while F1 corresponds to a score of 5 or 6. |
| The category values for this column were already listed for column: PATH_FIBROSIS_C_NAME |
|
|
| 31 |
PATH_VISUAL_ACUITY |
VARCHAR |
No |
|
|
|
| A description of the patient's visual acuity, using Snellen shorthand or an equivalent system, entered as part of the pathologic stage for a malignant melanoma of the uvea. |
|
|
| 32 |
CLIN_VISUAL_ACUITY |
VARCHAR |
No |
|
|
|
| A description of the patient's visual acuity, using Snellen shorthand or an equivalent system, entered as part of the clinical stage for a malignant melanoma of the uvea. |
|
|
| 33 |
PATH_METS_BIOPSY_YN |
VARCHAR |
No |
|
|
|
| Yes/no flag indicating whether a biopsy of the metastatic site was taken in conjunction with the pathologic stage. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 34 |
PATH_METS_SPEC_C_NAME |
VARCHAR |
No |
|
|
|
| A category value specifying the source of the metastatic specimen taken in conjunction with the pathologic stage (if any). |
| May contain organization-specific values: Yes |
|
|
| 35 |
CLIN_METS_BIOPSY_YN |
VARCHAR |
No |
|
|
|
| Yes/no flag indicating whether a biopsy of the metastatic site was taken in conjunction with the clinical stage. |
| The category values for this column were already listed for column: PATH_METS_BIOPSY_YN |
|
|
| 36 |
CLIN_METS_SPEC_C_NAME |
VARCHAR |
No |
|
|
|
| A category value specifying the source of the metastatic specimen taken in conjunction with the clinical stage (if any). |
| The category values for this column were already listed for column: PATH_METS_SPEC_C_NAME |
|
|
| 37 |
OT_AJCC_CLIN_STG_C_NAME |
VARCHAR |
No |
|
|
|
| The AJCC clinical stage grouping for this contact. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Stage I |
| Stage I NOS |
| Stage IA |
| Stage IA1 |
| Stage IA2 |
| Stage IB |
| Stage IB1 |
| Stage IB2 |
| Stage IC |
| Stage IS |
| Stage IEA |
| Stage IEB |
| Stage IE |
| Stage ISA |
| Stage ISB |
| Stage IC1 |
| Stage IC2 |
| Stage IC3 |
| Stage II |
| Stage II NOS |
| Stage IIA |
| Stage IIB |
| Stage IIC |
| Stage IIEA |
| Stage IIEB |
| Stage IIE |
| Stage IISA |
| Stage IISB |
| Stage IIS |
| Stage IIESA |
| Stage IIESB |
| Stage IIES |
| Stage IIA1 |
| Stage IIA2 |
| Stage II bulky |
| Stage III |
| Stage III NOS |
| Stage IIIA |
| Stage IIIB |
| Stage IIIC |
| Stage IIIEA |
| Stage IIIEB |
| Stage IIIE |
| Stage IIISA |
| Stage IIISB |
| Stage IIIS |
| Stage IIIESA |
| Stage IIIESB |
| Stage IIIES |
| Stage IIIC1 |
| Stage IIIC2 |
| Stage IIID |
| Stage IV |
| Stage IV NOS |
| Stage IVA |
| Stage IVB |
| Stage IVC |
| Stage IVA1 |
| Stage IVA2 |
| Stage IVS |
| Not Applicable |
| No Stage Recommended |
| Occult carcinoma |
| Stage Unknown |
| Stage IA3 |
| Stage IB3 |
| Stage IIIA(i) |
| Stage IIIA(ii) |
| Stage IIIA1 |
| Stage IIIA1(i) |
| Stage IIIA1(ii) |
| Stage IIIA2 |
| Stage IIIB(i) |
| Stage IIIB(ii) |
| Stage IIICr |
| Stage IIICp |
| Stage IIIC1r |
| Stage IIIC1p |
| Stage IIIC2r |
| Stage IIIC2p |
| Stage IVA(i) |
| Stage IVA(ii) |
| Stage V |
| Stage IIIB1 |
| Stage IIIB2 |
| Stage IIIC1i |
| Stage IIIC1ii |
| Stage IIIC2i |
| Stage IIIC2ii |
| Stage A |
| Stage B |
| Stage C |
| Recurrent - Initial Stage Unknown |
| Stage 0 |
| Stage 0a |
| Stage 0is |
|
|
| 38 |
OT_CLIN_MULT_TUM_YN |
VARCHAR |
No |
|
|
|
| Yes/no flag indicating whether the clinical stage was documented based on the presence of multiple primary tumors. |
| The category values for this column were already listed for column: PATH_METS_BIOPSY_YN |
|
|
| 39 |
OT_AJCC_CLIN_T_C_NAME |
VARCHAR |
No |
|
|
|
| The AJCC primary tumor (T) assessment for this contact of the clinical stage. |
| May contain organization-specific values: Yes |
| Category Entries: |
| T1 |
| T1mic |
| T1a |
| T1a1 |
| T1a2 |
| T1b |
| T1b1 |
| T1b2 |
| T1c |
| T1 NOS |
| T2 |
| T2a |
| T2b |
| T2c |
| T2d |
| T2a1 |
| T2a2 |
| T2 NOS |
| T3 |
| T3a |
| T3b |
| T3c |
| T3d |
| T3 NOS |
| T4 |
| T4a |
| T4b |
| T4c |
| T4d |
| T4e |
| T4 NOS |
| T1d |
| Not applicable |
| TX |
| T1c1 |
| T1c2 |
| T1c3 |
| T3a1 |
| T3a2 |
| cT |
| pT |
| pT0 |
| pTis |
| pT1 |
| pT1a |
| pT1b |
| pT1c |
| pT2 |
| pT2a |
| pT2b |
| pT2c |
| pT3 |
| pT3a |
| pT3b |
| pT4 |
| pT4a |
| pT4b |
| pTX |
| cT0 |
| cTa |
| cTis |
| cTis (DCIS) |
| cTis (LCIS) |
| cTis (Paget) |
| cTis (LAMN) |
| cTispu |
| cTispd |
| cT1 |
| cT1mi |
| cT1a |
| cT1a1 |
| cT1a2 |
| cT1b |
| cT1b1 |
| cT1b2 |
| cT1b3 |
| cT1c |
| cT1c1 |
| cT1c2 |
| cT1c3 |
| cT1d |
| cT1 NOS |
| cT2 |
| cT2a |
| cT2a1 |
| cT2a2 |
| cT2b |
| cT2c |
| cT2d |
| cT2 NOS |
| cT3 |
| cT3a |
| cT3a1 |
| cT3a2 |
| cT3b |
| cT3c |
| cT3d |
| cT3e |
| cT3 NOS |
| cT4 |
| cT4a |
| cT4b |
| cT4c |
| cT4d |
| cT4e |
| cT4 NOS |
| cTX |
| pT0 |
| pTa |
| pTis |
| pTis (DCIS) |
| pTis (LCIS) |
| pTis (Paget) |
| pTis (LAMN) |
| pTispu |
| pTispd |
| pT1 |
| pT1mi |
| pT1a |
| pT1a1 |
| pT1a2 |
| pT1b |
| pT1b1 |
| pT1b2 |
| pT1b3 |
| pT1c |
| pT1c1 |
| pT1c2 |
| pT1c3 |
| pT1d |
| pT1 NOS |
| pT2 |
| pT2a |
| pT2a1 |
| pT2a2 |
| pT2b |
| pT2c |
| pT2d |
| pT2 NOS |
| pT3 |
| pT3a |
| pT3a1 |
| pT3a2 |
| pT3b |
| pT3c |
| pT3d |
| pT3e |
| pT3 NOS |
| pT4 |
| pT4a |
| pT4b |
| pT4c |
| pT4d |
| pT4e |
| pT4 NOS |
| pTX |
| T0 |
| Ta |
| Tis (DCIS) |
| Tis (LCIS) |
| Tis (Paget's) |
| Tis |
| Tispu |
| Tispd |
|
|
| 40 |
OT_AJCC_CLIN_N_C_NAME |
VARCHAR |
No |
|
|
|
| The AJCC regional lymph nodes (N) assessment for this contact of the clinical stage. |
| May contain organization-specific values: Yes |
| Category Entries: |
| N1 |
| N1a |
| N1b |
| N1c |
| N1mi |
| N1 NOS |
| N2 |
| N2a |
| N2b |
| N2c |
| N2 NOS |
| N3 |
| N3a |
| N3b |
| N3c |
| N3 NOS |
| N4 |
| Not applicable |
| NX |
| cN |
| pN |
| cN0 |
| cN1 |
| cN2 |
| cN3 |
| cNX |
| pN0 |
| pN0(i-) |
| pN0(i+) |
| pN0(mol-) |
| pN0(mol+) |
| pN1 |
| pN1a |
| pN1b |
| pN1c |
| pN1mi |
| pN2 |
| pN2a |
| pN2b |
| pN2c |
| pN3 |
| pN3a |
| pN3b |
| pN3c |
| pNX |
| cN0 |
| cN0(i-) |
| cN0(i+) |
| cN0(mol-) |
| cN0(mol+) |
| cN0a |
| cN0a (biopsy) |
| cN0b (no biopsy) |
| cN0b |
| cN0 NOS |
| cN1 |
| cN1mi |
| cN1a |
| cN1a(sn) |
| cN1b |
| cN1c |
| cN1 NOS |
| cN2 |
| cN2mi |
| cN2a |
| cN2b |
| cN2c |
| cN2 NOS |
| cN3 |
| cN3a |
| cN3b |
| cN3c |
| cN3 NOS |
| cN4 |
| cNX |
| pN0 |
| pN0(i-) |
| pN0(i+) |
| pN0(mol-) |
| pN0(mol+) |
| pN0a |
| pN0a (biopsy) |
| pN0b (no biopsy) |
| pN0b |
| pN0 NOS |
| pN1 |
| pN1mi |
| pN1a |
| pN1a(sn) |
| pN1b |
| pN1c |
| pN1 NOS |
| pN2 |
| pN2mi |
| pN2a |
| pN2b |
| pN2c |
| pN2 NOS |
| pN3 |
| pN3a |
| pN3b |
| pN3c |
| pN3 NOS |
| pN4 |
| pNX |
| N0 |
| N0(i-) |
| N0(i+) |
| N0(mol-) |
| N0(mol+) |
| N0a (biopsy) |
| N0b (no biopsy) |
| N0 NOS |
|
|
| 41 |
OT_AJCC_CLIN_M_C_NAME |
VARCHAR |
No |
|
|
|
| The AJCC distant metastasis (M) assessment for this contact of the clinical stage. |
| May contain organization-specific values: Yes |
| Category Entries: |
| M1 |
| M1a |
| M1b |
| M1c |
| M1d |
| M1e |
| M1 NOS |
| M2 |
| M3 |
| M3a |
| M3b |
| M4 |
| Not applicable |
| MX |
| cM0 |
| cM0(i+) |
| cM1 |
| cM1a |
| cM1a(0) |
| cM1a(1) |
| cM1b |
| cM1b(0) |
| cM1b(1) |
| cM1c |
| cM1c(0) |
| cM1c(1) |
| cM1c1 |
| cM1c2 |
| cM1d |
| cM1d(0) |
| cM1d(1) |
| cM1e |
| cM1 NOS |
| pM1 |
| pM1a |
| pM1a(0) |
| pM1a(1) |
| pM1b |
| pM1b(0) |
| pM1b(1) |
| pM1c |
| pM1c(0) |
| pM1c(1) |
| pM1c1 |
| pM1c2 |
| pM1d |
| pM1d(0) |
| pM1d(1) |
| pM1e |
| pM1 NOS |
| M0 |
|
|
| 42 |
OT_AJCC_CLIN_G_C_NAME |
VARCHAR |
No |
|
|
|
| The AJCC histologic grade (G) assessment for this contact of the clinical stage. |
| May contain organization-specific values: Yes |
| Category Entries: |
| G0 |
| G1 |
| G2 |
| G3 |
| G4 |
| T-cell |
| B-cell |
| Null Cell |
| NK (natural killer) cell |
| G1-G2 |
| G2-G3 |
| G3a |
| G3b |
| G3-G4 |
| Gleason <= 6 |
| Gleason 7 |
| Gleason 8-10 |
| Gleason X |
| Low grade |
| High grade |
| GB |
| GX |
| No grade assigned |
| Not applicable |
|
|
| 43 |
OT_AJCC_CLIN_SER_C_NAME |
VARCHAR |
No |
|
|
|
| The AJCC serum tumor markers (S) assessment for this contact of the clinical stage. |
| May contain organization-specific values: Yes |
| Category Entries: |
| S1 |
| S2 |
| S3 |
| SX |
| S0 |
|
|
| 44 |
OT_AJCC_CLIN_RISK_C_NAME |
VARCHAR |
No |
|
|
|
| The AJCC risk factors assessment for this contact of the clinical stage. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Low risk |
| High risk |
| Unknown |
|
|
| 45 |
OT_FIGO_CLIN_STG_C_NAME |
VARCHAR |
No |
|
|
|
| The clinical FIGO stage for an incidence of gynecologic cancer. |
| The category values for this column were already listed for column: OT_AJCC_CLIN_STG_C_NAME |
|
|
| 46 |
OT_AJCC_PATH_STG_C_NAME |
VARCHAR |
No |
|
|
|
| The AJCC pathologic stage grouping for this contact. |
| The category values for this column were already listed for column: OT_AJCC_CLIN_STG_C_NAME |
|
|
| 47 |
OT_PATH_MULT_TUM_YN |
VARCHAR |
No |
|
|
|
| Yes/no flag indicating whether the pathologic stage was documented based on the presence of multiple primary tumors. |
| The category values for this column were already listed for column: PATH_METS_BIOPSY_YN |
|
|
| 48 |
OT_AJCC_PATH_T_C_NAME |
VARCHAR |
No |
|
|
|
| The AJCC primary tumor (T) assessment for this contact of the pathologic stage. |
| The category values for this column were already listed for column: OT_AJCC_CLIN_T_C_NAME |
|
|
| 49 |
OT_AJCC_PATH_N_C_NAME |
VARCHAR |
No |
|
|
|
| The AJCC regional lymph nodes (N) assessment for this contact of the pathologic stage. |
| The category values for this column were already listed for column: OT_AJCC_CLIN_N_C_NAME |
|
|
| 50 |
OT_AJCC_PATH_M_C_NAME |
VARCHAR |
No |
|
|
|
| The AJCC distant metastasis (M) assessment for this contact of the pathologic stage. |
| The category values for this column were already listed for column: OT_AJCC_CLIN_M_C_NAME |
|
|
| 51 |
OT_AJCC_PATH_G_C_NAME |
VARCHAR |
No |
|
|
|
| The AJCC histologic grade (G) assessment for this contact of the pathologic stage. |
| The category values for this column were already listed for column: OT_AJCC_CLIN_G_C_NAME |
|
|
| 52 |
OT_AJCC_PATH_SER_C_NAME |
VARCHAR |
No |
|
|
|
| The AJCC serum tumor markers (S) assessment for this contact of the pathologic stage. |
| The category values for this column were already listed for column: OT_AJCC_CLIN_SER_C_NAME |
|
|
| 53 |
OT_AJCC_PATH_RISK_C_NAME |
VARCHAR |
No |
|
|
|
| The AJCC risk factors assessment for this contact of the pathologic stage. |
| The category values for this column were already listed for column: OT_AJCC_CLIN_RISK_C_NAME |
|
|
| 54 |
OT_FIGO_PATH_STG_C_NAME |
VARCHAR |
No |
|
|
|
| The pathologic FIGO stage for an incidence of gynecologic cancer. |
| The category values for this column were already listed for column: OT_AJCC_CLIN_STG_C_NAME |
|
|
| 55 |
OT_AJCC_RESIDUAL_C_NAME |
VARCHAR |
No |
|
|
|
| The AJCC residual tumor (R) assessment for this contact of the pathologic stage. |
| May contain organization-specific values: Yes |
| Category Entries: |
| R0 - None |
| R1 - Microscopic |
| R2 - Macroscopic |
| RX - Cannot be assessed |
|
|
| 56 |
OT_AJCC_LV_INV_C_NAME |
VARCHAR |
No |
|
|
|
| The AJCC lymphatic vessel invasion (L) assessment for this contact of the pathologic stage. |
| May contain organization-specific values: Yes |
| Category Entries: |
| L0 - No lymphatic vessel invasion |
| L1 - Lymphatic vessel invasion |
| Not applicable |
| LX - Cannot be assessed |
| Lymph-Vascular Invasion Not Present (absent)/Not Identified |
| Lymph-Vascular Invasion Present/Identified |
| Unknown/Indeterminate |
|
|
| 57 |
OT_AJCC_VEN_INV_C_NAME |
VARCHAR |
No |
|
|
|
| The AJCC venous invasion (V) assessment for this contact of the pathologic stage. |
| May contain organization-specific values: Yes |
| Category Entries: |
| V0 - No venous invasion |
| V1 - Microscopic venous invasion |
| V2 - Macroscopic venous invasion |
| VX - Cannot be assessed |
|
|
| 58 |
OT_UNK_PRIM_SITE_YN |
VARCHAR |
No |
|
|
|
| Yes/no flag indicating whether the primary tumor site is uncertain and therefore can only be suspected. |
| The category values for this column were already listed for column: PATH_METS_BIOPSY_YN |
|
|
| 59 |
OT_CLIN_STAGE_STS_C_NAME |
VARCHAR |
No |
|
|
|
| The status of the clinical stage on this contact. |
| May contain organization-specific values: No |
| Category Entries: |
| New |
| Assigned |
| Started |
| Complete |
| Reopened |
| Redone |
|
|
| 60 |
OT_CLIN_SIGN_USR_ID |
VARCHAR |
No |
|
|
|
| The user ID of the person who signed the clinical stage. |
|
|
| 61 |
OT_CLIN_SIGN_USR_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 62 |
OT_CLIN_SIGN_DTTM |
DATETIME (Attached) |
No |
|
|
|
| The instant at which the clinical stage was signed. |
|
|
| 63 |
OT_PATH_STAGE_STS_C_NAME |
VARCHAR |
No |
|
|
|
| The status of the pathologic stage on this contact. |
| The category values for this column were already listed for column: OT_CLIN_STAGE_STS_C_NAME |
|
|
| 64 |
OT_PATH_SIGN_USR_ID |
VARCHAR |
No |
|
|
|
| The user ID of the person who signed the pathologic stage. |
|
|
| 65 |
OT_PATH_SIGN_USR_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 66 |
OT_PATH_SIGN_DTTM |
DATETIME (Attached) |
No |
|
|
|
| The instant at which the pathologic stage was signed. |
|
|
| 67 |
STAGE_EPT_ENC_DAT |
VARCHAR |
No |
|
|
|
| Stores the contact date (DAT) of the patient (EPT) contact in which this STG contact was edited. Set to 99999 if the stage is edited in a patient chart outside of an encounter. |
|
|
| 68 |
STAGE_EPT_ENC_CSN |
NUMERIC |
No |
|
|
|
| Stores the contact serial number (CSN) of the patient encounter in which this stage contact was edited. Empty if the stage is edited in a patient chart outside of an encounter. |
|
|
| 69 |
STAGE_ENC_DEPT_ID_EXTERNAL_NAME |
VARCHAR |
No |
|
|
|
| The external name of the department record. This is often used in patient correspondence such as reminder letters. |
|
|
| 70 |
STAGE_LOGIN_DEPT_ID_EXTERNAL_NAME |
VARCHAR |
No |
|
|
|
| The external name of the department record. This is often used in patient correspondence such as reminder letters. |
|
|
| 71 |
STG_DEF_ID_STG_DEF_NAME |
VARCHAR |
No |
|
|
|
| The name of the FCS record containing the Cancer Staging Definitions for a kind of cancer to be staged. |
|
|
| 72 |
STG_DEF_DAT |
NUMERIC |
No |
|
|
|
| Contact date of the cancer staging form (FCS) contact for the staging form that was used when entering the cancer staging information in this contact. |
|
|
| 73 |
STG_DEF_CSN |
NUMERIC |
No |
|
|
|
| Contact serial number of the cancer staging form (FCS) contact for the staging form that was used when entering the cancer staging information in this contact. |
|
|
| 74 |
DX_CONFIRM_C_NAME |
VARCHAR |
No |
|
|
|
| Indicates the best method used to confirm the presence of a patient's cancer being reported to a cancer registry. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Positive histology |
| Positive cytology, no positive histology |
| Positive histology PLUS positive immunophenotyping and/or positive genetic studies |
| Positive microscopic confirmation, method not specified |
| Positive laboratory test/marker study |
| Direct visualization without microscopic confirmation |
| Radiography and other imaging techniques without microscopic confirmation |
| Clinical diagnosis only (other than 5, 6, or 7) |
| Unknown whether or not microscopically confirmed (e.g., death certificate only) |
|
|
| 75 |
CLIN_STAGED_BY_C_NAME |
VARCHAR |
No |
|
|
|
| Indicates the person or people who assigned the AJCC staging elements and stage group when staging a patient's cancer diagnosis. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Not Staged |
| Managing physician |
| Pathologist |
| Pathologist and managing physician |
| Cancer Committee chair, cancer liaison physician, or registry physician advisor |
| Cancer registrar |
| Cancer registrar and physician |
| Staging assigned at another facility |
| Case is not eligible for staging |
| Unknown; not stated in patient's record |
|
|
| 76 |
STAGING_DATE |
DATETIME |
No |
|
|
|
| Allows the user to specify a date associated with the staging information being entered. |
|
|
| 77 |
BODY_SITE_C_NAME |
VARCHAR |
No |
|
|
|
| Stores the calculated or user-selected body site of this cancer stage. |
| May contain organization-specific values: Yes |
|
|
| 78 |
STAGE_FORM_METHOD_C_NAME |
VARCHAR |
No |
|
|
|
| Stores the method or version of the staging form used to document this stage. |
| May contain organization-specific values: Yes |
| Category Entries: |
| AJCC 6th Edition |
| AJCC 7th Edition |
| AJCC 8th Edition |
| AJCC Version 9 |
| Pediatric |
|
|
| 79 |
CLASSIFICATION_C_NAME |
VARCHAR |
No |
|
|
|
| Stores the specific classification (clinical, pathologic, etc.) of this stage. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Clinical |
| Pathologic |
|
|
| 80 |
DATA_MODEL_VER_C_NAME |
VARCHAR |
No |
|
|
|
| Stores the version of this stage record's data model, used to indicate which items it uses in the Diagnosis Stage (STG) master file. |
| May contain organization-specific values: No |
| Category Entries: |
| Pre-2014 |
| 2014 Base |
|
|
| 81 |
STAGE_DATE |
DATETIME |
No |
|
|
|
| Stores the date associated with this stage. |
|
|
| 82 |
STAGE_GROUP |
VARCHAR |
No |
|
|
|
| Stores the stage group as an easily accessible string. This value is obtained from a SmartData element on the stage form. |
|
|
| 83 |
STAGE_DESC |
VARCHAR |
No |
|
|
|
| Stores a short description of this stage, typically including key values recorded by the user. |
|
|
| 84 |
STAGE_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
| Stores the status (unsigned, signed, deleted, etc.) of this stage. |
| May contain organization-specific values: No |
| Category Entries: |
| Unsigned |
| Signed |
| Deleted |
|
|
| 85 |
SIGN_USER_ID |
VARCHAR |
No |
|
|
|
| If signed, stores the user who signed this stage. |
|
|
| 86 |
SIGN_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 87 |
SIGN_DATETIME |
DATETIME (UTC) |
No |
|
|
|
| If signed, stores the instant in UTC that the stage was signed. |
|
|
| 88 |
STAGE_DT_FALLBACK_TO_CREATE_DT |
DATETIME |
No |
|
|
|
| Stores the user-entered stage date, or if empty, the record creation date. |
|
|
