Loading
Vakuutus
InsProductReportService:getReportData

InsProductReportService:getReportData

Käytä tätä palvelua noutaaksesi kaikki tuotekentät ja -attribuutit tietylle tunnusten ja kenttäjoukkojen joukolle, mukaan lukien kaikki alitason tuotteet ja niiden attribuutit.

Luokka: InsProductReportService

Metodi: getReportData

Miten se toimii?

Tämä palvelu ottaa tuotetunnuksen ja muuntaa sen vastaavaksi raporttitiedoiksi.

Etäasetukset

Vaihtoehdot

Kuvaus

fieldsetName

Pakollinen.

Kenttäjoukon nimi, mukaan lukien etuliite, joka sisältää kaikki kentät raportin datassa.

Jos jätät tämän tyhjäksi, tuotekentän arvoksi rajoitetaan Tuotekoodi, Nimi ja Kuvaus.

Syötetty JSON

Tämä palvelu ei ota syötettyä JSON-tiedostoa.

Tulos-JSON

Palvelu palauttaa tulostetun JSON-tiedoston, joka sisältää raportin tarvittavat tiedot ja vastaavat sarakkeen otsikon tiedot.

{
   "rows":[
      {
         "values":{
            "ATTRIBUTE-15446":"Private Limit 5k/day",
            "ATTRIBUTE-15447":10,
            "ATTRIBUTE-15448":true,
            "ATTRIBUTE-15444":200000,
            "ATTRIBUTE-15445":5,
            "ins_tj_dev__TotalInsuredFormula__c":null,
            "ins_tj_dev__Term__c":null,
            "ins_tj_dev__PricingFormula__c":null,
            "ins_tj_dev__IsConfigurable__c":false,
            "ins_tj_dev__RecordTypeName__c":"Product",
            "ins_tj_dev__PricingSource__c":null,
            "ins_tj_dev__ImageId__c":null,
            "ins_tj_dev__Tier__c":null,
            "ins_tj_dev__IsRecommended__c":false,
            "ins_tj_dev__RateBandId__c":null,
            "ins_tj_dev__SubType__c":null,
            "ins_tj_dev__Type__c":null,
            "ins_tj_dev__MarketSegment__c":null,
            "ins_tj_dev__LineOfBusiness__c":null,
            "ProductCode":"HP107",
            "Family":null,
            "Description":null,
            "Name":"Health Plan v107",
            "Id":"01t4P000009ANHBQA4"
         },
         "headers":{
            "ATTRIBUTE-15448":"DC Dental C",
            "ATTRIBUTE-15447":"DC Dental B",
            "ATTRIBUTE-15446":"DC Dental A",
            "ATTRIBUTE-15445":"M200K Medical B",
            "ATTRIBUTE-15444":"M200K Medical A",
            "ins_tj_dev__TotalInsuredFormula__c":"Total Insured Formula",
            "ins_tj_dev__Term__c":"Term",
            "ins_tj_dev__PricingFormula__c":"Pricing Formula",
            "ins_tj_dev__IsConfigurable__c":"Configurable",
            "ins_tj_dev__RecordTypeName__c":"Record Type Name",
            "ins_tj_dev__PricingSource__c":"Pricing Source Mapping",
            "ins_tj_dev__ImageId__c":"Image",
            "ins_tj_dev__Tier__c":"Tier",
            "ins_tj_dev__IsRecommended__c":"Recommended",
            "ins_tj_dev__RateBandId__c":"Rate Band",
            "ins_tj_dev__SubType__c":"Sub Type",
            "ins_tj_dev__Type__c":"Type",
            "ins_tj_dev__MarketSegment__c":"Market Segment",
            "ins_tj_dev__LineOfBusiness__c":"Line of Business",
            "ProductCode":"Product Code",
            "Family":"Product Family",
            "Description":"Product Description",
            "Name":"Product Name",
            "Id":"Product ID"
         }
      },
      {
         "values":{
            "ATTRIBUTE-15442":"new Value",
            "ATTRIBUTE-15443":"Default Product Name",
            "ins_tj_dev__TotalInsuredFormula__c":null,
            "ins_tj_dev__Term__c":null,
            "ins_tj_dev__PricingFormula__c":null,
            "ins_tj_dev__IsConfigurable__c":false,
            "ins_tj_dev__RecordTypeName__c":"Product",
            "ins_tj_dev__PricingSource__c":null,
            "ins_tj_dev__ImageId__c":null,
            "ins_tj_dev__Tier__c":null,
            "ins_tj_dev__IsRecommended__c":false,
            "ins_tj_dev__RateBandId__c":null,
            "ins_tj_dev__SubType__c":null,
            "ins_tj_dev__Type__c":null,
            "ins_tj_dev__MarketSegment__c":null,
            "ins_tj_dev__LineOfBusiness__c":null,
            "ProductCode":"v107AA",
            "Family":null,
            "Description":null,
            "Name":"v107 All Attributes",
            "Id":"01t4P000009AMnuQAG"
         },
         "headers":{
            "ATTRIBUTE-15443":"COL_COVERAGE Product Name",
            "ATTRIBUTE-15442":"COL_COVERAGE Product Code",
            "ins_tj_dev__TotalInsuredFormula__c":"Total Insured Formula",
            "ins_tj_dev__Term__c":"Term",
            "ins_tj_dev__PricingFormula__c":"Pricing Formula",
            "ins_tj_dev__IsConfigurable__c":"Configurable",
            "ins_tj_dev__RecordTypeName__c":"Record Type Name",
            "ins_tj_dev__PricingSource__c":"Pricing Source Mapping",
            "ins_tj_dev__ImageId__c":"Image",
            "ins_tj_dev__Tier__c":"Tier",
            "ins_tj_dev__IsRecommended__c":"Recommended",
            "ins_tj_dev__RateBandId__c":"Rate Band",
            "ins_tj_dev__SubType__c":"Sub Type",
            "ins_tj_dev__Type__c":"Type",
            "ins_tj_dev__MarketSegment__c":"Market Segment",
            "ins_tj_dev__LineOfBusiness__c":"Line of Business",
            "ProductCode":"Product Code",
            "Family":"Product Family",
            "Description":"Product Description",
            "Name":"Product Name",
            "Id":"Product ID"
         }
      },
      {
         "values":{
            "SG_empOnlyCount":"",
            "SG_empSpouseCount":"",
            "SG_empChildCount":"",
            "SG_empFamilyCount":"",
            "SG_CM_MemberClass":null,
            "SG_CM_Age":"",
            "SG_CM_State":null,
            "SG_CM_Gender":null,
            "SG_CM_Smoker":false,
            "SG_CM_IsPrimary":true,
            "SG_CM_IsSpouse":false,
            "SG_mailOrderDrugsT1_INN":"$37.50 Copay",
            "SG_mailOrderDrugsT1_OON":"Not Covered",
            "SG_mailOrderDrugsT2_INN":"$87.50 Copay",
            "SG_mailOrderDrugsT2_OON":"Not Covered",
            "SG_mailOrderDrugsT3_INN":"$125 Copay",
            "SG_mailOrderDrugsT3_OON":"Not Covered",
            "SG_mailOrderDrugsT4_INN":"$187.50 Copay",
            "SG_mailOrderDrugsT4_OON":"Not Covered",
            "SG_mailOrderDrugsT5_INN":"$1,250 Copay",
            "SG_mailOrderDrugsT5_OON":"Not Covered",
            "SG_RetailDrugsT1_INN":"$15 Copay",
            "SG_RetailDrugsT1_OON":"Not Covered",
            "SG_RetailDrugsT2_INN":"$35 Copay",
            "SG_RetailDrugsT2_OON":"Not Covered",
            "SG_RetailDrugsT3_INN":"$50 Copay",
            "SG_RetailDrugsT3_OON":"Not Covered",
            "SG_RetailDrugsT4_INN":"$75 Copay After Ded",
            "SG_RetailDrugsT4_OON":"Not Covered",
            "SG_RetailDrugsT5_INN":"Not Covered",
            "SG_RetailDrugsT5_OON":"Not Covered",
            "SG_imaging_INN":"$125 Copay",
            "SG_imaging_OON":"Not Covered",
            "SG_specialist_INN":"$50 Copay",
            "SG_specialist_OON":"Not Covered",
            "SG_primaryCare_INN":"$25 Copay",
            "SG_primaryCare_OON":"Not Covered",
            "SG_annualDed_INN":"$500 Indiv | $1,000 Fam",
            "SG_annualDed_OON":"Not Covered",
            "SG_annualOOP_INN":"$1,500 Indiv | $3,000 Fam",
            "SG_annualOOP_OON":"Not Covered",
            "SG_coinsurance_INN":"20% After Ded",
            "SG_coinsurance_OON":"Not Covered",
            "SG_lifetimeMax_INN":"Unlimited",
            "SG_lifetimeMax_OON":"Unlimited",
            "SG_preventative_INN":"$0 Copay",
            "SG_preventative_OON":"$0 Copay",
            "SG_outpatientXray_INN":"$50 Copay",
            "SG_outpatientMental_INN":"20% Coins After Ded",
            "SG_outpatientRehab_INN":"20% Coins After Ded",
            "SG_outpatientSurg_INN":"$75 Copay",
            "SG_skilledNursing_INN":"20% Coins After Ded",
            "SG_outpatientXray_OON":"Not Covered",
            "SG_outpatientMental_OON":"30% Coins After Ded",
            "SG_outpatientRehab_OON":"Not Covered",
            "SG_outpatientSurg_OON":"Not Covered",
            "SG_skilledNursing_OON":"Not Covered",
            "SG_inPatientHosp_INN":"20% Coins After Ded",
            "SG_inPatientHosp_OON":"Not Covered",
            "SG_inpatientMental_INN":"20% Coins After Ded",
            "SG_inpatientMental_OON":"Not Covered",
            "SG_HSA _INN":"Yes",
            "SG_HSA _OON":"Yes",
            "SG_ambula_INN":"$175 Copay",
            "SG_ambula_OON":"$175 Copay",
            "SG_emergRoom_INN":"$250 Copay",
            "SG_emergRoom_OON":"$500 Copay",
            "SG_urgentCareFacility_INN":"$100 Copay",
            "SG_urgentCareFacility_OON":"Not Covered",
            "ins_tj_dev__TotalInsuredFormula__c":null,
            "ins_tj_dev__Term__c":null,
            "ins_tj_dev__PricingFormula__c":"GroupPremium",
            "ins_tj_dev__IsConfigurable__c":false,
            "ins_tj_dev__RecordTypeName__c":"Product",
            "ins_tj_dev__PricingSource__c":null,
            "ins_tj_dev__ImageId__c":null,
            "ins_tj_dev__Tier__c":null,
            "ins_tj_dev__IsRecommended__c":false,
            "ins_tj_dev__RateBandId__c":null,
            "ins_tj_dev__SubType__c":"PPO",
            "ins_tj_dev__Type__c":"Medical",
            "ins_tj_dev__MarketSegment__c":"Small Group",
            "ins_tj_dev__LineOfBusiness__c":"Group Health",
            "ProductCode":"SG-PPO-35",
            "Family":"Other",
            "Description":null,
            "Name":"PPO 35",
            "Id":"01t4P000009AtC8QAK"
         },
         "headers":{
            "SG_CM_IsSpouse":"SG-Census-RF IsSpouse",
            "SG_CM_IsPrimary":"SG-Census-RF IsPrimary",
            "SG_CM_Smoker":"SG-Census-RF Smoker",
            "SG_CM_Gender":"SG-Census-RF Gender",
            "SG_CM_State":"SG-Census-RF State",
            "SG_CM_Age":"SG-Census-RF Age",
            "SG_CM_MemberClass":"SG-Census-RF MemberClass",
            "SG_empFamilyCount":"SG-Census-RF Employee + Family Count",
            "SG_empChildCount":"SG-Census-RF Employee + Child Count",
            "SG_empSpouseCount":"SG-Census-RF Employee + Spouse Count",
            "SG_empOnlyCount":"SG-Census-RF Employee Only Count",
            "SG_RetailDrugsT5_OON":"SG_Prescript_drugs Retail Drugs–Tier 5",
            "SG_RetailDrugsT5_INN":"SG_Prescript_drugs Retail Drugs–Tier 5",
            "SG_RetailDrugsT4_OON":"SG_Prescript_drugs Retail Drugs–Tier 4",
            "SG_RetailDrugsT4_INN":"SG_Prescript_drugs Retail Drugs–Tier 4",
            "SG_RetailDrugsT3_OON":"SG_Prescript_drugs Retail Drugs–Tier 3",
            "SG_RetailDrugsT3_INN":"SG_Prescript_drugs Retail Drugs–Tier 3",
            "SG_RetailDrugsT2_OON":"SG_Prescript_drugs Retail Drugs–Tier 2",
            "SG_RetailDrugsT2_INN":"SG_Prescript_drugs Retail Drugs–Tier 2",
            "SG_RetailDrugsT1_OON":"SG_Prescript_drugs Retail Drugs–Tier 1",
            "SG_RetailDrugsT1_INN":"SG_Prescript_drugs Retail Drugs–Tier 1",
            "SG_mailOrderDrugsT5_OON":"SG_Prescript_drugs Mail Order Drugs–Tier 5 (90-Day Supply)",
            "SG_mailOrderDrugsT5_INN":"SG_Prescript_drugs Mail Order Drugs–Tier 5 (90-Day Supply)",
            "SG_mailOrderDrugsT4_OON":"SG_Prescript_drugs Mail Order Drugs–Tier 4 (90-Day Supply)",
            "SG_mailOrderDrugsT4_INN":"SG_Prescript_drugs Mail Order Drugs–Tier 4 (90-Day Supply)",
            "SG_mailOrderDrugsT3_OON":"SG_Prescript_drugs Mail Order Drugs–Tier 3 (90-Day Supply)",
            "SG_mailOrderDrugsT3_INN":"SG_Prescript_drugs Mail Order Drugs–Tier 3 (90-Day Supply)",
            "SG_mailOrderDrugsT2_OON":"SG_Prescript_drugs Mail Order Drugs–Tier 2 (90-Day Supply)",
            "SG_mailOrderDrugsT2_INN":"SG_Prescript_drugs Mail Order Drugs–Tier 2 (90-Day Supply)",
            "SG_mailOrderDrugsT1_OON":"SG_Prescript_drugs Mail Order Drugs–Tier 1 (90-Day Supply)",
            "SG_mailOrderDrugsT1_INN":"SG_Prescript_drugs Mail Order Drugs–Tier 1 (90-Day Supply)",
            "SG_imaging_OON":"SG_Xray_Diagnostic Imaging",
            "SG_imaging_INN":"SG_Xray_Diagnostic Imaging",
            "SG_specialist_OON":"SG_Specialist Specialist",
            "SG_specialist_INN":"SG_Specialist Specialist",
            "SG_primaryCare_OON":"SG_Pri_Care_Visit Primary Care Visit",
            "SG_primaryCare_INN":"SG_Pri_Care_Visit Primary Care Visit",
            "SG_preventative_OON":"SG_Med_Base Preventive Services",
            "SG_preventative_INN":"SG_Med_Base Preventive Services",
            "SG_lifetimeMax_OON":"SG_Med_Base Lifetime Maximum",
            "SG_lifetimeMax_INN":"SG_Med_Base Lifetime Maximum",
            "SG_coinsurance_OON":"SG_Med_Base Coinsurance",
            "SG_coinsurance_INN":"SG_Med_Base Coinsurance",
            "SG_annualOOP_OON":"SG_Med_Base Annual OOP Limit",
            "SG_annualOOP_INN":"SG_Med_Base Annual OOP Limit",
            "SG_annualDed_OON":"SG_Med_Base Annual Deductible",
            "SG_annualDed_INN":"SG_Med_Base Annual Deductible",
            "SG_skilledNursing_OON":"SG_Lab_Outpat_Prof Skilled Nursing Facility Care",
            "SG_skilledNursing_INN":"SG_Lab_Outpat_Prof Skilled Nursing Facility Care",
            "SG_outpatientSurg_OON":"SG_Lab_Outpat_Prof Outpatient Surgery",
            "SG_outpatientSurg_INN":"SG_Lab_Outpat_Prof Outpatient Surgery",
            "SG_outpatientRehab_OON":"SG_Lab_Outpat_Prof Outpatient Rehab Services",
            "SG_outpatientRehab_INN":"SG_Lab_Outpat_Prof Outpatient Rehab Services",
            "SG_outpatientMental_OON":"SG_Lab_Outpat_Prof Outpatient Mental Health",
            "SG_outpatientMental_INN":"SG_Lab_Outpat_Prof Outpatient Mental Health",
            "SG_outpatientXray_OON":"SG_Lab_Outpat_Prof Outpatient Lab/X-Ray",
            "SG_outpatientXray_INN":"SG_Lab_Outpat_Prof Outpatient Lab/X-Ray",
            "SG_inpatientMental_OON":"SG_Hosp_based_Serv In-Patient Mental Health",
            "SG_inpatientMental_INN":"SG_Hosp_based_Serv In-Patient Mental Health",
            "SG_inPatientHosp_OON":"SG_Hosp_based_Serv In-Patient Hospital Care",
            "SG_inPatientHosp_INN":"SG_Hosp_based_Serv In-Patient Hospital Care",
            "SG_HSA _OON":"SG_HSA Health Savings Account Eligible",
            "SG_HSA _INN":"SG_HSA Health Savings Account Eligible",
            "SG_urgentCareFacility_INN":"SG_Emerg_Serv Urgent Care Facility",
            "SG_emergRoom_OON":"SG_Emerg_Serv Emergency Room",
            "SG_urgentCareFacility_OON":"SG_Emerg_Serv Urgent Care Facility",
            "SG_emergRoom_INN":"SG_Emerg_Serv Emergency Room",
            "SG_ambula_OON":"SG_Emerg_Serv Ambulance",
            "SG_ambula_INN":"SG_Emerg_Serv Ambulance",
            "ins_tj_dev__TotalInsuredFormula__c":"Total Insured Formula",
            "ins_tj_dev__Term__c":"Term",
            "ins_tj_dev__PricingFormula__c":"Pricing Formula",
            "ins_tj_dev__IsConfigurable__c":"Configurable",
            "ins_tj_dev__RecordTypeName__c":"Record Type Name",
            "ins_tj_dev__PricingSource__c":"Pricing Source Mapping",
            "ins_tj_dev__ImageId__c":"Image",
            "ins_tj_dev__Tier__c":"Tier",
            "ins_tj_dev__IsRecommended__c":"Recommended",
            "ins_tj_dev__RateBandId__c":"Rate Band",
            "ins_tj_dev__SubType__c":"Sub Type",
            "ins_tj_dev__Type__c":"Type",
            "ins_tj_dev__MarketSegment__c":"Market Segment",
            "ins_tj_dev__LineOfBusiness__c":"Line of Business",
            "ProductCode":"Product Code",
            "Family":"Product Family",
            "Description":"Product Description",
            "Name":"Product Name",
            "Id":"Product ID"
         }
      }
   ]
}
 
Ladataan
Salesforce Help | Article