Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

JOBRELATE


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

       

   FILE - JOBRELATE


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

  where  (        Relation: Compet 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
--------------------------------------------------------------------------------
  COMPANY-PROF      FILEFLD

  where(((                           Type  = "AB"                           )
     Or  (                           Type  = "KN"                           )
     Or  (                           Type  = "OA"                           )
     Or  (                           Type  = "SK"                           ))
    And  (                       Job Code  = Spaces                         )
    And  (                       Position  = Spaces                         ))


  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
--------------------------------------------------------------------------------
  COMPET-PROF       FILEFLD

  where(((                           Type  = "AB"                           )
     Or  (                           Type  = "KN"                           )
     Or  (                           Type  = "OA"                           )
     Or  (                           Type  = "SK"                           ))
    And  (                   Profic Level != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - COMPET-PROFIC
  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 - 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
--------------------------------------------------------------------------------
  EMPCODES-APPS     OTOFLDS

  where  (        Relation: Empcodes Apps 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
--------------------------------------------------------------------------------
  EMPCODES-EMPS     OTOFLDS

  where  (        Relation: Empcodes 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
--------------------------------------------------------------------------------
  JBRSET2           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
--------------------------------------------------------------------------------
  JOB-FUNCTIONS     FILEFLD

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


  Is Used In No Indexes
  Is Used In Rel - EMPCODES-APPS
                 - EMPCODES-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
--------------------------------------------------------------------------------
  JOBCODE           FILEFLD

  where ((                       Job Code != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - JOB-CODE
  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
--------------------------------------------------------------------------------
  NO-PROF-EXIST     OTOFLDS

  where  (          Relation: Proficiency Does Not Exist )


  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
--------------------------------------------------------------------------------
  NOT-EDUCATION     FILEFLD

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



  Condition         Type
--------------------------------------------------------------------------------
  PHYS-MNTL-REQ     FILEFLD

  where  (                           Type  = "PH"                           
     Or                              Type  = "MR"                           )


  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
--------------------------------------------------------------------------------
  PHYS-MNTL-WRK     FILEFLD

  where ((                           Type  = "EC"                           )
     Or  (                           Type  = "EO"                           )
     Or  (                           Type  = "MR"                           )
     Or  (                           Type  = "PH"                           )
     Or  (                           Type  = "SR"                           )
     Or  (                           Type  = "TR"                           ))


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

  where ((                       Position != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - POSITION
  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
--------------------------------------------------------------------------------
  PROCESS-LEVEL     FILEFLD

  where ((                  Process Level != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - PROCESS-LEVEL
  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
--------------------------------------------------------------------------------
  PROFIC-LEVEL      FILEFLD

  where ((                   Profic Level != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - PROFIC-LEVEL
  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
--------------------------------------------------------------------------------
  SUBJECT           FILEFLD

  where  (                   Subject Code != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - SUBJECT
  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
--------------------------------------------------------------------------------
  TEST              FILEFLD

  where ((                           Type  = "TS"                           ))


  Is Used In No Indexes
  Is Used In Rel - TEST-REQUIRE
  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
--------------------------------------------------------------------------------
  WORKING-COND      FILEFLD

  where  (                           Type  = "SR"                           
     Or                              Type  = "EO"                           
     Or                              Type  = "TR"                           
     Or                              Type  = "EC"                           )


  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