This view provides detail information about expert and feedback conversations.
THREAD_DETAIL_ID (Oracle = number (10, 0)), (SQL = int)
The unique identifier of each question, answer or feedback comment on a server.
This field is a primary key.
THREAD_ID (Oracle = number (10, 0)), (SQL = int)
The unique identifier of each conversation.
TITLELEARNINGOBJECTID (Oracle = number (10, 0)), (SQL = int)
The identifier of the title Learning Object associated with the conversation.
TITLENAME (Oracle = nvarchar2), (SQL = nvarchar)
The title name of the conversation.
PATHNODE_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier of the activity (as specified in ACTIVITY_ID column) associated with the conversation.
ACTIVITYNAME (Oracle = nvarchar2), (SQL = nvarchar)
The activity name associated with the conversation.
LEARNINGOBJECTID (Oracle = number (10, 0)), (SQL = int)
Unique identifier of Learning Object associated with the conversation.
LERNINGOBJECTNAME (Oracle = nvarchar2), (SQL = nvarchar)
Name of the learning object associated with the conversation.
PATH (Oracle = nvarchar2), (SQL = nvarchar)
Location of the the learning object in the title tree.
SUBJECT (Oracle = nvarchar2), (SQL = nvarchar)
Subject text entered by user starting the conversation.
PLAY_MODE (Oracle = nvarchar2), (SQL = nvarchar)
The topic play mode type playing when the user started the expert or feedback conversation from a topic.
S = See It!
T = Try It!
K = Know It?
D = Do It!
FRAMEID (Oracle = nvarchar2), (SQL = nvarchar)
The ID of the frame in the topic when the user started the conversation from a topic.
LASTACTIONDATE (Oracle = date), (SQL = datetime)
The date of the last comment entered for the conversation.
FEEDBACKTYPEID (Oracle = number (10, 0)), (SQL = int)
Indicates whether the entry in the thread detail is part of a question or feedback conversation.
1 = Expert Advice
2 = Feedback
DIRECTION (Oracle = number (10, 0)), (SQL = int)
Indicates if the source of the thread detail is submitted to an expert or feedback monitor or is an answer from an expert or feedback monitor.
0 = Questions or feedback comments submitted to an expert or feedback monitor
1 = Answers or feedback replies from an expert or feedback monitor
USERID (Oracle = number (10, 0)), (SQL = int)
Unique identifier for the user.
USERNAME (Oracle = nvarchar2), (SQL = nvarchar)
Username that the user.
LASTNAME (Oracle = nvarchar2), (SQL = nvarchar)
User’s last name.
FIRSTNAME (Oracle = nvarchar2), (SQL = nvarchar)
User’s first name.
CREATEDATE (Oracle = timestamp (6)), (SQL = datetime)
The date when the thread detail of the conversation was created.
DETAILTEXT (Oracle = nclob), (SQL = ntext)
The text of the thread detail.