Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PACLASSPOS


                            PACLASSPOS FILE

                     Position Class/Position Number

The Position Class/Position Number file is used to associate position numbers
with position classes.

REFERENCED BY

PA103     PA201     PA210     PA82.1    HCPO.1

UPDATED BY

PA01.1    PA01.2    PA02.1    PA302     PA502

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PQP-COMPANY            Numeric 4                                 PA01.1  PA01.2
Element: Company       Contains the company number which
                       represents an established company.

PQP-POS-CLASS          Alpha 3                                   PA01.1  PA01.2
Element: Position ClassContains the code that represents a
                       position class.

PQP-POSITION           Alpha 12                                  PA01.1  PA01.2
Element: Position      Contains the user-defined code that
                       represents a position in the company.

                         PACLASSPOS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PQPSET1   COMPANY                                                PA01.1  PA01.2
          POS-CLASS                                              PA01.3  PA103
          POSITION                                               PA201   PA210
                                                                 PA82.1

PQPSET2   COMPANY                                                HCPO.1  PA01.2
          POSITION                                               PA02.1  PA302
          POS-CLASS                                              PA502

                         PACLASSPOS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PQP-COMPANY      -> PRS-COMPANY
                            Spaces           -> PRS-PROCESS-LEVEL

Passigned      PAASSIGNED   Not Required

                            PQP-COMPANY      -> PAA-COMPANY
                            PQP-POSITION     -> PAA-POSITION
                            Spaces           -> PAA-PROCESS-LEVEL
                            Spaces           -> PAA-DEPARTMENT
                            Spaces           -> PAA-JOB-CODE

Pqp Class      PACLASS      Required

                            PQP-COMPANY      -> PAQ-COMPANY
                            PQP-POS-CLASS    -> PAQ-POS-CLASS

                         PACLASSPOS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pabudget       PABUDGET

                            PQP-COMPANY      -> PAB-COMPANY
                            PQP-POSITION     -> PAB-POSITION
                                                PAB-EFFECT-DATE
                                                PAB-PROCESS-LEVEL
                                                PAB-DEPARTMENT
                                                PAB-JOB-CODE

Paencumber     PAENCUMBER

                            PQP-COMPANY      -> PEN-COMPANY
                            PQP-POSITION     -> PEN-POSITION
                            Spaces           -> PEN-PROCESS-LEVEL
                            Spaces           -> PEN-DEPARTMENT
                            Spaces           -> PEN-JOB-CODE
                                                PEN-EMPLOYEE
                                                PEN-GLT-OBJ-ID
                                                PEN-ATN-OBJ-ID

Pqp Employee   PATHFIND

                            PQP-COMPANY      -> PTF-COMPANY
                            126              -> PTF-FLD-NBR
                            PQP-POSITION     -> PTF-FLD-VALUE
                                                PTF-EMPLOYEE
                                                PTF-POS-LEVEL

Pqp Positions  PAPOSITION   Required

                            PQP-COMPANY      -> POS-COMPANY
                            PQP-POSITION     -> POS-POSITION
                                                POS-EFFECT-DATE