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

Queries EXT_USER, EXT_USER_TYPE, and PROVIDER_EOB_INTERFACE to determine whether the user identified by an Active Directory ID has any associated provider EOB interface records.

Classification¶

Field	Value
SQL ID	SQL-036
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsUserType`
Criteria property	Local SQL
Lifecycle method	`IsUserEobOwner`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:inUserID`	Input	String	30	AD user ID to check EOB ownership for.

Tables¶

Table	Access	Columns used
EXT_USER	SELECT	`EXT_USER_SEQ_NUM`, `ACTIVE_DIRECTORY_ID`
EXT_USER_TYPE	JOIN	`EXT_USER_SEQ_NUM`, `EXT_USER_TYPE_SEQ_NUM`
PROVIDER_EOB_INTERFACE	JOIN	`EXT_USER_TYPE_SEQ_NUM`

Sample SQL¶

SELECT p.ext_user_type_seq_num
FROM ext_user e, ext_user_type et, Provider_eob_Interface p
WHERE et.ext_user_seq_num = e.ext_user_seq_num
  AND et.ext_user_type_seq_num = p.ext_user_type_seq_num
  AND e.active_directory_id = :inUserID

Operations and processes¶

User type management

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\clsUserType.vb