InfoAccess

  

DATA VIEW NAME

CLARIFY_QUEUE_MEMBERSHIP

OVERVIEW 

This view contains a list of Clarify queues and the members of those queue.

LOAD FREQUENCY

The view is refreshed nightly replacing 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 the forms to fill out and connections that are necessary, go to the InfoAccess home page

SPECIAL CONSIDERATIONS

The view retains a permanent record of queue and their members

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

LOGIN_NAME

CHAR (30)

The login id of the queue member or manager.

QUEUE_NAME

CHAR (24)

Supply business description. The title of the queue.

ROLE

CHAR (15)

Supply business description. Valid values are member or supervisor.

EXTRACT_DATE_TIME

DATE

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