SQL-001: Create AuditedServiceOverride via Add¶

This ORM statement performs a create operation on AuditedServiceOverride via Add, executed from Services/SAIF.Services/Edi/AuditedServiceOverrideService.cs (L142).

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:Id`	Input	`long?`	N/A	Composite-key part
`:AuditId`	Input	`long?`	N/A	Composite-key part
`:IsBypassed`	Input	`bool?`	N/A	Bound as `'Y'`/`'N'` (`YesNoType`)
`:BillServiceCode`	Input	`string`	N/A
`:BillServiceTypeCode`	Input	`string`	N/A
`:NationalDrugCode`	Input	`string`	N/A
`:OriginalAuditId`	Input	`long?`	N/A
`:OverrideText`	Input	`string`	N/A
`:SecondaryClaimsBillsClaimsServiceCode`	Input	`string`	N/A
`:SecondaryServiceTypeCode`	Input	`string`	N/A
`:ServiceModifierCode1`	Input	`string`	N/A
`:ServiceModifierCode2`	Input	`string`	N/A
`:ServiceModifierCode3`	Input	`string`	N/A
`:ServiceModifierCode4`	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_AUDITED_SERVICE_OVERRIDE	INSERT	BILL_ID, AUDIT_SEQ_NUM, BYPASS_FLAG, BILL_SERVICE_CODE, BILL_SERVICE_TYPE_CODE, NATIONAL_DRUG_CODE, ORIG_AUDIT_SEQ_NUM, OVERRIDE_TEXT, SECONDARY_CBP_SERVICE_CODE, SECONDARY_SERVICE_TYPE_CODE, SERVICE_MODIFIER_CODE1, SERVICE_MODIFIER_CODE2, SERVICE_MODIFIER_CODE3, SERVICE_MODIFIER_CODE4, UPDATE_DATE, UPDATE_NUM, UPDATE_USER

LINQ statement¶

Source: Services/SAIF.Services/Edi/AuditedServiceOverrideService.cs:142.

// Services/SAIF.Services/Edi/AuditedServiceOverrideService.cs:142
unitOfWork.GetRepository<DataModel.AuditedServiceOverride>().Add(auditedServiceOverride);

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_AUDITED_SERVICE_OVERRIDE (
  BILL_ID,
  AUDIT_SEQ_NUM,
  BYPASS_FLAG,
  BILL_SERVICE_CODE,
  BILL_SERVICE_TYPE_CODE,
  NATIONAL_DRUG_CODE,
  ORIG_AUDIT_SEQ_NUM,
  OVERRIDE_TEXT,
  SECONDARY_CBP_SERVICE_CODE,
  SECONDARY_SERVICE_TYPE_CODE,
  SERVICE_MODIFIER_CODE1,
  SERVICE_MODIFIER_CODE2,
  SERVICE_MODIFIER_CODE3,
  SERVICE_MODIFIER_CODE4,
  UPDATE_DATE,
  UPDATE_NUM,
  UPDATE_USER)
VALUES (
  :Id,
  :AuditId,
  :IsBypassed,
  :BillServiceCode,
  :BillServiceTypeCode,
  :NationalDrugCode,
  :OriginalAuditId,
  :OverrideText,
  :SecondaryClaimsBillsClaimsServiceCode,
  :SecondaryServiceTypeCode,
  :ServiceModifierCode1,
  :ServiceModifierCode2,
  :ServiceModifierCode3,
  :ServiceModifierCode4,
  :UpdateDate,
  :UpdateNumber,
  :UpdateUser)

Translation notes: - Composite identifier (CompositeId()) with no generator: every key part is supplied by the caller. A stateful SaveOrUpdate on a composite-key entity may first issue a SELECT by the key columns to decide between INSERT and UPDATE. - :IsBypassed are bound as 'Y' / 'N' (YesNoType).

Operations and processes¶

AuditedServiceOverrideService.Add — see Operations and processes

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

Sources¶

Services/SAIF.Services/Edi/AuditedServiceOverrideService.cs (L142)