Schema Info

Schema Name: sfdl_dev_csv.storsmartzoho_storsmart_claims
  • created: 2023-08-14 10:12:08
  • disabled: False
  • format: raw
  • id: 2229
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_dev_csv",
    "table": "storsmartzoho_storsmart_claims"
}
  • type: csv
Schema Versions: 7
    • created: 2023-08-16 12:01:54
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.storsmartzoho_storsmart_claims`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.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 , `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`  string , `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.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-16/1692205308'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.storsmartzoho_storsmart_claims"
]
    • hive_path: s3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-16/1692205308
    • id: 4697528
    • processed: 1
    • raw_data: 
      {
    "14 Day Letter Sent": 70,
    "14 Day Letter Yes": 94,
    "ADJ COSTS": 151,
    "AIG - Storage Ceded Premiums": 58,
    "ALE Payment": 128,
    "Additional Costs": 13,
    "Adjustment Cost": 12,
    "After 8-31-19": 120,
    "Approved By": 9,
    "Approved to Close": 96,
    "Bader Archive Claim ID": 126,
    "Bader Renter Liability Claim": 113,
    "Cause of Loss": 55,
    "Cause of Loss Code": 40,
    "Cause of Loss Code is Null": 88,
    "Cause of Loss is Null": 87,
    "Certificate Number": 60,
    "Claim Count  Descriptions": 116,
    "Claim Number": 17,
    "Claim Re-opened Date": 75,
    "Claim Reserve Amount": 7,
    "Claim Status": 32,
    "Claim Type": 112,
    "Claim Types": 115,
    "Claims Name": 1,
    "Claims Owner Name": 3,
    "Claims Owner_1": 2,
    "Claims Paid 1": 92,
    "Combined old - New Claim Number": 142,
    "Confirm Complete": 69,
    "Confirmed and Sent": 38,
    "Corp Group": 65,
    "Corp Group Doesnt Match": 121,
    "Coverage End Date": 28,
    "Coverage Limit": 26,
    "Coverage Start Date": 27,
    "Created By": 73,
    "Created Time": 4,
    "Created to Approved": 97,
    "Created to Initial Report Date": 72,
    "DOC Count": 132,
    "Date Approved": 61,
    "Date Closed": 10,
    "Date Closed Null": 117,
    "Date ID Variable": 155,
    "Date of Claim": 22,
    "Date of Claim to Approval": 130,
    "Date of Loss": 21,
    "Days Since Approved": 62,
    "Days Since Confirmed": 66,
    "Days Since Created": 68,
    "Days Since First Report": 67,
    "Days to Close": 71,
    "Days to Close from DOC": 131,
    "Deductible Amount": 29,
    "Email": 59,
    "Enrollment Method": 30,
    "Error Claim": 156,
    "Error Codes": 90,
    "Exclude Bader - Nixon LAE transition": 143,
    "Exp O/S - Scott": 106,
    "Exp Paid - Scott": 105,
    "Facility Address": 18,
    "Facility Address - Nixon": 77,
    "Facility City": 14,
    "Facility Name": 16,
    "Facility Name - Nixon": 39,
    "Facility Number": 110,
    "Facility State": 31,
    "Filter - REVIEWED CXLD CLAIM": 136,
    "Filter - REVIEWED STREET OR ID MISMATCH": 137,
    "Final Payment": 11,
    "Full Address no Zip": 119,
    "Hours since created": 108,
    "Id": 0,
    "Ind O/S - Scott": 103,
    "Ind Paid - Scott": 104,
    "Indemnity Cost": 148,
    "Indemnity Payment": 129,
    "Initial Report Date": 8,
    "Initial Report Date Null": 95,
    "Initial Report to Approval": 91,
    "Initial Report to Date Closed": 93,
    "Initial report date filled": 84,
    "Insured": 101,
    "Insured - First Name": 20,
    "Insured - Last Name": 19,
    "Insured ID - Insuratrac": 111,
    "Last Activity Time": 6,
    "Manager Name": 33,
    "Mass uploaded info": 46,
    "Modified By": 74,
    "Modified Time": 5,
    "Modified the following": 15,
    "Nixon Cat Loss Tags": 154,
    "Nixon Old Claim Number": 139,
    "Nixon Processor": 122,
    "Nixon Processor Email": 123,
    "No Coverage Reason": 138,
    "Not PMA Kathy Corp Group": 141,
    "Not PMA Kathy Facility ID": 140,
    "O/C Stat": 100,
    "OPENCLAIMS": 144,
    "Open Claim Count": 147,
    "Open Claim Yes": 153,
    "PMA - Apartments Ceded Premiums": 146,
    "PMA - Storage Ceded Premiums": 145,
    "PMA-AIG": 133,
    "Paid": 49,
    "Paid Claim Count": 150,
    "Pending Approval": 124,
    "Pending Approval Hidden": 125,
    "Pending Payment": 63,
    "Phone Number": 34,
    "Policy Name": 99,
    "Premium Due": 36,
    "Premium Paid Thru": 23,
    "RCV Payment": 127,
    "Re-opened Claim": 57,
    "Reason Still Open": 37,
    "Reason for Denial": 56,
    "Reason for Denial Code": 44,
    "Reason for Denial Code is Null": 85,
    "Reason for denial is null": 86,
    "Reconciled - Nixon Check Register": 54,
    "Renter Liability": 114,
    "Reopened Claim Reference": 76,
    "Reserve - Claims & Adjustment": 50,
    "Reserve for Adjustment": 48,
    "Reviewed CXLD Facility Claim": 134,
    "Reviewed Double Check": 135,
    "Secondary Cause of Loss": 81,
    "Secondary Cause of Loss 3": 42,
    "Secondary Cause of Loss Code": 41,
    "Secondary Reason for Denial": 82,
    "Secondary Reason for Denial 3": 43,
    "Secondary Reason for Denial Code": 45,
    "Server_Update_ID": 83,
    "Subgrogated Claim": 78,
    "Subrogated Claim Payment": 79,
    "Subrogated Payment Date": 80,
    "Subtract Month": 64,
    "TIV for Location": 102,
    "Timestamp Confirmation Sent": 118,
    "Total All": 51,
    "Total Claims": 53,
    "Total Open Claims": 52,
    "Total Value - Scott": 107,
    "Unit Number": 25,
    "Vermin Coverage": 47,
    "Zip Code": 24,
    "Zoho Claims Record Link": 89,
    "email address": 35,
    "zcrm_claimid": 109,
    "zcrm_company_id": 149,
    "zcrmid": 98,
    "zoho crm claim link": 152
}
    • 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_Notes": "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_Doesn_t_Match": "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_Date_of_Claim": "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",
    "Description_of_Damage": "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",
    "Fields_Changed_By_Nixon": "string",
    "Filter___REVIEWED_CXLD_CLAIM": "string",
    "Filter___REVIEWED_STREET_OR_ID_MISMATCH": "string",
    "Final_Payment": "string",
    "First_Report_Comments": "string",
    "First_Report_Email": "string",
    "Full_Address_no_Zip": "string",
    "Hours_since_created": "string",
    "Id": "string",
    "Ind_O_S___Scott": "string",
    "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",
    "Payment": "string",
    "Pending_Approval": "string",
    "Pending_Approval_Hidden": "string",
    "Pending_Approval_Notes": "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",
    "Status": "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: 2229
    • schema_scan_id: 6251553
    • updated: 2023-08-16 12:02:05
    • created: 2023-08-16 11:31:39
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.storsmartzoho_storsmart_claims`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.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 , `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`  string , `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.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-16/1692203489'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.storsmartzoho_storsmart_claims"
]
    • hive_path: s3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-16/1692203489
    • id: 4697522
    • processed: 1
    • raw_data: 
      {
    "14 Day Letter Sent": 70,
    "14 Day Letter Yes": 94,
    "ADJ COSTS": 151,
    "AIG - Storage Ceded Premiums": 58,
    "ALE Payment": 128,
    "Additional Costs": 13,
    "Adjustment Cost": 12,
    "After 8-31-19": 120,
    "Approved By": 9,
    "Approved to Close": 96,
    "Bader Archive Claim ID": 126,
    "Bader Renter Liability Claim": 113,
    "Cause of Loss": 55,
    "Cause of Loss Code": 40,
    "Cause of Loss Code is Null": 88,
    "Cause of Loss is Null": 87,
    "Certificate Number": 60,
    "Claim Count  Descriptions": 116,
    "Claim Number": 17,
    "Claim Re-opened Date": 75,
    "Claim Reserve Amount": 7,
    "Claim Status": 32,
    "Claim Type": 112,
    "Claim Types": 115,
    "Claims Name": 1,
    "Claims Owner Name": 3,
    "Claims Owner_1": 2,
    "Claims Paid 1": 92,
    "Combined old - New Claim Number": 142,
    "Confirm Complete": 69,
    "Confirmed and Sent": 38,
    "Corp Group": 65,
    "Corp Group Doesnt Match": 121,
    "Coverage End Date": 28,
    "Coverage Limit": 26,
    "Coverage Start Date": 27,
    "Created By": 73,
    "Created Time": 4,
    "Created to Approved": 97,
    "Created to Initial Report Date": 72,
    "DOC Count": 132,
    "Date Approved": 61,
    "Date Closed": 10,
    "Date Closed Null": 117,
    "Date ID Variable": 155,
    "Date of Claim": 22,
    "Date of Claim to Approval": 130,
    "Date of Loss": 21,
    "Days Since Approved": 62,
    "Days Since Confirmed": 66,
    "Days Since Created": 68,
    "Days Since First Report": 67,
    "Days to Close": 71,
    "Days to Close from DOC": 131,
    "Deductible Amount": 29,
    "Email": 59,
    "Enrollment Method": 30,
    "Error Claim": 156,
    "Error Codes": 90,
    "Exclude Bader - Nixon LAE transition": 143,
    "Exp O/S - Scott": 106,
    "Exp Paid - Scott": 105,
    "Facility Address": 18,
    "Facility Address - Nixon": 77,
    "Facility City": 14,
    "Facility Name": 16,
    "Facility Name - Nixon": 39,
    "Facility Number": 110,
    "Facility State": 31,
    "Filter - REVIEWED CXLD CLAIM": 136,
    "Filter - REVIEWED STREET OR ID MISMATCH": 137,
    "Final Payment": 11,
    "Full Address no Zip": 119,
    "Hours since created": 108,
    "Id": 0,
    "Ind O/S - Scott": 103,
    "Ind Paid - Scott": 104,
    "Indemnity Cost": 148,
    "Indemnity Payment": 129,
    "Initial Report Date": 8,
    "Initial Report Date Null": 95,
    "Initial Report to Approval": 91,
    "Initial Report to Date Closed": 93,
    "Initial report date filled": 84,
    "Insured": 101,
    "Insured - First Name": 20,
    "Insured - Last Name": 19,
    "Insured ID - Insuratrac": 111,
    "Last Activity Time": 6,
    "Manager Name": 33,
    "Mass uploaded info": 46,
    "Modified By": 74,
    "Modified Time": 5,
    "Modified the following": 15,
    "Nixon Cat Loss Tags": 154,
    "Nixon Old Claim Number": 139,
    "Nixon Processor": 122,
    "Nixon Processor Email": 123,
    "No Coverage Reason": 138,
    "Not PMA Kathy Corp Group": 141,
    "Not PMA Kathy Facility ID": 140,
    "O/C Stat": 100,
    "OPENCLAIMS": 144,
    "Open Claim Count": 147,
    "Open Claim Yes": 153,
    "PMA - Apartments Ceded Premiums": 146,
    "PMA - Storage Ceded Premiums": 145,
    "PMA-AIG": 133,
    "Paid": 49,
    "Paid Claim Count": 150,
    "Pending Approval": 124,
    "Pending Approval Hidden": 125,
    "Pending Payment": 63,
    "Phone Number": 34,
    "Policy Name": 99,
    "Premium Due": 36,
    "Premium Paid Thru": 23,
    "RCV Payment": 127,
    "Re-opened Claim": 57,
    "Reason Still Open": 37,
    "Reason for Denial": 56,
    "Reason for Denial Code": 44,
    "Reason for Denial Code is Null": 85,
    "Reason for denial is null": 86,
    "Reconciled - Nixon Check Register": 54,
    "Renter Liability": 114,
    "Reopened Claim Reference": 76,
    "Reserve - Claims & Adjustment": 50,
    "Reserve for Adjustment": 48,
    "Reviewed CXLD Facility Claim": 134,
    "Reviewed Double Check": 135,
    "Secondary Cause of Loss": 81,
    "Secondary Cause of Loss 3": 42,
    "Secondary Cause of Loss Code": 41,
    "Secondary Reason for Denial": 82,
    "Secondary Reason for Denial 3": 43,
    "Secondary Reason for Denial Code": 45,
    "Server_Update_ID": 83,
    "Subgrogated Claim": 78,
    "Subrogated Claim Payment": 79,
    "Subrogated Payment Date": 80,
    "Subtract Month": 64,
    "TIV for Location": 102,
    "Timestamp Confirmation Sent": 118,
    "Total All": 51,
    "Total Claims": 53,
    "Total Open Claims": 52,
    "Total Value - Scott": 107,
    "Unit Number": 25,
    "Vermin Coverage": 47,
    "Zip Code": 24,
    "Zoho Claims Record Link": 89,
    "email address": 35,
    "zcrm_claimid": 109,
    "zcrm_company_id": 149,
    "zcrmid": 98,
    "zoho crm claim link": 152
}
    • 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_Notes": "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_Doesn_t_Match": "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_Date_of_Claim": "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",
    "Description_of_Damage": "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",
    "Fields_Changed_By_Nixon": "string",
    "Filter___REVIEWED_CXLD_CLAIM": "string",
    "Filter___REVIEWED_STREET_OR_ID_MISMATCH": "string",
    "Final_Payment": "string",
    "First_Report_Comments": "string",
    "First_Report_Email": "string",
    "Full_Address_no_Zip": "string",
    "Hours_since_created": "string",
    "Id": "string",
    "Ind_O_S___Scott": "string",
    "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",
    "Payment": "string",
    "Pending_Approval": "string",
    "Pending_Approval_Hidden": "string",
    "Pending_Approval_Notes": "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",
    "Status": "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: 2229
    • schema_scan_id: 6251533
    • updated: 2023-08-16 11:31:50
    • created: 2023-08-14 15:33:37
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.storsmartzoho_storsmart_claims`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.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 , `Stated_Cause_of_Loss`  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 , `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_Notes`  string , `First_Report_Email`  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 , `Fields_Changed_By_Nixon`  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`  string , `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 , `First_Report_Comments`  string , `Pending_Approval_Notes`  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.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-14/1692045187'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.storsmartzoho_storsmart_claims"
]
    • hive_path: s3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-14/1692045187
    • id: 4697333
    • processed: 1
    • raw_data: 
      {
    "14 Day Letter Sent": 71,
    "14 Day Letter Yes": 98,
    "ADJ COSTS": 157,
    "AIG - Storage Ceded Premiums": 59,
    "ALE Payment": 134,
    "Additional Costs": 13,
    "Adjustment Cost": 12,
    "After 8-31-19": 124,
    "Approved By": 9,
    "Approved to Close": 100,
    "Bader Archive Claim ID": 132,
    "Bader Renter Liability Claim": 117,
    "Cause of Loss": 56,
    "Cause of Loss Code": 41,
    "Cause of Loss Code is Null": 92,
    "Cause of Loss is Null": 91,
    "Certificate Number": 61,
    "Claim Count  Descriptions": 120,
    "Claim Notes": 76,
    "Claim Number": 18,
    "Claim Re-opened Date": 78,
    "Claim Reserve Amount": 7,
    "Claim Status": 33,
    "Claim Type": 116,
    "Claim Types": 119,
    "Claims Name": 1,
    "Claims Owner Name": 3,
    "Claims Owner_1": 2,
    "Claims Paid 1": 96,
    "Combined old - New Claim Number": 148,
    "Confirm Complete": 70,
    "Confirmed and Sent": 39,
    "Corp Group": 66,
    "Corp Group Doesnt Match": 125,
    "Coverage End Date": 29,
    "Coverage Limit": 27,
    "Coverage Start Date": 28,
    "Created By": 74,
    "Created Time": 4,
    "Created to Approved": 101,
    "Created to Initial Report Date": 73,
    "DOC Count": 138,
    "Date Approved": 62,
    "Date Closed": 10,
    "Date Closed Null": 121,
    "Date ID Variable": 161,
    "Date of Claim": 23,
    "Date of Claim to Approval": 136,
    "Date of Loss": 22,
    "Days Since Approved": 63,
    "Days Since Confirmed": 67,
    "Days Since Created": 69,
    "Days Since First Report": 68,
    "Days to Close": 72,
    "Days to Close from DOC": 137,
    "Deductible Amount": 30,
    "Email": 60,
    "Enrollment Method": 31,
    "Error Claim": 162,
    "Error Codes": 94,
    "Exclude Bader - Nixon LAE transition": 149,
    "Exp O/S - Scott": 110,
    "Exp Paid - Scott": 109,
    "Facility Address": 19,
    "Facility Address - Nixon": 80,
    "Facility City": 15,
    "Facility Name": 17,
    "Facility Name - Nixon": 40,
    "Facility Number": 114,
    "Facility State": 32,
    "Fields_Changed_By_Nixon": 87,
    "Filter - REVIEWED CXLD CLAIM": 142,
    "Filter - REVIEWED STREET OR ID MISMATCH": 143,
    "Final Payment": 11,
    "First Report Comments": 128,
    "First Report Email": 77,
    "Full Address no Zip": 123,
    "Hours since created": 112,
    "Id": 0,
    "Ind O/S - Scott": 107,
    "Ind Paid - Scott": 108,
    "Indemnity Cost": 154,
    "Indemnity Payment": 135,
    "Initial Report Date": 8,
    "Initial Report Date Null": 99,
    "Initial Report to Approval": 95,
    "Initial Report to Date Closed": 97,
    "Initial report date filled": 88,
    "Insured": 105,
    "Insured - First Name": 21,
    "Insured - Last Name": 20,
    "Insured ID - Insuratrac": 115,
    "Last Activity Time": 6,
    "Manager Name": 34,
    "Mass uploaded info": 47,
    "Modified By": 75,
    "Modified Time": 5,
    "Modified the following": 16,
    "Nixon Cat Loss Tags": 160,
    "Nixon Old Claim Number": 145,
    "Nixon Processor": 126,
    "Nixon Processor Email": 127,
    "No Coverage Reason": 144,
    "Not PMA Kathy Corp Group": 147,
    "Not PMA Kathy Facility ID": 146,
    "O/C Stat": 104,
    "OPENCLAIMS": 150,
    "Open Claim Count": 153,
    "Open Claim Yes": 159,
    "PMA - Apartments Ceded Premiums": 152,
    "PMA - Storage Ceded Premiums": 151,
    "PMA-AIG": 139,
    "Paid": 50,
    "Paid Claim Count": 156,
    "Pending Approval": 130,
    "Pending Approval Hidden": 131,
    "Pending Approval Notes": 129,
    "Pending Payment": 64,
    "Phone Number": 35,
    "Policy Name": 103,
    "Premium Due": 37,
    "Premium Paid Thru": 24,
    "RCV Payment": 133,
    "Re-opened Claim": 58,
    "Reason Still Open": 38,
    "Reason for Denial": 57,
    "Reason for Denial Code": 45,
    "Reason for Denial Code is Null": 89,
    "Reason for denial is null": 90,
    "Reconciled - Nixon Check Register": 55,
    "Renter Liability": 118,
    "Reopened Claim Reference": 79,
    "Reserve - Claims & Adjustment": 51,
    "Reserve for Adjustment": 49,
    "Reviewed CXLD Facility Claim": 140,
    "Reviewed Double Check": 141,
    "Secondary Cause of Loss": 84,
    "Secondary Cause of Loss 3": 43,
    "Secondary Cause of Loss Code": 42,
    "Secondary Reason for Denial": 85,
    "Secondary Reason for Denial 3": 44,
    "Secondary Reason for Denial Code": 46,
    "Server_Update_ID": 86,
    "Stated Cause of Loss": 14,
    "Subgrogated Claim": 81,
    "Subrogated Claim Payment": 82,
    "Subrogated Payment Date": 83,
    "Subtract Month": 65,
    "TIV for Location": 106,
    "Timestamp Confirmation Sent": 122,
    "Total All": 52,
    "Total Claims": 54,
    "Total Open Claims": 53,
    "Total Value - Scott": 111,
    "Unit Number": 26,
    "Vermin Coverage": 48,
    "Zip Code": 25,
    "Zoho Claims Record Link": 93,
    "email address": 36,
    "zcrm_claimid": 113,
    "zcrm_company_id": 155,
    "zcrmid": 102,
    "zoho crm claim link": 158
}
    • 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_Notes": "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_Doesn_t_Match": "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_Date_of_Claim": "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",
    "Description_of_Damage": "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",
    "Fields_Changed_By_Nixon": "string",
    "Filter___REVIEWED_CXLD_CLAIM": "string",
    "Filter___REVIEWED_STREET_OR_ID_MISMATCH": "string",
    "Final_Payment": "string",
    "First_Report_Comments": "string",
    "First_Report_Email": "string",
    "Full_Address_no_Zip": "string",
    "Hours_since_created": "string",
    "Id": "string",
    "Ind_O_S___Scott": "string",
    "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",
    "Payment": "string",
    "Pending_Approval": "string",
    "Pending_Approval_Hidden": "string",
    "Pending_Approval_Notes": "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",
    "Status": "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: 2229
    • schema_scan_id: 6250352
    • updated: 2023-08-14 15:33:48
    • created: 2023-08-14 14:31:52
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.storsmartzoho_storsmart_claims`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.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 , `Stated_Cause_of_Loss`  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 , `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_Notes`  string , `Description_of_Damage`  string , `First_Report_Email`  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 , `Fields_Changed_By_Nixon`  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`  string , `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_Doesn_t_Match`  string , `Nixon_Processor`  string , `Nixon_Processor_Email`  string , `First_Report_Comments`  string , `Pending_Approval_Notes`  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.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-14/1692041489'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.storsmartzoho_storsmart_claims"
]
    • hive_path: s3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-14/1692041489
    • id: 4697330
    • processed: 1
    • raw_data: 
      {
    "14 Day Letter Sent": 71,
    "14 Day Letter Yes": 99,
    "ADJ COSTS": 158,
    "AIG - Storage Ceded Premiums": 59,
    "ALE Payment": 135,
    "Additional Costs": 13,
    "Adjustment Cost": 12,
    "After 8-31-19": 125,
    "Approved By": 9,
    "Approved to Close": 101,
    "Bader Archive Claim ID": 133,
    "Bader Renter Liability Claim": 118,
    "Cause of Loss": 56,
    "Cause of Loss Code": 41,
    "Cause of Loss Code is Null": 93,
    "Cause of Loss is Null": 92,
    "Certificate Number": 61,
    "Claim Count  Descriptions": 121,
    "Claim Notes": 76,
    "Claim Number": 18,
    "Claim Re-opened Date": 79,
    "Claim Reserve Amount": 7,
    "Claim Status": 33,
    "Claim Type": 117,
    "Claim Types": 120,
    "Claims Name": 1,
    "Claims Owner Name": 3,
    "Claims Owner_1": 2,
    "Claims Paid 1": 97,
    "Combined old - New Claim Number": 149,
    "Confirm Complete": 70,
    "Confirmed and Sent": 39,
    "Corp Group": 66,
    "Corp Group Doesn't Match": 126,
    "Coverage End Date": 29,
    "Coverage Limit": 27,
    "Coverage Start Date": 28,
    "Created By": 74,
    "Created Time": 4,
    "Created to Approved": 102,
    "Created to Initial Report Date": 73,
    "DOC Count": 139,
    "Date Approved": 62,
    "Date Closed": 10,
    "Date Closed Null": 122,
    "Date ID Variable": 162,
    "Date of Claim": 23,
    "Date of Claim to Approval": 137,
    "Date of Loss": 22,
    "Days Since Approved": 63,
    "Days Since Confirmed": 67,
    "Days Since Created": 69,
    "Days Since First Report": 68,
    "Days to Close": 72,
    "Days to Close from DOC": 138,
    "Deductible Amount": 30,
    "Description of Damage": 77,
    "Email": 60,
    "Enrollment Method": 31,
    "Error Claim": 163,
    "Error Codes": 95,
    "Exclude Bader - Nixon LAE transition": 150,
    "Exp O/S - Scott": 111,
    "Exp Paid - Scott": 110,
    "Facility Address": 19,
    "Facility Address - Nixon": 81,
    "Facility City": 15,
    "Facility Name": 17,
    "Facility Name - Nixon": 40,
    "Facility Number": 115,
    "Facility State": 32,
    "Fields_Changed_By_Nixon": 88,
    "Filter - REVIEWED CXLD CLAIM": 143,
    "Filter - REVIEWED STREET OR ID MISMATCH": 144,
    "Final Payment": 11,
    "First Report Comments": 129,
    "First Report Email": 78,
    "Full Address no Zip": 124,
    "Hours since created": 113,
    "Id": 0,
    "Ind O/S - Scott": 108,
    "Ind Paid - Scott": 109,
    "Indemnity Cost": 155,
    "Indemnity Payment": 136,
    "Initial Report Date": 8,
    "Initial Report Date Null": 100,
    "Initial Report to Approval": 96,
    "Initial Report to Date Closed": 98,
    "Initial report date filled": 89,
    "Insured": 106,
    "Insured - First Name": 21,
    "Insured - Last Name": 20,
    "Insured ID - Insuratrac": 116,
    "Last Activity Time": 6,
    "Manager Name": 34,
    "Mass uploaded info": 47,
    "Modified By": 75,
    "Modified Time": 5,
    "Modified the following": 16,
    "Nixon Cat Loss Tags": 161,
    "Nixon Old Claim Number": 146,
    "Nixon Processor": 127,
    "Nixon Processor Email": 128,
    "No Coverage Reason": 145,
    "Not PMA Kathy Corp Group": 148,
    "Not PMA Kathy Facility ID": 147,
    "O/C Stat": 105,
    "OPENCLAIMS": 151,
    "Open Claim Count": 154,
    "Open Claim Yes": 160,
    "PMA - Apartments Ceded Premiums": 153,
    "PMA - Storage Ceded Premiums": 152,
    "PMA-AIG": 140,
    "Paid": 50,
    "Paid Claim Count": 157,
    "Pending Approval": 131,
    "Pending Approval Hidden": 132,
    "Pending Approval Notes": 130,
    "Pending Payment": 64,
    "Phone Number": 35,
    "Policy Name": 104,
    "Premium Due": 37,
    "Premium Paid Thru": 24,
    "RCV Payment": 134,
    "Re-opened Claim": 58,
    "Reason Still Open": 38,
    "Reason for Denial": 57,
    "Reason for Denial Code": 45,
    "Reason for Denial Code is Null": 90,
    "Reason for denial is null": 91,
    "Reconciled - Nixon Check Register": 55,
    "Renter Liability": 119,
    "Reopened Claim Reference": 80,
    "Reserve - Claims & Adjustment": 51,
    "Reserve for Adjustment": 49,
    "Reviewed CXLD Facility Claim": 141,
    "Reviewed Double Check": 142,
    "Secondary Cause of Loss": 85,
    "Secondary Cause of Loss 3": 43,
    "Secondary Cause of Loss Code": 42,
    "Secondary Reason for Denial": 86,
    "Secondary Reason for Denial 3": 44,
    "Secondary Reason for Denial Code": 46,
    "Server_Update_ID": 87,
    "Stated Cause of Loss": 14,
    "Subgrogated Claim": 82,
    "Subrogated Claim Payment": 83,
    "Subrogated Payment Date": 84,
    "Subtract Month": 65,
    "TIV for Location": 107,
    "Timestamp Confirmation Sent": 123,
    "Total All": 52,
    "Total Claims": 54,
    "Total Open Claims": 53,
    "Total Value - Scott": 112,
    "Unit Number": 26,
    "Vermin Coverage": 48,
    "Zip Code": 25,
    "Zoho Claims Record Link": 94,
    "email address": 36,
    "zcrm_claimid": 114,
    "zcrm_company_id": 156,
    "zcrmid": 103,
    "zoho crm claim link": 159
}
    • 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_Notes": "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_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_Date_of_Claim": "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",
    "Description_of_Damage": "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",
    "Fields_Changed_By_Nixon": "string",
    "Filter___REVIEWED_CXLD_CLAIM": "string",
    "Filter___REVIEWED_STREET_OR_ID_MISMATCH": "string",
    "Final_Payment": "string",
    "First_Report_Comments": "string",
    "First_Report_Email": "string",
    "Full_Address_no_Zip": "string",
    "Hours_since_created": "string",
    "Id": "string",
    "Ind_O_S___Scott": "string",
    "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",
    "Payment": "string",
    "Pending_Approval": "string",
    "Pending_Approval_Hidden": "string",
    "Pending_Approval_Notes": "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",
    "Status": "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: 2229
    • schema_scan_id: 6250341
    • updated: 2023-08-14 14:32:03
    • created: 2023-08-14 12:02:54
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.storsmartzoho_storsmart_claims`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.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 , `Stated_Cause_of_Loss`  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 , `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_Notes`  string , `Description_of_Damage`  string , `First_Report_Email`  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 , `Fields_Changed_By_Nixon`  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`  string , `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_Doesn_t_Match`  string , `Nixon_Processor`  string , `Nixon_Processor_Email`  string , `First_Report_Comments`  string , `Pending_Approval_Notes`  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.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-14/1692032560'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.storsmartzoho_storsmart_claims"
]
    • hive_path: s3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-14/1692032560
    • id: 4697327
    • processed: 1
    • raw_data: 
      {
    "14 Day Letter Sent": 71,
    "14 Day Letter Yes": 99,
    "ADJ COSTS": 158,
    "AIG - Storage Ceded Premiums": 59,
    "ALE Payment": 135,
    "Additional Costs": 13,
    "Adjustment Cost": 12,
    "After 8-31-19": 125,
    "Approved By": 9,
    "Approved to Close": 101,
    "Bader Archive Claim ID": 133,
    "Bader Renter Liability Claim": 118,
    "Cause of Loss": 56,
    "Cause of Loss Code": 41,
    "Cause of Loss Code is Null": 93,
    "Cause of Loss is Null": 92,
    "Certificate Number": 61,
    "Claim Count  Descriptions": 121,
    "Claim Notes": 76,
    "Claim Number": 18,
    "Claim Re-opened Date": 79,
    "Claim Reserve Amount": 7,
    "Claim Status": 33,
    "Claim Type": 117,
    "Claim Types": 120,
    "Claims Name": 1,
    "Claims Owner Name": 3,
    "Claims Owner_1": 2,
    "Claims Paid 1": 97,
    "Combined old - New Claim Number": 149,
    "Confirm Complete": 70,
    "Confirmed and Sent": 39,
    "Corp Group": 66,
    "Corp Group Doesn't Match": 126,
    "Coverage End Date": 29,
    "Coverage Limit": 27,
    "Coverage Start Date": 28,
    "Created By": 74,
    "Created Time": 4,
    "Created to Approved": 102,
    "Created to Initial Report Date": 73,
    "DOC Count": 139,
    "Date Approved": 62,
    "Date Closed": 10,
    "Date Closed Null": 122,
    "Date ID Variable": 162,
    "Date of Claim": 23,
    "Date of Claim to Approval": 137,
    "Date of Loss": 22,
    "Days Since Approved": 63,
    "Days Since Confirmed": 67,
    "Days Since Created": 69,
    "Days Since First Report": 68,
    "Days to Close": 72,
    "Days to Close from DOC": 138,
    "Deductible Amount": 30,
    "Description of Damage": 77,
    "Email": 60,
    "Enrollment Method": 31,
    "Error Claim": 163,
    "Error Codes": 95,
    "Exclude Bader - Nixon LAE transition": 150,
    "Exp O/S - Scott": 111,
    "Exp Paid - Scott": 110,
    "Facility Address": 19,
    "Facility Address - Nixon": 81,
    "Facility City": 15,
    "Facility Name": 17,
    "Facility Name - Nixon": 40,
    "Facility Number": 115,
    "Facility State": 32,
    "Fields_Changed_By_Nixon": 88,
    "Filter - REVIEWED CXLD CLAIM": 143,
    "Filter - REVIEWED STREET OR ID MISMATCH": 144,
    "Final Payment": 11,
    "First Report Comments": 129,
    "First Report Email": 78,
    "Full Address no Zip": 124,
    "Hours since created": 113,
    "Id": 0,
    "Ind O/S - Scott": 108,
    "Ind Paid - Scott": 109,
    "Indemnity Cost": 155,
    "Indemnity Payment": 136,
    "Initial Report Date": 8,
    "Initial Report Date Null": 100,
    "Initial Report to Approval": 96,
    "Initial Report to Date Closed": 98,
    "Initial report date filled": 89,
    "Insured": 106,
    "Insured - First Name": 21,
    "Insured - Last Name": 20,
    "Insured ID - Insuratrac": 116,
    "Last Activity Time": 6,
    "Manager Name": 34,
    "Mass uploaded info": 47,
    "Modified By": 75,
    "Modified Time": 5,
    "Modified the following": 16,
    "Nixon Cat Loss Tags": 161,
    "Nixon Old Claim Number": 146,
    "Nixon Processor": 127,
    "Nixon Processor Email": 128,
    "No Coverage Reason": 145,
    "Not PMA Kathy Corp Group": 148,
    "Not PMA Kathy Facility ID": 147,
    "O/C Stat": 105,
    "OPENCLAIMS": 151,
    "Open Claim Count": 154,
    "Open Claim Yes": 160,
    "PMA - Apartments Ceded Premiums": 153,
    "PMA - Storage Ceded Premiums": 152,
    "PMA-AIG": 140,
    "Paid": 50,
    "Paid Claim Count": 157,
    "Pending Approval": 131,
    "Pending Approval Hidden": 132,
    "Pending Approval Notes": 130,
    "Pending Payment": 64,
    "Phone Number": 35,
    "Policy Name": 104,
    "Premium Due": 37,
    "Premium Paid Thru": 24,
    "RCV Payment": 134,
    "Re-opened Claim": 58,
    "Reason Still Open": 38,
    "Reason for Denial": 57,
    "Reason for Denial Code": 45,
    "Reason for Denial Code is Null": 90,
    "Reason for denial is null": 91,
    "Reconciled - Nixon Check Register": 55,
    "Renter Liability": 119,
    "Reopened Claim Reference": 80,
    "Reserve - Claims & Adjustment": 51,
    "Reserve for Adjustment": 49,
    "Reviewed CXLD Facility Claim": 141,
    "Reviewed Double Check": 142,
    "Secondary Cause of Loss": 85,
    "Secondary Cause of Loss 3": 43,
    "Secondary Cause of Loss Code": 42,
    "Secondary Reason for Denial": 86,
    "Secondary Reason for Denial 3": 44,
    "Secondary Reason for Denial Code": 46,
    "Server_Update_ID": 87,
    "Stated Cause of Loss": 14,
    "Subgrogated Claim": 82,
    "Subrogated Claim Payment": 83,
    "Subrogated Payment Date": 84,
    "Subtract Month": 65,
    "TIV for Location": 107,
    "Timestamp Confirmation Sent": 123,
    "Total All": 52,
    "Total Claims": 54,
    "Total Open Claims": 53,
    "Total Value - Scott": 112,
    "Unit Number": 26,
    "Vermin Coverage": 48,
    "Zip Code": 25,
    "Zoho Claims Record Link": 94,
    "email address": 36,
    "zcrm_claimid": 114,
    "zcrm_company_id": 156,
    "zcrmid": 103,
    "zoho crm claim link": 159
}
    • 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_Notes": "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_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_Date_of_Claim": "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",
    "Description_of_Damage": "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",
    "Fields_Changed_By_Nixon": "string",
    "Filter___REVIEWED_CXLD_CLAIM": "string",
    "Filter___REVIEWED_STREET_OR_ID_MISMATCH": "string",
    "Final_Payment": "string",
    "First_Report_Comments": "string",
    "First_Report_Email": "string",
    "Full_Address_no_Zip": "string",
    "Hours_since_created": "string",
    "Id": "string",
    "Ind_O_S___Scott": "string",
    "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",
    "Payment": "string",
    "Pending_Approval": "string",
    "Pending_Approval_Hidden": "string",
    "Pending_Approval_Notes": "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",
    "Status": "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: 2229
    • schema_scan_id: 6250241
    • updated: 2023-08-14 12:03:05
    • created: 2023-08-14 11:57:33
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.storsmartzoho_storsmart_claims`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.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 , `Stated_Cause_of_Loss`  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 , `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_Notes`  string , `Description_of_Damage`  string , `First_Report_Email`  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 , `Fields_Changed_By_Nixon`  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`  string , `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_Doesn_t_Match`  string , `Nixon_Processor`  string , `Nixon_Processor_Email`  string , `First_Report_Comments`  string , `Pending_Approval_Notes`  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.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-14/1692032243'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.storsmartzoho_storsmart_claims"
]
    • hive_path: s3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-14/1692032243
    • id: 4697322
    • processed: 1
    • raw_data: 
      {
    "14 Day Letter Sent": 71,
    "14 Day Letter Yes": 99,
    "ADJ COSTS": 158,
    "AIG - Storage Ceded Premiums": 59,
    "ALE Payment": 135,
    "Additional Costs": 13,
    "Adjustment Cost": 12,
    "After 8-31-19": 125,
    "Approved By": 9,
    "Approved to Close": 101,
    "Bader Archive Claim ID": 133,
    "Bader Renter Liability Claim": 118,
    "Cause of Loss": 56,
    "Cause of Loss Code": 41,
    "Cause of Loss Code is Null": 93,
    "Cause of Loss is Null": 92,
    "Certificate Number": 61,
    "Claim Count  Descriptions": 121,
    "Claim Notes": 76,
    "Claim Number": 18,
    "Claim Re-opened Date": 79,
    "Claim Reserve Amount": 7,
    "Claim Status": 33,
    "Claim Type": 117,
    "Claim Types": 120,
    "Claims Name": 1,
    "Claims Owner Name": 3,
    "Claims Owner_1": 2,
    "Claims Paid 1": 97,
    "Combined old - New Claim Number": 149,
    "Confirm Complete": 70,
    "Confirmed and Sent": 39,
    "Corp Group": 66,
    "Corp Group Doesn't Match": 126,
    "Coverage End Date": 29,
    "Coverage Limit": 27,
    "Coverage Start Date": 28,
    "Created By": 74,
    "Created Time": 4,
    "Created to Approved": 102,
    "Created to Initial Report Date": 73,
    "DOC Count": 139,
    "Date Approved": 62,
    "Date Closed": 10,
    "Date Closed Null": 122,
    "Date ID Variable": 162,
    "Date of Claim": 23,
    "Date of Claim to Approval": 137,
    "Date of Loss": 22,
    "Days Since Approved": 63,
    "Days Since Confirmed": 67,
    "Days Since Created": 69,
    "Days Since First Report": 68,
    "Days to Close": 72,
    "Days to Close from DOC": 138,
    "Deductible Amount": 30,
    "Description of Damage": 77,
    "Email": 60,
    "Enrollment Method": 31,
    "Error Claim": 163,
    "Error Codes": 95,
    "Exclude Bader - Nixon LAE transition": 150,
    "Exp O/S - Scott": 111,
    "Exp Paid - Scott": 110,
    "Facility Address": 19,
    "Facility Address - Nixon": 81,
    "Facility City": 15,
    "Facility Name": 17,
    "Facility Name - Nixon": 40,
    "Facility Number": 115,
    "Facility State": 32,
    "Fields_Changed_By_Nixon": 88,
    "Filter - REVIEWED CXLD CLAIM": 143,
    "Filter - REVIEWED STREET OR ID MISMATCH": 144,
    "Final Payment": 11,
    "First Report Comments": 129,
    "First Report Email": 78,
    "Full Address no Zip": 124,
    "Hours since created": 113,
    "Id": 0,
    "Ind O/S - Scott": 108,
    "Ind Paid - Scott": 109,
    "Indemnity Cost": 155,
    "Indemnity Payment": 136,
    "Initial Report Date": 8,
    "Initial Report Date Null": 100,
    "Initial Report to Approval": 96,
    "Initial Report to Date Closed": 98,
    "Initial report date filled": 89,
    "Insured": 106,
    "Insured - First Name": 21,
    "Insured - Last Name": 20,
    "Insured ID - Insuratrac": 116,
    "Last Activity Time": 6,
    "Manager Name": 34,
    "Mass uploaded info": 47,
    "Modified By": 75,
    "Modified Time": 5,
    "Modified the following": 16,
    "Nixon Cat Loss Tags": 161,
    "Nixon Old Claim Number": 146,
    "Nixon Processor": 127,
    "Nixon Processor Email": 128,
    "No Coverage Reason": 145,
    "Not PMA Kathy Corp Group": 148,
    "Not PMA Kathy Facility ID": 147,
    "O/C Stat": 105,
    "OPENCLAIMS": 151,
    "Open Claim Count": 154,
    "Open Claim Yes": 160,
    "PMA - Apartments Ceded Premiums": 153,
    "PMA - Storage Ceded Premiums": 152,
    "PMA-AIG": 140,
    "Paid": 50,
    "Paid Claim Count": 157,
    "Pending Approval": 131,
    "Pending Approval Hidden": 132,
    "Pending Approval Notes": 130,
    "Pending Payment": 64,
    "Phone Number": 35,
    "Policy Name": 104,
    "Premium Due": 37,
    "Premium Paid Thru": 24,
    "RCV Payment": 134,
    "Re-opened Claim": 58,
    "Reason Still Open": 38,
    "Reason for Denial": 57,
    "Reason for Denial Code": 45,
    "Reason for Denial Code is Null": 90,
    "Reason for denial is null": 91,
    "Reconciled - Nixon Check Register": 55,
    "Renter Liability": 119,
    "Reopened Claim Reference": 80,
    "Reserve - Claims & Adjustment": 51,
    "Reserve for Adjustment": 49,
    "Reviewed CXLD Facility Claim": 141,
    "Reviewed Double Check": 142,
    "Secondary Cause of Loss": 85,
    "Secondary Cause of Loss 3": 43,
    "Secondary Cause of Loss Code": 42,
    "Secondary Reason for Denial": 86,
    "Secondary Reason for Denial 3": 44,
    "Secondary Reason for Denial Code": 46,
    "Server_Update_ID": 87,
    "Stated Cause of Loss": 14,
    "Subgrogated Claim": 82,
    "Subrogated Claim Payment": 83,
    "Subrogated Payment Date": 84,
    "Subtract Month": 65,
    "TIV for Location": 107,
    "Timestamp Confirmation Sent": 123,
    "Total All": 52,
    "Total Claims": 54,
    "Total Open Claims": 53,
    "Total Value - Scott": 112,
    "Unit Number": 26,
    "Vermin Coverage": 48,
    "Zip Code": 25,
    "Zoho Claims Record Link": 94,
    "email address": 36,
    "zcrm_claimid": 114,
    "zcrm_company_id": 156,
    "zcrmid": 103,
    "zoho crm claim link": 159
}
    • 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_Notes": "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_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_Date_of_Claim": "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",
    "Description_of_Damage": "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",
    "Fields_Changed_By_Nixon": "string",
    "Filter___REVIEWED_CXLD_CLAIM": "string",
    "Filter___REVIEWED_STREET_OR_ID_MISMATCH": "string",
    "Final_Payment": "string",
    "First_Report_Comments": "string",
    "First_Report_Email": "string",
    "Full_Address_no_Zip": "string",
    "Hours_since_created": "string",
    "Id": "string",
    "Ind_O_S___Scott": "string",
    "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",
    "Payment": "string",
    "Pending_Approval": "string",
    "Pending_Approval_Hidden": "string",
    "Pending_Approval_Notes": "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",
    "Status": "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: 2229
    • schema_scan_id: 6250227
    • updated: 2023-08-14 11:57:44
    • created: 2023-08-14 10:12:08
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.storsmartzoho_storsmart_claims`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.storsmartzoho_storsmart_claims`\n(\n `Facility_Number`  string , `Facility_Name___Nixon`  string , `Date_of_Date_of_Claim`  string , `Date_of_Loss`  string , `Date_Closed`  string , `Claims_Name`  string , `Claim_Number`  string , `Description_of_Damage`  string , `Status`  string , `Cause_of_Loss`  string , `Reason_for_Denial`  string , `Coverage_Limit`  string , `Payment`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-14/1692025910'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.storsmartzoho_storsmart_claims"
]
    • hive_path: s3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-14/1692025910
    • id: 4697319
    • processed: 1
    • raw_data: 
      {
    "Cause of Loss": 9,
    "Claim Number": 6,
    "Claims Name": 5,
    "Coverage Limit": 11,
    "Date Closed": 4,
    "Date of Date of Claim": 2,
    "Date of Loss": 3,
    "Description of Damage": 7,
    "Facility Name - Nixon": 1,
    "Facility Number": 0,
    "Payment": 12,
    "Reason for Denial": 10,
    "Status": 8
}
    • schema_attributes: 
      {
    "Cause_of_Loss": "string",
    "Claim_Number": "string",
    "Claims_Name": "string",
    "Coverage_Limit": "string",
    "Date_Closed": "string",
    "Date_of_Date_of_Claim": "string",
    "Date_of_Loss": "string",
    "Description_of_Damage": "string",
    "Facility_Name___Nixon": "string",
    "Facility_Number": "string",
    "Payment": "string",
    "Reason_for_Denial": "string",
    "Status": "string"
}
    • schema_name_id: 2229
    • schema_scan_id: 6250071
    • updated: 2023-08-14 10:12:20
Schema Scans: 7
Last at 2023-08-16 12:01:49
    • duration: 0:00:15.846011
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6251553
    • 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": "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": "string",
        "Id": "string",
        "Ind O/S - Scott": "string",
        "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 - 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",
        "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"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-dev",
        "hive_path": "s3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-16/1692205308",
        "key": "raw/storsmart_claims/2023-08-16/1692205308/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.storsmartzoho_storsmart_claims",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7851122794066805513,
        "service_name": "load-storsmart_claims",
        "span_id": 10689663003912043330,
        "trace_id": 7851122794066805513
    }
}
    • running: False
    • schema_name_id: 2229
    • start_time: 2023-08-16 12:01:49
    • success: True
    • trace_id: 7851122794066805513
    • duration: 0:00:15.950462
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6251533
    • 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",
        "Description of Damage": "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": "string",
        "Id": "string",
        "Ind O/S - Scott": "string",
        "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 - 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",
        "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"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-dev",
        "hive_path": "s3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-16/1692203489",
        "key": "raw/storsmart_claims/2023-08-16/1692203489/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.storsmartzoho_storsmart_claims",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10045652558981365123,
        "service_name": "load-storsmart_claims",
        "span_id": 5509383390129162934,
        "trace_id": 10045652558981365123
    }
}
    • running: False
    • schema_name_id: 2229
    • start_time: 2023-08-16 11:31:34
    • success: True
    • trace_id: 10045652558981365123
    • duration: 0:00:16.153038
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6250352
    • 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 Notes": "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",
        "Description of Damage": "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",
        "Fields_Changed_By_Nixon": "string",
        "Filter - REVIEWED CXLD CLAIM": "string",
        "Filter - REVIEWED STREET OR ID MISMATCH": "string",
        "Final Payment": "string",
        "First Report Comments": "string",
        "First Report Email": "string",
        "Full Address no Zip": "string",
        "Hours since created": "string",
        "Id": "string",
        "Ind O/S - Scott": "string",
        "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 - 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 Approval Notes": "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"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-dev",
        "hive_path": "s3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-14/1692045187",
        "key": "raw/storsmart_claims/2023-08-14/1692045187/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.storsmartzoho_storsmart_claims",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5686778158337348918,
        "service_name": "load-storsmart_claims",
        "span_id": 18151879466409969319,
        "trace_id": 5686778158337348918
    }
}
    • running: False
    • schema_name_id: 2229
    • start_time: 2023-08-14 15:33:32
    • success: True
    • trace_id: 5686778158337348918
    • duration: 0:00:15.911778
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6250341
    • 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 Notes": "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",
        "Description of Damage": "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",
        "Fields_Changed_By_Nixon": "string",
        "Filter - REVIEWED CXLD CLAIM": "string",
        "Filter - REVIEWED STREET OR ID MISMATCH": "string",
        "Final Payment": "string",
        "First Report Comments": "string",
        "First Report Email": "string",
        "Full Address no Zip": "string",
        "Hours since created": "string",
        "Id": "string",
        "Ind O/S - Scott": "string",
        "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 - 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 Approval Notes": "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"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-dev",
        "hive_path": "s3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-14/1692041489",
        "key": "raw/storsmart_claims/2023-08-14/1692041489/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.storsmartzoho_storsmart_claims",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11580978144201309849,
        "service_name": "load-storsmart_claims",
        "span_id": 9880553886405949353,
        "trace_id": 11580978144201309849
    }
}
    • running: False
    • schema_name_id: 2229
    • start_time: 2023-08-14 14:31:47
    • success: True
    • trace_id: 11580978144201309849
    • duration: 0:00:16.195643
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6250241
    • 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 Notes": "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",
        "Description of Damage": "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",
        "Fields_Changed_By_Nixon": "string",
        "Filter - REVIEWED CXLD CLAIM": "string",
        "Filter - REVIEWED STREET OR ID MISMATCH": "string",
        "Final Payment": "string",
        "First Report Comments": "string",
        "First Report Email": "string",
        "Full Address no Zip": "string",
        "Hours since created": "string",
        "Id": "string",
        "Ind O/S - Scott": "string",
        "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 - 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 Approval Notes": "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"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-dev",
        "hive_path": "s3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-14/1692032560",
        "key": "raw/storsmart_claims/2023-08-14/1692032560/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.storsmartzoho_storsmart_claims",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15978839457738529673,
        "service_name": "load-storsmart_claims",
        "span_id": 14735935870031578335,
        "trace_id": 15978839457738529673
    }
}
    • running: False
    • schema_name_id: 2229
    • start_time: 2023-08-14 12:02:49
    • success: True
    • trace_id: 15978839457738529673
    • duration: 0:00:16.218499
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6250227
    • 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 Notes": "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",
        "Description of Damage": "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",
        "Fields_Changed_By_Nixon": "string",
        "Filter - REVIEWED CXLD CLAIM": "string",
        "Filter - REVIEWED STREET OR ID MISMATCH": "string",
        "Final Payment": "string",
        "First Report Comments": "string",
        "First Report Email": "string",
        "Full Address no Zip": "string",
        "Hours since created": "string",
        "Id": "string",
        "Ind O/S - Scott": "string",
        "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 - 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 Approval Notes": "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"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-dev",
        "hive_path": "s3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-14/1692032243",
        "key": "raw/storsmart_claims/2023-08-14/1692032243/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.storsmartzoho_storsmart_claims",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15381548304401048855,
        "service_name": "load-storsmart_claims",
        "span_id": 14575274697975864907,
        "trace_id": 15381548304401048855
    }
}
    • running: False
    • schema_name_id: 2229
    • start_time: 2023-08-14 11:57:28
    • success: True
    • trace_id: 15381548304401048855
    • duration: 0:00:11.947175
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6250071
    • 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 Notes": "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",
        "Description of Damage": "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",
        "Fields_Changed_By_Nixon": "string",
        "Filter - REVIEWED CXLD CLAIM": "string",
        "Filter - REVIEWED STREET OR ID MISMATCH": "string",
        "Final Payment": "string",
        "First Report Comments": "string",
        "First Report Email": "string",
        "Full Address no Zip": "string",
        "Hours since created": "string",
        "Id": "string",
        "Ind O/S - Scott": "string",
        "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 - 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 Approval Notes": "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"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-dev",
        "hive_path": "s3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-14/1692025910",
        "key": "raw/storsmart_claims/2023-08-14/1692025910/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.storsmartzoho_storsmart_claims",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10092069817621261994,
        "service_name": "load-storsmart_claims",
        "span_id": 14615924376714959964,
        "trace_id": 10092069817621261994
    }
}
    • running: False
    • schema_name_id: 2229
    • start_time: 2023-08-14 10:12:08
    • success: True
    • trace_id: 10092069817621261994
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_Notes": "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_Doesn_t_Match": "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_Date_of_Claim": "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",
    "Description_of_Damage": "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",
    "Fields_Changed_By_Nixon": "string",
    "Filter___REVIEWED_CXLD_CLAIM": "string",
    "Filter___REVIEWED_STREET_OR_ID_MISMATCH": "string",
    "Final_Payment": "string",
    "First_Report_Comments": "string",
    "First_Report_Email": "string",
    "Full_Address_no_Zip": "string",
    "Hours_since_created": "string",
    "Id": "string",
    "Ind_O_S___Scott": "string",
    "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",
    "Payment": "string",
    "Pending_Approval": "string",
    "Pending_Approval_Hidden": "string",
    "Pending_Approval_Notes": "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",
    "Status": "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: 2023-08-16 12:01:54
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.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 , `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`  string , `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.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-16/1692205308'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.storsmartzoho_storsmart_claims`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.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-08-14 10:12:08",
        "disabled": false,
        "format": "raw",
        "id": 2229,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "storsmartzoho_storsmart_claims"
        },
        "type": "csv"
    },
    "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_Notes": "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_Doesn_t_Match": "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_Date_of_Claim": "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",
            "Description_of_Damage": "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",
            "Fields_Changed_By_Nixon": "string",
            "Filter___REVIEWED_CXLD_CLAIM": "string",
            "Filter___REVIEWED_STREET_OR_ID_MISMATCH": "string",
            "Final_Payment": "string",
            "First_Report_Comments": "string",
            "First_Report_Email": "string",
            "Full_Address_no_Zip": "string",
            "Hours_since_created": "string",
            "Id": "string",
            "Ind_O_S___Scott": "string",
            "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",
            "Payment": "string",
            "Pending_Approval": "string",
            "Pending_Approval_Hidden": "string",
            "Pending_Approval_Notes": "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",
            "Status": "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": "2023-08-16 12:01:54",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.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 , `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`  string , `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.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-dev/raw/storsmart_claims/2023-08-16/1692205308'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.storsmartzoho_storsmart_claims`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.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