{ "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Review", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "ms_drg": null, "exp_pymt": null, "total_cost": null, "chs_patient_type": null, "total_payments": null, "newborn___mother_encounter_reco": null, "patient_encounter___market_area": null, "zip_code": null, "attend_physician___physician": null, "apr_svc_line": null, "insurance_plan_1___payor": null, "billed_drg": null, "sg2_care_procedure_group___proc": null, "home_office_allocation_detailed": null, "charity_care_allowance": null, "op_advisory_board_sl": null, "patient_encounter___medical_rec": null, "sg2_care_procedure_group___sg2_": null, "indirect_cost": null, "admit_type": null, "direct_salary_cost": null, "discharge_date___date": null, "transfer_drg_cmi": null, "insurance_plan_1___product_type": null, "primary_cpt___cpt": null, "patient_type___rollup": null, "apr_drg": null, "sg2_care_family___service_line_": null, "pymt___dir_cost": null, "discharge_date___fiscal_year": null, "refer_physician___physician": null, "direct_fringe_benefit_cost": null, "primary_performing_physician___": null, "direct_supply_cost": null, "account_balance": null, "city": null, "sg2_care_family___care_family": null, "direct_cost": null, "sg2_care_family___service_line": null, "patient_encounter___rev_group": null, "marg_spad": null, "insurance_plan_1___financial_cl": null, "after": null, "primary_icd10_procedure___icd10": null, "method_of_arrival___description": null, "apr_sub_service_line": null, "profit__loss_": null, "bad_debt_allowance": null, "cases": null, "charge": null, "op_advisory_board_sub_sl": null, "patient_encounter___hb_encounte": null, "patient_encounter___er_visit_ty": null, "direct_pharmacy_cost": null, "age___rollup": null, "patient_encounter___medical_r_1": null, "insurance_plan_1___insurance_pl": null, "apr_drg___soi": null, "patient_encounter___service_l_1": null, "patient_encounter___service_lin": null, "days": null, "primary_icd10_diagnosis___icd10": null, "entity": null, "age": null, "avg_pymt_case": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Review", "displayField": "insurance_plan_1___product_type", "supportsCalculate": true, "fields": [ { "modelName": "discharge_date___fiscal_year", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "discharge_date___fiscal_year", "length": 8000, "alias": "Discharge Date - Fiscal Year", "type": "esriFieldTypeString" }, { "modelName": "entity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "length": 8000, "name": "entity", "alias": "entity", "type": "esriFieldTypeString" }, { "modelName": "patient_type___rollup", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "patient_type___rollup", "length": 8000, "alias": "Patient Type - Rollup", "type": "esriFieldTypeString" }, { "modelName": "patient_encounter___service_lin", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "patient_encounter___service_lin", "length": 8000, "alias": "Patient Encounter - Service Line Rollup 3", "type": "esriFieldTypeString" }, { "modelName": "patient_encounter___service_l_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "patient_encounter___service_l_1", "length": 8000, "alias": "Patient Encounter - Service Line 3", "type": "esriFieldTypeString" }, { "modelName": "sg2_care_family___service_line_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sg2_care_family___service_line_", "length": 8000, "alias": "Sg2 CARE Family - Service Line Group", "type": "esriFieldTypeString" }, { "modelName": "sg2_care_family___service_line", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sg2_care_family___service_line", "length": 8000, "alias": "Sg2 CARE Family - Service Line", "type": "esriFieldTypeString" }, { "modelName": "sg2_care_family___care_family", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sg2_care_family___care_family", "length": 8000, "alias": "Sg2 CARE Family - CARE Family", "type": "esriFieldTypeString" }, { "modelName": "patient_encounter___rev_group", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "patient_encounter___rev_group", "length": 8000, "alias": "Patient Encounter - Rev Group", "type": "esriFieldTypeString" }, { "modelName": "sg2_care_procedure_group___proc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sg2_care_procedure_group___proc", "length": 8000, "alias": "Sg2 CARE Procedure Group - Procedure Group", "type": "esriFieldTypeString" }, { "modelName": "sg2_care_procedure_group___sg2_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sg2_care_procedure_group___sg2_", "length": 8000, "alias": "Sg2 CARE Procedure Group - SG2 Procedure Group Custom Rollup", "type": "esriFieldTypeString" }, { "modelName": "patient_encounter___medical_rec", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "patient_encounter___medical_rec", "length": 8000, "alias": "Patient Encounter - Medical Record Number", "type": "esriFieldTypeString" }, { "modelName": "patient_encounter___hb_encounte", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "patient_encounter___hb_encounte", "alias": "Patient Encounter - HB Encounter Record Number", "type": "esriFieldTypeDouble" }, { "modelName": "primary_icd10_diagnosis___icd10", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "primary_icd10_diagnosis___icd10", "length": 8000, "alias": "Primary ICD10 Diagnosis - ICD10 Diagnosis", "type": "esriFieldTypeString" }, { "modelName": "primary_icd10_procedure___icd10", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "primary_icd10_procedure___icd10", "length": 8000, "alias": "Primary ICD10 Procedure - ICD10 Procedure", "type": "esriFieldTypeString" }, { "modelName": "primary_cpt___cpt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "primary_cpt___cpt", "length": 8000, "alias": "Primary CPT - CPT", "type": "esriFieldTypeString" }, { "modelName": "primary_performing_physician___", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "primary_performing_physician___", "length": 8000, "alias": "Primary Performing Physician - Physician", "type": "esriFieldTypeString" }, { "modelName": "ms_drg", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ms_drg", "length": 8000, "alias": "MS DRG", "type": "esriFieldTypeString" }, { "modelName": "billed_drg", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "billed_drg", "length": 8000, "alias": "Billed DRG", "type": "esriFieldTypeString" }, { "modelName": "patient_encounter___medical_r_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "patient_encounter___medical_r_1", "length": 8000, "alias": "Patient Encounter - Medical Record Number2", "type": "esriFieldTypeString" }, { "modelName": "marg_spad", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "marg_spad", "length": 8000, "alias": "Marg/Spad", "type": "esriFieldTypeString" }, { "modelName": "after", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "after", "length": 8000, "alias": "After", "type": "esriFieldTypeString" }, { "modelName": "chs_patient_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "chs_patient_type", "length": 8000, "alias": "CHS Patient Type", "type": "esriFieldTypeString" }, { "modelName": "attend_physician___physician", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "attend_physician___physician", "length": 8000, "alias": "Attend Physician - Physician", "type": "esriFieldTypeString" }, { "modelName": "refer_physician___physician", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "refer_physician___physician", "length": 8000, "alias": "Refer Physician - Physician", "type": "esriFieldTypeString" }, { "modelName": "op_advisory_board_sl", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "op_advisory_board_sl", "length": 8000, "alias": "OP Advisory Board SL", "type": "esriFieldTypeString" }, { "modelName": "op_advisory_board_sub_sl", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "op_advisory_board_sub_sl", "length": 8000, "alias": "OP Advisory Board Sub SL", "type": "esriFieldTypeString" }, { "modelName": "apr_svc_line", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "apr_svc_line", "length": 8000, "alias": "APR Svc Line", "type": "esriFieldTypeString" }, { "modelName": "apr_sub_service_line", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "apr_sub_service_line", "length": 8000, "alias": "APR Sub Service Line", "type": "esriFieldTypeString" }, { "modelName": "apr_drg", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "apr_drg", "length": 8000, "alias": "APR DRG", "type": "esriFieldTypeString" }, { "modelName": "apr_drg___soi", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "apr_drg___soi", "alias": "APR DRG - SOI", "type": "esriFieldTypeInteger" }, { "modelName": "insurance_plan_1___financial_cl", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "insurance_plan_1___financial_cl", "length": 8000, "alias": "Insurance Plan 1 - Financial Class", "type": "esriFieldTypeString" }, { "modelName": "insurance_plan_1___payor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "insurance_plan_1___payor", "length": 8000, "alias": "Insurance Plan 1 - Payor", "type": "esriFieldTypeString" }, { "modelName": "insurance_plan_1___insurance_pl", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "insurance_plan_1___insurance_pl", "length": 8000, "alias": "Insurance Plan 1 - Insurance Plan", "type": "esriFieldTypeString" }, { "modelName": "insurance_plan_1___product_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "insurance_plan_1___product_type", "length": 8000, "alias": "Insurance Plan 1 - Product Type Name", "type": "esriFieldTypeString" }, { "modelName": "age", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "age", "alias": "Age", "type": "esriFieldTypeInteger" }, { "modelName": "age___rollup", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "age___rollup", "length": 8000, "alias": "Age - Rollup", "type": "esriFieldTypeString" }, { "modelName": "newborn___mother_encounter_reco", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "newborn___mother_encounter_reco", "alias": "Newborn - Mother Encounter Record Number", "type": "esriFieldTypeInteger" }, { "modelName": "zip_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip_code", "alias": "Zip Code", "type": "esriFieldTypeInteger" }, { "modelName": "city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 8000, "alias": "City", "type": "esriFieldTypeString" }, { "modelName": "patient_encounter___market_area", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "patient_encounter___market_area", "length": 8000, "alias": "Patient Encounter - Market Area", "type": "esriFieldTypeString" }, { "modelName": "patient_encounter___er_visit_ty", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "patient_encounter___er_visit_ty", "length": 8000, "alias": "Patient Encounter - ER Visit Type", "type": "esriFieldTypeString" }, { "modelName": "admit_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "admit_type", "length": 8000, "alias": "Admit Type", "type": "esriFieldTypeString" }, { "modelName": "method_of_arrival___description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "method_of_arrival___description", "length": 8000, "alias": "Method of Arrival - Description", "type": "esriFieldTypeString" }, { "modelName": "cases", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cases", "alias": "Cases", "type": "esriFieldTypeInteger" }, { "modelName": "days", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "days", "alias": "Days", "type": "esriFieldTypeInteger" }, { "modelName": "transfer_drg_cmi", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "transfer_drg_cmi", "alias": "Transfer DRG CMI", "type": "esriFieldTypeInteger" }, { "modelName": "charge", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "charge", "alias": "Charge", "type": "esriFieldTypeInteger" }, { "modelName": "exp_pymt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "exp_pymt", "alias": "Exp Pymt", "type": "esriFieldTypeDouble" }, { "modelName": "total_payments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_payments", "alias": "Total Payments", "type": "esriFieldTypeInteger" }, { "modelName": "bad_debt_allowance", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bad_debt_allowance", "alias": "Bad Debt Allowance", "type": "esriFieldTypeInteger" }, { "modelName": "charity_care_allowance", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "charity_care_allowance", "alias": "Charity Care Allowance", "type": "esriFieldTypeInteger" }, { "modelName": "direct_cost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "direct_cost", "alias": "Direct Cost", "type": "esriFieldTypeDouble" }, { "modelName": "indirect_cost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "indirect_cost", "alias": "Indirect Cost", "type": "esriFieldTypeDouble" }, { "modelName": "direct_salary_cost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "direct_salary_cost", "alias": "Direct Salary Cost", "type": "esriFieldTypeDouble" }, { "modelName": "direct_fringe_benefit_cost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "direct_fringe_benefit_cost", "alias": "Direct Fringe Benefit Cost", "type": "esriFieldTypeDouble" }, { "modelName": "direct_supply_cost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "direct_supply_cost", "alias": "Direct Supply Cost", "type": "esriFieldTypeDouble" }, { "modelName": "direct_pharmacy_cost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "direct_pharmacy_cost", "alias": "Direct Pharmacy Cost", "type": "esriFieldTypeInteger" }, { "modelName": "home_office_allocation_detailed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "home_office_allocation_detailed", "alias": "Home Office Allocation Detailed Cost", "type": "esriFieldTypeDouble" }, { "modelName": "total_cost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_cost", "alias": "Total Cost", "type": "esriFieldTypeDouble" }, { "modelName": "pymt___dir_cost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pymt___dir_cost", "alias": "Pymt - Dir Cost", "type": "esriFieldTypeDouble" }, { "modelName": "profit__loss_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "profit__loss_", "alias": "Profit/(Loss)", "type": "esriFieldTypeDouble" }, { "modelName": "avg_pymt_case", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "avg_pymt_case", "alias": "Avg Pymt/Case", "type": "esriFieldTypeInteger" }, { "modelName": "account_balance", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "account_balance", "alias": "Account Balance", "type": "esriFieldTypeInteger" }, { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "discharge_date___date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "discharge_date___date", "length": 29, "alias": "Discharge_Date___Date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r16196_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "10351b085dba4f2e8607a8573b73b747", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }