All customer calls for information on orders, shipments, or complaints are logged. The cust_calls table contains information about these types of customer calls. Table 21 shows the columns of the cust_calls table.
| Column Name | Data Type | Description |
|---|---|---|
| customer_num | INTEGER | Customer number (foreign key to customer table) |
| call_dtime | DATETIME YEAR TO MINUTE | Date and time when call was received |
| user_id | CHAR(18) | Name of person logging call (default is user login name) |
| call_code | CHAR(1) | Type of call (foreign key to call_type table) |
| call_descr | CHAR(240) | Description of call |
| res_dtime | DATETIME YEAR TO MINUTE | Date and time when call was resolved |
| res_descr | CHAR(240) | Description of how call was resolved |