InfoAccess

  

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 web site

SPECIAL CONSIDERATIONS

The view retains all information about Clarify Cases permanently.

QUESTIONS

Contact: Division of Information Technology Help Desk
Phone: 264-4357 (HELP)

LAST UPDATED

5/2001 – New view created.

DATA FORMATS

Primary Key Columns are identified with an asterisk (*)

Alphanumeric Data

CHAR (N) (N) = length. Field contains letters and/or numbers.
Example: CHAR (5) could contain ‘ABC12’ or ‘12345’ or ‘ABCDEF’

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