SAIF.Business.Policy.Core database tables

This page catalogs database tables accessed by this library.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
BUSINESS	Oracle	[unqualified]**	R	Policy data*	clsPolicy
CANCELLATION	Oracle	[unqualified]**	CRUD	Cancel Reason Override data*	clsCancelReasonOverride, clsCancellationWarning, clsCancellationWarningCollection, clsPolicy
CANCEL_REASON_CODE	Oracle	[unqualified]**	CRUD	Cancel Reason Override data*	clsCancelReasonOverride, clsCancellationReason, clsCancellationReasonCollection
CANCEL_REASON_OVERRIDE	Oracle	[unqualified]**	CR	Cancel Reason Override data*	clsCancelReasonOverride
CARRIER_CHANGE_REASON_CODE	Oracle	[unqualified]**	R	Cancel Reason Override data*	clsCancelReasonOverride
CARRIER_CODE	Oracle	[unqualified]**	CRUD	Cancel Reason Override data*	clsCancelReasonOverride, clsInsuranceCarrier
CONTACT	Oracle	[unqualified]**	R	Location Contact data*	clsLocationContact, clsLocationContactCollection, clsPolicyLocation
COUNTY	Oracle	[unqualified]**	CRUD	County data*	clsCounty, clsCountyCollection
DUAL	Oracle	[unqualified]**	-	Cancellation Reason data*	clsCancellationReason, clsCancellationReasonCollection, clsCancellationWarning, clsCancellationWarningCollection, clsCounty, clsCountyCollection, clsInsuranceCarrier, clsLocation, clsLocationCollection, clsPolicyPeriodEmployerLiabilityLimits, clsPolicyPeriodEmployerLiabilityLimitsCollection, clsPolicyPeriodMaster, clsPolicyTeamFunction, clsPolicyTeamFunctionCollection, clsPolicyTeamMemberCollection, clsPriorCoverage, clsPriorCoverageCollection, clsSAIFOffice, clsSAIFOfficeCollection, clsWCISEmployee, clsWCISEmployeeCollection
EMPLOYERS_LIABILITY_FACTORS	Oracle	[unqualified]**	R	Employer Liability Limits Collection data*	clsEmployerLiabilityLimitsCollection
EMPLOYERS_LIABILITY_LIMITS	Oracle	[unqualified]**	R	Employer Liability Limits Collection data*	clsEmployerLiabilityLimitsCollection
ENTITY_CODE	Oracle	[unqualified]**	R	Entity Type data*	clsEntityType, clsEntityTypeCollection
LOCATION	Oracle	[unqualified]**	CRUD	Location data*	clsLocation, clsLocationCollection, clsPolicyLocation, clsPolicyLocationCollection
LOCATION_CODE	Oracle	[unqualified]**	R	Location Type data*	clsLocationType, clsLocationTypeCollection
LOCATION_VIEW	Oracle	[unqualified]**	U	Policy Location data*	clsPolicyLocation
NON_WCIS_STAT_TRANS	Oracle	[unqualified]**	R	Policy Period Base data*	clsPolicyPeriodBase
OFFICE_CODE	Oracle	[unqualified]**	CRUD	S A I F Office data*	clsSAIFOffice, clsSAIFOfficeCollection
POLICY	Oracle	[unqualified]**	R	W C I S Inquiry data*	WCISInquiry, clsPolicy, clsPolicyCollection
POLICY_PERIOD	Oracle	[unqualified]**	R	W C I S Inquiry data*	WCISInquiry, clsPolicyPeriodCollection
POLICY_PERIOD_EMP_LIAB	Oracle	[unqualified]**	CRUD	Policy Period Employer Liability Limits data*	clsPolicyPeriodEmployerLiabilityLimits, clsPolicyPeriodEmployerLiabilityLimitsCollection
POLICY_PERIOD_MASTER	Oracle	[unqualified]**	CRUD	Policy data*	clsPolicy, clsPolicyPeriodMaster
POLICY_PERIOD_NON_WCIS	Oracle	[unqualified]**	R	Legacy Policy Period Collection data*	clsLegacyPolicyPeriodCollection
POLICY_PERIOD_STATUS_CODE	Oracle	[unqualified]**	R	Policy Period Status data*	clsPolicyPeriodStatus, clsPolicyPeriodStatusCollection
POLICY_STATUS_CODE	Oracle	[unqualified]**	R	Policy Status Code data*	clsPolicyStatusCode, clsPolicyStatusCodeCollection
POLICY_TEAM_FUNCTION	Oracle	[unqualified]**	CRUD	Policy Team Member data*	clsPolicyTeamMember, clsPolicyTeamMemberCollection
PRIOR_COVERAGE	Oracle	[unqualified]**	CRUD	Prior Coverage data*	clsPriorCoverage, clsPriorCoverageCollection
SUB_CONSTANTS	Oracle	[unqualified]**	R	W C I S Inquiry data*	WCISInquiry
TEAM_FUNCTION_CODE	Oracle	[unqualified]**	CRUD	Policy Team Function data*	clsPolicyTeamFunction, clsPolicyTeamFunctionCollection
WCIS_CONSTANTS	Oracle	[unqualified]**	R	W C I S Inquiry data*	WCISInquiry
WCIS_EMPLOYEE	Oracle	[unqualified]**	CRUD	W C I S Employee data*	clsWCISEmployee, clsWCISEmployeeCollection

BUSINESS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Policy data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	POLICY
Business objects	clsPolicy

Operations referencing this table

• Retrieve a policy (optionally masked)

Business rules referencing this table

• BR-020: When masking is requested, policyholder names, contact identity/contact-method

SQL referencing this table

• SQL-072: Policy

---

CANCELLATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Cancel Reason Override data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	CRUD
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	POLICY, CANCEL_REASON_OVERRIDE, CANCEL_REASON_CODE, CARRIER_CODE, CARRIER_CHANGE_REASON_CODE
Business objects	clsCancelReasonOverride, clsCancellationWarning, clsCancellationWarningCollection, clsPolicy

Operations referencing this table

• Record a cancellation reason override
• Retrieve a policy (optionally masked)

Business rules referencing this table

• BR-033: New sequence values for writable entities are obtained
• BR-009: A cancellation reason override must carry a valid
• BR-020: When masking is requested, policyholder names, contact identity/contact-method

SQL referencing this table

• SQL-024: Cancellation Warning
• SQL-025: Cancellation Warning Collection
• SQL-047: Cancellation Warning
• SQL-048: Cancellation Warning Collection
• SQL-049: Cancel Reason Override
• SQL-050: Cancel Reason Override
• SQL-051: Cancel Reason Override
• SQL-052: Cancel Reason Override
• SQL-070: Policy
• SQL-124: Cancellation Warning
• SQL-125: Cancellation Warning Collection
• SQL-147: Cancellation Warning
• SQL-148: Cancellation Warning Collection

---

CANCEL_REASON_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Cancel Reason Override data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	CRUD
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	CANCELLATION, CANCEL_REASON_OVERRIDE
Business objects	clsCancelReasonOverride, clsCancellationReason, clsCancellationReasonCollection

Operations referencing this table

• Record a cancellation reason override

Business rules referencing this table

• BR-033: New sequence values for writable entities are obtained
• BR-009: A cancellation reason override must carry a valid

SQL referencing this table

• SQL-022: Cancellation Reason
• SQL-023: Cancellation Reason Collection
• SQL-045: Cancellation Reason
• SQL-046: Cancellation Reason Collection
• SQL-050: Cancel Reason Override
• SQL-122: Cancellation Reason
• SQL-123: Cancellation Reason Collection
• SQL-145: Cancellation Reason
• SQL-146: Cancellation Reason Collection

---

CANCEL_REASON_OVERRIDE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Cancel Reason Override data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	CR
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	CANCELLATION, CANCEL_REASON_CODE
Business objects	clsCancelReasonOverride

Operations referencing this table

• Record a cancellation reason override

Business rules referencing this table

• BR-009: A cancellation reason override must carry a valid
• BR-033: New sequence values for writable entities are obtained

SQL referencing this table

• SQL-026: Cancel Reason Override
• SQL-053: Cancel Reason Override

---

CARRIER_CHANGE_REASON_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Cancel Reason Override data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	CANCELLATION
Business objects	clsCancelReasonOverride

Operations referencing this table

• Record a cancellation reason override

Business rules referencing this table

• BR-009: A cancellation reason override must carry a valid
• BR-033: New sequence values for writable entities are obtained

SQL referencing this table

• SQL-051: Cancel Reason Override

---

CARRIER_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Cancel Reason Override data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	CRUD
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	CANCELLATION
Business objects	clsCancelReasonOverride, clsInsuranceCarrier

Operations referencing this table

• Record a cancellation reason override

Business rules referencing this table

• BR-029: SAIF's own carrier identity is represented by fixed
• BR-033: New sequence values for writable entities are obtained
• BR-009: A cancellation reason override must carry a valid

SQL referencing this table

• SQL-029: Insurance Carrier
• SQL-052: Cancel Reason Override
• SQL-060: Insurance Carrier
• SQL-128: Insurance Carrier
• SQL-151: Insurance Carrier

---

CONTACT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Location Contact data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	LOCATION
Business objects	clsLocationContact, clsLocationContactCollection, clsPolicyLocation

Operations referencing this table

• Filter policy locations for a view

Business rules referencing this table

• BR-020: When masking is requested, policyholder names, contact identity/contact-method
• BR-017: A location is active as of a date
• BR-018: Summary locations are active locations of type Business

SQL referencing this table

• SQL-066: Location Contact
• SQL-067: Location Contact Collection
• SQL-075: Policy Location

---

COUNTY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	County data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	CRUD
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	OFFICE_CODE
Business objects	clsCounty, clsCountyCollection

Business rules referencing this table

• BR-033: New sequence values for writable entities are obtained

SQL referencing this table

• SQL-027: County
• SQL-028: County Collection
• SQL-054: County
• SQL-055: County Collection
• SQL-126: County
• SQL-127: County Collection
• SQL-149: County
• SQL-150: County Collection

---

DUAL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Cancellation Reason data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	-
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	N/A
Business objects	clsCancellationReason, clsCancellationReasonCollection, clsCancellationWarning, clsCancellationWarningCollection, clsCounty, clsCountyCollection, clsInsuranceCarrier, clsLocation, clsLocationCollection, clsPolicyPeriodEmployerLiabilityLimits, clsPolicyPeriodEmployerLiabilityLimitsCollection, clsPolicyPeriodMaster, clsPolicyTeamFunction, clsPolicyTeamFunctionCollection, clsPolicyTeamMemberCollection, clsPriorCoverage, clsPriorCoverageCollection, clsSAIFOffice, clsSAIFOfficeCollection, clsWCISEmployee, clsWCISEmployeeCollection

Operations referencing this table

• Record a cancellation reason override
• Filter policy locations for a view
• Retrieve employers-liability limits
• Build a unified policy period timeline

Business rules referencing this table

• BR-033: New sequence values for writable entities are obtained
• BR-029: SAIF's own carrier identity is represented by fixed
• BR-017: A location is active as of a date
• BR-025: Per-period employers-liability limits must carry a valid statistical
• BR-010: A policy's period history is the union of
• BR-030: The service centre office is identified by office

SQL referencing this table

• SQL-001: Cancellation Reason
• SQL-002: Cancellation Reason Collection
• SQL-003: Cancellation Warning
• SQL-004: Cancellation Warning Collection
• SQL-005: County
• SQL-006: County Collection
• SQL-007: Insurance Carrier
• SQL-008: Location
• SQL-009: Location Collection
• SQL-010: Policy Period Employer Liability Limits
• SQL-011: Policy Period Employer Liability Limits Collection
• SQL-012: Policy Period Master
• SQL-013: Policy Team Function
• SQL-014: Policy Team Function Collection
• SQL-015: Policy Team Member Collection
• SQL-016: Prior Coverage
• SQL-017: Prior Coverage Collection
• SQL-018: S A I F Office
• SQL-019: S A I F Office Collection
• SQL-020: W C I S Employee
• SQL-021: W C I S Employee Collection

---

EMPLOYERS_LIABILITY_FACTORS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Employer Liability Limits Collection data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	N/A
Business objects	clsEmployerLiabilityLimitsCollection

Operations referencing this table

• Retrieve employers-liability limits

Business rules referencing this table

• BR-021: Employers-liability limits may be retrieved by statistical code

SQL referencing this table

• SQL-057: Employer Liability Limits Collection

---

EMPLOYERS_LIABILITY_LIMITS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Employer Liability Limits Collection data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	POLICY_PERIOD_EMP_LIAB
Business objects	clsEmployerLiabilityLimitsCollection

Operations referencing this table

• Retrieve employers-liability limits

Business rules referencing this table

• BR-021: Employers-liability limits may be retrieved by statistical code

SQL referencing this table

• SQL-057: Employer Liability Limits Collection

---

ENTITY_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Entity Type data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	POLICY
Business objects	clsEntityType, clsEntityTypeCollection

Operations referencing this table

• Determine ownership requirements for an entity type

Business rules referencing this table

• BR-006: Ownership information is required for all entity types
• BR-007: Sole proprietors require exactly one owner; partnerships, limited
• BR-008: For the Guidewire path, joint ventures require one
• BR-026: An entity type must have a valid code

SQL referencing this table

• SQL-058: Entity Type
• SQL-059: Entity Type Collection

---

LOCATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Location data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	CRUD
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	CONTACT, LOCATION_CODE
Business objects	clsLocation, clsLocationCollection, clsPolicyLocation, clsPolicyLocationCollection

Operations referencing this table

• Filter policy locations for a view

Business rules referencing this table

• BR-017: A location is active as of a date
• BR-018: Summary locations are active locations of type Business
• BR-020: When masking is requested, policyholder names, contact identity/contact-method
• BR-019: Only location types flagged PolicyLocationFlag = "Y" are

SQL referencing this table

• SQL-030: Location Collection
• SQL-064: Location
• SQL-065: Location Collection
• SQL-076: Policy Location
• SQL-077: Policy Location Collection
• SQL-129: Location
• SQL-130: Location Collection
• SQL-152: Location Collection

---

LOCATION_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Location Type data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	LOCATION
Business objects	clsLocationType, clsLocationTypeCollection

Operations referencing this table

• Filter policy locations for a view

Business rules referencing this table

• BR-019: Only location types flagged PolicyLocationFlag = "Y" are

SQL referencing this table

• SQL-068: Location Type
• SQL-069: Location Type Collection

---

LOCATION_VIEW

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Policy Location data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	U
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	N/A
Business objects	clsPolicyLocation

Operations referencing this table

• Filter policy locations for a view

Business rules referencing this table

• BR-017: A location is active as of a date
• BR-018: Summary locations are active locations of type Business
• BR-020: When masking is requested, policyholder names, contact identity/contact-method

SQL referencing this table

• SQL-131: Policy Location

---

NON_WCIS_STAT_TRANS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Policy Period Base data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	POLICY
Business objects	clsPolicyPeriodBase

Operations referencing this table

• Determine standard premium for a period

Business rules referencing this table

• BR-013: Standard premium is sourced from WCIS for WCIS
• BR-022: A policy period must have a non-zero policy
• BR-023: A policy period must have an effective date

SQL referencing this table

• SQL-084: Policy Period Base

---

OFFICE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	S A I F Office data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	CRUD
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	COUNTY, POLICY
Business objects	clsSAIFOffice, clsSAIFOfficeCollection

Business rules referencing this table

• BR-030: The service centre office is identified by office
• BR-033: New sequence values for writable entities are obtained

SQL referencing this table

• SQL-040: S A I F Office
• SQL-041: S A I F Office Collection
• SQL-102: S A I F Office
• SQL-103: S A I F Office Collection
• SQL-141: S A I F Office
• SQL-142: S A I F Office Collection
• SQL-162: S A I F Office
• SQL-163: S A I F Office Collection

---

POLICY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	W C I S Inquiry data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	POLICY_PERIOD, POLICY_PERIOD_NON_WCIS, POLICY_PERIOD_MASTER, CANCELLATION, BUSINESS, LOCATION`, NON_WCIS_STAT_TRANS, POLICY_TEAM_FUNCTION, PRIOR_COVERAGE, POLICY_STATUS_CODE, OFFICE_CODE, ENTITY_CODE
Business objects	WCISInquiry, clsPolicy, clsPolicyCollection

Operations referencing this table

• Retrieve a policy (optionally masked)
• Retrieve affiliated policies / policies for an account
• Determine standard premium for a period
• Determine whether a period is issued

Business rules referencing this table

• BR-020: When masking is requested, policyholder names, contact identity/contact-method
• BR-032: Preliminary audit is required when the WCIS edit

SQL referencing this table

• SQL-073: Policy
• SQL-074: Policy Collection
• SQL-111: W C I S Inquiry
• SQL-114: W C I S Inquiry
• SQL-115: W C I S Inquiry

---

POLICY_PERIOD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	W C I S Inquiry data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	POLICY, POLICY_PERIOD_STATUS_CODE, POLICY_PERIOD_EMP_LIAB
Business objects	WCISInquiry, clsPolicyPeriodCollection

Operations referencing this table

• Build a unified policy period timeline
• Configure dynamic period retrieval SQL
• Select the relevant period from a set
• Determine standard premium for a period
• Determine whether a period is issued

Business rules referencing this table

• BR-004: The current period is the first period flagged
• BR-005: Experience-rating base periods are those whose begin date
• BR-010: A policy's period history is the union of
• BR-011: Association-based period retrieval uses a different predicate per
• BR-012: An association type outside the supported set is
• BR-032: Preliminary audit is required when the WCIS edit

SQL referencing this table

• SQL-088: Policy Period Collection
• SQL-109: W C I S Inquiry
• SQL-112: W C I S Inquiry

---

POLICY_PERIOD_EMP_LIAB

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Policy Period Employer Liability Limits data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	CRUD
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	POLICY_PERIOD, EMPLOYERS_LIABILITY_LIMITS
Business objects	clsPolicyPeriodEmployerLiabilityLimits, clsPolicyPeriodEmployerLiabilityLimitsCollection

Operations referencing this table

• Retrieve employers-liability limits

Business rules referencing this table

• BR-025: Per-period employers-liability limits must carry a valid statistical
• BR-033: New sequence values for writable entities are obtained

SQL referencing this table

• SQL-031: Policy Period Employer Liability Limits
• SQL-032: Policy Period Employer Liability Limits Collection
• SQL-089: Policy Period Employer Liability Limits
• SQL-090: Policy Period Employer Liability Limits Collection
• SQL-132: Policy Period Employer Liability Limits
• SQL-133: Policy Period Employer Liability Limits Collection
• SQL-153: Policy Period Employer Liability Limits
• SQL-154: Policy Period Employer Liability Limits Collection

---

POLICY_PERIOD_MASTER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Policy data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	CRUD
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	POLICY
Business objects	clsPolicy, clsPolicyPeriodMaster

Operations referencing this table

• Build a unified policy period timeline
• Retrieve a policy (optionally masked)

Business rules referencing this table

• BR-010: A policy's period history is the union of
• BR-020: When masking is requested, policyholder names, contact identity/contact-method

SQL referencing this table

• SQL-033: Policy Period Master
• SQL-071: Policy
• SQL-091: Policy Period Master
• SQL-134: Policy Period Master
• SQL-155: Policy Period Master

---

POLICY_PERIOD_NON_WCIS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Legacy Policy Period Collection data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	POLICY
Business objects	clsLegacyPolicyPeriodCollection

Operations referencing this table

• Build a unified policy period timeline

Business rules referencing this table

• BR-010: A policy's period history is the union of

SQL referencing this table

• SQL-063: Legacy Policy Period Collection

---

POLICY_PERIOD_STATUS_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Policy Period Status data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	POLICY_PERIOD
Business objects	clsPolicyPeriodStatus, clsPolicyPeriodStatusCollection

Operations referencing this table

• Classify period status

Business rules referencing this table

• 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

SQL referencing this table

• SQL-092: Policy Period Status
• SQL-093: Policy Period Status Collection

---

POLICY_STATUS_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Policy Status Code data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	POLICY
Business objects	clsPolicyStatusCode, clsPolicyStatusCodeCollection

Operations referencing this table

• Classify period status

Business rules referencing this table

• BR-027: A policy status code must be non-empty
• BR-028: A policy in application status raises a warning

SQL referencing this table

• SQL-094: Policy Status Code
• SQL-095: Policy Status Code Collection

---

POLICY_TEAM_FUNCTION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Policy Team Member data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	CRUD
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	POLICY, TEAM_FUNCTION_CODE, WCIS_EMPLOYEE
Business objects	clsPolicyTeamMember, clsPolicyTeamMemberCollection

Business rules referencing this table

• BR-033: New sequence values for writable entities are obtained

SQL referencing this table

• SQL-036: Policy Team Member
• SQL-037: Policy Team Member Collection
• SQL-098: Policy Team Member
• SQL-099: Policy Team Member Collection
• SQL-137: Policy Team Member
• SQL-138: Policy Team Member Collection
• SQL-158: Policy Team Member
• SQL-159: Policy Team Member Collection

---

PRIOR_COVERAGE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Prior Coverage data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	CRUD
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	POLICY
Business objects	clsPriorCoverage, clsPriorCoverageCollection

Business rules referencing this table

• BR-033: New sequence values for writable entities are obtained

SQL referencing this table

• SQL-038: Prior Coverage
• SQL-039: Prior Coverage Collection
• SQL-100: Prior Coverage
• SQL-101: Prior Coverage Collection
• SQL-139: Prior Coverage
• SQL-140: Prior Coverage Collection
• SQL-160: Prior Coverage
• SQL-161: Prior Coverage Collection

---

SUB_CONSTANTS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	W C I S Inquiry data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	N/A
Business objects	WCISInquiry

Operations referencing this table

• Determine standard premium for a period
• Determine whether a period is issued

Business rules referencing this table

• BR-032: Preliminary audit is required when the WCIS edit

SQL referencing this table

• SQL-106: W C I S Inquiry
• SQL-113: W C I S Inquiry

---

TEAM_FUNCTION_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Policy Team Function data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	CRUD
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	POLICY_TEAM_FUNCTION
Business objects	clsPolicyTeamFunction, clsPolicyTeamFunctionCollection

Business rules referencing this table

• BR-033: New sequence values for writable entities are obtained

SQL referencing this table

• SQL-034: Policy Team Function
• SQL-035: Policy Team Function Collection
• SQL-096: Policy Team Function
• SQL-097: Policy Team Function Collection
• SQL-135: Policy Team Function
• SQL-136: Policy Team Function Collection
• SQL-156: Policy Team Function
• SQL-157: Policy Team Function Collection

---

WCIS_CONSTANTS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	W C I S Inquiry data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	N/A
Business objects	WCISInquiry

Operations referencing this table

• Determine standard premium for a period
• Determine whether a period is issued

Business rules referencing this table

• BR-032: Preliminary audit is required when the WCIS edit

SQL referencing this table

• SQL-118: W C I S Inquiry

---

WCIS_EMPLOYEE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	W C I S Employee data used by policy-core SQL.*
Access pattern	Direct SQL
CRUD operations	CRUD
Key columns used	See linked SQL documents*
Sequence	N/A
Related tables	POLICY_TEAM_FUNCTION
Business objects	clsWCISEmployee, clsWCISEmployeeCollection

Business rules referencing this table

• BR-033: New sequence values for writable entities are obtained

SQL referencing this table

• SQL-042: W C I S Employee
• SQL-043: W C I S Employee Collection
• SQL-104: W C I S Employee
• SQL-105: W C I S Employee Collection
• SQL-143: W C I S Employee
• SQL-144: W C I S Employee Collection
• SQL-164: W C I S Employee
• SQL-165: W C I S Employee Collection

Table relationship diagram

The following diagram shows inferred relationships between tables used by this library.

erDiagram
    POLICY ||--o{ POLICY-PERIOD : "One-to-many"
    POLICY ||--o{ POLICY-PERIOD-NON-WCIS : "One-to-many"
    POLICY ||--o{ POLICY-PERIOD-MASTER : "One-to-many"
    POLICY ||--o{ CANCELLATION : "One-to-many"
    POLICY ||--o{ BUSINESS : "One-to-many"
    POLICY ||--o{ LOCATION : "One-to-many"
    POLICY ||--o{ NON-WCIS-STAT-TRANS : "One-to-many"
    POLICY ||--o{ POLICY-TEAM-FUNCTION : "One-to-many"
    POLICY ||--o{ PRIOR-COVERAGE : "One-to-many"
    POLICY-STATUS-CODE ||--o{ POLICY : "Lookup (one-to-many)"
    POLICY-PERIOD-STATUS-CODE ||--o{ POLICY-PERIOD : "Lookup (one-to-many)"
    POLICY-PERIOD ||--o{ POLICY-PERIOD-EMP-LIAB : "One-to-many"
    EMPLOYERS-LIABILITY-LIMITS ||--o{ POLICY-PERIOD-EMP-LIAB : "Lookup (one-to-many)"
    EMPLOYERS-LIABILITY-LIMITS-ELL ||--o{ EMPLOYERS-LIABILITY-LIMITS-FACTOR-ROWS-ELF : "One-to-many"
    LOCATION ||--o{ CONTACT : "One-to-many"
    LOCATION-CODE ||--o{ LOCATION : "Lookup (one-to-many)"
    OFFICE-CODE ||--o{ COUNTY : "Lookup (one-to-many)"
    OFFICE-CODE ||--o{ POLICY : "Lookup (one-to-many)"
    ENTITY-CODE ||--o{ POLICY : "Lookup (one-to-many)"
    CANCELLATION ||--o{ CANCEL-REASON-OVERRIDE : "One-to-many"
    CANCEL-REASON-CODE ||--o{ CANCELLATION : "Lookup (one-to-many)"
    CANCEL-REASON-CODE ||--o{ CANCEL-REASON-OVERRIDE : "Lookup (one-to-many)"
    CARRIER-CODE ||--o{ CANCELLATION : "Lookup (one-to-many)"
    CARRIER-CHANGE-REASON-CODE ||--o{ CANCELLATION : "Lookup (one-to-many)"
    TEAM-FUNCTION-CODE ||--o{ POLICY-TEAM-FUNCTION : "Lookup (one-to-many)"
    WCIS-EMPLOYEE ||--o{ POLICY-TEAM-FUNCTION : "Lookup (one-to-many)"

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• Procedures
• Configuration
• API reference

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\clsPolicyPeriod.vb
• Business\SAIF.Business.Policy.Core\clsLegacyPolicyPeriod.vb
• Business\SAIF.Business.Policy.Core\clsPolicyLocation.vb
• Business\SAIF.Business.Policy.Core\clsLocationContact.vb
• Business\SAIF.Business.Policy.Core\WCISInquiry.vb