Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms


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

         

   FILE - PAPREREQ


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

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


  Is Used In No Indexes
  Is Used In Rel - COMPETENCY
  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            FILEFLD, OTOFLDS

  where ((                    Prereq Type  = "CS"                           )
    And  (        Relation: Course Prereq 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 3 Rules



  Condition         Type
--------------------------------------------------------------------------------
  COURSE-TYPE       FILEFLD

  where  (                    Prereq Type  = "CS"                           )


  Is Used In No Indexes
  Is Used In Rel - COURSE-PREREQ
  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
--------------------------------------------------------------------------------
  CURRENT           FILEFLD

  where ((                 Effective Date <=                                )
    And ((                       End Date  = Zeroes                         )
     Or  (                       End Date >=                                )))


  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
--------------------------------------------------------------------------------
  GROUP             FILEFLD, OTOFLDS

  where ((                    Prereq Type  = "EG"                           )
    And  (                Relation: Group 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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  GROUP-TYPE        FILEFLD

  where  (                    Prereq Type  = "EG"                           )


  Is Used In No Indexes
  Is Used In Rel - COMPGROUP
                 - GROUP
  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
--------------------------------------------------------------------------------
  NOT-REQUIRED      FILEFLD

  where ((                  Required Flag  = "N"                            ))


  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 ((                   Profic Level != Spaces                         ))


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

  where ((                  Required Flag  = "Y"                            ))


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

  where ((                    Prereq Type  = "SV"                           ))


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



  Condition         Type
--------------------------------------------------------------------------------
  SKILL             FILEFLD, OTOFLDS

  where ((                    Prereq Type  = "SK"                           )
    And  (            Relation: Skillcode Exists         ))


  Is Used In No Indexes
  Is Used In Rel - SKILLCODE
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In 1 Rule