Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = 'PhoneFinder Submit Process' The name of the submit process
 CREATEOUTPUTIDSET bit   Default = 0 Whether or not to create a selection of constituents as a result of the submit process
 OUTPUTIDSETNAME nvarchar(300)   Default = '' The name of the selection to create as a result of the submit process
 OVERWRITEOUTPUTIDSET bit   Default = 0 Whether or not to overwrite an existing selection if one by 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.
 INDIVIDUALADDRESSINCLUDECODE tinyint   Default = 0 The type of address to use in the process
 INDIVIDUALADDRESSINCLUDE nvarchar(16) (Computed) CASE [INDIVIDUALADDRESSINCLUDECODE] WHEN 0 THEN N'Primary address' WHEN 1 THEN N'Specific address' END Provides a translation for the 'INDIVIDUALADDRESSINCLUDECODE' field.
 ORGANIZATIONADDRESSINCLUDECODE tinyint   Default = 0 The type of address to use in the process
 ORGANIZATIONADDRESSINCLUDE nvarchar(16) (Computed) CASE [ORGANIZATIONADDRESSINCLUDECODE] WHEN 0 THEN N'Primary address' WHEN 1 THEN N'Specific address' END Provides a translation for the 'ORGANIZATIONADDRESSINCLUDECODE' field.
 INDIVIDUALPHONENUMBERINCLUDECODE tinyint   Default = 0 The type of phone number to use in the process for individuals
 INDIVIDUALPHONENUMBERINCLUDE nvarchar(21) (Computed) CASE [INDIVIDUALPHONENUMBERINCLUDECODE] WHEN 0 THEN N'Primary phone number' WHEN 1 THEN N'Specific phone number' END Provides a translation for the 'INDIVIDUALPHONENUMBERINCLUDECODE' field.
 ORGANIZATIONPHONENUMBERINCLUDECODE tinyint   Default = 0 The type of phone number to use in the process for organizations
 ORGANIZATIONPHONENUMBERINCLUDE nvarchar(21) (Computed) CASE [ORGANIZATIONPHONENUMBERINCLUDECODE] WHEN 0 THEN N'Primary phone number' WHEN 1 THEN N'Specific phone number' END Provides a translation for the 'ORGANIZATIONPHONENUMBERINCLUDECODE' field.
 INCLUDEINACTIVE bit   Default = 0 Include inactive constituents
 INCLUDEINCOMPLETEADDRESSES bit   Default = 0 Include incomplete addresses
 DATELASTRUN datetime The last date this process was run
 CREATENEWBATCH bit   Default = 0 Whether or not a new batch should be created the next time this process is run

Foreign Key Field Type Null Notes Description
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID The selection of constituents to submit
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 PHONEFINDERID uniqueidentifier   PHONEFINDER.ID The PhoneFinder process this submit process belongs to
 INDIVIDUALADDRESSTYPECODEID uniqueidentifier ADDRESSTYPECODE.ID The specific address type to use for individuals
 ORGANIZATIONADDRESSTYPECODEID uniqueidentifier ADDRESSTYPECODE.ID The specific address type to use for organizations
 INDIVIDUALPHONETYPECODEID uniqueidentifier PHONETYPECODE.LOCALID The specific phone type to use for individuals.
 ORGANIZATIONPHONETYPECODEID uniqueidentifier PHONETYPECODE.LOCALID The specific phone type to use for organizations

Index Name Field(s) Unique Primary Clustered
 IX_PHONEFINDERSUBMITPROCESS_DATEADDED DATEADDED    
 IX_PHONEFINDERSUBMITPROCESS_DATECHANGED DATECHANGED      
 PK_PHONEFINDERSUBMITPROCESS ID  
 UC_PHONEFINDERSUBMITPROCESS_PHONEFINDERID PHONEFINDERID    

Trigger Name Description
 TR_PHONEFINDERSUBMITPROCESS_AUDIT_UPDATE
 TR_PHONEFINDERSUBMITPROCESS_AUDIT_DELETE

Referenced by Field
 PHONEFINDERSUBMITPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table