Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMPLOYEE


                             EMPLOYEE FILE

                                Employee

Contains all employee information needed in the Lawson Payroll system. The
Employee PA Information file stores additional employee information used by
the Lawson Human Resource, Personnel, and Benefits systems. HR11.1 (Employee)
is the primary program that updates this file.

REFERENCED BY

AC03.3    AC03.7    AC145     AC17.3    AC18.2    AC190
AC191     AC197     AC203     AC210     AC217     AC218
AC41.1    AC41.4    AC42.1    AC46.1    AC50.1    AC500
AC52.1    AC520     AC54.1    AC540     AC62.1    AC92.2
AC92.4    AC92.6    ACAC.1    BN106     BN134     BN137
BN138     BN140     BN141     BN175     BN180     BN181
BN230     BN231     BN232     BN233     BN234     BN236
BN237     BN238     BN240     BN242     BN246     BN247
BN248     BN258     BN259     BN281     BN285     BN30.1
BN300     BN305     BN310     BN320     BN321     BN325
BN33.1    BN33.2    BN33.3    BN33.4    BN330     BN331
BN335     BN340     BN345     BN35.1    BN350     BN36.1
BN430     BN46.1    BN46.2    BN47.1    BN48.1    BN48.2
BN480     BN50.1    BN51.1    BN51.2    BN53.1    BN532
BN533     BN534     BN547     BN55.1    BN55.2    BN555
BN56.1    BN57.1    BN59.1    BN60.1    BN61.1    BN70.1
BN70.2    BN77.1    BN80.1    BN81.1    BN81.2    BN82.1
BN85.1    BN90.1    BS09.1    BS10.1    BS11.1    BS12.1
BS30.1    BS31.1    BS531     BR40.3    BR43.1    BR46.1
HC01.2    HCDL.1    HCEM.1    HCHP.1    HCSU.1    ES02.1
ES10.1    HAP3.1    HCTC.1    HEMD.1    HEMP.1    HEP4.1
HGLN.1    HHSU.1    HOSH.1    HPAE.1    HPOS.1    HPQC.1
HPRS.1    HR00.1    HR00.2    HR01.1    HR02.1    HR04.2
HR04.3    HR04.7    HR04.8    HR06.1    HR07.1    HR105
HR125     HR13.1    HR15.1    HR155     HR16.2    HR16.3
HR16.4    HR16.5    HR16.6    HR16.7    HR16.8    HR17.1
HR17.2    HR17.3    HR17.4    HR17.5    HR17.6    HR17.7
HR17.8    HR17.9    HR170     HR18.1    HR18.2    HR18.3
HR18.4    HR20.1    HR207     HR211     HR212     HR213
HR217     HR220     HR221     HR255     HR30.1    HR506
HR507     HR513     HR515     HR521     HR54.1    HR55.1
HR55.2    HR70.1    HR79.2    HR80.1    HR80.2    HR80.3
HR80.4    HR80.5    HR80.6    HR80.7    HR80.8    HR80.9
HR81.1    HR81.2    HR81.3    HR81.4    HR81.5    HR81.6
HR81.7    HR81.8    HR81.9    HR82.1    HR82.2    HR82.3
HR82.4    HR82.5    HR82.6    HR82.7    HR82.8    HR82.9
HR83.1    HR83.2    HR83.3    HR83.4    HR83.5    HR83.6
HR83.7    HR83.8    HR83.9    HR84.1    HR84.2    HR84.3
HR84.4    HR84.5    HR84.6    HR84.7    HR84.8    HR84.9
HR85.1    HR85.2    HR85.3    HR85.4    HR85.5    HR85.6
HR85.7    HR85.8    HR86.1    HR86.2    HR86.3    HR86.4
HR86.5    HR86.6    HR86.7    HR86.8    HR86.9    HR87.1
HR87.2    HR87.3    HR87.4    HR87.5    HR87.6    HR87.7
HR87.8    HR87.9    HR88.1    HR88.2    HR88.3    HR88.4
HR88.5    HR88.6    HR88.7    HR89.1    HR89.2    HR89.3
HR89.4    HR89.5    HR89.6    HR89.7    HR89.8    HR89.9
HR90.1    HR90.2    HRS1.1    HRSC.1    HS10.1    HS10.2
HS11.1    HS12.1    HS13.1    HS14.1    HS15.1    HS50.1
HS50.2    HS50.3    HS50.4    HS50.5    HS51.1    HS51.2
HS52.1    HS52.2    PA03.2    PA03.3    PA09.1    PA10.1
PA105     PA111     PA113     PA12.1    PA125     PA130
PA14.1    PA149     PA15.1    PA15.2    PA16.1    PA17.1
PA18.1    PA182     PA19.1    PA20.1    PA201     PA208
PA21.1    PA210     PA211     PA212     PA213     PA214
PA215     PA216     PA217     PA218     PA219     PA22.1
PA220     PA221     PA222     PA223     PA224     PA225
PA227     PA23.1    PA24.1    PA241     PA242     PA243
PA244     PA248     PA249     PA25.1    PA259     PA26.1
PA262     PA263     PA27.1    PA272     PA290     PA295
PA296     PA31.1    PA310     PA311     PA313     PA315
PA320     PA325     PA33.1    PA330     PA335     PA34.1
PA340     PA341     PA345     PA349     PA35.1    PA350
PA355     PA36.1    PA360     PA370     PA372     PA38.1
PA390     PA391     PA393     PA402     PA406     PA41.1
PA42.1    PA42.3    PA43.1    PA44.1    PA45.1    PA49.1
PA49.2    PA49.3    PA490     PA495     PA496     PA50.1
PA512     PA520     PA53.1    PA531     PA532     PA533
PA534     PA535     PA54.1    PA549     PA55.1    PA59.1
PA59.2    PA590     PA594     PA62.1    PA63.1    PA64.1
PA64.2    PA65.1    PA65.2    PA66.1    PA66.2    PA66.3
PA66.4    PA67.1    PA81.1    PA81.2    PA90.1    PA90.2
PA90.3    PA91.1    PA93.2    PA96.1    TR07.1    TR08.1
TR09.1    TR114     TR12.1    TR120     TR121     TR13.1
TR13.2    TR14.1    TR15.1    TR20.1    TR20.2    TR20.3
TR200     TR201     TR202     TR204     TR207     TR21.1
TR210     TR22.1    TR220     TR221     TR222     TR26.1
TR500     PBIP.1    HS20.1    HS21.1    HS22.1    HS22.2
HS22.3    HS34.1    HS35.1    HS36.1    HS535     PR114
PR12.1    PR12.2    PR12.3    PR12.5    PR127     PR135
PR137     PR141     PR142     PR155     PR160     PR162
PR180     PR188     PR197     PR198     PR212     PR214
PR216     PR223     PR226     PR229     PR23.1    PR230
PR239     PR240     PR241     PR242     PR243     PR244
PR245     PR247     PR248     PR250     PR251     PR252
PR253     PR260     PR265     PR270     PR275     PR276
PR277     PR278     PR280     PR281     PR282     PR283
PR284     PR285     PR286     PR289     PR290     PR291
PR292     PR293     PR295     PR297     PR298     PR299
PR313     PR37.1    PR38.1    PR418     PR50.1    PR50.2
PR50.3    PR50.4    PR51.1    PR51.3    PR512     PR52.1
PR55.1    PR70.1    PR83.1    PR84.1    PR85.1    PR86.1
PR88.1    PRSA.1    PRSC.1    PRWC.1    UK141     UK145
UK183     UK184     UK201     UK202     UK210     UK277
UK330     UK34.1    UK50.1    UK50.2    UK50.3    UK50.4
UK50.5    UK52.1    TA125     TA145     TA146     TA148
TA170     TA175     TA180     TA181     TA196     TA198
TA241     TA242     TA260     TA265     TA270     TA290
TA310     TA341     TA42.1    TA50.1    TA542     TA570
TA60.1    TA65.1    TA65.2    TA65.3    TA70.1    TA70.2
TA80.1    TA81.1    TM240     TM245     TM250     TM255
TM260     TM265     TM300     TM470     TM50.1    TM52.1
TM570     TM60.1    TM61.1    TM70.1    TM71.1    TP100
TP120     TP125     TP130     TP140     TP20.1    TP20.2
TP210     TP220     TP30.1    TP30.2    TP40.2    TP40.3
HRLRD     HEP3.1    HR03.1    HEP2.1    TA195     TA199

UPDATED BY

BN100     BN101     BN102     BN103     BN104     BN105
BN145     BN150     BN245     BN31.1    BN31.2    BN32.1
BN32.2    BN32.3    BN45.1    BN531     BN65.1    BN71.1
BN72.1    BS13.1    BS14.1    BS15.1    BS32.1    HR11.1
HR11.2    HR12.1    HR14.1    HR511     HR514     PA02.1
PA100     PA102     PA115     PA13.1    PA13.2    PA502
PA513     PA52.1    PA52.2    PA52.3    PA52.4    PA52.5
PR11.1    PR110     PR113     PR120     PR128     PR13.1
PR13.2    PR13.5    PR13.6    PR13.8    PR130     PR131
PR132     PR134     PR136     PR14.1    PR15.1    PR15.2
PR205     PR26.1    PR29.1    PR296     PR30.1    PR32.2
PR33.2    PR33.3    PR35.1    PR35.2    PR35.3    PR35.4
PR35.5    PR35.6    PR35.8    PR35.9    PR36.1    PR39.1
PR39.2    PR45.1    PR47.1    PR529     PR530     PR560
PR82.1    UK102     UK110     UK47.1    TA147     TP135

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

EMP-COMPANY            Numeric 4                                 HR11.1  HR11.2
Element: Company       Contains the company number.              HR511   HS50.1
                                                                 HS50.2  HS51.1
                                                                 HS51.2  HS52.1
                                                                 HS52.2  PA02.1
                                                                 PA100   PA102
                                                                 PA262   PA263
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA62.1
                                                                 PA63.1  PA64.1
                                                                 PA64.2  PA65.1
                                                                 PA65.2  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 PR33.2  PR33.3
                                                                 TR120   TR121
                                                                 TR20.1  TR20.2
                                                                 TR20.3  TR21.1
                                                                 TR22.1  TR26.1
                                                                 TR500

EMP-EMPLOYEE           Numeric 9                                 HR11.1  HR11.2
Element: Employee      Contains the number assigned to each      HR511   HS50.1
                       employee. The employee number is used     HS50.2  HS51.1
                       with the company number to uniquely       HS51.2  HS52.1
                       identify the employee throughout the      HS52.2  PA02.1
                       Lawson Human Resources systems.           PA100   PA102
                                                                 PA262   PA263
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA62.1
                                                                 PA63.1  PA64.1
                                                                 PA64.2  PA65.1
                                                                 PA65.2  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 PR33.2  PR33.3
                                                                 TR120   TR121
                                                                 TR20.1  TR20.2
                                                                 TR20.3  TR21.1
                                                                 TR22.1  TR26.1
                                                                 TR500

EMP-LAST-NAME          Alpha 30  (Lower Case)                    HR07.1  HR11.1
Element: Last Name     Contains the employee's last name.        HR11.2  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-FIRST-NAME         Alpha 15  (Lower Case)                    HR07.1  HR11.1
Element: First Name    Contains the employee's first name.       HR11.2  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-MIDDLE-INIT        Alpha 1                                   HR07.1  HR11.1
Element: Middle InitialContains the employee's middle initial.   HR11.2  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-MIDDLE-NAME        Alpha 15  (Lower Case)                    HR11.1  HR11.2
Element: Middle Name   Contains the employee's middle name.      HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-NICK-NAME          Alpha 30  (Lower Case)                    HR11.1  HR11.2
Element: Nick Name     Contains the employee's nick name.        HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-ADDR1              Alpha 30  (Lower Case)                    HR11.1  HR11.2
Element: Address 1     Contains the first line of the            HR511   PA02.1
                       employee's address.                       PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-ADDR2              Alpha 30  (Lower Case)                    HR11.1  HR11.2
Element: Address 1     Contains the second line of the           HR511   PA02.1
                       employee's address.                       PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-ADDR3              Alpha 30  (Lower Case)                    HR11.1  HR11.2
Element: Address 1     Contains the third line of the            HR511   PA02.1
                       employee's address.                       PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-ADDR4              Alpha 30  (Lower Case)                    HR11.1  HR11.2
Element: Address 1     Contains the fourth line of the           HR511   PA02.1
                       employee's address.                       PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-CITY               Alpha 18  (Lower Case)                    HR11.1  HR11.2
Element: City          Contains the city of the employee's       HR511   PA02.1
                       address.                                  PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-STATE              Alpha 2                                   HR11.1  HR11.2
Element: State or ProviContains the state of the employee's      HR511   PA02.1
                       address.                                  PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-ZIP                Alpha 10                                  HR11.1  HR11.2
Element: Postal Code   Contains the postal code of the           HR511   PA02.1
                       employee's address.                       PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-EMP-STATUS         Alpha 2                                   HCEM.1  HR11.1
Element: Status        Contains the employee's status, which     HR11.2  HR511
                       can be used to determine if this          PA02.1  PA100
                       employee is paid.                         PA102   PA272
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-FICA-NBR           Alpha 20                                  HR11.1  HR11.2
Element: Social Number Contains the employee's Social Security   HR511   PA02.1
                       number.                                   PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 PR252   PR290
                                                                 PR291   PR292
                                                                 PR297

EMP-EIC-STATUS         Numeric 1                                 HR11.1  HR11.2
Element: EIC Status    Indicates if the employee's EIC status    HR511   PA02.1
                       is Single or Joint.                       PA100   PA102
                       0 = Not Applicable                        PA502   PA52.1
                       1 = Single                                PA52.3  PA52.4
                       2 = Joint                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-PROCESS-LEVEL      Alpha 5                                   HCEM.1  HR11.1
Element: Process Lev HrContains the employee's process level.    HR11.2  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-DEPARTMENT         Alpha 5                                   HR11.1  HR11.2
Element: Department    Contains the employee's department.       HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-USER-LEVEL         Alpha 10                                  HR11.1  HR11.2
Element: User Level    Contains the employee's user level.       HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-HM-DIST-CO         Numeric 4                                 HR11.1  HR11.2
Element: Company       Contains the employee's home general      HR511   PA02.1
                       ledger distribution company for expense.  PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-HM-ACCT-UNIT       Alpha 15                                  HR11.1  HR11.2
Element: Accounting UniContains the employee's home general      HR511   PA02.1
                       ledger accounting unit for expense.       PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-HM-ACCOUNT         Numeric 6                                 HR11.1  HR11.2
Element: Account       Contains the employee's home general      HR511   PA02.1
                       ledger account for expense.               PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-HM-SUB-ACCT        Numeric 4                                 HR11.1  HR11.2
Element: Subaccount    Contains the employee's home general      HR511   PA02.1
                       ledger subaccount for expense.            PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-JOB-CODE           Alpha 9                                   HR11.1  HR11.2
Element: Job Code      Contains the employee's job code.         HR170   HR511
                                                                 HR70.1  PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-UNION-CODE         Alpha 10                                  HR11.1  HR11.2
Element: Union         Contains the employee's union code.       HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-SUPERVISOR         Alpha 10                                  HR11.1  HR11.2
Element: Supervisor    Contains the supervisor code that         HR511   PA02.1
                       identifies the supervisor to whom the     PA100   PA102
                       employee reports.                         PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-DATE-HIRED         Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Hire Date     Contains the employee's hire date.        HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-PAY-FREQUENCY      Numeric 1                                 HR11.1  HR11.2
Element: Pay Frequency Identifies the employee's pay frequency.  HR511   PA02.1
                       1 = Weekly                                PA100   PA102
                       2 = Biweekly                              PA502   PA52.1
                       3 = Semimonthly                           PA52.3  PA52.4
                       4 = Monthly                               PA52.5  PR110
                       5 = UK Four-Weekly                        PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 PR32.1  PR32.2
                                                                 PR33.2  PR33.3

EMP-SHIFT              Numeric 1                                 HR11.1  HR11.2
Element: Shift         Identifies the shift with which the       HR511   PA02.1
                       employee's pay is associated.             PA100   PA102
                       1 = Shift 1                               PA13.1  PA13.2
                       2 = Shift 2                               PA502   PA513
                       3 = Shift 3                               PA52.1  PA52.3
                       4 = Shift 4                               PA52.4  PA52.5
                       5 = Shift 5                               PR110   PR113
                       6 = Shift 6                               PR120   PR13.1
                       7 = Shift 7                               PR13.5  PR13.6
                       8 = Shift 8                               PR13.8
                       9 = Shift 9

EMP-SALARY-CLASS       Alpha 1                                   HR11.1  HR11.2
Element: Salary Class  Indicates if the rate of pay is hourly    HR511   PA02.1
                       or salaried.                              PA100   PA102
                       H = Hourly                                PA502   PA52.1
                       S = Salaried                              PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-EXEMPT-EMP         Alpha 1                                   HR11.1  HR11.2
Element: Exempt        Indicates if the employee is exempt       HR511   PA02.1
                       from overtime pay.                        PA100   PA102
                       N = No                                    PA502   PA52.1
                       Y = Yes                                   PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-PAY-RATE           Signed 13.4                               HR11.1  HR11.2
Element: Rate of Pay   Contains the employee's rate of pay.      HR511   PA02.1
                       This can be an annual amount or an        PA100   PA102
                       hourly amount. If this is a step and      PA13.1  PA13.2
                       grade employee, this field is zero and    PA502   PA513
                       the step, grade and schedule must exist.  PA52.1  PA52.3
                       The system uses these fields to retrieve  PA52.4  PA52.5
                       the employee's rate of pay at             PR110   PR113
                       calculation time.                         PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PR33.2
                                                                 PR33.3

EMP-STAND-HOURS        Signed 7.2                                HR11.1  HR11.2
Element: Standard HoursContains the number of hours this         HR511   PA02.1
                       employee usually works each pay period.   PA100   PA102
                       If you enter a value in this field,       PA502   PA52.1
                       additional edits occur at time entry.     PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-STAND-AMT          Signed 11.3                               HR11.1  HR11.2
Element: Standard AmounContains the amount of money the          HR511   PA02.1
                       employee usually makes per pay period.    PA100   PA102
                       If you enter a value in this field,       PA502   PA52.1
                       additional edits occur at time entry.     PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-WARN-FLAG          Alpha 1                                   HR11.1  HR11.2
Element: Warning MessagIndicates if a warning displays when      HR511   PA02.1
                       the employee exceeds the standard hours   PA100   PA102
                       or amount for a pay period.               PA502   PA52.1
                       N = No                                    PA52.3  PA52.4
                       Y = Yes                                   PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-ADD-ALLOW-PER      Signed 7.3                                HR11.1  HR11.2
Element: Allowance PercContains the additional percent (hours    HR511   PA02.1
                       or amount) allowed before a warning       PA100   PA102
                       message displays.                         PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-ADD-ALLOW-HRS      Signed 7.2                                HR11.1  HR11.2
Element: Allowance HourContains the additional hours allowed     HR511   PA02.1
                       before the warning message displays.      PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-ADD-ALLOW-AMT      Numeric 9                                 HR11.1  HR11.2
Element: Allowance AmouContains the additional amount of pay     HR511   PA02.1
                       allowed before the warning message        PA100   PA102
                       displays.                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-RPT-INS-COST       Signed 11.2                               HR11.1  HR11.2
Element: Reportable InsContains the reportable life insurance    HR511   PA02.1
                       cost for W-2 reporting. If you are using  PA100   PA102
                       the Lawson Benefits system, BN150 (Life   PA502   PA52.1
                       Insurance Reportable Income) updates      PA52.3  PA52.4
                       this field.                               PA52.5  PR11.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-AUTO-TIME-REC      Alpha 1                                   HR11.1  HR11.2
Automatic Time         Indicates if an employee is allowed to    HR511   PA02.1
Record                 have generated standard time records.     PA100   PA102
                       N = No                                    PA502   PA52.1
                       S = Standard                              PA52.3  PA52.4
                       T = Time Group                            PA52.5  PR110
                       Y = Yes                                   PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-LAST-DED-SEQ       Numeric 4                                 BN100   BN101
Last Deduction         Contains the last sequence number used    BN102   BN103
Sequence Nbr           when a deduction was created for the      BN104   BN105
                       employee through the Lawson Benefits      BN145   BN150
                       system. The Lawson Payroll system does    BN245   BN31.1
                       not use this field.                       BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN45.1  BN531
                                                                 BN65.1  BN71.1
                                                                 BN72.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  HR11.1
                                                                 HR11.2  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR128   PR13.1
                                                                 PR13.2  PR13.5
                                                                 PR13.6  PR13.8
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR14.1
                                                                 PR15.1  PR15.2
                                                                 PR205   PR26.1
                                                                 PR29.1  PR32.2
                                                                 PR33.2  PR33.3
                                                                 ...

EMP-AUTO-DEPOSIT       Alpha 1                                   HR11.1  HR11.2
Element: Automatic DepoIndicates if the employee is set up for   HR511   PA02.1
                       automatic payroll deposit.                PA100   PA102
                       N = No                                    PA502   PA52.1
                       P = Partial                               PA52.3  PA52.4
                       Y = Yes                                   PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-ADJ-HIRE-DATE      Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Adjusted Hire Contains the employee's adjusted hire     HR511   PA02.1
                       date.                                     PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-ANNIVERS-DATE      Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Anniversary DaContains the employee's anniversary       HR511   PA02.1
                       date of employment.                       PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-TERM-DATE          Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Termination DaContains the date of employment           HR511   PA02.1
                       termination.                              PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-LAST-CMT-SEQ       Numeric 4
Last Comment           Contains the last sequence number used
Sequence Number        when the last employee comment was
                       created.

EMP-CREATION-DATE      Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Creation Date Contains the date the employee record     HR511   PA02.1
                       was added to the database.                PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-NBR-FTE            Signed 7.6                                BN350   HR11.1
Element: Full Time EquiContains the employee's FTE (Full-time    HR11.2  HR511
                       Equivalency) factor which indicates the   PA02.1  PA100
                       percent of annual hours the employee      PA102   PA13.1
                       works. For example, if the employee       PA13.2  PA502
                       works full-time, this field is 1.000. If  PA513   PA52.1
                       this field is 0.5000, the employee works  PA52.3  PA52.4
                       half of the hours of a full-time          PA52.5  PR110
                       employee.                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TA175   TA199

EMP-PENSION-PLAN       Alpha 1                                   HR11.1  HR11.2
Element: Pension Plan  Indicates if the employee is a            HR511   PA02.1
                       participant in a retirement plan          PA100   PA102
                       maintained by the company.                PA502   PA52.1
                       N = No                                    PA52.3  PA52.4
                       Y = Yes                                   PA52.5  PR11.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-PAY-STEP           Numeric 2                                 HR11.1  HR11.2
Element: Step          Contains the appropriate step if the      HR511   PA02.1
                       employee's pay is based on a step and     PA100   PA102
                       grade schedule.                           PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-PAY-GRADE          Alpha 3                                   HR11.1  HR11.2
Element: Grade         Contains the appropriate grade if the     HR511   PA02.1
                       employee is paid based on a step and      PA100   PA102
                       grade schedule or is assigned to a grade  PA13.1  PA13.2
                       range schedule.                           PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-SCHEDULE           Alpha 9                                   HR11.1  HR11.2
Element: Schedule      Contains the schedule the employee is     HR511   PA02.1
                       associated with. There are two types of   PA100   PA102
                       schedules: step and grade and grade       PA13.1  PA13.2
                       range.                                    PA502   PA513
                                                                 PA52.1  PA52.3
                       The step and grade schedule is a matrix   PA52.4  PA52.5
                       used to determine an employee's rate of   PR110   PR113
                       pay based on their particular "step" and  PR120   PR13.1
                       "grade." If the employee is associated    PR13.5  PR13.6
                       with a step and grade schedule, the       PR13.8
                       system requires a value in the Step and
                       Grade fields and that the Rate of Pay
                       field is blank.

                       The grade range schedule is a series of
                       grades with minimum, midpoint, and
                       maximum salary amounts that is used for
                       salary administration. If an employee is
                       associated with a grade range schedule,
                       you can enter the grade, schedule, and
                       rate of pay. You can associate an
                       employee with only one type of schedule.

EMP-EBE-AMOUNT         Signed 9.2                                HR11.1  HR11.2
Element: Business ExpenContains the employee business expense    HR511   PA02.1
                       amount for W-2 purposes.                  PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR11.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-SICK-PAY           Signed 11.2                               HR11.1  HR11.2
Element: Sick Pay      Contains the employee's non-taxable       HR511   PA02.1
                       sick pay reportable on the W-2 form.      PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR11.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-OT-PLAN-CODE       Alpha 4                                   HR11.1  HR11.2
Element: Ot Plan Code  Contains the pay plan with which the      HR511   PA02.1
                       employee is associated.                   PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-DECEASED           Alpha 1                                   HR11.1  HR11.2
Element: Deceased      Indicates if the employee is deceased.    HR511   PA02.1
                       Y = Yes                                   PA100   PA102
                       N = No                                    PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR11.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-BSI-GROUP          Alpha 11                                  HR11.1  HR11.2
Element: Bsi Group     Contains the employee's BSI group code.   HR511   PA02.1
                       A BSI group code is a code defined in     PA100   PA102
                       BSI to provide an override tax formula    PA502   PA52.1
                       for specific employees.                   PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-WORK-STATE         Alpha 2                                   HR11.1  HR11.2
Element: Work State    Contains the employee's work state        HR511   PA02.1
                       abbreviation.                             PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-TAX-STATE          Alpha 2                                   HR11.1  HR11.2
Element: Tax State     Contains the employee's state taxing      HR511   PA02.1
                       authority for income tax purposes.        PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-TAX-PROVINCE       Alpha 2                                   HR11.1  HR11.2
Element: Province      Contains the tax province of the          HR511   PA02.1
                       employee that is used for Canada          PA100   PA102
                       Payroll.                                  PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-WC-STATE           Alpha 2                                   HR11.1  HR11.2
Element: Wc State      Contains the employee's work state        HR511   PA02.1
                       abbreviation that is used for computing   PA100   PA102
                       workers' compensation                     PA502   PA52.1
                       premiums.                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-TAX-COUNTY         Alpha 10                                  HR11.1  HR11.2
Element: Tax County    Contains the county taxing authority      HR511   PA02.1
                       for income tax purposes.                  PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-TAX-CITY           Alpha 10                                  HR11.1  HR11.2
Element: Tax City      Contains the city taxing authority for    HR511   PA02.1
                       income tax purposes.                      PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-MOVING-EXP         Signed 11.2                               HR11.1  HR11.2
Element: Moving Exp    Contains the employee's qualified         HR511   PA02.1
                       moving expenses that are reportable on    PA100   PA102
                       the W-2 form.                             PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR11.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-ALT-RATE-EXIST     Alpha 1                                   HR11.1  HR11.2
Element: Alt Rate ExistIndicates whether the employee has        HR14.1  HR511
                       alternates pay rates defined for          HR514   PA02.1
                       different job codes.                      PA100   PA102
                       Y = Yes                                   PA502   PA52.1
                       Blank = No                                PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-PEND-ACT-DATE      Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Pend Act Date Contains the date an action will take     HR511   PA02.1
                       effect.                                   PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.2  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  UK110

EMP-PIN                Alpha 10  (Lower Case)
Element: Pin           Contains the employee Personal
                       Identification Number.

EMP-TIPPED             Alpha 1                                   HR11.1  HR11.2
Element: Tipped        Contains a value that indicates whether   HR511   PA02.1
                       the employee is a tipped employee. This   PA100   PA102
                       field determines whether the system       PA502   PA52.1
                       verifies minimum wage and whether to      PA52.3  PA52.4
                       perform the tip credit calculation.       PA52.5  PR110
                       C = Tipped Employee - Tip Credit          PR113   PR120
                       N = Not a Tipped Employee                 PR13.1  PR13.5
                       T = Tipped Employee -No Tip Credit        PR13.6  PR13.8

EMP-EMAIL-ADDRESS      Alpha 60  (Lower Case)                    HR11.1  HR11.2
Element: Email Address Contains the employee's E-mail address.   HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-ACTIVITY           Alpha 15                                  HR11.1  HR11.2
Element: Activity      Contains the activity.                    HR511   PA02.1
                                                                 PA100   PA102
                       Activities are the tasks that make up     PA13.1  PA13.2
                       an activity group. Activities identify    PA502   PA513
                       work being done, such as work orders,     PA52.1  PA52.3
                       phases, products, and so on. A variety    PA52.4  PA52.5
                       of costs, revenues, or both make up an    PR110   PR113
                       activity. The Activity Management system  PR120   PR13.1
                       stores information such as                PR13.5  PR13.6
                       responsibility and schedule for each      PR13.8
                       activity. The breakdown of activity
                       costs and revenues is defined by account
                       categories. An activity must belong to
                       an activity group.

EMP-ACCT-CATEGORY      Alpha 5                                   HR11.1  HR11.2
Element: Account CategoContains the account category.            HR511   PA02.1
                                                                 PA100   PA102
                       Account categories are the Activity       PA13.1  PA13.2
                       Management accounts by which activity     PA502   PA513
                       transactions are grouped for budgeting    PA52.1  PA52.3
                       and reporting. Set up account categories  PA52.4  PA52.5
                       for an activity before you do any         PR110   PR113
                       budgeting or transaction processing.      PR120   PR13.1
                       Using account categories, you can sort    PR13.5  PR13.6
                       and combine incoming amounts into groups  PR13.8
                       for reporting and inquiry on activities.

EMP-MAX-LIMIT-OVRD     Alpha 1                                   HR11.1  HR11.2
Element: Max Limit OvrdIndicates the default for the maximum     HR511   PA02.1
                       compensation limit from Benefit Plan      PA100   PA102
                       file has been overriden for this          PA502   PA52.1
                       employee.                                 PA52.3  PA52.4
                       Y = Yes                                   PA52.5  PR110
                       N = No                                    PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-SEC-LVL            Numeric 1                                 HR11.1  HR11.2
Element: Sec Lvl       Contains the employee's security level.   HR12.1  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-SEC-LOCATION       Alpha 10                                  HR11.1  HR11.2
Element: Sec Location  Contains the employee's security          HR12.1  HR511
                       location.                                 PA02.1  PA100
                                                                 PA102   PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-POSITION           Alpha 12                                  HR11.1  HR11.2
Element: Position      Contains the user-defined code that       HR511   PA02.1
                       represents a position in the company.     PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-WORK-SCHED         Alpha 10                                  HR11.1  HR11.2
Element: Work Schedule Contains the employee's work schedule.    HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-SUPERVISOR-IND     Alpha 10                                  HR11.1  HR11.2
Element: Supervisor IndContains the employee's indirect          HR511   PA02.1
                       supervisor.                               PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-ANNUAL-HOURS       Numeric 4                                 HR11.1  HR11.2
Element: Annual Hours  Contains the employee's annual hours.     HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-WORK-COUNTY        Alpha 10                                  HR11.1  HR11.2
Element: Work County   Contains the employee's work county.      HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-WORK-CITY          Alpha 10                                  HR11.1  HR11.2
Element: Work City     Contains the employee's work city.        HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-WORK-SCHOOL        Alpha 10                                  HR11.1  HR11.2
Element: Work School   Contains the employee's work school.      HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-WORK-TRANSPORT     Alpha 10
Element: Work TransportContains the employees work
                       transportation.

EMP-TAX-SCHOOL         Alpha 10                                  HR11.1  HR11.2
Element: Tax School    Contains the employee's school tax        HR511   PA02.1
                       authority.                                PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-TAX-TRANSPORT      Alpha 10
Element: Tax Transport Contains the employee's tax
                       transportation authority.

EMP-FTE-TOTAL          Signed 11.6                               HR11.1  HR11.2
Element: Fte Total     Contains the employee's total FTE.        HR511   PA02.1
                                                                 PA100   PA102
                       The total FTE is the sum of the FTEs      PA13.1  PA13.2
                       for all of the employee's (Level 1        PA502   PA513
                       through 5) positions or jobs.             PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  TA195

EMP-PRO-RATE-TOTAL     Signed 13.4                               HR11.1  HR11.2
Element: Rate of Pay                                             HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-PRO-RATE-A-SAL     Signed 13.4                               HR11.1  HR11.2
Element: Rate of Pay                                             HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-NEW-HIRE-DATE      Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: New Hire Date                                           HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 PR296

EMP-COMPA-RATIO        Derived
Element: Compensation Ratio

EMP-PENET-RATIO        Derived
Element: Penetration Ratio

EMP-SAL-MTH-RATE       Derived
Element: Sal Mth Rate

EMP-HOUR-MTH-RATE      Derived
Element: Hour Mth Rate

EMP-MONTHLY-RATE       Derived
Element: Monthly Rate

EMP-SAL-BIWK-RATE      Derived
Element: Sal Biwk Rate

EMP-HRY-BIWK-RATE      Derived
Element: Hry Biwk Rate

EMP-SAL-SEMI-RATE      Derived
Element: Sal Semi Rate

EMP-HRY-SEMI-RATE      Derived
Element: Hry Semi Rate

EMP-SAL-WKLY-RATE      Derived
Element: Sal Wkly Rate

EMP-HRY-WKLY-RATE      Derived
Element: Hry Wkly Rate

EMP-WEEKLY-RATE        Derived
Element: Weekly Rate

EMP-BIWEEKLY-RATE      Derived
Element: Biweekly Rate

EMP-SEMIMNTH-RATE      Derived
Element: Semimnth Rate

EMP-EMP-ANN-HRS        Derived
Element: Emp Ann Hrs

EMP-CURRENCY-CODE      Alpha 5                                   HR11.1  HR11.2
Element: Currency Code Contains the pay currency.                HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-CURR-ND            Numeric 1                                 HR11.1  HR11.2
Account Currency       Represents the number of decimals         HR511   PA02.1
Code                   defined for the currency of the object.   PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

EMP-COUNTRY-CODE       Alpha 2                                   HR11.1  HR11.2
Element: Country Code  Contains the country of the employee's    HR511   PA02.1
                       home address.                             PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-NAME-PREFIX        Alpha 4  (Lower Case)                     HR11.1  HR11.2
Element: Name Prefix   Contains the prefix (title) of the        HR511   PA02.1
                       employee's name.                          PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-NAME-SUFFIX        Alpha 4  (Lower Case)                     HR11.1  HR11.2
Element: Name Suffix   Contains the suffix of the employee's     HR511   PA02.1
                       name.                                     PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-WORK-COUNTRY       Alpha 2                                   HR11.1  HR11.2
Element: Country Code  Contains the employee's work country.     HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-LAST-NAME-PRE      Alpha 30  (Lower Case)                    HR11.1  HR11.2
Element: Last Name Pre Contains the employee's previous last     HR511   PA02.1
                       name.                                     PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-EST-REMUN          Signed 11.2                               HR11.1  HR11.2
Element: Est Remun     Used for taxing Canada  Commission        HR511   PA02.1
                       Payments.                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-EST-EXPENSE        Signed 11.2                               HR11.1  HR11.2
Element: Est Expense   Used for taxing Canada Commission         HR511   PA02.1
                       Payments.                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-BUS-NBR-GRP        Alpha 4                                   HR11.1  HR11.2
Element: Bus Nbr Grp   Contains the business number group.       HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-QC-ENT-NBR-GRP     Alpha 4                                   HR11.1  HR11.2
Element: Qc Ent Nbr GrpContains the Quebec enterprise number     HR511   PA02.1
                       group.                                    PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-LAST-PRE           Derived
Element: Last Pre

EMP-LAST-SUF           Derived
Element: Last Suf

EMP-LAST-PRE-SUF       Derived
Element: Last Pre Suf

EMP-FIRST-MI           Derived
Element: First Mi

EMP-LAST-NAME-EXP      Derived
Element: Last Name Exp

EMP-FIRST-MI-EXP       Derived
Element: First Mi Exp

EMP-FULL-NAME          Derived
Element: Full Name

EMP-SHORT-NAME         Derived
Element: Short Name    Contains the employee's short name.

EMP-LABEL-NAME-1       Derived
Element: Label Name 1

EMP-WC-PROVINCE        Alpha 2                                   HR11.1  HR11.2
Element: Wc Province   Contains the employees province for       HR511   PA02.1
                       Canadian Workers Compensation.            PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-COUNTY             Alpha 25  (Lower Case)                    HR11.1  HR11.2
Element: County        The county for the company address.       HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-RAILROAD-CODE      Numeric 1                                 HR11.1  HR11.2
Element: Railroad Code 0 = Not Railroad Employee                 HR511   PA02.1
                       1 = Tier One Employee                     PA100   PA102
                       2 = Tier Two Employee                     PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-FST-DAY-WORKED     Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Fst Day Worked                                          HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-LAST-DAY-PAID      Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Last Day Paid                                           HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-LAB-DIST-FLAG      Alpha 1                                   HR11.1  HR11.2
Element: Lab Dist Flag " " = Not Applicable                      HR511   PA02.1
                       Y = Yes                                   PA100   PA102
                       N = No                                    PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-ENCUMBER-FLAG      Alpha 1                                   HR11.1  HR11.2
Element: Encumber Flag " " = Not Applicable                      HR511   PA02.1
                       Y = Yes                                   PA100   PA102
                       N = No                                    PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-EFFORT-FLAG        Alpha 1                                   HR11.1  HR11.2
Element: Effort Flag   Flag to indicate whether this activity    HR511   PA02.1
                       is subject to effort reporting, and if    PA100   PA102
                       it is, whether it prints in the           PA502   PA52.1
                       sponsored or non-sponsored section of     PA52.3  PA52.4
                       the report for effort reporting.          PA52.5  PR110
                       " " = Not Applicable                      PR113   PR120
                       Y = Yes                                   PR13.1  PR13.5
                       N = No                                    PR13.6  PR13.8

EMP-RPT-CURR           Alpha 5                                   HR11.1  HR11.2
Element: Rpt Curr                                                HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-PRMCERT-ID         Numeric 9                                 HR11.1  HR11.2
Element: Employee                                                HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-SNDCERT-ID         Numeric 9                                 HR11.1  HR11.2
Element: Employee                                                HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-FRNG-RATE          Signed 12.6                               HR11.1  HR11.2
Element: Frng Rate     A default fringe rate that can be sued    HR511   PA02.1
                       by the GM110 program to create            PA100   PA102
                       commitments for fringe amounts.  There    PA502   PA52.1
                       is a parameter choice on the GM110        PA52.3  PA52.4
                       program that allows the user to default   PA52.5  PR110
                       the fringe rate, post-to account and      PR113   PR120
                       account category information from the     PR13.1  PR13.5
                       activity or the employee.                 PR13.6  PR13.8

EMP-FRNG-ACCT-CAT      Alpha 5                                   HR11.1  HR11.2
Element: Account CategoA default post-to fringe account          HR511   PA02.1
                       category that can be used by GM110        PA100   PA102
                       program to create commitments for fringe  PA502   PA52.1
                       amounts.  There is a parameter choice on  PA52.3  PA52.4
                       the GM110 program that allows the user    PA52.5  PR110
                       to default the rate, post-to account and  PR113   PR120
                       account category information from the     PR13.1  PR13.5
                       activity or employee.                     PR13.6  PR13.8

EMP-FRNG-ACCOUNT       Numeric 6                                 HR11.1  HR11.2
Element: Account       A default post-to fringe account that     HR511   PA02.1
                       can be used by the GM110 program to       PA100   PA102
                       create commitments for fringe amounts.    PA502   PA52.1
                       There is a parameter choice on the GM110  PA52.3  PA52.4
                       program that allows the user to default   PA52.5  PR110
                       the fringe rate, post-to account and      PR113   PR120
                       account category information from the     PR13.1  PR13.5
                       activity or employee.                     PR13.6  PR13.8

EMP-FRNG-SUB-ACCT      Numeric 4                                 HR11.1  HR11.2
Element: Subaccount    A default post-to fringe sub account      HR511   PA02.1
                       that can be used by the GM110 program to  PA100   PA102
                       create commitments for fringe amounts.    PA502   PA52.1
                       There is a parameter choice on the GM110  PA52.3  PA52.4
                       program that allows the user to default   PA52.5  PR110
                       the fringe rate, post-to account and      PR113   PR120
                       account category information from the     PR13.1  PR13.5
                       activity or employee.                     PR13.6  PR13.8

EMP-DEATH-DATE         Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Date                                                    HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-TAX-FILTER         Numeric 1                                 HR11.1  HR11.2
Element: Tax Filter    1 = Locate All                            HR511   PA02.1
                       2 = Locate Federal & State Only           PA100   PA102
                       3 = Locate Federal Only                   PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EMP-REMOTE             Numeric 1                                 HR11.1  HR11.2
Element: Remote        0 = Not Remote                            HR511   PA02.1
                       1 = Remote                                PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

                         EMPLOYEE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EMPSET1   COMPANY                                                AC03.3  AC03.7
          EMPLOYEE                                               AC145   AC17.3
                                                                 AC18.2  AC190
                                                                 AC191   AC197
                                                                 AC203   AC210
                                                                 AC217   AC218
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC46.1
                                                                 AC50.1  AC500
                                                                 AC52.1  AC520
                                                                 AC54.1  AC540
                                                                 AC62.1  AC92.2
                                                                 AC92.4  AC92.6
                                                                 ACAC.1  BN100
                                                                 BN101   BN102
                                                                 ...

EMPSET2   COMPANY       KeyChange                                BN242   BN320
          PROCESS-LEVEL                                          HEP3.1  HR12.1
          DEPARTMENT                                             HR170   HR70.1
          EMPLOYEE                                               PA149   PA213
                                                                 PA340   TR222
                                                                 PR113   PR134
                                                                 PR136   PR205
                                                                 PR212   PR214
                                                                 PR226   PR229
                                                                 PR247   PR33.2
                                                                 PR38.1  PR39.2

EMPSET3   COMPANY       KeyChange                                HR03.1
          EMP-STATUS
          EMPLOYEE

EMPSET4   COMPANY       KeyChange                                HEP4.1  HR11.1
          FICA-NBR                                               HR11.2  HR511
          EMPLOYEE                                               PA02.1  PA100
                                                                 PA102   PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PR297
                                                                 PR299   UK184

EMPSET6   COMPANY       KeyChange                                HEP2.1  HR212
          LAST-NAME                                              HS10.1  HS10.2
          FIRST-NAME                                             PA311   PA370
          MIDDLE-INIT                                            PR33.3
          EMPLOYEE

EMPSET7   COMPANY       KeyChange                                BN100   BN101
          PROCESS-LEVEL                                          BN102   BN103
          EMPLOYEE                                               BN150   BN242
                                                                 BN245   BN331
                                                                 HC01.2  HCDL.1
                                                                 HCEM.1  HR00.2
                                                                 HR170   HR217
                                                                 HR220   HR70.1
                                                                 PA100   PA113
                                                                 PA149   PA213
                                                                 PA218   PA335
                                                                 PA496   PR113
                                                                 PR128   PR130
                                                                 PR141   PR197
                                                                 PR212   PR214
                                                                 ...

                         EMPLOYEE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Category  ACACCTCAT    Required
                            When EMP-ACCT-CATEGORY != Spaces

                            EMP-ACCT-CATEGORY     -> AAX-ACCT-CATEGORY

Activity       ACACTIVITY   Required
                            When EMP-ACTIVITY != Spaces

                            EMP-ACTIVITY          -> ACV-ACTIVITY

City           PRTAXAUTH    Required
                            When EMP-TAX-CITY != Spaces

                            EMP-TAX-CITY          -> PRX-TAX-ID-CODE

Company        PRSYSTEM     Required

                            EMP-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

County         PRTAXAUTH    Required
                            When EMP-TAX-COUNTY != Spaces

                            EMP-TAX-COUNTY        -> PRX-TAX-ID-CODE

Currency       CUCODES      Required
                            When (EMP-CURRENCY-CODE != Spaces )

                            EMP-CURRENCY-CODE     -> CUC-CURRENCY-CODE

Department     DEPTCODE     Required
                            When EMP-DEPARTMENT != Spaces

                            EMP-COMPANY           -> DPT-COMPANY
                            EMP-PROCESS-LEVEL     -> DPT-PROCESS-LEVEL
                            EMP-DEPARTMENT        -> DPT-DEPARTMENT

Emp Status     EMSTATUS     Required
                            When EMP-EMP-STATUS != Spaces

                            EMP-COMPANY           -> EMS-COMPANY
                            EMP-EMP-STATUS        -> EMS-EMP-STATUS

Home Account   GLMASTER     Required
                            When EMP-HM-ACCT-UNIT != Spaces
                            Or   EMP-HM-ACCOUNT   != Zeroes
                            Or   EMP-HM-SUB-ACCT  != Zeroes

                            EMP-HM-DIST-CO        -> GLM-COMPANY
                            EMP-HM-ACCT-UNIT      -> GLM-ACCT-UNIT
                            EMP-HM-ACCOUNT        -> GLM-ACCOUNT
                            EMP-HM-SUB-ACCT       -> GLM-SUB-ACCOUNT

Indir Supv     HRSUPER      Required
                            When (EMP-SUPERVISOR-IND != Spaces )

                            EMP-COMPANY           -> HSU-COMPANY
                            EMP-SUPERVISOR-IND    -> HSU-CODE

Job Code       JOBCODE      Required
                            When EMP-JOB-CODE != Spaces

                            EMP-COMPANY           -> JBC-COMPANY
                            EMP-JOB-CODE          -> JBC-JOB-CODE

Location       PCODES       Required
                            When PEM-LOCAT-CODE != Spaces

                            "LO"                  -> PCO-TYPE
                            PEM-LOCAT-CODE        -> PCO-CODE

Paemployee     PAEMPLOYEE   Not Required, Delete Cascades

                            EMP-COMPANY           -> PEM-COMPANY
                            EMP-EMPLOYEE          -> PEM-EMPLOYEE

Process Level  PRSYSTEM     Required

                            EMP-COMPANY           -> PRS-COMPANY
                            EMP-PROCESS-LEVEL     -> PRS-PROCESS-LEVEL

Prqcentgrp     PRQCENTGRP   Required

                            EMP-COMPANY           -> PQC-COMPANY
                            EMP-PROCESS-LEVEL     -> PQC-PROCESS-LEVEL
                            EMP-QC-ENT-NBR-GRP    -> PQC-QC-ENT-NBR-GRP

Resident State PRSTATE      Required
                            When EMP-TAX-STATE != Spaces

                            EMP-TAX-STATE         -> PSA-STATE

Supervisor     HRSUPER      Required
                            When EMP-SUPERVISOR != Spaces

                            EMP-COMPANY           -> HSU-COMPANY
                            EMP-SUPERVISOR        -> HSU-CODE

Tax Rpt State  PREMPSTATE   Not Required
                            Valid When (EMP-TAX-STATE != Spaces )

                            EMP-COMPANY           -> PES-COMPANY
                            EMP-EMPLOYEE          -> PES-EMPLOYEE
                            EMP-TAX-STATE         -> PES-STATE

Tax School     PRTAXAUTH    Not Required
                            Valid When EMP-TAX-SCHOOL != Spaces

                            EMP-TAX-SCHOOL        -> PRX-TAX-ID-CODE

Union          PCODES       Required
                            When EMP-UNION-CODE != Spaces

                            "UN"                  -> PCO-TYPE
                            EMP-UNION-CODE        -> PCO-CODE

User Level     PCODES       Required
                            When EMP-USER-LEVEL != Spaces

                            "UL"                  -> PCO-TYPE
                            EMP-USER-LEVEL        -> PCO-CODE

Wc State       PRSTATE      Required
                            When EMP-WC-STATE != Spaces

                            EMP-WC-STATE          -> PSA-STATE

Work City      PRTAXAUTH    Not Required
                            Valid When EMP-WORK-CITY != Spaces

                            EMP-WORK-CITY         -> PRX-TAX-ID-CODE

Work County    PRTAXAUTH    Not Required
                            Valid When EMP-WORK-COUNTY != Spaces

                            EMP-WORK-COUNTY       -> PRX-TAX-ID-CODE

Work Rpt State PREMPSTATE   Not Required
                            Valid When EMP-WORK-STATE != Spaces

                            EMP-COMPANY           -> PES-COMPANY
                            EMP-EMPLOYEE          -> PES-EMPLOYEE
                            EMP-WORK-STATE        -> PES-STATE

Work School    PRTAXAUTH    Not Required
                            Valid When EMP-WORK-SCHOOL != Spaces

                            EMP-WORK-SCHOOL       -> PRX-TAX-ID-CODE

Work State     PRSTATE      Required
                            When EMP-WORK-STATE != Spaces

                            EMP-WORK-STATE        -> PSA-STATE

                         EMPLOYEE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acassign       ACASSIGN

                            EMP-COMPANY           -> AAN-COMPANY
                            EMP-EMPLOYEE          -> AAN-EMPLOYEE-ASSET
                                                     AAN-ACTIVITY-GRP
                                                     AAN-ACTIVITY
                                                     AAN-RESOURCE-TYPE
                                                     AAN-RESOURCE-CODE

Ach Deposits   EMACHDEPST   Delete Cascades

                            EMP-COMPANY           -> EAD-COMPANY
                            EMP-EMPLOYEE          -> EAD-EMPLOYEE
                                                     EAD-ACH-DIST-NBR

All Pos        PAEMPPOS     Delete Cascades

                            EMP-COMPANY           -> PEP-COMPANY
                            EMP-EMPLOYEE          -> PEP-EMPLOYEE
                                                     PEP-POS-LEVEL
                                                     PEP-EFFECT-DATE

Alt Pay Rates  PRRATES      Delete Cascades

                            EMP-COMPANY           -> PRR-COMPANY
                            EMP-EMPLOYEE          -> PRR-EMPLOYEE
                                                     PRR-SEQ-NBR

Attend Hist    ATTENDHIST   Delete Cascades

                            EMP-COMPANY           -> ATH-COMPANY
                            EMP-EMPLOYEE          -> ATH-EMPLOYEE
                                                     ATH-DATE
                                                     ATH-ATTEND-CODE
                                                     ATH-TIME-SEQ

Beneficiaries  BENEFICRY

                            EMP-COMPANY           -> BNF-COMPANY
                            EMP-EMPLOYEE          -> BNF-EMPLOYEE
                                                     BNF-PLAN-TYPE
                                                     BNF-PLAN-CODE
                                                     BNF-SEQ-NBR

Benefit        BENEFIT      Delete Restricted

                            EMP-COMPANY           -> BEN-COMPANY
                            EMP-EMPLOYEE          -> BEN-EMPLOYEE
                                                     BEN-PLAN-TYPE
                                                     BEN-PLAN-CODE
                                                     BEN-START-DATE

Bnben          BNBEN        Delete Cascades

                            EMP-COMPANY           -> BNB-COMPANY
                            EMP-EMPLOYEE          -> BNB-EMPLOYEE
                                                     BNB-PLAN-TYPE
                                                     BNB-PLAN-CODE
                                                     BNB-START-DATE

Bnchange       BNCHANGE     Delete Cascades

                            EMP-COMPANY           -> BNH-COMPANY
                            EMP-EMPLOYEE          -> BNH-EMPLOYEE
                                                     BNH-EFFECT-DATE
                                                     BNH-SEQ-NBR

Bngrpchg       BNGRPCHG     Delete Cascades

                            EMP-COMPANY           -> BNG-COMPANY
                            EMP-EMPLOYEE          -> BNG-EMPLOYEE
                                                     BNG-EFFECT-DATE
                                                     BNG-SEQ-NBR

Bondbenseq     BONDBENSEQ

                            EMP-COMPANY           -> BBS-COMPANY
                            EMP-EMPLOYEE          -> BBS-EMPLOYEE
                                                     BBS-PLAN-CODE
                                                     BBS-START-DATE
                                                     BBS-BOND-SEQ-NBR

Ck Comments    PACOMMENTS   Delete Cascades

                            EMP-COMPANY           -> PAC-COMPANY
                            Zeroes                -> PAC-EMP-APP
                            "CK"                  -> PAC-CMT-TYPE
                            EMP-EMPLOYEE          -> PAC-EMPLOYEE
                            Spaces                -> PAC-JOB-CODE
                            Spaces                -> PAC-ACTION-CODE
                            Zeroes                -> PAC-LN-NBR
                                                     PAC-SEQ-NBR

Coda           CODA

                            EMP-COMPANY           -> COD-COMPANY
                            EMP-EMPLOYEE          -> COD-EMPLOYEE
                                                     COD-PLAN-TYPE
                                                     COD-PLAN-CODE
                                                     COD-PLAN-YEAR
                                                     COD-PROCESS-LEVEL
                                                     COD-BUS-NBR-GRP
                                                     COD-QC-ENT-NBR-GRP

Comphist       COMPHIST

                            EMP-COMPANY           -> CPH-COMPANY
                            EMP-EMPLOYEE          -> CPH-EMPLOYEE
                                                     CPH-PLAN-TYPE
                                                     CPH-PLAN-CODE
                                                     CPH-PLAN-YEAR

Correspondence HRCORRESP

                            EMP-COMPANY           -> HCP-COMPANY
                            "1"                   -> HCP-REQ-TYPE
                            EMP-EMPLOYEE          -> HCP-ID-NBR
                            Zeroes                -> HCP-DEPENDENT
                                                     HCP-SEQ-NBR

Cur Err Pro Tr TIMERECORD

                            EMP-COMPANY           -> TRD-COMPANY
                            EMP-PROCESS-LEVEL     -> TRD-PROCESS-LEVEL
                            EMP-EMPLOYEE          -> TRD-EMPLOYEE
                                                     TRD-CHECK-GRP
                                                     TRD-REPORT-ENTITY
                                                     TRD-BUS-NBR-GRP
                                                     TRD-SUPP-TAX-CODE
                                                     TRD-PROCESS-GRP
                                                     TRD-TIME-SEQ

Current Pos    PAEMPPOS

                            EMP-COMPANY           -> PEP-COMPANY
                            EMP-EMPLOYEE          -> PEP-EMPLOYEE
                                                     PEP-POS-LEVEL
                                                     PEP-EFFECT-DATE

Deduction      EMDEDMASTR   Delete Restricted

                            EMP-COMPANY           -> EDM-COMPANY
                            EMP-EMPLOYEE          -> EDM-EMPLOYEE
                                                     EDM-DED-CODE
                                                     EDM-SEQ-NBR

Emdistmast     EMDISTMAST   Delete Cascades

                            EMP-COMPANY           -> DIP-COMPANY
                            EMP-EMPLOYEE          -> DIP-EMPLOYEE
                                                     DIP-POSITION
                                                     DIP-PAY-CODE
                                                     DIP-DED-CODE
                                                     DIP-SEQ-NBR

Emp Garn       PREMPGARN    Delete Cascades

                            EMP-COMPANY           -> PEG-COMPANY
                            EMP-EMPLOYEE          -> PEG-EMPLOYEE
                                                     PEG-CASE-NUMBER
                                                     PEG-FILE-NUMBER

Emp Trans      EMTATRANS

                            EMP-COMPANY           -> ETT-COMPANY
                            EMP-EMPLOYEE          -> ETT-EMPLOYEE
                                                     ETT-PLAN-NAME
                                                     ETT-DATE
                                                     ETT-SEQ-NBR

Emtamastr      EMTAMASTR    Delete Cascades

                            EMP-COMPANY           -> ETM-COMPANY
                            EMP-EMPLOYEE          -> ETM-EMPLOYEE
                                                     ETM-PLAN-NAME

Err Time Recs  TIMERECORD

                            EMP-COMPANY           -> TRD-COMPANY
                            EMP-PROCESS-LEVEL     -> TRD-PROCESS-LEVEL
                            EMP-EMPLOYEE          -> TRD-EMPLOYEE
                                                     TRD-CHECK-GRP
                                                     TRD-REPORT-ENTITY
                                                     TRD-BUS-NBR-GRP
                                                     TRD-SUPP-TAX-CODE
                                                     TRD-PROCESS-GRP
                                                     TRD-TIME-SEQ

Flex Dollars   EMPFLEXDOL

                            EMP-COMPANY           -> EFD-COMPANY
                            EMP-EMPLOYEE          -> EFD-EMPLOYEE
                                                     EFD-START-DATE

Flex Periods   EMPFLEXREM

                            EMP-COMPANY           -> EFR-COMPANY
                            EMP-EMPLOYEE          -> EFR-EMPLOYEE
                                                     EFR-PLAN-START-DT
                                                     EFR-START-DATE

Fut Time Recs  TIMERECORD

                            EMP-COMPANY           -> TRD-COMPANY
                            EMP-EMPLOYEE          -> TRD-EMPLOYEE
                                                     TRD-TR-DATE
                                                     TRD-TIME-SEQ

Hr Occup Code  HROCCUPCD
                            Valid When EMP-JOB-CODE != Spaces

                            EMP-COMPANY           -> HOP-COMPANY
                            EMP-JOB-CODE          -> HOP-JOB-CODE
                            EMP-WORK-COUNTRY      -> HOP-COUNTRY-CODE
                                                     HOP-OCCUPTN-CODE

Hrhistory      HRHISTORY

                            EMP-COMPANY           -> HRH-COMPANY
                            EMP-EMPLOYEE          -> HRH-EMPLOYEE
                            Zeroes                -> HRH-OBJ-ID
                                                     HRH-FLD-NBR
                                                     HRH-BEG-DATE
                                                     HRH-SEQ-NBR

Job Hist       APPJOBHIST

                            EMP-COMPANY           -> AJH-COMPANY
                            EMP-EMPLOYEE          -> AJH-EMPLOYEE
                                                     AJH-SEQ-NBR
                                                     AJH-APPLICANT

Lp Service     TAEMPSERV

                            EMP-COMPANY           -> TES-COMPANY
                            EMP-EMPLOYEE          -> TES-EMPLOYEE
                                                     TES-TES-OBJ-ID

Lptrans        TAEMPTRANS

                            EMP-COMPANY           -> TTR-COMPANY
                            EMP-EMPLOYEE          -> TTR-EMPLOYEE
                                                     TTR-PLAN
                                                     TTR-EMPLOYEE-GROUP
                                                     TTR-POSITION
                                                     TTR-DATE
                                                     TTR-SEQ-NBR

One Time Ded   ONETMDED

                            EMP-COMPANY           -> OTD-COMPANY
                            EMP-EMPLOYEE          -> OTD-EMPLOYEE
                                                     OTD-DED-CODE
                                                     OTD-EDM-SEQ-NBR
                                                     OTD-SEQ-NBR

Open Manuals   PAYMASTR

                            EMP-COMPANY           -> PYM-COMPANY
                            EMP-PROCESS-LEVEL     -> PYM-PROCESS-LEVEL
                            EMP-EMPLOYEE          -> PYM-EMPLOYEE
                            "M"                   -> PYM-CHECK-TYPE
                                                     PYM-CHECK-ID

Part Benefit   PARTBEN      Delete Restricted

                            EMP-COMPANY           -> PTB-COMPANY
                            EMP-EMPLOYEE          -> PTB-EMPLOYEE
                                                     PTB-PARTICIPNT
                                                     PTB-PLAN-TYPE
                                                     PTB-PLAN-CODE
                                                     PTB-START-DATE

Pathfind       PATHFIND     Delete Cascades

                            EMP-COMPANY           -> PTF-COMPANY
                            EMP-EMPLOYEE          -> PTF-EMPLOYEE
                                                     PTF-FLD-NBR
                                                     PTF-POS-LEVEL

Paymastr       PAYMASTR     Delete Restricted

                            EMP-COMPANY           -> PYM-COMPANY
                            EMP-EMPLOYEE          -> PYM-EMPLOYEE
                                                     PYM-CHECK-ID

Payments       PAYMASTR     Delete Restricted

                            EMP-COMPANY           -> PYM-COMPANY
                            EMP-EMPLOYEE          -> PYM-EMPLOYEE
                                                     PYM-CHECK-DATE
                                                     PYM-CHECK-NBR
                                                     PYM-CHECK-ID

Pbhstdtl       PBHSTDTL

                            EMP-COMPANY           -> PBH-COMPANY
                            EMP-EMPLOYEE          -> PBH-EMPLOYEE
                                                     PBH-CHECK-ID
                                                     PBH-PROCESS-LEVEL
                                                     PBH-INVOICE
                                                     PBH-LINE-NBR

Pep Audit      PAPEPAUDIT   Delete Cascades

                            EMP-COMPANY           -> PEA-COMPANY
                            EMP-EMPLOYEE          -> PEA-EMPLOYEE
                                                     PEA-POS-LEVEL
                                                     PEA-EFFECT-DATE
                                                     PEA-UPDATE-DATE
                                                     PEA-FLD-NBR
                                                     PEA-ACT-OBJ-ID

Persacthst     PERSACTHST

                            EMP-COMPANY           -> PAH-COMPANY
                            EMP-EMPLOYEE          -> PAH-EMPLOYEE
                                                     PAH-EFFECT-DATE
                                                     PAH-ACTION-CODE
                                                     PAH-ACTION-NBR

Pgemployee     PGEMPLOYEE   Delete Cascades

                            EMP-COMPANY           -> PGE-COMPANY
                            EMP-EMPLOYEE          -> PGE-EMPLOYEE
                                                     PGE-GROUP-NAME

Plan Name      EMTAMASTR    Delete Restricted

                            EMP-COMPANY           -> ETM-COMPANY
                            EMP-EMPLOYEE          -> ETM-EMPLOYEE
                                                     ETM-PLAN-NAME

Pos Chg Error  PAPOSERR     Delete Cascades

                            EMP-COMPANY           -> PPE-COMPANY
                            EMP-EMPLOYEE          -> PPE-EMPLOYEE
                            Zeroes                -> PPE-REQUISITION
                                                     PPE-POSITION
                                                     PPE-EFFECT-DATE
                                                     PPE-UPDATE-TYPE

Position       PAPOSITION
                            Valid When (EMP-POSITION != Spaces )

                            EMP-COMPANY           -> POS-COMPANY
                            EMP-POSITION          -> POS-POSITION
                                                     POS-EFFECT-DATE

Pr Distribs    PRDISTRIB    Delete Restricted

                            EMP-COMPANY           -> PRD-COMPANY
                            EMP-EMPLOYEE          -> PRD-EMPLOYEE
                                                     PRD-GL-DATE
                                                     PRD-CHECK-ID
                                                     PRD-OBJ-ID

Prhours        PRHOURS      Delete Cascades

                            EMP-COMPANY           -> PHS-COMPANY
                            EMP-EMPLOYEE          -> PHS-EMPLOYEE
                                                     PHS-HOURS-TYPE
                                                     PHS-PAYROLL-YEAR

Quartded       QUARTDED

                            EMP-COMPANY           -> QTD-COMPANY
                            EMP-EMPLOYEE          -> QTD-EMPLOYEE
                            PRS-PAYROLL-YEAR      -> QTD-PAYROLL-YEAR
                                                     QTD-QUARTER
                                                     QTD-COUNTRY-CODE
                                                     QTD-DED-CODE
                                                     QTD-REPORT-ENTITY
                                                     QTD-BUS-NBR-GRP
                                                     QTD-QC-ENT-NBR-GRP
                                                     QTD-PROCESS-LEVEL
                                                     QTD-WORK-STATE
                                                     QTD-PENSION

Quartded All   QUARTDED

                            EMP-COMPANY           -> QTD-COMPANY
                            EMP-EMPLOYEE          -> QTD-EMPLOYEE
                                                     QTD-PAYROLL-YEAR
                                                     QTD-QUARTER
                                                     QTD-COUNTRY-CODE
                                                     QTD-DED-CODE
                                                     QTD-REPORT-ENTITY
                                                     QTD-BUS-NBR-GRP
                                                     QTD-QC-ENT-NBR-GRP
                                                     QTD-PROCESS-LEVEL
                                                     QTD-WORK-STATE
                                                     QTD-PENSION

Quartwage      QUARTWAGE

                            EMP-COMPANY           -> QTW-COMPANY
                            EMP-EMPLOYEE          -> QTW-EMPLOYEE
                            PRS-PAYROLL-YEAR      -> QTW-PAYROLL-YEAR
                                                     QTW-QUARTER
                                                     QTW-COUNTRY-CODE
                                                     QTW-PAY-SUM-GRP
                                                     QTW-REPORT-ENTITY
                                                     QTW-BUS-NBR-GRP
                                                     QTW-QC-ENT-NBR-GRP
                                                     QTW-PROCESS-LEVEL
                                                     QTW-WORK-STATE
                                                     QTW-PENSION

Quartwage All  QUARTWAGE

                            EMP-COMPANY           -> QTW-COMPANY
                            EMP-EMPLOYEE          -> QTW-EMPLOYEE
                                                     QTW-PAYROLL-YEAR
                                                     QTW-QUARTER
                                                     QTW-COUNTRY-CODE
                                                     QTW-PAY-SUM-GRP
                                                     QTW-REPORT-ENTITY
                                                     QTW-BUS-NBR-GRP
                                                     QTW-QC-ENT-NBR-GRP
                                                     QTW-PROCESS-LEVEL
                                                     QTW-WORK-STATE
                                                     QTW-PENSION

Report States  PREMPSTATE   Delete Cascades

                            EMP-COMPANY           -> PES-COMPANY
                            EMP-EMPLOYEE          -> PES-EMPLOYEE
                                                     PES-STATE

Salary History PRRATEHIST

                            EMP-COMPANY           -> PRH-COMPANY
                            EMP-EMPLOYEE          -> PRH-EMPLOYEE
                                                     PRH-POS-LEVEL
                                                     PRH-BEG-DATE
                                                     PRH-SEQ-NBR

Schedule       PRSAGHEAD
                            Valid When EMP-SCHEDULE != Spaces

                            EMP-COMPANY           -> SGH-COMPANY
                            "S"                   -> SGH-INDICATOR
                            EMP-SCHEDULE          -> SGH-SCHEDULE
                                                     SGH-EFFECT-DATE

Standtime      STANDTIME    Delete Cascades

                            EMP-COMPANY           -> STM-COMPANY
                            EMP-EMPLOYEE          -> STM-EMPLOYEE
                            Spaces                -> STM-TIME-GROUP
                                                     STM-PAY-CODE
                                                     STM-SEQ-NBR

Step And Grade PRSAGDTL
                            Valid When EMP-SCHEDULE  != Spaces
                                  And  EMP-PAY-STEP  != Zeroes
                                  And  EMP-PAY-GRADE != Spaces

                            EMP-COMPANY           -> SGD-COMPANY
                            EMP-SCHEDULE          -> SGD-SCHEDULE
                            EMP-PAY-GRADE         -> SGD-PAY-GRADE
                            EMP-PAY-STEP          -> SGD-PAY-STEP
                                                     SGD-EFFECT-DATE

Super Codes    HRSUPER

                            EMP-COMPANY           -> HSU-COMPANY
                            EMP-EMPLOYEE          -> HSU-EMPLOYEE
                                                     HSU-CODE

Ta Enroll      TAENROLL     Delete Cascades

                            EMP-COMPANY           -> TEN-COMPANY
                            EMP-EMPLOYEE          -> TEN-EMPLOYEE
                                                     TEN-PLAN
                                                     TEN-EMPLOYEE-GROUP
                                                     TEN-POSITION
                                                     TEN-JOB-CODE
                                                     TEN-PROCESS-LEVEL
                                                     TEN-DEPARTMENT

Ta Group       TAEEGROUP    Delete Cascades

                            EMP-COMPANY           -> TGR-COMPANY
                            EMP-EMPLOYEE          -> TGR-EMPLOYEE
                                                     TGR-EMPLOYEE-GROUP
                                                     TGR-EFFECTIVE-DATE
                                                     TGR-QUALIFY-FLAG

Ta Master      TAEEMASTER   Delete Cascades

                            EMP-COMPANY           -> TEM-COMPANY
                            EMP-EMPLOYEE          -> TEM-EMPLOYEE
                                                     TEM-PLAN
                                                     TEM-EMPLOYEE-GROUP
                                                     TEM-POSITION

Timerecord     TIMERECORD   Delete Restricted

                            EMP-COMPANY           -> TRD-COMPANY
                            EMP-EMPLOYEE          -> TRD-EMPLOYEE
                                                     TRD-TIME-SEQ

User Fields    HREMPUSF     Delete Cascades

                            EMP-COMPANY           -> HEU-COMPANY
                            Zeroes                -> HEU-EMP-APP
                            EMP-EMPLOYEE          -> HEU-EMPLOYEE
                                                     HEU-FIELD-KEY

Vesthours      VESTHOURS

                            EMP-COMPANY           -> VES-COMPANY
                            EMP-EMPLOYEE          -> VES-EMPLOYEE
                                                     VES-PLAN-TYPE
                                                     VES-PLAN-CODE
                                                     VES-PLAN-YEAR

Wages          PRTIME

                            EMP-COMPANY           -> PRT-COMPANY
                            EMP-EMPLOYEE          -> PRT-EMPLOYEE
                                                     PRT-TR-DATE
                                                     PRT-TIME-SEQ
                                                     PRT-CHECK-ID

Work Sched     HRWRKSCHD
                            Valid When (EMP-WORK-SCHED != Spaces )

                            EMP-COMPANY           -> WSC-COMPANY
                            EMP-WORK-SCHED        -> WSC-WORK-SCHED
                                                     WSC-EFFECT-DATE