Settings


    {$SETTING_NAME: DESCRIPTION|OPERATOR(REDUNDANT)|DATA_TYPE|LIST_ID(REDUNDANT)|[DEFAULT_VALUE(OPTIONAL)|]}


    SETTING_NAME: the name of the setting to use in the query. Usage: {$SETTING_NAME}


    OPERATOR: not used in Ivo


    DATA_TYPE

        1 = Text (will be trimmed with quotes)

        2 = Date

        3 = Number

        4 = Memo

        5 = Blob

        6 = Yes/No

        7 = Currency

        8 = Decimal

        9 = Text (will not be trimmed with quotes)


    LIST_ID: not used in Ivo


    DEFAULT_VALUE: the default value to use for the setting



    Example:

        {$StartDate: Start Date|=|2|-1|[@StartOfLastQuarter]|}


Functions


    {GetReportStatIdFromCode:CODE}


        CODE

            This is the code from the tblReportsItems table


    {DssDexFundingCodeStringByDexProgramType:PROGRAM_TYPE}


        PROGRAM_TYPE


            CHSP = 1

            NDAP = 2

            NDIS Appeals = 3

            ILC = 4

            DRC = 5

            Redress Support = 6


    {DictionaryValue:VALUE}


        VALUE 


            "act", "activity", "ent", "entity"



Variables


    {LoggedOnUserId}

    {OrganisationCode}

    {ActivityTypeDictionaryNameValue}

    {EntityTypeDictionaryNameValue}

    {ActivityTypesToIncludeInClientLists}

    {NdapFundingCodeString}

    {NacapFundingCodeString}

    {ElderAbuseFundingCodeString}