Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAREQCOST


                             PAREQCOST FILE

                          Job Requisition Cost

The Job Requisition Cost file contains information about the costs of hiring
an applicant. The costs can include general costs, such as newspaper
advertisements, or costs specific to an employee.

PA44.1 (Requisition Costs) is the primary program that updates this file.

REFERENCED BY

PA242     HR170     HR70.1

UPDATED BY

HR11.1    PA02.1    PA102     PA115     PA120     PA42.1
PA43.1    PA43.2    PA44.1    PA502

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PRC-COMPANY            Numeric 4                                 PA44.1
Element: Company       Contains the company number which
                       represents an established company.

PRC-REQUISITION        Numeric 9                                 PA44.1
Element: Requisition   Contains the system-assigned number
                       that represents the requisition.

PRC-DATE               Numeric 8  (yyyymmdd)                     PA44.1
Element: Date          Contains the date the cost was incurred.

PRC-REASON             Alpha 10                                  PA44.1
Element: Reason        Contains the reason for the cost.

PRC-EMP-APP            Numeric 1                                 PA44.1
Element: Type          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 = External
                       1 = Internal

PRC-APPLICANT          Numeric 9                                 PA44.1
Element: Applicant     Contains the applicant's number. The
                       number correlates all information about
                       the applicant.

PRC-COST               Signed 11.2                               HR11.1  PA43.1
Element: Cost          Contains the cost.                        PA43.2  PA44.1

PRC-CURRENCY-CODE      Alpha 5                                   PA44.1
Element: Currency Code Contains the currency in which the cost
                       is recorded.

PRC-CURR-ND            Numeric 1                                 PA44.1
Account Currency
Code

PRC-BASE-AMOUNT        Signed 15.2                               PA44.1
Element: Adj Amt       Contains the cost in the company's base
                       currency.

PRC-BASE-CURRENCY      Alpha 5                                   PA44.1
To Company Base        Contains the company's base currency.
Currency

PRC-BASE-ND            Numeric 1                                 PA44.1
Account Currency
Code

                         PAREQCOST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRCSET1   COMPANY                                                PA02.1  PA102
          REQUISITION                                            PA120   PA242
          DATE                                                   PA42.1  PA43.1
          REASON                                                 PA43.2  PA44.1
          EMP-APP                                                PA502
          APPLICANT

PRCSET2   COMPANY       KeyChange                                HR11.1  HR170
          EMP-APP                                                HR70.1  PA115
          APPLICANT
          REQUISITION
          DATE
          REASON

                         PAREQCOST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Applicant      APPLICANT    Required
                            When PRC-EMP-APP   =  1
                            And  PRC-APPLICANT != Zeroes

                            PRC-COMPANY          -> APL-COMPANY
                            PRC-APPLICANT        -> APL-APPLICANT

Base Currency  CUCODES      Required
                            When (PRC-CURRENCY-CODE != Spaces )

                            PRC-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Company        PRSYSTEM     Required

                            PRC-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required
                            When (PRC-CURRENCY-CODE != Spaces )

                            PRC-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Employee       EMPLOYEE     Required
                            When PRC-EMP-APP   =  Zeroes
                            And  PRC-APPLICANT != Zeroes

                            PRC-COMPANY          -> EMP-COMPANY
                            PRC-APPLICANT        -> EMP-EMPLOYEE

Reason         PCODES       Required
                            When PRC-REASON != Spaces

                            "CO"                 -> PCO-TYPE
                            PRC-REASON           -> PCO-CODE

Requisition    PAJOBREQ     Required

                            PRC-COMPANY          -> PJR-COMPANY
                            PRC-REQUISITION      -> PJR-REQUISITION