EMPLOYEE

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
AC297 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 BN140 BN141 BN175 BN180
BN181 BN230 BN231 BN232 BN233 BN234
BN236 BN237 BN238 BN240 BN242 BN246
BN247 BN248 BN258 BN259 BN260 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 BN556 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
BS11.1 BS30.1 BS31.1 BS531 ZB01.1 ZS531
BR40.3 BR43.1 BR46.1 HC01.2 HCDL.1 HCEM.1
HCHP.1 HCSU.1 ES02.1 ES10.1 HAP3.1 HCRE.1
HCTC.1 HEMD.1 HEMP.1 HEP4.1 HGLN.1 HHSU.1
HLTM.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
HR156 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 HR18.5 HR18.6
HR20.1 HR207 HR211 HR212 HR213 HR217
HR220 HR221 HR30.1 HR40.1 HR40.2 HR506
HR507 HR51.2 HR51.6 HR51.8 HR513 HR515
HR521 HR54.1 HR55.1 HR55.2 HR70.1 HR751
HR79.2 HR90.1 HR90.2 HR93.1 HR93.2 HR93.5
HR93.8 HR93.9 HR94.1 HRBD.1 HRS1.1 HRSC.1
HS08.1 HS10.1 HS10.2 HS17.1 HS19.1 HS19.2
HS208 HS703 HS705 LT01.1 LT11.5 LT11.6
LT13.5 LT13.6 LT213 LT22.5 LT28.1 ZH10.1
ZH12.1 ZH12.2 ZH156 ZH230 ZH500 ZH535
ZH568 EX14.1 EX14.2 EX175 EX542 EX545
EXI3.1 EXLD.1 EXXM.1 HS706 LP100 LP101
LP102 LP103 LP131 LP138 LP140 LP145
LP151 LP180 LP188 LP197 LP198 LP199
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 LP64.3 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 HS702 HS704
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 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 PA258 PA259 PA26.1 PA26.3 PA26.4
PA262 PA263 PA27.1 PA272 PA28.1 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 PA392 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 PA526 PA53.1
PA531 PA532 PA533 PA534 PA535 PA54.1
PA549 PA55.1 PA56.1 PA58.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 PA93.5 PA93.6 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 TR20.4 TR200 TR201 TR202
TR204 TR207 TR21.1 TR210 TR22.1 TR220
TR221 TR222 TR26.1 TR500 ZE526 ZE532
HS18.2 HS20.1 HS21.1 HS22.1 HS22.2 HS22.3
HS34.1 HS35.1 HS36.1 HS535 HS536 PR114
PR115 PR129 PR138 PR139 PR140 PR141
PR142 PR155 PR160 PR162 PR170 PR180
PR188 PR192 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
PR271 PR275 PR276 PR277 PR278 PR279
PR280 PR281 PR282 PR283 PR284 PR285
PR286 PR287 PR289 PR290 PR291 PR292
PR293 PR295 PR297 PR298 PR299 PR313
PR323 PR38.1 PR418 PR50.1 PR50.2 PR50.3
PR50.4 PR51.1 PR52.1 PR55.1 PR597 PR70.1
PR797 PR83.1 PR84.1 PR85.1 PR86.1 PR88.1
PR89.1 PRAT.1 PRSC.1 UK210 UK52.1 ZP10.1
ZP139 ZP296 ZP529 ZP551 ZP552 ZP554
ZP555 ZP557 ZP559 ZP560 ZP562 ZP565
ZP567 ZP580 SN80.2 SN80.3 SNEM.1 SNHC.1
TA148 TA175 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


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 BS10.1 BS12.1 BS13.1 BS14.1
BS15.1 BS32.1 ZB10.1 ZB31.1 ZB31.2 ZB32.1
ZB32.2 ZB32.3 HR11.1 HR11.2 HR11.4 HR12.1
HR14.1 HR28.1 HR511 HR514 HR708 HR709
HR711 LT101 LT111 PR521 ZH510 EXI2.1
EXI4.1 LP130 PA02.1 PA100 PA102 PA115
PA13.1 PA13.2 PA502 PA513 PA52.1 PA52.2
PA52.3 PA52.4 PA52.5 PR11.1 PR11.4 PR110
PR113 PR12.6 PR120 PR127 PR128 PR13.1
PR13.2 PR13.5 PR13.6 PR13.8 PR13.9 PR131
PR132 PR134 PR135 PR136 PR137 PR14.1
PR14.2 PR15.1 PR15.2 PR189 PR205 PR26.1
PR29.1 PR296 PR30.1 PR30.2 PR32.1 PR32.2
PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR35.9 PR36.1
PR36.4 PR37.1 PR39.1 PR39.2 PR45.1 PR47.1
PR512 PR514 PR529 PR530 PR539 PR560
PR582 PR80.1 PR80.3 PR80.4 PR82.1 UK102
UK110 TA147 HR228 HR255 PA213

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMP-COMPANY
Element: Company
Numeric 4
Contains the company number.
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
HS11.1 HS11.2
HS12.1 HS12.2
HS13.1 HS13.2
HS50.1 HS50.2
HS51.1 HS51.2
HS52.1 HS52.2
HS705 LP100
LP101 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
PA262 PA263
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA513 PA52.1
PA52.3 PA52.4
EMP-EMPLOYEE
Element: Employee
Numeric 9
Contains the number assigned to each employee. The employee number is used with the company number to uniquely identify the employee throughout the Lawson Human Capital Management applications.
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
HS11.1 HS11.2
HS12.1 HS12.2
HS13.1 HS13.2
HS50.1 HS50.2
HS51.1 HS51.2
HS52.1 HS52.2
LP100 LP101
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA262
PA263 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
EMP-LAST-NAME
Element: Last Name
Alpha 30 (Lower Case)
Contains the employee's last name.
BN305 HR07.1
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
EMP-FIRST-NAME
Element: First Name
Alpha 15 (Lower Case)
Contains the employee's first name.
BN305 HR07.1
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
EMP-MIDDLE-INIT
Element: Middle Initial
Alpha 1
Contains the employee's middle initial.
BN305 HR07.1
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
EMP-MIDDLE-NAME
Element: Middle Name
Alpha 15 (Lower Case)
Contains the employee's middle name.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-NICK-NAME
Element: Nick Name
Alpha 30 (Lower Case)
Contains the employee's nick name.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-ADDR1
Element: Hr Addr1
Alpha 57 (Lower Case)
Contains the first line of the employee's address.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
Contains the second line of the employee's address.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
Contains the third line of the employee's address.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
Contains the fourth line of the employee's address.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-CITY
Element: Hr City
Alpha 58 (Lower Case)
Contains the city of the employee's address.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-STATE
Element: State
Alpha 2
Contains the state of the employee's address.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-ZIP
Element: Zip
Alpha 10
Contains the postal code of the employee's address.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-EMP-STATUS
Element: Status
Alpha 2
Contains the employee's status, which can be used to determine if this employee is paid.
BN305 HCEM.1
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA272
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH230
ZH510
EMP-FICA-NBR
Element: Social Number
Alpha 20
Contains the employee's Social Security number.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
LT213 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR252 PR290
PR291 PR292
PR297 PR30.2
PR512 ZH510
EMP-EIC-STATUS
Element: EIC Status
Numeric 1
Indicates if the employee's EIC status is Single or Joint.
0 = Not Applicable
1 = Single
2 = Joint
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
Contains the employee's process level.
BN305 HCEM.1
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR33.2
PR33.3 PR512
ZH230 ZH510
EMP-DEPARTMENT
Element: Department
Alpha 5
Contains the employee's department.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH230
ZH510
EMP-USER-LEVEL
Element: User Level
Alpha 10
Contains the employee's user level.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-HM-DIST-CO
Element: Company
Numeric 4
Contains the employee's home general ledger distribution company for expense.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-HM-ACCT-UNIT
Element: Acct Unit
Alpha 15
Contains the employee's home general ledger accounting unit for expense.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-HM-ACCOUNT
Element: Account
Numeric 6
Contains the employee's home general ledger account for expense.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-HM-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the employee's home general ledger subaccount for expense.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-JOB-CODE
Element: Job Code
Alpha 9
Contains the employee's job code.
BN305 HR11.1
HR11.2 HR11.4
HR170 HR28.1
HR511 HR70.1
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-UNION-CODE
Element: Union
Alpha 10
Contains the employee's union code.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-SUPERVISOR
Element: Supervisor
Alpha 10
Contains the supervisor code that identifies the supervisor to whom the employee reports.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-DATE-HIRED
Element: Hire Date
Numeric 8 (yyyymmdd)
Contains the employee's hire date.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-PAY-FREQUENCY
Element: Pay Frequency
Numeric 1
Identifies the employee's pay frequency.
1 = Weekly
2 = Biweekly
3 = Semimonthly
4 = Monthly
5 = UK Four-Weekly
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR32.1 PR32.2
PR33.2 PR33.3
PR512 ZH510
EMP-SHIFT
Element: Shift
Numeric 1
Identifies the shift with which the employee's pay is associated.
1 = Shift 1
2 = Shift 2
3 = Shift 3
4 = Shift 4
5 = Shift 5
6 = Shift 6
7 = Shift 7
8 = Shift 8
9 = Shift 9
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-SALARY-CLASS
Element: Salary Class
Alpha 1
Select whether the rate of pay is hourly or salaried.
H = Hourly
S = Salaried
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-EXEMPT-EMP
Element: Exempt
Alpha 1
Indicates if the employee is exempt from overtime pay.
N = No
Y = Yes
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-PAY-RATE
Element: Pay Rate
Signed 13.4
Contains the employee's rate of pay. This can be an annual amount or an hourly amount. If this is a step and grade employee, this field is zero and the step, grade and schedule must exist. The application uses these fields to retrieve the employee's rate of pay at calculation time.
BN305 HLTM.1
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR33.2
PR33.3 PR512
ZH510
EMP-STAND-HOURS
Element: Stand Hours
Signed 7.2
Contains the number of hours this employee usually works each pay period. If you enter a value in this field, additional edits occur at time entry.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-STAND-AMT
Element: Stand Amt
Signed 11.3
Contains the amount of money the employee usually makes per pay period. If you enter a value in this field, additional edits occur at time entry.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-WARN-FLAG
Element: Warn Flag
Alpha 1
Indicates if a warning displays when the employee exceeds the standard hours or amount for a pay period.
N = No
Y = Yes
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-ADD-ALLOW-PER
Element: Add Allow Per
Signed 7.3
Contains the additional percent (hours or amount) allowed before a warning message displays.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-ADD-ALLOW-HRS
Element: Add Allow Hrs
Signed 7.2
Contains the additional hours allowed before the warning message displays.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-ADD-ALLOW-AMT
Element: Add Allow Amt
Numeric 9
Contains the additional amount of pay allowed before the warning message displays.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-RPT-INS-COST
Element: Reportable Insurance
Signed 11.2
Contains the reportable life insurance cost for W-2 reporting. If you are using the Lawson Benefits system, BN150 (Life Insurance Reportable Income) updates this field.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-AUTO-TIME-REC
Element: Auto Time Rec
Alpha 1
Indicates if an employee is allowed to have generated standard time records.
N = No
S = Standard
T = Time Group
Y = Yes
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-LAST-DED-SEQ
Element: Last Ded Seq
Numeric 4
Contains the last sequence number used when a deduction was created for the employee through the Lawson Benefits system. The Lawson Payroll system does not use this field.
...
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
BS10.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
EXI2.1 EXI4.1
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LP130
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR13.9 PR131
EMP-AUTO-DEPOSIT
Element: Auto Deposit
Alpha 1
Indicates if the employee is set up for automatic payroll deposit.
N = No
P = Partial
Y = Yes
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 PR80.4
ZH510
EMP-ADJ-HIRE-DATE
Element: Adjusted Hire Date
Numeric 8 (yyyymmdd)
Contains the employee's adjusted hire date.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-ANNIVERS-DATE
Element: Annivers Date
Numeric 8 (yyyymmdd)
Contains the employee's anniversary date of employment.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-TERM-DATE
Element: Term Date
Numeric 8 (yyyymmdd)
Contains the date of employment termination.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-LAST-CMT-SEQ
Element: Last Cmt Seq
Numeric 4
Contains the last sequence number used when the last employee comment was created.
EMP-CREATION-DATE
Element: Creation Date
Numeric 8 (yyyymmdd)
Contains the date the employee record was added to the database.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-NBR-FTE
Element: Full Time Equivalent
Signed 7.6
Contains the employee's FTE (Full-time Equivalency) factor which indicates the percent of annual hours the employee works. For example, if the employee works full-time, this field is 1.000. If this field is 0.5000, the employee works half of the hours of a full-time employee.
BN305 BN350
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR195 PR30.2
PR512 PR89.1
TA175 ZH510
EMP-PENSION-PLAN
Element: Pension Plan
Alpha 1
Indicates if the employee is a participant in a retirement plan maintained by the company.
N = No
Y = Yes
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR11.1 PR11.4
PR110 PR113
PR12.6 PR120
PR127 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
EMP-PAY-STEP
Element: Step
Numeric 2
Contains the appropriate step if the employee's pay is based on a step and grade schedule.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-PAY-GRADE
Element: Grade
Alpha 3
Contains the appropriate grade if the employee is paid based on a step and grade schedule or is assigned to a grade range schedule.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-SCHEDULE
Element: Schedule
Alpha 9
Contains the schedule the employee is associated with. There are two types of schedules: step and grade and grade range. The step and grade schedule is a matrix used to determine an employee's rate of pay based on their particular "step" and "grade." If the employee is associated with a step and grade schedule, the application 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.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-EBE-AMOUNT
Element: Business Expense
Signed 9.2
Contains the employee business expense amount for W-2 purposes.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-SICK-PAY
Element: Sick Pay
Signed 11.2
Contains the employee's non-taxable sick pay reportable on the W-2 form.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-OT-PLAN-CODE
Element: Ot Plan Code
Alpha 4
Contains the pay plan with which the employee is associated.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-DECEASED
Element: Deceased
Alpha 1
Indicates if the employee is deceased.
Y = Yes
N = No
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR11.1 PR11.4
PR110 PR113
PR12.6 PR120
PR127 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
EMP-BSI-GROUP
Element: Bsi Group
Alpha 11
Contains the employee's BSI group code. A BSI group code is a code defined in BSI to provide an override tax formula for specific employees.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-WORK-STATE
Element: Work State
Alpha 2
Contains the employee's work state abbreviation.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-TAX-STATE
Element: Tax State
Alpha 2
Contains the employee's state taxing authority for income tax purposes.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-TAX-PROVINCE
Element: Province
Alpha 2
Contains the tax province of the employee that is used for Canada Payroll.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-WC-STATE
Element: Wc State
Alpha 2
Contains the employee's work state abbreviation that is used for computing workers' compensation premiums.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-TAX-COUNTY
Element: Tax County
Alpha 10
Contains the county taxing authority for income tax purposes.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-TAX-CITY
Element: Tax City
Alpha 10
Contains the city taxing authority for income tax purposes.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-MOVING-EXP
Element: Moving Exp
Signed 11.2
Contains the employee's qualified moving expenses that are reportable on the W-2 form.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-ALT-RATE-EXIST
Element: Alt Rate Exist
Alpha 1
Indicates whether the employee has alternates pay rates defined for different job codes. Y = Yes Blank = No
BN305 HR11.1
HR11.2 HR11.4
HR14.1 HR28.1
HR511 HR514
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-PEND-ACT-DATE
Element: Pend Act Date
Numeric 8 (yyyymmdd)
Contains the date an action will take effect.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.2
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
UK110 ZH510
EMP-PIN
Element: Pin
Alpha 10 (Lower Case)
Contains the employee Personal Identification Number.
EMP-TIPPED
Element: Tipped
Alpha 1
Contains a value that indicates whether the employee is a tipped employee. This field determines whether the system verifies minimum wage and whether to perform the tip credit calculation.
C = Tipped Employee - Tip Credit
N = Not a Tipped Employee
T = Tipped Employee -No Tip Credit
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-EMAIL-ADDRESS
Element: Email Address
Alpha 60 (Lower Case)
Contains the employee's E-mail address.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH500
ZH510
EMP-ACTIVITY
Element: Activity
Alpha 15
Contains the activity. Activities are the tasks that make up an activity group. Activities identify work being done, such as work orders, phases, products, and so on. A variety of costs, revenues, or both make up an activity. The Activity Management system stores information such as responsibility and schedule for each activity. The breakdown of activity costs and revenues is defined by account categories. An activity must belong to an activity group.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-ACCT-CATEGORY
Element: Acct Category
Alpha 5
Contains the account category. Account categories are the Activity Management accounts by which activity transactions are grouped for budgeting and reporting. Set up account categories for an activity before you do any budgeting or transaction processing. Using account categories, you can sort and combine incoming amounts into groups for reporting and inquiry on activities.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-MAX-LIMIT-OVRD
Element: Max Limit Ovrd
Alpha 1
Indicates the default for the maximum compensation limit from Benefit Plan file has been overriden for this employee.
Y = Yes
N = No
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-SEC-LVL
Element: Sec Lvl
Numeric 1
Contains the employee's security level.
BN305 HR11.1
HR11.2 HR11.4
HR12.1 HR28.1
HR511 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
EMP-SEC-LOCATION
Element: Sec Location
Alpha 10
Contains the employee's security location.
BN305 HR11.1
HR11.2 HR11.4
HR12.1 HR28.1
HR511 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
EMP-POSITION
Element: Position
Alpha 12
Contains the user-defined code that represents a position in the company.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-WORK-SCHED
Element: Work Sched
Alpha 10
Contains the employee's work schedule.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-SUPERVISOR-IND
Element: Supervisor Ind
Alpha 10
Contains the employee's indirect supervisor.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-ANNUAL-HOURS
Element: Annual Hours
Signed 8.4
Contains the employee's annual hours.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-WORK-COUNTY
Element: Work County
Alpha 10
Contains the employee's work county.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-WORK-CITY
Element: Work City
Alpha 10
Contains the employee's work city.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-WORK-SCHOOL
Element: Work School
Alpha 10
Contains the employee's work school.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-WORK-TRANSPORT
Element: Work Transport
Alpha 10
Contains the employees work transportation.
EMP-TAX-SCHOOL
Element: Tax School
Alpha 10
Contains the employee's school tax authority.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-TAX-TRANSPORT
Element: Tax Transport
Alpha 10
Contains the employee's tax transportation authority.
EMP-FTE-TOTAL
Element: Fte Total
Signed 11.6
Contains the employee's total FTE. The total FTE is the sum of the FTEs for all of the employee's (Level 1 through 5) positions or jobs.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-PRO-RATE-TOTAL
Element: Pay Rate
Signed 13.4
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-PRO-RATE-A-SAL
Element: Pay Rate
Signed 13.4
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-NEW-HIRE-DATE
Element: New Hire Date
Numeric 8 (yyyymmdd)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR296
PR30.2 PR512
ZH510
EMP-COMPA-RATIO
Element: Compa Ratio
Derived
EMP-PENET-RATIO
Element: Penet Ratio
Derived
EMP-SAL-MTH-RATE
Element: Sal Mth Rate
Derived
EMP-HOUR-MTH-RATE
Element: Hour Mth Rate
Derived
EMP-MONTHLY-RATE
Element: Monthly Rate
Derived
EMP-SAL-BIWK-RATE
Element: Sal Biwk Rate
Derived
EMP-HRY-BIWK-RATE
Element: Hry Biwk Rate
Derived
EMP-SAL-SEMI-RATE
Element: Sal Semi Rate
Derived
EMP-HRY-SEMI-RATE
Element: Hry Semi Rate
Derived
EMP-SAL-WKLY-RATE
Element: Sal Wkly Rate
Derived
EMP-HRY-WKLY-RATE
Element: Hry Wkly Rate
Derived
EMP-WEEKLY-RATE
Element: Weekly Rate
Derived
EMP-BIWEEKLY-RATE
Element: Biweekly Rate
Derived
EMP-SEMIMNTH-RATE
Element: Semimnth Rate
Derived
EMP-EMP-ANN-HRS
Element: Emp Annual Hrs
Derived
EMP-CURRENCY-CODE
Element: Currency Code
Alpha 5
Contains the pay currency.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-COUNTRY-CODE
Element: Country Code
Alpha 2
Contains the country of the employee's home address.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-NAME-PREFIX
Element: Name Prefix
Alpha 4 (Lower Case)
Contains the prefix (title) of the employee's name.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-NAME-SUFFIX
Element: Name Suffix
Alpha 4 (Lower Case)
Contains the suffix of the employee's name.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-WORK-COUNTRY
Element: Country Code
Alpha 2
Contains the employee's work country.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-LAST-NAME-PRE
Element: Last Name Pre
Alpha 30 (Lower Case)
Contains the employee's previous last name.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-EST-REMUN
Element: Est Remun
Signed 11.2
Used for taxing Canada Commission Payments.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-EST-EXPENSE
Element: Est Expense
Signed 11.2
Used for taxing Canada Commission Payments.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-BUS-NBR-GRP
Element: Bus Nbr Grp
Alpha 4
Contains the business number group.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-QC-ENT-NBR-GRP
Element: Qc Ent Nbr Grp
Alpha 4
Contains the Quebec enterprise number group.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-LAST-PRE
Element: Last Pre
Derived
EMP-LAST-SUF
Element: Last Suf
Derived
EMP-LAST-PRE-SUF
Element: Last Pre Suf
Derived
EMP-FIRST-MI
Element: First Mi
Derived
EMP-LAST-NAME-EXP
Element: Last Name Exp
Derived
EMP-FIRST-MI-EXP
Element: First Mi Exp
Derived
EMP-FULL-NAME
Element: Full Name
Derived
EMP-SHORT-NAME
Element: Short Name
Derived
Contains the employee's short name.
EMP-LABEL-NAME-1
Element: Label Name 1
Derived
EMP-WC-PROVINCE
Element: Wc Province
Alpha 2
Contains the employees province for Canadian Workers Compensation.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-RAILROAD-CODE
Element: Railroad Code
Numeric 1

0 = Not Railroad Employee
1 = Tier One Employee
2 = Tier Two Employee
3 = Both Tier 1 and Tier 2
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-FST-DAY-WORKED
Element: Fst Day Worked
Numeric 8 (yyyymmdd)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-LAST-DAY-PAID
Element: Last Day Paid
Numeric 8 (yyyymmdd)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-LAB-DIST-FLAG
Element: Lab Dist Flag
Alpha 1

" " = Not Applicable
Y = Yes
N = No
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-ENCUMBER-FLAG
Element: Encumber Flag
Alpha 1

" " = Not Applicable
Y = Yes
N = No
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-EFFORT-FLAG
Element: Effort Flag
Alpha 1
Flag to indicate whether this activity is subject to effort reporting, and if it is, whether it prints in the sponsored or non-sponsored section of the report for effort reporting.
" " = Not Applicable
Y = Yes
N = No
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-RPT-CURR
Element: Rpt Curr
Alpha 5
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-PRMCERT-ID
Element: Employee
Numeric 9
Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-SNDCERT-ID
Element: Employee
Numeric 9
Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-FRNG-RATE
Element: Frng Rate
Signed 12.6
A default fringe rate that can be sued by the GM110 program to create commitments for fringe amounts. There is a parameter choice on the GM110 program that allows the user to default the fringe rate, post-to account and account category information from the activity or the employee.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-FRNG-ACCT-CAT
Element: Acct Category
Alpha 5
Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account 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
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-FRNG-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-FRNG-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-DEATH-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-TAX-FILTER
Element: Tax Filter
Numeric 1

1 = Locate All
2 = Locate Federal & State Only
3 = Locate Federal Only
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-REMOTE
Element: Remote
Numeric 1

0 = Not Remote
1 = Remote
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-PUB-SEC-RETIRE
Element: Pub Sec Retire
Numeric 4

0000 = Not a Member
0001 = Member; Use Hire Date
0002 = Member; Use Adj Hire Date
0003 = Member; State Specific
0004 = Suppress Soc Sec EE and ER
0005 = Suppress Medicare EE and ER
0006 = Suppress SS/Med EE and ER
0007 = Member; PERA - Tax Def
0008 = Member; SS Tax Def
0009 = Member; Med Tax Def
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-PRMCERT-COMP
Element: Company Hr
Numeric 4
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
HR708 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
EMP-SNDCERT-COMP
Element: Company Hr
Numeric 4
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
HR708 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
EMP-ST-STATUS
Element: St Status
Numeric 1
EMP-LAST-NAME-UC
Element: Last Name Uc
Alpha 30
Employees last name in upper case for efficiency in select by name
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
HR709 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
EMP-FIRST-NAME-UC
Element: First Name Uc
Alpha 15
Employees first name in upper case for efficiency in select by name
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
HR709 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
EMP-FICA-NBR-LAST4
Element: Fica Nbr Last4
Alpha 4
This field contains the last four digits of the employee's Fica Nbr. This allows clients to secure the regular Fica Nbr field and leave this field open for inclusion on payroll and other reports.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
HR711 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
EMP-EMAIL-PERSONAL
Element: Email Address
Alpha 60 (Lower Case)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EMP-UPDATED-BY-LTM
Element: Updated By Ltm
Alpha 1

Y = Yes
N = No
EMP-HICN
Element: Hl Claim Nbr
Alpha 11
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510


EMPLOYEE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMPSET1 COMPANY
EMPLOYEE
...
AC03.3 AC03.7
AC145 AC17.3
AC18.2 AC190
AC191 AC197
AC203 AC210
AC217 AC218
AC297 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
EMPSET2 COMPANY
PROCESS-LEVEL
DEPARTMENT
EMPLOYEE
KeyChange
BN242 BN320
HEP3.1 HR105
HR12.1 HR170
HR228 HR70.1
HS705 PA105
PA149 PA213
PA340 TR222
PR113 PR134
PR136 PR205
PR212 PR214
PR226 PR229
PR247 PR33.2
PR38.1 PR39.2
EMPSET3 COMPANY
EMP-STATUS
EMPLOYEE
KeyChange
HR03.1
EMPSET4 COMPANY
FICA-NBR
EMPLOYEE
KeyChange
...
BN305 HEP4.1
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LT101
LT111 ZH230
ZH510 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
EMPSET6 COMPANY
LAST-NAME-UC
FIRST-NAME-UC
MIDDLE-INIT
EMPLOYEE
KeyChange
HEP2.1 HR212
HR255 HS10.1
HS10.2 PA311
PA370 PR33.3
EMPSET7 COMPANY
PROCESS-LEVEL
EMPLOYEE
KeyChange
...
BN100 BN101
BN102 BN103
BN150 BN242
BN245 BN260
BN331 BS531
ZS531 HC01.2
HCDL.1 HCEM.1
HR00.2 HR00.3
HR170 HR217
HR220 HR70.1
HS703 HS706
LP100 LP102
LP103 LP131
LP151 LP180
LP199 LP231


EMPLOYEE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Empaltname EMPALTNAME Not Required
EMP-COMPANY->EAN-COMPANY
EMP-EMPLOYEE->EAN-EMPLOYEE
Empbod EMPBOD Not Required, Delete Cascades
EMP-COMPANY->EMB-COMPANY
EMP-EMPLOYEE->EMB-EMPLOYEE
Home Account GLMASTER Required
When EMP-HM-ACCT-UNIT !=Spaces
OrEMP-HM-ACCOUNT !=Zeroes
OrEMP-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
NAME
RELATED 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
  PAC-DATE
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
Cwchange CWCHANGE Delete Cascades
EMP-COMPANY->CCH-COMPANY
EMP-EMPLOYEE->CCH-EMPLOYEE
  CCH-POSITION
  CCH-WORK-SCHED
  CCH-EFFECT-DATE
  CCH-CHANGE-TYPE
Deduction EMDEDMASTR Delete Restricted
EMP-COMPANY->EDM-COMPANY
EMP-EMPLOYEE->EDM-EMPLOYEE
  EDM-DED-CODE
  EDM-EFFECT-DATE
  EDM-SEQ-NBR
Dependent EMDEPEND Delete Cascades
EMP-COMPANY->EMD-COMPANY
EMP-EMPLOYEE->EMD-EMPLOYEE
  EMD-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 Assignment CWASSIGN
EMP-COMPANY->CWA-COMPANY
EMP-EMPLOYEE->CWA-EMPLOYEE
  CWA-CONTRACT-YEAR
  CWA-POSITION
  CWA-ASG-EFFECT-DTE
  CWA-PCD-SEQ-NBR
Emp Cmchange CMCHANGE Delete Cascades
EMP-COMPANY->CHG-COMPANY
EMP-EMPLOYEE->CHG-EMPLOYEE
  CHG-POS-LEVEL
  CHG-EFFECT-DATE
  CHG-CHANGE-TYPE
  CHG-WORK-SCHED
  CHG-CONTRACT-YEAR
  CHG-CONTRACT-NBR
Emp Cmcontract CMCONTRACT
EMP-COMPANY->CNR-COMPANY
EMP-EMPLOYEE->CNR-EMPLOYEE
  CNR-CONTRACT-NBR
Emp Contract CWCONTRACT
EMP-COMPANY->CCT-COMPANY
EMP-EMPLOYEE->CCT-EMPLOYEE
  CCT-CONTRACT-YEAR
  CCT-POSITION
  CCT-CONT-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
Open Payments PAYMASTR
EMP-COMPANY->PYM-COMPANY
EMP-PROCESS-LEVEL->PYM-PROCESS-LEVEL
EMP-EMPLOYEE->PYM-EMPLOYEE
  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
AndEMP-PAY-STEP !=Zeroes
AndEMP-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-CONTRACT-YEAR
  WSC-EFFECT-DATE


File created: Thu Jun 09 02:16:07 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.