Jdruker/GCXI PG Queries Attributes

The "displayFolder" column should match the "Folder: {{{folder}}}" subhead and should always be populated.

• If "definedFolder" = the folder in the subhead, "displayFolder" = "definedFolder"
• Otherwise, "displayFolder" = "displaysInFolder"

Why are the query results sometimes correct and sometimes not? Compare the results on this page, which calls the top-level query for the Agent page and where some of the results are incomplete, with the results on User:Jdruker/GCXI_PG_Queries_Attributes2, where individual subordinate queries always seem to return full results.

Incomplete results on this page start from Folder: Agent > Detail > Ixn State.

Query for Agent attributes

Top-level query from Template:GCXI_Attributes_Display using diagnostic formatting template Template:GCXI_Attributes_DisplayDetails_Test. Results are inconsistent.

Folder: Agent

attr	definedFolder	displaysInFolder	displayFolder	form	anchor
attr	definedFolder	displaysInFolder	displayFolder	form	anchor
Agent Group	Agent	Agent > Activity	Agent		AgentAgentGroup
Agent Name	Agent	Agent > Activity	Agent	User Name • Last Name • First Name • Employee ID	AgentAgentName
Agent Resource Key	Agent		Agent		AgentAgentResourceKey
Group Combination Key	Agent		Agent		AgentGroupCombinationKey
Group Key	Agent		Agent		AgentGroupKey

Folder: Agent > Activity

attr	definedFolder	displaysInFolder	displayFolder	form	anchor
attr	definedFolder	displaysInFolder	displayFolder	form	anchor
Agent Group	Agent	Agent > Activity	Agent > Activity		AgentAgentGroup
Agent Name	Agent	Agent > Activity	Agent > Activity	User Name • Last Name • First Name • Employee ID	AgentAgentName

Folder: Agent > Activity > Activity Call Survey

There are no attributes in this folder.

Folder: Agent > Activity > Activity User Data Example

There are no attributes in this folder.

Folder: Agent > Activity > Queue

There are no attributes in this folder.

Folder: Agent > Detail

There are no attributes in this folder.

Folder: Agent > Detail > Ixn State

attr	definedFolder	displaysInFolder	displayFolder	form	anchor
attr	definedFolder	displaysInFolder	displayFolder	form	anchor
Additional Info	Agent > Detail > Ixn State		Agent > Detail > Ixn State		AgentDetailIxnStateAdditionalInfo
End Timestamp	Agent > Detail > Ixn State		Agent > Detail > Ixn State		AgentDetailIxnStateEndTimestamp
Interaction Type	Agent > Detail > Ixn State		Agent > Detail > Ixn State		AgentDetailIxnStateInteractionType
Start Timestamp	Agent > Detail > Ixn State		Agent > Detail > Ixn State		AgentDetailIxnStateStartTimestamp
State	Agent > Detail > Ixn State		Agent > Detail > Ixn State		AgentDetailIxnStateState

Folder: Agent > Detail > Session

attr	definedFolder	displaysInFolder	displayFolder	form	anchor
attr	definedFolder	displaysInFolder	displayFolder	form	anchor
Active	Agent > Detail > Session		Agent > Detail > Session		AgentDetailSessionActive
End Timestamp	Agent > Detail > Session		Agent > Detail > Session		AgentDetailSessionEndTimestamp
Session Key	Agent > Detail > Session		Agent > Detail > Session		AgentDetailSessionSessionKey
Start Timestamp	Agent > Detail > Session		Agent > Detail > Session		AgentDetailSessionStartTimestamp

Folder: Agent > Detail > State

attr	definedFolder	displaysInFolder	displayFolder	form	anchor
attr	definedFolder	displaysInFolder	displayFolder	form	anchor
Active Reason	Agent > Detail > State		Agent > Detail > State		AgentDetailStateActiveReason
Active State	Agent > Detail > State		Agent > Detail > State		AgentDetailStateActiveState
End Timestamp	Agent > Detail > State		Agent > Detail > State		AgentDetailStateEndTimestamp
Reason Code	Agent > State and Reason	Agent > Detail > State	Agent > Detail > State		AgentStateandReasonReasonCode
Reason Key	Agent > State and Reason	Agent > Detail > State	Agent > Detail > State		AgentStateandReasonReasonKey
Reason Timestamp	Agent > Detail > State		Agent > Detail > State		AgentDetailStateReasonTimestamp
Reason Type Code	Agent > State and Reason	Agent > Detail > State	Agent > Detail > State		AgentStateandReasonReasonTypeCode
Reason Value	Agent > State and Reason	Agent > Detail > State	Agent > Detail > State		AgentStateandReasonReasonValue
Start Timestamp	Agent > Detail > State		Agent > Detail > State		AgentDetailStateStartTimestamp
State	Agent > Detail > State		Agent > Detail > State	State Type Code	AgentDetailStateState

Folder: Agent > Group Membership

attr	definedFolder	displaysInFolder	displayFolder	form	anchor
attr	definedFolder	displaysInFolder	displayFolder	form	anchor
Agent Group	Agent > Group Membership		Agent > Group Membership		AgentGroupMembershipAgentGroup
Agent Name	Agent > Group Membership		Agent > Group Membership	User Name • Last Name • First Name • Employee ID	AgentGroupMembershipAgentName
Agent Resource Key	Agent > Group Membership		Agent > Group Membership		AgentGroupMembershipAgentResourceKey
Date Added	Agent > Group Membership		Agent > Group Membership		AgentGroupMembershipDateAdded
Date Removed	Agent > Group Membership		Agent > Group Membership		AgentGroupMembershipDateRemoved
End TS	Agent > Group Membership		Agent > Group Membership		AgentGroupMembershipEndTS
Group Key	Agent > Group Membership		Agent > Group Membership		AgentGroupMembershipGroupKey
Start Date Time Key	Agent > Group Membership		Agent > Group Membership		AgentGroupMembershipStartDateTimeKey

Folder: Agent > State and Reason

attr	definedFolder	displaysInFolder	displayFolder	form	anchor
attr	definedFolder	displaysInFolder	displayFolder	form	anchor
Agent Group	Agent	Agent > State and Reason	Agent > State and Reason		AgentAgentGroup
Agent Name	Agent	Agent > State and Reason	Agent > State and Reason	User Name • Last Name • First Name • Employee ID	AgentAgentName
Group Combination Sess Key	Agent > State and Reason		Agent > State and Reason		AgentStateandReasonGroupCombinationSessKey
Reason Code	Agent > State and Reason	Agent > Detail > State	Agent > State and Reason		AgentStateandReasonReasonCode
Reason Key	Agent > State and Reason	Agent > Detail > State	Agent > State and Reason		AgentStateandReasonReasonKey
Reason Type Code	Agent > State and Reason	Agent > Detail > State	Agent > State and Reason		AgentStateandReasonReasonTypeCode
Reason Value	Agent > State and Reason	Agent > Detail > State	Agent > State and Reason		AgentStateandReasonReasonValue
Resource State Reason Key	Agent > State and Reason		Agent > State and Reason		AgentStateandReasonReasourceStateResourceKey
State Name	Agent > State and Reason		Agent > State and Reason	State Type Code	AgentStateandReasonStateName

Folder: Agent > State and Reason > Interaction State

There are no attributes in this folder.

Folder: Agent > State and Reason > Interaction State > Interaction Predictive Routing

There are no attributes in this folder.

Folder: Agent > State and Reason > Summarized State

There are no attributes in this folder.