NameDescriptionTypeAdditional information
Id

integer

None.

pHciCaseNo

string

None.

pHciTransNo

string

None.

pEffYear

string

None.

pEnlistStat

string

None.

pEnlistDate

date

None.

pPackageType

string

None.

pMemPin

string

None.

pMemFname

string

None.

pMemMname

string

None.

pMemLname

string

None.

pMemExtname

string

None.

pMemDob

date

None.

pMemSex

string

None.

pPatientPin

string

None.

pPatientFname

string

None.

pPatientMname

string

None.

pPatientLname

string

None.

pPatientExtname

string

None.

pPatientSex

string

None.

pPatientDob

date

None.

pPatientType

string

None.

pPatientMobileNo

string

None.

pPatientLandlineNo

string

None.

pWithConsent

string

None.

pTransDate

date

None.

pCreatedBy

string

None.

pTransDateStr

string

None.

UpdatedBy

string

None.

DateUpdated

date

None.

DateUpdatedStr

string

None.

DeletedBy

string

None.

DateDeleted

date

None.

DateDeletedStr

string

None.

MembershipCategory

string

None.

FirstTrancheStatus

string

None.

FirstTrancheOnQueueBy

string

None.

FirstTrancheOnQueueDate

date

None.

FirstTrancheOnQueueDateStr

string

None.

FirstTrancheSubmittedBy

string

None.

FirstTrancheDateSubmitted

date

None.

FirstTrancheDateSubmittedStr

string

None.

pHciTransmittalNumber

string

None.

PatientName

string

None.