PAREQCOST – Job Requisition Cost

System
Personnel (PA)
Prefix
PRC
Primary key
COMPANY, REQUISITION, DATE, REASON, EMP-APP, APPLICANT
Fields
12
Updated by
14 programs
Referenced by
3 programs

PAREQCOST is the Job Requisition Cost table in Lawson Personnel (prefix PRC). It is indexed by COMPANY, REQUISITION, DATE, REASON, EMP-APP, APPLICANT (PRCSET1); alternate indexes: PRCSET2. It is related 1:1 to APPLICANT, CUCODES, PRSYSTEM, EMPLOYEE, PAEMPLOYEE, PCODES and PAJOBREQ. It is updated by HR11.1, LT101, LT111, PA02.1, PA102, PA115, PA120, PA42.1 and 6 more and referenced by HR170, HR70.1 and PA242. The table has 12 fields, 2 indexes and 8 documented relations.

About PAREQCOST

The Job Requisition Cost file contains information about the costs of hiring an applicant. The costs can include general costs, such as newspaper advertisements, or costs specific to an employee. PA44.1 (Requisition Costs) is the primary program that updates this file.

Fields (12)

Column = COBOL field name without the PRC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PRC-COMPANY PK
COMPANY		Numeric 4Contains the company number which represents an established company.PA44.1
PRC-REQUISITION PK
REQUISITION		Numeric 9Contains the system-assigned number that represents the requisition.PA44.1
PRC-DATE PK
DATE		Numeric 8 (yyyymmdd)Contains the date the cost was incurred.PA44.1
PRC-REASON PK
REASON		Alpha 10Contains the reason for the cost.PA44.1
PRC-EMP-APP PK
EMP_APP		Numeric 1Indicates whether the applicant is an internal or external applicant. An external applicant is a person applying from outside the company; an internal applicant is an employee applying from inside the company.
  • 0 External
  • 1 Internal
PA44.1
PRC-APPLICANT PK
APPLICANT		Numeric 9Contains the applicant's number. The number correlates all information about the applicant.PA44.1
PRC-COST
COST		Signed 11.2Contains the cost.HR11.1, PA43.1, PA43.2, PA44.1
PRC-CURRENCY-CODE
CURRENCY_CODE		Alpha 5Contains the currency in which the cost is recorded.PA44.1
PRC-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.PA44.1
PRC-BASE-AMOUNT
BASE_AMOUNT		Signed 15.2Contains the cost in the company's base currency.PA44.1
PRC-BASE-CURRENCY
BASE_CURRENCY		Alpha 5Contains the company's base currency.PA44.1
PRC-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.PA44.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PRCSET1COMPANY, REQUISITION, DATE, REASON, EMP-APP, APPLICANTPrimaryLT101, LT111, PA02.1, PA102, PA120, PA242, PA42.1, PA42.3 +5 more
PRCSET2COMPANY, EMP-APP, APPLICANT, REQUISITION, DATE, REASONKeyChangeHR11.1, HR170, HR70.1, PA115

Relations

One to one (8) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequiredWhen PRC-EMP-APP = 1 And PRC-APPLICANT != ZeroesPRC-COMPANY → APL-COMPANY, PRC-APPLICANT → APL-APPLICANT
Base CurrencyCUCODESRequiredWhen (PRC-CURRENCY-CODE != Spaces)PRC-CURRENCY-CODE → CUC-CURRENCY-CODE
CompanyPRSYSTEMRequiredPRC-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen (PRC-CURRENCY-CODE != Spaces)PRC-CURRENCY-CODE → CUC-CURRENCY-CODE
EmployeeEMPLOYEERequiredWhen PRC-EMP-APP = Zeroes And PRC-APPLICANT != ZeroesPRC-COMPANY → EMP-COMPANY, PRC-APPLICANT → EMP-EMPLOYEE
PaemployeePAEMPLOYEERequiredWhen PRC-EMP-APP = Zeroes And PRC-APPLICANT != ZeroesPRC-COMPANY → PEM-COMPANY, PRC-APPLICANT → PEM-EMPLOYEE
ReasonPCODESRequiredWhen PRC-REASON != Spaces"CO" → PCO-TYPE, PRC-REASON → PCO-CODE
RequisitionPAJOBREQRequiredPRC-COMPANY → PJR-COMPANY, PRC-REQUISITION → PJR-REQUISITION

Programs

Updated by (14)

Referenced by (3)