Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PAREQLOG FILE

                          Job Requisition Log

The Job Requisition Log file contains information about an applicant
associated with a requisition.

The Applicant Requisitions window of PA31.1 (Applicant) is the primary file
that updates this file.

REFERENCED BY

PA244     PA231     PA243     HR170     HR70.1

UPDATED BY

PA02.1    PA102     PA120     PA41.1    PA42.1    PA43.1
PA43.2    PA45.1    PA502     HR11.1    PA115

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PQL-COMPANY          Numeric 4                                   PA41.1  PA43.1
Company              Contains the company number, which          PA43.2  PA45.1
                     represents an established company.

PQL-REQUISITION      Numeric 9                                   PA41.1  PA43.1
Requisition          Contains the system-assigned number         PA43.2  PA45.1
                     that represents the requisition.

PQL-EMP-APP          Numeric 1                                   PA41.1  PA43.1
Type                 Indicates whether the applicant is an       PA43.2  PA45.1
                     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

PQL-APPLICANT        Numeric 9                                   PA41.1  PA43.1
Applicant            Contains the number that represents the     PA43.2  PA45.1
                     applicant. The number correlates all
                     information about the applicant.

PQL-DATE             Numeric 8  (yyyymmdd)                       PA243   PA41.1
Date                 Contains the date the applicant status      PA43.1  PA43.2
                     is effective.                               PA45.1

PQL-SEQ-NBR          Numeric 4                                   PA41.1  PA43.1
Sequence Number      Contains the automatically assigned         PA43.2  PA45.1
                     sequence number.

PQL-APP-STATUS       Alpha 2                                     PA243   PA41.1
Applicant Status     Contains the applicant's status.            PA43.1  PA43.2
                                                                 PA45.1

PQL-HIRE-SOURCE      Alpha 10                                    PA41.1  PA43.1
Hire Source          Contains the hire source that indicates     PA43.2  PA45.1
                     where the applicant learned of the
                     opening.

PQL-CONTACT-EMP      Numeric 9
Contact Emp          Indicates the contact employee.

                         PAREQLOG FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PQLSET1   COMPANY                                                HR11.1  PA02.1
          REQUISITION                                            PA102   PA115
          EMP-APP                                                PA120   PA244
          APPLICANT                                              PA41.1  PA42.1
          DATE                                                   PA43.1  PA43.2
          APP-STATUS                                             PA45.1  PA502
          SEQ-NBR

PQLSET2   COMPANY                                                PA120   PA231
          REQUISITION                                            PA243   PA41.1
          EMP-APP                                                PA43.1  PA43.2
          APPLICANT                                              PA45.1
          DATE*
          SEQ-NBR

PQLSET3   COMPANY       KeyChange                                HR170   HR70.1
          EMP-APP
          APPLICANT
          REQUISITION
          DATE
          SEQ-NBR

                         PAREQLOG FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Applicant      APPLICANT    Required
                            When PQL-EMP-APP = 1

                            PQL-COMPANY        -> APL-COMPANY
                            PQL-APPLICANT      -> APL-APPLICANT

Company        PRSYSTEM     Required

                            PQL-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required
                            When PQL-EMP-APP = Zeroes

                            PQL-COMPANY        -> EMP-COMPANY
                            PQL-APPLICANT      -> EMP-EMPLOYEE

Req App        PAREQAPP     Required

                            PQL-COMPANY        -> PRA-COMPANY
                            PQL-REQUISITION    -> PRA-REQUISITION
                            PQL-EMP-APP        -> PRA-EMP-APP
                            PQL-APPLICANT      -> PRA-APPLICANT

Requisition    PAJOBREQ     Required

                            PQL-COMPANY        -> PJR-COMPANY
                            PQL-REQUISITION    -> PJR-REQUISITION

Status         EMSTATUS     Required

                            PQL-COMPANY        -> EMS-COMPANY
                            PQL-APP-STATUS     -> EMS-EMP-STATUS