CLARIFY_EMPLOYEE

This view contains a list of employees authorized to use Clarify and related information. This view can be used in conjunction with the other UW.Clarify views.

How often is the information to be loaded? The view is refreshes nightly and replaces the current list.

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

How much history will be retained?  The view retains information about all employees, both active and inactive, who have ever been authorized to use Clarify.

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

5/2001 - New view created.
9/2001 - Added Status Column

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)

The 3 letter employee logon id as listed in the Clarify employee database.

CHAR (30)

Employee last name

CHAR (30)

Employee first name

CHAR (30)

The four digit UDDS code of the employee’s work group

CHAR (80)

The name of the employee’s workgroup

CHAR (30)

The 3-letter login id of the employee’s listed supervisor.

CHAR (1)

The Employee's curretn employment status:
A - Active
I = Inactive

DATE

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