Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms


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

         

   FILE - TIMERECORD


  Condition         Type
--------------------------------------------------------------------------------
  ACCT-CATEGORY     FILEFLD

  where  (                  Acct Category != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - ACCT-CATEGORY
  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
--------------------------------------------------------------------------------
  ACTIVITY          FILEFLD

  where  (                       Activity != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - ACTIVITY
  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
--------------------------------------------------------------------------------
  ALL-RELEASED      FILEFLD

  where  (                         Status != Zeroes                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In SubType - ALL-RELEASED
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ATN-OBJ-ID        FILEFLD

  where  (                     Atn Obj Id != Zeroes                         )


  Is Used In Index - TRDSET9
  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
--------------------------------------------------------------------------------
  ATTEND-CODE       FILEFLD

  where  (                    Attend Code != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - ATTEND-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
--------------------------------------------------------------------------------
  BATCH-NUMBER      FILEFLD

  where  (                      Batch Nbr != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - BATCH-NUMBER
  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
--------------------------------------------------------------------------------
  CHECK-ID          FILEFLD

  where  (                       Check Id != Zeroes                         )


  Is Used In Index - TRDSET8
  Is Used In Rel - PAYMASTR
  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  (                         Status  = 2                              )


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



  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
--------------------------------------------------------------------------------
  DIST-ACCOUNT      FILEFLD

  where  (                    Dst Account != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - DIST-ACCOUNT
  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
--------------------------------------------------------------------------------
  EDIT              FILEFLD, STATE

  where  (                         Status  = Zeroes                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In State - EDIT
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ERROR             FILEFLD

  where  (                         Status  = 3                              )


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



  Condition         Type
--------------------------------------------------------------------------------
  FUTURE            FILEFLD

  where  (                         Status  = 1                              )


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



  Condition         Type
--------------------------------------------------------------------------------
  GLT-OBJ-ID        FILEFLD

  where  (                     Glt Obj Id != Zeroes                         )


  Is Used In Index - TRDSET14
  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-CODE          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
--------------------------------------------------------------------------------
  LEAVE-STATUS      FILEFLD

  where ((                   Leave Status  = 2                              )
     Or  (                   Leave Status  = 3                              )
     Or  (                   Leave Status  = 4                              ))


  Is Used In Index - TRDSET15
  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
--------------------------------------------------------------------------------
  PENS-PAYMENT      FILEFLD

  where  (                   Pens Seq Nbr != Zeroes                         )


  Is Used In Index - TRDSET13
  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
--------------------------------------------------------------------------------
  PROCESSED         FILEFLD

  where  (                         Status  = 4                              )


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



  Condition         Type
--------------------------------------------------------------------------------
  REASON-CODE       FILEFLD

  where ((                    Reason Code != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - REASON-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
--------------------------------------------------------------------------------
  RELEASED          FILEFLD, STATE

  where  (                         Status  = 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
--------------------------------------------------------------------------------
  SERVICE-CODE      FILEFLD

  where ((                   Service Code != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - SERVICE-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
--------------------------------------------------------------------------------
  STATUS0           FILEFLD

  where  (                         Status  = Zeroes                         )


  Is Used In Index - TRDSET10
  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
--------------------------------------------------------------------------------
  STATUS1           FILEFLD

  where  (                         Status  = 1                              )


  Is Used In Index - TRDSET11
  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
--------------------------------------------------------------------------------
  STATUS234         FILEFLD

  where ((                         Status  = 2                              )
     Or  (                         Status  = 3                              )
     Or  (                         Status  = 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



  Condition         Type
--------------------------------------------------------------------------------
  SYSTEM-TYPE       FILEFLD

  where  (                     Check Type  = "S"                            )


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

  where  (                     Error Flag != Spaces                         )


  Is Used In Index - TRDSET2
  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
--------------------------------------------------------------------------------
  TRDSET3           FILEFLD

  where  (                         Status  = 1                              )


  Is Used In Index - TRDSET3
  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
--------------------------------------------------------------------------------
  TRDSET4           FILEFLD

  where  (                         Status  = 2                              
     Or                            Status  = 3                              
     Or                            Status  = 4                              
     Or                            Status  = 5                              )


  Is Used In Index - TRDSET4
  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
--------------------------------------------------------------------------------
  TRDSET5           FILEFLD

  where  (                         Status  = Zeroes                         )


  Is Used In Index - TRDSET5
  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
--------------------------------------------------------------------------------
  TRDSET6           FILEFLD

  where  (                         Status  = 3                              )


  Is Used In Index - TRDSET6
  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
--------------------------------------------------------------------------------
  TRSGBLCK-EXIST    OTOFLDS

  where  (             Relation: Trsgblck 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
--------------------------------------------------------------------------------
  UNIT-MEASURE      FILEFLD

  where  (                   Unit Measure != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - ACUOM
  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
--------------------------------------------------------------------------------
  UNRELEASED        FILEFLD

  where  (                         Status  = Zeroes                         )


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



  Condition         Type
--------------------------------------------------------------------------------
  WC-PROVINCE       FILEFLD

  where ((                       Wc State != Spaces                         )
    And  (                    Ca Wc Class != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - WC-PROVINCE
  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
--------------------------------------------------------------------------------
  WC-STATE          FILEFLD

  where ((                       Wc State != Spaces                         )
    And  (                       Wc Class != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - WC-STATE
  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
--------------------------------------------------------------------------------
  WORK-PROVINCE     FILEFLD

  where ((                     Work State != Spaces                         )
    And  (                    Ca Wc Class != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - WORK-PROVINCE
  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
--------------------------------------------------------------------------------
  WORK-STATE        FILEFLD

  where ((                     Work State != Spaces                         )
    And  (                       Wc Class != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - WORK-STATE
  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