SQL-001 Fetch claim display and confidentiality fields¶
Executed directly by clsClaimTask.GetExtraFields (not through the standard criteria-driven Before/After lifecycle) to bulk-load claim display attributes and confidentiality flags for list-retrieved claim tasks, since the task row itself carries only CLAIM_ID.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-001 |
| Operation type | Read |
| Execution method | Stored procedure |
| Database | Oracle |
| Schema | [unqualified]** — no owner prefix in the call string |
| Command type | StoredProcedure |
| Business object | clsClaimTask |
| Criteria property | Criteria.extraSQL (non-IBusinessCriteria property) |
| Lifecycle method | clsClaimTask.GetExtraFields, invoked from PostFill (list path) |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:ClaimId |
Input | Decimal (ClaimID property) |
— | Identifies the claim whose additional display/confidentiality fields are requested. |
:ClaimNum |
InputOutput | String | 7 | Returns the claim number without the check character; seeded from m_ClaimNum. |
:SAIFClaimNum |
InputOutput | String | 8 | Returns the SAIF claim number including the check character; seeded from m_SAIFClaimNum. |
:WorkerName |
InputOutput | String | 100 | Returns the injured worker name; may subsequently be replaced with "Confidential" by BR-MY-01. |
:PolicyName |
InputOutput | String | 100 | Returns the policy (employer) name. |
:WorkStatus |
InputOutput | String | 100 | Returns the claim work-status description. |
:conflictFlag |
InputOutput | String | 5 | Worker-conflict indicator; .NET maps "Y" → IsWorkerConflict = True. |
:exposureCode |
InputOutput | String | 5 | Exposure indicator; .NET maps any value other than "0" → IsExposure = True. |
:healthIssue |
InputOutput | String | 5 | Health-issue indicator; .NET maps "Y" → IsHealthIssue = True. |
:hostileWrkr |
InputOutput | String | 5 | Hostile-worker indicator; .NET maps any non-space value → IsHostileWrkr = True. |
Parameter types and lengths are the .NET-side binding declarations (
AddParm(...)) only. Because the PL/SQL source could not be retrieved, the true PL/SQL parameter modes and datatypes are unknown.**
Tables¶
| Table | Access | Columns used |
|---|---|---|
| N/A | — | The tables read by PK82284_CLAIM_TASK.SELECT_ADDITIONAL_FIELDS reside inside the Oracle package body and are not visible from this repository.** |
Sample SQL¶
-- Stored procedure call as it appears in code
CALL PK82284_CLAIM_TASK.SELECT_ADDITIONAL_FIELDS(
:ClaimId,
:ClaimNum,
:SAIFClaimNum,
:WorkerName,
:PolicyName,
:WorkStatus,
:conflictFlag,
:exposureCode,
:healthIssue,
:hostileWrkr)
-- Procedure body resides in the Oracle database and is not present in this repository.
-- Source retrieval via the Legends CLI was unavailable for this run; status: not-found.
Corresponding VB request setup, for traceability:
DataRequest.RequestType = DataRequestType.NonQuery
DataRequest.CommandType = CommandType.StoredProcedure
DataRequest.SQLStatement = MyCriteria.extraSQL ' "PK82284_CLAIM_TASK.SELECT_ADDITIONAL_FIELDS"
DataRequest.ID = "ExtraFields"
Operations and processes¶
Business rules¶
Sources¶
- SAIF.Business.Tasks.Claim/clsClaimTask.vb