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.

NMCAdmissionDate

date

None.

NMCAdmissionDateUnk

boolean

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.

EPID

string

None.

datCPatientDemographics

datCPatientDemographics

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.