SQL-055: PolicyPeriodPayrollAuditRepository.TrackInReport

This statement is a update operation invoked through StoredProc (inline CreateSqlQuery + ExecuteUpdate). Executed by PolicyPeriodPayrollAuditRepository.TrackInReport.

Classification

Field	Value
SQL ID	SQL-055
Operation type	Update
Execution method	StoredProc (inline CreateSqlQuery + ExecuteUpdate)
Database	Oracle
Schema	[unqualified]**
Command type	StoredProcedure
Business object	PolicyPeriodPayrollAuditRepository
Criteria property	N/A — no IBusinessCriteria
Lifecycle method	TrackInReport

Parameters

Parameter	Direction	Type	Max length	Description
:inpolicynum	Input	NUMBER (.NET SetDecimal)	N/A	Policy number
:inauditperiodstartdate	Input	DATE	N/A	Audit period start date

Tables

Table	Access	Columns used
Remote: wcis_dba.pk73101_image.track_in_report@POLDB (tables not visible**)	Write	See Sample SQL**

Sample SQL

Source: Data/SAIF.Data.NHibernate/Repositories/PolicyPeriodPayrollAuditRepository.cs:17

call WCIS_DBA.PK73101_IMAGE.TRACK_IN_REPORT(
    :inpolicynum,
    :inauditperiodstartdate
)

Operations and processes

• Payroll audit report tracking

Business rules

• PROC-RULE-045
• PROC-RULE-046

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Data/SAIF.Data.NHibernate/Repositories/PolicyPeriodPayrollAuditRepository.cs:15