Name: Review

Display Field: insurance_plan_1___product_type

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 10351b085dba4f2e8607a8573b73b747

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• discharge_date___fiscal_year ( modelName: discharge_date___fiscal_year, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Discharge Date - Fiscal Year, type: esriFieldTypeString )
• entity ( modelName: entity, nullable: true, editable: true, defaultValue: null, length: 8000, alias: entity, type: esriFieldTypeString )
• patient_type___rollup ( modelName: patient_type___rollup, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Patient Type - Rollup, type: esriFieldTypeString )
• patient_encounter___service_lin ( modelName: patient_encounter___service_lin, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Patient Encounter - Service Line Rollup 3, type: esriFieldTypeString )
• patient_encounter___service_l_1 ( modelName: patient_encounter___service_l_1, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Patient Encounter - Service Line 3, type: esriFieldTypeString )
• sg2_care_family___service_line_ ( modelName: sg2_care_family___service_line_, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Sg2 CARE Family - Service Line Group, type: esriFieldTypeString )
• sg2_care_family___service_line ( modelName: sg2_care_family___service_line, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Sg2 CARE Family - Service Line, type: esriFieldTypeString )
• sg2_care_family___care_family ( modelName: sg2_care_family___care_family, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Sg2 CARE Family - CARE Family, type: esriFieldTypeString )
• patient_encounter___rev_group ( modelName: patient_encounter___rev_group, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Patient Encounter - Rev Group, type: esriFieldTypeString )
• sg2_care_procedure_group___proc ( modelName: sg2_care_procedure_group___proc, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Sg2 CARE Procedure Group - Procedure Group, type: esriFieldTypeString )
• sg2_care_procedure_group___sg2_ ( modelName: sg2_care_procedure_group___sg2_, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Sg2 CARE Procedure Group - SG2 Procedure Group Custom Rollup, type: esriFieldTypeString )
• patient_encounter___medical_rec ( modelName: patient_encounter___medical_rec, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Patient Encounter - Medical Record Number, type: esriFieldTypeString )
• patient_encounter___hb_encounte ( modelName: patient_encounter___hb_encounte, nullable: true, editable: true, defaultValue: null, alias: Patient Encounter - HB Encounter Record Number, type: esriFieldTypeDouble )
• primary_icd10_diagnosis___icd10 ( modelName: primary_icd10_diagnosis___icd10, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Primary ICD10 Diagnosis - ICD10 Diagnosis, type: esriFieldTypeString )
• primary_icd10_procedure___icd10 ( modelName: primary_icd10_procedure___icd10, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Primary ICD10 Procedure - ICD10 Procedure, type: esriFieldTypeString )
• primary_cpt___cpt ( modelName: primary_cpt___cpt, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Primary CPT - CPT, type: esriFieldTypeString )
• primary_performing_physician___ ( modelName: primary_performing_physician___, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Primary Performing Physician - Physician, type: esriFieldTypeString )
• ms_drg ( modelName: ms_drg, nullable: true, editable: true, defaultValue: null, length: 8000, alias: MS DRG, type: esriFieldTypeString )
• billed_drg ( modelName: billed_drg, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Billed DRG, type: esriFieldTypeString )
• patient_encounter___medical_r_1 ( modelName: patient_encounter___medical_r_1, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Patient Encounter - Medical Record Number2, type: esriFieldTypeString )
• marg_spad ( modelName: marg_spad, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Marg/Spad, type: esriFieldTypeString )
• after ( modelName: after, nullable: true, editable: true, defaultValue: null, length: 8000, alias: After, type: esriFieldTypeString )
• chs_patient_type ( modelName: chs_patient_type, nullable: true, editable: true, defaultValue: null, length: 8000, alias: CHS Patient Type, type: esriFieldTypeString )
• attend_physician___physician ( modelName: attend_physician___physician, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Attend Physician - Physician, type: esriFieldTypeString )
• refer_physician___physician ( modelName: refer_physician___physician, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Refer Physician - Physician, type: esriFieldTypeString )
• op_advisory_board_sl ( modelName: op_advisory_board_sl, nullable: true, editable: true, defaultValue: null, length: 8000, alias: OP Advisory Board SL, type: esriFieldTypeString )
• op_advisory_board_sub_sl ( modelName: op_advisory_board_sub_sl, nullable: true, editable: true, defaultValue: null, length: 8000, alias: OP Advisory Board Sub SL, type: esriFieldTypeString )
• apr_svc_line ( modelName: apr_svc_line, nullable: true, editable: true, defaultValue: null, length: 8000, alias: APR Svc Line, type: esriFieldTypeString )
• apr_sub_service_line ( modelName: apr_sub_service_line, nullable: true, editable: true, defaultValue: null, length: 8000, alias: APR Sub Service Line, type: esriFieldTypeString )
• apr_drg ( modelName: apr_drg, nullable: true, editable: true, defaultValue: null, length: 8000, alias: APR DRG, type: esriFieldTypeString )
• apr_drg___soi ( modelName: apr_drg___soi, nullable: true, editable: true, defaultValue: null, alias: APR DRG - SOI, type: esriFieldTypeInteger )
• insurance_plan_1___financial_cl ( modelName: insurance_plan_1___financial_cl, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Insurance Plan 1 - Financial Class, type: esriFieldTypeString )
• insurance_plan_1___payor ( modelName: insurance_plan_1___payor, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Insurance Plan 1 - Payor, type: esriFieldTypeString )
• insurance_plan_1___insurance_pl ( modelName: insurance_plan_1___insurance_pl, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Insurance Plan 1 - Insurance Plan, type: esriFieldTypeString )
• insurance_plan_1___product_type ( modelName: insurance_plan_1___product_type, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Insurance Plan 1 - Product Type Name, type: esriFieldTypeString )
• age ( modelName: age, nullable: true, editable: true, defaultValue: null, alias: Age, type: esriFieldTypeInteger )
• age___rollup ( modelName: age___rollup, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Age - Rollup, type: esriFieldTypeString )
• newborn___mother_encounter_reco ( modelName: newborn___mother_encounter_reco, nullable: true, editable: true, defaultValue: null, alias: Newborn - Mother Encounter Record Number, type: esriFieldTypeInteger )
• zip_code ( modelName: zip_code, nullable: true, editable: true, defaultValue: null, alias: Zip Code, type: esriFieldTypeInteger )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, length: 8000, alias: City, type: esriFieldTypeString )
• patient_encounter___market_area ( modelName: patient_encounter___market_area, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Patient Encounter - Market Area, type: esriFieldTypeString )
• patient_encounter___er_visit_ty ( modelName: patient_encounter___er_visit_ty, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Patient Encounter - ER Visit Type, type: esriFieldTypeString )
• admit_type ( modelName: admit_type, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Admit Type, type: esriFieldTypeString )
• method_of_arrival___description ( modelName: method_of_arrival___description, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Method of Arrival - Description, type: esriFieldTypeString )
• cases ( modelName: cases, nullable: true, editable: true, defaultValue: null, alias: Cases, type: esriFieldTypeInteger )
• days ( modelName: days, nullable: true, editable: true, defaultValue: null, alias: Days, type: esriFieldTypeInteger )
• transfer_drg_cmi ( modelName: transfer_drg_cmi, nullable: true, editable: true, defaultValue: null, alias: Transfer DRG CMI, type: esriFieldTypeInteger )
• charge ( modelName: charge, nullable: true, editable: true, defaultValue: null, alias: Charge, type: esriFieldTypeInteger )
• exp_pymt ( modelName: exp_pymt, nullable: true, editable: true, defaultValue: null, alias: Exp Pymt, type: esriFieldTypeDouble )
• total_payments ( modelName: total_payments, nullable: true, editable: true, defaultValue: null, alias: Total Payments, type: esriFieldTypeInteger )
• bad_debt_allowance ( modelName: bad_debt_allowance, nullable: true, editable: true, defaultValue: null, alias: Bad Debt Allowance, type: esriFieldTypeInteger )
• charity_care_allowance ( modelName: charity_care_allowance, nullable: true, editable: true, defaultValue: null, alias: Charity Care Allowance, type: esriFieldTypeInteger )
• direct_cost ( modelName: direct_cost, nullable: true, editable: true, defaultValue: null, alias: Direct Cost, type: esriFieldTypeDouble )
• indirect_cost ( modelName: indirect_cost, nullable: true, editable: true, defaultValue: null, alias: Indirect Cost, type: esriFieldTypeDouble )
• direct_salary_cost ( modelName: direct_salary_cost, nullable: true, editable: true, defaultValue: null, alias: Direct Salary Cost, type: esriFieldTypeDouble )
• direct_fringe_benefit_cost ( modelName: direct_fringe_benefit_cost, nullable: true, editable: true, defaultValue: null, alias: Direct Fringe Benefit Cost, type: esriFieldTypeDouble )
• direct_supply_cost ( modelName: direct_supply_cost, nullable: true, editable: true, defaultValue: null, alias: Direct Supply Cost, type: esriFieldTypeDouble )
• direct_pharmacy_cost ( modelName: direct_pharmacy_cost, nullable: true, editable: true, defaultValue: null, alias: Direct Pharmacy Cost, type: esriFieldTypeInteger )
• home_office_allocation_detailed ( modelName: home_office_allocation_detailed, nullable: true, editable: true, defaultValue: null, alias: Home Office Allocation Detailed Cost, type: esriFieldTypeDouble )
• total_cost ( modelName: total_cost, nullable: true, editable: true, defaultValue: null, alias: Total Cost, type: esriFieldTypeDouble )
• pymt___dir_cost ( modelName: pymt___dir_cost, nullable: true, editable: true, defaultValue: null, alias: Pymt - Dir Cost, type: esriFieldTypeDouble )
• profit__loss_ ( modelName: profit__loss_, nullable: true, editable: true, defaultValue: null, alias: Profit/(Loss), type: esriFieldTypeDouble )
• avg_pymt_case ( modelName: avg_pymt_case, nullable: true, editable: true, defaultValue: null, alias: Avg Pymt/Case, type: esriFieldTypeInteger )
• account_balance ( modelName: account_balance, nullable: true, editable: true, defaultValue: null, alias: Account Balance, type: esriFieldTypeInteger )
• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• discharge_date___date ( modelName: discharge_date___date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Discharge_Date___Date, type: esriFieldTypeDate )

Templates:

• Name: Review
  Description:
  Prototype:
  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
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata