SQL-010: Create CbpProcedureCode via InsertProcedure¶

This ORM statement performs a create operation on CbpProcedureCode via InsertProcedure, executed from Services/SAIF.Services/Claims/ICDCodeService/Icd10CodeService.cs (L181).

Classification¶

Field	Value
SQL ID	SQL-010
Operation type	Create
Execution method	ORM (IRepository.Add)
Database	Oracle
Schema	[unqualified]**
Command type	N/A (ORM-generated)
Business object	`CbpProcedureCode`
Criteria property	N/A — ORM
Lifecycle method	`InsertProcedure`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:Code`	Input	`string (inherited from external base class; type inferred)`	N/A	Identifier supplied by the caller
`:UpdateNumber`	Input	`int`	N/A	Version column (`Version()`); NHibernate writes its initial value
`:Description`	Input	`string (inherited from external base class; type inferred)`	N/A
`:ShortDescription`	Input	`string`	N/A
`:EffectiveDate`	Input	`DateTime`	N/A
`:ExpirationDate`	Input	`DateTime?`	N/A
`:UpdateUser`	Input	`string`	N/A
`:UpdateDate`	Input	`DateTime`	N/A
`:IcdVersionCode`	Input	`string`	N/A

Tables¶

Table	Access	Columns used
CBP_PROCEDURE_CODE	INSERT	CODE, UPDATE_NUM, CODE_DESCR, SHORT_DESCR, EFF_DATE, EXP_DATE, UPDATE_USER, UPDATE_DATE, ICD_VERSION_CODE

LINQ statement¶

Source: Services/SAIF.Services/Claims/ICDCodeService/Icd10CodeService.cs:181.

// Services/SAIF.Services/Claims/ICDCodeService/Icd10CodeService.cs:181
unitOfWork.GetRepository<CbpProcedureCode>().Add(cbpProcdureCode);

Sample SQL¶

Inferred SQL: This SQL was inferred from the LINQ statement above and the NHibernate mappings. It is not concrete SQL from source code; NHibernate generates the executed statement at runtime, so aliases, column order, join syntax, and bind-parameter names may differ.

-- Inferred from LINQ (NHibernate mapping translation); not concrete SQL
INSERT INTO CBP_PROCEDURE_CODE (
  CODE,
  UPDATE_NUM,
  CODE_DESCR,
  SHORT_DESCR,
  EFF_DATE,
  EXP_DATE,
  UPDATE_USER,
  UPDATE_DATE,
  ICD_VERSION_CODE)
VALUES (
  :Code,
  :UpdateNumber,
  :Description,
  :ShortDescription,
  :EffectiveDate,
  :ExpirationDate,
  :UpdateUser,
  :UpdateDate,
  :IcdVersionCode)

Translation notes: - No generator is declared on Id(Code) (type string (inherited from external base class; type inferred)); FluentNHibernate defaults a non-integral identifier to assigned, so :Code is supplied by the caller. A stateful SaveOrUpdate may first issue a SELECT by CODE to decide between INSERT and UPDATE. - UPDATE_NUM is the optimistic-concurrency version column (Version(x => x.UpdateNumber)); NHibernate sets its initial value on INSERT.

Operations and processes¶

Icd10CodeService.InsertProcedure — see Operations and processes

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

Sources¶

Services/SAIF.Services/Claims/ICDCodeService/Icd10CodeService.cs (L181)