tmpHANAPATH_Baseline_A


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
DEMOGID int 4 null
WHEREPATIENTSEENCANCERSPECIALIST varchar 5 √ null
DATEFIRSTSEEN datetime 16,3 √ null
DATEOFREFERRAL datetime 16,3 √ null
POSTCODEATREFERRAL varchar 8 √ null
SOURCEOFREFERRAL varchar 2 √ null
REFERRALPRIORITY char 1 √ null
HEIGHT real 4 √ null
WEIGHTATREFERRAL real 4 √ null
SYMPTOMS_1 varchar 2 √ null
SYMPTOMS_2 varchar 2 √ null
SYMPTOMS_3 varchar 2 √ null
DATESYMPTOMSFIRSTNOTED varchar 10 √ null
PREVIOUSHNCANCER char 1 √ null
PREVTREATMENTYEAR int 4 √ null
PREVTREATMENTMONTH int 4 √ null
PREVTREATMENTDAY int 4 √ null
WHERETREATEDFORPREVNHCANCER varchar 5 √ null
DATEINITIALCONTACTDIETICIAN datetime 16,3 √ null
DIETICIANTREATINGTHEPATIENT varchar 8 √ null
WHEREPATIENTASSESSEDBYDIETICIAN varchar 5 √ null
NUTRITIONALLYASSESSEDPRETREATMENTBYDIETICIAN char 1 √ null
WASBMICOLLECTEDPRETREATMENT char 1 √ null
PREDOMINANTNUTRITIONALSUPPORTDURINGTREATMENT char 1 √ null
PREDOMINANTTUBETYPEDURINGTREATMENT char 1 √ null
REVIEWEDBYSPECIALISTHNDIETICIANPOSTTREATMENT char 1 √ null
COMPLIANTDIETETICADVICEBMI char 1 √ null
PRETREATMENTSALTASSESSMENT char 1 √ null
WHERESALTASSESSMENTDONE varchar 5 √ null
WHODIDTHESPEECHANDLANGUAGEASSESSMENT varchar 8 √ null
INTERINCISALMEASUREMENTPRETX char 1 √ null
MAXINTERINCISALDISTANCEPRETREATMENT int 4 √ null
DATEOFSALTPRETREATMENTASSESSMENT datetime 16,3 √ null
NORMALCYDIETPRE varchar 2 √ null
LARYNGECTOMYPOSTOPERATIVECOMMUNICATION char 1 √ null
POSTTREATMENTSALTASSESSMENT char 1 √ null
DATEPOSTTREATMENTSALTASSESSMENT datetime 16,3 √ null
NORMALCYDIETTHREEMONTHS varchar 2 √ null
LARYNGECTOMYCOMMUNICATIONTHREEMONTHS char 1 √ null
NORMALCYDIETTWELVEMONTHS varchar 2 √ null
LARYNGECTOMYCOMMUNICATIONTWELVEMONTHS char 1 √ null
DIDCNSSEEPATIENTBEFORETREATMENT char 1 √ null
WHEREWASTHENURSINGCAREPROVIDED varchar 5 √ null
DATECNSNEEDSASSESSMENTCOMPLETED datetime 16,3 √ null
DISCHARGESUMMARYSURGERY char 1 √ null
DISCHARGESUMMARYCHEMOTHERAPY char 1 √ null
DISCHARGESUMMARYRADIOTHERAPY char 1 √ null
CONSDENTISTASKEDATMDT char 1 √ null
RESTORATIVEDENTISTWHOASSESSEDPATIENT varchar 8 √ null
WHEREPATIENTASSESSEDBYDENTIST varchar 5 √ null
DENTALASSESSMENTNECESSARY char 1 √ null
DATEOFRESTORATIVEDENTALASSESSMENT datetime 16,3 √ null
CHESTXPRIORTOTREATMENT char 1 √ null
CTCHESTPRIORTOTREATMENT char 1 √ null
CTPRIMARYNECKPRIORTOTREATMENT char 1 √ null
MRIPRIMARYPRIORTOTREATMENT char 1 √ null
PETCTSCANPRIORTOTREATMENT char 1 √ null
ORTHOPANTOMOGRAMPRIORTOTREATMENT char 1 √ null
ULTRASOUNDPRIORTOTREATMENT char 1 √ null
WHEREWASTHEMDTMEETINGHELD varchar 5 √ null
DATEOFFIRSTMDTMEETING datetime 16,3 √ null
CAREPLANDISCUSSEDATMDTMEETING char 1 √ null
DATEMDTCAREPLANAGREED datetime 16,3 √ null
PLANNEDCANCERTREATMENTTYPE_1 varchar 2 √ null
PLANNEDCANCERTREATMENTTYPE_2 varchar 2 √ null
PLANNEDCANCERTREATMENTTYPE_3 varchar 2 √ null
PLANNEDCANCERTREATMENTTYPE_4 varchar 2 √ null
NOACTIVETREATMENT bit 1 null
BASISOFDIAGNOSIS char 1 √ null
TUMOURTGRADEMDT varchar 3 √ null
TUMOURNGRADEMDT varchar 3 √ null
TUMOURMGRADEMDT varchar 2 √ null
PATIENTAPPROACHEDABOUTCLINICALTRIALPARTICIPATION char 1 √ null
TRIALTREATMENTTYPE char 1 √ null
COMORBIDITYINDEXACE27 char 1 √ null
PERFORMANCESTATUS char 1 √ null
CAREPLANINTENTMDT char 1 √ null
REASONFORNOCANCERTREATMENT char 1 √ null
TELEID int 4 √ null
COMPLICATIONSACUTERADIO bit 1 null
COMPLICATIONSACUTECHEMO bit 1 null
WHEREWASTHERADIOTHERAPYPROVIDED varchar 5 √ null
CANCERTREATMENTEVENTTYPERADIOTHERAPY varchar 2 √ null
RADIOTHERAPYTREATMENTMODALITY varchar 2 √ null
RADIOTHERAPYCONSULTANT varchar 8 √ null
CANCERTXTYPEATTIMEOFRADIOTHERAPY varchar 2 √ null
RTPLANNEDSTARTDATE datetime 16,3 √ null
DATEOF1STFRACTION datetime 16,3 √ null
REASONFORDELAYRADIOTHERAPY char 1 √ null
RADIOTHERAPYTREATMENTREGION varchar 50 √ null
BRACHYTHERAPYTYPE char 1 √ null
RTINTENT char 1 √ null
RTTECHNIQUE char 1 √ null
RTPRESCRIBEDTOTALDOSE real 4 √ null
RTPRESCRIBEDNUMBEROFFRACTIONS int 4 √ null
RTACTUALTOTALDOSE real 4 √ null
RTACTUALNUMBEROFFRACTIONS int 4 √ null
RTBEAMTYPE char 1 √ null
PHOTONENERGY char 1 √ null
ELECTRONBEAMENERGY char 1 √ null
DATEOFLASTFRACTION datetime 16,3 √ null
RTREGIMECOMPLETEDASPLANNED char 1 √ null
REASONSFORNONCOMPLETION varchar 50 √ null
CHEMOID int 4 √ null
WHEREWASTHECHEMOTHERAPYPROVIDED varchar 5 √ null
CANCERTREATMENTEVENTTYPECHEMOTHERAPY varchar 2 √ null
CHEMOTHERAPYCONSULTANT varchar 8 √ null
CANCERTXTYPEATTIMEOFCHEMOTHERAPY varchar 2 √ null
TREATMENTINTENTCHEMO char 1 √ null
TIMINGOFCHEMOTHERAPY char 1 √ null
CTREGIMEN char 1 √ null
CTREGIMENSTARTDATE datetime 16,3 √ null
CHEMOTHERAPYTREATMENTMODALITY varchar 2 √ null
CHEMOTHERAPYDRUGTYPE char 1 √ null
PLANNEDNUMBEROFTREATMENTCYCLES int 4 √ null
CTREGIMENCOMPLETEDASPLANNED char 1 √ null
DOSEREDUCTION int 4 √ null
TIMEDELAY int 4 √ null
STOPPEDEARLY int 4 √ null
REASONSFORREGIMENMODIFICATIONCHEMOTHERAPY varchar 25 √ null
ANYPALLIATIVECARE char 1 √ null
PALLIATIVECARECONSULTANT varchar 8 √ null
PALLIATIVECAREORGANISATION varchar 5 √ null
PALLIATIVECARESTARTDATE datetime 16,3 √ null
NURSINGCAREORGANISATION varchar 5 √ null
DIAGNOSISDATE datetime 16,3 √ null
ERR_DATEOFREFERRAL bit 1 null
ERR_POSTCODEATREFERRAL bit 1 null
ERR_DATEOF1STFRACTION bit 1 null
ERR_CTREGIMENSTARTDATE bit 1 null
ERR_PALLIATIVECARESTARTDATE bit 1 null
Username varchar 50 null
DelimitedSymptomCodes varchar 100 √ null
DelimitedSymptomDescriptions varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tmpHANAPATH_Baseline_A Primary key Asc/Asc IMPORTLINKID + Username

Diagram producer might be missing

No diagrams were produced please see application output for any errors