CLARIFY_PRODUCTS

This view contains the information about supported products that are indicated on clarify case records. It provides detail about support category, escalation paths, impact data and other product related information.

This View can be used in conjunction with the following views:
UW.CLARIFY_CASES

Data view is refreshed nightly. The load replaces the previous view.

This data is for Internal DoIT users only.
You must receive approval to access data from the data custodian. For information on which forms to fill out or what connections are necessary go to the InfoAccess home page.

The view contains all products, active and inactive, ever listed in Clarify.

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

5/2001 – New view created.
5/2004 – Field lengths were increased:
PROD_SUPP_CONTRACT from 15 chars to 40 chars
PROD_IMPACT1_PHONE from 15 chars to 54 chars
PROD_IMPACT_BU_PHONE from 15 chars to 54 chars.

Primary Key Columns are identified with an asterisk (*)

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

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 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)

CHAR (30)

Name of the Product listed on a Clarify Case

CHAR (40)

The DoIT tTechnologist group supporting the product

CHAR (1)

Indicates if product is supported on an external level.
Valid Values
"1" = supported up to a hour for no fee
"2" = supported for a fee
"3" = unsupported - but will try and diagnose problem for fee
"4" = unsupported - call manufacturer
"5" = no support required for product

CHAR (1)

Indicates whether product is supported on an individual level.
Valid Values
"1" = supported up to a hour for no fee
"2" = supported for a fee
"3" = unsupported - but will try and diagnose problem for fee
"4" = unsupported - call manufacturer
"5" = no support required for product

CHAR (1)

Indicates whether product is supported on an departmental level.
Valid Values
"1" = supported up to a hour for no fee
"2" = supported for a fee
"3" = unsupported - but will try and diagnose problem for fee
"4" = unsupported - call manufacturer
"5" = no support required for product

CHAR (40)

The name of the clarify queue the escalation was placedThe DoIT contract or project number for the product.

CHAR (40)

The name of the Cclarify queue to which the product will be dispatched if technologist support is neededthe escalation was placed.

CHAR (40)

The name of the pPerson assigned to handle Iimpact1 problems.

CHAR (54)

Telephone number of person assigned to handle impact1 problem

CHAR (40)

Email address of person assigned to handle impact1 problem

CHAR (40)

The Impact 1 Backup of person assigned to handle case

CHAR (54)

Telephone number of backup person.

CHAR (40)

Email address of backup person.

CHAR (8)

Date product was entered in the Product table.

CHAR (8)

Last date product information was modified

CHAR (1)

Support name active
Valid Values:
0 = yes
1 = no.

CHAR (30)

Person entering Product initially on system

CHAR (30)

Last person to modify product information

CHAR (30)

The category of product. Valid values are support, service, mainframe.

DATE

The date and time these data were extracted.
Format : YYYYMMDD HH24:MI:SS