PAREQOFFER

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 LT101 LT111 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
Element: Company
Numeric 4
Contains the company number which represents an established company.
PA45.1
PRF-REQUISITION
Element: Requisition
Numeric 9
Contains the system-assigned number that represents the requisition.
PA45.1
PRF-EMP-APP
Employee or
Applicant
Numeric 1
Indicates 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
Element: Applicant
Numeric 9
Contains the applicant's number. The number correlates all information about the applicant.
PA45.1
PRF-DATE
Element: Date
Numeric 8 (yyyymmdd)
Contains the date the applicant status is effective.
PA45.1
PRF-OFFER-TYPE
Element: Offer Type
Alpha 1
Contains the type of offer.
E = Extend
A = Accept
D = Decline
C = Counter
PA45.1
PRF-REASON
Element: Offer Reason
Alpha 10
Contains the reason for the offer.
PA45.1
PRF-APP-STATUS
Element: Applicant Status
Alpha 2
Contains the applicant's status at the time of the offer.
PA45.1
PRF-FTE
Full Time
Equivalent Factor
Signed 11.6
Contains the Full Time Equivalent of the position being offered to the applicant.
PA45.1
PRF-PAY-RATE
Element: Pay Rate
Signed 13.4
Contains the pay rate being offered to the applicant.
PA45.1
PRF-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
Contains the start date for the applicant if the offer is accepted.
PA45.1
PRF-SIGNING-BONUS
Element: Signing Bonus
Numeric 7
Contains the amount of any signing bonus offered to the applicant.
PA45.1
PRF-CONTACT-EMP
Element: Contact Emp
Numeric 9
Contains the contact employee.
PA45.1
PRF-LETTER-CODE
Element: Letter Code
Alpha 2
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.
PA45.1
PRF-DATE-STAMP
Element: 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
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
PA45.1
PRF-USER-ID
Element: User
Alpha 10 (Lower Case)
PA45.1
PRF-CURRENCY-CODE
Element: Currency Code
Alpha 5
Contains the currency in which the pay is recorded.
PA45.1
PRF-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
PA45.1
PRF-BASE-CURRENCY
Element: Base Currency
Alpha 5
Contains the company's base currency.
PA45.1
PRF-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
PA45.1
PRF-BASE-SIGN-BON
Element: Base Sign Bon
Numeric 7
Contains the signing bonus in the company's base currency.
PA45.1
PRF-BASE-PAY-RATE
Element: Pay Rate
Signed 13.4
Contains the base pay rate in the company's base currency.
PA45.1


PAREQOFFER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRFSET1 COMPANY
REQUISITION
EMP-APP
APPLICANT
DATE
OFFER-TYPE
HR11.1 LT101
LT111 PA02.1
PA102 PA115
PA120 PA242
PA42.1 PA42.3
PA43.1 PA43.2
PA45.1 PA502
PA52.4 PA535
PRFSET2 COMPANY
EMP-APP
APPLICANT
REQUISITION
DATE
OFFER-TYPE
KeyChange
HR170 HR70.1
PRFSET3 COMPANY
DATE*
DATE-STAMP*
EMP-APP
APPLICANT
REQUISITION
OFFER-TYPE
KeyChange


PAREQOFFER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Applicant APPLICANT Required
When PRF-EMP-APP =1
AndPRF-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
AndPRF-APPLICANT !=Zeroes
PRF-COMPANY->EMP-COMPANY
PRF-APPLICANT->EMP-EMPLOYEE
Paemployee PAEMPLOYEE Required
When PRF-EMP-APP =Zeroes
AndPRF-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


File created: Thu Jun 09 02:25:08 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.