Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How should we handle long CONCEPT.concept_name entries that exceed 255 characters coming from NAACCR? #28

Closed
mgurley opened this issue Mar 4, 2019 · 3 comments
Labels
Milestone

Comments

@mgurley
Copy link
Collaborator

@mgurley mgurley commented Mar 4, 2019

No description provided.

@mgurley mgurley added the NAACCR label Mar 4, 2019
@mgurley mgurley added this to the Active Sprint milestone Mar 4, 2019
@mgurley mgurley changed the title How should we handle long CONCEPT.concept_name entries tha exceed 255 characters coming from NAACCR?? How should we handle long CONCEPT.concept_name entries that exceed 255 characters coming from NAACCR? Mar 4, 2019
@cgreich

This comment has been minimized.

Copy link
Collaborator

@cgreich cgreich commented Mar 5, 2019

Can you show us?

@mgurley

This comment has been minimized.

Copy link
Collaborator Author

@mgurley mgurley commented Mar 5, 2019

@cgreich Here is an example of the problem from Dmitry's first cut:

NAACCR Schema NAACCR Item NAACCR Item # NAACCR Item Code
colon_rectum EOD Primary Tumor 772 600

The NAACCR Item description for this is NAACCR Item for this NAACCR Schema is the following:

Adherent to other organs or structures clinically with >no microscopic examination
Tumor found in adhesion(s) if microscopic examination performed
All Colon subsites
- Abdominal wall
- Retroperitoneum (excluding fat)
- Small intestine

Cecum (C180)
- Greater omentum

Ascending colon (C182)
- Greater omentum
- Kidney, right
- Liver, right lobe
- Ureter, right

Transverse colon and flexures (C183, C184, C185)
- Bile ducts
- Gallbladder
- Kidney
- Liver
- Pancreas
- Spleen
- Stomach

Descending colon (C186)
- Greater omentum
- Kidney, left
- Pelvic wall
- Spleen
- Ureter, left

Sigmoid colon (C187)
- Greater omentum
- Pelvic wall

Rectosigmoid (C199)
- Cul de sac (rectouterine pouch)
- Pelvic wall/pelvic plexuses
- Small intestine

Rectum (C209)
- Anus/anal canal
- Bladder (males only)
- Cul de sac (rectouterine pouch)
- Ductus deferens
- Pelvic wall
- Prostate
- Rectovaginal septum
- Rectovesical fascia (males only)
- Seminal vesicle(s)
- Skeletal muscles of pelvic floor
- Vagina

So that would give us a concept_name with a length of 1022 characters as follows:

colon_rectum-EOD Primary Tumor-Adherent to other organs or structures clinically with no microscopic examination
Tumor found in adhesion(s) if microscopic examination performed
All Colon subsites
- Abdominal wall
- Retroperitoneum (excluding fat)
- Small intestine

Cecum (C180)
- Greater omentum

Ascending colon (C182)
- Greater omentum
- Kidney, right
- Liver, right lobe
- Ureter, right

Transverse colon and flexures (C183, C184, C185)
- Bile ducts
- Gallbladder
- Kidney
- Liver
- Pancreas
- Spleen
- Stomach

Descending colon (C186)
- Greater omentum
- Kidney, left
- Pelvic wall
- Spleen
- Ureter, left

Sigmoid colon (C187)
- Greater omentum
- Pelvic wall

Rectosigmoid (C199)
- Cul de sac (rectouterine pouch)
- Pelvic wall/pelvic plexuses
- Small intestine

Rectum (C209)
- Anus/anal canal
- Bladder (males only)
- Cul de sac (rectouterine pouch)
- Ductus deferens
- Pelvic wall
- Prostate
- Rectovaginal septum
- Rectovesical fascia (males only)
- Seminal vesicle(s)
- Skeletal muscles of pelvic floor
- Vagina
@mgurley

This comment has been minimized.

Copy link
Collaborator Author

@mgurley mgurley commented Mar 13, 2019

At the 3/12/2019 Oncology Workgroup meeting @dimshitc said that for CONCEPT.concept_name entries that exceed the length will have an entry made in CONCEPT_SYNONYM.

@mgurley mgurley closed this Mar 13, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.