SAIF.Business.View.Claim SQL catalog

This page indexes all SQL statements and stored procedure calls used by this library.

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-001	Count active support orders	Inline	cl_claim_support_order	clsClaimData
SQL-002	Retrieve MCO short description	Inline	MCO_PLAN	clsClaimData
SQL-003	Read via sp83411_Calc_Total_Paid	StoredProc	Stored procedure-owned tables not available	clsClaimData
SQL-004	Read via pk83407_payment_hist_trans.getPayRemarks	StoredProc	Stored procedure-owned tables not available	clsFinancialTransaction
SQL-005	Read via pk83407_payment_hist_trans.getPayRemarks	StoredProc	Stored procedure-owned tables not available	clsFinancialTransaction
SQL-006	Read via pk82281_claim_note.select_by_claimnum	StoredProc	Stored procedure-owned tables not available	Criteria
SQL-007	Read via pk83407_payment_hist_trans.SelectFinTranByClaimId	StoredProc	Stored procedure-owned tables not available	Criteria
SQL-008	Read via pk83407_payment_hist_trans.SelectFinTranByPolicyNum	StoredProc	Stored procedure-owned tables not available	Criteria
SQL-009	Read via pk83407_payment_hist_trans.SelectReimbFinTranByIssueDate	StoredProc	Stored procedure-owned tables not available	Criteria
SQL-010	Retrieve prison-code list with blank option	Inline	CL_PRISON_CODE	Criteria
SQL-011	Retrieve prison-code list with blank option	Inline	CL_PRISON_CODE	Criteria
SQL-012	Read CL_CLAIM_COST_CATEGORY_CODE	Inline	CL_CLAIM_COST_CATEGORY_CODE	Criteria
SQL-013	Read CL_CLAIM_RESPONSIBILITY	Inline	CL_CLAIM_RESPONSIBILITY	Criteria
SQL-014	Read CL_CLOSURE_LOCATION_TYPE_CODE	Inline	CL_CLOSURE_LOCATION_TYPE_CODE	Criteria
SQL-015	Read CL_CLOSURE_LOCATION_TYPE_CODE	Inline	CL_CLOSURE_LOCATION_TYPE_CODE	Criteria
SQL-016	Read CL_CLOSURE_TYPE_OF_ORDER_CODE	Inline	CL_CLOSURE_TYPE_OF_ORDER_CODE	Criteria
SQL-017	Read CL_CLOSURE_TYPE_OF_ORDER_CODE	Inline	CL_CLOSURE_TYPE_OF_ORDER_CODE	Criteria
SQL-018	Read CL_MCO_STATUS_REASON_CODE	Inline	CL_MCO_STATUS_REASON_CODE	Criteria
SQL-019	Read CL_MCO_STATUS_REASON_CODE	Inline	CL_MCO_STATUS_REASON_CODE	Criteria
SQL-020	Read CL_ORDER_TYPE_CODE	Inline	CL_ORDER_TYPE_CODE	Criteria
SQL-021	Read CL_ORDER_TYPE_CODE	Inline	CL_ORDER_TYPE_CODE	Criteria
SQL-022	Retrieve medical condition detail with latest decision	Inline	cl_medical_condition, cl_cond_compensability_decisn, condition_type_code, claim_decision_code, claim_denial_final_reas_cd, claim_denial_reason_code, claim_denial_status_code	Criteria
SQL-023	Read CL_WORK_STATUS_CODE	Inline	CL_WORK_STATUS_CODE	Criteria
SQL-024	Read CL_WORK_STATUS_CODE	Inline	CL_WORK_STATUS_CODE	Criteria
SQL-025	Read CL_WORK_RELEASE_CODE	Inline	CL_WORK_RELEASE_CODE	Criteria
SQL-026	Read CL_WORK_RELEASE_CODE	Inline	CL_WORK_RELEASE_CODE	Criteria
SQL-027	Read VOCATIONAL_RESP_CODE	Inline	VOCATIONAL_RESP_CODE	Criteria
SQL-028	Read CLAIM_ACTIVITY_CAT_TYPE_CODE	Inline	CLAIM_ACTIVITY_CAT_TYPE_CODE	Criteria
SQL-029	Read via sp83411_Calc_Total_Paid	StoredProc	Stored procedure-owned tables not available	Criteria
SQL-030	Count active support orders	Inline	cl_claim_support_order	may
SQL-031	Retrieve MCO short description	Inline	MCO_PLAN	may

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• Procedures
• API reference

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business.View.Claim\clsClaimData.vb
• Business\SAIF.Business.View.Claim\clsClaimData.vb
• Business\SAIF.Business.View.Claim\clsClaimData.vb
• Business\SAIF.Business.View.Claim\clsFinancialTransaction.vb
• Business\SAIF.Business.View.Claim\clsFinancialTransaction.vb
• Business\SAIF.Business.View.Claim\clsClaimNoteData.vb
• Business\SAIF.Business.View.Claim\clsFinancialTransactionCollection.vb
• Business\SAIF.Business.View.Claim\clsFinancialTransactionCollection.vb
• Business\SAIF.Business.View.Claim\clsFinancialTransactionCollection.vb
• Business\SAIF.Business.View.Claim\clsPrisonCodeCollection.vb
• Business\SAIF.Business.View.Claim\clsPrisonCode.vb
• Business\SAIF.Business.View.Claim\clsClaimCostCategoryCodeCollection.vb
• Business\SAIF.Business.View.Claim\clsClaimResponsibilityData.vb
• Business\SAIF.Business.View.Claim\clsClosureLocationTypeCodeCollection.vb
• Business\SAIF.Business.View.Claim\clsClosureLocationTypeCode.vb
• Business\SAIF.Business.View.Claim\clsClosureTypeOfOrderCodeCollection.vb
• Business\SAIF.Business.View.Claim\clsClosureTypeofOrderCode.vb
• Business\SAIF.Business.View.Claim\clsMcoStatusReasonCodeTable.vb
• Business\SAIF.Business.View.Claim\clsMcoStatusReasonCode.vb
• Business\SAIF.Business.View.Claim\clsOrderTypeCodeCollection.vb
• Business\SAIF.Business.View.Claim\clsOrderTypeCode.vb
• Business\SAIF.Business.View.Claim\clsMedicalConditionData.vb
• Business\SAIF.Business.View.Claim\clsWorkStatusCodeTable.vb
• Business\SAIF.Business.View.Claim\clsWorkStatusCode.vb
• Business\SAIF.Business.View.Claim\clsWorkReleaseCodeTable.vb
• Business\SAIF.Business.View.Claim\clsWorkReleaseCode.vb
• Business\SAIF.Business.View.Claim\clsVocResponsibilityData.vb
• Business\SAIF.Business.View.Claim\clsClaimActivityTypeCodeCollection.vb
• Business\SAIF.Business.View.Claim\clsClaimData.vb
• Business\SAIF.Business.View.Claim\clsClaimData.vb
• Business\SAIF.Business.View.Claim\clsClaimData.vb