| Name | Description | Type | Additional information |
|---|---|---|---|
| Id | integer |
None. |
|
| FKtblClaimsRefNo | globally unique identifier |
None. |
|
| pPatientReferred | string |
None. |
|
| pReferredIHCPAccreCode | string |
None. |
|
| pIsEmergency | string |
None. |
|
| pPatientType | string |
None. |
|
| pAdmissionDate | string |
None. |
|
| pDischargeDate | string |
None. |
|
| pAdmissionTime | string |
None. |
|
| pDischargeTime | string |
None. |
|
| TrackingNo | string |
None. |
|
| pDisposition | string |
String length: inclusive between 0 and 1 |
|
| pExpiredDateTime | string |
None. |
|
| pReferralIHCPAccreCode | string |
None. |
|
| pReferralReasons | string |
None. |
|
| pAccommodationType | string |
None. |
|
| pAdmissionDiagnosis | string |
None. |
|
| pProcedures | 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 |
String length: inclusive between 0 and 10 |
|
| pCheckUpDate2 | string |
String length: inclusive between 0 and 10 |
|
| pCheckUpDate3 | string |
String length: inclusive between 0 and 10 |
|
| pCheckUpDate4 | string |
String length: inclusive between 0 and 10 |
|
| pTBType | string |
None. |
|
| pNTPCardNo | string |
String length: inclusive between 0 and 18 |
|
| pDay0ARV | string |
String length: inclusive between 0 and 10 |
|
| pDay3ARV | string |
String length: inclusive between 0 and 10 |
|
| pDay7ARV | string |
String length: inclusive between 0 and 10 |
|
| pRIG | string |
String length: inclusive between 0 and 10 |
|
| pABPOthers | string |
String length: inclusive between 0 and 10 |
|
| pABPSpecify | string |
String length: inclusive between 0 and 50 |
|
| pNewBorn | string |
None. |
|
| pEssentialNewbornCare | string |
None. |
|
| pNewbornHearingScreeningTest | string |
None. |
|
| pNewbornScreeningTest | string |
None. |
|
| pFilterCardNo | string |
String length: inclusive between 0 and 20 |
|
| 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 |
String length: inclusive between 0 and 20 |
|
| pCataractPreAuth | string |
String length: inclusive between 0 and 20 |
|
| pLeftEyeIOLStickerNumber | string |
String length: inclusive between 0 and 20 |
|
| pLeftEyeIOLExpiryDate | string |
String length: inclusive between 0 and 20 |
|
| pRightEyeIOLStickerNumber | string |
String length: inclusive between 0 and 20 |
|
| pRightEyeIOLExpiryDate | string |
String length: inclusive between 0 and 10 |
|
| pCaseRate1Type | string |
String length: inclusive between 0 and 1 |
|
| pItemCode1 | string |
String length: inclusive between 0 and 6 |
|
| pCaseRateCode1 | string |
None. |
|
| pCaseRateAmount1 | string |
None. |
|
| pCaseRate2Type | string |
None. |
|
| pItemCode2 | string |
String length: inclusive between 0 and 6 |
|
| 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. |
|
| PatientName | string |
None. |
|
| pHasAttachedSOA | string |
None. |
|
| pThumbmarkedBy | string |
None. |
|
| pMemberMiddleName | string |
None. |
|
| pAprConsentToAccess | string |
None. |
|
| pDateSigned | string |
None. |
|
| pRelCode | string |
None. |
|
| pRelDesc | string |
None. |
|
| pReasonCode | string |
None. |
|
| pReasonDesc | string |
None. |
|
| Username | 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. |