Schema Info

Schema Name: sfdl_stage_csv.storsmartzoho_storsmart_claims
  • created: 2023-08-14 10:34:16
  • disabled: False
  • format: raw
  • id: 2074
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_stage_csv",
    "table": "storsmartzoho_storsmart_claims"
}
  • type: csv
Schema Versions: 3
    • created: 2023-10-04 07:01:21
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_claims`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `Stated_Cause_of_Loss`  string , `Reason_for_Denial`  string , `Re_opened_Claim`  string , `AIG___Storage_Ceded_Premiums`  string , `Email`  string , `Certificate_Number`  string , `Date_Approved`  string , `Days_Since_Approved`  string , `Pending_Payment`  string , `Subtract_Month`  string , `Corp_Group`  string , `Days_Since_Confirmed`  string , `Days_Since_First_Report`  string , `Days_Since_Created`  string , `Confirm_Complete`  string , `14_Day_Letter_Sent`  string , `Days_to_Close`  string , `Created_to_Initial_Report_Date`  string , `Created_By`  string , `Modified_By`  string , `Claim_Re_opened_Date`  string , `Reopened_Claim_Reference`  string , `Facility_Address___Nixon`  string , `Subgrogated_Claim`  string , `Subrogated_Claim_Payment`  string , `Subrogated_Payment_Date`  string , `Secondary_Cause_of_Loss`  string , `Secondary_Reason_for_Denial`  string , `Server_Update_ID`  string , `Initial_report_date_filled`  string , `Reason_for_Denial_Code_is_Null`  string , `Reason_for_denial_is_null`  string , `Cause_of_Loss_is_Null`  string , `Cause_of_Loss_Code_is_Null`  string , `Zoho_Claims_Record_Link`  string , `Error_Codes`  string , `Initial_Report_to_Approval`  string , `Claims_Paid_1`  string , `Initial_Report_to_Date_Closed`  string , `14_Day_Letter_Yes`  string , `Initial_Report_Date_Null`  string , `Approved_to_Close`  string , `Created_to_Approved`  string , `zcrmid`  string , `Policy_Name`  string , `O_C_Stat`  string , `Insured`  string , `TIV_for_Location`  string , `Ind_O_S___Scott`  string , `Ind_Paid___Scott`  string , `Exp_Paid___Scott`  string , `Exp_O_S___Scott`  string , `Total_Value___Scott`  string , `Hours_since_created`  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-stage/raw/storsmart_claims/2023-10-04/1696420869'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_claims"
]
    • hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_claims/2023-10-04/1696420869
    • id: 605399
    • processed: 1
    • raw_data: 
      {
    "14 Day Letter Sent": 71,
    "14 Day Letter Yes": 95,
    "ADJ COSTS": 152,
    "AIG - Storage Ceded Premiums": 59,
    "ALE Payment": 129,
    "Additional Costs": 13,
    "Adjustment Cost": 12,
    "After 8-31-19": 121,
    "Approved By": 9,
    "Approved to Close": 97,
    "Bader Archive Claim ID": 127,
    "Bader Renter Liability Claim": 114,
    "Cause of Loss": 55,
    "Cause of Loss Code": 40,
    "Cause of Loss Code is Null": 89,
    "Cause of Loss is Null": 88,
    "Certificate Number": 61,
    "Claim Count  Descriptions": 117,
    "Claim Number": 17,
    "Claim Re-opened Date": 76,
    "Claim Reserve Amount": 7,
    "Claim Status": 32,
    "Claim Type": 113,
    "Claim Types": 116,
    "Claims Name": 1,
    "Claims Owner Name": 3,
    "Claims Owner_1": 2,
    "Claims Paid 1": 93,
    "Combined old - New Claim Number": 143,
    "Confirm Complete": 70,
    "Confirmed and Sent": 38,
    "Corp Group": 66,
    "Corp Group Doesnt Match": 122,
    "Coverage End Date": 28,
    "Coverage Limit": 26,
    "Coverage Start Date": 27,
    "Created By": 74,
    "Created Time": 4,
    "Created to Approved": 98,
    "Created to Initial Report Date": 73,
    "DOC Count": 133,
    "Date Approved": 62,
    "Date Closed": 10,
    "Date Closed Null": 118,
    "Date ID Variable": 156,
    "Date of Claim": 22,
    "Date of Claim to Approval": 131,
    "Date of Loss": 21,
    "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": 132,
    "Deductible Amount": 29,
    "Email": 60,
    "Enrollment Method": 30,
    "Error Claim": 157,
    "Error Codes": 91,
    "Exclude Bader - Nixon LAE transition": 144,
    "Exp O/S - Scott": 107,
    "Exp Paid - Scott": 106,
    "Facility Address": 18,
    "Facility Address - Nixon": 78,
    "Facility City": 14,
    "Facility Name": 16,
    "Facility Name - Nixon": 39,
    "Facility Number": 111,
    "Facility State": 31,
    "Filter - REVIEWED CXLD CLAIM": 137,
    "Filter - REVIEWED STREET OR ID MISMATCH": 138,
    "Final Payment": 11,
    "Full Address no Zip": 120,
    "Hours since created": 109,
    "Id": 0,
    "Ind O/S - Scott": 104,
    "Ind Paid - Scott": 105,
    "Indemnity Cost": 149,
    "Indemnity Payment": 130,
    "Initial Report Date": 8,
    "Initial Report Date Null": 96,
    "Initial Report to Approval": 92,
    "Initial Report to Date Closed": 94,
    "Initial report date filled": 85,
    "Insured": 102,
    "Insured - First Name": 20,
    "Insured - Last Name": 19,
    "Insured ID - Insuratrac": 112,
    "Last Activity Time": 6,
    "Manager Name": 33,
    "Mass uploaded info": 46,
    "Modified By": 75,
    "Modified Time": 5,
    "Modified the following": 15,
    "Nixon Cat Loss Tags": 155,
    "Nixon Old Claim Number": 140,
    "Nixon Processor": 123,
    "Nixon Processor Email": 124,
    "No Coverage Reason": 139,
    "Not PMA Kathy Corp Group": 142,
    "Not PMA Kathy Facility ID": 141,
    "O/C Stat": 101,
    "OPENCLAIMS": 145,
    "Open Claim Count": 148,
    "Open Claim Yes": 154,
    "PMA - Apartments Ceded Premiums": 147,
    "PMA - Storage Ceded Premiums": 146,
    "PMA-AIG": 134,
    "Paid": 49,
    "Paid Claim Count": 151,
    "Pending Approval": 125,
    "Pending Approval Hidden": 126,
    "Pending Payment": 64,
    "Phone Number": 34,
    "Policy Name": 100,
    "Premium Due": 36,
    "Premium Paid Thru": 23,
    "RCV Payment": 128,
    "Re-opened Claim": 58,
    "Reason Still Open": 37,
    "Reason for Denial": 57,
    "Reason for Denial Code": 44,
    "Reason for Denial Code is Null": 86,
    "Reason for denial is null": 87,
    "Reconciled - Nixon Check Register": 54,
    "Renter Liability": 115,
    "Reopened Claim Reference": 77,
    "Reserve - Claims & Adjustment": 50,
    "Reserve for Adjustment": 48,
    "Reviewed CXLD Facility Claim": 135,
    "Reviewed Double Check": 136,
    "Secondary Cause of Loss": 82,
    "Secondary Cause of Loss 3": 42,
    "Secondary Cause of Loss Code": 41,
    "Secondary Reason for Denial": 83,
    "Secondary Reason for Denial 3": 43,
    "Secondary Reason for Denial Code": 45,
    "Server_Update_ID": 84,
    "Stated Cause of Loss": 56,
    "Subgrogated Claim": 79,
    "Subrogated Claim Payment": 80,
    "Subrogated Payment Date": 81,
    "Subtract Month": 65,
    "TIV for Location": 103,
    "Timestamp Confirmation Sent": 119,
    "Total All": 51,
    "Total Claims": 53,
    "Total Open Claims": 52,
    "Total Value - Scott": 108,
    "Unit Number": 25,
    "Vermin Coverage": 47,
    "Zip Code": 24,
    "Zoho Claims Record Link": 90,
    "email address": 35,
    "zcrm_claimid": 110,
    "zcrm_company_id": 150,
    "zcrmid": 99,
    "zoho crm claim link": 153
}
    • schema_attributes: 
      {
    "14_Day_Letter_Sent": "string",
    "14_Day_Letter_Yes": "string",
    "ADJ_COSTS": "string",
    "AIG___Storage_Ceded_Premiums": "string",
    "ALE_Payment": "string",
    "Additional_Costs": "string",
    "Adjustment_Cost": "string",
    "After_8_31_19": "string",
    "Approved_By": "string",
    "Approved_to_Close": "string",
    "Bader_Archive_Claim_ID": "string",
    "Bader_Renter_Liability_Claim": "string",
    "Cause_of_Loss": "string",
    "Cause_of_Loss_Code": "string",
    "Cause_of_Loss_Code_is_Null": "string",
    "Cause_of_Loss_is_Null": "string",
    "Certificate_Number": "string",
    "Claim_Count__Descriptions": "string",
    "Claim_Number": "string",
    "Claim_Re_opened_Date": "string",
    "Claim_Reserve_Amount": "string",
    "Claim_Status": "string",
    "Claim_Type": "string",
    "Claim_Types": "string",
    "Claims_Name": "string",
    "Claims_Owner_1": "string",
    "Claims_Owner_Name": "string",
    "Claims_Paid_1": "string",
    "Combined_old___New_Claim_Number": "string",
    "Confirm_Complete": "string",
    "Confirmed_and_Sent": "string",
    "Corp_Group": "string",
    "Corp_Group_Doesnt_Match": "string",
    "Coverage_End_Date": "string",
    "Coverage_Limit": "string",
    "Coverage_Start_Date": "string",
    "Created_By": "string",
    "Created_Time": "string",
    "Created_to_Approved": "string",
    "Created_to_Initial_Report_Date": "string",
    "DOC_Count": "string",
    "Date_Approved": "string",
    "Date_Closed": "string",
    "Date_Closed_Null": "string",
    "Date_ID_Variable": "string",
    "Date_of_Claim": "string",
    "Date_of_Claim_to_Approval": "string",
    "Date_of_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",
    "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_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_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: 2074
    • schema_scan_id: 5225093
    • updated: 2023-10-04 07:01:32
    • created: 2023-10-03 07:01:11
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_claims`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `Stated_Cause_of_Loss`  string , `Reason_for_Denial`  string , `Re_opened_Claim`  string , `AIG___Storage_Ceded_Premiums`  string , `Email`  string , `Certificate_Number`  string , `Date_Approved`  string , `Days_Since_Approved`  string , `Pending_Payment`  string , `Subtract_Month`  string , `Corp_Group`  string , `Days_Since_Confirmed`  string , `Days_Since_First_Report`  string , `Days_Since_Created`  string , `Confirm_Complete`  string , `14_Day_Letter_Sent`  string , `Days_to_Close`  string , `Created_to_Initial_Report_Date`  string , `Created_By`  string , `Modified_By`  string , `Claim_Re_opened_Date`  string , `Reopened_Claim_Reference`  string , `Facility_Address___Nixon`  string , `Subgrogated_Claim`  string , `Subrogated_Claim_Payment`  string , `Subrogated_Payment_Date`  string , `Secondary_Cause_of_Loss`  string , `Secondary_Reason_for_Denial`  string , `Server_Update_ID`  string , `Initial_report_date_filled`  string , `Reason_for_Denial_Code_is_Null`  string , `Reason_for_denial_is_null`  string , `Cause_of_Loss_is_Null`  string , `Cause_of_Loss_Code_is_Null`  string , `Zoho_Claims_Record_Link`  string , `Error_Codes`  string , `Initial_Report_to_Approval`  string , `Claims_Paid_1`  string , `Initial_Report_to_Date_Closed`  string , `14_Day_Letter_Yes`  string , `Initial_Report_Date_Null`  string , `Approved_to_Close`  string , `Created_to_Approved`  string , `zcrmid`  string , `Policy_Name`  string , `O_C_Stat`  string , `Insured`  string , `TIV_for_Location`  string , `Ind_O_S___Scott`  string , `Ind_Paid___Scott`  string , `Exp_Paid___Scott`  string , `Exp_O_S___Scott`  string , `Total_Value___Scott`  string , `Hours_since_created`  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-stage/raw/storsmart_claims/2023-10-03/1696334464'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_claims"
]
    • hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_claims/2023-10-03/1696334464
    • id: 604926
    • processed: 1
    • raw_data: 
      {
    "14 Day Letter Sent": 71,
    "14 Day Letter Yes": 95,
    "ADJ COSTS": 152,
    "AIG - Storage Ceded Premiums": 59,
    "ALE Payment": 129,
    "Additional Costs": 13,
    "Adjustment Cost": 12,
    "After 8-31-19": 121,
    "Approved By": 9,
    "Approved to Close": 97,
    "Bader Archive Claim ID": 127,
    "Bader Renter Liability Claim": 114,
    "Cause of Loss": 55,
    "Cause of Loss Code": 40,
    "Cause of Loss Code is Null": 89,
    "Cause of Loss is Null": 88,
    "Certificate Number": 61,
    "Claim Count  Descriptions": 117,
    "Claim Number": 17,
    "Claim Re-opened Date": 76,
    "Claim Reserve Amount": 7,
    "Claim Status": 32,
    "Claim Type": 113,
    "Claim Types": 116,
    "Claims Name": 1,
    "Claims Owner Name": 3,
    "Claims Owner_1": 2,
    "Claims Paid 1": 93,
    "Combined old - New Claim Number": 143,
    "Confirm Complete": 70,
    "Confirmed and Sent": 38,
    "Corp Group": 66,
    "Corp Group Doesnt Match": 122,
    "Coverage End Date": 28,
    "Coverage Limit": 26,
    "Coverage Start Date": 27,
    "Created By": 74,
    "Created Time": 4,
    "Created to Approved": 98,
    "Created to Initial Report Date": 73,
    "DOC Count": 133,
    "Date Approved": 62,
    "Date Closed": 10,
    "Date Closed Null": 118,
    "Date ID Variable": 156,
    "Date of Claim": 22,
    "Date of Claim to Approval": 131,
    "Date of Loss": 21,
    "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": 132,
    "Deductible Amount": 29,
    "Email": 60,
    "Enrollment Method": 30,
    "Error Claim": 157,
    "Error Codes": 91,
    "Exclude Bader - Nixon LAE transition": 144,
    "Exp O/S - Scott": 107,
    "Exp Paid - Scott": 106,
    "Facility Address": 18,
    "Facility Address - Nixon": 78,
    "Facility City": 14,
    "Facility Name": 16,
    "Facility Name - Nixon": 39,
    "Facility Number": 111,
    "Facility State": 31,
    "Filter - REVIEWED CXLD CLAIM": 137,
    "Filter - REVIEWED STREET OR ID MISMATCH": 138,
    "Final Payment": 11,
    "Full Address no Zip": 120,
    "Hours since created": 109,
    "Id": 0,
    "Ind O/S - Scott": 104,
    "Ind Paid - Scott": 105,
    "Indemnity Cost": 149,
    "Indemnity Payment": 130,
    "Initial Report Date": 8,
    "Initial Report Date Null": 96,
    "Initial Report to Approval": 92,
    "Initial Report to Date Closed": 94,
    "Initial report date filled": 85,
    "Insured": 102,
    "Insured - First Name": 20,
    "Insured - Last Name": 19,
    "Insured ID - Insuratrac": 112,
    "Last Activity Time": 6,
    "Manager Name": 33,
    "Mass uploaded info": 46,
    "Modified By": 75,
    "Modified Time": 5,
    "Modified the following": 15,
    "Nixon Cat Loss Tags": 155,
    "Nixon Old Claim Number": 140,
    "Nixon Processor": 123,
    "Nixon Processor Email": 124,
    "No Coverage Reason": 139,
    "Not PMA Kathy Corp Group": 142,
    "Not PMA Kathy Facility ID": 141,
    "O/C Stat": 101,
    "OPENCLAIMS": 145,
    "Open Claim Count": 148,
    "Open Claim Yes": 154,
    "PMA - Apartments Ceded Premiums": 147,
    "PMA - Storage Ceded Premiums": 146,
    "PMA-AIG": 134,
    "Paid": 49,
    "Paid Claim Count": 151,
    "Pending Approval": 125,
    "Pending Approval Hidden": 126,
    "Pending Payment": 64,
    "Phone Number": 34,
    "Policy Name": 100,
    "Premium Due": 36,
    "Premium Paid Thru": 23,
    "RCV Payment": 128,
    "Re-opened Claim": 58,
    "Reason Still Open": 37,
    "Reason for Denial": 57,
    "Reason for Denial Code": 44,
    "Reason for Denial Code is Null": 86,
    "Reason for denial is null": 87,
    "Reconciled - Nixon Check Register": 54,
    "Renter Liability": 115,
    "Reopened Claim Reference": 77,
    "Reserve - Claims & Adjustment": 50,
    "Reserve for Adjustment": 48,
    "Reviewed CXLD Facility Claim": 135,
    "Reviewed Double Check": 136,
    "Secondary Cause of Loss": 82,
    "Secondary Cause of Loss 3": 42,
    "Secondary Cause of Loss Code": 41,
    "Secondary Reason for Denial": 83,
    "Secondary Reason for Denial 3": 43,
    "Secondary Reason for Denial Code": 45,
    "Server_Update_ID": 84,
    "Stated Cause of Loss": 56,
    "Subgrogated Claim": 79,
    "Subrogated Claim Payment": 80,
    "Subrogated Payment Date": 81,
    "Subtract Month": 65,
    "TIV for Location": 103,
    "Timestamp Confirmation Sent": 119,
    "Total All": 51,
    "Total Claims": 53,
    "Total Open Claims": 52,
    "Total Value - Scott": 108,
    "Unit Number": 25,
    "Vermin Coverage": 47,
    "Zip Code": 24,
    "Zoho Claims Record Link": 90,
    "email address": 35,
    "zcrm_claimid": 110,
    "zcrm_company_id": 150,
    "zcrmid": 99,
    "zoho crm claim link": 153
}
    • schema_attributes: 
      {
    "14_Day_Letter_Sent": "string",
    "14_Day_Letter_Yes": "string",
    "ADJ_COSTS": "string",
    "AIG___Storage_Ceded_Premiums": "string",
    "ALE_Payment": "string",
    "Additional_Costs": "string",
    "Adjustment_Cost": "string",
    "After_8_31_19": "string",
    "Approved_By": "string",
    "Approved_to_Close": "string",
    "Bader_Archive_Claim_ID": "string",
    "Bader_Renter_Liability_Claim": "string",
    "Cause_of_Loss": "string",
    "Cause_of_Loss_Code": "string",
    "Cause_of_Loss_Code_is_Null": "string",
    "Cause_of_Loss_is_Null": "string",
    "Certificate_Number": "string",
    "Claim_Count__Descriptions": "string",
    "Claim_Number": "string",
    "Claim_Re_opened_Date": "string",
    "Claim_Reserve_Amount": "string",
    "Claim_Status": "string",
    "Claim_Type": "string",
    "Claim_Types": "string",
    "Claims_Name": "string",
    "Claims_Owner_1": "string",
    "Claims_Owner_Name": "string",
    "Claims_Paid_1": "string",
    "Combined_old___New_Claim_Number": "string",
    "Confirm_Complete": "string",
    "Confirmed_and_Sent": "string",
    "Corp_Group": "string",
    "Corp_Group_Doesnt_Match": "string",
    "Coverage_End_Date": "string",
    "Coverage_Limit": "string",
    "Coverage_Start_Date": "string",
    "Created_By": "string",
    "Created_Time": "string",
    "Created_to_Approved": "string",
    "Created_to_Initial_Report_Date": "string",
    "DOC_Count": "string",
    "Date_Approved": "string",
    "Date_Closed": "string",
    "Date_Closed_Null": "string",
    "Date_ID_Variable": "string",
    "Date_of_Claim": "string",
    "Date_of_Claim_to_Approval": "string",
    "Date_of_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",
    "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_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_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: 2074
    • schema_scan_id: 5222922
    • updated: 2023-10-03 07:01:22
    • created: 2023-10-02 07:00:55
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_claims`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `Stated_Cause_of_Loss`  string , `Reason_for_Denial`  string , `Re_opened_Claim`  string , `AIG___Storage_Ceded_Premiums`  string , `Email`  string , `Certificate_Number`  string , `Date_Approved`  string , `Days_Since_Approved`  string , `Pending_Payment`  string , `Subtract_Month`  string , `Corp_Group`  string , `Days_Since_Confirmed`  string , `Days_Since_First_Report`  string , `Days_Since_Created`  string , `Confirm_Complete`  string , `14_Day_Letter_Sent`  string , `Days_to_Close`  string , `Created_to_Initial_Report_Date`  string , `Created_By`  string , `Modified_By`  string , `Claim_Re_opened_Date`  string , `Reopened_Claim_Reference`  string , `Facility_Address___Nixon`  string , `Subgrogated_Claim`  string , `Subrogated_Claim_Payment`  string , `Subrogated_Payment_Date`  string , `Secondary_Cause_of_Loss`  string , `Secondary_Reason_for_Denial`  string , `Server_Update_ID`  string , `Initial_report_date_filled`  string , `Reason_for_Denial_Code_is_Null`  string , `Reason_for_denial_is_null`  string , `Cause_of_Loss_is_Null`  string , `Cause_of_Loss_Code_is_Null`  string , `Zoho_Claims_Record_Link`  string , `Error_Codes`  string , `Initial_Report_to_Approval`  string , `Claims_Paid_1`  string , `Initial_Report_to_Date_Closed`  string , `14_Day_Letter_Yes`  string , `Initial_Report_Date_Null`  string , `Approved_to_Close`  string , `Created_to_Approved`  string , `zcrmid`  string , `Policy_Name`  string , `O_C_Stat`  string , `Insured`  string , `TIV_for_Location`  string , `Ind_O_S___Scott`  string , `Ind_Paid___Scott`  string , `Exp_Paid___Scott`  string , `Exp_O_S___Scott`  string , `Total_Value___Scott`  string , `Hours_since_created`  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-stage/raw/storsmart_claims/2023-10-02/1696248049'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_claims"
]
    • hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_claims/2023-10-02/1696248049
    • id: 604451
    • processed: 1
    • raw_data: 
      {
    "14 Day Letter Sent": 71,
    "14 Day Letter Yes": 95,
    "ADJ COSTS": 152,
    "AIG - Storage Ceded Premiums": 59,
    "ALE Payment": 129,
    "Additional Costs": 13,
    "Adjustment Cost": 12,
    "After 8-31-19": 121,
    "Approved By": 9,
    "Approved to Close": 97,
    "Bader Archive Claim ID": 127,
    "Bader Renter Liability Claim": 114,
    "Cause of Loss": 55,
    "Cause of Loss Code": 40,
    "Cause of Loss Code is Null": 89,
    "Cause of Loss is Null": 88,
    "Certificate Number": 61,
    "Claim Count  Descriptions": 117,
    "Claim Number": 17,
    "Claim Re-opened Date": 76,
    "Claim Reserve Amount": 7,
    "Claim Status": 32,
    "Claim Type": 113,
    "Claim Types": 116,
    "Claims Name": 1,
    "Claims Owner Name": 3,
    "Claims Owner_1": 2,
    "Claims Paid 1": 93,
    "Combined old - New Claim Number": 143,
    "Confirm Complete": 70,
    "Confirmed and Sent": 38,
    "Corp Group": 66,
    "Corp Group Doesnt Match": 122,
    "Coverage End Date": 28,
    "Coverage Limit": 26,
    "Coverage Start Date": 27,
    "Created By": 74,
    "Created Time": 4,
    "Created to Approved": 98,
    "Created to Initial Report Date": 73,
    "DOC Count": 133,
    "Date Approved": 62,
    "Date Closed": 10,
    "Date Closed Null": 118,
    "Date ID Variable": 156,
    "Date of Claim": 22,
    "Date of Claim to Approval": 131,
    "Date of Loss": 21,
    "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": 132,
    "Deductible Amount": 29,
    "Email": 60,
    "Enrollment Method": 30,
    "Error Claim": 157,
    "Error Codes": 91,
    "Exclude Bader - Nixon LAE transition": 144,
    "Exp O/S - Scott": 107,
    "Exp Paid - Scott": 106,
    "Facility Address": 18,
    "Facility Address - Nixon": 78,
    "Facility City": 14,
    "Facility Name": 16,
    "Facility Name - Nixon": 39,
    "Facility Number": 111,
    "Facility State": 31,
    "Filter - REVIEWED CXLD CLAIM": 137,
    "Filter - REVIEWED STREET OR ID MISMATCH": 138,
    "Final Payment": 11,
    "Full Address no Zip": 120,
    "Hours since created": 109,
    "Id": 0,
    "Ind O/S - Scott": 104,
    "Ind Paid - Scott": 105,
    "Indemnity Cost": 149,
    "Indemnity Payment": 130,
    "Initial Report Date": 8,
    "Initial Report Date Null": 96,
    "Initial Report to Approval": 92,
    "Initial Report to Date Closed": 94,
    "Initial report date filled": 85,
    "Insured": 102,
    "Insured - First Name": 20,
    "Insured - Last Name": 19,
    "Insured ID - Insuratrac": 112,
    "Last Activity Time": 6,
    "Manager Name": 33,
    "Mass uploaded info": 46,
    "Modified By": 75,
    "Modified Time": 5,
    "Modified the following": 15,
    "Nixon Cat Loss Tags": 155,
    "Nixon Old Claim Number": 140,
    "Nixon Processor": 123,
    "Nixon Processor Email": 124,
    "No Coverage Reason": 139,
    "Not PMA Kathy Corp Group": 142,
    "Not PMA Kathy Facility ID": 141,
    "O/C Stat": 101,
    "OPENCLAIMS": 145,
    "Open Claim Count": 148,
    "Open Claim Yes": 154,
    "PMA - Apartments Ceded Premiums": 147,
    "PMA - Storage Ceded Premiums": 146,
    "PMA-AIG": 134,
    "Paid": 49,
    "Paid Claim Count": 151,
    "Pending Approval": 125,
    "Pending Approval Hidden": 126,
    "Pending Payment": 64,
    "Phone Number": 34,
    "Policy Name": 100,
    "Premium Due": 36,
    "Premium Paid Thru": 23,
    "RCV Payment": 128,
    "Re-opened Claim": 58,
    "Reason Still Open": 37,
    "Reason for Denial": 57,
    "Reason for Denial Code": 44,
    "Reason for Denial Code is Null": 86,
    "Reason for denial is null": 87,
    "Reconciled - Nixon Check Register": 54,
    "Renter Liability": 115,
    "Reopened Claim Reference": 77,
    "Reserve - Claims & Adjustment": 50,
    "Reserve for Adjustment": 48,
    "Reviewed CXLD Facility Claim": 135,
    "Reviewed Double Check": 136,
    "Secondary Cause of Loss": 82,
    "Secondary Cause of Loss 3": 42,
    "Secondary Cause of Loss Code": 41,
    "Secondary Reason for Denial": 83,
    "Secondary Reason for Denial 3": 43,
    "Secondary Reason for Denial Code": 45,
    "Server_Update_ID": 84,
    "Stated Cause of Loss": 56,
    "Subgrogated Claim": 79,
    "Subrogated Claim Payment": 80,
    "Subrogated Payment Date": 81,
    "Subtract Month": 65,
    "TIV for Location": 103,
    "Timestamp Confirmation Sent": 119,
    "Total All": 51,
    "Total Claims": 53,
    "Total Open Claims": 52,
    "Total Value - Scott": 108,
    "Unit Number": 25,
    "Vermin Coverage": 47,
    "Zip Code": 24,
    "Zoho Claims Record Link": 90,
    "email address": 35,
    "zcrm_claimid": 110,
    "zcrm_company_id": 150,
    "zcrmid": 99,
    "zoho crm claim link": 153
}
    • schema_attributes: 
      {
    "14_Day_Letter_Sent": "string",
    "14_Day_Letter_Yes": "string",
    "ADJ_COSTS": "string",
    "AIG___Storage_Ceded_Premiums": "string",
    "ALE_Payment": "string",
    "Additional_Costs": "string",
    "Adjustment_Cost": "string",
    "After_8_31_19": "string",
    "Approved_By": "string",
    "Approved_to_Close": "string",
    "Bader_Archive_Claim_ID": "string",
    "Bader_Renter_Liability_Claim": "string",
    "Cause_of_Loss": "string",
    "Cause_of_Loss_Code": "string",
    "Cause_of_Loss_Code_is_Null": "string",
    "Cause_of_Loss_is_Null": "string",
    "Certificate_Number": "string",
    "Claim_Count__Descriptions": "string",
    "Claim_Number": "string",
    "Claim_Re_opened_Date": "string",
    "Claim_Reserve_Amount": "string",
    "Claim_Status": "string",
    "Claim_Type": "string",
    "Claim_Types": "string",
    "Claims_Name": "string",
    "Claims_Owner_1": "string",
    "Claims_Owner_Name": "string",
    "Claims_Paid_1": "string",
    "Combined_old___New_Claim_Number": "string",
    "Confirm_Complete": "string",
    "Confirmed_and_Sent": "string",
    "Corp_Group": "string",
    "Corp_Group_Doesnt_Match": "string",
    "Coverage_End_Date": "string",
    "Coverage_Limit": "string",
    "Coverage_Start_Date": "string",
    "Created_By": "string",
    "Created_Time": "string",
    "Created_to_Approved": "string",
    "Created_to_Initial_Report_Date": "string",
    "DOC_Count": "string",
    "Date_Approved": "string",
    "Date_Closed": "string",
    "Date_Closed_Null": "string",
    "Date_ID_Variable": "string",
    "Date_of_Claim": "string",
    "Date_of_Claim_to_Approval": "string",
    "Date_of_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",
    "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_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_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: 2074
    • schema_scan_id: 5220323
    • updated: 2023-10-02 07:01:06
Schema Scans: 3
Last at 2023-10-04 07:01:16
    • duration: 0:00:16.050936
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 5225093
    • 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-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_claims/2023-10-04/1696420869",
        "key": "raw/storsmart_claims/2023-10-04/1696420869/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_claims",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 884520249871665461,
        "service_name": "load-storsmart_claims",
        "span_id": 314417973132194798,
        "trace_id": 884520249871665461
    }
}
    • running: False
    • schema_name_id: 2074
    • start_time: 2023-10-04 07:01:16
    • success: True
    • trace_id: 884520249871665461
    • duration: 0:00:16.276522
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 5222922
    • 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-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_claims/2023-10-03/1696334464",
        "key": "raw/storsmart_claims/2023-10-03/1696334464/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_claims",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17557782531134784353,
        "service_name": "load-storsmart_claims",
        "span_id": 15234825162405299254,
        "trace_id": 17557782531134784353
    }
}
    • running: False
    • schema_name_id: 2074
    • start_time: 2023-10-03 07:01:06
    • success: True
    • trace_id: 17557782531134784353
    • duration: 0:00:15.648793
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 5220323
    • 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-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_claims/2023-10-02/1696248049",
        "key": "raw/storsmart_claims/2023-10-02/1696248049/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_claims",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7703380710698303292,
        "service_name": "load-storsmart_claims",
        "span_id": 14199278696505321078,
        "trace_id": 7703380710698303292
    }
}
    • running: False
    • schema_name_id: 2074
    • start_time: 2023-10-02 07:00:50
    • success: True
    • trace_id: 7703380710698303292
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "14_Day_Letter_Sent": "string",
    "14_Day_Letter_Yes": "string",
    "ADJ_COSTS": "string",
    "AIG___Storage_Ceded_Premiums": "string",
    "ALE_Payment": "string",
    "Additional_Costs": "string",
    "Adjustment_Cost": "string",
    "After_8_31_19": "string",
    "Approved_By": "string",
    "Approved_to_Close": "string",
    "Bader_Archive_Claim_ID": "string",
    "Bader_Renter_Liability_Claim": "string",
    "Cause_of_Loss": "string",
    "Cause_of_Loss_Code": "string",
    "Cause_of_Loss_Code_is_Null": "string",
    "Cause_of_Loss_is_Null": "string",
    "Certificate_Number": "string",
    "Claim_Count__Descriptions": "string",
    "Claim_Number": "string",
    "Claim_Re_opened_Date": "string",
    "Claim_Reserve_Amount": "string",
    "Claim_Status": "string",
    "Claim_Type": "string",
    "Claim_Types": "string",
    "Claims_Name": "string",
    "Claims_Owner_1": "string",
    "Claims_Owner_Name": "string",
    "Claims_Paid_1": "string",
    "Combined_old___New_Claim_Number": "string",
    "Confirm_Complete": "string",
    "Confirmed_and_Sent": "string",
    "Corp_Group": "string",
    "Corp_Group_Doesnt_Match": "string",
    "Coverage_End_Date": "string",
    "Coverage_Limit": "string",
    "Coverage_Start_Date": "string",
    "Created_By": "string",
    "Created_Time": "string",
    "Created_to_Approved": "string",
    "Created_to_Initial_Report_Date": "string",
    "DOC_Count": "string",
    "Date_Approved": "string",
    "Date_Closed": "string",
    "Date_Closed_Null": "string",
    "Date_ID_Variable": "string",
    "Date_of_Claim": "string",
    "Date_of_Claim_to_Approval": "string",
    "Date_of_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",
    "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_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_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-10-04 07:01:21
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `Stated_Cause_of_Loss`  string , `Reason_for_Denial`  string , `Re_opened_Claim`  string , `AIG___Storage_Ceded_Premiums`  string , `Email`  string , `Certificate_Number`  string , `Date_Approved`  string , `Days_Since_Approved`  string , `Pending_Payment`  string , `Subtract_Month`  string , `Corp_Group`  string , `Days_Since_Confirmed`  string , `Days_Since_First_Report`  string , `Days_Since_Created`  string , `Confirm_Complete`  string , `14_Day_Letter_Sent`  string , `Days_to_Close`  string , `Created_to_Initial_Report_Date`  string , `Created_By`  string , `Modified_By`  string , `Claim_Re_opened_Date`  string , `Reopened_Claim_Reference`  string , `Facility_Address___Nixon`  string , `Subgrogated_Claim`  string , `Subrogated_Claim_Payment`  string , `Subrogated_Payment_Date`  string , `Secondary_Cause_of_Loss`  string , `Secondary_Reason_for_Denial`  string , `Server_Update_ID`  string , `Initial_report_date_filled`  string , `Reason_for_Denial_Code_is_Null`  string , `Reason_for_denial_is_null`  string , `Cause_of_Loss_is_Null`  string , `Cause_of_Loss_Code_is_Null`  string , `Zoho_Claims_Record_Link`  string , `Error_Codes`  string , `Initial_Report_to_Approval`  string , `Claims_Paid_1`  string , `Initial_Report_to_Date_Closed`  string , `14_Day_Letter_Yes`  string , `Initial_Report_Date_Null`  string , `Approved_to_Close`  string , `Created_to_Approved`  string , `zcrmid`  string , `Policy_Name`  string , `O_C_Stat`  string , `Insured`  string , `TIV_for_Location`  string , `Ind_O_S___Scott`  string , `Ind_Paid___Scott`  string , `Exp_Paid___Scott`  string , `Exp_O_S___Scott`  string , `Total_Value___Scott`  string , `Hours_since_created`  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-stage/raw/storsmart_claims/2023-10-04/1696420869'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_claims`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_claims"
}
Server:
  • hostname: schemamanager-5c55c886bf-h2ts4
  • name: schema_manager
  • process_start: 2025-10-21 13:03:27
  • sf_env: stage
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2023-08-14 10:34:16",
        "disabled": false,
        "format": "raw",
        "id": 2074,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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_Number": "string",
            "Claim_Re_opened_Date": "string",
            "Claim_Reserve_Amount": "string",
            "Claim_Status": "string",
            "Claim_Type": "string",
            "Claim_Types": "string",
            "Claims_Name": "string",
            "Claims_Owner_1": "string",
            "Claims_Owner_Name": "string",
            "Claims_Paid_1": "string",
            "Combined_old___New_Claim_Number": "string",
            "Confirm_Complete": "string",
            "Confirmed_and_Sent": "string",
            "Corp_Group": "string",
            "Corp_Group_Doesnt_Match": "string",
            "Coverage_End_Date": "string",
            "Coverage_Limit": "string",
            "Coverage_Start_Date": "string",
            "Created_By": "string",
            "Created_Time": "string",
            "Created_to_Approved": "string",
            "Created_to_Initial_Report_Date": "string",
            "DOC_Count": "string",
            "Date_Approved": "string",
            "Date_Closed": "string",
            "Date_Closed_Null": "string",
            "Date_ID_Variable": "string",
            "Date_of_Claim": "string",
            "Date_of_Claim_to_Approval": "string",
            "Date_of_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",
            "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_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_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-10-04 07:01:21",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `Stated_Cause_of_Loss`  string , `Reason_for_Denial`  string , `Re_opened_Claim`  string , `AIG___Storage_Ceded_Premiums`  string , `Email`  string , `Certificate_Number`  string , `Date_Approved`  string , `Days_Since_Approved`  string , `Pending_Payment`  string , `Subtract_Month`  string , `Corp_Group`  string , `Days_Since_Confirmed`  string , `Days_Since_First_Report`  string , `Days_Since_Created`  string , `Confirm_Complete`  string , `14_Day_Letter_Sent`  string , `Days_to_Close`  string , `Created_to_Initial_Report_Date`  string , `Created_By`  string , `Modified_By`  string , `Claim_Re_opened_Date`  string , `Reopened_Claim_Reference`  string , `Facility_Address___Nixon`  string , `Subgrogated_Claim`  string , `Subrogated_Claim_Payment`  string , `Subrogated_Payment_Date`  string , `Secondary_Cause_of_Loss`  string , `Secondary_Reason_for_Denial`  string , `Server_Update_ID`  string , `Initial_report_date_filled`  string , `Reason_for_Denial_Code_is_Null`  string , `Reason_for_denial_is_null`  string , `Cause_of_Loss_is_Null`  string , `Cause_of_Loss_Code_is_Null`  string , `Zoho_Claims_Record_Link`  string , `Error_Codes`  string , `Initial_Report_to_Approval`  string , `Claims_Paid_1`  string , `Initial_Report_to_Date_Closed`  string , `14_Day_Letter_Yes`  string , `Initial_Report_Date_Null`  string , `Approved_to_Close`  string , `Created_to_Approved`  string , `zcrmid`  string , `Policy_Name`  string , `O_C_Stat`  string , `Insured`  string , `TIV_for_Location`  string , `Ind_O_S___Scott`  string , `Ind_Paid___Scott`  string , `Exp_Paid___Scott`  string , `Exp_O_S___Scott`  string , `Total_Value___Scott`  string , `Hours_since_created`  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-stage/raw/storsmart_claims/2023-10-04/1696420869'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_claims`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_claims"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform