ClaimQueryProvider¶

Query provider exposing 17 data-access operation(s) (GetActiveClaimsWithOutstandingReserves, GetAttendingPhysician, GetClaimFromInjuryClaimCrossReference, GetClaimLegalRepresentative, GetClaimPersonAddresses, GetClaimRequestDecisions and 11 more) against 17 distinct table(s); see sql/index.md for the full ORM operation catalog.

Purpose¶

Provides read/write access to 17 table(s) via NHibernate IQueryable<T>/GetRepository<T>() calls documented in sql/index.md.
Exposes 17 public query/command method(s) consumed by higher application layers; see database-tables.md for the underlying schema.

Context¶

Namespace: SAIF.Data.Queries.Claims
Assembly/package: SAIF.Data

Public members¶

Member	Signature	Purpose
Date	`DateTime? Date { get; set; }`	Date/time value for date.*
Amount	`Decimal Amount { get; set; }`	Monetary amount for amount.*
IsValidClaim	`bool IsValidClaim(long claimId)`	Indicates whether valid claim.*
IsValidClaim	`bool IsValidClaim(string claimNumber)`	Indicates whether valid claim.*
HasLegalRepresentativeHistory	`bool HasLegalRepresentativeHistory(long claimId)`	Indicates whether legal representative history.*
GetClaim	`InjuryClaim GetClaim(long claimId)`	Retrieves claim.*
GetClaim	`InjuryClaim GetClaim(string claimNumber)`	Retrieves claim.*
GetLatestMco	`McoLocation GetLatestMco(long claimId)`	Retrieves latest mco.*
GetAllMcoLocations	`IEnumerable<McoLocation> GetAllMcoLocations(long claimId)`	Retrieves all mco locations.*
GetClaimFromInjuryClaimCrossReference	`InjuryClaim GetClaimFromInjuryClaimCrossReference(string customerClaimNumber)`	Executes an ORM query (SQL-056) against LPT_CLAIM_CROSS_REFERENCE.
GetAttendingPhysician	`AttendingPhysician GetAttendingPhysician(long claimId)`	Executes an ORM query (SQL-057) against PROVIDER_LOCATION.
GetClaimStatusDate	`DateTime GetClaimStatusDate(long claimId)`	Executes an ORM query (SQL-058) against CL_CLAIM_STATUS_ACTIVITY.
GetWorkStatus	`ClaimWorkStatus GetWorkStatus(long claimId)`	Retrieves work status.*
GetWorkReleaseStatus	`ClaimWorkReleaseStatus GetWorkReleaseStatus(long claimId)`	Retrieves work release status.*
GetLatestClaimTypeActivity	`ClaimTypeActivity GetLatestClaimTypeActivity(long claimId)`	Retrieves latest claim type activity.*
GetClaimTypeActivity	`IEnumerable<ClaimTypeActivity> GetClaimTypeActivity(long claimId)`	Retrieves claim type activity.*
GetClaimPersonAddresses	`IEnumerable<ClaimPersonAddress> GetClaimPersonAddresses(long personId)`	Executes an ORM query (SQL-059) against CL_CLAIM_PERSON_ADDRESS.
GetClaimsMissingTaxId	`IEnumerable<InjuryClaim> GetClaimsMissingTaxId(DateTime lookbackDate)`	Executes an ORM query (SQL-060) against CL_INJURY_CLAIM, CL_CLAIM_PERSON.
GetLatestClaimStatus	`ClaimStatusDetail GetLatestClaimStatus(long claimId)`	Retrieves latest claim status.*
GetCompensabilityStatus	`CompensabilityStatusCode GetCompensabilityStatus(long claimId)`	Retrieves compensability status.*
GetClaimStatusActivity	`IEnumerable<ClaimStatusActivity> GetClaimStatusActivity(long claimId)`	Executes an ORM query (SQL-061) against CL_CLAIM_STATUS_ACTIVITY.
GetClaimRequestDecisions	`IEnumerable<ClaimRequestDecision> GetClaimRequestDecisions(long claimId)`	Executes an ORM query (SQL-062) against CL_CLAIM_REQUEST_DECISION.
GetWcdStatusHistory	`IEnumerable<ClaimStatusDetail> GetWcdStatusHistory(long claimId)`	Retrieves wcd status history.*
GetOriginalAcceptance	`ClaimRequestDecision GetOriginalAcceptance(long claimId)`	Executes an ORM query (SQL-063) against CL_CLAIM_REQUEST_DECISION, CL_REQUEST_TYPE_CODE, CLAIM_DECISION_CODE.
GetClaimLegalRepresentative	`ClaimLegalRepresentative GetClaimLegalRepresentative(long claimId)`	Executes an ORM query (SQL-064) against CL_CLAIM_LEGAL_REPRESENTATIVE.
GetResponsibility	`ClaimResponsibility GetResponsibility(long claimId)`	Retrieves responsibility.*
GetVocationalCoordinator	`VocationalResponsibilityCode GetVocationalCoordinator(long claimId)`	Retrieves vocational coordinator.*
GetRTWAdjusterMailId	`string GetRTWAdjusterMailId(long claimId)`	Retrieves RTW adjuster mail id.*
GetMcoEnrollmentDate	`DateTime GetMcoEnrollmentDate(long claimId)`	Retrieves mco enrollment date.*
GetConditions	`IEnumerable<MedicalCondition> GetConditions(long claimId)`	Executes an ORM query (SQL-065) against CL_MEDICAL_CONDITION, CL_INJURY_CLAIM.
GetActiveClaimsWithOutstandingReserves	`IEnumerable<long> GetActiveClaimsWithOutstandingReserves()`	Executes an ORM query (SQL-066) against CL_INJURY_CLAIM.
GetVocationalDetails	`IEnumerable<VocationalDetail> GetVocationalDetails(long claimId)`	Retrieves vocational details.*
GetPharmacyEligibilityReport	`PharmacyEligibilityReport GetPharmacyEligibilityReport(long claimId)`	Executes an ORM query (SQL-067) against CL_PHARMACY_ELIGIBILITY_REPORT.
GetEaipPeriods	`IEnumerable<EaipPeriod> GetEaipPeriods(long claimId)`	Executes an ORM query (SQL-068) against EAIP_PERIOD, CL_INJURY_CLAIM.
GetThirdPartyCase	`ThirdPartyCase GetThirdPartyCase(long claimId)`	Executes an ORM query (SQL-069) against THRDPARTY_CASE.
GetRtwCase	`RTWCase GetRtwCase(long claimId)`	Executes an ORM query (SQL-070) against RTW_CASE.
GetLastPayment	`FinancialTransaction GetLastPayment(long claimId)`	Retrieves last payment.*
GetClaimStatusCode	`ClaimStatusCode GetClaimStatusCode(string code)`	Executes an ORM query (SQL-071) against claim_status_code.
GetClaimTypeCode	`ClaimTypeCode GetClaimTypeCode(string code)`	Executes an ORM query (SQL-072) against CL_CLAIM_TYPE_CODE.
GetRecoverableOverpaymentBalance	`decimal GetRecoverableOverpaymentBalance(long claimId)`	Retrieves recoverable overpayment balance.*
ClaimQueryProvider(IRepositoryFactory factory, IBillQueryProvider billQueryProvider, ILegalQueryProvider legalQueryProvider, IReserveQueryProvider reserveQueryProvider, IWorkerQueryProvider workerQueryProvider, IPolicyQueryProvider policyQueryProvider, IEmployeeQueryProvider employeeQueryProvider, ICCClaimApiService claimApiService, IClaimDataApiClient gwClaimDataApiClient)	`ClaimQueryProvider(IRepositoryFactory factory, IBillQueryProvider billQueryProvider, ILegalQueryProvider legalQueryProvider, IReserveQueryProvider reserveQueryProvider, IWorkerQueryProvider workerQueryProvider, IPolicyQueryProvider policyQueryProvider, IEmployeeQueryProvider employeeQueryProvider, ICCClaimApiService claimApiService, IClaimDataApiClient gwClaimDataApiClient)`	Initializes a new instance, wiring the repository factory used by this provider's query methods.*

Behavioral notes¶

Query methods build LINQ expressions over IQueryable<T> obtained via Factory.GetRepository<T>() and execute them against the underlying NHibernate session.*

Constraints and usage notes¶

Instances are constructed with an IRepositoryFactory and are expected to be resolved through dependency injection rather than instantiated directly.*

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Data/SAIF.Data/Queries/Claims/ClaimQueryProvider.cs