Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PACANHDR


                             PACANHDR FILE

REFERENCED BY

PA294     PA594

UPDATED BY

PA94.1    HR00.1    HR01.1    PBIP.1    PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PHD-COMPANY            Numeric 4                                 PA94.1
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PHD-SIC                Numeric 3                                 PA94.1
Element: Sic           Contains Canadian Standard Industry Code
                       (SIC) provided by Canadian Government.

PHD-DESCRIPTION        Alpha 30  (Lower Case)                    PA94.1
Element: Description   This field displays the description.

                         PACANHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PHDSET1   COMPANY                                                HR00.1  HR01.1
          SIC                                                    PA294   PA594
                                                                 PA94.1  PBIP.1
                                                                 PR197

                         PACANHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PHD-COMPANY    -> PRS-COMPANY
                            Spaces         -> PRS-PROCESS-LEVEL

Pacanhdr       PACANHDR     Required

                            PHD-COMPANY    -> PHD-COMPANY
                            PHD-SIC        -> PHD-SIC

                         PACANHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pacaneea       PACANEEA

                            PHD-COMPANY    -> PCE-COMPANY
                            PHD-SIC        -> PCE-SIC
                                              PCE-PROCESS-LEVEL
                                              PCE-DEPARTMENT
                                              PCE-LOCAT-CODE