Adds Data Sets to SDIs.

sdcid

Identifier of the SDC.

Yes

keyid1

Identifiers of the SDIs.

Yes

keyid2

Identifiers of the SDIs.

Only for multi-key SDCs.

keyid3

Identifiers of the SDIs.

Only for multi-key SDCs.

paramlistid

Identifier of the Parameter List.

Yes

paramlistversionid

Identifier of the Parameter List Version.

Yes

variantid

Identifier of the Parameter List Variant.

Yes

dataset

Data Set Number.

No

If you do not specify a value, the next highest Data Set Number is used.

paramid

Identifier of the Parameter you are adding to the Data Set.

No.

paramtype

Identifier of the Parameter Type.

No.

replicateid

Identifiers of the Parameter Replicates.

No.

applylock

Determines whether or not (Y/N) data are locked during Action processing.

No

rsetid

Identifier of the RSet that is passed into this Action.

No.

This is useful if you have created an RSet in another Action and want to use those values in this Action.
For example, suppose you have created an RSet in Action-001, and the Rset contains SDCId and KeyId values from multiple SDIs. You want to pass these values into Action-007. Rather than specifying all of these values in Action-007, you can simply specify the RSetId from Action-001.
An added advantage is that if data are locked in the Action-001 RSet, they will be locked in Action-007 as well.

propsmatch

Determines how multiple property values are associated with SDIs.

Yes

To demonstrate use of this property for all Actions that support it, here is a generic example. Consider these property values:

• sdcid = NSAID
• keyid1 = ibuprofen;naproxen
• buffer = Na3PO4;CH3COONa

In this case:

• propsmatch = Y associates each buffer with each SDI, i.e.,
  ibuprofen's buffer is Na3PO4, naproxen's buffer is CH3COONa.
• propsmatch = N associates both buffers with each SDI, i.e.,
  both ibuprofen and naproxen use Na3PO4 and CH3COONa as buffers.

auditreason

Auditing information recorded in the "Reason" column of the TraceLog table.

No

auditactivity

Auditing information recorded in the "Activity" column of the TraceLog table.

No

auditsignedflag

Auditing information recorded in the "SignedFlag" column of the TraceLog table.

No

auditdt

Auditing information recorded in the "ModDt" column of the TraceLog table.

No

param

workflowid

Identifier of the Workflow.

As of version 7, ServerSide Workflow are not longer available

workflowversionid

Identifier of the Workflow Version.

As of version 7, ServerSide Workflow are not longer available

workflowinstance

Identifier of the Workflow Instance.

As of version 7, ServerSide Workflow are not longer available

addnewonly

Yes

matchusersequence

newds

available

Determines whether or not (Y/N) data can be entered for the Data Set.

No

adddataitems

trackitemid

scheduleplanid

scheduleplanitemid

s_qcbatchid

s_qcbatchitemid

qcbatchid

- Undocumented property for internal use only

qcbatchitemid

- Undocumented property for internal use only

createworksheet

Determines if the worksheet(s) would be created or not. Default to Y.

No

Only single value is accepted. Determines whether a worksheet will be created or not. If value is "Y" then it will check if the createworksheetrule is 'On Creation' or 'On Assignment'. If 'On Creation' then it will create worksheet. If 'On Assignment' then it will check if this dataset is assigned to any analyst/role/department. If yes, then creates worksheet.

formid

Determines the form which would be used to create worksheet for the workitems.

No

Only single value is accepted.
Worksheet would only be created if createworksheetrule for the Param List is 'On Creation' or 'On Assignment' and the dataset is being assigned to any analyst/dept.
If a form is passed in explicitly then it would be used, else the default form is retrieved from the Param List definition.

formversionid

The formversionid of the form.

No

Only single value is accepted.

securityuser

Overrides the departmental security user of the paramlist

No

securitydepartment

Overrides the departmental security department of the paramlist

No

newdatasetinstancexml

Instance numbers of the new Datasets. When calling this Action from code, this is an XML file that can be passed into the constructor of a DataSet object.

This Action inserts a new record in the SDIData table, and can also affect records in the SDIData, SDIDataItem, SDIDataItemLimits, and SDIDataApproval tables.