PAERECRUIT – No description in the Lawson data dictionary

System
Personnel (PA)
Prefix
PEU
Primary key
RECRD-TYPE, COMPANY, PROCESS-LEVEL, EMPLOYEE, CODE, TYPE, SUBJECT, SEQ-NBR
Fields
14
Updated by
149 programs
Referenced by
0 programs

PAERECRUIT is a Lawson Personnel table (prefix PEU); no description in the lawson data dictionary. It is indexed by RECRD-TYPE, COMPANY, PROCESS-LEVEL, EMPLOYEE, CODE, TYPE, SUBJECT, SEQ-NBR (PEUSET1). It is related 1:1 to PRSYSTEM, DEPTCODE, EMPCODES, EMPLOYEE, PAEMPLOYEE, PCODES, PAJOBREQ and HRSUPER. It is updated by BN305, HR00.1, HR01.1, HR02.1, HR04.2, HR04.3, HR04.7, HR04.8 and 141 more. The table has 14 fields, 1 index and 9 documented relations.

About PAERECRUIT

No description in the Lawson data dictionary.

Fields (14)

Column = COBOL field name without the PEU- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PEU-RECRD-TYPE PK
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
BN305, HR00.1, HR01.1, HR02.1, HR04.2, HR04.3, HR04.7, HR04.8 +52 more (list truncated in source)
#PEU-COMPANY PK
COMPANY		Numeric 4—BN305, HR00.1, HR01.1, HR02.1, HR04.2, HR04.3, HR04.7, HR04.8 +52 more (list truncated in source)
#PEU-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5—BN305, HR00.1, HR01.1, HR02.1, HR04.2, HR04.3, HR04.7, HR04.8 +52 more (list truncated in source)
#PEU-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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.BN305, HR00.1, HR01.1, HR02.1, HR04.2, HR04.3, HR04.7, HR04.8 +52 more (list truncated in source)
#PEU-CODE PK
CODE		Alpha 10Code that is valid for the specified record type.BN305, HR00.1, HR01.1, HR02.1, HR04.2, HR04.3, HR04.7, HR04.8 +52 more (list truncated in source)
#PEU-TYPE PK
TYPE		Alpha 2This 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.BN305, HR00.1, HR01.1, HR02.1, HR04.2, HR04.3, HR04.7, HR04.8 +52 more (list truncated in source)
#PEU-SUBJECT PK
SUBJECT		Alpha 10—BN305, HR00.1, HR01.1, HR02.1, HR04.2, HR04.3, HR04.7, HR04.8 +52 more (list truncated in source)
#PEU-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.BN305, HR00.1, HR01.1, HR02.1, HR04.2, HR04.3, HR04.7, HR04.8 +52 more (list truncated in source)
#PEU-ACTION
ACTION		Alpha 1—
  • A Add
  • C Change
  • D Delete
BN305, HR00.1, HR01.1, HR02.1, HR04.2, HR04.3, HR04.7, HR04.8 +52 more (list truncated in source)
#PEU-SELECTION
SELECTION		Alpha 100—BN305, HR00.1, HR01.1, HR02.1, HR04.2, HR04.3, HR04.7, HR04.8 +52 more (list truncated in source)
#PEU-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.BN305, HR00.1, HR01.1, HR02.1, HR04.2, HR04.3, HR04.7, HR04.8 +52 more (list truncated in source)
#PEU-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BN305, HR00.1, HR01.1, HR02.1, HR04.2, HR04.3, HR04.7, HR04.8 +52 more (list truncated in source)
#PEU-DATE-STAMP2
DATE_STAMP2		Numeric 8 (yyyymmdd)—BN305, HR00.1, HR01.1, HR02.1, HR04.2, HR04.3, HR04.7, HR04.8 +52 more (list truncated in source)
#PEU-TIME-STAMP2
TIME_STAMP2		Numeric 6 (hhmmss)—BN305, HR00.1, HR01.1, HR02.1, HR04.2, HR04.3, HR04.7, HR04.8 +52 more (list truncated in source)

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PEUSET1
  1. RECRD-TYPE
  2. COMPANY
  3. PROCESS-LEVEL
  4. EMPLOYEE
  5. CODE
  6. TYPE
  7. SUBJECT
  8. SEQ-NBR
PrimaryBN305, HR00.1, HR01.1, HR02.1, HR04.2, HR04.3, HR04.7, HR04.8 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMDEPTCODEEMPCODESEMPLOYEEPAEMPLOYEEPCODESPAJOBREQHRSUPERPAERECRUIT

One to one (9) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredWhen (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
DepartmentDEPTCODERequiredWhen PEU-RECRD-TYPE = 33 And PEU-ACTION != "D"
PEU-COMPANY→DPT-COMPANY
PEU-PROCESS-LEVEL→DPT-PROCESS-LEVEL
PEU-CODE→DPT-DEPARTMENT
EmpcodesEMPCODESRequiredWhen (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
EmployeeEMPLOYEERequiredWhen PEU-RECRD-TYPE <= 19 And PEU-EMPLOYEE != Zeroes And PEU-ACTION != "D"
PEU-COMPANY→EMP-COMPANY
PEU-EMPLOYEE→EMP-EMPLOYEE
PaemployeePAEMPLOYEERequiredWhen PEU-RECRD-TYPE <= 19 And PEU-EMPLOYEE != Zeroes And PEU-ACTION != "D"
PEU-COMPANY→PEM-COMPANY
PEU-EMPLOYEE→PEM-EMPLOYEE
PcodesPCODESRequiredWhen (PEU-RECRD-TYPE >= 36 And PEU-RECRD-TYPE <= 39) And PEU-ACTION != "D"
PEU-TYPE→PCO-TYPE
PEU-CODE→PCO-CODE
Process LevelPRSYSTEMRequiredWhen PEU-PROCESS-LEVEL != Spaces And PEU-ACTION != "D"
PEU-COMPANY→PRS-COMPANY
PEU-PROCESS-LEVEL→PRS-PROCESS-LEVEL
RequisitionPAJOBREQRequiredWhen (PEU-RECRD-TYPE >= 20 And PEU-RECRD-TYPE <= 29) And PEU-ACTION != "D"
PEU-COMPANY→PJR-COMPANY
PEU-EMPLOYEE→PJR-REQUISITION
SupervisorHRSUPERRequiredWhen PEU-RECRD-TYPE = 34 And PEU-ACTION != "D"
PEU-COMPANY→HSU-COMPANY
PEU-CODE→HSU-CODE

Programs

Updated by (149)