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 SNEM.1 SNHC.1 HR155 HR170 HR55.2
HR70.1 LP100 LP101 LP251 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 PA95.1
TR21.1 TR22.1 TR26.1 TR500 PR216 BN150
ET530 ETI2.1 LP130 PA10.1 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
PR35.9 PR36.1 PR45.1 PR529 PR530 PR560
PR80.1 PR82.1 UK102 UK560 SN80.2 SN80.3
TA147 LP180 PA201 PA211 PA302 PA402
LP140 LP145 LP198
UPDATED BY
BN305 ET700 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 PA115 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEP-COMPANY Numeric 4 BN305 HR11.1
Element: Company Hr Contains the number that represents an HR11.2 HR511
established company and is entered on PA02.1 PA100
all functions. PA102 PA115
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 BN305 HR11.1
Element: Employee Contains the employee number. An HR11.2 HR511
employee number is assigned to each PA02.1 PA100
person employed by the company. The PA102 PA115
application uses the employee number to PA13.1 PA13.2
correlate all information related to the PA502 PA513
employee. PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEP-POSITION Alpha 12 BN305 HAP3.1
Element: Position Contains the user-defined code that HEP4.1 HPOS.1
represents a position in the company. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PEP-POS-LEVEL Numeric 2 BN305 HR11.1
Element: Pos Level Contains the position level. Indicates HR11.2 HR511
if this level is the first, second, or PA02.1 PA100
third level for the employee. PA102 PA115
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 BN305 HAP3.1
Element: Fte Contains the level's FTE. 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
PA115 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
PEP-EFFECT-DATE Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: Effect Date Contains the effective date for the HEP4.1 HPOS.1
level. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PEP-END-DATE Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: End Date Contains the employee's ending date in HEP4.1 HPOS.1
this level. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PEP-JOB-CODE Alpha 9 BN305 HAP3.1
Element: Job Code Contains a user-defined code that HEP4.1 HPOS.1
represents a type of job. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PEP-PROCESS-LEVEL Alpha 5 BN305 HAP3.1
Element: Process Lev Hr 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
PA115 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
PEP-DEPARTMENT Alpha 5 BN305 HAP3.1
Element: Department Contains the department. 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
PA115 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
PEP-PAY-RATE Signed 13.4 BN305 HAP3.1
Element: Pay Rate Contains the level's rate of pay. 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
PA115 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
PEP-USER-LEVEL Alpha 10 BN305 HAP3.1
Element: User Level Contains the level's user level. 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
PA115 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
PEP-LOCAT-CODE Alpha 10 BN305 HAP3.1
Element: Locat Code Contains the level's location. 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
PA115 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
PEP-SUPERVISOR Alpha 10 BN305 HAP3.1
Element: Supervisor Contains the level's supervisor. 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
PA115 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
PEP-SUPERVISOR-IND Alpha 10 BN305 HAP3.1
Element: Supervisor IndContains the level's indirect HEP4.1 HPOS.1
supervisor. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PEP-UNION-CODE Alpha 10 BN305 HAP3.1
Element: Union Code Contains the union code for this level. 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
PA115 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
PEP-BARGAIN-UNIT Alpha 10 BN305 HAP3.1
Element: Bargain Unit 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
PA115 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
PEP-DATE-ASSIGN Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: Date Assign 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
PA115 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
PEP-WORK-SCHED Alpha 10 BN305 HAP3.1
Element: Work Sched Contains the work schedule for this HEP4.1 HPOS.1
level. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PEP-SHIFT Numeric 1 BN305 HAP3.1
Element: Shift Contains the shift number associated HEP4.1 HPOS.1
with the level. HPQC.1 HPRS.1
1 = Shift 1 HR11.1 HR11.2
2 = Shift 2 HR15.1 HR511
3 = Shift 3 HR515 HR54.1
4 = Shift 4 HRS1.1 HRSC.1
5 = Shift 5 PA02.1 PA100
6 = Shift 6 PA102 PA113
7 = Shift 7 PA115 PA13.1
8 = Shift 8 PA13.2 PA502
9 = Shift 9 PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEP-SCHEDULE Alpha 9 BN305 HAP3.1
Element: Schedule Contains the grade range or step HEP4.1 HPOS.1
schedule for this level. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PEP-PAY-GRADE Alpha 3 BN305 HAP3.1
Element: Pay Grade Contains the grade for this level. 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
PA115 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
PEP-PAY-STEP Numeric 2 BN305 HAP3.1
Element: Pay Step Contains the step for this level. 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
PA115 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
PEP-EXP-COMPANY Numeric 4 BN305 HAP3.1
Element: Company Contains the gl expense company for HEP4.1 HPOS.1
this level. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PEP-EXP-ACCT-UNIT Alpha 15 BN305 HAP3.1
Element: Acct Unit Contains the gl expense account unit HEP4.1 HPOS.1
for this level. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PEP-EXP-ACCOUNT Numeric 6 BN305 HAP3.1
Element: Account Contains the gl distribution account HEP4.1 HPOS.1
number for this level. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PEP-EXP-SUB-ACCT Numeric 4 BN305 HAP3.1
Element: Sub Acct Contains the gl distribution expense HEP4.1 HPOS.1
subaccount for this level. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PEP-ACTIVITY Alpha 15 BN305 HAP3.1
Element: Activity Activities are the processes or HEP4.1 HPOS.1
procedures that produce work. Cost HPQC.1 HPRS.1
objects (products, services, customers, HR11.1 HR11.2
and so on) are the reasons for HR15.1 HR511
performing the activity. HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PEP-ACCT-CATEGORY Alpha 5 BN305 HAP3.1
Element: Acct Category Account categories are groupings of HEP4.1 HPOS.1
costs, revenues, or a combination of HPQC.1 HPRS.1
both used for reporting and inquiries HR11.1 HR11.2
for activities in the Activity HR15.1 HR511
Management system. All transactions are HR515 HR54.1
posted to an account category within an HRS1.1 HRSC.1
activity. You can assign a specific PA02.1 PA100
General Ledger account or range of PA102 PA113
accounts (company, accounting unit, PA115 PA13.1
account, and subaccount) that make up PA13.2 PA502
the transactions posted to an account PA513 PA52.1
category using AC07.1 (Account PA52.3 PA52.4
Assignment). PA52.5 PA54.1
PR110 PR113
Period-to-date, year-to-date, and PR120 PR13.1
life-to-date balances are maintained by PR13.5 PR13.6
account category for activities. Account PR13.8
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) BN305 HAP3.1
Element: Pos Eff Dt If this level uses a position, contains HEP4.1 HPOS.1
the effective date of the position end. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PEP-ANNUAL-HOURS Numeric 4 BN305 HAP3.1
Element: Annual Hours Contains the annual hours for this HEP4.1 HPOS.1
level. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PEP-PRO-RATE-A-SAL Signed 13.4 BN305 HAP3.1
Element: Pay Rate Contains the prorated salary for this HEP4.1 HPOS.1
level. HPQC.1 HPRS.1
HR11.1 HR11.2
If the employee is salaried, the total HR15.1 HR511
prorated salary is the same as the rate HR515 HR54.1
of pay. HRS1.1 HRSC.1
PA02.1 PA100
If the employee is hourly, the total PA102 PA113
prorated salary is the sum of the pay PA115 PA13.1
rate times the annual hours times the PA13.2 PA502
FTE for each position level. PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEP-DATE-STAMP Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Date Stamp This field contains the server date HR11.2 HR511
(month, date, and year) of the last PA02.1 PA100
change to this record. PA102 PA115
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) BN305 HR11.1
Element: Time Stamp Contains the server time (hour, minute, HR11.2 HR511
and second) when the record was last PA02.1 PA100
changed. PA102 PA115
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) BN305 HR11.1
Element: User HR11.2 HR511
PA02.1 PA100
PA102 PA115
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 BN305 HAP3.1
Element: Currency Code Contains the currency for the pay rate HEP4.1 HPOS.1
at this level. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PEP-CURR-ND Numeric 1 BN305 HR11.1
Element: Acct Nd The number of decimals assigned to a HR11.2 HR511
particular account as determined by the PA02.1 PA100
account currency. PA102 PA115
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 BN305 HAP3.1
Element: Base Currency Contains the employee's base currency. HEP4.1 HPOS.1
HPQC.1 HPRS.1
The base currency is the employee's HR11.1 HR11.2
primary (Level 1) currency as of the HR15.1 HR511
effective date. HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PEP-BASE-ND Numeric 1 BN305 HR11.1
Element: Base Nd The number of decimal positions defined HR11.2 HR511
for the company base currency. PA02.1 PA100
PA102 PA115
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 BN305 HAP3.1
Element: Pay Rate Contains the pay rate for this level as HEP4.1 HPOS.1
translated into the base currency. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PEP-USER-AMOUNT Signed 13.4 BN305 HAP3.1
Element: Pay Rate 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
PA115 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
PAEMPPOS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEPSET1 COMPANY BN305 ET700
EMPLOYEE HC01.2 HCDL.1
POS-LEVEL HCEM.1 HCHP.1
EFFECT-DATE HAP3.1 HEP4.1
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
...
PEPSET2 COMPANY Subset BN305 HC01.2
EMPLOYEE Where (END-DATE = Zeroes ) HCDL.1 HCEM.1
POS-LEVEL HAP3.1 HEP4.1
EFFECT-DATE HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR170
HR217 HR511
HR515 HR54.1
HR55.2 HR70.1
HRS1.1 HRSC.1
LP100 LP101
LP251 PA02.1
PA100 PA102
PA111 PA113
...
PEPSET3 COMPANY BN150 BN305
EMPLOYEE ET530 ETI2.1
POS-LEVEL HC01.2 HCDL.1
EFFECT-DATE* HCEM.1 HAP3.1
HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR170 HR217
HR511 HR515
HR54.1 HR55.2
HR70.1 HRS1.1
HRSC.1 LP100
LP101 LP130
PA02.1 PA10.1
...
PEPSET4 COMPANY KeyChange LP180 PA02.1
POSITION PA10.1 PA102
EMPLOYEE PA201 PA210
POS-LEVEL PA211 PA272
EFFECT-DATE PA302 PA402
PA502
PEPSET5 COMPANY KeyChange HR11.2 HR511
EMPLOYEE LP100 LP140
POSITION LP145 LP198
JOB-CODE PA02.1 PA10.1
PROCESS-LEVEL PA100 PA102
DEPARTMENT PA13.1 PA13.2
EFFECT-DATE* PA213 PA502
POS-LEVEL PA513 PA52.5
PR110
PEPSET6 COMPANY KeyChange, Subset BN150 ET530
EMPLOYEE Where (POSITION != Spaces ) ETI2.1 LP100
POSITION LP101 LP130
EFFECT-DATE* LP140 LP145
POS-LEVEL LP198 PA210
PR128 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
PR35.9 PR36.1
...
PEPSET7 COMPANY KeyChange, Subset BN150 ET530
EMPLOYEE Where (POSITION = Spaces ) ETI2.1 LP130
JOB-CODE PA211 PR128
PROCESS-LEVEL PR130 PR131
DEPARTMENT PR132 PR134
EFFECT-DATE* PR136 PR189
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 PR80.1
...
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
|