Page Name

Description:

Identifies the system in which a person is enrolled and from which the person expects to collect benefits upon retirement. An employee is enrolled in one of these system administered by the Division of Retirement.

Coding Instructions:

For EMPLOYEE_VACANTS table: Code your choice of Retirement Code. Administered funds retirement costs will be calculated for EMPR_TYP_CODE = V, X (vacant and summer reserves).

Algorithm:

Usage Type:

ELEMENT

Begin Term:

192001

End Term:

Last Modified:

10-SEP-2008

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Salary Category Detail (SCD)	EMPLOYEE_DEMO (EDEM)	RETIRE_CD_EMP	40	1663	29	Salary Category Detail
Salary Category Detail (SCD)	EMPLOYEE_VACANTS (EVAC)	RETIRE_CD_EMP	40	1871	31	Salary Category Detail
University Employee/OPS (EMPL)	EMPLOYEE_DEMO (EDEM)	RETIRE_CD_EMP	40	1663	29	University Employee/OPS

1 - 3

Code	Label	Percent	Fica
AD	Scores Div. B (prior 1-1-58)	9.19	Y
AF	Scores Div. B (after 7-1-63)	9.19	Y
CA	Renewed Membership - Regular Class	13.63	Y
CB	Renewed Membership - Special Risk Class	32.79	Y
DL	DROP extension for law enforcement	21.13	Y
DP	DROP from FRS	21.13	Y
DS	DROP from TRS, all plans	21.13	Y
DT	DROP from Plan B, Scores	21.13	N
HA	Florida Retirement Reg Mem	13.63	Y
HB	FRS Special Risk	32.79	Y
HD	FRS (Vow of Poverty)	10.15	N
HJ	FRS Special Risk-Admin Support Class	39.82	Y
HK	FRS IFAS Supplemental	18.75	Y
HM	SMS Class	34.52	Y
IA	Teachers Retirement System Plan A	6.25	N

Export to Spreadsheet

1-15 16-30 31-41

Row Display

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
EMPL	EMPLOYEE_DEMO	0008	Missing or Invalid Value	9	Critical Error: may cause submission to be rejected
EMPL	EMPLOYEE_DEMO	4157	Frequency of Values for EMPLOYEE_DEMO.RETIRE_CD_EMP	0	Frequency Distribution: not an indication of an error
EMPL	EMPLOYEE_DEMO	5421	If Retirement Code (01047) is Senior Management (UM) then BOG Job Structure Category must be Faculty Administrator - Managerial (07), Lower-Level Executive (12), or Upper-Level Executive (13).	9	Critical Error: may cause submission to be rejected
SCD	EMPLOYEE_DEMO	0008	Missing or Invalid Value	9	Critical Error: may cause submission to be rejected
SCD	EMPLOYEE_DEMO	4157	Frequency of Values for EMPLOYEE_DEMO.RETIRE_CD_EMP	0	Frequency Distribution: not an indication of an error
SCD	EMPLOYEE_DEMO	5421	If Retirement Code (01047) is Senior Management (UM) then BOG Job Structure Category must be Faculty Administrator - Managerial (07), Lower-Level Executive (12), or Upper-Level Executive (13).	9	Critical Error: may cause submission to be rejected
SCD	EMPLOYEE_VACANTS	0008	Missing or Invalid Value	9	Critical Error: may cause submission to be rejected
SCD	EMPLOYEE_VACANTS	4156	Frequency of Values for EMPLOYEE_VACANTS.RETIRE_CD_EMP	0	Frequency Distribution: not an indication of an error

1 - 8

Physical Description:

VARCHAR2(2)

Short Name:

RETCD

Column Name:

RETIRE_CODE_EMP

Page Name

Associated Submissions, Tables, and Columns

Allowed Values Benefits

Edit Values

Prior Database Information:

Element: Retirement Code, Employment Resource - 01047

Page Name

Associated Submissions, Tables, and Columns

Allowed Values Benefits

Edit Values

Prior Database Information: