Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PAREQAPP FILE

                      Job Requisition Application

The Job Requisition Application file contains information about the internal
and external applicants associated with a requisition.

PA43.1 (Requisition Applicants) and the Applicant Requisitions window of
PA31.1 (Applicant) are the primary programs that update this file.

REFERENCED BY

HR170     HR70.1    PA243     PA41.1    PA44.1    PA45.1
PA231     PA244

UPDATED BY

PA120     PA42.1    PA43.1    PA43.2    PA502

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

PRA-EMP-APP          Numeric 1                                   PA43.1  PA43.2
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 = Internal
                     1 = External

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

PRA-DATE-APPLIED     Numeric 8  (yyyymmdd)                       PA43.1  PA43.2
Date Applied         Contains the applicant applied for the
                     requisition.

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

                     This must be valid in the Human
                     Resources Code file.

                         PAREQAPP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRASET1   COMPANY                                                HR170   HR70.1
          REQUISITION                                            PA243   PA41.1
          EMP-APP                                                PA42.1  PA43.1
          APPLICANT                                              PA44.1  PA45.1
                                                                 PA502

PRASET2   COMPANY                                                HR170   HR70.1
          EMP-APP                                                PA120   PA231
          APPLICANT                                              PA244   PA43.2
          REQUISITION

                         PAREQAPP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Applicant      APPLICANT    Required
                            When PRA-EMP-APP = 1

                            PRA-COMPANY        -> APL-COMPANY
                            PRA-APPLICANT      -> APL-APPLICANT

Company        PRSYSTEM     Required

                            PRA-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required
                            When PRA-EMP-APP = Zeroes

                            PRA-COMPANY        -> EMP-COMPANY
                            PRA-APPLICANT      -> EMP-EMPLOYEE

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

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

Requisition    PAJOBREQ     Required

                            PRA-COMPANY        -> PJR-COMPANY
                            PRA-REQUISITION    -> PJR-REQUISITION

                         PAREQAPP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cert Emp       EMPCODES
                            Valid When PRA-EMP-APP = Zeroes

                            PRA-COMPANY        -> EPC-COMPANY
                            "CE"               -> EPC-TYPE
                            Zeroes             -> EPC-EMP-APP
                            PRA-APPLICANT      -> EPC-EMPLOYEE
                                                  EPC-CODE
                                                  EPC-SUBJECT
                                                  EPC-SEQ-NBR

Certificates   EMPCODES
                            Valid When PRA-EMP-APP = 1

                            PRA-COMPANY        -> EPC-COMPANY
                            "CE"               -> EPC-TYPE
                            1                  -> EPC-EMP-APP
                            PRA-APPLICANT      -> EPC-EMPLOYEE
                                                  EPC-CODE
                                                  EPC-SUBJECT
                                                  EPC-SEQ-NBR

Competency     EMPCODES
                            Valid When PRA-EMP-APP = 1

                            PRA-COMPANY        -> EPC-COMPANY
                            1                  -> EPC-EMP-APP
                            PRA-APPLICANT      -> EPC-EMPLOYEE
                                                  EPC-TYPE
                                                  EPC-CODE
                                                  EPC-SUBJECT
                                                  EPC-SEQ-NBR

Competency Emp EMPCODES
                            Valid When PRA-EMP-APP = Zeroes

                            PRA-COMPANY        -> EPC-COMPANY
                            Zeroes             -> EPC-EMP-APP
                            PRA-APPLICANT      -> EPC-EMPLOYEE
                                                  EPC-TYPE
                                                  EPC-CODE
                                                  EPC-SUBJECT
                                                  EPC-SEQ-NBR

Educ Emp       EMPCODES
                            Valid When PRA-EMP-APP = Zeroes

                            PRA-COMPANY        -> EPC-COMPANY
                            "ED"               -> EPC-TYPE
                            Zeroes             -> EPC-EMP-APP
                            PRA-APPLICANT      -> EPC-EMPLOYEE
                                                  EPC-CODE
                                                  EPC-SUBJECT
                                                  EPC-SEQ-NBR

Education      EMPCODES
                            Valid When PRA-EMP-APP = 1

                            PRA-COMPANY        -> EPC-COMPANY
                            "ED"               -> EPC-TYPE
                            1                  -> EPC-EMP-APP
                            PRA-APPLICANT      -> EPC-EMPLOYEE
                                                  EPC-CODE
                                                  EPC-SUBJECT
                                                  EPC-SEQ-NBR

Employers      APPJOBHIST
                            Valid When PRA-EMP-APP = 1

                            PRA-COMPANY        -> AJH-COMPANY
                            PRA-APPLICANT      -> AJH-APPLICANT
                                                  AJH-EMPLOYEE
                                                  AJH-EMPLOYER-NAME
                                                  AJH-SEQ-NBR

Interview      INTERVIEW

                            PRA-COMPANY        -> ITV-COMPANY
                            PRA-REQUISITION    -> ITV-REQUISITION
                            PRA-EMP-APP        -> ITV-EMP-APP
                            PRA-APPLICANT      -> ITV-APPLICANT
                                                  ITV-SEQ-NBR

References     REFERENC
                            Valid When PRA-EMP-APP = 1

                            PRA-COMPANY        -> REF-COMPANY
                            PRA-APPLICANT      -> REF-APPLICANT
                                                  REF-SEQ-NBR

Req Log        PAREQLOG     Delete Cascades

                            PRA-COMPANY        -> PQL-COMPANY
                            PRA-REQUISITION    -> PQL-REQUISITION
                            PRA-EMP-APP        -> PQL-EMP-APP
                            PRA-APPLICANT      -> PQL-APPLICANT
                                                  PQL-DATE
                                                  PQL-SEQ-NBR