Skip to content

SAIF.Application.Policy database tables

This library does not author table SQL directly. The tables below are reached only through the Oracle function invoked by SQL-001, so they are documented here as delegated, read-only dependencies of the application's one direct database call.

Table catalog

Table Database Schema/Link CRUD Purpose Primary business object
POLICY Oracle [unqualified]** R Supplies policy status, current balance, and cancel-status branching context clsStandardPolicyHeaderDataProvider*
POLICY_STATUS_CODE Oracle [unqualified]** R Maps policy status code to status-group branching values clsStandardPolicyHeaderDataProvider*
POLICY_DEMAND Oracle [unqualified]** R Determines defaulted and demanded collection states clsStandardPolicyHeaderDataProvider*
POLICY_PERIOD_PAYROLL_AUDIT Oracle [unqualified]** R Determines pending-audit and pending-payroll-report conditions clsStandardPolicyHeaderDataProvider*
AUDIT_CODE Oracle [unqualified]** R Distinguishes physical audit rows from other audit rows clsStandardPolicyHeaderDataProvider*
CANCELLATION Oracle [unqualified]** R Supplies the latest cancel date used by audit and payroll-report checks clsStandardPolicyHeaderDataProvider*
COLLECTION_LEGAL_ACTION Oracle [unqualified]** R Detects open judgment and lien collection actions clsStandardPolicyHeaderDataProvider*

POLICY

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Supplies POLICY_STATUS_CODE and CURRENT_BALANCE to the cancellation-status function.
Access pattern Stored function call via SQL-001
CRUD operations Read
Key columns used POLICY_NUM, POLICY_STATUS_CODE, CURRENT_BALANCE
Sequence N/A
Related tables POLICY_STATUS_CODE, POLICY_DEMAND, POLICY_PERIOD_PAYROLL_AUDIT, CANCELLATION, COLLECTION_LEGAL_ACTION
Business objects clsStandardPolicyHeaderDataProvider*

Operations referencing this table

Business rules referencing this table

SQL referencing this table

POLICY_STATUS_CODE

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Supplies POLICY_STATUS_GROUP_CODE so the function can branch into pending-cancel, cancelled, or application logic.
Access pattern Stored function call via SQL-001
CRUD operations Read
Key columns used CODE, POLICY_STATUS_GROUP_CODE
Sequence N/A
Related tables POLICY
Business objects clsStandardPolicyHeaderDataProvider*

Operations referencing this table

SQL referencing this table

POLICY_DEMAND

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Determines whether the policy is Defaulted or Demanded.
Access pattern Stored function call via SQL-001
CRUD operations Read
Key columns used POLICY_NUM, COLLECTION_ACT_RESPONSE_CODE
Sequence N/A
Related tables POLICY
Business objects clsStandardPolicyHeaderDataProvider*

Operations referencing this table

SQL referencing this table

POLICY_PERIOD_PAYROLL_AUDIT

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Determines whether outstanding audits or payroll reports exist before the latest cancel date.
Access pattern Stored function call via SQL-001
CRUD operations Read
Key columns used POLICY_NUM, AUDIT_STATUS_CODE, AUDIT_PERIOD_START_DATE, AUDIT_CODE, PAYROLL_SEQ_NUM
Sequence N/A
Related tables AUDIT_CODE, CANCELLATION, POLICY
Business objects clsStandardPolicyHeaderDataProvider*

Operations referencing this table

SQL referencing this table

AUDIT_CODE

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Labels pending audit rows as physical or non-physical audit work.
Access pattern Stored function call via SQL-001
CRUD operations Read
Key columns used CODE, AUDIT_TYPE_CODE
Sequence N/A
Related tables POLICY_PERIOD_PAYROLL_AUDIT
Business objects clsStandardPolicyHeaderDataProvider*

Operations referencing this table

SQL referencing this table

CANCELLATION

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Supplies the latest cancel date used to qualify audit and payroll-report checks.
Access pattern Stored function call via SQL-001
CRUD operations Read
Key columns used POLICY_NUM, CANCELLATION_SEQ_NUM, CANCEL_DATE
Sequence N/A
Related tables POLICY, POLICY_PERIOD_PAYROLL_AUDIT
Business objects clsStandardPolicyHeaderDataProvider*

Operations referencing this table

SQL referencing this table

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Detects open judgment and lien collection actions for cancelled policies.
Access pattern Stored function call via SQL-001
CRUD operations Read
Key columns used POLICY_NUM, COLLECTION_ACTION_CODE, CANCEL_DATE
Sequence N/A
Related tables POLICY
Business objects clsStandardPolicyHeaderDataProvider*

Operations referencing this table

SQL referencing this table

Table relationship diagram

The following diagram shows relationships inferred from the Oracle function behind the application's direct SQL call.

erDiagram
    POLICY_STATUS_CODE ||--o{ POLICY : status_code
    POLICY ||--o{ POLICY_DEMAND : policy_num
    POLICY ||--o{ POLICY_PERIOD_PAYROLL_AUDIT : policy_num
    AUDIT_CODE ||--o{ POLICY_PERIOD_PAYROLL_AUDIT : audit_code
    POLICY ||--o{ CANCELLATION : policy_num
    POLICY ||--o{ COLLECTION_LEGAL_ACTION : policy_num
    POLICY_PERIOD_PAYROLL_AUDIT ||--|| POLICY_PERIOD_PAYROLL_AUDIT : payroll_seq_num

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

  • Application\SAIF.Application.Policy\PolicyHeader\clsStandardPolicyHeaderDataProvider.vb