Add(Int32,Int32,Int32,Nullable<Double>,DBDouble,DBDouble,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,DBDouble,DBDouble,Nullable<Boolean>,Nullable<Boolean>,DBInt,DBInt,DBInt,DBInt,DBInt,DBInt,DBInt,DBInt,DBInt,DBDouble,DBInt,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBDouble,DBInt,Nullable<Int32>,DBInt,DBInt,Int32,DBString,DateTime) Method

• Visual Basic
• C#

'Declaration
 
Public Overloads Shared Sub Add( _
   ByVal sessionId As Integer, _
   ByVal qmSpecId As Integer, _
   ByVal charId As Integer, _
   ByVal target As Nullable(Of Double), _
   ByVal lsv As DBDouble, _
   ByVal usv As DBDouble, _
   ByVal lsvIsOffset As Nullable(Of Boolean), _
   ByVal usvIsOffset As Nullable(Of Boolean), _
   ByVal lsvOffsetIsPct As Nullable(Of Boolean), _
   ByVal usvOffsetIsPct As Nullable(Of Boolean), _
   ByVal lrv As DBDouble, _
   ByVal urv As DBDouble, _
   ByVal lrvIsMult As Nullable(Of Boolean), _
   ByVal urvIsMult As Nullable(Of Boolean), _
   ByVal severityCd As DBInt, _
   ByVal planId As DBInt, _
   ByVal sampleSizeSource As DBInt, _
   ByVal normalSampleSize As DBInt, _
   ByVal minimumSampleSize As DBInt, _
   ByVal maximumSampleSize As DBInt, _
   ByVal clSource As DBInt, _
   ByVal samplesForCl As DBInt, _
   ByVal samplesBeforeCl As DBInt, _
   ByVal stdAvg As DBDouble, _
   ByVal stdAvgIsTarget As DBInt, _
   ByVal stdDeviation As DBDouble, _
   ByVal clXbar As DBDouble, _
   ByVal lclXbar As DBDouble, _
   ByVal uclXbar As DBDouble, _
   ByVal clRange As DBDouble, _
   ByVal lclRange As DBDouble, _
   ByVal uclRange As DBDouble, _
   ByVal clSigma As DBDouble, _
   ByVal lclSigma As DBDouble, _
   ByVal uclSigma As DBDouble, _
   ByVal clIx As DBDouble, _
   ByVal lclIx As DBDouble, _
   ByVal uclIx As DBDouble, _
   ByVal clImr As DBDouble, _
   ByVal lclImr As DBDouble, _
   ByVal uclImr As DBDouble, _
   ByVal clMa As DBDouble, _
   ByVal lclMa As DBDouble, _
   ByVal uclMa As DBDouble, _
   ByVal clMr As DBDouble, _
   ByVal lclMr As DBDouble, _
   ByVal uclMr As DBDouble, _
   ByVal clMs As DBDouble, _
   ByVal lclMs As DBDouble, _
   ByVal uclMs As DBDouble, _
   ByVal clP As DBDouble, _
   ByVal lclP As DBDouble, _
   ByVal uclP As DBDouble, _
   ByVal clNp As DBDouble, _
   ByVal lclNp As DBDouble, _
   ByVal uclNp As DBDouble, _
   ByVal clC As DBDouble, _
   ByVal lclC As DBDouble, _
   ByVal uclC As DBDouble, _
   ByVal clU As DBDouble, _
   ByVal lclU As DBDouble, _
   ByVal uclU As DBDouble, _
   ByVal defaultChart As DBInt, _
   ByVal automatedColl As Nullable(Of Integer), _
   ByVal timeInterval As DBInt, _
   ByVal timeIntUnit As DBInt, _
   ByVal displaySeq As Integer, _
   ByVal lastEditComment As DBString, _
   ByRef lastEditAt As Date _
) 

'Usage
 
Dim sessionId As Integer
Dim qmSpecId As Integer
Dim charId As Integer
Dim target As Nullable(Of Double)
Dim lsv As DBDouble
Dim usv As DBDouble
Dim lsvIsOffset As Nullable(Of Boolean)
Dim usvIsOffset As Nullable(Of Boolean)
Dim lsvOffsetIsPct As Nullable(Of Boolean)
Dim usvOffsetIsPct As Nullable(Of Boolean)
Dim lrv As DBDouble
Dim urv As DBDouble
Dim lrvIsMult As Nullable(Of Boolean)
Dim urvIsMult As Nullable(Of Boolean)
Dim severityCd As DBInt
Dim planId As DBInt
Dim sampleSizeSource As DBInt
Dim normalSampleSize As DBInt
Dim minimumSampleSize As DBInt
Dim maximumSampleSize As DBInt
Dim clSource As DBInt
Dim samplesForCl As DBInt
Dim samplesBeforeCl As DBInt
Dim stdAvg As DBDouble
Dim stdAvgIsTarget As DBInt
Dim stdDeviation As DBDouble
Dim clXbar As DBDouble
Dim lclXbar As DBDouble
Dim uclXbar As DBDouble
Dim clRange As DBDouble
Dim lclRange As DBDouble
Dim uclRange As DBDouble
Dim clSigma As DBDouble
Dim lclSigma As DBDouble
Dim uclSigma As DBDouble
Dim clIx As DBDouble
Dim lclIx As DBDouble
Dim uclIx As DBDouble
Dim clImr As DBDouble
Dim lclImr As DBDouble
Dim uclImr As DBDouble
Dim clMa As DBDouble
Dim lclMa As DBDouble
Dim uclMa As DBDouble
Dim clMr As DBDouble
Dim lclMr As DBDouble
Dim uclMr As DBDouble
Dim clMs As DBDouble
Dim lclMs As DBDouble
Dim uclMs As DBDouble
Dim clP As DBDouble
Dim lclP As DBDouble
Dim uclP As DBDouble
Dim clNp As DBDouble
Dim lclNp As DBDouble
Dim uclNp As DBDouble
Dim clC As DBDouble
Dim lclC As DBDouble
Dim uclC As DBDouble
Dim clU As DBDouble
Dim lclU As DBDouble
Dim uclU As DBDouble
Dim defaultChart As DBInt
Dim automatedColl As Nullable(Of Integer)
Dim timeInterval As DBInt
Dim timeIntUnit As DBInt
Dim displaySeq As Integer
Dim lastEditComment As DBString
Dim lastEditAt As Date
 
QmSpecCharLink.Add(sessionId, qmSpecId, charId, target, lsv, usv, lsvIsOffset, usvIsOffset, lsvOffsetIsPct, usvOffsetIsPct, lrv, urv, lrvIsMult, urvIsMult, severityCd, planId, sampleSizeSource, normalSampleSize, minimumSampleSize, maximumSampleSize, clSource, samplesForCl, samplesBeforeCl, stdAvg, stdAvgIsTarget, stdDeviation, clXbar, lclXbar, uclXbar, clRange, lclRange, uclRange, clSigma, lclSigma, uclSigma, clIx, lclIx, uclIx, clImr, lclImr, uclImr, clMa, lclMa, uclMa, clMr, lclMr, uclMr, clMs, lclMs, uclMs, clP, lclP, uclP, clNp, lclNp, uclNp, clC, lclC, uclC, clU, lclU, uclU, defaultChart, automatedColl, timeInterval, timeIntUnit, displaySeq, lastEditComment, lastEditAt)

public static void Add( 
   int sessionId,
   int qmSpecId,
   int charId,
   Nullable<double> target,
   DBDouble lsv,
   DBDouble usv,
   Nullable<bool> lsvIsOffset,
   Nullable<bool> usvIsOffset,
   Nullable<bool> lsvOffsetIsPct,
   Nullable<bool> usvOffsetIsPct,
   DBDouble lrv,
   DBDouble urv,
   Nullable<bool> lrvIsMult,
   Nullable<bool> urvIsMult,
   DBInt severityCd,
   DBInt planId,
   DBInt sampleSizeSource,
   DBInt normalSampleSize,
   DBInt minimumSampleSize,
   DBInt maximumSampleSize,
   DBInt clSource,
   DBInt samplesForCl,
   DBInt samplesBeforeCl,
   DBDouble stdAvg,
   DBInt stdAvgIsTarget,
   DBDouble stdDeviation,
   DBDouble clXbar,
   DBDouble lclXbar,
   DBDouble uclXbar,
   DBDouble clRange,
   DBDouble lclRange,
   DBDouble uclRange,
   DBDouble clSigma,
   DBDouble lclSigma,
   DBDouble uclSigma,
   DBDouble clIx,
   DBDouble lclIx,
   DBDouble uclIx,
   DBDouble clImr,
   DBDouble lclImr,
   DBDouble uclImr,
   DBDouble clMa,
   DBDouble lclMa,
   DBDouble uclMa,
   DBDouble clMr,
   DBDouble lclMr,
   DBDouble uclMr,
   DBDouble clMs,
   DBDouble lclMs,
   DBDouble uclMs,
   DBDouble clP,
   DBDouble lclP,
   DBDouble uclP,
   DBDouble clNp,
   DBDouble lclNp,
   DBDouble uclNp,
   DBDouble clC,
   DBDouble lclC,
   DBDouble uclC,
   DBDouble clU,
   DBDouble lclU,
   DBDouble uclU,
   DBInt defaultChart,
   Nullable<int> automatedColl,
   DBInt timeInterval,
   DBInt timeIntUnit,
   int displaySeq,
   DBString lastEditComment,
   out DateTime lastEditAt
)

Parameters

sessionId

Required. Holds the session ID of the user who is making this method call.

qmSpecId

Required. Holds the ID assigned to the specification that is being linked.

charId

Required. Holds the ID assigned to the characteristic that is being linked.

target

Required. Holds the target value for this characteristic.

lsv

Optional. Holds the lower specification value.

usv

Optional. Holds the upper specification value.

lsvIsOffset

Optional. Holds a logical data type (which is a flag) if lsv is the difference between target and lsl, that is, lsv is not equal to lower spec limit (lsl) but is an offset.

usvIsOffset

Optional. Holds a logical data type (which is a flag) if usv is the difference between usl and target, that is, usv is not equal to upper spec limit (usl) but is an offset.

lsvOffsetIsPct

Optional. Holds a logical data type (which is a flag) if lsv is an offset. Is it a percent of the target? Default = Yes.

usvOffsetIsPct

Optional. Holds a logical data type which is a flag if usv is an offset. Is it a percent of the target? Default = Yes.

lrv

Optional. Holds the lower reasonable value.

urv

Optional. Holds the upper reasonable value.

lrvIsMult

Optional. Holds a logical data type (which is a flag) if lrv is a multiplier for the difference between the lower spec limits and target, to find offset from target for lrl; if not, lrv - lower reasonable limit (an absolute value).

urvIsMult

Optional. Holds a logical data type (which is a flag) if urv is a multiplier for the difference between the upper spec limits and target, to find offset from target for url; if no, urv - upper reasonable limit (an absolute value).

severityCd

Optional. Holds the severity of the characteristic.

planId

Unused. Holds the ID of the plan. This will be ignored and null will be stored in the database.

sampleSizeSource

Optional. Holds the source of the sample size.

normalSampleSize

Optional. Holds the normal number of measurements in a sample.

minimumSampleSize

Optional. Holds the minimum number of measurements in a sample.

maximumSampleSize

Optional. Holds the maximum number of measurements in a sample.

clSource

Optional. Holds an enumeration that indicates the control limit source.

0 = automatically calculate from data (default)

1 = compute from standard mean and standard deviation values (if variable) or compute from standard p, np average proportion and standard c, u average number per unit values (if attribute)

2 = use preset values

samplesForCl

Optional. Holds the number of samples to use for the calculation of control limits.

samplesBeforeCl

Optional. Holds the number of samples required before control limits are calculated.

stdAvg

Optional. Holds the standard average value.

If cl_source = 1 and type is variable, this is the standard mean.

If type is binary attribute, this is the standard p, np average proportion value.

If type is counted attribute this is the standard c, u average number per unit value.

stdAvgIsTarget

Optional. Holds the value 1 to use the target instead of the std_avg value as the standard, else 0. If not null, used to override the std_avg_is_target setting for the characteristic.

stdDeviation

Optional. Holds the standard deviation value.

clXbar

Optional. Holds the center line for xbar chart.

lclXbar

Optional. Holds the lower control limit for xbar chart.

uclXbar

Optional. Holds the upper control limit for xbar chart.

clRange

Optional. Holds the center line for range.

lclRange

Optional. Holds the lower control limit for range.

uclRange

Optional. Holds the upper control limit for range.

clSigma

Optional. Holds the center line for sigma.

lclSigma

Optional. Holds the lower control limit for sigma.

uclSigma

Optional. Holds the upper control limit for sigma.

clIx

Optional. Holds the center line for an individual x.

lclIx

Optional. Holds the lower control limit for an individual x.

uclIx

Optional. Holds the upper control limit for an individual x.

clImr

Optional. Holds the center line for an individual moving range.

lclImr

Optional. Holds the lower control limit for an individual moving range.

uclImr

Optional. Holds the upper control limit for an individual moving range.

clMa

Optional. Holds the center line for a moving average.

lclMa

Optional. Holds the lower control limit for a moving average.

uclMa

Optional. Holds the upper control limit for a moving average.

clMr

Optional. Holds the center line for a moving range.

lclMr

Optional. Holds the lower control limit for a moving range.

uclMr

Optional. Holds the upper control limit for a moving range.

clMs

Optional. Holds the center line for a moving sigma.

lclMs

Optional. Holds the lower control limit for a moving sigma.

uclMs

Optional. Holds the upper control limit for a moving sigma.

clP

Optional. Holds the center line for p chart.

lclP

Optional. Holds the lower control limit for p chart.

uclP

Optional. Holds the upper control limit for p chart.

clNp

Optional. Holds the center line for np chart.

lclNp

Optional. Holds the lower control limit for np chart.

uclNp

Optional. Holds the upper control limit for np chart.

clC

Optional. Holds the center line for c chart.

lclC

Optional. Holds the lower control limit for c chart.

uclC

Optional. Holds the upper control limit for c chart.

clU

Optional. Holds the center line for u chart.

lclU

Optional. Holds the lower control limit for u chart.

uclU

Optional. Holds the upper control limit for u chart.

defaultChart

Optional. Holds an enumeration that specifies the default chart type for the characteristic.

2 = Xbar + Range

3 = Xbar + Sigma

5 = IX + MR (the default)

7 = MA + Range

8 = MA + Sigma

16 = p

17 = np

18 = u

19 = c

20 = DPMO (coding per QI Analyst)

automatedColl

Optional. Holds an enumeration that indicates whether this characteristic can be collected automatically.

0 = No

1 = Yes

2 = Use the characteristic's automated_coll setting (the default)

timeInterval

Optional. If sample size > 1 and automated_coll is Yes, holds the interval between the measurements.

Note that this is a default for the characteristic, which can be overridden independently at each SRO.

timeIntUnit

Optional. Holds an enumeration that indicates the units of the time interval between the measurements.

0 = seconds

1 = minutes

2 = hours

displaySeq

Required. Holds the value for the display sequence of the specification-characteristic link (see Remarks). The default value is 1. The value must be 1 or greater.

lastEditComment

Optional. Holds the comments that describe why this record is being added.

lastEditAt

Output. Holds the datetime of the record in the Qm_Spec_Char_Link table when link is created.