Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAREQAPP


                             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

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

PRA-APPLICANT          Numeric 9                                 PA43.1  PA43.2
Element: 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
Element: Date Applied  Contains the applicant applied for the
                       requisition.

PRA-HIRE-SOURCE        Alpha 10                                  PA43.1  PA43.2
Element: 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.

PRA-APPLICANT-NAME     Derived
Element: Applicant Name

                         PAREQAPP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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

                         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