NameDescriptionTypeAdditional information
Id

integer

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.

UpdatedBy

string

None.

DateUpdated

date

None.

pReferredIHCPFacilityName

string

None.

CaseRate1Amount

decimal number

None.

CaseRate2Amount

decimal number

None.

CaseRate1PfAmount

decimal number

None.

CaseRate2PfAmount

decimal number

None.

pPatientReferredStreet

string

None.

pPatientReferredCity

string

None.

pPatientReferredProvince

string

None.

pPatientReferredZipCode

string

None.

pReferral

string

None.

pReferralName

string

None.

pReferralStreet

string

None.

pReferralCity

string

None.

pReferralProvince

string

None.

pReferralZipCode

string

None.

pReferredReason

string

None.