- DATA VIEW NAME
- EMPLOYEE_CURRENT_SERVICE
- OVERVIEW
- This view shows the service earned for the calendar year preceding the 1/1/XX Statement date. This service is reported by employment category. Each employee could have up to 4 employment categories for the given year.
This information can be used in conjunction with the information in the following views for a more complete picture of the employees’ WRS account:
UW-UA_EMPLOYEE_TOTAL_SERVICE (Multiple records
possible)
UW-UA_EMPLOYEE_CONTRIBUTIONS
UW-UA_EMPLOYEE_GENERAL_INFO
UW-UA_EMPLOYEE_CATEGORY
UW-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), added
Sequence_Num, view can now contain up to 7 rows of data 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. |
| SEQUENCE_NUM | Varchar2(1) | This is the sequence number that indicates that up to 7 rows of data may exist on this view per emplid |
| 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. |
| CATEGORY_CODE | Varchar2(2) | This code identifies the employment category an employee is reported in to the Wisconsin Retirement System during the current calendar year. Example ’30’ is general employee ’40’ is teacher |
| SERVICE_YEARS | Varchar2(15) | This field is used to designate the fiscal year in which the most current creditable service is being reported. Example of Teacher service as reported: CCYY-YY (1994-95) M/Y to M/D/Y (7/1 to 12/31/95) Example of General employee service as reported: CCYY (1996) |
| EMPLOYEE_EARNINGS | Number(10,2) | Employee’s earnings for the calendar or fiscal year being reported for each employment category. For a teacher there will be two figures shown. One for the fiscal year end as 7/1/XX and a separate figure for the period from 7/1/XX through 1/1/XX. |
| EMPLOYEE_CRED_SERV | Number(4,2) | Total service earned in the calendar or fiscal year being reported for each employment category. For a teacher there will be two figures shown. One for the fiscal year end as 7/1/XX and a separate figure for the period from 7/1/XX through 1/1/XX. |
| EXTRACT_DATE_TIME | Date | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |