| Name | Description | Type | Additional information |
|---|---|---|---|
| COMPANY_NAME | string |
None. |
|
| INSURANCE_COMPANY_NAME | string |
None. |
|
| POLICY_NO | string |
None. |
|
| POLICY_START_DATE | string |
None. |
|
| POLICY_END_DATE | string |
None. |
|
| TPA_ID | string |
None. |
|
| EMPLOYEE_NO | string |
None. |
|
| EMPLOYEE_NAME | string |
None. |
|
| PATIENT_NAME | string |
None. |
|
| PATIENT_DOB | string |
None. |
|
| PATIENT_RELATION | string |
None. |
|
| PATIENT_RELATIONID | string |
None. |
|
| PRE_AUTH_NO | string |
None. |
|
| PRE_AUTH_TYPE | string |
None. |
|
| PRE_AUTH_REQUEST_DATE | string |
None. |
|
| PRE_AUTH_SENT_DATE | string |
None. |
|
| PRE_AUTH_AMOUNT | string |
None. |
|
| PRE_AUTH_STATUS | string |
None. |
|
| PRE_AUTH_STATUS_DATE | string |
None. |
|
| CLAIM_ID | string |
None. |
|
| CLAIM_TYPE | string |
None. |
|
| ICD_CODE | string |
None. |
|
| AILMENT | string |
None. |
|
| PROCEDURE_NAME | string |
None. |
|
| DATE_OF_ADMISSION | string |
None. |
|
| DATE_OF_DISCHARGE | string |
None. |
|
| CLAIM_RECEIVED_DATE | string |
None. |
|
| CLAIM_AMOUNT | string |
None. |
|
| APPROVED_AMOUNT | string |
None. |
|
| APPROVED_DATE | string |
None. |
|
| DEDUCTION_AMOUNT | string |
None. |
|
| DEDUCTION_REASONS | string |
None. |
|
| SETTLED_DATE | string |
None. |
|
| CHEQUE_AMOUNT | string |
None. |
|
| CHEQUE_NO | string |
None. |
|
| CHEQUE_DATE | string |
None. |
|
| DISPATCH_DATE | string |
None. |
|
| EFT_REF_NO | string |
None. |
|
| EFT_DATE | string |
None. |
|
| CLAIM_STATUS | string |
None. |
|
| STATUS_REASON | string |
None. |
|
| SUM_INSURED | string |
None. |
|
| BALANCE_SUM_INSURED | string |
None. |
|
| HOSPITAL_NAME | string |
None. |
|
| HOSPITAL_CITY | string |
None. |
|
| HOSPITAL_STATE | string |
None. |
|
| DOCUMENT_REQUIRED | string |
None. |
|
| FILE_NO | string |
None. |
|
| HOSPITAL_ADDRESS | string |
None. |
|
| HOSPITAL_PIN | string |
None. |
|
| STATUSDATE | string |
None. |
|
| LETTERLINK | string |
None. |
|
| DATE_QRYRAISED1 | string |
None. |
|
| DATE_QRYRAISED2 | string |
None. |
|
| DATE_QRYRAISED3 | string |
None. |
|
| REASON_QRYRAISED1 | string |
None. |
|
| REASON_QRYRAISED2 | string |
None. |
|
| REASON_QRYRAISED3 | string |
None. |
|
| BUFFER_AMOUNT | string |
None. |
|
| DEFICIENCY_REASON | string |
None. |
|
| DEFICIENCY_DATE | string |
None. |
|
| REJECTION_REASON | string |
None. |
|
| REJECTION_DATE | string |
None. |
|
| CLAIMTYPE_IPD_OPD | string |
None. |
|
| AGE | string |
None. |
|
| GENDER | string |
None. |
|
| FIR_Date | string |
None. |
|
| FIR_Number | string |
None. |
|
| FIR_Extention | string |
None. |
|
| Partial_Payment_Seq | string |
None. |
|
| Additional_Al_Amount | string |
None. |
|
| RoomAndNursingCharges | string |
None. |
|
| ICUCharges | string |
None. |
|
| ConsultationCharges | string |
None. |
|
| ProfessionalFeeCharges | string |
None. |
|
| SurgeryCharges | string |
None. |
|
| MedicineAndConsumablesCharges | string |
None. |
|
| InvestigationCharges | string |
None. |
|
| ImplantCharges | string |
None. |
|
| OtherNonHospitalExpenses | string |
None. |
|
| MiscellaneousCharges | string |
None. |
|
| AmbulanceCharges | string |
None. |
|
| OTCharges | string |
None. |
|
| Nursing_Charges | string |
None. |
|
| Anaesthetist_fees | string |
None. |
|
| Servicetax | string |
None. |
|
| service_charges | string |
None. |
|
| settled_fin_year | string |
None. |
|
| HospitalCityBifurcationTierWise | string |
None. |
|
| ClaimDocumentReceivedDate | string |
None. |
|
| Def_rec_date_from_insured | string |
None. |
|
| FinalDocRecDate | string |
None. |
|
| Designation | string |
None. |
|
| Location | string |
None. |
|
| HospitalDiscount | string |
None. |
|
| IntimationRefNo | string |
None. |
|
| Document | Collection of documentData |
None. |