CLARIFY_QUEUE_HISTORICAL

This view contains a record of all Clarify queues that a case has been dispatched to along with other pertinent information. The view should be used in conjunction with other UW.Clarify views

The view is refreshed nightly and new data is appended to the existing data.

DoIT Help Desk - Chris Holsman
DoIT User System Services - Chris Holsman

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

The view retains all history information about Clarify Queues permanently.

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

5/2001 – New view created.

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)

DATE

Supply business descriptionThe system timestamp when the case was Dispatched. Dispatch is a formal recorded event in the Clarify system.

CHAR (11)

Supply business description.The ID number of the case being dispatched.

CHAR (24)

Supply business descriptionThe title of the queue to which the case was dispatched.

CHAR (30)

Supply business descriptionThe 3-letter login id of the person dispatching the case.

DATE

The date and time these data were extracted.