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 Name	What 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_GroupCustom	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.