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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PEUSET1RECRD-TYPE, COMPANY, PROCESS-LEVEL, EMPLOYEE, CODE, TYPE, SUBJECT, SEQ-NBRPrimaryBN305, HR00.1, HR01.1, HR02.1, HR04.2, HR04.3, HR04.7, HR04.8 +22 more (list truncated in source)

Relations

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)