 |
Lawson Insight Technical Documentation |
|
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 TR21.1 TR22.1
TR26.1 TR500 PR216 PA311 PA496 PR33.2
PR33.3 PA201 PA211 PA302 PA402 AC541
AC542 AC550 AC551 BN150 PR130 PR131
PR132 PR134 PR136 PR189 PR29.1 PR32.2
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 TA147 UK120
UPDATED BY
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
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
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 HR11.1 HR11.2
Position Contains the user-defined code that HR15.1 HR511
represents a position in the company. 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
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 HR11.1 HR11.2
Fte Contains the level's FTE. 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) HR11.1 HR11.2
Effective Date Contains the effective date for the HR15.1 HR511
level. 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) HR11.1 HR11.2
Ending Date Contains the employee's ending date in HR15.1 HR511
this level. 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 HR11.1 HR11.2
Job Code Contains a user-defined code that HR15.1 HR511
represents a type of job. 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 HR11.1 HR11.2
Process Level This field contains the process level, HR15.1 HR511
which is the reporting hierarchy below HR515 HR54.1
company. 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 HR11.1 HR11.2
Department Contains the department. 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 HR11.1 HR11.2
Rate of Pay Contains the level's rate of pay. 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 HR11.1 HR11.2
User Level Contains the level's user level. 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 HR11.1 HR11.2
Location Contains the level's location. 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 HR11.1 HR11.2
Supervisor Contains the level's supervisor. 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 HR11.1 HR11.2
Supervisor Ind Contains the level's indirect HR15.1 HR511
supervisor. 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 HR11.1 HR11.2
Union Code Contains the union code for this level. 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 HR11.1 HR11.2
Work Schedule Contains the work schedule for this HR15.1 HR511
level. 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 HR11.1 HR11.2
Shift Contains the shift number associated HR15.1 HR511
with the level. HR515 HR54.1
1 = Shift 1 HR650 HRS1.1
2 = Shift 2 HRSC.1 PA02.1
3 = Shift 3 PA100 PA102
4 = Shift 4 PA113 PA13.1
5 = Shift 5 PA13.2 PA502
6 = Shift 6 PA513 PA52.1
7 = Shift 7 PA52.3 PA52.4
8 = Shift 8 PA52.5 PA54.1
9 = Shift 9 PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
PEP-SCHEDULE Alpha 9 HR11.1 HR11.2
Schedule Contains the grade range or step HR15.1 HR511
schedule for this level. 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 HR11.1 HR11.2
Grade Contains the grade for this level. 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 HR11.1 HR11.2
Step Contains the step for this level. 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 HR11.1 HR11.2
Exp Company Contains the gl expense company for HR15.1 HR511
this level. 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 HR11.1 HR11.2
Expense Accounting Contains the gl expense account unit HR15.1 HR511
Unit for this level. 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 HR11.1 HR11.2
Expense Account Contains the gl distribution account HR15.1 HR511
number for this level. 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 HR11.1 HR11.2
Depr Expense Contains the gl distribution expense HR15.1 HR511
Subaccount subaccount for this level. 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 HR11.1 HR11.2
Activity Activities are the processes or HR15.1 HR511
procedures that produce work. Cost HR515 HR54.1
objects (products, services, customers, HR650 HRS1.1
and so on) are the reasons for HRSC.1 PA02.1
performing the activity. 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 HR11.1 HR11.2
Account Category Account categories are groupings of HR15.1 HR511
costs, revenues, or a combination of HR515 HR54.1
both used for reporting and inquiries HR650 HRS1.1
for activities in the Activity HRSC.1 PA02.1
Management system. All transactions are PA100 PA102
posted to an account category within an PA113 PA13.1
activity. You can assign a specific PA13.2 PA502
General Ledger account or range of PA513 PA52.1
accounts (company, accounting unit, PA52.3 PA52.4
account, and subaccount) that make up PA52.5 PA54.1
the transactions posted to an account PR110 PR113
category using AC07.1 (Account PR120 PR13.1
Assignment). PR13.5 PR13.6
PR13.8 PRSC.1
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 HR11.2
Pos Eff Dt If this level uses a position, contains HR15.1 HR511
the effective date of the position end. 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 HR11.1 HR11.2
Annual Hours Contains the annual hours for this HR15.1 HR511
level. 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 HR11.1 HR11.2
Pro Rate A Sal Contains the prorated salary for this HR15.1 HR511
level. HR515 HR54.1
HR650 HRS1.1
If the employee is salaried, the total HRSC.1 PA02.1
prorated salary is the same as the rate PA100 PA102
of pay. PA113 PA13.1
PA13.2 PA502
If the employee is hourly, the total PA513 PA52.1
prorated salary is the sum of the pay PA52.3 PA52.4
rate times the annual hours times the PA52.5 PA54.1
FTE for each position level. PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
PEP-DATE-STAMP Numeric 8 (yyyymmdd) HR11.1 HR11.2
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
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
User ID Name Contains the user ID of the person who HR511 HR650
last changed this record. 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
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
Currency Number of Represents the number of decimals HR511 HR650
Decimals defined for the currency of the object. 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
Base Currency Contains the employee's base currency. HR511 HR650
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
Base Number Of The number of decimal positions defined HR511 HR650
Decimals for the company base currency. 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 HR11.1 HR11.2
Base Pay Rate Contains the pay rate for this level as HR15.1 HR511
translated into the base currency. 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 HR11.1
EFFECT-DATE 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
PA313 PA502
PA513 PA52.1
...
PEPSET2 COMPANY Subset HC01.1 HC02.1
EMPLOYEE Where (END-DATE = Zeroes ) HCEM.1 HCOP.1
POS-LEVEL HR11.1 HR11.2
EFFECT-DATE HR15.1 HR155
HR170 HR217
HR511 HR54.1
HR55.2 HR650
HR70.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA111 PA113
PA13.1 PA13.2
PA149 PA16.1
PA20.1 PA21.1
PA213 PA218
...
PEPSET3 COMPANY HC01.1 HC02.1
EMPLOYEE HCEM.1 HCOP.1
POS-LEVEL HR11.1 HR11.2
EFFECT-DATE* HR15.1 HR217
HR511 HR515
HR54.1 HR650
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA13.1 PA13.2
PA149 PA213
PA218 PA272
PA311 PA313
PA496 PA502
PA513 PA52.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
|