tblCNSInitialReferral


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CareID int 4 null
tblMAIN_REFERRALS.CARE_ID FK_tblCNSInitialReferral_tblMAIN_REFERRALSC
L_DEC_REF_DATE date 20 √ null
L_REF_DATE date 20 √ null
L_DISCH_DATE date 20 √ null
L_REF_SOURCE varchar 5 √ null
ltblCNS_SOURCE_REF.SOURCE_ID FK_tblCNSInitialReferral_ltblCNS_SOURCE_REFC
L_INCLUDED varchar 5 √ null
ltblCNS_REASON_REF.REF_ID FK_tblCNSInitialReferral_ltblCNS_REASON_REFC
L_PRESENT_SURGEON bit 1 ((0))
L_PRESENT bit 1 ((0))
L_PRESENT_DOC bit 1 ((0))
L_PRESENT_NURSE bit 1 ((0))
L_PRESENT_GP bit 1 ((0))
L_PRESENT_OTHER bit 1 ((0))
L_PRESENT_UNKNOWN bit 1 ((0))
L_PRESENT_CONSULTANT bit 1 ((0))
L_CONTACT int 4 √ null
ltblYNNA.YNNA_ID FK_tblCNSInitialReferral_L_CONTACTC
L_ACCEPTED int 4 √ null
ltblYN.YN_ID FK_tblCNSInitialReferral_L_ACCEPTEDC
L_VERBAL int 4 √ null
ltblYNNA.YNNA_ID FK_tblCNSInitialReferral_L_VERBALR
L_WRITTEN int 4 √ null
ltblYNNA.YNNA_ID FK_tblCNSInitialReferral_L_WRITTENR
L_DETAILS int 4 √ null
ltblYNNA.YNNA_ID FK_tblCNSInitialReferral_L_DETAILSR
L_DN_INFORMED bit 1 ((0))
DistrictNurseName nvarchar 100 √ null
DistrictNursePhone nvarchar 100 √ null
L_UNDERSTANDING bit 1 ((0))
L_INT_ADVICE bit 1 ((0))
L_INT_SHORT bit 1 ((0))
L_INT_REG bit 1 ((0))
L_PROGNOSIS varchar 255 √ null
REASON_CNS_NOT_PRESENT int 4 √ null
ltblREASON_CNS_NOT_PRESENT.SOURCE_ID FK_tblCNSInitialReferral_REASON_CNS_NOT_PRESENTC
REASON_CNS_NOT_PRESENT_OTHER varchar 255 √ null
L_KEY_WORKER_OTHER varchar 255 √ null
L_KEY_WORKER_NEW int 4 √ null
GPInformed int 4 √ null
KeyWorkerTel varchar 50 √ null
KeyWorkerExt varchar 10 √ null
ACTION_ID int 4 √ null
OtherSourceOfReferral varchar 150 √ null
OtherReasonReferred varchar 150 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblCNSInitialReferral Primary key Asc CareID

Relationships

Close relationships within degrees of separation