---
title: SAIF.Business.External.Users SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: <owner>
last_reviewed: 2026-07-24
library: SAIF.Business.External.Users
reference_type: package
---

# SAIF.Business.External.Users SQL catalog

This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type.

## Sequence operations

| SQL ID | Description | Sequence | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-saif-business-external-users.md) | Max PA auditor ID + 1 | N/A (MAX + 1 pattern) | PA_AUDITOR | `clsAuditor` |

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-002](SQL-002-saif-business-external-users.md) | Insert audit assignment override | Inline | PA_ASSIGN_OVERRIDE | `clsAuditAssignmentOverride` |
| [SQL-003](SQL-003-saif-business-external-users.md) | Insert auditor | Inline | PA_AUDITOR | `clsAuditor` |
| [SQL-004](SQL-004-saif-business-external-users.md) | Insert auditor zip code | Inline | PA_AUDITOR_ZIP_CODE | `clsAuditorZipCode` |
| [SQL-005](SQL-005-saif-business-external-users.md) | Insert external user | Inline | EXT_USER | `clsUser` |
| [SQL-006](SQL-006-saif-business-external-users.md) | Insert user access group | Inline | EXT_USER_ACCESS_GROUP | `clsUserAccessGroup` |
| [SQL-007](SQL-007-saif-business-external-users.md) | Insert deny-self-registration row | Inline | EXT_USER_DENY_SELF_REG | `clsUserDenySelfRegistration` |
| [SQL-008](SQL-008-saif-business-external-users.md) | Insert security question | Inline | EXT_USER_SECURITY_QUESTION | `clsUserSecurityQuestion` |
| [SQL-009](SQL-009-saif-business-external-users.md) | Insert user type | Inline | EXT_USER_TYPE | `clsUserType` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-010](SQL-010-saif-business-external-users.md) | Retrieve audit assignment override | Inline | PA_ASSIGN_OVERRIDE | `clsAuditAssignmentOverride` |
| [SQL-011](SQL-011-saif-business-external-users.md) | Retrieve auditor by ID or user | Inline | PA_AUDITOR | `clsAuditor` |
| [SQL-012](SQL-012-saif-business-external-users.md) | Retrieve auditors by vendor/flags | Inline | PA_AUDITOR | `clsAuditorCollection` |
| [SQL-013](SQL-013-saif-business-external-users.md) | Retrieve auditor zip codes | Inline | PA_AUDITOR_ZIP_CODE | `clsAuditorZipCodeCollection` |
| [SQL-014](SQL-014-saif-business-external-users.md) | Validate provider registration (Oracle function) | Inline + Oracle function | DUAL | `clsNewUserArgs` |
| [SQL-015](SQL-015-saif-business-external-users.md) | Retrieve user by key / base user projection | Inline | EXT_USER | `clsUser` |
| [SQL-016](SQL-016-saif-business-external-users.md) | Detect duplicate active email | Inline | EXT_USER, EMAIL_ADDRESS, EXT_USER_TYPE | `clsUser` |
| [SQL-017](SQL-017-saif-business-external-users.md) | Retrieve forgotten user by customer and email | StringBuilder / Inline | EXT_USER, EXT_USER_TYPE, EMAIL_ADDRESS | `clsUser` |
| [SQL-018](SQL-018-saif-business-external-users.md) | Retrieve provider identity by user type | Inline | EXT_USER_TYPE, EXT_USER, EMAIL_ADDRESS, PERSON | `clsUser` |
| [SQL-019](SQL-019-saif-business-external-users.md) | Retrieve users by type and customer group | Inline | EXT_USER, EXT_USER_TYPE | `clsUser` |
| [SQL-020](SQL-020-saif-business-external-users.md) | Search users with optional filters | Inline + conditional assembly | EXT_USER, PERSON, EXT_USER_TYPE, EXT_USER_ACCESS_GROUP, COMPANY, PERSON_EMAIL, EMAIL_ADDRESS | `clsUser` |
| [SQL-021](SQL-021-saif-business-external-users.md) | Retrieve AD groups for an access group | Inline | EXT_USER_AD_GROUP, EXT_USER_ACCESS_GROUP_AD | `clsUserAccessGroup` |
| [SQL-022](SQL-022-saif-business-external-users.md) | Retrieve user access group row | Inline | EXT_USER_ACCESS_GROUP, EXT_USER_ACCESS_GROUP_CODE, EXT_USER_TYPE, EXT_USER_TYPE_ACCESS_GROUP, EXT_USER_ACCESS_GROUP_GCODE | `clsUserAccessGroup` |
| [SQL-023](SQL-023-saif-business-external-users.md) | Retrieve all access-group definitions | Inline | EXT_USER_TYPE_ACCESS_GROUP, EXT_USER_ACCESS_GROUP_CODE, EXT_USER_ACCESS_GROUP_GCODE | `clsUserAccessGroup` |
| [SQL-024](SQL-024-saif-business-external-users.md) | Retrieve all possible access groups for a user type | Inline | EXT_USER_TYPE_ACCESS_GROUP, EXT_USER_ACCESS_GROUP_CODE, EXT_USER_ACCESS_GROUP, EXT_USER_ACCESS_GROUP_GCODE | `clsUserAccessGroup` |
| [SQL-025](SQL-025-saif-business-external-users.md) | Find newly-added access groups from AD | Inline | EXT_USER_AD_GROUP, EXT_USER_ACCESS_GROUP_AD, EXT_USER_ACCESS_GROUP, EXT_USER_ACCESS_GROUP_GCODE | `clsUserAccessGroup` |
| [SQL-026](SQL-026-saif-business-external-users.md) | Find removed access groups from AD | Inline + dynamic NOT IN | EXT_USER, EXT_USER_TYPE, EXT_USER_ACCESS_GROUP, EXT_USER_ACCESS_GROUP_AD, EXT_USER_AD_GROUP | `clsUserAccessGroup` |
| [SQL-027](SQL-027-saif-business-external-users.md) | Retrieve deny-self-registration row | Inline | EXT_USER_DENY_SELF_REG | `clsUserDenySelfRegistration` |
| [SQL-028](SQL-028-saif-business-external-users.md) | Retrieve security question row(s) | Inline | EXT_USER_SECURITY_QUESTION, EXT_USER_SEC_QUESTION_CODE, EXT_USER_SEC_QUESTION_GCODE | `clsUserSecurityQuestion` |
| [SQL-029](SQL-029-saif-business-external-users.md) | Retrieve available security questions | Inline | EXT_USER_SEC_QUESTION_CODE, EXT_USER_SEC_QUESTION_GCODE | `clsUserSecurityQuestion` |
| [SQL-030](SQL-030-saif-business-external-users.md) | Retrieve user type row | Inline | EXT_USER_TYPE, EXT_USER_TYPE_CODE, EXT_USER_TYPE_CODE_PROMPT | `clsUserType` |
| [SQL-031](SQL-031-saif-business-external-users.md) | Retrieve all user type definitions | Inline | EXT_USER_TYPE_CODE, EXT_USER_TYPE_CODE_PROMPT | `clsUserType` |
| [SQL-032](SQL-032-saif-business-external-users.md) | Find current admin user type for provider EFT | Inline | EXT_USER_TYPE | `clsUserType` |
| [SQL-033](SQL-033-saif-business-external-users.md) | Quoted policy expiry check | Stored procedure | Oracle package (body not in repo) | `clsUserType` |
| [SQL-034](SQL-034-saif-business-external-users.md) | Billing plan type retrieval | Stored procedure | Oracle package (body not in repo) | `clsUserType` |
| [SQL-035](SQL-035-saif-business-external-users.md) | ePay eligibility check | Stored procedure | Oracle package (body not in repo) | `clsUserType` |
| [SQL-036](SQL-036-saif-business-external-users.md) | Check whether user owns provider EOB rows | Inline | EXT_USER, EXT_USER_TYPE, PROVIDER_EOB_INTERFACE | `clsUserType` |
| [SQL-037](SQL-037-saif-business-external-users.md) | Retrieve zip code mapping | Inline | PA_ZIP_CODE, COUNTY, OFFICE_CODE | `clsZipCode` |
| [SQL-038](SQL-038-saif-business-external-users.md) | Load user-type code map | Inline | EXT_USER_TYPE_CODE | `mdlCodeMaps` |
| [SQL-039](SQL-039-saif-business-external-users.md) | Load user-status code map | Inline | EXT_USER_STATUS_CODE | `mdlCodeMaps` |
| [SQL-040](SQL-040-saif-business-external-users.md) | Load RTW codes | Inline | RTW_LOAD_CODE | `mdlGroupAssociation` |
| [SQL-041](SQL-041-saif-business-external-users.md) | Load auditor by AD user and vendor; fallback by vendor | Inline | PA_AUDITOR | `mdlAuditor` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-042](SQL-042-saif-business-external-users.md) | Inline update used by clsAuditAssignmentOverride | Inline | PA_ASSIGN_OVERRIDE | `clsAuditAssignmentOverride` |
| [SQL-043](SQL-043-saif-business-external-users.md) | Inline update used by clsAuditor | Inline | PA_AUDITOR | `clsAuditor` |
| [SQL-044](SQL-044-saif-business-external-users.md) | Inline update used by clsAuditorZipCode | Inline | PA_AUDITOR_ZIP_CODE | `clsAuditorZipCode` |
| [SQL-045](SQL-045-saif-business-external-users.md) | Inline update used by clsUser | Inline | EXT_USER | `clsUser` |
| [SQL-046](SQL-046-saif-business-external-users.md) | Inline update used by clsUser | Inline | EXT_USER | `clsUser` |
| [SQL-047](SQL-047-saif-business-external-users.md) | Inline update used by clsUserAccessGroup | Inline | EXT_USER_ACCESS_GROUP | `clsUserAccessGroup` |
| [SQL-048](SQL-048-saif-business-external-users.md) | Inline update used by clsUserDenySelfRegistration | Inline | EXT_USER_DENY_SELF_REG | `clsUserDenySelfRegistration` |
| [SQL-049](SQL-049-saif-business-external-users.md) | Inline update used by clsUserSecurityQuestion | Inline | EXT_USER_SECURITY_QUESTION | `clsUserSecurityQuestion` |
| [SQL-050](SQL-050-saif-business-external-users.md) | Inline update used by clsUserType | Inline | EXT_USER_TYPE | `clsUserType` |
| [SQL-051](SQL-051-saif-business-external-users.md) | Inline update used by clsUserType | Inline | PAYMENT_AUTHORIZATION | `clsUserType` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-052](SQL-052-saif-business-external-users.md) | Inline delete used by clsAuditorZipCode | Inline | PA_AUDITOR_ZIP_CODE | `clsAuditorZipCode` |
| [SQL-053](SQL-053-saif-business-external-users.md) | Inline delete used by clsUserAccessGroup | Inline | EXT_USER_ACCESS_GROUP | `clsUserAccessGroup` |
| [SQL-054](SQL-054-saif-business-external-users.md) | Inline delete used by clsUserDenySelfRegistration | Inline | EXT_USER_DENY_SELF_REG | `clsUserDenySelfRegistration` |
| [SQL-055](SQL-055-saif-business-external-users.md) | Inline delete used by clsUserSecurityQuestion | Inline | EXT_USER_SECURITY_QUESTION | `clsUserSecurityQuestion` |
| [SQL-056](SQL-056-saif-business-external-users.md) | Inline delete used by clsUserType | Inline | EXT_USER_TYPE | `clsUserType` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [API reference](../api/index.md)
- [Configuration](../configuration.md)

## Sources
- `Business\SAIF.Business.External.Users\clsAuditAssignmentOverride.vb`
- `Business\SAIF.Business.External.Users\clsAuditor.vb`
- `Business\SAIF.Business.External.Users\clsAuditorCollection.vb`
- `Business\SAIF.Business.External.Users\clsAuditorZipCode.vb`
- `Business\SAIF.Business.External.Users\clsAuditorZipCodeCollection.vb`
- `Business\SAIF.Business.External.Users\clsNewUserArgs.vb`
- `Business\SAIF.Business.External.Users\clsUser.vb`
- `Business\SAIF.Business.External.Users\clsUserAccessGroup.vb`
- `Business\SAIF.Business.External.Users\clsUserDenySelfRegistration.vb`
- `Business\SAIF.Business.External.Users\clsUserSecurityQuestion.vb`
- `Business\SAIF.Business.External.Users\clsUserType.vb`
- `Business\SAIF.Business.External.Users\clsZipCode.vb`
- `Business\SAIF.Business.External.Users\mdlAuditor.vb`
- `Business\SAIF.Business.External.Users\mdlCodeMaps.vb`
- `Business\SAIF.Business.External.Users\mdlGroupAssociation.vb`