- DATA VIEW NAME
- CLARIFY_CASES
- OVERVIEW
- This view contains information about closed Clarify cases. A case is a task created in response to a customer contract. A case constitutes a complete and formal record of the request from the customer and what the service group has done to provide assistance in resolving the problem. Cases can contain confidential personal information and should be treated accordingly.
This View can be used in conjunction with the following views:
UW.CLARIFY_ACTIVITY_LOG - LOAD FREQUENCY
- Data View is refreshed nightly. The daily load appends all cases closed since the previous load.
- DATA CUSTODIAN
- DoIT Help Desk – Chris Holsman
DoIT User System Services – Chris Holsman - AUTHORIZATION
- You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to the InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - The view retains all information about Clarify Cases permanently.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 5/2001 – New view created.
- DATA FORMATS
- Primary Key Columns are identified with an asterisk(*)
- Alphanumeric Data
- VARCHAR2( N) (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘ABC’ or ‘A’ - Numeric Data
- NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions.
X = total number of digits
Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12 - Date
- DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)
| Column Name | Format | Description |
|---|---|---|
| ID_NUMBER | CHAR (11) | ID number assigned to a Clariy case. |
| TITLE | CHAR (80) | A brief description of the subject The title of the case. |
| CREATE_DATETIME | DATE | The date time stamp when the cases was entered into the clarify system. |
| CREATE_DATE | CHAR (8) | YYYYMMDD The creation date. Datestamp from create_datetime. |
| CREATE_TIME | CHAR (8) | HH24:MI:SS Timestamp from create_datetime. |
| CHAR (80) | Sites can be departmental or individual. For department sites – the department UDDS; for -or an individual campus ID for Individual sites – the staff or student id | |
| SITE_NAME | CHAR (80) | The name of the individual or departmentA named location — whether department or individual |
| CONTACT_FIRST | CHAR (30) | List Name of Contact/case reporter. |
| CONTACT_LAST | CHAR (30) | List Name of Contact/case reporter. |
| CONTRACT_ROLE | CHAR (80) | Category of contact. Examples: Student, Facstaff |
| CLOSE_DATETIME | DATE | Date and time case was closed. YYYYMMDD HH24:MM:SS |
| PRODUCT_NAME | CHAR (30) | The name of the product used. The service or item selected from the Clarify product list as the product or service being supported. |
| LOGIN_NAME | CHAR (30) | The name of the person who created the case. |
| CALL_TYPE | CHAR (40) | The category of the case as determined at the initial contact. Examples: diagnosis, repair, information, referral |
| CASE_PRIORITY | CHAR (30) | A determination of the severity and required response time. Possible valid values: Impact 1 (highest priority), Impact 2 and Impact 3. |
| BILLING_CATEGORY | CHAR (30) | For internal DoIT use. An indicator of how the Help Desk will pay other DoIT groups for their work on a case. |
| CONTACT_METHOD | CHAR (30) | Examples: phone, walk-in, email |
| OPERATING_SYSTEM | CHAR (30) | Platform operating system – Win98, MacOS |
| PLATFORM | CHAR (30) | Type of computer – Wintel, Mac, Unix |
| VERSION | CHAR (30) | Specific release of the OS |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |