Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            PACLASSPOS FILE

                     Position Class/Position Number

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

REFERENCED BY

PA201     HCPO.1

UPDATED BY

PA01.1    PA01.2    PA302     PA502

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

PQP-POS-CLASS        Alpha 3                                     PA01.1  PA01.2
Position Class       Contains the code that represents a
                     position class.

PQP-POSITION         Alpha 12                                    PA01.1  PA01.2
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  PA201
          POSITION

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

                         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

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

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