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
 |