User Defined Tables

Set up the following user-defined tables for Iowa state reporting.

Table	Description	Referencing Report
ES	Employment statuses	RIC Census report
ET	Employment status subtypes	RIC Census report
Z1	Pay and benefit types	Basic Educational Data Survey (BEDS) report - compensation and benefit information
Z2	Degree codes	BEDS report - degree information
User-defined table for Quarterly Wage Location	Locations for Quarterly Wage report	Quarterly Wage report

Create ES

On the start page, select Human Resources.
Select Reference Tables.
From the Personnel menu, select User Defined Codes.
Select Add new.
Create records by entering the Table Code, Code, and Title listed under Employment statuses.
After entering the Table Code, Code, and Title, select Accept to save the record.
Repeat steps 3 through 5 and create the remaining records.

Employment statuses

The following table shows the table code, codes, and titles for the user-defined table ES.

Table Code	Code	Title
ES	0000	Employment Status
ES	D	Deceased
ES	H	Hired
ES	L	Leave of Absence
ES	P	Disabled
ES	R	Retired
ES	T	Terminated

Create ET

On the start page, select Human Resources.
Select Reference Tables.
From the Personnel menu, select User Defined Codes.
Select Add new.
Create records by entering the Table Code, Code, and Title listed under Employment status subtypes.
After entering the Table Code, Code, and Title, select Accept to save the record.
Repeat steps 3 through 5 and create the remaining records.

Employment status subtypes

The following table shows the table code, codes, and titles for the user-defined table ET.

Table Code	Code	Title
ET	0000	Employment Status Subtype
ET	A	Approved - Paid
ET	E	Early
ET	F	Family Medical Leave Act
ET	M	Military
ET	N	Normal
ET	O	Original
ET	P	Postponed
ET	R	Rehired
ET	U	Approved - Unpaid

Create Z1

On the start page, select Human Resources.
Select Reference Tables.
From the Personnel menu, select User Defined Codes.
Select Add new.
Specify the Table Code as Z1.
In the Code field, enter a prefix letter (P or B) plus a pay code or benefit code.
In the Title field, enter the pay or benefit type.
Select Accept.

Pay and Benefit types

Pay types

Title	Used for
XTRA	Extra Compensation
BNUS	Bonus Pay
PROF	Professional Development
TCHR	Teacher Compensation
LEAD	Teacher Leader Compensation

Benefit types

Title	Used for
RETBEN	Retirement Benefits
ANN	Annuities
HLTHBEN	Health Benefits
OTHBEN	Other Benefits

In addition to pay and benefit types, you must create a record for the four-digit district code used for BEDS reporting, with the title DISTID.

Create Z2

On the start page, select Human Resources.
Select Reference Tables.
From the Personnel menu, select User Defined Codes.
Select Add new.
Specify the Table Code as Z2.
In the Code field, enter a valid Degree code.
In the Title field, enter the corresponding state code.
Select Accept.

State codes

Title	Description
0	No Degree
1	Bachelor’s
2	Master’s
3	Specialist
4	Professional
5	Doctorate
6	Associate’s

Create User-Defined Table for Quarterly Wage Location

An optional user-defined table can provide a crosswalk between local and state locations, as may be needed for the Quarterly Wage report when the option to include multiple worksite data is selected. When creating and submitting a report, wages are totaled and included for each distinct location recognized by the state. The state location code on the Location Table page may suffice to crosswalk state and local locations for each employee when local and state locations have a one-to-one correspondence. However, depending on the district’s setup, the crosswalk may also be accomplished through a user-defined table.

On the start page, select Human Resources.
Select Reference Tables.
From the Personnel menu, select User Defined Codes.
Select Add new.
Enter a Table Code of your choice.
Specify a numeric Code.
Specify a Title.
Select Accept.

The Quarterly Wage Location Table field on the Human Resources Profile – State page must contain the name of the user-defined table.

The entries in the user-defined table include the table title in the table field (user_ref.prefx), the local location in the 'code' field (user_ref.code), and the corresponding state location code in the 'title' field (i.e., user_ref.desc_x).