SQL-001: PK82284_CLAIM_TASK.SELECT_ADDITIONAL_FIELDS¶

This SQL artifact supports Criteria by executing a read operation through StoredProc.

Classification¶

Field	Value
SQL ID	SQL-001
Operation type	Read
Execution method	StoredProc
Database	Oracle
Schema	[unqualified]**
Command type	StoredProcedure
Business object	`Criteria`
Criteria property	`extrasql`
Lifecycle method	`Criteria read`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:ClaimId`	Input	Number	N/A	Source value `ClaimID`
`:ClaimNum`	InputOutput	Number	7	Source value `m_ClaimNum`
`:SAIFClaimNum`	InputOutput	Number	8	Source value `m_SAIFClaimNum`
`:WorkerName`	InputOutput	String	100	Source value `m_WorkerName`
`:PolicyName`	InputOutput	String	100	Source value `m_PolicyName`
`:WorkStatus`	InputOutput	Unknown	100	Source value `m_WorkStatus`
`:conflictFlag`	InputOutput	String	5	Source value `workerConflict`
`:exposureCode`	InputOutput	String	5	Source value `exposureCode`
`:healthIssue`	InputOutput	Unknown	5	Source value `healthIssue`
`:hostileWrkr`	InputOutput	Unknown	5	Source value `hostileWrkr`

Tables¶

Table	Access	Columns used
`PK82284_CLAIM_TASK.SELECT_ADDITIONAL_FIELDS`	CALL	Output parameter contract for `ClaimNum`, `SAIFClaimNum`, `WorkerName`, `PolicyName`, `WorkStatus`, `conflictFlag`, `exposureCode`, `healthIssue`, and `hostileWrkr`.

Sample SQL¶

BEGIN PK82284_CLAIM_TASK.SELECT_ADDITIONAL_FIELDS(:ClaimId, :ClaimNum, :SAIFClaimNum, :WorkerName, :PolicyName, :WorkStatus, :conflictFlag, :exposureCode, :healthIssue, :hostileWrkr); END;
-- Stored procedure body retrieved from Oracle package WCIS_DBA.PK82284_CLAIM_TASK.

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

Sources¶

Business\SAIF.Business.Tasks.Claim\clsClaimTask.vb