- DATA VIEW NAME
- EMPLOYEE_MONEY_PURCHASE
- OVERVIEW
- This view contains a summary of all contributions made to the Wisconsin Retirement System by an employee and his employer that would be used in determining a Money Purchase Annuity.
This information can be used in conjunction with the following to show a more complete picture of the employee’s WRS record:
UA_EMPLOYEE_TOTAL_SERVICE (Multiple records
possible)
UA_EMPLOYEE_CURRENT_SERVICE (Multiple records
possible)
UA_EMPLOYEE_CATEGORY
UA_EMPLOYEE_GENERAL_INFO
UA_EMPLOYEE_CONTRIBUTIONS - 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 - This view should be used when calculation a Money Purchase Annuity. When dealing with a Formula Annuity the UA_EMPLOYEE_CONTRIBUTIONS view should be used.
- 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), changed all references from ‘fixed’ to ‘core’, some field name changes that depict employer as EMPLR and amount as 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. |
| CORE_INT_PERCENT | Number(5,2) | The core interest rate as a percent earned for the reporting year format nn.nn (6.5% or 11.3% etc). |
| VARI_RATE_PERCENT | Number(5,2) | The variable gain or loss for the reporting year format nn.nn (6.5% or 11.3% etc). |
| EMP_RETIRE_AMT_C | Number(10,2) | The total amount of the employee required core contributions payable as a money purchase retirement benefit. |
| EMP_RETIRE_AMT_V | Number(10,2) | Total amount of employee required variable contributions payable as a money purchase retirement benefit. |
| EMP_RETIRE_AMT_T | Number(10,2) | Total employees’ contribution to their retirement account. |
| EMPLR_RETIRE_AMT_C | Number(10,2) | The total amount of the employer required core contributions payable as a money purchase retirement benefit. |
| EMPLR_RETIRE_AMT_V | Number(10,2) | The total amount of the employer required variable contributions payable as a money purchase retirement benefit. |
| EMPLR_RETIRE_AMT_T | Number(10,2) | Total employer’s contribution to an employees’ retirement account. |
| TOTAL_RETIRE_AMT_C | Number(10,2) | Total amount of both employee and employer’s retirement contribution to the employee’s core retirement account. |
| TOTAL_RETIRE_AMT_V | Number(10,2) | Total amount of both employee and employer’s retirement contribution to the employee’s variable retirement account. |
| TOTAL_RETIRE_AMT_T | Number(10,2) | Total amount of both employee and employer’s retirement contribution payable as a money purchase retirement benefit. |
| EXTRACT_DATE_TIME | Date | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS. |