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 AC03.7 AC145 AC17.3 AC18.2 AC190
AC191 AC197 AC203 AC210 AC217 AC218
AC41.1 AC41.4 AC42.1 AC46.1 AC50.1 AC500
AC52.1 AC520 AC54.1 AC540 AC62.1 AC92.2
AC92.4 AC92.6 ACAC.1 BN106 BN134 BN137
BN138 BN140 BN141 BN175 BN180 BN181
BN230 BN231 BN232 BN233 BN234 BN236
BN237 BN238 BN240 BN242 BN246 BN247
BN248 BN258 BN259 BN281 BN285 BN30.1
BN300 BN305 BN310 BN320 BN321 BN325
BN33.1 BN33.2 BN33.3 BN33.4 BN330 BN331
BN335 BN340 BN345 BN35.1 BN350 BN36.1
BN430 BN46.1 BN46.2 BN47.1 BN48.1 BN48.2
BN480 BN50.1 BN51.1 BN51.2 BN53.1 BN532
BN533 BN534 BN547 BN55.1 BN55.2 BN555
BN56.1 BN57.1 BN59.1 BN60.1 BN61.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 BR40.3 BR43.1 BR46.1
HC01.2 HCDL.1 HCEM.1 HCHP.1 HCSU.1 ES02.1
ES10.1 HAP3.1 HCTC.1 HEMD.1 HEMP.1 HEP4.1
HGLN.1 HHSU.1 HOSH.1 HPAE.1 HPOS.1 HPQC.1
HPRS.1 HR00.1 HR00.2 HR01.1 HR02.1 HR04.2
HR04.3 HR04.7 HR04.8 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 HR221 HR255 HR30.1 HR506
HR507 HR513 HR515 HR521 HR54.1 HR55.1
HR55.2 HR70.1 HR79.2 HR80.1 HR80.2 HR80.3
HR80.4 HR80.5 HR80.6 HR80.7 HR80.8 HR80.9
HR81.1 HR81.2 HR81.3 HR81.4 HR81.5 HR81.6
HR81.7 HR81.8 HR81.9 HR82.1 HR82.2 HR82.3
HR82.4 HR82.5 HR82.6 HR82.7 HR82.8 HR82.9
HR83.1 HR83.2 HR83.3 HR83.4 HR83.5 HR83.6
HR83.7 HR83.8 HR83.9 HR84.1 HR84.2 HR84.3
HR84.4 HR84.5 HR84.6 HR84.7 HR84.8 HR84.9
HR85.1 HR85.2 HR85.3 HR85.4 HR85.5 HR85.6
HR85.7 HR85.8 HR86.1 HR86.2 HR86.3 HR86.4
HR86.5 HR86.6 HR86.7 HR86.8 HR86.9 HR87.1
HR87.2 HR87.3 HR87.4 HR87.5 HR87.6 HR87.7
HR87.8 HR87.9 HR88.1 HR88.2 HR88.3 HR88.4
HR88.5 HR88.6 HR88.7 HR89.1 HR89.2 HR89.3
HR89.4 HR89.5 HR89.6 HR89.7 HR89.8 HR89.9
HR90.1 HR90.2 HRS1.1 HRSC.1 HS10.1 HS10.2
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 PA03.3 PA09.1 PA10.1
PA105 PA111 PA113 PA12.1 PA125 PA130
PA14.1 PA149 PA15.1 PA15.2 PA16.1 PA17.1
PA18.1 PA182 PA19.1 PA20.1 PA201 PA208
PA21.1 PA210 PA211 PA212 PA213 PA214
PA215 PA216 PA217 PA218 PA219 PA22.1
PA220 PA221 PA222 PA223 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 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 PA42.3 PA43.1 PA44.1 PA45.1 PA49.1
PA49.2 PA49.3 PA490 PA495 PA496 PA50.1
PA512 PA520 PA53.1 PA531 PA532 PA533
PA534 PA535 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 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 PR127 PR135
PR137 PR141 PR142 PR155 PR160 PR162
PR180 PR188 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 PR286 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 PRSA.1 PRSC.1 PRWC.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 TP100
TP120 TP125 TP130 TP140 TP20.1 TP20.2
TP210 TP220 TP30.1 TP30.2 TP40.2 TP40.3
HRLRD HEP3.1 HR03.1 HEP2.1 TA195 TA199
UPDATED BY
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 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 PR128 PR13.1
PR13.2 PR13.5 PR13.6 PR13.8 PR130 PR131
PR132 PR134 PR136 PR14.1 PR15.1 PR15.2
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 PR35.9 PR36.1 PR39.1
PR39.2 PR45.1 PR47.1 PR529 PR530 PR560
PR82.1 UK102 UK110 UK47.1 TA147 TP135
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMP-COMPANY Numeric 4 HR11.1 HR11.2
Element: Company Contains the company number. HR511 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 HS50.1
employee. The employee number is used HS50.2 HS51.1
with the company number to uniquely HS51.2 HS52.1
identify the employee throughout the HS52.2 PA02.1
Lawson Human Resources systems. 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
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
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
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 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 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 PA02.1
employee's address. 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 PA02.1
employee's address. 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 PA02.1
employee's address. 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 PA02.1
employee's address. 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 PA02.1
address. 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 PA02.1
address. PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-ZIP Alpha 10 HR11.1 HR11.2
Element: Postal Code Contains the postal code of the HR511 PA02.1
employee's address. 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 HR11.1
Element: Status Contains the employee's status, which HR11.2 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 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-FICA-NBR Alpha 20 HR11.1 HR11.2
Element: Social Number Contains the employee's Social Security HR511 PA02.1
number. 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 PA02.1
is Single or Joint. PA100 PA102
0 = Not Applicable PA502 PA52.1
1 = Single PA52.3 PA52.4
2 = Joint PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-PROCESS-LEVEL Alpha 5 HCEM.1 HR11.1
Element: Process Lev HrContains the employee's process level. HR11.2 HR511
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 HR11.1 HR11.2
Element: 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
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-USER-LEVEL Alpha 10 HR11.1 HR11.2
Element: 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
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-HM-DIST-CO Numeric 4 HR11.1 HR11.2
Element: Company 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
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-HM-ACCT-UNIT Alpha 15 HR11.1 HR11.2
Element: Accounting UniContains the employee's home general HR511 PA02.1
ledger accounting unit for expense. 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 HR11.1 HR11.2
Element: 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
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-HM-SUB-ACCT Numeric 4 HR11.1 HR11.2
Element: 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
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-JOB-CODE Alpha 9 HR11.1 HR11.2
Element: 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
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-UNION-CODE Alpha 10 HR11.1 HR11.2
Element: 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
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-SUPERVISOR Alpha 10 HR11.1 HR11.2
Element: 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
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-DATE-HIRED Numeric 8 (yyyymmdd) HR11.1 HR11.2
Element: Hire Date Contains the employee's hire date. HR511 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 PA02.1
1 = Weekly PA100 PA102
2 = Biweekly PA502 PA52.1
3 = Semimonthly PA52.3 PA52.4
4 = Monthly PA52.5 PR110
5 = UK Four-Weekly PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR32.1 PR32.2
PR33.2 PR33.3
EMP-SHIFT Numeric 1 HR11.1 HR11.2
Element: 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 PR110 PR113
6 = Shift 6 PR120 PR13.1
7 = Shift 7 PR13.5 PR13.6
8 = Shift 8 PR13.8
9 = Shift 9
EMP-SALARY-CLASS Alpha 1 HR11.1 HR11.2
Element: 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 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-EXEMPT-EMP Alpha 1 HR11.1 HR11.2
Element: 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 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 PA02.1
This can be an annual amount or an PA100 PA102
hourly amount. If this is a step and PA13.1 PA13.2
grade employee, this field is zero and PA502 PA513
the step, grade and schedule must exist. PA52.1 PA52.3
The system uses these fields to retrieve PA52.4 PA52.5
the employee's rate of pay at PR110 PR113
calculation time. 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 PA02.1
employee usually works each pay period. PA100 PA102
If you enter a value in this field, PA502 PA52.1
additional edits occur at time entry. 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 PA02.1
employee usually makes per pay period. PA100 PA102
If you enter a value in this field, PA502 PA52.1
additional edits occur at time entry. 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 PA02.1
the employee exceeds the standard hours PA100 PA102
or amount for a pay period. PA502 PA52.1
N = No PA52.3 PA52.4
Y = Yes 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 PA02.1
or amount) allowed before a warning PA100 PA102
message displays. 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 PA02.1
before the warning message displays. 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 PA02.1
allowed before the warning message PA100 PA102
displays. 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 PA02.1
cost for W-2 reporting. If you are using PA100 PA102
the Lawson Benefits system, BN150 (Life PA502 PA52.1
Insurance Reportable Income) updates PA52.3 PA52.4
this field. PA52.5 PR11.1
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 PA02.1
Record have generated standard time records. PA100 PA102
N = No PA502 PA52.1
S = Standard PA52.3 PA52.4
T = Time Group PA52.5 PR110
Y = Yes PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
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 BN150
system. The Lawson Payroll system does BN245 BN31.1
not use this field. 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EMP-AUTO-DEPOSIT Alpha 1 HR11.1 HR11.2
Element: Automatic DepoIndicates if the employee is set up for HR511 PA02.1
automatic payroll deposit. PA100 PA102
N = No PA502 PA52.1
P = Partial PA52.3 PA52.4
Y = Yes PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-ADJ-HIRE-DATE Numeric 8 (yyyymmdd) HR11.1 HR11.2
Element: Adjusted Hire Contains the employee's adjusted hire HR511 PA02.1
date. 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 PA02.1
date of employment. 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) HR11.1 HR11.2
Element: Termination DaContains the date of employment HR511 PA02.1
termination. 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
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 HR11.2
Element: Creation Date Contains the date the employee record HR511 PA02.1
was added to the database. 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 7.6 BN350 HR11.1
Element: Full Time EquiContains the employee's FTE (Full-time HR11.2 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 PR110
employee. PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
TA175 TA199
EMP-PENSION-PLAN Alpha 1 HR11.1 HR11.2
Element: Pension Plan Indicates if the employee is a HR511 PA02.1
participant in a retirement plan PA100 PA102
maintained by the company. PA502 PA52.1
N = No PA52.3 PA52.4
Y = Yes PA52.5 PR11.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-PAY-STEP Numeric 2 HR11.1 HR11.2
Element: 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
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-PAY-GRADE Alpha 3 HR11.1 HR11.2
Element: 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
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-SCHEDULE Alpha 9 HR11.1 HR11.2
Element: 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 PR110 PR113
pay based on their particular "step" and PR120 PR13.1
"grade." If the employee is associated PR13.5 PR13.6
with a step and grade schedule, the PR13.8
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 HR11.2
Element: Business ExpenContains the employee business expense HR511 PA02.1
amount for W-2 purposes. PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR11.1
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 PA02.1
sick pay reportable on the W-2 form. PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR11.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-OT-PLAN-CODE Alpha 4 HR11.1 HR11.2
Element: 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 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 PA02.1
Y = Yes PA100 PA102
N = No PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR11.1
PR110 PR113
PR120 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 PA02.1
A BSI group code is a code defined in PA100 PA102
BSI to provide an override tax formula PA502 PA52.1
for specific employees. 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 PA02.1
abbreviation. 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 PA02.1
authority for income tax purposes. 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 PA02.1
employee that is used for Canada PA100 PA102
Payroll. 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 PA02.1
abbreviation that is used for computing PA100 PA102
workers' compensation PA502 PA52.1
premiums. 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 PA02.1
for income tax purposes. 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 PA02.1
income tax purposes. 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 PA02.1
moving expenses that are reportable on PA100 PA102
the W-2 form. PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR11.1
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 PA02.1
different job codes. PA100 PA102
Y = Yes PA502 PA52.1
Blank = No 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 PA02.1
effect. 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 PA02.1
the employee is a tipped employee. This PA100 PA102
field determines whether the system PA502 PA52.1
verifies minimum wage and whether to PA52.3 PA52.4
perform the tip credit calculation. PA52.5 PR110
C = Tipped Employee - Tip Credit PR113 PR120
N = Not a Tipped Employee PR13.1 PR13.5
T = Tipped Employee -No Tip Credit 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 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 HR11.1 HR11.2
Element: 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 PR110 PR113
activity. The Activity Management system PR120 PR13.1
stores information such as PR13.5 PR13.6
responsibility and schedule for each PR13.8
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 HR11.1 HR11.2
Element: Account CategoContains 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 PR110 PR113
budgeting or transaction processing. PR120 PR13.1
Using account categories, you can sort PR13.5 PR13.6
and combine incoming amounts into groups PR13.8
for reporting and inquiry on activities.
EMP-MAX-LIMIT-OVRD Alpha 1 HR11.1 HR11.2
Element: Max Limit OvrdIndicates the default for the maximum HR511 PA02.1
compensation limit from Benefit Plan PA100 PA102
file has been overriden for this PA502 PA52.1
employee. PA52.3 PA52.4
Y = Yes PA52.5 PR110
N = No 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
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. 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 HR11.1 HR11.2
Element: 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
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 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 PA02.1
supervisor. 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 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 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 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 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 PA02.1
authority. 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 11.6 HR11.1 HR11.2
Element: Fte Total Contains the employee's total FTE. HR511 PA02.1
PA100 PA102
The total FTE is the sum of the FTEs PA13.1 PA13.2
for all of the employee's (Level 1 PA502 PA513
through 5) positions or jobs. 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: Rate of Pay HR511 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: Rate of Pay HR511 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 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 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 Represents the number of decimals HR511 PA02.1
Code defined for the currency of the object. 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 PA02.1
home address. 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 PA02.1
employee's name. 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 PA02.1
name. 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 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 PA02.1
name. 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 PA02.1
Payments. 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 PA02.1
Payments. 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 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 PA02.1
group. 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 PA02.1
Canadian Workers Compensation. 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 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 PA02.1
1 = Tier One Employee PA100 PA102
2 = Tier Two Employee PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-FST-DAY-WORKED Numeric 8 (yyyymmdd) HR11.1 HR11.2
Element: Fst Day Worked HR511 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 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-LAB-DIST-FLAG Alpha 1 HR11.1 HR11.2
Element: Lab Dist Flag " " = Not Applicable HR511 PA02.1
Y = Yes PA100 PA102
N = No PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-ENCUMBER-FLAG Alpha 1 HR11.1 HR11.2
Element: Encumber Flag " " = Not Applicable HR511 PA02.1
Y = Yes PA100 PA102
N = No PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
EMP-EFFORT-FLAG Alpha 1 HR11.1 HR11.2
Element: Effort Flag Flag to indicate whether this activity HR511 PA02.1
is subject to effort reporting, and if PA100 PA102
it is, whether it prints in the PA502 PA52.1
sponsored or non-sponsored section of PA52.3 PA52.4
the report for effort reporting. PA52.5 PR110
" " = Not Applicable PR113 PR120
Y = Yes PR13.1 PR13.5
N = No PR13.6 PR13.8
EMP-RPT-CURR Alpha 5 HR11.1 HR11.2
Element: Rpt Curr HR511 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-PRMCERT-ID Numeric 9 HR11.1 HR11.2
Element: Employee HR511 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-SNDCERT-ID Numeric 9 HR11.1 HR11.2
Element: Employee HR511 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-FRNG-RATE Signed 12.6 HR11.1 HR11.2
Element: Frng Rate A default fringe rate that can be sued HR511 PA02.1
by the GM110 program to create PA100 PA102
commitments for fringe amounts. There PA502 PA52.1
is a parameter choice on the GM110 PA52.3 PA52.4
program that allows the user to default PA52.5 PR110
the fringe rate, post-to account and PR113 PR120
account category information from the PR13.1 PR13.5
activity or the employee. PR13.6 PR13.8
EMP-FRNG-ACCT-CAT Alpha 5 HR11.1 HR11.2
Element: Account CategoA default post-to fringe account HR511 PA02.1
category that can be used by GM110 PA100 PA102
program to create commitments for fringe PA502 PA52.1
amounts. There is a parameter choice on PA52.3 PA52.4
the GM110 program that allows the user PA52.5 PR110
to default the rate, post-to account and PR113 PR120
account category information from the PR13.1 PR13.5
activity or employee. PR13.6 PR13.8
EMP-FRNG-ACCOUNT Numeric 6 HR11.1 HR11.2
Element: Account A default post-to fringe account that HR511 PA02.1
can be used by the GM110 program to PA100 PA102
create commitments for fringe amounts. PA502 PA52.1
There is a parameter choice on the GM110 PA52.3 PA52.4
program that allows the user to default PA52.5 PR110
the fringe rate, post-to account and PR113 PR120
account category information from the PR13.1 PR13.5
activity or employee. PR13.6 PR13.8
EMP-FRNG-SUB-ACCT Numeric 4 HR11.1 HR11.2
Element: Subaccount A default post-to fringe sub account HR511 PA02.1
that can be used by the GM110 program to PA100 PA102
create commitments for fringe amounts. PA502 PA52.1
There is a parameter choice on the GM110 PA52.3 PA52.4
program that allows the user to default PA52.5 PR110
the fringe rate, post-to account and PR113 PR120
account category information from the PR13.1 PR13.5
activity or employee. PR13.6 PR13.8
EMP-DEATH-DATE Numeric 8 (yyyymmdd) HR11.1 HR11.2
Element: Date HR511 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 PA02.1
2 = Locate Federal & State Only PA100 PA102
3 = Locate Federal Only 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 PA02.1
1 = Remote 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 AC03.7
EMPLOYEE AC145 AC17.3
AC18.2 AC190
AC191 AC197
AC203 AC210
AC217 AC218
AC41.1 AC41.4
AC42.1 AC46.1
AC50.1 AC500
AC52.1 AC520
AC54.1 AC540
AC62.1 AC92.2
AC92.4 AC92.6
ACAC.1 BN100
BN101 BN102
...
EMPSET2 COMPANY KeyChange BN242 BN320
PROCESS-LEVEL HEP3.1 HR12.1
DEPARTMENT HR170 HR70.1
EMPLOYEE PA149 PA213
PA340 TR222
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 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
HC01.2 HCDL.1
HCEM.1 HR00.2
HR170 HR217
HR220 HR70.1
PA100 PA113
PA149 PA213
PA218 PA335
PA496 PR113
PR128 PR130
PR141 PR197
PR212 PR214
...
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
Supervisor HRSUPER Required
When EMP-SUPERVISOR != Spaces
EMP-COMPANY -> HSU-COMPANY
EMP-SUPERVISOR -> HSU-CODE
Tax Rpt State PREMPSTATE Not Required
Valid When (EMP-TAX-STATE != Spaces )
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
Valid When EMP-WORK-STATE != Spaces
EMP-COMPANY -> PES-COMPANY
EMP-EMPLOYEE -> PES-EMPLOYEE
EMP-WORK-STATE -> PES-STATE
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
COD-PROCESS-LEVEL
COD-BUS-NBR-GRP
COD-QC-ENT-NBR-GRP
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
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
Hr Occup Code HROCCUPCD
Valid When EMP-JOB-CODE != Spaces
EMP-COMPANY -> HOP-COMPANY
EMP-JOB-CODE -> HOP-JOB-CODE
EMP-WORK-COUNTRY -> HOP-COUNTRY-CODE
HOP-OCCUPTN-CODE
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
Lp Service TAEMPSERV
EMP-COMPANY -> TES-COMPANY
EMP-EMPLOYEE -> TES-EMPLOYEE
TES-TES-OBJ-ID
Lptrans TAEMPTRANS
EMP-COMPANY -> TTR-COMPANY
EMP-EMPLOYEE -> TTR-EMPLOYEE
TTR-PLAN
TTR-EMPLOYEE-GROUP
TTR-POSITION
TTR-DATE
TTR-SEQ-NBR
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
Schedule PRSAGHEAD
Valid When EMP-SCHEDULE != Spaces
EMP-COMPANY -> SGH-COMPANY
"S" -> SGH-INDICATOR
EMP-SCHEDULE -> SGH-SCHEDULE
SGH-EFFECT-DATE
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
Super Codes HRSUPER
EMP-COMPANY -> HSU-COMPANY
EMP-EMPLOYEE -> HSU-EMPLOYEE
HSU-CODE
Ta Enroll TAENROLL Delete Cascades
EMP-COMPANY -> TEN-COMPANY
EMP-EMPLOYEE -> TEN-EMPLOYEE
TEN-PLAN
TEN-EMPLOYEE-GROUP
TEN-POSITION
TEN-JOB-CODE
TEN-PROCESS-LEVEL
TEN-DEPARTMENT
Ta Group TAEEGROUP Delete Cascades
EMP-COMPANY -> TGR-COMPANY
EMP-EMPLOYEE -> TGR-EMPLOYEE
TGR-EMPLOYEE-GROUP
TGR-EFFECTIVE-DATE
TGR-QUALIFY-FLAG
Ta Master TAEEMASTER Delete Cascades
EMP-COMPANY -> TEM-COMPANY
EMP-EMPLOYEE -> TEM-EMPLOYEE
TEM-PLAN
TEM-EMPLOYEE-GROUP
TEM-POSITION
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
Work Sched HRWRKSCHD
Valid When (EMP-WORK-SCHED != Spaces )
EMP-COMPANY -> WSC-COMPANY
EMP-WORK-SCHED -> WSC-WORK-SCHED
WSC-EFFECT-DATE
|