PAREQOFFER FILE
Job Requisition Offer
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.
REFERENCED BY
PA242 HR170 HR70.1
UPDATED BY
PA120 PA42.1 PA43.1 PA43.2 PA45.1 PA502
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRF-COMPANY Numeric 4 PA45.1
Company Contains the company number which
represents an established company.
PRF-REQUISITION Numeric 9 PA45.1
Requisition Contains the system-assigned number
that represents the requisition.
PRF-EMP-APP Numeric 1 PA45.1
Employee or Indicates whether the applicant is an
Applicant 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
PRF-APPLICANT Numeric 9 PA45.1
Applicant Contains the applicant's number. The
number correlates all information about
the applicant.
PRF-DATE Numeric 8 (yyyymmdd) PA45.1
Date Contains the date the applicant status
is effective.
PRF-OFFER-TYPE Alpha 1 PA45.1
Offer Type Contains the type of offer.
E = Extend
A = Accept
D = Decline
C = Counter
PRF-REASON Alpha 10 PA45.1
Offer Reason Contains the reason for the offer.
PRF-APP-STATUS Alpha 2 PA45.1
Applicant Status Contains the applicant's status at the
time of the offer.
PRF-FTE Signed 8.3 PA45.1
Full Time Contains the Full Time Equivalent of
Equivalent Factor the position being offered to the
applicant.
PRF-PAY-RATE Signed 13.4 PA45.1
Pay Rate Contains the pay rate being offered to
the applicant.
PRF-START-DATE Numeric 8 (yyyymmdd) PA45.1
Start Date Contains the start date for the
applicant if the offer is accepted.
PRF-SIGNING-BONUS Numeric 7 PA45.1
Signing Bonus Contains the amount of any signing
bonus offered to the applicant.
PRF-CONTACT-EMP Numeric 9 PA45.1
Contact Emp Contains the contact employee.
PRF-LETTER-CODE Alpha 2 PA45.1
Letter Code Contains 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.
PRF-DATE-STAMP Numeric 8 (yyyymmdd) PA45.1
Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
PRF-TIME-STAMP Numeric 6 (hhmmss) PA45.1
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
PRF-USER-ID Alpha 10 (Lower Case) PA45.1
User ID Name Contains the user ID of the person who
last changed this record.
PRF-CURRENCY-CODE Alpha 5 PA45.1
Currency Code Contains the currency in which the pay
is recorded.
PRF-CURR-ND Numeric 1 PA45.1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
PRF-BASE-CURRENCY Alpha 5 PA45.1
Base Currency Contains the company's base currency.
PRF-BASE-ND Numeric 1 PA45.1
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
PRF-BASE-SIGN-BON Numeric 7 PA45.1
Base Sign Bon Contains the signing bonus in the
company's base currency.
PRF-BASE-PAY-RATE Signed 13.4 PA45.1
Base Pay Rate Contains the base pay rate in the
company's base currency.
PAREQOFFER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRFSET1 COMPANY PA120 PA242
REQUISITION PA42.1 PA43.1
EMP-APP PA43.2 PA45.1
APPLICANT PA502
DATE
OFFER-TYPE
PRFSET2 COMPANY KeyChange HR170 HR70.1
EMP-APP
APPLICANT
REQUISITION
DATE
OFFER-TYPE
PAREQOFFER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Applicant APPLICANT Required
When PRF-EMP-APP = 1
And PRF-APPLICANT != Zeroes
PRF-COMPANY -> APL-COMPANY
PRF-APPLICANT -> APL-APPLICANT
Base Currency CUCODES Required
When (PRF-CURRENCY-CODE != Spaces )
PRF-BASE-CURRENCY -> CUC-CURRENCY-CODE
Company PRSYSTEM Required
PRF-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Contact Emp EMPLOYEE Not Required
PRF-COMPANY -> EMP-COMPANY
PRF-CONTACT-EMP -> EMP-EMPLOYEE
Currency CUCODES Required
When (PRF-CURRENCY-CODE != Spaces )
PRF-CURRENCY-CODE -> CUC-CURRENCY-CODE
Employee EMPLOYEE Required
When PRF-EMP-APP = Zeroes
And PRF-APPLICANT != Zeroes
PRF-COMPANY -> EMP-COMPANY
PRF-APPLICANT -> EMP-EMPLOYEE
Reason PCODES Required
When PRF-REASON != Spaces
"RS" -> PCO-TYPE
PRF-REASON -> PCO-CODE
Req Status EMSTATUS Required
PRF-COMPANY -> EMS-COMPANY
PRF-APP-STATUS -> EMS-EMP-STATUS
Reqapp PAREQAPP Required
PRF-COMPANY -> PRA-COMPANY
PRF-REQUISITION -> PRA-REQUISITION
PRF-EMP-APP -> PRA-EMP-APP
PRF-APPLICANT -> PRA-APPLICANT
Requisition PAJOBREQ Required
PRF-COMPANY -> PJR-COMPANY
PRF-REQUISITION -> PJR-REQUISITION
|
