Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAREQOFFER


                            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
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 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
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
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


PRF-BASE-CURRENCY      Alpha 5                                   PA45.1
Element: Base Currency Contains the company's base currency.

PRF-BASE-ND            Numeric 1                                 PA45.1
Element: Base Nd       The number of decimal positions defined
                       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: 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  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