Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
What Is Attribute 4 (id4)? — Cloud Customer Connect
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)?

Accepted answer
26
Views
5
Comments
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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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