SQL-028: Insert paymentplantype¶

Insert paymentplantype in the context of clsPaymentPlanType.

Classification¶

Field	Value
SQL ID	SQL-028
Operation type	Insert
Execution method	NonQuery
Database	Oracle
Command type	Text
Schema	[unqualified]
Business object	`clsPaymentPlanType`
Criteria property	`InsertSQL`
Lifecycle method	BeforeInsert / AfterInsert

Parameters¶

Parameter	Direction	Type	Max length	Description
`:Code`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.
`:Description`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.
`:MarketTypeCode`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.
`:PolicyRenewalTrackCode`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.
`:PayrollReportScheduleFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.
`:GenerateBillingCode`	Input	Numeric*	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.
`:CreateDate`	Input	Date	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.
`:CreateUser`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.
`:UpdateDate`	Input	Date	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.
`:UpdateUser`	Input	Date	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.
`:AuditTypeCode`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.
`:AdjustedRateCalculationFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.
`:NewPolicyPeriodDefaultFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.
`:AdjustedRateStyleRecapFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.
`:DisplayOrderNumber`	Input	Numeric*	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.
`:PayrollByClassFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.
`:PaymentRequiredFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.
`:CreatePFTCode`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanType.InsertSQL.

Tables¶

Table	Access	Columns used
PAYMENT_PLAN_TYPE_CODE	INSERT	See sample SQL

Sample SQL¶

Insert into PAYMENT_PLAN_TYPE_CODE (
  CODE,
  CODE_DESCR,
  MARKET_TYPE_CODE,
  POLICY_RENEWAL_TRACK_CODE,
  PAYROLL_REPORT_SCHEDULE_FLAG,
  GENERATE_BILLING_CODE,
  CREATE_DATE,
  CREATE_USER,
  UPDATE_DATE,
  UPDATE_USER,
  AUDIT_TYPE_CODE,
  ADJUSTED_RATE_CALCULATION_FLAG,
  NEW_POLICY_PERIOD_DEFAULT_FLAG,
  ADJUSTED_RATE_STYLE_RECAP_FLAG,
  DISPLAY_ORDER_NUM,
  PAYROLL_BY_CLASS_FLAG,
  PAYMENT_REQUIRED_FLAG,
  CREATE_PFT_CODE
)
VALUES (
  :Code,
  :Description,
  :MarketTypeCode,
  :PolicyRenewalTrackCode,
  :PayrollReportScheduleFlag,
  :GenerateBillingCode,
  :CreateDate,
  :CreateUser,
  :UpdateDate,
  :UpdateUser,
  :AuditTypeCode,
  :AdjustedRateCalculationFlag,
  :NewPolicyPeriodDefaultFlag,
  :AdjustedRateStyleRecapFlag,
  :DisplayOrderNumber,
  :PayrollByClassFlag,
  :PaymentRequiredFlag,
  :CreatePFTCode
)

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Business/SAIF.Business.Policy.Premium/Billing/clsPaymentPlanType.vb