Lawson Insight Technical Documentation

                            PRQCENTGRP FILE

REFERENCED BY

AC541     AC542     BN150     HR511     HR650     PA502
PR128     PR13.1    PR13.5    PR13.6    PR13.8    PR131
PR132     PR134     PR136     PR30.1    PR32.2    PR33.2
PR33.3    PR35.1    PR35.2    PR35.3    PR35.4    PR35.5
PR35.6    PR35.8    PR36.1    PR530     PR560     PR82.1
UK102     UK120

UPDATED BY

HR00.1    HR00.3    HR01.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  PR197
                     established company and is entered on
                     all function codes.

PQC-PROCESS-LEVEL    Alpha 5                                     HR00.1  HR00.3
Process Level        This field contains the process level,      HR01.1  PR197
                     which is the reporting hierarchy below
                     company.

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

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

                         PRQCENTGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PQCSET1   COMPANY                                                AC541   AC542
          PROCESS-LEVEL                                          BN150   HR00.1
          QC-ENT-NBR-GRP                                         HR00.3  HR01.1
                                                                 HR511   HR650
                                                                 PA502   PR128
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR197   PR30.1
                                                                 PR32.2  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 ...

                         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