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