Table: EMS Interest Code Tables

  • CSI_CSiDonate_InterestDefinition
  • CSI_CSiDonate_InterestFunds

Purpose

This standalone panel source replaces the interest fund definitions available in iMIS 2017. These only apply to iMIS EMS.

Schema: CSI_CSiDonate_InterestDefinition

Column NameColumn Type (iMIS)Column Type (SQL)Description
CodeCHAR (Length: 10)VARCHAR(10)The code associated with your interest definition.
DescriptionCHAR (Length: 255)VARCHAR(255)The description of the interest code defined.

Schema: CSI_CSiDonate_InterestFunds

Column NameColumn Type (iMIS)Column Type (SQL)Description
FundCodeCHAR (Length: 5)VARCHAR(5)The fund code to associate with the interest code.
InterestCodeCHAR (Length: 10)VARCHAR(10)The corresponding interest code defined in the table above.

Did this page help you?