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 |
| parsed_category_id | nvarchar(100) | From v2.4.0.0 (Oct 2024) For a Topic registration on level 1, it contains the id of the Category. For a Topic registration on level 2 or below, we here show all its 'parents', e.g. "5277|5281|5282" |
| parsed_category_name | nvarchar(1500) | From v2.4.0.0 (Oct 2024) For a Topic registration on level 1, it contains the name of the Category. For a Topic registration on level 2 or below, we here show its 'parents', e.g. "Puzzel product area|PCC|Admin Portal" |