Retrieve a policy (optionally masked)

Retrieve a policy (optionally masked) describes the corresponding policy-core workflow and its BOF or Oracle touchpoints.

Field	Value
Operation ID	OP-001
Trigger	caller requests a single policy by policy number
Inputs	data portal, policy number, mask-data flag (default False)
Outputs	populated clsPolicy
Primary components	`clsPolicy.GetPolicy(inDataportal, inPolicyNumber, inMaskData) (clsPolicy.vb)`
Entry point	Business\SAIF.Business.Policy.Core

Steps

1. Construct a Criteria instance carrying the policy number and the MaskData flag.
2. Execute RetrieveSQL against POLICY via the data portal.
3. Fill maps result columns to properties. If MaskData is True, POLICYHOLDER_NAME and POLICYHOLDER_LEGAL_NAME are replaced with clsConstants.DataMaskingConstants placeholders (BR-020).
4. Market type, financial system and issuance system codes are converted through SAIF.Business.Policy.Enums converters.
5. Return the populated object; navigation properties (periods, locations, contacts) are retrieved lazily on first access.*
6. Consolidate supporting references.
7. Related business rules: BR-020
8. Related SQL statements: SQL-070, SQL-071, SQL-072, SQL-073
9. Related tables: CANCELLATION, POLICY_PERIOD_MASTER, BUSINESS, POLICY

Process flow

The following diagram visualizes this operation's control flow.

flowchart TD
    Start([Trigger]) --> S1[Apply policy-core logic]
    S1 --> D{Validation or branch?}
    D -->|Continue| S2[Execute BOF SQL or Oracle call]
    D -->|Stop| EndErr([Return error or empty result])
    S2 --> EndOk([Return populated result])

Failure and edge-case behavior

• Error, warning, and empty-result behavior follows the rules and SQL cited in the steps above.
• Stored-procedure-backed paths depend on Oracle-side logic outside this repository.**

Related documentation

• Operations and processes
• Business rules
• SQL catalog
• Database tables

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\clsPolicy.vb
• Business\SAIF.Business.Policy.Core\clsPolicyPeriodBase.vb
• Business\SAIF.Business.Policy.Core\clsPolicyPeriod.vb
• Business\SAIF.Business.Policy.Core\clsLegacyPolicyPeriod.vb
• Business\SAIF.Business.Policy.Core\clsCancelReasonOverride.vb
• Business\SAIF.Business.Policy.Core\WCISInquiry.vb