SQL-036: External-user last-logon/user lookup family*¶

This document describes SQL-036, the external-user last-logon/user lookup family* statement or call used by SAIF.Business.

Classification¶

Field	Value
SQL ID	SQL-036
Operation type	Read
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`ExternalUserServices`
Criteria property	`N/A`
Lifecycle method	`GetLastLogonsByCustomer, GetUsersByCustomer`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:customerGroupID \| :customerID`, `:code0..:codeN`	Input	String	20 / 5

Tables¶

Table	Access	Columns used
EXT_USER	SELECT	See sample SQL and source implementation.
EXT_USER_TYPE	SELECT	See sample SQL and source implementation.

Sample SQL¶

SELECT u.active_directory_id, u.last_logon_date, t.ext_user_type_code, u.test_user_flag
  FROM ext_user u
  JOIN ext_user_type t ON t.ext_user_seq_num = u.ext_user_seq_num
 WHERE t.customer_group_id = :customerGroupID
   AND t.ext_user_type_code IN (:code0[, :code1, :code2])
 ORDER BY u.test_user_flag, u.last_logon_date DESC

GetUsersByCustomer substitutes t.customer_id = :customerID and uses the same dynamic IN (:codeN...) assembly.

Operations and processes¶

Address validation and external-user reporting

Business rules¶

BR-SB-007: Production external-user queries hide test users

Note: Statements marked with * are inferred from code behavior rather than explicit documentation or comments; statements marked with ** could not be confirmed and should be treated as unknown until verified.

Sources¶

Business\SAIF.Business\Services\ExternalUserServices.vb