Lawson Insight Technical Documentation |
|
EMPLOYEE
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 AC131 AC17.3 AC18.2 AC190 AC191
AC196 AC203 AC210 AC217 AC218 AC259
AC297 AC41.1 AC41.4 AC42.1 AC50.1 AC500
AC52.1 AC520 AC530 AC54.1 AC540 AC550
AC551 AC559 AC59.1 AC62.1 AC92.2 AC92.4
AC92.6 ACAC.1 BN106 BN134 BN138 BN140
BN141 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 BN53.1
BN532 BN547 BN55.1 BN55.2 BN555 BN56.1
BN57.1 BN59.1 BN60.1 BN61.1 BN66.1 BN70.1
BN70.2 BN702 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 BR40.3 BR43.1
HC01.1 HC02.1 HCEM.1 HCOP.1 HCOP.2 HCSU.1
DA15.1 ES02.1 ES10.1 FC202 HCTC.1 HEMD.1
HEMP.1 HEP4.1 HGLM.1 HGLN.1 HHSU.1 HOSH.1
HPAE.1 HPOS.1 HPQC.1 HPRS.1 HR00.1 HR00.2
HR00.3 HR01.1 HR02.1 HR06.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 HR20.1 HR207 HR211 HR212 HR213
HR217 HR220 HR255 HR30.1 HR506 HR507
HR513 HR515 HR521 HR54.1 HR55.1 HR55.2
HR70.1 HR90.1 HR90.2 HRS1.1 HRSC.1 HS10.1
HS10.2 ZR651 HS11.1 HS12.1 HS13.1 HS14.1
HS15.1 HS50.1 HS50.2 HS50.3 HS50.4 HS50.5
HS51.1 HS51.2 HS52.1 HS52.2 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 PA227 PA23.1 PA24.1
PA241 PA242 PA243 PA244 PA248 PA249
PA25.1 PA259 PA26.1 PA262 PA263 PA27.1
PA272 PA290 PA295 PA296 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 PA496 PA50.1 PA512 PA520 PA53.1
PA531 PA532 PA533 PA54.1 PA549 PA55.1
PA59.1 PA59.2 PA590 PA594 PA62.1 PA63.1
PA64.1 PA64.2 PA65.1 PA65.2 PA66.1 PA66.2
PA66.3 PA66.4 PA67.1 PA81.1 PA81.2 PA90.1
PA90.2 PA90.3 PA91.1 PA93.2 PA95.1 PA96.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 HS22.3 HS34.1 HS35.1 HS36.1
HS535 PR114 PR12.1 PR12.2 PR12.3 PR12.5
PR135 PR137 PR139 PR140 PR141 PR142
PR155 PR160 PR162 PR180 PR188 PR195
PR197 PR198 PR212 PR214 PR216 PR223
PR226 PR229 PR23.1 PR230 PR239 PR240
PR241 PR242 PR243 PR244 PR245 PR247
PR248 PR250 PR251 PR252 PR253 PR260
PR265 PR270 PR275 PR276 PR277 PR278
PR280 PR281 PR282 PR283 PR284 PR285
PR289 PR290 PR291 PR292 PR293 PR295
PR297 PR298 PR299 PR313 PR37.1 PR38.1
PR418 PR50.1 PR50.2 PR50.3 PR50.4 PR51.1
PR51.3 PR512 PR52.1 PR55.1 PR70.1 PR83.1
PR84.1 PR85.1 PR86.1 PR88.1 PR89.1 PRSA.1
PRSC.1 PRWC.1 UK13.1 UK141 UK145 UK183
UK184 UK201 UK202 UK210 UK277 UK330
UK34.1 UK50.1 UK50.2 UK50.3 UK50.4 UK50.5
UK52.1 TA125 TA145 TA146 TA148 TA170
TA175 TA180 TA181 TA196 TA198 TA241
TA242 TA260 TA265 TA270 TA290 TA310
TA341 TA42.1 TA50.1 TA542 TA570 TA60.1
TA65.1 TA65.2 TA65.3 TA70.1 TA70.2 TA80.1
TA81.1 TM240 TM245 TM250 TM255 TM260
TM265 TM300 TM470 TM50.1 TM52.1 TM570
TM60.1 TM61.1 TM70.1 TM71.1 UK220 UK260
UK270 UK300 UK60.1 UK70.1 FCLRD HRLRD
HEP3.1 HR03.1 HEP2.1 PR300 TA195 TA199
UPDATED BY
AC541 AC542 BN100 BN101 BN102 BN103
BN104 BN105 BN145 BN150 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 HR11.2 HR12.1 HR14.1 HR511
HR514 HR650 PA02.1 PA100 PA102 PA115
PA13.1 PA13.2 PA502 PA513 PA52.1 PA52.2
PA52.3 PA52.4 PA52.5 PR11.1 PR110 PR113
PR120 PR127 PR128 PR13.1 PR13.2 PR13.5
PR13.6 PR13.8 PR130 PR131 PR132 PR134
PR136 PR14.1 PR15.1 PR15.2 PR189 PR205
PR26.1 PR29.1 PR296 PR30.1 PR32.2 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR36.1 PR39.1 PR39.2 PR45.1
PR47.1 PR514 PR529 PR530 PR560 PR80.1
PR80.3 PR82.1 UK102 UK110 UK47.1 UK560
TA147 UK120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMP-COMPANY Numeric 4 HR11.1 HR11.2
Element: Company Contains the company number. HR511 HR650
HS50.1 HS50.2
HS51.1 HS51.2
HS52.1 HS52.2
PA02.1 PA100
PA102 PA262
PA263 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PA62.1 PA63.1
PA64.1 PA64.2
PA65.1 PA65.2
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR33.2
PR33.3 TR120
TR121 TR20.1
TR20.2 TR20.3
TR21.1 TR22.1
TR26.1 TR500
EMP-EMPLOYEE Numeric 9 HR11.1 HR11.2
Element: Employee Contains the number assigned to each HR511 HR650
employee. The employee number is used HS50.1 HS50.2
with the company number to uniquely HS51.1 HS51.2
identify the employee throughout the HS52.1 HS52.2
Lawson Human Resources systems. PA02.1 PA100
PA102 PA262
PA263 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PA62.1 PA63.1
PA64.1 PA64.2
PA65.1 PA65.2
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR33.2
PR33.3 TR120
TR121 TR20.1
TR20.2 TR20.3
TR21.1 TR22.1
TR26.1 TR500
EMP-LAST-NAME Alpha 30 (Lower Case) HR07.1 HR11.1
Element: Last Name Contains the employee's last name. HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-FIRST-NAME Alpha 15 (Lower Case) HR07.1 HR11.1
Element: First Name Contains the employee's first name. HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-MIDDLE-INIT Alpha 1 HR07.1 HR11.1
Element: Middle InitialContains the employee's middle initial. HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-MIDDLE-NAME Alpha 15 (Lower Case) HR11.1 HR11.2
Element: Middle Name Contains the employee's middle name. HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-NICK-NAME Alpha 30 (Lower Case) HR11.1 HR11.2
Element: Nick Name Contains the employee's nick name. HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-ADDR1 Alpha 30 (Lower Case) HR11.1 HR11.2
Element: Address 1 Contains the first line of the HR511 HR650
employee's address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-ADDR2 Alpha 30 (Lower Case) HR11.1 HR11.2
Element: Address 1 Contains the second line of the HR511 HR650
employee's address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-ADDR3 Alpha 30 (Lower Case) HR11.1 HR11.2
Element: Address 1 Contains the third line of the HR511 HR650
employee's address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-ADDR4 Alpha 30 (Lower Case) HR11.1 HR11.2
Element: Address 1 Contains the fourth line of the HR511 HR650
employee's address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-CITY Alpha 18 (Lower Case) HR11.1 HR11.2
Element: City Contains the city of the employee's HR511 HR650
address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-STATE Alpha 2 HR11.1 HR11.2
Element: State or ProviContains the state of the employee's HR511 HR650
address. PA02.1 PA100
PA102 PA502
AL = Alabama PA52.1 PA52.3
AK = Alaska PA52.4 PA52.5
AZ = Arizona PR110 PR113
AR = Arkansas PR120 PR13.1
CA = California PR13.5 PR13.6
CO = Colorado PR13.8
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 HR11.2
Element: Postal Code Contains the postal code of the HR511 HR650
employee's address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-EMP-STATUS Alpha 2 HCEM.1 HCOP.2
Element: Status Contains the employee's status, which HR11.1 HR11.2
can be used to determine if this HR511 HR650
employee is paid. PA02.1 PA100
PA102 PA272
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-FICA-NBR Alpha 15 HR11.1 HR11.2
Element: Social Number Contains the employee's Social Security HR511 HR650
number. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR252
PR290 PR291
PR292 PR297
EMP-EIC-STATUS Numeric 1 HR11.1 HR11.2
Element: EIC Status Indicates if the employee's EIC status HR511 HR650
is Single or Joint. PA02.1 PA100
0 = Not Applicable PA102 PA502
1 = Single PA52.1 PA52.3
2 = Joint PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-PROCESS-LEVEL Alpha 5 HCEM.1 HCOP.2
Element: Process Level Contains the employee's process level. HR11.1 HR11.2
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-DEPARTMENT Alpha 5 HCOP.2 HR11.1
Element: Department Contains the employee's department. HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-USER-LEVEL Alpha 10 HCOP.2 HR11.1
Element: User Level Contains the employee's user level. HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-HM-DIST-CO Numeric 4 HCOP.2 HR11.1
Element: Hm Dist Co Contains the employee's home general HR11.2 HR511
ledger distribution company for expense. HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-HM-ACCT-UNIT Alpha 15 HCOP.2 HR11.1
Expense Accounting Contains the employee's home general HR11.2 HR511
Unit ledger accounting unit for expense. HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-HM-ACCOUNT Numeric 6 HCOP.2 HR11.1
Element: Expense AccounContains the employee's home general HR11.2 HR511
ledger account for expense. HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-HM-SUB-ACCT Numeric 4 HCOP.2 HR11.1
Element: Expense SubaccContains the employee's home general HR11.2 HR511
ledger subaccount for expense. HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-JOB-CODE Alpha 9 HCOP.2 HR11.1
Element: Job Code Contains the employee's job code. HR11.2 HR170
HR511 HR650
HR70.1 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-UNION-CODE Alpha 10 HCOP.2 HR11.1
Element: Union Contains the employee's union code. HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-SUPERVISOR Alpha 10 HCOP.2 HR11.1
Element: Supervisor Contains the supervisor code that HR11.2 HR511
identifies the supervisor to whom the HR650 PA02.1
employee reports. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-DATE-HIRED Numeric 8 (yyyymmdd) HCOP.2 HR11.1
Element: Hire Date Contains the employee's hire date. HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-PAY-FREQUENCY Numeric 1 HR11.1 HR11.2
Element: Pay Frequency Identifies the employee's pay frequency. HR511 HR650
1 = Weekly PA02.1 PA100
2 = Biweekly PA102 PA502
3 = Semimonthly PA52.1 PA52.3
4 = Monthly PA52.4 PA52.5
5 = UK Four-Weekly PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR32.1
PR32.2 PR33.2
PR33.3
EMP-SHIFT Numeric 1 HCOP.2 HR11.1
Element: Shift Identifies the shift with which the HR11.2 HR511
employee's pay is associated. HR650 PA02.1
1 = Shift 1 PA100 PA102
2 = Shift 2 PA13.1 PA13.2
3 = Shift 3 PA502 PA513
4 = Shift 4 PA52.1 PA52.3
5 = Shift 5 PA52.4 PA52.5
6 = Shift 6 PR110 PR113
7 = Shift 7 PR120 PR13.1
8 = Shift 8 PR13.5 PR13.6
9 = Shift 9 PR13.8
EMP-SALARY-CLASS Alpha 1 HCOP.2 HR11.1
Element: Salary Class Indicates if the rate of pay is hourly HR11.2 HR511
or salaried. HR650 PA02.1
PA100 PA102
H = Hourly PA502 PA52.1
S = Salaried PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-EXEMPT-EMP Alpha 1 HCOP.2 HR11.1
Element: Exempt Indicates if the employee is exempt HR11.2 HR511
from overtime pay. HR650 PA02.1
N = No PA100 PA102
Y = Yes PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-PAY-RATE Signed 13.4 HR11.1 HR11.2
Element: Rate of Pay Contains the employee's rate of pay. HR511 HR650
This can be an annual amount or an PA02.1 PA100
hourly amount. If this is a step and PA102 PA13.1
grade employee, this field is zero and PA13.2 PA502
the step, grade and schedule must exist. PA513 PA52.1
The system uses these fields to retrieve PA52.3 PA52.4
the employee's rate of pay at PA52.5 PR110
calculation time. PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR33.2 PR33.3
EMP-STAND-HOURS Signed 7.2 HR11.1 HR11.2
Element: Standard HoursContains the number of hours this HR511 HR650
employee usually works each pay period. PA02.1 PA100
If you enter a value in this field, PA102 PA502
additional edits occur at time entry. PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-STAND-AMT Signed 11.3 HR11.1 HR11.2
Element: Standard AmounContains the amount of money the HR511 HR650
employee usually makes per pay period. PA02.1 PA100
If you enter a value in this field, PA102 PA502
additional edits occur at time entry. PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-WARN-FLAG Alpha 1 HR11.1 HR11.2
Element: Warning MessagIndicates if a warning displays when HR511 HR650
the employee exceeds the standard hours PA02.1 PA100
or amount for a pay period. PA102 PA502
N = No PA52.1 PA52.3
Y = Yes PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-ADD-ALLOW-PER Signed 7.3 HR11.1 HR11.2
Element: Allowance PercContains the additional percent (hours HR511 HR650
or amount) allowed before a warning PA02.1 PA100
message displays. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-ADD-ALLOW-HRS Signed 7.2 HR11.1 HR11.2
Element: Allowance HourContains the additional hours allowed HR511 HR650
before the warning message displays. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-ADD-ALLOW-AMT Numeric 9 HR11.1 HR11.2
Element: Allowance AmouContains the additional amount of pay HR511 HR650
allowed before the warning message PA02.1 PA100
displays. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-RPT-INS-COST Signed 11.2 HR11.1 HR11.2
Element: Reportable InsContains the reportable life insurance HR511 HR650
cost for W-2 reporting. If you are using PA02.1 PA100
the Lawson Benefits system, BN150 (Life PA102 PA502
Insurance Reportable Income) updates PA52.1 PA52.3
this field. PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-AUTO-TIME-REC Alpha 1 HR11.1 HR11.2
Automatic Time Indicates if an employee is allowed to HR511 HR650
Record have generated standard time records. PA02.1 PA100
N = No PA102 PA502
S = Standard PA52.1 PA52.3
T = Time Group PA52.4 PA52.5
Y = Yes PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-LAST-DED-SEQ Numeric 4 AC541 AC542
Last Deduction Contains the last sequence number used BN100 BN101
Sequence Nbr when a deduction was created for the BN102 BN103
employee through the Lawson Benefits BN104 BN105
system. The Lawson Payroll system does BN145 BN150
not use this field. 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
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EMP-AUTO-DEPOSIT Alpha 1 HR11.1 HR11.2
Element: Automatic DepoIndicates if the employee is set up for HR511 HR650
automatic payroll deposit. PA02.1 PA100
N = No PA102 PA502
P = Partial PA52.1 PA52.3
Y = Yes PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-ADJ-HIRE-DATE Numeric 8 (yyyymmdd) HCOP.2 HR11.1
Element: Adjusted Hire Contains the employee's adjusted hire HR11.2 HR511
date. HR650 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-ANNIVERS-DATE Numeric 8 (yyyymmdd) HR11.1 HR11.2
Element: Anniversary DaContains the employee's anniversary HR511 HR650
date of employment. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-TERM-DATE Numeric 8 (yyyymmdd) HCOP.2 HR11.1
Element: Termination DaContains the date of employment HR11.2 HR511
termination. HR650 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-LAST-CMT-SEQ Numeric 4
Element: Sequence NumbeContains the last sequence number used
when the last employee comment was
created.
EMP-CREATION-DATE Numeric 8 (yyyymmdd) HR11.1 HR11.2
Element: Date Contains the date the employee record HR511 HR650
was added to the database. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-NBR-FTE Signed 4.3 BN350 HCOP.2
Element: Full Time EquiContains the employee's FTE (Full-time HR11.1 HR11.2
Equivalency) factor which indicates the HR511 HR650
percent of annual hours the employee PA02.1 PA100
works. For example, if the employee PA102 PA13.1
works full-time, this field is 1.000. If PA13.2 PA502
this field is 0.5000, the employee works PA513 PA52.1
half of the hours of a full-time PA52.3 PA52.4
employee. PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR195 PR89.1
TA175 TA199
EMP-PENSION-PLAN Alpha 1 HR11.1 HR11.2
Element: Pension Plan Indicates if the employee is a HR511 HR650
participant in a retirement plan PA02.1 PA100
maintained by the company. PA102 PA502
N = No PA52.1 PA52.3
Y = Yes PA52.4 PA52.5
PR11.1 PR110
PR113 PR120
PR127 PR13.1
PR13.5 PR13.6
PR13.8
EMP-PAY-STEP Numeric 2 HCOP.2 HR11.1
Element: Step Contains the appropriate step if the HR11.2 HR511
employee's pay is based on a step and HR650 PA02.1
grade schedule. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-PAY-GRADE Alpha 3 HCOP.2 HR11.1
Element: Grade Contains the appropriate grade if the HR11.2 HR511
employee is paid based on a step and HR650 PA02.1
grade schedule or is assigned to a grade PA100 PA102
range schedule. PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-SCHEDULE Alpha 9 HCOP.2 HR11.1
Element: Schedule Contains the schedule the employee is HR11.2 HR511
associated with. There are two types of HR650 PA02.1
schedules: step and grade and grade PA100 PA102
range. PA13.1 PA13.2
PA502 PA513
The step and grade schedule is a matrix PA52.1 PA52.3
used to determine an employee's rate of PA52.4 PA52.5
pay based on their particular "step" and PR110 PR113
"grade." If the employee is associated PR120 PR13.1
with a step and grade schedule, the PR13.5 PR13.6
system requires a value in the Step and PR13.8
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 HR11.2
Element: Business ExpenContains the employee business expense HR511 HR650
amount for W-2 purposes. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-SICK-PAY Signed 11.2 HR11.1 HR11.2
Element: Sick Pay Contains the employee's non-taxable HR511 HR650
sick pay reportable on the W-2 form. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-OT-PLAN-CODE Alpha 4 HCOP.2 HR11.1
Element: Ot Plan Code Contains the pay plan with which the HR11.2 HR511
employee is associated. HR650 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-DECEASED Alpha 1 HR11.1 HR11.2
Element: Deceased Indicates if the employee is deceased. HR511 HR650
Y = Yes PA02.1 PA100
N = No PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR11.1 PR110
PR113 PR120
PR127 PR13.1
PR13.5 PR13.6
PR13.8
EMP-BSI-GROUP Alpha 11 HR11.1 HR11.2
Element: Bsi Group Contains the employee's BSI group code. HR511 HR650
A BSI group code is a code defined in PA02.1 PA100
BSI to provide an override tax formula PA102 PA502
for specific employees. PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-WORK-STATE Alpha 2 HR11.1 HR11.2
Element: Work State Contains the employee's work state HR511 HR650
abbreviation. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-TAX-STATE Alpha 2 HR11.1 HR11.2
Element: Tax State Contains the employee's state taxing HR511 HR650
authority for income tax purposes. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-TAX-PROVINCE Alpha 2 HR11.1 HR11.2
Element: Province Contains the tax province of the HR511 HR650
employee that is used for Canada PA02.1 PA100
Payroll. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-WC-STATE Alpha 2 HR11.1 HR11.2
Element: Wc State Contains the employee's work state HR511 HR650
abbreviation that is used for computing PA02.1 PA100
workers' compensation PA102 PA502
premiums. PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-TAX-COUNTY Alpha 10 HR11.1 HR11.2
Element: Tax County Contains the county taxing authority HR511 HR650
for income tax purposes. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-TAX-CITY Alpha 10 HR11.1 HR11.2
Element: Tax City Contains the city taxing authority for HR511 HR650
income tax purposes. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-MOVING-EXP Signed 11.2 HR11.1 HR11.2
Element: Moving Exp Contains the employee's qualified HR511 HR650
moving expenses that are reportable on PA02.1 PA100
the W-2 form. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-ALT-RATE-EXIST Alpha 1 HR11.1 HR11.2
Element: Alt Rate ExistIndicates whether the employee has HR14.1 HR511
alternates pay rates defined for HR514 HR650
different job codes. PA02.1 PA100
Y = Yes PA102 PA502
Blank = No PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-PEND-ACT-DATE Numeric 8 (yyyymmdd) HR11.1 HR11.2
Element: Pend Act Date Contains the date an action will take HR511 HR650
effect. PA02.1 PA100
PA102 PA502
PA52.1 PA52.2
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
UK110
EMP-PIN Alpha 10 (Lower Case)
Element: Pin Contains the employee Personal
Identification Number.
EMP-TIPPED Alpha 1 HR11.1 HR11.2
Element: Tipped Contains a value that indicates whether HR511 HR650
the employee is a tipped employee. This PA02.1 PA100
field determines whether the system PA102 PA502
verifies minimum wage and whether to PA52.1 PA52.3
perform the tip credit calculation. PA52.4 PA52.5
C = Tipped Employee - Tip Credit PR110 PR113
N = Not a Tipped Employee PR120 PR13.1
T = Tipped Employee -No Tip Credit PR13.5 PR13.6
PR13.8
EMP-EMAIL-ADDRESS Alpha 60 (Lower Case) HR11.1 HR11.2
Element: Email Address Contains the employee's E-mail address. HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-ACTIVITY Alpha 15 HCOP.2 HR11.1
Element: Activity Contains the activity. HR11.2 HR511
HR650 PA02.1
Activities are the tasks that make up PA100 PA102
an activity group. Activities identify PA13.1 PA13.2
work being done, such as work orders, PA502 PA513
phases, products, and so on. A variety PA52.1 PA52.3
of costs, revenues, or both make up an PA52.4 PA52.5
activity. The Activity Management system PR110 PR113
stores information such as PR120 PR13.1
responsibility and schedule for each PR13.5 PR13.6
activity. The breakdown of activity PR13.8
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
Element: Account CategoContains the account category. HR11.2 HR511
HR650 PA02.1
Account categories are the Activity PA100 PA102
Management accounts by which activity PA13.1 PA13.2
transactions are grouped for budgeting PA502 PA513
and reporting. Set up account categories PA52.1 PA52.3
for an activity before you do any PA52.4 PA52.5
budgeting or transaction processing. PR110 PR113
Using account categories, you can sort PR120 PR13.1
and combine incoming amounts into groups PR13.5 PR13.6
for reporting and inquiry on activities. PR13.8
EMP-MAX-LIMIT-OVRD Alpha 1 HR11.1 HR11.2
Element: Max Limit OvrdIndicates the default for the maximum HR511 HR650
compensation limit from Benefit Plan PA02.1 PA100
file has been overriden for this PA102 PA502
employee. PA52.1 PA52.3
Y = Yes PA52.4 PA52.5
N = No PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-SEC-LVL Numeric 1 HR11.1 HR11.2
Element: Sec Lvl Contains the employee's security level. HR12.1 HR511
HR650 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-SEC-LOCATION Alpha 10 HR11.1 HR11.2
Element: Sec Location Contains the employee's security HR12.1 HR511
location. HR650 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-POSITION Alpha 12 HCOP.2 HR11.1
Element: Position Contains the user-defined code that HR11.2 HR511
represents a position in the company. HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-WORK-SCHED Alpha 10 HR11.1 HR11.2
Element: Work Schedule Contains the employee's work schedule. HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-SUPERVISOR-IND Alpha 10 HR11.1 HR11.2
Element: Supervisor IndContains the employee's indirect HR511 HR650
supervisor. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-ANNUAL-HOURS Numeric 4 HR11.1 HR11.2
Element: Annual Hours Contains the employee's annual hours. HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-WORK-COUNTY Alpha 10 HR11.1 HR11.2
Element: Work County Contains the employee's work county. HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-WORK-CITY Alpha 10 HR11.1 HR11.2
Element: Work City Contains the employee's work city. HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-WORK-SCHOOL Alpha 10 HR11.1 HR11.2
Element: Work School Contains the employee's work school. HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-WORK-TRANSPORT Alpha 10
Element: Work TransportContains the employees work
transportation.
EMP-TAX-SCHOOL Alpha 10 HR11.1 HR11.2
Element: Tax School Contains the employee's school tax HR511 HR650
authority. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-TAX-TRANSPORT Alpha 10
Element: Tax Transport Contains the employee's tax
transportation authority.
EMP-FTE-TOTAL Signed 8.3 HCOP.2 HR11.1
Element: Fte Total Contains the employee's total FTE. HR11.2 HR511
HR650 PA02.1
The total FTE is the sum of the FTEs PA100 PA102
for all of the employee's (Level 1 PA13.1 PA13.2
through 5) positions or jobs. PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 TA195
EMP-PRO-RATE-TOTAL Signed 13.4 HR11.1 HR11.2
Element: Pro Rate Total HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-PRO-RATE-A-SAL Signed 13.4 HR11.1 HR11.2
Element: Pro Rate A Sal HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-NEW-HIRE-DATE Numeric 8 (yyyymmdd) HR11.1 HR11.2
Element: New Hire Date HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR296
EMP-COMPA-RATIO Derived
Element: Compensation Ratio
EMP-PENET-RATIO Derived
Element: Penetration Ratio
EMP-SAL-MTH-RATE Derived
Element: Sal Mth Rate
EMP-HOUR-MTH-RATE Derived
Element: Hour Mth Rate
EMP-MONTHLY-RATE Derived
Element: Monthly Rate
EMP-SAL-BIWK-RATE Derived
Element: Sal Biwk Rate
EMP-HRY-BIWK-RATE Derived
Element: Hry Biwk Rate
EMP-SAL-SEMI-RATE Derived
Element: Sal Semi Rate
EMP-HRY-SEMI-RATE Derived
Element: Hry Semi Rate
EMP-SAL-WKLY-RATE Derived
Element: Sal Wkly Rate
EMP-HRY-WKLY-RATE Derived
Element: Hry Wkly Rate
EMP-WEEKLY-RATE Derived
Element: Weekly Rate
EMP-BIWEEKLY-RATE Derived
Element: Biweekly Rate
EMP-SEMIMNTH-RATE Derived
Element: Semimnth Rate
EMP-EMP-ANN-HRS Derived
Element: Emp Ann Hrs
EMP-CURRENCY-CODE Alpha 5 HR11.1 HR11.2
Element: Currency Code Contains the pay currency. HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-CURR-ND Numeric 1 HR11.1 HR11.2
Account Currency HR511 HR650
Code PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-COUNTRY-CODE Alpha 2 HR11.1 HR11.2
Element: Country Code Contains the country of the employee's HR511 HR650
home address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-NAME-PREFIX Alpha 4 (Lower Case) HR11.1 HR11.2
Element: Name Prefix Contains the prefix (title) of the HR511 HR650
employee's name. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-NAME-SUFFIX Alpha 4 (Lower Case) HR11.1 HR11.2
Element: Name Suffix Contains the suffix of the employee's HR511 HR650
name. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-WORK-COUNTRY Alpha 2 HR11.1 HR11.2
Element: Country Code Contains the employee's work country. HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-LAST-NAME-PRE Alpha 30 (Lower Case) HR11.1 HR11.2
Element: Last Name Pre Contains the employee's previous last HR511 HR650
name. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-EST-REMUN Signed 11.2 HR11.1 HR11.2
Element: Est Remun Used for taxing Canada Commission HR511 HR650
Payments. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-EST-EXPENSE Signed 11.2 HR11.1 HR11.2
Element: Est Expense Used for taxing Canada Commission HR511 HR650
Payments. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-BUS-NBR-GRP Alpha 4 HR11.1 HR11.2
Element: Bus Nbr Grp Contains the business number group. HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-QC-ENT-NBR-GRP Alpha 4 HR11.1 HR11.2
Element: Qc Ent Nbr GrpContains the Quebec enterprise number HR511 HR650
group. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-LAST-PRE Derived
Element: Last Pre
EMP-LAST-SUF Derived
Element: Last Suf
EMP-LAST-PRE-SUF Derived
Element: Last Pre Suf
EMP-FIRST-MI Derived
Element: First Mi
EMP-LAST-NAME-EXP Derived
Element: Last Name Exp
EMP-FIRST-MI-EXP Derived
Element: First Mi Exp
EMP-FULL-NAME Derived
Element: Full Name
EMP-SHORT-NAME Derived
Element: Short Name Contains the employee's short name.
EMP-LABEL-NAME-1 Derived
Element: Label Name 1
EMP-WC-PROVINCE Alpha 2 HR11.1 HR11.2
Element: Wc Province Contains the employees province for HR511 HR650
Canadian Workers Compensation. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-COUNTY Alpha 25 (Lower Case) HR11.1 HR11.2
Element: County The county for the company address. HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-RAILROAD-CODE Numeric 1 HR11.1 HR11.2
Element: Railroad Code 0 = Not Railroad Employee HR511 HR650
1 = Tier One Employee PA02.1 PA100
2 = Tier Two Employee PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-I9-DOC-DESCR Alpha 10 Occurs 2 Times
Element: I9 Doc Descr
EMP-FST-DAY-WORKED Numeric 8 (yyyymmdd) HR11.1 HR11.2
Element: Fst Day Worked HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-LAST-DAY-PAID Numeric 8 (yyyymmdd) HR11.1 HR11.2
Element: Last Day Paid HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-TAX-FILTER Numeric 1 HR11.1 HR11.2
Element: Tax Filter 1 = Locate All HR511 HR650
2 = Locate Federal & State Only PA02.1 PA100
3 = Locate Federal Only PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-REMOTE Numeric 1 HR11.1 HR11.2
Element: Remote 0 = Not Remote HR511 HR650
1 = Remote PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMPLOYEE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMPSET1 COMPANY AC03.3 AC131
EMPLOYEE AC17.3 AC18.2
AC190 AC191
AC196 AC203
AC210 AC217
AC218 AC259
AC297 AC41.1
AC41.4 AC42.1
AC50.1 AC500
AC52.1 AC520
AC530 AC54.1
AC540 AC541
AC542 AC550
AC551 AC559
AC59.1 AC62.1
...
EMPSET2 COMPANY KeyChange BN242 BN320
PROCESS-LEVEL HEP3.1 HR12.1
DEPARTMENT HR170 HR650
EMPLOYEE HR70.1 PA149
PA340 PR113
PR134 PR136
PR205 PR212
PR214 PR226
PR229 PR247
PR33.2 PR38.1
PR39.2
EMPSET3 COMPANY KeyChange HR03.1
EMP-STATUS
EMPLOYEE
EMPSET4 COMPANY KeyChange HEP4.1 HR11.1
FICA-NBR HR11.2 HR511
EMPLOYEE HR650 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR297 PR299
UK184
EMPSET6 COMPANY KeyChange HEP2.1 HR212
LAST-NAME HS10.1 HS10.2
FIRST-NAME PA311 PA370
MIDDLE-INIT PR33.3
EMPLOYEE
EMPSET7 COMPANY KeyChange BN100 BN101
PROCESS-LEVEL BN102 BN103
EMPLOYEE BN150 BN242
BN245 BN331
BN66.1 HC01.1
HC02.1 HCEM.1
HCOP.1 HR00.2
HR00.3 HR170
HR217 HR220
HR70.1 PA100
PA113 PA149
PA218 PA335
PA496 PR113
PR128 PR130
PR139 PR140
...
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
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 PEM-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
Prqcentgrp PRQCENTGRP Required
EMP-COMPANY -> PQC-COMPANY
EMP-PROCESS-LEVEL -> PQC-PROCESS-LEVEL
EMP-QC-ENT-NBR-GRP -> PQC-QC-ENT-NBR-GRP
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
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
Bnben BNBEN Delete Cascades
EMP-COMPANY -> BNB-COMPANY
EMP-EMPLOYEE -> BNB-EMPLOYEE
BNB-PLAN-TYPE
BNB-PLAN-CODE
BNB-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-TYPE
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
Correspondence HRCORRESP
EMP-COMPANY -> HCP-COMPANY
"1" -> HCP-REQ-TYPE
EMP-EMPLOYEE -> HCP-ID-NBR
Zeroes -> HCP-DEPENDENT
HCP-SEQ-NBR
Cur Err Pro Tr TIMERECORD
EMP-COMPANY -> TRD-COMPANY
EMP-PROCESS-LEVEL -> TRD-PROCESS-LEVEL
EMP-EMPLOYEE -> TRD-EMPLOYEE
TRD-CHECK-GRP
TRD-REPORT-ENTITY
TRD-BUS-NBR-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-REPORT-ENTITY
PDH-DED-CODE
PDH-SEQ-NBR
PDH-YEAR
PDH-MONTH
PDH-PERIOD-NBR
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-REPORT-ENTITY
TRD-BUS-NBR-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
PEA-FLD-NBR
PEA-ACT-OBJ-ID
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
Prhours PRHOURS Delete Cascades
EMP-COMPANY -> PHS-COMPANY
EMP-EMPLOYEE -> PHS-EMPLOYEE
PHS-HOURS-TYPE
PHS-PAYROLL-YEAR
Quartded QUARTDED
EMP-COMPANY -> QTD-COMPANY
EMP-EMPLOYEE -> QTD-EMPLOYEE
PRS-PAYROLL-YEAR -> QTD-PAYROLL-YEAR
QTD-QUARTER
QTD-COUNTRY-CODE
QTD-DED-CODE
QTD-REPORT-ENTITY
QTD-BUS-NBR-GRP
QTD-QC-ENT-NBR-GRP
QTD-PROCESS-LEVEL
QTD-WORK-STATE
QTD-PENSION
Quartded All QUARTDED
EMP-COMPANY -> QTD-COMPANY
EMP-EMPLOYEE -> QTD-EMPLOYEE
QTD-PAYROLL-YEAR
QTD-QUARTER
QTD-COUNTRY-CODE
QTD-DED-CODE
QTD-REPORT-ENTITY
QTD-BUS-NBR-GRP
QTD-QC-ENT-NBR-GRP
QTD-PROCESS-LEVEL
QTD-WORK-STATE
QTD-PENSION
Quartwage QUARTWAGE
EMP-COMPANY -> QTW-COMPANY
EMP-EMPLOYEE -> QTW-EMPLOYEE
PRS-PAYROLL-YEAR -> QTW-PAYROLL-YEAR
QTW-QUARTER
QTW-COUNTRY-CODE
QTW-PAY-SUM-GRP
QTW-REPORT-ENTITY
QTW-BUS-NBR-GRP
QTW-QC-ENT-NBR-GRP
QTW-PROCESS-LEVEL
QTW-WORK-STATE
QTW-PENSION
Quartwage All QUARTWAGE
EMP-COMPANY -> QTW-COMPANY
EMP-EMPLOYEE -> QTW-EMPLOYEE
QTW-PAYROLL-YEAR
QTW-QUARTER
QTW-COUNTRY-CODE
QTW-PAY-SUM-GRP
QTW-REPORT-ENTITY
QTW-BUS-NBR-GRP
QTW-QC-ENT-NBR-GRP
QTW-PROCESS-LEVEL
QTW-WORK-STATE
QTW-PENSION
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
Step And Grade PRSAGDTL
Valid 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
SGD-EFFECT-DATE
Stock Exer BNEMPEXER
EMP-COMPANY -> BXR-COMPANY
EMP-EMPLOYEE -> BXR-EMPLOYEE
BXR-OPT-GRANT-NBR
BXR-EXERCISE-DATE
BXR-SEQ-NBR
Stock Grant BNEMPGRNT
EMP-COMPANY -> BEG-COMPANY
EMP-EMPLOYEE -> BEG-EMPLOYEE
BEG-OPT-GRANT-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
|