m (1 revision imported: Adding parent column info to PDMRef entries) |
(Trying the landscape div for the SQL per validation tool result) |
||
| Line 8: | Line 8: | ||
|viewDesc = | |viewDesc = | ||
|introduced = | |introduced = | ||
| − | |SQL = | + | |SQL = <div class="pdf-table-landscape"> |
| + | <source lang="xml" enclose="div"> | ||
| + | select | ||
irf.INTERACTION_RESOURCE_ID as ID, | irf.INTERACTION_RESOURCE_ID as ID, | ||
irf.INTERACTION_ID as INTERACTION_ID, | irf.INTERACTION_ID as INTERACTION_ID, | ||
| Line 55: | Line 57: | ||
join CDR_DATE_TIME edt on edt.DATE_TIME_KEY = ((irf.END_TS-irf.AFTER_CALL_WORK_DURATION-irf.CONS_RCV_ACW_DURATION)/900)*900 | join CDR_DATE_TIME edt on edt.DATE_TIME_KEY = ((irf.END_TS-irf.AFTER_CALL_WORK_DURATION-irf.CONS_RCV_ACW_DURATION)/900)*900 | ||
join TECHNICAL_DESCRIPTOR td on irf.TECHNICAL_DESCRIPTOR_KEY = td.TECHNICAL_DESCRIPTOR_KEY | join TECHNICAL_DESCRIPTOR td on irf.TECHNICAL_DESCRIPTOR_KEY = td.TECHNICAL_DESCRIPTOR_KEY | ||
| − | + | </source></div> | |
| − | </source> | ||
}} | }} | ||
Revision as of 03:33, May 8, 2018
View CDR
Description
Reserved
Column List
| Column | Description |
|---|---|
| ID | |
| INTERACTION_ID | |
| MEDIA_TYPE | |
| INTERACTION_TYPE | |
| ORIGINATOR | |
| TARGET | |
| PARTY_TYPE | |
| PARTY_NAME | |
| STATUS | |
| START_TS | The UTC-equivalent value of the date and time when the calling list was added to IDB, which may differ from when the calling list was actually added to contact center configuration. |
| END_TS | The UTC-equivalent value of the date and time when the calling list was removed from contact center configuration. |
| TIME_ZONE_CODE | |
| START_DATE_TIME_STRING | |
| END_DATE_TIME_STRING | |
| FIRST_LEG_FLAG | |
| CONNECTED_FLAG | |
| ELAPSED_DURATION | |
| ENGAGE_DURATION | |
| CONFERENCE_ENGAGE_DURATION | |
| CONSULTATION_ENGAGE_DURATION | |
| HOLD_DURATION | |
| ORDINAL | |
| TECHNICAL_RESULT | |
| PARTY_ROLE | |
| TENANT_KEY | The surrogate key that is used to join to the TENANT dimension. |
References
The summary List of References will include the following entries for this table or view:
| Child Table/View | Child Table/View Column | Parent Table/View | Parent Table/View Column |
|---|---|---|---|
| CDR | INTERACTION_ID | INTERACTION_FACT | INTERACTION_ID |
| CDR | TENANT_KEY | TENANT | TENANT_KEY |
Comments or questions about this documentation? Contact us for support!