SQL-002: CollectionsRepository.CreateSoilDebtorReferenceRecords¶

This statement is a create operation invoked through StoredProc (inline CreateSqlQuery + ExecuteUpdate). Executed by CollectionsRepository.CreateSoilDebtorReferenceRecords.

Classification¶

Field	Value
SQL ID	SQL-002
Operation type	Create
Execution method	StoredProc (inline `CreateSqlQuery` + `ExecuteUpdate`)
Database	Oracle
Schema	WCIS_DBA* (package owner; unqualified inside package); [unqualified]**
Command type	StoredProcedure
Business object	`CollectionsRepository`
Criteria property	N/A — no IBusinessCriteria
Lifecycle method	`CreateSoilDebtorReferenceRecords`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:create_date_in`	Input	DATE (.NET `SetDateTime`)	N/A	Run date stamped on the SOIL reference rows
`:run_id`	Input	VARCHAR2 (.NET `string`)	N/A**	Unique run id; filters CLM_DBA.TEMP_DATA_PERSON_ADDRESS

Tables¶

Table	Access	Columns used
SOIL_DEBTOR_REFERENCE	C	See Sample SQL
LEGAL_COLLECTION_DEBTOR	Write	See Sample SQL
LEGAL_COLLECTION	Write	See Sample SQL
CLM_DBA.TEMP_DATA_PERSON_ADDRESS	Write	See Sample SQL
THRDPARTY	Write	See Sample SQL
PERSON	Write	See Sample SQL

Sample SQL¶

Source: Data/SAIF.Data.NHibernate/Repositories/CollectionsRepository.cs:133

call WCIS_DBA.PK80011_LEGALCOL_SOIL.CREATE_REFERENCE_RECORDS(
    :create_date_in,
    :run_id
)

Operations and processes¶

SOIL (State of Oregon Intercept) processing

Business rules¶

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Data/SAIF.Data.NHibernate/Repositories/CollectionsRepository.cs:131