--- title: "Database tables" summary: Database tables used by SAIF.Data.NHibernate with relationships and usage context status: draft owner: SAIF.Core documentation team last_reviewed: 2026-09-24 library: SAIF.Data.NHibernate reference_type: package --- # 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](#address) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | R | Referenced by CollectionsRepository | `CollectionsRepository` | | [AFFILIATE](#affiliate) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | R | Referenced by CollectionsRepository | `CollectionsRepository` | | [ANALYTICS_DB.dbo.CSG_CLM_SGMNTN_REQUEST_CLAIM](#analytics_db.dbo.csg_clm_sgmntn_request_claim) | SQL Server | ANALYTICS_DB.dbo | C | Referenced by ClaimScoreRepository | `ClaimScoreRepository` | | [CLM_DBA.TEMP_DATA_PERSON_ADDRESS](#clm_dba.temp_data_person_address) | Oracle | CLM_DBA | R | Referenced by CollectionsRepository | `CollectionsRepository` | | [COMPANY](#company) | Oracle / Oracle* | WCIS_DBA* (package owner; unqualified inside package); [unqualified]** | R | Referenced by CollectionsRepository, InvestigationRepositoryExtensions | `CollectionsRepository` | | [COMPANY_ADDRESS](#company_address) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | R | Referenced by CollectionsRepository | `CollectionsRepository` | | [dbo.CSG_ModelSeqNum (sequence)](<#dbo.csg_modelseqnum-(sequence)>) | SQL Server | dbo (analyticsDb) | R | Referenced by ClaimScoreRepository | `ClaimScoreRepository` | | [DEPT_REVENUE_SOIL_ADJUSTMENT](#dept_revenue_soil_adjustment) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | C | Referenced by CollectionsRepository | `CollectionsRepository` | | [DEPT_REVENUE_SOIL_BALANCE](#dept_revenue_soil_balance) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | R | Referenced by CollectionsRepository | `CollectionsRepository` | | [EIS_PROD.dbo.WCS_POLICY](#eis_prod.dbo.wcs_policy) | SQL Server | EIS_PROD.dbo | R | Referenced by ClaimScoreRepository | `ClaimScoreRepository` | | [EIS_STAGING.dbo.BDS_CTL_MESSAGES](#eis_staging.dbo.bds_ctl_messages) | SQL Server | EIS_STAGING.dbo | R | Referenced by ClaimScoreRepository | `ClaimScoreRepository` | | [group_association](#group_association) | Oracle* | [unqualified]** | R | Referenced by GroupRepository | `GroupRepository` | | [image](#image) | Oracle* | [unqualified]** | RU | Referenced by GroupImageRepository | `GroupImageRepository` | | [image_category_code](#image_category_code) | Oracle* | [unqualified]** | R | Referenced by ImageCategoryCodeRepository | `ImageCategoryCodeRepository` | | [image_document_type_code](#image_document_type_code) | Oracle* | [unqualified]** | R | Referenced by ImageCategoryCodeRepository | `ImageCategoryCodeRepository` | | [Image_Group](#image_group) | Oracle* | [unqualified]** | R | Referenced by GroupImageRepository | `GroupImageRepository` | | [INVESTIGATION](#investigation) | Oracle* | [unqualified]** | R | Referenced by InvestigationRepositoryExtensions | `InvestigationRepositoryExtensions` | | [LC_TRAN_CATEGORY_CODE](#lc_tran_category_code) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | R | Referenced by Collections.hbm.xml (no caller), CollectionsRepository | `CollectionsRepository` | | [LEGAL_COLLECTION](#legal_collection) | Oracle / Oracle* | WCIS_DBA* (package owner; unqualified inside package); [unqualified]** | R | Referenced by CollectionsRepository | `CollectionsRepository` | | [LEGAL_COLLECTION_CODE](#legal_collection_code) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | R | Referenced by CollectionsRepository | `CollectionsRepository` | | [LEGAL_COLLECTION_DEBTOR](#legal_collection_debtor) | Oracle / Oracle* | WCIS_DBA* (package owner; unqualified inside package); [unqualified]** | RU | Referenced by CollectionsRepository | `CollectionsRepository` | | [LEGAL_COLLECTION_PAYMENT_REF](#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](#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](#legal_collection_tran_code) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | R | Referenced by Collections.hbm.xml (no caller), CollectionsRepository | `CollectionsRepository` | | [LOCATION](#location) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | R | Referenced by CollectionsRepository | `CollectionsRepository` | | [LOCATION_VIEW](#location_view) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | R | Referenced by CollectionsRepository | `CollectionsRepository` | | [MARKET_TYPE_CODE](#market_type_code) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | R | Referenced by CollectionsRepository | `CollectionsRepository` | | [output_document](#output_document) | Oracle* | [unqualified]** | R | Referenced by PolicyOutputDocumentRepository | `PolicyOutputDocumentRepository` | | [output_document_type_code](#output_document_type_code) | Oracle* | [unqualified]** | R | Referenced by PolicyOutputDocumentRepository | `PolicyOutputDocumentRepository` | | [PERSON](#person) | Oracle / Oracle* | WCIS_DBA* (package owner; unqualified inside package); [unqualified]** | R | Referenced by CollectionsRepository, InvestigationRepositoryExtensions | `CollectionsRepository` | | [PERSON_ADDRESS](#person_address) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | R | Referenced by CollectionsRepository | `CollectionsRepository` | | [PERSON_PHONE](#person_phone) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | R | Referenced by CollectionsRepository | `CollectionsRepository` | | [PHONE](#phone) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | R | Referenced by CollectionsRepository | `CollectionsRepository` | | [POLICY](#policy) | Oracle / Oracle* | WCIS_DBA* (package owner; unqualified inside package); [unqualified]** | R | Referenced by CollectionsRepository, InvestigationRepositoryExtensions, PolicyOutputDocumentRepository | `CollectionsRepository` | | [POLICY_FINANCIAL_TRANS](#policy_financial_trans) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | R | Referenced by CollectionsRepository | `CollectionsRepository` | | [policy_output_document](#policy_output_document) | Oracle* | [unqualified]** | R | Referenced by PolicyOutputDocumentRepository | `PolicyOutputDocumentRepository` | | [POLICY_SEARCH](#policy_search) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | R | Referenced by CollectionsRepository | `CollectionsRepository` | | [PROVIDER](#provider) | Oracle* | [unqualified]** | R | Referenced by ProvidersRepository | `ProvidersRepository` | | [PROVIDER_ADDRESS](#provider_address) | Oracle* | [unqualified]** | R | Referenced by ProvidersRepository | `ProvidersRepository` | | [PROVIDER_LOCATION](#provider_location) | Oracle* | [unqualified]** | R | Referenced by InvestigationRepositoryExtensions, ProvidersRepository | `InvestigationRepositoryExtensions` | | [SOIL_DEBTOR_REFERENCE](#soil_debtor_reference) | Oracle / Oracle* | WCIS_DBA* (package owner; unqualified inside package); [unqualified]** | CR | Referenced by CollectionsRepository | `CollectionsRepository` | | [SUB_POLICY](#sub_policy) | Oracle* | [unqualified]** | R | Referenced by PolicyOutputDocumentRepository | `PolicyOutputDocumentRepository` | | [SUBJECT](#subject) | Oracle* | [unqualified]** | R | Referenced by InvestigationRepositoryExtensions | `InvestigationRepositoryExtensions` | | [THRDPARTY](#thrdparty) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | R | Referenced by CollectionsRepository | `CollectionsRepository` | | [THRDPARTY_DISTRIBUTION](#thrdparty_distribution) | Oracle | WCIS_DBA* (package owner; unqualified inside package) | R | Referenced by CollectionsRepository | `CollectionsRepository` | | [THRDPARTY_FIRM](#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](operations/collections-case-lookups.md) ### Business rules referencing ADDRESS - [PROC-RULE-009](business-rules.md#proc-rule-009-third-party-contact-sources) ### SQL referencing ADDRESS - [SQL-011: CollectionsRepository.GetThirdPartyAddress](sql/SQL-011-collections-repository-get-third-party-address.md) --- ## 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](operations/collections-case-lookups.md) - [SOIL (State of Oregon Intercept) processing](operations/soil-processing.md) ### Business rules referencing AFFILIATE - [PROC-RULE-010](business-rules.md#proc-rule-010-closed-cases-are-hidden-unless-requested) - [PROC-RULE-011](business-rules.md#proc-rule-011-search-branch-selection) - [PROC-RULE-012](business-rules.md#proc-rule-012-debtor-name-resolution-order) - [PROC-RULE-013](business-rules.md#proc-rule-013-debtor-ssn-source) - [PROC-RULE-032](business-rules.md#proc-rule-032-balances-are-summed-per-ssn) - [PROC-RULE-038](business-rules.md#proc-rule-038-dropped-debtors-are-deleted-at-dor) ### SQL referencing AFFILIATE - [SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords](sql/SQL-003-collections-repository-create-soil-adjustment-records.md) - [SQL-006: CollectionsRepository.GetDebtorName](sql/SQL-006-collections-repository-get-debtor-name.md) - [SQL-007: CollectionsRepository.GetPrimaryDebtorName](sql/SQL-007-collections-repository-get-primary-debtor-name.md) - [SQL-008: CollectionsRepository.GetDebtorSsn](sql/SQL-008-collections-repository-get-debtor-ssn.md) - [SQL-012: CollectionsRepository.SearchCollections](sql/SQL-012-collections-repository-search-collections.md) --- ## 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](operations/claim-score-category.md) ### Business rules referencing ANALYTICS_DB.dbo.CSG_CLM_SGMNTN_REQUEST_CLAIM - [PROC-RULE-020](business-rules.md#proc-rule-020-each-request-gets-a-new-model-sequence-number) - [PROC-RULE-024](business-rules.md#proc-rule-024-failure-notification) - [SDN-BR-020](business-rules.md#sdn-br-020-claim-complexity%2Fsegmentation-score-is-computed-by-the-sql-server-procedure-bp_clm_segmntn_complexity_score) ### SQL referencing ANALYTICS_DB.dbo.CSG_CLM_SGMNTN_REQUEST_CLAIM - [SQL-001: ClaimScoreRepository.GetClaimScoreCategory](sql/SQL-001-claim-score-repository-get-claim-score-category.md) --- ## 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](operations/collections-case-lookups.md) - [SOIL (State of Oregon Intercept) processing](operations/soil-processing.md) ### Business rules referencing CLM_DBA.TEMP_DATA_PERSON_ADDRESS - [PROC-RULE-010](business-rules.md#proc-rule-010-closed-cases-are-hidden-unless-requested) - [PROC-RULE-011](business-rules.md#proc-rule-011-search-branch-selection) - [PROC-RULE-030](business-rules.md#proc-rule-030-soil-eligibility) - [PROC-RULE-031](business-rules.md#proc-rule-031-audit-user) - [PROC-RULE-032](business-rules.md#proc-rule-032-balances-are-summed-per-ssn) - [PROC-RULE-038](business-rules.md#proc-rule-038-dropped-debtors-are-deleted-at-dor) - [SDN-BR-011](business-rules.md#sdn-br-011-soil-debtor-eligibility%3A-balance-%E2%89%A5-0%2C-include-on-soil-flag-'y'%2C-no-third-party%2C-worker-id-present) ### SQL referencing CLM_DBA.TEMP_DATA_PERSON_ADDRESS - [SQL-002: CollectionsRepository.CreateSoilDebtorReferenceRecords](sql/SQL-002-collections-repository-create-soil-debtor-reference-records.md) - [SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords](sql/SQL-003-collections-repository-create-soil-adjustment-records.md) - [SQL-012: CollectionsRepository.SearchCollections](sql/SQL-012-collections-repository-search-collections.md) --- ## 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](operations/collections-case-lookups.md) - [Investigation subject and claim](operations/investigation-subject-and-claim.md) ### Business rules referencing COMPANY - [PROC-RULE-010](business-rules.md#proc-rule-010-closed-cases-are-hidden-unless-requested) - [PROC-RULE-011](business-rules.md#proc-rule-011-search-branch-selection) - [PROC-RULE-012](business-rules.md#proc-rule-012-debtor-name-resolution-order) - [SDN-BR-050](business-rules.md#sdn-br-050-investigation-subject-name-resolves-via-person%2C-company-or-provider-location%2C-with-nvl-fallbacks) ### SQL referencing COMPANY - [SQL-006: CollectionsRepository.GetDebtorName](sql/SQL-006-collections-repository-get-debtor-name.md) - [SQL-007: CollectionsRepository.GetPrimaryDebtorName](sql/SQL-007-collections-repository-get-primary-debtor-name.md) - [SQL-012: CollectionsRepository.SearchCollections](sql/SQL-012-collections-repository-search-collections.md) - [SQL-032: InvestigationRepositoryExtensions.GetSubjectName](sql/SQL-032-investigation-repository-extensions-get-subject-name.md) --- ## 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](operations/collections-case-lookups.md) ### Business rules referencing COMPANY_ADDRESS - [PROC-RULE-009](business-rules.md#proc-rule-009-third-party-contact-sources) ### SQL referencing COMPANY_ADDRESS - [SQL-011: CollectionsRepository.GetThirdPartyAddress](sql/SQL-011-collections-repository-get-third-party-address.md) --- ## 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](operations/soil-processing.md) ### Business rules referencing DEPT_REVENUE_SOIL_ADJUSTMENT - [PROC-RULE-032](business-rules.md#proc-rule-032-balances-are-summed-per-ssn) - [PROC-RULE-038](business-rules.md#proc-rule-038-dropped-debtors-are-deleted-at-dor) ### SQL referencing DEPT_REVENUE_SOIL_ADJUSTMENT - [SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords](sql/SQL-003-collections-repository-create-soil-adjustment-records.md) --- ## 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](operations/soil-processing.md) ### Business rules referencing DEPT_REVENUE_SOIL_BALANCE - [PROC-RULE-032](business-rules.md#proc-rule-032-balances-are-summed-per-ssn) - [PROC-RULE-038](business-rules.md#proc-rule-038-dropped-debtors-are-deleted-at-dor) ### SQL referencing DEPT_REVENUE_SOIL_BALANCE - [SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords](sql/SQL-003-collections-repository-create-soil-adjustment-records.md) --- ## 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](operations/claim-score-category.md) ### Business rules referencing EIS_PROD.dbo.WCS_POLICY - [PROC-RULE-020](business-rules.md#proc-rule-020-each-request-gets-a-new-model-sequence-number) - [PROC-RULE-024](business-rules.md#proc-rule-024-failure-notification) - [SDN-BR-020](business-rules.md#sdn-br-020-claim-complexity%2Fsegmentation-score-is-computed-by-the-sql-server-procedure-bp_clm_segmntn_complexity_score) ### SQL referencing EIS_PROD.dbo.WCS_POLICY - [SQL-001: ClaimScoreRepository.GetClaimScoreCategory](sql/SQL-001-claim-score-repository-get-claim-score-category.md) --- ## 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](operations/claim-score-category.md) ### Business rules referencing EIS_STAGING.dbo.BDS_CTL_MESSAGES - [PROC-RULE-020](business-rules.md#proc-rule-020-each-request-gets-a-new-model-sequence-number) - [PROC-RULE-024](business-rules.md#proc-rule-024-failure-notification) - [SDN-BR-020](business-rules.md#sdn-br-020-claim-complexity%2Fsegmentation-score-is-computed-by-the-sql-server-procedure-bp_clm_segmntn_complexity_score) ### SQL referencing EIS_STAGING.dbo.BDS_CTL_MESSAGES - [SQL-001: ClaimScoreRepository.GetClaimScoreCategory](sql/SQL-001-claim-score-repository-get-claim-score-category.md) --- ## 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](operations/group-and-category-lookups.md) ### SQL referencing group_association - [SQL-026: GroupRepository.GroupFound](sql/SQL-026-group-repository-group-found.md) - [SQL-027: GroupRepository.GetGroupOrDefault](sql/SQL-027-group-repository-get-group-or-default.md) - [SQL-028: GroupRepository.GetGroup](sql/SQL-028-group-repository-get-group.md) --- ## 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](operations/group-image-filtered-search.md) - [Group image soft delete](operations/group-image-soft-delete.md) ### Business rules referencing image - [SDN-BR-040](business-rules.md#sdn-br-040-group-image-delete-is-a-soft-delete) - [SDN-BR-041](business-rules.md#sdn-br-041-filter-sentinels-%22---%22) - [SDN-BR-042](business-rules.md#sdn-br-042-deleted-images-are-visible-only-to-users-permitted-to-see-deleted-images) - [SDN-BR-043](business-rules.md#sdn-br-043-confidential-images-are-visible-only-to-users-permitted-to-see-confidential-images) ### SQL referencing image - [SQL-025: GroupImageRepository.GetFilteredImageGroups](sql/SQL-025-group-image-repository-get-filtered-image-groups.md) - [SQL-054: GroupImageRepository.Delete](sql/SQL-054-group-image-repository-delete.md) --- ## 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](operations/group-and-category-lookups.md) ### Business rules referencing image_category_code - [SDN-BR-044](business-rules.md#sdn-br-044-group-image-categories-are-those-with-file-code-%22group%22) ### SQL referencing image_category_code - [SQL-029: ImageCategoryCodeRepository.ImageDocumentTypeFound](sql/SQL-029-image-category-code-repository-image-document-type-found.md) - [SQL-030: ImageCategoryCodeRepository.GetDocumentTypeOrDefault](sql/SQL-030-image-category-code-repository-get-document-type-or-default.md) - [SQL-031: ImageCategoryCodeRepository.GetImageCategoryCodes](sql/SQL-031-image-category-code-repository-get-image-category-codes.md) --- ## 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](operations/group-and-category-lookups.md) ### Business rules referencing image_document_type_code - [SDN-BR-044](business-rules.md#sdn-br-044-group-image-categories-are-those-with-file-code-%22group%22) ### SQL referencing image_document_type_code - [SQL-029: ImageCategoryCodeRepository.ImageDocumentTypeFound](sql/SQL-029-image-category-code-repository-image-document-type-found.md) - [SQL-030: ImageCategoryCodeRepository.GetDocumentTypeOrDefault](sql/SQL-030-image-category-code-repository-get-document-type-or-default.md) --- ## 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](operations/group-image-filtered-search.md) - [Group image soft delete](operations/group-image-soft-delete.md) ### Business rules referencing Image_Group - [SDN-BR-041](business-rules.md#sdn-br-041-filter-sentinels-%22---%22) - [SDN-BR-042](business-rules.md#sdn-br-042-deleted-images-are-visible-only-to-users-permitted-to-see-deleted-images) - [SDN-BR-043](business-rules.md#sdn-br-043-confidential-images-are-visible-only-to-users-permitted-to-see-confidential-images) ### SQL referencing Image_Group - [SQL-022: GroupImageRepository.ImageFound](sql/SQL-022-group-image-repository-image-found.md) - [SQL-023: GroupImageRepository.GetImageGroup](sql/SQL-023-group-image-repository-get-image-group.md) - [SQL-024: GroupImageRepository.GetImageGroupOrDefault](sql/SQL-024-group-image-repository-get-image-group-or-default.md) - [SQL-025: GroupImageRepository.GetFilteredImageGroups](sql/SQL-025-group-image-repository-get-filtered-image-groups.md) - [SQL-054: GroupImageRepository.Delete](sql/SQL-054-group-image-repository-delete.md) --- ## 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](operations/investigation-subject-and-claim.md) ### Business rules referencing INVESTIGATION - [SDN-BR-050](business-rules.md#sdn-br-050-investigation-subject-name-resolves-via-person%2C-company-or-provider-location%2C-with-nvl-fallbacks) ### SQL referencing INVESTIGATION - [SQL-032: InvestigationRepositoryExtensions.GetSubjectName](sql/SQL-032-investigation-repository-extensions-get-subject-name.md) - [SQL-033: InvestigationRepositoryExtensions.GetClaimId](sql/SQL-033-investigation-repository-extensions-get-claim-id.md) --- ## 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](operations/collections-case-lookups.md) - [Collections payment application](operations/collections-payment-application.md) ### Business rules referencing LC_TRAN_CATEGORY_CODE - [PROC-RULE-003](business-rules.md#proc-rule-003-payments-and-credit-adjustments-are-shown-negative) - [PROC-RULE-006](business-rules.md#proc-rule-006-judgment-description-source) - [PROC-RULE-025](business-rules.md#proc-rule-025-only-unapplied-payments-are-applied) - [PROC-RULE-028](business-rules.md#proc-rule-028-the-payment-keeps-the-unapplied-remainder) - [SDN-BR-010](business-rules.md#sdn-br-010-collection-case-payments-are-applied-by-the-oracle-package-applypayments-for-the-case-and-payment-date) ### SQL referencing LC_TRAN_CATEGORY_CODE - [SQL-005: CollectionsRepository.GetCategoryTotals](sql/SQL-005-collections-repository-get-category-totals.md) - [SQL-052: PK80010_LEGAL_COLLECTIONS.APPLYPAYMENTS (unused, no caller)](sql/SQL-052-applypayments-unused.md) - [SQL-053: CollectionsRepository.ApplyPayments](sql/SQL-053-collections-repository-apply-payments.md) --- ## 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](operations/collections-case-lookups.md) - [Collections interest and payment selection](operations/collections-interest-and-payment-selection.md) - [SOIL (State of Oregon Intercept) processing](operations/soil-processing.md) ### Business rules referencing LEGAL_COLLECTION - [PROC-RULE-001](business-rules.md#proc-rule-001-numeric-references-match-case-id%2C-policy-number-or-claim-number) - [PROC-RULE-002](business-rules.md#proc-rule-002-non-numeric-references) - [PROC-RULE-003](business-rules.md#proc-rule-003-payments-and-credit-adjustments-are-shown-negative) - [PROC-RULE-006](business-rules.md#proc-rule-006-judgment-description-source) - [PROC-RULE-008](business-rules.md#proc-rule-008-debtor-location-precedence) - [PROC-RULE-010](business-rules.md#proc-rule-010-closed-cases-are-hidden-unless-requested) - [PROC-RULE-011](business-rules.md#proc-rule-011-search-branch-selection) - [PROC-RULE-012](business-rules.md#proc-rule-012-debtor-name-resolution-order) - [PROC-RULE-013](business-rules.md#proc-rule-013-debtor-ssn-source) - [PROC-RULE-014](business-rules.md#proc-rule-014-'all'-selects-every-case) - [PROC-RULE-017](business-rules.md#proc-rule-017-interest-start-date-and-statement-balance) - [PROC-RULE-018](business-rules.md#proc-rule-018-unposted-payments-for-open-cases) - [PROC-RULE-019](business-rules.md#proc-rule-019-statement-and-follow-up-selection) - [PROC-RULE-030](business-rules.md#proc-rule-030-soil-eligibility) - [PROC-RULE-031](business-rules.md#proc-rule-031-audit-user) - [PROC-RULE-032](business-rules.md#proc-rule-032-balances-are-summed-per-ssn) - [PROC-RULE-038](business-rules.md#proc-rule-038-dropped-debtors-are-deleted-at-dor) - [SDN-BR-011](business-rules.md#sdn-br-011-soil-debtor-eligibility%3A-balance-%E2%89%A5-0%2C-include-on-soil-flag-'y'%2C-no-third-party%2C-worker-id-present) - [SDN-BR-012](business-rules.md#sdn-br-012-soil-transactions-are-selected-by-the-truncated-create-date) ### SQL referencing LEGAL_COLLECTION - [SQL-002: CollectionsRepository.CreateSoilDebtorReferenceRecords](sql/SQL-002-collections-repository-create-soil-debtor-reference-records.md) - [SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords](sql/SQL-003-collections-repository-create-soil-adjustment-records.md) - [SQL-004: CollectionsRepository.GetCasesByReferenceNumber](sql/SQL-004-collections-repository-get-cases-by-reference-number.md) - [SQL-005: CollectionsRepository.GetCategoryTotals](sql/SQL-005-collections-repository-get-category-totals.md) - [SQL-006: CollectionsRepository.GetDebtorName](sql/SQL-006-collections-repository-get-debtor-name.md) - [SQL-007: CollectionsRepository.GetPrimaryDebtorName](sql/SQL-007-collections-repository-get-primary-debtor-name.md) - [SQL-008: CollectionsRepository.GetDebtorSsn](sql/SQL-008-collections-repository-get-debtor-ssn.md) - [SQL-010: CollectionsRepository.GetPolicyAddress](sql/SQL-010-collections-repository-get-policy-address.md) - [SQL-012: CollectionsRepository.SearchCollections](sql/SQL-012-collections-repository-search-collections.md) - [SQL-013: CollectionsRepository.GetInterest](sql/SQL-013-collections-repository-get-interest.md) - [SQL-014: CollectionsRepository.GetMissingPolicyPayments](sql/SQL-014-collections-repository-get-missing-policy-payments.md) - [SQL-015: CollectionsRepository.GetThirdPartyPayments](sql/SQL-015-collections-repository-get-third-party-payments.md) - [SQL-016: CollectionsRepository.DebtorsWithoutPayments](sql/SQL-016-collections-repository-debtors-without-payments.md) - [SQL-017: CollectionsRepository.DebtorsWithExpiredLocs](sql/SQL-017-collections-repository-debtors-with-expired-locs.md) - [SQL-018: CollectionsRepository.BalanceBroughtToMinAmountTransactions](sql/SQL-018-collections-repository-balance-brought-to-min-amount-transactions.md) - [SQL-019: CollectionsRepository.GetWorkerIdForDebtors](sql/SQL-019-collections-repository-get-worker-id-for-debtors.md) - [SQL-020: CollectionsRepository.GetWorkerIdForSoilTrans](sql/SQL-020-collections-repository-get-worker-id-for-soil-trans.md) --- ## 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](operations/collections-case-lookups.md) ### Business rules referencing LEGAL_COLLECTION_CODE - [PROC-RULE-001](business-rules.md#proc-rule-001-numeric-references-match-case-id%2C-policy-number-or-claim-number) - [PROC-RULE-002](business-rules.md#proc-rule-002-non-numeric-references) ### SQL referencing LEGAL_COLLECTION_CODE - [SQL-004: CollectionsRepository.GetCasesByReferenceNumber](sql/SQL-004-collections-repository-get-cases-by-reference-number.md) --- ## 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](operations/collections-case-lookups.md) - [Collections interest and payment selection](operations/collections-interest-and-payment-selection.md) - [SOIL (State of Oregon Intercept) processing](operations/soil-processing.md) ### Business rules referencing LEGAL_COLLECTION_DEBTOR - [PROC-RULE-008](business-rules.md#proc-rule-008-debtor-location-precedence) - [PROC-RULE-010](business-rules.md#proc-rule-010-closed-cases-are-hidden-unless-requested) - [PROC-RULE-011](business-rules.md#proc-rule-011-search-branch-selection) - [PROC-RULE-012](business-rules.md#proc-rule-012-debtor-name-resolution-order) - [PROC-RULE-013](business-rules.md#proc-rule-013-debtor-ssn-source) - [PROC-RULE-017](business-rules.md#proc-rule-017-interest-start-date-and-statement-balance) - [PROC-RULE-018](business-rules.md#proc-rule-018-unposted-payments-for-open-cases) - [PROC-RULE-019](business-rules.md#proc-rule-019-statement-and-follow-up-selection) - [PROC-RULE-030](business-rules.md#proc-rule-030-soil-eligibility) - [PROC-RULE-031](business-rules.md#proc-rule-031-audit-user) - [PROC-RULE-032](business-rules.md#proc-rule-032-balances-are-summed-per-ssn) - [PROC-RULE-038](business-rules.md#proc-rule-038-dropped-debtors-are-deleted-at-dor) - [SDN-BR-011](business-rules.md#sdn-br-011-soil-debtor-eligibility%3A-balance-%E2%89%A5-0%2C-include-on-soil-flag-'y'%2C-no-third-party%2C-worker-id-present) - [SDN-BR-012](business-rules.md#sdn-br-012-soil-transactions-are-selected-by-the-truncated-create-date) ### SQL referencing LEGAL_COLLECTION_DEBTOR - [SQL-002: CollectionsRepository.CreateSoilDebtorReferenceRecords](sql/SQL-002-collections-repository-create-soil-debtor-reference-records.md) - [SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords](sql/SQL-003-collections-repository-create-soil-adjustment-records.md) - [SQL-006: CollectionsRepository.GetDebtorName](sql/SQL-006-collections-repository-get-debtor-name.md) - [SQL-007: CollectionsRepository.GetPrimaryDebtorName](sql/SQL-007-collections-repository-get-primary-debtor-name.md) - [SQL-008: CollectionsRepository.GetDebtorSsn](sql/SQL-008-collections-repository-get-debtor-ssn.md) - [SQL-010: CollectionsRepository.GetPolicyAddress](sql/SQL-010-collections-repository-get-policy-address.md) - [SQL-012: CollectionsRepository.SearchCollections](sql/SQL-012-collections-repository-search-collections.md) - [SQL-015: CollectionsRepository.GetThirdPartyPayments](sql/SQL-015-collections-repository-get-third-party-payments.md) - [SQL-016: CollectionsRepository.DebtorsWithoutPayments](sql/SQL-016-collections-repository-debtors-without-payments.md) - [SQL-017: CollectionsRepository.DebtorsWithExpiredLocs](sql/SQL-017-collections-repository-debtors-with-expired-locs.md) - [SQL-019: CollectionsRepository.GetWorkerIdForDebtors](sql/SQL-019-collections-repository-get-worker-id-for-debtors.md) - [SQL-020: CollectionsRepository.GetWorkerIdForSoilTrans](sql/SQL-020-collections-repository-get-worker-id-for-soil-trans.md) - [SQL-021: CollectionsRepository.DebtorLastStatementBalance](sql/SQL-021-collections-repository-debtor-last-statement-balance.md) --- ## 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](operations/collections-payment-application.md) ### Business rules referencing LEGAL_COLLECTION_PAYMENT_REF - [PROC-RULE-025](business-rules.md#proc-rule-025-only-unapplied-payments-are-applied) - [PROC-RULE-028](business-rules.md#proc-rule-028-the-payment-keeps-the-unapplied-remainder) - [SDN-BR-010](business-rules.md#sdn-br-010-collection-case-payments-are-applied-by-the-oracle-package-applypayments-for-the-case-and-payment-date) ### SQL referencing LEGAL_COLLECTION_PAYMENT_REF - [SQL-052: PK80010_LEGAL_COLLECTIONS.APPLYPAYMENTS (unused, no caller)](sql/SQL-052-applypayments-unused.md) - [SQL-053: CollectionsRepository.ApplyPayments](sql/SQL-053-collections-repository-apply-payments.md) --- ## 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](operations/collections-case-lookups.md) - [Collections interest and payment selection](operations/collections-interest-and-payment-selection.md) - [Collections payment application](operations/collections-payment-application.md) ### Business rules referencing LEGAL_COLLECTION_TRANSACTION - [PROC-RULE-003](business-rules.md#proc-rule-003-payments-and-credit-adjustments-are-shown-negative) - [PROC-RULE-006](business-rules.md#proc-rule-006-judgment-description-source) - [PROC-RULE-014](business-rules.md#proc-rule-014-'all'-selects-every-case) - [PROC-RULE-017](business-rules.md#proc-rule-017-interest-start-date-and-statement-balance) - [PROC-RULE-018](business-rules.md#proc-rule-018-unposted-payments-for-open-cases) - [PROC-RULE-019](business-rules.md#proc-rule-019-statement-and-follow-up-selection) - [PROC-RULE-025](business-rules.md#proc-rule-025-only-unapplied-payments-are-applied) - [PROC-RULE-028](business-rules.md#proc-rule-028-the-payment-keeps-the-unapplied-remainder) - [SDN-BR-010](business-rules.md#sdn-br-010-collection-case-payments-are-applied-by-the-oracle-package-applypayments-for-the-case-and-payment-date) ### SQL referencing LEGAL_COLLECTION_TRANSACTION - [SQL-005: CollectionsRepository.GetCategoryTotals](sql/SQL-005-collections-repository-get-category-totals.md) - [SQL-013: CollectionsRepository.GetInterest](sql/SQL-013-collections-repository-get-interest.md) - [SQL-014: CollectionsRepository.GetMissingPolicyPayments](sql/SQL-014-collections-repository-get-missing-policy-payments.md) - [SQL-016: CollectionsRepository.DebtorsWithoutPayments](sql/SQL-016-collections-repository-debtors-without-payments.md) - [SQL-018: CollectionsRepository.BalanceBroughtToMinAmountTransactions](sql/SQL-018-collections-repository-balance-brought-to-min-amount-transactions.md) - [SQL-021: CollectionsRepository.DebtorLastStatementBalance](sql/SQL-021-collections-repository-debtor-last-statement-balance.md) - [SQL-052: PK80010_LEGAL_COLLECTIONS.APPLYPAYMENTS (unused, no caller)](sql/SQL-052-applypayments-unused.md) - [SQL-053: CollectionsRepository.ApplyPayments](sql/SQL-053-collections-repository-apply-payments.md) --- ## 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](operations/collections-case-lookups.md) - [Collections payment application](operations/collections-payment-application.md) ### Business rules referencing LEGAL_COLLECTION_TRAN_CODE - [PROC-RULE-003](business-rules.md#proc-rule-003-payments-and-credit-adjustments-are-shown-negative) - [PROC-RULE-006](business-rules.md#proc-rule-006-judgment-description-source) - [PROC-RULE-017](business-rules.md#proc-rule-017-interest-start-date-and-statement-balance) - [PROC-RULE-025](business-rules.md#proc-rule-025-only-unapplied-payments-are-applied) - [PROC-RULE-028](business-rules.md#proc-rule-028-the-payment-keeps-the-unapplied-remainder) - [SDN-BR-010](business-rules.md#sdn-br-010-collection-case-payments-are-applied-by-the-oracle-package-applypayments-for-the-case-and-payment-date) ### SQL referencing LEGAL_COLLECTION_TRAN_CODE - [SQL-005: CollectionsRepository.GetCategoryTotals](sql/SQL-005-collections-repository-get-category-totals.md) - [SQL-021: CollectionsRepository.DebtorLastStatementBalance](sql/SQL-021-collections-repository-debtor-last-statement-balance.md) - [SQL-052: PK80010_LEGAL_COLLECTIONS.APPLYPAYMENTS (unused, no caller)](sql/SQL-052-applypayments-unused.md) - [SQL-053: CollectionsRepository.ApplyPayments](sql/SQL-053-collections-repository-apply-payments.md) --- ## 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](operations/collections-case-lookups.md) - [Collections interest and payment selection](operations/collections-interest-and-payment-selection.md) ### Business rules referencing LOCATION - [PROC-RULE-008](business-rules.md#proc-rule-008-debtor-location-precedence) - [PROC-RULE-019](business-rules.md#proc-rule-019-statement-and-follow-up-selection) ### SQL referencing LOCATION - [SQL-010: CollectionsRepository.GetPolicyAddress](sql/SQL-010-collections-repository-get-policy-address.md) - [SQL-017: CollectionsRepository.DebtorsWithExpiredLocs](sql/SQL-017-collections-repository-debtors-with-expired-locs.md) --- ## 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](operations/collections-case-lookups.md) ### Business rules referencing LOCATION_VIEW - [PROC-RULE-007](business-rules.md#proc-rule-007-foreign-address-flag) ### SQL referencing LOCATION_VIEW - [SQL-009: CollectionsRepository.GetFraudOtherAddress](sql/SQL-009-collections-repository-get-fraud-other-address.md) --- ## 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](operations/collections-case-lookups.md) ### Business rules referencing MARKET_TYPE_CODE - [PROC-RULE-010](business-rules.md#proc-rule-010-closed-cases-are-hidden-unless-requested) - [PROC-RULE-011](business-rules.md#proc-rule-011-search-branch-selection) ### SQL referencing MARKET_TYPE_CODE - [SQL-012: CollectionsRepository.SearchCollections](sql/SQL-012-collections-repository-search-collections.md) --- ## 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](operations/policy-output-documents.md) ### Business rules referencing output_document - [SDN-BR-060](business-rules.md#sdn-br-060-agency-inbox%3A-unread-%3D-not-viewed-and-not-agency-deleted) - [SDN-BR-061](business-rules.md#sdn-br-061-agencies-see-only-released%2C-agency-viewable-documents) - [SDN-BR-062](business-rules.md#sdn-br-062-category-%22all%22-or-blank-means-no-filter) - [SDN-BR-063](business-rules.md#sdn-br-063-child-documents-are-returned-only-for-a-released-parent) ### SQL referencing output_document - [SQL-036: PolicyOutputDocumentRepository.GetUnReleasedDocumentsPriorToDate](sql/SQL-036-policy-output-document-repository-get-un-released-documents-prior-to-date.md) - [SQL-038: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsBySourceKeyText](sql/SQL-038-policy-output-document-repository-get-policy-output-documents-by-source-key-text.md) - [SQL-039: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsByImageId](sql/SQL-039-policy-output-document-repository-get-policy-output-documents-by-image-id.md) - [SQL-041: PolicyOutputDocumentRepository.GetReleasedAgencyViewablePolicyOutputDocuments](sql/SQL-041-policy-output-document-repository-get-released-agency-viewable-policy-output-documents.md) - [SQL-042: PolicyOutputDocumentRepository.GetHeldAndPendingAgencyViewablePolicyOutputDocuments](sql/SQL-042-policy-output-document-repository-get-held-and-pending-agency-viewable-policy-output-documents.md) - [SQL-043: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsForInbox](sql/SQL-043-policy-output-document-repository-get-policy-output-documents-for-inbox.md) - [SQL-044: PolicyOutputDocumentRepository.GetPolicyOutputDocuments](sql/SQL-044-policy-output-document-repository-get-policy-output-documents.md) - [SQL-045: PolicyOutputDocumentRepository.CheckDocumentExist](sql/SQL-045-policy-output-document-repository-check-document-exist.md) - [SQL-046: PolicyOutputDocumentRepository.GetReleasedAgencyViewableChildOutputDocuments](sql/SQL-046-policy-output-document-repository-get-released-agency-viewable-child-output-documents.md) --- ## 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](operations/policy-output-documents.md) ### Business rules referencing output_document_type_code - [SDN-BR-060](business-rules.md#sdn-br-060-agency-inbox%3A-unread-%3D-not-viewed-and-not-agency-deleted) - [SDN-BR-061](business-rules.md#sdn-br-061-agencies-see-only-released%2C-agency-viewable-documents) - [SDN-BR-062](business-rules.md#sdn-br-062-category-%22all%22-or-blank-means-no-filter) ### SQL referencing output_document_type_code - [SQL-036: PolicyOutputDocumentRepository.GetUnReleasedDocumentsPriorToDate](sql/SQL-036-policy-output-document-repository-get-un-released-documents-prior-to-date.md) - [SQL-038: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsBySourceKeyText](sql/SQL-038-policy-output-document-repository-get-policy-output-documents-by-source-key-text.md) - [SQL-039: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsByImageId](sql/SQL-039-policy-output-document-repository-get-policy-output-documents-by-image-id.md) - [SQL-041: PolicyOutputDocumentRepository.GetReleasedAgencyViewablePolicyOutputDocuments](sql/SQL-041-policy-output-document-repository-get-released-agency-viewable-policy-output-documents.md) - [SQL-042: PolicyOutputDocumentRepository.GetHeldAndPendingAgencyViewablePolicyOutputDocuments](sql/SQL-042-policy-output-document-repository-get-held-and-pending-agency-viewable-policy-output-documents.md) - [SQL-043: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsForInbox](sql/SQL-043-policy-output-document-repository-get-policy-output-documents-for-inbox.md) - [SQL-044: PolicyOutputDocumentRepository.GetPolicyOutputDocuments](sql/SQL-044-policy-output-document-repository-get-policy-output-documents.md) - [SQL-046: PolicyOutputDocumentRepository.GetReleasedAgencyViewableChildOutputDocuments](sql/SQL-046-policy-output-document-repository-get-released-agency-viewable-child-output-documents.md) --- ## 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](operations/collections-case-lookups.md) - [Investigation subject and claim](operations/investigation-subject-and-claim.md) - [SOIL (State of Oregon Intercept) processing](operations/soil-processing.md) ### Business rules referencing PERSON - [PROC-RULE-010](business-rules.md#proc-rule-010-closed-cases-are-hidden-unless-requested) - [PROC-RULE-011](business-rules.md#proc-rule-011-search-branch-selection) - [PROC-RULE-012](business-rules.md#proc-rule-012-debtor-name-resolution-order) - [PROC-RULE-013](business-rules.md#proc-rule-013-debtor-ssn-source) - [PROC-RULE-030](business-rules.md#proc-rule-030-soil-eligibility) - [PROC-RULE-031](business-rules.md#proc-rule-031-audit-user) - [PROC-RULE-032](business-rules.md#proc-rule-032-balances-are-summed-per-ssn) - [PROC-RULE-038](business-rules.md#proc-rule-038-dropped-debtors-are-deleted-at-dor) - [SDN-BR-011](business-rules.md#sdn-br-011-soil-debtor-eligibility%3A-balance-%E2%89%A5-0%2C-include-on-soil-flag-'y'%2C-no-third-party%2C-worker-id-present) - [SDN-BR-050](business-rules.md#sdn-br-050-investigation-subject-name-resolves-via-person%2C-company-or-provider-location%2C-with-nvl-fallbacks) ### SQL referencing PERSON - [SQL-002: CollectionsRepository.CreateSoilDebtorReferenceRecords](sql/SQL-002-collections-repository-create-soil-debtor-reference-records.md) - [SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords](sql/SQL-003-collections-repository-create-soil-adjustment-records.md) - [SQL-006: CollectionsRepository.GetDebtorName](sql/SQL-006-collections-repository-get-debtor-name.md) - [SQL-007: CollectionsRepository.GetPrimaryDebtorName](sql/SQL-007-collections-repository-get-primary-debtor-name.md) - [SQL-008: CollectionsRepository.GetDebtorSsn](sql/SQL-008-collections-repository-get-debtor-ssn.md) - [SQL-012: CollectionsRepository.SearchCollections](sql/SQL-012-collections-repository-search-collections.md) - [SQL-032: InvestigationRepositoryExtensions.GetSubjectName](sql/SQL-032-investigation-repository-extensions-get-subject-name.md) --- ## 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](operations/collections-case-lookups.md) ### Business rules referencing PERSON_ADDRESS - [PROC-RULE-009](business-rules.md#proc-rule-009-third-party-contact-sources) ### SQL referencing PERSON_ADDRESS - [SQL-011: CollectionsRepository.GetThirdPartyAddress](sql/SQL-011-collections-repository-get-third-party-address.md) --- ## 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](operations/collections-case-lookups.md) ### Business rules referencing PERSON_PHONE - [PROC-RULE-009](business-rules.md#proc-rule-009-third-party-contact-sources) ### SQL referencing PERSON_PHONE - [SQL-011: CollectionsRepository.GetThirdPartyAddress](sql/SQL-011-collections-repository-get-third-party-address.md) --- ## 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](operations/collections-case-lookups.md) ### Business rules referencing PHONE - [PROC-RULE-009](business-rules.md#proc-rule-009-third-party-contact-sources) ### SQL referencing PHONE - [SQL-011: CollectionsRepository.GetThirdPartyAddress](sql/SQL-011-collections-repository-get-third-party-address.md) --- ## 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](operations/collections-case-lookups.md) - [Investigation subject and claim](operations/investigation-subject-and-claim.md) - [Policy output documents](operations/policy-output-documents.md) ### Business rules referencing POLICY - [PROC-RULE-001](business-rules.md#proc-rule-001-numeric-references-match-case-id%2C-policy-number-or-claim-number) - [PROC-RULE-002](business-rules.md#proc-rule-002-non-numeric-references) - [PROC-RULE-010](business-rules.md#proc-rule-010-closed-cases-are-hidden-unless-requested) - [PROC-RULE-011](business-rules.md#proc-rule-011-search-branch-selection) - [PROC-RULE-012](business-rules.md#proc-rule-012-debtor-name-resolution-order) - [SDN-BR-050](business-rules.md#sdn-br-050-investigation-subject-name-resolves-via-person%2C-company-or-provider-location%2C-with-nvl-fallbacks) - [SDN-BR-060](business-rules.md#sdn-br-060-agency-inbox%3A-unread-%3D-not-viewed-and-not-agency-deleted) - [SDN-BR-061](business-rules.md#sdn-br-061-agencies-see-only-released%2C-agency-viewable-documents) - [SDN-BR-062](business-rules.md#sdn-br-062-category-%22all%22-or-blank-means-no-filter) - [SDN-BR-063](business-rules.md#sdn-br-063-child-documents-are-returned-only-for-a-released-parent) ### SQL referencing POLICY - [SQL-004: CollectionsRepository.GetCasesByReferenceNumber](sql/SQL-004-collections-repository-get-cases-by-reference-number.md) - [SQL-006: CollectionsRepository.GetDebtorName](sql/SQL-006-collections-repository-get-debtor-name.md) - [SQL-007: CollectionsRepository.GetPrimaryDebtorName](sql/SQL-007-collections-repository-get-primary-debtor-name.md) - [SQL-012: CollectionsRepository.SearchCollections](sql/SQL-012-collections-repository-search-collections.md) - [SQL-032: InvestigationRepositoryExtensions.GetSubjectName](sql/SQL-032-investigation-repository-extensions-get-subject-name.md) - [SQL-036: PolicyOutputDocumentRepository.GetUnReleasedDocumentsPriorToDate](sql/SQL-036-policy-output-document-repository-get-un-released-documents-prior-to-date.md) - [SQL-038: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsBySourceKeyText](sql/SQL-038-policy-output-document-repository-get-policy-output-documents-by-source-key-text.md) - [SQL-039: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsByImageId](sql/SQL-039-policy-output-document-repository-get-policy-output-documents-by-image-id.md) - [SQL-041: PolicyOutputDocumentRepository.GetReleasedAgencyViewablePolicyOutputDocuments](sql/SQL-041-policy-output-document-repository-get-released-agency-viewable-policy-output-documents.md) - [SQL-042: PolicyOutputDocumentRepository.GetHeldAndPendingAgencyViewablePolicyOutputDocuments](sql/SQL-042-policy-output-document-repository-get-held-and-pending-agency-viewable-policy-output-documents.md) - [SQL-043: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsForInbox](sql/SQL-043-policy-output-document-repository-get-policy-output-documents-for-inbox.md) - [SQL-044: PolicyOutputDocumentRepository.GetPolicyOutputDocuments](sql/SQL-044-policy-output-document-repository-get-policy-output-documents.md) - [SQL-045: PolicyOutputDocumentRepository.CheckDocumentExist](sql/SQL-045-policy-output-document-repository-check-document-exist.md) - [SQL-046: PolicyOutputDocumentRepository.GetReleasedAgencyViewableChildOutputDocuments](sql/SQL-046-policy-output-document-repository-get-released-agency-viewable-child-output-documents.md) - [SQL-047: PolicyOutputDocumentRepository.GetAccountNumber](sql/SQL-047-policy-output-document-repository-get-account-number.md) --- ## 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](operations/collections-interest-and-payment-selection.md) ### Business rules referencing POLICY_FINANCIAL_TRANS - [PROC-RULE-018](business-rules.md#proc-rule-018-unposted-payments-for-open-cases) ### SQL referencing POLICY_FINANCIAL_TRANS - [SQL-014: CollectionsRepository.GetMissingPolicyPayments](sql/SQL-014-collections-repository-get-missing-policy-payments.md) --- ## 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](operations/policy-output-documents.md) ### Business rules referencing policy_output_document - [SDN-BR-060](business-rules.md#sdn-br-060-agency-inbox%3A-unread-%3D-not-viewed-and-not-agency-deleted) - [SDN-BR-061](business-rules.md#sdn-br-061-agencies-see-only-released%2C-agency-viewable-documents) - [SDN-BR-062](business-rules.md#sdn-br-062-category-%22all%22-or-blank-means-no-filter) - [SDN-BR-063](business-rules.md#sdn-br-063-child-documents-are-returned-only-for-a-released-parent) ### SQL referencing policy_output_document - [SQL-036: PolicyOutputDocumentRepository.GetUnReleasedDocumentsPriorToDate](sql/SQL-036-policy-output-document-repository-get-un-released-documents-prior-to-date.md) - [SQL-037: PolicyOutputDocumentRepository.GetPolicyOutputDocument](sql/SQL-037-policy-output-document-repository-get-policy-output-document.md) - [SQL-038: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsBySourceKeyText](sql/SQL-038-policy-output-document-repository-get-policy-output-documents-by-source-key-text.md) - [SQL-039: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsByImageId](sql/SQL-039-policy-output-document-repository-get-policy-output-documents-by-image-id.md) - [SQL-040: PolicyOutputDocumentRepository.GetHeldDocumentsForNotification](sql/SQL-040-policy-output-document-repository-get-held-documents-for-notification.md) - [SQL-041: PolicyOutputDocumentRepository.GetReleasedAgencyViewablePolicyOutputDocuments](sql/SQL-041-policy-output-document-repository-get-released-agency-viewable-policy-output-documents.md) - [SQL-042: PolicyOutputDocumentRepository.GetHeldAndPendingAgencyViewablePolicyOutputDocuments](sql/SQL-042-policy-output-document-repository-get-held-and-pending-agency-viewable-policy-output-documents.md) - [SQL-043: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsForInbox](sql/SQL-043-policy-output-document-repository-get-policy-output-documents-for-inbox.md) - [SQL-044: PolicyOutputDocumentRepository.GetPolicyOutputDocuments](sql/SQL-044-policy-output-document-repository-get-policy-output-documents.md) - [SQL-045: PolicyOutputDocumentRepository.CheckDocumentExist](sql/SQL-045-policy-output-document-repository-check-document-exist.md) - [SQL-046: PolicyOutputDocumentRepository.GetReleasedAgencyViewableChildOutputDocuments](sql/SQL-046-policy-output-document-repository-get-released-agency-viewable-child-output-documents.md) --- ## 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](operations/collections-case-lookups.md) ### Business rules referencing POLICY_SEARCH - [PROC-RULE-010](business-rules.md#proc-rule-010-closed-cases-are-hidden-unless-requested) - [PROC-RULE-011](business-rules.md#proc-rule-011-search-branch-selection) ### SQL referencing POLICY_SEARCH - [SQL-012: CollectionsRepository.SearchCollections](sql/SQL-012-collections-repository-search-collections.md) --- ## 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](operations/provider-address-retrieval.md) ### Business rules referencing PROVIDER - [SDN-BR-030](business-rules.md#sdn-br-030-providersrepository-requires-a-non-null-unit-of-work) - [SDN-BR-031](business-rules.md#sdn-br-031-provider-payment-address-type-%3D-pay%2C-physical-%3D-phy) ### SQL referencing PROVIDER - [SQL-048: ProvidersRepository.GetProviderByTaxIdBatch](sql/SQL-048-providers-repository-get-provider-by-tax-id-batch.md) --- ## 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](operations/provider-address-retrieval.md) ### Business rules referencing PROVIDER_ADDRESS - [SDN-BR-030](business-rules.md#sdn-br-030-providersrepository-requires-a-non-null-unit-of-work) - [SDN-BR-031](business-rules.md#sdn-br-031-provider-payment-address-type-%3D-pay%2C-physical-%3D-phy) ### SQL referencing PROVIDER_ADDRESS - [SQL-049: ProvidersRepository.GetProviderAddresses](sql/SQL-049-providers-repository-get-provider-addresses.md) --- ## 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](operations/investigation-subject-and-claim.md) - [Provider address retrieval](operations/provider-address-retrieval.md) ### Business rules referencing PROVIDER_LOCATION - [SDN-BR-030](business-rules.md#sdn-br-030-providersrepository-requires-a-non-null-unit-of-work) - [SDN-BR-031](business-rules.md#sdn-br-031-provider-payment-address-type-%3D-pay%2C-physical-%3D-phy) - [SDN-BR-050](business-rules.md#sdn-br-050-investigation-subject-name-resolves-via-person%2C-company-or-provider-location%2C-with-nvl-fallbacks) ### SQL referencing PROVIDER_LOCATION - [SQL-032: InvestigationRepositoryExtensions.GetSubjectName](sql/SQL-032-investigation-repository-extensions-get-subject-name.md) - [SQL-049: ProvidersRepository.GetProviderAddresses](sql/SQL-049-providers-repository-get-provider-addresses.md) --- ## 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](operations/soil-processing.md) ### Business rules referencing SOIL_DEBTOR_REFERENCE - [PROC-RULE-030](business-rules.md#proc-rule-030-soil-eligibility) - [PROC-RULE-031](business-rules.md#proc-rule-031-audit-user) - [PROC-RULE-032](business-rules.md#proc-rule-032-balances-are-summed-per-ssn) - [PROC-RULE-038](business-rules.md#proc-rule-038-dropped-debtors-are-deleted-at-dor) - [SDN-BR-011](business-rules.md#sdn-br-011-soil-debtor-eligibility%3A-balance-%E2%89%A5-0%2C-include-on-soil-flag-'y'%2C-no-third-party%2C-worker-id-present) - [SDN-BR-012](business-rules.md#sdn-br-012-soil-transactions-are-selected-by-the-truncated-create-date) ### SQL referencing SOIL_DEBTOR_REFERENCE - [SQL-002: CollectionsRepository.CreateSoilDebtorReferenceRecords](sql/SQL-002-collections-repository-create-soil-debtor-reference-records.md) - [SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords](sql/SQL-003-collections-repository-create-soil-adjustment-records.md) - [SQL-020: CollectionsRepository.GetWorkerIdForSoilTrans](sql/SQL-020-collections-repository-get-worker-id-for-soil-trans.md) --- ## 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](operations/policy-output-documents.md) ### Business rules referencing SUB_POLICY - [SDN-BR-060](business-rules.md#sdn-br-060-agency-inbox%3A-unread-%3D-not-viewed-and-not-agency-deleted) - [SDN-BR-061](business-rules.md#sdn-br-061-agencies-see-only-released%2C-agency-viewable-documents) - [SDN-BR-062](business-rules.md#sdn-br-062-category-%22all%22-or-blank-means-no-filter) ### SQL referencing SUB_POLICY - [SQL-036: PolicyOutputDocumentRepository.GetUnReleasedDocumentsPriorToDate](sql/SQL-036-policy-output-document-repository-get-un-released-documents-prior-to-date.md) - [SQL-038: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsBySourceKeyText](sql/SQL-038-policy-output-document-repository-get-policy-output-documents-by-source-key-text.md) - [SQL-039: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsByImageId](sql/SQL-039-policy-output-document-repository-get-policy-output-documents-by-image-id.md) - [SQL-041: PolicyOutputDocumentRepository.GetReleasedAgencyViewablePolicyOutputDocuments](sql/SQL-041-policy-output-document-repository-get-released-agency-viewable-policy-output-documents.md) - [SQL-042: PolicyOutputDocumentRepository.GetHeldAndPendingAgencyViewablePolicyOutputDocuments](sql/SQL-042-policy-output-document-repository-get-held-and-pending-agency-viewable-policy-output-documents.md) - [SQL-043: PolicyOutputDocumentRepository.GetPolicyOutputDocumentsForInbox](sql/SQL-043-policy-output-document-repository-get-policy-output-documents-for-inbox.md) - [SQL-044: PolicyOutputDocumentRepository.GetPolicyOutputDocuments](sql/SQL-044-policy-output-document-repository-get-policy-output-documents.md) --- ## 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](operations/investigation-subject-and-claim.md) ### Business rules referencing SUBJECT - [SDN-BR-050](business-rules.md#sdn-br-050-investigation-subject-name-resolves-via-person%2C-company-or-provider-location%2C-with-nvl-fallbacks) ### SQL referencing SUBJECT - [SQL-032: InvestigationRepositoryExtensions.GetSubjectName](sql/SQL-032-investigation-repository-extensions-get-subject-name.md) --- ## 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](operations/collections-case-lookups.md) - [Collections interest and payment selection](operations/collections-interest-and-payment-selection.md) - [SOIL (State of Oregon Intercept) processing](operations/soil-processing.md) ### Business rules referencing THRDPARTY - [PROC-RULE-009](business-rules.md#proc-rule-009-third-party-contact-sources) - [PROC-RULE-010](business-rules.md#proc-rule-010-closed-cases-are-hidden-unless-requested) - [PROC-RULE-011](business-rules.md#proc-rule-011-search-branch-selection) - [PROC-RULE-012](business-rules.md#proc-rule-012-debtor-name-resolution-order) - [PROC-RULE-013](business-rules.md#proc-rule-013-debtor-ssn-source) - [PROC-RULE-018](business-rules.md#proc-rule-018-unposted-payments-for-open-cases) - [PROC-RULE-030](business-rules.md#proc-rule-030-soil-eligibility) - [PROC-RULE-031](business-rules.md#proc-rule-031-audit-user) - [PROC-RULE-032](business-rules.md#proc-rule-032-balances-are-summed-per-ssn) - [PROC-RULE-038](business-rules.md#proc-rule-038-dropped-debtors-are-deleted-at-dor) - [SDN-BR-011](business-rules.md#sdn-br-011-soil-debtor-eligibility%3A-balance-%E2%89%A5-0%2C-include-on-soil-flag-'y'%2C-no-third-party%2C-worker-id-present) ### SQL referencing THRDPARTY - [SQL-002: CollectionsRepository.CreateSoilDebtorReferenceRecords](sql/SQL-002-collections-repository-create-soil-debtor-reference-records.md) - [SQL-003: CollectionsRepository.CreateSoilAdjustmentRecords](sql/SQL-003-collections-repository-create-soil-adjustment-records.md) - [SQL-006: CollectionsRepository.GetDebtorName](sql/SQL-006-collections-repository-get-debtor-name.md) - [SQL-007: CollectionsRepository.GetPrimaryDebtorName](sql/SQL-007-collections-repository-get-primary-debtor-name.md) - [SQL-008: CollectionsRepository.GetDebtorSsn](sql/SQL-008-collections-repository-get-debtor-ssn.md) - [SQL-011: CollectionsRepository.GetThirdPartyAddress](sql/SQL-011-collections-repository-get-third-party-address.md) - [SQL-012: CollectionsRepository.SearchCollections](sql/SQL-012-collections-repository-search-collections.md) - [SQL-015: CollectionsRepository.GetThirdPartyPayments](sql/SQL-015-collections-repository-get-third-party-payments.md) --- ## 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](operations/collections-interest-and-payment-selection.md) ### Business rules referencing THRDPARTY_DISTRIBUTION - [PROC-RULE-018](business-rules.md#proc-rule-018-unposted-payments-for-open-cases) ### SQL referencing THRDPARTY_DISTRIBUTION - [SQL-015: CollectionsRepository.GetThirdPartyPayments](sql/SQL-015-collections-repository-get-third-party-payments.md) --- ## 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](operations/collections-case-lookups.md) ### Business rules referencing THRDPARTY_FIRM - [PROC-RULE-009](business-rules.md#proc-rule-009-third-party-contact-sources) - [PROC-RULE-010](business-rules.md#proc-rule-010-closed-cases-are-hidden-unless-requested) - [PROC-RULE-011](business-rules.md#proc-rule-011-search-branch-selection) - [PROC-RULE-012](business-rules.md#proc-rule-012-debtor-name-resolution-order) ### SQL referencing THRDPARTY_FIRM - [SQL-006: CollectionsRepository.GetDebtorName](sql/SQL-006-collections-repository-get-debtor-name.md) - [SQL-007: CollectionsRepository.GetPrimaryDebtorName](sql/SQL-007-collections-repository-get-primary-debtor-name.md) - [SQL-011: CollectionsRepository.GetThirdPartyAddress](sql/SQL-011-collections-repository-get-third-party-address.md) - [SQL-012: CollectionsRepository.SearchCollections](sql/SQL-012-collections-repository-search-collections.md) --- ## 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. ```mermaid 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](index.md) - [Overview](overview.md) - [Architecture](architecture.md) - [Dependencies](dependencies.md) - [Operations and processes](operations-processes.md) - [Business rules](business-rules.md) - [Security and authorization](security-authorization.md) - [SQL catalog](sql/index.md) - [Procedures](procedures/index.md) - [API reference](api/index.md) ## Sources - `Data/SAIF.Data.NHibernate/Mappings/**`