PAEMPPOS – Employee Multiple Pos, Jobs

System
Human Resources (HR)
Prefix
PEP
Primary key
COMPANY, EMPLOYEE, POS-LEVEL, EFFECT-DATE
Fields
43
Updated by
98 programs
Referenced by
58 programs

PAEMPPOS is the Employee Multiple Pos, Jobs table in Lawson Human Resources (prefix PEP). It is indexed by COMPANY, EMPLOYEE, POS-LEVEL, EFFECT-DATE (PEPSET1); alternate indexes: PEPSET2, PEPSET3, PEPSET4, PEPSET5, PEPSET6, PEPSET7 and PEPSET9. It is related 1:1 to ACACCTCAT, ACACTIVITY, PCODES, CUCODES, PRSYSTEM, DEPTCODE, GLMASTER, JOBCODE and 4 more and 1:M to PRSAGDTL, HROCCUPCD, HRHISTORY, PRRATEHIST, PAPEPAUDIT, PAPOSERR, PAPOSITION, PRSAGHEAD and 1 more. It is updated by BN150, BN305, EXI2.1, EXI4.1, HAP3.1, HCRE.1, HEP4.1, HPOS.1 and 90 more and referenced by HC01.2, HCDL.1, HCEM.1, HCHP.1, HLTM.1, HR155, HR156, HR170 and 50 more. The table has 43 fields, 8 indexes and 28 documented relations.

About PAEMPPOS

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.

Fields (43)

Column = COBOL field name without the PEP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PEP-COMPANY PK
COMPANY
Numeric 4Contains the number that represents an established company and is entered on all functions.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
PEP-EMPLOYEE PK
EMPLOYEE
Numeric 9Contains the employee number. An employee number is assigned to each person employed by the company. The application uses the employee number to correlate all information related to the employee.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
PEP-POSITION
POSITION
Alpha 12Contains the user-defined code that represents a position in the company.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-POS-LEVEL PK
POS_LEVEL
Numeric 2Contains the position level. Indicates if this level is the first, second, or third level for the employee.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
PEP-FTE
FTE
Signed 11.6Contains the level's FTE.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-EFFECT-DATE PK
EFFECT_DATE
Numeric 8 (yyyymmdd)Contains the effective date for the level.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-END-DATE
END_DATE
Numeric 8 (yyyymmdd)Contains the employee's ending date in this level.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-JOB-CODE
JOB_CODE
Alpha 9Contains a user-defined code that represents a type of job.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-PROCESS-LEVEL
PROCESS_LEVEL
Alpha 5BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-DEPARTMENT
DEPARTMENT
Alpha 5Contains the department.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-PAY-RATE
PAY_RATE
Signed 13.4Contains the level's rate of pay.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-USER-LEVEL
USER_LEVEL
Alpha 10Contains the level's user level.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-LOCAT-CODE
LOCAT_CODE
Alpha 10Contains the level's location.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-SUPERVISOR
SUPERVISOR
Alpha 10Contains the level's supervisor.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-SUPERVISOR-IND
SUPERVISOR_IND
Alpha 10Contains the level's indirect supervisor.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-UNION-CODE
UNION_CODE
Alpha 10Contains the union code for this level.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-BARGAIN-UNIT
BARGAIN_UNIT
Alpha 10BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-DATE-ASSIGN
DATE_ASSIGN
Numeric 8 (yyyymmdd)BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-WORK-SCHED
WORK_SCHED
Alpha 10Contains the work schedule for this level.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-SHIFT
SHIFT
Numeric 1Contains the shift number associated with the level.
  • 1 Shift 1
  • 2 Shift 2
  • 3 Shift 3
  • 4 Shift 4
  • 5 Shift 5
  • 6 Shift 6
  • 7 Shift 7
  • 8 Shift 8
  • 9 Shift 9
BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-SCHEDULE
SCHEDULE
Alpha 9Contains the grade range or step schedule for this level.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-PAY-GRADE
PAY_GRADE
Alpha 3Contains the grade for this level.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-PAY-STEP
PAY_STEP
Numeric 2Contains the step for this level.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-EXP-COMPANY
EXP_COMPANY
Numeric 4Contains the gl expense company for this level.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-EXP-ACCT-UNIT
EXP_ACCT_UNIT
Alpha 15Contains the gl expense account unit for this level.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-EXP-ACCOUNT
EXP_ACCOUNT
Numeric 6Contains the gl distribution account number for this level.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-EXP-SUB-ACCT
EXP_SUB_ACCT
Numeric 4Contains the gl distribution expense subaccount for this level.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-ACTIVITY
ACTIVITY
Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-ACCT-CATEGORY
ACCT_CATEGORY
Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-POS-EFF-DT
POS_EFF_DT
Numeric 8 (yyyymmdd)If this level uses a position, contains the effective date of the position end.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-ANNUAL-HOURS
ANNUAL_HOURS
Signed 8.4Contains the annual hours for this level.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-PRO-RATE-A-SAL
PRO_RATE_A_SAL
Signed 13.4Contains the prorated salary for this level. If the employee is salaried, the total 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.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-DATE-STAMP
DATE_STAMP
Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
PEP-TIME-STAMP
TIME_STAMP
Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
PEP-USER-ID
USER_ID
Alpha 10 (Lower Case)BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
PEP-CURRENCY-CODE
CURRENCY_CODE
Alpha 5Contains the currency for the pay rate at this level.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-CURR-ND
CURR_ND
Numeric 1The number of decimals assigned to a particular account as determined by the account currency.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
PEP-BASE-CURRENCY
BASE_CURRENCY
Alpha 5Contains the employee's base currency. The base currency is the employee's primary (Level 1) currency as of the effective date.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-BASE-ND
BASE_ND
Numeric 1The number of decimal positions defined for the company base currency.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
PEP-BASE-PAY-RATE
BASE_PAY_RATE
Signed 13.4Contains the pay rate for this level as translated into the base currency.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-USER-AMOUNT
USER_AMOUNT
Signed 13.4BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
PEP-WORK-ASSIGNMNT
WORK_ASSIGNMNT
Numeric 4BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
PEP-UPDATED-BY-LTM
UPDATED_BY_LTM
Alpha 1
  • Y Yes
  • N No
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more

Indexes (8)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PEPSET1COMPANY, EMPLOYEE, POS-LEVEL, EFFECT-DATEPrimaryBN305, HC01.2, HCDL.1, HCEM.1, HCHP.1, HAP3.1, HCRE.1, HEP4.1 +22 more (list truncated in source)
PEPSET2COMPANY, EMPLOYEE, POS-LEVEL, EFFECT-DATESubsetWhere (END-DATE = Zeroes)BN305, HC01.2, HCDL.1, HCEM.1, HAP3.1, HCRE.1, HEP4.1, HLTM.1 +22 more (list truncated in source)
PEPSET3COMPANY, EMPLOYEE, POS-LEVEL, EFFECT-DATE*BN150, BN305, HC01.2, HCDL.1, HCEM.1, HAP3.1, HCRE.1, HEP4.1 +22 more (list truncated in source)
PEPSET4COMPANY, POSITION, EMPLOYEE, POS-LEVEL, EFFECT-DATEKeyChangeHLTM.1, LT101, LT111, LP180, PA02.1, PA10.1, PA102, PA201 +6 more
PEPSET5COMPANY, EMPLOYEE, POSITION, JOB-CODE, PROCESS-LEVEL, DEPARTMENT, EFFECT-DATE*, POS-LEVELKeyChangeHR11.2, HR511, LT101, LT111, LP100, LP140, LP145, LP198 +11 more
PEPSET6COMPANY, EMPLOYEE, POSITION, EFFECT-DATE*, POS-LEVELKeyChange, SubsetWhere (POSITION != Spaces)BN150, PR521, EXI2.1, EXI4.1, LP100, LP101, LP130, LP140 +22 more (list truncated in source)
PEPSET7COMPANY, EMPLOYEE, JOB-CODE, PROCESS-LEVEL, DEPARTMENT, EFFECT-DATE*, POS-LEVELKeyChange, SubsetWhere (POSITION = Spaces)BN150, PR521, EXI2.1, EXI4.1, LP130, PA211, PR128, PR131 +22 more (list truncated in source)
PEPSET9COMPANY, EMPLOYEE, JOB-CODE, EFFECT-DATE, POS-LEVELKeyChange, SubsetWhere (JOB-CODE != Spaces)PA10.1

Relations

One to one (18) — lookups and parents

RelationTableRulesConditionField map
Acct CatACACCTCATRequiredWhen (PEP-ACCT-CATEGORY != Spaces)PEP-ACCT-CATEGORYAAX-ACCT-CATEGORY
ActivityACACTIVITYRequiredWhen (PEP-ACTIVITY != Spaces)PEP-ACTIVITYACV-ACTIVITY
Bargain UnitPCODESRequiredWhen PEP-BARGAIN-UNIT != Spaces"BU"PCO-TYPE, PEP-BARGAIN-UNITPCO-CODE
Base CurrencyCUCODESRequiredWhen (PEP-CURRENCY-CODE != Spaces)PEP-BASE-CURRENCYCUC-CURRENCY-CODE
CompanyPRSYSTEMRequiredPEP-COMPANYPRS-COMPANY, SpacesPRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen (PEP-CURRENCY-CODE != Spaces)PEP-CURRENCY-CODECUC-CURRENCY-CODE
DepartmentDEPTCODERequiredWhen (PEP-DEPARTMENT != Spaces)PEP-COMPANYDPT-COMPANY, PEP-PROCESS-LEVELDPT-PROCESS-LEVEL, PEP-DEPARTMENTDPT-DEPARTMENT
Exp AccountGLMASTERRequiredWhen (PEP-EXP-ACCT-UNIT != Spaces) Or (PEP-EXP-ACCOUNT != Zeroes)PEP-EXP-COMPANYGLM-COMPANY, PEP-EXP-ACCT-UNITGLM-ACCT-UNIT, PEP-EXP-ACCOUNTGLM-ACCOUNT, PEP-EXP-SUB-ACCTGLM-SUB-ACCOUNT
JobcodeJOBCODERequiredWhen (PEP-JOB-CODE != Spaces)PEP-COMPANYJBC-COMPANY, PEP-JOB-CODEJBC-JOB-CODE
Locat CodePCODESRequiredWhen (PEP-LOCAT-CODE != Spaces)"LO"PCO-TYPE, PEP-LOCAT-CODEPCO-CODE
PaemployeePAEMPLOYEERequiredPEP-COMPANYPEM-COMPANY, PEP-EMPLOYEEPEM-EMPLOYEE
Pep EmployeeEMPLOYEERequiredPEP-COMPANYEMP-COMPANY, PEP-EMPLOYEEEMP-EMPLOYEE
Pos DatePAPOSITIONRequiredWhen (PEP-POSITION != Spaces)PEP-COMPANYPOS-COMPANY, PEP-POSITIONPOS-POSITION, PEP-POS-EFF-DTPOS-EFFECT-DATE
Process LevelPRSYSTEMRequiredWhen (PEP-PROCESS-LEVEL != Spaces)PEP-COMPANYPRS-COMPANY, PEP-PROCESS-LEVELPRS-PROCESS-LEVEL
SupervisorHRSUPERRequiredWhen (PEP-SUPERVISOR != Spaces)PEP-COMPANYHSU-COMPANY, PEP-SUPERVISORHSU-CODE
Supervisor IndHRSUPERRequiredWhen (PEP-SUPERVISOR-IND != Spaces)PEP-COMPANYHSU-COMPANY, PEP-SUPERVISOR-INDHSU-CODE
UnionPCODESRequiredWhen (PEP-UNION-CODE != Spaces)"UN"PCO-TYPE, PEP-UNION-CODEPCO-CODE
User LevelPCODESRequiredWhen (PEP-USER-LEVEL != Spaces)"UL"PCO-TYPE, PEP-USER-LEVELPCO-CODE

One to many (10) — child tables

RelationTableRulesConditionField map
GradePRSAGDTLRequiredWhen (PEP-SCHEDULE != Spaces) And (PEP-PAY-GRADE != Spaces)PEP-COMPANYSGD-COMPANY, PEP-SCHEDULESGD-SCHEDULE, PEP-PAY-GRADESGD-PAY-GRADE, 1SGD-PAY-STEP, SGD-EFFECT-DATE
Hr Occup CodeHROCCUPCDValid When (PEP-JOB-CODE != Spaces)PEP-COMPANYHOP-COMPANY, PEP-JOB-CODEHOP-JOB-CODE, EMP-WORK-COUNTRYHOP-COUNTRY-CODE, HOP-OCCUPTN-CODE
HrhistoryHRHISTORYPEP-COMPANYHRH-COMPANY, PEP-EMPLOYEEHRH-EMPLOYEE, ZeroesHRH-OBJ-ID, HRH-FLD-NBR, HRH-POS-LEVEL, HRH-BEG-DATE, HRH-SEQ-NBR
Pay Rate HistPRRATEHISTPEP-COMPANYPRH-COMPANY, PEP-EMPLOYEEPRH-EMPLOYEE, PEP-POS-LEVELPRH-POS-LEVEL, PRH-BEG-DATE, PRH-SEQ-NBR
Pep AuditPAPEPAUDITPEP-COMPANYPEA-COMPANY, PEP-EMPLOYEEPEA-EMPLOYEE, PEP-POS-LEVELPEA-POS-LEVEL, PEA-EFFECT-DATE, PEA-UPDATE-DATE, PEA-FLD-NBR, PEA-ACT-OBJ-ID
Pos Chg ErrorPAPOSERRPEP-COMPANYPPE-COMPANY, PEP-EMPLOYEEPPE-EMPLOYEE, ZeroesPPE-REQUISITION, PPE-POSITION, PPE-EFFECT-DATE, PPE-UPDATE-TYPE
PositionPAPOSITIONPEP-COMPANYPOS-COMPANY, PEP-POSITIONPOS-POSITION, POS-EFFECT-DATE
SchedulePRSAGHEADRequiredWhen (PEP-SCHEDULE != Spaces)PEP-COMPANYSGH-COMPANY, "S"SGH-INDICATOR, PEP-SCHEDULESGH-SCHEDULE, SGH-EFFECT-DATE
Step,gradePRSAGDTLRequiredWhen (PEP-SCHEDULE != Spaces) And (PEP-PAY-GRADE != Spaces) And (PEP-PAY-STEP != Zeroes)PEP-COMPANYSGD-COMPANY, PEP-SCHEDULESGD-SCHEDULE, PEP-PAY-GRADESGD-PAY-GRADE, PEP-PAY-STEPSGD-PAY-STEP, SGD-EFFECT-DATE
Work SchedHRWRKSCHDValid When (PEP-WORK-SCHED != Spaces)PEP-COMPANYWSC-COMPANY, PEP-WORK-SCHEDWSC-WORK-SCHED, WSC-CONTRACT-YEAR, WSC-EFFECT-DATE

Programs

Updated by (98)

Referenced by (58)