STG_INFO

Description: |
This table stores general information about the stage of a patient's cancer, including clinical and pathologic staging attributes that were determined using methods defined by the American Joint Committee on Cancer (AJCC).

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
STAGE_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | STAGE_ID | NUMERIC | No |
The cancer stage ID.
2 | STAGE_TITLE_NM | VARCHAR | No |
The title of this cancer stage row, usually indicative of the body site or cancer type being staged.
3 | STAGE_TYPE_C_NAME | VARCHAR | No |
The type of stage in this record: Free Text, AJCC, SEER, or Pediatric.
May contain organization-specific values: No
Category Entries:
Free Text
AJCC
SEER
Pediatrics
4 | STAGE_CLASS_C_NAME | VARCHAR | No |
The classification of the stage in this row, for example Clinical or Pathologic.
May contain organization-specific values: No
Category Entries:
Unspecified
Clinical
Surgical
Pathologic
Both Clinical and Pathologic
Retreatment
Autopsy
5 | STAGE | VARCHAR | No |
The free text stage in this row.
6 | STG_PAT_ID | VARCHAR | No |
The ID of the patient to which the stage in this row applies.
7 | STG_BODY_SITE_C_NAME | VARCHAR | No |
The body site to which the stage in this row applies.
May contain organization-specific values: Yes
8 | AJCC_LV_INV_C_NAME | VARCHAR | No |
The lymphatic vessel invasion of the AJCC 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
9 | AJCC_VENOUS_INV_C_NAME | VARCHAR | No |
The venous invasion of the AJCC 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
10 | AJCC_RESIDUAL_C_NAME | VARCHAR | No |
The residual tumor of the AJCC stage.
May contain organization-specific values: Yes
Category Entries:
R0
R1
R2
R0(un)
R1(un)
RX
11 | AJCC_HIST_GRADE_C_NAME | VARCHAR | No |
The histologic grade of the AJCC 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
Intermediate grade
High grade
GB
GX
No grade assigned
Not applicable
12 | AJCC_STAGE_C_NAME | VARCHAR | No |
The AJCC stage for the diagnosis.
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 IVD
Stage A
Stage B
Stage C
Recurrent - Initial Stage Unknown
Stage 0
Stage 0a
Stage 0is
13 | AJCC_PATH_STAGE_C_NAME | VARCHAR | No |
The AJCC pathologic stage.
The category values for this column were already listed for column: AJCC_STAGE_C_NAME
14 | AJCC_CLIN_STAGE_C_NAME | VARCHAR | No |
The AJCC clinical stage.
The category values for this column were already listed for column: AJCC_STAGE_C_NAME
15 | AJCC_T_C_NAME | VARCHAR | No |
The primary tumor component of the summary 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 (DCIS/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 (DCIS/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
16 | AJCC_PATH_T_C_NAME | VARCHAR | No |
The primary tumor component of the pathologic stage.
The category values for this column were already listed for column: AJCC_T_C_NAME
17 | AJCC_CLIN_T_C_NAME | VARCHAR | No |
The primary tumor component of the clinical stage.
The category values for this column were already listed for column: AJCC_T_C_NAME
18 | AJCC_N_C_NAME | VARCHAR | No |
The regional lymph nodes component of the summary 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
19 | AJCC_PATH_N_C_NAME | VARCHAR | No |
The regional lymph nodes component of the pathologic stage.
The category values for this column were already listed for column: AJCC_N_C_NAME
20 | AJCC_CLIN_N_C_NAME | VARCHAR | No |
The regional lymph nodes component of the clinical stage.
The category values for this column were already listed for column: AJCC_N_C_NAME
21 | AJCC_M_C_NAME | VARCHAR | No |
The distant metastasis component of the summary 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
22 | AJCC_PATH_M_C_NAME | VARCHAR | No |
The distant metastasis component of the pathologic stage.
The category values for this column were already listed for column: AJCC_M_C_NAME
23 | AJCC_CLIN_M_C_NAME | VARCHAR | No |
The distant metastasis component of the clinical stage.
The category values for this column were already listed for column: AJCC_M_C_NAME
24 | CLIN_STAGE_STS_C_NAME | VARCHAR | No |
The clinical stage status, such as New, Assigned, or Started.
May contain organization-specific values: No
Category Entries:
New
Assigned
Started
Complete
Reopened
Redone
25 | CLIN_SIGN_USR_ID | VARCHAR | No |
The user ID of the last person to sign the clinical stage in this row.
26 | CLIN_SIGN_USR_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
27 | CLIN_SIGN_INST | DATETIME (Local) | No |
The date/time in external format of the last time the clinical stage in this row was signed.
28 | PATH_STAGE_STS_C_NAME | VARCHAR | No |
The pathologic stage status.
The category values for this column were already listed for column: CLIN_STAGE_STS_C_NAME
29 | PATH_SIGN_USR_ID | VARCHAR | No |
The user ID of the last person to sign the pathologic stage in this row.
30 | PATH_SIGN_USR_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
31 | PATH_SIGN_INST | DATETIME (Local) | No |
The date/time in external format of the last time the pathologic stage in this row was signed.
32 | UNK_PRIM_SITE_YN | VARCHAR | No |
Yes/no flag as to whether the primary tumor site or cancer type listed in the Body Site (I STG 65, STG_BODY_SITE_C) is merely suspected instead of being known for certain.
May contain organization-specific values: No
Category Entries:
No
Yes
33 | HAS_CS_INFO_YN | VARCHAR | No |
Yes/no flag as to whether this STG row contains any collaborative staging (CS) information.
The category values for this column were already listed for column: UNK_PRIM_SITE_YN
34 | STAGE_METHOD_VERS_C_NAME | VARCHAR | No |
Specifies the staging methodology (or version of that methodology) that is used to stage this cancer, from the Staging Method or Version (I FCS 60) of the corresponding Cancer Staging Definitions (FCS) record.
May contain organization-specific values: Yes
Category Entries:
AJCC 6th Edition
AJCC 7th Edition
AJCC 8th Edition
AJCC Version 9
Pediatric
35 | STAGE_CONV_SRC_ID | NUMERIC | No |
For each new stage (STG) record created by the Epic 2014 cancer staging conversion, this item will store the ID of the stage record that it was created from.
36 | RECORD_STATUS_C_NAME | VARCHAR | No |
The record status category number for the stage (e.g. soft-deleted).
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
37 | LINKED_PROBLEM_LIST_ID | NUMERIC | No |
Virtual item that holds the problem list record ID (LPL) the stage belongs to.
38 | IS_STAGE_DELETED_YN | VARCHAR | No |
Virtual item that checks the latest contact of the Data Model Version (I STG 64) and Status (I STG 620) to determine if the stage record is deleted or not.
The category values for this column were already listed for column: UNK_PRIM_SITE_YN