SQL-026: Employee collection retrieval*¶

This document describes SQL-026, the employee collection retrieval* statement or call used by SAIF.Business.

Classification¶

Field	Value
SQL ID	SQL-026
Operation type	Read
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsEmployeeDataCollection`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve`

Parameters¶

This SQL statement has no explicit parameters in the provided findings.

Tables¶

Table	Access	Columns used
ADP_EMPLOYEE	SELECT	See sample SQL and source implementation.
VIRTUAL_EMPLOYEE	SELECT	See sample SQL and source implementation.

Sample SQL¶

clsEmployeeDataCollection.Criteria.RetrieveSQL reuses clsEmployeeData.Criteria.Retrieve_SQL and appends one of:

AND ADP.DEPTID = '<DepartmentID>'
AND ADP.DESCR = '<JobTitle>'
AND ADP.LOCATION = '<Location>'
AND ADP.EMPL_STATUS = 'A'

It optionally appends UNION ALL <Retrieve_Virtual_SQL> ....

Operations and processes¶

Employee collection retrieval

Business rules¶

BR-SB-011: Employee collection retrieval appends literal filter predicates

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