Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAOFFLANG


                             PAOFFLANG FILE

REFERENCED BY

PA496     PA296

UPDATED BY

PA96.1    HR00.1    HR01.1    HR11.1    PA02.1    PA115
PA302     PA502

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PLA-COMPANY            Numeric 4                                 PA96.1
Element: Company Hr

PLA-EMPLOYEE           Numeric 9                                 PA96.1
Element: Employee      Contains the employee number. Each
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

PLA-POSITION           Alpha 12                                  PA96.1
Element: Position      Contains the user-defined code that
                       represents a position in the company.

PLA-REPORT-TYPE        Alpha 1                                   PA96.1
Element: Report Type   1 = Service to Public
                       2 = Internal Services
                       3 = Supervision

PLA-SEQ-NBR            Numeric 4                                 PA96.1
Element: Seq Nbr       An automatically assigned sequence
                       number.

PLA-EFFECT-DATE        Numeric 8  (yyyymmdd)                     PA96.1
Element: Effect Date

PLA-END-DATE           Numeric 8  (yyyymmdd)                     PA96.1
Element: End Date      The end date for this effort period.

PLA-TYPE               Alpha 2                                   PA96.1
Element: Type          This identifies whether this record is
                       created because of a picking
                       transaction, or because of a return.
                       Valid values are:
                           "IS" = Picking transaction.
                           "RR" = Return.
                        ~$1 VENDOR
                       The vendor's identification code.

                       BO = Bilingual Office
                       BR = Billingual Region

PLA-CODE               Alpha 10                                  PA96.1
Element: Code          Code that is valid for the specified
                       record type.

PLA-DATE               Numeric 8  (yyyymmdd)                     PA96.1
Element: Date          This field displays the system date
                       when this was created.

                         PAOFFLANG FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PLASET1   COMPANY                                                HR00.1  HR01.1
          EMPLOYEE                                               HR11.1  PA02.1
          POSITION                                               PA115   PA302
          REPORT-TYPE                                            PA496   PA502
          SEQ-NBR                                                PA96.1

PLASET2   COMPANY       KeyChange                                PA296   PA96.1
          EMPLOYEE
          POSITION
          REPORT-TYPE
          DATE*
          SEQ-NBR

                         PAOFFLANG FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PLA-COMPANY     -> PRS-COMPANY
                            Spaces          -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required
                            When PLA-EMPLOYEE != Zeroes

                            PLA-COMPANY     -> EMP-COMPANY
                            PLA-EMPLOYEE    -> EMP-EMPLOYEE

Office         PCODES       Required
                            When PLA-TYPE = "BO"

                            PLA-TYPE        -> PCO-TYPE
                            PLA-CODE        -> PCO-CODE

Paemployee     PAEMPLOYEE   Required
                            When PLA-EMPLOYEE != Zeroes

                            PLA-COMPANY     -> PEM-COMPANY
                            PLA-EMPLOYEE    -> PEM-EMPLOYEE

Region         PCODES       Required
                            When PLA-TYPE = "BR"

                            PLA-TYPE        -> PCO-TYPE
                            PLA-CODE        -> PCO-CODE

                         PAOFFLANG FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Position       PAPOSITION
                            Valid When PLA-POSITION != Spaces

                            PLA-COMPANY     -> POS-COMPANY
                            PLA-POSITION    -> POS-POSITION
                                               POS-EFFECT-DATE