 |
Lawson Insight Technical Documentation |
|
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
|