PAREQOFFER – Job Requisition Offer

System
Personnel (PA)
Prefix
PRF
Primary key
COMPANY, REQUISITION, EMP-APP, APPLICANT, DATE, OFFER-TYPE
Fields
23
Updated by
14 programs
Referenced by
4 programs

PAREQOFFER is the Job Requisition Offer table in Lawson Personnel (prefix PRF). It is indexed by COMPANY, REQUISITION, EMP-APP, APPLICANT, DATE, OFFER-TYPE (PRFSET1); alternate indexes: PRFSET2 and PRFSET3. It is related 1:1 to APPLICANT, CUCODES, PRSYSTEM, EMPLOYEE, PAEMPLOYEE, PCODES, EMSTATUS, PAREQAPP and 1 more. It is updated by HR11.1, LT101, LT111, PA02.1, PA102, PA115, PA120, PA42.1 and 6 more and referenced by HR170, HR70.1, PA242 and PA52.4. The table has 23 fields, 3 indexes and 11 documented relations.

About PAREQOFFER

The Requisition Offer file contains information about the offers that the company extends under a requisition. PA45.1 (Requisition Offers) is the primary program that updates this file.

Fields (23)

Column = COBOL field name without the PRF- 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
#PRF-COMPANY PK
COMPANY		Numeric 4Contains the company number which represents an established company.PA45.1
#PRF-REQUISITION PK
REQUISITION		Numeric 9Contains the system-assigned number that represents the requisition.PA45.1
#PRF-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 Internal
  • 1 External
PA45.1
#PRF-APPLICANT PK
APPLICANT		Numeric 9Contains the applicant's number. The number correlates all information about the applicant.PA45.1
#PRF-DATE PK
DATE		Numeric 8 (yyyymmdd)Contains the date the applicant status is effective.PA45.1
#PRF-OFFER-TYPE PK
OFFER_TYPE		Alpha 1Contains the type of offer.
  • E Extend
  • A Accept
  • D Decline
  • C Counter
PA45.1
#PRF-REASON
REASON		Alpha 10Contains the reason for the offer.PA45.1
#PRF-APP-STATUS
APP_STATUS		Alpha 2Contains the applicant's status at the time of the offer.PA45.1
#PRF-FTE
FTE		Signed 11.6Contains the Full Time Equivalent of the position being offered to the applicant.PA45.1
#PRF-PAY-RATE
PAY_RATE		Signed 13.4Contains the pay rate being offered to the applicant.PA45.1
#PRF-START-DATE
START_DATE		Numeric 8 (yyyymmdd)Contains the start date for the applicant if the offer is accepted.PA45.1
#PRF-SIGNING-BONUS
SIGNING_BONUS		Numeric 7Contains the amount of any signing bonus offered to the applicant.PA45.1
#PRF-CONTACT-EMP
CONTACT_EMP		Numeric 9Contains the contact employee.PA45.1
#PRF-LETTER-CODE
LETTER_CODE		Alpha 2Contains a letter that can be used for a user-defined purpose. For example, to indicate the type of letter sent or to group information for export.PA45.1
#PRF-DATE-STAMP SET3
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.PA45.1
#PRF-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.PA45.1
#PRF-USER-ID
USER_ID		Alpha 10 (Lower Case)—PA45.1
#PRF-CURRENCY-CODE
CURRENCY_CODE		Alpha 5Contains the currency in which the pay is recorded.PA45.1
#PRF-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.PA45.1
#PRF-BASE-CURRENCY
BASE_CURRENCY		Alpha 5Contains the company's base currency.PA45.1
#PRF-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.PA45.1
#PRF-BASE-SIGN-BON
BASE_SIGN_BON		Numeric 7Contains the signing bonus in the company's base currency.PA45.1
#PRF-BASE-PAY-RATE
BASE_PAY_RATE		Signed 13.4Contains the base pay rate in the company's base currency.PA45.1

Indexes (3)

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
PRFSET1
  1. COMPANY
  2. REQUISITION
  3. EMP-APP
  4. APPLICANT
  5. DATE
  6. OFFER-TYPE
PrimaryHR11.1, LT101, LT111, PA02.1, PA102, PA115, PA120, PA242 +8 more
PRFSET2
  1. COMPANY
  2. EMP-APP
  3. APPLICANT
  4. REQUISITION
  5. DATE
  6. OFFER-TYPE
KeyChangeHR170, HR70.1
PRFSET3
  1. COMPANY
  2. DATE ↓
  3. DATE-STAMP ↓
  4. EMP-APP
  5. APPLICANT
  6. REQUISITION
  7. OFFER-TYPE
KeyChange—

Relations

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

One to one (11) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequiredWhen PRF-EMP-APP = 1 And PRF-APPLICANT != Zeroes
PRF-COMPANY→APL-COMPANY
PRF-APPLICANT→APL-APPLICANT
Base CurrencyCUCODESRequiredWhen (PRF-CURRENCY-CODE != Spaces)
PRF-BASE-CURRENCY→CUC-CURRENCY-CODE
CompanyPRSYSTEMRequired
PRF-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Contact EmpEMPLOYEERequiredWhen PRF-CONTACT-EMP != Zeroes
PRF-COMPANY→EMP-COMPANY
PRF-CONTACT-EMP→EMP-EMPLOYEE
CurrencyCUCODESRequiredWhen (PRF-CURRENCY-CODE != Spaces)
PRF-CURRENCY-CODE→CUC-CURRENCY-CODE
EmployeeEMPLOYEERequiredWhen PRF-EMP-APP = Zeroes And PRF-APPLICANT != Zeroes
PRF-COMPANY→EMP-COMPANY
PRF-APPLICANT→EMP-EMPLOYEE
PaemployeePAEMPLOYEERequiredWhen PRF-EMP-APP = Zeroes And PRF-APPLICANT != Zeroes
PRF-COMPANY→PEM-COMPANY
PRF-APPLICANT→PEM-EMPLOYEE
ReasonPCODESRequiredWhen PRF-REASON != Spaces
"RS"→PCO-TYPE
PRF-REASON→PCO-CODE
Req StatusEMSTATUSRequired
PRF-COMPANY→EMS-COMPANY
PRF-APP-STATUS→EMS-EMP-STATUS
ReqappPAREQAPPRequired
PRF-COMPANY→PRA-COMPANY
PRF-REQUISITION→PRA-REQUISITION
PRF-EMP-APP→PRA-EMP-APP
PRF-APPLICANT→PRA-APPLICANT
RequisitionPAJOBREQRequired
PRF-COMPANY→PJR-COMPANY
PRF-REQUISITION→PJR-REQUISITION

Programs

Updated by (14)

Referenced by (4)