Skip to content

SQL-004: Create BillOverride via Add

This ORM statement performs a create operation on BillOverride via Add, executed from Services/SAIF.Services/Edi/BillOverrideService.cs (L134).

Classification

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

Parameters

Parameter Direction Type Max length Description
:Id Input long? N/A Identifier supplied by the caller
:IsBypassed Input bool N/A Bound as 'Y'/'N' (YesNoType)
:BillTypeCode Input string N/A
:ClaimsBillsProcessingAdmissionTypeCode Input string N/A
:DrugCode Input string N/A
:OverrideText Input string N/A
:StatementThruDate Input DateTime? N/A
:UniformBillingBillTypeCode Input string N/A
:UpdateDate Input DateTime? N/A
:UpdateNumber Input long N/A
:UpdateUser Input string N/A

Tables

Table Access Columns used
EDI_BILL_OVERRIDE INSERT BILL_ID, BYPASS_FLAG, BILL_TYPE_CODE, CBP_ADMISSION_TYPE_CODE, DRG_CODE, OVERRIDE_TEXT, STATEMENT_THRU_DATE, UB_BILL_TYPE_CODE, UPDATE_DATE, UPDATE_NUM, UPDATE_USER

LINQ statement

Source: Services/SAIF.Services/Edi/BillOverrideService.cs:134.

// Services/SAIF.Services/Edi/BillOverrideService.cs:134
unitOfWork.GetRepository<DataModel.BillOverride>().Add(newBillOverride);

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 EDI_BILL_OVERRIDE (
  BILL_ID,
  BYPASS_FLAG,
  BILL_TYPE_CODE,
  CBP_ADMISSION_TYPE_CODE,
  DRG_CODE,
  OVERRIDE_TEXT,
  STATEMENT_THRU_DATE,
  UB_BILL_TYPE_CODE,
  UPDATE_DATE,
  UPDATE_NUM,
  UPDATE_USER)
VALUES (
  :Id,
  :IsBypassed,
  :BillTypeCode,
  :ClaimsBillsProcessingAdmissionTypeCode,
  :DrugCode,
  :OverrideText,
  :StatementThruDate,
  :UniformBillingBillTypeCode,
  :UpdateDate,
  :UpdateNumber,
  :UpdateUser)

Translation notes: - GeneratedBy.Assigned(): :Id is supplied by the caller. Because the identifier is assigned, a stateful SaveOrUpdate cannot tell a new instance from a detached one by identifier alone; NHibernate may first issue a SELECT by BILL_ID (or rely on the version unsaved-value, if mapped) to decide between INSERT and UPDATE. - :IsBypassed are bound as 'Y' / 'N' (YesNoType).

Operations and processes

Business rules

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

Sources

  • Services/SAIF.Services/Edi/BillOverrideService.cs (L134)