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 HRS1.1
HRSC.1 PA06.1 PA149 PA272 PR128 HR15.1
HR155 HR170 HR54.1 HR55.2 HR70.1 PA111
PA16.1 PA20.1 PA21.1 PA213 PA22.1 PA24.1
PA249 PA34.1 PA35.1 PA36.1 PA38.1 PA406
PA49.1 PA49.3 PA520 PA54.1 PA549 PA66.3
TR21.1 TR22.1 TR500 PR216 BN150 PA311
PR131 PR132 PR134 PR136 PR32.2 PR32.1
PR33.2 PR33.3 PR33.1 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR36.1 PR530
PR80.1 PR82.1 UK102 UK120 PA201 PA211
PA302 PA402 AC750 PR137 PR140 PR150
PR195 PR199 PR37.1 PR45.1 PR85.1 UK330
UPDATED BY
HR11.1 HR511 HR700 PA02.1 PA100 PA102
PA13.1 PA13.2 PA313 PA502 PA513 PA52.1
PA52.3 PA52.4 PA52.5 PR110 PR13.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEP-COMPANY Numeric 4 HR11.1 HR511
Company Contains the number that represents an PA02.1 PA100
established company and is entered on PA102 PA13.1
all functions. PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-EMPLOYEE Numeric 9 HR11.1 HR511
Employee Contains the employee number. An PA02.1 PA100
employee number is assigned to each PA102 PA13.1
person employed by the company. The PA13.2 PA502
system uses the employee number to PA513 PA52.1
correlate all information related to the PA52.3 PA52.4
employee. PA52.5 PR13.1
PEP-POSITION Alpha 12 HR11.1 HR511
Position Contains the user-defined code that PA02.1 PA100
represents a position in the company. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-POS-LEVEL Numeric 2 HR11.1 HR511
Pos Level Contains the position level. Indicates PA02.1 PA100
if this level is the first, second, or PA102 PA13.1
third level for the employee. PA13.2 PA502
01 = Level 1 PA513 PA52.1
02 = Level 2 PA52.3 PA52.4
03 = Level 3 PA52.5 PR13.1
04 = Level 4
05 = Level 5
PEP-FTE Signed 8.3 HR11.1 HR511
Fte Contains the level's FTE. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-EFFECT-DATE Numeric 8 (yyyymmdd) HR11.1 HR511
Effective Date Contains the effective date for the PA02.1 PA100
level. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR13.1
PEP-END-DATE Numeric 8 (yyyymmdd) HR11.1 HR511
Ending Date Contains the employee's ending date in PA02.1 PA100
this level. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR13.1
PEP-JOB-CODE Alpha 9 HR11.1 HR511
Job Code Contains a user-defined code that PA02.1 PA100
represents a type of job. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-PROCESS-LEVEL Alpha 5 HR11.1 HR511
Process Level This field contains the process level, PA02.1 PA100
which is the reporting hierarchy below PA102 PA13.1
company. PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-DEPARTMENT Alpha 5 HR11.1 HR511
Department Contains the department. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-PAY-RATE Signed 13.4 HR11.1 HR511
Rate of Pay Contains the level's rate of pay. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR13.1
PEP-USER-LEVEL Alpha 10 HR11.1 HR511
User Level Contains the level's user level. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-LOCAT-CODE Alpha 10 HR11.1 HR511
Location Contains the level's location. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-SUPERVISOR Alpha 10 HR11.1 HR511
Supervisor Contains the level's supervisor. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-SUPERVISOR-IND Alpha 10 HR11.1 HR511
Supervisor Ind Contains the level's indirect PA02.1 PA100
supervisor. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-UNION-CODE Alpha 10 HR11.1 HR511
Union Code Contains the union code for this level. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-WORK-SCHED Alpha 10 HR11.1 HR511
Work Schedule Contains the work schedule for this PA02.1 PA100
level. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-SHIFT Numeric 1 HR11.1 HR511
Shift Contains the shift number associated PA02.1 PA100
with the level. PA102 PA13.1
1 = Shift 1 PA13.2 PA502
2 = Shift 2 PA513 PA52.1
3 = Shift 3 PA52.3 PA52.4
4 = Shift 4 PA52.5 PR13.1
5 = Shift 5
6 = Shift 6
7 = Shift 7
8 = Shift 8
9 = Shift 9
PEP-SCHEDULE Alpha 9 HR11.1 HR511
Schedule Contains the grade range or step PA02.1 PA100
schedule for this level. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-PAY-GRADE Alpha 3 HR11.1 HR511
Grade Contains the grade for this level. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-PAY-STEP Numeric 2 HR11.1 HR511
Step Contains the step for this level. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-EXP-COMPANY Numeric 4 HR11.1 HR511
Exp Company Contains the gl expense company for this PA02.1 PA100
level. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-EXP-ACCT-UNIT Alpha 15 HR11.1 HR511
Expense Accounting Contains the gl expense account unit for PA02.1 PA100
Unit this level. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-EXP-ACCOUNT Numeric 6 HR11.1 HR511
Expense Account Contains the gl distribution account PA02.1 PA100
number for this level. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-EXP-SUB-ACCT Numeric 4 HR11.1 HR511
Depr Expense Contains the gl distribution expense PA02.1 PA100
Subaccount subaccount for this level. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-ACTIVITY Alpha 15 HR11.1 HR511
Activity Activities are the processes or PA02.1 PA100
procedures that produce work. Cost PA102 PA13.1
objects (products, services, customers, PA13.2 PA502
and so on) are the reasons for PA513 PA52.1
performing the activity. Activities and PA52.3 PA52.4
cost object activities are used PA52.5 PR13.1
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two kinds of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
PEP-ACCT-CATEGORY Alpha 5 HR11.1 HR511
Account Category Account categories are groupings of PA02.1 PA100
costs, revenues, or a combination of PA102 PA13.1
both used for reporting and inquiries PA13.2 PA502
for activities in the Activity PA513 PA52.1
Management system. All transactions are PA52.3 PA52.4
posted to an account category within an PA52.5 PR13.1
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) HR11.1 HR511
Pos Eff Dt If this level uses a position, contains PA02.1 PA100
the effective date of the position end. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-ANNUAL-HOURS Numeric 4 HR11.1 HR511
Annual Hours Contains the annual hours for this PA02.1 PA100
level. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEP-PRO-RATE-A-SAL Signed 13.4 HR11.1 HR511
Pro Rate A Sal Contains the prorated salary for this PA02.1 PA100
level. PA102 PA13.1
PA13.2 PA502
If the employee is salaried, the total PA513 PA52.1
prorated salary is the same as the rate PA52.3 PA52.4
of pay. PA52.5 PR110
PR13.1
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) HR11.1 HR511
Date Stamp Contains the server date (month, date, PA02.1 PA100
and year) of the last change to this PA102 PA13.1
record. PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR13.1
PEP-TIME-STAMP Numeric 6 (hhmmss) HR11.1 HR511
Time Stamp Contains the server time (hour, minute, PA02.1 PA100
and second) when the record was last PA102 PA13.1
changed. PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR13.1
PEP-USER-ID Alpha 10 (Lower Case) HR11.1 HR511
User ID Name Contains the user ID of the person who PA02.1 PA100
last changed this record. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR13.1
PEP-CURRENCY-CODE Alpha 5 HR11.1 HR511
Currency Code Contains the currency for the pay rate HR700 PA02.1
at this level. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEP-CURR-ND Numeric 1 HR11.1 HR511
Currency Number of Represents the number of decimals HR700 PA02.1
Decimals defined for the currency of the object. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEP-BASE-CURRENCY Alpha 5 HR11.1 HR511
Base Currency Contains the employee's base currency. HR700 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
PR13.1
PEP-BASE-ND Numeric 1 HR11.1 HR511
Base Number Of The number of decimal positions defined HR700 PA02.1
Decimals for the company base currency. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEP-BASE-PAY-RATE Signed 13.4 HR11.1 HR511
Base Pay Rate Contains the pay rate for this level as HR700 PA02.1
translated into the base currency. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR13.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 HR11.1
EFFECT-DATE HR511 HR700
HRS1.1 HRSC.1
PA02.1 PA06.1
PA100 PA102
PA115 PA13.1
PA13.2 PA149
PA272 PA313
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR128 PR13.1
PEPSET2 COMPANY Subset HC01.1 HC02.1
EMPLOYEE Where (END-DATE = Zeroes ) HCEM.1 HCOP.1
POS-LEVEL HR11.1 HR15.1
EFFECT-DATE HR155 HR170
HR511 HR54.1
HR55.2 HR70.1
HR700 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA111 PA13.1
PA13.2 PA149
PA16.1 PA20.1
PA21.1 PA213
PA22.1 PA24.1
PA249 PA272
...
PEPSET3 COMPANY BN150 HC01.1
EMPLOYEE HC02.1 HCEM.1
POS-LEVEL HCOP.1 HR11.1
EFFECT-DATE* HR511 HR54.1
PA02.1 PA100
PA102 PA13.1
PA13.2 PA149
PA213 PA272
PA311 PA313
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR128
PR13.1 PR131
PR132 PR134
...
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
DEPARTMENT
EFFECT-DATE*
POS-LEVEL
PEPSET6 COMPANY KeyChange, Subset AC750 BN150
EMPLOYEE Where (POSITION != Spaces ) PR128 PR131
POSITION PR132 PR134
EFFECT-DATE* PR136 PR137
POS-LEVEL PR140 PR150
PR195 PR199
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR530
PR80.1 PR82.1
...
PEPSET7 COMPANY KeyChange, Subset BN150 PA211
EMPLOYEE Where (POSITION = Spaces ) PR128 PR131
JOB-CODE PR132 PR134
PROCESS-LEVEL PR136 PR137
DEPARTMENT PR140 PR150
EFFECT-DATE* PR195 PR199
POS-LEVEL PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR530
PR80.1 PR82.1
...
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
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
|