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