- DATA VIEW NAME
- RETIREMENT_BENEFIT_PROJECTIONS
- OVERVIEW
- 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 (multiple records possible)
UA_EMPLOYEE_CONTRIBUTIONS
UA_EMPLOYEE_GENERAL_INFO
UA_EMPLOYEE_TOTAL_SERVICE (multiple records possible)
UA_EMPLOYEE_MONEY_PURCHASE
UA_EMPLOYEE_CATEGORY - 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 - There will be one or two monthly money purchase benefit amounts shown for each employee depending upon whether the employee has reached normal retirement age for the employment category in which employed or whether the employee is old enough to receive an unreduced monthly benefit.
The first benefit amount is payable at the employee’s normal retirement age for employment category in which last employed, e.g. age 55 for general employees and teachers.
The second benefit amount is payable at the age on which the employee is eligible for an “unreduced” retirement benefit, e.g. a general employee age 57 with 30 years of service. A general employee that has reached age 57 and has 30 years of service will only have one money purchase benefit amount shown.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 03/2002 – 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) and Loaddate becomes Extract_Date_Time c4j
02/15 – Custodian Change - 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 |
|---|---|---|
| *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_AGE_1 | Number (2,0) | This is the first age at which the employee can receive a retirement benefit. There is also an age at which an employee can receive an unreduced retirement benefit (see Employee_Age_2). |
| MONTHLY_MONEY_PURCH_ BENEFIT_1 |
Number(10,2) | This is the money purchase retirement benefit the employee can receive monthly at the earliest age a benefit can be drawn. There is also a monthly money purchase benefit amount for the age at which the employee can first receive an unreduced benefit (see Monthly_Money_Purchase_Benefit_2). |
| MONTHLY_FORMULA_BENEFIT_1 | Number (10,2) | This is the formula retirement benefit the employee can receive monthly at the earliest age a benefit can be drawn. There is also a monthly formula benefit amount for the age at which the employee can first receive an unreduced benefit (see Monthly_Formula_Benefit_2). |
| EMPLOYEE_AGE_2 | Number (2,0) | This is the age at which an employee can receive an unreduced retirement benefit. There is also an earliest age at which the employee can receive a retirement benefit (see Employee_Age_1). |
| MONTHLY_MONEY_PURCH_ BENEFIT_2 |
Number (10,2) | This is the money purchase retirement benefit the employee can receive monthly at the age an unreduced benefit can be drawn. There is also a monthly money purchase benefit amount for the earliest age at which an employee can receive a benefit (see Monthly_Money_Purchase_Benefit_1). |
| MONTHLY_FORMULA_BENEFIT_2 | Number (10,2) | This is the formula retirement benefit the employee can receive monthly at the age an unreduced benefit can be drawn. There is also a monthly formula benefit amount for the earliest age at which an employee can receive a benefit (see Monthly_Formula_Benefit_1). |
| EXTRACT_DATE_TIME | Date | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS. |