RE7 Schema -- Code table for Event Participation

Options

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

Comments

  • 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.

  • 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