Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMPCODES


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

       

   FILE - EMPCODES


  Condition         Type
--------------------------------------------------------------------------------
  APPLICANT         FILEFLD

  where  (                        Emp App  = 1                              )


  Is Used In No Indexes
  Is Used In Rel - APPLICANT
  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
--------------------------------------------------------------------------------
  BENEFITS          FILEFLD

  where  (                           Type  = "BN"                           )


  Is Used In No Indexes
  Is Used In Rel - BN-COMMENTS
  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  = "SK"                           )
     Or  (                           Type  = "KN"                           )
     Or  (                           Type  = "OA"                           )
     Or  (                           Type  = "CE"                           ))


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

  where  (                           Type  = "CE"                           )


  Is Used In No Indexes
  Is Used In Rel - CE-COMMENTS
                 - 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
--------------------------------------------------------------------------------
  COMPANY-PROP      FILEFLD

  where  (                           Type  = "CP"                           )


  Is Used In No Indexes
  Is Used In Rel - CP-COMMENTS
  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 Index - EPCSET3
  Is Used In Rel - SK-COMMENTS
  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
--------------------------------------------------------------------------------
  CONTRACT          FILEFLD

  where ((                           Type  = "CN"                           ))


  Is Used In No Indexes
  Is Used In Rel - CONTRACT
  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
--------------------------------------------------------------------------------
  CP-COMMENTS-EX    OTOFLDS

  where  (          Relation: Cp Comments 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
--------------------------------------------------------------------------------
  CURR-CONTRACT     FILEFLD

  where ((                           Type  = "CN"                           )
    And ((                  Date Returned  = Zeroes                         )
     Or  (                  Date Returned  >                                )))


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

  where ((                  Currency Code != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - BASE-CURRENCY
                 - CURRENCY
  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
--------------------------------------------------------------------------------
  EDUCATION         FILEFLD

  where  (                           Type  = "ED"                           )


  Is Used In No Indexes
  Is Used In Rel - ED-COMMENTS
  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
--------------------------------------------------------------------------------
  EMPLOYEE          FILEFLD

  where  (                        Emp App  = Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - EMPLOYEE
                 - PAEMPLOYEE
  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
--------------------------------------------------------------------------------
  EPCSET3           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 No Rules



  Condition         Type
--------------------------------------------------------------------------------
  EPCSET4           FILEFLD

  where  (                           Type  = "ED"                           )


  Is Used In Index - EPCSET4
  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
--------------------------------------------------------------------------------
  EPCSET5           FILEFLD

  where  (                           Type  = "ED"                           )


  Is Used In Index - EPCSET5
  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
--------------------------------------------------------------------------------
  INSTITUTION       FILEFLD

  where  (                           Type  = "ED"                           
    And                        Instructor != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - INSTITUTION
  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
--------------------------------------------------------------------------------
  OBJECT-ID         FILEFLD

  where ((                         Obj Id != Zeroes                         ))


  Is Used In Index - EPCSET6
  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
--------------------------------------------------------------------------------
  PAEMPLOYEE        OTOFLDS

  where  (           Relation: Paemployee 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
--------------------------------------------------------------------------------
  RELOCATION        FILEFLD

  where  (                           Type  = "RL"                           )


  Is Used In No Indexes
  Is Used In Rel - RL-COMMENTS
  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
--------------------------------------------------------------------------------
  SET7              FILEFLD

  where(((                           Type != "BN"                           )
    And  (                           Type != "RL"                           )))


  Is Used In Index - EPCSET7
  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-SOURCE      FILEFLD

  where  (                   Skill Source != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - SKILL-SOURCE
  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
--------------------------------------------------------------------------------
  SKILLS            FILEFLD

  where  (                           Type  = "SK"                           )


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

  where  (                        Subject != 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  TRAINING-SKILL    FILEFLD

  where  (                           Type  = "SK"                           
    And                            Obj Id != Zeroes                         )


  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