This page provides the complete list of SearchConfig options available in the VBAPI search system.
Each SearchConfig defines a logical grouping of database tables that can be queried together through the search API. Understanding which tables are included in each configuration helps you determine what data is accessible for your search queries.
- Find your use case: Look for SearchConfigs that match your data needs
- Check available tables: Review which tables are accessible in each configuration
- Plan your SearchCriteria: Use the table names to construct your filter conditions
- Select your fields: Choose which columns to return in your SearchRequest
| Search Config Name | Tables |
|---|---|
| ADMISSIONTYPEPLACE | AdmissionTypePlace |
| APCCODE | APCCodes |
| ARMORCODEEXCODE | ArmorCodeExCode |
| AUTH | Members, Auth, AuthType, Users, SubEnrollment, Provider, AuthCode, AuthStatus |
| AUTHCODE | AuthCode |
| AUTHREVIEWLEVEL | AuthReviewLevel |
| AUTHREVIEWSEVERITY | AuthReviewSeverity |
| AUTHREVIEWSTATUS | AuthReviewStatus |
| AUTHREVIEWTYPE | AuthReviewType |
| AUTHREVIEWURGENCYTYPE | AuthReviewUrgencyType |
| AUTHTYPE | AuthType |
| AUTHUNITCONVERSION | UnitConversion |
| AUTHUNITTYPE | UnitType |
| BENEFIT | BenefitProviderTypes, BenefitProcedures, BenefitDiagCodes, BenefitCodes, BenefitPlace, BenefitSpecialty, BenefitCategory |
| BENEFITCATEGORY | BenefitCategory |
| BENPLAN | BenefitCodes, PlanBenefits, Plans |
| BILLINGCYCLE | BillingCycle |
| BILLTYPE | BillType |
| BROKERAGE | Brokerage |
| CALLDESTINATION | CallTrackingCallDestination |
| CALLERTYPE | CallTrackingCallerType |
| CALLSTATUS | CallTrackingCallStatus |
| CALLTRACK | SubEnrollment, Provider, CallTracking, CallTrackingSubscriber, Groups, Members |
| CALLTYPE | CallTrackingCallType |
| CAPADJ | CapitationAdjustment |
| CAPGENTRANS | CAPITATIONGENTRANSLIST |
| CAPITATIONADJUSTMENTREASON | CapitationAdjustmentReason |
| CAPITATIONADJUSTMENTTYPE | CapitationAdjustmentType |
| CAPITATIONPLANRATE | CapitationPlanRate |
| CARECASE | GroupDivision, CareCaseTreatment, CareCaseProvider, CareCaseWorkLog, CareCase, CareCaseIntake, CaseReason, CareCaseAuth, Provider, CareManager, CareCaseDiagnosis, CareManagerCase, Users, Groups, CareCaseSavings, CarePlan, CareCaseClinicalTrial, Members, CareCaseMedication, CareCaseClinicalFact |
| CARECASEACTIONDATE | CARECASEACTIONDATE |
| CARECASECLINICALFACTCATEGORY | CareCaseClinicalFactCategory |
| CARECASECLINICALTRIALARM | CareCaseClinicalTrialArm |
| CARECASECLINICALTRIALREASON | CareCaseClinicalTrialReason |
| CARECASECLINICALTRIALSTUDYPHASE | CareCaseClinicalTrialStudyPhase |
| CARECASECONCORDANCE | CareCaseConcordance |
| CARECASEDETAIL | CareCaseDetail, CareCase |
| CARECASEELIGIBILITYSTATUS | CareCaseEligibilityStatus |
| CARECASEEMETICRISK | CareCaseEmeticRisk |
| CARECASEINTAKETYPE | CareCaseIntakeType |
| CARECASEINTENT | CareCaseIntent |
| CARECASELOAD | CARECASELOAD |
| CARECASELOADBREAKDOWN | CARECASELOADBREAKDOWN |
| CARECASELOADWEIGHTED | CARECASELOADWEIGHTED |
| CARECASELOGENTRYTYPE | CareCaseLogEntryType |
| CARECASELOT | CareCaseLot |
| CARECASEMANAGERCASE | CARECASEMANAGERCASELIST |
| CARECASENEUTROPENICRISK | CareCaseNeutropenicRisk |
| CARECASENODETAIL | Members, CarePlan, GroupDivision, Provider, CARECASELIST, CareManagerCase, CareCase, Groups |
| CARECASERECOMMEND | CARECASERECOMMENDLIST |
| CARECASESAVINGSTYPE | CareCaseSavingsType |
| CARECASESTAGE | CareCaseStage |
| CARECASETREATMENTTYPE | CareCaseTreatmentType |
| CARECASEWORKLOGTYPE | CareCaseWorkLogType |
| CAREMANAGERAUTH | Users, CareManager, AuthStatus, Auth, Members |
| CAREMANAGERCASE | CareManager, CareManagerCase, Users |
| CAREMANAGERTYPE | CareManagerType |
| CAREMANAGERUSER | Users, CareManager |
| CAREMGR | CareManager |
| CAREPLAN | CarePlan |
| CARETYPE | CareType |
| CASEATTACHMENTTYPE | CaseAttachmentType |
| CASECLOSEREASON | CaseCloseReason |
| CASEHEAD | CaseHead |
| CASEHEADTYPE | CaseHeadType |
| CASEMEDICALCONCORDANCELEVEL | CaseMedicalConcordanceLevel |
| CASEPRIORITY | CasePriority |
| CASEREASON | CaseReason |
| CASESTATUS | CaseStatus |
| CASESTATUSREASON | CaseStatusReason |
| CDC_OPTIONS | CDC_OPTIONS |
| CHECKBATCH | CheckBatch |
| CHECKEDIT | CheckEditSetDetail, CheckEdit |
| CHECKRUNCAND | CHECKRUNCANDIDATELIST |
| CHECKS | CheckExport, CHECKTOTALS, Checks, CHECKEXPORTLATEST |
| CHECKVOIDDET | CHECKVOIDDETAIL |
| CLAIM | CLAIMTOTALS, Plans, Payee, Provider, GroupDivision, ClaimInvoiceDetail, Members, Checks, CheckBatch, ClaimAuditDetail, FundingAccount, Subscribers, ClaimDetail, Claim, CLAIMPROCESSDATEUSER, Groups, ReinsContractTransClaim, Payor, CheckExport |
| CLAIMADJUDICATEAUTORATE | CLAIMADJUDICATEAUTORATE |
| CLAIMADJUDICATEDURATION | CLAIMADJUDICATEDURATION |
| CLAIMADJUDICATESUMMARY | CLAIMADJUDICATESUMMARY |
| CLAIMANDCLAIMBATCH | Payor, CheckBatch, Provider, ReinsContractTransClaim, CLAIMANDCLAIMBATCHPAYTO, Plans, Checks, CheckExport, Groups, Payee, CLAIMANDCLAIMBATCH, CLAIMANDCLAIMBATCHTOTALS, ClaimBatch, CostContainZelisClaimReprice, Claim, CLAIMANDCLAIMBATCHDETAIL, Members |
| CLAIMANDCLAIMBATCHDETAIL | CLAIMANDCLAIMBATCHDETAIL |
| CLAIMANESTHESIAMODIFIERUNIT | ClaimAnesthesiaModifierUnit |
| CLAIMANESTHESIAPLACECODEUNIT | ClaimAnesthesiaPlaceCodeUnit |
| CLAIMANESTHESIAPROCEDURECODEUNIT | ClaimAnesthesiaProcedureCodeUnit |
| CLAIMAUDIT | ClaimAudit |
| CLAIMAUDITAPPEALREASON | ClaimAuditAppealReason |
| CLAIMAUDITAPPEALRESULT | ClaimAuditAppealResult |
| CLAIMAUDITCLAIM | Claim, ClaimAuditDetail, CLAIMPROCESSDATEUSER, CLAIMTOTALS |
| CLAIMAUDITRESULT | ClaimAuditResult |
| CLAIMAUDITSTATUS | ClaimAuditStatus |
| CLAIMAUDITSUMMARY | CLAIMAUDITSUMMARY |
| CLAIMBATCH | ClaimBatch, ClaimBatches, Provider, Members, CLAIMBATCHTOTALS, ProcedureCode, MemberBeneficiary, ClaimBatchDetail |
| CLAIMBATCHAUTHMATCH | CLAIMBATCHAUTHMATCH |
| CLAIMBATCHDETAILBENEFIT | ClaimBatchDetailBenefit |
| CLAIMBATCHDETAILERROR | CLAIMBATCHDETAILERRORLIST |
| CLAIMBATCHERROR | CLAIMBATCHERRORLIST |
| CLAIMBATCHES | CLAIMBATCHESCLAIMCOUNT, CLAIMBATCHESMAXCLAIM, ClaimBatches |
| CLAIMCODINGRULE | ClaimCodingRule |
| CLAIMCONDITIONCODE | ClaimConditionCode |
| CLAIMCUSTOMEXCODERULE | ClaimCustomExCodeRule |
| CLAIMDEDUCTIONTYPE | ClaimDeductionType |
| CLAIMDEDUCTIONTYPERESTRICTED | CLAIMDEDUCTIONTYPERESTRICTED |
| CLAIMDENTAL | ToothProcedure, Tooth, Claim, MemberTooth, ClaimDetail |
| CLAIMDETAILEXCODEDEF | CLAIMDETAILEXCODEHIPAALIST |
| CLAIMDETAILPRESUBMISSION | CLAIMDETAILPRESUBMISSION |
| CLAIMEXCODEDEF | CLAIMEXCODEHIPAALIST |
| CLAIMFUNDEDSTATUS | ClaimFundedStatus |
| CLAIMINJQUIRY | CLAIMEXCODEHIPAALIST, Members, Checks, Claim, ClaimStatus, CLAIMPAYTO, BenefitCodes, Provider, CLAIMTOTALS, CLAIMDETAILEXCODEHIPAALIST |
| CLAIMINV | CLAIMINVOICETOTALS, ClaimInvoice |
| CLAIMINVOICEADJUSTMENTREASON | ClaimInvoiceAdjustmentReason |
| CLAIMLIFE | CLAIMLIFE |
| CLAIMLIFEBEN | PlanBenefits, BenefitCodes, SubEnrollmentPlan |
| CLAIMLIFEMEM | CLAIMLIFEMEMLIST |
| CLAIMLIFEPAY | CLAIMLIFEPAYMENTLIST |
| CLAIMOCCURRENCECODE | ClaimOccurrenceCode |
| CLAIMOFFSETSUMMARY | CLAIMOFFSETSUMMARY |
| CLAIMPOTENTIALADJ | POTENTIALCLAIMADJUSTMENTS |
| CLAIMPREBATCH | ClaimPreBatch |
| CLAIMPREBATCHDETAIL | ClaimPreBatchDetail |
| CLAIMPRESUBMISSION | CLAIMPRESUBMISSION |
| CLAIMPROMPTPAY | ClaimPromptPay |
| CLAIMQUEUE | ClaimQueue |
| CLAIMQUEUELOG | ClaimQueueLog |
| CLAIMREF | Members, Provider, CLAIMREF |
| CLAIMREPRICEREMOVE | ClaimRepriceRemove |
| CLAIMRULE | ClaimRule |
| CLAIMSUSPENSECRIT | ProviderNetwork, ClaimExCode, CostContainZelisClaimReprice, Provider, CLAIMTOTALS, ClaimDetail, Members, ClaimTransaction, Claim |
| CLAIMVALUECODE | ClaimValueCode |
| CLASS | Class |
| CLIACERTIFICATE | CLIACertificate |
| CLMBATCHPLN | Plans, ClaimBatchPlan |
| CLMFLEX | Subscribers, ClaimFlex, GroupFlex, SubscriberFlex |
| CLMREPORT | ClaimReport, ReportDefinition |
| COLLEGE | College |
| COLLEGETYPE | CollegeType |
| COLUMNDESCRIPTION | COLUMNDESCRIPTION |
| COMMACTIVELIC | COMMACTIVELICENSELIST |
| COMMADJ | CommissionAgencyRep, CommissionAgency, CommissionRep, CommissionAdjustment |
| COMMAGENCY | CommissionAgencyRep, CommissionRep, CommissionAgency |
| COMMAGENTSPLIT | COMMAGENTSPLIT |
| COMMCALCAGENCY | COMMCALCAGENCYLIST |
| COMMCALCAGENT | COMMCALCAGENTLIST |
| COMMCHECKDETAIL | COMMCHECKDETAIL |
| COMMCHECKS | COMMCHECKS |
| COMMGENTRANS | COMMGENTRANSLIST |
| COMMISSIONACTIVITY | CommissionActivity |
| COMMISSIONADJUSTMENTREASON | CommissionAdjustmentReason |
| COMMISSIONADJUSTMENTTYPE | CommissionAdjustmentType |
| COMMISSIONAGENCYTYPE | CommissionAgencyType |
| COMMISSIONAPPOINTMENTTYPE | CommissionAppointmentType |
| COMMISSIONBASIS | CommissionBasis |
| COMMISSIONCATEGORY | CommissionCategory |
| COMMISSIONCYCLE | CommissionCycle |
| COMMISSIONLICENSETYPE | CommissionLicenseType |
| COMMISSIONRATECLUSTER | CommissionRateCluster |
| COMMISSIONREP | CommissionRep |
| COMMISSIONREPTYPE | CommissionRepType |
| COMMRATE | CommissionRate |
| COMMRATETEMPLATECLUSTER | COMMRATETEMPLATECLUSTER |
| COMMREPACCT | FundingAccount, CommissionRepAccount |
| COMMREPCOMMISSION | COMMREPCOMMISSIONLIST |
| COMMREPGRPDIV | Groups, GroupDivision, CommissionRepGroup |
| COMMREPRATE | COMMREPRATELIST |
| COMMREPSUB | Subscribers, CommissionRepSubscriber |
| COMMREPWRITINGAGENT | COMMREPWRITINGAGENTLIST |
| COMMTRANS | CommissionAgency, CommissionRep, CommissionAgencyRep, Commission, CommissionAgencyRepRate, CommissionRate |
| COMMUNICATIONMETHOD | CommunicationMethod |
| COMPDATAEXCODELIST | COMPDATAEXCODELIST |
| CONTACT | Contact |
| CONTACTASSIGN | Contact, ContactAssign |
| CONTACTCATEGORY | ContactCategory |
| CONTACTSTATUS | ContactStatus |
| CONTEXT4CASEINDEX | CostContainContext4CaseIndex |
| CONTEXT4CATEGORY | CostContainContext4Category |
| CONTEXT4DEFAULTACTION | CostContainContext4DefaultAction |
| CONTEXT4MESSAGETYPE | CostContainContext4MessageType |
| CONTRIBUTIONSCHEDULE | ContributionSchedule |
| CORRTRACKAUTH | Auth, CORRTRACKAUTH |
| CORRTRACKMEMBER | CORRTRACKMEMBER, Members |
| COSTCONTAINCONTEXT4EXCODE | CostContainContext4ExCode |
| COSTCONTAINZELISEDITCODE | CostContainZelisEditCode |
| COSTCONTAINZELISEOBCODE | CostContainZelisEOBCode |
| COUNTRY | Country |
| COUNTY | County |
| COVERAGETYPE | CoverageType |
| CREDAMOUNT | CredAmount |
| CREDATTESTATIONMETHOD | CredAttestationMethod |
| CREDATTESTATIONQUESTION | CredAttestationQuestion |
| CREDATTESTATIONSOURCE | CredAttestationSource |
| CREDATTESTATIONTYPE | CredAttestationType |
| CREDCARRIER | CredCarrier |
| CREDCERTIFICATION | CredCertification |
| CREDCONFIDENTIAL | CredConfidential |
| CREDCONTRACT | CredContract |
| CREDDATE | CredDate |
| CREDEDUCATIONTYPE | CredEducationType |
| CREDLICENSETYPE | CredLicenseType |
| CREDOPTION | CredOption |
| CREDPRACTICECATEGORY | CredPracticeCategory |
| CREDPRACTICETYPE | CredPracticeType |
| CREDQUALITY | CredQuality |
| CREDSERVICE | CredService |
| CREDSTATUS | CredStatus |
| CREDTECHNIQUE | CredTechnique |
| CREDTERMINATION | CredTermination |
| CREDTYPE | CredType |
| CRITERIA | Criteria |
| CURRENCY | Currency |
| CURRENCYEXCHANGERATE | CurrencyExchangeRate |
| DAYINTERVAL | DayInterval |
| DIAGNOSTICCODE | DiagnosticCode |
| DIAGNOSTICCODEGROUP | DiagnosticCodeGroup |
| DISABILITYSUMMARY | CLAIMDISABILITYSUMMARY |
| DISABILITYTAXYEARSUMMARY | CLAIMDISABILITYTAXYEARSUMMARY |
| DISASTER | Disaster, DisasterLocation |
| DRGCLUSTER | DRGCluster |
| DRGCODE | DRGCodes |
| DRUGCODE | DrugCode |
| DUPESET | DuplicateMaster, DuplicateMasterSet, DuplicateSet |
| EDICODEMAP | EDICodeMap |
| ELIGIBILITYSTATUS | EligibilityStatus |
| ENROLLMENT | Relationships, MemberEligibilityStatus, Plans, Groups, Subscribers, PlanType, MemberAddress, CaseHead, SubEnrollment, Members, GroupContract, SubEnrollmentPlan, MemEnrollmentPlan |
| ENROLLMENT_MEMPRIORACCUM | BenefitCodes, GroupPlanYear, Plans, GroupDivision, Members, Groups, GroupContractPlan, PlanType, SubEnrollment, PlanBenefits |
| ENROLLMENT_SUBPRIORACCUM | PlanType, BenefitCodes, GroupDivision, Plans, PlanBenefits, GroupPlanYear, GroupContractPlan, Groups, Subscribers, SubEnrollment |
| ENROLLMENTWAITINGPERIOD | Groups, GroupDivision, Plans, EnrollmentWaitingPeriod |
| ERRORCATEGORYTYPE | ErrorCategoryType |
| ETHNICITYCODE | EthnicityCode |
| EVENT | Event, Users |
| EVENTARG | EVENTARGLIST |
| EXCODECAT | ExplanationCodeCategory, ExplanationCodes |
| EXPENSETYPE | ExpenseType |
| EXPLANATIONCODE | ExplanationCodes |
| EXPLANATIONCODECATEGORY | ExplanationCodeCategory |
| EXPLORERLIST | ObjectList, ExplorerList |
| EXTERNALID | ExternalID |
| FEESCHED | FeeSched |
| FEESCHEDDET | GroupUCPercentClaimType, Specialty, ExplanationCodes, ProviderTypes, FeeSchedDetail |
| FEESCHEDMODIFIEREXCLUDE | FeeSchedModifierExclude |
| FIELDSECURITY | USERFIELDSECURITY, Users |
| FILTER | Filter |
| FILTERDATESCRITERIA | FILTERDATESCRITERIALIST |
| FLEXCALC | FLEXCALCLIST |
| FLEXCLMSUMMARY | FLEXCLAIMSUMMARYLIST |
| FLEXDET | FLEXDETLIST |
| FLEXVENDOR | FlexVendor |
| FORFEITURESTATUS | ForfeitureStatus |
| FUNDACCOUNTBALANCE | FUNDACCOUNTBALANCELIST |
| FUNDCLAIM | FUNDCLAIMLIST |
| FUNDCLAIM_TF | GETFUNDCLAIMLIST |
| FUNDCLAIMVALIDATEMEMBERPAYTO | FUNDCLAIMVALIDATEMEMBERPAYTO |
| FUNDCLAIMVALIDATEPAYTO | FUNDCLAIMVALIDATEPAYTO |
| FUNDING | Funding |
| FUNDINGACCOUNT | FundingAccount |
| FUNDINGACCOUNTTYPE | FundingAccountType |
| FUNDINGCHECKEDITRESULT | CheckEdit, FUNDINGCHECKEDITRESULT |
| FUNDINGDEP | Funding, FundingDeposit |
| FUNDINGDEPAMOUNT | FUNDINGDEPOSITAMOUNT, Payor, FundingDeposit, PayorAccount, FundingAccount |
| FUNDINGEMPLOYEE | FundingAccount, FUNDINGACCOUNTGROUP |
| FUNDINGINDICATOR | FundingIndicator |
| FUNDINGINVADDRESS | FUNDINGINVALIDADDRESS |
| FUNDINGINVADDRESSCLAIM | FUNDINGINVALIDADDRESSCLAIM |
| FUNDINGISSUETYPE | FundingIssueType |
| FUNDINGRECONCILE | FundingReconcile |
| FUNDINGRECONCILESTATUS | FundingReconcileStatus |
| FUNDINGREQUEST | FundingRequest |
| FUNDINGREQUESTSTATUS | FundingRequestStatus |
| FUNDINGREQUESTTYPE | FundingRequestType |
| FUNDINGSTATUS | FundingStatus |
| FUNDINGTRANS | FUNDINGTRANSFERCOMBINED |
| FUNDINGTYPE | FundingType |
| FUNDRECONCREDIT | FUNDRECONCREDIT |
| FUNDRECONDEBIT | FUNDRECONDEBIT |
| FUNDREQCLAIMLIST | FUNDREQCLAIMLIST |
| GENDER | Gender |
| GRIEV | GrievanceCategory, GRIEVRELATEDNOTES, Grievance, GrievanceStatus, GrievanceType, Members, Provider |
| GRIEVANCEADMINCHANGETYPE | GrievanceAdminChangeType |
| GRIEVANCECATEGORY | GrievanceCategory |
| GRIEVANCEISSUETYPE | GrievanceIssueType |
| GRIEVANCERESOLUTIONTYPE | GrievanceResolutionType |
| GRIEVANCESTATUS | GrievanceStatus |
| GRIEVANCETYPE | GrievanceType |
| GRIEVFILE | CallTracking, FILEGRIEVANCESOURCE |
| GROUP | Groups, GroupDivision |
| GROUPCONTRACT | Groups, GroupContract, GroupDivision |
| GROUPDIVCAP | GroupDivisionCaptive |
| GROUPPARINC | GroupsParticipationIncentive |
| GROUPPLAN | GroupDivision, GroupContractPlan, PlanType, Groups, Plans |
| GROUPTIER | GroupContractTier, Tier |
| GROUPVOL | GroupVolume |
| GRPINTERVAL | DayInterval, GroupDayInterval |
| HIPAAADJUSTMENTCODE | HIPAAAdjustmentCode |
| HIPAABENEFITCODE | HIPAABenefitCode |
| HIPAACLAIMSTATUSCATEGORYCODE | HIPAAClaimStatusCategoryCode |
| HIPAACLAIMSTATUSCODE | HIPAAClaimStatusCode |
| HIPAAPLANTYPE | HIPAAPlanType |
| HIPAAREASON | HIPAAReason |
| HIPAARELATIONSHIP | HIPAARelationship |
| HIPAAREMITTANCECODE | HIPAARemittanceCode |
| HIPAATIER | HIPAATier |
| IDCARDREQ | PA_TRACKING_LATEST_IDCARDREQUEST, IDCardRequest |
| IDCARDSELECT | GroupFlex, Relationships, Members, SubEnrollment, SubEnrollmentPlan |
| IDCODE_FULL | IDCodeValue, IDCodeType |
| IDCODETYPE | IDCodeType |
| INSURANCECARRIER | InsuranceCarrier |
| INSURANCECARRIERTYPE | InsuranceCarrierType |
| INSURANCETYPE | InsuranceType |
| INVADJREC | PremInvoiceAdjReceived, PremInvoicePayment, PremPayment, PremInvoiceAdjustment |
| INVCAT | INVOICECATEGORYTOTALS |
| INVEXISTPAYMENT | INVOICEEXISTINGPAYMENTLIST |
| INVFINAL | PremInvoiceSubscriber, PremInvoice |
| INVGROUPCAT | INVOICECATEGORYGROUPTOTALS |
| INVOICEREASON | InvoiceReason |
| INVPAYMENT | INVOICEPAYMENTLIST |
| INVRATE | INVOICERATELIST |
| INVREC | PremInvoiceReceived, PremPayment, PremInvoicePayment |
| INVSUB | INVOICESUBSCRIBERTOTALS |
| INVSUBPLAN | INVOICESUBSCRIBERPLANTOTALS |
| INVSUBPLANSUMMARY | INVOICESUBSCRIBERPLANSUMMARY |
| IPWHITELIST | IPWhitelist |
| ISSUEDURATIONVALUE | IssueDurationValue |
| JOBCRITERIA_CHECKBATCH | JOBCRITERIA_CHECKBATCH |
| JOBS | JOBLIST |
| JOBSEXECDETAIL | JOBEXECUTIONDETAIL |
| JOBSEXECMETA | JobExecutionMetaData |
| JOBSHISTORY | JOBHISTORYLIST |
| JOBSINPROCESS | JOBINPROCESSLIST |
| LANGUAGE | Languages |
| MARITALSTATUS | MaritalStatus |
| MATRIXBENPLACE | SPDMATRIX_BENPLACE |
| MATRIXCOVPROC | SPDMATRIX_COVPROC |
| MATRIXNOTE | SPDMATRIX_NOTE |
| MATRIXPBM | SPDMATRIX_PBM |
| MATRIXPLANBENMAX | SPDMATRIX_PLANBENMAX |
| MATRIXPREAUTH | SPDMATRIX_PREAUTH |
| MEMACCT | Members, MemberAccount, Relationships, FundingAccount |
| MEMACCUM | MemberAccum, Members |
| MEMBENPLAN | MemberBeneficiary, MemberBeneficiaryPlan |
| MEMBERBENEFICIARY | MemberBeneficiary |
| MEMENROLLMENTBENEFITVOLUME | MEMENROLLMENTBENEFITVOLUME |
| MEMPRIMARYNETWORK | MEMPRIMARYNETWORK |
| MEMPRIORACCUM | MemberPriorAccum, Members |
| MODIFIER | Modifier |
| MYWORKFLOWAUTHS | Members, Provider, SubEnrollment, WORKFLOWAUTHS, Auth, Users |
| MYWORKFLOWCHECKS | WORKFLOWCHECKS, Checks, CheckExport |
| MYWORKFLOWCLAIMS | ProcedureCode, ClaimBatch, ClaimBatchDetail, MemberBeneficiary, Provider, ClaimBatches, Members, WORKFLOWCLAIMS |
| MYWORKFLOWENROLLMENTS | MemberCaseHead, MemEnrollmentPlan, SubEnrollmentPlan, Subscribers, Groups, MemberAddress, SubEnrollment, WORKFLOWENROLLMENTS, CaseHead, GroupContract, Members, MemberEligibilityStatus |
| NETPROFILEPROV | NETPROFILEPROV |
| NETWORK | Networks |
| NETWORKPROFILE | NetworkProfile |
| NOTE | NoteData, Users, Subscribers, NoteCategory, NOTEMEMBERLIST, NoteSource, Members |
| NOTECATEGORY | NoteCategory |
| NOTEPRIORITY | NotePriority |
| NOTETYPE | NoteType |
| OCCUPATION | Occupation |
| PAYACCTFUND | FundingAccount, Payor, PAYORACCOUNTCLAIMCOUNT, PayorAccount |
| PAYACTIVITYGROUPSUMMARY | PAYACTIVITYGROUPSUMMARY |
| PAYACTIVITYINVOICESUMMARY | PAYACTIVITYINVOICESUMMARY |
| PAYEE | Payee |
| PAYMENTMETHOD | PaymentMethod |
| PAYMENTSCHEDULE | PaymentSchedule |
| PAYOR | Payor |
| PBMTYPE | PBMType |
| PLACECODE | PlaceCodes |
| PLANADDEDACCUM | PlanAddedAccum |
| PLANADDEDACCUMBENEFIT | PlanAddedAccumBenefits |
| PLANBENEFIT | BenefitCodes, BenefitCategory, PlanType, PlanBenefits, Plans |
| PLANCOORDINATION | PlanCoordination |
| PLANDISPLAYTYPE | PlanDisplayType |
| PLANLINEAGE | PlanLineage |
| PLANMAXDESC | PLANMAXDESC |
| PLANS | Plans, PlanType |
| PLANTYPE | PlanType |
| PMTONACCT | PremPaymentOnAccount, Subscribers, PremPayment |
| POLICYFORFEITUREEXT | PolicyForfeitureExt |
| POLICYSTATUS | PolicyStatus |
| PRACTICETYPE | PracticeType |
| PREMDIST | Subscribers, PremRateCategory, PremRate, PremDistribution, PremInvoice |
| PREMDISTCHECKS | PREMDISTRIBUTIONCHECKS |
| PREMINVOICE | Subscribers, INVOICELIST, PremInvoiceSubscriber |
| PREMINVOICEADJ | Subscribers, PremInvoicePayment, SUBSCRIBERMEMIDLIST, PremInvoiceAdjustment, Groups, PremInvoice, InvoiceReason, PremPayment, PremRate, PremInvoiceSubscriberDetail, PremInvoiceAdjReceived |
| PREMINVPAY | PremInvoicePayment, PremPayment, PREMINVPAYMENTLIST, PremInvoice |
| PREMPASTDUETRIGGER | PremPastDueTrigger |
| PREMPAYMENT | PREMPAYMENTLIST |
| PREMPAYMENTTYPE | PremPaymentType |
| PREMRATEADDON | PlanType, PremRateCategory, PremRate, PremRateBasis, Tier, PremRateType |
| PREMRATEADJ | PremRate, PremRateBasis, PremRateType, Tier, PremRateCategory, PlanType |
| PREMRATEALL | Tier, PlanType, PremRateCategory, PremRate, PremRateType, PremRateBasis |
| PREMRATEAPP | PremRateType, PremRate, PlanType, Tier, PREMRATEDESC, PremRateBasis, PremRateCategory |
| PREMRATEBASIS | PremRateBasis |
| PREMRATECATEGORY | PremRateCategory |
| PREMRATECOBRASELECT | SubEnrollmentPlan, PremRate |
| PREMRATEEXP | PlanType, PremRate, PremRateBasis, PremRateType, Tier, PremRateCategory |
| PREMRATEMEM | PremRateBasis, PlanType, PremRateCategory, PremRateType, Tier, PremRate |
| PREMRATEMINMAX | PremRateMinMax, Groups, Subscribers, GroupDivision |
| PREMRATEPAYEE | PremRatePayee, Payee, Payor, FundingAccount |
| PREMRATESELF | PremRateCategory, PremRateBasis, PremRate, PlanType, Tier, PremRateType |
| PREMRATESYS | PremRate, PlanType, PremRateBasis, PremRateCategory, PremRateType, Tier |
| PREMRATETEMP | PremRate, PlanType, PremRateType, PremRateCategory, PremRateBasis, Tier |
| PREMRATETEMPSELF | Tier, PremRateCategory, PremRateBasis, PlanType, PremRateType, PremRate |
| PROCEDURECATEGORY | ProcedureCategory |
| PROCEDURECLUSTER | ProcedureCluster |
| PROCEDURECODE | ProcedureCode |
| PROCEDURECODEQUALIFIER | ProcedureCodeQualifier |
| PROCEDUREGROUP | ProcedureGroup |
| PROV | Provider, ProviderNetwork, ProviderPayee, Specialty, ProviderTypes, ProviderSpecialty, Networks, Payee, ProviderLanguages |
| PROVACCOUNT | Provider, ProviderAccount, FundingAccount |
| PROVCRED | Provider, ProviderCred |
| PROVCREDOFFICE | State, Payee, PROVCREDOFFICE |
| PROVIDERROLE | ProviderRole |
| PROVIDERWITHHOLD | ProviderWithhold |
| PROVPAYEE | Provider, Payee, ProviderPayee |
| PROVPROFILE | ProviderSpecialty, ProviderProfile, Specialty, Provider, ProviderLanguages, ProviderNetwork, ProviderPayee, Payee |
| PROVTYPE | ProviderTypes |
| PYRFILTER | Filter, PayorFilter |
| REASON | Reasons |
| REIMBURSESCHEDULE | ReimburseSchedule |
| REINSCLAIM | REINSTRANSCLAIMLIST |
| REINSCONTRACT | ReinsContract |
| REINSCONTRACTCONDITIONALSPECIFIC | ReinsContractConditionalSpecific |
| REINSCONTRACTCYCLE | ReinsContractCycle |
| REINSCONTRACTSTATUS | ReinsContractStatus |
| REINSCONTRACTTYPE | ReinsContractType |
| REINSMEMBERLOSS | REINSMEMBERLOSS |
| REINSMEMCONDITIONALSPECIFIC | REINSMEMCONDITIONALSPECIFIC |
| REINSTIER | REINSFILTEREDTIERLIST |
| REINSTRANS | ReinsContractTrans, REINSTRANSSUMMARY, ReinsContract, Members, Groups |
| REINSTRANSGEN | REINSTRANSGENERATELIST |
| REINSTRANSREIMBURSE | Funding, ReinsContractTransReimburse |
| REINSURANCEOPTION | ReinsuranceOption |
| RELATIONSHIP | Relationships |
| REPORTCATEGORY | ReportCategory |
| REPORTDEF | ReportCategory, ReportDefinition |
| RPTSERIES | ReportSeries, ReportSeriesStep, ReportSeriesStepArg |
| RPTSERIESTMPLT | REPORTSERIESTEMPLATECOUNT |
| SECURITYAREA | SecurityArea |
| SECURITYLEVEL | SecurityLevel |
| SIGNATURE | Signature |
| SPECIALTY | Specialty |
| STATE | State |
| STATEINTEREST | StateInterest, State |
| SUBACCUM | Subscribers, SubscriberAccum |
| SUBBEN | SUBSCRIBERBENLIST |
| SUBENROLLMENT | SubEnrollment, GroupDivision, Subscribers, Groups |
| SUBENROLLMENTBENEFITVOLUME | SUBENROLLMENTBENEFITVOLUME |
| SUBENROLLMENTPLANVOLUME | SUBENROLLMENTPLANVOLUME |
| SUBFLEX | Groups, SubscriberFlex, Plans, Subscribers, GroupFlex |
| SUBPAYMENTMETHOD | SubPaymentMethod |
| SUBPLANFLEX | Plans, GroupFlex, Groups, SubEnrollmentPlan |
| SUBPOLICYCASHVAL | SubscriberPlanPolicy, SUBSCRIBERPLANPOLICYCASHVALUE |
| SUBPOLICYFORF | SUBSCRIBERPOLICYFORFEITURE |
| SUBPOLICYFORFACT | SUBSCRIBERPOLICYFORFEITUREACTIVITY |
| SUBPRIORACCUM | Subscribers, SubscriberPriorAccum |
| SUBSCRIBERONACCOUNT | SUBSCRIBERONACCOUNT |
| SUBVOLDESC | SUBENROLLMENTPLANVOLUMEDESC |
| SUFFIX | Suffix |
| SUSADJCLAIM | SUSPENSEADJCLAIMLIST, Claim |
| SUSCLAIM | SUSPENSECLAIMLIST, Claim |
| SUSCRIT | SuspenseType, SuspenseCriteria |
| SUSPENSETYPE | SuspenseType |
| SYSTEMLOGDATA | SystemLogData |
| TALONEXCODE | CostContainTalonExCode |
| TALONLOG | CostContainTalonLog |
| TAXFILINGSTATUS | TaxFilingStatus |
| TAXONOMY | Taxonomy |
| TAXONOMYGROUP | TaxonomyGroup |
| TEMPLATERATEGROUPAPPLIED | PREMRATETEMPLATEGROUPAPPLIED |
| TEMPLATERATEGROUPAVAILABLE | PREMRATETEMPLATEGROUPAVAILABLE |
| TEMPLATERATEGROUPDIVAPPLIED | PREMRATETEMPLATEGROUPDIVISIONAPPLIED |
| TEMPLATERATEGROUPDIVAVAILABLE | PREMRATETEMPLATEGROUPDIVISIONAVAILABLE |
| TIER | Tier |
| TIMELYFILING | TimelyFiling |
| TOOTH | ToothQuadrant, ToothChartType, Tooth, ToothChart |
| TOOTHACTION | ToothAction |
| TOOTHCHARTTYPE | ToothChartType |
| TOOTHPROCEDURE | ToothProcedure |
| UCNETWORK | UCNetwork |
| USER | USERLIST |
| USERANDUSERGROUP | USERANDUSERGROUPLIST |
| USERNOTEACCES | UserNoteAccess |
| USEROBJECTSECURITY | USEROBJECTSECURITY |
| USEROBJECTSECURITYACCESS | USEROBJECTSECURITYACCESS |
| VBADATAINT_CLAIM | VBADATAINTEGRATIONCLAIM |
| VBAG_CLIENTCONFIG | ClientConfig |
| VBAG_MESSAGES | UserProfile, MESSAGESEARCH, USERSEARCH |
| VBAG_MESSAGETHREAD | MESSAGETHREADSEARCH |
| VBAG_MESSAGETHREADSTATUS | MessageThreadStatus |
| VBAG_MESSAGETHREADTYPE | MessageThreadType |
| VBAG_MYREQUEST | RequestStatus, Request, VBAGatewaySubscription, RequestType |
| VBAG_REQUEST | REQUESTSEARCH, RequestMetaData |
| VBAG_REQUESTSOURCE | VBAGATEWAYREQUESTSOURCE |
| VBAG_REQUESTSTATUS | RequestStatus |
| VBAG_REQUESTTYPE | RequestType |
| VBAG_USER | USERSEARCH |
| VBAGATEWAYSUBSCRIPTION | VBAGatewaySubscription |
| VBAINTERFACE | VBAInterface |
| VBAINTERFACESTATUS | VBAInterfaceStatus |
| VBAINTERFACETYPE | VBAInterfaceType |
| VBAINTERFACEVENDOR | VBAInterfaceVendor |
| VBAINTRFCIDCODE | IDCODE_INTRFACE, VBAInterface |
| VBAINTRFCIDCODEGROUP | IDCODE_GROUP, Groups |
| VBAINTRFCIDCODEGROUPDIV | IDCODE_GROUPDIVISION, GroupDivision, Groups |
| VBAINTRFCIDCODEGROUPPLAN | Groups, IDCODE_GROUPPLAN, Plans, GroupDivision |
| VBAINTRFCIDCODEPLAN | Plans, IDCODE_PLAN |
| VISIUMCLAIMHEADER | VISIUM_CLAIMHEADER |
| VISIUMEXCODE | CostContainVisiumExCode |
| VISIUMLOG | CostContainVisiumLog |
| VISIUMSERVICEDETAIL | VISIUM_SERVICEDETAIL |
| VISIUMSETTING | CostContainVisiumSetting |
| WITHHOLDTAXID | WITHHOLDTAXIDCLAIMLIST |
| WORKFLOW | WorkflowType, Workflow, Criteria |
| WORKFLOW_AUTH | Members, Users, Auth, SubEnrollment, CareManager, Provider |
| WORKFLOW_CHECK | Checks, CheckExport |
| WORKFLOW_CLAIMBATCH | ClaimBatches, MemberBeneficiary, Provider, ClaimBatchDetail, Plans, ClaimBatch, Members, CLAIMBATCHTOTALS, ProcedureCode |
| WORKFLOW_ENROLLMENT | MemberCaseHead, CaseHead, SubEnrollmentPlan, MemberAddress, SubEnrollment, MemEnrollmentPlan, Groups, GroupContract, MemberEligibilityStatus, Members |
| WORKFLOWAGING | WORKFLOWAGING |
| WORKFLOWCLAIMSACTIVE | WorkflowUser, Workflow, Provider, WorkflowTask, ClaimBatch, Members, WORKFLOWCLAIMS |
| WORKFLOWTASKAGING | WORKFLOWTASKAGING |
| WORKFLOWUNASSIGNEDAGING | WORKFLOWUNASSIGNEDAGING |
| WORKFLOWUSERAGING | WORKFLOWUSERAGING |
| ZELISEXCODE | CostContainZelisExCode |
| ZELISPOLL | CostContainZelisPoll |
| ZIPCODE | ZipCodes |
- CLAIM: Complete claim data including totals, providers, members, checks, and related details
- CLAIMBATCH: Claim batch processing with procedure codes and member beneficiaries
- CLAIMAUDIT: Claim audit information and processing details
- CLAIMQUEUE: Claim processing queues and workflow management
- ENROLLMENT: Complete member enrollment data with relationships, addresses, and plans
- MEMBERBENEFICIARY: Member beneficiary information and plan details
- MEMACCUM: Member accumulator data for benefit tracking
- SUBENROLLMENT: Subscriber enrollment details with group and plan information
- PROV: Provider information including networks, specialties, languages, and payment details
- PROVPROFILE: Detailed provider profiles with credentials and network participation
- NETWORK: Network definitions and configurations
- SPECIALTY: Medical specialties and provider classifications
- AUTH: Authorization data with member, provider, and status information
- AUTHCODE: Authorization codes and classifications
- CARECASE: Care management cases with treatments, providers, and clinical data
- CHECKS: Check processing and payment information
- FUNDING: Funding account management and transactions
- PREMINVOICE: Premium invoicing and payment processing
- COMMISSION: Commission calculations and payments
- Start with your primary data need: Identify the main entity you're querying (claims, members, providers)
- Consider related data: Choose configs that include the related tables you need
- Check table availability: Use this reference to verify all needed tables are included
- Use specific configs: More targeted SearchConfigs generally perform better than broad ones
- Limit selected fields: Only request the columns you actually need in your results
- Filter efficiently: Apply the most restrictive criteria first
- Understand joins: SearchConfigs define how tables are joined - review the available tables to understand relationships
- Plan your criteria: Structure your SearchCriteria to work with the available table relationships
- Test with small datasets: Start with limited criteria to understand the data structure before building complex queries