Skip to content

SQL-007: Generate Provider Contact Code

Returns the next identifier value used when creating provider contact code.

Classification

Field Value
SQL ID SQL-007
Operation type Sequence
Execution method Inline
Database Oracle
Schema [unqualified]**
Command type Text
Business object clsProviderContactCode
Criteria property CreateSQL
Lifecycle method Create

Parameters

No parameters. This statement does not accept bind input.

Tables

No tables are referenced by this SQL statement.

Sample SQL

SELECT CODE_NEXTVAL FROM DUAL

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

Sources

  • Business\SAIF.Business.Provider\clsProviderContactCode.vb