Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| NOGCAID | int identity | 4 | √ | null |
|
|
||
| CareID | int | 4 | √ | null |
|
|
||
| CancerStatus | varchar | 2 | √ | null |
|
|
||
| TumourStatus | int | 4 | √ | null |
|
|
||
| PriorityType | varchar | 2 | √ | null |
|
|
||
| FirstSeenDate | date | 20 | √ | null |
|
|
||
| SNOMedCT | int | 4 | √ | null |
|
|
||
| DiagnosisCode | varchar | 5 | √ | null |
|
|
||
| IsNewNOGCAReferral | bit | 1 | null |
|
|
|||
| PatientID | int | 4 | √ | null |
|
|
||
| NHSNumber | varchar | 50 | √ | null |
|
|
||
| DateOfBirth | smalldatetime | 16 | √ | null |
|
|
||
| SubmittingOrg | varchar | 5 | √ | null |
|
|
||
| Username | varchar | 50 | √ | null |
|
|
||
| Error1 | bit | 1 | ((0)) |
|
|
|||
| Error2 | bit | 1 | ((0)) |
|
|
|||
| Error3 | bit | 1 | ((0)) |
|
|
|||
| Error4 | bit | 1 | ((0)) |
|
|
|||
| Error5 | bit | 1 | ((0)) |
|
|
|||
| Error6 | bit | 1 | ((0)) |
|
|
|||
| Error7 | bit | 1 | ((0)) |
|
|
|||
| Error8 | bit | 1 | ((0)) |
|
|
|||
| Error9 | bit | 1 | ((0)) |
|
|
|||
| Error10 | bit | 1 | ((0)) |
|
|
|||
| Error11 | bit | 1 | ((0)) |
|
|
|||
| Error12 | bit | 1 | ((0)) |
|
|
|||
| Error13 | bit | 1 | ((0)) |
|
|
|||
| Error14 | bit | 1 | ((0)) |
|
|
|||
| Error15 | bit | 1 | ((0)) |
|
|
|||
| Error16 | bit | 1 | ((0)) |
|
|
|||
| Error17 | bit | 1 | ((0)) |
|
|
|||
| Error18 | bit | 1 | ((0)) |
|
|
|||
| Error19 | bit | 1 | ((0)) |
|
|
|||
| Error20 | bit | 1 | ((0)) |
|
|
|||
| Error21 | bit | 1 | ((0)) |
|
|
|||
| Error22 | bit | 1 | ((0)) |
|
|
|||
| Error23 | bit | 1 | ((0)) |
|
|
|||
| Error24 | bit | 1 | ((0)) |
|
|
|||
| Error25 | bit | 1 | ((0)) |
|
|
|||
| Error26 | bit | 1 | ((0)) |
|
|
|||
| Error27 | bit | 1 | ((0)) |
|
|
|||
| Error28 | bit | 1 | ((0)) |
|
|
|||
| Error29 | bit | 1 | ((0)) |
|
|
|||
| Error30 | bit | 1 | ((0)) |
|
|
|||
| Error31 | bit | 1 | ((0)) |
|
|
|||
| Error32 | bit | 1 | ((0)) |
|
|
|||
| Error33 | bit | 1 | ((0)) |
|
|
|||
| Error34 | bit | 1 | ((0)) |
|
|
|||
| Error35 | bit | 1 | ((0)) |
|
|
|||
| Error36 | bit | 1 | ((0)) |
|
|
|||
| Error37 | bit | 1 | ((0)) |
|
|
|||
| Error38 | bit | 1 | ((0)) |
|
|
|||
| Error39 | bit | 1 | ((0)) |
|
|
|||
| Error40 | bit | 1 | ((0)) |
|
|
|||
| Error41 | bit | 1 | ((0)) |
|
|
|||
| Error42 | bit | 1 | ((0)) |
|
|
|||
| Error43 | bit | 1 | ((0)) |
|
|
|||
| Error44 | bit | 1 | ((0)) |
|
|
|||
| Error45 | bit | 1 | ((0)) |
|
|
|||
| Error46 | bit | 1 | ((0)) |
|
|
|||
| Error47 | bit | 1 | ((0)) |
|
|
|||
| Error48 | bit | 1 | ((0)) |
|
|
|||
| Error49 | bit | 1 | ((0)) |
|
|
|||
| Error50 | bit | 1 | ((0)) |
|
|
|||
| Error51 | bit | 1 | ((0)) |
|
|
|||
| Error52 | bit | 1 | ((0)) |
|
|
|||
| Error53 | bit | 1 | ((0)) |
|
|
|||
| Error54 | bit | 1 | ((0)) |
|
|
|||
| Error55 | bit | 1 | ((0)) |
|
|
|||
| Error56 | bit | 1 | ((0)) |
|
|
|||
| Error57 | bit | 1 | ((0)) |
|
|
|||
| Error58 | bit | 1 | ((0)) |
|
|
|||
| Error59 | bit | 1 | ((0)) |
|
|
|||
| ErrMissingQuadranticBiopsies | bit | 1 | ((0)) |
|
|
|||
| ErrMissingAdditionalBiopsies | bit | 1 | ((0)) |
|
|
|||
| ErrMissingHospitalInitialTreatment | bit | 1 | ((0)) |
|
|
|||
| ErrMissingDateInitialTreatment | bit | 1 | ((0)) |
|
|
|||
| ErrMissingSecondConfirmedPathologist | bit | 1 | ((0)) |
|
|
|||
| ErrMissingPlanReason | bit | 1 | ((0)) |
|
|
|||
| ErrMissingNextSurveillance | bit | 1 | ((0)) |
|
|
|||
| ErrMissingExcisionComplete | bit | 1 | ((0)) |
|
|
|||
| ErrMissingYesPlan | bit | 1 | ((0)) |
|
|
|||
| ErrMissingNoPlan | bit | 1 | ((0)) |
|
|
|||
| ErrMissingAgreedMDT | bit | 1 | ((0)) |
|
|
|||
| ErrMissingCircumferentialLength | bit | 1 | ((0)) |
|
|
|||
| ErrMissingMaxLength | bit | 1 | ((0)) |
|
|
|||
| ErrMissingPalReason | bit | 1 | ((0)) |
|
|
|||
| ErrDateCarePlanEndoscopicBiopsy | bit | 1 | ((0)) |
|
|
|||
| ErrDateInitialTreatmentEndoscopicBiopsy | bit | 1 | ((0)) |
|
|
|||
| ErrMissingChemoDate | bit | 1 | ((0)) |
|
|
|||
| ErrMissingChemoOutcome | bit | 1 | ((0)) |
|
|
|||
| ErrMissingRadioDate | bit | 1 | ((0)) |
|
|
|||
| ErrMissingRadioOutcome | bit | 1 | ((0)) |
|
|
|||
| ErrMissingStentType | bit | 1 | ((0)) |
|
|
|||
| ErrMissingStentPlacement | bit | 1 | ((0)) |
|
|
|||
| ErrMissingEndoComp | bit | 1 | ((0)) |
|
|
|||
| ErrNoComplications | bit | 1 | ((0)) |
|
|
|||
| ErrMissingSurgicalPathway | bit | 1 | ((0)) |
|
|
|||
| ErrMissingERASPathwayCompleted | bit | 1 | ((0)) |
|
|
|||
| ErrCoMob | bit | 1 | ((0)) |
|
|
|||
| ErrAdjunctiveTherapy | bit | 1 | ((0)) |
|
|
|||
| ErrCoMobHGD | bit | 1 | ((0)) |
|
|
|||
| ErrTeleTreatIntent | bit | 1 | ((0)) |
|
|
|||
| ErrAdjTele | bit | 1 | ((0)) |
|
|
|||
| ErrAbdominalAccess | bit | 1 | √ | null |
|
|
||
| ErrTNM | bit | 1 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tmpRPT_NOGCA_REFERRAL | Primary key | Asc | NOGCAID |
Diagram producer might be missing
No diagrams were produced please see application output for any errors