| Name | Description | Type | Additional information |
|---|---|---|---|
| what_year | string |
None. |
|
| INSURER_NAME | string |
None. |
|
| Broker_Branch_Name | string |
None. |
|
| TPA_NAME | string |
None. |
|
| YEAR | string |
None. |
|
| CORPORATE_NAME | string |
None. |
|
| ENTITY_NAME | string |
None. |
|
| POLICY_NO | string |
None. |
|
| Policy_Start_Date | string |
None. |
|
| Policy_End_Date | string |
None. |
|
| EMPLOYEE_NAME | string |
None. |
|
| EMPLOYEE_NO | string |
None. |
|
| CLAIMANT_NAME | string |
None. |
|
| MEMBER_ID | string |
None. |
|
| RELATION | string |
None. |
|
| AGE | string |
None. |
|
| GENDER | string |
None. |
|
| DOJ | string |
None. |
|
| BASE_SUM_INSURED | string |
None. |
|
| BALANCE_SUM_INSURED | string |
None. |
|
| TOP_UP_SUM_INSURED | string |
None. |
|
| Claim_NO | string |
None. |
|
| TYPE_OF_CLAIM | string |
None. |
|
| Intial_Cashless_Recdate | string |
None. |
|
| Initial_Cashless_RecTime | string |
None. |
|
| QSentDateTime | string |
None. |
|
| QrecieveDateTime | string |
None. |
|
| Cashless_Approval_Date | string |
None. |
|
| Cashless_Approval_Time | string |
None. |
|
| Type | string |
None. |
|
| TAT_in_Minutes | string |
None. |
|
| Date_Of_Admission | string |
None. |
|
| Date_Of_Discharge | string |
None. |
|
| LENGTH_OF_STAY | string |
None. |
|
| CLAIM_RECEIVED_DT | string |
None. |
|
| Reimbursement_Query_Raised_Date | string |
None. |
|
| Reimbursement_Last_Query_Received_date | string |
None. |
|
| CLAIM_AMOUNT | string |
None. |
|
| SETTLED_AMOUNT | string |
None. |
|
| DISALLOWED_AMOUNT | string |
None. |
|
| DISALLOWED_REASON | string |
None. |
|
| CO_PAY_AMOUNT | string |
None. |
|
| DISAALLOWANCE_AS_PER_HIGHER_ROOM_RENT | string |
None. |
|
| DISAALLOWANCE_AS_PER_AILMENT_SUBLIMIT | string |
None. |
|
| DISAALLOWANCE_AS_BSI_EXHAUSTED | string |
None. |
|
| DISAALLOWANCE_AS_PER_OTHER_POLICY_T_C | string |
None. |
|
| STANDARD_DISALLOWANCE | string |
None. |
|
| DISAALLOWANCE_AS_CLAIM_ABOVE_PACKAGE_RATES_MOU | string |
None. |
|
| DISAALLOWANCE_AS_OTHER_NW_DISCOUNTS | string |
None. |
|
| CORPORATE_BUFFER_UTILISED | string |
None. |
|
| BUFFER_AMOUNT_ | string |
None. |
|
| CLAIM_PROCESS_DT | string |
None. |
|
| FLOAT_DATE | string |
None. |
|
| CHQNO | string |
None. |
|
| CHEQUE_ISSUE_SETTLED_DT | string |
None. |
|
| CLAIM_STATUS | string |
None. |
|
| REMARKS_REASONS | string |
None. |
|
| ICD_CODE | string |
None. |
|
| AILMENT_GROUP | string |
None. |
|
| AILMNENT_ILLNESS | string |
None. |
|
| MATERNITY_BREAKUP | string |
None. |
|
| PROCEDURES_SURGICAL_NON_SURGICAL | string |
None. |
|
| AILMENTS_CAPPED | string |
None. |
|
| AILMENT_CAPPED_LIMIT | string |
None. |
|
| HOSPITAL | string |
None. |
|
| NETWORK | string |
None. |
|
| HOSPITAL_PACKAGAE_RATES | string |
None. |
|
| PPN | string |
None. |
|
| TYPE_OF_HOSPITALIZATION | string |
None. |
|
| TYPE_OF_TREATMENT | string |
None. |
|
| CITY | string |
None. |
|
| METRO_NON_METRO | string |
None. |
|
| STATE | string |
None. |
|
| REGION | string |
None. |
|
| PRE_HOSPITALIZATION_AMOUNT | string |
None. |
|
| POST_HOSPITALIZATION_AMOUNT | string |
None. |
|
| NON_MEDICAL_EXPENSES | string |
None. |
|
| ROOM_ACCOMODATION_TYPE | string |
None. |
|
| ROOM_RENT_CLAIMED | string |
None. |
|
| ROOM_RENT_PAID | string |
None. |
|
| PROPORTIONATE_DEDUCTION | string |
None. |
|
| AMOUNT_PAID_BY_PATIENT | string |
None. |
|
| CONSULTATION_CHARGES_CLAIMED | string |
None. |
|
| CONSULTATION_CHARGES_PAID | string |
None. |
|
| PHYSICIAN_CHARGES_CLAIMED | string |
None. |
|
| PHYSICIAN_CHARGES_PAID | string |
None. |
|
| SURGERY_CHARGES_CLAIMED | string |
None. |
|
| SURGERY_CHARGES_PAID | string |
None. |
|
| MEDICINE_CHARGES_CLAIMED | string |
None. |
|
| MEDICINE_CHARGES_PAID | string |
None. |
|
| INVESTIGATION_CHARGES_CLAIMED | string |
None. |
|
| INVESTIGATION_CHARGES_PAID | string |
None. |
|
| MISC_CHARGES | string |
None. |
|
| SERVICE_TAX | string |
None. |
|
| QUERYREASON | string |
None. |
|
| Rejection_remarks | string |
None. |
|
| Rejection_Group | string |
None. |
|
| Rejection_Date | string |
None. |
|
| Covid | string |
None. |
|
| LDR_Date | string |
None. |
|
| UTR_Details | string |
None. |
|
| Rohini_ID | string |
None. |
|
| Hospital_Type | string |
None. |
|
| Hospital_Discount | string |
None. |
|
| IncurredAmt | string |
None. |
|
| Pre_post_expense | string |
None. |
|
| Final_Cashless_Recdate | string |
None. |
|
| Final_Cashless_RecTime | string |
None. |
|
| Initial_Cashless_Approval_Date | string |
None. |
|
| Initial_Cashless_Approval_Time | string |
None. |
|
| IPD_OPD | string |
None. |
|
| Reject_Exclusion_Clause_Code | string |
None. |