NameDescriptionTypeAdditional information
RID

integer

None.

NMC_Case_ID

integer

None.

CaseID_Internal

string

None.

CaseGUID

globally unique identifier

None.

CaseMergeGUID

globally unique identifier

None.

NMCCaseType

integer

None.

NMCCaseTypeName

string

None.

NMCCaseClassification

integer

None.

NMCCaseClassificationName

string

None.

PatientID

integer

None.

Province

integer

None.

District

integer

None.

SubDistrict

integer

None.

Facility

integer

None.

FacilityContact

string

None.

FacilityAltContact

string

None.

FacilityFileNo

string

None.

FacilityHPRSPRN

string

None.

NotificationDate

date

None.

NotifierName

string

None.

NotifierSurname

string

None.

NotifierContact

string

None.

NotifierEmail

string

None.

NotifierSANCHPCSA

string

None.

NMCDiagnosed

integer

None.

NMCContact

integer

None.

NMCMethodDiagnosis

integer

None.

NMCOtherDiagnosis

string

None.

NMCOtherSymptoms

string

None.

NMCTreatmentDescription

string

None.

NMCSymptomDate

date

None.

NMCDiagnosisDate

date

None.

NMCAdmissionStatus

integer

None.

NMCWardName

string

None.

NMCPatientVitalStatus

integer

None.

NMCDeathDate

date

None.

NMCCaseSeverity

integer

None.

HasTravelled

integer

None.

VacStatus

integer

None.

VacLastDate

date

None.

VacSpecimenCollected

integer

None.

VacSpecimenDate

date

None.

VacSpecimenbarcode

string

None.

NMCDiagnosedGroup

integer

None.

Notified

boolean

None.

ShouldNotify

boolean

None.

CreatedBy

string

None.

CreatedDate

date

None.

ModifiedBy

string

None.

ModifiedDate

date

None.

Episode_Number

string

None.

SaveDeviceIndex

integer

None.

Case_Matched_Indicator

integer

None.

Case_Primary_Indicator

integer

None.

Case_ID_Matched

integer

None.

Lab_Results_Indicator

integer

None.

Case_Notes

string

None.

Coded_Reasons_ID

integer

None.

Coded_Reasons

string

None.

Original_Case_Type_Name

string

None.

Case_Duplicate_Indicator

integer

None.

IsProcessed

boolean

None.

IsDeleted

boolean

None.

IsEnabled

boolean

None.

SysTest

boolean

None.

NMCAdmissionDate

date

None.

NMCAdmissionDateUnk

boolean

None.

EPID

string

None.

datCSymptoms

Collection of datCSymptoms

None.

datCTravelHistory

Collection of datCTravelHistory

None.

datCCase_Diphtheria

Collection of datCCase_Diphtheria

None.

datCCase_TB

Collection of datCCase_TB

None.

datCCase_Listeriosis

Collection of datCCase_Listeriosis

None.

datCCaseMonkeypox

Collection of datCCaseMonkeypox

None.

datCCaseMonkeypox1

Collection of datCCaseMonkeypox

None.

datCListeriosisFoodConsumption

Collection of datCListeriosisFoodConsumption

None.

datCListeriosisFoodSource

Collection of datCListeriosisFoodSource

None.

datCListeriosisFoodSourceOther

Collection of datCListeriosisFoodSourceOther

None.

datCListeriosisOutsideFoodSource

Collection of datCListeriosisOutsideFoodSource

None.

datCListeriosisPatientIllness

Collection of datCListeriosisPatientIllness

None.

datCListeriosisPregnantOutcome

Collection of datCListeriosisPregnantOutcome

None.

datCListeriosisProxyPRelationship

Collection of datCListeriosisProxyPRelationship

None.

datCListeriosisSpecimen

Collection of datCListeriosisSpecimen

None.