- 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-HELP (4357) - LAST UPDATED
- 5/2001 – New view created.
- 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 |
|---|---|---|
| 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 |