{"number":0,"provider":"clock","name":"timer","as":"timer","title":null,"description":null,"keyword":"trigger","dynamicPickListSelection":{},"toggleCfg":{},"input":{"interval":"5"},"block":[{"number":1,"provider":"oracle","name":"search_rows","as":"search_rows","title":"Search rows in ROOT.DWH_SF_WKTO_CASE","description":"Search rows in ROOT.DWH_SF_WKTO_CASE table in Oracle","keyword":"action","dynamicPickListSelection":{"table":"ROOT.DWH_SF_WKTO_CASE"},"toggleCfg":{"table":true},"input":{"table":"ROOT.DWH_SF_WKTO_CASE"},"extended_output_schema":[{"type":"array","name":"rows","label":"Rows","of":"object","properties":[{"control_type":"text","label":"ID","details":{"primary_key":true,"data_type":"nvarchar2","column_name":"ID","length":18,"precision":null,"scale":null},"event_title":true,"hint":"nvarchar2, max length 18, primary key","optional":true,"type":"string","name":"id"},{"control_type":"integer","label":"ISDELETED","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISDELETED","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isdeleted"},{"control_type":"text","label":"CASENUMBER","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CASENUMBER","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"casenumber"},{"control_type":"text","label":"CONTACTID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONTACTID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"contactid"},{"control_type":"text","label":"ACCOUNTID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ACCOUNTID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"accountid"},{"control_type":"text","label":"ASSETID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ASSETID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"assetid"},{"control_type":"text","label":"ENTITLEMENTID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ENTITLEMENTID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"entitlementid"},{"control_type":"text","label":"PARENTID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PARENTID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"parentid"},{"control_type":"text","label":"SUPPLIEDNAME","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SUPPLIEDNAME","length":80,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 80","type":"string","name":"suppliedname"},{"control_type":"text","label":"SUPPLIEDEMAIL","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SUPPLIEDEMAIL","length":80,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 80","type":"string","name":"suppliedemail"},{"control_type":"text","label":"SUPPLIEDPHONE","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SUPPLIEDPHONE","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"suppliedphone"},{"control_type":"text","label":"SUPPLIEDCOMPANY","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SUPPLIEDCOMPANY","length":80,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 80","type":"string","name":"suppliedcompany"},{"control_type":"text","label":"TYPE","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TYPE","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"type"},{"control_type":"text","label":"RECORDTYPEID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RECORDTYPEID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"recordtypeid"},{"control_type":"text","label":"STATUS","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"STATUS","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"status"},{"control_type":"text","label":"REASON","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"REASON","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"reason"},{"control_type":"text","label":"ORIGIN","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ORIGIN","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"origin"},{"control_type":"text","label":"SUBJECT","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SUBJECT","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"subject"},{"control_type":"text","label":"PRIORITY","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRIORITY","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"priority"},{"control_type":"integer","label":"ISCLOSED","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISCLOSED","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isclosed"},{"control_type":"text","label":"CLOSEDDATE","details":{"primary_key":false,"data_type":"date","column_name":"CLOSEDDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"closeddate"},{"control_type":"integer","label":"ISESCALATED","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISESCALATED","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isescalated"},{"control_type":"integer","label":"HASCOMMENTSUNREADBYOWNER","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"HASCOMMENTSUNREADBYOWNER","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"hascommentsunreadbyowner"},{"control_type":"integer","label":"HASSELFSERVICECOMMENTS","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"HASSELFSERVICECOMMENTS","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"hasselfservicecomments"},{"control_type":"text","label":"CURRENCYISOCODE","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CURRENCYISOCODE","length":3,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 3","type":"string","name":"currencyisocode"},{"control_type":"text","label":"OWNERID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"OWNERID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"ownerid"},{"control_type":"text","label":"CREATEDDATE","details":{"primary_key":false,"data_type":"date","column_name":"CREATEDDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"createddate"},{"control_type":"text","label":"CREATEDBYID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CREATEDBYID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"createdbyid"},{"control_type":"text","label":"LASTMODIFIEDDATE","details":{"primary_key":false,"data_type":"date","column_name":"LASTMODIFIEDDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"lastmodifieddate"},{"control_type":"text","label":"LASTMODIFIEDBYID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LASTMODIFIEDBYID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"lastmodifiedbyid"},{"control_type":"text","label":"SYSTEMMODSTAMP","details":{"primary_key":false,"data_type":"date","column_name":"SYSTEMMODSTAMP","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"systemmodstamp"},{"control_type":"text","label":"LASTVIEWEDDATE","details":{"primary_key":false,"data_type":"date","column_name":"LASTVIEWEDDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"lastvieweddate"},{"control_type":"text","label":"LASTREFERENCEDDATE","details":{"primary_key":false,"data_type":"date","column_name":"LASTREFERENCEDDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"lastreferenceddate"},{"control_type":"text","label":"CONNECTIONRECEIVEDID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONNECTIONRECEIVEDID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"connectionreceivedid"},{"control_type":"text","label":"CONNECTIONSENTID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONNECTIONSENTID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"connectionsentid"},{"control_type":"text","label":"CASE_SUB_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CASE_SUB_TYPE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"case_sub_type__c"},{"control_type":"text","label":"SERIAL_2__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SERIAL_2__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"serial_2__c"},{"control_type":"text","label":"WEB_ADDRESS_LINE_1__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_ADDRESS_LINE_1__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"web_address_line_1__c"},{"control_type":"text","label":"WEB_ADDRESS_LINE_2__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_ADDRESS_LINE_2__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"web_address_line_2__c"},{"control_type":"text","label":"WEB_CITY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_CITY__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_city__c"},{"control_type":"text","label":"WEB_COMPANY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_COMPANY__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_company__c"},{"control_type":"text","label":"WEB_COUNTRY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_COUNTRY__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_country__c"},{"control_type":"text","label":"WEB_EMAIL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_EMAIL__C","length":80,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 80","type":"string","name":"web_email__c"},{"control_type":"text","label":"WEB_FIRST_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_FIRST_NAME__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_first_name__c"},{"control_type":"text","label":"WEB_LAST_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_LAST_NAME__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_last_name__c"},{"control_type":"text","label":"WEB_STATE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_STATE__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_state__c"},{"control_type":"text","label":"WEB_TELEPHONE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_TELEPHONE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"web_telephone__c"},{"control_type":"text","label":"WEB_ZIP_POSTAL_CODE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_ZIP_POSTAL_CODE__C","length":16,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 16","type":"string","name":"web_zip_postal_code__c"},{"control_type":"text","label":"YOUR_ROLE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"YOUR_ROLE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"your_role__c"},{"control_type":"integer","label":"ACTUAL_RESOLUTION_TIME_IN_MINU","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ACTUAL_RESOLUTION_TIME_IN_MINU","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"actual_resolution_time_in_minu"},{"control_type":"text","label":"ACTUAL_RESOLUTION_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"ACTUAL_RESOLUTION_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"actual_resolution_time__c"},{"control_type":"integer","label":"ACTUAL_RESPONSE_TIME_IN_MINUTE","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ACTUAL_RESPONSE_TIME_IN_MINUTE","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"actual_response_time_in_minute"},{"control_type":"text","label":"ACTUAL_RESPONSE_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"ACTUAL_RESPONSE_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"actual_response_time__c"},{"control_type":"integer","label":"ACTUAL_RESTORATION_TIME_IN_MIN","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ACTUAL_RESTORATION_TIME_IN_MIN","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"actual_restoration_time_in_min"},{"control_type":"text","label":"ACTUAL_RESTORATION_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"ACTUAL_RESTORATION_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"actual_restoration_time__c"},{"control_type":"integer","label":"AFTER_HOURS_TECH_SUPPORT__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"AFTER_HOURS_TECH_SUPPORT__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"after_hours_tech_support__c"},{"control_type":"text","label":"ASSET_SERIAL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ASSET_SERIAL__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"asset_serial__c"},{"control_type":"text","label":"ASSET__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ASSET__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"asset__c"},{"control_type":"text","label":"BILLING_CITY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"BILLING_CITY__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"billing_city__c"},{"control_type":"text","label":"BUSINESS_UNITL4__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"BUSINESS_UNITL4__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"business_unitl4__c"},{"control_type":"text","label":"BUSINESS_UNIT_L4__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"BUSINESS_UNIT_L4__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"business_unit_l4__c"},{"control_type":"text","label":"CPAR__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CPAR__C","length":10,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 10","type":"string","name":"cpar__c"},{"control_type":"text","label":"CR_STATUS_FIXED_IN_VALUES__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CR_STATUS_FIXED_IN_VALUES__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"cr_status_fixed_in_values__c"},{"control_type":"text","label":"CR_VALUES__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CR_VALUES__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"cr_values__c"},{"control_type":"text","label":"CALIBRATION_SERVICE_2__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CALIBRATION_SERVICE_2__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"calibration_service_2__c"},{"control_type":"text","label":"CALIBRATION_SERVICE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CALIBRATION_SERVICE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"calibration_service__c"},{"control_type":"number","label":"CASE_AGE_TRACKING__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"CASE_AGE_TRACKING__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"case_age_tracking__c"},{"control_type":"integer","label":"CASE_AGE__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"CASE_AGE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"case_age__c"},{"control_type":"integer","label":"CASE_CLOSE_CHECK__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"CASE_CLOSE_CHECK__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"case_close_check__c"},{"control_type":"text","label":"CASE_CLOSURE_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"CASE_CLOSURE_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"case_closure_time__c"},{"control_type":"text","label":"CASE_CREATION_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"CASE_CREATION_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"case_creation_date__c"},{"control_type":"text","label":"CASE_CREATION_DATE_DEL__C","details":{"primary_key":false,"data_type":"date","column_name":"CASE_CREATION_DATE_DEL__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"case_creation_date_del__c"},{"control_type":"text","label":"CASE_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CASE_NAME__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"case_name__c"},{"control_type":"text","label":"CASE_TYPE_DETAIL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CASE_TYPE_DETAIL__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"case_type_detail__c"},{"control_type":"text","label":"CASE_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CASE_TYPE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"case_type__c"},{"control_type":"text","label":"CATALOG_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CATALOG_NUMBER__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"catalog_number__c"},{"control_type":"integer","label":"COMMITMENT_SLA__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"COMMITMENT_SLA__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"commitment_sla__c"},{"control_type":"text","label":"COMPANY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"COMPANY__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"company__c"},{"control_type":"text","label":"COMPONENT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"COMPONENT__C","length":250,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 250","type":"string","name":"component__c"},{"control_type":"text","label":"CONDITION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONDITION__C","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"condition__c"},{"control_type":"text","label":"COVERAGE_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"COVERAGE_TYPE__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"coverage_type__c"},{"control_type":"text","label":"CURRENT_QUEUE_IN_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"CURRENT_QUEUE_IN_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"current_queue_in_datetime__c"},{"control_type":"text","label":"CURRENT_QUEUE_TIME_FORMAT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CURRENT_QUEUE_TIME_FORMAT__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"current_queue_time_format__c"},{"control_type":"text","label":"CURRENT_QUEUE_TIME_NOTIFICATIO","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CURRENT_QUEUE_TIME_NOTIFICATIO","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"current_queue_time_notificatio"},{"control_type":"text","label":"CURRENT_QUEUE_TIME_TRACK_ON_CA","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CURRENT_QUEUE_TIME_TRACK_ON_CA","length":20,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 20","type":"string","name":"current_queue_time_track_on_ca"},{"control_type":"number","label":"CURRENT_QUEUE_TIME__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"CURRENT_QUEUE_TIME__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"current_queue_time__c"},{"control_type":"text","label":"CUSTOMER_CASE_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"CUSTOMER_CASE_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"customer_case_time__c"},{"control_type":"text","label":"CUSTOMER_IMPACT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CUSTOMER_IMPACT__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"customer_impact__c"},{"control_type":"text","label":"CUSTOMER_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CUSTOMER_NUMBER__C","length":20,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 20","type":"string","name":"customer_number__c"},{"control_type":"text","label":"CUSTOMER_TIME_IN_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"CUSTOMER_TIME_IN_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"customer_time_in_datetime__c"},{"control_type":"text","label":"CUSTOMER_TIME_OUT_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"CUSTOMER_TIME_OUT_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"customer_time_out_datetime__c"},{"control_type":"number","label":"CUSTOMER_TIME_TRACKING__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"CUSTOMER_TIME_TRACKING__C","length":0,"precision":18,"scale":5},"optional":true,"hint":"number","type":"number","name":"customer_time_tracking__c"},{"control_type":"text","label":"CUSTOMER_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CUSTOMER_TIME__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"customer_time__c"},{"control_type":"text","label":"DATE_FIX_RELEASED__C","details":{"primary_key":false,"data_type":"date","column_name":"DATE_FIX_RELEASED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"date_fix_released__c"},{"control_type":"integer","label":"DO_NOT_EMAIL__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"DO_NOT_EMAIL__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"do_not_email__c"},{"control_type":"integer","label":"EMAIL_24X7__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"EMAIL_24X7__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"email_24x7__c"},{"control_type":"text","label":"END_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"END_TIME__C","length":8,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 8","type":"string","name":"end_time__c"},{"control_type":"integer","label":"ENTITLEMENT_VERIFIED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ENTITLEMENT_VERIFIED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"entitlement_verified__c"},{"control_type":"text","label":"ENTITLEMENT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ENTITLEMENT__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"entitlement__c"},{"control_type":"text","label":"ESCALATED_ICON__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ESCALATED_ICON__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"escalated_icon__c"},{"control_type":"integer","label":"ESCALATED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ESCALATED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"escalated__c"},{"control_type":"integer","label":"ESCALATION_FLAG__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ESCALATION_FLAG__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"escalation_flag__c"},{"control_type":"text","label":"ESCALATION_MANAGER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ESCALATION_MANAGER__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"escalation_manager__c"},{"control_type":"text","label":"ESCALATION_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ESCALATION_TYPE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"escalation_type__c"},{"control_type":"integer","label":"FEEBACK_REQUESTED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"FEEBACK_REQUESTED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"feeback_requested__c"},{"control_type":"integer","label":"FIRST_CALL_RESOLUTION__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"FIRST_CALL_RESOLUTION__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"first_call_resolution__c"},{"control_type":"text","label":"FIX_RESPONSE_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"FIX_RESPONSE_TIME__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"fix_response_time__c"},{"control_type":"integer","label":"FIX_ALREADY_AVAILABLE__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"FIX_ALREADY_AVAILABLE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"fix_already_available__c"},{"control_type":"text","label":"FOLLOW_UP_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"FOLLOW_UP_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"follow_up_date__c"},{"control_type":"text","label":"FREEZE_RESOLUTION_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"FREEZE_RESOLUTION_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"freeze_resolution_time__c"},{"control_type":"text","label":"FREEZE_RESPONSE_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"FREEZE_RESPONSE_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"freeze_response_time__c"},{"control_type":"text","label":"FREEZE_RESTORATION_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"FREEZE_RESTORATION_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"freeze_restoration_time__c"},{"control_type":"integer","label":"FUTUREMETHODCALLED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"FUTUREMETHODCALLED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"futuremethodcalled__c"},{"control_type":"text","label":"GMT_OFFSET__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"GMT_OFFSET__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"gmt_offset__c"},{"control_type":"text","label":"HOT_FIX_TIMESTAMP__C","details":{"primary_key":false,"data_type":"date","column_name":"HOT_FIX_TIMESTAMP__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"hot_fix_timestamp__c"},{"control_type":"text","label":"HARDWARE_VERSION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"HARDWARE_VERSION__C","length":250,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 250","type":"string","name":"hardware_version__c"},{"control_type":"integer","label":"HOT_CASE__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"HOT_CASE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"hot_case__c"},{"control_type":"text","label":"HOT_FIX_DETAIL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"HOT_FIX_DETAIL__C","length":100,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 100","type":"string","name":"hot_fix_detail__c"},{"control_type":"integer","label":"HOT_FIX_FLAG__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"HOT_FIX_FLAG__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"hot_fix_flag__c"},{"control_type":"text","label":"INSTANCE_ID__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"INSTANCE_ID__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"instance_id__c"},{"control_type":"text","label":"INSTANCE_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"INSTANCE_NUMBER__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"instance_number__c"},{"control_type":"integer","label":"INTERNAL_CASE__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"INTERNAL_CASE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"internal_case__c"},{"control_type":"integer","label":"IS_REQUEST_VIOLATED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"IS_REQUEST_VIOLATED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"is_request_violated__c"},{"control_type":"integer","label":"IS_RESOLUTION_VIOLATED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"IS_RESOLUTION_VIOLATED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"is_resolution_violated__c"},{"control_type":"integer","label":"IS_RESPONSE_VIOLATED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"IS_RESPONSE_VIOLATED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"is_response_violated__c"},{"control_type":"integer","label":"IS_RESTORATION_VIOLATED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"IS_RESTORATION_VIOLATED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"is_restoration_violated__c"},{"control_type":"text","label":"JDSU_TIME_IN_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"JDSU_TIME_IN_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"jdsu_time_in_datetime__c"},{"control_type":"text","label":"JDSU_TIME_OUT_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"JDSU_TIME_OUT_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"jdsu_time_out_datetime__c"},{"control_type":"text","label":"JDSU_TIME_TEMP__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"JDSU_TIME_TEMP__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"jdsu_time_temp__c"},{"control_type":"number","label":"JDSU_TIME_TRACKING__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"JDSU_TIME_TRACKING__C","length":0,"precision":18,"scale":5},"optional":true,"hint":"number","type":"number","name":"jdsu_time_tracking__c"},{"control_type":"text","label":"JDSU_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"JDSU_TIME__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"jdsu_time__c"},{"control_type":"number","label":"JDSU_TIME_MINS__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"JDSU_TIME_MINS__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"jdsu_time_mins__c"},{"control_type":"text","label":"JIRA_ISSUE_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"JIRA_ISSUE_NUMBER__C","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"jira_issue_number__c"},{"control_type":"text","label":"JIRA_PROJECTS__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"JIRA_PROJECTS__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"jira_projects__c"},{"control_type":"text","label":"JIRA_SERIAL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"JIRA_SERIAL__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"jira_serial__c"},{"control_type":"text","label":"JIRA_TICKET_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"JIRA_TICKET_OWNER__C","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"jira_ticket_owner__c"},{"control_type":"text","label":"JIRA_TICKET_STATUS__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"JIRA_TICKET_STATUS__C","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"jira_ticket_status__c"},{"control_type":"text","label":"JOB_TITLE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"JOB_TITLE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"job_title__c"},{"control_type":"text","label":"LAST_MODIFIED_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"LAST_MODIFIED_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"last_modified_date__c"},{"control_type":"text","label":"LEGACY_ACTUAL_RESOLUTION_TIME_","details":{"primary_key":false,"data_type":"date","column_name":"LEGACY_ACTUAL_RESOLUTION_TIME_","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"legacy_actual_resolution_time_"},{"control_type":"text","label":"LEGACY_ACTUAL_RESPONSE_TIME_IN","details":{"primary_key":false,"data_type":"date","column_name":"LEGACY_ACTUAL_RESPONSE_TIME_IN","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"legacy_actual_response_time_in"},{"control_type":"text","label":"LEGACY_ACTUAL_RESTORATION_TIME","details":{"primary_key":false,"data_type":"date","column_name":"LEGACY_ACTUAL_RESTORATION_TIME","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"legacy_actual_restoration_time"},{"control_type":"text","label":"LEGACY_CONTACT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEGACY_CONTACT__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"legacy_contact__c"},{"control_type":"text","label":"LEGACY_CUSTOMER_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEGACY_CUSTOMER_TIME__C","length":128,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 128","type":"string","name":"legacy_customer_time__c"},{"control_type":"text","label":"LEGACY_ID__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEGACY_ID__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"legacy_id__c"},{"control_type":"text","label":"LEGACY_JDSU_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEGACY_JDSU_TIME__C","length":128,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 128","type":"string","name":"legacy_jdsu_time__c"},{"control_type":"integer","label":"LEGACY_MAJOR_SLA_RESOLUTION_TI","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"LEGACY_MAJOR_SLA_RESOLUTION_TI","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"legacy_major_sla_resolution_ti"},{"control_type":"integer","label":"LEGACY_MAJOR_SLA_RESTORATION_T","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"LEGACY_MAJOR_SLA_RESTORATION_T","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"legacy_major_sla_restoration_t"},{"control_type":"integer","label":"LEGACY_MINOR_SLA_RESOLUTION_TI","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"LEGACY_MINOR_SLA_RESOLUTION_TI","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"legacy_minor_sla_resolution_ti"},{"control_type":"integer","label":"LEGACY_MINOR_SLA_RESTORATION_T","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"LEGACY_MINOR_SLA_RESTORATION_T","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"legacy_minor_sla_restoration_t"},{"control_type":"text","label":"LEGACY_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEGACY_OWNER__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"legacy_owner__c"},{"control_type":"integer","label":"LEGACY_SLA_RESPONSE_TIME__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"LEGACY_SLA_RESPONSE_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"legacy_sla_response_time__c"},{"control_type":"text","label":"LEGACY_SYSTEM_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEGACY_SYSTEM_NAME__C","length":100,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 100","type":"string","name":"legacy_system_name__c"},{"control_type":"text","label":"LEVEL_1_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEVEL_1_OWNER__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"level_1_owner__c"},{"control_type":"text","label":"LEVEL_2_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEVEL_2_OWNER__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"level_2_owner__c"},{"control_type":"text","label":"LEVEL_3_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEVEL_3_OWNER__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"level_3_owner__c"},{"control_type":"text","label":"NSE_CLOSE_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"NSE_CLOSE_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"nse_close_date__c"},{"control_type":"number","label":"OLD_TIME_IN_OPEN_CONDITION__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"OLD_TIME_IN_OPEN_CONDITION__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"old_time_in_open_condition__c"},{"control_type":"number","label":"OLD_CUSTOMER_TIME__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"OLD_CUSTOMER_TIME__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"old_customer_time__c"},{"control_type":"number","label":"OLD_JDSU_TIME__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"OLD_JDSU_TIME__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"old_jdsu_time__c"},{"control_type":"number","label":"OLD_TIME_IN_ESCALATED_CONDITIO","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"OLD_TIME_IN_ESCALATED_CONDITIO","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"old_time_in_escalated_conditio"},{"control_type":"number","label":"OLD_TIME_IN_WAITING_FOR_CUSTOM","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"OLD_TIME_IN_WAITING_FOR_CUSTOM","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"old_time_in_waiting_for_custom"},{"control_type":"text","label":"ORIG_PURCHASE_ORDER_NUMBER_2__","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ORIG_PURCHASE_ORDER_NUMBER_2__","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"orig_purchase_order_number_2__"},{"control_type":"text","label":"ORIG_PURCHASE_ORDER_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ORIG_PURCHASE_ORDER_NUMBER__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"orig_purchase_order_number__c"},{"control_type":"text","label":"ORIG_SALES_ORDER_NUMBER_2__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ORIG_SALES_ORDER_NUMBER_2__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"orig_sales_order_number_2__c"},{"control_type":"text","label":"ORIG_SALES_ORDER_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ORIG_SALES_ORDER_NUMBER__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"orig_sales_order_number__c"},{"control_type":"text","label":"ORIGINAL_ORDER_SHIP_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"ORIGINAL_ORDER_SHIP_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"original_order_ship_date__c"},{"control_type":"text","label":"ORIGINAL_SO__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ORIGINAL_SO__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"original_so__c"},{"control_type":"text","label":"ORIGINATION_C__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ORIGINATION_C__C","length":60,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 60","type":"string","name":"origination_c__c"},{"control_type":"text","label":"PO_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PO_NUMBER__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"po_number__c"},{"control_type":"text","label":"PREVIOUS_CASE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PREVIOUS_CASE__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"previous_case__c"},{"control_type":"text","label":"PRODUCT_CATEGORYL5__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_CATEGORYL5__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"product_categoryl5__c"},{"control_type":"text","label":"PRODUCT_CATEGORY_L5__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_CATEGORY_L5__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"product_category_l5__c"},{"control_type":"text","label":"PRODUCT_DETAIL_L8_OLD__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_DETAIL_L8_OLD__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"product_detail_l8_old__c"},{"control_type":"text","label":"PRODUCT_DETAIL_L8__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_DETAIL_L8__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"product_detail_l8__c"},{"control_type":"text","label":"PRODUCT_FAMILY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_FAMILY__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"product_family__c"},{"control_type":"text","label":"PRODUCT_LINE_IDENTIFICATIONL4_","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_LINE_IDENTIFICATIONL4_","length":100,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 100","type":"string","name":"product_line_identificationl4_"},{"control_type":"text","label":"PRODUCT_LINE_IDENTIFICATIONL5_","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_LINE_IDENTIFICATIONL5_","length":100,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 100","type":"string","name":"product_line_identificationl5_"},{"control_type":"text","label":"PRODUCT_LINE_IDENTIFICATIONL8_","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_LINE_IDENTIFICATIONL8_","length":100,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 100","type":"string","name":"product_line_identificationl8_"},{"control_type":"text","label":"PRODUCT_LINE_L5__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_LINE_L5__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"product_line_l5__c"},{"control_type":"text","label":"PRODUCT_MODEL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_MODEL__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"product_model__c"},{"control_type":"text","label":"PRODUCT_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_NUMBER__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"product_number__c"},{"control_type":"text","label":"PRODUCT_SERIAL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_SERIAL__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"product_serial__c"},{"control_type":"text","label":"PRODUCT_SUBTYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_SUBTYPE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"product_subtype__c"},{"control_type":"text","label":"PRODUCT_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_TYPE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"product_type__c"},{"control_type":"text","label":"QIN__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"QIN__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"qin__c"},{"control_type":"text","label":"RMA__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RMA__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"rma__c"},{"control_type":"text","label":"REGION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"REGION__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"region__c"},{"control_type":"text","label":"REGION_ARCHIVE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"REGION_ARCHIVE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"region_archive__c"},{"control_type":"text","label":"REQUEST_INFORMATION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"REQUEST_INFORMATION__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"request_information__c"},{"control_type":"text","label":"REQUEST_TYPE_2__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"REQUEST_TYPE_2__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"request_type_2__c"},{"control_type":"text","label":"REQUEST_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"REQUEST_TYPE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"request_type__c"},{"control_type":"text","label":"RESOLUTION_COMMENT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RESOLUTION_COMMENT__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"resolution_comment__c"},{"control_type":"text","label":"RESOLUTION_INTIME__C","details":{"primary_key":false,"data_type":"date","column_name":"RESOLUTION_INTIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"resolution_intime__c"},{"control_type":"integer","label":"RESOLUTION_TIME_SLA__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"RESOLUTION_TIME_SLA__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"resolution_time_sla__c"},{"control_type":"number","label":"RESOLUTION_TIME__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"RESOLUTION_TIME__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"resolution_time__c"},{"control_type":"text","label":"RESOLUTION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RESOLUTION__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"resolution__c"},{"control_type":"integer","label":"RESPONSE_TIME_SLA__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"RESPONSE_TIME_SLA__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"response_time_sla__c"},{"control_type":"text","label":"RESPONSE_TIME_MINS__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RESPONSE_TIME_MINS__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"response_time_mins__c"},{"control_type":"number","label":"RESTORATION_TIME_HOURS__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"RESTORATION_TIME_HOURS__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"restoration_time_hours__c"},{"control_type":"integer","label":"RESTORATION_TIME_SLA__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"RESTORATION_TIME_SLA__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"restoration_time_sla__c"},{"control_type":"text","label":"RESTORATION_TIME_MINS__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RESTORATION_TIME_MINS__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"restoration_time_mins__c"},{"control_type":"text","label":"RETURNING_MODEL_NUMBER_2__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RETURNING_MODEL_NUMBER_2__C","length":16,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 16","type":"string","name":"returning_model_number_2__c"},{"control_type":"text","label":"RETURNING_MODEL_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RETURNING_MODEL_NUMBER__C","length":16,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 16","type":"string","name":"returning_model_number__c"},{"control_type":"text","label":"ROOT_CAUSE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ROOT_CAUSE__C","length":60,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 60","type":"string","name":"root_cause__c"},{"control_type":"text","label":"SLA_LEVEL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SLA_LEVEL__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"sla_level__c"},{"control_type":"text","label":"SLA_RESOLUTION_TIME_DAYS__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SLA_RESOLUTION_TIME_DAYS__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"sla_resolution_time_days__c"},{"control_type":"text","label":"SLA_RESPONSE_TIME_HOURS__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SLA_RESPONSE_TIME_HOURS__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"sla_response_time_hours__c"},{"control_type":"text","label":"SLA_RESTORATION_TIME_DAYS__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SLA_RESTORATION_TIME_DAYS__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"sla_restoration_time_days__c"},{"control_type":"text","label":"SLA_SUMMARY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SLA_SUMMARY__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"sla_summary__c"},{"control_type":"text","label":"SO_RELATED_TO_THIS_TICKET__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SO_RELATED_TO_THIS_TICKET__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"so_related_to_this_ticket__c"},{"control_type":"text","label":"SR_UNIT_RECEIPT_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"SR_UNIT_RECEIPT_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"sr_unit_receipt_date__c"},{"control_type":"text","label":"SEND_SURVEY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SEND_SURVEY__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"send_survey__c"},{"control_type":"text","label":"SEND_TO_ENGINEERING_MAJOR__C","details":{"primary_key":false,"data_type":"date","column_name":"SEND_TO_ENGINEERING_MAJOR__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"send_to_engineering_major__c"},{"control_type":"text","label":"SEND_TO_ENGINEERING_MINOR__C","details":{"primary_key":false,"data_type":"date","column_name":"SEND_TO_ENGINEERING_MINOR__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"send_to_engineering_minor__c"},{"control_type":"text","label":"SERIAL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SERIAL__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"serial__c"},{"control_type":"number","label":"SEVERITY_HOURS__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"SEVERITY_HOURS__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"severity_hours__c"},{"control_type":"text","label":"SEVERITY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SEVERITY__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"severity__c"},{"control_type":"text","label":"SOFTWARE_VERSION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SOFTWARE_VERSION__C","length":250,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 250","type":"string","name":"software_version__c"},{"control_type":"text","label":"SOLUTION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SOLUTION__C","length":1000,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1000","type":"string","name":"solution__c"},{"control_type":"text","label":"START_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"START_TIME__C","length":8,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 8","type":"string","name":"start_time__c"},{"control_type":"integer","label":"STOP_QUEUE_EMAIL_NOTIFICATION_","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"STOP_QUEUE_EMAIL_NOTIFICATION_","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"stop_queue_email_notification_"},{"control_type":"text","label":"SUMMARY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SUMMARY__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"summary__c"},{"control_type":"text","label":"SYSTEM_DESCRIPTION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SYSTEM_DESCRIPTION__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"system_description__c"},{"control_type":"text","label":"SYSTEM_HANDLE_C__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SYSTEM_HANDLE_C__C","length":60,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 60","type":"string","name":"system_handle_c__c"},{"control_type":"text","label":"SYSTEM_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SYSTEM_NAME__C","length":100,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 100","type":"string","name":"system_name__c"},{"control_type":"text","label":"SYSTEM_NUMBER_HANDLE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SYSTEM_NUMBER_HANDLE__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"system_number_handle__c"},{"control_type":"text","label":"TL9000_FRT_DEFERRED_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"TL9000_FRT_DEFERRED_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"tl9000_frt_deferred_date__c"},{"control_type":"integer","label":"TL9000_PROBLEM_RECURRENCE__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"TL9000_PROBLEM_RECURRENCE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"tl9000_problem_recurrence__c"},{"control_type":"integer","label":"TL9000_SFQ_DFC_COUNT__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"TL9000_SFQ_DFC_COUNT__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"tl9000_sfq_dfc_count__c"},{"control_type":"integer","label":"TL9000_SFQ_DFC__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"TL9000_SFQ_DFC__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"tl9000_sfq_dfc__c"},{"control_type":"integer","label":"TL9000_SQ_FLAG__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"TL9000_SQ_FLAG__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"tl9000_sq_flag__c"},{"control_type":"text","label":"TL9000_SEVERITY_LEVEL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TL9000_SEVERITY_LEVEL__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"tl9000_severity_level__c"},{"control_type":"text","label":"TARGET_RESOLUTION_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"TARGET_RESOLUTION_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"target_resolution_time__c"},{"control_type":"text","label":"TARGET_RESPONSE_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"TARGET_RESPONSE_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"target_response_time__c"},{"control_type":"text","label":"TARGET_RESTORATION_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"TARGET_RESTORATION_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"target_restoration_time__c"},{"control_type":"integer","label":"TIME_ELAPSED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"TIME_ELAPSED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"time_elapsed__c"},{"control_type":"text","label":"TIME_IN_ESCALATED_CONDITION_FO","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TIME_IN_ESCALATED_CONDITION_FO","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"time_in_escalated_condition_fo"},{"control_type":"number","label":"TIME_IN_ESCALATED_CONDITION__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"TIME_IN_ESCALATED_CONDITION__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"time_in_escalated_condition__c"},{"control_type":"text","label":"TIME_IN_ESCALATED_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"TIME_IN_ESCALATED_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"time_in_escalated_datetime__c"},{"control_type":"text","label":"TIME_IN_OPEN_CONDITION_FORMAT_","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TIME_IN_OPEN_CONDITION_FORMAT_","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"time_in_open_condition_format_"},{"control_type":"number","label":"TIME_IN_OPEN_CONDITION__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"TIME_IN_OPEN_CONDITION__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"time_in_open_condition__c"},{"control_type":"text","label":"TIME_IN_OPEN_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"TIME_IN_OPEN_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"time_in_open_datetime__c"},{"control_type":"text","label":"TIME_IN_WAITINGFORCUSTOMER_DAT","details":{"primary_key":false,"data_type":"date","column_name":"TIME_IN_WAITINGFORCUSTOMER_DAT","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"time_in_waitingforcustomer_dat"},{"control_type":"text","label":"TIME_IN_WAITING_FOR_CUSTOMER_F","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TIME_IN_WAITING_FOR_CUSTOMER_F","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"time_in_waiting_for_customer_f"},{"control_type":"number","label":"TIME_IN_WAITING_FOR_CUSTOMER__","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"TIME_IN_WAITING_FOR_CUSTOMER__","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"time_in_waiting_for_customer__"},{"control_type":"text","label":"TIME_OUT_ESCALATED_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"TIME_OUT_ESCALATED_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"time_out_escalated_datetime__c"},{"control_type":"text","label":"TIME_OUT_OPEN_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"TIME_OUT_OPEN_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"time_out_open_datetime__c"},{"control_type":"text","label":"TIME_OUT_WAITINGFORCUSTOMER_DA","details":{"primary_key":false,"data_type":"date","column_name":"TIME_OUT_WAITINGFORCUSTOMER_DA","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"time_out_waitingforcustomer_da"},{"control_type":"text","label":"TIME_ZONE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TIME_ZONE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"time_zone__c"},{"control_type":"text","label":"TODAY_S_DATE_5_BUSINESS__C","details":{"primary_key":false,"data_type":"date","column_name":"TODAY_S_DATE_5_BUSINESS__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"today_s_date_5_business__c"},{"control_type":"text","label":"TODAY_S_DATE_5__C","details":{"primary_key":false,"data_type":"date","column_name":"TODAY_S_DATE_5__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"today_s_date_5__c"},{"control_type":"text","label":"TOTAL_CASE_OPEN_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TOTAL_CASE_OPEN_TIME__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"total_case_open_time__c"},{"control_type":"text","label":"TOTAL_CASE_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TOTAL_CASE_TIME__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"total_case_time__c"},{"control_type":"text","label":"TOTAL_OUTAGE_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TOTAL_OUTAGE_TIME__C","length":14,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 14","type":"string","name":"total_outage_time__c"},{"control_type":"integer","label":"TOTAL_SYSTEM_ELEMENTS__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"TOTAL_SYSTEM_ELEMENTS__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"total_system_elements__c"},{"control_type":"text","label":"USER_CONTACT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"USER_CONTACT__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"user_contact__c"},{"control_type":"text","label":"WEB_YOUR_TITLE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_YOUR_TITLE__C","length":200,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 200","type":"string","name":"web_your_title__c"},{"control_type":"text","label":"WORK_GROUP__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WORK_GROUP__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"work_group__c"},{"control_type":"text","label":"X5_BUSINESS_DAYS_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"X5_BUSINESS_DAYS_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"x5_business_days_date__c"},{"control_type":"integer","label":"X8X5_EMAIL__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"X8X5_EMAIL__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"x8x5_email__c"},{"control_type":"number","label":"CUSTOMER_TIME_TRACKING_TEMP__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"CUSTOMER_TIME_TRACKING_TEMP__C","length":0,"precision":18,"scale":5},"optional":true,"hint":"number","type":"number","name":"customer_time_tracking_temp__c"},{"control_type":"number","label":"JDSU_TIME_TRACKING_TEMP__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"JDSU_TIME_TRACKING_TEMP__C","length":0,"precision":18,"scale":5},"optional":true,"hint":"number","type":"number","name":"jdsu_time_tracking_temp__c"},{"control_type":"text","label":"LEVEL_1_RESPONSE__C","details":{"primary_key":false,"data_type":"date","column_name":"LEVEL_1_RESPONSE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"level_1_response__c"},{"control_type":"text","label":"RESOLUTION_TIME_MANUAL__C","details":{"primary_key":false,"data_type":"date","column_name":"RESOLUTION_TIME_MANUAL__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"resolution_time_manual__c"},{"control_type":"text","label":"RESTORATION_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"RESTORATION_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"restoration_time__c"},{"control_type":"integer","label":"SURVEY_EMAIL_SEND_TO_CONTACT__","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"SURVEY_EMAIL_SEND_TO_CONTACT__","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"survey_email_send_to_contact__"},{"control_type":"text","label":"CHATTER_TEXT_BY_CUSTOMER__C","details":{"primary_key":false,"data_type":"nclob","column_name":"CHATTER_TEXT_BY_CUSTOMER__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"chatter_text_by_customer__c"},{"control_type":"integer","label":"SEND_CHATTER_EMAIL_TO_CASE_OWN","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"SEND_CHATTER_EMAIL_TO_CASE_OWN","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"send_chatter_email_to_case_own"},{"control_type":"text","label":"SYSTEM_HANDLE_REGION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SYSTEM_HANDLE_REGION__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"system_handle_region__c"},{"control_type":"text","label":"RELATED_ID__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RELATED_ID__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"related_id__c"},{"control_type":"text","label":"SENDEMAIL_DISCRIPTION__C","details":{"primary_key":false,"data_type":"nclob","column_name":"SENDEMAIL_DISCRIPTION__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"sendemail_discription__c"},{"control_type":"text","label":"SENDEMAIL_SUBJECT__C","details":{"primary_key":false,"data_type":"nclob","column_name":"SENDEMAIL_SUBJECT__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"sendemail_subject__c"},{"control_type":"integer","label":"SENDEMAIL__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"SENDEMAIL__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"sendemail__c"},{"control_type":"number","label":"RESPONSE_TIME_SUMMARY__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"RESPONSE_TIME_SUMMARY__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"response_time_summary__c"},{"control_type":"text","label":"ACTION_PLAN__C","details":{"primary_key":false,"data_type":"nclob","column_name":"ACTION_PLAN__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"action_plan__c"},{"control_type":"text","label":"ARIESO_CASE_ID__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ARIESO_CASE_ID__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"arieso_case_id__c"},{"control_type":"text","label":"CLOSED_BY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CLOSED_BY__C","length":100,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 100","type":"string","name":"closed_by__c"},{"control_type":"text","label":"DATE_RETURNED_FROM_3RD_LINE__C","details":{"primary_key":false,"data_type":"date","column_name":"DATE_RETURNED_FROM_3RD_LINE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"date_returned_from_3rd_line__c"},{"control_type":"integer","label":"DEVELOPMENT_REFERENCE_CHK__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"DEVELOPMENT_REFERENCE_CHK__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"development_reference_chk__c"},{"control_type":"text","label":"DEVELOPMENT_REFERENCE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"DEVELOPMENT_REFERENCE__C","length":1024,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1024","type":"string","name":"development_reference__c"},{"control_type":"integer","label":"KB_CANDIDATE__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"KB_CANDIDATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"kb_candidate__c"},{"control_type":"text","label":"RESOLUTION_DETAIL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RESOLUTION_DETAIL__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"resolution_detail__c"},{"control_type":"text","label":"TARGET_FIX_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"TARGET_FIX_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"target_fix_date__c"},{"control_type":"text","label":"X3RD_LINE_RESOLUTION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"X3RD_LINE_RESOLUTION__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"x3rd_line_resolution__c"},{"control_type":"text","label":"LEGACY_LI_ENTITLED_FIRST_RESPO","details":{"primary_key":false,"data_type":"date","column_name":"LEGACY_LI_ENTITLED_FIRST_RESPO","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"legacy_li_entitled_first_respo"},{"control_type":"text","label":"LEGACY_LI_ENTITLED_RESOLVE_TIM","details":{"primary_key":false,"data_type":"date","column_name":"LEGACY_LI_ENTITLED_RESOLVE_TIM","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"legacy_li_entitled_resolve_tim"},{"control_type":"text","label":"LEGACY_LI_ENTITLED_WORKAROUND_","details":{"primary_key":false,"data_type":"date","column_name":"LEGACY_LI_ENTITLED_WORKAROUND_","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"legacy_li_entitled_workaround_"},{"control_type":"text","label":"AM_FE_ACCOUNT_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"AM_FE_ACCOUNT_OWNER__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"am_fe_account_owner__c"},{"control_type":"text","label":"ACTUAL_DELIVERY_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"ACTUAL_DELIVERY_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"actual_delivery_date__c"},{"control_type":"text","label":"ADDITIONAL_INFORMATION__C","details":{"primary_key":false,"data_type":"nclob","column_name":"ADDITIONAL_INFORMATION__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"additional_information__c"},{"control_type":"text","label":"BETA_RELEASE_ACCEPTABLE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"BETA_RELEASE_ACCEPTABLE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"beta_release_acceptable__c"},{"control_type":"text","label":"BUSINESS_JUSTIFICATION__C","details":{"primary_key":false,"data_type":"nclob","column_name":"BUSINESS_JUSTIFICATION__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"business_justification__c"},{"control_type":"text","label":"BUSINESS_PRIORITY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"BUSINESS_PRIORITY__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"business_priority__c"},{"control_type":"text","label":"CHANCE_OF_WINNING__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CHANCE_OF_WINNING__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"chance_of_winning__c"},{"control_type":"text","label":"COMMITED_ORDER_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"COMMITED_ORDER_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"commited_order_date__c"},{"control_type":"text","label":"COMMITTED_DATE_TO_CUSTOMER__C","details":{"primary_key":false,"data_type":"date","column_name":"COMMITTED_DATE_TO_CUSTOMER__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"committed_date_to_customer__c"},{"control_type":"text","label":"COMPETITIVE_SITUATION__C","details":{"primary_key":false,"data_type":"nclob","column_name":"COMPETITIVE_SITUATION__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"competitive_situation__c"},{"control_type":"number","label":"DEAL_SIZE__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"DEAL_SIZE__C","length":0,"precision":14,"scale":4},"optional":true,"hint":"number","type":"number","name":"deal_size__c"},{"control_type":"text","label":"ENGINEERING_ESTIMATE_MAN_MONTH","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ENGINEERING_ESTIMATE_MAN_MONTH","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"engineering_estimate_man_month"},{"control_type":"text","label":"ESTIMATED_DELIVERY_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"ESTIMATED_DELIVERY_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"estimated_delivery_date__c"},{"control_type":"integer","label":"ISOFFEREXPIRED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISOFFEREXPIRED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isofferexpired__c"},{"control_type":"text","label":"LATEST_ACCEPTABLE_DELIVERY_DAT","details":{"primary_key":false,"data_type":"date","column_name":"LATEST_ACCEPTABLE_DELIVERY_DAT","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"latest_acceptable_delivery_dat"},{"control_type":"text","label":"OFFER_EXPIRATION_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"OFFER_EXPIRATION_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"offer_expiration_date__c"},{"control_type":"text","label":"OPPORTUNITYNAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"OPPORTUNITYNAME__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"opportunityname__c"},{"control_type":"text","label":"PLM_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PLM_OWNER__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"plm_owner__c"},{"control_type":"text","label":"PLANNED_RELEASE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PLANNED_RELEASE__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"planned_release__c"},{"control_type":"text","label":"QUALITY_EXPECTATION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"QUALITY_EXPECTATION__C","length":200,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 200","type":"string","name":"quality_expectation__c"},{"control_type":"text","label":"QUOTATION_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"QUOTATION_NAME__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"quotation_name__c"},{"control_type":"text","label":"R_D_COMMENTS_AND_QUESTIONS__C","details":{"primary_key":false,"data_type":"nclob","column_name":"R_D_COMMENTS_AND_QUESTIONS__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"r_d_comments_and_questions__c"},{"control_type":"text","label":"R_D_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"R_D_OWNER__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"r_d_owner__c"},{"control_type":"number","label":"R_D_ROUGH_LOE_ESTIMATE__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"R_D_ROUGH_LOE_ESTIMATE__C","length":0,"precision":5,"scale":2},"optional":true,"hint":"number","type":"number","name":"r_d_rough_loe_estimate__c"},{"control_type":"text","label":"REQUESTED_DELIVERY_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"REQUESTED_DELIVERY_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"requested_delivery_date__c"},{"control_type":"text","label":"REQUIREMENT_STABILITY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"REQUIREMENT_STABILITY__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"requirement_stability__c"},{"control_type":"text","label":"REQUIREMENT_SUMMARY__C","details":{"primary_key":false,"data_type":"nclob","column_name":"REQUIREMENT_SUMMARY__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"requirement_summary__c"},{"control_type":"text","label":"REQUIREMENTS_CATEGORY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"REQUIREMENTS_CATEGORY__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"requirements_category__c"},{"control_type":"text","label":"RESPONSE_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"RESPONSE_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"response_date__c"},{"control_type":"text","label":"RISK_IF_NOT_APPROVED__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RISK_IF_NOT_APPROVED__C","length":200,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 200","type":"string","name":"risk_if_not_approved__c"},{"control_type":"text","label":"SOLUTION_CONSULTANT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SOLUTION_CONSULTANT__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"solution_consultant__c"},{"control_type":"text","label":"T1_GATE_HELD__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"T1_GATE_HELD__C","length":200,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 200","type":"string","name":"t1_gate_held__c"},{"control_type":"text","label":"LICENSE_KEY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LICENSE_KEY__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"license_key__c"},{"control_type":"text","label":"MACHINE_ID__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"MACHINE_ID__C","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"machine_id__c"},{"control_type":"text","label":"CONTACT_FULL_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONTACT_FULL_NAME__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"contact_full_name__c"},{"control_type":"text","label":"WCONTACT_PHONE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WCONTACT_PHONE__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"wcontact_phone__c"},{"control_type":"text","label":"WCONTACT_EMAIL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WCONTACT_EMAIL__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"wcontact_email__c"},{"control_type":"text","label":"WACCOUNT_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WACCOUNT_OWNER__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"waccount_owner__c"},{"control_type":"text","label":"WCONTACT_MAILINGCOUNTRY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WCONTACT_MAILINGCOUNTRY__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"wcontact_mailingcountry__c"},{"control_type":"integer","label":"WSTRATEGIC_ACCOUNT__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"WSTRATEGIC_ACCOUNT__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"wstrategic_account__c"},{"control_type":"text","label":"WACCOUNTRECTYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WACCOUNTRECTYPE__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"waccountrectype__c"},{"control_type":"text","label":"STATUS_UPDATE__C","details":{"primary_key":false,"data_type":"nclob","column_name":"STATUS_UPDATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"status_update__c"},{"control_type":"text","label":"PRODUCTID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCTID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"productid"},{"control_type":"text","label":"BUSINESSHOURSID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"BUSINESSHOURSID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"businesshoursid"},{"control_type":"integer","label":"ISVISIBLEINSELFSERVICE","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISVISIBLEINSELFSERVICE","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isvisibleinselfservice"},{"control_type":"integer","label":"ISCLOSEDONCREATE","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISCLOSEDONCREATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isclosedoncreate"},{"control_type":"integer","label":"ISSELFSERVICECLOSED","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISSELFSERVICECLOSED","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isselfserviceclosed"},{"control_type":"text","label":"SLASTARTDATE","details":{"primary_key":false,"data_type":"date","column_name":"SLASTARTDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"slastartdate"},{"control_type":"text","label":"SLAEXITDATE","details":{"primary_key":false,"data_type":"date","column_name":"SLAEXITDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"slaexitdate"},{"control_type":"integer","label":"ISSTOPPED","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISSTOPPED","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isstopped"},{"control_type":"text","label":"STOPSTARTDATE","details":{"primary_key":false,"data_type":"date","column_name":"STOPSTARTDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"stopstartdate"},{"control_type":"text","label":"MILESTONESTATUS","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"MILESTONESTATUS","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"milestonestatus"},{"control_type":"text","label":"ACCOUNT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ACCOUNT__C","length":180,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 180","type":"string","name":"account__c"},{"control_type":"text","label":"COMMENTS__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"COMMENTS__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"comments__c"},{"control_type":"text","label":"CONTACT_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONTACT_NAME__C","length":200,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 200","type":"string","name":"contact_name__c"},{"control_type":"text","label":"PRODUCT_ACTIVE_START_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"PRODUCT_ACTIVE_START_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"product_active_start_date__c"},{"control_type":"text","label":"PRODUCT_CUSTOM__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_CUSTOM__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"product_custom__c"},{"control_type":"text","label":"PRODUCT_VERSION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_VERSION__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"product_version__c"},{"control_type":"text","label":"SERIAL_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SERIAL_NUMBER__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"serial_number__c"},{"control_type":"text","label":"URGENCY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"URGENCY__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"urgency__c"},{"control_type":"text","label":"OSP_CASE_SUB_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"OSP_CASE_SUB_TYPE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"osp_case_sub_type__c"},{"control_type":"text","label":"AGF__ADM_WORK__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"AGF__ADM_WORK__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"agf__adm_work__c"},{"control_type":"integer","label":"EMERGENCY_CASE__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"EMERGENCY_CASE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"emergency_case__c"},{"control_type":"text","label":"CUSTOMER_REFERENCE_ID__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CUSTOMER_REFERENCE_ID__C","length":20,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 20","type":"string","name":"customer_reference_id__c"},{"control_type":"text","label":"CASE_CONTACT_NOTIFICATION_EMAI","details":{"primary_key":false,"data_type":"nclob","column_name":"CASE_CONTACT_NOTIFICATION_EMAI","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"case_contact_notification_emai"},{"control_type":"text","label":"CONTACT_NOTIFICATION_EMAIL_TYP","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONTACT_NOTIFICATION_EMAIL_TYP","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"contact_notification_email_typ"},{"control_type":"integer","label":"SEND_EMAIL_TO_CONTACT_TOGGLE__","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"SEND_EMAIL_TO_CONTACT_TOGGLE__","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"send_email_to_contact_toggle__"},{"control_type":"text","label":"CASE_CONTACT_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CASE_CONTACT_NAME__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"case_contact_name__c"},{"control_type":"text","label":"MET_RESOLUTION_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"MET_RESOLUTION_TIME__C","length":10,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 10","type":"string","name":"met_resolution_time__c"},{"control_type":"text","label":"MET_RESPONSE_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"MET_RESPONSE_TIME__C","length":10,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 10","type":"string","name":"met_response_time__c"},{"control_type":"text","label":"MET_RESTORATION_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"MET_RESTORATION_TIME__C","length":10,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 10","type":"string","name":"met_restoration_time__c"},{"control_type":"integer","label":"TL9000_SEVERITY_LEVEL_MINOR__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"TL9000_SEVERITY_LEVEL_MINOR__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"tl9000_severity_level_minor__c"},{"control_type":"text","label":"NI_ASSET__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"NI_ASSET__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"ni_asset__c"},{"control_type":"text","label":"LAST_MODIFIED__C","details":{"primary_key":false,"data_type":"date","column_name":"LAST_MODIFIED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"last_modified__c"}]}],"visible_config_fields":["table"],"hidden_config_fields":["where"],"uuid":"35bbb4fc-596f-410b-ae38-0b520541bca5"},{"number":2,"as":"foreach","keyword":"foreach","dynamicPickListSelection":{},"toggleCfg":{},"clear_scope":false,"input":{},"block":[{"number":3,"provider":"oracle","name":"delete_rows","as":"delete_rows","title":"Delete rows in ROOT.DWH_SF_WKTO_CASE","description":"Delete rows in ROOT.DWH_SF_WKTO_CASE table in Oracle","keyword":"action","dynamicPickListSelection":{"table":"ROOT.DWH_SF_WKTO_CASE"},"toggleCfg":{"table":true},"input":{"table":"ROOT.DWH_SF_WKTO_CASE","where":"ID='#{_('data.foreach.foreach.id')}'"},"uuid":"210a7d28-0bbd-4512-9009-9c5b59ead706"}],"source":"#{_('data.oracle.search_rows.rows')}","uuid":"4e6723e5-4f30-43c7-b73f-4a61cbd1a807"},{"number":4,"provider":"logger","name":"log_message","as":"log_message","title":null,"description":null,"keyword":"action","dynamicPickListSelection":{},"toggleCfg":{},"input":{"message":"fpQIFM9zySHBBd0STZmfJ5TCRxOOnJi0zR9nbX96heAGn7aI7jmxJxK9ByBWxZS2XCwozfOSj5wxdT0WlQb7xq7nDj0joSZqhYUCl03QTILeG0zQCPsjWokf0s2hyW9i85sSduq9GlrJIu0dJE5bTfmBUZtBVU8xy7kZ2WIJjSvxvLaAKG0IXnOQTRVFBTeiabIK4Oxgh049girjJ7SQCF8u0hkFqg3lfHa9VZWyJqafFixjwkzYfL6zoiYw8vJ7XknqJE6U17RpCxss4ZMzscHAWtkaO3T8nDYDhxdqA6gmIrMPpHOVU0eGCqZ073RbcfJEJs2nUpnln594hbMtLC8SWl7io8sFBR6L06Xg5USbyEDWc95phjzOyxk9hDXvqLfZFuEtXKr0A7Opn7gEfcohFKOzlUWaRGoMjjCOEl5NtU8yUM12ToDFMaF8kHiZSgTKRqJYz5uZlt2VkB6X9jCcuMVGtdv3uQNXnz1omJsF7ccD4AkkCoRZr6Z36OtmKsnBLLlQyVhq31v5ZbDRP3nWVdDkR3FTP8paIWOHYhl0PNyrL9iFc3fBNH2Jc0XFnRxsUFC3y0GbkxJLkeBxt4rI6sZI3DaSPK1NdWHfsZu5LtxJODPLodnACWIbeWacv5c32NEIxLPzBEKfwulzuZmKtkhbGCdLT5G0frRyjVlOSs3lj9cxG5Jp8APmry5Q0d1fIrucCyCU1aEI9psROs8fqskSe6XaoqKJhkOwllgFSiUZD4Y1iFtwTR7eKX4n0EYD00uLgySIKGiCJjRVtQIN2E2qgaqMLLQeU7laR7dypnM7F8jQI3TONMTB8Kt55ITlId4Vr7j306CK2RLmdbdFld215cqHlQoqB1IXc71nY5GALN6Q16pvPWv7JQXMd15r32gSH7IXTiIueONZsHAYawIABxbrGCLIYdYeS7vPWhr43EHSoWfhAUOp8Pjo1VOmNoWTzZ8ugGwWW5mLWa6uHxYbslRECnmWN1L8D67tiwL1R16xCZw5qwlW0omnEfxeTAp3lf5EEEYyKZ2JLZKwllMdgoiqtp6RPAt2xFA97mlFHPYutWaIXNTgNEIiusbc1zuIO0UU3fAR8UZVYTEfMvVB3MEjYql64dAeovoMHknrOwNPK1zHrlItUITSVaLrAVrXkP1Rnk0zOQdBFMGq314fcoU0mtZSRzjxhiE9gxW0eSmB2rzKJMa9dwXxi8LUB0uqPrSPVuNHEg7NnoF9B7CvZfAYNzpx7rFGWjvoA2o9yeZxWJRAtNw5yWslyVrXNQXJwtaTHwttWWbLFxnMVelEQXw9femZp5yMOD5dIuq1US6tPosvHT32dd62NfWaJTyktkuMDYAliFQrblt18MDA29zGqlgdsUSaE50sqVMMH1ueCCdk2uST0NPp1UmOh1b7lRY4xp3FvB06PqIxP1w5g38eo1arXoXbqTzcAW8awQzAOsO1AHyr5Wa27icMwXB8BxfcdBD6nw15EoBIPaw1aJQmDlWBcrm99jRhNanlG6im2aJqBPNrmIlx83pY59rb9LKvIRjzRfRDs75v8sOaZ2SIg1ct0aVNTmzP1tlqmSGudiayHxf831MtAAENCHh6fWEy7TQOoOmiFUEggrgS3XQSFQwRXq1zfxjKxPDqxz8ukDoaivYaV9sbpLPMiXLF1metv4cHSvhAyLkMlJjl7AtvH6LkmVjTXu4vx2ambtDOwYw8AYL8BbxI2CABA74o4LiWovSWLxY8aJdV4oQ6MYDf80RY2J8c2YKF2KQvWCrSKZ9LUHGu4YsljdeT5dn1R8KKAM3MqnGQrblD2xAFueQr2YCbrO9PZOmscdfl8ZMS3F2H0AovXXr6qyRmIgLmphgY2Cc46wNAMXWv7P0xhXGEnnrrun9tFuBgsCNAn1hgfQGDKjW7uN1aLbisuLWJEMypNwePi6pY2wYRNmgzNnAliAoKqVIw1o7Ny6NQjKdgB2SkVcs28iMdNiuA31YBrT2zDTud"},"comment":"2000 Character String","uuid":"43ddd976-1e00-43ed-81e6-e5668ab733aa"},{"number":5,"keyword":"try","dynamicPickListSelection":{},"toggleCfg":{},"input":{},"block":[{"number":6,"provider":"oracle","name":"insert_row","as":"insert_row","title":"Create row in ROOT.DWH_SF_WKTO_CASE","description":"Create row in ROOT.DWH_SF_WKTO_CASE table in Oracle","keyword":"action","dynamicPickListSelection":{"table":"ROOT.DWH_SF_WKTO_CASE"},"toggleCfg":{"table":true},"input":{"table":"ROOT.DWH_SF_WKTO_CASE","columns":{"id":"1","chatter_text_by_customer__c":"#{_('data.logger.log_message.message')}"}},"extended_input_schema":[{"type":"object","name":"columns","label":"Columns","properties":[{"control_type":"text","label":"ID","details":{"primary_key":true,"data_type":"nvarchar2","column_name":"ID","length":18,"precision":null,"scale":null},"event_title":true,"hint":"nvarchar2, max length 18, primary key","optional":true,"type":"string","name":"id","parent":"columns"},{"control_type":"integer","label":"ISDELETED","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISDELETED","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isdeleted","parent":"columns"},{"control_type":"text","label":"CASENUMBER","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CASENUMBER","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"casenumber","parent":"columns"},{"control_type":"text","label":"CONTACTID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONTACTID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"contactid","parent":"columns"},{"control_type":"text","label":"ACCOUNTID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ACCOUNTID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"accountid","parent":"columns"},{"control_type":"text","label":"ASSETID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ASSETID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"assetid","parent":"columns"},{"control_type":"text","label":"ENTITLEMENTID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ENTITLEMENTID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"entitlementid","parent":"columns"},{"control_type":"text","label":"PARENTID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PARENTID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"parentid","parent":"columns"},{"control_type":"text","label":"SUPPLIEDNAME","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SUPPLIEDNAME","length":80,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 80","type":"string","name":"suppliedname","parent":"columns"},{"control_type":"text","label":"SUPPLIEDEMAIL","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SUPPLIEDEMAIL","length":80,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 80","type":"string","name":"suppliedemail","parent":"columns"},{"control_type":"text","label":"SUPPLIEDPHONE","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SUPPLIEDPHONE","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"suppliedphone","parent":"columns"},{"control_type":"text","label":"SUPPLIEDCOMPANY","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SUPPLIEDCOMPANY","length":80,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 80","type":"string","name":"suppliedcompany","parent":"columns"},{"control_type":"text","label":"TYPE","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TYPE","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"type","parent":"columns"},{"control_type":"text","label":"RECORDTYPEID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RECORDTYPEID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"recordtypeid","parent":"columns"},{"control_type":"text","label":"STATUS","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"STATUS","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"status","parent":"columns"},{"control_type":"text","label":"REASON","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"REASON","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"reason","parent":"columns"},{"control_type":"text","label":"ORIGIN","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ORIGIN","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"origin","parent":"columns"},{"control_type":"text","label":"SUBJECT","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SUBJECT","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"subject","parent":"columns"},{"control_type":"text","label":"PRIORITY","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRIORITY","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"priority","parent":"columns"},{"control_type":"integer","label":"ISCLOSED","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISCLOSED","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isclosed","parent":"columns"},{"control_type":"text","label":"CLOSEDDATE","details":{"primary_key":false,"data_type":"date","column_name":"CLOSEDDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"closeddate","parent":"columns"},{"control_type":"integer","label":"ISESCALATED","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISESCALATED","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isescalated","parent":"columns"},{"control_type":"integer","label":"HASCOMMENTSUNREADBYOWNER","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"HASCOMMENTSUNREADBYOWNER","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"hascommentsunreadbyowner","parent":"columns"},{"control_type":"integer","label":"HASSELFSERVICECOMMENTS","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"HASSELFSERVICECOMMENTS","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"hasselfservicecomments","parent":"columns"},{"control_type":"text","label":"CURRENCYISOCODE","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CURRENCYISOCODE","length":3,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 3","type":"string","name":"currencyisocode","parent":"columns"},{"control_type":"text","label":"OWNERID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"OWNERID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"ownerid","parent":"columns"},{"control_type":"text","label":"CREATEDDATE","details":{"primary_key":false,"data_type":"date","column_name":"CREATEDDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"createddate","parent":"columns"},{"control_type":"text","label":"CREATEDBYID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CREATEDBYID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"createdbyid","parent":"columns"},{"control_type":"text","label":"LASTMODIFIEDDATE","details":{"primary_key":false,"data_type":"date","column_name":"LASTMODIFIEDDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"lastmodifieddate","parent":"columns"},{"control_type":"text","label":"LASTMODIFIEDBYID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LASTMODIFIEDBYID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"lastmodifiedbyid","parent":"columns"},{"control_type":"text","label":"SYSTEMMODSTAMP","details":{"primary_key":false,"data_type":"date","column_name":"SYSTEMMODSTAMP","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"systemmodstamp","parent":"columns"},{"control_type":"text","label":"LASTVIEWEDDATE","details":{"primary_key":false,"data_type":"date","column_name":"LASTVIEWEDDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"lastvieweddate","parent":"columns"},{"control_type":"text","label":"LASTREFERENCEDDATE","details":{"primary_key":false,"data_type":"date","column_name":"LASTREFERENCEDDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"lastreferenceddate","parent":"columns"},{"control_type":"text","label":"CONNECTIONRECEIVEDID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONNECTIONRECEIVEDID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"connectionreceivedid","parent":"columns"},{"control_type":"text","label":"CONNECTIONSENTID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONNECTIONSENTID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"connectionsentid","parent":"columns"},{"control_type":"text","label":"CASE_SUB_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CASE_SUB_TYPE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"case_sub_type__c","parent":"columns"},{"control_type":"text","label":"SERIAL_2__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SERIAL_2__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"serial_2__c","parent":"columns"},{"control_type":"text","label":"WEB_ADDRESS_LINE_1__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_ADDRESS_LINE_1__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"web_address_line_1__c","parent":"columns"},{"control_type":"text","label":"WEB_ADDRESS_LINE_2__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_ADDRESS_LINE_2__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"web_address_line_2__c","parent":"columns"},{"control_type":"text","label":"WEB_CITY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_CITY__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_city__c","parent":"columns"},{"control_type":"text","label":"WEB_COMPANY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_COMPANY__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_company__c","parent":"columns"},{"control_type":"text","label":"WEB_COUNTRY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_COUNTRY__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_country__c","parent":"columns"},{"control_type":"text","label":"WEB_EMAIL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_EMAIL__C","length":80,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 80","type":"string","name":"web_email__c","parent":"columns"},{"control_type":"text","label":"WEB_FIRST_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_FIRST_NAME__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_first_name__c","parent":"columns"},{"control_type":"text","label":"WEB_LAST_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_LAST_NAME__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_last_name__c","parent":"columns"},{"control_type":"text","label":"WEB_STATE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_STATE__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_state__c","parent":"columns"},{"control_type":"text","label":"WEB_TELEPHONE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_TELEPHONE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"web_telephone__c","parent":"columns"},{"control_type":"text","label":"WEB_ZIP_POSTAL_CODE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_ZIP_POSTAL_CODE__C","length":16,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 16","type":"string","name":"web_zip_postal_code__c","parent":"columns"},{"control_type":"text","label":"YOUR_ROLE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"YOUR_ROLE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"your_role__c","parent":"columns"},{"control_type":"integer","label":"ACTUAL_RESOLUTION_TIME_IN_MINU","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ACTUAL_RESOLUTION_TIME_IN_MINU","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"actual_resolution_time_in_minu","parent":"columns"},{"control_type":"text","label":"ACTUAL_RESOLUTION_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"ACTUAL_RESOLUTION_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"actual_resolution_time__c","parent":"columns"},{"control_type":"integer","label":"ACTUAL_RESPONSE_TIME_IN_MINUTE","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ACTUAL_RESPONSE_TIME_IN_MINUTE","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"actual_response_time_in_minute","parent":"columns"},{"control_type":"text","label":"ACTUAL_RESPONSE_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"ACTUAL_RESPONSE_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"actual_response_time__c","parent":"columns"},{"control_type":"integer","label":"ACTUAL_RESTORATION_TIME_IN_MIN","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ACTUAL_RESTORATION_TIME_IN_MIN","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"actual_restoration_time_in_min","parent":"columns"},{"control_type":"text","label":"ACTUAL_RESTORATION_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"ACTUAL_RESTORATION_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"actual_restoration_time__c","parent":"columns"},{"control_type":"integer","label":"AFTER_HOURS_TECH_SUPPORT__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"AFTER_HOURS_TECH_SUPPORT__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"after_hours_tech_support__c","parent":"columns"},{"control_type":"text","label":"ASSET_SERIAL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ASSET_SERIAL__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"asset_serial__c","parent":"columns"},{"control_type":"text","label":"ASSET__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ASSET__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"asset__c","parent":"columns"},{"control_type":"text","label":"BILLING_CITY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"BILLING_CITY__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"billing_city__c","parent":"columns"},{"control_type":"text","label":"BUSINESS_UNITL4__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"BUSINESS_UNITL4__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"business_unitl4__c","parent":"columns"},{"control_type":"text","label":"BUSINESS_UNIT_L4__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"BUSINESS_UNIT_L4__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"business_unit_l4__c","parent":"columns"},{"control_type":"text","label":"CPAR__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CPAR__C","length":10,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 10","type":"string","name":"cpar__c","parent":"columns"},{"control_type":"text","label":"CR_STATUS_FIXED_IN_VALUES__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CR_STATUS_FIXED_IN_VALUES__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"cr_status_fixed_in_values__c","parent":"columns"},{"control_type":"text","label":"CR_VALUES__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CR_VALUES__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"cr_values__c","parent":"columns"},{"control_type":"text","label":"CALIBRATION_SERVICE_2__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CALIBRATION_SERVICE_2__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"calibration_service_2__c","parent":"columns"},{"control_type":"text","label":"CALIBRATION_SERVICE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CALIBRATION_SERVICE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"calibration_service__c","parent":"columns"},{"control_type":"number","label":"CASE_AGE_TRACKING__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"CASE_AGE_TRACKING__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"case_age_tracking__c","parent":"columns"},{"control_type":"integer","label":"CASE_AGE__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"CASE_AGE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"case_age__c","parent":"columns"},{"control_type":"integer","label":"CASE_CLOSE_CHECK__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"CASE_CLOSE_CHECK__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"case_close_check__c","parent":"columns"},{"control_type":"text","label":"CASE_CLOSURE_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"CASE_CLOSURE_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"case_closure_time__c","parent":"columns"},{"control_type":"text","label":"CASE_CREATION_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"CASE_CREATION_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"case_creation_date__c","parent":"columns"},{"control_type":"text","label":"CASE_CREATION_DATE_DEL__C","details":{"primary_key":false,"data_type":"date","column_name":"CASE_CREATION_DATE_DEL__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"case_creation_date_del__c","parent":"columns"},{"control_type":"text","label":"CASE_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CASE_NAME__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"case_name__c","parent":"columns"},{"control_type":"text","label":"CASE_TYPE_DETAIL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CASE_TYPE_DETAIL__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"case_type_detail__c","parent":"columns"},{"control_type":"text","label":"CASE_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CASE_TYPE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"case_type__c","parent":"columns"},{"control_type":"text","label":"CATALOG_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CATALOG_NUMBER__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"catalog_number__c","parent":"columns"},{"control_type":"integer","label":"COMMITMENT_SLA__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"COMMITMENT_SLA__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"commitment_sla__c","parent":"columns"},{"control_type":"text","label":"COMPANY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"COMPANY__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"company__c","parent":"columns"},{"control_type":"text","label":"COMPONENT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"COMPONENT__C","length":250,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 250","type":"string","name":"component__c","parent":"columns"},{"control_type":"text","label":"CONDITION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONDITION__C","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"condition__c","parent":"columns"},{"control_type":"text","label":"COVERAGE_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"COVERAGE_TYPE__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"coverage_type__c","parent":"columns"},{"control_type":"text","label":"CURRENT_QUEUE_IN_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"CURRENT_QUEUE_IN_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"current_queue_in_datetime__c","parent":"columns"},{"control_type":"text","label":"CURRENT_QUEUE_TIME_FORMAT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CURRENT_QUEUE_TIME_FORMAT__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"current_queue_time_format__c","parent":"columns"},{"control_type":"text","label":"CURRENT_QUEUE_TIME_NOTIFICATIO","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CURRENT_QUEUE_TIME_NOTIFICATIO","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"current_queue_time_notificatio","parent":"columns"},{"control_type":"text","label":"CURRENT_QUEUE_TIME_TRACK_ON_CA","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CURRENT_QUEUE_TIME_TRACK_ON_CA","length":20,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 20","type":"string","name":"current_queue_time_track_on_ca","parent":"columns"},{"control_type":"number","label":"CURRENT_QUEUE_TIME__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"CURRENT_QUEUE_TIME__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"current_queue_time__c","parent":"columns"},{"control_type":"text","label":"CUSTOMER_CASE_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"CUSTOMER_CASE_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"customer_case_time__c","parent":"columns"},{"control_type":"text","label":"CUSTOMER_IMPACT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CUSTOMER_IMPACT__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"customer_impact__c","parent":"columns"},{"control_type":"text","label":"CUSTOMER_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CUSTOMER_NUMBER__C","length":20,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 20","type":"string","name":"customer_number__c","parent":"columns"},{"control_type":"text","label":"CUSTOMER_TIME_IN_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"CUSTOMER_TIME_IN_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"customer_time_in_datetime__c","parent":"columns"},{"control_type":"text","label":"CUSTOMER_TIME_OUT_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"CUSTOMER_TIME_OUT_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"customer_time_out_datetime__c","parent":"columns"},{"control_type":"number","label":"CUSTOMER_TIME_TRACKING__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"CUSTOMER_TIME_TRACKING__C","length":0,"precision":18,"scale":5},"optional":true,"hint":"number","type":"number","name":"customer_time_tracking__c","parent":"columns"},{"control_type":"text","label":"CUSTOMER_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CUSTOMER_TIME__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"customer_time__c","parent":"columns"},{"control_type":"text","label":"DATE_FIX_RELEASED__C","details":{"primary_key":false,"data_type":"date","column_name":"DATE_FIX_RELEASED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"date_fix_released__c","parent":"columns"},{"control_type":"integer","label":"DO_NOT_EMAIL__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"DO_NOT_EMAIL__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"do_not_email__c","parent":"columns"},{"control_type":"integer","label":"EMAIL_24X7__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"EMAIL_24X7__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"email_24x7__c","parent":"columns"},{"control_type":"text","label":"END_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"END_TIME__C","length":8,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 8","type":"string","name":"end_time__c","parent":"columns"},{"control_type":"integer","label":"ENTITLEMENT_VERIFIED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ENTITLEMENT_VERIFIED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"entitlement_verified__c","parent":"columns"},{"control_type":"text","label":"ENTITLEMENT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ENTITLEMENT__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"entitlement__c","parent":"columns"},{"control_type":"text","label":"ESCALATED_ICON__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ESCALATED_ICON__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"escalated_icon__c","parent":"columns"},{"control_type":"integer","label":"ESCALATED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ESCALATED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"escalated__c","parent":"columns"},{"control_type":"integer","label":"ESCALATION_FLAG__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ESCALATION_FLAG__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"escalation_flag__c","parent":"columns"},{"control_type":"text","label":"ESCALATION_MANAGER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ESCALATION_MANAGER__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"escalation_manager__c","parent":"columns"},{"control_type":"text","label":"ESCALATION_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ESCALATION_TYPE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"escalation_type__c","parent":"columns"},{"control_type":"integer","label":"FEEBACK_REQUESTED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"FEEBACK_REQUESTED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"feeback_requested__c","parent":"columns"},{"control_type":"integer","label":"FIRST_CALL_RESOLUTION__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"FIRST_CALL_RESOLUTION__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"first_call_resolution__c","parent":"columns"},{"control_type":"text","label":"FIX_RESPONSE_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"FIX_RESPONSE_TIME__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"fix_response_time__c","parent":"columns"},{"control_type":"integer","label":"FIX_ALREADY_AVAILABLE__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"FIX_ALREADY_AVAILABLE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"fix_already_available__c","parent":"columns"},{"control_type":"text","label":"FOLLOW_UP_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"FOLLOW_UP_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"follow_up_date__c","parent":"columns"},{"control_type":"text","label":"FREEZE_RESOLUTION_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"FREEZE_RESOLUTION_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"freeze_resolution_time__c","parent":"columns"},{"control_type":"text","label":"FREEZE_RESPONSE_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"FREEZE_RESPONSE_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"freeze_response_time__c","parent":"columns"},{"control_type":"text","label":"FREEZE_RESTORATION_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"FREEZE_RESTORATION_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"freeze_restoration_time__c","parent":"columns"},{"control_type":"integer","label":"FUTUREMETHODCALLED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"FUTUREMETHODCALLED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"futuremethodcalled__c","parent":"columns"},{"control_type":"text","label":"GMT_OFFSET__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"GMT_OFFSET__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"gmt_offset__c","parent":"columns"},{"control_type":"text","label":"HOT_FIX_TIMESTAMP__C","details":{"primary_key":false,"data_type":"date","column_name":"HOT_FIX_TIMESTAMP__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"hot_fix_timestamp__c","parent":"columns"},{"control_type":"text","label":"HARDWARE_VERSION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"HARDWARE_VERSION__C","length":250,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 250","type":"string","name":"hardware_version__c","parent":"columns"},{"control_type":"integer","label":"HOT_CASE__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"HOT_CASE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"hot_case__c","parent":"columns"},{"control_type":"text","label":"HOT_FIX_DETAIL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"HOT_FIX_DETAIL__C","length":100,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 100","type":"string","name":"hot_fix_detail__c","parent":"columns"},{"control_type":"integer","label":"HOT_FIX_FLAG__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"HOT_FIX_FLAG__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"hot_fix_flag__c","parent":"columns"},{"control_type":"text","label":"INSTANCE_ID__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"INSTANCE_ID__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"instance_id__c","parent":"columns"},{"control_type":"text","label":"INSTANCE_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"INSTANCE_NUMBER__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"instance_number__c","parent":"columns"},{"control_type":"integer","label":"INTERNAL_CASE__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"INTERNAL_CASE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"internal_case__c","parent":"columns"},{"control_type":"integer","label":"IS_REQUEST_VIOLATED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"IS_REQUEST_VIOLATED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"is_request_violated__c","parent":"columns"},{"control_type":"integer","label":"IS_RESOLUTION_VIOLATED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"IS_RESOLUTION_VIOLATED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"is_resolution_violated__c","parent":"columns"},{"control_type":"integer","label":"IS_RESPONSE_VIOLATED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"IS_RESPONSE_VIOLATED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"is_response_violated__c","parent":"columns"},{"control_type":"integer","label":"IS_RESTORATION_VIOLATED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"IS_RESTORATION_VIOLATED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"is_restoration_violated__c","parent":"columns"},{"control_type":"text","label":"JDSU_TIME_IN_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"JDSU_TIME_IN_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"jdsu_time_in_datetime__c","parent":"columns"},{"control_type":"text","label":"JDSU_TIME_OUT_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"JDSU_TIME_OUT_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"jdsu_time_out_datetime__c","parent":"columns"},{"control_type":"text","label":"JDSU_TIME_TEMP__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"JDSU_TIME_TEMP__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"jdsu_time_temp__c","parent":"columns"},{"control_type":"number","label":"JDSU_TIME_TRACKING__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"JDSU_TIME_TRACKING__C","length":0,"precision":18,"scale":5},"optional":true,"hint":"number","type":"number","name":"jdsu_time_tracking__c","parent":"columns"},{"control_type":"text","label":"JDSU_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"JDSU_TIME__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"jdsu_time__c","parent":"columns"},{"control_type":"number","label":"JDSU_TIME_MINS__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"JDSU_TIME_MINS__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"jdsu_time_mins__c","parent":"columns"},{"control_type":"text","label":"JIRA_ISSUE_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"JIRA_ISSUE_NUMBER__C","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"jira_issue_number__c","parent":"columns"},{"control_type":"text","label":"JIRA_PROJECTS__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"JIRA_PROJECTS__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"jira_projects__c","parent":"columns"},{"control_type":"text","label":"JIRA_SERIAL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"JIRA_SERIAL__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"jira_serial__c","parent":"columns"},{"control_type":"text","label":"JIRA_TICKET_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"JIRA_TICKET_OWNER__C","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"jira_ticket_owner__c","parent":"columns"},{"control_type":"text","label":"JIRA_TICKET_STATUS__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"JIRA_TICKET_STATUS__C","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"jira_ticket_status__c","parent":"columns"},{"control_type":"text","label":"JOB_TITLE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"JOB_TITLE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"job_title__c","parent":"columns"},{"control_type":"text","label":"LAST_MODIFIED_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"LAST_MODIFIED_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"last_modified_date__c","parent":"columns"},{"control_type":"text","label":"LEGACY_ACTUAL_RESOLUTION_TIME_","details":{"primary_key":false,"data_type":"date","column_name":"LEGACY_ACTUAL_RESOLUTION_TIME_","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"legacy_actual_resolution_time_","parent":"columns"},{"control_type":"text","label":"LEGACY_ACTUAL_RESPONSE_TIME_IN","details":{"primary_key":false,"data_type":"date","column_name":"LEGACY_ACTUAL_RESPONSE_TIME_IN","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"legacy_actual_response_time_in","parent":"columns"},{"control_type":"text","label":"LEGACY_ACTUAL_RESTORATION_TIME","details":{"primary_key":false,"data_type":"date","column_name":"LEGACY_ACTUAL_RESTORATION_TIME","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"legacy_actual_restoration_time","parent":"columns"},{"control_type":"text","label":"LEGACY_CONTACT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEGACY_CONTACT__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"legacy_contact__c","parent":"columns"},{"control_type":"text","label":"LEGACY_CUSTOMER_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEGACY_CUSTOMER_TIME__C","length":128,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 128","type":"string","name":"legacy_customer_time__c","parent":"columns"},{"control_type":"text","label":"LEGACY_ID__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEGACY_ID__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"legacy_id__c","parent":"columns"},{"control_type":"text","label":"LEGACY_JDSU_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEGACY_JDSU_TIME__C","length":128,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 128","type":"string","name":"legacy_jdsu_time__c","parent":"columns"},{"control_type":"integer","label":"LEGACY_MAJOR_SLA_RESOLUTION_TI","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"LEGACY_MAJOR_SLA_RESOLUTION_TI","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"legacy_major_sla_resolution_ti","parent":"columns"},{"control_type":"integer","label":"LEGACY_MAJOR_SLA_RESTORATION_T","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"LEGACY_MAJOR_SLA_RESTORATION_T","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"legacy_major_sla_restoration_t","parent":"columns"},{"control_type":"integer","label":"LEGACY_MINOR_SLA_RESOLUTION_TI","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"LEGACY_MINOR_SLA_RESOLUTION_TI","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"legacy_minor_sla_resolution_ti","parent":"columns"},{"control_type":"integer","label":"LEGACY_MINOR_SLA_RESTORATION_T","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"LEGACY_MINOR_SLA_RESTORATION_T","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"legacy_minor_sla_restoration_t","parent":"columns"},{"control_type":"text","label":"LEGACY_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEGACY_OWNER__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"legacy_owner__c","parent":"columns"},{"control_type":"integer","label":"LEGACY_SLA_RESPONSE_TIME__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"LEGACY_SLA_RESPONSE_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"legacy_sla_response_time__c","parent":"columns"},{"control_type":"text","label":"LEGACY_SYSTEM_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEGACY_SYSTEM_NAME__C","length":100,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 100","type":"string","name":"legacy_system_name__c","parent":"columns"},{"control_type":"text","label":"LEVEL_1_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEVEL_1_OWNER__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"level_1_owner__c","parent":"columns"},{"control_type":"text","label":"LEVEL_2_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEVEL_2_OWNER__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"level_2_owner__c","parent":"columns"},{"control_type":"text","label":"LEVEL_3_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LEVEL_3_OWNER__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"level_3_owner__c","parent":"columns"},{"control_type":"text","label":"NSE_CLOSE_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"NSE_CLOSE_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"nse_close_date__c","parent":"columns"},{"control_type":"number","label":"OLD_TIME_IN_OPEN_CONDITION__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"OLD_TIME_IN_OPEN_CONDITION__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"old_time_in_open_condition__c","parent":"columns"},{"control_type":"number","label":"OLD_CUSTOMER_TIME__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"OLD_CUSTOMER_TIME__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"old_customer_time__c","parent":"columns"},{"control_type":"number","label":"OLD_JDSU_TIME__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"OLD_JDSU_TIME__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"old_jdsu_time__c","parent":"columns"},{"control_type":"number","label":"OLD_TIME_IN_ESCALATED_CONDITIO","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"OLD_TIME_IN_ESCALATED_CONDITIO","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"old_time_in_escalated_conditio","parent":"columns"},{"control_type":"number","label":"OLD_TIME_IN_WAITING_FOR_CUSTOM","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"OLD_TIME_IN_WAITING_FOR_CUSTOM","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"old_time_in_waiting_for_custom","parent":"columns"},{"control_type":"text","label":"ORIG_PURCHASE_ORDER_NUMBER_2__","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ORIG_PURCHASE_ORDER_NUMBER_2__","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"orig_purchase_order_number_2__","parent":"columns"},{"control_type":"text","label":"ORIG_PURCHASE_ORDER_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ORIG_PURCHASE_ORDER_NUMBER__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"orig_purchase_order_number__c","parent":"columns"},{"control_type":"text","label":"ORIG_SALES_ORDER_NUMBER_2__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ORIG_SALES_ORDER_NUMBER_2__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"orig_sales_order_number_2__c","parent":"columns"},{"control_type":"text","label":"ORIG_SALES_ORDER_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ORIG_SALES_ORDER_NUMBER__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"orig_sales_order_number__c","parent":"columns"},{"control_type":"text","label":"ORIGINAL_ORDER_SHIP_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"ORIGINAL_ORDER_SHIP_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"original_order_ship_date__c","parent":"columns"},{"control_type":"text","label":"ORIGINAL_SO__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ORIGINAL_SO__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"original_so__c","parent":"columns"},{"control_type":"text","label":"ORIGINATION_C__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ORIGINATION_C__C","length":60,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 60","type":"string","name":"origination_c__c","parent":"columns"},{"control_type":"text","label":"PO_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PO_NUMBER__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"po_number__c","parent":"columns"},{"control_type":"text","label":"PREVIOUS_CASE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PREVIOUS_CASE__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"previous_case__c","parent":"columns"},{"control_type":"text","label":"PRODUCT_CATEGORYL5__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_CATEGORYL5__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"product_categoryl5__c","parent":"columns"},{"control_type":"text","label":"PRODUCT_CATEGORY_L5__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_CATEGORY_L5__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"product_category_l5__c","parent":"columns"},{"control_type":"text","label":"PRODUCT_DETAIL_L8_OLD__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_DETAIL_L8_OLD__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"product_detail_l8_old__c","parent":"columns"},{"control_type":"text","label":"PRODUCT_DETAIL_L8__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_DETAIL_L8__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"product_detail_l8__c","parent":"columns"},{"control_type":"text","label":"PRODUCT_FAMILY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_FAMILY__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"product_family__c","parent":"columns"},{"control_type":"text","label":"PRODUCT_LINE_IDENTIFICATIONL4_","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_LINE_IDENTIFICATIONL4_","length":100,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 100","type":"string","name":"product_line_identificationl4_","parent":"columns"},{"control_type":"text","label":"PRODUCT_LINE_IDENTIFICATIONL5_","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_LINE_IDENTIFICATIONL5_","length":100,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 100","type":"string","name":"product_line_identificationl5_","parent":"columns"},{"control_type":"text","label":"PRODUCT_LINE_IDENTIFICATIONL8_","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_LINE_IDENTIFICATIONL8_","length":100,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 100","type":"string","name":"product_line_identificationl8_","parent":"columns"},{"control_type":"text","label":"PRODUCT_LINE_L5__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_LINE_L5__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"product_line_l5__c","parent":"columns"},{"control_type":"text","label":"PRODUCT_MODEL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_MODEL__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"product_model__c","parent":"columns"},{"control_type":"text","label":"PRODUCT_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_NUMBER__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"product_number__c","parent":"columns"},{"control_type":"text","label":"PRODUCT_SERIAL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_SERIAL__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"product_serial__c","parent":"columns"},{"control_type":"text","label":"PRODUCT_SUBTYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_SUBTYPE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"product_subtype__c","parent":"columns"},{"control_type":"text","label":"PRODUCT_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_TYPE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"product_type__c","parent":"columns"},{"control_type":"text","label":"QIN__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"QIN__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"qin__c","parent":"columns"},{"control_type":"text","label":"RMA__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RMA__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"rma__c","parent":"columns"},{"control_type":"text","label":"REGION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"REGION__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"region__c","parent":"columns"},{"control_type":"text","label":"REGION_ARCHIVE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"REGION_ARCHIVE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"region_archive__c","parent":"columns"},{"control_type":"text","label":"REQUEST_INFORMATION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"REQUEST_INFORMATION__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"request_information__c","parent":"columns"},{"control_type":"text","label":"REQUEST_TYPE_2__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"REQUEST_TYPE_2__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"request_type_2__c","parent":"columns"},{"control_type":"text","label":"REQUEST_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"REQUEST_TYPE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"request_type__c","parent":"columns"},{"control_type":"text","label":"RESOLUTION_COMMENT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RESOLUTION_COMMENT__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"resolution_comment__c","parent":"columns"},{"control_type":"text","label":"RESOLUTION_INTIME__C","details":{"primary_key":false,"data_type":"date","column_name":"RESOLUTION_INTIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"resolution_intime__c","parent":"columns"},{"control_type":"integer","label":"RESOLUTION_TIME_SLA__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"RESOLUTION_TIME_SLA__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"resolution_time_sla__c","parent":"columns"},{"control_type":"number","label":"RESOLUTION_TIME__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"RESOLUTION_TIME__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"resolution_time__c","parent":"columns"},{"control_type":"text","label":"RESOLUTION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RESOLUTION__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"resolution__c","parent":"columns"},{"control_type":"integer","label":"RESPONSE_TIME_SLA__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"RESPONSE_TIME_SLA__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"response_time_sla__c","parent":"columns"},{"control_type":"text","label":"RESPONSE_TIME_MINS__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RESPONSE_TIME_MINS__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"response_time_mins__c","parent":"columns"},{"control_type":"number","label":"RESTORATION_TIME_HOURS__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"RESTORATION_TIME_HOURS__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"restoration_time_hours__c","parent":"columns"},{"control_type":"integer","label":"RESTORATION_TIME_SLA__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"RESTORATION_TIME_SLA__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"restoration_time_sla__c","parent":"columns"},{"control_type":"text","label":"RESTORATION_TIME_MINS__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RESTORATION_TIME_MINS__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"restoration_time_mins__c","parent":"columns"},{"control_type":"text","label":"RETURNING_MODEL_NUMBER_2__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RETURNING_MODEL_NUMBER_2__C","length":16,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 16","type":"string","name":"returning_model_number_2__c","parent":"columns"},{"control_type":"text","label":"RETURNING_MODEL_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RETURNING_MODEL_NUMBER__C","length":16,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 16","type":"string","name":"returning_model_number__c","parent":"columns"},{"control_type":"text","label":"ROOT_CAUSE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ROOT_CAUSE__C","length":60,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 60","type":"string","name":"root_cause__c","parent":"columns"},{"control_type":"text","label":"SLA_LEVEL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SLA_LEVEL__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"sla_level__c","parent":"columns"},{"control_type":"text","label":"SLA_RESOLUTION_TIME_DAYS__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SLA_RESOLUTION_TIME_DAYS__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"sla_resolution_time_days__c","parent":"columns"},{"control_type":"text","label":"SLA_RESPONSE_TIME_HOURS__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SLA_RESPONSE_TIME_HOURS__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"sla_response_time_hours__c","parent":"columns"},{"control_type":"text","label":"SLA_RESTORATION_TIME_DAYS__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SLA_RESTORATION_TIME_DAYS__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"sla_restoration_time_days__c","parent":"columns"},{"control_type":"text","label":"SLA_SUMMARY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SLA_SUMMARY__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"sla_summary__c","parent":"columns"},{"control_type":"text","label":"SO_RELATED_TO_THIS_TICKET__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SO_RELATED_TO_THIS_TICKET__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"so_related_to_this_ticket__c","parent":"columns"},{"control_type":"text","label":"SR_UNIT_RECEIPT_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"SR_UNIT_RECEIPT_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"sr_unit_receipt_date__c","parent":"columns"},{"control_type":"text","label":"SEND_SURVEY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SEND_SURVEY__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"send_survey__c","parent":"columns"},{"control_type":"text","label":"SEND_TO_ENGINEERING_MAJOR__C","details":{"primary_key":false,"data_type":"date","column_name":"SEND_TO_ENGINEERING_MAJOR__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"send_to_engineering_major__c","parent":"columns"},{"control_type":"text","label":"SEND_TO_ENGINEERING_MINOR__C","details":{"primary_key":false,"data_type":"date","column_name":"SEND_TO_ENGINEERING_MINOR__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"send_to_engineering_minor__c","parent":"columns"},{"control_type":"text","label":"SERIAL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SERIAL__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"serial__c","parent":"columns"},{"control_type":"number","label":"SEVERITY_HOURS__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"SEVERITY_HOURS__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"severity_hours__c","parent":"columns"},{"control_type":"text","label":"SEVERITY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SEVERITY__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"severity__c","parent":"columns"},{"control_type":"text","label":"SOFTWARE_VERSION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SOFTWARE_VERSION__C","length":250,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 250","type":"string","name":"software_version__c","parent":"columns"},{"control_type":"text","label":"SOLUTION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SOLUTION__C","length":1000,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1000","type":"string","name":"solution__c","parent":"columns"},{"control_type":"text","label":"START_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"START_TIME__C","length":8,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 8","type":"string","name":"start_time__c","parent":"columns"},{"control_type":"integer","label":"STOP_QUEUE_EMAIL_NOTIFICATION_","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"STOP_QUEUE_EMAIL_NOTIFICATION_","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"stop_queue_email_notification_","parent":"columns"},{"control_type":"text","label":"SUMMARY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SUMMARY__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"summary__c","parent":"columns"},{"control_type":"text","label":"SYSTEM_DESCRIPTION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SYSTEM_DESCRIPTION__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"system_description__c","parent":"columns"},{"control_type":"text","label":"SYSTEM_HANDLE_C__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SYSTEM_HANDLE_C__C","length":60,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 60","type":"string","name":"system_handle_c__c","parent":"columns"},{"control_type":"text","label":"SYSTEM_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SYSTEM_NAME__C","length":100,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 100","type":"string","name":"system_name__c","parent":"columns"},{"control_type":"text","label":"SYSTEM_NUMBER_HANDLE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SYSTEM_NUMBER_HANDLE__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"system_number_handle__c","parent":"columns"},{"control_type":"text","label":"TL9000_FRT_DEFERRED_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"TL9000_FRT_DEFERRED_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"tl9000_frt_deferred_date__c","parent":"columns"},{"control_type":"integer","label":"TL9000_PROBLEM_RECURRENCE__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"TL9000_PROBLEM_RECURRENCE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"tl9000_problem_recurrence__c","parent":"columns"},{"control_type":"integer","label":"TL9000_SFQ_DFC_COUNT__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"TL9000_SFQ_DFC_COUNT__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"tl9000_sfq_dfc_count__c","parent":"columns"},{"control_type":"integer","label":"TL9000_SFQ_DFC__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"TL9000_SFQ_DFC__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"tl9000_sfq_dfc__c","parent":"columns"},{"control_type":"integer","label":"TL9000_SQ_FLAG__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"TL9000_SQ_FLAG__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"tl9000_sq_flag__c","parent":"columns"},{"control_type":"text","label":"TL9000_SEVERITY_LEVEL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TL9000_SEVERITY_LEVEL__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"tl9000_severity_level__c","parent":"columns"},{"control_type":"text","label":"TARGET_RESOLUTION_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"TARGET_RESOLUTION_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"target_resolution_time__c","parent":"columns"},{"control_type":"text","label":"TARGET_RESPONSE_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"TARGET_RESPONSE_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"target_response_time__c","parent":"columns"},{"control_type":"text","label":"TARGET_RESTORATION_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"TARGET_RESTORATION_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"target_restoration_time__c","parent":"columns"},{"control_type":"integer","label":"TIME_ELAPSED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"TIME_ELAPSED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"time_elapsed__c","parent":"columns"},{"control_type":"text","label":"TIME_IN_ESCALATED_CONDITION_FO","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TIME_IN_ESCALATED_CONDITION_FO","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"time_in_escalated_condition_fo","parent":"columns"},{"control_type":"number","label":"TIME_IN_ESCALATED_CONDITION__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"TIME_IN_ESCALATED_CONDITION__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"time_in_escalated_condition__c","parent":"columns"},{"control_type":"text","label":"TIME_IN_ESCALATED_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"TIME_IN_ESCALATED_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"time_in_escalated_datetime__c","parent":"columns"},{"control_type":"text","label":"TIME_IN_OPEN_CONDITION_FORMAT_","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TIME_IN_OPEN_CONDITION_FORMAT_","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"time_in_open_condition_format_","parent":"columns"},{"control_type":"number","label":"TIME_IN_OPEN_CONDITION__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"TIME_IN_OPEN_CONDITION__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"time_in_open_condition__c","parent":"columns"},{"control_type":"text","label":"TIME_IN_OPEN_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"TIME_IN_OPEN_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"time_in_open_datetime__c","parent":"columns"},{"control_type":"text","label":"TIME_IN_WAITINGFORCUSTOMER_DAT","details":{"primary_key":false,"data_type":"date","column_name":"TIME_IN_WAITINGFORCUSTOMER_DAT","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"time_in_waitingforcustomer_dat","parent":"columns"},{"control_type":"text","label":"TIME_IN_WAITING_FOR_CUSTOMER_F","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TIME_IN_WAITING_FOR_CUSTOMER_F","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"time_in_waiting_for_customer_f","parent":"columns"},{"control_type":"number","label":"TIME_IN_WAITING_FOR_CUSTOMER__","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"TIME_IN_WAITING_FOR_CUSTOMER__","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"time_in_waiting_for_customer__","parent":"columns"},{"control_type":"text","label":"TIME_OUT_ESCALATED_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"TIME_OUT_ESCALATED_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"time_out_escalated_datetime__c","parent":"columns"},{"control_type":"text","label":"TIME_OUT_OPEN_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"TIME_OUT_OPEN_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"time_out_open_datetime__c","parent":"columns"},{"control_type":"text","label":"TIME_OUT_WAITINGFORCUSTOMER_DA","details":{"primary_key":false,"data_type":"date","column_name":"TIME_OUT_WAITINGFORCUSTOMER_DA","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"time_out_waitingforcustomer_da","parent":"columns"},{"control_type":"text","label":"TIME_ZONE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TIME_ZONE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"time_zone__c","parent":"columns"},{"control_type":"text","label":"TODAY_S_DATE_5_BUSINESS__C","details":{"primary_key":false,"data_type":"date","column_name":"TODAY_S_DATE_5_BUSINESS__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"today_s_date_5_business__c","parent":"columns"},{"control_type":"text","label":"TODAY_S_DATE_5__C","details":{"primary_key":false,"data_type":"date","column_name":"TODAY_S_DATE_5__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"today_s_date_5__c","parent":"columns"},{"control_type":"text","label":"TOTAL_CASE_OPEN_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TOTAL_CASE_OPEN_TIME__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"total_case_open_time__c","parent":"columns"},{"control_type":"text","label":"TOTAL_CASE_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TOTAL_CASE_TIME__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"total_case_time__c","parent":"columns"},{"control_type":"text","label":"TOTAL_OUTAGE_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TOTAL_OUTAGE_TIME__C","length":14,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 14","type":"string","name":"total_outage_time__c","parent":"columns"},{"control_type":"integer","label":"TOTAL_SYSTEM_ELEMENTS__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"TOTAL_SYSTEM_ELEMENTS__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"total_system_elements__c","parent":"columns"},{"control_type":"text","label":"USER_CONTACT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"USER_CONTACT__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"user_contact__c","parent":"columns"},{"control_type":"text","label":"WEB_YOUR_TITLE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_YOUR_TITLE__C","length":200,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 200","type":"string","name":"web_your_title__c","parent":"columns"},{"control_type":"text","label":"WORK_GROUP__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WORK_GROUP__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"work_group__c","parent":"columns"},{"control_type":"text","label":"X5_BUSINESS_DAYS_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"X5_BUSINESS_DAYS_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"x5_business_days_date__c","parent":"columns"},{"control_type":"integer","label":"X8X5_EMAIL__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"X8X5_EMAIL__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"x8x5_email__c","parent":"columns"},{"control_type":"number","label":"CUSTOMER_TIME_TRACKING_TEMP__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"CUSTOMER_TIME_TRACKING_TEMP__C","length":0,"precision":18,"scale":5},"optional":true,"hint":"number","type":"number","name":"customer_time_tracking_temp__c","parent":"columns"},{"control_type":"number","label":"JDSU_TIME_TRACKING_TEMP__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"JDSU_TIME_TRACKING_TEMP__C","length":0,"precision":18,"scale":5},"optional":true,"hint":"number","type":"number","name":"jdsu_time_tracking_temp__c","parent":"columns"},{"control_type":"text","label":"LEVEL_1_RESPONSE__C","details":{"primary_key":false,"data_type":"date","column_name":"LEVEL_1_RESPONSE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"level_1_response__c","parent":"columns"},{"control_type":"text","label":"RESOLUTION_TIME_MANUAL__C","details":{"primary_key":false,"data_type":"date","column_name":"RESOLUTION_TIME_MANUAL__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"resolution_time_manual__c","parent":"columns"},{"control_type":"text","label":"RESTORATION_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"RESTORATION_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"restoration_time__c","parent":"columns"},{"control_type":"integer","label":"SURVEY_EMAIL_SEND_TO_CONTACT__","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"SURVEY_EMAIL_SEND_TO_CONTACT__","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"survey_email_send_to_contact__","parent":"columns"},{"control_type":"text","label":"CHATTER_TEXT_BY_CUSTOMER__C","details":{"primary_key":false,"data_type":"nclob","column_name":"CHATTER_TEXT_BY_CUSTOMER__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"chatter_text_by_customer__c","parent":"columns"},{"control_type":"integer","label":"SEND_CHATTER_EMAIL_TO_CASE_OWN","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"SEND_CHATTER_EMAIL_TO_CASE_OWN","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"send_chatter_email_to_case_own","parent":"columns"},{"control_type":"text","label":"SYSTEM_HANDLE_REGION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SYSTEM_HANDLE_REGION__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"system_handle_region__c","parent":"columns"},{"control_type":"text","label":"RELATED_ID__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RELATED_ID__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"related_id__c","parent":"columns"},{"control_type":"text","label":"SENDEMAIL_DISCRIPTION__C","details":{"primary_key":false,"data_type":"nclob","column_name":"SENDEMAIL_DISCRIPTION__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"sendemail_discription__c","parent":"columns"},{"control_type":"text","label":"SENDEMAIL_SUBJECT__C","details":{"primary_key":false,"data_type":"nclob","column_name":"SENDEMAIL_SUBJECT__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"sendemail_subject__c","parent":"columns"},{"control_type":"integer","label":"SENDEMAIL__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"SENDEMAIL__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"sendemail__c","parent":"columns"},{"control_type":"number","label":"RESPONSE_TIME_SUMMARY__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"RESPONSE_TIME_SUMMARY__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"response_time_summary__c","parent":"columns"},{"control_type":"text","label":"ACTION_PLAN__C","details":{"primary_key":false,"data_type":"nclob","column_name":"ACTION_PLAN__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"action_plan__c","parent":"columns"},{"control_type":"text","label":"ARIESO_CASE_ID__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ARIESO_CASE_ID__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"arieso_case_id__c","parent":"columns"},{"control_type":"text","label":"CLOSED_BY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CLOSED_BY__C","length":100,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 100","type":"string","name":"closed_by__c","parent":"columns"},{"control_type":"text","label":"DATE_RETURNED_FROM_3RD_LINE__C","details":{"primary_key":false,"data_type":"date","column_name":"DATE_RETURNED_FROM_3RD_LINE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"date_returned_from_3rd_line__c","parent":"columns"},{"control_type":"integer","label":"DEVELOPMENT_REFERENCE_CHK__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"DEVELOPMENT_REFERENCE_CHK__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"development_reference_chk__c","parent":"columns"},{"control_type":"text","label":"DEVELOPMENT_REFERENCE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"DEVELOPMENT_REFERENCE__C","length":1024,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1024","type":"string","name":"development_reference__c","parent":"columns"},{"control_type":"integer","label":"KB_CANDIDATE__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"KB_CANDIDATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"kb_candidate__c","parent":"columns"},{"control_type":"text","label":"RESOLUTION_DETAIL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RESOLUTION_DETAIL__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"resolution_detail__c","parent":"columns"},{"control_type":"text","label":"TARGET_FIX_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"TARGET_FIX_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"target_fix_date__c","parent":"columns"},{"control_type":"text","label":"X3RD_LINE_RESOLUTION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"X3RD_LINE_RESOLUTION__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"x3rd_line_resolution__c","parent":"columns"},{"control_type":"text","label":"LEGACY_LI_ENTITLED_FIRST_RESPO","details":{"primary_key":false,"data_type":"date","column_name":"LEGACY_LI_ENTITLED_FIRST_RESPO","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"legacy_li_entitled_first_respo","parent":"columns"},{"control_type":"text","label":"LEGACY_LI_ENTITLED_RESOLVE_TIM","details":{"primary_key":false,"data_type":"date","column_name":"LEGACY_LI_ENTITLED_RESOLVE_TIM","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"legacy_li_entitled_resolve_tim","parent":"columns"},{"control_type":"text","label":"LEGACY_LI_ENTITLED_WORKAROUND_","details":{"primary_key":false,"data_type":"date","column_name":"LEGACY_LI_ENTITLED_WORKAROUND_","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"legacy_li_entitled_workaround_","parent":"columns"},{"control_type":"text","label":"AM_FE_ACCOUNT_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"AM_FE_ACCOUNT_OWNER__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"am_fe_account_owner__c","parent":"columns"},{"control_type":"text","label":"ACTUAL_DELIVERY_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"ACTUAL_DELIVERY_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"actual_delivery_date__c","parent":"columns"},{"control_type":"text","label":"ADDITIONAL_INFORMATION__C","details":{"primary_key":false,"data_type":"nclob","column_name":"ADDITIONAL_INFORMATION__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"additional_information__c","parent":"columns"},{"control_type":"text","label":"BETA_RELEASE_ACCEPTABLE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"BETA_RELEASE_ACCEPTABLE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"beta_release_acceptable__c","parent":"columns"},{"control_type":"text","label":"BUSINESS_JUSTIFICATION__C","details":{"primary_key":false,"data_type":"nclob","column_name":"BUSINESS_JUSTIFICATION__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"business_justification__c","parent":"columns"},{"control_type":"text","label":"BUSINESS_PRIORITY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"BUSINESS_PRIORITY__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"business_priority__c","parent":"columns"},{"control_type":"text","label":"CHANCE_OF_WINNING__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CHANCE_OF_WINNING__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"chance_of_winning__c","parent":"columns"},{"control_type":"text","label":"COMMITED_ORDER_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"COMMITED_ORDER_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"commited_order_date__c","parent":"columns"},{"control_type":"text","label":"COMMITTED_DATE_TO_CUSTOMER__C","details":{"primary_key":false,"data_type":"date","column_name":"COMMITTED_DATE_TO_CUSTOMER__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"committed_date_to_customer__c","parent":"columns"},{"control_type":"text","label":"COMPETITIVE_SITUATION__C","details":{"primary_key":false,"data_type":"nclob","column_name":"COMPETITIVE_SITUATION__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"competitive_situation__c","parent":"columns"},{"control_type":"number","label":"DEAL_SIZE__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"DEAL_SIZE__C","length":0,"precision":14,"scale":4},"optional":true,"hint":"number","type":"number","name":"deal_size__c","parent":"columns"},{"control_type":"text","label":"ENGINEERING_ESTIMATE_MAN_MONTH","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ENGINEERING_ESTIMATE_MAN_MONTH","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"engineering_estimate_man_month","parent":"columns"},{"control_type":"text","label":"ESTIMATED_DELIVERY_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"ESTIMATED_DELIVERY_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"estimated_delivery_date__c","parent":"columns"},{"control_type":"integer","label":"ISOFFEREXPIRED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISOFFEREXPIRED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isofferexpired__c","parent":"columns"},{"control_type":"text","label":"LATEST_ACCEPTABLE_DELIVERY_DAT","details":{"primary_key":false,"data_type":"date","column_name":"LATEST_ACCEPTABLE_DELIVERY_DAT","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"latest_acceptable_delivery_dat","parent":"columns"},{"control_type":"text","label":"OFFER_EXPIRATION_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"OFFER_EXPIRATION_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"offer_expiration_date__c","parent":"columns"},{"control_type":"text","label":"OPPORTUNITYNAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"OPPORTUNITYNAME__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"opportunityname__c","parent":"columns"},{"control_type":"text","label":"PLM_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PLM_OWNER__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"plm_owner__c","parent":"columns"},{"control_type":"text","label":"PLANNED_RELEASE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PLANNED_RELEASE__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"planned_release__c","parent":"columns"},{"control_type":"text","label":"QUALITY_EXPECTATION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"QUALITY_EXPECTATION__C","length":200,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 200","type":"string","name":"quality_expectation__c","parent":"columns"},{"control_type":"text","label":"QUOTATION_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"QUOTATION_NAME__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"quotation_name__c","parent":"columns"},{"control_type":"text","label":"R_D_COMMENTS_AND_QUESTIONS__C","details":{"primary_key":false,"data_type":"nclob","column_name":"R_D_COMMENTS_AND_QUESTIONS__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"r_d_comments_and_questions__c","parent":"columns"},{"control_type":"text","label":"R_D_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"R_D_OWNER__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"r_d_owner__c","parent":"columns"},{"control_type":"number","label":"R_D_ROUGH_LOE_ESTIMATE__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"R_D_ROUGH_LOE_ESTIMATE__C","length":0,"precision":5,"scale":2},"optional":true,"hint":"number","type":"number","name":"r_d_rough_loe_estimate__c","parent":"columns"},{"control_type":"text","label":"REQUESTED_DELIVERY_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"REQUESTED_DELIVERY_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"requested_delivery_date__c","parent":"columns"},{"control_type":"text","label":"REQUIREMENT_STABILITY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"REQUIREMENT_STABILITY__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"requirement_stability__c","parent":"columns"},{"control_type":"text","label":"REQUIREMENT_SUMMARY__C","details":{"primary_key":false,"data_type":"nclob","column_name":"REQUIREMENT_SUMMARY__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"requirement_summary__c","parent":"columns"},{"control_type":"text","label":"REQUIREMENTS_CATEGORY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"REQUIREMENTS_CATEGORY__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"requirements_category__c","parent":"columns"},{"control_type":"text","label":"RESPONSE_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"RESPONSE_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"response_date__c","parent":"columns"},{"control_type":"text","label":"RISK_IF_NOT_APPROVED__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RISK_IF_NOT_APPROVED__C","length":200,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 200","type":"string","name":"risk_if_not_approved__c","parent":"columns"},{"control_type":"text","label":"SOLUTION_CONSULTANT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SOLUTION_CONSULTANT__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"solution_consultant__c","parent":"columns"},{"control_type":"text","label":"T1_GATE_HELD__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"T1_GATE_HELD__C","length":200,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 200","type":"string","name":"t1_gate_held__c","parent":"columns"},{"control_type":"text","label":"LICENSE_KEY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LICENSE_KEY__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"license_key__c","parent":"columns"},{"control_type":"text","label":"MACHINE_ID__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"MACHINE_ID__C","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"machine_id__c","parent":"columns"},{"control_type":"text","label":"CONTACT_FULL_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONTACT_FULL_NAME__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"contact_full_name__c","parent":"columns"},{"control_type":"text","label":"WCONTACT_PHONE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WCONTACT_PHONE__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"wcontact_phone__c","parent":"columns"},{"control_type":"text","label":"WCONTACT_EMAIL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WCONTACT_EMAIL__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"wcontact_email__c","parent":"columns"},{"control_type":"text","label":"WACCOUNT_OWNER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WACCOUNT_OWNER__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"waccount_owner__c","parent":"columns"},{"control_type":"text","label":"WCONTACT_MAILINGCOUNTRY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WCONTACT_MAILINGCOUNTRY__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"wcontact_mailingcountry__c","parent":"columns"},{"control_type":"integer","label":"WSTRATEGIC_ACCOUNT__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"WSTRATEGIC_ACCOUNT__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"wstrategic_account__c","parent":"columns"},{"control_type":"text","label":"WACCOUNTRECTYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WACCOUNTRECTYPE__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"waccountrectype__c","parent":"columns"},{"control_type":"text","label":"STATUS_UPDATE__C","details":{"primary_key":false,"data_type":"nclob","column_name":"STATUS_UPDATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"status_update__c","parent":"columns"},{"control_type":"text","label":"PRODUCTID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCTID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"productid","parent":"columns"},{"control_type":"text","label":"BUSINESSHOURSID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"BUSINESSHOURSID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"businesshoursid","parent":"columns"},{"control_type":"integer","label":"ISVISIBLEINSELFSERVICE","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISVISIBLEINSELFSERVICE","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isvisibleinselfservice","parent":"columns"},{"control_type":"integer","label":"ISCLOSEDONCREATE","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISCLOSEDONCREATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isclosedoncreate","parent":"columns"},{"control_type":"integer","label":"ISSELFSERVICECLOSED","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISSELFSERVICECLOSED","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isselfserviceclosed","parent":"columns"},{"control_type":"text","label":"SLASTARTDATE","details":{"primary_key":false,"data_type":"date","column_name":"SLASTARTDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"slastartdate","parent":"columns"},{"control_type":"text","label":"SLAEXITDATE","details":{"primary_key":false,"data_type":"date","column_name":"SLAEXITDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"slaexitdate","parent":"columns"},{"control_type":"integer","label":"ISSTOPPED","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISSTOPPED","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isstopped","parent":"columns"},{"control_type":"text","label":"STOPSTARTDATE","details":{"primary_key":false,"data_type":"date","column_name":"STOPSTARTDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"stopstartdate","parent":"columns"},{"control_type":"text","label":"MILESTONESTATUS","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"MILESTONESTATUS","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"milestonestatus","parent":"columns"},{"control_type":"text","label":"ACCOUNT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ACCOUNT__C","length":180,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 180","type":"string","name":"account__c","parent":"columns"},{"control_type":"text","label":"COMMENTS__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"COMMENTS__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"comments__c","parent":"columns"},{"control_type":"text","label":"CONTACT_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONTACT_NAME__C","length":200,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 200","type":"string","name":"contact_name__c","parent":"columns"},{"control_type":"text","label":"PRODUCT_ACTIVE_START_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"PRODUCT_ACTIVE_START_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"product_active_start_date__c","parent":"columns"},{"control_type":"text","label":"PRODUCT_CUSTOM__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_CUSTOM__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"product_custom__c","parent":"columns"},{"control_type":"text","label":"PRODUCT_VERSION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRODUCT_VERSION__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"product_version__c","parent":"columns"},{"control_type":"text","label":"SERIAL_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SERIAL_NUMBER__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"serial_number__c","parent":"columns"},{"control_type":"text","label":"URGENCY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"URGENCY__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"urgency__c","parent":"columns"},{"control_type":"text","label":"OSP_CASE_SUB_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"OSP_CASE_SUB_TYPE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"osp_case_sub_type__c","parent":"columns"},{"control_type":"text","label":"AGF__ADM_WORK__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"AGF__ADM_WORK__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"agf__adm_work__c","parent":"columns"},{"control_type":"integer","label":"EMERGENCY_CASE__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"EMERGENCY_CASE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"emergency_case__c","parent":"columns"},{"control_type":"text","label":"CUSTOMER_REFERENCE_ID__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CUSTOMER_REFERENCE_ID__C","length":20,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 20","type":"string","name":"customer_reference_id__c","parent":"columns"},{"control_type":"text","label":"CASE_CONTACT_NOTIFICATION_EMAI","details":{"primary_key":false,"data_type":"nclob","column_name":"CASE_CONTACT_NOTIFICATION_EMAI","length":0,"precision":null,"scale":null},"optional":true,"hint":"nclob","type":"string","name":"case_contact_notification_emai","parent":"columns"},{"control_type":"text","label":"CONTACT_NOTIFICATION_EMAIL_TYP","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONTACT_NOTIFICATION_EMAIL_TYP","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"contact_notification_email_typ","parent":"columns"},{"control_type":"integer","label":"SEND_EMAIL_TO_CONTACT_TOGGLE__","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"SEND_EMAIL_TO_CONTACT_TOGGLE__","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"send_email_to_contact_toggle__","parent":"columns"},{"control_type":"text","label":"CASE_CONTACT_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CASE_CONTACT_NAME__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"case_contact_name__c","parent":"columns"},{"control_type":"text","label":"MET_RESOLUTION_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"MET_RESOLUTION_TIME__C","length":10,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 10","type":"string","name":"met_resolution_time__c","parent":"columns"},{"control_type":"text","label":"MET_RESPONSE_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"MET_RESPONSE_TIME__C","length":10,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 10","type":"string","name":"met_response_time__c","parent":"columns"},{"control_type":"text","label":"MET_RESTORATION_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"MET_RESTORATION_TIME__C","length":10,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 10","type":"string","name":"met_restoration_time__c","parent":"columns"},{"control_type":"integer","label":"TL9000_SEVERITY_LEVEL_MINOR__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"TL9000_SEVERITY_LEVEL_MINOR__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"tl9000_severity_level_minor__c","parent":"columns"},{"control_type":"text","label":"NI_ASSET__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"NI_ASSET__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"ni_asset__c","parent":"columns"},{"control_type":"text","label":"LAST_MODIFIED__C","details":{"primary_key":false,"data_type":"date","column_name":"LAST_MODIFIED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"last_modified__c","parent":"columns"}]}],"visible_config_fields":["table","columns.id","columns.nvarchar_field","columns","columns.chatter_text_by_customer__c"],"comment":"Insert 2000 Character String into NCLOB field","uuid":"3dfd2e6a-515d-4202-b21e-9e94ece8156e"},{"number":7,"as":"catch","keyword":"catch","dynamicPickListSelection":{},"toggleCfg":{},"input":{"max_retry_count":"0","retry_interval":"2"},"block":[],"uuid":"1bb29f0b-e136-47da-b9d8-f2e87890a661"}],"uuid":"c61c4d05-0f9d-4c61-987c-e1e6f02d5c30"},{"number":8,"keyword":"try","dynamicPickListSelection":{},"toggleCfg":{},"input":{},"block":[{"number":9,"provider":"oracle","name":"insert_row","as":"insert_row__4","title":"Create row in ROOT.DWH_SF_WKTO_CASE","description":"Create row in ROOT.DWH_SF_WKTO_CASE table in Oracle","keyword":"action","dynamicPickListSelection":{"table":"ROOT.DWH_SF_WKTO_CASE"},"toggleCfg":{"table":true},"input":{"table":"ROOT.DWH_SF_WKTO_CASE","columns":{"id":"2","chatter_text_by_customer__c":"#{_('data.logger.log_message.message')}#{_('data.logger.log_message.message')}"}},"extended_input_schema":[{"type":"object","name":"columns","label":"Columns","properties":[{"control_type":"text","label":"ID","details":{"primary_key":true,"data_type":"nvarchar2","column_name":"ID","length":18,"precision":null,"scale":null},"event_title":true,"hint":"nvarchar2, max length 18, primary key","optional":true,"type":"string","name":"id","parent":"columns"},{"control_type":"integer","label":"ISDELETED","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISDELETED","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isdeleted","parent":"columns"},{"control_type":"text","label":"CASENUMBER","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CASENUMBER","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"casenumber","parent":"columns"},{"control_type":"text","label":"CONTACTID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONTACTID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"contactid","parent":"columns"},{"control_type":"text","label":"ACCOUNTID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ACCOUNTID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"accountid","parent":"columns"},{"control_type":"text","label":"ASSETID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ASSETID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"assetid","parent":"columns"},{"control_type":"text","label":"ENTITLEMENTID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ENTITLEMENTID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"entitlementid","parent":"columns"},{"control_type":"text","label":"PARENTID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PARENTID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"parentid","parent":"columns"},{"control_type":"text","label":"SUPPLIEDNAME","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SUPPLIEDNAME","length":80,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 80","type":"string","name":"suppliedname","parent":"columns"},{"control_type":"text","label":"SUPPLIEDEMAIL","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SUPPLIEDEMAIL","length":80,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 80","type":"string","name":"suppliedemail","parent":"columns"},{"control_type":"text","label":"SUPPLIEDPHONE","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SUPPLIEDPHONE","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"suppliedphone","parent":"columns"},{"control_type":"text","label":"SUPPLIEDCOMPANY","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SUPPLIEDCOMPANY","length":80,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 80","type":"string","name":"suppliedcompany","parent":"columns"},{"control_type":"text","label":"TYPE","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"TYPE","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"type","parent":"columns"},{"control_type":"text","label":"RECORDTYPEID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"RECORDTYPEID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"recordtypeid","parent":"columns"},{"control_type":"text","label":"STATUS","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"STATUS","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"status","parent":"columns"},{"control_type":"text","label":"REASON","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"REASON","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"reason","parent":"columns"},{"control_type":"text","label":"ORIGIN","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ORIGIN","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"origin","parent":"columns"},{"control_type":"text","label":"SUBJECT","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SUBJECT","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"subject","parent":"columns"},{"control_type":"text","label":"PRIORITY","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"PRIORITY","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"priority","parent":"columns"},{"control_type":"integer","label":"ISCLOSED","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISCLOSED","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isclosed","parent":"columns"},{"control_type":"text","label":"CLOSEDDATE","details":{"primary_key":false,"data_type":"date","column_name":"CLOSEDDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"closeddate","parent":"columns"},{"control_type":"integer","label":"ISESCALATED","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ISESCALATED","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"isescalated","parent":"columns"},{"control_type":"integer","label":"HASCOMMENTSUNREADBYOWNER","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"HASCOMMENTSUNREADBYOWNER","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"hascommentsunreadbyowner","parent":"columns"},{"control_type":"integer","label":"HASSELFSERVICECOMMENTS","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"HASSELFSERVICECOMMENTS","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"hasselfservicecomments","parent":"columns"},{"control_type":"text","label":"CURRENCYISOCODE","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CURRENCYISOCODE","length":3,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 3","type":"string","name":"currencyisocode","parent":"columns"},{"control_type":"text","label":"OWNERID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"OWNERID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"ownerid","parent":"columns"},{"control_type":"text","label":"CREATEDDATE","details":{"primary_key":false,"data_type":"date","column_name":"CREATEDDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"createddate","parent":"columns"},{"control_type":"text","label":"CREATEDBYID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CREATEDBYID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"createdbyid","parent":"columns"},{"control_type":"text","label":"LASTMODIFIEDDATE","details":{"primary_key":false,"data_type":"date","column_name":"LASTMODIFIEDDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"lastmodifieddate","parent":"columns"},{"control_type":"text","label":"LASTMODIFIEDBYID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"LASTMODIFIEDBYID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"lastmodifiedbyid","parent":"columns"},{"control_type":"text","label":"SYSTEMMODSTAMP","details":{"primary_key":false,"data_type":"date","column_name":"SYSTEMMODSTAMP","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"systemmodstamp","parent":"columns"},{"control_type":"text","label":"LASTVIEWEDDATE","details":{"primary_key":false,"data_type":"date","column_name":"LASTVIEWEDDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"lastvieweddate","parent":"columns"},{"control_type":"text","label":"LASTREFERENCEDDATE","details":{"primary_key":false,"data_type":"date","column_name":"LASTREFERENCEDDATE","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"lastreferenceddate","parent":"columns"},{"control_type":"text","label":"CONNECTIONRECEIVEDID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONNECTIONRECEIVEDID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"connectionreceivedid","parent":"columns"},{"control_type":"text","label":"CONNECTIONSENTID","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONNECTIONSENTID","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"connectionsentid","parent":"columns"},{"control_type":"text","label":"CASE_SUB_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CASE_SUB_TYPE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"case_sub_type__c","parent":"columns"},{"control_type":"text","label":"SERIAL_2__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"SERIAL_2__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"serial_2__c","parent":"columns"},{"control_type":"text","label":"WEB_ADDRESS_LINE_1__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_ADDRESS_LINE_1__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"web_address_line_1__c","parent":"columns"},{"control_type":"text","label":"WEB_ADDRESS_LINE_2__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_ADDRESS_LINE_2__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"web_address_line_2__c","parent":"columns"},{"control_type":"text","label":"WEB_CITY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_CITY__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_city__c","parent":"columns"},{"control_type":"text","label":"WEB_COMPANY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_COMPANY__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_company__c","parent":"columns"},{"control_type":"text","label":"WEB_COUNTRY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_COUNTRY__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_country__c","parent":"columns"},{"control_type":"text","label":"WEB_EMAIL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_EMAIL__C","length":80,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 80","type":"string","name":"web_email__c","parent":"columns"},{"control_type":"text","label":"WEB_FIRST_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_FIRST_NAME__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_first_name__c","parent":"columns"},{"control_type":"text","label":"WEB_LAST_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_LAST_NAME__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_last_name__c","parent":"columns"},{"control_type":"text","label":"WEB_STATE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_STATE__C","length":50,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 50","type":"string","name":"web_state__c","parent":"columns"},{"control_type":"text","label":"WEB_TELEPHONE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_TELEPHONE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"web_telephone__c","parent":"columns"},{"control_type":"text","label":"WEB_ZIP_POSTAL_CODE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"WEB_ZIP_POSTAL_CODE__C","length":16,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 16","type":"string","name":"web_zip_postal_code__c","parent":"columns"},{"control_type":"text","label":"YOUR_ROLE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"YOUR_ROLE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"your_role__c","parent":"columns"},{"control_type":"integer","label":"ACTUAL_RESOLUTION_TIME_IN_MINU","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ACTUAL_RESOLUTION_TIME_IN_MINU","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"actual_resolution_time_in_minu","parent":"columns"},{"control_type":"text","label":"ACTUAL_RESOLUTION_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"ACTUAL_RESOLUTION_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"actual_resolution_time__c","parent":"columns"},{"control_type":"integer","label":"ACTUAL_RESPONSE_TIME_IN_MINUTE","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ACTUAL_RESPONSE_TIME_IN_MINUTE","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"actual_response_time_in_minute","parent":"columns"},{"control_type":"text","label":"ACTUAL_RESPONSE_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"ACTUAL_RESPONSE_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"actual_response_time__c","parent":"columns"},{"control_type":"integer","label":"ACTUAL_RESTORATION_TIME_IN_MIN","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ACTUAL_RESTORATION_TIME_IN_MIN","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"actual_restoration_time_in_min","parent":"columns"},{"control_type":"text","label":"ACTUAL_RESTORATION_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"ACTUAL_RESTORATION_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"actual_restoration_time__c","parent":"columns"},{"control_type":"integer","label":"AFTER_HOURS_TECH_SUPPORT__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"AFTER_HOURS_TECH_SUPPORT__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"after_hours_tech_support__c","parent":"columns"},{"control_type":"text","label":"ASSET_SERIAL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ASSET_SERIAL__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"asset_serial__c","parent":"columns"},{"control_type":"text","label":"ASSET__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ASSET__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"asset__c","parent":"columns"},{"control_type":"text","label":"BILLING_CITY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"BILLING_CITY__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"billing_city__c","parent":"columns"},{"control_type":"text","label":"BUSINESS_UNITL4__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"BUSINESS_UNITL4__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"business_unitl4__c","parent":"columns"},{"control_type":"text","label":"BUSINESS_UNIT_L4__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"BUSINESS_UNIT_L4__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"business_unit_l4__c","parent":"columns"},{"control_type":"text","label":"CPAR__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CPAR__C","length":10,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 10","type":"string","name":"cpar__c","parent":"columns"},{"control_type":"text","label":"CR_STATUS_FIXED_IN_VALUES__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CR_STATUS_FIXED_IN_VALUES__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"cr_status_fixed_in_values__c","parent":"columns"},{"control_type":"text","label":"CR_VALUES__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CR_VALUES__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"cr_values__c","parent":"columns"},{"control_type":"text","label":"CALIBRATION_SERVICE_2__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CALIBRATION_SERVICE_2__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"calibration_service_2__c","parent":"columns"},{"control_type":"text","label":"CALIBRATION_SERVICE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CALIBRATION_SERVICE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"calibration_service__c","parent":"columns"},{"control_type":"number","label":"CASE_AGE_TRACKING__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"CASE_AGE_TRACKING__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"case_age_tracking__c","parent":"columns"},{"control_type":"integer","label":"CASE_AGE__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"CASE_AGE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"case_age__c","parent":"columns"},{"control_type":"integer","label":"CASE_CLOSE_CHECK__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"CASE_CLOSE_CHECK__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"case_close_check__c","parent":"columns"},{"control_type":"text","label":"CASE_CLOSURE_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"CASE_CLOSURE_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"case_closure_time__c","parent":"columns"},{"control_type":"text","label":"CASE_CREATION_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"CASE_CREATION_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"case_creation_date__c","parent":"columns"},{"control_type":"text","label":"CASE_CREATION_DATE_DEL__C","details":{"primary_key":false,"data_type":"date","column_name":"CASE_CREATION_DATE_DEL__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"case_creation_date_del__c","parent":"columns"},{"control_type":"text","label":"CASE_NAME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CASE_NAME__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"case_name__c","parent":"columns"},{"control_type":"text","label":"CASE_TYPE_DETAIL__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CASE_TYPE_DETAIL__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"case_type_detail__c","parent":"columns"},{"control_type":"text","label":"CASE_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CASE_TYPE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"case_type__c","parent":"columns"},{"control_type":"text","label":"CATALOG_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CATALOG_NUMBER__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"catalog_number__c","parent":"columns"},{"control_type":"integer","label":"COMMITMENT_SLA__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"COMMITMENT_SLA__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"commitment_sla__c","parent":"columns"},{"control_type":"text","label":"COMPANY__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"COMPANY__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"company__c","parent":"columns"},{"control_type":"text","label":"COMPONENT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"COMPONENT__C","length":250,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 250","type":"string","name":"component__c","parent":"columns"},{"control_type":"text","label":"CONDITION__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CONDITION__C","length":40,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 40","type":"string","name":"condition__c","parent":"columns"},{"control_type":"text","label":"COVERAGE_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"COVERAGE_TYPE__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"coverage_type__c","parent":"columns"},{"control_type":"text","label":"CURRENT_QUEUE_IN_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"CURRENT_QUEUE_IN_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"current_queue_in_datetime__c","parent":"columns"},{"control_type":"text","label":"CURRENT_QUEUE_TIME_FORMAT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CURRENT_QUEUE_TIME_FORMAT__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"current_queue_time_format__c","parent":"columns"},{"control_type":"text","label":"CURRENT_QUEUE_TIME_NOTIFICATIO","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CURRENT_QUEUE_TIME_NOTIFICATIO","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"current_queue_time_notificatio","parent":"columns"},{"control_type":"text","label":"CURRENT_QUEUE_TIME_TRACK_ON_CA","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CURRENT_QUEUE_TIME_TRACK_ON_CA","length":20,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 20","type":"string","name":"current_queue_time_track_on_ca","parent":"columns"},{"control_type":"number","label":"CURRENT_QUEUE_TIME__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"CURRENT_QUEUE_TIME__C","length":0,"precision":18,"scale":2},"optional":true,"hint":"number","type":"number","name":"current_queue_time__c","parent":"columns"},{"control_type":"text","label":"CUSTOMER_CASE_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"CUSTOMER_CASE_TIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"customer_case_time__c","parent":"columns"},{"control_type":"text","label":"CUSTOMER_IMPACT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CUSTOMER_IMPACT__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"customer_impact__c","parent":"columns"},{"control_type":"text","label":"CUSTOMER_NUMBER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CUSTOMER_NUMBER__C","length":20,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 20","type":"string","name":"customer_number__c","parent":"columns"},{"control_type":"text","label":"CUSTOMER_TIME_IN_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"CUSTOMER_TIME_IN_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"customer_time_in_datetime__c","parent":"columns"},{"control_type":"text","label":"CUSTOMER_TIME_OUT_DATETIME__C","details":{"primary_key":false,"data_type":"date","column_name":"CUSTOMER_TIME_OUT_DATETIME__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"customer_time_out_datetime__c","parent":"columns"},{"control_type":"number","label":"CUSTOMER_TIME_TRACKING__C","parse_output":"parse_numeric_output","details":{"primary_key":false,"data_type":"number","column_name":"CUSTOMER_TIME_TRACKING__C","length":0,"precision":18,"scale":5},"optional":true,"hint":"number","type":"number","name":"customer_time_tracking__c","parent":"columns"},{"control_type":"text","label":"CUSTOMER_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"CUSTOMER_TIME__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"customer_time__c","parent":"columns"},{"control_type":"text","label":"DATE_FIX_RELEASED__C","details":{"primary_key":false,"data_type":"date","column_name":"DATE_FIX_RELEASED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"date_fix_released__c","parent":"columns"},{"control_type":"integer","label":"DO_NOT_EMAIL__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"DO_NOT_EMAIL__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"do_not_email__c","parent":"columns"},{"control_type":"integer","label":"EMAIL_24X7__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"EMAIL_24X7__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"email_24x7__c","parent":"columns"},{"control_type":"text","label":"END_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"END_TIME__C","length":8,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 8","type":"string","name":"end_time__c","parent":"columns"},{"control_type":"integer","label":"ENTITLEMENT_VERIFIED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ENTITLEMENT_VERIFIED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"entitlement_verified__c","parent":"columns"},{"control_type":"text","label":"ENTITLEMENT__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ENTITLEMENT__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"entitlement__c","parent":"columns"},{"control_type":"text","label":"ESCALATED_ICON__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ESCALATED_ICON__C","length":1300,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 1300","type":"string","name":"escalated_icon__c","parent":"columns"},{"control_type":"integer","label":"ESCALATED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ESCALATED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"escalated__c","parent":"columns"},{"control_type":"integer","label":"ESCALATION_FLAG__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"ESCALATION_FLAG__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"escalation_flag__c","parent":"columns"},{"control_type":"text","label":"ESCALATION_MANAGER__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ESCALATION_MANAGER__C","length":18,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 18","type":"string","name":"escalation_manager__c","parent":"columns"},{"control_type":"text","label":"ESCALATION_TYPE__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"ESCALATION_TYPE__C","length":255,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 255","type":"string","name":"escalation_type__c","parent":"columns"},{"control_type":"integer","label":"FEEBACK_REQUESTED__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"FEEBACK_REQUESTED__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"feeback_requested__c","parent":"columns"},{"control_type":"integer","label":"FIRST_CALL_RESOLUTION__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"FIRST_CALL_RESOLUTION__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"first_call_resolution__c","parent":"columns"},{"control_type":"text","label":"FIX_RESPONSE_TIME__C","details":{"primary_key":false,"data_type":"nvarchar2","column_name":"FIX_RESPONSE_TIME__C","length":30,"precision":null,"scale":null},"optional":true,"hint":"nvarchar2, max length 30","type":"string","name":"fix_response_time__c","parent":"columns"},{"control_type":"integer","label":"FIX_ALREADY_AVAILABLE__C","parse_output":"parse_integer_output","details":{"primary_key":false,"data_type":"number","column_name":"FIX_ALREADY_AVAILABLE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"number","type":"integer","name":"fix_already_available__c","parent":"columns"},{"control_type":"text","label":"FOLLOW_UP_DATE__C","details":{"primary_key":false,"data_type":"date","column_name":"FOLLOW_UP_DATE__C","length":0,"precision":null,"scale":null},"optional":true,"hint":"date","type":"string","name":"follow_up_date__c","parent":"columns"},{"control_type":"text","label":"FREEZE_RESOLUTION_TIME__C","details":{"primary_key":false,"data_type":"date","column_name":"FREEZE_R