|
|
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
PA42.3 PA43.1 PA43.2 PA45.1 PA502 PA535
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRF-COMPANY Numeric 4 PA45.1 PA535
Element: Company Contains the company number which
represents an established company.
PRF-REQUISITION Numeric 9 PA45.1 PA535
Element: Requisition Contains the system-assigned number
that represents the requisition.
PRF-EMP-APP Numeric 1 PA45.1 PA535
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 PA535
Element: Applicant Contains the applicant's number. The
number correlates all information about
the applicant.
PRF-DATE Numeric 8 (yyyymmdd) PA45.1 PA535
Element: Date Contains the date the applicant status
is effective.
PRF-OFFER-TYPE Alpha 1 PA45.1 PA535
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 11.6 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 PA535
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 PA535
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 PA535
Element: User Contains the user ID of the person who
last changed this record.
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 Represents the number of decimals
Code defined for the currency of the object.
PRF-BASE-CURRENCY Alpha 5 PA45.1
Element: 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
Element: Base Sign Bon Contains the signing bonus in the
company's base currency.
PRF-BASE-PAY-RATE Signed 13.4 PA45.1
Element: Rate of Pay 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 PA42.3
DATE PA43.1 PA43.2
OFFER-TYPE PA45.1 PA502
PA52.4 PA535
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 Required
When PRF-CONTACT-EMP != Zeroes
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
Paemployee PAEMPLOYEE Required
When PRF-EMP-APP = Zeroes
And PRF-APPLICANT != Zeroes
PRF-COMPANY -> PEM-COMPANY
PRF-APPLICANT -> PEM-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
|
