- DATA VIEW NAME
- CLARIFY_EMPLOYEE
- OVERVIEW
- 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.
- LOAD FREQUENCY
- How often is the information to be loaded? The view is refreshes nightly and replaces the current list.
- 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 - 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.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 5/2001 – New view created.
9/2001 – Added Status Column - 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 3 letter employee logon id as listed in the Clarify employee database. |
| LAST_NAME | CHAR (30) | Employee last name |
| FIRST_NAME | CHAR (30) | Employee first name |
| UDDS | CHAR (30) | The four digit UDDS code of the employee’s work group |
| WORK_GROUP | CHAR (80) | The name of the employee’s workgroup |
| SUPERVISOR_LOGIN | CHAR (30) | The 3-letter login id of the employee’s listed supervisor. |
| STATUS | CHAR (1) | The Employee’s curretn employment status: A – Active I = Inactive |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |