Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAEMPLOYEE


                            PAEMPLOYEE FILE

                     Employee Personnel Information

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

REFERENCED BY

BN100     BN101     BN102     BN103     BN104     BN105
BN106     BN137     BN138     BN140     BN141     BN145
BN150     BN175     BN230     BN231     BN232     BN233
BN234     BN236     BN237     BN238     BN240     BN242
BN245     BN246     BN248     BN258     BN285     BN300
BN305     BN31.1    BN31.2    BN310     BN32.1    BN32.2
BN32.3    BN320     BN325     BN33.1    BN33.2    BN33.3
BN330     BN331     BN335     BN340     BN345     BN35.1
BN350     BN36.1    BN430     BN45.1    BN48.1    BN48.2
BN531     BN533     BN55.1    BN55.2    BN555     BN56.1
BN57.1    BN65.1    BN70.1    BN71.1    BN72.1    BS09.1
BS10.1    BS11.1    BS12.1    BS13.1    BS14.1    BS15.1
BS32.1    HCDL.1    HCEM.1    HCHP.1    HAP3.1    HEP4.1
HPOS.1    HPQC.1    HPRS.1    HR15.1    HR155     HR170
HR20.1    HR211     HR213     HR217     HR220     HR30.1
HR515     HR54.1    HR55.2    HR70.1    HRS1.1    HRSC.1
HS10.1    HS10.2    HS11.1    HS12.1    HS13.1    HS14.1
HS50.1    HS50.2    PA10.1    PA113     PA149     PA210
PA212     PA214     PA215     PA216     PA217     PA220
PA221     PA222     PA223     PA224     PA225     PA227
PA248     PA249     PA262     PA272     PA290     PA296
PA31.1    PA310     PA311     PA315     PA320     PA325
PA330     PA335     PA345     PA350     PA355     PA360
PA370     PA372     PA390     PA391     PA393     PA406
PA490     PA495     PA496     PA53.1    PA531     PA532
PA533     PA534     PA54.1    PA59.1    PA590     PA594
PA64.1    PA64.2    PA66.2    PA66.3    PA90.1    TR120
TR121     TR20.1    TR20.2    TR20.3    TR207     PR128
PR130     PR131     PR132     PR134     PR136     PR14.1
PR15.2    PR160     PR180     PR188     PR197     PR205
PR240     PR241     PR242     PR243     PR244     PR245
PR250     PR251     PR252     PR253     PR282     PR29.1
PR292     PR293     PR296     PR297     PR298     PR299
PR32.2    PR33.2    PR33.3    PR35.1    PR35.2    PR35.3
PR35.4    PR35.5    PR35.6    PR35.8    PR35.9    PR36.1
PR45.1    PR529     PR530     PR560     PR82.1    PR88.1
PRSC.1    UK102     UK110     UK201     TA147     TP135
HRLRD

UPDATED BY

BN180     BN47.1    BN547     BN80.1    BN90.1    HR11.1
HR11.2    HR12.1    HR13.1    HR511     HR513     HR90.1
HR90.2    PA02.1    PA100     PA102     PA115     PA12.1
PA13.1    PA13.2    PA14.1    PA15.1    PA16.1    PA17.1
PA20.1    PA21.1    PA218     PA22.1    PA24.1    PA26.1
PA27.1    PA34.1    PA35.1    PA36.1    PA38.1    PA41.1
PA502     PA512     PA513     PA52.1    PA52.3    PA52.4
PA52.5    PA520     PA96.1    TR21.1    TR22.1    TR26.1
TR500     PR110     PR113     PR120     PR13.1    PR13.5
PR13.6    PR13.8    PR84.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PEM-COMPANY            Numeric 4                                 HR11.1  HR11.2
Element: Company Hr    Contains the number that represents an    HR511   PA02.1
                       established company and is entered on     PA100   PA102
                       all functions.                            PA14.1  PA15.1
                                                                 PA17.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-EMPLOYEE           Numeric 9                                 BN350   HR11.1
Element: Employee      Contains the employee number. An          HR11.2  HR511
                       employee number is assigned to each       PA02.1  PA100
                       person employed by the company. The       PA102   PA14.1
                       system uses the employee number to        PA15.1  PA17.1
                       correlate all information related to the  PA502   PA52.1
                       employee. This number must be valid in    PA52.3  PA52.4
                       the Employee file.                        PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-SUPP-ADDR1         Alpha 30  (Lower Case)                    HR11.1  HR11.2
Element: Supplemental AContains the first line of the            HR511   PA02.1
                       supplemental address.                     PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-SUPP-ADDR2         Alpha 30  (Lower Case)                    HR11.1  HR11.2
Supplemental           Contains the second line of the           HR511   PA02.1
Address 2              supplemental address.                     PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-SUPP-ADDR3         Alpha 30  (Lower Case)                    HR11.1  HR11.2
Element: Supp Addr3    Contains the third line of the            HR511   PA02.1
                       supplemental address.                     PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-SUPP-ADDR4         Alpha 30  (Lower Case)                    HR11.1  HR11.2
Element: Supp Addr4    Contains the fourth line of the           HR511   PA02.1
                       supplemental address.                     PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-SUPP-CITY          Alpha 18  (Lower Case)                    HR11.1  HR11.2
Supplemental           Contains the city of the supplemental     HR511   PA02.1
Address City           address.                                  PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-SUPP-STATE         Alpha 2                                   HR11.1  HR11.2
Suppl. Address         Contains the state of the supplemental    HR511   PA02.1
State/Province         address.                                  PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-SUPP-ZIP           Alpha 10                                  HR11.1  HR11.2
Suppl. Address         Contains the postal code of the           HR511   PA02.1
Postal Code            supplemental address.                     PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-SUPP-CNTRY-CD      Alpha 2                                   HR11.1  HR11.2
Element: Supp Cntry Cd Contains the country of the               HR511   PA02.1
                       supplemental address.                     PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-HM-PHONE-CNTRY     Alpha 6                                   HR11.1  HR11.2
Element: Hm Phone CntryContains the country code of the          HR511   PA02.1
                       employee's home telephone number.         PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-HM-PHONE-NBR       Alpha 15                                  HR11.1  HR11.2
Element: Hm Phone Nbr  Contains the employee's home telephone    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

PEM-WK-PHONE-CNTRY     Alpha 6                                   HR11.1  HR11.2
Work Telephone         Contains the country code of the          HR511   PA02.1
Country                employee's work telephone number.         PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-WK-PHONE-NBR       Alpha 15                                  HR11.1  HR11.2
Element: Work TelephoneContains the employee's work telephone    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

PEM-WK-PHONE-EXT       Alpha 5                                   HR11.1  HR11.2
Work Telephone         Contains the extension of the             HR511   PA02.1
Extension              employee's work telephone number.         PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-EEO-CLASS          Alpha 4  (Lower Case)                     HR11.1  HR11.2
Element: EEO Class     Contains the employee's ethnic origin.    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

PEM-SEX                Alpha 1                                   HR11.1  HR11.2
Element: Gender        Contains the employee's gender.           HR511   PA02.1
                       F = Female                                PA100   PA102
                       M = Male                                  PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-HANDICAP-ID        Alpha 1                                   HR11.1  HR11.2
Element: Disability    Indicates if the employee is disabled.    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

PEM-COMP-CODE          Alpha 4                                   HR11.1  HR11.2
Element: Miscellaneous Contains miscellaneous data.              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

PEM-COMP-NBR           Alpha 10                                  HR11.1  HR11.2
Element: Miscellaneous Contains miscellaneous data.              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

PEM-VETERAN            Alpha 1                                   HR11.1  HR11.2
Element: Veteran       Indicates the individual is a veteran.    HR511   PA02.1
                       1 = Veteran                               PA100   PA102
                       2 = Disabled Veteran                      PA14.1  PA502
                       3 = Vietnam Era Veteran                   PA52.1  PA52.3
                       4 = Vietnam Era Disabled Veteran          PA52.4  PA52.5
                       5 = Gulf War Era Veteran                  PR110   PR113
                       6 = Special Disabled Veteran              PR120   PR13.1
                       7 = Other Eligible Veteran                PR13.5  PR13.6
                       8 = Newly Separated Veteran               PR13.8
                       N = No
                       Y = Yes

PEM-BIRTHDATE          Numeric 8  (yyyymmdd)                     BN350   HR11.1
Element: Birthdate     Contains the employee's birthdate.        HR11.2  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA90.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-BIRTH-CITY         Alpha 18  (Lower Case)                    HR11.1  HR11.2
Element: Birth Place: CContains the city where the employee      HR511   PA02.1
                       was born.                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-BIRTH-STATE        Alpha 2                                   HR11.1  HR11.2
Birth Place:           Contains the two-character abbreviation   HR511   PA02.1
State/Province         of the state where the employee was       PA100   PA102
                       born.                                     PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-BIRTH-CNTRY-CD     Alpha 2                                   HR11.1  HR11.2
Element: Birth Cntry CdIndicates country where employee was      HR511   PA02.1
                       born.                                     PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-SENIOR-DATE        Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Seniority DateContains the employee's seniority date.   HR511   PA02.1
                                                                 PA10.1  PA100
                                                                 PA102   PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PR84.1

PEM-MAIDEN-LST-NM      Alpha 30  (Lower Case)                    HR11.1  HR11.2
Element: Maiden Last NaContains the employee's maiden 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

PEM-MAIDEN-FST-NM      Alpha 15  (Lower Case)                    HR11.1  HR11.2
Element: Maiden First NContains the employee's maiden first      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

PEM-MAIDEN-MI          Alpha 1                                   HR11.1  HR11.2
Maiden Name Middle     Contains the employee's maiden middle     HR511   PA02.1
Initial                initial.                                  PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-FORMER-LST-NM      Alpha 30  (Lower Case)                    HR11.1  HR11.2
Element: Former Last NaContains the employee's former 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

PEM-FORMER-FST-NM      Alpha 15  (Lower Case)                    HR11.1  HR11.2
Element: Former First NContains the employee's former first      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

PEM-FORMER-MI          Alpha 1                                   HR11.1  HR11.2
Former Name Middle     Contains the employee's former middle     HR511   PA02.1
Initial                initial.                                  PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-LOCAT-CODE         Alpha 10                                  HR11.1  HR11.2
Element: Location      Contains a user-defined location code     HR511   PA02.1
                       that identifies where the employee        PA10.1  PA100
                       works. The Human Resource Code file       PA102   PA13.1
                       validates  this field.                    PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-HIRE-SOURCE        Alpha 10                                  HR11.1  HR11.2
Element: Hire Source   Contains a user-defined hire source       HR511   PA02.1
                       code that identifies the source from      PA100   PA102
                       which the employee was acquired. This     PA502   PA52.1
                       field is validated in the Human Resource  PA52.3  PA52.4
                       Code file.                                PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-SECURITY-CODE      Alpha 10                                  HR11.1  HR11.2
Element: Badge Code    Contains a user-defined badge code        HR511   PA02.1
                       assigned to the employee. This field is   PA100   PA102
                       not associated with Lawson user           PA502   PA52.1
                       security.                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-SECURITY-NBR       Alpha 10                                  HR11.1  HR11.2
Element: Badge Number  Contains an internal security number      HR511   PA02.1
                       that is assigned to the employee. This    PA100   PA102
                       field is not associated with Lawson user  PA502   PA52.1
                       security.                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-BARGAIN-UNIT       Alpha 10                                  HR11.1  HR11.2
Element: Bargaining UniContains a user-defined code that         HR511   PA02.1
                       represents the employee's union           PA100   PA102
                       bargaining unit.                          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

PEM-CLOCK-NBR          Alpha 10                                  HR11.1  HR11.2
Element: Clock Number  Contains the employee's clock number.     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

PEM-MAIL-GROUP         Alpha 10                                  HR11.1  HR11.2
Element: Mail Group    Contains a user-defined code that         HR511   PA02.1
                       identifies the mail group to which an     PA100   PA102
                       employee belongs.                         PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-MB-NBR             Alpha 10                                  HR11.1  HR11.2
Element: Mail Box NumbeContains the employee's mail box number.  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

PEM-DRAFT-STATUS       Alpha 3                                   HR11.1  HR11.2
Bill of Exchange       Contains a user-defined code that         HR511   PA02.1
Status                 identifies the employee's draft status.   PA100   PA102
                                                                 PA14.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-FINAL-RANK         Alpha 3                                   HR11.1  HR11.2
Element: Final MilitaryIdentifies the highest military rank      HR511   PA02.1
                       attained by the employee.                 PA100   PA102
                                                                 PA14.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-CUR-STATUS         Alpha 2                                   HR11.1  HR11.2
Element: Current StatusIndicates if the employee is currently    HR511   PA02.1
                       in the Reserves or National Guard.        PA100   PA102
                       NG = National Guard                       PA14.1  PA502
                       RE = Reserves                             PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-LAST-PHYSICAL      Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Last Physical Contains the date of the employee's       HR511   PA02.1
                       last physical exam.                       PA100   PA102
                                                                 PA15.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-PHY-SCHD           Alpha 2                                   HR11.1  HR11.2
Element: Physical SchedContains the frequency of the             HR511   PA02.1
                       employee's physical examinations.         PA100   PA102
                       2Y = 2 years                              PA15.1  PA502
                       3Y = 3 years                              PA52.1  PA52.3
                       4Y = 4 years                              PA52.4  PA52.5
                       5Y = 5 years                              PR110   PR113
                       6Y = 6 years                              PR120   PR13.1
                       7Y = 7 years                              PR13.5  PR13.6
                       8Y = 8 years                              PR13.8
                       9Y = 9 years
                       AN = Annual
                       MO = Monthly
                       QT = Quarterly
                       SA = Semi-annual

PEM-NEXT-PHYSICAL      Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Next Physical Contains the date of the employee's       HR511   PA02.1
                       next scheduled physical exam.             PA100   PA102
                                                                 PA15.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-HEIGHT-FT          Numeric 2                                 HR11.1  HR11.2
Element: Height - Feet Contains the employee's height in feet.   HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA15.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-HEIGHT-IN          Numeric 2                                 HR11.1  HR11.2
Element: Height - IncheContains the employee's height in         HR511   PA02.1
                       inches.                                   PA100   PA102
                       01                                        PA15.1  PA502
                       11                                        PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-WGHT               Signed 5.2                                HR11.1  HR11.2
Element: Weight        Contains the employee's weight.           HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA15.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-BLOOD-TYPE         Alpha 3                                   HR11.1  HR11.2
Element: Blood Type    Contains the employee's blood type.       HR511   PA02.1
                       A+                                        PA100   PA102
                       A-                                        PA15.1  PA502
                       AB+                                       PA52.1  PA52.3
                       AB-                                       PA52.4  PA52.5
                       B+                                        PR110   PR113
                       B-                                        PR120   PR13.1
                       O+                                        PR13.5  PR13.6
                       O-                                        PR13.8

PEM-PARKING-LOT        Alpha 10                                  HR11.1  HR11.2
Element: Parking Lot CoContains a user-defined code that         HR511   PA02.1
                       represents the employee's assigned        PA100   PA102
                       parking lot.                              PA17.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-PARKING-SPACE      Alpha 10                                  HR11.1  HR11.2
Element: Parking Space Identifies the parking space assigned     HR511   PA02.1
                       to the employee.                          PA100   PA102
                                                                 PA17.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-DR-LICENSE         Alpha 20                                  HR11.1  HR11.2
Driver License         Contains the employee's driver's          HR511   PA02.1
Number                 license number.                           PA100   PA102
                                                                 PA17.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-DR-LIC-ST          Alpha 2                                   HR11.1  HR11.2
Element: Driver LicenseContains the abbreviation of the state    HR511   PA02.1
                       that issued the employee's driver's       PA100   PA102
                       license.                                  PA17.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-EXP-DATE           Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Expiration    Contains the expiration date of the       HR511   PA02.1
                       employee's driver's license.              PA100   PA102
                                                                 PA17.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-DR-LIC-CLASS       Alpha 3                                   HR11.1  HR11.2
Element: Driver LicenseContains the class of the employee's      HR511   PA02.1
                       driver's license.                         PA100   PA102
                                                                 PA17.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-REV-SCHEDULE       Alpha 2                                   HR11.1  HR11.2
Element: Review SchedulIdentifies the frequency of performance   HR511   PA02.1
                       reviews for the employee.                 PA100   PA102
                       AN = Annual                               PA26.1  PA502
                       MO = Monthly                              PA52.1  PA52.3
                       QT = Quarterly                            PA52.4  PA52.5
                       SA = Semi-annual                          PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-NEXT-REVIEW        Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Next Review DaContains the next scheduled performance   HR511   PA02.1
                       review date for the employee.             PA100   PA102
                                                                 PA26.1  PA345
                                                                 PA370   PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-NEXT-REV-CODE      Alpha 10                                  HR11.1  HR11.2
Element: Next Review CoIdentifies the review type for the next   HR511   PA02.1
                       scheduled review date (for example,       PA100   PA102
                       salary review).                           PA26.1  PA345
                                                                 PA370   PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-LAST-REVIEW        Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Last Review DaContains the date of the employee's       HR511   PA02.1
                       last review.                              PA100   PA102
                                                                 PA26.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-LAST-MIL-SEQ       Numeric 4                                 HR11.1  HR11.2
Last Military          Contains the last sequence number used    HR511   PA02.1
Sequence Number        to store a military record.               PA100   PA102
                                                                 PA14.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-LAST-REV-SEQ       Numeric 4                                 HR11.1  HR11.2
Last Review            Contains the last sequence number used    HR511   PA02.1
Sequence Number        to store a review record.                 PA100   PA102
                                                                 PA26.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-LAST-COM-SEQ       Numeric 4                                 BN90.1  HR11.1
Last Comment           Contains the last sequence number used    HR11.2  HR511
Sequence Number        to store a comment record.                HR90.1  HR90.2
                                                                 PA02.1  PA100
                                                                 PA102   PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-LAST-INT-SEQ       Numeric 4                                 HR11.1  HR11.2
Last Interview         Contains the last sequence number used    HR511   PA02.1
Sequence Number        to store an interview record.             PA100   PA102
                                                                 PA41.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-LAST-BNF-SEQ       Numeric 4                                 BN47.1  BN547
Last Beneficiary       Contains the last sequence number used    HR11.1  HR11.2
Sequence Nbr           to store a beneficiary record.            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

PEM-LAST-INV-NBR       Numeric 4                                 BN180   BN80.1
Element: Last Invoice NContains the last sequence number used    HR11.1  HR11.2
                       to store an invoice record.               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

PEM-LAST-EPC-SEQ       Numeric 4                                 HR11.1  HR11.2
Last Emp Code          Contains the last sequence number used    HR511   PA02.1
Sequence Number        to store HR codes for an employee.        PA100   PA102
                                                                 PA16.1  PA20.1
                                                                 PA21.1  PA22.1
                                                                 PA24.1  PA27.1
                                                                 PA34.1  PA35.1
                                                                 PA36.1  PA38.1
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA520
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  TR21.1
                                                                 TR22.1  TR26.1
                                                                 TR500

PEM-FNCTN-GROUP        Numeric 2                                 HR11.1  HR11.2
Element: EEO-4 Group   Identifies for the EEO-4 report,  the     HR511   PA02.1
                       type of work the employee does.           PA100   PA102
                       01                                        PA502   PA52.1
                       15                                        PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-EXCLUDE-FLAG       Alpha 1                                   HR11.1  HR11.2
Element: Exclude From EDetermines if an employee is included     HR511   PA02.1
                       in the EEO-4 report.                      PA100   PA102
                       N = Include on EEO-4 Report               PA502   PA52.1
                       Y = Exclude from EEO-4 Report             PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-NBR-HL-DEP         Numeric 3                                 HR11.1  HR11.2
Element: Health DependeContains the number of dependents         HR13.1  HR511
                       covered by the employee's health          HR513   PA02.1
                       insurance.                                PA100   PA102
                                                                 PA218   PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-NBR-DN-DEP         Numeric 3                                 HR11.1  HR11.2
Element: Dental DependeContains the number of dependents         HR13.1  HR511
                       covered by the employee's dental          HR513   PA02.1
                       insurance.                                PA100   PA102
                                                                 PA218   PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-LIFE-STYLE-CR      Numeric 2                                 HR11.1  HR11.2
Element: Life Style Cr Contains the number of credits given      HR511   PA02.1
                       for a healthy lifestyle. This is used to  PA100   PA102
                       calculate flex credits.                   PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-HL-COV-PROOF       Alpha 1                                   HR11.1  HR11.2
Element: Spouse Health Indicates if there is proof that the      HR511   PA02.1
                       employee is covered by health insurance   PA100   PA102
                       outside the company.                      PA502   PA52.1
                       N = No                                    PA52.3  PA52.4
                       Y = Yes                                   PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-DN-COV-PROOF       Alpha 1                                   HR11.1  HR11.2
Element: Spouse Dental Indicates if there is proof that the      HR511   PA02.1
                       employee is covered by dental insurance   PA100   PA102
                       outside the company.                      PA502   PA52.1
                       N = No                                    PA52.3  PA52.4
                       Y = Yes                                   PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-HL-VERIFY-DT       Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Spouse Health Plan     Contains the date outside health          HR511   PA02.1
Verify Date            coverage was verified.                    PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-DN-VERIFY-DT       Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Spouse Dental Plan     Contains the date outside dental          HR511   PA02.1
Verify Date            coverage was verified.                    PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-SPOUSE-EMP         Alpha 30  (Lower Case)                    HR11.1  HR11.2
Element: Spouse EmployeContains the name of the employee's       HR511   PA02.1
                       spouse's employer.                        PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

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

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

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

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

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

PEM-SP-EMP-STATE       Alpha 2                                   HR11.1  HR11.2
Spouse Employer        Contains the state of the spouse's        HR511   PA02.1
State/Province         employer's address.                       PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-SP-EMP-ZIP         Alpha 10                                  HR11.1  HR11.2
Spouse Employer        Contains the postal code of the           HR511   PA02.1
Postal Code            spouse's employer's address.              PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-SP-EMP-COUNTRY     Alpha 2                                   HR11.1  HR11.2
Element: Sp Emp CountryContains country of spouse's employer'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

PEM-SP-EMP-PH-CNTR     Alpha 6                                   HR11.1  HR11.2
Element: Sp Emp Ph CntrContains the country code of the          HR511   PA02.1
                       spouse's employer's telephone number.     PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-SP-EMP-PH-NBR      Alpha 15                                  HR11.1  HR11.2
Element: Sp Emp Ph Nbr Contains the spouse's employer's          HR511   PA02.1
                       telephone number.                         PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-OWNER-FLAG         Alpha 1                                   HR11.1  HR11.2
Element: Owner         Identifies owners of the company.         HR511   PA02.1
                       N = No                                    PA100   PA102
                       Y = Yes                                   PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-KEY-EMP-FLAG       Alpha 1                                   HR11.1  HR11.2
Element: Key Employee  Identifies key employees of the           HR511   PA02.1
                       company.                                  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

PEM-OFFICER            Alpha 1                                   HR11.1  HR11.2
Element: Officer       Identifies officers of the company.       HR511   PA02.1
                       N = No                                    PA100   PA102
                       Y = Yes                                   PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-HIGH-COMP          Alpha 1                                   HR11.1  HR11.2
Element: Highly CompensIdentifies highly compensated employees   HR511   PA02.1
                       for non-discrimination testing in the     PA100   PA102
                       Lawson Benefits System.                   PA502   PA52.1
                       N = No                                    PA52.3  PA52.4
                       Y = Yes                                   PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-SMOKER             Alpha 1                                   HR11.1  HR11.2
Element: Smoker        Indicates if an employee is a smoker.     HR511   PA02.1
                       The Lawson Benefits system uses this      PA100   PA102
                       information when calculating employee     PA502   PA52.1
                       life and disability insurance premiums.   PA52.3  PA52.4
                       N = No                                    PA52.5  PR110
                       Y = Yes                                   PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-I9-STATUS          Alpha 10                                  HR11.1  HR11.2
Element: Eligibility StIdentifies the employee's immigration     HR511   PA02.1
                       status.                                   PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-I9-ALIEN-NBR       Alpha 11                                  HR11.1  HR11.2
Element: Alien Number  Contains the employee's alien number.     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

PEM-I9-ADMIT-NBR       Alpha 13                                  HR11.1  HR11.2
Element: Admission NumbContains the employee's admission         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

PEM-I9-STA-EXP-DT      Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Expiration DatContains the expiration date of the       HR511   PA02.1
                       employee's work authorization status.     PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-I9-DOC-NBR         Alpha 20 Occurs 2 Times                   HR11.1  HR11.2
Element: Document NumbeContains the document identification      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

PEM-I9-DOC-TYPE        Alpha 10 Occurs 2 Times                   HR11.1  HR11.2
Element: Document Type Identifies the type of document entered.  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

PEM-I9-DOC-EXP-DT      Numeric 8  (yyyymmdd) Occurs 2 Times      HR11.1  HR11.2
Document Expiration    Contains the expiration date of the       HR511   PA02.1
Date                   document.                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-I9-AUTHORIZE       Alpha 30  (Lower Case)                    HR11.1  HR11.2
Element: Authorization Identifies the person who examined the    HR511   PA02.1
                       evidence or documents establishing the    PA100   PA102
                       employee's identity and employment        PA502   PA52.1
                       eligibility.                              PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-TRUE-MAR-STAT      Alpha 1                                   HR11.1  HR11.2
Element: True Marital SContains the employee's true marital      HR511   PA02.1
                       status.                                   PA100   PA102
                       D = Divorced                              PA502   PA52.1
                       M = Married                               PA52.3  PA52.4
                       S = Single                                PA52.5  PR110
                       W = Widowed                               PR113   PR120
                       L = Legally Separated                     PR13.1  PR13.5
                       O = Significant Other                     PR13.6  PR13.8
                       P = Domestic Partner
                       C = Common Law

PEM-LAST-PAE-SEQ       Numeric 4                                 HR11.1  HR11.2
Element: Last Pae Seq  Contains the last number used to store    HR511   PA02.1
                       an emergency contact record for the       PA100   PA102
                       employee.                                 PA12.1  PA502
                                                                 PA512   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-PRIMARY-CARE       Alpha 10                                  HR11.1  HR11.2
Primary Care           Contains the code that represents the     HR511   PA02.1
Physician              employee's primary care physician.        PA100   PA102
                                                                 PA15.1  PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEM-FAMILY-AGG         Numeric 9                                 HR11.1  HR11.2
Element: Family Agg    Contains the number of the employee       HR511   PA02.1
                       defined as the family aggregate           PA100   PA102
                       employee.                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-BEN-SALARY-1       Signed 11.2                               HR11.1  HR11.2
Element: Benefit SalaryContains optional user-defined benefit    HR511   PA02.1
                       salary information.                       PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-BEN-SALARY-2       Signed 11.2                               HR11.1  HR11.2
Element: Benefit SalaryContains optional user-defined benefit    HR511   PA02.1
                       salary information.                       PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-BEN-SALARY-3       Signed 11.2                               HR11.1  HR11.2
Element: Benefit SalaryContains optional user-defined benefit    HR511   PA02.1
                       salary information.                       PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-BEN-SALARY-4       Signed 11.2                               HR11.1  HR11.2
Element: Benefit SalaryContains optional user-defined benefit    HR511   PA02.1
                       salary information.                       PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-BEN-SALARY-5       Signed 11.2                               HR11.1  HR11.2
Element: Benefit SalaryContains optional user-defined benefit    HR511   PA02.1
                       salary information.                       PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-BEN-DATE-1         Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Ben Date 1    Contains an optional user-defined         HR511   PA02.1
                       benefit date.                             PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-BEN-DATE-2         Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Ben Date 2    Contains an optional user-defined         HR511   PA02.1
                       benefit date.                             PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-BEN-DATE-3         Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Ben Date 3    Contains an optional user-defined         HR511   PA02.1
                       benefit date.                             PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-BEN-DATE-4         Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Ben Date 4    Contains an optional user-defined         HR511   PA02.1
                       benefit date.                             PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-BEN-DATE-5         Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Ben Date 5    Contains an optional user-defined         HR511   PA02.1
                       benefit date.                             PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-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

PEM-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

PEM-CUR-AGE            Derived
Element: Age

PEM-SEX-1              Derived
Element: Gender

PEM-EEO-CLASS-1        Derived
Element: Eeo Class 1

PEM-WORK-ZIP           Alpha 10                                  HR11.1  HR11.2
Element: Work Zip      Contains the employee's work postal       HR511   PA02.1
                       code.                                     PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-HEIGHT-UNIT        Alpha 1                                   PA15.1
Element: Height Unit   Contains unit in which height is
                       recorded.
                       1 = Feet
                       2 = Meters

PEM-WGHT-UNIT          Alpha 1                                   PA15.1
Element: Wght Unit     Contains unit in which the employee's
                       weight is recorded.
                       1 = Pounds
                       2 = Stones
                       3 = Kilograms

PEM-LANGUAGE-CODE      Alpha 10                                  HR11.1  HR11.2
Element: Language Code Contains employee's language if other     HR511   PA02.1
                       than company's primary language.          PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-RELIGION           Alpha 10                                  HR11.1  HR11.2
Element: Religion      Contains employee's religion.             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

PEM-DISABILITY         Alpha 10                                  HR11.1  HR11.2
Element: Disability    Contains type of disability.              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

PEM-SUPP-PHONE-CNT     Alpha 6                                   HR11.1  HR11.2
Element: Supp Phone CntContains phone country of supplemental    HR511   PA02.1
                       phone number.                             PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-SUPP-PHONE-NBR     Alpha 15                                  HR11.1  HR11.2
Element: Supp Phone NbrContains supplemental phone number.       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

PEM-CONSENT            Alpha 1                                   HR11.1  HR11.2
Element: Consent       N = No                                    HR511   PA02.1
                       Y = Yes                                   PA100   PA102
                       " " = No                                  PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-ABORIGINAL         Alpha 1                                   HR11.1  HR11.2
Element: Aboriginal    Designates if an employee is Aboriginal.  HR511   PA02.1
                       N = No                                    PA100   PA102
                       Y = Yes                                   PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-VISIBLE-MIN        Alpha 1                                   HR11.1  HR11.2
Element: Visible Min   Designates if an employee is a visible    HR511   PA02.1
                       minority.                                 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

PEM-RELATED-EMP        Alpha 1                                   HR11.1  HR11.2
Element: Related Emp   Determines whether or not an employee is  HR511   PA02.1
                       related to the employer.                  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

PEM-I9-DOC-DESCR       Alpha 10 Occurs 2 Times                   HR11.1  HR11.2
Element: I9 Doc Descr                                            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

PEM-BILINGUAL          Alpha 1                                   PA96.1
Element: Bilingual     N = No
                       Y = Yes

PEM-SUPP-COUNTY        Alpha 25  (Lower Case)                    HR11.1  HR11.2
Element: County                                                  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

PEM-STOCK-TRADE        Alpha 1                                   HR11.1  HR11.2
Element: Stock Trade   " " = Not applicable                      HR511   PA02.1
                       1 = Insider                               PA100   PA102
                       2 = SEC Restricted                        PA502   PA52.1
                       3 = Insider & SEC Restricted              PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-DATE-ASSIGN        Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Date Assign                                             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

PEM-USER-AMOUNT        Signed 13.4                               HR11.1  HR11.2
Element: User Amount                                             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

PEM-ESTAB-PATIENT      Numeric 1                                 HR11.1  HR11.2
Element: Estab Patient 1 = No                                    HR511   PA02.1
                       2 = Yes                                   PA100   PA102
                       3 = Unknown                               PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEM-PRIOR-COV-MO       Numeric 2                                 HR11.1  HR11.2
Element: Prior Cov Mo                                            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

                         PAEMPLOYEE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PEMSET1   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
                                                                 BN104   BN105
                                                                 BN106   BN137
                                                                 BN138   BN140
                                                                 BN141   BN145
                                                                 BN150   BN175
                                                                 BN180   BN230
                                                                 BN231   BN232
                                                                 BN233   BN234
                                                                 BN236   BN237
                                                                 BN238   BN240
                                                                 BN242   BN245
                                                                 BN246   BN248
                                                                 BN258   BN285
                                                                 ...

                         PAEMPLOYEE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Badge Code     PCODES       Required
                            When PEM-SECURITY-CODE != Spaces

                            "SC"                 -> PCO-TYPE
                            PEM-SECURITY-CODE    -> PCO-CODE

Bargain Unit   PCODES       Required
                            When PEM-BARGAIN-UNIT != Spaces

                            "BU"                 -> PCO-TYPE
                            PEM-BARGAIN-UNIT     -> PCO-CODE

Company        PRSYSTEM     Required

                            PEM-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Disability     PCODES       Required
                            When PEM-DISABILITY != Spaces

                            "DI"                 -> PCO-TYPE
                            PEM-DISABILITY       -> PCO-CODE

Employee       EMPLOYEE     Required

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

Ethnicity      HRCTRYCODE   Required
                            When PEM-EEO-CLASS != Spaces

                            "ET"                 -> CTC-TYPE
                            EMP-WORK-COUNTRY     -> CTC-COUNTRY-CODE
                            PEM-EEO-CLASS        -> CTC-HRCTRY-CODE

Family Agg     EMPLOYEE     Required
                            When PEM-FAMILY-AGG != Zeroes

                            PEM-COMPANY          -> EMP-COMPANY
                            PEM-FAMILY-AGG       -> EMP-EMPLOYEE

Hire Source    PCODES       Required
                            When PEM-HIRE-SOURCE != Spaces

                            "HS"                 -> PCO-TYPE
                            PEM-HIRE-SOURCE      -> PCO-CODE

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

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

Mail Group     PCODES       Required
                            When PEM-MAIL-GROUP != Spaces

                            "MG"                 -> PCO-TYPE
                            PEM-MAIL-GROUP       -> PCO-CODE

Primary Care   PCODES       Required
                            When PEM-PRIMARY-CARE != Spaces

                            "PC"                 -> PCO-TYPE
                            PEM-PRIMARY-CARE     -> PCO-CODE

Religion       PCODES       Required
                            When PEM-RELIGION != Spaces

                            "RE"                 -> PCO-TYPE
                            PEM-RELIGION         -> PCO-CODE

Supp Country   INSTCTRYCD   Required
                            When (PEM-SUPP-CNTRY-CD != Spaces )

                            PEM-SUPP-CNTRY-CD    -> INT-COUNTRY-CODE

                         PAEMPLOYEE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accomodation   PAMEDICAL    Delete Restricted

                            PEM-COMPANY          -> PMD-COMPANY
                            PEM-EMPLOYEE         -> PMD-EMPLOYEE
                            "AC"                 -> PMD-TYPE
                                                    PMD-CODE
                                                    PMD-SEQ-NBR

Applicant      APPLICANT

                            PEM-COMPANY          -> APL-COMPANY
                            PEM-EMPLOYEE         -> APL-EMPLOYEE
                                                    APL-APPLICANT

Automobiles    EMPAUTO      Delete Cascades

                            PEM-COMPANY          -> EAT-COMPANY
                            PEM-EMPLOYEE         -> EAT-EMPLOYEE
                                                    EAT-AUTO-NBR

Bn Comments    PACOMMENTS   Delete Cascades

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

Bnempexer      BNEMPEXER

                            PEM-COMPANY          -> BXR-COMPANY
                            PEM-EMPLOYEE         -> BXR-EMPLOYEE
                                                    BXR-OPT-GRANT-NBR
                                                    BXR-STOCK-CTF
                                                    BXR-EXERCISE-DATE
                                                    BXR-SEQ-NBR

Ce Comments    PACOMMENTS   Delete Cascades

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

Certifications EMPCODES     Delete Cascades

                            PEM-COMPANY          -> EPC-COMPANY
                            "CE"                 -> EPC-TYPE
                            Zeroes               -> EPC-EMP-APP
                            PEM-EMPLOYEE         -> EPC-EMPLOYEE
                                                    EPC-CODE
                                                    EPC-SUBJECT
                                                    EPC-SEQ-NBR

Co Property    EMPCODES

                            PEM-COMPANY          -> EPC-COMPANY
                            "CP"                 -> EPC-TYPE
                            Zeroes               -> EPC-EMP-APP
                            PEM-EMPLOYEE         -> EPC-EMPLOYEE
                                                    EPC-CODE
                                                    EPC-SUBJECT
                                                    EPC-SEQ-NBR

Competency     EMPCODES     Delete Cascades

                            PEM-COMPANY          -> EPC-COMPANY
                            Zeroes               -> EPC-EMP-APP
                            PEM-EMPLOYEE         -> EPC-EMPLOYEE
                                                    EPC-TYPE
                                                    EPC-CODE
                                                    EPC-SUBJECT
                                                    EPC-SEQ-NBR

Contract       EMPCODES     Delete Cascades

                            PEM-COMPANY          -> EPC-COMPANY
                            Zeroes               -> EPC-EMP-APP
                            PEM-EMPLOYEE         -> EPC-EMPLOYEE
                            "CN"                 -> EPC-TYPE
                                                    EPC-CODE
                                                    EPC-DATE-ACQUIRED
                                                    EPC-SUBJECT
                                                    EPC-SEQ-NBR

Correspondence HRCORRESP

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

Cp Comments    PACOMMENTS   Delete Cascades

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

Dependents     EMDEPEND     Delete Restricted

                            PEM-COMPANY          -> EMD-COMPANY
                            PEM-EMPLOYEE         -> EMD-EMPLOYEE
                                                    EMD-SEQ-NBR

Dis Action Stp PAGRDISTEP

                            PEM-COMPANY          -> PGI-COMPANY
                            PEM-EMPLOYEE         -> PGI-EMPLOYEE
                            "2 "                 -> PGI-TYPE
                                                    PGI-GRIEV-DIS-NBR
                                                    PGI-EFFECT-DATE
                                                    PGI-SEQ-NBR

Discpl Actions PAGRDI

                            PEM-COMPANY          -> PAG-COMPANY
                            PEM-EMPLOYEE         -> PAG-EMPLOYEE
                            "2 "                 -> PAG-TYPE
                                                    PAG-DATE
                                                    PAG-GRIEV-DIS-NBR

Dp Comments    PACOMMENTS   Delete Cascades

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

Ec Comments    PACOMMENTS   Delete Cascades

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

Ed Comments    PACOMMENTS   Delete Cascades

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

Education      EMPCODES     Delete Cascades

                            PEM-COMPANY          -> EPC-COMPANY
                            "ED"                 -> EPC-TYPE
                            Zeroes               -> EPC-EMP-APP
                            PEM-EMPLOYEE         -> EPC-EMPLOYEE
                                                    EPC-CODE
                                                    EPC-SUBJECT
                                                    EPC-SEQ-NBR

Emerg Contact  PAEMERGCNT   Delete Restricted

                            PEM-COMPANY          -> PAE-COMPANY
                            PEM-EMPLOYEE         -> PAE-EMPLOYEE
                                                    PAE-SEQ-NBR

Ge Comments    PACOMMENTS   Delete Cascades

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

Gmeffort       GMEFFORT

                            PEM-COMPANY          -> EFH-HR-COMPANY
                            PEM-EMPLOYEE         -> EFH-EMPLOYEE
                                                    EFH-BEGIN-DATE
                                                    EFH-END-DATE
                                                    EFH-SEQUENCE-NBR

Gmlabdist      GMLABDIST

                            PEM-COMPANY          -> GML-HR-COMPANY
                            PEM-EMPLOYEE         -> GML-EMPLOYEE
                                                    GML-EFFECT-DATE
                                                    GML-JOB-CODE
                                                    GML-POSITION
                                                    GML-PAY-CODE

Gmretdist      GMRETDIST

                            PEM-COMPANY          -> GMI-HR-COMPANY
                            PEM-EMPLOYEE         -> GMI-EMPLOYEE
                                                    GMI-START-DATE
                                                    GMI-END-DATE
                                                    GMI-JOB-CODE
                                                    GMI-POSITION
                                                    GMI-PAY-CODE
                                                    GMI-SEQUENCE-NBR

Gmtranefrt     GMTRANEFRT

                            PEM-COMPANY          -> GEF-HR-COMPANY
                            PEM-EMPLOYEE         -> GEF-EMPLOYEE
                                                    GEF-ACTIVITY
                                                    GEF-ACCT-CATEGORY
                                                    GEF-COMPANY
                                                    GEF-ACCT-UNIT
                                                    GEF-ACCOUNT
                                                    GEF-SUB-ACCT
                                                    GEF-OBJ-ID

Gri Dis Act St PAGRDISTEP

                            PEM-COMPANY          -> PGI-COMPANY
                            PEM-EMPLOYEE         -> PGI-EMPLOYEE
                            "2 "                 -> PGI-TYPE
                                                    PGI-GRIEV-DIS-NBR
                                                    PGI-EFFECT-DATE
                                                    PGI-SEQ-NBR

Griev Dis Act  PAGRDI

                            PEM-COMPANY          -> PAG-COMPANY
                            PEM-EMPLOYEE         -> PAG-EMPLOYEE
                                                    PAG-TYPE
                                                    PAG-DATE
                                                    PAG-GRIEV-DIS-NBR

Griev Steps    PAGRDISTEP

                            PEM-COMPANY          -> PGI-COMPANY
                            PEM-EMPLOYEE         -> PGI-EMPLOYEE
                            "1 "                 -> PGI-TYPE
                                                    PGI-GRIEV-DIS-NBR
                                                    PGI-EFFECT-DATE
                                                    PGI-SEQ-NBR

Grievances     PAGRDI

                            PEM-COMPANY          -> PAG-COMPANY
                            PEM-EMPLOYEE         -> PAG-EMPLOYEE
                            "1 "                 -> PAG-TYPE
                                                    PAG-DATE
                                                    PAG-GRIEV-DIS-NBR

Hist Err       HISTERR      Delete Cascades

                            PEM-COMPANY          -> HER-COMPANY
                            PEM-EMPLOYEE         -> HER-EMPLOYEE
                                                    HER-OBJ-ID
                                                    HER-EFFECT-DATE
                                                    HER-ACTION-CODE
                                                    HER-ACTION-NBR
                                                    HER-FLD-NBR
                                                    HER-SEQ-NBR

Hr Cont Nbr    HRCONTNBR

                            PEM-COMPANY          -> HCN-COMPANY
                            "1"                  -> HCN-REQ-TYPE
                            PEM-EMPLOYEE         -> HCN-ID-NBR
                            Zeroes               -> HCN-DEPENDENT
                                                    HCN-SEQ-NBR

Incid Followup PAFOLLOWUP   Delete Cascades

                            PEM-COMPANY          -> PAF-COMPANY
                            PEM-EMPLOYEE         -> PAF-EMPLOYEE
                                                    PAF-ESTABLISHMENT
                                                    PAF-INCIDENT-NBR
                                                    PAF-EFFECT-DATE
                                                    PAF-SEQ-NBR

Incident Costs PAINCICOST   Delete Cascades

                            PEM-COMPANY          -> PAI-COMPANY
                            PEM-EMPLOYEE         -> PAI-EMPLOYEE
                                                    PAI-ESTABLISHMENT
                                                    PAI-INCIDENT-NBR
                                                    PAI-EFFECT-DATE
                                                    PAI-SEQ-NBR

Interviews     INTERVIEW    Delete Cascades

                            PEM-COMPANY          -> ITV-COMPANY
                            Zeroes               -> ITV-EMP-APP
                            PEM-EMPLOYEE         -> ITV-APPLICANT
                                                    ITV-SEQ-NBR

Iv Comments    PACOMMENTS   Delete Cascades

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

Job Hist       APPJOBHIST

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

Job Interest   PAJOBINTRS   Delete Cascades

                            PEM-COMPANY          -> PJI-COMPANY
                            Zeroes               -> PJI-EMP-APP
                            PEM-EMPLOYEE         -> PJI-EMPLOYEE
                                                    PJI-JOB-CODE
                                                    PJI-POSITION

Jobauth        JOBAUTH      Delete Cascades

                            PEM-COMPANY          -> JBA-COMPANY
                            Zeroes               -> JBA-EMP-APP
                            PEM-EMPLOYEE         -> JBA-EMPLOYEE
                                                    JBA-JOB-CODE
                                                    JBA-POSITION

Md Comments    PACOMMENTS   Delete Cascades

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

Medical Codes  PAMEDICAL    Delete Restricted

                            PEM-COMPANY          -> PMD-COMPANY
                            PEM-EMPLOYEE         -> PMD-EMPLOYEE
                            "EM"                 -> PMD-TYPE
                                                    PMD-CODE
                                                    PMD-SEQ-NBR

Mi Comments    PACOMMENTS   Delete Cascades

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

Military       MILITARY     Delete Cascades

                            PEM-COMPANY          -> MIL-COMPANY
                            Zeroes               -> MIL-EMP-APP
                            PEM-EMPLOYEE         -> MIL-EMPLOYEE
                                                    MIL-BR-SERVICE
                                                    MIL-SEQ-NBR

Off Lang       PAOFFLANG

                            PEM-COMPANY          -> PLA-COMPANY
                            PEM-EMPLOYEE         -> PLA-EMPLOYEE
                            Spaces               -> PLA-POSITION
                                                    PLA-REPORT-TYPE
                                                    PLA-SEQ-NBR

Os Comments    PACOMMENTS   Delete Cascades

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

Osha           OSHA         Delete Cascades

                            PEM-COMPANY          -> OSH-COMPANY
                            PEM-EMPLOYEE         -> OSH-EMPLOYEE
                                                    OSH-ESTABLISHMENT
                                                    OSH-SEQ-NBR

Pa Benefits    EMPCODES     Delete Cascades

                            PEM-COMPANY          -> EPC-COMPANY
                            "BN"                 -> EPC-TYPE
                            Zeroes               -> EPC-EMP-APP
                            PEM-EMPLOYEE         -> EPC-EMPLOYEE
                                                    EPC-CODE
                                                    EPC-SUBJECT
                                                    EPC-SEQ-NBR

Pa Comments    PACOMMENTS   Delete Cascades

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

Paencumber     PAENCUMBER   Delete Restricted

                            PEM-COMPANY          -> PEN-COMPANY
                            PEM-EMPLOYEE         -> PEN-EMPLOYEE
                                                    PEN-POSITION
                                                    PEN-PROCESS-LEVEL
                                                    PEN-DEPARTMENT
                                                    PEN-JOB-CODE
                                                    PEN-GLT-OBJ-ID
                                                    PEN-ATN-OBJ-ID

Painstruct     PAINSTRUCT

                            PEM-COMPANY          -> INS-COMPANY
                            PEM-EMPLOYEE         -> INS-EMPLOYEE
                                                    INS-LAST-NAME
                                                    INS-FIRST-NAME
                                                    INS-MIDDLE-INIT
                                                    INS-INSTRUCT

Pending Action PERSACTION

                            PEM-COMPANY          -> PCT-COMPANY
                            PEM-EMPLOYEE         -> PCT-EMPLOYEE
                                                    PCT-ACTION-TYPE
                                                    PCT-ACTION-CODE
                                                    PCT-EFFECT-DATE
                                                    PCT-ACTION-NBR

Registrations  PAREGISTER

                            PEM-COMPANY          -> REG-COMPANY
                            PEM-EMPLOYEE         -> REG-EMPLOYEE
                                                    REG-COURSE
                                                    REG-SESSION
                                                    REG-START-DATE

Relocation     EMPCODES

                            PEM-COMPANY          -> EPC-COMPANY
                            "RL"                 -> EPC-TYPE
                            Zeroes               -> EPC-EMP-APP
                            PEM-EMPLOYEE         -> EPC-EMPLOYEE
                                                    EPC-CODE
                                                    EPC-SUBJECT
                                                    EPC-SEQ-NBR

Requisitions   PAREQAPP     Delete Cascades

                            PEM-COMPANY          -> PRA-COMPANY
                            Zeroes               -> PRA-EMP-APP
                            PEM-EMPLOYEE         -> PRA-APPLICANT
                                                    PRA-REQUISITION

Reviews        REVIEW       Delete Cascades

                            PEM-COMPANY          -> REV-COMPANY
                            PEM-EMPLOYEE         -> REV-EMPLOYEE
                                                    REV-SCHED-DATE
                                                    REV-CODE

Rl Comments    PACOMMENTS   Delete Cascades

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

Rv Comments    PACOMMENTS   Delete Cascades

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

Sk Comments    PACOMMENTS   Delete Cascades

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

Stockgrnt      BNEMPGRNT

                            PEM-COMPANY          -> BEG-COMPANY
                            PEM-EMPLOYEE         -> BEG-EMPLOYEE
                                                    BEG-OPT-GRANT-NBR
                                                    BEG-STOCK-CTF

Test Exception PATESTOVER

                            PEM-COMPANY          -> PAV-COMPANY
                            PEM-EMPLOYEE         -> PAV-EMPLOYEE
                                                    PAV-TEST

Tracks         PAEMPTRACK   Delete Cascades

                            PEM-COMPANY          -> ETR-COMPANY
                            PEM-EMPLOYEE         -> ETR-EMPLOYEE
                                                    ETR-TYPE
                                                    ETR-TRACK

Train Costs    PAEMPCOSTS   Delete Cascades

                            PEM-COMPANY          -> EMC-COMPANY
                            PEM-EMPLOYEE         -> EMC-EMPLOYEE
                                                    EMC-COURSE
                                                    EMC-DATE
                                                    EMC-COST-TYPE
                                                    EMC-COST-CAT

Training       PATRNHIST    Delete Cascades

                            PEM-COMPANY          -> TRH-COMPANY
                            PEM-EMPLOYEE         -> TRH-EMPLOYEE
                                                    TRH-COURSE
                                                    TRH-DATE-COMPLETED

Tv Comments    PACOMMENTS   Delete Cascades

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

Visas          EMPVISA      Delete Cascades

                            PEM-COMPANY          -> EMV-COMPANY
                            PEM-EMPLOYEE         -> EMV-EMPLOYEE
                                                    EMV-DEPENDENT
                                                    EMV-SEQ-NBR

Work Restrict  PAMEDICAL    Delete Restricted

                            PEM-COMPANY          -> PMD-COMPANY
                            PEM-EMPLOYEE         -> PMD-EMPLOYEE
                            "WR"                 -> PMD-TYPE
                                                    PMD-CODE
                                                    PMD-SEQ-NBR

Wr Comments    PACOMMENTS   Delete Cascades

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