Page Name

Description:

For OPS reporting only. Rate Type at which the employee is being paid as reported in Current Year Rate (01017). This is the unit of measure for the number of Units Worked (01624)

Coding Instructions:

For OPS reporting only. Code the pay basis within which the Current Year Rate (01017) for the term is figured. In OPS reports, Rate of Pay can be calculated dividing Current Year Rate (01017) by the Units Worked (01624). This will be the unit of measure associated with the number of units of work.

Algorithm:

Bi-weekly every two weeks (26 pay periods per year)
Monthly once per month
Lump Sum once per term
Semi-monthly the 1st and 15th of the month (24 pay periods per year.
Hourly pay based upon estimated total term hours

Usage Type:

ELEMENT

Begin Term:

200508

End Term:

Last Modified:

17-SEP-2008

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Salary Category Detail (SCD)	EMPLOYEE_DATA (EDAT)	RATE_TYP	471	1805	30	Salary Category Detail
University Employee/OPS (EMPL)	EMPLOYEE_DATA (EDAT)	RATE_TYP	471	1805	30	University Employee/OPS

1 - 2

Excel code	Code	Description	Grouping
'.	.	MISSING	-
'B	B	Bi-weekly
'H	H	Hourly
'L	L	Lump Sum
'M	M	Monthly
'S	S	Semi-Monthly

Download

1 - 6

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
EMPL	EMPLOYEE_DATA	0605	OPS and RATE_TYP missing or invalid	9	Critical Error: may cause submission to be rejected
EMPL	EMPLOYEE_DATA	6233	RATE_TYP is nulled if PAY_PLAN_NBR in ('10', '20', '22', '30', '40', '50', '55', '60', '70', '80', '90', '95', '98', '99')	1	Generated or Modified during SUDS Edit Process
SCD	EMPLOYEE_DATA	6233	RATE_TYP is nulled if PAY_PLAN_NBR in ('10', '20', '22', '30', '40', '50', '55', '60', '70', '80', '90', '95', '98', '99')	1	Generated or Modified during SUDS Edit Process

1 - 3

Physical Description:

VARCHAR2(1)

Short Name:

RATETYP

Column Name:

RATE_TYPE

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information:

Element: Rate Type - 01625

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information: