Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ATTENDHIST


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

       

   FILE - ATTENDHIST


  Condition         Type
--------------------------------------------------------------------------------
  DEPARTMENT        FILEFLD

  where  (                     Department != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - DEPARTMENT
  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
--------------------------------------------------------------------------------
  FRIDAY            FILEFLD

  where ((                       Days Ind  = 6                              ))


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

  where ((                    Record Type  = "M"                            ))


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

  where ((                       Days Ind  = 2                              ))


  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
--------------------------------------------------------------------------------
  NO-OCCUR          FILEFLD

  where ((                     Occurrence != "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
--------------------------------------------------------------------------------
  NO-POINTS         FILEFLD

  where ((                         Points  = 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



  Condition         Type
--------------------------------------------------------------------------------
  NO-TAEEMASTER     OTOFLDS

  where  (           Relation: Taeemaster 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
--------------------------------------------------------------------------------
  OCCUR             FILEFLD

  where ((                     Occurrence  = "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
--------------------------------------------------------------------------------
  POINTS            FILEFLD

  where ((                         Points != 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



  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
--------------------------------------------------------------------------------
  PRTIME            OTOFLDS

  where  (               Relation: Prtime 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
--------------------------------------------------------------------------------
  SATURDAY          FILEFLD

  where ((                       Days Ind  = 7                              ))


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

  where ((                       Days Ind  = 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
--------------------------------------------------------------------------------
  SYSTEM            FILEFLD

  where ((                    Record Type  = "S"                            ))


  Is Used In No Indexes
  Is Used In Rel - PRTIME
  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
--------------------------------------------------------------------------------
  THURSDAY          FILEFLD

  where ((                       Days Ind  = 5                              ))


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

  where ((                       Days Ind  = 3                              ))


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

  where ((                       Days Ind  = 4                              ))


  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