Skip to main content
Skip table of contents

Appendix

The following views are included with your ICE installation. Note that you may have custom versions of these views/tables based on your requirements. 

This is not an all inclusive list of the views and tables. To retrieve a full list, you can filter your table/view list in SSMS for name contains "csi_ICE".

View NameWhat does it include?When should it be used?
vcsi_ICE_ActivityAttachment
  • URL of uploaded documents via workflow actions
  • Document name
  • Activity type
  • Product code
Pull document URL and document name without using Activity table. Link WorkflowTransGuid to Tran_Key within vcsi_ICE_WorkflowTrans to retrieve other data from workflow action. 
vcsi_ICE_ChapterInformationCustom
  • Data fields used in the ICE header typically showing chapter name, address, phone and website. 
Could be updated to include or update the data points shown in the header. 
vcsi_ICE_CommitteeCodeCustom
  • Committee Code
  • Title
  • iMIS ID (chapter/group) the committee is linked to 
Pull committee title of chapter/group linking on iMIS ID.
vcsi_ICE_CommitteeRoleSimple
  • Committee history by person by committee
  • Example fields: start/end dates, title, position code, rank, current flag, committee code, group ID
Pull current, past or future committee roster. Use ISCURRENT = '1' to pull current members. Use TERMSTATUS = 'Past' to pull past members or 'Future' for future members. Group ID is typically the chapter/group assigned to that committee. 
vcsi_ICE_DemoCustom
  • Demographics for your chapter/groups that have a page in ICE
  • Example fields: ID, is Chapter, Committee Code, Installed Year
This view is normally customized during ICE implementation. The "isChapter" field is used to control the chapter/groups listed in the Jump To list in ICE. 
vcsi_ICE_DemographicPointer
  • List of your demographic fields set up in ICE
Pull list of demographic fields and details without going into ICE Admin > Demographic > Definition.
vcsi_ICE_Form
  • List of your forms in ICE
  • Example fields: Form Code (ProductCode), Table Name, Key Field Prompt, Title, Internal note, transaction/effective/thru dates, form type, status
Pull list of forms without going into ICE Admin > Forms > Manage. 
vcsi_ICE_FormItem
  • List of the fields used within a form in ICE. 
  • Example fields: Form Code (ProductCode), Table Name, Prompt, Default Value, validation table. 
Pull list of forms without going into ICE Admin > Forms > Manage. Could link to vcsi_ICE_Form via ObjectKey field. 
vcsi_ICE_InvoiceRule
  • Workflow actions that include a fee.
  • Price is typically pulled from value set in iMIS
Pull list of workflow actions with products that are charged. Could link to Product table for current price.  Pull list of Invoice Rules without going into ICE Admin > Workflow > Review > Manage Invoice Rules.
vcsi_ICE_MessageMergeField
  • Available merge fields that can be used within ICE notification messages
Used within ICE notification messages. 
vcsi_ICE_MessageMergeFieldCustom
  • Any custom merge fields for ICE notification messages
Fields added based on client specifications.
vcsi_ICE_Notification
  • List of ICE transactional notification message settings
  • Example fields: Message Code, workflow action, workflow event (status), who the email is sent to
Pull list of transactional notifications without going into ICE Admin > Notifications > Transactional Notifications. 
vcsi_ICE_PaymentInformation
  • ICE eCheck license required
  • Transaction history of payments received via ICE
  • Example fields: Transaction Date, Payment type, Amount, Response message, Cash Account, Trans Number, BT ID
Could be used for troubleshooting a payment issue reported by a user. 
csi_ice_payments_log
  • ICE eCheck license required
  • Transaction history of invoice payments received via ICE
  • Example fields: ID, Amount, Cash Account, Payment Type, PNREF (reference number from payment processor system), Result Code, Response Message 
Could be used for troubleshooting a payment issue reported by a user.  Link to vcsi_ICE_PaymentInformation by PNREF = TRANSACTION_ID
csi_ICE_MemberDues_Cart_PaymentLog
  • ICE eCheck license required
  • Transaction history of dues payments received via ICE
  • Example fields: PNREF (reference number from payment processor system), Result Code, Response Message, Status
Could be used for troubleshooting a payment issue reported by a user.  Link to vcsi_ICE_PaymentInformation by PNREF = TRANSACTION_ID
vcsi_ICE_PendingWorkflowTran
  • List of workflow actions that are pending approval
  • Example fields: Product Code, Effected ID, Effective/Transaction Date, BT ID (chapter ID), Tran Key, Additional information fields, Batch Num
Pull list of pending transactions for staff/volunteers to manage.
vcsi_ICE_Person
  • Demographics for records in your database
  • Typically only record types that have access to ICE or that an action can be performed on
  • Example fields: ID, Address Date, Initiation information, Name information, other demographic fields
This view is normally customized during ICE implementation. It can be used in many reports in place of the Name table. 
vcsi_ICE_PersonCustom
  • Demographics for records in your database
  • Typically only record types that have access to ICE or that an action can be performed on
  • Example fields: ID, "status flags" such as Is Member, Is Deceased, Is Lost, Initation Number, Initiation Year
This view is normally customized during ICE implementation. Typically are used for qualifiers for workflow actions. 
vcsi_ICE_SecurityBase
  • List of security groups that are set up in ICE. 
  • Example fields: Title, SQL statement used, Security group code
Pull list of security groups without going into ICE Admin. 
vcsi_ICE_Setting
  • List of core settings in ICE
  • Example fields: effective date warning message, sitemap demographic pointer, member type of new contact
Pull list of settings without going into ICE Admin. 
csi_ICE_SecurityGroupInRoleBase
  • List of Security Groups with Security Permissions assigned to each. 
Pull list of security groups with permissions without going into ICE Admin. 
csi_ICE_SitemapNodes
  • List of all sitemap nodes
  • Example fields: Sitemap Node Title, Security Roles assigned, URL, Visibility Setting
Pull list of security settings by sitemap item without going into ICE Admin. 
vcsi_ICE_UDTables
  • List of demographic UD tables from iMIS that are available for use in ICE
  • Example fields: table name, multi-instance, member types set
Pull list of UD tables without querying UD_Table table.
vcsi_ICE_WorkflowProduct
  • List of workflow products in ICE. This includes membership actions, leadership actions, and forms 
  • Example fields: Product Code, Category, Title, Description
Pull list of workflow products without going into ICE Admin > Workflow > Review > Manage Products.
vcsi_ICE_WorkflowProduct_ActivityMapping
  • List of activity mappings per product code. 
  • Example fields: Product Code, Activity Type, mapping per activity field
Pull list of activity mappings without going into ICE Admin > Workflow > Review > Manage Activity Mappings.
vcsi_ICE_WorkflowProduct_ApproverGroupReq
  • List of product codes with approval requirement. 
  • Example fields: Product Code, approval level, approval count required
Pull list of approval requirements without going into ICE Admin > Workflow > Review > Manage Approvers.
vcsi_ICE_WorkflowProduct_DataPointers
  • List of additional information questions per workflow action.
  • Example fields: Product Code, data type, field name, field label (prompt), validation table, requirement status, rank
Pull list of additional information questions without going into ICE Admin > Workflow > Review > Manage Additional Information.
vcsi_ICE_WorkflowProduct_Qualifiers
  • List of qualifiers per workflow action.
  • Example fields: Product Code, demographic field name, value expected
Pull list of qualifiers without going into ICE Admin > Workflow > Review > Manage Qualifiers.
vcsi_ICE_WorkflowTran_Approvers
  • Approval verdict data
  • Example fields: Activity Sequence, ID, Verdict, Verdict Date, Transaction Number
Could be used to pull approval status per transaction. Could link to activity sequence or transaction number. 
vcsi_ICE_WorkflowTrans
  • Details per workflow action. 
  • Example fields: Product Code, effected ID, dates, chapter ID, workflow tran key, stage, additional information data fields, batch number
Pull details for workflow actions. This view can be helpful to pull workflow transaction data without pulling from Activity table in case there is no activity mapped or not all data is mapped to activity. 


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.