Lawson Insight Technical Documentation

                            PRQCENTGRP FILE

REFERENCED BY

AC541     AC542     BN150     HPQC.1    HR11.1    HR11.2
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     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
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
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
Qc Ent Nbr Grp                                                   HR01.1  PBIP.1
                                                                 PR197

PQC-QC-ENT-NBR       Alpha 16                                    HR00.1  HR00.3
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  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  PR13.8
                                                                 PR130   PR131
                                                                 ...

                         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