SQL-014: Validate provider registration¶

Executes an Oracle function call through SELECT ... FROM DUAL to validate provider registration eligibility using pk82396_medical_bills.ValidateProvReg. The function result determines whether the provider registration is valid.*

Classification¶

Field	Value
SQL ID	SQL-014
Operation type	Read
Execution method	Inline SQL + Oracle function
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsNewUserArgs`
Criteria property	`DataRequest.SQLStatement`
Lifecycle method	`IsValidProviderRegistration`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:inBillId`	Input	Decimal	7	Medical bill identifier.
`:inClaimNum`	Input	String	N/A	Claim number for validation context.
`:inProvider`	Input	String	N/A	Provider identifier.

Tables¶

Table	Access	Columns used
DUAL	SELECT	N/A (pseudo-table used for Oracle function call)

Sample SQL¶

-- Oracle function call via DUAL
SELECT pk82396_medical_bills.ValidateProvReg(:inBillId, :inClaimNum, :inProvider)
FROM dual

Operations and processes¶

Provider registration validation

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.External.Users\clsNewUserArgs.vb