Schema Info

Schema Name: sfdl_dev_json.storsmartzoho_storsmart_claims
  • created: 2023-09-20 18:04:55
  • disabled: False
  • format: raw
  • id: 2240
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_dev_json",
    "table": "storsmartzoho_storsmart_claims"
}
  • type: json
Schema Versions: 3
    • created: 2025-06-10 16:00:20
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_json`",
    "DROP TABLE IF EXISTS `sfdl_dev_json.storsmartzoho_storsmart_claims`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_json.storsmartzoho_storsmart_claims`\n(\n`Id`string,`Claims_Name`string,`Claims_Owner_1`string,`Claims_Owner_Name`string,`Created_Time`string,`Modified_Time`string,`Last_Activity_Time`string,`Claim_Reserve_Amount`string,`Initial_Report_Date`string,`Approved_By`string,`Date_Closed`string,`Final_Payment`string,`Adjustment_Cost`string,`Additional_Costs`string,`Facility_City`string,`Modified_the_following`string,`Facility_Name`string,`Claim_Number`string,`Facility_Address`string,`Insured___Last_Name`STRING,`Insured___First_Name`STRING,`Date_of_Loss`string,`Date_of_Claim`string,`Premium_Paid_Thru`string,`Zip_Code`string,`Unit_Number`string,`Coverage_Limit`string,`Coverage_Start_Date`string,`Coverage_End_Date`string,`Deductible_Amount`string,`Enrollment_Method`string,`Facility_State`string,`Claim_Status`string,`Manager_Name`string,`Phone_Number`string,`email_address`string,`Premium_Due`string,`Reason_Still_Open`string,`Confirmed_and_Sent`string,`Facility_Name___Nixon`STRING,`Cause_of_Loss_Code`string,`Secondary_Cause_of_Loss_Code`string,`Secondary_Cause_of_Loss_3`string,`Secondary_Reason_for_Denial_3`string,`Reason_for_Denial_Code`string,`Secondary_Reason_for_Denial_Code`string,`Mass_uploaded_info`string,`Vermin_Coverage`string,`Reserve_for_Adjustment`string,`Paid`string,`Reserve___Claims___Adjustment`STRING,`Total_All`string,`Total_Open_Claims`string,`Total_Claims`string,`Reconciled___Nixon_Check_Register`STRING,`Cause_of_Loss`string,`Stated_Cause_of_Loss`string,`Reason_for_Denial`string,`Re_opened_Claim`STRING,`AIG___Storage_Ceded_Premiums`STRING,`Email`string,`Certificate_Number`string,`Date_Approved`string,`Days_Since_Approved`string,`Pending_Payment`string,`Subtract_Month`string,`Corp_Group`string,`Days_Since_Confirmed`string,`Days_Since_First_Report`string,`Days_Since_Created`string,`Confirm_Complete`string,`14_Day_Letter_Sent`string,`Days_to_Close`string,`Created_to_Initial_Report_Date`string,`Created_By`string,`Modified_By`string,`Claim_Re_opened_Date`STRING,`Reopened_Claim_Reference`string,`Facility_Address___Nixon`STRING,`Subgrogated_Claim`string,`Subrogated_Claim_Payment`string,`Subrogated_Payment_Date`string,`Secondary_Cause_of_Loss`string,`Secondary_Reason_for_Denial`string,`Server_Update_ID`string,`Initial_report_date_filled`string,`Reason_for_Denial_Code_is_Null`string,`Reason_for_denial_is_null`string,`Cause_of_Loss_is_Null`string,`Cause_of_Loss_Code_is_Null`string,`Zoho_Claims_Record_Link`string,`Error_Codes`string,`Initial_Report_to_Approval`string,`Claims_Paid_1`string,`Initial_Report_to_Date_Closed`string,`14_Day_Letter_Yes`string,`Initial_Report_Date_Null`string,`Approved_to_Close`string,`Created_to_Approved`string,`zcrmid`string,`Policy_Name`string,`O_C_Stat`STRING,`Insured`string,`TIV_for_Location`string,`Ind_O_S___Scott`STRING,`Ind_Paid___Scott`STRING,`Exp_Paid___Scott`STRING,`Exp_O_S___Scott`STRING,`Total_Value___Scott`STRING,`Hours_since_created`bigint,`zcrm_claimid`string,`Facility_Number`string,`Insured_ID___Insuratrac`STRING,`Claim_Type`string,`Bader_Renter_Liability_Claim`string,`Renter_Liability`string,`Claim_Types`string,`Claim_Count__Descriptions`string,`Date_Closed_Null`string,`Timestamp_Confirmation_Sent`string,`Full_Address_no_Zip`string,`After_8_31_19`STRING,`Corp_Group_Doesnt_Match`STRING,`Nixon_Processor`string,`Nixon_Processor_Email`string,`Pending_Approval`string,`Pending_Approval_Hidden`string,`Bader_Archive_Claim_ID`string,`RCV_Payment`string,`ALE_Payment`string,`Indemnity_Payment`string,`Date_of_Claim_to_Approval`string,`Days_to_Close_from_DOC`string,`DOC_Count`string,`PMA_AIG`STRING,`Reviewed_CXLD_Facility_Claim`string,`Reviewed_Double_Check`string,`Filter___REVIEWED_CXLD_CLAIM`STRING,`Filter___REVIEWED_STREET_OR_ID_MISMATCH`STRING,`No_Coverage_Reason`string,`Nixon_Old_Claim_Number`string,`Not_PMA_Kathy_Facility_ID`string,`Not_PMA_Kathy_Corp_Group`string,`Combined_old___New_Claim_Number`STRING,`Exclude_Bader___Nixon_LAE_transition`STRING,`OPENCLAIMS`string,`PMA___Storage_Ceded_Premiums`STRING,`PMA___Apartments_Ceded_Premiums`STRING,`Open_Claim_Count`string,`Indemnity_Cost`string,`zcrm_company_id`string,`Paid_Claim_Count`string,`ADJ_COSTS`string,`zoho_crm_claim_link`string,`Open_Claim_Yes`string,`Nixon_Cat_Loss_Tags`string,`Date_ID_Variable`string,`Error_Claim`string\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-storsmartzoho-dev/raw/storsmart_claims/2025-06-10/1749588942'\n",
    "MSCK REPAIR TABLE sfdl_dev_json.storsmartzoho_storsmart_claims"
]
    • hive_path: s3://sfdl-json-storsmartzoho-dev/raw/storsmart_claims/2025-06-10/1749588942
    • id: 4760282
    • processed: 1
    • raw_data: 
      {
    "14_Day_Letter_Sent": "No",
    "14_Day_Letter_Yes": "0",
    "ADJ_COSTS": "175",
    "AIG___Storage_Ceded_Premiums": "",
    "ALE_Payment": "",
    "Additional_Costs": "",
    "Adjustment_Cost": "",
    "After_8_31_19": "NO",
    "Approved_By": "Pam Locke",
    "Approved_to_Close": "",
    "Bader_Archive_Claim_ID": "",
    "Bader_Renter_Liability_Claim": "No",
    "Cause_of_Loss": "Water Damage",
    "Cause_of_Loss_Code": "11",
    "Cause_of_Loss_Code_is_Null": "0",
    "Cause_of_Loss_is_Null": "0",
    "Certificate_Number": "2738-8-I95-06/20/22",
    "Claim_Count__Descriptions": "PMA - Storage",
    "Claim_Number": "60222-169882",
    "Claim_Re_opened_Date": "",
    "Claim_Reserve_Amount": "$ 0.00",
    "Claim_Status": "Closed",
    "Claim_Type": "",
    "Claim_Types": "PMA - Storage",
    "Claims_Name": "Weldon 12-16-22",
    "Claims_Owner_1": "404206000028908186",
    "Claims_Owner_Name": "Ron Rider Jr.",
    "Claims_Paid_1": "1",
    "Combined_old___New_Claim_Number": "60222-169882",
    "Confirm_Complete": "Dec 27, 2022",
    "Confirmed_and_Sent": "Yes",
    "Corp_Group": "B.2738 - A-Family Storage, LLC",
    "Corp_Group_Doesnt_Match": "FIX",
    "Coverage_End_Date": "Dec 17, 2022",
    "Coverage_Limit": "$ 2,000.00",
    "Coverage_Start_Date": "Jun 20, 2022",
    "Created_By": "404206000028908186",
    "Created_Time": "Dec 20, 2022 10:31 AM",
    "Created_to_Approved": "",
    "Created_to_Initial_Report_Date": "10",
    "DOC_Count": "1",
    "Date_Approved": "",
    "Date_Closed": "Jan 05, 2023",
    "Date_Closed_Null": "2023-01-05 00:00:00",
    "Date_ID_Variable": "DECEMBER2022",
    "Date_of_Claim": "Dec 20, 2022",
    "Date_of_Claim_to_Approval": "",
    "Date_of_Loss": "Dec 16, 2022",
    "Days_Since_Approved": "",
    "Days_Since_Confirmed": "903",
    "Days_Since_Created": "903",
    "Days_Since_First_Report": "893",
    "Days_to_Close": "16",
    "Days_to_Close_from_DOC": "16",
    "Deductible_Amount": "$0.00",
    "Email": "",
    "Enrollment_Method": "",
    "Error_Claim": "",
    "Error_Codes": "0",
    "Exclude_Bader___Nixon_LAE_transition": "",
    "Exp_O_S___Scott": "175",
    "Exp_Paid___Scott": "0",
    "Facility_Address": "3939 N. Romero Road",
    "Facility_Address___Nixon": "3939 N. Romero Road Tuson AZ 85747, Tucson, AZ, 85705",
    "Facility_City": "Tuson",
    "Facility_Name": "404206000062901542",
    "Facility_Name___Nixon": "B.2738 - A-Family Discount Storage: B.AZ.2738.8",
    "Facility_Number": "B.AZ.2738.8",
    "Facility_State": "AZ",
    "Filter___REVIEWED_CXLD_CLAIM": "",
    "Filter___REVIEWED_STREET_OR_ID_MISMATCH": "",
    "Final_Payment": "$ 145.98",
    "Full_Address_no_Zip": "3939 N. Romero Road Tuson, AZ",
    "Hours_since_created": "21682",
    "Id": "404206000292028238",
    "Ind_O_S___Scott": "0",
    "Ind_Paid___Scott": "145.98",
    "Indemnity_Cost": "145.98",
    "Indemnity_Payment": "",
    "Initial_Report_Date": "Dec 30, 2022",
    "Initial_Report_Date_Null": "0",
    "Initial_Report_to_Approval": "",
    "Initial_Report_to_Date_Closed": "6",
    "Initial_report_date_filled": "Yes",
    "Insured": "Weldon, Kathy",
    "Insured_ID___Insuratrac": "",
    "Insured___First_Name": "Kathy",
    "Insured___Last_Name": "Weldon",
    "Last_Activity_Time": "Mar 02, 2023 11:57 AM",
    "Manager_Name": "Susan Gylling",
    "Mass_uploaded_info": "No",
    "Modified_By": "404206000261587005",
    "Modified_Time": "Mar 02, 2023 11:57 AM",
    "Modified_the_following": "Insured Last Name;Certificate Number;Facility Name",
    "Nixon_Cat_Loss_Tags": "",
    "Nixon_Old_Claim_Number": "",
    "Nixon_Processor": "Connie",
    "Nixon_Processor_Email": "[email protected]",
    "No_Coverage_Reason": "",
    "Not_PMA_Kathy_Corp_Group": "B.2738 - A-Family Storage, LLC",
    "Not_PMA_Kathy_Facility_ID": "B.AZ.2738.8",
    "OPENCLAIMS": "0",
    "O_C_Stat": "C",
    "Open_Claim_Count": "0",
    "Open_Claim_Yes": "0",
    "PMA_AIG": "PMA - Storage",
    "PMA___Apartments_Ceded_Premiums": "",
    "PMA___Storage_Ceded_Premiums": "",
    "Paid": "$ 145.98",
    "Paid_Claim_Count": "1",
    "Pending_Approval": "No",
    "Pending_Approval_Hidden": "",
    "Pending_Payment": "$ 0.00",
    "Phone_Number": "(520) 293-7191",
    "Policy_Name": "Storsmart Insurance",
    "Premium_Due": "No Premium Due",
    "Premium_Paid_Thru": "Dec 20, 2022",
    "RCV_Payment": "",
    "Re_opened_Claim": "No",
    "Reason_Still_Open": "",
    "Reason_for_Denial": "",
    "Reason_for_Denial_Code": "",
    "Reason_for_Denial_Code_is_Null": "1",
    "Reason_for_denial_is_null": "1",
    "Reconciled___Nixon_Check_Register": "No",
    "Renter_Liability": "",
    "Reopened_Claim_Reference": "",
    "Reserve___Claims___Adjustment": "$ 175.00",
    "Reserve_for_Adjustment": "$ 175.00",
    "Reviewed_CXLD_Facility_Claim": "No",
    "Reviewed_Double_Check": "",
    "Secondary_Cause_of_Loss": "",
    "Secondary_Cause_of_Loss_3": "",
    "Secondary_Cause_of_Loss_Code": "",
    "Secondary_Reason_for_Denial": "",
    "Secondary_Reason_for_Denial_3": "",
    "Secondary_Reason_for_Denial_Code": "",
    "Server_Update_ID": "16731306818069112811214113221513",
    "Stated_Cause_of_Loss": "Water Damage",
    "Subgrogated_Claim": "No",
    "Subrogated_Claim_Payment": "",
    "Subrogated_Payment_Date": "",
    "Subtract_Month": "5",
    "TIV_for_Location": "2000",
    "Timestamp_Confirmation_Sent": "",
    "Total_All": "$ 320.98",
    "Total_Claims": "1",
    "Total_Open_Claims": "0",
    "Total_Value___Scott": "320.98",
    "Unit_Number": "I95",
    "Vermin_Coverage": "",
    "Zip_Code": "85747",
    "Zoho_Claims_Record_Link": "https://crm.zoho.com/crm/EntityInfo.do?module=CustomModule2&id=404206000292028238",
    "email_address": "",
    "zcrm_claimid": "zcrm_404206000292028238",
    "zcrm_company_id": "zcrm_404206000062901542",
    "zcrmid": "zcrm_404206000292028238",
    "zoho_crm_claim_link": "https://crm.zoho.com/crm/EntityInfo.do?module=CustomModule2&id=404206000292028238"
}
    • schema_attributes: 
      {
    "14_Day_Letter_Sent": "string",
    "14_Day_Letter_Yes": "string",
    "ADJ_COSTS": "string",
    "AIG___Storage_Ceded_Premiums": "string",
    "ALE_Payment": "string",
    "Additional_Costs": "string",
    "Adjustment_Cost": "string",
    "After_8_31_19": "string",
    "Approved_By": "string",
    "Approved_to_Close": "string",
    "Bader_Archive_Claim_ID": "string",
    "Bader_Renter_Liability_Claim": "string",
    "Cause_of_Loss": "string",
    "Cause_of_Loss_Code": "string",
    "Cause_of_Loss_Code_is_Null": "string",
    "Cause_of_Loss_is_Null": "string",
    "Certificate_Number": "string",
    "Claim_Count__Descriptions": "string",
    "Claim_Number": "string",
    "Claim_Re_opened_Date": "string",
    "Claim_Reserve_Amount": "string",
    "Claim_Status": "string",
    "Claim_Type": "string",
    "Claim_Types": "string",
    "Claims_Name": "string",
    "Claims_Owner_1": "string",
    "Claims_Owner_Name": "string",
    "Claims_Paid_1": "string",
    "Combined_old___New_Claim_Number": "string",
    "Confirm_Complete": "string",
    "Confirmed_and_Sent": "string",
    "Corp_Group": "string",
    "Corp_Group_Doesnt_Match": "string",
    "Coverage_End_Date": "string",
    "Coverage_Limit": "string",
    "Coverage_Start_Date": "string",
    "Created_By": "string",
    "Created_Time": "string",
    "Created_to_Approved": "string",
    "Created_to_Initial_Report_Date": "string",
    "DOC_Count": "string",
    "Date_Approved": "string",
    "Date_Closed": "string",
    "Date_Closed_Null": "string",
    "Date_ID_Variable": "string",
    "Date_of_Claim": "string",
    "Date_of_Claim_to_Approval": "string",
    "Date_of_Loss": "string",
    "Days_Since_Approved": "string",
    "Days_Since_Confirmed": "string",
    "Days_Since_Created": "string",
    "Days_Since_First_Report": "string",
    "Days_to_Close": "string",
    "Days_to_Close_from_DOC": "string",
    "Deductible_Amount": "string",
    "Email": "string",
    "Enrollment_Method": "string",
    "Error_Claim": "string",
    "Error_Codes": "string",
    "Exclude_Bader___Nixon_LAE_transition": "string",
    "Exp_O_S___Scott": "bigint",
    "Exp_Paid___Scott": "bigint",
    "Facility_Address": "string",
    "Facility_Address___Nixon": "string",
    "Facility_City": "string",
    "Facility_Name": "string",
    "Facility_Name___Nixon": "string",
    "Facility_Number": "string",
    "Facility_State": "string",
    "Filter___REVIEWED_CXLD_CLAIM": "string",
    "Filter___REVIEWED_STREET_OR_ID_MISMATCH": "string",
    "Final_Payment": "string",
    "Full_Address_no_Zip": "string",
    "Hours_since_created": "bigint",
    "Id": "string",
    "Ind_O_S___Scott": "string",
    "Ind_Paid___Scott": "bigint",
    "Indemnity_Cost": "string",
    "Indemnity_Payment": "string",
    "Initial_Report_Date": "string",
    "Initial_Report_Date_Null": "string",
    "Initial_Report_to_Approval": "string",
    "Initial_Report_to_Date_Closed": "string",
    "Initial_report_date_filled": "string",
    "Insured": "string",
    "Insured_ID___Insuratrac": "string",
    "Insured___First_Name": "string",
    "Insured___Last_Name": "string",
    "Last_Activity_Time": "string",
    "Manager_Name": "string",
    "Mass_uploaded_info": "string",
    "Modified_By": "string",
    "Modified_Time": "string",
    "Modified_the_following": "string",
    "Nixon_Cat_Loss_Tags": "string",
    "Nixon_Old_Claim_Number": "string",
    "Nixon_Processor": "string",
    "Nixon_Processor_Email": "string",
    "No_Coverage_Reason": "string",
    "Not_PMA_Kathy_Corp_Group": "string",
    "Not_PMA_Kathy_Facility_ID": "string",
    "OPENCLAIMS": "string",
    "O_C_Stat": "string",
    "Open_Claim_Count": "string",
    "Open_Claim_Yes": "string",
    "PMA_AIG": "string",
    "PMA___Apartments_Ceded_Premiums": "string",
    "PMA___Storage_Ceded_Premiums": "string",
    "Paid": "string",
    "Paid_Claim_Count": "string",
    "Pending_Approval": "string",
    "Pending_Approval_Hidden": "string",
    "Pending_Payment": "string",
    "Phone_Number": "string",
    "Policy_Name": "string",
    "Premium_Due": "string",
    "Premium_Paid_Thru": "string",
    "RCV_Payment": "string",
    "Re_opened_Claim": "string",
    "Reason_Still_Open": "string",
    "Reason_for_Denial": "string",
    "Reason_for_Denial_Code": "string",
    "Reason_for_Denial_Code_is_Null": "string",
    "Reason_for_denial_is_null": "string",
    "Reconciled___Nixon_Check_Register": "string",
    "Renter_Liability": "string",
    "Reopened_Claim_Reference": "string",
    "Reserve___Claims___Adjustment": "string",
    "Reserve_for_Adjustment": "string",
    "Reviewed_CXLD_Facility_Claim": "string",
    "Reviewed_Double_Check": "string",
    "Secondary_Cause_of_Loss": "string",
    "Secondary_Cause_of_Loss_3": "string",
    "Secondary_Cause_of_Loss_Code": "string",
    "Secondary_Reason_for_Denial": "string",
    "Secondary_Reason_for_Denial_3": "string",
    "Secondary_Reason_for_Denial_Code": "string",
    "Server_Update_ID": "string",
    "Stated_Cause_of_Loss": "string",
    "Subgrogated_Claim": "string",
    "Subrogated_Claim_Payment": "string",
    "Subrogated_Payment_Date": "string",
    "Subtract_Month": "string",
    "TIV_for_Location": "string",
    "Timestamp_Confirmation_Sent": "string",
    "Total_All": "string",
    "Total_Claims": "string",
    "Total_Open_Claims": "string",
    "Total_Value___Scott": "string",
    "Unit_Number": "string",
    "Vermin_Coverage": "string",
    "Zip_Code": "string",
    "Zoho_Claims_Record_Link": "string",
    "email_address": "string",
    "zcrm_claimid": "string",
    "zcrm_company_id": "string",
    "zcrmid": "string",
    "zoho_crm_claim_link": "string"
}
    • schema_name_id: 2240
    • schema_scan_id: 6808741
    • updated: 2025-06-10 16:00:31
    • created: 2024-09-26 15:20:13
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_json`",
    "DROP TABLE IF EXISTS `sfdl_dev_json.storsmartzoho_storsmart_claims`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_json.storsmartzoho_storsmart_claims`\n(\n`Id`string,`Claims_Name`string,`Claims_Owner_1`string,`Claims_Owner_Name`string,`Created_Time`string,`Modified_Time`string,`Last_Activity_Time`string,`Claim_Reserve_Amount`string,`Initial_Report_Date`string,`Approved_By`string,`Date_Closed`string,`Final_Payment`string,`Adjustment_Cost`string,`Additional_Costs`string,`Facility_City`string,`Modified_the_following`string,`Facility_Name`string,`Claim_Number`string,`Facility_Address`string,`Insured___Last_Name`STRING,`Insured___First_Name`STRING,`Date_of_Loss`string,`Date_of_Claim`string,`Premium_Paid_Thru`string,`Zip_Code`string,`Unit_Number`string,`Coverage_Limit`string,`Coverage_Start_Date`string,`Coverage_End_Date`string,`Deductible_Amount`string,`Enrollment_Method`string,`Facility_State`string,`Claim_Status`string,`Manager_Name`string,`Phone_Number`string,`email_address`string,`Premium_Due`string,`Reason_Still_Open`string,`Confirmed_and_Sent`string,`Facility_Name___Nixon`STRING,`Cause_of_Loss_Code`string,`Secondary_Cause_of_Loss_Code`string,`Secondary_Cause_of_Loss_3`string,`Secondary_Reason_for_Denial_3`string,`Reason_for_Denial_Code`string,`Secondary_Reason_for_Denial_Code`string,`Mass_uploaded_info`string,`Vermin_Coverage`string,`Reserve_for_Adjustment`string,`Paid`string,`Reserve___Claims___Adjustment`STRING,`Total_All`string,`Total_Open_Claims`string,`Total_Claims`string,`Reconciled___Nixon_Check_Register`STRING,`Cause_of_Loss`string,`Stated_Cause_of_Loss`string,`Reason_for_Denial`string,`Re_opened_Claim`STRING,`AIG___Storage_Ceded_Premiums`STRING,`Email`string,`Certificate_Number`string,`Date_Approved`string,`Days_Since_Approved`string,`Pending_Payment`string,`Subtract_Month`string,`Corp_Group`string,`Days_Since_Confirmed`string,`Days_Since_First_Report`string,`Days_Since_Created`string,`Confirm_Complete`string,`14_Day_Letter_Sent`string,`Days_to_Close`string,`Created_to_Initial_Report_Date`string,`Created_By`string,`Modified_By`string,`Claim_Re_opened_Date`STRING,`Reopened_Claim_Reference`string,`Facility_Address___Nixon`STRING,`Subgrogated_Claim`string,`Subrogated_Claim_Payment`string,`Subrogated_Payment_Date`string,`Secondary_Cause_of_Loss`string,`Secondary_Reason_for_Denial`string,`Server_Update_ID`string,`Initial_report_date_filled`string,`Reason_for_Denial_Code_is_Null`string,`Reason_for_denial_is_null`string,`Cause_of_Loss_is_Null`string,`Cause_of_Loss_Code_is_Null`string,`Zoho_Claims_Record_Link`string,`Error_Codes`string,`Initial_Report_to_Approval`string,`Claims_Paid_1`string,`Initial_Report_to_Date_Closed`string,`14_Day_Letter_Yes`string,`Initial_Report_Date_Null`string,`Approved_to_Close`string,`Created_to_Approved`string,`zcrmid`string,`Policy_Name`string,`O_C_Stat`STRING,`Insured`string,`TIV_for_Location`string,`Ind_O_S___Scott`STRING,`Ind_Paid___Scott`STRING,`Exp_Paid___Scott`STRING,`Exp_O_S___Scott`STRING,`Total_Value___Scott`STRING,`Hours_since_created`bigint,`zcrm_claimid`string,`Facility_Number`string,`Insured_ID___Insuratrac`STRING,`Claim_Type`string,`Bader_Renter_Liability_Claim`string,`Renter_Liability`string,`Claim_Types`string,`Claim_Count__Descriptions`string,`Date_Closed_Null`string,`Timestamp_Confirmation_Sent`string,`Full_Address_no_Zip`string,`After_8_31_19`STRING,`Corp_Group_Doesnt_Match`STRING,`Nixon_Processor`string,`Nixon_Processor_Email`string,`Pending_Approval`string,`Pending_Approval_Hidden`string,`Bader_Archive_Claim_ID`string,`RCV_Payment`string,`ALE_Payment`string,`Indemnity_Payment`string,`Date_of_Claim_to_Approval`string,`Days_to_Close_from_DOC`string,`DOC_Count`string,`PMA_AIG`STRING,`Reviewed_CXLD_Facility_Claim`string,`Reviewed_Double_Check`string,`Filter___REVIEWED_CXLD_CLAIM`STRING,`Filter___REVIEWED_STREET_OR_ID_MISMATCH`STRING,`No_Coverage_Reason`string,`Nixon_Old_Claim_Number`string,`Not_PMA_Kathy_Facility_ID`string,`Not_PMA_Kathy_Corp_Group`string,`Combined_old___New_Claim_Number`STRING,`Exclude_Bader___Nixon_LAE_transition`STRING,`OPENCLAIMS`string,`PMA___Storage_Ceded_Premiums`STRING,`PMA___Apartments_Ceded_Premiums`STRING,`Open_Claim_Count`string,`Indemnity_Cost`string,`zcrm_company_id`string,`Paid_Claim_Count`string,`ADJ_COSTS`string,`zoho_crm_claim_link`string,`Open_Claim_Yes`string,`Nixon_Cat_Loss_Tags`string,`Date_ID_Variable`string,`Error_Claim`string\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-storsmartzoho-dev/raw/storsmart_claims/2024-09-26/1727381737'\n",
    "MSCK REPAIR TABLE sfdl_dev_json.storsmartzoho_storsmart_claims"
]
    • hive_path: s3://sfdl-json-storsmartzoho-dev/raw/storsmart_claims/2024-09-26/1727381737
    • id: 4710965
    • processed: 1
    • raw_data: 
      {
    "14_Day_Letter_Sent": "No",
    "14_Day_Letter_Yes": "0",
    "ADJ_COSTS": "175",
    "AIG___Storage_Ceded_Premiums": "",
    "ALE_Payment": "",
    "Additional_Costs": "$ 0.00",
    "Adjustment_Cost": "$ 175.00",
    "After_8_31_19": "NO",
    "Approved_By": "Rob Thompkins",
    "Approved_to_Close": "",
    "Bader_Archive_Claim_ID": "",
    "Bader_Renter_Liability_Claim": "No",
    "Cause_of_Loss": "Water Damage",
    "Cause_of_Loss_Code": "11",
    "Cause_of_Loss_Code_is_Null": "0",
    "Cause_of_Loss_is_Null": "0",
    "Certificate_Number": "NJ13301VE008062614",
    "Claim_Count__Descriptions": "AIG - Storage",
    "Claim_Number": "60222-107107",
    "Claim_Re_opened_Date": "",
    "Claim_Reserve_Amount": "$ 0.00",
    "Claim_Status": "Closed",
    "Claim_Type": "AIG - Storage",
    "Claim_Types": "AIG - Storage",
    "Claims_Name": "Pena 8-13-14",
    "Claims_Owner_1": "404206000003335001",
    "Claims_Owner_Name": "Brittany Billings",
    "Claims_Paid_1": "1",
    "Combined_old___New_Claim_Number": "STM2014107107",
    "Confirm_Complete": "Aug 15, 2014",
    "Confirmed_and_Sent": "Yes",
    "Corp_Group": "Columbia Storage Group, LLC - 10289",
    "Corp_Group_Doesnt_Match": "FIX",
    "Coverage_End_Date": "Aug 31, 2014",
    "Coverage_Limit": "$ 2,000.00",
    "Coverage_Start_Date": "Jun 26, 2014",
    "Created_By": "404206000003335001",
    "Created_Time": "Aug 15, 2014 11:31 AM",
    "Created_to_Approved": "",
    "Created_to_Initial_Report_Date": "0",
    "DOC_Count": "1",
    "Date_Approved": "",
    "Date_Closed": "Sep 16, 2014",
    "Date_Closed_Null": "2014-09-16 00:00:00",
    "Date_ID_Variable": "AUGUST2014",
    "Date_of_Claim": "Aug 15, 2014",
    "Date_of_Claim_to_Approval": "",
    "Date_of_Loss": "Aug 13, 2014",
    "Days_Since_Approved": "",
    "Days_Since_Confirmed": "3695",
    "Days_Since_Created": "3695",
    "Days_Since_First_Report": "3695",
    "Days_to_Close": "32",
    "Days_to_Close_from_DOC": "32",
    "Deductible_Amount": "$100",
    "Email": "",
    "Enrollment_Method": "Election Agreement",
    "Error_Claim": "",
    "Error_Codes": "0",
    "Exclude_Bader___Nixon_LAE_transition": "",
    "Exp_O_S___Scott": "0",
    "Exp_Paid___Scott": "175",
    "Facility_Address": "5400 Harding Highway",
    "Facility_Address___Nixon": "",
    "Facility_City": "Mays Landing",
    "Facility_Name": "404206000002731046",
    "Facility_Name___Nixon": "",
    "Facility_Number": "NJ13301",
    "Facility_State": "NJ",
    "Filter___REVIEWED_CXLD_CLAIM": "",
    "Filter___REVIEWED_STREET_OR_ID_MISMATCH": "",
    "Final_Payment": "$ 2,000.00",
    "Full_Address_no_Zip": "5400 Harding Highway Mays Landing, NJ",
    "Hours_since_created": "88688",
    "Id": "404206000003583129",
    "Ind_O_S___Scott": "0",
    "Ind_Paid___Scott": "2000",
    "Indemnity_Cost": "2000",
    "Indemnity_Payment": "",
    "Initial_Report_Date": "Aug 15, 2014",
    "Initial_Report_Date_Null": "0",
    "Initial_Report_to_Approval": "",
    "Initial_Report_to_Date_Closed": "32",
    "Initial_report_date_filled": "",
    "Insured": "Pena, Ayerim",
    "Insured_ID___Insuratrac": "",
    "Insured___First_Name": "Ayerim",
    "Insured___Last_Name": "Pena",
    "Last_Activity_Time": "Oct 01, 2021 09:19 AM",
    "Manager_Name": "Michal Eichhorn",
    "Mass_uploaded_info": "No",
    "Modified_By": "404206000050676001",
    "Modified_Time": "Oct 01, 2021 09:19 AM",
    "Modified_the_following": "Certificate Number",
    "Nixon_Cat_Loss_Tags": "",
    "Nixon_Old_Claim_Number": "STM2014107107",
    "Nixon_Processor": "",
    "Nixon_Processor_Email": "",
    "No_Coverage_Reason": "",
    "Not_PMA_Kathy_Corp_Group": "Not PMA - Columbia Storage Group, LLC - 10289",
    "Not_PMA_Kathy_Facility_ID": "Not PMA - NJ13301",
    "OPENCLAIMS": "0",
    "O_C_Stat": "C",
    "Open_Claim_Count": "0",
    "Open_Claim_Yes": "0",
    "PMA_AIG": "AIG",
    "PMA___Apartments_Ceded_Premiums": "",
    "PMA___Storage_Ceded_Premiums": "",
    "Paid": "$ 2,175.00",
    "Paid_Claim_Count": "1",
    "Pending_Approval": "No",
    "Pending_Approval_Hidden": "",
    "Pending_Payment": "",
    "Phone_Number": "(609) 498-6003",
    "Policy_Name": "Storsmart Insurance",
    "Premium_Due": "No Premium Due",
    "Premium_Paid_Thru": "Aug 31, 2014",
    "RCV_Payment": "",
    "Re_opened_Claim": "No",
    "Reason_Still_Open": "",
    "Reason_for_Denial": "",
    "Reason_for_Denial_Code": "",
    "Reason_for_Denial_Code_is_Null": "1",
    "Reason_for_denial_is_null": "1",
    "Reconciled___Nixon_Check_Register": "No",
    "Renter_Liability": "",
    "Reopened_Claim_Reference": "",
    "Reserve___Claims___Adjustment": "$ 0.00",
    "Reserve_for_Adjustment": "$ 0.00",
    "Reviewed_CXLD_Facility_Claim": "No",
    "Reviewed_Double_Check": "",
    "Secondary_Cause_of_Loss": "",
    "Secondary_Cause_of_Loss_3": "",
    "Secondary_Cause_of_Loss_Code": "",
    "Secondary_Reason_for_Denial": "",
    "Secondary_Reason_for_Denial_3": "",
    "Secondary_Reason_for_Denial_Code": "",
    "Server_Update_ID": "",
    "Stated_Cause_of_Loss": "Water/ Mold Damage - mattress, box spring, couch, table",
    "Subgrogated_Claim": "No",
    "Subrogated_Claim_Payment": "",
    "Subrogated_Payment_Date": "",
    "Subtract_Month": "0",
    "TIV_for_Location": "2000",
    "Timestamp_Confirmation_Sent": "",
    "Total_All": "$ 2,175.00",
    "Total_Claims": "1",
    "Total_Open_Claims": "0",
    "Total_Value___Scott": "2175",
    "Unit_Number": "E008",
    "Vermin_Coverage": "",
    "Zip_Code": "08330",
    "Zoho_Claims_Record_Link": "https://crm.zoho.com/crm/EntityInfo.do?module=CustomModule2&id=404206000003583129",
    "email_address": "[email protected]",
    "zcrm_claimid": "zcrm_404206000003583129",
    "zcrm_company_id": "zcrm_404206000002731046",
    "zcrmid": "zcrm_404206000003583129",
    "zoho_crm_claim_link": "https://crm.zoho.com/crm/EntityInfo.do?module=CustomModule2&id=404206000003583129"
}
    • schema_attributes: 
      {
    "14_Day_Letter_Sent": "string",
    "14_Day_Letter_Yes": "string",
    "ADJ_COSTS": "string",
    "AIG___Storage_Ceded_Premiums": "string",
    "ALE_Payment": "string",
    "Additional_Costs": "string",
    "Adjustment_Cost": "string",
    "After_8_31_19": "string",
    "Approved_By": "string",
    "Approved_to_Close": "string",
    "Bader_Archive_Claim_ID": "string",
    "Bader_Renter_Liability_Claim": "string",
    "Cause_of_Loss": "string",
    "Cause_of_Loss_Code": "string",
    "Cause_of_Loss_Code_is_Null": "string",
    "Cause_of_Loss_is_Null": "string",
    "Certificate_Number": "string",
    "Claim_Count__Descriptions": "string",
    "Claim_Number": "string",
    "Claim_Re_opened_Date": "string",
    "Claim_Reserve_Amount": "string",
    "Claim_Status": "string",
    "Claim_Type": "string",
    "Claim_Types": "string",
    "Claims_Name": "string",
    "Claims_Owner_1": "string",
    "Claims_Owner_Name": "string",
    "Claims_Paid_1": "string",
    "Combined_old___New_Claim_Number": "string",
    "Confirm_Complete": "string",
    "Confirmed_and_Sent": "string",
    "Corp_Group": "string",
    "Corp_Group_Doesnt_Match": "string",
    "Coverage_End_Date": "string",
    "Coverage_Limit": "string",
    "Coverage_Start_Date": "string",
    "Created_By": "string",
    "Created_Time": "string",
    "Created_to_Approved": "string",
    "Created_to_Initial_Report_Date": "string",
    "DOC_Count": "string",
    "Date_Approved": "string",
    "Date_Closed": "string",
    "Date_Closed_Null": "string",
    "Date_ID_Variable": "string",
    "Date_of_Claim": "string",
    "Date_of_Claim_to_Approval": "string",
    "Date_of_Loss": "string",
    "Days_Since_Approved": "string",
    "Days_Since_Confirmed": "string",
    "Days_Since_Created": "string",
    "Days_Since_First_Report": "string",
    "Days_to_Close": "string",
    "Days_to_Close_from_DOC": "string",
    "Deductible_Amount": "string",
    "Email": "string",
    "Enrollment_Method": "string",
    "Error_Claim": "string",
    "Error_Codes": "string",
    "Exclude_Bader___Nixon_LAE_transition": "string",
    "Exp_O_S___Scott": "bigint",
    "Exp_Paid___Scott": "string",
    "Facility_Address": "string",
    "Facility_Address___Nixon": "string",
    "Facility_City": "string",
    "Facility_Name": "string",
    "Facility_Name___Nixon": "string",
    "Facility_Number": "string",
    "Facility_State": "string",
    "Filter___REVIEWED_CXLD_CLAIM": "string",
    "Filter___REVIEWED_STREET_OR_ID_MISMATCH": "string",
    "Final_Payment": "string",
    "Full_Address_no_Zip": "string",
    "Hours_since_created": "bigint",
    "Id": "string",
    "Ind_O_S___Scott": "bigint",
    "Ind_Paid___Scott": "string",
    "Indemnity_Cost": "string",
    "Indemnity_Payment": "string",
    "Initial_Report_Date": "string",
    "Initial_Report_Date_Null": "string",
    "Initial_Report_to_Approval": "string",
    "Initial_Report_to_Date_Closed": "string",
    "Initial_report_date_filled": "string",
    "Insured": "string",
    "Insured_ID___Insuratrac": "string",
    "Insured___First_Name": "string",
    "Insured___Last_Name": "string",
    "Last_Activity_Time": "string",
    "Manager_Name": "string",
    "Mass_uploaded_info": "string",
    "Modified_By": "string",
    "Modified_Time": "string",
    "Modified_the_following": "string",
    "Nixon_Cat_Loss_Tags": "string",
    "Nixon_Old_Claim_Number": "string",
    "Nixon_Processor": "string",
    "Nixon_Processor_Email": "string",
    "No_Coverage_Reason": "string",
    "Not_PMA_Kathy_Corp_Group": "string",
    "Not_PMA_Kathy_Facility_ID": "string",
    "OPENCLAIMS": "string",
    "O_C_Stat": "string",
    "Open_Claim_Count": "string",
    "Open_Claim_Yes": "string",
    "PMA_AIG": "string",
    "PMA___Apartments_Ceded_Premiums": "string",
    "PMA___Storage_Ceded_Premiums": "string",
    "Paid": "string",
    "Paid_Claim_Count": "string",
    "Pending_Approval": "string",
    "Pending_Approval_Hidden": "string",
    "Pending_Payment": "string",
    "Phone_Number": "string",
    "Policy_Name": "string",
    "Premium_Due": "string",
    "Premium_Paid_Thru": "string",
    "RCV_Payment": "string",
    "Re_opened_Claim": "string",
    "Reason_Still_Open": "string",
    "Reason_for_Denial": "string",
    "Reason_for_Denial_Code": "string",
    "Reason_for_Denial_Code_is_Null": "string",
    "Reason_for_denial_is_null": "string",
    "Reconciled___Nixon_Check_Register": "string",
    "Renter_Liability": "string",
    "Reopened_Claim_Reference": "string",
    "Reserve___Claims___Adjustment": "string",
    "Reserve_for_Adjustment": "string",
    "Reviewed_CXLD_Facility_Claim": "string",
    "Reviewed_Double_Check": "string",
    "Secondary_Cause_of_Loss": "string",
    "Secondary_Cause_of_Loss_3": "string",
    "Secondary_Cause_of_Loss_Code": "string",
    "Secondary_Reason_for_Denial": "string",
    "Secondary_Reason_for_Denial_3": "string",
    "Secondary_Reason_for_Denial_Code": "string",
    "Server_Update_ID": "string",
    "Stated_Cause_of_Loss": "string",
    "Subgrogated_Claim": "string",
    "Subrogated_Claim_Payment": "string",
    "Subrogated_Payment_Date": "string",
    "Subtract_Month": "string",
    "TIV_for_Location": "string",
    "Timestamp_Confirmation_Sent": "string",
    "Total_All": "string",
    "Total_Claims": "string",
    "Total_Open_Claims": "string",
    "Total_Value___Scott": "bigint",
    "Unit_Number": "string",
    "Vermin_Coverage": "string",
    "Zip_Code": "string",
    "Zoho_Claims_Record_Link": "string",
    "email_address": "string",
    "zcrm_claimid": "string",
    "zcrm_company_id": "string",
    "zcrmid": "string",
    "zoho_crm_claim_link": "string"
}
    • schema_name_id: 2240
    • schema_scan_id: 6603452
    • updated: 2024-09-26 15:20:25
    • created: 2024-03-28 14:31:08
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_json`",
    "DROP TABLE IF EXISTS `sfdl_dev_json.storsmartzoho_storsmart_claims`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_json.storsmartzoho_storsmart_claims`\n(\n`Id`string,`Claims_Name`string,`Claims_Owner_1`string,`Claims_Owner_Name`string,`Created_Time`string,`Modified_Time`string,`Last_Activity_Time`string,`Claim_Reserve_Amount`string,`Initial_Report_Date`string,`Approved_By`string,`Date_Closed`string,`Final_Payment`string,`Adjustment_Cost`string,`Additional_Costs`string,`Facility_City`string,`Modified_the_following`string,`Facility_Name`string,`Claim_Number`string,`Facility_Address`string,`Insured___Last_Name`STRING,`Insured___First_Name`STRING,`Date_of_Loss`string,`Date_of_Claim`string,`Premium_Paid_Thru`string,`Zip_Code`string,`Unit_Number`string,`Coverage_Limit`string,`Coverage_Start_Date`string,`Coverage_End_Date`string,`Deductible_Amount`string,`Enrollment_Method`string,`Facility_State`string,`Claim_Status`string,`Manager_Name`string,`Phone_Number`string,`email_address`string,`Premium_Due`string,`Reason_Still_Open`string,`Confirmed_and_Sent`string,`Facility_Name___Nixon`STRING,`Cause_of_Loss_Code`string,`Secondary_Cause_of_Loss_Code`string,`Secondary_Cause_of_Loss_3`string,`Secondary_Reason_for_Denial_3`string,`Reason_for_Denial_Code`string,`Secondary_Reason_for_Denial_Code`string,`Mass_uploaded_info`string,`Vermin_Coverage`string,`Reserve_for_Adjustment`string,`Paid`string,`Reserve___Claims___Adjustment`STRING,`Total_All`string,`Total_Open_Claims`string,`Total_Claims`string,`Reconciled___Nixon_Check_Register`STRING,`Cause_of_Loss`string,`Stated_Cause_of_Loss`string,`Reason_for_Denial`string,`Re_opened_Claim`STRING,`AIG___Storage_Ceded_Premiums`STRING,`Email`string,`Certificate_Number`string,`Date_Approved`string,`Days_Since_Approved`string,`Pending_Payment`string,`Subtract_Month`string,`Corp_Group`string,`Days_Since_Confirmed`string,`Days_Since_First_Report`string,`Days_Since_Created`string,`Confirm_Complete`string,`14_Day_Letter_Sent`string,`Days_to_Close`string,`Created_to_Initial_Report_Date`string,`Created_By`string,`Modified_By`string,`Claim_Re_opened_Date`STRING,`Reopened_Claim_Reference`string,`Facility_Address___Nixon`STRING,`Subgrogated_Claim`string,`Subrogated_Claim_Payment`string,`Subrogated_Payment_Date`string,`Secondary_Cause_of_Loss`string,`Secondary_Reason_for_Denial`string,`Server_Update_ID`string,`Initial_report_date_filled`string,`Reason_for_Denial_Code_is_Null`string,`Reason_for_denial_is_null`string,`Cause_of_Loss_is_Null`string,`Cause_of_Loss_Code_is_Null`string,`Zoho_Claims_Record_Link`string,`Error_Codes`string,`Initial_Report_to_Approval`string,`Claims_Paid_1`string,`Initial_Report_to_Date_Closed`string,`14_Day_Letter_Yes`string,`Initial_Report_Date_Null`string,`Approved_to_Close`string,`Created_to_Approved`string,`zcrmid`string,`Policy_Name`string,`O_C_Stat`STRING,`Insured`string,`TIV_for_Location`string,`Ind_O_S___Scott`STRING,`Ind_Paid___Scott`STRING,`Exp_Paid___Scott`STRING,`Exp_O_S___Scott`STRING,`Total_Value___Scott`STRING,`Hours_since_created`bigint,`zcrm_claimid`string,`Facility_Number`string,`Insured_ID___Insuratrac`STRING,`Claim_Type`string,`Bader_Renter_Liability_Claim`string,`Renter_Liability`string,`Claim_Types`string,`Claim_Count__Descriptions`string,`Date_Closed_Null`string,`Timestamp_Confirmation_Sent`string,`Full_Address_no_Zip`string,`After_8_31_19`STRING,`Corp_Group_Doesnt_Match`STRING,`Nixon_Processor`string,`Nixon_Processor_Email`string,`Pending_Approval`string,`Pending_Approval_Hidden`string,`Bader_Archive_Claim_ID`string,`RCV_Payment`string,`ALE_Payment`string,`Indemnity_Payment`string,`Date_of_Claim_to_Approval`string,`Days_to_Close_from_DOC`string,`DOC_Count`string,`PMA_AIG`STRING,`Reviewed_CXLD_Facility_Claim`string,`Reviewed_Double_Check`string,`Filter___REVIEWED_CXLD_CLAIM`STRING,`Filter___REVIEWED_STREET_OR_ID_MISMATCH`STRING,`No_Coverage_Reason`string,`Nixon_Old_Claim_Number`string,`Not_PMA_Kathy_Facility_ID`string,`Not_PMA_Kathy_Corp_Group`string,`Combined_old___New_Claim_Number`STRING,`Exclude_Bader___Nixon_LAE_transition`STRING,`OPENCLAIMS`string,`PMA___Storage_Ceded_Premiums`STRING,`PMA___Apartments_Ceded_Premiums`STRING,`Open_Claim_Count`string,`Indemnity_Cost`string,`zcrm_company_id`string,`Paid_Claim_Count`string,`ADJ_COSTS`string,`zoho_crm_claim_link`string,`Open_Claim_Yes`string,`Nixon_Cat_Loss_Tags`string,`Date_ID_Variable`string,`Error_Claim`string\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-storsmartzoho-dev/raw/storsmart_claims/2024-03-28/1711654036'\n",
    "MSCK REPAIR TABLE sfdl_dev_json.storsmartzoho_storsmart_claims"
]
    • hive_path: s3://sfdl-json-storsmartzoho-dev/raw/storsmart_claims/2024-03-28/1711654036
    • id: 4704798
    • processed: 1
    • raw_data: 
      {
    "14_Day_Letter_Sent": "No",
    "14_Day_Letter_Yes": "0",
    "ADJ_COSTS": "175",
    "AIG___Storage_Ceded_Premiums": "",
    "ALE_Payment": "",
    "Additional_Costs": "",
    "Adjustment_Cost": "",
    "After_8_31_19": "NO",
    "Approved_By": "Daniela Casper",
    "Approved_to_Close": "",
    "Bader_Archive_Claim_ID": "",
    "Bader_Renter_Liability_Claim": "No",
    "Cause_of_Loss": "Burglary",
    "Cause_of_Loss_Code": "14",
    "Cause_of_Loss_Code_is_Null": "0",
    "Cause_of_Loss_is_Null": "0",
    "Certificate_Number": "2814-213-319-08/29/23",
    "Claim_Count__Descriptions": "PMA - Storage",
    "Claim_Number": "60222-186201",
    "Claim_Re_opened_Date": "",
    "Claim_Reserve_Amount": "$ 0.00",
    "Claim_Status": "Closed",
    "Claim_Type": "",
    "Claim_Types": "PMA - Storage",
    "Claims_Name": "Hutchinson 02-10-24",
    "Claims_Owner_1": "404206000028908186",
    "Claims_Owner_Name": "Ron Rider Jr.",
    "Claims_Paid_1": "1",
    "Combined_old___New_Claim_Number": "60222-186201",
    "Confirm_Complete": "Feb 21, 2024",
    "Confirmed_and_Sent": "Yes",
    "Corp_Group": "B.2814 - KO Management LLC",
    "Corp_Group_Doesnt_Match": "FIX",
    "Coverage_End_Date": "Feb 21, 2024",
    "Coverage_Limit": "$ 2,000.00",
    "Coverage_Start_Date": "Aug 29, 2023",
    "Created_By": "404206000028908186",
    "Created_Time": "Feb 20, 2024 04:31 PM",
    "Created_to_Approved": "",
    "Created_to_Initial_Report_Date": "31",
    "DOC_Count": "1",
    "Date_Approved": "",
    "Date_Closed": "Mar 25, 2024",
    "Date_Closed_Null": "2024-03-25 00:00:00",
    "Date_ID_Variable": "FEBRUARY2024",
    "Date_of_Claim": "Feb 20, 2024",
    "Date_of_Claim_to_Approval": "",
    "Date_of_Loss": "Feb 10, 2024",
    "Days_Since_Approved": "",
    "Days_Since_Confirmed": "37",
    "Days_Since_Created": "37",
    "Days_Since_First_Report": "6",
    "Days_to_Close": "34",
    "Days_to_Close_from_DOC": "34",
    "Deductible_Amount": "$0.00",
    "Email": "",
    "Enrollment_Method": "",
    "Error_Claim": "",
    "Error_Codes": "0",
    "Exclude_Bader___Nixon_LAE_transition": "",
    "Exp_O_S___Scott": "175",
    "Exp_Paid___Scott": "0",
    "Facility_Address": "2105 SW A Avenue",
    "Facility_Address___Nixon": "2105 SW A Avenue Lawton OK 73501, Lawton, OK, 73501",
    "Facility_City": "Lawton",
    "Facility_Name": "404206000290876460",
    "Facility_Name___Nixon": "B.2814 - KO Management LLC: B.OK.2814.213",
    "Facility_Number": "B.OK.2814.213",
    "Facility_State": "OK",
    "Filter___REVIEWED_CXLD_CLAIM": "",
    "Filter___REVIEWED_STREET_OR_ID_MISMATCH": "",
    "Final_Payment": "$ 2,000.00",
    "Full_Address_no_Zip": "2105 SW A Avenue Lawton, OK",
    "Hours_since_created": "890",
    "Id": "404206000408584634",
    "Ind_O_S___Scott": "0",
    "Ind_Paid___Scott": "2000",
    "Indemnity_Cost": "2000",
    "Indemnity_Payment": "",
    "Initial_Report_Date": "Mar 22, 2024",
    "Initial_Report_Date_Null": "0",
    "Initial_Report_to_Approval": "",
    "Initial_Report_to_Date_Closed": "3",
    "Initial_report_date_filled": "Yes",
    "Insured": "Hutchinson, Tiffany",
    "Insured_ID___Insuratrac": "",
    "Insured___First_Name": "Tiffany",
    "Insured___Last_Name": "Hutchinson",
    "Last_Activity_Time": "Mar 27, 2024 07:31 PM",
    "Manager_Name": "",
    "Mass_uploaded_info": "No",
    "Modified_By": "404206000028908186",
    "Modified_Time": "Mar 27, 2024 07:31 PM",
    "Modified_the_following": "Certificate Number;Facility Name;Facility Address",
    "Nixon_Cat_Loss_Tags": "",
    "Nixon_Old_Claim_Number": "",
    "Nixon_Processor": "Kaylee",
    "Nixon_Processor_Email": "[email protected]",
    "No_Coverage_Reason": "",
    "Not_PMA_Kathy_Corp_Group": "B.2814 - KO Management LLC",
    "Not_PMA_Kathy_Facility_ID": "B.OK.2814.213",
    "OPENCLAIMS": "0",
    "O_C_Stat": "C",
    "Open_Claim_Count": "0",
    "Open_Claim_Yes": "0",
    "PMA_AIG": "PMA - Storage",
    "PMA___Apartments_Ceded_Premiums": "",
    "PMA___Storage_Ceded_Premiums": "",
    "Paid": "$ 2,000.00",
    "Paid_Claim_Count": "1",
    "Pending_Approval": "No",
    "Pending_Approval_Hidden": "",
    "Pending_Payment": "$ 0.00",
    "Phone_Number": "(580) 279-6750",
    "Policy_Name": "Storsmart Insurance",
    "Premium_Due": "No Premium Due",
    "Premium_Paid_Thru": "Feb 29, 2024",
    "RCV_Payment": "",
    "Re_opened_Claim": "No",
    "Reason_Still_Open": "",
    "Reason_for_Denial": "",
    "Reason_for_Denial_Code": "",
    "Reason_for_Denial_Code_is_Null": "1",
    "Reason_for_denial_is_null": "1",
    "Reconciled___Nixon_Check_Register": "No",
    "Renter_Liability": "",
    "Reopened_Claim_Reference": "",
    "Reserve___Claims___Adjustment": "$ 175.00",
    "Reserve_for_Adjustment": "$ 175.00",
    "Reviewed_CXLD_Facility_Claim": "No",
    "Reviewed_Double_Check": "",
    "Secondary_Cause_of_Loss": "",
    "Secondary_Cause_of_Loss_3": "",
    "Secondary_Cause_of_Loss_Code": "",
    "Secondary_Reason_for_Denial": "",
    "Secondary_Reason_for_Denial_3": "",
    "Secondary_Reason_for_Denial_Code": "",
    "Server_Update_ID": "17115822732443025932119111162115",
    "Stated_Cause_of_Loss": "Burglary",
    "Subgrogated_Claim": "No",
    "Subrogated_Claim_Payment": "",
    "Subrogated_Payment_Date": "",
    "Subtract_Month": "0",
    "TIV_for_Location": "2000",
    "Timestamp_Confirmation_Sent": "",
    "Total_All": "$ 2,175.00",
    "Total_Claims": "1",
    "Total_Open_Claims": "0",
    "Total_Value___Scott": "2175",
    "Unit_Number": "319",
    "Vermin_Coverage": "",
    "Zip_Code": "73501",
    "Zoho_Claims_Record_Link": "https://crm.zoho.com/crm/EntityInfo.do?module=CustomModule2&id=404206000408584634",
    "email_address": "",
    "zcrm_claimid": "zcrm_404206000408584634",
    "zcrm_company_id": "zcrm_404206000290876460",
    "zcrmid": "zcrm_404206000408584634",
    "zoho_crm_claim_link": "https://crm.zoho.com/crm/EntityInfo.do?module=CustomModule2&id=404206000408584634"
}
    • schema_attributes: 
      {
    "14_Day_Letter_Sent": "string",
    "14_Day_Letter_Yes": "string",
    "ADJ_COSTS": "string",
    "AIG___Storage_Ceded_Premiums": "string",
    "ALE_Payment": "string",
    "Additional_Costs": "string",
    "Adjustment_Cost": "string",
    "After_8_31_19": "string",
    "Approved_By": "string",
    "Approved_to_Close": "string",
    "Bader_Archive_Claim_ID": "string",
    "Bader_Renter_Liability_Claim": "string",
    "Cause_of_Loss": "string",
    "Cause_of_Loss_Code": "string",
    "Cause_of_Loss_Code_is_Null": "string",
    "Cause_of_Loss_is_Null": "string",
    "Certificate_Number": "string",
    "Claim_Count__Descriptions": "string",
    "Claim_Number": "string",
    "Claim_Re_opened_Date": "string",
    "Claim_Reserve_Amount": "string",
    "Claim_Status": "string",
    "Claim_Type": "string",
    "Claim_Types": "string",
    "Claims_Name": "string",
    "Claims_Owner_1": "string",
    "Claims_Owner_Name": "string",
    "Claims_Paid_1": "string",
    "Combined_old___New_Claim_Number": "string",
    "Confirm_Complete": "string",
    "Confirmed_and_Sent": "string",
    "Corp_Group": "string",
    "Corp_Group_Doesnt_Match": "string",
    "Coverage_End_Date": "string",
    "Coverage_Limit": "string",
    "Coverage_Start_Date": "string",
    "Created_By": "string",
    "Created_Time": "string",
    "Created_to_Approved": "string",
    "Created_to_Initial_Report_Date": "string",
    "DOC_Count": "string",
    "Date_Approved": "string",
    "Date_Closed": "string",
    "Date_Closed_Null": "string",
    "Date_ID_Variable": "string",
    "Date_of_Claim": "string",
    "Date_of_Claim_to_Approval": "string",
    "Date_of_Loss": "string",
    "Days_Since_Approved": "string",
    "Days_Since_Confirmed": "string",
    "Days_Since_Created": "string",
    "Days_Since_First_Report": "string",
    "Days_to_Close": "string",
    "Days_to_Close_from_DOC": "string",
    "Deductible_Amount": "string",
    "Email": "string",
    "Enrollment_Method": "string",
    "Error_Claim": "string",
    "Error_Codes": "string",
    "Exclude_Bader___Nixon_LAE_transition": "string",
    "Exp_O_S___Scott": "string",
    "Exp_Paid___Scott": "string",
    "Facility_Address": "string",
    "Facility_Address___Nixon": "string",
    "Facility_City": "string",
    "Facility_Name": "string",
    "Facility_Name___Nixon": "string",
    "Facility_Number": "string",
    "Facility_State": "string",
    "Filter___REVIEWED_CXLD_CLAIM": "string",
    "Filter___REVIEWED_STREET_OR_ID_MISMATCH": "string",
    "Final_Payment": "string",
    "Full_Address_no_Zip": "string",
    "Hours_since_created": "bigint",
    "Id": "string",
    "Ind_O_S___Scott": "bigint",
    "Ind_Paid___Scott": "bigint",
    "Indemnity_Cost": "string",
    "Indemnity_Payment": "string",
    "Initial_Report_Date": "string",
    "Initial_Report_Date_Null": "string",
    "Initial_Report_to_Approval": "string",
    "Initial_Report_to_Date_Closed": "string",
    "Initial_report_date_filled": "string",
    "Insured": "string",
    "Insured_ID___Insuratrac": "string",
    "Insured___First_Name": "string",
    "Insured___Last_Name": "string",
    "Last_Activity_Time": "string",
    "Manager_Name": "string",
    "Mass_uploaded_info": "string",
    "Modified_By": "string",
    "Modified_Time": "string",
    "Modified_the_following": "string",
    "Nixon_Cat_Loss_Tags": "string",
    "Nixon_Old_Claim_Number": "string",
    "Nixon_Processor": "string",
    "Nixon_Processor_Email": "string",
    "No_Coverage_Reason": "string",
    "Not_PMA_Kathy_Corp_Group": "string",
    "Not_PMA_Kathy_Facility_ID": "string",
    "OPENCLAIMS": "string",
    "O_C_Stat": "string",
    "Open_Claim_Count": "string",
    "Open_Claim_Yes": "string",
    "PMA_AIG": "string",
    "PMA___Apartments_Ceded_Premiums": "string",
    "PMA___Storage_Ceded_Premiums": "string",
    "Paid": "string",
    "Paid_Claim_Count": "string",
    "Pending_Approval": "string",
    "Pending_Approval_Hidden": "string",
    "Pending_Payment": "string",
    "Phone_Number": "string",
    "Policy_Name": "string",
    "Premium_Due": "string",
    "Premium_Paid_Thru": "string",
    "RCV_Payment": "string",
    "Re_opened_Claim": "string",
    "Reason_Still_Open": "string",
    "Reason_for_Denial": "string",
    "Reason_for_Denial_Code": "string",
    "Reason_for_Denial_Code_is_Null": "string",
    "Reason_for_denial_is_null": "string",
    "Reconciled___Nixon_Check_Register": "string",
    "Renter_Liability": "string",
    "Reopened_Claim_Reference": "string",
    "Reserve___Claims___Adjustment": "string",
    "Reserve_for_Adjustment": "string",
    "Reviewed_CXLD_Facility_Claim": "string",
    "Reviewed_Double_Check": "string",
    "Secondary_Cause_of_Loss": "string",
    "Secondary_Cause_of_Loss_3": "string",
    "Secondary_Cause_of_Loss_Code": "string",
    "Secondary_Reason_for_Denial": "string",
    "Secondary_Reason_for_Denial_3": "string",
    "Secondary_Reason_for_Denial_Code": "string",
    "Server_Update_ID": "string",
    "Stated_Cause_of_Loss": "string",
    "Subgrogated_Claim": "string",
    "Subrogated_Claim_Payment": "string",
    "Subrogated_Payment_Date": "string",
    "Subtract_Month": "string",
    "TIV_for_Location": "string",
    "Timestamp_Confirmation_Sent": "string",
    "Total_All": "string",
    "Total_Claims": "string",
    "Total_Open_Claims": "string",
    "Total_Value___Scott": "string",
    "Unit_Number": "string",
    "Vermin_Coverage": "string",
    "Zip_Code": "string",
    "Zoho_Claims_Record_Link": "string",
    "email_address": "string",
    "zcrm_claimid": "string",
    "zcrm_company_id": "string",
    "zcrmid": "string",
    "zoho_crm_claim_link": "string"
}
    • schema_name_id: 2240
    • schema_scan_id: 6457909
    • updated: 2024-03-28 14:31:22
Schema Scans: 3
Last at 2025-06-10 15:55:46
    • duration: 0:04:45.229291
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6808741
    • payload: 
      {
    "datatype_dict": {
        "14 Day Letter Sent": "string",
        "14 Day Letter Yes": "string",
        "ADJ COSTS": "string",
        "AIG - Storage Ceded Premiums": "string",
        "ALE Payment": "string",
        "Additional Costs": "string",
        "Adjustment Cost": "string",
        "After 8-31-19": "string",
        "Approved By": "string",
        "Approved to Close": "string",
        "Bader Archive Claim ID": "string",
        "Bader Renter Liability Claim": "string",
        "Cause of Loss": "string",
        "Cause of Loss Code": "string",
        "Cause of Loss Code is Null": "string",
        "Cause of Loss is Null": "string",
        "Certificate Number": "string",
        "Claim Count  Descriptions": "string",
        "Claim Number": "string",
        "Claim Re-opened Date": "string",
        "Claim Reserve Amount": "string",
        "Claim Status": "string",
        "Claim Type": "string",
        "Claim Types": "string",
        "Claims Name": "string",
        "Claims Owner Name": "string",
        "Claims Owner_1": "string",
        "Claims Paid 1": "string",
        "Combined old - New Claim Number": "string",
        "Confirm Complete": "string",
        "Confirmed and Sent": "string",
        "Corp Group": "string",
        "Corp Group Doesn't Match": "string",
        "Coverage End Date": "string",
        "Coverage Limit": "string",
        "Coverage Start Date": "string",
        "Created By": "string",
        "Created Time": "string",
        "Created to Approved": "string",
        "Created to Initial Report Date": "string",
        "DOC Count": "string",
        "Date Approved": "string",
        "Date Closed": "string",
        "Date Closed Null": "string",
        "Date ID Variable": "string",
        "Date of Claim": "string",
        "Date of Claim to Approval": "string",
        "Date of Loss": "string",
        "Days Since Approved": "string",
        "Days Since Confirmed": "string",
        "Days Since Created": "string",
        "Days Since First Report": "string",
        "Days to Close": "string",
        "Days to Close from DOC": "string",
        "Deductible Amount": "string",
        "Email": "string",
        "Enrollment Method": "string",
        "Error Claim": "string",
        "Error Codes": "string",
        "Exclude Bader - Nixon LAE transition": "string",
        "Exp O/S - Scott": "bigint",
        "Exp Paid - Scott": "bigint",
        "Facility Address": "string",
        "Facility Address - Nixon": "string",
        "Facility City": "string",
        "Facility Name": "string",
        "Facility Name - Nixon": "string",
        "Facility Number": "string",
        "Facility State": "string",
        "Filter - REVIEWED CXLD CLAIM": "string",
        "Filter - REVIEWED STREET OR ID MISMATCH": "string",
        "Final Payment": "string",
        "Full Address no Zip": "string",
        "Hours since created": "bigint",
        "Id": "string",
        "Ind O/S - Scott": "bigint",
        "Ind Paid - Scott": "bigint",
        "Indemnity Cost": "string",
        "Indemnity Payment": "string",
        "Initial Report Date": "string",
        "Initial Report Date Null": "string",
        "Initial Report to Approval": "string",
        "Initial Report to Date Closed": "string",
        "Initial report date filled": "string",
        "Insured": "string",
        "Insured - First Name": "string",
        "Insured - Last Name": "string",
        "Insured ID - Insuratrac": "string",
        "Last Activity Time": "string",
        "Manager Name": "string",
        "Mass uploaded info": "string",
        "Modified By": "string",
        "Modified Time": "string",
        "Modified the following": "string",
        "Nixon Cat Loss Tags": "string",
        "Nixon Old Claim Number": "string",
        "Nixon Processor": "string",
        "Nixon Processor Email": "string",
        "No Coverage Reason": "string",
        "Not PMA Kathy Corp Group": "string",
        "Not PMA Kathy Facility ID": "string",
        "O/C Stat": "string",
        "OPENCLAIMS": "string",
        "Open Claim Count": "string",
        "Open Claim Yes": "string",
        "PMA - Apartments Ceded Premiums": "string",
        "PMA - Storage Ceded Premiums": "string",
        "PMA-AIG": "string",
        "Paid": "string",
        "Paid Claim Count": "string",
        "Pending Approval": "string",
        "Pending Approval Hidden": "string",
        "Pending Payment": "string",
        "Phone Number": "string",
        "Policy Name": "string",
        "Premium Due": "string",
        "Premium Paid Thru": "string",
        "RCV Payment": "string",
        "Re-opened Claim": "string",
        "Reason Still Open": "string",
        "Reason for Denial": "string",
        "Reason for Denial Code": "string",
        "Reason for Denial Code is Null": "string",
        "Reason for denial is null": "string",
        "Reconciled - Nixon Check Register": "string",
        "Renter Liability": "string",
        "Reopened Claim Reference": "string",
        "Reserve - Claims & Adjustment": "string",
        "Reserve for Adjustment": "string",
        "Reviewed CXLD Facility Claim": "string",
        "Reviewed Double Check": "string",
        "Secondary Cause of Loss": "string",
        "Secondary Cause of Loss 3": "string",
        "Secondary Cause of Loss Code": "string",
        "Secondary Reason for Denial": "string",
        "Secondary Reason for Denial 3": "string",
        "Secondary Reason for Denial Code": "string",
        "Server_Update_ID": "string",
        "Stated Cause of Loss": "string",
        "Subgrogated Claim": "string",
        "Subrogated Claim Payment": "string",
        "Subrogated Payment Date": "string",
        "Subtract Month": "string",
        "TIV for Location": "string",
        "Timestamp Confirmation Sent": "string",
        "Total All": "string",
        "Total Claims": "string",
        "Total Open Claims": "string",
        "Total Value - Scott": "bigint",
        "Unit Number": "string",
        "Vermin Coverage": "string",
        "Zip Code": "string",
        "Zoho Claims Record Link": "string",
        "email address": "string",
        "zcrm_claimid": "string",
        "zcrm_company_id": "string",
        "zcrmid": "string",
        "zoho crm claim link": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-storsmartzoho-dev",
        "hive_path": "s3://sfdl-json-storsmartzoho-dev/raw/storsmart_claims/2025-06-10/1749588942",
        "key": "raw/storsmart_claims/2025-06-10/1749588942/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_json.storsmartzoho_storsmart_claims",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 12287446959636771204,
        "service_name": "load-storsmart_claims",
        "span_id": 15610348533053369759,
        "trace_id": 12287446959636771204
    }
}
    • running: False
    • schema_name_id: 2240
    • start_time: 2025-06-10 15:55:46
    • success: True
    • trace_id: 12287446959636771204
    • duration: 0:04:34.108190
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6603452
    • payload: 
      {
    "datatype_dict": {
        "14 Day Letter Sent": "string",
        "14 Day Letter Yes": "string",
        "ADJ COSTS": "string",
        "AIG - Storage Ceded Premiums": "string",
        "ALE Payment": "string",
        "Additional Costs": "string",
        "Adjustment Cost": "string",
        "After 8-31-19": "string",
        "Approved By": "string",
        "Approved to Close": "string",
        "Bader Archive Claim ID": "string",
        "Bader Renter Liability Claim": "string",
        "Cause of Loss": "string",
        "Cause of Loss Code": "string",
        "Cause of Loss Code is Null": "string",
        "Cause of Loss is Null": "string",
        "Certificate Number": "string",
        "Claim Count  Descriptions": "string",
        "Claim Number": "string",
        "Claim Re-opened Date": "string",
        "Claim Reserve Amount": "string",
        "Claim Status": "string",
        "Claim Type": "string",
        "Claim Types": "string",
        "Claims Name": "string",
        "Claims Owner Name": "string",
        "Claims Owner_1": "string",
        "Claims Paid 1": "string",
        "Combined old - New Claim Number": "string",
        "Confirm Complete": "string",
        "Confirmed and Sent": "string",
        "Corp Group": "string",
        "Corp Group Doesn't Match": "string",
        "Coverage End Date": "string",
        "Coverage Limit": "string",
        "Coverage Start Date": "string",
        "Created By": "string",
        "Created Time": "string",
        "Created to Approved": "string",
        "Created to Initial Report Date": "string",
        "DOC Count": "string",
        "Date Approved": "string",
        "Date Closed": "string",
        "Date Closed Null": "string",
        "Date ID Variable": "string",
        "Date of Claim": "string",
        "Date of Claim to Approval": "string",
        "Date of Loss": "string",
        "Days Since Approved": "string",
        "Days Since Confirmed": "string",
        "Days Since Created": "string",
        "Days Since First Report": "string",
        "Days to Close": "string",
        "Days to Close from DOC": "string",
        "Deductible Amount": "string",
        "Email": "string",
        "Enrollment Method": "string",
        "Error Claim": "string",
        "Error Codes": "string",
        "Exclude Bader - Nixon LAE transition": "string",
        "Exp O/S - Scott": "bigint",
        "Exp Paid - Scott": "bigint",
        "Facility Address": "string",
        "Facility Address - Nixon": "string",
        "Facility City": "string",
        "Facility Name": "string",
        "Facility Name - Nixon": "string",
        "Facility Number": "string",
        "Facility State": "string",
        "Filter - REVIEWED CXLD CLAIM": "string",
        "Filter - REVIEWED STREET OR ID MISMATCH": "string",
        "Final Payment": "string",
        "Full Address no Zip": "string",
        "Hours since created": "bigint",
        "Id": "string",
        "Ind O/S - Scott": "bigint",
        "Ind Paid - Scott": "bigint",
        "Indemnity Cost": "string",
        "Indemnity Payment": "string",
        "Initial Report Date": "string",
        "Initial Report Date Null": "string",
        "Initial Report to Approval": "string",
        "Initial Report to Date Closed": "string",
        "Initial report date filled": "string",
        "Insured": "string",
        "Insured - First Name": "string",
        "Insured - Last Name": "string",
        "Insured ID - Insuratrac": "string",
        "Last Activity Time": "string",
        "Manager Name": "string",
        "Mass uploaded info": "string",
        "Modified By": "string",
        "Modified Time": "string",
        "Modified the following": "string",
        "Nixon Cat Loss Tags": "string",
        "Nixon Old Claim Number": "string",
        "Nixon Processor": "string",
        "Nixon Processor Email": "string",
        "No Coverage Reason": "string",
        "Not PMA Kathy Corp Group": "string",
        "Not PMA Kathy Facility ID": "string",
        "O/C Stat": "string",
        "OPENCLAIMS": "string",
        "Open Claim Count": "string",
        "Open Claim Yes": "string",
        "PMA - Apartments Ceded Premiums": "string",
        "PMA - Storage Ceded Premiums": "string",
        "PMA-AIG": "string",
        "Paid": "string",
        "Paid Claim Count": "string",
        "Pending Approval": "string",
        "Pending Approval Hidden": "string",
        "Pending Payment": "string",
        "Phone Number": "string",
        "Policy Name": "string",
        "Premium Due": "string",
        "Premium Paid Thru": "string",
        "RCV Payment": "string",
        "Re-opened Claim": "string",
        "Reason Still Open": "string",
        "Reason for Denial": "string",
        "Reason for Denial Code": "string",
        "Reason for Denial Code is Null": "string",
        "Reason for denial is null": "string",
        "Reconciled - Nixon Check Register": "string",
        "Renter Liability": "string",
        "Reopened Claim Reference": "string",
        "Reserve - Claims & Adjustment": "string",
        "Reserve for Adjustment": "string",
        "Reviewed CXLD Facility Claim": "string",
        "Reviewed Double Check": "string",
        "Secondary Cause of Loss": "string",
        "Secondary Cause of Loss 3": "string",
        "Secondary Cause of Loss Code": "string",
        "Secondary Reason for Denial": "string",
        "Secondary Reason for Denial 3": "string",
        "Secondary Reason for Denial Code": "string",
        "Server_Update_ID": "string",
        "Stated Cause of Loss": "string",
        "Subgrogated Claim": "string",
        "Subrogated Claim Payment": "string",
        "Subrogated Payment Date": "string",
        "Subtract Month": "string",
        "TIV for Location": "string",
        "Timestamp Confirmation Sent": "string",
        "Total All": "string",
        "Total Claims": "string",
        "Total Open Claims": "string",
        "Total Value - Scott": "bigint",
        "Unit Number": "string",
        "Vermin Coverage": "string",
        "Zip Code": "string",
        "Zoho Claims Record Link": "string",
        "email address": "string",
        "zcrm_claimid": "string",
        "zcrm_company_id": "string",
        "zcrmid": "string",
        "zoho crm claim link": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-storsmartzoho-dev",
        "hive_path": "s3://sfdl-json-storsmartzoho-dev/raw/storsmart_claims/2024-09-26/1727381737",
        "key": "raw/storsmart_claims/2024-09-26/1727381737/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_json.storsmartzoho_storsmart_claims",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 16763797349726746939,
        "service_name": "load-storsmart_claims",
        "span_id": 5277151857869528172,
        "trace_id": 16763797349726746939
    }
}
    • running: False
    • schema_name_id: 2240
    • start_time: 2024-09-26 15:15:51
    • success: True
    • trace_id: 16763797349726746939
    • duration: 0:03:59.170095
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6457909
    • payload: 
      {
    "datatype_dict": {
        "14 Day Letter Sent": "string",
        "14 Day Letter Yes": "string",
        "ADJ COSTS": "string",
        "AIG - Storage Ceded Premiums": "string",
        "ALE Payment": "string",
        "Additional Costs": "string",
        "Adjustment Cost": "string",
        "After 8-31-19": "string",
        "Approved By": "string",
        "Approved to Close": "string",
        "Bader Archive Claim ID": "string",
        "Bader Renter Liability Claim": "string",
        "Cause of Loss": "string",
        "Cause of Loss Code": "string",
        "Cause of Loss Code is Null": "string",
        "Cause of Loss is Null": "string",
        "Certificate Number": "string",
        "Claim Count  Descriptions": "string",
        "Claim Number": "string",
        "Claim Re-opened Date": "string",
        "Claim Reserve Amount": "string",
        "Claim Status": "string",
        "Claim Type": "string",
        "Claim Types": "string",
        "Claims Name": "string",
        "Claims Owner Name": "string",
        "Claims Owner_1": "string",
        "Claims Paid 1": "string",
        "Combined old - New Claim Number": "string",
        "Confirm Complete": "string",
        "Confirmed and Sent": "string",
        "Corp Group": "string",
        "Corp Group Doesn't Match": "string",
        "Coverage End Date": "string",
        "Coverage Limit": "string",
        "Coverage Start Date": "string",
        "Created By": "string",
        "Created Time": "string",
        "Created to Approved": "string",
        "Created to Initial Report Date": "string",
        "DOC Count": "string",
        "Date Approved": "string",
        "Date Closed": "string",
        "Date Closed Null": "string",
        "Date ID Variable": "string",
        "Date of Claim": "string",
        "Date of Claim to Approval": "string",
        "Date of Loss": "string",
        "Days Since Approved": "string",
        "Days Since Confirmed": "string",
        "Days Since Created": "string",
        "Days Since First Report": "string",
        "Days to Close": "string",
        "Days to Close from DOC": "string",
        "Deductible Amount": "string",
        "Email": "string",
        "Enrollment Method": "string",
        "Error Claim": "string",
        "Error Codes": "string",
        "Exclude Bader - Nixon LAE transition": "string",
        "Exp O/S - Scott": "bigint",
        "Exp Paid - Scott": "bigint",
        "Facility Address": "string",
        "Facility Address - Nixon": "string",
        "Facility City": "string",
        "Facility Name": "string",
        "Facility Name - Nixon": "string",
        "Facility Number": "string",
        "Facility State": "string",
        "Filter - REVIEWED CXLD CLAIM": "string",
        "Filter - REVIEWED STREET OR ID MISMATCH": "string",
        "Final Payment": "string",
        "Full Address no Zip": "string",
        "Hours since created": "bigint",
        "Id": "string",
        "Ind O/S - Scott": "bigint",
        "Ind Paid - Scott": "bigint",
        "Indemnity Cost": "string",
        "Indemnity Payment": "string",
        "Initial Report Date": "string",
        "Initial Report Date Null": "string",
        "Initial Report to Approval": "string",
        "Initial Report to Date Closed": "string",
        "Initial report date filled": "string",
        "Insured": "string",
        "Insured - First Name": "string",
        "Insured - Last Name": "string",
        "Insured ID - Insuratrac": "string",
        "Last Activity Time": "string",
        "Manager Name": "string",
        "Mass uploaded info": "string",
        "Modified By": "string",
        "Modified Time": "string",
        "Modified the following": "string",
        "Nixon Cat Loss Tags": "string",
        "Nixon Old Claim Number": "string",
        "Nixon Processor": "string",
        "Nixon Processor Email": "string",
        "No Coverage Reason": "string",
        "Not PMA Kathy Corp Group": "string",
        "Not PMA Kathy Facility ID": "string",
        "O/C Stat": "string",
        "OPENCLAIMS": "string",
        "Open Claim Count": "string",
        "Open Claim Yes": "string",
        "PMA - Apartments Ceded Premiums": "string",
        "PMA - Storage Ceded Premiums": "string",
        "PMA-AIG": "string",
        "Paid": "string",
        "Paid Claim Count": "string",
        "Pending Approval": "string",
        "Pending Approval Hidden": "string",
        "Pending Payment": "string",
        "Phone Number": "string",
        "Policy Name": "string",
        "Premium Due": "string",
        "Premium Paid Thru": "string",
        "RCV Payment": "string",
        "Re-opened Claim": "string",
        "Reason Still Open": "string",
        "Reason for Denial": "string",
        "Reason for Denial Code": "string",
        "Reason for Denial Code is Null": "string",
        "Reason for denial is null": "string",
        "Reconciled - Nixon Check Register": "string",
        "Renter Liability": "string",
        "Reopened Claim Reference": "string",
        "Reserve - Claims & Adjustment": "string",
        "Reserve for Adjustment": "string",
        "Reviewed CXLD Facility Claim": "string",
        "Reviewed Double Check": "string",
        "Secondary Cause of Loss": "string",
        "Secondary Cause of Loss 3": "string",
        "Secondary Cause of Loss Code": "string",
        "Secondary Reason for Denial": "string",
        "Secondary Reason for Denial 3": "string",
        "Secondary Reason for Denial Code": "string",
        "Server_Update_ID": "string",
        "Stated Cause of Loss": "string",
        "Subgrogated Claim": "string",
        "Subrogated Claim Payment": "string",
        "Subrogated Payment Date": "string",
        "Subtract Month": "string",
        "TIV for Location": "string",
        "Timestamp Confirmation Sent": "string",
        "Total All": "string",
        "Total Claims": "string",
        "Total Open Claims": "string",
        "Total Value - Scott": "bigint",
        "Unit Number": "string",
        "Vermin Coverage": "string",
        "Zip Code": "string",
        "Zoho Claims Record Link": "string",
        "email address": "string",
        "zcrm_claimid": "string",
        "zcrm_company_id": "string",
        "zcrmid": "string",
        "zoho crm claim link": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-storsmartzoho-dev",
        "hive_path": "s3://sfdl-json-storsmartzoho-dev/raw/storsmart_claims/2024-03-28/1711654036",
        "key": "raw/storsmart_claims/2024-03-28/1711654036/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_json.storsmartzoho_storsmart_claims",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 14390016308656371493,
        "service_name": "load-storsmart_claims",
        "span_id": 14011192107051193973,
        "trace_id": 14390016308656371493
    }
}
    • running: False
    • schema_name_id: 2240
    • start_time: 2024-03-28 14:27:23
    • success: True
    • trace_id: 14390016308656371493
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "14_Day_Letter_Sent": "string",
    "14_Day_Letter_Yes": "string",
    "ADJ_COSTS": "string",
    "AIG___Storage_Ceded_Premiums": "string",
    "ALE_Payment": "string",
    "Additional_Costs": "string",
    "Adjustment_Cost": "string",
    "After_8_31_19": "string",
    "Approved_By": "string",
    "Approved_to_Close": "string",
    "Bader_Archive_Claim_ID": "string",
    "Bader_Renter_Liability_Claim": "string",
    "Cause_of_Loss": "string",
    "Cause_of_Loss_Code": "string",
    "Cause_of_Loss_Code_is_Null": "string",
    "Cause_of_Loss_is_Null": "string",
    "Certificate_Number": "string",
    "Claim_Count__Descriptions": "string",
    "Claim_Number": "string",
    "Claim_Re_opened_Date": "string",
    "Claim_Reserve_Amount": "string",
    "Claim_Status": "string",
    "Claim_Type": "string",
    "Claim_Types": "string",
    "Claims_Name": "string",
    "Claims_Owner_1": "string",
    "Claims_Owner_Name": "string",
    "Claims_Paid_1": "string",
    "Combined_old___New_Claim_Number": "string",
    "Confirm_Complete": "string",
    "Confirmed_and_Sent": "string",
    "Corp_Group": "string",
    "Corp_Group_Doesnt_Match": "string",
    "Coverage_End_Date": "string",
    "Coverage_Limit": "string",
    "Coverage_Start_Date": "string",
    "Created_By": "string",
    "Created_Time": "string",
    "Created_to_Approved": "string",
    "Created_to_Initial_Report_Date": "string",
    "DOC_Count": "string",
    "Date_Approved": "string",
    "Date_Closed": "string",
    "Date_Closed_Null": "string",
    "Date_ID_Variable": "string",
    "Date_of_Claim": "string",
    "Date_of_Claim_to_Approval": "string",
    "Date_of_Loss": "string",
    "Days_Since_Approved": "string",
    "Days_Since_Confirmed": "string",
    "Days_Since_Created": "string",
    "Days_Since_First_Report": "string",
    "Days_to_Close": "string",
    "Days_to_Close_from_DOC": "string",
    "Deductible_Amount": "string",
    "Email": "string",
    "Enrollment_Method": "string",
    "Error_Claim": "string",
    "Error_Codes": "string",
    "Exclude_Bader___Nixon_LAE_transition": "string",
    "Exp_O_S___Scott": "bigint",
    "Exp_Paid___Scott": "bigint",
    "Facility_Address": "string",
    "Facility_Address___Nixon": "string",
    "Facility_City": "string",
    "Facility_Name": "string",
    "Facility_Name___Nixon": "string",
    "Facility_Number": "string",
    "Facility_State": "string",
    "Filter___REVIEWED_CXLD_CLAIM": "string",
    "Filter___REVIEWED_STREET_OR_ID_MISMATCH": "string",
    "Final_Payment": "string",
    "Full_Address_no_Zip": "string",
    "Hours_since_created": "bigint",
    "Id": "string",
    "Ind_O_S___Scott": "string",
    "Ind_Paid___Scott": "bigint",
    "Indemnity_Cost": "string",
    "Indemnity_Payment": "string",
    "Initial_Report_Date": "string",
    "Initial_Report_Date_Null": "string",
    "Initial_Report_to_Approval": "string",
    "Initial_Report_to_Date_Closed": "string",
    "Initial_report_date_filled": "string",
    "Insured": "string",
    "Insured_ID___Insuratrac": "string",
    "Insured___First_Name": "string",
    "Insured___Last_Name": "string",
    "Last_Activity_Time": "string",
    "Manager_Name": "string",
    "Mass_uploaded_info": "string",
    "Modified_By": "string",
    "Modified_Time": "string",
    "Modified_the_following": "string",
    "Nixon_Cat_Loss_Tags": "string",
    "Nixon_Old_Claim_Number": "string",
    "Nixon_Processor": "string",
    "Nixon_Processor_Email": "string",
    "No_Coverage_Reason": "string",
    "Not_PMA_Kathy_Corp_Group": "string",
    "Not_PMA_Kathy_Facility_ID": "string",
    "OPENCLAIMS": "string",
    "O_C_Stat": "string",
    "Open_Claim_Count": "string",
    "Open_Claim_Yes": "string",
    "PMA_AIG": "string",
    "PMA___Apartments_Ceded_Premiums": "string",
    "PMA___Storage_Ceded_Premiums": "string",
    "Paid": "string",
    "Paid_Claim_Count": "string",
    "Pending_Approval": "string",
    "Pending_Approval_Hidden": "string",
    "Pending_Payment": "string",
    "Phone_Number": "string",
    "Policy_Name": "string",
    "Premium_Due": "string",
    "Premium_Paid_Thru": "string",
    "RCV_Payment": "string",
    "Re_opened_Claim": "string",
    "Reason_Still_Open": "string",
    "Reason_for_Denial": "string",
    "Reason_for_Denial_Code": "string",
    "Reason_for_Denial_Code_is_Null": "string",
    "Reason_for_denial_is_null": "string",
    "Reconciled___Nixon_Check_Register": "string",
    "Renter_Liability": "string",
    "Reopened_Claim_Reference": "string",
    "Reserve___Claims___Adjustment": "string",
    "Reserve_for_Adjustment": "string",
    "Reviewed_CXLD_Facility_Claim": "string",
    "Reviewed_Double_Check": "string",
    "Secondary_Cause_of_Loss": "string",
    "Secondary_Cause_of_Loss_3": "string",
    "Secondary_Cause_of_Loss_Code": "string",
    "Secondary_Reason_for_Denial": "string",
    "Secondary_Reason_for_Denial_3": "string",
    "Secondary_Reason_for_Denial_Code": "string",
    "Server_Update_ID": "string",
    "Stated_Cause_of_Loss": "string",
    "Subgrogated_Claim": "string",
    "Subrogated_Claim_Payment": "string",
    "Subrogated_Payment_Date": "string",
    "Subtract_Month": "string",
    "TIV_for_Location": "string",
    "Timestamp_Confirmation_Sent": "string",
    "Total_All": "string",
    "Total_Claims": "string",
    "Total_Open_Claims": "string",
    "Total_Value___Scott": "string",
    "Unit_Number": "string",
    "Vermin_Coverage": "string",
    "Zip_Code": "string",
    "Zoho_Claims_Record_Link": "string",
    "email_address": "string",
    "zcrm_claimid": "string",
    "zcrm_company_id": "string",
    "zcrmid": "string",
    "zoho_crm_claim_link": "string"
}
  • created: 2025-06-10 16:00:20
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_json`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_json.storsmartzoho_storsmart_claims`\n(\n`Id`string,`Claims_Name`string,`Claims_Owner_1`string,`Claims_Owner_Name`string,`Created_Time`string,`Modified_Time`string,`Last_Activity_Time`string,`Claim_Reserve_Amount`string,`Initial_Report_Date`string,`Approved_By`string,`Date_Closed`string,`Final_Payment`string,`Adjustment_Cost`string,`Additional_Costs`string,`Facility_City`string,`Modified_the_following`string,`Facility_Name`string,`Claim_Number`string,`Facility_Address`string,`Insured___Last_Name`STRING,`Insured___First_Name`STRING,`Date_of_Loss`string,`Date_of_Claim`string,`Premium_Paid_Thru`string,`Zip_Code`string,`Unit_Number`string,`Coverage_Limit`string,`Coverage_Start_Date`string,`Coverage_End_Date`string,`Deductible_Amount`string,`Enrollment_Method`string,`Facility_State`string,`Claim_Status`string,`Manager_Name`string,`Phone_Number`string,`email_address`string,`Premium_Due`string,`Reason_Still_Open`string,`Confirmed_and_Sent`string,`Facility_Name___Nixon`STRING,`Cause_of_Loss_Code`string,`Secondary_Cause_of_Loss_Code`string,`Secondary_Cause_of_Loss_3`string,`Secondary_Reason_for_Denial_3`string,`Reason_for_Denial_Code`string,`Secondary_Reason_for_Denial_Code`string,`Mass_uploaded_info`string,`Vermin_Coverage`string,`Reserve_for_Adjustment`string,`Paid`string,`Reserve___Claims___Adjustment`STRING,`Total_All`string,`Total_Open_Claims`string,`Total_Claims`string,`Reconciled___Nixon_Check_Register`STRING,`Cause_of_Loss`string,`Stated_Cause_of_Loss`string,`Reason_for_Denial`string,`Re_opened_Claim`STRING,`AIG___Storage_Ceded_Premiums`STRING,`Email`string,`Certificate_Number`string,`Date_Approved`string,`Days_Since_Approved`string,`Pending_Payment`string,`Subtract_Month`string,`Corp_Group`string,`Days_Since_Confirmed`string,`Days_Since_First_Report`string,`Days_Since_Created`string,`Confirm_Complete`string,`14_Day_Letter_Sent`string,`Days_to_Close`string,`Created_to_Initial_Report_Date`string,`Created_By`string,`Modified_By`string,`Claim_Re_opened_Date`STRING,`Reopened_Claim_Reference`string,`Facility_Address___Nixon`STRING,`Subgrogated_Claim`string,`Subrogated_Claim_Payment`string,`Subrogated_Payment_Date`string,`Secondary_Cause_of_Loss`string,`Secondary_Reason_for_Denial`string,`Server_Update_ID`string,`Initial_report_date_filled`string,`Reason_for_Denial_Code_is_Null`string,`Reason_for_denial_is_null`string,`Cause_of_Loss_is_Null`string,`Cause_of_Loss_Code_is_Null`string,`Zoho_Claims_Record_Link`string,`Error_Codes`string,`Initial_Report_to_Approval`string,`Claims_Paid_1`string,`Initial_Report_to_Date_Closed`string,`14_Day_Letter_Yes`string,`Initial_Report_Date_Null`string,`Approved_to_Close`string,`Created_to_Approved`string,`zcrmid`string,`Policy_Name`string,`O_C_Stat`STRING,`Insured`string,`TIV_for_Location`string,`Ind_O_S___Scott`STRING,`Ind_Paid___Scott`STRING,`Exp_Paid___Scott`STRING,`Exp_O_S___Scott`STRING,`Total_Value___Scott`STRING,`Hours_since_created`bigint,`zcrm_claimid`string,`Facility_Number`string,`Insured_ID___Insuratrac`STRING,`Claim_Type`string,`Bader_Renter_Liability_Claim`string,`Renter_Liability`string,`Claim_Types`string,`Claim_Count__Descriptions`string,`Date_Closed_Null`string,`Timestamp_Confirmation_Sent`string,`Full_Address_no_Zip`string,`After_8_31_19`STRING,`Corp_Group_Doesnt_Match`STRING,`Nixon_Processor`string,`Nixon_Processor_Email`string,`Pending_Approval`string,`Pending_Approval_Hidden`string,`Bader_Archive_Claim_ID`string,`RCV_Payment`string,`ALE_Payment`string,`Indemnity_Payment`string,`Date_of_Claim_to_Approval`string,`Days_to_Close_from_DOC`string,`DOC_Count`string,`PMA_AIG`STRING,`Reviewed_CXLD_Facility_Claim`string,`Reviewed_Double_Check`string,`Filter___REVIEWED_CXLD_CLAIM`STRING,`Filter___REVIEWED_STREET_OR_ID_MISMATCH`STRING,`No_Coverage_Reason`string,`Nixon_Old_Claim_Number`string,`Not_PMA_Kathy_Facility_ID`string,`Not_PMA_Kathy_Corp_Group`string,`Combined_old___New_Claim_Number`STRING,`Exclude_Bader___Nixon_LAE_transition`STRING,`OPENCLAIMS`string,`PMA___Storage_Ceded_Premiums`STRING,`PMA___Apartments_Ceded_Premiums`STRING,`Open_Claim_Count`string,`Indemnity_Cost`string,`zcrm_company_id`string,`Paid_Claim_Count`string,`ADJ_COSTS`string,`zoho_crm_claim_link`string,`Open_Claim_Yes`string,`Nixon_Cat_Loss_Tags`string,`Date_ID_Variable`string,`Error_Claim`string\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-storsmartzoho-dev/raw/storsmart_claims/2025-06-10/1749588942'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_json.storsmartzoho_storsmart_claims`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_json.storsmartzoho_storsmart_claims"
}
Server:
  • hostname: schemamanager-5447774fc6-4w58v
  • name: schema_manager
  • process_start: 2026-04-02 21:43:44
  • sf_env: dev
  • version: 2427328685
Raw: 
{
    "name": {
        "created": "2023-09-20 18:04:55",
        "disabled": false,
        "format": "raw",
        "id": 2240,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_json",
            "table": "storsmartzoho_storsmart_claims"
        },
        "type": "json"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "14_Day_Letter_Sent": "string",
            "14_Day_Letter_Yes": "string",
            "ADJ_COSTS": "string",
            "AIG___Storage_Ceded_Premiums": "string",
            "ALE_Payment": "string",
            "Additional_Costs": "string",
            "Adjustment_Cost": "string",
            "After_8_31_19": "string",
            "Approved_By": "string",
            "Approved_to_Close": "string",
            "Bader_Archive_Claim_ID": "string",
            "Bader_Renter_Liability_Claim": "string",
            "Cause_of_Loss": "string",
            "Cause_of_Loss_Code": "string",
            "Cause_of_Loss_Code_is_Null": "string",
            "Cause_of_Loss_is_Null": "string",
            "Certificate_Number": "string",
            "Claim_Count__Descriptions": "string",
            "Claim_Number": "string",
            "Claim_Re_opened_Date": "string",
            "Claim_Reserve_Amount": "string",
            "Claim_Status": "string",
            "Claim_Type": "string",
            "Claim_Types": "string",
            "Claims_Name": "string",
            "Claims_Owner_1": "string",
            "Claims_Owner_Name": "string",
            "Claims_Paid_1": "string",
            "Combined_old___New_Claim_Number": "string",
            "Confirm_Complete": "string",
            "Confirmed_and_Sent": "string",
            "Corp_Group": "string",
            "Corp_Group_Doesnt_Match": "string",
            "Coverage_End_Date": "string",
            "Coverage_Limit": "string",
            "Coverage_Start_Date": "string",
            "Created_By": "string",
            "Created_Time": "string",
            "Created_to_Approved": "string",
            "Created_to_Initial_Report_Date": "string",
            "DOC_Count": "string",
            "Date_Approved": "string",
            "Date_Closed": "string",
            "Date_Closed_Null": "string",
            "Date_ID_Variable": "string",
            "Date_of_Claim": "string",
            "Date_of_Claim_to_Approval": "string",
            "Date_of_Loss": "string",
            "Days_Since_Approved": "string",
            "Days_Since_Confirmed": "string",
            "Days_Since_Created": "string",
            "Days_Since_First_Report": "string",
            "Days_to_Close": "string",
            "Days_to_Close_from_DOC": "string",
            "Deductible_Amount": "string",
            "Email": "string",
            "Enrollment_Method": "string",
            "Error_Claim": "string",
            "Error_Codes": "string",
            "Exclude_Bader___Nixon_LAE_transition": "string",
            "Exp_O_S___Scott": "bigint",
            "Exp_Paid___Scott": "bigint",
            "Facility_Address": "string",
            "Facility_Address___Nixon": "string",
            "Facility_City": "string",
            "Facility_Name": "string",
            "Facility_Name___Nixon": "string",
            "Facility_Number": "string",
            "Facility_State": "string",
            "Filter___REVIEWED_CXLD_CLAIM": "string",
            "Filter___REVIEWED_STREET_OR_ID_MISMATCH": "string",
            "Final_Payment": "string",
            "Full_Address_no_Zip": "string",
            "Hours_since_created": "bigint",
            "Id": "string",
            "Ind_O_S___Scott": "string",
            "Ind_Paid___Scott": "bigint",
            "Indemnity_Cost": "string",
            "Indemnity_Payment": "string",
            "Initial_Report_Date": "string",
            "Initial_Report_Date_Null": "string",
            "Initial_Report_to_Approval": "string",
            "Initial_Report_to_Date_Closed": "string",
            "Initial_report_date_filled": "string",
            "Insured": "string",
            "Insured_ID___Insuratrac": "string",
            "Insured___First_Name": "string",
            "Insured___Last_Name": "string",
            "Last_Activity_Time": "string",
            "Manager_Name": "string",
            "Mass_uploaded_info": "string",
            "Modified_By": "string",
            "Modified_Time": "string",
            "Modified_the_following": "string",
            "Nixon_Cat_Loss_Tags": "string",
            "Nixon_Old_Claim_Number": "string",
            "Nixon_Processor": "string",
            "Nixon_Processor_Email": "string",
            "No_Coverage_Reason": "string",
            "Not_PMA_Kathy_Corp_Group": "string",
            "Not_PMA_Kathy_Facility_ID": "string",
            "OPENCLAIMS": "string",
            "O_C_Stat": "string",
            "Open_Claim_Count": "string",
            "Open_Claim_Yes": "string",
            "PMA_AIG": "string",
            "PMA___Apartments_Ceded_Premiums": "string",
            "PMA___Storage_Ceded_Premiums": "string",
            "Paid": "string",
            "Paid_Claim_Count": "string",
            "Pending_Approval": "string",
            "Pending_Approval_Hidden": "string",
            "Pending_Payment": "string",
            "Phone_Number": "string",
            "Policy_Name": "string",
            "Premium_Due": "string",
            "Premium_Paid_Thru": "string",
            "RCV_Payment": "string",
            "Re_opened_Claim": "string",
            "Reason_Still_Open": "string",
            "Reason_for_Denial": "string",
            "Reason_for_Denial_Code": "string",
            "Reason_for_Denial_Code_is_Null": "string",
            "Reason_for_denial_is_null": "string",
            "Reconciled___Nixon_Check_Register": "string",
            "Renter_Liability": "string",
            "Reopened_Claim_Reference": "string",
            "Reserve___Claims___Adjustment": "string",
            "Reserve_for_Adjustment": "string",
            "Reviewed_CXLD_Facility_Claim": "string",
            "Reviewed_Double_Check": "string",
            "Secondary_Cause_of_Loss": "string",
            "Secondary_Cause_of_Loss_3": "string",
            "Secondary_Cause_of_Loss_Code": "string",
            "Secondary_Reason_for_Denial": "string",
            "Secondary_Reason_for_Denial_3": "string",
            "Secondary_Reason_for_Denial_Code": "string",
            "Server_Update_ID": "string",
            "Stated_Cause_of_Loss": "string",
            "Subgrogated_Claim": "string",
            "Subrogated_Claim_Payment": "string",
            "Subrogated_Payment_Date": "string",
            "Subtract_Month": "string",
            "TIV_for_Location": "string",
            "Timestamp_Confirmation_Sent": "string",
            "Total_All": "string",
            "Total_Claims": "string",
            "Total_Open_Claims": "string",
            "Total_Value___Scott": "string",
            "Unit_Number": "string",
            "Vermin_Coverage": "string",
            "Zip_Code": "string",
            "Zoho_Claims_Record_Link": "string",
            "email_address": "string",
            "zcrm_claimid": "string",
            "zcrm_company_id": "string",
            "zcrmid": "string",
            "zoho_crm_claim_link": "string"
        },
        "created": "2025-06-10 16:00:20",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_json`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_json.storsmartzoho_storsmart_claims`\n(\n`Id`string,`Claims_Name`string,`Claims_Owner_1`string,`Claims_Owner_Name`string,`Created_Time`string,`Modified_Time`string,`Last_Activity_Time`string,`Claim_Reserve_Amount`string,`Initial_Report_Date`string,`Approved_By`string,`Date_Closed`string,`Final_Payment`string,`Adjustment_Cost`string,`Additional_Costs`string,`Facility_City`string,`Modified_the_following`string,`Facility_Name`string,`Claim_Number`string,`Facility_Address`string,`Insured___Last_Name`STRING,`Insured___First_Name`STRING,`Date_of_Loss`string,`Date_of_Claim`string,`Premium_Paid_Thru`string,`Zip_Code`string,`Unit_Number`string,`Coverage_Limit`string,`Coverage_Start_Date`string,`Coverage_End_Date`string,`Deductible_Amount`string,`Enrollment_Method`string,`Facility_State`string,`Claim_Status`string,`Manager_Name`string,`Phone_Number`string,`email_address`string,`Premium_Due`string,`Reason_Still_Open`string,`Confirmed_and_Sent`string,`Facility_Name___Nixon`STRING,`Cause_of_Loss_Code`string,`Secondary_Cause_of_Loss_Code`string,`Secondary_Cause_of_Loss_3`string,`Secondary_Reason_for_Denial_3`string,`Reason_for_Denial_Code`string,`Secondary_Reason_for_Denial_Code`string,`Mass_uploaded_info`string,`Vermin_Coverage`string,`Reserve_for_Adjustment`string,`Paid`string,`Reserve___Claims___Adjustment`STRING,`Total_All`string,`Total_Open_Claims`string,`Total_Claims`string,`Reconciled___Nixon_Check_Register`STRING,`Cause_of_Loss`string,`Stated_Cause_of_Loss`string,`Reason_for_Denial`string,`Re_opened_Claim`STRING,`AIG___Storage_Ceded_Premiums`STRING,`Email`string,`Certificate_Number`string,`Date_Approved`string,`Days_Since_Approved`string,`Pending_Payment`string,`Subtract_Month`string,`Corp_Group`string,`Days_Since_Confirmed`string,`Days_Since_First_Report`string,`Days_Since_Created`string,`Confirm_Complete`string,`14_Day_Letter_Sent`string,`Days_to_Close`string,`Created_to_Initial_Report_Date`string,`Created_By`string,`Modified_By`string,`Claim_Re_opened_Date`STRING,`Reopened_Claim_Reference`string,`Facility_Address___Nixon`STRING,`Subgrogated_Claim`string,`Subrogated_Claim_Payment`string,`Subrogated_Payment_Date`string,`Secondary_Cause_of_Loss`string,`Secondary_Reason_for_Denial`string,`Server_Update_ID`string,`Initial_report_date_filled`string,`Reason_for_Denial_Code_is_Null`string,`Reason_for_denial_is_null`string,`Cause_of_Loss_is_Null`string,`Cause_of_Loss_Code_is_Null`string,`Zoho_Claims_Record_Link`string,`Error_Codes`string,`Initial_Report_to_Approval`string,`Claims_Paid_1`string,`Initial_Report_to_Date_Closed`string,`14_Day_Letter_Yes`string,`Initial_Report_Date_Null`string,`Approved_to_Close`string,`Created_to_Approved`string,`zcrmid`string,`Policy_Name`string,`O_C_Stat`STRING,`Insured`string,`TIV_for_Location`string,`Ind_O_S___Scott`STRING,`Ind_Paid___Scott`STRING,`Exp_Paid___Scott`STRING,`Exp_O_S___Scott`STRING,`Total_Value___Scott`STRING,`Hours_since_created`bigint,`zcrm_claimid`string,`Facility_Number`string,`Insured_ID___Insuratrac`STRING,`Claim_Type`string,`Bader_Renter_Liability_Claim`string,`Renter_Liability`string,`Claim_Types`string,`Claim_Count__Descriptions`string,`Date_Closed_Null`string,`Timestamp_Confirmation_Sent`string,`Full_Address_no_Zip`string,`After_8_31_19`STRING,`Corp_Group_Doesnt_Match`STRING,`Nixon_Processor`string,`Nixon_Processor_Email`string,`Pending_Approval`string,`Pending_Approval_Hidden`string,`Bader_Archive_Claim_ID`string,`RCV_Payment`string,`ALE_Payment`string,`Indemnity_Payment`string,`Date_of_Claim_to_Approval`string,`Days_to_Close_from_DOC`string,`DOC_Count`string,`PMA_AIG`STRING,`Reviewed_CXLD_Facility_Claim`string,`Reviewed_Double_Check`string,`Filter___REVIEWED_CXLD_CLAIM`STRING,`Filter___REVIEWED_STREET_OR_ID_MISMATCH`STRING,`No_Coverage_Reason`string,`Nixon_Old_Claim_Number`string,`Not_PMA_Kathy_Facility_ID`string,`Not_PMA_Kathy_Corp_Group`string,`Combined_old___New_Claim_Number`STRING,`Exclude_Bader___Nixon_LAE_transition`STRING,`OPENCLAIMS`string,`PMA___Storage_Ceded_Premiums`STRING,`PMA___Apartments_Ceded_Premiums`STRING,`Open_Claim_Count`string,`Indemnity_Cost`string,`zcrm_company_id`string,`Paid_Claim_Count`string,`ADJ_COSTS`string,`zoho_crm_claim_link`string,`Open_Claim_Yes`string,`Nixon_Cat_Loss_Tags`string,`Date_ID_Variable`string,`Error_Claim`string\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-storsmartzoho-dev/raw/storsmart_claims/2025-06-10/1749588942'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_json.storsmartzoho_storsmart_claims`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_json.storsmartzoho_storsmart_claims"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}
©2019 SpareFoot Data Platform