Lawson Insight Technical Documentation | 
  
    
  | 
  
                            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
 |