Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the parameter set.
 DESCRIPTION nvarchar(255)   Default = '' The description of the parameter set.
 POPULATEMETHODCODE tinyint   Default = 0 This field specifies the method by which the process will populate the research group.
 CREATEOUTPUTIDSET bit   Default = 0 Designates whether or not an ID set should be created as a result of the process.
 OUTPUTIDSETNAME nvarchar(100)   Default = '' The name of the output ID set to be created by the process.
 OVERWRITEOUTPUTIDSET bit   Default = 0 Designates whether or not to overwrite the output ID set if one with the same name already exists.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 POPULATEMETHOD nvarchar(33) (Computed) CASE [POPULATEMETHODCODE] WHEN 0 THEN N'Add members from selection' WHEN 1 THEN N'Update member list from selection' END Provides a translation for the 'POPULATEMETHODCODE' field.
 DATELASTRUN datetime This date is used to filter records by the date the process was last run.

Foreign Key Field Type Null Notes Description
 RESEARCHGROUPID uniqueidentifier   RESEARCHGROUP.ID A foreign key to the ID of the research group to which the process will be applied.
 IDSETREGISTERID uniqueidentifier   IDSETREGISTER.ID A foreign key to the ID set used to filter which records the process will use populate the research group.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_RESEARCHGROUPPOPULATEPROCESS_DATEADDED DATEADDED    
 IX_RESEARCHGROUPPOPULATEPROCESS_DATECHANGED DATECHANGED      
 PK_RESEARCHGROUPPOPULATEPROCESS ID  
 UC_RESEARCHGROUPPOPULATEPROCESS_NAME NAME    

Trigger Name Description
 TR_RESEARCHGROUPPOPULATEPROCESS_AUDIT_UPDATE
 TR_RESEARCHGROUPPOPULATEPROCESS_AUDIT_DELETE

Referenced by Field
 RESEARCHGROUPPOPULATEPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table