Skip to content

Other query providers

Support certificate-holder search, task lookup, worker/support-order queries, report/payment classification, and Medicare beneficiary history matching.

Field Value
Operation ID OP-SD-22
Trigger Miscellaneous read queries across certificate, task, worker, report, payment, and Medicare domains.
Inputs Search terms, worker id, code values
Outputs Filtered lists, counts, bool
Primary components CertificateHolderQueryProvider, TaskQueryProvider, WorkerQueryProvider, ReportQueryProvider, PaymentsQueryProvider, MedicareQueryProvider
Entry point Data/SAIF.Data/Queries/Policies/Certificates/CertificateHolderProvider.cs

Steps

  1. CertificateHolderQueryProvider: excludes superseded holders and runs a word search across name and address fields (SD-BR-090, SQL-001, SQL-002, SQL-003, SQL-051). Data: CERTIFICATE_HOLDER.
  2. TaskQueryProvider: matches codes case-insensitively (SD-BR-091). Data: TASK.
  3. WorkerQueryProvider.GetActiveSupportOrderCount: counts orders with no termination date (SD-BR-092). Data: CL_CLAIM_SUPPORT_ORDER. GetWorkerAge computes age.
  4. ReportQueryProvider: "active" means ExpirationDate == null (SD-BR-093).
  5. PaymentsQueryProvider: "MA" means medical audit (SD-BR-094).
  6. MedicareQueryProvider: matches beneficiary query history on all fields (SD-BR-095). Data: MEDICARE_QUERY_HISTORY, MEDICARE_BENEFICIARY_QUERY_BAT.
  7. Other LINQ read providers without distinctive rules: AddressVerification, ClaimPayment, Reserve, ServiceCode, ServiceCodeMaintenance, Edi, Employee, Image, Policy, EbillAddress/Document/Invoice/Patient/Provider/Service.

Process flow

The following diagram visualizes this operation's control flow.

flowchart TD
    Start(["Miscellaneous read queries across certificate, task,<br>worker, report, payment, and Medicare domains."]) --> S1["`CertificateHolderQueryProvider`"]
    S1 --> S2{"Rules satisfied?"}
    S2 -->|Yes| EndOk([Result returned])
    S2 -->|No| EndErr([Exception / empty result])

Failure and edge-case behavior

  • Unrecognized code values: excluded from filtered results rather than raising an error.

Sources

  • Data/SAIF.Data/Queries/Policies/Certificates/CertificateHolderProvider.cs
  • Data/SAIF.Data/Queries/AddressVerification/AddressVerificationQueryProvider.cs:34
  • Data/SAIF.Data/Queries/AddressVerification/AddressVerificationQueryProvider.cs:42
  • Data/SAIF.Data/Queries/AddressVerification/AddressVerificationQueryProvider.cs:49