Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PAPROMAP FILE

Holds the list of education or certification codes which are mapped to each
section of the profile. This mapping is user-determined.

UPDATED BY

HR00.1    HR01.1    PBIP.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PPM-COMPANY          Numeric 4
Company              The company number represents an
                     established company and is entered on
                     all function codes.


PPM-WEB-TYPE         Alpha 3
Web Type             Indicates the type of profile.
                     1 = Physician
                     2 = Nurse

PPM-SEQ              Numeric 3
Sequence Number      Indicates the section of the profile.
                     E.g. 1 = Education; 2 = Licenses

PPM-TYPE             Alpha 2
Type                 Indentifies the type of profile. Valid
                     values  are:
                     CE = Certification
                     ED = Education
                     SK = Skill

PPM-CODE             Alpha 10
Code                 Contains the code of the profile.

PPM-SEQ-NBR          Numeric 4
Sequence Number      An automatically assigned sequence
                     number.

PPM-COMMMENT         Alpha 40  (Lower Case)
Commment             Contains comments on the profile.

                         PAPROMAP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PPMSET1   COMPANY                                                HR00.1  HR01.1
          WEB-TYPE                                               PBIP.1  PR197
          SEQ
          TYPE
          CODE
          SEQ-NBR

PPMSET2   COMPANY
          TYPE
          CODE
          SEQ-NBR
          WEB-TYPE
          SEQ

                         PAPROMAP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Certification  PCODES       Required
                            When PPM-TYPE = "CE"

                            "CE"            -> PCO-TYPE
                            PPM-CODE        -> PCO-CODE

Company        PRSYSTEM     Required

                            PPM-COMPANY     -> PRS-COMPANY
                            Spaces          -> PRS-PROCESS-LEVEL

Profile        PAPROFILE    Required

                            PPM-COMPANY     -> PPF-COMPANY
                            PPM-WEB-TYPE    -> PPF-WEB-TYPE
                            PPM-SEQ         -> PPF-SEQ

Skill          PCODES       Required
                            When PPM-TYPE = "SK"

                            "SK"            -> PCO-TYPE
                            PPM-CODE        -> PCO-CODE