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.2 HCDL.1 HCEM.1 HCHP.1 HR217 PA06.1
PA149 PA210 PA213 PA218 PA272 PA495
PR128 HR00.1 HR01.1 HR155 HR170 HR55.2
HR70.1 PA111 PA16.1 PA182 PA20.1 PA21.1
PA22.1 PA24.1 PA249 PA27.1 PA34.1 PA35.1
PA36.1 PA38.1 PA406 PA49.1 PA49.3 PA520
PA549 PA66.3 TR21.1 TR22.1 TR26.1 TR500
PBIP.1 PR197 PR216 PA311 PA496 PR33.2
PR33.3 PA10.1 PA201 PA211 PA302 PA402
BN150 PR130 PR131 PR132 PR134 PR136
PR29.1 PR32.2 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR35.9 PR36.1 PR45.1
PR529 PR530 PR560 PR82.1 UK102 TA147
TP135
UPDATED BY
HAP3.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1 HR11.1
HR11.2 HR15.1 HR511 HR515 HR54.1 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 Hr Contains the number that represents an HR511 PA02.1
established company and is entered on PA100 PA102
all functions. 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 PA02.1
employee number is assigned to each PA100 PA102
person employed by the company. The PA13.1 PA13.2
system uses the employee number to PA502 PA513
correlate all information related to the PA52.1 PA52.3
employee. PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEP-POSITION Alpha 12 HAP3.1 HEP4.1
Element: Position Contains the user-defined code that HPOS.1 HPQC.1
represents a position in the company. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 PA02.1
if this level is the first, second, or PA100 PA102
third level for the employee. 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-FTE Signed 11.6 HAP3.1 HEP4.1
Element: Fte Contains the level's FTE. HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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) HAP3.1 HEP4.1
Element: Effective DateContains the effective date for the HPOS.1 HPQC.1
level. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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) HAP3.1 HEP4.1
Element: Ending Date Contains the employee's ending date in HPOS.1 HPQC.1
this level. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Job Code Contains a user-defined code that HPOS.1 HPQC.1
represents a type of job. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Process Lev HrThis field contains the process level, HPOS.1 HPQC.1
which is the reporting hierarchy below HPRS.1 HR11.1
company. HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Department Contains the department. HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Rate of Pay Contains the level's rate of pay. HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: User Level Contains the level's user level. HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Location Contains the level's location. HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Supervisor Contains the level's supervisor. HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Supervisor IndContains the level's indirect HPOS.1 HPQC.1
supervisor. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Union Code Contains the union code for this level. HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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-BARGAIN-UNIT Alpha 10 HAP3.1 HEP4.1
Element: Bargaining Unit HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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-DATE-ASSIGN Numeric 8 (yyyymmdd) HAP3.1 HEP4.1
Element: Date Assign HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Work Schedule Contains the work schedule for this HPOS.1 HPQC.1
level. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Shift Contains the shift number associated HPOS.1 HPQC.1
with the level. HPRS.1 HR11.1
1 = Shift 1 HR11.2 HR15.1
2 = Shift 2 HR511 HR515
3 = Shift 3 HR54.1 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 HAP3.1 HEP4.1
Element: Schedule Contains the grade range or step HPOS.1 HPQC.1
schedule for this level. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Grade Contains the grade for this level. HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Step Contains the step for this level. HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Company Contains the gl expense company for HPOS.1 HPQC.1
this level. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Accounting UniContains the gl expense account unit HPOS.1 HPQC.1
for this level. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Account Contains the gl distribution account HPOS.1 HPQC.1
number for this level. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Subaccount Contains the gl distribution expense HPOS.1 HPQC.1
subaccount for this level. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Activity Activities are the processes or HPOS.1 HPQC.1
procedures that produce work. Cost HPRS.1 HR11.1
objects (products, services, customers, HR11.2 HR15.1
and so on) are the reasons for HR511 HR515
performing the activity. HR54.1 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 HAP3.1 HEP4.1
Element: Account CategoAccount categories are groupings of HPOS.1 HPQC.1
costs, revenues, or a combination of HPRS.1 HR11.1
both used for reporting and inquiries HR11.2 HR15.1
for activities in the Activity HR511 HR515
Management system. All transactions are HR54.1 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.
Valid account category types are:
cost
revenue
accrual
pass thru
PEP-POS-EFF-DT Numeric 8 (yyyymmdd) HAP3.1 HEP4.1
Element: Pos Eff Dt If this level uses a position, contains HPOS.1 HPQC.1
the effective date of the position end. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Annual Hours Contains the annual hours for this HPOS.1 HPQC.1
level. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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 HAP3.1 HEP4.1
Element: Rate of Pay Contains the prorated salary for this HPOS.1 HPQC.1
level. HPRS.1 HR11.1
HR11.2 HR15.1
If the employee is salaried, the total HR511 HR515
prorated salary is the same as the rate HR54.1 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 PA02.1
(month, date, and year) of the last PA100 PA102
change to this record. 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 PA02.1
and second) when the record was last PA100 PA102
changed. 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 Contains the user ID of the person who HR511 PA02.1
last changed this record. 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 PA02.1
at this level. 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 Represents the number of decimals HR511 PA02.1
Code defined for the currency of the object. 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
Element: Base Currency Contains the employee's base currency. HR511 PA02.1
PA100 PA102
The base currency is the employee's PA13.1 PA13.2
primary (Level 1) currency as of the PA502 PA513
effective date. 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
Base Number Of The number of decimal positions defined HR511 PA02.1
Decimals for the company base currency. 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 HAP3.1 HEP4.1
Element: Rate of Pay Contains the pay rate for this level as HPOS.1 HPQC.1
translated into the base currency. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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-AMOUNT Signed 13.4 HAP3.1 HEP4.1
Element: Rate of Pay HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 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.2 HCDL.1
EMPLOYEE HCEM.1 HCHP.1
POS-LEVEL HAP3.1 HEP4.1
EFFECT-DATE HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR217 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA06.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA149 PA210
PA213 PA218
...
PEPSET2 COMPANY Subset HC01.2 HCDL.1
EMPLOYEE Where (END-DATE = Zeroes ) HCEM.1 HAP3.1
POS-LEVEL HEP4.1 HPOS.1
EFFECT-DATE HPQC.1 HPRS.1
HR00.1 HR01.1
HR11.1 HR11.2
HR15.1 HR155
HR170 HR217
HR511 HR515
HR54.1 HR55.2
HR70.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA111 PA113
PA13.1 PA13.2
...
PEPSET3 COMPANY HC01.2 HCDL.1
EMPLOYEE HCEM.1 HAP3.1
POS-LEVEL HEP4.1 HPOS.1
EFFECT-DATE* HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR217
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA13.3
PA149 PA213
PA218 PA272
PA311 PA313
...
PEPSET4 COMPANY KeyChange PA02.1 PA10.1
POSITION PA102 PA201
EMPLOYEE PA210 PA211
POS-LEVEL PA272 PA302
EFFECT-DATE PA402 PA502
PEPSET5 COMPANY KeyChange HR11.2 HR511
EMPLOYEE PA02.1 PA10.1
POSITION PA100 PA102
JOB-CODE PA13.1 PA13.2
PROCESS-LEVEL PA213 PA502
DEPARTMENT PA513 PA52.5
EFFECT-DATE* PR110
POS-LEVEL
PEPSET6 COMPANY KeyChange, Subset BN150 PA210
EMPLOYEE Where (POSITION != Spaces ) PR128 PR130
POSITION PR131 PR132
EFFECT-DATE* PR134 PR136
POS-LEVEL PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR82.1
UK102 TA147
TP135
PEPSET7 COMPANY KeyChange, Subset BN150 PA211
EMPLOYEE Where (POSITION = Spaces ) PR128 PR130
JOB-CODE PR131 PR132
PROCESS-LEVEL PR134 PR136
DEPARTMENT PR29.1 PR32.2
EFFECT-DATE* PR33.2 PR33.3
POS-LEVEL PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR82.1
UK102 TA147
TP135
PEPSET8 COMPANY KeyChange, Subset PA210
EMPLOYEE Where (END-DATE = Zeroes )
POS-LEVEL
POSITION
JOB-CODE
PROCESS-LEVEL
EFFECT-DATE
PEPSET9 COMPANY KeyChange, Subset PA10.1 PA210
EMPLOYEE Where (JOB-CODE != Spaces )
JOB-CODE
EFFECT-DATE
POS-LEVEL
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
Bargain Unit PCODES Required
When PEP-BARGAIN-UNIT != Spaces
"BU" -> PCO-TYPE
PEP-BARGAIN-UNIT -> PCO-CODE
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
Paemployee PAEMPLOYEE Required
PEP-COMPANY -> PEM-COMPANY
PEP-EMPLOYEE -> PEM-EMPLOYEE
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
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
Hr Occup Code HROCCUPCD
Valid When (PEP-JOB-CODE != Spaces )
PEP-COMPANY -> HOP-COMPANY
PEP-JOB-CODE -> HOP-JOB-CODE
EMP-WORK-COUNTRY -> HOP-COUNTRY-CODE
HOP-OCCUPTN-CODE
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
Pay Rate Hist PRRATEHIST
PEP-COMPANY -> PRH-COMPANY
PEP-EMPLOYEE -> PRH-EMPLOYEE
PEP-POS-LEVEL -> PRH-POS-LEVEL
PRH-BEG-DATE
PRH-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
Work Sched HRWRKSCHD
Valid When (PEP-WORK-SCHED != Spaces )
PEP-COMPANY -> WSC-COMPANY
PEP-WORK-SCHED -> WSC-WORK-SCHED
WSC-EFFECT-DATE
|