Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMPVISA


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

       

   FILE - EMPVISA


  Condition         Type
--------------------------------------------------------------------------------
  APPLY-STATUS      FILEFLD

  where  (                   Apply Status != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - APPLY-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
--------------------------------------------------------------------------------
  CITIZEN           FILEFLD

  where  (                        Citizen != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - CITIZEN
  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  (                     Renew 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
--------------------------------------------------------------------------------
  DEPENDENT         FILEFLD

  where  (                      Dependent  > Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - DEPENDENT
  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  (                      Dependent  = 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
--------------------------------------------------------------------------------
  EXPIRED           FILEFLD

  where ((                       Exp Date != Zeroes                         )
    And  (                       Exp 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-EXPIRED       FILEFLD

  where ((                       Exp Date  = Zeroes                         )
     Or  (                       Exp 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
--------------------------------------------------------------------------------
  TRAV-DOCUMENT     FILEFLD

  where  (                  Trav Document != Spaces                         )


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

  where ((                  Visa Cntry Cd != Spaces                         ))


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