SAIF.Business SQL catalog

This page indexes the inline SQL statements and stored-procedure calls used by SAIF.Business.

Create operations

SQL ID	Description	Type	Tables	Business object
SQL-002	Pk82029 titan insert employee leave	StoredProc	EMPLOYEE_LEAVE	clsEmployeeLeave
SQL-003	Inline create used by ImageServices	Inline	PDF_CONVERSION_ERROR	ImageServices

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-004	Sp82288 calcmaxburialamt	StoredProc	N/A	ClaimServices
SQL-005	Pk82001 claim getpersonaddress	StoredProc	CL_INJURY_CLAIM	ClaimServices
SQL-006	Responsible-adjuster lookup by claim number	Inline	CL_INJURY_CLAIM, CL_CLAIM_RESPONSIBILITY	ClaimServices
SQL-007	Responsible-adjuster lookup by claim id	Inline	CL_INJURY_CLAIM, CL_CLAIM_RESPONSIBILITY	ClaimServices
SQL-008	Claim existence check	Inline	CL_INJURY_CLAIM	ClaimServices
SQL-009	Responsibility-code validation	Inline	CL_CLAIM_RESPONSIBILITY	ClaimServices
SQL-010	Legal-collection existence	Inline	LEGAL_COLLECTION	ClaimServices
SQL-011	Investigation request date	Inline	INVESTIGATION	ClaimServices
SQL-012	Existing benefit-payment search	Inline	CL_FINANCIAL_TRANS, CL_FINANCIAL_TRANS_DTL	ClaimServices
SQL-013	Payment-transaction status checks*	Inline	CL_FINANCIAL_TRANS	ClaimServices
SQL-014	Override-security lookup	Inline	CL_SECURITY_OVERRIDE, ADP_VIRTUAL_EMPLOYEE_VIEW	ClaimServices
SQL-015	Legal-case existence	Inline	LEGAL_CASE	ClaimServices
SQL-016	Incurred-cost aggregation	Inline	CL_INCURRED_CATEGORY_COST, CL_INCURRED_COST_HISTORY	ClaimServices
SQL-017	Support-order existence	Inline	CL_CLAIM_SUPPORT_ORDER_CONN	ClaimServices
SQL-018	Sp82348 claim authorization	StoredProc	ADP_EMPLOYEE	ClaimServices
SQL-019	Pk82350 eft isauthorizedforeft	StoredProc	PAYMENT_AUTHORIZATION	ClaimServices
SQL-020	Pk82350 eft isbeneficiaryauthforeft	StoredProc	PAYMENT_AUTHORIZATION	ClaimServices
SQL-021	External-view eligibility query	Inline	CL_INJURY_CLAIM	ClaimServices
SQL-022	Address/state/country/zip validation family*	Inline	ALL_STATES, ZIP_CODE, COUNTRY, ZIP_MCO_COUNTY	clsAddress, clsAddressStructure, ObjectServices
SQL-023	Employee retrieval (adp / virtual variant)*	Inline	ADP_EMPLOYEE, VIRTUAL_EMPLOYEE	clsEmployeeData
SQL-024	Wcis employee fallback	Inline	WCIS_EMPLOYEE	clsEmployeeData
SQL-025	Employee adjunct lookups*	Inline	ADP_EMPLOYEE, ADP_EMPLOYEE_PHONE_VIEW	clsEmployeeData
SQL-026	Employee collection retrieval*	Inline	ADP_EMPLOYEE, VIRTUAL_EMPLOYEE	clsEmployeeDataCollection
SQL-027	Employee-leave retrieval	Inline	EMPLOYEE_LEAVE	clsEmployeeLeave
SQL-028	Pk82029 titan select employee leave	StoredProc	EMPLOYEE_LEAVE	clsEmployeeLeaveCollection
SQL-029	Help-text retrieval	Inline	APPLICATION_HELP_DETAIL	clsHelpText
SQL-030	Help-text collection retrieval	Inline	APPLICATION_HELP_MASTER, APPLICATION_HELP_DETAIL	clsHelpTextCollection
SQL-031	Language-translation retrieval	Inline	LANGUAGE_TRANSLATION	clsLanguageTranslation
SQL-032	Language-translation collection retrieval*	Inline	LANGUAGE_TRANSLATION	clsLanguageTranslationCollection
SQL-033	Saif output-address retrieval	Inline	LOCATION	clsSAIFOutputAddress
SQL-034	Cp get group key 4 pms info	StoredProc	N/A	clsUserType
SQL-035	Eft procedure family*	StoredProc	N/A	EFTServices
SQL-036	External-user last-logon/user lookup family*	Inline	EXT_USER, EXT_USER_TYPE	ExternalUserServices
SQL-037	Image/ifn lookup family*	Inline	IMAGE, IMGSYS	ImageInfo
SQL-038	Imaging helper sql/procedure family*	Mixed	RECORDING; procedures only**	ImageServices
SQL-039	Mco lookup family	Inline	MCO_PLAN, MCO_GSA_LOCATION	MCOInfo
SQL-040	Code-map lookup family*	Inline	Code/lookup tables	mdlCodeMaps
SQL-041	Cp report date	StoredProc	N/A	ObjectServices
SQL-042	Policy lookup family*	Mixed	POLICY_PERIOD_ALL, POLICY, NON_EMPR_ACCT; procedures only**	PolicyServices
SQL-043	Unit-stat lookup family	Inline	POLICY_PERIOD_MASTER, POLICY, US_POLICY_UNIT	UnitStatServices

Update operations

SQL ID	Description	Type	Tables	Business object
SQL-044	Pharmacy-eligibility update	Inline	CL_PHARMACY_ELIGIBILITY_REPORT	ClaimServices
SQL-045	Payment-transaction-type next issue date update	Inline	PAYMENT_TRANSACTION_TYPE_CODE	ClaimServices
SQL-046	Pk82029 titan update employee leave	StoredProc	EMPLOYEE_LEAVE	clsEmployeeLeave

Delete operations

SQL ID	Description	Type	Tables	Business object
SQL-047	Pk82029 titan delete employee leave	StoredProc	EMPLOYEE_LEAVE	clsEmployeeLeave

Sequence operations

SQL ID	Description	Sequence	Tables	Business object
SQL-001	dual sequence used by clsHelpText	dual	DUAL	clsHelpText

Related documentation

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

Note: Statements marked with * are inferred from code behavior rather than explicit documentation or comments.

Sources

• Business\SAIF.Business\ClaimServices.vb
• Business\SAIF.Business\clsEmployeeData.vb
• Business\SAIF.Business\clsEmployeeDataCollection.vb
• Business\SAIF.Business\clsEmployeeLeave.vb
• Business\SAIF.Business\clsHelpText.vb
• Business\SAIF.Business\clsHelpTextCollection.vb
• Business\SAIF.Business\clsLanguageTranslation.vb
• Business\SAIF.Business\clsLanguageTranslationCollection.vb
• Business\SAIF.Business\clsSAIFOutputAddress.vb
• Business\SAIF.Business\clsUserType.vb
• Business\SAIF.Business\EFTServices.vb
• Business\SAIF.Business\ImageInfo.vb
• Business\SAIF.Business\ImageServices.vb
• Business\SAIF.Business\MCOInfo.vb
• Business\SAIF.Business\mdlCodeMaps.vb
• Business\SAIF.Business\ObjectServices.vb
• Business\SAIF.Business\PolicyServices.vb
• Business\SAIF.Business\UnitStatServices.vb
• Business\SAIF.Business\ContactInfo\clsAddress.vb
• Business\SAIF.Business\ContactInfo\clsAddressStructure.vb
• Business\SAIF.Business\Services\ExternalUserServices.vb