Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAREQLOG


                             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    PA42.3
PA43.1    PA43.2    PA45.1    PA502     PA535     HR11.1
PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

PQL-EMP-APP            Numeric 1                                 PA41.1  PA43.1
Element: Emp App       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
Element: 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
Element: Date          Contains the date the applicant status    PA43.1  PA43.2
                       is effective.                             PA45.1

PQL-SEQ-NBR            Numeric 4                                 PA41.1  PA43.1
Element: Seq Nbr       Contains the automatically assigned       PA43.2  PA45.1
                       sequence number.

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

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

PQL-CONTACT-EMP        Numeric 9
Element: 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                                                   PA42.3  PA43.1
          APP-STATUS                                             PA43.2  PA45.1
          SEQ-NBR                                                PA502   PA535

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

Emp Contact    EMPLOYEE     Required
                            When PQL-CONTACT-EMP != Zeroes

                            PQL-COMPANY        -> EMP-COMPANY
                            PQL-CONTACT-EMP    -> EMP-EMPLOYEE

Employee       EMPLOYEE     Required
                            When PQL-EMP-APP = Zeroes

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

Hire Source    PCODES       Required
                            When PQL-HIRE-SOURCE != Spaces

                            "HS"               -> PCO-TYPE
                            PQL-HIRE-SOURCE    -> PCO-CODE

Paemployee     PAEMPLOYEE   Required
                            When PQL-EMP-APP = Zeroes

                            PQL-COMPANY        -> PEM-COMPANY
                            PQL-APPLICANT      -> PEM-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