Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PACANEEA


                             PACANEEA FILE

REFERENCED BY

PA294     PA594

UPDATED BY

PA94.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PCE-COMPANY            Numeric 4                                 PA94.1
Element: Company Hr

PCE-SIC                Numeric 6                                 PA94.1
Element: Sic           Contains the Canadian Standard Industry
                       Code by the Canadian Government.

PCE-PROCESS-LEVEL      Alpha 5                                   PA94.1
Element: Process Lev Hr

PCE-DEPARTMENT         Alpha 5                                   PA94.1
Element: Department    Contains the department.

PCE-LOCAT-CODE         Alpha 10                                  PA94.1
Element: Locat Code    Contains the location.

                         PACANEEA FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PCESET1   COMPANY                                                PA294   PA94.1
          SIC
          PROCESS-LEVEL
          DEPARTMENT
          LOCAT-CODE

PCESET2   COMPANY                                                PA594   PA94.1
          PROCESS-LEVEL
          DEPARTMENT
          LOCAT-CODE

PCESET3   COMPANY
          LOCAT-CODE
          PROCESS-LEVEL
          DEPARTMENT

                         PACANEEA FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PCE-COMPANY          -> PRS-COMPANY  (PRSSET1)
                            Spaces               -> PRS-PROCESS-LEVEL

Department     DEPTCODE     Required
                            When PCE-DEPARTMENT != Spaces
                            And  PCE-DEPARTMENT != "*ALL"

                            PCE-COMPANY          -> DPT-COMPANY
                            PCE-PROCESS-LEVEL    -> DPT-PROCESS-LEVEL
                            PCE-DEPARTMENT       -> DPT-DEPARTMENT

Location       PCODES       Required
                            When PCE-LOCAT-CODE != Spaces

                            "LO"                 -> PCO-TYPE
                            PCE-LOCAT-CODE       -> PCO-CODE

Pacanhdr       PACANHDR     Required

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

Process Level  PRSYSTEM     Required
                            When PCE-PROCESS-LEVEL != Spaces

                            PCE-COMPANY          -> PRS-COMPANY
                            PCE-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL