User Defined Tables
Set up user-defined tables to crosswalk local and state codes. There are two required user-defined table setups (Z1 and Z2) and a third optional user-defined table, for which you can use any name.
The following are the user-defined tables in the application:
Table | Description | Referencing Report |
|---|---|---|
PAY AND BEN TYPES | Basic Educational Data Survey (BEDS) report - compensation and benefit information | |
DEGREE CODES | BEDS report - degree information | |
Create Z1
On the application start page, choose Menu, then choose Human Resources.
Select Reference Tables, then choose User Defined Codes (under Personnel).
Click 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.
Click OK.
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 also create a record for the 4-digit district code used for BEDS reporting, with the title of DISTID.
Create Z2
On the application start page, choose Menu, then choose Human Resources.
Select Reference Tables, then choose User Defined Codes (under Personnel).
Click 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.
Click OK.
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 set up 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 application start page, choose Menu, then choose Human Resources.
Select Reference Tables, then choose User Defined Codes (under Personnel).
Click New.
Enter a Table Code of your choice.
Specify a numeric Code.
Specify a Title.
Click OK.
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).