RE7 Schema -- Code table for Event Participation

Options
Jonathon Gillenwater
Jonathon Gillenwater Blackbaud Employee
Fourth Anniversary Blackbaud Staff Inquirer Level 1
in Blackbaud Raiser's Edge NXT®: General Discussion

Currently using RODBA and Microsoft Access with RE. I am trying to find the code table for Event Participation field, but am unable to locate it in the RE 7 schema. Does anyone happen to know where this 4 digit code is located in the schema? Please see image

e899828d841d312f552aa602bc0d83c7-huge-im
Tagged:

Comments

  • Alan French
    Alan French
    Tenth Anniversary 1,000 Likes 500 Comments Name Dropper

    I think they might be in the TABLEENTRIESID column in the TABLEENTRIES table? I'm having some technical issues with RE this morning though so I can't check if that's the right field at the moment.

  • Rosa Crichton
    Rosa Crichton
    Seventh Anniversary First Comment Activity: First Reply Facilitator Level 1

    Alan and Jonathan, I am also using Access for custom reporting. Is there another way to write dbo.tmp tables. The table name keeps changes everyday. ie below.

    DBO.tmp221004_1064332690_1 AS T_2_3_2029
    DBO.tmp221005_1064332690_1 AS T_3_3_2030

    DBO.tmp220814_1064332690_1 AS T_2_3_2029
    DBO.tmp220815_1064332690_1 AS T_3_3_2030

    Thanks in advance,

    Rosa

Categories