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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET4 SET5 SET6
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 SET5 SET7 SET9
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 SET5 SET7
PROCESS_LEVEL		Alpha 5—BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
#PEP-DEPARTMENT SET5 SET7
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 10—BN305, 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.4—BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
#PEP-WORK-ASSIGNMNT
WORK_ASSIGNMNT		Numeric 4—BN305, 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PEPSET1
  1. COMPANY
  2. EMPLOYEE
  3. POS-LEVEL
  4. EFFECT-DATE
PrimaryBN305, HC01.2, HCDL.1, HCEM.1, HCHP.1, HAP3.1, HCRE.1, HEP4.1 +22 more (list truncated in source)
PEPSET2
  1. COMPANY
  2. EMPLOYEE
  3. POS-LEVEL
  4. EFFECT-DATE
SubsetWhere (END-DATE = Zeroes)BN305, HC01.2, HCDL.1, HCEM.1, HAP3.1, HCRE.1, HEP4.1, HLTM.1 +22 more (list truncated in source)
PEPSET3
  1. COMPANY
  2. EMPLOYEE
  3. POS-LEVEL
  4. EFFECT-DATE ↓
BN150, BN305, HC01.2, HCDL.1, HCEM.1, HAP3.1, HCRE.1, HEP4.1 +22 more (list truncated in source)
PEPSET4
  1. COMPANY
  2. POSITION
  3. EMPLOYEE
  4. POS-LEVEL
  5. EFFECT-DATE
KeyChangeHLTM.1, LT101, LT111, LP180, PA02.1, PA10.1, PA102, PA201 +6 more
PEPSET5
  1. COMPANY
  2. EMPLOYEE
  3. POSITION
  4. JOB-CODE
  5. PROCESS-LEVEL
  6. DEPARTMENT
  7. EFFECT-DATE ↓
  8. POS-LEVEL
KeyChangeHR11.2, HR511, LT101, LT111, LP100, LP140, LP145, LP198 +11 more
PEPSET6
  1. COMPANY
  2. EMPLOYEE
  3. POSITION
  4. EFFECT-DATE ↓
  5. POS-LEVEL
KeyChange, SubsetWhere (POSITION != Spaces)BN150, PR521, EXI2.1, EXI4.1, LP100, LP101, LP130, LP140 +22 more (list truncated in source)
PEPSET7
  1. COMPANY
  2. EMPLOYEE
  3. JOB-CODE
  4. PROCESS-LEVEL
  5. DEPARTMENT
  6. EFFECT-DATE ↓
  7. POS-LEVEL
KeyChange, SubsetWhere (POSITION = Spaces)BN150, PR521, EXI2.1, EXI4.1, LP130, PA211, PR128, PR131 +22 more (list truncated in source)
PEPSET9
  1. COMPANY
  2. EMPLOYEE
  3. JOB-CODE
  4. EFFECT-DATE
  5. POS-LEVEL
KeyChange, SubsetWhere (JOB-CODE != Spaces)PA10.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACCTCATACACTIVITYPCODESCUCODESPRSYSTEMDEPTCODEGLMASTERJOBCODEPAEMPLOYEEEMPLOYEEPAPOSITIONHRSUPERPRSAGDTLHROCCUPCDHRHISTORYPRRATEHISTPAPEPAUDITPAPOSERRPAPOSITIONPRSAGHEADHRWRKSCHDPAEMPPOS

One to one (18) — lookups and parents

RelationTableRulesConditionField map
Acct CatACACCTCATRequiredWhen (PEP-ACCT-CATEGORY != Spaces)
PEP-ACCT-CATEGORY→AAX-ACCT-CATEGORY
ActivityACACTIVITYRequiredWhen (PEP-ACTIVITY != Spaces)
PEP-ACTIVITY→ACV-ACTIVITY
Bargain UnitPCODESRequiredWhen PEP-BARGAIN-UNIT != Spaces
"BU"→PCO-TYPE
PEP-BARGAIN-UNIT→PCO-CODE
Base CurrencyCUCODESRequiredWhen (PEP-CURRENCY-CODE != Spaces)
PEP-BASE-CURRENCY→CUC-CURRENCY-CODE
CompanyPRSYSTEMRequired
PEP-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen (PEP-CURRENCY-CODE != Spaces)
PEP-CURRENCY-CODE→CUC-CURRENCY-CODE
DepartmentDEPTCODERequiredWhen (PEP-DEPARTMENT != Spaces)
PEP-COMPANY→DPT-COMPANY
PEP-PROCESS-LEVEL→DPT-PROCESS-LEVEL
PEP-DEPARTMENT→DPT-DEPARTMENT
Exp AccountGLMASTERRequiredWhen (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
JobcodeJOBCODERequiredWhen (PEP-JOB-CODE != Spaces)
PEP-COMPANY→JBC-COMPANY
PEP-JOB-CODE→JBC-JOB-CODE
Locat CodePCODESRequiredWhen (PEP-LOCAT-CODE != Spaces)
"LO"→PCO-TYPE
PEP-LOCAT-CODE→PCO-CODE
PaemployeePAEMPLOYEERequired
PEP-COMPANY→PEM-COMPANY
PEP-EMPLOYEE→PEM-EMPLOYEE
Pep EmployeeEMPLOYEERequired
PEP-COMPANY→EMP-COMPANY
PEP-EMPLOYEE→EMP-EMPLOYEE
Pos DatePAPOSITIONRequiredWhen (PEP-POSITION != Spaces)
PEP-COMPANY→POS-COMPANY
PEP-POSITION→POS-POSITION
PEP-POS-EFF-DT→POS-EFFECT-DATE
Process LevelPRSYSTEMRequiredWhen (PEP-PROCESS-LEVEL != Spaces)
PEP-COMPANY→PRS-COMPANY
PEP-PROCESS-LEVEL→PRS-PROCESS-LEVEL
SupervisorHRSUPERRequiredWhen (PEP-SUPERVISOR != Spaces)
PEP-COMPANY→HSU-COMPANY
PEP-SUPERVISOR→HSU-CODE
Supervisor IndHRSUPERRequiredWhen (PEP-SUPERVISOR-IND != Spaces)
PEP-COMPANY→HSU-COMPANY
PEP-SUPERVISOR-IND→HSU-CODE
UnionPCODESRequiredWhen (PEP-UNION-CODE != Spaces)
"UN"→PCO-TYPE
PEP-UNION-CODE→PCO-CODE
User LevelPCODESRequiredWhen (PEP-USER-LEVEL != Spaces)
"UL"→PCO-TYPE
PEP-USER-LEVEL→PCO-CODE

One to many (10) — child tables

RelationTableRulesConditionField map
GradePRSAGDTLRequiredWhen (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
Hr Occup CodeHROCCUPCDValid When (PEP-JOB-CODE != Spaces)
PEP-COMPANY→HOP-COMPANY
PEP-JOB-CODE→HOP-JOB-CODE
EMP-WORK-COUNTRY→HOP-COUNTRY-CODE
—→HOP-OCCUPTN-CODE
HrhistoryHRHISTORY
PEP-COMPANY→HRH-COMPANY
PEP-EMPLOYEE→HRH-EMPLOYEE
Zeroes→HRH-OBJ-ID
—→HRH-FLD-NBR
—→HRH-POS-LEVEL
—→HRH-BEG-DATE
—→HRH-SEQ-NBR
Pay Rate HistPRRATEHIST
PEP-COMPANY→PRH-COMPANY
PEP-EMPLOYEE→PRH-EMPLOYEE
PEP-POS-LEVEL→PRH-POS-LEVEL
—→PRH-BEG-DATE
—→PRH-SEQ-NBR
Pep AuditPAPEPAUDIT
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 ErrorPAPOSERR
PEP-COMPANY→PPE-COMPANY
PEP-EMPLOYEE→PPE-EMPLOYEE
Zeroes→PPE-REQUISITION
—→PPE-POSITION
—→PPE-EFFECT-DATE
—→PPE-UPDATE-TYPE
PositionPAPOSITION
PEP-COMPANY→POS-COMPANY
PEP-POSITION→POS-POSITION
—→POS-EFFECT-DATE
SchedulePRSAGHEADRequiredWhen (PEP-SCHEDULE != Spaces)
PEP-COMPANY→SGH-COMPANY
"S"→SGH-INDICATOR
PEP-SCHEDULE→SGH-SCHEDULE
—→SGH-EFFECT-DATE
Step,gradePRSAGDTLRequiredWhen (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
Work SchedHRWRKSCHDValid When (PEP-WORK-SCHED != Spaces)
PEP-COMPANY→WSC-COMPANY
PEP-WORK-SCHED→WSC-WORK-SCHED
—→WSC-CONTRACT-YEAR
—→WSC-EFFECT-DATE

Programs

Updated by (98)

Referenced by (58)