Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAJOBREQ


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

       

   FILE - PAJOBREQ


  Condition         Type
--------------------------------------------------------------------------------
  APP-STATUS        FILEFLD

  where  (                     App Status != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - APP-STATUS
  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
--------------------------------------------------------------------------------
  APPROVAL-EMP      FILEFLD, ARRFLDS

  where  (                   Approval Emp != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - APPROVAL-EMP
  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
--------------------------------------------------------------------------------
  APPROVED          FILEFLD

  where  (                  Approval Flag != "N"                            )


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

  where  (                  Currency Code != Spaces                         
     Or                       Curr Code 2 != Spaces                         )


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

  where  (                    Contact Nbr != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - CONTACT-NBR
  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
--------------------------------------------------------------------------------
  COST              OTOFLDS

  where  (                 Relation: Cost 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-EXT-POST      FILEFLD

  where  (                 External Start <=                                
    And  (                  External Stop  = Zeroes                         
     Or                     External Stop >=                                ))


  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-INT-POST      FILEFLD

  where  (                 Internal Start <=                                
    And  (                  Internal Stop >=                                
     Or                     Internal Stop  = 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
--------------------------------------------------------------------------------
  CURR-CODE-2       FILEFLD

  where ((                    Curr Code 2 != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - CURRENCY2
  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 - 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  EXT-APPLICANTS    OTOFLDS

  where  (       Relation: Ext Applicants 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
--------------------------------------------------------------------------------
  EXT-POST-OPEN     FILEFLD

  where ((                 External Start != Zeroes                         
    And                    External Start <=                                )
    And  (                  External Stop  = Zeroes                         
     Or                     External Stop >=                                )
    And  (                    Closed Date  = Zeroes                         
     Or                       Closed 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
--------------------------------------------------------------------------------
  GRADE-STEP        FILEFLD

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


  Is Used In No Indexes
  Is Used In Rel - GRADE-STEP
  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
--------------------------------------------------------------------------------
  INT-APPLICANTS    OTOFLDS

  where  (       Relation: Int Applicants 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
--------------------------------------------------------------------------------
  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-POSITION       FILEFLD

  where ((                       Position  = Spaces                         ))


  Is Used In Index - PJRSET3
  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-APPROVED      FILEFLD

  where  (                  Approval Flag  = "N"                            )


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

  where  (                    Closed Date  = 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
--------------------------------------------------------------------------------
  NOT-CLOSED2       FILEFLD

  where  (                    Closed Date  = Zeroes                         
     Or                       Closed 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
--------------------------------------------------------------------------------
  NOT-OPEN          FILEFLD

  where  (                      Open Date  = 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
--------------------------------------------------------------------------------
  OFFERS            OTOFLDS

  where  (               Relation: Offers 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
--------------------------------------------------------------------------------
  OPEN              FILEFLD

  where  (                      Open Date != 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
--------------------------------------------------------------------------------
  OPEN-APPROVED     FILEFLD

  where  (                    Closed Date  = Zeroes                         
    And                         Open Date != 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  POSITION          FILEFLD

  where ((                       Position != Spaces                         ))


  Is Used In Index - PJRSET2
  Is Used In Rel - POS-CHG-ERROR
                 - POS-DATE
                 - 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
--------------------------------------------------------------------------------
  REP-EMPLOYEE      FILEFLD

  where  (                   Rep Employee != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - REP-EMPLOYEE
  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
--------------------------------------------------------------------------------
  REQ-STATUS        FILEFLD

  where  (                     Req Status != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - REQ-STATUS
  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
--------------------------------------------------------------------------------
  REQUEST-BY        FILEFLD

  where  (                     Request By != Zeroes                         )


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

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


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

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


  Is Used In No Indexes
  Is Used In Rel - SCHEDULE
  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 Index - PJRSET5
  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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  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-SCHEDULE     FILEFLD

  where  (                     Work Sched != Spaces                         )


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