| Field | Datatype | Len | Description (Parent Form: Use) |
|---|
| action | varchar | 80 | Call: Action |
| agent | varchar | 30 | Call: Agent (login) |
| AgentId | int | 4 | Call: Agent (id number) |
| Call_Id | varchar | 15 | Call: Call Number (character format) |
| callid | int | 4 | Call: Call Number (integer format) |
| CharWgCall | varchar | 10 | Call: workgroup number (character format) |
| class | varchar | 30 | Cust: Class (if student) |
| curr | varchar | 40 | Cust: Curric. (if student) |
| datemodified | int | 4 | Call: Last modified date/time |
| datereported | int | 4 | Call: Call create date/time |
| dateresolved | int | 4 | Call: Closed/Solved date/tme |
| dept | varchar | 45 | Cust: Department |
| E911_phonenumb | varchar | 7 | Call: Office Phone |
| email | varchar | 50 | Cust: Email address |
| firstname | varchar | 25 | Cust: First Name |
| h_addr1 | varchar | 30 | Cust: Home Address Line 1 |
| h_addr2 | varchar | 30 | Cust: Home address line 2 |
| h_city | varchar | 30 | Cust: Home City |
| home_phone | varchar | 12 | Cust: Home Phone |
| impact | int | 4 | Call: Impact |
| initial_workgroup | varchar | 30 | Call: Initial Workgroup (name) |
| Last_modified_by | varchar | 30 | Call: Last Modified By (login name) |
| lastname | varchar | 25 | Cust: Last Name |
| nextcontactdate | int | 4 | Call: Next Contact date/time |
| origin | int | 4 | Call: Origin |
| ouc | varchar | 8 | Cust: OUC number |
| owner | varchar | 30 | Call: Owner (login name) |
| ownercall | int | 4 | Call: Owner (id number) |
| position | varchar | 30 | Cust: Position |
| priority | int | 4 | Call: Priority |
| privacy | varchar | 1 | Cust: Privacy Block |
| problem | varchar | 254 | Call: Short Problem Description |
| problemtext | text | 16 | Call: Problem Text |
| product_name | varchar | 255 | Call: Product (name) |
| productcall | int | 4 | Call: Product (id number) |
| Request_ID | varchar | 31 | Call: Call number left padded w/ zeros to lenght of 8 |
| Sender_Email | varchar | 255 | Call: Sender email address |
| solutioncall | int | 4 | Call: Solution (id number) |
| Status | int | 4 | Call Status |
| timespent | int | 4 | Call: Time spent (seconds) |
| TimeSpnt | varchar | 10 | Call: Time spent (formatted hh:mm:ss) |
| username | varchar | 12 | Cust: login name |
| w_addr1 | varchar | 100 | Cust: Work address line 1 |
| w_addr2 | varchar | 30 | Cust: Work address line 2 |
| w_city | varchar | 30 | Cust: City |
| work_fax | varchar | 12 | Cust: Work FAX |
| work_phone | varchar | 12 | Cust: Work phone |
| workgroup | varchar | 30 | Call: Workgroup (name) |
| workgroupcall | int | 4 | Call: Workgroup (id number) |