- DATA VIEW NAME
- EMPLOYEE_GENERAL_INFO
- OVERVIEW
- This view contains general information about the employees and their account such as location within the University when the last Annual Statement of Benefits was delivered (UDDS), birthdate etc.
This information can be used in conjunction with the following to show a more complete picture of the employee’s WRS record:
UA_EMPLOYEE_CURRENT_SERVICE
UA_EMPLOYEE_CONTRIBUTIONS
UA_EMPLOYEE_TOTAL_SERVICE
UA_EMPLOYEE_MONEY_PURCHASE - LOAD FREQUENCY
- Data no longer updated as of 11/2012
- DATA CUSTODIAN
- HRS Service Center
Contact: Catharine Derubeis - AUTHORIZATION
- You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 6/97 – New View Created
03/09 – Custodian Change
04/10 – Added Member_ID c4j
06/12 – Custodian Change c4j
11/12 – Removed SSN (replaced by Emplid), removed dist_code and udds and moved placement of retirement-age to right after birthdate, added QDRO amt and Loaddate becomes Extract_Date_Time c4j
02/15 – Custodian Change - DATA FORMATS
- The codes following the field names in this document define the field. The different types are:
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’
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
| Column Name | Format | Description |
|---|---|---|
| EMPLID | Varchar2(8) | The emplid of the employee, assigned by university. This 8-character field should be used when writing query selection criteria. |
| MEMBER_ID | Varchar2(13) | In order to better protect your personal information, the Department of Employee Trust Funds (ETF) has assigned member identification (ID) numbers to all WRS members. |
| EMPLOYEE_NAME | Varchar2(36) | Employees name, last, first, middle initial. |
| EMPLOYEE_BIRTHDATE | Date | The birthdate of the employee. Format: CCYYMMDD Note: this field could be blank if no birthdate is present on the file. |
| RETIREMENT_AGE | Number(2) | The normal retirement age associated with the employment category the person is in as of the date of the Annual Statement of Benefits. Example – general employment category = 65 normal retirement age. |
| EMPLOYEE_TOTAL_SERVICE | Number(6,2) | Total amount of creditable years of service before 2000 plus after 1999 plus after Act10 in the retirement system by employment category. |
| QDRO_AMT | Number(6,2) | The qualified domestic relations order amount, if any, associated with this emplid. |
| EXTRACT_DATE_TIME | Date | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS. |