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 AC69.2
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 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 BN66.1
BN70.1 BN70.2 BN77.1 BN80.1 BN81.1 BN81.2
BN82.1 BN85.1 BN90.1 BS09.1 BS10.1 BS11.1
BS12.1 BS30.1 BS31.1 BS531 BR40.3 BR43.1
BR46.1 ET09.1 ET175 ET540 ET542 ET545
ETI3.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 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
HR221 HR255 HR30.1 HR506 HR507 HR513
HR515 HR521 HR54.1 HR55.1 HR55.2 HR70.1
HR79.2 HR90.1 HR90.2 HRS1.1 HRSC.1 HS08.1
HS10.1 HS10.2 HS208 LP100 LP101 LP103
LP138 LP140 LP145 LP180 LP188 LP197
LP198 LP220 LP231 LP240 LP251 LP260
LP262 LP264 LP270 LP31.1 LP32.1 LP32.2
LP32.3 LP331 LP34.1 LP35.1 LP353 LP370
LP51.1 LP53.1 LP54.1 LP553 LP554 LP570
LP60.1 LP60.2 LP60.3 LP60.4 LP61.1 LP62.1
LP62.2 LP63.1 LP63.2 LP64.1 LP64.2 LP65.1
LP70.1 LP70.2 LP80.1 LP88.1 HS11.1 HS11.2
HS12.1 HS12.2 HS13.1 HS13.2 HS14.1 HS15.1
HS50.1 HS50.2 HS50.3 HS50.4 HS50.5 HS51.1
HS51.2 HS52.1 HS52.2 HS701 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 PA26.3 PA26.4 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 PA56.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 PA702 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 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 PR227
PR229 PR23.1 PR230 PR239 PR240 PR241
PR242 PR243 PR244 PR245 PR247 PR248
PR249 PR250 PR251 PR252 PR253 PR260
PR261 PR262 PR265 PR266 PR27.1 PR27.2
PR270 PR275 PR276 PR277 PR278 PR279
PR280 PR281 PR282 PR283 PR284 PR285
PR286 PR287 PR289 PR290 PR291 PR292
PR293 PR295 PR297 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
PRSC.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
PW110 PW510 SN80.2 SN80.3 SNEM.1 SNHC.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 HRLRD HEP3.1 HR03.1
HEP2.1 PR274 PR300 TA195 TA199
UPDATED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN150 BN245 BN305 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
ET530 ET700 ETI1.1 ETI2.1 HR11.1 HR11.2
HR12.1 HR14.1 HR511 HR514 HR708 HR709
LP130 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 PR14.2 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 PR35.9 PR36.1 PR39.1 PR39.2
PR45.1 PR47.1 PR514 PR529 PR530 PR539
PR560 PR80.1 PR80.3 PR82.1 UK102 UK110
UK47.1 UK560 TA147
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMP-COMPANY Numeric 4 BN305 HR11.1
Element: Company Contains the company number. HR11.2 HR511
HS11.1 HS11.2
HS12.1 HS12.2
HS13.1 HS13.2
HS50.1 HS50.2
HS51.1 HS51.2
HS52.1 HS52.2
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA262 PA263
PA502 PA513
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 BN305 HR11.1
Element: Employee Contains the number assigned to each HR11.2 HR511
employee. The employee number is used HS11.1 HS11.2
with the company number to uniquely HS12.1 HS12.2
identify the employee throughout the HS13.1 HS13.2
Lawson Human Capital Management HS50.1 HS50.2
applications. HS51.1 HS51.2
HS52.1 HS52.2
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA262 PA263
PA502 PA513
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) BN305 HR07.1
Element: Last Name Contains the employee's last name. HR11.1 HR11.2
HR511 PA02.1
PA100 PA102
PA115 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-FIRST-NAME Alpha 15 (Lower Case) BN305 HR07.1
Element: First Name Contains the employee's first name. HR11.1 HR11.2
HR511 PA02.1
PA100 PA102
PA115 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-MIDDLE-INIT Alpha 1 BN305 HR07.1
Element: Middle InitialContains the employee's middle initial. HR11.1 HR11.2
HR511 PA02.1
PA100 PA102
PA115 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-MIDDLE-NAME Alpha 15 (Lower Case) BN305 HR11.1
Element: Middle Name Contains the employee's middle name. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-NICK-NAME Alpha 30 (Lower Case) BN305 HR11.1
Element: Nick Name Contains the employee's nick name. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-ADDR1 Alpha 30 (Lower Case) BN305 HR11.1
Element: Addr1 Contains the first line of the HR11.2 HR511
employee's address. PA02.1 PA100
PA102 PA115
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-ADDR2 Alpha 30 (Lower Case) BN305 HR11.1
Element: Addr1 Contains the second line of the HR11.2 HR511
employee's address. PA02.1 PA100
PA102 PA115
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-ADDR3 Alpha 30 (Lower Case) BN305 HR11.1
Element: Addr1 Contains the third line of the HR11.2 HR511
employee's address. PA02.1 PA100
PA102 PA115
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-ADDR4 Alpha 30 (Lower Case) BN305 HR11.1
Element: Addr1 Contains the fourth line of the HR11.2 HR511
employee's address. PA02.1 PA100
PA102 PA115
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-CITY Alpha 18 (Lower Case) BN305 HR11.1
Element: City Contains the city of the employee's HR11.2 HR511
address. PA02.1 PA100
PA102 PA115
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-STATE Alpha 2 BN305 HR11.1
Element: State Contains the state of the employee's HR11.2 HR511
address. PA02.1 PA100
PA102 PA115
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-ZIP Alpha 10 BN305 HR11.1
Element: Zip Contains the postal code of the HR11.2 HR511
employee's address. PA02.1 PA100
PA102 PA115
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-EMP-STATUS Alpha 2 BN305 HCEM.1
Element: Status Contains the employee's status, which HR11.1 HR11.2
can be used to determine if this HR511 PA02.1
employee is paid. PA100 PA102
PA115 PA13.1
PA13.2 PA272
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-FICA-NBR Alpha 20 BN305 HR11.1
Element: Social Number Contains the employee's Social Security HR11.2 HR511
number. PA02.1 PA100
PA102 PA115
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 PR252
PR290 PR291
PR292 PR297
EMP-EIC-STATUS Numeric 1 BN305 HR11.1
Element: EIC Status Indicates if the employee's EIC status HR11.2 HR511
is Single or Joint. PA02.1 PA100
0 = Not Applicable PA102 PA115
1 = Single PA13.1 PA13.2
2 = Joint PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-PROCESS-LEVEL Alpha 5 BN305 HCEM.1
Element: Process Lev HrContains the employee's process level. HR11.1 HR11.2
HR511 PA02.1
PA100 PA102
PA115 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
PR33.2 PR33.3
EMP-DEPARTMENT Alpha 5 BN305 HR11.1
Element: Department Contains the employee's department. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: User Level Contains the employee's user level. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Company Contains the employee's home general HR11.2 HR511
ledger distribution company for expense. PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Acct Unit Contains the employee's home general HR11.2 HR511
ledger accounting unit for expense. PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Account Contains the employee's home general HR11.2 HR511
ledger account for expense. PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Sub Acct Contains the employee's home general HR11.2 HR511
ledger subaccount for expense. PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Job Code Contains the employee's job code. HR11.2 HR170
HR511 HR70.1
PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Union Contains the employee's union code. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Supervisor Contains the supervisor code that HR11.2 HR511
identifies the supervisor to whom the PA02.1 PA100
employee reports. PA102 PA115
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) BN305 HR11.1
Element: Hire Date Contains the employee's hire date. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-FREQUENCY Numeric 1 BN305 HR11.1
Element: Pay Frequency Identifies the employee's pay frequency. HR11.2 HR511
1 = Weekly PA02.1 PA100
2 = Biweekly PA102 PA115
3 = Semimonthly PA13.1 PA13.2
4 = Monthly PA502 PA513
5 = UK Four-Weekly PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR32.1
PR32.2 PR33.2
PR33.3
EMP-SHIFT Numeric 1 BN305 HR11.1
Element: Shift Identifies the shift with which the HR11.2 HR511
employee's pay is associated. PA02.1 PA100
1 = Shift 1 PA102 PA115
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 BN305 HR11.1
Element: Salary Class Indicates if the rate of pay is hourly HR11.2 HR511
or salaried. PA02.1 PA100
H = Hourly PA102 PA115
S = Salaried 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-EXEMPT-EMP Alpha 1 BN305 HR11.1
Element: Exempt Indicates if the employee is exempt HR11.2 HR511
from overtime pay. PA02.1 PA100
N = No PA102 PA115
Y = Yes 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-RATE Signed 13.4 BN305 HR11.1
Element: Pay Rate Contains the employee's rate of pay. HR11.2 HR511
This can be an annual amount or an PA02.1 PA100
hourly amount. If this is a step and PA102 PA115
grade employee, this field is zero and PA13.1 PA13.2
the step, grade and schedule must exist. PA502 PA513
The application uses these fields to PA52.1 PA52.3
retrieve the employee's rate of pay at PA52.4 PA52.5
calculation time. PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR33.2
PR33.3
EMP-STAND-HOURS Signed 7.2 BN305 HR11.1
Element: Stand Hours Contains the number of hours this HR11.2 HR511
employee usually works each pay period. PA02.1 PA100
If you enter a value in this field, PA102 PA115
additional edits occur at time entry. 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-STAND-AMT Signed 11.3 BN305 HR11.1
Element: Stand Amt Contains the amount of money the HR11.2 HR511
employee usually makes per pay period. PA02.1 PA100
If you enter a value in this field, PA102 PA115
additional edits occur at time entry. 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-WARN-FLAG Alpha 1 BN305 HR11.1
Element: Warn Flag Indicates if a warning displays when HR11.2 HR511
the employee exceeds the standard hours PA02.1 PA100
or amount for a pay period. PA102 PA115
N = No PA13.1 PA13.2
Y = Yes PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-ADD-ALLOW-PER Signed 7.3 BN305 HR11.1
Element: Add Allow Per Contains the additional percent (hours HR11.2 HR511
or amount) allowed before a warning PA02.1 PA100
message displays. PA102 PA115
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-ADD-ALLOW-HRS Signed 7.2 BN305 HR11.1
Element: Add Allow Hrs Contains the additional hours allowed HR11.2 HR511
before the warning message displays. PA02.1 PA100
PA102 PA115
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-ADD-ALLOW-AMT Numeric 9 BN305 HR11.1
Element: Add Allow Amt Contains the additional amount of pay HR11.2 HR511
allowed before the warning message PA02.1 PA100
displays. PA102 PA115
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-RPT-INS-COST Signed 11.2 BN305 HR11.1
Element: Reportable InsContains the reportable life insurance HR11.2 HR511
cost for W-2 reporting. If you are using PA02.1 PA100
the Lawson Benefits system, BN150 (Life PA102 PA115
Insurance Reportable Income) updates PA13.1 PA13.2
this field. PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-AUTO-TIME-REC Alpha 1 BN305 HR11.1
Element: Auto Time Rec Indicates if an employee is allowed to HR11.2 HR511
have generated standard time records. PA02.1 PA100
N = No PA102 PA115
S = Standard PA13.1 PA13.2
T = Time Group PA502 PA513
Y = Yes PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-LAST-DED-SEQ Numeric 4 BN100 BN101
Element: Last Ded Seq Contains the last sequence number used BN102 BN103
when a deduction was created for the BN104 BN105
employee through the Lawson Benefits BN145 BN150
system. The Lawson Payroll system does BN245 BN305
not use this field. 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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EMP-AUTO-DEPOSIT Alpha 1 BN305 HR11.1
Element: Auto Deposit Indicates if the employee is set up for HR11.2 HR511
automatic payroll deposit. PA02.1 PA100
N = No PA102 PA115
P = Partial PA13.1 PA13.2
Y = Yes PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-ADJ-HIRE-DATE Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Adjusted Hire Contains the employee's adjusted hire HR11.2 HR511
date. PA02.1 PA100
PA102 PA115
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-ANNIVERS-DATE Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Annivers Date Contains the employee's anniversary HR11.2 HR511
date of employment. PA02.1 PA100
PA102 PA115
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-TERM-DATE Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Term Date Contains the date of employment HR11.2 HR511
termination. PA02.1 PA100
PA102 PA115
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-LAST-CMT-SEQ Numeric 4
Element: Last Cmt Seq Contains the last sequence number used
when the last employee comment was
created.
EMP-CREATION-DATE Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Creation Date Contains the date the employee record HR11.2 HR511
was added to the database. PA02.1 PA100
PA102 PA115
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-NBR-FTE Signed 7.6 BN305 BN350
Element: Full Time EquiContains the employee's FTE (Full-time HR11.1 HR11.2
Equivalency) factor which indicates the HR511 PA02.1
percent of annual hours the employee PA100 PA102
works. For example, if the employee PA115 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 BN305 HR11.1
Element: Pension Plan Indicates if the employee is a HR11.2 HR511
participant in a retirement plan PA02.1 PA100
maintained by the company. PA102 PA115
N = No PA13.1 PA13.2
Y = Yes PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR11.1 PR110
PR113 PR120
PR127 PR13.1
PR13.5 PR13.6
PR13.8
EMP-PAY-STEP Numeric 2 BN305 HR11.1
Element: Step Contains the appropriate step if the HR11.2 HR511
employee's pay is based on a step and PA02.1 PA100
grade schedule. PA102 PA115
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 BN305 HR11.1
Element: Grade Contains the appropriate grade if the HR11.2 HR511
employee is paid based on a step and PA02.1 PA100
grade schedule or is assigned to a grade PA102 PA115
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 BN305 HR11.1
Element: Schedule Contains the schedule the employee is HR11.2 HR511
associated with. There are two types of PA02.1 PA100
schedules: step and grade and grade PA102 PA115
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
application requires a value in the Step PR13.8
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 BN305 HR11.1
Element: Business ExpenContains the employee business expense HR11.2 HR511
amount for W-2 purposes. PA02.1 PA100
PA102 PA115
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-SICK-PAY Signed 11.2 BN305 HR11.1
Element: Sick Pay Contains the employee's non-taxable HR11.2 HR511
sick pay reportable on the W-2 form. PA02.1 PA100
PA102 PA115
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-OT-PLAN-CODE Alpha 4 BN305 HR11.1
Element: Ot Plan Code Contains the pay plan with which the HR11.2 HR511
employee is associated. PA02.1 PA100
PA102 PA115
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-DECEASED Alpha 1 BN305 HR11.1
Element: Deceased Indicates if the employee is deceased. HR11.2 HR511
Y = Yes PA02.1 PA100
N = No PA102 PA115
PA13.1 PA13.2
PA502 PA513
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 BN305 HR11.1
Element: Bsi Group Contains the employee's BSI group code. HR11.2 HR511
A BSI group code is a code defined in PA02.1 PA100
BSI to provide an override tax formula PA102 PA115
for specific employees. 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-STATE Alpha 2 BN305 HR11.1
Element: Work State Contains the employee's work state HR11.2 HR511
abbreviation. PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Tax State Contains the employee's state taxing HR11.2 HR511
authority for income tax purposes. PA02.1 PA100
PA102 PA115
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-PROVINCE Alpha 2 BN305 HR11.1
Element: Province Contains the tax province of the HR11.2 HR511
employee that is used for Canada PA02.1 PA100
Payroll. PA102 PA115
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-WC-STATE Alpha 2 BN305 HR11.1
Element: Wc State Contains the employee's work state HR11.2 HR511
abbreviation that is used for computing PA02.1 PA100
workers' compensation PA102 PA115
premiums. 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-COUNTY Alpha 10 BN305 HR11.1
Element: Tax County Contains the county taxing authority HR11.2 HR511
for income tax purposes. PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Tax City Contains the city taxing authority for HR11.2 HR511
income tax purposes. PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Moving Exp Contains the employee's qualified HR11.2 HR511
moving expenses that are reportable on PA02.1 PA100
the W-2 form. PA102 PA115
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-ALT-RATE-EXIST Alpha 1 BN305 HR11.1
Element: Alt Rate ExistIndicates whether the employee has HR11.2 HR14.1
alternates pay rates defined for HR511 HR514
different job codes. PA02.1 PA100
Y = Yes PA102 PA115
Blank = No 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-PEND-ACT-DATE Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Pend Act Date Contains the date an action will take HR11.2 HR511
effect. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
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 BN305 HR11.1
Element: Tipped Contains a value that indicates whether HR11.2 HR511
the employee is a tipped employee. This PA02.1 PA100
field determines whether the system PA102 PA115
verifies minimum wage and whether to PA13.1 PA13.2
perform the tip credit calculation. PA502 PA513
C = Tipped Employee - Tip Credit PA52.1 PA52.3
N = Not a Tipped Employee PA52.4 PA52.5
T = Tipped Employee -No Tip Credit PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-EMAIL-ADDRESS Alpha 60 (Lower Case) BN305 HR11.1
Element: Email Address Contains the employee's E-mail address. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-ACTIVITY Alpha 15 BN305 HR11.1
Element: Activity Contains the activity. HR11.2 HR511
PA02.1 PA100
Activities are the tasks that make up PA102 PA115
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 BN305 HR11.1
Element: Acct Category Contains the account category. HR11.2 HR511
PA02.1 PA100
Account categories are the Activity PA102 PA115
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 BN305 HR11.1
Element: Max Limit OvrdIndicates the default for the maximum HR11.2 HR511
compensation limit from Benefit Plan PA02.1 PA100
file has been overriden for this PA102 PA115
employee. PA13.1 PA13.2
Y = Yes PA502 PA513
N = No PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-SEC-LVL Numeric 1 BN305 HR11.1
Element: Sec Lvl Contains the employee's security level. HR11.2 HR12.1
HR511 PA02.1
PA100 PA102
PA115 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-SEC-LOCATION Alpha 10 BN305 HR11.1
Element: Sec Location Contains the employee's security HR11.2 HR12.1
location. HR511 PA02.1
PA100 PA102
PA115 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-POSITION Alpha 12 BN305 HR11.1
Element: Position Contains the user-defined code that HR11.2 HR511
represents a position in the company. PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Work Sched Contains the employee's work schedule. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Supervisor IndContains the employee's indirect HR11.2 HR511
supervisor. PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Annual Hours Contains the employee's annual hours. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Work County Contains the employee's work county. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Work City Contains the employee's work city. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Work School Contains the employee's work school. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Tax School Contains the employee's school tax HR11.2 HR511
authority. PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Fte Total Contains the employee's total FTE. HR11.2 HR511
PA02.1 PA100
The total FTE is the sum of the FTEs PA102 PA115
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 BN305 HR11.1
Element: Pay Rate HR11.2 HR511
PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Pay Rate HR11.2 HR511
PA02.1 PA100
PA102 PA115
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) BN305 HR11.1
Element: New Hire Date HR11.2 HR511
PA02.1 PA100
PA102 PA115
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 PR296
EMP-COMPA-RATIO Derived
Element: Compa Ratio
EMP-PENET-RATIO Derived
Element: Penet 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 BN305 HR11.1
Element: Currency Code Contains the pay currency. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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 BN305 HR11.1
Element: Acct Nd The number of decimals assigned to a HR11.2 HR511
particular account as determined by the PA02.1 PA100
account currency. PA102 PA115
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 BN305 HR11.1
Element: Country Code Contains the country of the employee's HR11.2 HR511
home address. PA02.1 PA100
PA102 PA115
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-NAME-PREFIX Alpha 4 (Lower Case) BN305 HR11.1
Element: Name Prefix Contains the prefix (title) of the HR11.2 HR511
employee's name. PA02.1 PA100
PA102 PA115
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-NAME-SUFFIX Alpha 4 (Lower Case) BN305 HR11.1
Element: Name Suffix Contains the suffix of the employee's HR11.2 HR511
name. PA02.1 PA100
PA102 PA115
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-COUNTRY Alpha 2 BN305 HR11.1
Element: Country Code Contains the employee's work country. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-LAST-NAME-PRE Alpha 30 (Lower Case) BN305 HR11.1
Element: Last Name Pre Contains the employee's previous last HR11.2 HR511
name. PA02.1 PA100
PA102 PA115
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-EST-REMUN Signed 11.2 BN305 HR11.1
Element: Est Remun Used for taxing Canada Commission HR11.2 HR511
Payments. PA02.1 PA100
PA102 PA115
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-EST-EXPENSE Signed 11.2 BN305 HR11.1
Element: Est Expense Used for taxing Canada Commission HR11.2 HR511
Payments. PA02.1 PA100
PA102 PA115
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-BUS-NBR-GRP Alpha 4 BN305 HR11.1
Element: Bus Nbr Grp Contains the business number group. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-QC-ENT-NBR-GRP Alpha 4 BN305 HR11.1
Element: Qc Ent Nbr GrpContains the Quebec enterprise number HR11.2 HR511
group. PA02.1 PA100
PA102 PA115
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-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 BN305 HR11.1
Element: Wc Province Contains the employees province for HR11.2 HR511
Canadian Workers Compensation. PA02.1 PA100
PA102 PA115
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-COUNTY Alpha 25 (Lower Case) BN305 HR11.1
Element: County The county for the company address. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-RAILROAD-CODE Numeric 1 BN305 HR11.1
Element: Railroad Code 0 = Not Railroad Employee HR11.2 HR511
1 = Tier One Employee PA02.1 PA100
2 = Tier Two Employee PA102 PA115
3 = Both Tier 1 and Tier 2 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-FST-DAY-WORKED Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Fst Day Worked HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-LAST-DAY-PAID Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Last Day Paid HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-LAB-DIST-FLAG Alpha 1 BN305 HR11.1
Element: Lab Dist Flag " " = Not Applicable HR11.2 HR511
Y = Yes PA02.1 PA100
N = No PA102 PA115
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-ENCUMBER-FLAG Alpha 1 BN305 HR11.1
Element: Encumber Flag " " = Not Applicable HR11.2 HR511
Y = Yes PA02.1 PA100
N = No PA102 PA115
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-EFFORT-FLAG Alpha 1 BN305 HR11.1
Element: Effort Flag Flag to indicate whether this activity HR11.2 HR511
is subject to effort reporting, and if PA02.1 PA100
it is, whether it prints in the PA102 PA115
sponsored or non-sponsored section of PA13.1 PA13.2
the report for effort reporting. PA502 PA513
" " = Not Applicable PA52.1 PA52.3
Y = Yes PA52.4 PA52.5
N = No PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-RPT-CURR Alpha 5 BN305 HR11.1
Element: Rpt Curr HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-PRMCERT-ID Numeric 9 BN305 HR11.1
Element: Employee Contains the employee number. Each HR11.2 HR511
person employed by the company is PA02.1 PA100
assigned a unique number. The system PA102 PA115
uses the employee number to correlate PA13.1 PA13.2
all of the information related to that PA502 PA513
person. PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-SNDCERT-ID Numeric 9 BN305 HR11.1
Element: Employee Contains the employee number. Each HR11.2 HR511
person employed by the company is PA02.1 PA100
assigned a unique number. The system PA102 PA115
uses the employee number to correlate PA13.1 PA13.2
all of the information related to that PA502 PA513
person. 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 BN305 HR11.1
Element: Frng Rate A default fringe rate that can be sued HR11.2 HR511
by the GM110 program to create PA02.1 PA100
commitments for fringe amounts. There PA102 PA115
is a parameter choice on the GM110 PA13.1 PA13.2
program that allows the user to default PA502 PA513
the fringe rate, post-to account and PA52.1 PA52.3
account category information from the PA52.4 PA52.5
activity or the employee. PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EMP-FRNG-ACCT-CAT Alpha 5 BN305 HR11.1
Element: Acct Category Account categories are groupings of HR11.2 HR511
costs, revenues, or a combination of PA02.1 PA100
both used for reporting and inquiries PA102 PA115
for activities in the Activity PA13.1 PA13.2
Management system. All transactions are PA502 PA513
posted to an account category within an PA52.1 PA52.3
activity. You can assign a specific PA52.4 PA52.5
General Ledger account or range of PR110 PR113
accounts (company, accounting unit, PR120 PR13.1
account, and subaccount) that make up PR13.5 PR13.6
the transactions posted to an account PR13.8
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
EMP-FRNG-ACCOUNT Numeric 6 BN305 HR11.1
Element: Account This field along with the accounting HR11.2 HR511
unit and subaccount make up the location PA02.1 PA100
(account) where amounts and other PA102 PA115
account information is stored. 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-FRNG-SUB-ACCT Numeric 4 BN305 HR11.1
Element: Sub Acct This field contains the subaccount from HR11.2 HR511
your general ledger chart of accounts PA02.1 PA100
that was charged with the amount carried PA102 PA115
on this record. 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-DEATH-DATE Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Date This field displays the system date HR11.2 HR511
when this was created. PA02.1 PA100
PA102 PA115
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-FILTER Numeric 1 BN305 HR11.1
Element: Tax Filter 1 = Locate All HR11.2 HR511
2 = Locate Federal & State Only PA02.1 PA100
3 = Locate Federal Only PA102 PA115
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-REMOTE Numeric 1 BN305 HR11.1
Element: Remote 0 = Not Remote HR11.2 HR511
1 = Remote PA02.1 PA100
PA102 PA115
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-PUB-SEC-RETIRE Numeric 1 BN305 HR11.1
Element: Pub Sec Retire0 = Not a Member HR11.2 HR511
1 = Yes; Use Hire Date PA02.1 PA100
2 = Yes; Use Adj Hire Date PA102 PA115
3 = Yes; Commonwealth of MA 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-PRMCERT-COMP Numeric 4 BN305 HR11.1
Element: Company Hr HR11.2 HR511
HR708 PA02.1
PA100 PA102
PA115 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-SNDCERT-COMP Numeric 4 BN305 HR11.1
Element: Company Hr HR11.2 HR511
HR708 PA02.1
PA100 PA102
PA115 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-ST-STATUS Numeric 1
Element: St Status
EMP-LAST-NAME-UC Alpha 30 BN305 HR11.1
Element: Last Name Uc Employees last name in upper case for HR11.2 HR511
efficiency in select by name HR709 PA02.1
PA100 PA102
PA115 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-FIRST-NAME-UC Alpha 15 BN305 HR11.1
Element: First Name Uc Employees first name in upper case for HR11.2 HR511
efficiency in select by name HR709 PA02.1
PA100 PA102
PA115 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
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 AC69.2
AC92.2 AC92.4
AC92.6 ACAC.1
BN100 BN101
...
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 BN100 BN101
EMP-STATUS BN102 BN103
EMPLOYEE BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
HR03.1
EMPSET4 COMPANY KeyChange BN305 HEP4.1
FICA-NBR HR11.1 HR11.2
EMPLOYEE HR511 PA02.1
PA100 PA102
PA115 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
PR297 PR299
UK184
EMPSET6 COMPANY KeyChange HEP2.1 HR212
LAST-NAME-UC HR255 HS10.1
FIRST-NAME-UC HS10.2 PA311
MIDDLE-INIT PA370 PR33.3
EMPLOYEE
EMPSET7 COMPANY KeyChange BN100 BN101
PROCESS-LEVEL BN102 BN103
EMPLOYEE BN150 BN242
BN245 BN331
BS531 HC01.2
HCDL.1 HCEM.1
HR00.2 HR00.3
HR170 HR217
HR220 HR70.1
LP100 LP103
LP130 LP180
LP231 LP240
LP264 LP270
LP353 PA100
PA113 PA149
...
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
Prmcert Id EMPLOYEE Required
When (EMP-PRMCERT-COMP != Zeroes )
And (EMP-PRMCERT-COMP != Zeroes )
EMP-PRMCERT-COMP -> EMP-COMPANY
EMP-PRMCERT-ID -> EMP-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
Sndcert Id EMPLOYEE Required
When (EMP-SNDCERT-COMP != Zeroes )
And (EMP-SNDCERT-ID != Zeroes )
EMP-SNDCERT-COMP -> EMP-COMPANY
EMP-SNDCERT-ID -> EMP-EMPLOYEE
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 Leave LPEMPLEAVE
EMP-COMPANY -> LEL-COMPANY
EMP-EMPLOYEE -> LEL-EMPLOYEE
LEL-BEGIN-DATE
LEL-SEQ-NBR
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
Gmeffort GMEFFORT
EMP-COMPANY -> EFH-HR-COMPANY
EMP-EMPLOYEE -> EFH-EMPLOYEE
EFH-BEGIN-DATE
EFH-END-DATE
EFH-SEQUENCE-NBR
Gmlabdist GMLABDIST
EMP-COMPANY -> GML-HR-COMPANY
EMP-EMPLOYEE -> GML-EMPLOYEE
GML-EFFECT-DATE
GML-JOB-CODE
GML-POSITION
GML-PAY-CODE
Gmretdist GMRETDIST
EMP-COMPANY -> GMI-HR-COMPANY
EMP-EMPLOYEE -> GMI-EMPLOYEE
GMI-START-DATE
GMI-END-DATE
GMI-JOB-CODE
GMI-POSITION
GMI-PAY-CODE
GMI-SEQUENCE-NBR
Gmtranefrt GMTRANEFRT
EMP-COMPANY -> GEF-HR-COMPANY
EMP-EMPLOYEE -> GEF-EMPLOYEE
GEF-ACTIVITY
GEF-ACCT-CATEGORY
GEF-COMPANY
GEF-ACCT-UNIT
GEF-ACCOUNT
GEF-SUB-ACCT
GEF-OBJ-ID
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-TR-DATE
TES-TES-OBJ-ID
TES-SERVICE-STATUS
TES-EVENT-STATUS
Lptrans TAEMPTRANS
EMP-COMPANY -> TTR-COMPANY
EMP-EMPLOYEE -> TTR-EMPLOYEE
TTR-PLAN
TTR-EMPLOYEE-GROUP
TTR-POSITION
TTR-DATE
TTR-SEQ-NBR
Objectives PAEMPGOAL Delete Restricted
EMP-COMPANY -> PGO-COMPANY
EMP-EMPLOYEE -> PGO-EMPLOYEE
PGO-END-DATE
PGO-PRIORITY
PGO-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
Ot Plan Code PROVERTIME
Valid When EMP-OT-PLAN-CODE != Spaces
EMP-COMPANY -> PRO-COMPANY
EMP-OT-PLAN-CODE -> PRO-PLAN-CODE
PRO-EFFECT-DATE
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
Payments2 PAYMASTR
EMP-COMPANY -> PYM-COMPANY
EMP-EMPLOYEE -> PYM-EMPLOYEE
PYM-CHECK-DATE
PYM-CHECK-NBR
PYM-CHECK-ID
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
Taloshrs TALOSHRS Delete Cascades
EMP-COMPANY -> TLH-COMPANY
EMP-EMPLOYEE -> TLH-EMPLOYEE
TLH-PLAN
TLH-EMPLOYEE-GROUP
TLH-POSITION
TLH-PLAN-RULE
TLH-ACCRUAL-TYPE
TLH-YEAR
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
|