SAIF.Data.NHibernate database tables

This page catalogs the 46 database tables accessed by this library's SQL, stored procedures, and LINQ repositories.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
ADDRESS	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by CollectionsRepository	CollectionsRepository
AFFILIATE	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by CollectionsRepository	CollectionsRepository
ANALYTICS_DB.dbo.CSG_CLM_SGMNTN_REQUEST_CLAIM	SQL Server	ANALYTICS_DB.dbo	C	Referenced by ClaimScoreRepository	ClaimScoreRepository
CLM_DBA.TEMP_DATA_PERSON_ADDRESS	Oracle	CLM_DBA	R	Referenced by CollectionsRepository	CollectionsRepository
COMPANY	Oracle / Oracle*	WCIS_DBA* (package owner; unqualified inside package); [unqualified]**	R	Referenced by CollectionsRepository, InvestigationRepositoryExtensions	CollectionsRepository
COMPANY_ADDRESS	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by CollectionsRepository	CollectionsRepository
dbo.CSG_ModelSeqNum (sequence)	SQL Server	dbo (analyticsDb)	R	Referenced by ClaimScoreRepository	ClaimScoreRepository
DEPT_REVENUE_SOIL_ADJUSTMENT	Oracle	WCIS_DBA* (package owner; unqualified inside package)	C	Referenced by CollectionsRepository	CollectionsRepository
DEPT_REVENUE_SOIL_BALANCE	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by CollectionsRepository	CollectionsRepository
EIS_PROD.dbo.WCS_POLICY	SQL Server	EIS_PROD.dbo	R	Referenced by ClaimScoreRepository	ClaimScoreRepository
EIS_STAGING.dbo.BDS_CTL_MESSAGES	SQL Server	EIS_STAGING.dbo	R	Referenced by ClaimScoreRepository	ClaimScoreRepository
group_association	Oracle*	[unqualified]**	R	Referenced by GroupRepository	GroupRepository
image	Oracle*	[unqualified]**	RU	Referenced by GroupImageRepository	GroupImageRepository
image_category_code	Oracle*	[unqualified]**	R	Referenced by ImageCategoryCodeRepository	ImageCategoryCodeRepository
image_document_type_code	Oracle*	[unqualified]**	R	Referenced by ImageCategoryCodeRepository	ImageCategoryCodeRepository
Image_Group	Oracle*	[unqualified]**	R	Referenced by GroupImageRepository	GroupImageRepository
INVESTIGATION	Oracle*	[unqualified]**	R	Referenced by InvestigationRepositoryExtensions	InvestigationRepositoryExtensions
LC_TRAN_CATEGORY_CODE	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by Collections.hbm.xml (no caller), CollectionsRepository	CollectionsRepository
LEGAL_COLLECTION	Oracle / Oracle*	WCIS_DBA* (package owner; unqualified inside package); [unqualified]**	R	Referenced by CollectionsRepository	CollectionsRepository
LEGAL_COLLECTION_CODE	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by CollectionsRepository	CollectionsRepository
LEGAL_COLLECTION_DEBTOR	Oracle / Oracle*	WCIS_DBA* (package owner; unqualified inside package); [unqualified]**	RU	Referenced by CollectionsRepository	CollectionsRepository
LEGAL_COLLECTION_PAYMENT_REF	Oracle	WCIS_DBA* (package owner; unqualified inside package)	C	Referenced by Collections.hbm.xml (no caller), CollectionsRepository	CollectionsRepository
LEGAL_COLLECTION_TRANSACTION	Oracle	WCIS_DBA* (package owner; unqualified inside package)	RU	Referenced by Collections.hbm.xml (no caller), CollectionsRepository	CollectionsRepository
LEGAL_COLLECTION_TRAN_CODE	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by Collections.hbm.xml (no caller), CollectionsRepository	CollectionsRepository
LOCATION	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by CollectionsRepository	CollectionsRepository
LOCATION_VIEW	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by CollectionsRepository	CollectionsRepository
MARKET_TYPE_CODE	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by CollectionsRepository	CollectionsRepository
output_document	Oracle*	[unqualified]**	R	Referenced by PolicyOutputDocumentRepository	PolicyOutputDocumentRepository
output_document_type_code	Oracle*	[unqualified]**	R	Referenced by PolicyOutputDocumentRepository	PolicyOutputDocumentRepository
PERSON	Oracle / Oracle*	WCIS_DBA* (package owner; unqualified inside package); [unqualified]**	R	Referenced by CollectionsRepository, InvestigationRepositoryExtensions	CollectionsRepository
PERSON_ADDRESS	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by CollectionsRepository	CollectionsRepository
PERSON_PHONE	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by CollectionsRepository	CollectionsRepository
PHONE	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by CollectionsRepository	CollectionsRepository
POLICY	Oracle / Oracle*	WCIS_DBA* (package owner; unqualified inside package); [unqualified]**	R	Referenced by CollectionsRepository, InvestigationRepositoryExtensions, PolicyOutputDocumentRepository	CollectionsRepository
POLICY_FINANCIAL_TRANS	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by CollectionsRepository	CollectionsRepository
policy_output_document	Oracle*	[unqualified]**	R	Referenced by PolicyOutputDocumentRepository	PolicyOutputDocumentRepository
POLICY_SEARCH	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by CollectionsRepository	CollectionsRepository
PROVIDER	Oracle*	[unqualified]**	R	Referenced by ProvidersRepository	ProvidersRepository
PROVIDER_ADDRESS	Oracle*	[unqualified]**	R	Referenced by ProvidersRepository	ProvidersRepository
PROVIDER_LOCATION	Oracle*	[unqualified]**	R	Referenced by InvestigationRepositoryExtensions, ProvidersRepository	InvestigationRepositoryExtensions
SOIL_DEBTOR_REFERENCE	Oracle / Oracle*	WCIS_DBA* (package owner; unqualified inside package); [unqualified]**	CR	Referenced by CollectionsRepository	CollectionsRepository
SUB_POLICY	Oracle*	[unqualified]**	R	Referenced by PolicyOutputDocumentRepository	PolicyOutputDocumentRepository
SUBJECT	Oracle*	[unqualified]**	R	Referenced by InvestigationRepositoryExtensions	InvestigationRepositoryExtensions
THRDPARTY	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by CollectionsRepository	CollectionsRepository
THRDPARTY_DISTRIBUTION	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by CollectionsRepository	CollectionsRepository
THRDPARTY_FIRM	Oracle	WCIS_DBA* (package owner; unqualified inside package)	R	Referenced by CollectionsRepository	CollectionsRepository

ADDRESS

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	None discovered*
Business objects	CollectionsRepository

Operations referencing ADDRESS

• Collections case lookups

Business rules referencing ADDRESS

• PROC-RULE-009

SQL referencing ADDRESS

• SQL-011: CollectionsRepository.GetThirdPartyAddress

---

AFFILIATE

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	None discovered*
Business objects	CollectionsRepository

Operations referencing AFFILIATE

• Collections case lookups
• SOIL (State of Oregon Intercept) processing

Business rules referencing AFFILIATE

• PROC-RULE-010
• PROC-RULE-011
• PROC-RULE-012
• PROC-RULE-013
• PROC-RULE-032
• PROC-RULE-038

SQL referencing AFFILIATE

• SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords
• SQL-006: CollectionsRepository.GetDebtorName
• SQL-007: CollectionsRepository.GetPrimaryDebtorName
• SQL-008: CollectionsRepository.GetDebtorSsn
• SQL-012: CollectionsRepository.SearchCollections

---

ANALYTICS_DB.dbo.CSG_CLM_SGMNTN_REQUEST_CLAIM

Field	Value
Database	SQL Server
Schema/Link	ANALYTICS_DB.dbo
Purpose	Referenced by ClaimScoreRepository
Access pattern	stored procedure
CRUD operations	Create
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	EIS_PROD.DBO.WCS_POLICY
Business objects	ClaimScoreRepository

Operations referencing ANALYTICS_DB.dbo.CSG_CLM_SGMNTN_REQUEST_CLAIM

• Claim score category

Business rules referencing ANALYTICS_DB.dbo.CSG_CLM_SGMNTN_REQUEST_CLAIM

• PROC-RULE-020
• PROC-RULE-024
• SDN-BR-020

SQL referencing ANALYTICS_DB.dbo.CSG_CLM_SGMNTN_REQUEST_CLAIM

• SQL-001: ClaimScoreRepository.GetClaimScoreCategory

---

CLM_DBA.TEMP_DATA_PERSON_ADDRESS

Field	Value
Database	Oracle
Schema/Link	CLM_DBA
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	None discovered*
Business objects	CollectionsRepository

Operations referencing CLM_DBA.TEMP_DATA_PERSON_ADDRESS

• Collections case lookups
• SOIL (State of Oregon Intercept) processing

Business rules referencing CLM_DBA.TEMP_DATA_PERSON_ADDRESS

• PROC-RULE-010
• PROC-RULE-011
• PROC-RULE-030
• PROC-RULE-031
• PROC-RULE-032
• PROC-RULE-038
• SDN-BR-011

SQL referencing CLM_DBA.TEMP_DATA_PERSON_ADDRESS

• SQL-002: CollectionsRepository.CreateSoilDebtorReferenceRecords
• SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords
• SQL-012: CollectionsRepository.SearchCollections

---

COMPANY

Field	Value
Database	Oracle / Oracle*
Schema/Link	WCIS_DBA* (package owner; unqualified inside package); [unqualified]**
Purpose	Referenced by CollectionsRepository, InvestigationRepositoryExtensions
Access pattern	direct SQL, stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	SUBJECT
Business objects	CollectionsRepository, InvestigationRepositoryExtensions

Operations referencing COMPANY

• Collections case lookups
• Investigation subject and claim

Business rules referencing COMPANY

• PROC-RULE-010
• PROC-RULE-011
• PROC-RULE-012
• SDN-BR-050

SQL referencing COMPANY

• SQL-006: CollectionsRepository.GetDebtorName
• SQL-007: CollectionsRepository.GetPrimaryDebtorName
• SQL-012: CollectionsRepository.SearchCollections
• SQL-032: InvestigationRepositoryExtensions.GetSubjectName

---

COMPANY_ADDRESS

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	None discovered*
Business objects	CollectionsRepository

Operations referencing COMPANY_ADDRESS

• Collections case lookups

Business rules referencing COMPANY_ADDRESS

• PROC-RULE-009

SQL referencing COMPANY_ADDRESS

• SQL-011: CollectionsRepository.GetThirdPartyAddress

---

dbo.CSG_ModelSeqNum (sequence)

Field	Value
Database	SQL Server
Schema/Link	dbo (analyticsDb)
Purpose	Referenced by ClaimScoreRepository
Access pattern	ORM (ClassMap only)*
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	CSG_ModelSeqNum
Related tables	None discovered*
Business objects	ClaimScoreRepository

---

DEPT_REVENUE_SOIL_ADJUSTMENT

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Create
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	DEPT_REVENUE_SOIL_BALANCE
Business objects	CollectionsRepository

Operations referencing DEPT_REVENUE_SOIL_ADJUSTMENT

• SOIL (State of Oregon Intercept) processing

Business rules referencing DEPT_REVENUE_SOIL_ADJUSTMENT

• PROC-RULE-032
• PROC-RULE-038

SQL referencing DEPT_REVENUE_SOIL_ADJUSTMENT

• SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords

---

DEPT_REVENUE_SOIL_BALANCE

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	DEPT_REVENUE_SOIL_ADJUSTMENT
Business objects	CollectionsRepository

Operations referencing DEPT_REVENUE_SOIL_BALANCE

• SOIL (State of Oregon Intercept) processing

Business rules referencing DEPT_REVENUE_SOIL_BALANCE

• PROC-RULE-032
• PROC-RULE-038

SQL referencing DEPT_REVENUE_SOIL_BALANCE

• SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords

---

EIS_PROD.dbo.WCS_POLICY

Field	Value
Database	SQL Server
Schema/Link	EIS_PROD.dbo
Purpose	Referenced by ClaimScoreRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	ANALYTICS_DB.DBO.CSG_CLM_SGMNTN_REQUEST_CLAIM
Business objects	ClaimScoreRepository

Operations referencing EIS_PROD.dbo.WCS_POLICY

• Claim score category

Business rules referencing EIS_PROD.dbo.WCS_POLICY

• PROC-RULE-020
• PROC-RULE-024
• SDN-BR-020

SQL referencing EIS_PROD.dbo.WCS_POLICY

• SQL-001: ClaimScoreRepository.GetClaimScoreCategory

---

EIS_STAGING.dbo.BDS_CTL_MESSAGES

Field	Value
Database	SQL Server
Schema/Link	EIS_STAGING.dbo
Purpose	Referenced by ClaimScoreRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	None discovered*
Business objects	ClaimScoreRepository

Operations referencing EIS_STAGING.dbo.BDS_CTL_MESSAGES

• Claim score category

Business rules referencing EIS_STAGING.dbo.BDS_CTL_MESSAGES

• PROC-RULE-020
• PROC-RULE-024
• SDN-BR-020

SQL referencing EIS_STAGING.dbo.BDS_CTL_MESSAGES

• SQL-001: ClaimScoreRepository.GetClaimScoreCategory

---

group_association

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Referenced by GroupRepository
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	image, Image_Group
Business objects	GroupRepository

Operations referencing group_association

• Group and category lookups

SQL referencing group_association

• SQL-026: GroupRepository.GroupFound
• SQL-027: GroupRepository.GetGroupOrDefault
• SQL-028: GroupRepository.GetGroup

---

image

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Referenced by GroupImageRepository
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read, Update
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	group_association, Image_Group
Business objects	GroupImageRepository

Operations referencing image

• Group image filtered search
• Group image soft delete

Business rules referencing image

• SDN-BR-040
• SDN-BR-041
• SDN-BR-042
• SDN-BR-043

SQL referencing image

• SQL-025: GroupImageRepository.GetFilteredImageGroups
• SQL-054: GroupImageRepository.Delete

---

image_category_code

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Referenced by ImageCategoryCodeRepository
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	image_document_type_code
Business objects	ImageCategoryCodeRepository

Operations referencing image_category_code

• Group and category lookups

Business rules referencing image_category_code

• SDN-BR-044

SQL referencing image_category_code

• SQL-029: ImageCategoryCodeRepository.ImageDocumentTypeFound
• SQL-030: ImageCategoryCodeRepository.GetDocumentTypeOrDefault
• SQL-031: ImageCategoryCodeRepository.GetImageCategoryCodes

---

image_document_type_code

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Referenced by ImageCategoryCodeRepository
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	image_category_code
Business objects	ImageCategoryCodeRepository

Operations referencing image_document_type_code

• Group and category lookups

Business rules referencing image_document_type_code

• SDN-BR-044

SQL referencing image_document_type_code

• SQL-029: ImageCategoryCodeRepository.ImageDocumentTypeFound
• SQL-030: ImageCategoryCodeRepository.GetDocumentTypeOrDefault

---

Image_Group

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Referenced by GroupImageRepository
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	group_association, image
Business objects	GroupImageRepository

Operations referencing Image_Group

• Group image filtered search
• Group image soft delete

Business rules referencing Image_Group

• SDN-BR-041
• SDN-BR-042
• SDN-BR-043

SQL referencing Image_Group

• SQL-022: GroupImageRepository.ImageFound
• SQL-023: GroupImageRepository.GetImageGroup
• SQL-024: GroupImageRepository.GetImageGroupOrDefault
• SQL-025: GroupImageRepository.GetFilteredImageGroups
• SQL-054: GroupImageRepository.Delete

---

INVESTIGATION

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Referenced by InvestigationRepositoryExtensions
Access pattern	direct SQL
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	POLICY, PROVIDER_LOCATION, SUBJECT
Business objects	InvestigationRepositoryExtensions

Operations referencing INVESTIGATION

• Investigation subject and claim

Business rules referencing INVESTIGATION

• SDN-BR-050

SQL referencing INVESTIGATION

• SQL-032: InvestigationRepositoryExtensions.GetSubjectName
• SQL-033: InvestigationRepositoryExtensions.GetClaimId

---

LC_TRAN_CATEGORY_CODE

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by Collections.hbm.xml (no caller), CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	LEGAL_COLLECTION_TRAN_CODE
Business objects	Collections.hbm.xml (no caller), CollectionsRepository

Operations referencing LC_TRAN_CATEGORY_CODE

• Collections case lookups
• Collections payment application

Business rules referencing LC_TRAN_CATEGORY_CODE

• PROC-RULE-003
• PROC-RULE-006
• PROC-RULE-025
• PROC-RULE-028
• SDN-BR-010

SQL referencing LC_TRAN_CATEGORY_CODE

• SQL-005: CollectionsRepository.GetCategoryTotals
• SQL-052: PK80010_LEGAL_COLLECTIONS.APPLYPAYMENTS (unused, no caller)
• SQL-053: CollectionsRepository.ApplyPayments

---

LEGAL_COLLECTION

Field	Value
Database	Oracle / Oracle*
Schema/Link	WCIS_DBA* (package owner; unqualified inside package); [unqualified]**
Purpose	Referenced by CollectionsRepository
Access pattern	direct SQL, stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	LEGAL_COLLECTION_CODE, LEGAL_COLLECTION_DEBTOR, LEGAL_COLLECTION_PAYMENT_REF, LEGAL_COLLECTION_TRANSACTION, POLICY
Business objects	CollectionsRepository

Operations referencing LEGAL_COLLECTION

• Collections case lookups
• Collections interest and payment selection
• SOIL (State of Oregon Intercept) processing

Business rules referencing LEGAL_COLLECTION

• PROC-RULE-001
• PROC-RULE-002
• PROC-RULE-003
• PROC-RULE-006
• PROC-RULE-008
• PROC-RULE-010
• PROC-RULE-011
• PROC-RULE-012
• PROC-RULE-013
• PROC-RULE-014
• PROC-RULE-017
• PROC-RULE-018
• PROC-RULE-019
• PROC-RULE-030
• PROC-RULE-031
• PROC-RULE-032
• PROC-RULE-038
• SDN-BR-011
• SDN-BR-012

SQL referencing LEGAL_COLLECTION

• SQL-002: CollectionsRepository.CreateSoilDebtorReferenceRecords
• SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords
• SQL-004: CollectionsRepository.GetCasesByReferenceNumber
• SQL-005: CollectionsRepository.GetCategoryTotals
• SQL-006: CollectionsRepository.GetDebtorName
• SQL-007: CollectionsRepository.GetPrimaryDebtorName
• SQL-008: CollectionsRepository.GetDebtorSsn
• SQL-010: CollectionsRepository.GetPolicyAddress
• SQL-012: CollectionsRepository.SearchCollections
• SQL-013: CollectionsRepository.GetInterest
• SQL-014: CollectionsRepository.GetMissingPolicyPayments
• SQL-015: CollectionsRepository.GetThirdPartyPayments
• SQL-016: CollectionsRepository.DebtorsWithoutPayments
• SQL-017: CollectionsRepository.DebtorsWithExpiredLocs
• SQL-018: CollectionsRepository.BalanceBroughtToMinAmountTransactions
• SQL-019: CollectionsRepository.GetWorkerIdForDebtors
• SQL-020: CollectionsRepository.GetWorkerIdForSoilTrans

---

LEGAL_COLLECTION_CODE

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	LEGAL_COLLECTION
Business objects	CollectionsRepository

Operations referencing LEGAL_COLLECTION_CODE

• Collections case lookups

Business rules referencing LEGAL_COLLECTION_CODE

• PROC-RULE-001
• PROC-RULE-002

SQL referencing LEGAL_COLLECTION_CODE

• SQL-004: CollectionsRepository.GetCasesByReferenceNumber

---

LEGAL_COLLECTION_DEBTOR

Field	Value
Database	Oracle / Oracle*
Schema/Link	WCIS_DBA* (package owner; unqualified inside package); [unqualified]**
Purpose	Referenced by CollectionsRepository
Access pattern	direct SQL, stored procedure
CRUD operations	Read / Update
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	LEGAL_COLLECTION, LOCATION, SOIL_DEBTOR_REFERENCE, THRDPARTY
Business objects	CollectionsRepository

Operations referencing LEGAL_COLLECTION_DEBTOR

• Collections case lookups
• Collections interest and payment selection
• SOIL (State of Oregon Intercept) processing

Business rules referencing LEGAL_COLLECTION_DEBTOR

• PROC-RULE-008
• PROC-RULE-010
• PROC-RULE-011
• PROC-RULE-012
• PROC-RULE-013
• PROC-RULE-017
• PROC-RULE-018
• PROC-RULE-019
• PROC-RULE-030
• PROC-RULE-031
• PROC-RULE-032
• PROC-RULE-038
• SDN-BR-011
• SDN-BR-012

SQL referencing LEGAL_COLLECTION_DEBTOR

• SQL-002: CollectionsRepository.CreateSoilDebtorReferenceRecords
• SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords
• SQL-006: CollectionsRepository.GetDebtorName
• SQL-007: CollectionsRepository.GetPrimaryDebtorName
• SQL-008: CollectionsRepository.GetDebtorSsn
• SQL-010: CollectionsRepository.GetPolicyAddress
• SQL-012: CollectionsRepository.SearchCollections
• SQL-015: CollectionsRepository.GetThirdPartyPayments
• SQL-016: CollectionsRepository.DebtorsWithoutPayments
• SQL-017: CollectionsRepository.DebtorsWithExpiredLocs
• SQL-019: CollectionsRepository.GetWorkerIdForDebtors
• SQL-020: CollectionsRepository.GetWorkerIdForSoilTrans
• SQL-021: CollectionsRepository.DebtorLastStatementBalance

---

LEGAL_COLLECTION_PAYMENT_REF

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by Collections.hbm.xml (no caller), CollectionsRepository
Access pattern	stored procedure
CRUD operations	Create
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	LEGAL_COLLECTION, LEGAL_COLLECTION_TRANSACTION
Business objects	Collections.hbm.xml (no caller), CollectionsRepository

Operations referencing LEGAL_COLLECTION_PAYMENT_REF

• Collections payment application

Business rules referencing LEGAL_COLLECTION_PAYMENT_REF

• PROC-RULE-025
• PROC-RULE-028
• SDN-BR-010

SQL referencing LEGAL_COLLECTION_PAYMENT_REF

• SQL-052: PK80010_LEGAL_COLLECTIONS.APPLYPAYMENTS (unused, no caller)
• SQL-053: CollectionsRepository.ApplyPayments

---

LEGAL_COLLECTION_TRANSACTION

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by Collections.hbm.xml (no caller), CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read / Update
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	LEGAL_COLLECTION, LEGAL_COLLECTION_PAYMENT_REF, LEGAL_COLLECTION_TRAN_CODE
Business objects	Collections.hbm.xml (no caller), CollectionsRepository

Operations referencing LEGAL_COLLECTION_TRANSACTION

• Collections case lookups
• Collections interest and payment selection
• Collections payment application

Business rules referencing LEGAL_COLLECTION_TRANSACTION

• PROC-RULE-003
• PROC-RULE-006
• PROC-RULE-014
• PROC-RULE-017
• PROC-RULE-018
• PROC-RULE-019
• PROC-RULE-025
• PROC-RULE-028
• SDN-BR-010

SQL referencing LEGAL_COLLECTION_TRANSACTION

• SQL-005: CollectionsRepository.GetCategoryTotals
• SQL-013: CollectionsRepository.GetInterest
• SQL-014: CollectionsRepository.GetMissingPolicyPayments
• SQL-016: CollectionsRepository.DebtorsWithoutPayments
• SQL-018: CollectionsRepository.BalanceBroughtToMinAmountTransactions
• SQL-021: CollectionsRepository.DebtorLastStatementBalance
• SQL-052: PK80010_LEGAL_COLLECTIONS.APPLYPAYMENTS (unused, no caller)
• SQL-053: CollectionsRepository.ApplyPayments

---

LEGAL_COLLECTION_TRAN_CODE

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by Collections.hbm.xml (no caller), CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	LC_TRAN_CATEGORY_CODE, LEGAL_COLLECTION_TRANSACTION
Business objects	Collections.hbm.xml (no caller), CollectionsRepository

Operations referencing LEGAL_COLLECTION_TRAN_CODE

• Collections case lookups
• Collections payment application

Business rules referencing LEGAL_COLLECTION_TRAN_CODE

• PROC-RULE-003
• PROC-RULE-006
• PROC-RULE-017
• PROC-RULE-025
• PROC-RULE-028
• SDN-BR-010

SQL referencing LEGAL_COLLECTION_TRAN_CODE

• SQL-005: CollectionsRepository.GetCategoryTotals
• SQL-021: CollectionsRepository.DebtorLastStatementBalance
• SQL-052: PK80010_LEGAL_COLLECTIONS.APPLYPAYMENTS (unused, no caller)
• SQL-053: CollectionsRepository.ApplyPayments

---

LOCATION

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	LEGAL_COLLECTION_DEBTOR
Business objects	CollectionsRepository

Operations referencing LOCATION

• Collections case lookups
• Collections interest and payment selection

Business rules referencing LOCATION

• PROC-RULE-008
• PROC-RULE-019

SQL referencing LOCATION

• SQL-010: CollectionsRepository.GetPolicyAddress
• SQL-017: CollectionsRepository.DebtorsWithExpiredLocs

---

LOCATION_VIEW

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	None discovered*
Business objects	CollectionsRepository

Operations referencing LOCATION_VIEW

• Collections case lookups

Business rules referencing LOCATION_VIEW

• PROC-RULE-007

SQL referencing LOCATION_VIEW

• SQL-009: CollectionsRepository.GetFraudOtherAddress

---

MARKET_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	POLICY
Business objects	CollectionsRepository

Operations referencing MARKET_TYPE_CODE

• Collections case lookups

Business rules referencing MARKET_TYPE_CODE

• PROC-RULE-010
• PROC-RULE-011

SQL referencing MARKET_TYPE_CODE

• SQL-012: CollectionsRepository.SearchCollections

---

output_document

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Referenced by PolicyOutputDocumentRepository
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	POLICY, policy_output_document, output_document_type_code, SUB_POLICY
Business objects	PolicyOutputDocumentRepository

Operations referencing output_document

• Policy output documents

Business rules referencing output_document

• SDN-BR-060
• SDN-BR-061
• SDN-BR-062
• SDN-BR-063

SQL referencing output_document

• SQL-036: PolicyOutputDocumentRepository.GetUnReleasedDocumentsPriorToDate
• SQL-038: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsBySourceKeyText
• SQL-039: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsByImageId
• SQL-041: PolicyOutputDocumentRepository.GetReleasedAgencyViewablePolicyOutputDocuments
• SQL-042: PolicyOutputDocumentRepository.GetHeldAndPendingAgencyViewablePolicyOutputDocuments
• SQL-043: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsForInbox
• SQL-044: PolicyOutputDocumentRepository.GetPolicyOutputDocuments
• SQL-045: PolicyOutputDocumentRepository.CheckDocumentExist
• SQL-046: PolicyOutputDocumentRepository.GetReleasedAgencyViewableChildOutputDocuments

---

output_document_type_code

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Referenced by PolicyOutputDocumentRepository
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	POLICY, policy_output_document, output_document, SUB_POLICY
Business objects	PolicyOutputDocumentRepository

Operations referencing output_document_type_code

• Policy output documents

Business rules referencing output_document_type_code

• SDN-BR-060
• SDN-BR-061
• SDN-BR-062

SQL referencing output_document_type_code

• SQL-036: PolicyOutputDocumentRepository.GetUnReleasedDocumentsPriorToDate
• SQL-038: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsBySourceKeyText
• SQL-039: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsByImageId
• SQL-041: PolicyOutputDocumentRepository.GetReleasedAgencyViewablePolicyOutputDocuments
• SQL-042: PolicyOutputDocumentRepository.GetHeldAndPendingAgencyViewablePolicyOutputDocuments
• SQL-043: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsForInbox
• SQL-044: PolicyOutputDocumentRepository.GetPolicyOutputDocuments
• SQL-046: PolicyOutputDocumentRepository.GetReleasedAgencyViewableChildOutputDocuments

---

PERSON

Field	Value
Database	Oracle / Oracle*
Schema/Link	WCIS_DBA* (package owner; unqualified inside package); [unqualified]**
Purpose	Referenced by CollectionsRepository, InvestigationRepositoryExtensions
Access pattern	direct SQL, stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	SUBJECT
Business objects	CollectionsRepository, InvestigationRepositoryExtensions

Operations referencing PERSON

• Collections case lookups
• Investigation subject and claim
• SOIL (State of Oregon Intercept) processing

Business rules referencing PERSON

• PROC-RULE-010
• PROC-RULE-011
• PROC-RULE-012
• PROC-RULE-013
• PROC-RULE-030
• PROC-RULE-031
• PROC-RULE-032
• PROC-RULE-038
• SDN-BR-011
• SDN-BR-050

SQL referencing PERSON

• SQL-002: CollectionsRepository.CreateSoilDebtorReferenceRecords
• SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords
• SQL-006: CollectionsRepository.GetDebtorName
• SQL-007: CollectionsRepository.GetPrimaryDebtorName
• SQL-008: CollectionsRepository.GetDebtorSsn
• SQL-012: CollectionsRepository.SearchCollections
• SQL-032: InvestigationRepositoryExtensions.GetSubjectName

---

PERSON_ADDRESS

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	None discovered*
Business objects	CollectionsRepository

Operations referencing PERSON_ADDRESS

• Collections case lookups

Business rules referencing PERSON_ADDRESS

• PROC-RULE-009

SQL referencing PERSON_ADDRESS

• SQL-011: CollectionsRepository.GetThirdPartyAddress

---

PERSON_PHONE

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	None discovered*
Business objects	CollectionsRepository

Operations referencing PERSON_PHONE

• Collections case lookups

Business rules referencing PERSON_PHONE

• PROC-RULE-009

SQL referencing PERSON_PHONE

• SQL-011: CollectionsRepository.GetThirdPartyAddress

---

PHONE

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	None discovered*
Business objects	CollectionsRepository

Operations referencing PHONE

• Collections case lookups

Business rules referencing PHONE

• PROC-RULE-009

SQL referencing PHONE

• SQL-011: CollectionsRepository.GetThirdPartyAddress

---

POLICY

Field	Value
Database	Oracle / Oracle*
Schema/Link	WCIS_DBA* (package owner; unqualified inside package); [unqualified]**
Purpose	Referenced by CollectionsRepository, InvestigationRepositoryExtensions, PolicyOutputDocumentRepository
Access pattern	ORM (NHibernate LINQ), direct SQL, stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	INVESTIGATION, LEGAL_COLLECTION, MARKET_TYPE_CODE, POLICY, output_document, output_document_type_code, policy_output_document, SUB_POLICY
Business objects	CollectionsRepository, InvestigationRepositoryExtensions, PolicyOutputDocumentRepository

Operations referencing POLICY

• Collections case lookups
• Investigation subject and claim
• Policy output documents

Business rules referencing POLICY

• PROC-RULE-001
• PROC-RULE-002
• PROC-RULE-010
• PROC-RULE-011
• PROC-RULE-012
• SDN-BR-050
• SDN-BR-060
• SDN-BR-061
• SDN-BR-062
• SDN-BR-063

SQL referencing POLICY

• SQL-004: CollectionsRepository.GetCasesByReferenceNumber
• SQL-006: CollectionsRepository.GetDebtorName
• SQL-007: CollectionsRepository.GetPrimaryDebtorName
• SQL-012: CollectionsRepository.SearchCollections
• SQL-032: InvestigationRepositoryExtensions.GetSubjectName
• SQL-036: PolicyOutputDocumentRepository.GetUnReleasedDocumentsPriorToDate
• SQL-038: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsBySourceKeyText
• SQL-039: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsByImageId
• SQL-041: PolicyOutputDocumentRepository.GetReleasedAgencyViewablePolicyOutputDocuments
• SQL-042: PolicyOutputDocumentRepository.GetHeldAndPendingAgencyViewablePolicyOutputDocuments
• SQL-043: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsForInbox
• SQL-044: PolicyOutputDocumentRepository.GetPolicyOutputDocuments
• SQL-045: PolicyOutputDocumentRepository.CheckDocumentExist
• SQL-046: PolicyOutputDocumentRepository.GetReleasedAgencyViewableChildOutputDocuments
• SQL-047: PolicyOutputDocumentRepository.GetAccountNumber

---

POLICY_FINANCIAL_TRANS

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	None discovered*
Business objects	CollectionsRepository

Operations referencing POLICY_FINANCIAL_TRANS

• Collections interest and payment selection

Business rules referencing POLICY_FINANCIAL_TRANS

• PROC-RULE-018

SQL referencing POLICY_FINANCIAL_TRANS

• SQL-014: CollectionsRepository.GetMissingPolicyPayments

---

policy_output_document

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Referenced by PolicyOutputDocumentRepository
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	output_document, output_document_type_code, POLICY, SUB_POLICY
Business objects	PolicyOutputDocumentRepository

Operations referencing policy_output_document

• Policy output documents

Business rules referencing policy_output_document

• SDN-BR-060
• SDN-BR-061
• SDN-BR-062
• SDN-BR-063

SQL referencing policy_output_document

• SQL-036: PolicyOutputDocumentRepository.GetUnReleasedDocumentsPriorToDate
• SQL-037: PolicyOutputDocumentRepository.GetPolicyOutputDocument
• SQL-038: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsBySourceKeyText
• SQL-039: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsByImageId
• SQL-040: PolicyOutputDocumentRepository.GetHeldDocumentsForNotification
• SQL-041: PolicyOutputDocumentRepository.GetReleasedAgencyViewablePolicyOutputDocuments
• SQL-042: PolicyOutputDocumentRepository.GetHeldAndPendingAgencyViewablePolicyOutputDocuments
• SQL-043: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsForInbox
• SQL-044: PolicyOutputDocumentRepository.GetPolicyOutputDocuments
• SQL-045: PolicyOutputDocumentRepository.CheckDocumentExist
• SQL-046: PolicyOutputDocumentRepository.GetReleasedAgencyViewableChildOutputDocuments

---

POLICY_SEARCH

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	None discovered*
Business objects	CollectionsRepository

Operations referencing POLICY_SEARCH

• Collections case lookups

Business rules referencing POLICY_SEARCH

• PROC-RULE-010
• PROC-RULE-011

SQL referencing POLICY_SEARCH

• SQL-012: CollectionsRepository.SearchCollections

---

PROVIDER

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Referenced by ProvidersRepository
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	None discovered*
Business objects	ProvidersRepository

Operations referencing PROVIDER

• Provider address retrieval

Business rules referencing PROVIDER

• SDN-BR-030
• SDN-BR-031

SQL referencing PROVIDER

• SQL-048: ProvidersRepository.GetProviderByTaxIdBatch

---

PROVIDER_ADDRESS

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Referenced by ProvidersRepository
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	PROVIDER_LOCATION
Business objects	ProvidersRepository

Operations referencing PROVIDER_ADDRESS

• Provider address retrieval

Business rules referencing PROVIDER_ADDRESS

• SDN-BR-030
• SDN-BR-031

SQL referencing PROVIDER_ADDRESS

• SQL-049: ProvidersRepository.GetProviderAddresses

---

PROVIDER_LOCATION

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Referenced by InvestigationRepositoryExtensions, ProvidersRepository
Access pattern	ORM (NHibernate LINQ), direct SQL
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	INVESTIGATION, PROVIDER_ADDRESS
Business objects	InvestigationRepositoryExtensions, ProvidersRepository

Operations referencing PROVIDER_LOCATION

• Investigation subject and claim
• Provider address retrieval

Business rules referencing PROVIDER_LOCATION

• SDN-BR-030
• SDN-BR-031
• SDN-BR-050

SQL referencing PROVIDER_LOCATION

• SQL-032: InvestigationRepositoryExtensions.GetSubjectName
• SQL-049: ProvidersRepository.GetProviderAddresses

---

SOIL_DEBTOR_REFERENCE

Field	Value
Database	Oracle / Oracle*
Schema/Link	WCIS_DBA* (package owner; unqualified inside package); [unqualified]**
Purpose	Referenced by CollectionsRepository
Access pattern	direct SQL, stored procedure
CRUD operations	Create / Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	LEGAL_COLLECTION_DEBTOR
Business objects	CollectionsRepository

Operations referencing SOIL_DEBTOR_REFERENCE

• SOIL (State of Oregon Intercept) processing

Business rules referencing SOIL_DEBTOR_REFERENCE

• PROC-RULE-030
• PROC-RULE-031
• PROC-RULE-032
• PROC-RULE-038
• SDN-BR-011
• SDN-BR-012

SQL referencing SOIL_DEBTOR_REFERENCE

• SQL-002: CollectionsRepository.CreateSoilDebtorReferenceRecords
• SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords
• SQL-020: CollectionsRepository.GetWorkerIdForSoilTrans

---

SUB_POLICY

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Referenced by PolicyOutputDocumentRepository
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	POLICY, policy_output_document, output_document, output_document_type_code
Business objects	PolicyOutputDocumentRepository

Operations referencing SUB_POLICY

• Policy output documents

Business rules referencing SUB_POLICY

• SDN-BR-060
• SDN-BR-061
• SDN-BR-062

SQL referencing SUB_POLICY

• SQL-036: PolicyOutputDocumentRepository.GetUnReleasedDocumentsPriorToDate
• SQL-038: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsBySourceKeyText
• SQL-039: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsByImageId
• SQL-041: PolicyOutputDocumentRepository.GetReleasedAgencyViewablePolicyOutputDocuments
• SQL-042: PolicyOutputDocumentRepository.GetHeldAndPendingAgencyViewablePolicyOutputDocuments
• SQL-043: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsForInbox
• SQL-044: PolicyOutputDocumentRepository.GetPolicyOutputDocuments

---

SUBJECT

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Referenced by InvestigationRepositoryExtensions
Access pattern	direct SQL
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	COMPANY, INVESTIGATION, PERSON
Business objects	InvestigationRepositoryExtensions

Operations referencing SUBJECT

• Investigation subject and claim

Business rules referencing SUBJECT

• SDN-BR-050

SQL referencing SUBJECT

• SQL-032: InvestigationRepositoryExtensions.GetSubjectName

---

THRDPARTY

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	LEGAL_COLLECTION_DEBTOR, THRDPARTY_FIRM
Business objects	CollectionsRepository

Operations referencing THRDPARTY

• Collections case lookups
• Collections interest and payment selection
• SOIL (State of Oregon Intercept) processing

Business rules referencing THRDPARTY

• PROC-RULE-009
• PROC-RULE-010
• PROC-RULE-011
• PROC-RULE-012
• PROC-RULE-013
• PROC-RULE-018
• PROC-RULE-030
• PROC-RULE-031
• PROC-RULE-032
• PROC-RULE-038
• SDN-BR-011

SQL referencing THRDPARTY

• SQL-002: CollectionsRepository.CreateSoilDebtorReferenceRecords
• SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords
• SQL-006: CollectionsRepository.GetDebtorName
• SQL-007: CollectionsRepository.GetPrimaryDebtorName
• SQL-008: CollectionsRepository.GetDebtorSsn
• SQL-011: CollectionsRepository.GetThirdPartyAddress
• SQL-012: CollectionsRepository.SearchCollections
• SQL-015: CollectionsRepository.GetThirdPartyPayments

---

THRDPARTY_DISTRIBUTION

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	None discovered*
Business objects	CollectionsRepository

Operations referencing THRDPARTY_DISTRIBUTION

• Collections interest and payment selection

Business rules referencing THRDPARTY_DISTRIBUTION

• PROC-RULE-018

SQL referencing THRDPARTY_DISTRIBUTION

• SQL-015: CollectionsRepository.GetThirdPartyPayments

---

THRDPARTY_FIRM

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA* (package owner; unqualified inside package)
Purpose	Referenced by CollectionsRepository
Access pattern	stored procedure
CRUD operations	Read
Key columns used	See join columns in Sample SQL of referencing SQL documents**
Sequence	N/A
Related tables	THRDPARTY
Business objects	CollectionsRepository

Operations referencing THRDPARTY_FIRM

• Collections case lookups

Business rules referencing THRDPARTY_FIRM

• PROC-RULE-009
• PROC-RULE-010
• PROC-RULE-011
• PROC-RULE-012

SQL referencing THRDPARTY_FIRM

• SQL-006: CollectionsRepository.GetDebtorName
• SQL-007: CollectionsRepository.GetPrimaryDebtorName
• SQL-011: CollectionsRepository.GetThirdPartyAddress
• SQL-012: CollectionsRepository.SearchCollections

---

Table relationship diagram

The following diagram shows relationships discovered between the tables used by this library, drawn from explicit SQL/procedure joins and ClassMap References/HasMany declarations restricted to this library's 46 accessed tables.

erDiagram
    INVESTIGATION ||--o{ SUBJECT : "many-to-one"
    PERSON ||--o{ SUBJECT : "one-to-many"
    COMPANY ||--o{ SUBJECT : "one-to-many"
    PROVIDER_LOCATION ||--o{ INVESTIGATION : "one-to-many"
    POLICY ||--o{ INVESTIGATION : "one-to-many"
    LEGAL_COLLECTION ||--o{ LEGAL_COLLECTION_DEBTOR : "one-to-many"
    LEGAL_COLLECTION_DEBTOR ||--o{ SOIL_DEBTOR_REFERENCE : "one-to-many"
    LEGAL_COLLECTION ||--o{ LEGAL_COLLECTION_TRANSACTION : "one-to-many"
    LEGAL_COLLECTION_TRAN_CODE ||--o{ LEGAL_COLLECTION_TRANSACTION : "one-to-many"
    LEGAL_COLLECTION_TRANSACTION ||--o{ LEGAL_COLLECTION_PAYMENT_REF : "one-to-many"
    POLICY ||--o{ LEGAL_COLLECTION : "one-to-many"
    THRDPARTY ||--o{ LEGAL_COLLECTION_DEBTOR : "one-to-many"
    LOCATION ||--o{ LEGAL_COLLECTION_DEBTOR : "one-to-many"
    DEPT_REVENUE_SOIL_BALANCE ||--o{ DEPT_REVENUE_SOIL_ADJUSTMENT : "one-to-many"
    EIS_PROD_DBO_WCS_POLICY ||--o{ ANALYTICS_DB_DBO_CSG_CLM_SGMNTN_REQUEST_CLAIM : "one-to-many*"
    GROUP_ASSOCIATION ||--o{ IMAGE_GROUP : "one-to-many"
    IMAGE_GROUP ||--o{ IMAGE : "one-to-many"
    IMAGE_CATEGORY_CODE ||--o{ IMAGE_DOCUMENT_TYPE_CODE : "one-to-many"
    LC_TRAN_CATEGORY_CODE ||--o{ LEGAL_COLLECTION_TRAN_CODE : "one-to-many"
    LEGAL_COLLECTION ||--o{ LEGAL_COLLECTION_PAYMENT_REF : "one-to-many"
    LEGAL_COLLECTION_CODE ||--o{ LEGAL_COLLECTION : "one-to-many"
    MARKET_TYPE_CODE ||--o{ POLICY : "one-to-many"
    OUTPUT_DOCUMENT ||--o{ POLICY_OUTPUT_DOCUMENT : "one-to-many"
    OUTPUT_DOCUMENT_TYPE_CODE ||--o{ OUTPUT_DOCUMENT : "one-to-many"
    POLICY ||--o{ POLICY : "one-to-many"
    POLICY ||--o{ POLICY_OUTPUT_DOCUMENT : "one-to-many"
    POLICY ||--o{ SUB_POLICY : "one-to-many"
    POLICY_OUTPUT_DOCUMENT ||--o{ OUTPUT_DOCUMENT : "one-to-many"
    PROVIDER_LOCATION ||--o{ PROVIDER_ADDRESS : "one-to-many"
    THRDPARTY_FIRM ||--o{ THRDPARTY : "one-to-many"

Related documentation

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

Sources

• Data/SAIF.Data.NHibernate/Mappings/**