Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PCODES


                               CONDITION REPORT
                               ----------------

       

   FILE - PCODES


  Condition         Type
--------------------------------------------------------------------------------
  ABILITIES         FILEFLD

  where ((                           Type  = "AB"                           ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ACT-SU-WEB-ALL    FILEFLD

  where  (                    Active Flag  = "A"                            
    And                    Web Avail Supv  = "3"                            
    And  (                           Type  = "CE"                           
     Or                              Type  = "ED"                           
     Or                              Type  = "KN"                           
     Or                              Type  = "SK"                           
     Or                              Type  = "AB"                           
     Or                              Type  = "OA"                           ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ACT-SU-WEB-CMP    FILEFLD

  where ((                    Active Flag  = "A"                            )
    And  (                 Web Avail Supv  = "3"                            )
    And ((                           Type  = "SK"                           )
     Or  (                           Type  = "AB"                           )
     Or  (                           Type  = "KN"                           )
     Or  (                           Type  = "OA"                           )))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ACT-SU-WEB-CRT    FILEFLD

  where ((                    Active Flag  = "A"                            )
    And  (                 Web Avail Supv  = "3"                            )
    And  (                           Type  = "CE"                           ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ACT-SUP-WEB-ED    FILEFLD

  where ((                    Active Flag  = "A"                            )
    And  (                 Web Avail Supv  = "3"                            )
    And  (                           Type  = "ED"                           ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ACT-WEB-ALL       FILEFLD

  where  (                    Active Flag  = "A"                            
    And                     Web Available  = "3"                            
    And  (                           Type  = "CE"                           
     Or                              Type  = "ED"                           
     Or                              Type  = "KN"                           
     Or                              Type  = "SK"                           
     Or                              Type  = "AB"                           
     Or                              Type  = "OA"                           ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ACT-WEB-CERT      FILEFLD

  where ((                    Active Flag  = "A"                            )
    And  (                  Web Available  = "3"                            )
    And  (                           Type  = "CE"                           ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ACT-WEB-COMP      FILEFLD

  where ((                    Active Flag  = "A"                            )
    And  (                  Web Available  = "3"                            )
    And ((                           Type  = "SK"                           )
     Or  (                           Type  = "AB"                           )
     Or  (                           Type  = "KN"                           )
     Or  (                           Type  = "OA"                           )))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ACT-WEB-EDUC      FILEFLD

  where ((                    Active Flag  = "A"                            )
    And  (                  Web Available  = "3"                            )
    And  (                           Type  = "ED"                           ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ACTIVE            FILEFLD

  where  (                    Active Flag  = "A"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ACTIVE-COURSE     FILEFLD, OTOFLDS

  where ((                    Active Flag  = "A"                            )
    And  (        Relation: Course Compet Exists         ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CERT-COMPET       FILEFLD

  where ((                           Type  = "AB"                           )
     Or  (                           Type  = "KN"                           )
     Or  (                           Type  = "OA"                           )
     Or  (                           Type  = "SK"                           )
     Or  (                           Type  = "CE"                           ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CERTIFICATION     FILEFLD

  where  (                           Type  = "CE"                           )


  Is Used In No Indexes
  Is Used In Rel - TRACK-CERT
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CMA               FILEFLD

  where  (                           Type  = "CA"                           )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  COMP-PROF-EXIS    OTOFLDS

  where  (          Relation: Comp Profic Exists         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  COMPETENCY        FILEFLD

  where ((                           Type  = "AB"                           )
     Or  (                           Type  = "KN"                           )
     Or  (                           Type  = "OA"                           )
     Or  (                           Type  = "SK"                           ))


  Is Used In No Indexes
  Is Used In Rel - COMP-PROFIC
                 - COURSE-COMPET
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  COURSE-SKILLS     OTOFLDS

  where  (        Relation: Course Skills Exists         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  KNOWLEDGE         FILEFLD

  where ((                           Type  = "KN"                           ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  LOCATION          FILEFLD

  where  (                           Type  = "LO"                           )


  Is Used In No Indexes
  Is Used In Rel - LOCATION-EMPS
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  LOCATION-EMPS     OTOFLDS

  where  (        Relation: Location Emps Exists         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  NOC               FILEFLD

  where  (                           Type  = "NC"                           )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  OTHER-ATTRIB      FILEFLD

  where ((                           Type  = "OA"                           ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  PCODESDTL         OTOFLDS

  where  (            Relation: Pcodesdtl Exists         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  PROF-EXIST        OTOFLDS

  where  (          Relation: Proficiency Exists         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  PROFICIENCY       FILEFLD

  where ((                           Type  = "PF"                           ))


  Is Used In No Indexes
  Is Used In Rel - PROFICIENCY
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  REVIEW            FILEFLD

  where ((                           Type  = "RT"                           )
     Or  (                           Type  = "PR"                           ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  SKILL             FILEFLD

  where ((                           Type  = "SK"                           ))


  Is Used In No Indexes
  Is Used In Rel - COURSE-SKILLS
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  TRACK-CERT        OTOFLDS

  where  (           Relation: Track Cert Exists         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  UNION             FILEFLD

  where  (                           Type  = "UN"                           )


  Is Used In No Indexes
  Is Used In Rel - UNION-EMPS
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  UNION-EMPS        OTOFLDS

  where  (           Relation: Union Emps Exists         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  USER-FIELDS       FILEFLD

  where  (                           Type  = "U1"                           
     Or                              Type  = "U2"                           
     Or                              Type  = "U3"                           
     Or                              Type  = "U4"                           
     Or                              Type  = "U5"                           
     Or                              Type  = "U6"                           
     Or                              Type  = "U7"                           
     Or                              Type  = "U8"                           )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In SubType - USER-FIELDS
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  USER-LEV-EMPS     OTOFLDS

  where  (        Relation: User Lev Emps Exists         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  USER-LEVEL        FILEFLD

  where  (                           Type  = "UL"                           )


  Is Used In No Indexes
  Is Used In Rel - USER-LEV-EMPS
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  VW-EM-WEB-ALL     FILEFLD

  where  (                    Active Flag  = "A"                            
    And                     Web Available  > "1"                            
    And  (                           Type  = "CE"                           
     Or                              Type  = "ED"                           
     Or                              Type  = "KN"                           
     Or                              Type  = "SK"                           
     Or                              Type  = "AB"                           
     Or                              Type  = "OA"                           ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  VW-EM-WEB-CMP     FILEFLD

  where  (                    Active Flag  = "A"                            
    And                     Web Available  > "1"                            
    And  (                           Type  = "KN"                           
     Or                              Type  = "SK"                           
     Or                              Type  = "AB"                           
     Or                              Type  = "OA"                           ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  VW-EM-WEB-CRT     FILEFLD

  where  (                    Active Flag  = "A"                            
    And                     Web Available  > "1"                            
    And                              Type  = "CE"                           )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  VW-EM-WEB-ED      FILEFLD

  where  (                    Active Flag  = "A"                            
    And                     Web Available  > "1"                            
    And                              Type  = "ED"                           )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  VW-SU-WEB-ALL     FILEFLD

  where  (                    Active Flag  = "A"                            
    And                    Web Avail Supv  > "1"                            
    And  (                           Type  = "CE"                           
     Or                              Type  = "ED"                           
     Or                              Type  = "KN"                           
     Or                              Type  = "SK"                           
     Or                              Type  = "AB"                           
     Or                              Type  = "OA"                           ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  VW-SU-WEB-CMP     FILEFLD

  where  (                    Active Flag  = "A"                            
    And                    Web Avail Supv  > "1"                            
    And  (                           Type  = "KN"                           
     Or                              Type  = "SK"                           
     Or                              Type  = "AB"                           
     Or                              Type  = "OA"                           ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  VW-SU-WEB-CRT     FILEFLD

  where  (                    Active Flag  = "A"                            
    And                    Web Avail Supv  > "1"                            
    And                              Type  = "CE"                           )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  VW-SU-WEB-ED      FILEFLD

  where  (                    Active Flag  = "A"                            
    And                    Web Avail Supv  > "1"                            
    And                              Type  = "ED"                           )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  WEB-AVAIL         FILEFLD

  where ((                  Web Available  > "1"                            ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  WEB-SUPV-ACTIV    FILEFLD

  where  (                    Active Flag  = "A"                            
    And                    Web Avail Supv  > "1"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  WEB-SUPV-AVAIL    FILEFLD

  where ((                 Web Avail Supv  > "1"                            ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules