Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRQCENTGRP


                            PRQCENTGRP FILE

REFERENCED BY

AC541     AC542     BN150     HPQC.1    HR11.1    HR11.2
HR200     HR201     HR211     HR511     HR650     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     PR189     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    PR36.1    PR45.1    PR529
PR530     PR560     PR80.1    PR82.1    UK102     UK560
TA147     UK120

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       The company number represents an          HR01.1  PBIP.1
                       established company and is entered on     PR197
                       all function codes.

PQC-PROCESS-LEVEL      Alpha 5                                   HR00.1  HR00.3
Element: Process Level This 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                                                AC541   AC542
          PROCESS-LEVEL                                          BN150   HPQC.1
          QC-ENT-NBR-GRP                                         HR00.1  HR00.3
                                                                 HR01.1  HR11.1
                                                                 HR11.2  HR200
                                                                 HR201   HR211
                                                                 HR511   HR650
                                                                 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
                                                                 ...

                         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