SQL-103: Retrieve s a i f office collection¶
Retrieve s a i f office collection in the context of clsSAIFOfficeCollection.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-103 |
| Operation type | Read |
| Execution method | IDataRequest.SQLStatement (CommandType.Text) |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsSAIFOfficeCollection |
| Criteria property | RetrieveSQL |
| Lifecycle method | BeforeRetrieve / AfterRetrieve |
Parameters¶
This statement has no bind parameters.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| OFFICE_CODE | SELECT | See sample SQL |
Sample SQL¶
SELECT
OFFICE_CODE.CODE as Code,
OFFICE_CODE.CODE_DESCR as Description,
OFFICE_CODE.PMS_OFFICE_CODE as PMSOfficeCode,
OFFICE_CODE.POLICY_RENEWAL_TRACK_CODE as PolicyRenewalTrackCode,
OFFICE_CODE.LOC_SEQ_NUM as LocationSeqNum,
OFFICE_CODE.CANCELLATION_TRACK_CODE as CancellationTrackCode,
OFFICE_CODE.POLICY_REGION_CODE as PolicyRegionCode
FROM
OFFICE_CODE
Business rules¶
- BR-030: The service centre office is identified by office
- BR-033: New sequence values for writable entities are obtained
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.Policy.Core\clsSAIFOfficeCollection.vb