NameDescriptionTypeAdditional information
RefNo

globally unique identifier

None.

Id

integer

None.

pHospitalTransmittalNo

string

None.

pUserName

string

None.

pHospitalCode

string

None.

pPIN

string

None.

pClaimNumber

string

None.

EligibilityTrackingNo

string

None.

CaseNo

string

None.

pClaimSeriesLhio

string

None.

pStatus

string

None.

pProcessStage

string

None.

pProcessDate

string

None.

pDeniedReason

string

None.

pStatusXml

string

None.

pVoucherDetailsXml

string

None.

pMemberLastName

string

None.

pMemberFirstName

string

None.

pMemberMiddleName

string

None.

pMemberSuffix

string

None.

pMemberSex

string

None.

pMemberBirthDate

date

None.

pMailingAddress

string

None.

pZipCode

string

None.

pLandlineNo

string

None.

pMobileNo

string

None.

pEmailAddress

string

None.

pPatientIs

string

None.

pAdmissionDate

date

None.

pDischargeDate

date

None.

pPatientLastName

string

None.

pPatientFirstName

string

None.

pPatientMiddleName

string

None.

pPatientSuffix

string

None.

pPatientPIN

string

None.

pPatientBirthDate

date

None.

pPatientSex

string

None.

pMemberShipType

string

None.

pPEN

string

None.

pEmployerName

string

None.

pForm3

string

None.

pRVS

string

None.

pTotalAmountActual

string

None.

pTotalAmountClaimed

string

None.

pIsFinal

string

None.

isok

string

None.

with3over6

string

None.

with9over12

string

None.

remainingdays

string

None.

asof

string

None.

reason

string

None.

docneeded

string

None.

SubmitResultEnc

string

None.

SubmitResult

string

None.

SubmitResultError

string

None.

pReceiptTicketNumber

string

None.

pTransmissionDateTime

date

None.

CreatedBy

string

None.

DateCreated

date

None.

UpdatedBy

string

None.

DateUpdated

date

None.

Deleted

boolean

None.

DeletedBy

string

None.

DateDeleted

date

None.

LastDateTransmitted

date

None.

pVoucherNo

string

None.

pVoucherDate

string

None.

pCheckNo

string

None.

pCheckDate

string

None.

pCheckAmount

string

None.

pClaimAmount

string

None.

pClaimPayeeName

string

None.

pDeficiency

string

None.

pRequirement

string

None.

SubmittedBy

string

None.

DateSubmitted

date

None.

SendToHims

boolean

None.

SendToHimsErrorDesc

string

None.

SentToHims

boolean

None.

SentToHimsDate

date

None.

pCivilStatus

string

None.

RefiledBy

string

None.

DateRefiled

string

None.

Captured

boolean

None.

MEMBER_CATEGORY_ID

string

None.

MEMBER_CATEGORY_DESC

string

None.

LastDateCheckStatus

date

None.

PatientType

string

None.

pPatientName

string

None.

pAdmissionDateStr

string

None.

pDischargeDateStr

string

None.

isMember

boolean

None.

pChiefComplaint

string

None.

isForOPDHemodialysisClaim

string

None.

v2

boolean

None.

referenceno

string

None.

FKtblClaimsRefNo

globally unique identifier

None.

pPatientReferred

string

None.

pReferredIHCPAccreCode

string

None.

pIsEmergency

string

None.

pPatientType

string

None.

pDisposition

string

None.

pExpiredDateTime

string

None.

pReferralIHCPAccreCode

string

None.

pReferralReasons

string

None.

pAccommodationType

string

None.

pAdmissionDiagnosis

string

None.

pHemodialysis

string

None.

pPeritoneal

string

None.

pLinac

string

None.

pCobalt

string

None.

pTransfusion

string

None.

pBrachytheraphy

string

None.

pChemotherapy

string

None.

pDebridement

string

None.

pImrt

string

None.

pCheckUpDate1

string

None.

pCheckUpDate2

string

None.

pCheckUpDate3

string

None.

pCheckUpDate4

string

None.

pTBType

string

None.

pNTPCardNo

string

None.

pDay0ARV

string

None.

pDay3ARV

string

None.

pDay7ARV

string

None.

pRIG

string

None.

pABPOthers

string

None.

pABPSpecify

string

None.

pNewBorn

string

None.

pEssentialNewbornCare

string

None.

pNewbornHearingScreeningTest

string

None.

pNewbornScreeningTest

string

None.

pFilterCardNo

string

None.

pDrying

string

None.

pSkinToSkin

string

None.

pCordClamping

string

None.

pProphylaxis

string

None.

pWeighing

string

None.

pVitaminK

string

None.

pBCG

string

None.

pNonSeparation

string

None.

pHepatitisB

string

None.

pLaboratoryNumber

string

None.

pCataractPreAuth

string

None.

pLeftEyeIOLStickerNumber

string

None.

pLeftEyeIOLExpiryDate

string

None.

pRightEyeIOLStickerNumber

string

None.

pRightEyeIOLExpiryDate

string

None.

pCaseRate1Type

string

None.

pItemCode1

string

None.

pCaseRateCode1

string

None.

pCaseRateAmount1

string

None.

pCaseRate2Type

string

None.

pItemCode2

string

None.

pCaseRateCode2

string

None.

pCaseRateAmount2

string

None.

pEnoughBenefits

string

None.

pTotalHCIFees

string

None.

pTotalProfFees

string

None.

pGrandTotal

string

None.

pTotalActualCharges

string

None.

pDiscount

string

None.

pPhilhealthBenefit

string

None.

pTotalAmount

string

None.

pMemberPatient

string

None.

pHMO

string

None.

pOthers

string

None.

pTotalActualChargesPf

string

None.

pDiscountPf

string

None.

pPhilhealthBenefitPf

string

None.

pTotalAmountPf

string

None.

pMemberPatientPf

string

None.

pHMOPf

string

None.

pOthersPf

string

None.

pDrugsMedicinesSupplies

string

None.

pDMSTotalAmount

string

None.

pExaminations

string

None.

pExamTotalAmount

string

None.

pHasAttachedSOA

string

None.

pDateSigned

string

None.

pAprConsentToAccess

string

None.

pThumbmarkedBy

string

None.

pRelCode

string

None.

pRelDesc

string

None.

pReasonCode

string

None.

pReasonDesc

string

None.

AddedBy

string

None.

DateAdded

date

None.

FktblClaimsRefNo

globally unique identifier

None.

pIllnessHistory

string

None.

pSpecificDesc

string

None.

pLastMensPeriod

string

None.

pPregCnt

string

None.

pDeliveryCnt

string

None.

pOtherComplaint

string

None.

pGenSurveyId

string

None.

pGenSurveyRem

string

None.

pPainSite

string

None.

pSystolic

string

None.

pDiastolic

string

None.

pHr

string

None.

pRr

string

None.

pTemp

string

None.

Symptoms

string

None.

Heent

string

None.

Chest

string

None.

Cvs

string

None.

Abdomen

string

None.

GuIe

string

None.

Skin

string

None.

Neuro

string

None.

pHeentRem

string

None.

pChestRem

string

None.

pHeartRem

string

None.

pAbdomenRem

string

None.

pGuRem

string

None.

pSkinRem

string

None.

pNeuroRem

string

None.

pFullTermCnt

string

None.

pPrematureCnt

string

None.

pAbortionCnt

string

None.

pLivChildrenCnt

string

None.

pHeight

string

None.

pWeight

string

None.

AgeYears

string

None.

AgeMonths

string

None.

AgeDays

string

None.

Age

string

None.

PatientName

string

None.

CaseRate1Amount

decimal number

None.

CaseRate2Amount

decimal number

None.

CaseRate1PfAmount

decimal number

None.

CaseRate2PfAmount

decimal number

None.

OtherFundSourcePfAmount

decimal number

None.

OtherFundSourcePfDescription

string

None.

pPatientReferredStreet

string

None.

pPatientReferredCity

string

None.

pPatientReferredProvince

string

None.

pPatientReferredZipCode

string

None.

HospitalBenefit

decimal number

None.

PfBenefit

decimal number

None.

Doctors

string

None.

Diagnosis

string

None.

WithCF4

string

None.

CR1Amount

decimal number

None.

CR2Amount

decimal number

None.