Fields mappings
The fields mappings table displays how the field name you see in Data Management relates to the column name in the source data set.
|
Display name |
Type |
Tags |
Aggregator |
Display format |
Attributes |
Source |
Data set column name |
|---|---|---|---|---|---|---|---|
| Aband Count | NUMBER | Call Detail, RingCentral Engage | Sum | Call Detail | aband_count | ||
| Aband Rate | NUMBER | Call Detail, RingCentral Engage | Sum | Call Detail | aband_rate | ||
| Accepted | NUMBER | Agent Session, RingCentral Engage | Sum | {0,number,#} | Agent Session | Accepted | |
| Account ID | STRING | Agent Segment, RingCentral Engage | Latest | Queue | accountId | ||
| Account ID | STRING | Agent Segment, RingCentral Engage | Latest | Agent Group | accountId | ||
| Account ID | STRING | Agent Segment, RingCentral Engage | Latest | Agent | accountId | ||
| Account ID | STRING | Agent Segment, RingCentral Engage | Latest | Agent Segment | Account ID | ||
| Account ID | STRING | Agent Segment, RingCentral Engage | Latest | Queue Group | accountId | ||
| Agent Connect Route | STRING | Call Detail, RingCentral Engage | Latest | Call Detail | connected_route | ||
| Agent Group ID | NUMBER | Agent, Agent Group, RingCentral Engage | Latest | {0,number,#} | Agent Group | agentGroupId | |
| Agent Group ID | NUMBER | Agent, Agent Group, RingCentral Engage | Latest | {0,number,#} | Agent | groupId | |
| Agent Group Name | STRING | Agent Group, RingCentral Engage | Latest | Agent Group | groupName | ||
| Agent ID | NUMBER | Agent Segment, Agent Session, Call Detail, RingCentral Engage | Latest | {0,number,#} | Agent Session | Agent ID | |
| Agent ID | NUMBER | Agent Segment, Agent Session, Call Detail, RingCentral Engage | Latest | {0,number,#} | Agent Segment | Agent ID | |
| Agent ID | NUMBER | Agent Segment, Agent Session, Call Detail, RingCentral Engage | Latest | {0,number,#} | Agent | agentId | |
| Agent ID | NUMBER | Agent Segment, Agent Session, Call Detail, RingCentral Engage | Latest | {0,number,#} | Call Detail | connect_id | |
| Agent Name | STRING | Agent, RingCentral Engage | Latest | Agent | Full Name | ||
| Agent Session | NUMBER | Agent Segment, Agent Session, RingCentral Engage | Latest | Agent Segment | Agent Login ID | ||
| Agent Session | NUMBER | Agent Segment, Agent Session, RingCentral Engage | Latest | Agent Session | Login Session ID | ||
| Agent Type | STRING | Agent, RingCentral Engage | Latest | Agent | agentType | ||
| Agent Wait Duration | NUMBER | Agent Segment, RingCentral Engage | Sum | Agent Segment | Agent Wait Duration Sec | ||
| ANI | STRING | Agent Segment, Call Detail, RingCentral Engage | Latest | Agent Segment | ANI | ||
| ANI | STRING | Agent Segment, Call Detail, RingCentral Engage | Latest | Call Detail | ANI | ||
| Avail Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Avail Time | ||
| Avg Handle Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | AHT | ||
| Avg Hold Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Avg Hold Time | ||
| Avg Pending Disp Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Avg Disp Time | ||
| Avg Talk Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Avg Talk Time | ||
| Avg Wait Time | NUMBER | Call Detail, RingCentral Engage | Sum | Call Detail | avg_wait_time | ||
| Away Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Away Time | ||
| Break Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Break Time | ||
| Call Connect Duration | NUMBER | Call Detail, RingCentral Engage | Sum | Call Detail | connected_duration | ||
| Call Connect Timestamp | DATE | Call Detail, RingCentral Engage | Latest | {0,date,yyyy/MM/dd HH:mm:ss} | Call Detail | connected_dts | |
| Call Disposition | STRING | Agent Segment, Call Detail, RingCentral Engage | Latest | Call Detail | connected_disposition | ||
| Call Duration | NUMBER | Call Detail, RingCentral Engage | Sum | Call Detail | call_duration | ||
| Call ID | STRING | Agent Segment, Call Detail, RingCentral Engage | Latest | Agent Segment | UII | ||
| Call ID | STRING | Agent Segment, Call Detail, RingCentral Engage | Latest | Call Detail | UII | ||
| Call Result | STRING | Call Detail, RingCentral Engage | Latest | Call Detail | call_result | ||
| Call Segment | NUMBER | Agent Segment, RingCentral Engage | Latest | Agent Segment | Session ID | ||
| Call Start Timestamp | DATE | Call Detail, RingCentral Engage | Latest | {0,date,yyyy/MM/dd HH:mm:ss} | Call Detail | call_start_dts | |
| Call Status | STRING | Call Detail, RingCentral Engage | Latest | Call Detail | call_status | ||
| Call Type | STRING | Agent Segment, Call Detail, RingCentral Engage | Latest | Call Detail | source_type | ||
| Call Type | STRING | Agent Segment, Call Detail, RingCentral Engage | Latest | Agent Segment | Call Type | ||
| Call Wait Duration | NUMBER | Call Detail, RingCentral Engage | Sum | Call Detail | call_wait_duration | ||
| Calls Handled | NUMBER | Call Detail, RingCentral Engage | Sum | Call Detail | calls_handled | ||
| Calls Offered | NUMBER | Call Detail, RingCentral Engage | Sum | Call Detail | calls_offered | ||
| Calls Placed On Hold | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Calls Placed On Hold | ||
| Campaign ID | NUMBER | Agent Segment, Call Detail, RingCentral Engage | Latest | Agent Segment | Campaign ID | ||
| Campaign ID | NUMBER | Agent Segment, Call Detail, RingCentral Engage | Latest | Call Detail | campaign_id | ||
| Campaign Name | STRING | Agent Segment, Call Detail, RingCentral Engage | Latest | Call Detail | campaign_name | ||
| Campaign Name | STRING | Agent Segment, Call Detail, RingCentral Engage | Latest | Agent Segment | Campaign Name | ||
| Connected Term Party | STRING | Agent Segment, Call Detail, RingCentral Engage | Latest | Call Detail | connected_term_party | ||
| Connected Term Party | STRING | Agent Segment, Call Detail, RingCentral Engage | Latest | Agent Segment | Term Party | ||
| Connected Term Reason | STRING | Agent Segment, Call Detail, RingCentral Engage | Latest | Agent Segment | Term Reason | ||
| Connected Term Reason | STRING | Agent Segment, Call Detail, RingCentral Engage | Latest | Call Detail | connected_term_reason | ||
| Deflected Count | NUMBER | Call Detail, RingCentral Engage | Sum | Call Detail | deflected_count | ||
| Dial Group ID | NUMBER | Call Detail, RingCentral Engage | Latest | Call Detail | dialgroup_id | ||
| Dial Group Name | STRING | Agent Session, RingCentral Engage | Latest | Agent Session | Dial Group | ||
| Dial Type | STRING | Call Detail, RingCentral Engage | Latest | Call Detail | dial_type | ||
| Dialed Number Information Service | STRING | Agent Segment, Call detail, RingCentral Engage | Latest | Agent Segment | DNIS | ||
| Dialed Number Information Service | STRING | Agent Segment, Call detail, RingCentral Engage | Latest | Call Detail | DNIS | ||
| Disposition Transfer Count | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Disp Xfers | ||
| Engaged Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Engaged Time | ||
| Enqueue Timestamp | DATE | Agent Segment, RingCentral Engage | Latest | {0,date,yyyy/MM/dd HH:mm:ss} | Agent Segment | Enqueue Dts | |
| EOC Term Count | NUMBER | Call Detail, RingCentral Engage | Sum | Call Detail | eoc_term_count | ||
| First Name | STRING | Agent, RingCentral Engage | Latest | Agent | firstName | ||
| Handle Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Handling Time | ||
| Hold Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Hold Time | ||
| Interval Timestamp | DATE | Agent Segment, Agent Session, Call Detail, RingCentral Engage | Latest | {0,date,yyyy/MM/dd HH:mm:ss} | Call Detail | interval_timestamp | |
| Interval Timestamp | DATE | Agent Segment, Agent Session, Call Detail, RingCentral Engage | Latest | {0,date,yyyy/MM/dd HH:mm:ss} | Agent Session | Interval Timestamp | |
| Interval Timestamp | DATE | Agent Segment, Agent Session, Call Detail, RingCentral Engage | Latest | {0,date,yyyy/MM/dd HH:mm:ss} | Agent Segment | Interval Timestamp | |
| Is Agent Active | BOOLEAN | Agent, RingCentral Engage | Latest | Agent | isActive | ||
| is Queue Active | STRING | Queue, RingCentral Engage | Latest | Queue | isActive | ||
| Last Name | STRING | Agent, RingCentral Engage | Latest | Agent | lastName | ||
| Location | STRING | Agent, RingCentral Engage | Latest | Agent | location | ||
| Login DTS | DATE | Agent Session, RingCentral Engage | Latest | {0,date,yyyy/MM/dd HH:mm:ss} | Agent Session | Login DTS | |
| Login Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Login Time | ||
| Lunch Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Lunch Time | ||
| Manual No Connect | NUMBER | Agent Session, RingCentral Engage | Sum | {0,number,#} | Agent Session | Manual No Connect | |
| Off Hook Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Off Hook Time | ||
| Pct Login Utilization | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Login Util | ||
| Pct Off Hook To Login | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Off Hook To Login | ||
| Pct Off Hook Utilization | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Off-Hook Utilization | ||
| Pct Transfer Calls Accepted | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Transfer Calls Accepted % | ||
| Pending Disp Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Pending Disp Time | ||
| Phone | STRING | Agent Session, RingCentral Engage | Latest | Agent Session | Phone | ||
| Presented | NUMBER | Agent Session, RingCentral Engage | Sum | {0,number,#} | Agent Session | Presented | |
| Queue Description | STRING | Queue, RingCentral Engage | Latest | Queue | gateDesc | ||
| Queue Group ID | NUMBER | Call Detail, Queue, RingCentral Engage | Latest | {0,number,#} | Queue Group | gateGroupId | |
| Queue Group ID | NUMBER | Call Detail, Queue, RingCentral Engage | Latest | {0,number,#} | Queue | gateGroup.id | |
| Queue Group ID | NUMBER | Call Detail, Queue, RingCentral Engage | Latest | {0,number,#} | Call Detail | queue_group_id | |
| Queue Group Name | STRING | RingCentral Engage | Latest | Queue Group | groupName | ||
| Queue ID | NUMBER | Agent Segment, Call Detail, RingCentral Engage | Latest | {0,number,#} | Queue | gateId | |
| Queue ID | NUMBER | Agent Segment, Call Detail, RingCentral Engage | Latest | {0,number,#} | Call Detail | queue_id | |
| Queue ID | NUMBER | Agent Segment, Call Detail, RingCentral Engage | Latest | {0,number,#} | Agent Segment | Queue ID | |
| Queue Name | STRING | Queue, RingCentral Engage | Latest | Queue | gateName | ||
| Queue Time | NUMBER | Call Detail, RingCentral Engage | Sum | Call Detail | queue_time | ||
| Ring No Ans Count | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | RNA | ||
| Ring No Ans Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Ring No Ans Time | ||
| Ring Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Ring Time | ||
| Rounded Off Hook Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Rounded Off Hook Time | ||
| Segment Call Duration | NUMBER | Agent Segment, RingCentral Engage | Sum | Agent Segment | Duration Sec | ||
| Segment Disposition | STRING | Agent Segment, RingCentral Engage | Latest | Agent Segment | Agent Disposition | ||
| Segment Hold Duration | NUMBER | Agent Segment, RingCentral Engage | Sum | Agent Segment | Hold Duration Sec | ||
| Segment Queue Duration | NUMBER | Agent Segment, RingCentral Engage | Sum | Agent Segment | Queue Duration Sec | ||
| Segment Ring Time | NUMBER | Agent Segment, RingCentral Engage | Sum | Agent Segment | Dial Duration Sec | ||
| Segment Start Timestamp | DATE | Agent Segment, RingCentral Engage | Latest | {0,date,yyyy/MM/dd HH:mm:ss} | Agent Segment | Start Dts | |
| Segment Wrap Time | NUMBER | Agent Segment, RingCentral Engage | Sum | Agent Segment | Wrap Time Sec | ||
| Talk Time | NUMBER | Agent Session, RingCentral Engage | Sum | {0,number,#} | Agent Session | Talk Time | |
| Training Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Training Time | ||
| Username | STRING | Agent, RingCentral Engage | Latest | Agent | username | ||
| Work Time | NUMBER | Agent Session, RingCentral Engage | Sum | Agent Session | Work Time |