Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APPJOBHIST


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

       

   FILE - APPJOBHIST


  Condition         Type
--------------------------------------------------------------------------------
  APPLICANT         FILEFLD

  where  (                      Applicant != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - APPLICANT
                 - COMMENTS
  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
--------------------------------------------------------------------------------
  COMMENTS-EXIST    OTOFLDS

  where  (             Relation: Comments 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
--------------------------------------------------------------------------------
  CONTACTED         FILEFLD

  where  (                   Contact 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
--------------------------------------------------------------------------------
  COUNTRY           FILEFLD

  where ((                   Country Code != Spaces                         ))


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

  where  (                       Employee != Zeroes                         )


  Is Used In Index - AJHSET3
  Is Used In Rel - EMP-COMMENTS
                 - EMPLOYEE
                 - PAEMPLOYEE
  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
--------------------------------------------------------------------------------
  EMPLOYEE-EXIST    OTOFLDS

  where  (             Relation: Employee 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
--------------------------------------------------------------------------------
  SEQ-NBR-BLANK     FILEFLD

  where  (                        Seq Nbr  = 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