Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAJOBINTRS


                            PAJOBINTRS FILE

UPDATED BY

HS50.5    HR00.1    HR01.1    HR11.1    PA115     PA120
PBIP.1    PR197     HR06.1    HR506     PA02.1    PA302
PA502

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PJI-COMPANY            Numeric 4                                 HS50.5
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PJI-EMP-APP            Numeric 1                                 HS50.5
Element: Type          Indicates whether the person is an
                       external or internal applicant.

                       An external applicant is a person
                       applying from outside the company; an
                       internal applicant is an employee
                       applying from inside the company.

PJI-EMPLOYEE           Numeric 9                                 HS50.5
Element: Employee      Contains the employee number. Each
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

PJI-JOB-CODE           Alpha 9                                   HS50.5
Element: Job Code      Contains a user-defined code that
                       represents a type of job.

PJI-POSITION           Alpha 12                                  HS50.5
Element: Position      Contains the user-defined code that
                       represents a position in the company.

PJI-DATE-STAMP         Numeric 8  (yyyymmdd)                     HS50.5
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

PJI-TIME-STAMP         Numeric 6  (hhmmss)                       HS50.5
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

PJI-USER-ID            Alpha 10  (Lower Case)                    HS50.5
Element: User          Contains the user ID of the person who
                       last changed this record.

                         PAJOBINTRS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PJISET1   COMPANY                                                HR00.1  HR01.1
          EMP-APP                                                HR11.1  HS50.5
          EMPLOYEE                                               PA115   PA120
          JOB-CODE                                               PBIP.1  PR197
          POSITION

PJISET2   COMPANY                                                HR06.1  HR506
          JOB-CODE                                               PA02.1  PA302
          POSITION                                               PA502
          EMP-APP
          EMPLOYEE

                         PAJOBINTRS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Applicant      APPLICANT    Required
                            When PJI-EMP-APP = 1

                            PJI-COMPANY     -> APL-COMPANY
                            PJI-EMPLOYEE    -> APL-APPLICANT

Employee       EMPLOYEE     Required
                            When PJI-EMP-APP = Zeroes

                            PJI-COMPANY     -> EMP-COMPANY
                            PJI-EMPLOYEE    -> EMP-EMPLOYEE

Job Code       JOBCODE      Required
                            When PJI-JOB-CODE != Spaces

                            PJI-COMPANY     -> JBC-COMPANY
                            PJI-JOB-CODE    -> JBC-JOB-CODE

Paemployee     PAEMPLOYEE   Required

                            PJI-COMPANY     -> PEM-COMPANY
                            PJI-EMPLOYEE    -> PEM-EMPLOYEE

                         PAJOBINTRS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Job Requis     PAJOBREQ
                            Valid When PJI-JOB-CODE != Spaces

                            PJI-COMPANY     -> PJR-COMPANY
                            PJI-JOB-CODE    -> PJR-JOB-CODE
                                               PJR-REQUISITION

Pos Requis     PAJOBREQ
                            Valid When PJI-POSITION != Spaces

                            PJI-COMPANY     -> PJR-COMPANY
                            PJI-POSITION    -> PJR-POSITION
                                               PJR-REQUISITION

Position       PAPOSITION
                            Valid When PJI-POSITION != Spaces

                            PJI-COMPANY     -> POS-COMPANY
                            PJI-POSITION    -> POS-POSITION
                                               POS-EFFECT-DATE