| SQL-001 |
Get location verification requests |
LINQ (inferred SQL) |
LOCATION_VERIFICATION_REQUEST, ADDRESS_VERIFICATION_REQUEST |
AddressVerificationQueryProvider |
| SQL-002 |
Get address verification requests |
LINQ (inferred SQL) |
ADDRESS_VERIFICATION_REQUEST |
AddressVerificationQueryProvider |
| SQL-003 |
Get verified address |
LINQ (inferred SQL) |
VERIFIED_ADDRESS |
AddressVerificationQueryProvider |
| SQL-004 |
Get audit note |
LINQ (inferred SQL) |
CBP_NOTE |
AuditNoteQueryProvider |
| SQL-005 |
Get audit notes for claim |
LINQ (inferred SQL) |
CBP_NOTE |
AuditNoteQueryProvider |
| SQL-006 |
Get audit notes for bill |
LINQ (inferred SQL) |
CBP_NOTE |
AuditNoteQueryProvider |
| SQL-007 |
Get all audit notes |
LINQ (inferred SQL) |
CBP_NOTE |
AuditNoteQueryProvider |
| SQL-008 |
Get note type code |
LINQ (inferred SQL) |
CBP_NOTE_TYPE_CODE |
AuditNoteQueryProvider |
| SQL-009 |
Get note categories |
LINQ (inferred SQL) |
CBP_NOTE_CATEGORY_CODE |
AuditNoteQueryProvider |
| SQL-010 |
Get note types |
LINQ (inferred SQL) |
CBP_NOTE_TYPE_CODE |
AuditNoteQueryProvider |
| SQL-011 |
Get note types for category |
LINQ (inferred SQL) |
CBP_NOTE_TYPE_CODE |
AuditNoteQueryProvider |
| SQL-012 |
Is audit note no contention |
LINQ (inferred SQL) |
CBP_NOTE |
AuditNoteQueryProvider |
| SQL-013 |
Get audit |
LINQ (inferred SQL) |
CBP_AUDIT |
AuditQueryProvider |
| SQL-014 |
Get audit for bill |
LINQ (inferred SQL) |
CBP_AUDIT |
AuditQueryProvider |
| SQL-015 |
Get national drug code |
LINQ (inferred SQL) |
CBP_NATIONAL_DRUG |
AuditQueryProvider |
| SQL-016 |
Is nurse review required |
LINQ (inferred SQL) |
CBP_SERVICE_CODE |
AuditQueryProvider |
| SQL-017 |
Is nurse review required |
LINQ (inferred SQL) |
CBP_AUDITED_SERVICE, CBP_AUDIT |
AuditQueryProvider |
| SQL-018 |
Get non duplicate service count |
LINQ (inferred SQL) |
CBP_AUDITED_SERVICE, CBP_AUDIT |
AuditQueryProvider |
| SQL-019 |
Get services |
LINQ (inferred SQL) |
CBP_AUDITED_SERVICE, CBP_AUDIT, CBP_BILL |
AuditQueryProvider |
| SQL-020 |
Get original bills |
LINQ (inferred SQL) |
CBP_AUDITED_SERVICE, CBP_AUDIT |
AuditQueryProvider |
| SQL-021 |
Get physical medicine count |
LINQ (inferred SQL) |
CBP_AUDITED_SERVICE, CBP_BILL, CBP_SERVICE_PHYSICAL_MEDICINE |
AuditQueryProvider |
| SQL-022 |
Get physical medicine count |
LINQ (inferred SQL) |
CBP_SERVICE_PHYSICAL_MEDICINE, CBP_AUDITED_SERVICE, CBP_BILL |
AuditQueryProvider |
| SQL-023 |
Get adjustment type |
LINQ (inferred SQL) |
CBP_AUDIT_ADJUSTMENT_TYPE |
AuditQueryProvider |
| SQL-024 |
Bill exists |
LINQ (inferred SQL) |
CBP_BILL |
BillQueryProvider |
| SQL-025 |
Get bill |
LINQ (inferred SQL) |
CBP_BILL |
BillQueryProvider |
| SQL-026 |
Get bills for claim |
LINQ (inferred SQL) |
CBP_BILL |
BillQueryProvider |
| SQL-027 |
Get bill ids for claim |
LINQ (inferred SQL) |
CBP_BILL |
BillQueryProvider |
| SQL-028 |
Get bill types |
LINQ (inferred SQL) |
CBP_BILL_TYPE_CODE |
BillQueryProvider |
| SQL-029 |
Get bill status code |
LINQ (inferred SQL) |
CBP_BILL_STATUS_CODE |
BillQueryProvider |
| SQL-030 |
Get bill status history |
LINQ (inferred SQL) |
CBP_BILL_STATUS |
BillQueryProvider |
| SQL-031 |
Get regenerated bill entry source code |
LINQ (inferred SQL) |
CBP_BILL_ENTRY_SOURCE_CODE |
BillQueryProvider |
| SQL-032 |
Get bill amounts |
LINQ (inferred SQL) |
CBP_BILL, CBP_AUDITED_SERVICE, CBP_AUDIT |
BillQueryProvider |
| SQL-033 |
Get bill amounts |
LINQ (inferred SQL) |
CBP_BILL, CBP_AUDITED_SERVICE, CBP_AUDIT |
BillQueryProvider |
| SQL-034 |
Get stripped cbp diagnosis |
LINQ (inferred SQL) |
CBP_DIAGNOSIS |
BillQueryProvider |
| SQL-035 |
Get cbp diagnosis |
LINQ (inferred SQL) |
CBP_DIAGNOSIS |
BillQueryProvider |
| SQL-036 |
Get cbp diagnosis type code |
LINQ (inferred SQL) |
CBP_DIAGNOSIS_TYPE_CODE |
BillQueryProvider |
| SQL-037 |
Get ebill entry source code |
LINQ (inferred SQL) |
CBP_BILL_ENTRY_SOURCE_CODE |
BillQueryProvider |
| SQL-038 |
Get cbp bill type code |
LINQ (inferred SQL) |
CBP_BILL_TYPE_CODE |
BillQueryProvider |
| SQL-039 |
Get cbp service code not expired |
LINQ (inferred SQL) |
CBP_SERVICE_CODE |
BillQueryProvider |
| SQL-040 |
Get cbp service code expired |
LINQ (inferred SQL) |
CBP_SERVICE_CODE |
BillQueryProvider |
| SQL-041 |
Get cbp service z code |
LINQ (inferred SQL) |
CBP_SERVICE_CODE |
BillQueryProvider |
| SQL-042 |
Get cbp service z dec description |
LINQ (inferred SQL) |
CBP_SERVICE_DESCRIPTION |
BillQueryProvider |
| SQL-043 |
Get cbp service z dec description stateless |
LINQ (inferred SQL) |
CBP_SERVICE_DESCRIPTION |
BillQueryProvider |
| SQL-044 |
Get bill service type code |
LINQ (inferred SQL) |
CBP_SERVICE_TYPE_CODE |
BillQueryProvider |
| SQL-045 |
Get bill service code |
LINQ (inferred SQL) |
CBP_SERVICE_CODE |
BillQueryProvider |
| SQL-046 |
Get bill service code stateless |
LINQ (inferred SQL) |
CBP_SERVICE_CODE |
BillQueryProvider |
| SQL-047 |
Get national drug |
LINQ (inferred SQL) |
CBP_NATIONAL_DRUG |
BillQueryProvider |
| SQL-048 |
Get dispense as written |
LINQ (inferred SQL) |
CL_PHARMACY_DAW_CODE |
BillQueryProvider |
| SQL-049 |
Get cbp procedure code |
LINQ (inferred SQL) |
CBP_PROCEDURE_CODE |
BillQueryProvider |
| SQL-050 |
Get icd version |
LINQ (inferred SQL) |
IcdVersionCode |
BillQueryProvider |
| SQL-051 |
Get certificate holder |
LINQ (inferred SQL) |
CERTIFICATE_HOLDER |
CertificateHolderQueryProvider |
| SQL-052 |
Get certificate holders |
LINQ (inferred SQL) |
CERTIFICATE_HOLDER |
CertificateHolderQueryProvider |
| SQL-053 |
Get certificate holders |
LINQ (inferred SQL) |
CERTIFICATE_HOLDER |
CertificateHolderQueryProvider |
| SQL-054 |
Get special handling codes |
LINQ (inferred SQL) |
CL_PAYMENT_SPCL_HANDLING_CODE |
ClaimPaymentQueryProvider |
| SQL-055 |
Get special handling code |
LINQ (inferred SQL) |
CL_PAYMENT_SPCL_HANDLING_CODE |
ClaimPaymentQueryProvider |
| SQL-056 |
Get claim from injury claim cross reference |
LINQ (inferred SQL) |
LPT_CLAIM_CROSS_REFERENCE |
ClaimQueryProvider |
| SQL-057 |
Get attending physician |
LINQ (inferred SQL) |
PROVIDER_LOCATION |
ClaimQueryProvider |
| SQL-058 |
Get claim status date |
LINQ (inferred SQL) |
CL_CLAIM_STATUS_ACTIVITY |
ClaimQueryProvider |
| SQL-059 |
Get claim person addresses |
LINQ (inferred SQL) |
CL_CLAIM_PERSON_ADDRESS |
ClaimQueryProvider |
| SQL-060 |
Get claims missing tax id |
LINQ (inferred SQL) |
CL_INJURY_CLAIM, CL_CLAIM_PERSON |
ClaimQueryProvider |
| SQL-061 |
Get claim status activity |
LINQ (inferred SQL) |
CL_CLAIM_STATUS_ACTIVITY |
ClaimQueryProvider |
| SQL-062 |
Get claim request decisions |
LINQ (inferred SQL) |
CL_CLAIM_REQUEST_DECISION |
ClaimQueryProvider |
| SQL-063 |
Get original acceptance |
LINQ (inferred SQL) |
CL_CLAIM_REQUEST_DECISION |
ClaimQueryProvider |
| SQL-064 |
Get claim legal representative |
LINQ (inferred SQL) |
CL_CLAIM_LEGAL_REPRESENTATIVE |
ClaimQueryProvider |
| SQL-065 |
Get conditions |
LINQ (inferred SQL) |
CL_MEDICAL_CONDITION |
ClaimQueryProvider |
| SQL-066 |
Get active claims with outstanding reserves |
LINQ (inferred SQL) |
CL_INJURY_CLAIM |
ClaimQueryProvider |
| SQL-067 |
Get pharmacy eligibility report |
LINQ (inferred SQL) |
CL_PHARMACY_ELIGIBILITY_REPORT |
ClaimQueryProvider |
| SQL-068 |
Get eaip periods |
LINQ (inferred SQL) |
EAIP_PERIOD |
ClaimQueryProvider |
| SQL-069 |
Get third party case |
LINQ (inferred SQL) |
THRDPARTY_CASE |
ClaimQueryProvider |
| SQL-070 |
Get rtw case |
LINQ (inferred SQL) |
RTW_CASE |
ClaimQueryProvider |
| SQL-071 |
Get claim status code |
LINQ (inferred SQL) |
claim_status_code |
ClaimQueryProvider |
| SQL-072 |
Get claim type code |
LINQ (inferred SQL) |
CL_CLAIM_TYPE_CODE |
ClaimQueryProvider |
| SQL-073 |
Has claim security override |
LINQ (inferred SQL) |
CL_SECURITY_OVERRIDE |
ClaimSecurityOverrideProvider |
| SQL-074 |
Get address |
LINQ (inferred SQL) |
EBILL_ADDRESS |
EbillAddressQueryProvider |
| SQL-075 |
Get address type by code |
LINQ (inferred SQL) |
EBILL_ADDRESS_TYPE_CODE |
EbillAddressQueryProvider |
| SQL-076 |
Get address by batch id |
LINQ (inferred SQL) |
EBILL_ADDRESS |
EbillAddressQueryProvider |
| SQL-077 |
Get addresses to override |
LINQ (inferred SQL) |
EBILL_ADDRESS_OVERRIDE |
EbillAddressQueryProvider |
| SQL-078 |
Get batch |
LINQ (inferred SQL) |
EBILL_BATCH |
EbillBatchQueryProvider |
| SQL-079 |
Get batch |
LINQ (inferred SQL) |
EBILL_BATCH |
EbillBatchQueryProvider |
| SQL-080 |
Get batch |
LINQ (inferred SQL) |
EBILL_BATCH |
EbillBatchQueryProvider |
| SQL-081 |
Get batch |
LINQ (inferred SQL) |
EBILL_BATCH |
EbillBatchQueryProvider |
| SQL-082 |
Get first batch |
LINQ (inferred SQL) |
EBILL_BATCH |
EbillBatchQueryProvider |
| SQL-083 |
Get first batch |
LINQ (inferred SQL) |
EBILL_BATCH |
EbillBatchQueryProvider |
| SQL-084 |
Get last batch |
LINQ (inferred SQL) |
EBILL_BATCH |
EbillBatchQueryProvider |
| SQL-085 |
Get last batch |
LINQ (inferred SQL) |
EBILL_BATCH |
EbillBatchQueryProvider |
| SQL-086 |
Get last batch |
LINQ (inferred SQL) |
EBILL_BATCH |
EbillBatchQueryProvider |
| SQL-087 |
Get batch type |
LINQ (inferred SQL) |
EBILL_BATCH_TYPE_CODE |
EbillBatchQueryProvider |
| SQL-088 |
Get batch type code |
LINQ (inferred SQL) |
EBILL_BATCH_TYPE_CODE |
EbillBatchQueryProvider |
| SQL-089 |
Get batch status |
LINQ (inferred SQL) |
EBILL_BATCH_STATUS_CODE |
EbillBatchQueryProvider |
| SQL-090 |
Get clearinghouse by tax id |
LINQ (inferred SQL) |
EBILL_CLEARINGHOUSE |
EbillClearinghouseQueryProvider |
| SQL-091 |
Get clearinghouse by clearinghouse code |
LINQ (inferred SQL) |
EBILL_CLEARINGHOUSE |
EbillClearinghouseQueryProvider |
| SQL-092 |
Get document |
LINQ (inferred SQL) |
EBILL_DOCUMENT |
EbillDocumentQueryProvider |
| SQL-093 |
Get non imaged documentsfor batch |
LINQ (inferred SQL) |
EBILL_DOCUMENT, EBILL |
EbillDocumentQueryProvider |
| SQL-094 |
Get non imaged documentsfor bill |
LINQ (inferred SQL) |
EBILL_DOCUMENT |
EbillDocumentQueryProvider |
| SQL-095 |
Get documentsfor bill |
LINQ (inferred SQL) |
EBILL_DOCUMENT |
EbillDocumentQueryProvider |
| SQL-096 |
Get billing parent documents imaged by batch id |
LINQ (inferred SQL) |
EBILL_DOCUMENT, EBILL |
EbillDocumentQueryProvider |
| SQL-097 |
Get document type by code |
LINQ (inferred SQL) |
EBILL_DOCUMENT_TYPE_CODE |
EbillDocumentQueryProvider |
| SQL-098 |
Get document type by set type |
LINQ (inferred SQL) |
EBILL_DOCUMENT_TYPE_CODE |
EbillDocumentQueryProvider |
| SQL-099 |
Get document override |
LINQ (inferred SQL) |
EBILL_DOCUMENT_OVERRIDE |
EbillDocumentQueryProvider |
| SQL-100 |
Get completed zero payment bills for eob |
LINQ (inferred SQL) |
EBILL, CBP_BILL, CBP_AUDIT, EBILL_BATCH |
EbillEobQueryProvider |
| SQL-101 |
Get completed zero payment bills for eob |
LINQ (inferred SQL) |
EBILL, CBP_BILL, CBP_AUDIT |
EbillEobQueryProvider |
| SQL-102 |
Get eobs for batch |
LINQ (inferred SQL) |
EBILL_EOB |
EbillEobQueryProvider |
| SQL-103 |
Get eob |
LINQ (inferred SQL) |
EBILL_EOB |
EbillEobQueryProvider |
| SQL-104 |
Get health information |
LINQ (inferred SQL) |
EBILL_HEALTH_INFORMATION |
EbillHealthInformationQueryProvider |
| SQL-105 |
Get health info type by code |
LINQ (inferred SQL) |
EBILL_HEALTH_INFO_TYPE_CODE |
EbillHealthInformationQueryProvider |
| SQL-106 |
Get drg code |
LINQ (inferred SQL) |
EBILL_HEALTH_INFORMATION |
EbillHealthInformationQueryProvider |
| SQL-107 |
Get invoice |
LINQ (inferred SQL) |
EBILL_INVOICE |
EbillInvoiceQueryProvider |
| SQL-108 |
Get invoice bills |
LINQ (inferred SQL) |
EBILL_INVOICE_BILL |
EbillInvoiceQueryProvider |
| SQL-109 |
Get invoice error |
LINQ (inferred SQL) |
EBILL_INVOICE_ERROR |
EbillInvoiceQueryProvider |
| SQL-110 |
Get patient |
LINQ (inferred SQL) |
EBILL_PATIENT |
EbillPatientQueryProvider |
| SQL-111 |
Get non indexed patients |
LINQ (inferred SQL) |
EBILL_PATIENT, EBILL_PROVIDER |
EbillPatientQueryProvider |
| SQL-112 |
Get provider |
LINQ (inferred SQL) |
EBILL_PROVIDER |
EbillProviderQueryProvider |
| SQL-113 |
Get non indexed providers |
LINQ (inferred SQL) |
EBILL_PROVIDER |
EbillProviderQueryProvider |
| SQL-114 |
Get bill |
LINQ (inferred SQL) |
EBILL |
EbillQueryProvider |
| SQL-115 |
Get bill by clearinghouse and control number |
LINQ (inferred SQL) |
EBILL, EBILL_BATCH |
EbillQueryProvider |
| SQL-116 |
Get bill count by clearinghouse control number |
LINQ (inferred SQL) |
EBILL |
EbillQueryProvider |
| SQL-117 |
Get bills for response file for clearinghouse |
LINQ (inferred SQL) |
EBILL, EBILL_BATCH, CBP_BILL |
EbillQueryProvider |
| SQL-118 |
Get bills by batch |
LINQ (inferred SQL) |
EBILL |
EbillQueryProvider |
| SQL-119 |
Get bills by eob |
LINQ (inferred SQL) |
EBILL |
EbillQueryProvider |
| SQL-120 |
Get bills by received month |
LINQ (inferred SQL) |
EBILL, EBILL_BATCH |
EbillQueryProvider |
| SQL-121 |
Get ebill response set |
LINQ (inferred SQL) |
EBILL_RESPONSE_SET |
EbillQueryProvider |
| SQL-122 |
Get non indexed bills |
LINQ (inferred SQL) |
EBILL, EBILL_PATIENT, EBILL_PROVIDER |
EbillQueryProvider |
| SQL-123 |
Get non assigned bills |
LINQ (inferred SQL) |
EBILL, EBILL_PATIENT, EBILL_PROVIDER |
EbillQueryProvider |
| SQL-124 |
Get non imaged bills |
LINQ (inferred SQL) |
EBILL |
EbillQueryProvider |
| SQL-125 |
Get indexed bills |
LINQ (inferred SQL) |
EBILL, EBILL_PATIENT, EBILL_PROVIDER |
EbillQueryProvider |
| SQL-126 |
Get imaged bills |
LINQ (inferred SQL) |
EBILL, EBILL_PATIENT, EBILL_PROVIDER |
EbillQueryProvider |
| SQL-127 |
Get ebill |
LINQ (inferred SQL) |
EBILL |
EbillQueryProvider |
| SQL-128 |
Get bill status code |
LINQ (inferred SQL) |
EBILL_STATUS_CODE |
EbillQueryProvider |
| SQL-129 |
Get pended provider errors |
LINQ (inferred SQL) |
EBILL_ERROR_CONDITION |
EbillQueryProvider |
| SQL-130 |
Get pended patient errors |
LINQ (inferred SQL) |
EBILL_ERROR_CONDITION |
EbillQueryProvider |
| SQL-131 |
Get pended bill errors |
LINQ (inferred SQL) |
EBILL_ERROR_CONDITION |
EbillQueryProvider |
| SQL-132 |
Get pended errors |
LINQ (inferred SQL) |
EBILL_ERROR_CONDITION |
EbillQueryProvider |
| SQL-133 |
Get bill assignment rule |
LINQ (inferred SQL) |
EBILL_ASSIGNMENT_RULE |
EbillQueryProvider |
| SQL-134 |
Get bill set type code |
LINQ (inferred SQL) |
EBILL_SET_TYPE_CODE |
EbillQueryProvider |
| SQL-135 |
Get bill set type code by code |
LINQ (inferred SQL) |
EBILL_SET_TYPE_CODE |
EbillQueryProvider |
| SQL-136 |
Get edi place of service code |
LINQ (inferred SQL) |
EDI_PLACE_OF_SERVICE_CODE |
EbillQueryProvider |
| SQL-137 |
Set compound drug for all service lines for the bill |
LINQ (inferred SQL) |
EBILL_SERVICE |
EbillQueryProvider |
| SQL-138 |
Get maximum service date |
LINQ (inferred SQL) |
EBILL_SERVICE |
EbillServiceQueryProvider |
| SQL-139 |
Get minimum service date |
LINQ (inferred SQL) |
EBILL_SERVICE |
EbillServiceQueryProvider |
| SQL-140 |
Get ebill service |
LINQ (inferred SQL) |
EBILL |
EbillServiceQueryProvider |
| SQL-141 |
Get ebill service |
LINQ (inferred SQL) |
EBILL_SERVICE |
EbillServiceQueryProvider |
| SQL-142 |
Get clearinghouse |
LINQ (inferred SQL) |
EBILL_CLEARINGHOUSE |
EbillingQueryProvider |
| SQL-143 |
Get bill report |
LINQ (inferred SQL) |
EDI_BILL_REPORT |
EdiQueryProvider |
| SQL-144 |
Get bill |
LINQ (inferred SQL) |
EDI_BILL |
EdiQueryProvider |
| SQL-145 |
Get bill by segment count |
LINQ (inferred SQL) |
EDI_BILL |
EdiQueryProvider |
| SQL-146 |
Get wcis employee |
LINQ (inferred SQL) |
WCIS_Employee |
EmployeeQueryProvider |
| SQL-147 |
Get image |
LINQ (inferred SQL) |
image |
ImageQueryProvider |
| SQL-148 |
Get affilliated images |
LINQ (inferred SQL) |
image, IMAGE_AFFILIATION |
ImageQueryProvider |
| SQL-149 |
Get image system |
LINQ (inferred SQL) |
IMGSYS |
ImageQueryProvider |
| SQL-150 |
Get image document type |
LINQ (inferred SQL) |
image_document_type_code |
ImageQueryProvider |
| SQL-151 |
Alert legal |
LINQ (inferred SQL) |
LEGAL_CASE |
ImageQueryProvider |
| SQL-152 |
Get legal case |
LINQ (inferred SQL) |
LEGAL_CASE |
LegalQueryProvider |
| SQL-153 |
Get legal cases |
LINQ (inferred SQL) |
LEGAL_CASE |
LegalQueryProvider |
| SQL-154 |
Get claim id for case |
LINQ (inferred SQL) |
LEGAL_CASE |
LegalQueryProvider |
| SQL-155 |
Get case cost |
LINQ (inferred SQL) |
CASE_COST |
LegalQueryProvider |
| SQL-156 |
Get legal bills |
LINQ (inferred SQL) |
LEGAL_BILL |
LegalQueryProvider |
| SQL-157 |
Get subpoenas |
LINQ (inferred SQL) |
SUBPOENA |
LegalQueryProvider |
| SQL-158 |
Get appeal assigned attorney |
LINQ (inferred SQL) |
APPEAL |
LegalQueryProvider |
| SQL-159 |
Get adp employee name |
LINQ (inferred SQL) |
ADP_EMPLOYEE |
LegalQueryProvider |
| SQL-160 |
Get active legal cases |
LINQ (inferred SQL) |
LEGAL_CASE, CASE_STATUS_CODE |
LegalQueryProvider |
| SQL-161 |
Get attorney profile |
LINQ (inferred SQL) |
ATTORNEY_PROFILE |
LegalQueryProvider |
| SQL-162 |
Get other firm |
LINQ (inferred SQL) |
OTHER_FIRM |
LegalQueryProvider |
| SQL-163 |
Get legal person |
LINQ (inferred SQL) |
LEGAL_PERSON |
LegalQueryProvider |
| SQL-164 |
Get legal person address |
LINQ (inferred SQL) |
LEGAL_PERSON_ADDRESS |
LegalQueryProvider |
| SQL-165 |
Is primary case |
LINQ (inferred SQL) |
CONSOLIDATED_CASE |
LegalQueryProvider |
| SQL-166 |
Is image alert needed |
LINQ (inferred SQL) |
LEGAL_CASE |
LegalQueryProvider |
| SQL-167 |
Get location |
LINQ (inferred SQL) |
LOCATION |
LocationQueryProvider |
| SQL-168 |
Get policy locations |
LINQ (inferred SQL) |
LOCATION |
LocationQueryProvider |
| SQL-169 |
Get primary location |
LINQ (inferred SQL) |
LOCATION |
LocationQueryProvider |
| SQL-170 |
Get policy mailing location |
LINQ (inferred SQL) |
LOCATION |
LocationQueryProvider |
| SQL-171 |
Get location contacts |
LINQ (inferred SQL) |
CONTACT |
LocationQueryProvider |
| SQL-172 |
Get polcy claim location with default |
LINQ (inferred SQL) |
LOCATION |
LocationQueryProvider |
| SQL-173 |
Get claim location contact with default |
LINQ (inferred SQL) |
CONTACT |
LocationQueryProvider |
| SQL-174 |
Get office code |
LINQ (inferred SQL) |
OFFICE_CODE |
LocationQueryProvider |
| SQL-175 |
Get oregon business locations |
LINQ (inferred SQL) |
LOCATION |
LocationQueryProvider |
| SQL-176 |
Get next minumum submission batch |
LINQ (inferred SQL) |
MEDICARE_BENEFICIARY_QUERY_BAT |
MedicareQueryProvider |
| SQL-177 |
Find medicare history match |
LINQ (inferred SQL) |
MEDICARE_QUERY_HISTORY |
MedicareQueryProvider |
| SQL-178 |
Get countfor batch of medicare beneficiary |
LINQ (inferred SQL) |
MEDICARE_BENEFICIARY_QUERY |
MedicareQueryProvider |
| SQL-179 |
Get countfor batch of medicare history |
LINQ (inferred SQL) |
MEDICARE_QUERY_HISTORY |
MedicareQueryProvider |
| SQL-180 |
Get beneficiaries |
LINQ (inferred SQL) |
MEDICARE_BENEFICIARY_QUERY |
MedicareQueryProvider |
| SQL-181 |
Get released status |
LINQ (inferred SQL) |
document_status_code |
OutputDocumentQueryProvider |
| SQL-182 |
Get account number |
LINQ (inferred SQL) |
POLICY |
OutputDocumentQueryProvider |
| SQL-183 |
Get document date |
LINQ (inferred SQL) |
batch_process_log |
OutputDocumentQueryProvider |
| SQL-184 |
Document system date |
ORM (IRepository.SystemDate) |
|
OutputDocumentQueryProvider |
| SQL-185 |
Get policy output document |
LINQ (inferred SQL) |
policy_output_document |
OutputDocumentQueryProvider |
| SQL-186 |
Policy output document query |
LINQ (inferred SQL) |
policy_output_document |
OutputDocumentQueryProvider |
| SQL-187 |
Output document type code query |
LINQ (inferred SQL) |
output_document_type_code |
OutputDocumentQueryProvider |
| SQL-188 |
Get category codes |
LINQ (inferred SQL) |
output_document_category_code |
OutputDocumentQueryProvider |
| SQL-189 |
Document status code query |
LINQ (inferred SQL) |
document_status_code |
OutputDocumentQueryProvider |
| SQL-190 |
Get recoverable balance |
LINQ (inferred SQL) |
CL_OVERPAYMENT |
OverpaymentQueryProvider |
| SQL-191 |
Get payment transaction statisic |
LINQ (inferred SQL) |
PAYMENT_TRANSACTION_STAT |
PaymentsQueryProvider |
| SQL-192 |
Get last payment transaction statisic |
LINQ (inferred SQL) |
PAYMENT_TRANSACTION_STAT |
PaymentsQueryProvider |
| SQL-193 |
Get payment type |
LINQ (inferred SQL) |
PAYMENT_TRANSACTION_TYPE_CODE |
PaymentsQueryProvider |
| SQL-194 |
Get policy |
LINQ (inferred SQL) |
POLICY |
PolicyQueryProvider |
| SQL-195 |
Get non policy account |
LINQ (inferred SQL) |
NON_EMPR_ACCT |
PolicyQueryProvider |
| SQL-196 |
Get policy team function |
LINQ (inferred SQL) |
POLICY_TEAM_FUNCTION |
PolicyQueryProvider |
| SQL-197 |
Get business |
LINQ (inferred SQL) |
BUSINESS |
PolicyQueryProvider |
| SQL-198 |
Get group association |
LINQ (inferred SQL) |
POLICY_PERIOD_GROUP_ASSOC |
PolicyQueryProvider |
| SQL-199 |
Get payroll report for report id |
LINQ (inferred SQL) |
POLICY_PERIOD_PAYROLL_AUDIT |
PolicyQueryProvider |
| SQL-200 |
Get provider address last update date |
LINQ (inferred SQL) |
PROVIDER_ADDRESS |
ProviderQueryProvider |
| SQL-201 |
Get all active provider addresses for update date |
LINQ (inferred SQL) |
PROVIDER_ADDRESS |
ProviderQueryProvider |
| SQL-202 |
Get provider |
LINQ (inferred SQL) |
PROVIDER |
ProviderQueryProvider |
| SQL-203 |
Get provider by tax id |
LINQ (inferred SQL) |
PROVIDER_TAX_ID |
ProviderQueryProvider |
| SQL-204 |
Get provider by tax id |
LINQ (inferred SQL) |
PROVIDER |
ProviderQueryProvider |
| SQL-205 |
Get location |
LINQ (inferred SQL) |
PROVIDER_LOCATION |
ProviderQueryProvider |
| SQL-206 |
Get provider addresses |
LINQ (inferred SQL) |
PROVIDER_ADDRESS, PROVIDER_LOCATION |
ProviderQueryProvider |
| SQL-207 |
Get provider addresses |
LINQ (inferred SQL) |
PROVIDER_ADDRESS, PROVIDER_LOCATION |
ProviderQueryProvider |
| SQL-208 |
Get provider location addresses |
LINQ (inferred SQL) |
PROVIDER_ADDRESS |
ProviderQueryProvider |
| SQL-209 |
Get provider location addresses |
LINQ (inferred SQL) |
PROVIDER_ADDRESS |
ProviderQueryProvider |
| SQL-210 |
Get bill provider location ids |
LINQ (inferred SQL) |
CBP_BILL |
ProviderQueryProvider |
| SQL-211 |
Get provider identities by npi |
LINQ (inferred SQL) |
PROVIDER_IDENTITY |
ProviderQueryProvider |
| SQL-212 |
Get working provider relationships by parent location |
LINQ (inferred SQL) |
PROVIDER_RELATIONSHIP |
ProviderQueryProvider |
| SQL-213 |
Get expired relationships on or after date |
LINQ (inferred SQL) |
PROVIDER_RELATIONSHIP |
ProviderQueryProvider |
| SQL-214 |
Get active working relationships for provider |
LINQ (inferred SQL) |
PROVIDER_RELATIONSHIP |
ProviderQueryProvider |
| SQL-215 |
Get provider m c o plans |
LINQ (inferred SQL) |
MCO_PROVIDER |
ProviderQueryProvider |
| SQL-216 |
Is provider in mco |
LINQ (inferred SQL) |
MCO_PROVIDER |
ProviderQueryProvider |
| SQL-217 |
Has active relationship |
LINQ (inferred SQL) |
PROVIDER_RELATIONSHIP |
ProviderQueryProvider |
| SQL-218 |
Get attending claims with relationship |
LINQ (inferred SQL) |
ATTENDING_PHYSICIAN |
ReportQueryProvider |
| SQL-219 |
Get legal rep claims with relationship |
LINQ (inferred SQL) |
CL_CLAIM_LEGAL_REPRESENTATIVE |
ReportQueryProvider |
| SQL-220 |
Get active attending physician records for claim |
LINQ (inferred SQL) |
ATTENDING_PHYSICIAN |
ReportQueryProvider |
| SQL-221 |
Get active legal rep records for claim |
LINQ (inferred SQL) |
CL_CLAIM_LEGAL_REPRESENTATIVE |
ReportQueryProvider |
| SQL-222 |
Get latest incurred cost |
LINQ (inferred SQL) |
CL_INCURRED_COST_HISTORY |
ReserveQueryProvider |
| SQL-223 |
Get incurred cost for date |
LINQ (inferred SQL) |
CL_INCURRED_COST_HISTORY |
ReserveQueryProvider |
| SQL-224 |
Get total paid to date for category |
LINQ (inferred SQL) |
CL_PAYMENT_TOTAL |
ReserveQueryProvider |
| SQL-225 |
Get cpt services |
LINQ (inferred SQL) |
CBP_CPT_SERVICE |
ServiceCodeMaintenanceQueryProvider |
| SQL-226 |
Get descriptions |
LINQ (inferred SQL) |
CBP_SERVICE_DESCRIPTION |
ServiceCodeMaintenanceQueryProvider |
| SQL-227 |
Get fee schedules |
LINQ (inferred SQL) |
CBP_SERVICE_FEE |
ServiceCodeMaintenanceQueryProvider |
| SQL-228 |
Get service code |
LINQ (inferred SQL) |
CBP_SERVICE_CODE |
ServiceCodeMaintenanceQueryProvider |
| SQL-229 |
Get service code |
LINQ (inferred SQL) |
CBP_SERVICE_CODE |
ServiceCodeQueryProvider |
| SQL-230 |
Get procedure code |
LINQ (inferred SQL) |
CBP_PROCEDURE_CODE |
ServiceCodeQueryProvider |
| SQL-231 |
Get source |
LINQ (inferred SQL) |
TASK_SOURCE_CODE |
TaskQueryProvider |
| SQL-232 |
Get action |
LINQ (inferred SQL) |
TASK_ACTION_CODE |
TaskQueryProvider |
| SQL-233 |
Get priroity |
LINQ (inferred SQL) |
TASK_PRIORITY_CODE |
TaskQueryProvider |
| SQL-234 |
Get category |
LINQ (inferred SQL) |
TASK_CATEGORY_CODE |
TaskQueryProvider |
| SQL-235 |
Get task |
LINQ (inferred SQL) |
TASK |
TaskQueryProvider |
| SQL-236 |
Get tasks for user |
LINQ (inferred SQL) |
TASK |
TaskQueryProvider |
| SQL-237 |
Get active support order count |
LINQ (inferred SQL) |
CL_CLAIM_SUPPORT_ORDER |
WorkerQueryProvider |
| SQL-238 |
Get preferred contact method |
LINQ (inferred SQL) |
cl_pref_contact_method_code |
WorkerQueryProvider |
| SQL-239 |
Get health insurance provider name |
LINQ (inferred SQL) |
CL_INJURY_CLAIM |
WorkerQueryProvider |
| SQL-255 |
Type |
LINQ (inferred SQL) |
CLAIM_ADDRESS_TYPE_CODE |
AddressBuilder |
| SQL-256 |
Repository |
N/A (no query executed) |
|
Builder |
| SQL-257 |
Claim type |
LINQ (inferred SQL) |
CL_CLAIM_TYPE_CODE |
ClaimBuilder |
| SQL-258 |
Claim status |
LINQ (inferred SQL) |
claim_status_code |
ClaimBuilder |
| SQL-259 |
Claim status |
LINQ (inferred SQL) |
CL_CLAIM_STATUS_ACTIVITY |
ClaimBuilder |
| SQL-260 |
Policy |
LINQ (inferred SQL) |
POLICY |
ClaimBuilder |
| SQL-261 |
Jurisdiction |
LINQ (inferred SQL) |
CL_JURISDICTION_CODE |
ClaimCodeTableBuilder |
| SQL-262 |
Claim type |
LINQ (inferred SQL) |
CL_CLAIM_TYPE_CODE |
ClaimCodeTableBuilder |
| SQL-263 |
Claim status |
LINQ (inferred SQL) |
claim_status_code |
ClaimCodeTableBuilder |
| SQL-264 |
Address type |
LINQ (inferred SQL) |
CLAIM_ADDRESS_TYPE_CODE |
ClaimCodeTableBuilder |
| SQL-265 |
Claim responsibility |
LINQ (inferred SQL) |
CL_CLAIM_RESPONSIBILITY |
ClaimCodeTableBuilder |
| SQL-266 |
Seed for ebilling |
LINQ (inferred SQL) |
EBILL_BATCH_STATUS_CODE |
EbillingExtensions |
| SQL-267 |
Seed for ebilling |
LINQ (inferred SQL) |
EBILL_STATUS_CODE |
EbillingExtensions |
| SQL-268 |
Seed for ebilling |
LINQ (inferred SQL) |
EBILL_SET_TYPE_CODE |
EbillingExtensions |
| SQL-269 |
Seed for ebilling |
LINQ (inferred SQL) |
EBILL_ADDRESS_TYPE_CODE |
EbillingExtensions |
| SQL-270 |
Seed for ebilling |
LINQ (inferred SQL) |
EBILL_DOCUMENT_TYPE_CODE |
EbillingExtensions |
| SQL-271 |
Seed for ebilling |
LINQ (inferred SQL) |
EBILL_BATCH_TYPE_CODE |
EbillingExtensions |
| SQL-272 |
Update document type with set code |
LINQ (inferred SQL) |
EBILL_DOCUMENT_TYPE_CODE, EBILL_SET_TYPE_CODE |
EbillingExtensions |
| SQL-273 |
Update document type with set code |
LINQ (inferred SQL) |
EBILL_SET_TYPE_CODE |
EbillingExtensions |
| SQL-274 |
Seed for online support |
LINQ (inferred SQL) |
ERROR_GROUP_CODE |
OnlineSupportExtensions |
| SQL-275 |
Seed for online support |
LINQ (inferred SQL) |
ERROR_ENVIRONMENT |
OnlineSupportExtensions |
| SQL-276 |
Seed for online support |
LINQ (inferred SQL) |
App_Error |
OnlineSupportExtensions |
| SQL-277 |
Seed for policy testing |
LINQ (inferred SQL) |
MARKET_TYPE_CODE |
PolicyExtensions |
| SQL-278 |
Seed for policy testing |
LINQ (inferred SQL) |
POLICY_RELATIONSHIP_CODE |
PolicyExtensions |
| SQL-279 |
Seed for policy testing |
LINQ (inferred SQL) |
OFFICE_CODE |
PolicyExtensions |
| SQL-280 |
Generate agencies |
LINQ (inferred SQL) |
Agency |
PolicyExtensions |
| SQL-281 |
Generate default policies |
LINQ (inferred SQL) |
POLICY_TEAM_FUNCTION |
PolicyExtensions |
| SQL-282 |
Generate default policies |
LINQ (inferred SQL) |
MARKET_TYPE_CODE |
PolicyExtensions |
| SQL-283 |
Generate default policies |
LINQ (inferred SQL) |
OFFICE_CODE |
PolicyExtensions |
| SQL-284 |
Generate relationship policies |
LINQ (inferred SQL) |
MARKET_TYPE_CODE |
PolicyExtensions |
| SQL-285 |
Generate relationship policies |
LINQ (inferred SQL) |
POLICY_RELATIONSHIP_CODE |
PolicyExtensions |
| SQL-286 |
Get regional policy served by direct writer |
LINQ (inferred SQL) |
POLICY, Agent |
PolicyOutputDocumentExtensions |
| SQL-287 |
Seed with documents on a policy served by an external agent |
LINQ (inferred SQL) |
POLICY, Agent |
PolicyOutputDocumentExtensions |
| SQL-288 |
Seed for document testing |
LINQ (inferred SQL) |
document_status_code |
PolicyOutputDocumentExtensions |
| SQL-289 |
Seed for document testing |
LINQ (inferred SQL) |
output_document_category_code |
PolicyOutputDocumentExtensions |
| SQL-290 |
Seed for document testing |
LINQ (inferred SQL) |
image_category_code |
PolicyOutputDocumentExtensions |
| SQL-291 |
Seed for document testing |
LINQ (inferred SQL) |
image_category_code, image_document_type_code |
PolicyOutputDocumentExtensions |
| SQL-292 |
Seed for document testing |
LINQ (inferred SQL) |
output_doc_notify_text_code |
PolicyOutputDocumentExtensions |
| SQL-293 |
Seed for document testing |
LINQ (inferred SQL) |
output_doc_notify_text_code, output_document_category_code, image_document_type_code, output_document_type_code |
PolicyOutputDocumentExtensions |
| SQL-294 |
Seed for document testing |
LINQ (inferred SQL) |
output_document_type_code, ENDORSE_CODE |
PolicyOutputDocumentExtensions |
| SQL-295 |
Get doc status |
LINQ (inferred SQL) |
document_status_code |
PolicyOutputDocumentExtensions |
| SQL-296 |
Generate packet |
LINQ (inferred SQL) |
POLICY |
PolicyOutputDocumentExtensions |
| SQL-297 |
Generate packet |
LINQ (inferred SQL) |
output_document_type_code |
PolicyOutputDocumentExtensions |
| SQL-298 |
Generate packet |
LINQ (inferred SQL) |
output_document_type_code |
PolicyOutputDocumentExtensions |
| SQL-299 |
Get document type |
LINQ (inferred SQL) |
output_document_type_code |
PolicyOutputDocumentExtensions |
| SQL-300 |
Add documents |
LINQ (inferred SQL) |
output_document_type_code |
PolicyOutputDocumentExtensions |
| SQL-301 |
Add agency viewable documents |
LINQ (inferred SQL) |
output_document_type_code |
PolicyOutputDocumentExtensions |
| SQL-302 |
Seed for task testing |
LINQ (inferred SQL) |
TASK_SOURCE_CODE |
TaskExtensions |
| SQL-303 |
Seed for task testing |
LINQ (inferred SQL) |
TASK_ACTION_CODE |
TaskExtensions |
| SQL-304 |
Seed for task testing |
LINQ (inferred SQL) |
TASK_PRIORITY_CODE |
TaskExtensions |
| SQL-305 |
Fill task category |
LINQ (inferred SQL) |
TASK_PRIORITY_CODE |
TaskExtensions |
| SQL-306 |
Fill task category |
LINQ (inferred SQL) |
TASK_ACTION_CODE |
TaskExtensions |
| SQL-307 |
Fill task category |
LINQ (inferred SQL) |
TASK_SOURCE_CODE |
TaskExtensions |