SQL-047: Create RctPolicyToTransmit via InsertRctPolicyToTransmit¶

This ORM statement performs a create operation on RctPolicyToTransmit via InsertRctPolicyToTransmit, executed from Services/SAIF.Services/Rct/RctPolicyToTransmitService.cs (L59).

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:PolicyNumber`	Input	`long`	N/A	Identifier supplied by the caller
`:PolicyPeriodEffectiveDate`	Input	`DateTime`	N/A
`:MarketTypeCode`	Input	`string`	N/A
`:OriginalPolicyPeriodEffectiveDate`	Input	`DateTime?`	N/A

Tables¶

Table	Access	Columns used
RCT_POLICIES_TO_TRANSMIT	INSERT	POLICY_NUM, POLICY_PERIOD_EFF_DATE, MARKET_TYPE_CODE, ORIGINAL_PP_EFF_DATE

LINQ statement¶

Source: Services/SAIF.Services/Rct/RctPolicyToTransmitService.cs:59.

// Services/SAIF.Services/Rct/RctPolicyToTransmitService.cs:59
_unitOfWork.GetRepository<DataRct.RctPolicyToTransmit>().Add(dataPolicyToTransmit);

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 RCT_POLICIES_TO_TRANSMIT (
  POLICY_NUM,
  POLICY_PERIOD_EFF_DATE,
  MARKET_TYPE_CODE,
  ORIGINAL_PP_EFF_DATE)
VALUES (
  :PolicyNumber,
  :PolicyPeriodEffectiveDate,
  :MarketTypeCode,
  :OriginalPolicyPeriodEffectiveDate)

Translation notes: - No generator is declared on Id(PolicyNumber); FluentNHibernate defaults an integral identifier to the identity generator, which the Oracle10 dialect does not provide as a native column type. The INSERT is shown with POLICY_NUM bound from :PolicyNumber as set by the caller; the exact runtime behaviour of this default on Oracle could not be confirmed statically.

Operations and processes¶

RctPolicyToTransmitService.InsertRctPolicyToTransmit — see Operations and processes

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

Sources¶

Services/SAIF.Services/Rct/RctPolicyToTransmitService.cs (L59)