This page catalogs the database tables that SAIF.Business.View.Policy reads directly from inline SQL. Every table is read only; the library implements no insert, update, or delete path (BR-021).
Most policy data reaches this library through Oracle stored procedures rather than through direct table access. Tables touched only inside a procedure body are not listed here because they are opaque to the .NET source; they are described on the Procedures pages instead.
A separate SQL Server data store, configured through the BDS_* settings described on the Configuration page, backs the group-membership procedure cp_policy_in_group used by BR-006. That store is reached through its own connection path and none of its tables are referenced by name in this library's source, so no table entry can be cataloged for it.**
The SQL Server BDS database (eisD0P11) also backs the legacy external-client e-mail lookup procedure cp_external_client_lookup, which reads the Net_Registrant table via a three-part name (EIS_PROD.dbo.Net_Registrant) confirmed by retrieved procedure source.
Reference table of policy association type codes. Each row supplies the display description, category, sort order, security group, and the name of the stored procedure that supplies associations of that type.
Premium-audit history for a policy. Used to report the most recent completed final audit and, in the security layer, to decide whether a fee auditor's engagement is current.
Policy master. This library reads it directly only for the system-derived policy relationship branch of the association query; every other policy read passes through a stored procedure.
Policy period master. Supplies the date window used to scope discount-combination membership and the latest effective date used as a default as-of date.
The following diagram shows the relationships that this library's inline SQL relies on.
erDiagram
POLICY ||--o{ POLICY_RELATIONSHIP : "parent or member policy"
POLICY ||--o{ POLICY : "policy relationship policy"
POLICY ||--o{ COMBO_POLICY_PERIOD : "discount combination member"
POLICY ||--o{ ER_COMBINATION_POLICY : "experience combination member"
POLICY_PERIOD ||--|| COMBO_POLICY_PERIOD : "same policy and effective date"
POLICY ||--o{ POLICY_PERIOD : "policy periods"
POLICY ||--o{ TRADING_AS : "registered names"
POLICY_PERIOD_ALL ||--o{ ENDORSEMENT : "issued period evidence"
POLICY_PERIOD_ALL ||--o{ POLICY_PERIOD_NON_WCIS : "issued period evidence"
BUSINESS_AFFILIATE }o--|| AFFILIATE : "affiliate ssn"
POLICY {
NUMBER POLICY_NUM PK
NUMBER POLICY_RELATIONSHIP_POLICY_NUM FK
VARCHAR2 POLICY_RELATIONSHIP_CODE
NUMBER RATE_ACCOUNT
}
POLICY_RELATIONSHIP {
NUMBER PARENT_POLICY_NUM FK
NUMBER MBR_POLICY_NUM FK
VARCHAR2 AFFIL_TYP_CD
}
POLICY_PERIOD {
NUMBER POLICY_NUM PK
DATE POLICY_PERIOD_EFF_DATE PK
DATE POLICY_PERIOD_EXP_DATE
}
COMBO_POLICY_PERIOD {
NUMBER POLICY_NUM PK
DATE POLICY_PERIOD_EFF_DATE PK
NUMBER COMBO_PERIOD_SEQ_NUM
VARCHAR2 ACTIVE_MEMBER_FLAG
VARCHAR2 MIN_PREMIUM_MEMBER_FLAG
}
ER_COMBINATION_POLICY {
NUMBER POLICY_NUM PK
NUMBER ER_COMBINATION_SEQ_NUM
DATE EFF_DATE
DATE EXP_DATE
}
POLICY_PERIOD_ALL {
NUMBER POLICY_NUM PK
DATE POLICY_PERIOD_EFF_DATE PK
DATE POLICY_PERIOD_EXP_DATE
DATE CANCEL_DATE
}
ENDORSEMENT {
NUMBER POLICY_NUM FK
DATE POLICY_PERIOD_EFF_DATE FK
VARCHAR2 ENDORSE_CODE
DATE PRINTED_DATE
}
POLICY_PERIOD_NON_WCIS {
NUMBER POLICY_NUM FK
DATE POLICY_PERIOD_EFF_DATE FK
VARCHAR2 POLICY_PERIOD_STATUS_CODE
}
TRADING_AS {
NUMBER TRADING_SEQ_NUM PK
NUMBER POLICY_NUM FK
VARCHAR2 TRADING_AS_NAME
DATE TRADING_AS_CANCEL_DATE
}
BUSINESS_AFFILIATE {
NUMBER POLICY_NUM FK
VARCHAR2 AFFILIATE_SSN FK
VARCHAR2 OFFICER_OF_NOTICE_FLAG
DATE AFFILIATE_CANCEL_DATE
}
AFFILIATE {
VARCHAR2 AFFILIATE_SSN PK
VARCHAR2 AFFILIATE_FIRST_NAME
VARCHAR2 AFFILIATE_INITIAL
VARCHAR2 AFFILIATE_LAST_NAME
}
ASSOCIATION_TYPE_CODE, NON_EMPR_ACCT, PA_AUDIT, and CANCELLATION are omitted from the diagram because this library queries each of them standalone, without a join.
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.