SQL-093: Retrieve policy period status collection¶
Retrieve policy period status collection in the context of clsPolicyPeriodStatusCollection.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-093 |
| Operation type | Read |
| Execution method | IDataRequest.SQLStatement (CommandType.Text) |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsPolicyPeriodStatusCollection |
| Criteria property | RetrieveSQL |
| Lifecycle method | BeforeRetrieve / AfterRetrieve |
Parameters¶
This statement has no bind parameters.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| POLICY_PERIOD_STATUS_CODE | SELECT | See sample SQL |
Sample SQL¶
SELECT
POLICY_PERIOD_STATUS_CODE.CODE as Code,
POLICY_PERIOD_STATUS_CODE.CODE_DESCR as CodeDescr,
POLICY_PERIOD_STATUS_CODE.PMS_INTERFACE_FLAG as PmsInterfaceFlag,
POLICY_PERIOD_STATUS_CODE.SHORT_CODE_DESCR as ShortCodeDescr
FROM
POLICY_PERIOD_STATUS_CODE
Operations and processes¶
Business rules¶
- BR-001: Policy period status codes map to a fixed
- BR-002: An unrecognised status code yields Statuses.Unknown; an unrecognised
- BR-003: Statuses roll up into six status groups Application
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\clsPolicyPeriodStatusCollection.vb