Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms


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

         

   FILE - PAPOSITION


  Condition         Type
--------------------------------------------------------------------------------
  ACCOUNT-CAT       FILEFLD

  where ((                  Acct Category != Spaces                         ))


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

  where  (                   Posit Status  < 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
--------------------------------------------------------------------------------
  ACTIVE-CURRENT    FILEFLD

  where  (                   Posit Status  < 3                              
    And                       Effect 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
--------------------------------------------------------------------------------
  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-EMPLOYEES     OTOFLDS

  where  (         Relation: Emp Pos Hist 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
--------------------------------------------------------------------------------
  ASSIGN-RES        OTOFLDS

  where  (           Relation: Assign Res 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
--------------------------------------------------------------------------------
  BARGAIN-UNIT      FILEFLD

  where  (                   Bargain Unit != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - BARGAIN-UNIT
  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
--------------------------------------------------------------------------------
  BUDGET            OTOFLDS

  where  (               Relation: Budget 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
--------------------------------------------------------------------------------
  CHG-REASON        FILEFLD

  where ((                     Chg Reason != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - CHG-REASON
  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
--------------------------------------------------------------------------------
  CLASS-POS         OTOFLDS

  where  (            Relation: Class Pos 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
--------------------------------------------------------------------------------
  CUR-EMPLOYEES     OTOFLDS

  where  (             Relation: Pathfind 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  CURRENT           FILEFLD

  where ((                    Effect 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
--------------------------------------------------------------------------------
  CURRENT-POS       FILEFLD

  where  (                       End Date  = Zeroes                         )


  Is Used In Index - POSSET4
  Is Used In Rel - POS-INTEREST
  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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  ENCUMBER          FILEFLD

  where  (                  Encumber 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
--------------------------------------------------------------------------------
  EXP-ACCOUNT       FILEFLD

  where ((                  Exp Acct Unit != Spaces                         )
     Or  (                    Exp Account != Zeroes                         ))


  Is Used In No Indexes
  Is Used In Rel - EXP-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
--------------------------------------------------------------------------------
  GRADE             FILEFLD

  where ((                      Pay Grade != Spaces                         )
    And  (                       Schedule != 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
--------------------------------------------------------------------------------
  GRADE-NO-STEP     FILEFLD

  where ((                       Schedule != Spaces                         )
    And  (                      Pay Grade != Spaces                         )
    And  (                       Pay Step  = Zeroes                         ))


  Is Used In No Indexes
  Is Used In Rel - GRADE
  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
--------------------------------------------------------------------------------
  HIST-ERR          OTOFLDS

  where  (             Relation: Hist Err 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  JOB-RELATION      OTOFLDS

  where  (        Relation: Job Relations 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
--------------------------------------------------------------------------------
  LOCATION          FILEFLD

  where  (                     Locat Code != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - LOCATION
  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-UPDATE         FILEFLD

  where  (                    Update 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
--------------------------------------------------------------------------------
  NOT-ENCUMBER      FILEFLD

  where  (                  Encumber 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
--------------------------------------------------------------------------------
  OFF-LANG          OTOFLDS

  where  (             Relation: Off Lang 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
--------------------------------------------------------------------------------
  OT-PLAN           FILEFLD

  where ((                   Ot Plan Code != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - OT-PLAN
  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
--------------------------------------------------------------------------------
  PAENCUMB-EXIST    OTOFLDS

  where  (           Relation: Paencumber 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
--------------------------------------------------------------------------------
  POS-CHG-ERROR     OTOFLDS

  where  (        Relation: Pos Chg Error 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
--------------------------------------------------------------------------------
  POS-CLASSPOS      OTOFLDS

  where  (         Relation: Pos Classpos 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
--------------------------------------------------------------------------------
  POS-INTEREST      OTOFLDS

  where  (         Relation: Pos Interest 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
--------------------------------------------------------------------------------
  POSCHANGE         OTOFLDS

  where  (            Relation: Poschange 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  REQUISITION       OTOFLDS

  where  (          Relation: Requisition 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
--------------------------------------------------------------------------------
  SCHEDULE          FILEFLD

  where ((                       Schedule != 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
--------------------------------------------------------------------------------
  STEP-AND-GRADE    FILEFLD

  where ((                       Pay Step != Zeroes                         ))


  Is Used In No Indexes
  Is Used In Rel - STEP-AND-GRADE
  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
--------------------------------------------------------------------------------
  SUPERVISOR        FILEFLD

  where  (                     Supervisor != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - SUPERVISOR
  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
--------------------------------------------------------------------------------
  SUPERVISOR-IND    FILEFLD

  where ((                 Supervisor Ind != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - INDIR-SUPV
                 - SUPERVISOR-IND
  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
--------------------------------------------------------------------------------
  SUPV-LINK         FILEFLD

  where ((                 Supervisor Lnk != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - SUPV-LINK
  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
--------------------------------------------------------------------------------
  UNION             FILEFLD

  where  (                     Union Code != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - UNION-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
--------------------------------------------------------------------------------
  UPDATE-Y          FILEFLD

  where  (                    Update 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
--------------------------------------------------------------------------------
  USER-FIELDS       OTOFLDS

  where  (          Relation: User Fields 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
--------------------------------------------------------------------------------
  USER-LEVEL        FILEFLD

  where  (                     User Level != Spaces                         )


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

  where ((                     Work Sched != Spaces                         ))


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