Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

JOBCODE


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

       

   FILE - JOBCODE


  Condition         Type
--------------------------------------------------------------------------------
  ACADEMIC-RANK     FILEFLD

  where ((                  Academic Rank >= "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
--------------------------------------------------------------------------------
  ACTIVE            FILEFLD

  where  (                    Active Flag  = "A"                            )


  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
--------------------------------------------------------------------------------
  APPROVED-BY       FILEFLD

  where  (                    Approved By != Zeroes                         )


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

  where  (                        Eeo Cat  = "50"                           
     Or                           Eeo Cat  = "51"                           )


  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
--------------------------------------------------------------------------------
  CRAFT-WORKERS     FILEFLD

  where  (                        Eeo Cat  = "60"                           
     Or                           Eeo Cat  = "61"                           )


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

  where  (          Relation: Description 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
--------------------------------------------------------------------------------
  EEO-CATEGORY      FILEFLD

  where ((                        Eeo Cat >= "01"                           )
    And  (                        Eeo Cat != "99"                           ))


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

  where  (            Relation: Employees 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
--------------------------------------------------------------------------------
  EXPENSE-ACCT      FILEFLD

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


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

  where  (                   Gender Class  = "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
--------------------------------------------------------------------------------
  GRADE             FILEFLD

  where  (                      Pay Grade != 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
--------------------------------------------------------------------------------
  HIGHER-ED         FILEFLD

  where ((                    High Ed Cat >= 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  HOURLY            FILEFLD

  where  (                   Salary Class  = "H"                            )


  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
--------------------------------------------------------------------------------
  HR-OCCUP-CODE     OTOFLDS

  where  (        Relation: Hr Occup Code 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
--------------------------------------------------------------------------------
  HRHIST-EXISTS     OTOFLDS

  where  (            Relation: Hrhistory 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-CLASS         FILEFLD

  where  (                      Job Class != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - JOB-CLASS
  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-INTEREST      OTOFLDS

  where  (         Relation: Job 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
--------------------------------------------------------------------------------
  JOB-RELATIONS     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
--------------------------------------------------------------------------------
  LABORERS          FILEFLD

  where  (                        Eeo Cat  = "80"                           
     Or                           Eeo Cat  = "82"                           )


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

  where  (                   Gender Class  = "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
--------------------------------------------------------------------------------
  NEUTRAL           FILEFLD

  where  (                   Gender Class  = "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
--------------------------------------------------------------------------------
  NO-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
--------------------------------------------------------------------------------
  OFFICLS-MNGRS     FILEFLD

  where  (                        Eeo Cat  = "10"                           
     Or                           Eeo Cat  = "11"                           )


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

  where  (                        Eeo Cat  = "70"                           
     Or                           Eeo Cat  = "72"                           )


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

  where  (                        Eeo Cat  = "20"                           
     Or                           Eeo Cat  = "21"                           )


  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
--------------------------------------------------------------------------------
  REPORTS-TO        FILEFLD

  where  (                     Reports To != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - REPORTS-TO
  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
--------------------------------------------------------------------------------
  REQUIS-EXISTS     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
--------------------------------------------------------------------------------
  SALARY            FILEFLD

  where  (                   Salary Class  = "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
--------------------------------------------------------------------------------
  SALES-WORKERS     FILEFLD

  where  (                        Eeo Cat  = "40"                           
     Or                           Eeo Cat  = "41"                           )


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

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


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

  where  (                       Schedule != Spaces                         )


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

  where  (                        Eeo Cat  = "90"                           
     Or                           Eeo Cat  = "92"                           )


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

  where  (                        Eeo Cat  = "30"                           
     Or                           Eeo Cat  = "31"                           )


  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
--------------------------------------------------------------------------------
  TENURE-ELIG       FILEFLD

  where ((                    Tenure Elig  = "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
--------------------------------------------------------------------------------
  WC-CLASS          FILEFLD

  where  (                       Wc Class != Spaces                         )


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

  where  (                    Ca Wc Class != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - WC-CLASS-CA
  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