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    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                                               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
 |