PAEMPPOS

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
BN150 PR521 EXI2.1 EXI4.1 LP130 LP140
LP145 LP180 LP198 LP251 PA495 PR130
PR131 PR132 PR134 PR135 PR136 PR137
PR189 PR29.1 PR32.1 PR32.2 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR35.9
PR36.1 PR37.1 PR45.1 PR529 PR530 PR560
PR582 PR80.1 PR80.4 PR82.1 UK102 UK560
ZP530 TA147 WA01.2 HCHP.1 SNEM.1 SNHC.1
PA95.1 SN80.2 SN80.3


UPDATED BY
BN305 HC01.2 HCDL.1 HCEM.1 HAP3.1 HCRE.1
HEP4.1 HLTM.1 HPOS.1 HPQC.1 HPRS.1 HR11.1
HR11.2 HR15.1 HR155 HR156 HR170 HR217
HR28.1 HR511 HR515 HR54.1 HR55.2 HR70.1
HRS1.1 HRSC.1 HS703 HS705 LT101 LT11.5
LT11.6 LT213 ZH156 ZH500 ZH510 LP100
LP101 PA02.1 PA06.1 PA10.1 PA100 PA102
PA111 PA113 PA115 PA13.1 PA13.2 PA13.3
PA149 PA16.1 PA182 PA20.1 PA201 PA21.1
PA210 PA211 PA213 PA218 PA22.1 PA24.1
PA249 PA258 PA27.1 PA272 PA302 PA311
PA313 PA34.1 PA35.1 PA36.1 PA38.1 PA402
PA406 PA49.1 PA49.3 PA496 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PA520 PA53.1
PA54.1 PA549 PA66.3 TR21.1 TR22.1 TR26.1
TR500 ZE521 ZE531 ZE540 PR110 PR113
PR12.6 PR120 PR128 PR13.1 PR13.5 PR13.6
PR13.8 PR13.9 PR216 PR30.2 PR33.2 PR33.3

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEP-COMPANY
Element: Company Hr
Numeric 4
Contains the number that represents an established company and is entered on all functions.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-EMPLOYEE
Element: Employee
Numeric 9
Contains 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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-POSITION
Element: Position
Alpha 12
Contains 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
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-POS-LEVEL
Element: Pos Level
Numeric 2
Contains the position level. Indicates if this level is the first, second, or third level for the employee.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-FTE
Element: Fte
Signed 11.6
Contains the level's FTE.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-EFFECT-DATE
Element: 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
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-END-DATE
Element: 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
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-JOB-CODE
Element: Job Code
Alpha 9
Contains 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
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-DEPARTMENT
Element: Department
Alpha 5
Contains the department.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-PAY-RATE
Element: Pay Rate
Signed 13.4
Contains the level's rate of pay.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-USER-LEVEL
Element: User Level
Alpha 10
Contains the level's user level.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-LOCAT-CODE
Element: Locat Code
Alpha 10
Contains the level's location.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-SUPERVISOR
Element: Supervisor
Alpha 10
Contains the level's supervisor.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-SUPERVISOR-IND
Element: Supervisor Ind
Alpha 10
Contains the level's indirect supervisor.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-UNION-CODE
Element: Union Code
Alpha 10
Contains the union code for this level.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-BARGAIN-UNIT
Element: Bargain Unit
Alpha 10
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-DATE-ASSIGN
Element: Date Assign
Numeric 8 (yyyymmdd)
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-WORK-SCHED
Element: Work Sched
Alpha 10
Contains the work schedule for this level.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-SHIFT
Element: Shift
Numeric 1
Contains 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
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-SCHEDULE
Element: Schedule
Alpha 9
Contains the grade range or step schedule for this level.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-PAY-GRADE
Element: Pay Grade
Alpha 3
Contains the grade for this level.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-PAY-STEP
Element: Pay Step
Numeric 2
Contains the step for this level.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-EXP-COMPANY
Element: Company
Numeric 4
Contains the gl expense company for this level.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-EXP-ACCT-UNIT
Element: Acct Unit
Alpha 15
Contains the gl expense account unit for this level.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-EXP-ACCOUNT
Element: Account
Numeric 6
Contains the gl distribution account number for this level.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-EXP-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the gl distribution expense subaccount for this level.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-ACTIVITY
Element: Activity
Alpha 15
Activities 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
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-ACCT-CATEGORY
Element: Acct Category
Alpha 5
Account 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 thru
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-POS-EFF-DT
Element: 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
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-ANNUAL-HOURS
Element: Annual Hours
Numeric 4
Contains the annual hours for this level.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-PRO-RATE-A-SAL
Element: Pay Rate
Signed 13.4
Contains 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
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-DATE-STAMP
Element: 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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-USER-ID
Element: User
Alpha 10 (Lower Case)
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-CURRENCY-CODE
Element: Currency Code
Alpha 5
Contains the currency for the pay rate at this level.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-BASE-CURRENCY
Element: Base Currency
Alpha 5
Contains 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
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-BASE-PAY-RATE
Element: Pay Rate
Signed 13.4
Contains 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
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEP-USER-AMOUNT
Element: Pay Rate
Signed 13.4
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510


PAEMPPOS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEPSET1 COMPANY
EMPLOYEE
POS-LEVEL
EFFECT-DATE
...
BN305 HC01.2
HCDL.1 HCEM.1
HCHP.1 HAP3.1
HCRE.1 HEP4.1
HLTM.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR217
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
LT11.6 LT213
ZH510 PA02.1
PA06.1 PA100
PEPSET2 COMPANY
EMPLOYEE
POS-LEVEL
EFFECT-DATE
Subset
Where(END-DATE =Zeroes)
...
BN305 HC01.2
HCDL.1 HCEM.1
HAP3.1 HCRE.1
HEP4.1 HLTM.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR170 HR217
HR28.1 HR511
HR515 HR54.1
HR55.2 HR70.1
HRS1.1 HRSC.1
LT101 ZH156
ZH500 ZH510
PEPSET3 COMPANY
EMPLOYEE
POS-LEVEL
EFFECT-DATE*
...
BN150 BN305
HC01.2 HCDL.1
HCEM.1 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR170 HR217
HR28.1 HR511
HR515 HR54.1
HR55.2 HR70.1
HRS1.1 HRSC.1
HS703 HS705
LT101 LT11.5
PEPSET4 COMPANY
POSITION
EMPLOYEE
POS-LEVEL
EFFECT-DATE
KeyChange
HLTM.1 LT101
LP180 PA02.1
PA10.1 PA102
PA201 PA210
PA211 PA272
PA302 PA402
PA502
PEPSET5 COMPANY
EMPLOYEE
POSITION
JOB-CODE
PROCESS-LEVEL
DEPARTMENT
EFFECT-DATE*
POS-LEVEL
KeyChange
HR11.2 HR511
LT101 LP100
LP140 LP145
LP198 PA02.1
PA10.1 PA100
PA102 PA13.1
PA13.2 PA213
PA502 PA513
PA52.5 PR110
PEPSET6 COMPANY
EMPLOYEE
POSITION
EFFECT-DATE*
POS-LEVEL
KeyChange, Subset
Where(POSITION !=Spaces)
...
BN150 PR521
EXI2.1 EXI4.1
LP100 LP101
LP130 LP140
LP145 LP198
PA210 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PEPSET7 COMPANY
EMPLOYEE
JOB-CODE
PROCESS-LEVEL
DEPARTMENT
EFFECT-DATE*
POS-LEVEL
KeyChange, Subset
Where(POSITION =Spaces)
...
BN150 PR521
EXI2.1 EXI4.1
LP130 PA211
PR128 PR130
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PEPSET9 COMPANY
EMPLOYEE
JOB-CODE
EFFECT-DATE
POS-LEVEL
KeyChange, Subset
Where(JOB-CODE !=Spaces)
PA10.1


PAEMPPOS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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-CONTRACT-YEAR
  WSC-EFFECT-DATE


File created: Thu Jun 09 11:15:24 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.