Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

What Is Attribute 4 (id4)?

edited Nov 6, 2018 5:08AM in Reporting & Analytics for B2C Service 5 comments

Summary

What value is contained in the transactions.id4 column?

Content

We have created an analytics report for the transactions table that outputs the transactions.id4 column. The report contains filters that limit the results WHERE transactions.tbl = 1 AND transactions.trans_type = 24. According to the data dictionary, these are the joins for the transactions.id4 column:

  • mailings.mailing_id where transactions.tbl = 53, transactions.trans_type = 24
  • channel_types.chan_type_id where transactions.tbl = 1, transactions.trans_type = 8
  • channel_types.chan_type_id where transactions.tbl = 1, transactions.trans_type = 37
  • channel_types.chan_type_id where transactions.tbl = 1, transactions.trans_type = 51

For our use case of transactions.id = 1 and transactions.trans_type = 24, the value contained in this column appears to be undocumented. These are examples of the values that are populated in the column:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!