tmpHANAPATH_Followup


Columns

Column Type Size Nulls Auto Default Children Parents Comments
S char 1 null
SPECVERSION varchar 5 null
SUBMITCODE varchar 5 null
IMPORTLINKID int 4 null
IMPORTCHILDID int 4 null
DATEOFFOLLOWUP datetime 16,3 √ null
WEIGHT real 4 √ null
INTERINCISALMEASUREMENTPOSTTX char 1 √ null
MAXINTERINCISALDISTANCEPOSTTREATMENT int 4 √ null
WHEREWASTHEFOLLOWUP varchar 5 √ null
SUSPECTEDRECURRENCE char 1 √ null
SITEOFSUSPECTEDHNRECURRENCE varchar 5 √ null
SIDEOFSUSPECTEDRECURRENCE char 1 √ null
SUSPECTEDNEWTUMOUR char 1 √ null
SITEOFSUSPECTEDNEWTUMOUR varchar 2 √ null
HEADNECKSITEOFSUSPECTEDNEWTUMOUR varchar 5 √ null
SIDEOFSUSPECTEDNEWTUMOUR char 1 √ null
COMPLICATIONSGENERAL bit 1 null
COMPLICATIONSACUTERADIO bit 1 null
COMPLICATIONSLATERADIO bit 1 null
COMPLICATIONSACUTECHEMO bit 1 null
COMPLICATIONSLATECHEMO bit 1 null
COMPLICATIONSLATESURGICAL bit 1 null
COMPLICATIONSOTHER bit 1 null
OTHERCOMPLICATIONS varchar 1024 √ null
PLANNEDWEEKSTONEXTAPPOINTMENT int 4 √ null
DATEOFCLINICIANLETTER datetime 16,3 √ null
LETTERCOPIEDTOMDTCOORDINATOR char 1 √ null
DATEOFRADIOLOGYREPORTFORHEADNECKTUMOUR datetime 16,3 √ null
RADIOLOGYREPORTCOPIEDTOMDTCOORDINATOR char 1 √ null
DATEPATHOLOGYREPORTHNTUMOUR datetime 16,3 √ null
PATHOLOGYREPORTCOPIEDTOMDTCOORDINATOR char 1 √ null
DATEOFMDTDISCUSSIONRECURRENCE datetime 16,3 √ null
DATENEWTUMOURCLINICALLYAGREED datetime 16,3 √ null
DATEOFRECURRENCECLINICALLYAGREED datetime 16,3 √ null
PRIMARYTUMOURSTATUS char 1 √ null
NODESTATUS char 1 √ null
METASTATICSTATUS char 1 √ null
PATIENTSTATUS char 1 √ null
GENERALCAUSEOFDEATH char 1 √ null
SPECIFICCAUSEOFDEATH varchar 75 √ null
LOCATIONOFDEATH varchar 2 √ null
DATEOFDEATH datetime 16,3 √ null
ERR_DATEOFFOLLOWUP bit 1 null
Username varchar 50 null

Indexes

Constraint Name Type Sort Column(s)
PK_tmpHANAPATH_Followup Primary key Asc/Asc IMPORTCHILDID + Username

Diagram producer might be missing

No diagrams were produced please see application output for any errors