Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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
HRS1.1    HRSC.1    PA06.1    PA149     PA218     PA272
PR128     HR15.1    HR155     HR170     HR54.1    HR55.2
HR70.1    PA111     PA16.1    PA213     PA249     PA406
PA49.1    PA49.3    PA54.1    PA549     PA66.3    TR22.1
TR500     PR216     PA311     PR33.2    PR33.3    PA201
PA211     PA302     PA402     AC541     AC542     AC550
AC551     BN150     PR131     PR132     PR134     PR136
PR32.2    PR35.1    PR35.2    PR35.3    PR35.4    PR35.5
PR35.6    PR35.8    PR36.1    PR530     PR82.1    UK102
UK120

UPDATED BY

HR511     HR650     PA113     PA313     PA502     PA513
PR13.1    PR13.5    PR13.6    PR13.8

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PEP-COMPANY          Numeric 4                                   HR511   HR650
Company              Contains the number that represents an      PA502   PA513
                     established company and is entered on       PR13.1  PR13.5
                     all functions.                              PR13.6  PR13.8

PEP-EMPLOYEE         Numeric 9                                   HR511   HR650
Employee             Contains the employee number. An            PA502   PA513
                     employee number is assigned to each         PR13.1  PR13.5
                     person employed by the company. The         PR13.6  PR13.8
                     system uses the employee number to
                     correlate all information related to the
                     employee.

PEP-POSITION         Alpha 12                                    HR511   HR650
Position             Contains the user-defined code that         PA113   PA502
                     represents a position in the company.       PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-POS-LEVEL        Numeric 2                                   HR511   HR650
Pos Level            Contains the position level. Indicates      PA502   PA513
                     if this level is the first, second, or      PR13.1  PR13.5
                     third level for the employee.               PR13.6  PR13.8
                     01 = Level 1
                     02 = Level 2
                     03 = Level 3
                     04 = Level 4
                     05 = Level 5

PEP-FTE              Signed 8.3                                  HR511   HR650
Fte                  Contains the level's FTE.                   PA113   PA502
                                                                 PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-EFFECT-DATE      Numeric 8  (yyyymmdd)                       HR511   HR650
Effective Date       Contains the effective date for the         PA113   PA502
                     level.                                      PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-END-DATE         Numeric 8  (yyyymmdd)                       HR511   HR650
Ending Date          Contains the employee's ending date in      PA113   PA502
                     this level.                                 PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-JOB-CODE         Alpha 9                                     HR511   HR650
Job Code             Contains a user-defined code that           PA113   PA502
                     represents a type of job.                   PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-PROCESS-LEVEL    Alpha 5                                     HR511   HR650
Process Level        This field contains the process level,      PA113   PA502
                     which is the reporting hierarchy below      PA513   PR13.1
                     company.                                    PR13.5  PR13.6
                                                                 PR13.8

PEP-DEPARTMENT       Alpha 5                                     HR511   HR650
Department           Contains the department.                    PA113   PA502
                                                                 PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-PAY-RATE         Signed 13.4                                 HR511   HR650
Rate of Pay          Contains the level's rate of pay.           PA113   PA502
                                                                 PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-USER-LEVEL       Alpha 10                                    HR511   HR650
User Level           Contains the level's user level.            PA113   PA502
                                                                 PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-LOCAT-CODE       Alpha 10                                    HR511   HR650
Location             Contains the level's location.              PA113   PA502
                                                                 PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-SUPERVISOR       Alpha 10                                    HR511   HR650
Supervisor           Contains the level's supervisor.            PA113   PA502
                                                                 PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-SUPERVISOR-IND   Alpha 10                                    HR511   HR650
Supervisor Ind       Contains the level's indirect               PA113   PA502
                     supervisor.                                 PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-UNION-CODE       Alpha 10                                    HR511   HR650
Union Code           Contains the union code for this level.     PA113   PA502
                                                                 PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-WORK-SCHED       Alpha 10                                    HR511   HR650
Work Schedule        Contains the work schedule for this         PA113   PA502
                     level.                                      PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-SHIFT            Numeric 1                                   HR511   HR650
Shift                Contains the shift number associated        PA113   PA502
                     with the level.                             PA513   PR13.1
                     1 = Shift 1                                 PR13.5  PR13.6
                     2 = Shift 2                                 PR13.8
                     3 = Shift 3
                     4 = Shift 4
                     5 = Shift 5
                     6 = Shift 6
                     7 = Shift 7
                     8 = Shift 8
                     9 = Shift 9

PEP-SCHEDULE         Alpha 9                                     HR511   HR650
Schedule             Contains the grade range or step            PA113   PA502
                     schedule for this level.                    PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-PAY-GRADE        Alpha 3                                     HR511   HR650
Grade                Contains the grade for this level.          PA113   PA502
                                                                 PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-PAY-STEP         Numeric 2                                   HR511   HR650
Step                 Contains the step for this level.           PA113   PA502
                                                                 PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-EXP-COMPANY      Numeric 4                                   HR511   HR650
Exp Company          Contains the gl expense company for         PA113   PA502
                     this  level.                                PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-EXP-ACCT-UNIT    Alpha 15                                    HR511   HR650
Expense Accounting   Contains the gl expense account unit        PA113   PA502
Unit                 for this level.                             PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-EXP-ACCOUNT      Numeric 6                                   HR511   HR650
Expense Account      Contains the gl distribution account        PA113   PA502
                     number for this level.                      PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-EXP-SUB-ACCT     Numeric 4                                   HR511   HR650
Depr Expense         Contains the gl distribution expense        PA113   PA502
Subaccount           subaccount for this level.                  PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-ACTIVITY         Alpha 15                                    HR511   HR650
Activity             Activities are the processes or             PA113   PA502
                     procedures that produce work. Cost          PA513   PR13.1
                     objects (products, services, customers,     PR13.5  PR13.6
                     and so on) are the reasons for              PR13.8
                     performing the activity.


PEP-ACCT-CATEGORY    Alpha 5                                     HR511   HR650
Account Category     Account categories are groupings of         PA113   PA502
                     costs, revenues, or a combination of        PA513   PR13.1
                     both used for reporting and inquiries       PR13.5  PR13.6
                     for activities in the Activity              PR13.8
                     Management system. All transactions are
                     posted to an account category within an
                     activity. You can assign a specific
                     General Ledger account or range of
                     accounts (company, accounting unit,
                     account, and subaccount) that make up
                     the transactions posted to an account
                     category using AC07.1 (Account
                     Assignment).

                     Period-to-date, year-to-date, and
                     life-to-date balances are maintained by
                     account category for activities. Account
                     categories must be assigned to
                     activities before you do any budgeting
                     or transaction processing.

PEP-POS-EFF-DT       Numeric 8  (yyyymmdd)                       HR511   HR650
Pos Eff Dt           If this level uses a position, contains     PA113   PA502
                     the effective date of the position end.     PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-ANNUAL-HOURS     Numeric 4                                   HR511   HR650
Annual Hours         Contains the annual hours for this          PA113   PA502
                     level.                                      PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEP-PRO-RATE-A-SAL   Signed 13.4                                 HR511   HR650
Pro Rate A Sal       Contains the prorated salary for this       PA113   PA502
                     level.                                      PA513   PR13.1
                                                                 PR13.5  PR13.6
                     If the employee is salaried, the total      PR13.8
                     prorated salary is the same as the rate
                     of pay.

                     If the employee is hourly, the total
                     prorated salary is the sum of the pay
                     rate times the annual hours times the
                     FTE for each position level.

PEP-DATE-STAMP       Numeric 8  (yyyymmdd)                       HR511   HR650
Date Stamp           This field contains the server date         PA502   PA513
                     (month, date, and year) of the last         PR13.1  PR13.5
                     change to this record.                      PR13.6  PR13.8

PEP-TIME-STAMP       Numeric 6  (hhmmss)                         HR511   HR650
Time Stamp           Contains the server time (hour, minute,     PA502   PA513
                     and second) when the record was last        PR13.1  PR13.5
                     changed.                                    PR13.6  PR13.8

PEP-USER-ID          Alpha 10  (Lower Case)                      HR511   HR650
User ID Name         Contains the user ID of the person who      PA502   PA513
                     last changed this record.                   PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEP-CURRENCY-CODE    Alpha 5                                     HR511   HR650
Currency Code        Contains the currency for the pay rate      PA502   PA513
                     at this level.                              PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEP-CURR-ND          Numeric 1                                   HR511   HR650
Currency Number of   Represents the number of decimals           PA502   PA513
Decimals             defined for the currency of the object.     PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEP-BASE-CURRENCY    Alpha 5                                     HR511   HR650
Base Currency        Contains the employee's base currency.      PA502   PA513
                                                                 PR13.1  PR13.5
                     The base currency is the employee's         PR13.6  PR13.8
                     primary (Level 1) currency as of the
                     effective date.

PEP-BASE-ND          Numeric 1                                   HR511   HR650
Base Number Of       The number of decimal positions defined     PA502   PA513
Decimals             for the company base currency.              PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PEP-BASE-PAY-RATE    Signed 13.4                                 HR511   HR650
Base Pay Rate        Contains the pay rate for this level as     PA113   PA502
                     translated into the base currency.          PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

                         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  HR217
          EFFECT-DATE                                            HR511   HR650
                                                                 HRS1.1  HRSC.1
                                                                 PA06.1  PA113
                                                                 PA149   PA218
                                                                 PA272   PA313
                                                                 PA502   PA513
                                                                 PR128   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PEPSET2   COMPANY       Subset                                   HC01.1  HC02.1
          EMPLOYEE      Where (END-DATE = Zeroes )               HCEM.1  HCOP.1
          POS-LEVEL                                              HR15.1  HR155
          EFFECT-DATE                                            HR170   HR217
                                                                 HR511   HR54.1
                                                                 HR55.2  HR650
                                                                 HR70.1  HRS1.1
                                                                 HRSC.1  PA111
                                                                 PA113   PA149
                                                                 PA16.1  PA213
                                                                 PA218   PA249
                                                                 PA272   PA406
                                                                 PA49.1  PA49.3
                                                                 PA502   PA513
                                                                 PA54.1  PA549
                                                                 ...

PEPSET3   COMPANY                                                HC01.1  HC02.1
          EMPLOYEE                                               HCEM.1  HCOP.1
          POS-LEVEL                                              HR217   HR511
          EFFECT-DATE*                                           HR54.1  HR650
                                                                 PA113   PA149
                                                                 PA213   PA218
                                                                 PA272   PA311
                                                                 PA313   PA502
                                                                 PA513   PA54.1
                                                                 PR128   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PR33.2
                                                                 PR33.3

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

PEPSET5   COMPANY       KeyChange                                HR511   PA502
          EMPLOYEE                                               PA513
          POSITION
          JOB-CODE
          PROCESS-LEVEL
          DEPARTMENT
          EFFECT-DATE*
          POS-LEVEL

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

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

                         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    Delete Cascades

                            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