Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAEMPPOS


                             PAEMPPOS FILE

                      Employee Multiple Pos, Jobs

Contains the positions and jobs to which an employee is assigned.

The employee's current levels are indicated by a blank ending date. All other
records in the file represent position, job history.

REFERENCED BY

HC01.1    HC02.1    HCEM.1    HCOP.1    HCOP.2    HR217
PA06.1    PA149     PA218     PA272     PR128     HR155
HR170     HR55.2    HR70.1    PA111     PA16.1    PA20.1
PA21.1    PA213     PA22.1    PA24.1    PA249     PA27.1
PA34.1    PA35.1    PA36.1    PA38.1    PA406     PA49.1
PA49.3    PA520     PA549     PA66.3    PA95.1    TR21.1
TR22.1    TR26.1    TR500     PR216     AC541     AC542
BN150     PA311     PA496     PA53.1    PR130     PR131
PR132     PR134     PR136     PR189     PR29.1    PR32.2
PR33.2    PR33.3    PR35.1    PR35.2    PR35.3    PR35.4
PR35.5    PR35.6    PR35.8    PR36.1    PR45.1    PR529
PR530     PR560     PR80.1    PR82.1    UK102     UK560
TA147     UK120     PA201     PA211     PA302     PA402
AC550     AC551

UPDATED BY

HGLM.1    HPOS.1    HPQC.1    HPRS.1    HR11.1    HR11.2
HR15.1    HR511     HR515     HR54.1    HR650     HRS1.1
HRSC.1    PA02.1    PA100     PA102     PA113     PA13.1
PA13.2    PA313     PA502     PA513     PA52.1    PA52.3
PA52.4    PA52.5    PA54.1    PR110     PR113     PR120
PR13.1    PR13.5    PR13.6    PR13.8    PRSC.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PEP-COMPANY            Numeric 4                                 HR11.1  HR11.2
Element: Company       Contains the number that represents an    HR511   HR650
                       established company and is entered on     PA02.1  PA100
                       all functions.                            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

PEP-EMPLOYEE           Numeric 9                                 HR11.1  HR11.2
Element: Employee      Contains the employee number. An          HR511   HR650
                       employee number is assigned to each       PA02.1  PA100
                       person employed by the company. The       PA102   PA13.1
                       system uses the employee number to        PA13.2  PA502
                       correlate all information related to the  PA513   PA52.1
                       employee.                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEP-POSITION           Alpha 12                                  HGLM.1  HPOS.1
Element: Position      Contains the user-defined code that       HPQC.1  HPRS.1
                       represents a position in the company.     HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-POS-LEVEL          Numeric 2                                 HR11.1  HR11.2
Element: Pos Level     Contains the position level. Indicates    HR511   HR650
                       if this level is the first, second, or    PA02.1  PA100
                       third level for the employee.             PA102   PA13.1
                       01 = Level 1                              PA13.2  PA502
                       02 = Level 2                              PA513   PA52.1
                       03 = Level 3                              PA52.3  PA52.4
                       04 = Level 4                              PA52.5  PR110
                       05 = Level 5                              PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEP-FTE                Signed 8.3                                HGLM.1  HPOS.1
Element: Fte           Contains the level's FTE.                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-EFFECT-DATE        Numeric 8  (yyyymmdd)                     HGLM.1  HPOS.1
Element: Date          Contains the effective date for the       HPQC.1  HPRS.1
                       level.                                    HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-END-DATE           Numeric 8  (yyyymmdd)                     HGLM.1  HPOS.1
Element: Date          Contains the employee's ending date in    HPQC.1  HPRS.1
                       this level.                               HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-JOB-CODE           Alpha 9                                   HGLM.1  HPOS.1
Element: Job Code      Contains a user-defined code that         HPQC.1  HPRS.1
                       represents a type of job.                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-PROCESS-LEVEL      Alpha 5                                   HGLM.1  HPOS.1
Element: Process Level This field contains the process level,    HPQC.1  HPRS.1
                       which is the reporting hierarchy below    HR11.1  HR11.2
                       company.                                  HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-DEPARTMENT         Alpha 5                                   HGLM.1  HPOS.1
Element: Department    Contains the department.                  HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-PAY-RATE           Signed 13.4                               HGLM.1  HPOS.1
Element: Rate of Pay   Contains the level's rate of pay.         HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-USER-LEVEL         Alpha 10                                  HGLM.1  HPOS.1
Element: User Level    Contains the level's user level.          HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-LOCAT-CODE         Alpha 10                                  HGLM.1  HPOS.1
Element: Location      Contains the level's location.            HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-SUPERVISOR         Alpha 10                                  HGLM.1  HPOS.1
Element: Supervisor    Contains the level's supervisor.          HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-SUPERVISOR-IND     Alpha 10                                  HGLM.1  HPOS.1
Element: Supervisor IndContains the level's indirect             HPQC.1  HPRS.1
                       supervisor.                               HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-UNION-CODE         Alpha 10                                  HGLM.1  HPOS.1
Element: Union Code    Contains the union code for this level.   HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-WORK-SCHED         Alpha 10                                  HGLM.1  HPOS.1
Element: Work Schedule Contains the work schedule for this       HPQC.1  HPRS.1
                       level.                                    HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-SHIFT              Numeric 1                                 HGLM.1  HPOS.1
Element: Shift         Contains the shift number associated      HPQC.1  HPRS.1
                       with the level.                           HR11.1  HR11.2
                       1 = Shift 1                               HR15.1  HR511
                       2 = Shift 2                               HR515   HR54.1
                       3 = Shift 3                               HR650   HRS1.1
                       4 = Shift 4                               HRSC.1  PA02.1
                       5 = Shift 5                               PA100   PA102
                       6 = Shift 6                               PA113   PA13.1
                       7 = Shift 7                               PA13.2  PA502
                       8 = Shift 8                               PA513   PA52.1
                       9 = Shift 9                               PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-SCHEDULE           Alpha 9                                   HGLM.1  HPOS.1
Element: Schedule      Contains the grade range or step          HPQC.1  HPRS.1
                       schedule for this level.                  HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-PAY-GRADE          Alpha 3                                   HGLM.1  HPOS.1
Element: Grade         Contains the grade for this level.        HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-PAY-STEP           Numeric 2                                 HGLM.1  HPOS.1
Element: Step          Contains the step for this level.         HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-EXP-COMPANY        Numeric 4                                 HGLM.1  HPOS.1
Element: Exp Company   Contains the gl expense company for       HPQC.1  HPRS.1
                       this  level.                              HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-EXP-ACCT-UNIT      Alpha 15                                  HGLM.1  HPOS.1
Element: Accounting UniContains the gl expense account unit      HPQC.1  HPRS.1
                       for this level.                           HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-EXP-ACCOUNT        Numeric 6                                 HGLM.1  HPOS.1
Element: Account       Contains the gl distribution account      HPQC.1  HPRS.1
                       number for this level.                    HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-EXP-SUB-ACCT       Numeric 4                                 HGLM.1  HPOS.1
Element: Subaccount    Contains the gl distribution expense      HPQC.1  HPRS.1
                       subaccount for this level.                HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-ACTIVITY           Alpha 15                                  HGLM.1  HPOS.1
Element: Activity      Activities are the processes or           HPQC.1  HPRS.1
                       procedures that produce work. Cost        HR11.1  HR11.2
                       objects (products, services, customers,   HR15.1  HR511
                       and so on) are the reasons for            HR515   HR54.1
                       performing the activity.                  HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-ACCT-CATEGORY      Alpha 5                                   HGLM.1  HPOS.1
Element: Account CategoAccount categories are groupings of       HPQC.1  HPRS.1
                       costs, revenues, or a combination of      HR11.1  HR11.2
                       both used for reporting and inquiries     HR15.1  HR511
                       for activities in the Activity            HR515   HR54.1
                       Management system. All transactions are   HR650   HRS1.1
                       posted to an account category within an   HRSC.1  PA02.1
                       activity. You can assign a specific       PA100   PA102
                       General Ledger account or range of        PA113   PA13.1
                       accounts (company, accounting unit,       PA13.2  PA502
                       account, and subaccount) that make up     PA513   PA52.1
                       the transactions posted to an account     PA52.3  PA52.4
                       category using AC07.1 (Account            PA52.5  PA54.1
                       Assignment).                              PR110   PR113
                                                                 PR120   PR13.1
                       Period-to-date, year-to-date, and         PR13.5  PR13.6
                       life-to-date balances are maintained by   PR13.8  PRSC.1
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

PEP-POS-EFF-DT         Numeric 8  (yyyymmdd)                     HGLM.1  HPOS.1
Element: Pos Eff Dt    If this level uses a position, contains   HPQC.1  HPRS.1
                       the effective date of the position end.   HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-ANNUAL-HOURS       Numeric 4                                 HGLM.1  HPOS.1
Element: Annual Hours  Contains the annual hours for this        HPQC.1  HPRS.1
                       level.                                    HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-PRO-RATE-A-SAL     Signed 13.4                               HGLM.1  HPOS.1
Element: Pro Rate A SalContains the prorated salary for this     HPQC.1  HPRS.1
                       level.                                    HR11.1  HR11.2
                                                                 HR15.1  HR511
                       If the employee is salaried, the total    HR515   HR54.1
                       prorated salary is the same as the rate   HR650   HRS1.1
                       of pay.                                   HRSC.1  PA02.1
                                                                 PA100   PA102
                       If the employee is hourly, the total      PA113   PA13.1
                       prorated salary is the sum of the pay     PA13.2  PA502
                       rate times the annual hours times the     PA513   PA52.1
                       FTE for each position level.              PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

PEP-DATE-STAMP         Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Date Stamp    This field contains the server date       HR511   HR650
                       (month, date, and year) of the last       PA02.1  PA100
                       change to this record.                    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

PEP-TIME-STAMP         Numeric 6  (hhmmss)                       HR11.1  HR11.2
Element: Time Stamp    Contains the server time (hour, minute,   HR511   HR650
                       and second) when the record was last      PA02.1  PA100
                       changed.                                  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

PEP-USER-ID            Alpha 10  (Lower Case)                    HR11.1  HR11.2
Element: User                                                    HR511   HR650
                                                                 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

PEP-CURRENCY-CODE      Alpha 5                                   HR11.1  HR11.2
Element: Currency Code Contains the currency for the pay rate    HR511   HR650
                       at this level.                            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

PEP-CURR-ND            Numeric 1                                 HR11.1  HR11.2
Account Currency                                                 HR511   HR650
Code                                                             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

PEP-BASE-CURRENCY      Alpha 5                                   HR11.1  HR11.2
To Company Base        Contains the employee's base currency.    HR511   HR650
Currency                                                         PA02.1  PA100
                       The base currency is the employee's       PA102   PA13.1
                       primary (Level 1) currency as of the      PA13.2  PA502
                       effective date.                           PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEP-BASE-ND            Numeric 1                                 HR11.1  HR11.2
Account Currency                                                 HR511   HR650
Code                                                             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

PEP-BASE-PAY-RATE      Signed 13.4                               HGLM.1  HPOS.1
Element: Base Pay Rate Contains the pay rate for this level as   HPQC.1  HPRS.1
                       translated into the base currency.        HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

                         PAEMPPOS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PEPSET1   COMPANY                                                HC01.1  HC02.1
          EMPLOYEE                                               HCEM.1  HCOP.1
          POS-LEVEL                                              HCOP.2  HGLM.1
          EFFECT-DATE                                            HPOS.1  HPQC.1
                                                                 HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR217   HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA06.1  PA100
                                                                 PA102   PA113
                                                                 PA115   PA13.1
                                                                 PA13.2  PA149
                                                                 PA218   PA272
                                                                 ...

PEPSET2   COMPANY       Subset                                   HC01.1  HC02.1
          EMPLOYEE      Where (END-DATE = Zeroes )               HCEM.1  HCOP.1
          POS-LEVEL                                              HGLM.1  HPOS.1
          EFFECT-DATE                                            HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR170   HR217
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR650   HR70.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA111
                                                                 PA113   PA13.1
                                                                 PA13.2  PA149
                                                                 ...

PEPSET3   COMPANY                                                AC541   AC542
          EMPLOYEE                                               BN150   HC01.1
          POS-LEVEL                                              HC02.1  HCEM.1
          EFFECT-DATE*                                           HCOP.1  HGLM.1
                                                                 HPOS.1  HPQC.1
                                                                 HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR155   HR170
                                                                 HR217   HR511
                                                                 HR515   HR54.1
                                                                 HR55.2  HR650
                                                                 HR70.1  HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 ...

PEPSET4   COMPANY       KeyChange                                PA02.1  PA102
          POSITION                                               PA201   PA211
          EMPLOYEE                                               PA272   PA302
          POS-LEVEL                                              PA402   PA502
          EFFECT-DATE

PEPSET5   COMPANY       KeyChange                                HR511   PA02.1
          EMPLOYEE                                               PA100   PA102
          POSITION                                               PA13.1  PA13.2
          JOB-CODE                                               PA502   PA513
          PROCESS-LEVEL                                          PA52.5  PR110
          DEPARTMENT
          EFFECT-DATE*
          POS-LEVEL

PEPSET6   COMPANY       KeyChange, Subset                        AC541   AC542
          EMPLOYEE      Where (POSITION != Spaces )              AC550   AC551
          POSITION                                               BN150   PR128
          EFFECT-DATE*                                           PR130   PR131
          POS-LEVEL                                              PR132   PR134
                                                                 PR136   PR189
                                                                 PR29.1  PR32.2
                                                                 PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR36.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 ...

PEPSET7   COMPANY       KeyChange, Subset                        AC541   AC542
          EMPLOYEE      Where (POSITION = Spaces )               BN150   PA211
          JOB-CODE                                               PR128   PR130
          PROCESS-LEVEL                                          PR131   PR132
          DEPARTMENT                                             PR134   PR136
          EFFECT-DATE*                                           PR189   PR29.1
          POS-LEVEL                                              PR32.2  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR45.1
                                                                 PR529   PR530
                                                                 PR560   PR80.1
                                                                 PR82.1  UK102
                                                                 ...

                         PAEMPPOS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Cat       ACACCTCAT    Required
                            When (PEP-ACCT-CATEGORY != Spaces )

                            PEP-ACCT-CATEGORY     -> AAX-ACCT-CATEGORY

Activity       ACACTIVITY   Required
                            When (PEP-ACTIVITY != Spaces )

                            PEP-ACTIVITY          -> ACV-ACTIVITY

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

                            PEP-BASE-CURRENCY     -> CUC-CURRENCY-CODE

Company        PRSYSTEM     Required

                            PEP-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

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

                            PEP-CURRENCY-CODE     -> CUC-CURRENCY-CODE

Department     DEPTCODE     Required
                            When (PEP-DEPARTMENT != Spaces )

                            PEP-COMPANY           -> DPT-COMPANY
                            PEP-PROCESS-LEVEL     -> DPT-PROCESS-LEVEL
                            PEP-DEPARTMENT        -> DPT-DEPARTMENT

Exp Account    GLMASTER     Required
                            When (PEP-EXP-ACCT-UNIT != Spaces )
                            Or   (PEP-EXP-ACCOUNT   != Zeroes )

                            PEP-EXP-COMPANY       -> GLM-COMPANY
                            PEP-EXP-ACCT-UNIT     -> GLM-ACCT-UNIT
                            PEP-EXP-ACCOUNT       -> GLM-ACCOUNT
                            PEP-EXP-SUB-ACCT      -> GLM-SUB-ACCOUNT

Jobcode        JOBCODE      Required
                            When (PEP-JOB-CODE != Spaces )

                            PEP-COMPANY           -> JBC-COMPANY
                            PEP-JOB-CODE          -> JBC-JOB-CODE

Locat Code     PCODES       Required
                            When (PEP-LOCAT-CODE != Spaces )

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

Pep Employee   EMPLOYEE     Required

                            PEP-COMPANY           -> EMP-COMPANY
                            PEP-EMPLOYEE          -> EMP-EMPLOYEE

Pos Date       PAPOSITION   Required
                            When (PEP-POSITION != Spaces )

                            PEP-COMPANY           -> POS-COMPANY
                            PEP-POSITION          -> POS-POSITION
                            PEP-POS-EFF-DT        -> POS-EFFECT-DATE

Process Level  PRSYSTEM     Required
                            When (PEP-PROCESS-LEVEL != Spaces )

                            PEP-COMPANY           -> PRS-COMPANY
                            PEP-PROCESS-LEVEL     -> PRS-PROCESS-LEVEL

Supervisor     HRSUPER      Required
                            When (PEP-SUPERVISOR != Spaces )

                            PEP-COMPANY           -> HSU-COMPANY
                            PEP-SUPERVISOR        -> HSU-CODE

Supervisor Ind HRSUPER      Required
                            When (PEP-SUPERVISOR-IND != Spaces )

                            PEP-COMPANY           -> HSU-COMPANY
                            PEP-SUPERVISOR-IND    -> HSU-CODE

Union          PCODES       Required
                            When (PEP-UNION-CODE != Spaces )

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

User Level     PCODES       Required
                            When (PEP-USER-LEVEL != Spaces )

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

Work Sched     PCODES       Required
                            When (PEP-WORK-SCHED != Spaces )

                            "WS"                  -> PCO-TYPE
                            PEP-WORK-SCHED        -> PCO-CODE

                         PAEMPPOS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Grade          PRSAGDTL     Required
                            When (PEP-SCHEDULE  != Spaces )
                            And  (PEP-PAY-GRADE != Spaces )

                            PEP-COMPANY           -> SGD-COMPANY
                            PEP-SCHEDULE          -> SGD-SCHEDULE
                            PEP-PAY-GRADE         -> SGD-PAY-GRADE
                            1                     -> SGD-PAY-STEP
                                                     SGD-EFFECT-DATE

Hrhistory      HRHISTORY

                            PEP-COMPANY           -> HRH-COMPANY
                            PEP-EMPLOYEE          -> HRH-EMPLOYEE
                            Zeroes                -> HRH-OBJ-ID
                                                     HRH-FLD-NBR
                                                     HRH-POS-LEVEL
                                                     HRH-BEG-DATE
                                                     HRH-SEQ-NBR

Pep Audit      PAPEPAUDIT

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

Pos Chg Error  PAPOSERR

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

Position       PAPOSITION

                            PEP-COMPANY           -> POS-COMPANY
                            PEP-POSITION          -> POS-POSITION
                                                     POS-EFFECT-DATE

Schedule       PRSAGHEAD    Required
                            When (PEP-SCHEDULE != Spaces )

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

Step,grade     PRSAGDTL     Required
                            When (PEP-SCHEDULE  != Spaces )
                            And  (PEP-PAY-GRADE != Spaces )
                            And  (PEP-PAY-STEP  != Zeroes )

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