Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.CancerRegistryData
Touchworks 25.2
[dbo].[CancerRegistryData]
MS_Description
Cancer Registry data
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[dict_id]
5
NOT NULL
1 - 1
Key to the CancerRegistryData table
RegistryHeaderID
[dbo].[dict_id]
5
NOT NULL
Header. Link to RegistryHeader.ID
OnsetDate
datetime
8
NULL allowed
Onset date
Histology
int
4
NULL allowed
Histology
PrimarySite
int
4
NULL allowed
Primary site
ResolvedDate
datetime
8
NULL allowed
Resolved date
Behavior
int
4
NULL allowed
Behavior
Laterality
int
4
NULL allowed
Laterality
DiagnosticConfirm
int
4
NULL allowed
Diagnostic confirmation
Grade
int
4
NULL allowed
Grade
SubmittingProvider
[dbo].[uniqueid]
9
NOT NULL
Submitting provider. Link to Person.ID
ClinicalStageGrp
int
4
NULL allowed
Clinical stage group
ClinicalStageDesc
int
4
NULL allowed
Clinical stage description
ClinicalEdition
int
4
NULL allowed
Clinical Stage Edition
ClinicalStagedBy
int
4
NULL allowed
Clinical Staged by
ClinicalT
int
4
NULL allowed
Clinical stage T
ClinicalN
int
4
NULL allowed
Clinical stage N
ClinicalM
int
4
NULL allowed
Clinical stage M
PathologicStageGrp
int
4
NULL allowed
Pathologic stage group
PathologicStageDesc
int
4
NULL allowed
Pathologic Stage description
PathologicEdition
int
4
NULL allowed
Pathologic Edition
PathologicStagedBy
int
4
NULL allowed
Pathologic Staged by
PathologicT
int
4
NULL allowed
Pathologic Stage T
PathologicN
int
4
NULL allowed
Pathologic Stage N
PathologicM
int
4
NULL allowed
Pathologic Stage M
CancerNotes
varchar(7000)
7000
NULL allowed
Cancer Notes
RadiationNotes
varchar(7000)
7000
NULL allowed
Radiation notes
LastUpdatedClinicalDTTM
datetime
8
NULL allowed
Clinical Stage updated date time
LastUpdatedPathologicDTTM
datetime
8
NULL allowed
Pathologic stage updated date time