|
PAERECRUIT FILE
UPDATED BY
BN305 HR00.1 HR01.1 HR02.1 HR04.2 HR04.3
HR04.7 HR04.8 HR06.1 HR07.1 HR11.1 HR11.2
HR506 HR507 HR511 HR80.1 HR80.2 HR80.3
HR80.4 HR80.5 HR80.6 HR80.7 HR80.8 HR80.9
HR81.1 HR81.2 HR81.3 HR81.4 HR81.5 HR81.6
HR81.7 HR81.8 HR81.9 HR82.1 HR82.2 HR82.3
HR82.4 HR82.5 HR82.6 HR82.7 HR82.8 HR82.9
HR83.1 HR83.2 HR83.3 HR83.4 HR83.5 HR83.6
HR83.7 HR83.8 HR83.9 HR84.1 HR84.2 HR84.3
HR84.4 HR84.5 HR84.6 HR84.7 HR84.8 HR84.9
HR85.1 HR85.2 HR85.3 HR85.4 HR85.5 HR85.6
HR85.7 HR85.8 HR86.1 HR86.2 HR86.3 HR86.4
HR86.5 HR86.6 HR86.7 HR86.8 HR86.9 HR87.1
HR87.2 HR87.3 HR87.4 HR87.5 HR87.6 HR87.7
HR87.8 HR87.9 HR88.1 HR88.2 HR88.3 HR88.4
HR88.5 HR88.6 HR88.7 HR89.1 HR89.2 HR89.3
HR89.4 HR89.5 HR89.6 HR89.7 HR89.8 HR89.9
HR91.7 PA02.1 PA100 PA102 PA115 PA13.1
PA13.2 PA20.1 PA21.1 PA22.1 PA24.1 PA27.1
PA34.1 PA35.1 PA36.1 PA38.1 PA47.1 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PA520
PA532 PA534 TR21.1 TR26.1 PR110 PR113
PR120 PR13.1 PR13.5 PR13.6 PR13.8
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEU-RECRD-TYPE Numeric 2 BN305 HR00.1
Element: Recrd Type 01 = Employee General Data HR01.1 HR02.1
09 = Employee General Data HR04.2 HR04.3
10 = Employee Educ/Certs/Comp HR04.7 HR04.8
19 = Employee Educ/Certs/Comp HR06.1 HR07.1
20 = Requisition Data HR11.1 HR11.2
29 = Requisition Data HR506 HR507
30 = Codes HR511 HR80.1
31 = Company HR80.2 HR80.3
32 = Process Level HR80.4 HR80.5
33 = Department HR80.6 HR80.7
34 = Supervisor HR80.8 HR80.9
35 = Country HR81.1 HR81.2
36 = Education Degree HR81.3 HR81.4
37 = Competency HR81.5 HR81.6
38 = Certification HR81.7 HR81.8
39 = Requisition Cost Code HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
...
PEU-COMPANY Numeric 4 BN305 HR00.1
Element: Company Hr HR01.1 HR02.1
HR04.2 HR04.3
HR04.7 HR04.8
HR06.1 HR07.1
HR11.1 HR11.2
HR506 HR507
HR511 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
...
PEU-PROCESS-LEVEL Alpha 5 BN305 HR00.1
Element: Process Lev Hr HR01.1 HR02.1
HR04.2 HR04.3
HR04.7 HR04.8
HR06.1 HR07.1
HR11.1 HR11.2
HR506 HR507
HR511 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
...
PEU-EMPLOYEE Numeric 9 BN305 HR00.1
Element: Employee Contains the employee number. Each HR01.1 HR02.1
person employed by the company is HR04.2 HR04.3
assigned a unique number. The system HR04.7 HR04.8
uses the employee number to correlate HR06.1 HR07.1
all of the information related to that HR11.1 HR11.2
person. HR506 HR507
HR511 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
...
PEU-CODE Alpha 10 BN305 HR00.1
Element: Code Code that is valid for the specified HR01.1 HR02.1
record type. HR04.2 HR04.3
HR04.7 HR04.8
HR06.1 HR07.1
HR11.1 HR11.2
HR506 HR507
HR511 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
...
PEU-TYPE Alpha 2 BN305 HR00.1
Element: Type This identifies whether this record is HR01.1 HR02.1
created because of a picking HR04.2 HR04.3
transaction, or because of a return. HR04.7 HR04.8
Valid values are: HR06.1 HR07.1
"IS" = Picking transaction. HR11.1 HR11.2
"RR" = Return. HR506 HR507
~$1 VENDOR HR511 HR80.1
The vendor's identification code. HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
...
PEU-SUBJECT Alpha 10 BN305 HR00.1
Element: Subject HR01.1 HR02.1
HR04.2 HR04.3
HR04.7 HR04.8
HR06.1 HR07.1
HR11.1 HR11.2
HR506 HR507
HR511 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
...
PEU-SEQ-NBR Numeric 4 BN305 HR00.1
Element: Seq Nbr An automatically assigned sequence HR01.1 HR02.1
number. HR04.2 HR04.3
HR04.7 HR04.8
HR06.1 HR07.1
HR11.1 HR11.2
HR506 HR507
HR511 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
...
PEU-ACTION Alpha 1 BN305 HR00.1
Element: Action A = Add HR01.1 HR02.1
C = Change HR04.2 HR04.3
D = Delete HR04.7 HR04.8
HR06.1 HR07.1
HR11.1 HR11.2
HR506 HR507
HR511 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
...
PEU-SELECTION Alpha 100 BN305 HR00.1
Element: Selection HR01.1 HR02.1
HR04.2 HR04.3
HR04.7 HR04.8
HR06.1 HR07.1
HR11.1 HR11.2
HR506 HR507
HR511 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
...
PEU-DATE-STAMP Numeric 8 (yyyymmdd) BN305 HR00.1
Element: Date Stamp This field contains the server date HR01.1 HR02.1
(month, date, and year) of the last HR04.2 HR04.3
change to this record. HR04.7 HR04.8
HR06.1 HR07.1
HR11.1 HR11.2
HR506 HR507
HR511 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
...
PEU-TIME-STAMP Numeric 6 (hhmmss) BN305 HR00.1
Element: Time Stamp Contains the server time (hour, minute, HR01.1 HR02.1
and second) when the record was last HR04.2 HR04.3
changed. HR04.7 HR04.8
HR06.1 HR07.1
HR11.1 HR11.2
HR506 HR507
HR511 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
...
PEU-DATE-STAMP2 Numeric 8 (yyyymmdd) BN305 HR00.1
Element: Date Stamp2 HR01.1 HR02.1
HR04.2 HR04.3
HR04.7 HR04.8
HR06.1 HR07.1
HR11.1 HR11.2
HR506 HR507
HR511 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
...
PEU-TIME-STAMP2 Numeric 6 (hhmmss) BN305 HR00.1
Element: Time Stamp2 HR01.1 HR02.1
HR04.2 HR04.3
HR04.7 HR04.8
HR06.1 HR07.1
HR11.1 HR11.2
HR506 HR507
HR511 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
...
PAERECRUIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEUSET1 RECRD-TYPE BN305 HR00.1
COMPANY HR01.1 HR02.1
PROCESS-LEVEL HR04.2 HR04.3
EMPLOYEE HR04.7 HR04.8
CODE HR06.1 HR07.1
TYPE HR11.1 HR11.2
SUBJECT HR506 HR507
SEQ-NBR HR511 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
...
PAERECRUIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|