SQL-032: Language-translation collection retrieval*¶

This document describes SQL-032, the language-translation collection retrieval* statement or call used by SAIF.Business.

Classification¶

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

Parameters¶

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

Tables¶

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

Sample SQL¶

SELECT LANGUAGE_TRANSLATION.LANGUAGE_CODE AS LanguageCode,
       LANGUAGE_TRANSLATION.LANGUAGE_GENDER_CODE AS LanguageGenderCode,
       LANGUAGE_TRANSLATION.LOOKUP_VALUE AS LookupValue,
       LANGUAGE_TRANSLATION.TRANSLATED_VALUE AS TranslatedValue,
       LANGUAGE_TRANSLATION.UPDATE_DATE AS UpdateDate,
       LANGUAGE_TRANSLATION.UPDATE_USER AS UpdateUser
  FROM LANGUAGE_TRANSLATION

Optional filters append language and gender predicates.

Operations and processes¶

Language translation retrieval

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