SAIF.Business.Policy.Audit.Premium SQL catalog¶
This page indexes all SQL statements and stored procedure calls in this library, grouped by operation type.
Create operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-004 | Insert Pa Audit Data | Inline | PA_AUDIT |
clsAudit |
| SQL-005 | Insert Pa Assign Override Data | Inline | PA_ASSIGN_OVERRIDE |
clsAuditAssignmentOverride |
| SQL-006 | Insert Pa Event Data | Inline | PA_EVENT |
clsAuditEvent |
| SQL-007 | Insert Pa Event Data | Inline | PA_EVENT |
clsAuditEventCollection |
| SQL-008 | Insert Pa Auditor Data | Inline | PA_AUDITOR |
clsAuditor |
| SQL-009 | Insert Pa Auditor Zip Code Data | Inline | PA_AUDITOR_ZIP_CODE |
clsAuditorZipCode |
| SQL-010 | Insert N/A — Stored Procedure Data | Stored Proc | N/A | clsAuditPolicyPeriod |
| SQL-011 | Insert Pa Policy Period Data | Inline | PA_POLICY_PERIOD |
clsAuditPolicyPeriod |
| SQL-012 | Insert Pa Policy Data | Inline | PA_POLICY |
clsAuditPolicySchedulingDetail |
| SQL-013 | Insert Pa Result Data | Inline | PA_RESULT |
clsAuditResult |
| SQL-014 | Insert Pa Review Result Data | Inline | PA_REVIEW_RESULT |
clsAuditReviewResult |
| SQL-015 | Insert Pa Policy Data | Inline | PA_POLICY |
clsAuditSelectionOverride |
| SQL-016 | Insert Pa Selection Test Data | Inline | PA_SELECTION_TEST |
clsAuditSelectionTestResult |
| SQL-017 | Insert Pa Premium Audit Result Data | Inline | PA_PREMIUM_AUDIT_RESULT |
clsPremiumAuditResult |
| SQL-020 | Execute N/A — Stored Procedure Data | Stored Proc | N/A | clsAudit |
Read operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-018 | Read N/A — Stored Procedure Data | Stored Proc | N/A | clsAudit |
| SQL-019 | Read Pa Audit Data | Inline | PA_AUDIT, PA_POLICY_PERIOD |
clsAudit |
| SQL-021 | Read Pa Audit Data | Inline | PA_AUDIT, PA_POLICY_PERIOD |
clsAudit |
| SQL-022 | Read Trading As Data | Inline | TRADING_AS |
clsAudit |
| SQL-023 | Read Policy Data | Inline | POLICY, BUSINESS |
clsAudit |
| SQL-024 | Read Pa Audit Data | Inline | PA_AUDIT, POLICY |
clsAudit |
| SQL-025 | Read N/A — Stored Procedure Data | Stored Proc | N/A | clsAuditablePeriodCollection |
| SQL-026 | Read Pa Assign Override Data | Inline | PA_ASSIGN_OVERRIDE |
clsAuditAssignmentOverride |
| SQL-027 | Read Pa Audit Data | Inline | PA_AUDIT, PA_POLICY_PERIOD, PA_AUDITOR, BUSINESS, POLICY, OFFICE_CODE, LOCATION, PA_AUDITOR_ZIP_CODE, PA_ZIP_CODE, COUNTY |
clsAuditCollection |
| SQL-028 | Read Policy Data | Inline | POLICY, POLICY_PERIOD |
clsAuditCollection |
| SQL-029 | Read Pa Audit Data | Inline | PA_AUDIT, POLICY |
clsAuditCollection |
| SQL-030 | Read Pa Event Data | Inline | PA_EVENT |
clsAuditEvent |
| SQL-031 | Read Pa Event Data | Inline | PA_EVENT |
clsAuditEventCollection |
| SQL-032 | Read Pa Auditor Data | Inline | PA_AUDITOR |
clsAuditor |
| SQL-033 | Read Pa Auditor Data | Inline | PA_AUDITOR |
clsAuditorCollection |
| SQL-034 | Read Pa Auditor Zip Code Data | Inline | PA_AUDITOR_ZIP_CODE |
clsAuditorZipCodeCollection |
| SQL-035 | Read N/A — Stored Procedure Data | Stored Proc | N/A | clsAuditPolicyCollection |
| SQL-036 | Read Trading As Data | Inline | TRADING_AS |
clsAuditPolicyCollection |
| SQL-037 | Read Er Combination Policy Data | Inline | ER_COMBINATION_POLICY, POLICY |
clsAuditPolicyCollection |
| SQL-038 | Read N/A — Stored Procedure Data | Stored Proc | N/A | clsAuditPolicyPeriod |
| SQL-039 | Read N/A — Stored Procedure Data | Stored Proc | N/A | clsAuditPolicyPeriod |
| SQL-040 | Read N/A — Stored Procedure Data | Stored Proc | N/A | clsAuditPolicyPeriod |
| SQL-041 | Read N/A — Stored Procedure Data | Stored Proc | N/A | clsAuditPolicyPeriod |
| SQL-042 | Read N/A — Stored Procedure Data | Stored Proc | N/A | clsAuditPolicyPeriod |
| SQL-043 | Read N/A — Stored Procedure Data | Stored Proc | N/A | clsAuditPolicyPeriod |
| SQL-044 | Read Pa Policy Data | Inline | PA_POLICY |
clsAuditPolicySchedulingDetail |
| SQL-045 | Read Pa Result Data | Inline | PA_RESULT |
clsAuditResult |
| SQL-046 | Read Pa Result Data | Inline | PA_RESULT, PA_RESULT_TYPE |
clsAuditResultCollection |
| SQL-047 | Read Pa Result Type Data | Inline | PA_RESULT_TYPE |
clsAuditResultType |
| SQL-048 | Read Pa Result Type Data | Inline | PA_RESULT_TYPE |
clsAuditResultTypeCollection |
| SQL-049 | Read Pa Review Reason Code Data | Inline | PA_REVIEW_REASON_CODE, PA_REVIEW_REASON_RESULT |
clsAuditReviewReasonCode |
| SQL-050 | Read Pa Review Reason Code Data | Inline | PA_REVIEW_REASON_CODE, PA_REVIEW_REASON_RESULT |
clsAuditReviewReasonCodeCollection |
| SQL-051 | Read Pa Review Result Data | Inline | PA_REVIEW_RESULT, PA_AUDIT |
clsAuditReviewResult |
| SQL-052 | Read Pa Review Result Code Data | Inline | PA_REVIEW_RESULT_CODE, PA_REVIEW_REASON_RESULT |
clsAuditReviewResultCode |
| SQL-053 | Read Pa Review Result Code Data | Inline | PA_REVIEW_RESULT_CODE, PA_REVIEW_REASON_RESULT |
clsAuditReviewResultCodeCollection |
| SQL-054 | Read Pa Review Result Data | Inline | PA_REVIEW_RESULT, PA_AUDIT |
clsAuditReviewResultCollection |
| SQL-055 | Read Pa Selection Category Code Data | Inline | PA_SELECTION_CATEGORY_CODE, PA_SLCTN_CATEGORY_GROUP_CODE |
clsAuditSelectionCategoryCode |
| SQL-056 | Read Pa Selection Category Code Data | Inline | PA_SELECTION_CATEGORY_CODE, PA_SLCTN_CATEGORY_GROUP_CODE |
clsAuditSelectionCategoryCodeCollection |
| SQL-057 | Read Pa Slctn Category Market Type Data | Inline | PA_SLCTN_CATEGORY_MARKET_TYPE, PA_SLCTN_CAT_MKT_TYPE_REASON, PA_SELECTION_CATEGORY_CODE |
clsAuditSelectionCategoryCollection |
| SQL-058 | Read Lf Apvenmast Data | Inline | LF_APVENMAST |
clsAuditSelectionNotification |
| SQL-059 | Read Pa Policy Data | Inline | PA_POLICY |
clsAuditSelectionOverride |
| SQL-060 | Read N/A — Stored Procedure Data | Stored Proc | N/A | clsAuditSelectionPolicyPeriod |
| SQL-061 | Read N/A — Stored Procedure Data | Stored Proc | N/A | clsAuditSelectionPolicyPeriodCollection |
| SQL-062 | Read Pa Selection Rule Threshold Data | Inline | PA_SELECTION_RULE_THRESHOLD |
clsAuditSelectionTester |
| SQL-063 | Read Pa Selection Rule Data | Inline | PA_SELECTION_RULE, PA_SLCTN_CAT_MKT_TYPE_RSN_RULE, PA_SLCTN_CATEGORY_MARKET_TYPE |
clsAuditSelectionTester |
| SQL-064 | Read Pa Selection Rule Value Data | Inline | PA_SELECTION_RULE_VALUE |
clsAuditSelectionTesterValue |
| SQL-065 | Read Pa Selection Rule Data | Inline | PA_SELECTION_RULE, PA_SLCTN_CAT_MKT_TYPE_RSN_RULE, PA_SLCTN_CATEGORY_MARKET_TYPE, PA_SELECTION_RULE_VALUE |
clsAuditSelectionTesterValueCollection |
| SQL-066 | Read Pa Selection Test Data | Inline | PA_SELECTION_TEST, PA_SELECTION_RULE |
clsAuditSelectionTestResultCollection |
| SQL-067 | Read Pa Reason Code Data | Inline | PA_REASON_CODE |
clsPAReasonCode |
| SQL-068 | Read Pa Reason Code Data | Inline | PA_REASON_CODE |
clsPAReasonCodeCollection |
| SQL-069 | Read Pa Premium Audit Result Data | Inline | PA_PREMIUM_AUDIT_RESULT |
clsPremiumAuditResult |
| SQL-070 | Read Pa Type Market Type Data | Inline | PA_TYPE_MARKET_TYPE, PA_TYPE_CODE |
clsPremiumAuditTypeCode |
| SQL-071 | Read Pa Type Market Type Data | Inline | PA_TYPE_MARKET_TYPE, PA_TYPE_CODE |
clsPremiumAuditTypeCodeCollection |
| SQL-072 | Read Pa Status Code Data | Inline | PA_STATUS_CODE |
clsStatusCollection |
| SQL-073 | Read Pa Selection Rule Data | Inline | PA_SELECTION_RULE, PA_SLCTN_CAT_MKT_TYPE_RSN_RULE, PA_SLCTN_CATEGORY_MARKET_TYPE |
clsWorkbookReviewTester |
| SQL-074 | Read Pa Zip Code Data | Inline | PA_ZIP_CODE, COUNTY, OFFICE_CODE |
clsZipCode |
| SQL-075 | Read Pa Zip Code Data | Inline | PA_ZIP_CODE, COUNTY, OFFICE_CODE |
clsZipCodeCollection |
Update operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-076 | Update Pa Audit Data | Inline | PA_AUDIT |
clsAudit |
| SQL-077 | Update Pa Assign Override Data | Inline | PA_ASSIGN_OVERRIDE |
clsAuditAssignmentOverride |
| SQL-078 | Update Pa Event Data | Inline | PA_EVENT |
clsAuditEvent |
| SQL-079 | Update Pa Auditor Data | Inline | PA_AUDITOR |
clsAuditor |
| SQL-080 | Update Pa Auditor Zip Code Data | Inline | PA_AUDITOR_ZIP_CODE |
clsAuditorZipCode |
| SQL-081 | Update N/A — Stored Procedure Data | Stored Proc | N/A | clsAuditPolicyPeriod |
| SQL-082 | Update Pa Policy Period Data | Inline | PA_POLICY_PERIOD |
clsAuditPolicyPeriod |
| SQL-083 | Update Pa Policy Data | Inline | PA_POLICY |
clsAuditPolicySchedulingDetail |
| SQL-084 | Update Pa Result Data | Inline | PA_RESULT |
clsAuditResult |
| SQL-085 | Update Pa Review Result Data | Inline | PA_REVIEW_RESULT |
clsAuditReviewResult |
| SQL-086 | Update Pa Policy Data | Inline | PA_POLICY |
clsAuditSelectionOverride |
| SQL-087 | Update Pa Premium Audit Result Data | Inline | PA_PREMIUM_AUDIT_RESULT |
clsPremiumAuditResult |
Delete operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-088 | Delete Pa Audit Data | Inline | PA_AUDIT |
clsAudit |
| SQL-089 | Delete Pa Event Data | Inline | PA_EVENT |
clsAuditEvent |
| SQL-090 | Delete Pa Auditor Zip Code Data | Inline | PA_AUDITOR_ZIP_CODE |
clsAuditorZipCode |
| SQL-091 | Delete Pa Policy Period Data | Inline | PA_POLICY_PERIOD |
clsAuditPolicyPeriod |
| SQL-092 | Delete Pa Result Data | Inline | PA_RESULT |
clsAuditResult |
| SQL-093 | Delete Pa Review Result Data | Inline | PA_REVIEW_RESULT |
clsAuditReviewResult |
| SQL-094 | Delete Pa Selection Test Data | Inline | PA_SELECTION_TEST |
clsAuditSelectionTestResult |
| SQL-095 | Delete Pa Premium Audit Result Data | Inline | PA_PREMIUM_AUDIT_RESULT |
clsPremiumAuditResult |
Sequence operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-001 | Fetch Next Dual Value | Inline | DUAL |
clsAudit |
| SQL-002 | Fetch Next Dual Value | Inline | DUAL |
clsAuditEvent |
| SQL-003 | Fetch Next Pa Auditor Value | Inline | PA_AUDITOR |
clsAuditor |
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Operations and processes
- Business rules
- Database tables
- API reference
Sources¶
Business/SAIF.Business.Policy.Audit.Premium/clsAudit.vb:2634-2660Business/SAIF.Business.Policy.Audit.Premium/clsAudit.vb:2666-2685, 5004-5015Business/SAIF.Business.Policy.Audit.Premium/clsAudit.vb:2686-2703, 5016-5020Business/SAIF.Business.Policy.Audit.Premium/clsAudit.vb:2707-2745, 5021-5060Business/SAIF.Business.Policy.Audit.Premium/clsAudit.vb:2750-2780, 5061-5071Business/SAIF.Business.Policy.Audit.Premium/clsAudit.vb:3233-3260, 4983-5003Business/SAIF.Business.Policy.Audit.Premium/clsAudit.vb:4788Business/SAIF.Business.Policy.Audit.Premium/clsAudit.vb:4793Business/SAIF.Business.Policy.Audit.Premium/clsAudit.vb:4800Business/SAIF.Business.Policy.Audit.Premium/clsAudit.vb:4916Business/SAIF.Business.Policy.Audit.Premium/clsAudit.vb:4921Business/SAIF.Business.Policy.Audit.Premium/clsAuditAssignmentOverride.vb:548Business/SAIF.Business.Policy.Audit.Premium/clsAuditAssignmentOverride.vb:564Business/SAIF.Business.Policy.Audit.Premium/clsAuditAssignmentOverride.vb:576Business/SAIF.Business.Policy.Audit.Premium/clsAuditCollection.vb:1208Business/SAIF.Business.Policy.Audit.Premium/clsAuditCollection.vb:1447-1648Business/SAIF.Business.Policy.Audit.Premium/clsAuditCollection.vb:344-380, 1214-1240Business/SAIF.Business.Policy.Audit.Premium/clsAuditEvent.vb:495Business/SAIF.Business.Policy.Audit.Premium/clsAuditEvent.vb:501Business/SAIF.Business.Policy.Audit.Premium/clsAuditEvent.vb:509Business/SAIF.Business.Policy.Audit.Premium/clsAuditEvent.vb:529Business/SAIF.Business.Policy.Audit.Premium/clsAuditEvent.vb:544Business/SAIF.Business.Policy.Audit.Premium/clsAuditEventCollection.vb:380Business/SAIF.Business.Policy.Audit.Premium/clsAuditEventCollection.vb:402Business/SAIF.Business.Policy.Audit.Premium/clsAuditPolicyCollection.vb:585-620, 790-800Business/SAIF.Business.Policy.Audit.Premium/clsAuditPolicyCollection.vb:620-650, 801-815Business/SAIF.Business.Policy.Audit.Premium/clsAuditPolicyCollection.vb:652-680, 816-820Business/SAIF.Business.Policy.Audit.Premium/clsAuditPolicyPeriod.vb:1132Business/SAIF.Business.Policy.Audit.Premium/clsAuditPolicyPeriod.vb:1143Business/SAIF.Business.Policy.Audit.Premium/clsAuditPolicyPeriod.vb:1181Business/SAIF.Business.Policy.Audit.Premium/clsAuditPolicyPeriod.vb:560-585, 1202-1206Business/SAIF.Business.Policy.Audit.Premium/clsAuditPolicyPeriod.vb:595-620, 1207-1212Business/SAIF.Business.Policy.Audit.Premium/clsAuditPolicyPeriod.vb:634-660, 1213-1218Business/SAIF.Business.Policy.Audit.Premium/clsAuditPolicyPeriod.vb:662-690, 1219-1224Business/SAIF.Business.Policy.Audit.Premium/clsAuditPolicyPeriod.vb:700-730, 1225-1229Business/SAIF.Business.Policy.Audit.Premium/clsAuditPolicyPeriod.vb:740-775, 1230-1234Business/SAIF.Business.Policy.Audit.Premium/clsAuditPolicyPeriod.vb:776-805, 1235-1239Business/SAIF.Business.Policy.Audit.Premium/clsAuditPolicyPeriod.vb:806-835, 1240-1244Business/SAIF.Business.Policy.Audit.Premium/clsAuditPolicySchedulingDetail.vb:388Business/SAIF.Business.Policy.Audit.Premium/clsAuditPolicySchedulingDetail.vb:408Business/SAIF.Business.Policy.Audit.Premium/clsAuditPolicySchedulingDetail.vb:423Business/SAIF.Business.Policy.Audit.Premium/clsAuditResult.vb:599Business/SAIF.Business.Policy.Audit.Premium/clsAuditResult.vb:609Business/SAIF.Business.Policy.Audit.Premium/clsAuditResult.vb:631Business/SAIF.Business.Policy.Audit.Premium/clsAuditResult.vb:650Business/SAIF.Business.Policy.Audit.Premium/clsAuditResultCollection.vb:442Business/SAIF.Business.Policy.Audit.Premium/clsAuditResultType.vb:447Business/SAIF.Business.Policy.Audit.Premium/clsAuditResultTypeCollection.vb:379Business/SAIF.Business.Policy.Audit.Premium/clsAuditReviewReasonCode.vb:360Business/SAIF.Business.Policy.Audit.Premium/clsAuditReviewReasonCodeCollection.vb:324Business/SAIF.Business.Policy.Audit.Premium/clsAuditReviewResult.vb:647Business/SAIF.Business.Policy.Audit.Premium/clsAuditReviewResult.vb:655Business/SAIF.Business.Policy.Audit.Premium/clsAuditReviewResult.vb:682Business/SAIF.Business.Policy.Audit.Premium/clsAuditReviewResult.vb:704Business/SAIF.Business.Policy.Audit.Premium/clsAuditReviewResultCode.vb:328Business/SAIF.Business.Policy.Audit.Premium/clsAuditReviewResultCodeCollection.vb:335Business/SAIF.Business.Policy.Audit.Premium/clsAuditReviewResultCollection.vb:356Business/SAIF.Business.Policy.Audit.Premium/clsAuditSelectionCategoryCode.vb:299Business/SAIF.Business.Policy.Audit.Premium/clsAuditSelectionCategoryCodeCollection.vb:286Business/SAIF.Business.Policy.Audit.Premium/clsAuditSelectionCategoryCollection.vb:329Business/SAIF.Business.Policy.Audit.Premium/clsAuditSelectionNotification.vb:88-115, 486-494Business/SAIF.Business.Policy.Audit.Premium/clsAuditSelectionOverride.vb:517Business/SAIF.Business.Policy.Audit.Premium/clsAuditSelectionOverride.vb:537Business/SAIF.Business.Policy.Audit.Premium/clsAuditSelectionOverride.vb:551Business/SAIF.Business.Policy.Audit.Premium/clsAuditSelectionPolicyPeriod.vb:392Business/SAIF.Business.Policy.Audit.Premium/clsAuditSelectionPolicyPeriodCollection.vb:345Business/SAIF.Business.Policy.Audit.Premium/clsAuditSelectionTestResult.vb:372Business/SAIF.Business.Policy.Audit.Premium/clsAuditSelectionTestResult.vb:381Business/SAIF.Business.Policy.Audit.Premium/clsAuditSelectionTestResultCollection.vb:313Business/SAIF.Business.Policy.Audit.Premium/clsAuditSelectionTester.vb:1153Business/SAIF.Business.Policy.Audit.Premium/clsAuditSelectionTester.vb:205-245, 1176-1186Business/SAIF.Business.Policy.Audit.Premium/clsAuditSelectionTesterValue.vb:303Business/SAIF.Business.Policy.Audit.Premium/clsAuditSelectionTesterValueCollection.vb:239Business/SAIF.Business.Policy.Audit.Premium/clsAuditablePeriodCollection.vb:488Business/SAIF.Business.Policy.Audit.Premium/clsAuditor.vb:785Business/SAIF.Business.Policy.Audit.Premium/clsAuditor.vb:796Business/SAIF.Business.Policy.Audit.Premium/clsAuditor.vb:831Business/SAIF.Business.Policy.Audit.Premium/clsAuditor.vb:854Business/SAIF.Business.Policy.Audit.Premium/clsAuditorCollection.vb:500Business/SAIF.Business.Policy.Audit.Premium/clsAuditorZipCode.vb:468Business/SAIF.Business.Policy.Audit.Premium/clsAuditorZipCode.vb:477Business/SAIF.Business.Policy.Audit.Premium/clsAuditorZipCode.vb:497Business/SAIF.Business.Policy.Audit.Premium/clsAuditorZipCodeCollection.vb:477Business/SAIF.Business.Policy.Audit.Premium/clsPAReasonCode.vb:277Business/SAIF.Business.Policy.Audit.Premium/clsPAReasonCodeCollection.vb:259Business/SAIF.Business.Policy.Audit.Premium/clsPremiumAuditResult.vb:572Business/SAIF.Business.Policy.Audit.Premium/clsPremiumAuditResult.vb:581Business/SAIF.Business.Policy.Audit.Premium/clsPremiumAuditResult.vb:604Business/SAIF.Business.Policy.Audit.Premium/clsPremiumAuditResult.vb:620Business/SAIF.Business.Policy.Audit.Premium/clsPremiumAuditTypeCode.vb:385Business/SAIF.Business.Policy.Audit.Premium/clsPremiumAuditTypeCodeCollection.vb:310Business/SAIF.Business.Policy.Audit.Premium/clsStatusCollection.vb:249Business/SAIF.Business.Policy.Audit.Premium/clsWorkbookReviewTester.vb:616Business/SAIF.Business.Policy.Audit.Premium/clsZipCode.vb:463Business/SAIF.Business.Policy.Audit.Premium/clsZipCodeCollection.vb:466