Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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

PA120     PA42.1    PA43.1    PA43.2    PA44.1    PA502

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

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

PRC-EMP-APP          Numeric 1                                   PA44.1
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
Applicant            Contains the applicant's number. The
                     number correlates all information about
                     the applicant.

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

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

PRC-CURR-ND          Numeric 1                                   PA44.1
Currency Number of   Represents the number of decimals
Decimals             defined for the currency of the object.

PRC-BASE-AMOUNT      Signed 15.2                                 PA44.1
Base Amount          Contains the cost in the company's base
                     currency.

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

PRC-BASE-ND          Numeric 1                                   PA44.1
Base Number Of       The number of decimal positions defined
Decimals             for the company base currency.

                         PAREQCOST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

PRCSET2   COMPANY       KeyChange                                HR170   HR70.1
          EMP-APP
          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