- DATA VIEW NAME
- CLARIFY_PRODUCTS
- OVERVIEW
- 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 - LOAD FREQUENCY
- Data view is refreshed nightly. The load replaces the previous view.
- DATA CUSTODIAN
- DoIT Help Desk – Chris Holsman
DoIT User System Services – Chris Holsman - AUTHORIZATION
- 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 - SPECIAL
CONSIDERATIONS - The view contains all products, active and inactive, ever listed in Clarify.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 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. - 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 |
|---|---|---|
| PRODUCT_NAME | CHAR (30) | Name of the Product listed on a Clarify Case |
| PROD_TECH_RESP | CHAR (40) | The DoIT tTechnologist group supporting the product |
| PROD_SL_EXTERNAL | 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 |
| PROD_SL_INDIVID | 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 |
| PROD_SL_DEPART | 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 |
| PROD_SUPP_CONTRACT | CHAR (40) | The name of the clarify queue the escalation was placedThe DoIT contract or project number for the product. |
| PROD_ESCAL_QUEUE | CHAR (40) | The name of the Cclarify queue to which the product will be dispatched if technologist support is neededthe escalation was placed. |
| PROD_IMPACT1_NAME | CHAR (40) | The name of the pPerson assigned to handle Iimpact1 problems. |
| PROD_IMPACT1_PHONE | CHAR (54) | Telephone number of person assigned to handle impact1 problem |
| PROD_IMPACT1_EMAILl | CHAR (40) | Email address of person assigned to handle impact1 problem |
| PROD_IMPACT_BU_NAME | CHAR (40) | The Impact 1 Backup of person assigned to handle case |
| PROD_IMPACT_BU_PHONE | CHAR (54) | Telephone number of backup person. |
| PROD_IMPACT_BU_EMAIL | CHAR (40) | Email address of backup person. |
| PROD_ENTRY_DATE | CHAR (8) | Date product was entered in the Product table. |
| PROD_MODIFY_DATE | CHAR (8) | Last date product information was modified |
| PROD_PSN_ACTIVE | CHAR (1) | Support name active Valid Values: 0 = yes 1 = no. |
| PROD_ENTERED_BY | CHAR (30) | Person entering Product initially on system |
| PROD_MODIFIED_BY | CHAR (30) | Last person to modify product information |
| PART TYPE | CHAR (30) | The category of product. Valid values are support, service, mainframe. |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |