Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRQCENTGRP


                            PRQCENTGRP FILE

REFERENCED BY

BN150     HPQC.1    HR11.1    HR11.2    HR200     HR201
HR511     PA02.1    PA100     PA102     PA502     PA52.1
PA52.3    PA52.4    PA52.5    PR110     PR113     PR120
PR128     PR13.1    PR13.5    PR13.6    PR13.8    PR130
PR131     PR132     PR134     PR136     PR240     PR241
PR242     PR243     PR244     PR245     PR29.1    PR30.1
PR32.2    PR33.2    PR33.3    PR35.1    PR35.2    PR35.3
PR35.4    PR35.5    PR35.6    PR35.8    PR35.9    PR36.1
PR45.1    PR529     PR530     PR560     PR82.1    UK102
TA147     TP135

UPDATED BY

HR00.1    HR00.3    HR01.1    PBIP.1    PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PQC-COMPANY            Numeric 4                                 HR00.1  HR00.3
Element: Company Hr    Identifies the AP company if the          HR01.1  PBIP.1
                       resource type = V.  Identifies the HR     PR197
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PQC-PROCESS-LEVEL      Alpha 5                                   HR00.1  HR00.3
Element: Process Lev HrThis field contains the process level,    HR01.1  PBIP.1
                       which is the reporting hierarchy below    PR197
                       company.

PQC-QC-ENT-NBR-GRP     Alpha 4                                   HR00.1  HR00.3
Element: Qc Ent Nbr Grp                                          HR01.1  PBIP.1
                                                                 PR197

PQC-QC-ENT-NBR         Alpha 16                                  HR00.1  HR00.3
Element: Qc Ent Nbr                                              HR01.1  PBIP.1
                                                                 PR197

                         PRQCENTGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PQCSET1   COMPANY                                                BN150   HPQC.1
          PROCESS-LEVEL                                          HR00.1  HR00.3
          QC-ENT-NBR-GRP                                         HR01.1  HR11.1
                                                                 HR11.2  HR200
                                                                 HR201   HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PBIP.1  PR110
                                                                 PR113   PR120
                                                                 PR128   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PR130
                                                                 PR131   PR132
                                                                 ...

                         PRQCENTGRP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PQC-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Process Level  PRSYSTEM     Required

                            PQC-COMPANY          -> PRS-COMPANY
                            PQC-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

                         PRQCENTGRP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employees      EMPLOYEE

                            PQC-COMPANY          -> EMP-COMPANY
                            PQC-PROCESS-LEVEL    -> EMP-PROCESS-LEVEL
                                                    EMP-EMPLOYEE