SAIF.Business.Policy.Core SQL catalog

This page indexes every SQL statement and stored-procedure invocation identified in this library.

Create operations

SQL ID	Description	Type	Tables	Business object
SQL-022	Insert cancellation reason	Inline	CANCEL_REASON_CODE	clsCancellationReason
SQL-023	Insert cancellation reason collection	Inline	CANCEL_REASON_CODE	clsCancellationReasonCollection
SQL-024	Insert cancellation warning	Inline	CANCELLATION	clsCancellationWarning
SQL-025	Insert cancellation warning collection	Inline	CANCELLATION	clsCancellationWarningCollection
SQL-026	Insert cancel reason override	Inline	CANCEL_REASON_OVERRIDE	clsCancelReasonOverride
SQL-027	Insert county	Inline	COUNTY	clsCounty
SQL-028	Insert county collection	Inline	COUNTY	clsCountyCollection
SQL-029	Insert insurance carrier	Inline	CARRIER_CODE	clsInsuranceCarrier
SQL-030	Insert location collection	Inline	LOCATION	clsLocationCollection
SQL-031	Insert policy period employer liability limits	Inline	POLICY_PERIOD_EMP_LIAB	clsPolicyPeriodEmployerLiabilityLimits
SQL-032	Insert policy period employer liability limits collection	Inline	POLICY_PERIOD_EMP_LIAB	clsPolicyPeriodEmployerLiabilityLimitsCollection
SQL-033	Insert policy period master	Inline	POLICY_PERIOD_MASTER	clsPolicyPeriodMaster
SQL-034	Insert policy team function	Inline	TEAM_FUNCTION_CODE	clsPolicyTeamFunction
SQL-035	Insert policy team function collection	Inline	TEAM_FUNCTION_CODE	clsPolicyTeamFunctionCollection
SQL-036	Insert policy team member	Inline	POLICY_TEAM_FUNCTION	clsPolicyTeamMember
SQL-037	Insert policy team member collection	Inline	POLICY_TEAM_FUNCTION	clsPolicyTeamMemberCollection
SQL-038	Insert prior coverage	Inline	PRIOR_COVERAGE	clsPriorCoverage
SQL-039	Insert prior coverage collection	Inline	PRIOR_COVERAGE	clsPriorCoverageCollection
SQL-040	Insert s a i f office	Inline	OFFICE_CODE	clsSAIFOffice
SQL-041	Insert s a i f office collection	Inline	OFFICE_CODE	clsSAIFOfficeCollection
SQL-042	Insert w c i s employee	Inline	WCIS_EMPLOYEE	clsWCISEmployee
SQL-043	Insert w c i s employee collection	Inline	WCIS_EMPLOYEE	clsWCISEmployeeCollection
SQL-044	Call pk72899_production_error.sp72900_post_production_error	Stored Proc	N/A	clsWCISInterfacer

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-045	Retrieve cancellation reason	Inline	CANCEL_REASON_CODE	clsCancellationReason
SQL-046	Retrieve cancellation reason collection	Inline	CANCEL_REASON_CODE	clsCancellationReasonCollection
SQL-047	Retrieve cancellation warning	Inline	CANCELLATION	clsCancellationWarning
SQL-048	Retrieve cancellation warning collection	Inline	CANCELLATION	clsCancellationWarningCollection
SQL-049	Retrieve cancel reason override	Inline	CANCELLATION	clsCancelReasonOverride
SQL-050	Retrieve cancel reason override	Inline	CANCELLATION, CANCEL_REASON_CODE	clsCancelReasonOverride
SQL-051	Retrieve cancel reason override	Inline	CANCELLATION, CARRIER_CHANGE_REASON_CODE	clsCancelReasonOverride
SQL-052	Retrieve cancel reason override	Inline	CANCELLATION, CARRIER_CODE	clsCancelReasonOverride
SQL-053	Retrieve cancel reason override	Inline	CANCEL_REASON_OVERRIDE	clsCancelReasonOverride
SQL-054	Retrieve county	Inline	COUNTY	clsCounty
SQL-055	Retrieve county collection	Inline	COUNTY	clsCountyCollection
SQL-056	Retrieve employer liability limits	Inline	N/A	clsEmployerLiabilityLimits
SQL-057	Retrieve employer liability limits collection	Inline	EMPLOYERS_LIABILITY_LIMITS, EMPLOYERS_LIABILITY_FACTORS	clsEmployerLiabilityLimitsCollection
SQL-058	Retrieve entity type	Inline	ENTITY_CODE	clsEntityType
SQL-059	Retrieve entity type collection	Inline	ENTITY_CODE	clsEntityTypeCollection
SQL-060	Retrieve insurance carrier	Inline	CARRIER_CODE	clsInsuranceCarrier
SQL-061	Call SP73029_GET_NONWCIS_GOV_CLASS	Stored Proc	N/A	clsLegacyPolicyPeriod
SQL-062	Retrieve legacy policy period	Inline	N/A	clsLegacyPolicyPeriod
SQL-063	Retrieve legacy policy period collection	Inline	POLICY_PERIOD_NON_WCIS	clsLegacyPolicyPeriodCollection
SQL-064	Retrieve location	Inline	LOCATION	clsLocation
SQL-065	Retrieve location collection	Inline	LOCATION	clsLocationCollection
SQL-066	Retrieve location contact	Inline	CONTACT	clsLocationContact
SQL-067	Retrieve location contact collection	Inline	CONTACT	clsLocationContactCollection
SQL-068	Retrieve location type	Inline	LOCATION_CODE	clsLocationType
SQL-069	Retrieve location type collection	Inline	LOCATION_CODE	clsLocationTypeCollection
SQL-070	Retrieve policy	Inline	CANCELLATION	clsPolicy
SQL-071	Retrieve policy	Inline	POLICY_PERIOD_MASTER	clsPolicy
SQL-072	Retrieve policy	Inline	BUSINESS	clsPolicy
SQL-073	Retrieve policy	Inline	POLICY	clsPolicy
SQL-074	Retrieve policy collection	Inline	POLICY	clsPolicyCollection
SQL-075	Retrieve policy location	Inline	CONTACT	clsPolicyLocation
SQL-076	Retrieve policy location	Inline	LOCATION	clsPolicyLocation
SQL-077	Retrieve policy location collection	Inline	LOCATION	clsPolicyLocationCollection
SQL-078	Call PK73059_prem_hist_summary.get_6_digit_gov_class	Stored Proc	N/A	clsPolicyPeriod
SQL-079	Call SP72658_GET_GOV_CLASS	Stored Proc	N/A	clsPolicyPeriod
SQL-080	Call Pk72195_Renewal.sp72187_get_standard_prem	Stored Proc	N/A	clsPolicyPeriod
SQL-081	Call pk72195_renewal.sp72190_calc_weighted_freq	Stored Proc	N/A	clsPolicyPeriod
SQL-082	Call sp73089_get_policy_bound_flag	Stored Proc	N/A	clsPolicyPeriod
SQL-083	Retrieve policy period	Inline	N/A	clsPolicyPeriod
SQL-084	Retrieve policy period base	Inline	NON_WCIS_STAT_TRANS	clsPolicyPeriodBase
SQL-085	Call pk72846_view_policy.sp73111_get_wcis_std_premium	Stored Proc	N/A	clsPolicyPeriodBase
SQL-086	Call pk73057_billing_master.is_on_arrears_plan	Stored Proc	N/A	clsPolicyPeriodBase
SQL-087	Call pk73057_billing_master.bm_report_schedule_flag_yn	Stored Proc	N/A	clsPolicyPeriodBase
SQL-088	Retrieve policy period collection	Inline	POLICY_PERIOD	clsPolicyPeriodCollection
SQL-089	Retrieve policy period employer liability limits	Inline	POLICY_PERIOD_EMP_LIAB	clsPolicyPeriodEmployerLiabilityLimits
SQL-090	Retrieve policy period employer liability limits collection	Inline	POLICY_PERIOD_EMP_LIAB	clsPolicyPeriodEmployerLiabilityLimitsCollection
SQL-091	Retrieve policy period master	Inline	POLICY_PERIOD_MASTER	clsPolicyPeriodMaster
SQL-092	Retrieve policy period status	Inline	POLICY_PERIOD_STATUS_CODE	clsPolicyPeriodStatus
SQL-093	Retrieve policy period status collection	Inline	POLICY_PERIOD_STATUS_CODE	clsPolicyPeriodStatusCollection
SQL-094	Retrieve policy status code	Inline	POLICY_STATUS_CODE	clsPolicyStatusCode
SQL-095	Retrieve policy status code collection	Inline	POLICY_STATUS_CODE	clsPolicyStatusCodeCollection
SQL-096	Retrieve policy team function	Inline	TEAM_FUNCTION_CODE	clsPolicyTeamFunction
SQL-097	Retrieve policy team function collection	Inline	TEAM_FUNCTION_CODE	clsPolicyTeamFunctionCollection
SQL-098	Retrieve policy team member	Inline	POLICY_TEAM_FUNCTION	clsPolicyTeamMember
SQL-099	Retrieve policy team member collection	Inline	POLICY_TEAM_FUNCTION	clsPolicyTeamMemberCollection
SQL-100	Retrieve prior coverage	Inline	PRIOR_COVERAGE	clsPriorCoverage
SQL-101	Retrieve prior coverage collection	Inline	PRIOR_COVERAGE	clsPriorCoverageCollection
SQL-102	Retrieve s a i f office	Inline	OFFICE_CODE	clsSAIFOffice
SQL-103	Retrieve s a i f office collection	Inline	OFFICE_CODE	clsSAIFOfficeCollection
SQL-104	Retrieve w c i s employee	Inline	WCIS_EMPLOYEE	clsWCISEmployee
SQL-105	Retrieve w c i s employee collection	Inline	WCIS_EMPLOYEE	clsWCISEmployeeCollection
SQL-106	Retrieve w c i s inquiry	Inline	SUB_CONSTANTS	WCISInquiry
SQL-107	Call Pk73190_Quoteprint.Get_Billing_Master_Count	Stored Proc	N/A	WCISInquiry
SQL-108	Call sp72814_get_cont_cov_date	Stored Proc	N/A	WCISInquiry
SQL-109	Retrieve w c i s inquiry	Inline	POLICY_PERIOD	WCISInquiry
SQL-110	Call pk73059_prem_hist_summary.determine_manual_premium	Stored Proc	N/A	WCISInquiry
SQL-111	Retrieve w c i s inquiry	Inline	POLICY	WCISInquiry
SQL-112	Retrieve w c i s inquiry	Inline	POLICY_PERIOD	WCISInquiry
SQL-113	Retrieve w c i s inquiry	Inline	SUB_CONSTANTS	WCISInquiry
SQL-114	Retrieve w c i s inquiry	Inline	POLICY	WCISInquiry
SQL-115	Retrieve w c i s inquiry	Inline	POLICY	WCISInquiry
SQL-116	Call Pk73190_Quoteprint.Get_Premium_History_Count	Stored Proc	N/A	WCISInquiry
SQL-117	Call Pk73190_Quoteprint.Get_Rating_Plan_Count	Stored Proc	N/A	WCISInquiry
SQL-118	Retrieve w c i s inquiry	Inline	WCIS_CONSTANTS	WCISInquiry
SQL-119	Call SP72347_INFO_PAGE_PRINTED_YN	Stored Proc	N/A	WCISInquiry
SQL-120	Call Sp72803_Edit_Prelim_Audit	Stored Proc	N/A	WCISInquiry
SQL-121	Call pk72226_team_assignment.regional_office_yn	Stored Proc	N/A	WCISInquiry

Update operations

SQL ID	Description	Type	Tables	Business object
SQL-122	Update cancellation reason	Inline	CANCEL_REASON_CODE	clsCancellationReason
SQL-123	Update cancellation reason collection	Inline	CANCEL_REASON_CODE	clsCancellationReasonCollection
SQL-124	Update cancellation warning	Inline	CANCELLATION	clsCancellationWarning
SQL-125	Update cancellation warning collection	Inline	CANCELLATION	clsCancellationWarningCollection
SQL-126	Update county	Inline	COUNTY	clsCounty
SQL-127	Update county collection	Inline	COUNTY	clsCountyCollection
SQL-128	Update insurance carrier	Inline	CARRIER_CODE	clsInsuranceCarrier
SQL-129	Update location	Inline	LOCATION	clsLocation
SQL-130	Update location collection	Inline	LOCATION	clsLocationCollection
SQL-131	Update policy location	Inline	LOCATION_VIEW	clsPolicyLocation
SQL-132	Update policy period employer liability limits	Inline	POLICY_PERIOD_EMP_LIAB	clsPolicyPeriodEmployerLiabilityLimits
SQL-133	Update policy period employer liability limits collection	Inline	POLICY_PERIOD_EMP_LIAB	clsPolicyPeriodEmployerLiabilityLimitsCollection
SQL-134	Update policy period master	Inline	POLICY_PERIOD_MASTER	clsPolicyPeriodMaster
SQL-135	Update policy team function	Inline	TEAM_FUNCTION_CODE	clsPolicyTeamFunction
SQL-136	Update policy team function collection	Inline	TEAM_FUNCTION_CODE	clsPolicyTeamFunctionCollection
SQL-137	Update policy team member	Inline	POLICY_TEAM_FUNCTION	clsPolicyTeamMember
SQL-138	Update policy team member collection	Inline	POLICY_TEAM_FUNCTION	clsPolicyTeamMemberCollection
SQL-139	Update prior coverage	Inline	PRIOR_COVERAGE	clsPriorCoverage
SQL-140	Update prior coverage collection	Inline	PRIOR_COVERAGE	clsPriorCoverageCollection
SQL-141	Update s a i f office	Inline	OFFICE_CODE	clsSAIFOffice
SQL-142	Update s a i f office collection	Inline	OFFICE_CODE	clsSAIFOfficeCollection
SQL-143	Update w c i s employee	Inline	WCIS_EMPLOYEE	clsWCISEmployee
SQL-144	Update w c i s employee collection	Inline	WCIS_EMPLOYEE	clsWCISEmployeeCollection

Delete operations

SQL ID	Description	Type	Tables	Business object
SQL-145	Delete cancellation reason	Inline	CANCEL_REASON_CODE	clsCancellationReason
SQL-146	Delete cancellation reason collection	Inline	CANCEL_REASON_CODE	clsCancellationReasonCollection
SQL-147	Delete cancellation warning	Inline	CANCELLATION	clsCancellationWarning
SQL-148	Delete cancellation warning collection	Inline	CANCELLATION	clsCancellationWarningCollection
SQL-149	Delete county	Inline	COUNTY	clsCounty
SQL-150	Delete county collection	Inline	COUNTY	clsCountyCollection
SQL-151	Delete insurance carrier	Inline	CARRIER_CODE	clsInsuranceCarrier
SQL-152	Delete location collection	Inline	LOCATION	clsLocationCollection
SQL-153	Delete policy period employer liability limits	Inline	POLICY_PERIOD_EMP_LIAB	clsPolicyPeriodEmployerLiabilityLimits
SQL-154	Delete policy period employer liability limits collection	Inline	POLICY_PERIOD_EMP_LIAB	clsPolicyPeriodEmployerLiabilityLimitsCollection
SQL-155	Delete policy period master	Inline	POLICY_PERIOD_MASTER	clsPolicyPeriodMaster
SQL-156	Delete policy team function	Inline	TEAM_FUNCTION_CODE	clsPolicyTeamFunction
SQL-157	Delete policy team function collection	Inline	TEAM_FUNCTION_CODE	clsPolicyTeamFunctionCollection
SQL-158	Delete policy team member	Inline	POLICY_TEAM_FUNCTION	clsPolicyTeamMember
SQL-159	Delete policy team member collection	Inline	POLICY_TEAM_FUNCTION	clsPolicyTeamMemberCollection
SQL-160	Delete prior coverage	Inline	PRIOR_COVERAGE	clsPriorCoverage
SQL-161	Delete prior coverage collection	Inline	PRIOR_COVERAGE	clsPriorCoverageCollection
SQL-162	Delete s a i f office	Inline	OFFICE_CODE	clsSAIFOffice
SQL-163	Delete s a i f office collection	Inline	OFFICE_CODE	clsSAIFOfficeCollection
SQL-164	Delete w c i s employee	Inline	WCIS_EMPLOYEE	clsWCISEmployee
SQL-165	Delete w c i s employee collection	Inline	WCIS_EMPLOYEE	clsWCISEmployeeCollection

Sequence operations

SQL ID	Description	Sequence	Tables	Business object
SQL-001	Fetch next cancellation reason sequence value	DUAL	DUAL	clsCancellationReason
SQL-002	Fetch next cancellation reason collection sequence value	DUAL	DUAL	clsCancellationReasonCollection
SQL-003	Fetch next cancellation warning sequence value	DUAL	DUAL	clsCancellationWarning
SQL-004	Fetch next cancellation warning collection sequence value	DUAL	DUAL	clsCancellationWarningCollection
SQL-005	Fetch next county sequence value	DUAL	DUAL	clsCounty
SQL-006	Fetch next county collection sequence value	DUAL	DUAL	clsCountyCollection
SQL-007	Fetch next insurance carrier sequence value	DUAL	DUAL	clsInsuranceCarrier
SQL-008	Fetch next location sequence value	DUAL	DUAL	clsLocation
SQL-009	Fetch next location collection sequence value	DUAL	DUAL	clsLocationCollection
SQL-010	Fetch next policy period employer liability limits sequence value	DUAL	DUAL	clsPolicyPeriodEmployerLiabilityLimits
SQL-011	Fetch next policy period employer liability limits collection sequence value	DUAL	DUAL	clsPolicyPeriodEmployerLiabilityLimitsCollection
SQL-012	Fetch next policy period master sequence value	DUAL	DUAL	clsPolicyPeriodMaster
SQL-013	Fetch next policy team function sequence value	DUAL	DUAL	clsPolicyTeamFunction
SQL-014	Fetch next policy team function collection sequence value	DUAL	DUAL	clsPolicyTeamFunctionCollection
SQL-015	Fetch next policy team member collection sequence value	DUAL	DUAL	clsPolicyTeamMemberCollection
SQL-016	Fetch next prior coverage sequence value	DUAL	DUAL	clsPriorCoverage
SQL-017	Fetch next prior coverage collection sequence value	DUAL	DUAL	clsPriorCoverageCollection
SQL-018	Fetch next s a i f office sequence value	DUAL	DUAL	clsSAIFOffice
SQL-019	Fetch next s a i f office collection sequence value	DUAL	DUAL	clsSAIFOfficeCollection
SQL-020	Fetch next w c i s employee sequence value	DUAL	DUAL	clsWCISEmployee
SQL-021	Fetch next w c i s employee collection sequence value	DUAL	DUAL	clsWCISEmployeeCollection

Related documentation

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

Sources

• Business\SAIF.Business.Policy.Core\clsPolicy.vb
• Business\SAIF.Business.Policy.Core\clsPolicyPeriod.vb
• Business\SAIF.Business.Policy.Core\clsLegacyPolicyPeriod.vb
• Business\SAIF.Business.Policy.Core\WCISInquiry.vb
• Business\SAIF.Business.Policy.Core\clsWCISInterfacer.vb