|
|
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 PA52.4 HR170 HR70.1
UPDATED BY
HR11.1 PA02.1 PA102 PA115 PA120 PA42.1
PA43.1 PA43.2 PA45.1 PA502
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRF-COMPANY Numeric 4 PA45.1
Element: Company Contains the company number which
represents an established company.
PRF-REQUISITION Numeric 9 PA45.1
Element: 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
Element: Applicant Contains the applicant's number. The
number correlates all information about
the applicant.
PRF-DATE Numeric 8 (yyyymmdd) PA45.1
Element: Date Contains the date the applicant status
is effective.
PRF-OFFER-TYPE Alpha 1 PA45.1
Element: Offer Type Contains the type of offer.
E = Extend
A = Accept
D = Decline
C = Counter
PRF-REASON Alpha 10 PA45.1
Element: Offer Reason Contains the reason for the offer.
PRF-APP-STATUS Alpha 2 PA45.1
Element: Applicant StatContains 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
Element: Pay Rate Contains the pay rate being offered to
the applicant.
PRF-START-DATE Numeric 8 (yyyymmdd) PA45.1
Element: Start Date Contains the start date for the
applicant if the offer is accepted.
PRF-SIGNING-BONUS Numeric 7 PA45.1
Element: Signing Bonus Contains the amount of any signing
bonus offered to the applicant.
PRF-CONTACT-EMP Numeric 9 PA45.1
Element: Contact Emp Contains the contact employee.
PRF-LETTER-CODE Alpha 2 PA45.1
Element: 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
Element: 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
Element: 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
Element: User
PRF-CURRENCY-CODE Alpha 5 PA45.1
Element: Currency Code Contains the currency in which the pay
is recorded.
PRF-CURR-ND Numeric 1 PA45.1
Account Currency
Code
PRF-BASE-CURRENCY Alpha 5 PA45.1
To Company Base Contains the company's base currency.
Currency
PRF-BASE-ND Numeric 1 PA45.1
Account Currency
Code
PRF-BASE-SIGN-BON Numeric 7 PA45.1
Element: Base Sign Bon Contains the signing bonus in the
company's base currency.
PRF-BASE-PAY-RATE Signed 13.4 PA45.1
Element: 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 HR11.1 PA02.1
REQUISITION PA102 PA115
EMP-APP PA120 PA242
APPLICANT PA42.1 PA43.1
DATE PA43.2 PA45.1
OFFER-TYPE PA502 PA52.4
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
|
