Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APPLICANT


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

       

   FILE - APPLICANT


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

  where  (         Relation: Certificates 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
--------------------------------------------------------------------------------
  COMPET-EXIST      OTOFLDS

  where  (           Relation: Competency 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
--------------------------------------------------------------------------------
  CORRES-EXIST      OTOFLDS

  where  (       Relation: Correspondence 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  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 - 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
--------------------------------------------------------------------------------
  DISABILITY        FILEFLD

  where  (                     Disability != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - DISABILITY
  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
--------------------------------------------------------------------------------
  EDUCATION         OTOFLDS

  where  (            Relation: Education 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
--------------------------------------------------------------------------------
  EMP-STATUS        FILEFLD

  where  (                     Emp Status != Spaces                         )


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

  where  (                       Employee != Zeroes                         )


  Is Used In Index - APLSET4
  Is Used In Rel - 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  EMPLOYERS         OTOFLDS

  where  (            Relation: Employers 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
--------------------------------------------------------------------------------
  ETHNICITY         FILEFLD

  where  (                      Eeo Class != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - ETHNICITY
  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
--------------------------------------------------------------------------------
  HIRE-SOURCE       FILEFLD

  where  (                    Hire Source != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - HIRE-SOURCE
  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
--------------------------------------------------------------------------------
  INTERVIEWS        OTOFLDS

  where  (           Relation: Interviews 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-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-REQS-EXIST    OTOFLDS

  where  (         Relation: Requisitions 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
--------------------------------------------------------------------------------
  JOB1              FILEFLD

  where  (                           Job1 != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - JOB1
  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
--------------------------------------------------------------------------------
  JOB2              FILEFLD

  where  (                           Job2 != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - JOB2
  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
--------------------------------------------------------------------------------
  JOB3              FILEFLD

  where  (                           Job3 != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - JOB3
  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
--------------------------------------------------------------------------------
  JOBS-APPLIED      FILEFLD

  where  (                           Job1 != Spaces                         
     Or                              Job2 != Spaces                         
     Or                              Job3 != 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
--------------------------------------------------------------------------------
  LANGUAGE          FILEFLD

  where  (                  Language Code != 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
--------------------------------------------------------------------------------
  LAST-NAME-PRE     FILEFLD

  where  (                  Last Name Pre != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - LAST-NAME-EXP
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  MIDDLE-INIT       FILEFLD

  where  (                    Middle Init != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - FIRST-MI-EXP
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  NAME-PREFIX       FILEFLD

  where  (                    Name Prefix != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - NAME-PREFIX
  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
--------------------------------------------------------------------------------
  NAME-SUFFIX       FILEFLD

  where  (                    Name Suffix != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - NAME-SUFFIX
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - LAST-NAME-EXP
                    - LAST-NAME-EXP
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  POSITION1         FILEFLD

  where  (                      Position1 != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - POSITION1
  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
--------------------------------------------------------------------------------
  POSITION2         FILEFLD

  where  (                      Position2 != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - POSITION2
  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
--------------------------------------------------------------------------------
  POSITION3         FILEFLD

  where  (                      Position3 != Spaces                         )


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

  where ((                  Prev Cntry Cd != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - PREV-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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  RATING            FILEFLD

  where  (                         Rating != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - RATING
  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
--------------------------------------------------------------------------------
  REFERENCES        OTOFLDS

  where  (           Relation: References 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
--------------------------------------------------------------------------------
  RELIGION          FILEFLD

  where  (                       Religion != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - RELIGION
  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
--------------------------------------------------------------------------------
  WK-RST-CODE1      FILEFLD

  where  (                   Wk Rst Code1 != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - WK-RST-CODE1
  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
--------------------------------------------------------------------------------
  WK-RST-CODE2      FILEFLD

  where  (                   Wk Rst Code2 != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - WK-RST-CODE2
  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
--------------------------------------------------------------------------------
  WK-RST-CODE3      FILEFLD

  where  (                   Wk Rst Code3 != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - WK-RST-CODE3
  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
--------------------------------------------------------------------------------
  WK-RST-CODE4      FILEFLD

  where  (                   Wk Rst Code4 != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - WK-RST-CODE4
  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