| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
PEU-RECRD-TYPE
Element: Recrd Type | Numeric 2
01 = Employee General Data
09 = Employee General Data
10 = Employee Educ/Certs/Comp
19 = Employee Educ/Certs/Comp
20 = Requisition Data
29 = Requisition Data
30 = Codes
31 = Company
32 = Process Level
33 = Department
34 = Supervisor
35 = Country
36 = Education Degree
37 = Competency
38 = Certification
39 = Requisition Cost Code |
|
PEU-COMPANY
Element: Company Hr | Numeric 4
|
|
PEU-PROCESS-LEVEL
Element: Process Lev Hr | Alpha 5
|
|
PEU-EMPLOYEE
Element: Employee | Numeric 9
Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
|
|
PEU-CODE
Element: Code | Alpha 10
Code that is valid for the specified
record type.
|
|
PEU-TYPE
Element: Type | Alpha 2
This identifies whether this record is
created because of a picking
transaction, or because of a return.
Valid values are:
"IS" = Picking transaction.
"RR" = Return.
~$1 VENDOR
The vendor's identification code.
|
|
PEU-SUBJECT
Element: Subject | Alpha 10
|
|
PEU-SEQ-NBR
Element: Seq Nbr | Numeric 4
An automatically assigned sequence
number.
|
|
PEU-ACTION
Element: Action | Alpha 1
A = Add
C = Change
D = Delete |
|
PEU-SELECTION
Element: Selection | Alpha 100
|
|
PEU-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.
|
|
PEU-TIME-STAMP
Element: Time Stamp | Numeric 6 (hhmmss)
Contains the server time (hour, minute,
and second) when the record was last
changed.
|
|
PEU-DATE-STAMP2
Element: Date Stamp2 | Numeric 8 (yyyymmdd)
|
|
PEU-TIME-STAMP2
Element: Time Stamp2 | Numeric 6 (hhmmss)
|
|
RELATION
NAME |
RELATED FILE |
INTEGRITY RULES / FIELD MATCH |
| Company |
PRSYSTEM |
Required
| When | ( | PEU-RECRD-TYPE | = | 31 | |
| And | | PEU-ACTION | != | "D" | ) |
| Or | ( | PEU-RECRD-TYPE | != | 31 | |
| And | | PEU-COMPANY | != | Zeroes | ) |
| PEU-COMPANY | -> | PRS-COMPANY |
| Spaces | -> | PRS-PROCESS-LEVEL |
|
| Department |
DEPTCODE |
Required
| When | | PEU-RECRD-TYPE | = | 33 | |
| And | | PEU-ACTION | != | "D" | |
| PEU-COMPANY | -> | DPT-COMPANY |
| PEU-PROCESS-LEVEL | -> | DPT-PROCESS-LEVEL |
| PEU-CODE | -> | DPT-DEPARTMENT |
|
| Empcodes |
EMPCODES |
Required
| When | ( | PEU-RECRD-TYPE | >= | 10 | |
| And | | PEU-RECRD-TYPE | <= | 19 | ) |
| And | | PEU-ACTION | != | "D" | |
| PEU-COMPANY | -> | EPC-COMPANY |
| PEU-TYPE | -> | EPC-TYPE |
| Zeroes | -> | EPC-EMP-APP |
| PEU-EMPLOYEE | -> | EPC-EMPLOYEE |
| PEU-CODE | -> | EPC-CODE |
| PEU-SUBJECT | -> | EPC-SUBJECT |
| PEU-SEQ-NBR | -> | EPC-SEQ-NBR |
|
| Employee |
EMPLOYEE |
Required
| When | | PEU-RECRD-TYPE | <= | 19 | |
| And | | PEU-EMPLOYEE | != | Zeroes | |
| And | | PEU-ACTION | != | "D" | |
| PEU-COMPANY | -> | EMP-COMPANY |
| PEU-EMPLOYEE | -> | EMP-EMPLOYEE |
|
| Paemployee |
PAEMPLOYEE |
Required
| When | | PEU-RECRD-TYPE | <= | 19 | |
| And | | PEU-EMPLOYEE | != | Zeroes | |
| And | | PEU-ACTION | != | "D" | |
| PEU-COMPANY | -> | PEM-COMPANY |
| PEU-EMPLOYEE | -> | PEM-EMPLOYEE |
|
| Pcodes |
PCODES |
Required
| When | ( | PEU-RECRD-TYPE | >= | 36 | |
| And | | PEU-RECRD-TYPE | <= | 39 | ) |
| And | | PEU-ACTION | != | "D" | |
| PEU-TYPE | -> | PCO-TYPE |
| PEU-CODE | -> | PCO-CODE |
|
| Process Level |
PRSYSTEM |
Required
| When | | PEU-PROCESS-LEVEL | != | Spaces | |
| And | | PEU-ACTION | != | "D" | |
| PEU-COMPANY | -> | PRS-COMPANY |
| PEU-PROCESS-LEVEL | -> | PRS-PROCESS-LEVEL |
|
| Requisition |
PAJOBREQ |
Required
| When | ( | PEU-RECRD-TYPE | >= | 20 | |
| And | | PEU-RECRD-TYPE | <= | 29 | ) |
| And | | PEU-ACTION | != | "D" | |
| PEU-COMPANY | -> | PJR-COMPANY |
| PEU-EMPLOYEE | -> | PJR-REQUISITION |
|
| Supervisor |
HRSUPER |
Required
| When | | PEU-RECRD-TYPE | = | 34 | |
| And | | PEU-ACTION | != | "D" | |
| PEU-COMPANY | -> | HSU-COMPANY |
| PEU-CODE | -> | HSU-CODE |
|
