EMPLOYEE FILE
Employee
Contains all employee information needed in the Lawson Payroll system. The
Employee PA Information file stores additional employee information used by
the Lawson Human Resource, Personnel, and Benefits systems. HR11.1 (Employee)
is the primary program that updates this file.
REFERENCED BY
AC03.3 AC115 AC196 AC440 AC50.1 AC500
AC52.1 AC520 AC530 AC731 AC750 BN134
BN138 BN140 BN141 BN150 BN175 BN180
BN181 BN230 BN231 BN232 BN233 BN236
BN237 BN238 BN240 BN242 BN246 BN247
BN248 BN258 BN259 BN281 BN285 BN30.1
BN300 BN305 BN310 BN320 BN321 BN325
BN330 BN331 BN335 BN340 BN345 BN35.1
BN350 BN36.1 BN400 BN430 BN46.1 BN46.2
BN47.1 BN48.1 BN48.2 BN480 BN50.1 BN500
BN51.1 BN51.2 BN532 BN55.1 BN55.2 BN56.1
BN57.1 BN59.1 BN60.1 BN61.1 BN66.1 BN70.1
BN70.2 BN77.1 BN80.1 BN81.1 BN81.2 BN82.1
BN85.1 BN90.1 BS09.1 BS10.1 BS11.1 BS12.1
BS30.1 BS31.1 BS531 HC01.1 HC02.1 HCEM.1
HCOP.1 HCOP.2 HCSU.1 ES02.1 ES10.1 HCTC.1
HEMD.1 HEMP.1 HGLN.1 HHSU.1 HOSH.1 HPAE.1
HPXG.1 HR00.1 HR01.1 HR07.1 HR105 HR125
HR13.1 HR15.1 HR155 HR16.2 HR16.3 HR16.4
HR16.5 HR16.6 HR16.7 HR16.8 HR17.1 HR17.2
HR17.3 HR17.4 HR17.5 HR17.6 HR17.7 HR17.8
HR17.9 HR170 HR18.1 HR18.2 HR18.3 HR18.4
HR207 HR211 HR212 HR213 HR255 HR30.1
HR507 HR513 HR515 HR521 HR54.1 HR55.1
HR55.2 HR70.1 HR90.1 HR90.2 HRS1.1 HRSC.1
HS10.1 HS11.1 HS12.1 HS13.1 HS14.1 HS15.1
PA03.2 PA09.1 PA105 PA111 PA113 PA12.1
PA125 PA130 PA14.1 PA149 PA15.1 PA15.2
PA16.1 PA17.1 PA18.1 PA19.1 PA20.1 PA201
PA208 PA21.1 PA211 PA212 PA213 PA214
PA215 PA216 PA217 PA218 PA219 PA22.1
PA220 PA221 PA222 PA224 PA225 PA23.1
PA24.1 PA241 PA242 PA243 PA244 PA248
PA249 PA25.1 PA259 PA26.1 PA262 PA272
PA290 PA295 PA300 PA305 PA31.1 PA310
PA311 PA313 PA315 PA320 PA325 PA33.1
PA330 PA335 PA34.1 PA340 PA341 PA345
PA349 PA35.1 PA350 PA355 PA36.1 PA360
PA370 PA372 PA38.1 PA390 PA391 PA393
PA402 PA406 PA41.1 PA42.1 PA43.1 PA44.1
PA45.1 PA49.1 PA49.2 PA49.3 PA490 PA50.1
PA512 PA520 PA53.1 PA531 PA532 PA533
PA54.1 PA549 PA59.1 PA59.2 PA590 PA62.1
PA64.1 PA64.2 PA66.1 PA66.2 PA66.3 PA66.4
PA67.1 PA81.1 PA81.2 PA90.1 PA90.2 PA90.3
PA91.1 TR07.1 TR08.1 TR09.1 TR114 TR12.1
TR120 TR121 TR13.1 TR13.2 TR14.1 TR15.1
TR20.1 TR20.2 TR20.3 TR200 TR201 TR202
TR204 TR207 TR21.1 TR210 TR22.1 TR220
TR221 TR222 TR26.1 TR500 PBIP.1 HS20.1
HS21.1 HS22.1 HS22.2 HS34.1 HS35.1 HS535
PR114 PR12.1 PR12.2 PR12.3 PR128 PR131
PR132 PR134 PR135 PR136 PR137 PR139
PR140 PR141 PR142 PR150 PR155 PR160
PR162 PR180 PR195 PR199 PR212 PR214
PR216 PR223 PR226 PR23.1 PR230 PR239
PR260 PR265 PR270 PR275 PR276 PR277
PR278 PR280 PR281 PR285 PR289 PR290
PR291 PR292 PR293 PR294 PR295 PR297
PR298 PR32.1 PR32.2 PR33.1 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR36.1 PR37.1 PR45.1 PR50.1 PR50.2
PR50.3 PR50.4 PR51.1 PR512 PR52.1 PR530
PR55.1 PR560 PR80.1 PR80.2 PR82.1 PR82.2
PR83.1 PR85.1 PR86.1 PR89.1 UK102 UK210
UK330 UK52.1 TA125 TA170 TA175 TA180
TA260 TA265 TA270 TA290 TA310 TA570
TA60.1 TA65.1 TA65.2 TA65.3 TA70.1 TA70.2
TA80.1 TM240 TM245 TM250 TM255 TM300
TM470 TM50.1 TM52.1 TM570 TM60.1 TM61.1
TM70.1 TM71.1 UK120 UK220 UK260 UK270
UK300 UK60.1 UK70.1 HEP3.1 HR02.1 PR38.1
HEP4.1 HEP2.1 TA195 TA199
UPDATED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN245 BN31.1 BN31.2 BN32.1 BN32.2
BN32.3 BN45.1 BN531 BN65.1 BN71.1 BN72.1
BS13.1 BS14.1 BS15.1 BS32.1 HR11.1 HR12.1
HR14.1 HR511 HR514 HR700 HR704 PA02.1
PA100 PA102 PA115 PA13.1 PA13.2 PA502
PA513 PA52.1 PA52.2 PA52.3 PA52.4 PA52.5
PR11.1 PR110 PR120 PR13.1 PR13.2 PR14.1
PR15.1 PR15.2 PR205 PR26.1 PR296 PR30.1
PR39.1 PR39.2 PR514 UK110
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMP-COMPANY Numeric 4 HR11.1 HR511
Company Contains the company number. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PR33.2 PR33.3
EMP-EMPLOYEE Numeric 9 HR11.1 HR511
Employee Contains the number assigned to each PA02.1 PA100
employee. The employee number is used PA102 PA13.1
with the company number to uniquely PA13.2 PA502
identify the employee throughout the PA513 PA52.1
Lawson Human Resources systems. PA52.3 PA52.4
PA52.5 PR13.1
PR33.2 PR33.3
EMP-LAST-NAME Alpha 30 (Lower Case) HR07.1 HR11.1
Last Name Contains the employee's last name. HR511 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMP-FIRST-NAME Alpha 15 (Lower Case) HR07.1 HR11.1
First Name Contains the employee's first name. HR511 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMP-MIDDLE-INIT Alpha 1 HR07.1 HR11.1
Middle Initial Contains the employee's middle initial. HR511 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMP-MIDDLE-NAME Alpha 15 (Lower Case) HR11.1 HR511
Middle Name Contains the employee's middle name. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-NICK-NAME Alpha 30 (Lower Case) HR11.1 HR511
Nick Name Contains the employee's nick name. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-ADDR1 Alpha 30 (Lower Case) HR11.1 HR511
Address 1 Contains the first line of the PA02.1 PA100
employee's address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-ADDR2 Alpha 30 (Lower Case) HR11.1 HR511
Address 2 Contains the second line of the PA02.1 PA100
employee's address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-ADDR3 Alpha 30 (Lower Case) HR11.1 HR511
Address 3 Contains the third line of the PA02.1 PA100
employee's address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-ADDR4 Alpha 30 (Lower Case) HR11.1 HR511
Address 4 Contains the fourth line of the PA02.1 PA100
employee's address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-CITY Alpha 18 (Lower Case) HR11.1 HR511
City Contains the city of the employee's PA02.1 PA100
address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-STATE Alpha 2 HR11.1 HR511
State or Province Contains the state of the employee's PA02.1 PA100
address. PA102 PA502
AL = Alabama PA52.1 PA52.3
AK = Alaska PA52.4 PA52.5
AZ = Arizona PR13.1
AR = Arkansas
CA = California
CO = Colorado
CT = Connecticut
DE = Delaware
DC = Dist of Columbia
FL = Florida
GA = Georgia
HI = Hawaii
ID = Idaho
IL = Illinois
IN = Indiana
IA = Iowa
KS = Kansas
KY = Kentucky
LA = Louisiana
ME = Maine
MD = Maryland
MA = Massachusetts
MI = Michigan
MN = Minnesota
MS = Mississippi
MO = Missouri
MT = Montana
NE = Nebraska
NV = Nevada
NH = New Hampshire
NJ = New Jersey
NM = New Mexico
NY = New York
NC = North Carolina
ND = North Dakota
OH = Ohio
OK = Oklahoma
OR = Oregon
PA = Pennsylvania
PR = Puerto Rico
RI = Rhode Island
SC = South Carolina
SD = South Dakota
TN = Tennessee
TX = Texas
UT = Utah
VT = Vermont
VA = Virginia
VI = Virgin Islands
WA = Washington
WV = West Virginia
WI = Wisconsin
WY = Wyoming
EMP-ZIP Alpha 10 HR11.1 HR511
Postal Code Contains the postal code of the PA02.1 PA100
employee's address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-COUNTRY Alpha 30 (Lower Case)
Country or Other Contains the country of the employee's
address.
EMP-EMP-STATUS Alpha 2 HCEM.1 HCOP.2
Status Contains the employee's status, which HR11.1 HR511
can be used to determine if this PA02.1 PA100
employee is paid. PA102 PA272
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMP-FICA-NBR Alpha 15 HR11.1 HR511
SSN (Social Contains the employee's Social Security PA02.1 PA100
Security Number) number. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1 PR291
PR292 PR297
PR298
EMP-EIC-STATUS Numeric 1 HR11.1 HR511
EIC Status Indicates if the employee's EIC status PA02.1 PA100
is Single or Joint. PA102 PA502
0 = Not Applicable PA52.1 PA52.3
1 = Single PA52.4 PA52.5
2 = Joint PR13.1
EMP-PROCESS-LEVEL Alpha 5 HCEM.1 HCOP.2
Process Level Contains the employee's process level. HR11.1 HR511
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMP-DEPARTMENT Alpha 5 HCOP.2 HR11.1
Department Contains the employee's department. HR511 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-USER-LEVEL Alpha 10 HCOP.2 HR11.1
User Level Contains the employee's user level. HR511 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-HM-DIST-CO Numeric 4 HCOP.2 HR11.1
Hm Dist Co Contains the employee's home general HR511 PA02.1
ledger distribution company for expense. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-HM-ACCT-UNIT Alpha 15 HCOP.2 HR11.1
Expense Accounting Contains the employee's home general HR511 PA02.1
Unit ledger accounting unit for expense. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-HM-ACCOUNT Numeric 6 HCOP.2 HR11.1
Expense Account Contains the employee's home general HR511 PA02.1
ledger account for expense. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-HM-SUB-ACCT Numeric 4 HCOP.2 HR11.1
Expense Subaccount Contains the employee's home general HR511 PA02.1
ledger subaccount for expense. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-JOB-CODE Alpha 9 HCOP.2 HR11.1
Job Code Contains the employee's job code. HR170 HR511
HR70.1 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-UNION-CODE Alpha 10 HCOP.2 HR11.1
Union Contains the employee's union code. HR511 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-SUPERVISOR Alpha 10 HCOP.2 HR11.1
Supervisor Contains the supervisor code that HR511 PA02.1
identifies the supervisor to whom the PA100 PA102
employee reports. PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-DATE-HIRED Numeric 8 (yyyymmdd) HCOP.2 HR11.1
Hire Date Contains the employee's hire date. HR511 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMP-PAY-FREQUENCY Numeric 1 HR11.1 HR511
Pay Frequency Identifies the employee's pay frequency. PA02.1 PA100
1 = Weekly PA102 PA502
2 = Biweekly PA52.1 PA52.3
3 = Semimonthly PA52.4 PA52.5
4 = Monthly PR13.1 PR32.1
PR32.2 PR33.2
PR33.3
EMP-SHIFT Numeric 1 HCOP.2 HR11.1
Shift Identifies the shift with which the HR511 PA02.1
employee's pay is associated. PA100 PA102
1 = Shift 1 PA13.1 PA13.2
2 = Shift 2 PA502 PA513
3 = Shift 3 PA52.1 PA52.3
4 = Shift 4 PA52.4 PA52.5
5 = Shift 5 PR13.1
6 = Shift 6
7 = Shift 7
8 = Shift 8
9 = Shift 9
EMP-SALARY-CLASS Alpha 1 HCOP.2 HR11.1
Salary Class Indicates if the rate of pay is hourly HR511 PA02.1
or salaried. PA100 PA102
H = Hourly PA502 PA52.1
S = Salaried PA52.3 PA52.4
PA52.5 PR13.1
EMP-EXEMPT-EMP Alpha 1 HCOP.2 HR11.1
Exempt Indicates if the employee is exempt HR511 PA02.1
from overtime pay. PA100 PA102
N = No PA502 PA52.1
Y = Yes PA52.3 PA52.4
PA52.5 PR13.1
EMP-PAY-RATE Signed 13.4 HR11.1 HR511
Rate of Pay Contains the employee's rate of pay. PA02.1 PA100
This can be an annual amount or an PA102 PA13.1
hourly amount. If this is a step and PA13.2 PA502
grade employee, this field is zero and PA513 PA52.1
the step, grade and schedule must exist. PA52.3 PA52.4
The system uses these fields to retrieve PA52.5 PR110
the employee's rate of pay at PR120 PR13.1
calculation time. PR33.2 PR33.3
EMP-STAND-HOURS Signed 7.2 HR11.1 HR511
Standard Hours Contains the number of hours this PA02.1 PA100
employee usually works each pay period. PA102 PA502
If you enter a value in this field, PA52.1 PA52.3
additional edits occur at time entry. PA52.4 PA52.5
PR13.1
EMP-STAND-AMT Signed 11.3 HR11.1 HR511
Standard Amount Contains the amount of money the PA02.1 PA100
employee usually makes per pay period. PA102 PA502
If you enter a value in this field, PA52.1 PA52.3
additional edits occur at time entry. PA52.4 PA52.5
PR13.1
EMP-WARN-FLAG Alpha 1 HR11.1 HR511
Warning Message Indicates if a warning displays when PA02.1 PA100
the employee exceeds the standard hours PA102 PA502
or amount for a pay period. PA52.1 PA52.3
N = No PA52.4 PA52.5
Y = Yes PR13.1
EMP-ADD-ALLOW-PER Signed 7.3 HR11.1 HR511
Allowance Percent Contains the additional percent (hours PA02.1 PA100
or amount) allowed before a warning PA102 PA502
message displays. PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-ADD-ALLOW-HRS Signed 7.2 HR11.1 HR511
Allowance Hours Contains the additional hours allowed PA02.1 PA100
before the warning message displays. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-ADD-ALLOW-AMT Numeric 9 HR11.1 HR511
Allowance Amount Contains the additional amount of pay PA02.1 PA100
allowed before the warning message PA102 PA502
displays. PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-RPT-INS-COST Signed 11.2 HR11.1 HR511
Reportable Insurance Contains the reportable life insurance PA02.1 PA100
cost for W-2 reporting. If you are using PA102 PA502
the Lawson Benefits system, BN150 (Life PA52.1 PA52.3
Insurance Reportable Income) updates PA52.4 PA52.5
this field. PR13.1
EMP-AUTO-TIME-REC Alpha 1 HR11.1 HR511
Automatic Time Indicates if an employee is allowed to PA02.1 PA100
Record have generated standard time records. PA102 PA502
N = No PA52.1 PA52.3
S = Standard PA52.4 PA52.5
T = Time Group PR13.1
Y = Yes
EMP-LAST-DED-SEQ Numeric 4 BN100 BN101
Last Deduction Contains the last sequence number used BN102 BN103
Sequence Nbr when a deduction was created for the BN104 BN105
employee through the Lawson Benefits BN145 BN245
system. The Lawson Payroll system does BN31.1 BN31.2
not use this field. BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR511
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EMP-AUTO-DEPOSIT Alpha 1 HR11.1 HR511
Automatic Deposit Indicates if the employee is set up for PA02.1 PA100
automatic payroll deposit. PA102 PA502
N = No PA52.1 PA52.3
P = Partial PA52.4 PA52.5
Y = Yes PR13.1
EMP-ACH-DIST-NBR Numeric 2
Default ACH Contains the number that identifies
which ACH account serves as the default
account. The default account is the
account where the system deposits any
remaining money. If the value in the
automatic Deposit field is Y (Yes) or P
(Partial), you must enter a value in
this field.
EMP-ADJ-HIRE-DATE Numeric 8 (yyyymmdd) HCOP.2 HR11.1
Adjusted Hire Date Contains the employee's adjusted hire HR511 PA02.1
date. PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMP-ANNIVERS-DATE Numeric 8 (yyyymmdd) HR11.1 HR511
Anniversary Date Contains the employee's anniversary PA02.1 PA100
date of employment. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-TERM-DATE Numeric 8 (yyyymmdd) HCOP.2 HR11.1
Termination Date Contains the date of employment HR511 PA02.1
termination. PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMP-LAST-CMT-SEQ Numeric 4
Last Comment Contains the last sequence number used
Sequence Number when the last employee comment was
created.
EMP-CREATION-DATE Numeric 8 (yyyymmdd) HR11.1 HR511
Creation Date Contains the date the employee record PA02.1 PA100
was added to the database. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-NBR-FTE Signed 4.3 BN350 HCOP.2
Full Time Equivalent Contains the employee's FTE (Full-time HR11.1 HR511
Equivalency) factor which indicates the PA02.1 PA100
percent of annual hours the employee PA102 PA13.1
works. For example, if the employee PA13.2 PA502
works full-time, this field is 1.000. If PA513 PA52.1
this field is 0.5000, the employee works PA52.3 PA52.4
half of the hours of a full-time PA52.5 PR13.1
employee. PR195 PR89.1
TA175 TA195
TA199
EMP-PENSION-PLAN Alpha 1 HR11.1 HR511
Pension Plan Indicates if the employee is a PA02.1 PA100
participant in a retirement plan PA102 PA502
maintained by the company. PA52.1 PA52.3
N = No PA52.4 PA52.5
Y = Yes PR13.1
EMP-PAY-STEP Numeric 2 HCOP.2 HR11.1
Step Contains the appropriate step if the HR511 PA02.1
employee's pay is based on a step and PA100 PA102
grade schedule. PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-PAY-GRADE Alpha 3 HCOP.2 HR11.1
Grade Contains the appropriate grade if the HR511 PA02.1
employee is paid based on a step and PA100 PA102
grade schedule or is assigned to a grade PA13.1 PA13.2
range schedule. PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-SCHEDULE Alpha 9 HCOP.2 HR11.1
Schedule Contains the schedule the employee is HR511 PA02.1
associated with. There are two types of PA100 PA102
schedules: step and grade and grade PA13.1 PA13.2
range. PA502 PA513
PA52.1 PA52.3
The step and grade schedule is a matrix PA52.4 PA52.5
used to determine an employee's rate of PR13.1
pay based on their particular "step" and
"grade." If the employee is associated
with a step and grade schedule, the
system requires a value in the Step and
Grade fields and that the Rate of Pay
field is blank.
The grade range schedule is a series of
grades with minimum, midpoint, and
maximum salary amounts that is used for
salary administration. If an employee is
associated with a grade range schedule,
you can enter the grade, schedule, and
rate of pay. You can associate an
employee with only one type of schedule.
EMP-EBE-AMOUNT Signed 9.2 HR11.1 HR511
Business Expense Contains the employee business expense PA02.1 PA100
amount for W-2 purposes. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-SICK-PAY Signed 11.2 HR11.1 HR511
Sick Pay Contains the employee's non-taxable PA02.1 PA100
sick pay reportable on the W-2 form. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-OT-PLAN-CODE Alpha 4 HCOP.2 HR11.1
Ot Plan Code Contains the pay plan with which the HR511 PA02.1
employee is associated. PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMP-DECEASED Alpha 1 HR11.1 HR511
Deceased Indicates if the employee is deceased. PA02.1 PA100
Y = Yes PA102 PA502
N = No PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-BSI-GROUP Alpha 11 HR11.1 HR511
Bsi Group Contains the employee's BSI group code. PA02.1 PA100
A BSI group code is a code defined in PA102 PA502
BSI to provide an override tax formula PA52.1 PA52.3
for specific employees. PA52.4 PA52.5
PR13.1
EMP-WORK-STATE Alpha 2 HR11.1 HR511
Work State Contains the employee's work state PA02.1 PA100
abbreviation. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-WORK-PROVINCE Alpha 2
Work Province Contains the employee's work province
abbreviation.
EMP-TAX-STATE Alpha 2 HR11.1 HR511
Tax State Contains the employee's state taxing PA02.1 PA100
authority for income tax purposes. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-WC-STATE Alpha 2 HR11.1 HR511
Wc State Contains the employee's work state PA02.1 PA100
abbreviation that is used for computing PA102 PA502
workers' compensation PA52.1 PA52.3
premiums. PA52.4 PA52.5
PR13.1
EMP-TAX-COUNTY Alpha 10 HR11.1 HR511
Tax County Contains the county taxing authority PA02.1 PA100
for income tax purposes. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-TAX-CITY Alpha 10 HR11.1 HR511
Tax City Contains the city taxing authority for PA02.1 PA100
income tax purposes. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-MOVING-EXP Signed 11.2 HR11.1 HR511
Moving Exp Contains the employee's qualified PA02.1 PA100
moving expenses that are reportable on PA102 PA502
the W-2 form. PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-ALT-RATE-EXIST Alpha 1 HR11.1 HR14.1
Alt Rate Exist Indicates whether the employee has HR511 HR514
alternates pay rates defined for PA02.1 PA100
different job codes. PA102 PA502
Y = Yes PA52.1 PA52.3
Blank = No PA52.4 PA52.5
PR13.1
EMP-PEND-ACT-DATE Numeric 8 (yyyymmdd) HR11.1 HR511
Pend Act Date Contains the date an action will take PA02.1 PA100
effect. PA102 PA502
PA52.1 PA52.2
PA52.3 PA52.4
PA52.5 PR13.1
UK110
EMP-TAX-GROUP Alpha 10 HR11.1 HR511
Reportable Income A reportable income group is a PA02.1 PA100
Group user-defined code that represents a PA102 PA502
group of accounts payable companies and PA52.1 PA52.3
process levels. Used to process and PA52.4 PA52.5
report reportable vendor income. PR11.1 PR13.1
EMP-PIN Alpha 10 (Lower Case)
Pin Contains the employee Personal
Identification Number.
EMP-TIPPED Alpha 1 HR11.1 HR511
Tipped Contains a value that indicates whether PA02.1 PA100
the employee is a tipped employee. This PA102 PA502
field determines whether the system PA52.1 PA52.3
verifies minimum wage and whether to PA52.4 PA52.5
perform the tip credit calculation. PR13.1
C = Tipped Employee - Tip Credit
N = Not a Tipped Employee
T = Tipped Employee -No Tip Credit
EMP-FAX-COUNTRY Alpha 6
Fax Country This field contains the prefix of the
fax number. For example, the country or
city code.
EMP-FAX-NUMBER Alpha 15
Fax Number This field contains the fax number.
EMP-FAX-EXT Alpha 5
Fax Extension This field contains the fax number
extension.
EMP-EMAIL-ADDRESS Alpha 60 (Lower Case) HR11.1 HR511
Email Address Contains the employee's E-mail address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-ACTIVITY Alpha 15 HCOP.2 HR11.1
Activity Contains the activity. HR511 PA02.1
PA100 PA102
Activities are the tasks that make up PA13.1 PA13.2
an activity group. Activities identify PA502 PA513
work being done, such as work orders, PA52.1 PA52.3
phases, products, and so on. A variety PA52.4 PA52.5
of costs, revenues, or both make up an PR13.1
activity. The Activity Management system
stores information such as
responsibility and schedule for each
activity. The breakdown of activity
costs and revenues is defined by account
categories. An activity must belong to
an activity group.
EMP-ACCT-CATEGORY Alpha 5 HCOP.2 HR11.1
Account Category Contains the account category. HR511 PA02.1
PA100 PA102
Account categories are the Activity PA13.1 PA13.2
Management accounts by which activity PA502 PA513
transactions are grouped for budgeting PA52.1 PA52.3
and reporting. Set up account categories PA52.4 PA52.5
for an activity before you do any PR13.1
budgeting or transaction processing.
Using account categories, you can sort
and combine incoming amounts into groups
for reporting and inquiry on activities.
EMP-MAX-LIMIT-OVRD Alpha 1 HR11.1 HR511
Max Limit Ovrd Indicates the default for the maximum PA02.1 PA100
compensation limit from Benefit Plan PA102 PA502
file has been overriden for this PA52.1 PA52.3
employee. PA52.4 PA52.5
Y = Yes PR13.1
N = No
EMP-SEC-LVL Numeric 1 HR11.1 HR12.1
Sec Lvl Contains the employee's security level. HR511 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMP-SEC-LOCATION Alpha 10 HR11.1 HR12.1
Sec Location Contains the employee's security HR511 PA02.1
location. PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMP-POSITION Alpha 12 HCOP.2 HR11.1
Position Contains the user-defined code that HR511 PA02.1
represents a position in the company. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-WORK-SCHED Alpha 10 HR11.1 HR511
Work Schedule Contains the employee's work schedule. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMP-SUPERVISOR-IND Alpha 10 HR11.1 HR511
Supervisor Ind Contains the employee's indirect PA02.1 PA100
supervisor. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMP-ANNUAL-HOURS Numeric 4 HR11.1 HR511
Annual Hours Contains the employee's annual hours. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMP-WORK-COUNTY Alpha 10 HR11.1 HR511
Work County Contains the employee's work county. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-WORK-CITY Alpha 10 HR11.1 HR511
Work City Contains the employee's work city. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-WORK-SCHOOL Alpha 10 HR11.1 HR511
Work School Contains the employee's work school. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-WORK-TRANSPORT Alpha 10
Work Transport Contains the employees work
transportation.
EMP-TAX-SCHOOL Alpha 10 HR11.1 HR511
Tax School Contains the employee's school tax PA02.1 PA100
authority. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-TAX-TRANSPORT Alpha 10
Tax Transport Contains the employee's tax
transportation authority.
EMP-FTE-TOTAL Signed 8.3 HCOP.2 HR11.1
Fte Total Contains the employee's total FTE. HR511 PA02.1
PA100 PA102
The total FTE is the sum of the FTEs for PA13.1 PA13.2
all of the employee's (Level 1 through PA502 PA513
5) positions or jobs. PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-PRO-RATE-TOTAL Signed 13.4 HR11.1 HR511
Pro Rate Total PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMP-PRO-RATE-A-SAL Signed 13.4 HR11.1 HR511
Pro Rate A Sal PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR13.1
EMP-NEW-HIRE-DATE Numeric 8 (yyyymmdd) HR11.1 HR511
New Hire Date PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1 PR296
EMP-COMPA-RATIO Derived
Compensation Ratio
EMP-PENET-RATIO Derived
Penetration Ratio
EMP-SAL-MTH-RATE Derived
Sal Mth Rate
EMP-HOUR-MTH-RATE Derived
Hour Mth Rate
EMP-MONTHLY-RATE Derived
Monthly Rate
EMP-SAL-BIWK-RATE Derived
Sal Biwk Rate
EMP-HRY-BIWK-RATE Derived
Hry Biwk Rate
EMP-SAL-SEMI-RATE Derived
Sal Semi Rate
EMP-HRY-SEMI-RATE Derived
Hry Semi Rate
EMP-SAL-WKLY-RATE Derived
Sal Wkly Rate
EMP-HRY-WKLY-RATE Derived
Hry Wkly Rate
EMP-WEEKLY-RATE Derived
Weekly Rate
EMP-BIWEEKLY-RATE Derived
Biweekly Rate
EMP-SEMIMNTH-RATE Derived
Semimnth Rate
EMP-EMP-ANN-HRS Derived
Emp Ann Hrs
EMP-CURRENCY-CODE Alpha 5 HR11.1 HR511
Currency Code Contains the pay currency. HR700 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-CURR-ND Numeric 1 HR11.1 HR511
Currency Number of Represents the number of decimals HR700 PA02.1
Decimals defined for the currency of the object. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-COUNTRY-CODE Alpha 2 HR11.1 HR511
Country Code Contains the country of the employee's HR704 PA02.1
home address. PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMP-NAME-PREFIX Alpha 4 (Lower Case) HR11.1 HR511
Name Prefix Contains the prefix (title) of the PA02.1 PA100
employee's name. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-NAME-SUFFIX Alpha 4 (Lower Case) HR11.1 HR511
Name Suffix Contains the suffix of the employee's PA02.1 PA100
name. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-WORK-COUNTRY Alpha 2 HR11.1 HR511
Work Country Contains the employee's work country. HR704 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMP-LAST-NAME-PRE Alpha 30 (Lower Case) HR11.1 HR511
Last Name Pre Contains the employee's last name PA02.1 PA100
prefix. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
EMP-LAST-PRE Derived
Last Pre
EMP-LAST-SUF Derived
Last Suf
EMP-LAST-PRE-SUF Derived
Last Pre Suf
EMP-FIRST-MI Derived
First Mi
EMP-LAST-NAME-EXP Derived
Last Name Exp
EMP-FIRST-MI-EXP Derived
First Mi Exp
EMP-FULL-NAME Derived
Full Name
EMP-SHORT-NAME Derived
Short Name Contains the employee's short name.
EMP-LABEL-NAME-1 Derived
Label Name 1
EMPLOYEE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMPSET1 COMPANY AC03.3 AC115
EMPLOYEE AC196 AC440
AC50.1 AC500
AC52.1 AC520
AC530 AC731
AC750 BN100
BN101 BN102
BN103 BN104
BN105 BN134
BN138 BN140
BN141 BN145
BN150 BN175
BN180 BN181
BN230 BN231
BN232 BN233
...
EMPSET2 COMPANY KeyChange HEP3.1 HR02.1
PROCESS-LEVEL HR12.1 HR170
DEPARTMENT HR70.1 PA149
EMPLOYEE PA340 PR134
PR136 PR205
PR212 PR214
PR226 PR33.2
PR38.1 PR39.2
EMPSET4 COMPANY KeyChange HEP4.1 HR11.1
FICA-NBR HR511 PA02.1
EMPLOYEE PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
EMPSET6 COMPANY KeyChange HEP2.1 HR212
LAST-NAME HS10.1 PA311
FIRST-NAME PA370 PR33.3
MIDDLE-INIT
EMPLOYEE
EMPSET7 COMPANY KeyChange BN100 BN101
PROCESS-LEVEL BN102 BN103
EMPLOYEE BN150 BN242
BN245 BN331
HC01.1 HC02.1
HCEM.1 HCOP.1
HR00.1 HR01.1
PA100 PA149
PA335 PBIP.1
PR128 PR139
PR212 PR214
PR226 PR293
PR295 PR296
PR33.2 UK330
TA170 TA180
...
EMPLOYEE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Category ACACCTCAT Required
When EMP-ACCT-CATEGORY != Spaces
EMP-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Ach Deposit EMACHDEPST Required
When EMP-ACH-DIST-NBR != Zeroes
EMP-COMPANY -> EAD-COMPANY
EMP-EMPLOYEE -> EAD-EMPLOYEE
EMP-ACH-DIST-NBR -> EAD-ACH-DIST-NBR
Activity ACACTIVITY Required
When EMP-ACTIVITY != Spaces
EMP-ACTIVITY -> ACV-ACTIVITY
City PRTAXAUTH Required
When EMP-TAX-CITY != Spaces
EMP-TAX-CITY -> PRX-TAX-ID-CODE
Company PRSYSTEM Required
EMP-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
County PRTAXAUTH Required
When EMP-TAX-COUNTY != Spaces
EMP-TAX-COUNTY -> PRX-TAX-ID-CODE
Currency CUCODES Required
When (EMP-CURRENCY-CODE != Spaces )
EMP-CURRENCY-CODE -> CUC-CURRENCY-CODE
Department DEPTCODE Required
When EMP-DEPARTMENT != Spaces
EMP-COMPANY -> DPT-COMPANY
EMP-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
EMP-DEPARTMENT -> DPT-DEPARTMENT
Emp Status EMSTATUS Required
When EMP-EMP-STATUS != Spaces
EMP-COMPANY -> EMS-COMPANY
EMP-EMP-STATUS -> EMS-EMP-STATUS
Home Account GLMASTER Required
When EMP-HM-ACCT-UNIT != Spaces
Or EMP-HM-ACCOUNT != Zeroes
Or EMP-HM-SUB-ACCT != Zeroes
EMP-HM-DIST-CO -> GLM-COMPANY
EMP-HM-ACCT-UNIT -> GLM-ACCT-UNIT
EMP-HM-ACCOUNT -> GLM-ACCOUNT
EMP-HM-SUB-ACCT -> GLM-SUB-ACCOUNT
Indir Supv HRSUPER Required
When (EMP-SUPERVISOR-IND != Spaces )
EMP-COMPANY -> HSU-COMPANY
EMP-SUPERVISOR-IND -> HSU-CODE
Job Code JOBCODE Required
When EMP-JOB-CODE != Spaces
EMP-COMPANY -> JBC-COMPANY
EMP-JOB-CODE -> JBC-JOB-CODE
Location PCODES Required
When EMP-LOCAT-CODE != Spaces
"LO" -> PCO-TYPE
PEM-LOCAT-CODE -> PCO-CODE
Paemployee PAEMPLOYEE Not Required, Delete Cascades
EMP-COMPANY -> PEM-COMPANY
EMP-EMPLOYEE -> PEM-EMPLOYEE
Process Level PRSYSTEM Required
EMP-COMPANY -> PRS-COMPANY
EMP-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Resident State PRSTATE Required
When EMP-TAX-STATE != Spaces
EMP-TAX-STATE -> PSA-STATE
Schedule PRSAGHEAD Required
When EMP-SCHEDULE != Spaces
EMP-COMPANY -> SGH-COMPANY
"S" -> SGH-INDICATOR
EMP-SCHEDULE -> SGH-SCHEDULE
Zeroes -> SGH-EFFECT-DATE
Step And Grade PRSAGDTL Required
When EMP-SCHEDULE != Spaces
And EMP-PAY-STEP != Zeroes
And EMP-PAY-GRADE != Spaces
EMP-COMPANY -> SGD-COMPANY
EMP-SCHEDULE -> SGD-SCHEDULE
EMP-PAY-GRADE -> SGD-PAY-GRADE
EMP-PAY-STEP -> SGD-PAY-STEP
Zeroes -> SGD-EFFECT-DATE
Supervisor HRSUPER Required
When EMP-SUPERVISOR != Spaces
EMP-COMPANY -> HSU-COMPANY
EMP-SUPERVISOR -> HSU-CODE
Tax Rpt State PREMPSTATE Not Required
EMP-COMPANY -> PES-COMPANY
EMP-EMPLOYEE -> PES-EMPLOYEE
EMP-TAX-STATE -> PES-STATE
Tax School PRTAXAUTH Not Required
Valid When EMP-TAX-SCHOOL != Spaces
EMP-TAX-SCHOOL -> PRX-TAX-ID-CODE
Union PCODES Required
When EMP-UNION-CODE != Spaces
"UN" -> PCO-TYPE
EMP-UNION-CODE -> PCO-CODE
User Level PCODES Required
When EMP-USER-LEVEL != Spaces
"UL" -> PCO-TYPE
EMP-USER-LEVEL -> PCO-CODE
Wc State PRSTATE Required
When EMP-WC-STATE != Spaces
EMP-WC-STATE -> PSA-STATE
Work City PRTAXAUTH Not Required
Valid When EMP-WORK-CITY != Spaces
EMP-WORK-CITY -> PRX-TAX-ID-CODE
Work County PRTAXAUTH Not Required
Valid When EMP-WORK-COUNTY != Spaces
EMP-WORK-COUNTY -> PRX-TAX-ID-CODE
Work Rpt State PREMPSTATE Not Required
EMP-COMPANY -> PES-COMPANY
EMP-EMPLOYEE -> PES-EMPLOYEE
EMP-WORK-STATE -> PES-STATE
Work Sched PCODES Required
When (EMP-WORK-SCHED != Spaces )
"WS" -> PCO-TYPE
EMP-WORK-SCHED -> PCO-CODE
Work School PRTAXAUTH Not Required
Valid When EMP-WORK-SCHOOL != Spaces
EMP-WORK-SCHOOL -> PRX-TAX-ID-CODE
Work State PRSTATE Required
When EMP-WORK-STATE != Spaces
EMP-WORK-STATE -> PSA-STATE
EMPLOYEE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acassign ACASSIGN
EMP-COMPANY -> AAN-COMPANY
EMP-EMPLOYEE -> AAN-EMPLOYEE-ASSET
AAN-ACTIVITY-GRP
AAN-ACTIVITY
AAN-RESOURCE-TYPE
AAN-RESOURCE-CODE
Ach Deposits EMACHDEPST Delete Cascades
EMP-COMPANY -> EAD-COMPANY
EMP-EMPLOYEE -> EAD-EMPLOYEE
EAD-ACH-DIST-NBR
All Pos PAEMPPOS Delete Cascades
EMP-COMPANY -> PEP-COMPANY
EMP-EMPLOYEE -> PEP-EMPLOYEE
PEP-POS-LEVEL
PEP-EFFECT-DATE
Alt Pay Rates PRRATES Delete Cascades
EMP-COMPANY -> PRR-COMPANY
EMP-EMPLOYEE -> PRR-EMPLOYEE
PRR-SEQ-NBR
Attend Hist ATTENDHIST Delete Cascades
EMP-COMPANY -> ATH-COMPANY
EMP-EMPLOYEE -> ATH-EMPLOYEE
ATH-DATE
ATH-ATTEND-CODE
ATH-TIME-SEQ
Beneficiaries BENEFICRY
EMP-COMPANY -> BNF-COMPANY
EMP-EMPLOYEE -> BNF-EMPLOYEE
BNF-PLAN-TYPE
BNF-PLAN-CODE
BNF-SEQ-NBR
Benefit BENEFIT Delete Restricted
EMP-COMPANY -> BEN-COMPANY
EMP-EMPLOYEE -> BEN-EMPLOYEE
BEN-PLAN-TYPE
BEN-PLAN-CODE
BEN-START-DATE
Bnchange BNCHANGE Delete Cascades
EMP-COMPANY -> BNH-COMPANY
EMP-EMPLOYEE -> BNH-EMPLOYEE
BNH-EFFECT-DATE
BNH-SEQ-NBR
Bngrpchg BNGRPCHG Delete Cascades
EMP-COMPANY -> BNG-COMPANY
EMP-EMPLOYEE -> BNG-EMPLOYEE
BNG-EFFECT-DATE
BNG-SEQ-NBR
Bondbenseq BONDBENSEQ
EMP-COMPANY -> BBS-COMPANY
EMP-EMPLOYEE -> BBS-EMPLOYEE
BBS-PLAN-CODE
BBS-START-DATE
BBS-BOND-SEQ-NBR
Ck Comments PACOMMENTS Delete Cascades
EMP-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"CK" -> PAC-CMT-TYPE
EMP-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Coda CODA
EMP-COMPANY -> COD-COMPANY
EMP-EMPLOYEE -> COD-EMPLOYEE
COD-PLAN-CODE
COD-PLAN-YEAR
Comphist COMPHIST
EMP-COMPANY -> CPH-COMPANY
EMP-EMPLOYEE -> CPH-EMPLOYEE
CPH-PLAN-TYPE
CPH-PLAN-CODE
CPH-PLAN-YEAR
Cur Err Pro Tr TIMERECORD
EMP-COMPANY -> TRD-COMPANY
EMP-PROCESS-LEVEL -> TRD-PROCESS-LEVEL
EMP-EMPLOYEE -> TRD-EMPLOYEE
TRD-CHECK-GRP
TRD-SUPP-TAX-CODE
TRD-PROCESS-GRP
TRD-TIME-SEQ
Current Pos PAEMPPOS
EMP-COMPANY -> PEP-COMPANY
EMP-EMPLOYEE -> PEP-EMPLOYEE
PEP-POS-LEVEL
PEP-EFFECT-DATE
Ded History PREMDEDHST Delete Restricted
EMP-COMPANY -> PDH-COMPANY
EMP-EMPLOYEE -> PDH-EMPLOYEE
PDH-DED-CODE
PDH-SEQ-NBR
PDH-YEAR
PDH-MONTH
Deduction EMDEDMASTR Delete Restricted
EMP-COMPANY -> EDM-COMPANY
EMP-EMPLOYEE -> EDM-EMPLOYEE
EDM-DED-CODE
EDM-SEQ-NBR
Emdistmast EMDISTMAST Delete Cascades
EMP-COMPANY -> DIP-COMPANY
EMP-EMPLOYEE -> DIP-EMPLOYEE
DIP-POSITION
DIP-PAY-CODE
DIP-DED-CODE
DIP-SEQ-NBR
Emp Garn PREMPGARN Delete Cascades
EMP-COMPANY -> PEG-COMPANY
EMP-EMPLOYEE -> PEG-EMPLOYEE
PEG-CASE-NUMBER
PEG-FILE-NUMBER
Emp Trans EMTATRANS
EMP-COMPANY -> ETT-COMPANY
EMP-EMPLOYEE -> ETT-EMPLOYEE
ETT-PLAN-NAME
ETT-DATE
ETT-SEQ-NBR
Emtamastr EMTAMASTR Delete Cascades
EMP-COMPANY -> ETM-COMPANY
EMP-EMPLOYEE -> ETM-EMPLOYEE
ETM-PLAN-NAME
Err Time Recs TIMERECORD
EMP-COMPANY -> TRD-COMPANY
EMP-PROCESS-LEVEL -> TRD-PROCESS-LEVEL
EMP-EMPLOYEE -> TRD-EMPLOYEE
TRD-CHECK-GRP
TRD-SUPP-TAX-CODE
TRD-PROCESS-GRP
TRD-TIME-SEQ
Flex Dollars EMPFLEXDOL
EMP-COMPANY -> EFD-COMPANY
EMP-EMPLOYEE -> EFD-EMPLOYEE
EFD-START-DATE
Flex Periods EMPFLEXREM
EMP-COMPANY -> EFR-COMPANY
EMP-EMPLOYEE -> EFR-EMPLOYEE
EFR-PLAN-START-DT
EFR-START-DATE
Fut Time Recs TIMERECORD
EMP-COMPANY -> TRD-COMPANY
EMP-EMPLOYEE -> TRD-EMPLOYEE
TRD-TR-DATE
TRD-TIME-SEQ
Hrhistory HRHISTORY
EMP-COMPANY -> HRH-COMPANY
EMP-EMPLOYEE -> HRH-EMPLOYEE
Zeroes -> HRH-OBJ-ID
HRH-FLD-NBR
HRH-BEG-DATE
HRH-SEQ-NBR
Job Hist APPJOBHIST
EMP-COMPANY -> AJH-COMPANY
EMP-EMPLOYEE -> AJH-EMPLOYEE
AJH-SEQ-NBR
AJH-APPLICANT
One Time Ded ONETMDED
EMP-COMPANY -> OTD-COMPANY
EMP-EMPLOYEE -> OTD-EMPLOYEE
OTD-DED-CODE
OTD-EDM-SEQ-NBR
OTD-SEQ-NBR
Open Manuals PAYMASTR
EMP-COMPANY -> PYM-COMPANY
EMP-PROCESS-LEVEL -> PYM-PROCESS-LEVEL
EMP-EMPLOYEE -> PYM-EMPLOYEE
"M" -> PYM-CHECK-TYPE
PYM-CHECK-ID
Part Benefit PARTBEN Delete Restricted
EMP-COMPANY -> PTB-COMPANY
EMP-EMPLOYEE -> PTB-EMPLOYEE
PTB-PARTICIPNT
PTB-PLAN-TYPE
PTB-PLAN-CODE
PTB-START-DATE
Pathfind PATHFIND Delete Cascades
EMP-COMPANY -> PTF-COMPANY
EMP-EMPLOYEE -> PTF-EMPLOYEE
PTF-FLD-NBR
PTF-POS-LEVEL
Paymastr PAYMASTR Delete Restricted
EMP-COMPANY -> PYM-COMPANY
EMP-EMPLOYEE -> PYM-EMPLOYEE
PYM-CHECK-ID
Payments PAYMASTR Delete Restricted
EMP-COMPANY -> PYM-COMPANY
EMP-EMPLOYEE -> PYM-EMPLOYEE
PYM-CHECK-DATE
PYM-CHECK-NBR
PYM-CHECK-ID
Pbhstdtl PBHSTDTL
EMP-COMPANY -> PBH-COMPANY
EMP-EMPLOYEE -> PBH-EMPLOYEE
PBH-CHECK-ID
PBH-PROCESS-LEVEL
PBH-INVOICE
PBH-LINE-NBR
Pep Audit PAPEPAUDIT Delete Cascades
EMP-COMPANY -> PEA-COMPANY
EMP-EMPLOYEE -> PEA-EMPLOYEE
PEA-POS-LEVEL
PEA-EFFECT-DATE
PEA-UPDATE-DATE
Persacthst PERSACTHST
EMP-COMPANY -> PAH-COMPANY
EMP-EMPLOYEE -> PAH-EMPLOYEE
PAH-EFFECT-DATE
PAH-ACTION-CODE
PAH-ACTION-NBR
Pgemployee PGEMPLOYEE Delete Cascades
EMP-COMPANY -> PGE-COMPANY
EMP-EMPLOYEE -> PGE-EMPLOYEE
PGE-GROUP-NAME
Plan Name EMTAMASTR Delete Restricted
EMP-COMPANY -> ETM-COMPANY
EMP-EMPLOYEE -> ETM-EMPLOYEE
ETM-PLAN-NAME
Pos Chg Error PAPOSERR Delete Cascades
EMP-COMPANY -> PPE-COMPANY
EMP-EMPLOYEE -> PPE-EMPLOYEE
Zeroes -> PPE-REQUISITION
PPE-POSITION
PPE-EFFECT-DATE
PPE-UPDATE-TYPE
Position PAPOSITION
Valid When (EMP-POSITION != Spaces )
EMP-COMPANY -> POS-COMPANY
EMP-POSITION -> POS-POSITION
POS-EFFECT-DATE
Pr Distribs PRDISTRIB Delete Restricted
EMP-COMPANY -> PRD-COMPANY
EMP-EMPLOYEE -> PRD-EMPLOYEE
PRD-GL-DATE
PRD-CHECK-ID
PRD-OBJ-ID
Quartded QUARTDED
EMP-COMPANY -> QTD-COMPANY
EMP-EMPLOYEE -> QTD-EMPLOYEE
PRS-PAYROLL-YEAR -> QTD-PAYROLL-YEAR
QTD-QUARTER
QTD-DED-CODE
QTD-PROCESS-LEVEL
QTD-WORK-STATE
Quartded All QUARTDED
EMP-COMPANY -> QTD-COMPANY
EMP-EMPLOYEE -> QTD-EMPLOYEE
QTD-PAYROLL-YEAR
QTD-QUARTER
QTD-DED-CODE
QTD-PROCESS-LEVEL
QTD-WORK-STATE
Quartwage QUARTWAGE
EMP-COMPANY -> QTW-COMPANY
EMP-EMPLOYEE -> QTW-EMPLOYEE
PRS-PAYROLL-YEAR -> QTW-PAYROLL-YEAR
QTW-QUARTER
QTW-PAY-SUM-GRP
QTW-PROCESS-LEVEL
QTW-WORK-STATE
Quartwage All QUARTWAGE
EMP-COMPANY -> QTW-COMPANY
EMP-EMPLOYEE -> QTW-EMPLOYEE
QTW-PAYROLL-YEAR
QTW-QUARTER
QTW-PAY-SUM-GRP
QTW-PROCESS-LEVEL
QTW-WORK-STATE
Report States PREMPSTATE Delete Cascades
EMP-COMPANY -> PES-COMPANY
EMP-EMPLOYEE -> PES-EMPLOYEE
PES-STATE
Salary History PRRATEHIST
EMP-COMPANY -> PRH-COMPANY
EMP-EMPLOYEE -> PRH-EMPLOYEE
PRH-POS-LEVEL
PRH-BEG-DATE
PRH-SEQ-NBR
Standtime STANDTIME Delete Cascades
EMP-COMPANY -> STM-COMPANY
EMP-EMPLOYEE -> STM-EMPLOYEE
Spaces -> STM-TIME-GROUP
STM-PAY-CODE
STM-SEQ-NBR
Super Codes HRSUPER
EMP-COMPANY -> HSU-COMPANY
EMP-EMPLOYEE -> HSU-EMPLOYEE
HSU-CODE
Timerecord TIMERECORD Delete Restricted
EMP-COMPANY -> TRD-COMPANY
EMP-EMPLOYEE -> TRD-EMPLOYEE
TRD-TIME-SEQ
User Fields HREMPUSF Delete Cascades
EMP-COMPANY -> HEU-COMPANY
Zeroes -> HEU-EMP-APP
EMP-EMPLOYEE -> HEU-EMPLOYEE
HEU-FIELD-KEY
Vesthours VESTHOURS
EMP-COMPANY -> VES-COMPANY
EMP-EMPLOYEE -> VES-EMPLOYEE
VES-PLAN-TYPE
VES-PLAN-CODE
VES-PLAN-YEAR
Wages PRTIME
EMP-COMPANY -> PRT-COMPANY
EMP-EMPLOYEE -> PRT-EMPLOYEE
PRT-TR-DATE
PRT-TIME-SEQ
PRT-CHECK-ID
|