(Trying the landscape div for the SQL per validation tool result) |
|||
| (One intermediate revision by one other user not shown) | |||
| Line 6: | Line 6: | ||
|viewName = CDR | |viewName = CDR | ||
|shortDesc = | |shortDesc = | ||
| − | |viewDesc = | + | |viewDesc = {{Editgrn_open}}Reserved{{Editgrn_close}} |
|introduced = | |introduced = | ||
|SQL = <div class="pdf-table-landscape"> | |SQL = <div class="pdf-table-landscape"> | ||
Latest revision as of 14:58, January 6, 2020
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 |
This page was last edited on January 6, 2020, at 14:58.
Comments or questions about this documentation? Contact us for support!