SQL-VP-038 Retrieve the fee auditor's accessible policy list¶
Used by clsPolicySecurity.GetPolicyListForFeeAuditor(), the Auditor-type "book of business" list
builder behind the PolicyList property.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-VP-038 |
| Operation type | Read |
| Execution method | Inline SQL |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsPolicySecurity |
| Criteria property | GetPolicyListForFeeAuditor() (ad hoc method) |
| Lifecycle method | ad hoc method |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:VendorNum |
Input | ID | N/A | Auditor's vendor number to look up accessible policies for. |
Tables¶
| Table | Access | Columns used |
|---|---|---|
| PA_AUDIT | SELECT / JOIN | AUDITOR_SEQ_NUM, POLICY_NUM |
| PA_AUDITOR | JOIN | AUDITOR_SEQ_NUM, VENDOR_NUM |
| POLICY | JOIN | POLICY_NUM, POLICY_NAME |
Sample SQL¶
SELECT
POLICY.POLICY_NUM,
POLICY.POLICY_NAME
FROM
PA_AUDIT
INNER JOIN PA_AUDITOR
ON PA_AUDIT.AUDITOR_SEQ_NUM = PA_AUDITOR.AUDITOR_SEQ_NUM
INNER JOIN POLICY
ON PA_AUDIT.POLICY_NUM = POLICY.POLICY_NUM
WHERE
PA_AUDITOR.VENDOR_NUM = :VendorNum
Exact column/join reconstruction inferred from method naming and typical schema conventions; not
verified byte-for-byte against the live GetAuditorPolicyListSQL() method body.
Note: Statements marked with
*were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with**could not be confirmed; treat as unknown until verified.
Sources¶
SAIF.Business.View.Policy\clsPolicySecurity.vb