vw_enqreg_total
Table name: vw_enqreg_total
Contains/role: This is a view over the 3 enquiry registration tables (enqreg_header / enqreg_category / enqreg_topic). Links them together to simplify queries where you want to see/deal with all information (header/topic/category) related to each of the enquiry registrations.
Please note that an Enquiry registration done by an agent that does not contain a selected Topic, but only action 'Marked as unanswered'/Reschedule or only a Comment, will result in a record in enqreg_header but not a record in enqreg_category nor enqreg_topic, and therefore no record in vw_enqreg_total.
| Name | Datatype | Description |
|---|---|---|
| enqreg_header_recid |
int |
See enqreg_header.enqreg_header_recid |
| internal_session_id | uniqueidentifier | See enqreg_header.internal_session_id |
| customer_key | varchar(100) | See enqreg_header.customer_key |
| internal_country_src_db | varchar(10) | See enqreg_header.internal_country_src_db |
| dte_time_stamp | datetime | See enqreg_header.dte_time_stamp |
| agent_id | int | See enqreg_header.agent_id |
| queue_key | varchar(255) | See enqreg_header.queue_key |
| enquiry_media_type | varchar(255) | See enqreg_header.enquiry_media_type |
| related_iq_session_id | uniqueidentifier | See enqreg_header.related_iq_session_id |
| dte_updated | datetime | See enqreg_header.dte_updated |
| comment | nvarchar(MAX) | |
| reschedule_time | datetimeoffset | |
| enqreg_category_recid | int | See enqreg_category.enqreg_category_recid |
| category_id | int | See enqreg_category.category_id |
| category_name | nvarchar(255) | See enqreg_category.category_name |
| enqreg_topic_recid | int | See enqreg_topic.enqreg_topic_recid |
| topic_id | int | See enqreg_topic.topic_id |
| topic_name | nvarchar(255) | See enqreg_topic.topic_name |
| marked_unansw | varchar(255) | See enqreg_header.marked_unansw |
| reserved | varchar(255) | See enqreg_header.reserved |