SAIF.Business.External.Users database tables

This page catalogs database tables accessed by this library.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
COMPANY	Oracle	[unqualified]**	R	Company identity lookup used in user-type joins	clsUser
COUNTY	Oracle	[unqualified]**	R	County name and office-code mapping for zip code routing	clsZipCode
DUAL	Oracle	[unqualified]**	R	Oracle pseudo-table used for Oracle function calls	clsNewUserArgs
EMAIL_ADDRESS	Oracle	[unqualified]**	R	Email address lookup joined to user records	clsUser
EXT_USER	Oracle	[unqualified]**	C/R/U	Core external portal user record	clsUser, clsUserType, clsUserAccessGroup
EXT_USER_ACCESS_GROUP	Oracle	[unqualified]**	C/R/U/D	Access-group membership rows for external users	clsUserAccessGroup, clsUser
EXT_USER_ACCESS_GROUP_AD	Oracle	[unqualified]**	R	Mapping between access groups and AD groups	clsUserAccessGroup
EXT_USER_ACCESS_GROUP_CODE	Oracle	[unqualified]**	R	Code table for access-group descriptions	clsUserAccessGroup
EXT_USER_ACCESS_GROUP_GCODE	Oracle	[unqualified]**	R	Globalized descriptions for access-group codes	clsUserAccessGroup
EXT_USER_AD_GROUP	Oracle	[unqualified]**	R	Active Directory group name lookup	clsUserAccessGroup
EXT_USER_DENY_SELF_REG	Oracle	[unqualified]**	C/R/U/D	Block-list entries that prevent self-registration	clsUserDenySelfRegistration
EXT_USER_SEC_QUESTION_CODE	Oracle	[unqualified]**	R	Security question code definitions	clsUserSecurityQuestion
EXT_USER_SEC_QUESTION_GCODE	Oracle	[unqualified]**	R	Globalized text for security question codes	clsUserSecurityQuestion
EXT_USER_SECURITY_QUESTION	Oracle	[unqualified]**	C/R/U/D	User-specific security question/answer records	clsUserSecurityQuestion
EXT_USER_STATUS_CODE	Oracle	[unqualified]**	R	Status code lookup for external users	mdlCodeMaps
EXT_USER_TYPE	Oracle	[unqualified]**	C/R/U/D	User type/role classification rows	clsUserType, clsUser, clsUserAccessGroup
EXT_USER_TYPE_ACCESS_GROUP	Oracle	[unqualified]**	R	Mapping of access groups allowed for each user type	clsUserAccessGroup
EXT_USER_TYPE_CODE	Oracle	[unqualified]**	R	Code table for user type definitions	clsUserType, mdlCodeMaps
EXT_USER_TYPE_CODE_PROMPT	Oracle	[unqualified]**	R	Prompt label definitions for user type codes	clsUserType
OFFICE_CODE	Oracle	[unqualified]**	R	Office code descriptions and region mapping	clsZipCode
PA_ASSIGN_OVERRIDE	Oracle	[unqualified]**	C/R/U	Policy-level audit assignment override records	clsAuditAssignmentOverride
PA_AUDITOR	Oracle	[unqualified]**	C/R/U	Premium auditor entity records	clsAuditor, clsAuditorCollection, mdlAuditor, clsUser
PA_AUDITOR_ZIP_CODE	Oracle	[unqualified]**	C/R/U/D	Zip-code range assignments for auditors	clsAuditorZipCode, clsAuditorZipCodeCollection
PA_ZIP_CODE	Oracle	[unqualified]**	R	Zip-code routing data (office, county, region)	clsZipCode
PAYMENT_AUTHORIZATION	Oracle	payment_owner	U	Payment authorization records updated with EFT contact email	clsUserType
PERSON	Oracle	[unqualified]**	R	Person identity record linked to external users	clsUser
PERSON_EMAIL	Oracle	[unqualified]**	R	Person-to-email address association	clsUser
PROVIDER_EOB_INTERFACE	Oracle	[unqualified]**	R	Provider EOB ownership check	clsUserType
RTW_LOAD_CODE	Oracle	[unqualified]**	R	Return-to-work load codes for group association	mdlGroupAssociation

---

COMPANY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Provides company name for external-user search result enrichment.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	COMPANY_SEQ_NUM, COMPANY_NAME
Sequence	N/A
Related tables	EXT_USER_TYPE
Business objects	clsUser

SQL referencing this table

• SQL-020: Search users with optional filters

---

COUNTY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Provides county name and office code for zip-code routing lookups.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	COUNTY_CODE, COUNTY_NAME, OFFICE_CODE
Sequence	N/A
Related tables	PA_ZIP_CODE, OFFICE_CODE
Business objects	clsZipCode

Operations referencing this table

• Zip code routing lookup

SQL referencing this table

• SQL-037: Retrieve zip code mapping

---

DUAL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Oracle pseudo-table used to execute function calls that return scalar values.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	N/A (pseudo-table)
Sequence	N/A
Related tables	N/A
Business objects	clsNewUserArgs

Operations referencing this table

• Provider registration validation

SQL referencing this table

• SQL-014: Validate provider registration

---

EMAIL_ADDRESS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores email addresses linked to external users via EMAIL_ADDRESS_SEQ_NUM.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	EMAIL_ADDRESS_SEQ_NUM, EMAIL_ADDRESS
Sequence	N/A
Related tables	EXT_USER, PERSON_EMAIL
Business objects	clsUser

SQL referencing this table

• SQL-016: Detect duplicate active email
• SQL-017: Retrieve forgotten user by customer and email
• SQL-018: Retrieve provider identity by user type
• SQL-020: Search users with optional filters

---

EXT_USER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Core record for external (non-employee) portal users, holding identity, status, flags, and credential references.
Access pattern	Direct SQL
CRUD operations	Create, Read, Update
Key columns used	EXT_USER_SEQ_NUM, PERSON_SEQ_NUM, ACTIVE_DIRECTORY_ID, STATUS_CODE, AUTHORIZED_USER_FLAG, EMAIL_ADDRESS_SEQ_NUM, TEST_USER_FLAG, HAS_CLAIM_FLAG, UPDATE_NUM
Sequence	EXT_USER_SEQ*
Related tables	EXT_USER_TYPE, EMAIL_ADDRESS, PERSON
Business objects	clsUser, clsUserType, clsUserAccessGroup

Operations referencing this table

• User self-registration / account management
• User search

Business rules referencing this table

• BR-EU-01: Authorized-user flag persistence
• BR-EU-04: Unique active email per non-test user
• BR-EU-05: Optimistic concurrency via UPDATE_NUM

SQL referencing this table

• SQL-005: Insert external user
• SQL-015: Retrieve user by key / base user projection
• SQL-016: Detect duplicate active email
• SQL-017: Retrieve forgotten user by customer and email
• SQL-019: Retrieve users by type and customer group
• SQL-020: Search users with optional filters
• SQL-045: Update external user
• SQL-046: Update last logon date

---

EXT_USER_ACCESS_GROUP

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Persists access-group membership rows for a user type, including expiration and default-access flag.
Access pattern	Direct SQL
CRUD operations	Create, Read, Update, Delete
Key columns used	EXT_USER_ACCESS_GROUP_SEQ_NUM, EXT_USER_TYPE_SEQ_NUM, EXT_USER_ACCESS_GROUP_CODE, DEFAULT_ACCESS_FLAG, EXPIRATION_DATE, UPDATE_NUM
Sequence	EXT_USER_ACCESS_GROUP_SEQ*
Related tables	EXT_USER_TYPE, EXT_USER_ACCESS_GROUP_CODE, EXT_USER_TYPE_ACCESS_GROUP
Business objects	clsUserAccessGroup, clsUser

Operations referencing this table

• User access group management

Business rules referencing this table

• BR-EU-05: Optimistic concurrency via UPDATE_NUM

SQL referencing this table

• SQL-006: Insert user access group
• SQL-022: Retrieve user access group row
• SQL-024: Retrieve all possible access groups for a user type
• SQL-047: Update user access group
• SQL-053: Delete user access group

---

EXT_USER_ACCESS_GROUP_AD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Maps access-group codes to Active Directory group sequence numbers.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	EXT_USER_AD_GROUP_SEQ_NUM, EXT_USER_ACCESS_GROUP_CODE, EXT_USER_TYPE_CODE
Sequence	N/A
Related tables	EXT_USER_AD_GROUP, EXT_USER_ACCESS_GROUP
Business objects	clsUserAccessGroup

SQL referencing this table

• SQL-021: Retrieve AD groups for an access group
• SQL-025: Find newly-added access groups from AD
• SQL-026: Find removed access groups from AD

---

EXT_USER_ACCESS_GROUP_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Code table providing descriptions for access-group codes.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	CODE, CODE_DESCR
Sequence	N/A
Related tables	EXT_USER_ACCESS_GROUP, EXT_USER_TYPE_ACCESS_GROUP, EXT_USER_ACCESS_GROUP_GCODE
Business objects	clsUserAccessGroup

SQL referencing this table

• SQL-022: Retrieve user access group row
• SQL-023: Retrieve all access-group definitions
• SQL-024: Retrieve all possible access groups for a user type

---

EXT_USER_ACCESS_GROUP_GCODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Provides globalized (culture-specific) descriptions for access-group codes.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	CODE, CULTURE_CODE, CODE_DESCR
Sequence	N/A
Related tables	EXT_USER_ACCESS_GROUP_CODE
Business objects	clsUserAccessGroup

SQL referencing this table

• SQL-022: Retrieve user access group row
• SQL-023: Retrieve all access-group definitions
• SQL-025: Find newly-added access groups from AD

---

EXT_USER_AD_GROUP

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores Active Directory group names used for access-group reconciliation.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	EXT_USER_AD_GROUP_SEQ_NUM, AD_GROUP_NAME, EXT_USER_TYPE_CODE
Sequence	N/A
Related tables	EXT_USER_ACCESS_GROUP_AD
Business objects	clsUserAccessGroup

Operations referencing this table

• User access group management

SQL referencing this table

• SQL-021: Retrieve AD groups for an access group
• SQL-025: Find newly-added access groups from AD
• SQL-026: Find removed access groups from AD

---

EXT_USER_DENY_SELF_REG

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Block-list entries preventing self-registration for specific user-type/customer-group combinations.
Access pattern	Direct SQL
CRUD operations	Create, Read, Update, Delete
Key columns used	CUSTOMER_GROUP_ID, EXT_USER_TYPE_CODE, CUSTOMER_REQUESTED_FLAG, REASON_TXT, UPDATE_NUM
Sequence	N/A
Related tables	N/A
Business objects	clsUserDenySelfRegistration

Operations referencing this table

• Deny self-registration check

Business rules referencing this table

• BR-EU-02: Deny-self-registration block-list
• BR-EU-05: Optimistic concurrency via UPDATE_NUM

SQL referencing this table

• SQL-007: Insert deny-self-registration row
• SQL-027: Retrieve deny-self-registration row
• SQL-048: Update deny-self-registration row
• SQL-054: Delete deny-self-registration row

---

EXT_USER_SEC_QUESTION_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Defines available security question codes and their text, including an optional expiration date.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	CODE, QUESTION_TEXT, EXPIRATION_DATE
Sequence	N/A
Related tables	EXT_USER_SECURITY_QUESTION, EXT_USER_SEC_QUESTION_GCODE
Business objects	clsUserSecurityQuestion

SQL referencing this table

• SQL-028: Retrieve security question row(s)
• SQL-029: Retrieve available security questions

---

EXT_USER_SEC_QUESTION_GCODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Provides globalized (culture-specific) question text for security question codes.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	CODE, CULTURE_CODE, QUESTION_TEXT
Sequence	N/A
Related tables	EXT_USER_SEC_QUESTION_CODE
Business objects	clsUserSecurityQuestion

SQL referencing this table

• SQL-028: Retrieve security question row(s)
• SQL-029: Retrieve available security questions

---

EXT_USER_SECURITY_QUESTION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores each user's chosen security question and answer for password recovery.
Access pattern	Direct SQL
CRUD operations	Create, Read, Update, Delete
Key columns used	EXT_USER_SEC_QUESTION_SEQ_NUM, EXT_USER_SEQ_NUM, EXT_USER_SEC_QUESTION_CODE, ANSWER_TEXT, UPDATE_NUM
Sequence	EXT_USER_SEC_QUESTION_SEQ*
Related tables	EXT_USER, EXT_USER_SEC_QUESTION_CODE
Business objects	clsUserSecurityQuestion

Operations referencing this table

• Security question management

Business rules referencing this table

• BR-EU-05: Optimistic concurrency via UPDATE_NUM

SQL referencing this table

• SQL-008: Insert security question
• SQL-028: Retrieve security question row(s)
• SQL-049: Update security question
• SQL-055: Delete security question

---

EXT_USER_STATUS_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Code table for external user status values (e.g., ACTIV, PENDA, DIS).
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	CODE, CODE_DESCR
Sequence	N/A
Related tables	N/A
Business objects	mdlCodeMaps

SQL referencing this table

• SQL-039: Load user-status code map

---

EXT_USER_TYPE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	User type/role classification row linking a user to a source-system context (customer ID, credentials, flags).
Access pattern	Direct SQL
CRUD operations	Create, Read, Update, Delete
Key columns used	EXT_USER_TYPE_SEQ_NUM, EXT_USER_SEQ_NUM, EXT_USER_TYPE_CODE, COMPANY_SEQ_NUM, CUSTOMER_ID, CUSTOMER_GROUP_ID, PRIMARY_TYPE_FLAG, ADMIN_USER_FLAG, STEWARD_FLAG, UPDATE_NUM
Sequence	EXT_USER_TYPE_SEQ*
Related tables	EXT_USER, EXT_USER_TYPE_CODE, EXT_USER_ACCESS_GROUP
Business objects	clsUserType, clsUser, clsUserAccessGroup

Operations referencing this table

• User type management

Business rules referencing this table

• BR-EU-04: Unique active email per non-test user
• BR-EU-05: Optimistic concurrency via UPDATE_NUM

SQL referencing this table

• SQL-009: Insert user type
• SQL-030: Retrieve user type row
• SQL-031: Retrieve all user type definitions
• SQL-050: Update user type
• SQL-056: Delete user type

---

EXT_USER_TYPE_ACCESS_GROUP

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Defines which access groups are available for each user type, with admin, steward, and self-registration flags.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	EXT_USER_TYPE_CODE, EXT_USER_ACCESS_GROUP_CODE, ADMIN_ACCESS_FLAG, STEWARD_ACCESS_FLAG, SELF_REG_ACCESS_FLAG, SYSTEM_CONTROLLED_FLAG, DEFAULT_STATUS_FLAG, SORT_ORDER_NUM
Sequence	N/A
Related tables	EXT_USER_TYPE, EXT_USER_ACCESS_GROUP_CODE
Business objects	clsUserAccessGroup

SQL referencing this table

• SQL-022: Retrieve user access group row
• SQL-023: Retrieve all access-group definitions
• SQL-024: Retrieve all possible access groups for a user type

---

EXT_USER_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Master code table for user type definitions including source-system ID descriptions.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	CODE, CUSTOMER_ID_DESCR, CUSTOMER_GROUP_ID_DESCR
Sequence	N/A
Related tables	EXT_USER_TYPE, EXT_USER_TYPE_CODE_PROMPT
Business objects	clsUserType, mdlCodeMaps

SQL referencing this table

• SQL-030: Retrieve user type row
• SQL-031: Retrieve all user type definitions
• SQL-038: Load user-type code map

---

EXT_USER_TYPE_CODE_PROMPT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Provides UI prompt label descriptions for specific user type code fields (e.g., customer ID prompt).
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	EXT_USER_TYPE_CODE, PROMPT_CODE, PROMPT_DESCR
Sequence	N/A
Related tables	EXT_USER_TYPE_CODE
Business objects	clsUserType

SQL referencing this table

• SQL-030: Retrieve user type row
• SQL-031: Retrieve all user type definitions

---

OFFICE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Office code descriptions and policy region codes used in zip code routing.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	CODE, CODE_DESCR, POLICY_REGION_CODE
Sequence	N/A
Related tables	COUNTY, PA_ZIP_CODE
Business objects	clsZipCode

Operations referencing this table

• Zip code routing lookup

SQL referencing this table

• SQL-037: Retrieve zip code mapping

---

PA_ASSIGN_OVERRIDE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Policy-level overrides specifying the default auditor and a do-not-assign auditor for audit assignment.
Access pattern	Direct SQL
CRUD operations	Create, Read, Update
Key columns used	POLICY_NUM, DEFAULT_PA_AUDITOR_ID, DONOT_ASSIGN_PA_AUDITOR_ID, CREATE_USER, CREATE_DATE, UPDATE_USER, UPDATE_DATE
Sequence	N/A
Related tables	PA_AUDITOR
Business objects	clsAuditAssignmentOverride

Operations referencing this table

• Auditor assignment / override

Business rules referencing this table

• BR-EU-03: Audit-assignment auditor distinctness

SQL referencing this table

• SQL-002: Insert audit assignment override
• SQL-010: Retrieve audit assignment override
• SQL-042: Update audit assignment override

---

PA_AUDITOR

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Premium auditor entity records used for claim audit assignment, including scheduling and filter flags.
Access pattern	Direct SQL
CRUD operations	Create, Read, Update
Key columns used	PA_AUDITOR_ID, ASSIGN_FLAG, AUDITOR_NAME, AUDITOR_SHORT_NAME, USER_ID, VENDOR_NUM, FILTER_LIST_FLAG, SCHEDULE_FLAG, REVIEWER_FLAG, ACTIVE_REVIEWER_FLAG, MONTHLY_MAXIMUM_COUNT
Sequence	N/A (uses MAX(PA_AUDITOR_ID) + 1 via SQL-001)
Related tables	PA_AUDITOR_ZIP_CODE, PA_ASSIGN_OVERRIDE
Business objects	clsAuditor, clsAuditorCollection, mdlAuditor, clsUser

Operations referencing this table

• Auditor assignment / override
• Premium auditor lookup

SQL referencing this table

• SQL-001: Max PA auditor ID + 1
• SQL-003: Insert auditor
• SQL-011: Retrieve auditor by ID or user
• SQL-012: Retrieve auditors by vendor/flags
• SQL-041: Load auditor by AD user and vendor; fallback by vendor
• SQL-043: Update auditor

---

PA_AUDITOR_ZIP_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Associates auditors with specific zip codes defining their geographic assignment range.
Access pattern	Direct SQL
CRUD operations	Create, Read, Update, Delete
Key columns used	PA_AUDITOR_ID, ZIP_CODE
Sequence	N/A
Related tables	PA_AUDITOR
Business objects	clsAuditorZipCode, clsAuditorZipCodeCollection

Operations referencing this table

• Auditor assignment / override

SQL referencing this table

• SQL-004: Insert auditor zip code
• SQL-013: Retrieve auditor zip codes
• SQL-044: Update auditor zip code
• SQL-052: Delete auditor zip code

---

PA_ZIP_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Maps zip codes to audit office codes and county codes for audit routing.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	ZIP_CODE, AUDIT_OFFICE_CODE, STATE_CODE, COUNTY_CODE
Sequence	N/A
Related tables	COUNTY, OFFICE_CODE
Business objects	clsZipCode

Operations referencing this table

• Zip code routing lookup

SQL referencing this table

• SQL-037: Retrieve zip code mapping

---

PAYMENT_AUTHORIZATION

Field	Value
Database	Oracle
Schema/Link	payment_owner
Purpose	Payment authorization records; this library updates the CUSTOMER_CONTACT_EMAIL_ADDR column for provider EFT authorization.
Access pattern	Direct SQL
CRUD operations	Update
Key columns used	CUSTOMER_CONTACT_EMAIL_ADDR, CUSTOMER_ID, UPDATE_DATE, UPDATE_USER
Sequence	N/A
Related tables	N/A
Business objects	clsUserType

Operations referencing this table

• User type management

SQL referencing this table

• SQL-051: Update EFT authorization email

---

PERSON

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Person identity record linked to external users via PERSON_SEQ_NUM; provides the person name for user retrieval.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	PERSON_SEQ_NUM, NAME
Sequence	N/A
Related tables	EXT_USER, PERSON_EMAIL
Business objects	clsUser

SQL referencing this table

• SQL-018: Retrieve provider identity by user type
• SQL-020: Search users with optional filters

---

PERSON_EMAIL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Associates person records with email address records; used in user search joins.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	PERSON_SEQ_NUM, EMAIL_ADDRESS_SEQ_NUM
Sequence	N/A
Related tables	PERSON, EMAIL_ADDRESS
Business objects	clsUser

SQL referencing this table

• SQL-020: Search users with optional filters

---

PROVIDER_EOB_INTERFACE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Provider EOB (Explanation of Benefits) interface records; used to check whether a user owns any EOB rows.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	EXT_USER_TYPE_SEQ_NUM
Sequence	N/A
Related tables	EXT_USER_TYPE
Business objects	clsUserType

SQL referencing this table

• SQL-036: Check whether user owns provider EOB rows

---

RTW_LOAD_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Return-to-work load code values used by the group-association module.
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	CODE
Sequence	N/A
Related tables	N/A
Business objects	mdlGroupAssociation

SQL referencing this table

• SQL-040: Load RTW codes

---

Table relationship diagram

The following diagram shows key relationships between core tables used by this library.

erDiagram
    EXT_USER ||--o{ EXT_USER_TYPE : "EXT_USER_SEQ_NUM"
    EXT_USER ||--o{ EXT_USER_SECURITY_QUESTION : "EXT_USER_SEQ_NUM"
    EXT_USER_TYPE ||--o{ EXT_USER_ACCESS_GROUP : "EXT_USER_TYPE_SEQ_NUM"
    EXT_USER ||--o| EMAIL_ADDRESS : "EMAIL_ADDRESS_SEQ_NUM"
    EXT_USER ||--o| PERSON : "PERSON_SEQ_NUM"
    PERSON ||--o{ PERSON_EMAIL : "PERSON_SEQ_NUM"
    PERSON_EMAIL }o--|| EMAIL_ADDRESS : "EMAIL_ADDRESS_SEQ_NUM"
    EXT_USER_TYPE }o--|| EXT_USER_TYPE_CODE : "EXT_USER_TYPE_CODE"
    EXT_USER_TYPE_CODE ||--o{ EXT_USER_TYPE_CODE_PROMPT : "EXT_USER_TYPE_CODE"
    EXT_USER_ACCESS_GROUP }o--|| EXT_USER_ACCESS_GROUP_CODE : "EXT_USER_ACCESS_GROUP_CODE"
    EXT_USER_SECURITY_QUESTION }o--|| EXT_USER_SEC_QUESTION_CODE : "EXT_USER_SEC_QUESTION_CODE"
    EXT_USER_ACCESS_GROUP_AD }o--|| EXT_USER_AD_GROUP : "EXT_USER_AD_GROUP_SEQ_NUM"
    PA_AUDITOR ||--o{ PA_AUDITOR_ZIP_CODE : "PA_AUDITOR_ID"
    PA_ZIP_CODE }o--o| COUNTY : "COUNTY_CODE"
    COUNTY }o--|| OFFICE_CODE : "OFFICE_CODE"
    EXT_USER_TYPE }o--o| COMPANY : "COMPANY_SEQ_NUM"

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• API reference
• Configuration

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

• Business\SAIF.Business.External.Users\clsUser.vb
• Business\SAIF.Business.External.Users\clsAuditor.vb
• Business\SAIF.Business.External.Users\clsAuditorCollection.vb
• Business\SAIF.Business.External.Users\clsAuditAssignmentOverride.vb
• Business\SAIF.Business.External.Users\clsAuditorZipCode.vb
• Business\SAIF.Business.External.Users\clsAuditorZipCodeCollection.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\mdlCodeMaps.vb
• Business\SAIF.Business.External.Users\mdlGroupAssociation.vb