Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAPROMAP


                             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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PPM-COMPANY            Numeric 4
Element: Company Hr

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

PPM-SEQ                Numeric 3
Element: Seq           Indicates the section of the profile.
                       E.g. 1 = Education; 2 = Licenses

PPM-TYPE               Alpha 2
Element: Type          Indentifies the type of profile. Valid
                       values  are:
                       CE = Certification
                       ED = Education
                       SK = Skill
                       AB = Ability
                       KN = Knowledge
                       OA = Other Attributes

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

PPM-SEQ-NBR            Numeric 4
Element: Seq Nbr       An automatically assigned sequence
                       number.

PPM-COMMMENT           Alpha 40  (Lower Case)
Element: 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
          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

Competency     PCODES       Required
                            When (PPM-TYPE = "AB" )
                            Or   (PPM-TYPE = "KN" )
                            Or   (PPM-TYPE = "OA" )
                            Or   (PPM-TYPE = "SK" )

                            PPM-TYPE        -> PCO-TYPE
                            PPM-CODE        -> PCO-CODE

Profile        PAPROFILE    Required

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