CUST_SERVICE_FORMS

Description: |
This table contains information about the forms associated to this customer service communication.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
COMM_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | COMM_ID | NUMERIC | No |
The unique identifier (.1 item) for the communication record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | CRM_FORMS_LIST_FORM_ID | VARCHAR | No |
Holds both filed and unfiled forms attached to the communication.
4 | CRM_FORMS_LIST_FORM_ID_FORM_NAME | VARCHAR | No |
The name of the form associated with the questionnaire.
5 | CRM_FORMS_FILED_YN | VARCHAR | No |
Indicates whether the form is filed or not.
May contain organization-specific values: No
Category Entries:
No
Yes
6 | FORM_CSN_ID | NUMERIC | No |
This item stores the contact serial number (I LQF 8) of the SmartForms used in this encounter. Additionally, like I NCS 630, this information is passed from the relevant host. If the host does not pass the information, then the SmartForm CSN may not appear in this item.