Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OSHA


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

       

   FILE - OSHA


  Condition         Type
--------------------------------------------------------------------------------
  BODY-PART         FILEFLD

  where ((                   Body Part Cd != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - BODY-PART
  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
--------------------------------------------------------------------------------
  COSTS             OTOFLDS

  where  (                Relation: Costs 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  DEATH             FILEFLD

  where  (                          Death  = "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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  ESTABLISH-DTL     OTOFLDS

  where  (        Relation: Establish Dtl 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
--------------------------------------------------------------------------------
  ESTABLISHMENT     FILEFLD

  where ((                  Establishment != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - ESTABLISH-DTL
                 - ESTABLISHMENT
  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
--------------------------------------------------------------------------------
  FIRST-AID-BY      FILEFLD

  where ((                   First Aid By != Zeroes                         ))


  Is Used In No Indexes
  Is Used In Rel - FIRST-AID-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
--------------------------------------------------------------------------------
  FOLLOWUP          OTOFLDS

  where  (            Relation: Follow Up 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
--------------------------------------------------------------------------------
  HOSPITAL          FILEFLD

  where ((                       Hospital != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - HOSPITAL
  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
--------------------------------------------------------------------------------
  ILLNESS           FILEFLD

  where  (                        Ill Inj  = "IL"                           )


  Is Used In No Indexes
  Is Used In Rel - ILLNESS
  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
--------------------------------------------------------------------------------
  ILLNESS-TYPE      FILEFLD

  where ((                        Illness != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - ILLNESS-TYPE
  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
--------------------------------------------------------------------------------
  INCIDENT          FILEFLD

  where ((                       Incident != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - INCIDENT
  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
--------------------------------------------------------------------------------
  INCIDENT-CAT      FILEFLD

  where ((                      Incid Cat != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - INCIDENT-CAT
  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
--------------------------------------------------------------------------------
  INCIDENT-OUTCM    FILEFLD

  where ((                        Outcome != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - INCIDENT-OUTCM
  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
--------------------------------------------------------------------------------
  INCIDENT-STAT     FILEFLD

  where ((                   Incid Status != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - INCIDENT-STAT
  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
--------------------------------------------------------------------------------
  INJURY            FILEFLD

  where  (                        Ill Inj  = "IN"                           )


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

  where ((                   Sharp Device != "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
--------------------------------------------------------------------------------
  NO-DEATH          FILEFLD

  where  (                          Death != "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
--------------------------------------------------------------------------------
  NOT-OSHA          FILEFLD

  where ((                      Osha 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-WORK-COMP     FILEFLD

  where ((                        Wc 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
--------------------------------------------------------------------------------
  OSHA              FILEFLD

  where ((                      Osha 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
--------------------------------------------------------------------------------
  PHYSICIAN         FILEFLD

  where  (                      Physician != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - PHYSICIAN
  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
--------------------------------------------------------------------------------
  PRIOR-INCIDENT    FILEFLD

  where  (                  Prior Seq Nbr != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - PRIOR-INCIDENT
  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
--------------------------------------------------------------------------------
  PRIVACY-CASE      FILEFLD

  where ((                      Osha 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  REPORT-BY         FILEFLD

  where ((                     Reports By != Zeroes                         ))


  Is Used In No Indexes
  Is Used In Rel - REPORT-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
--------------------------------------------------------------------------------
  REPORT-TO         FILEFLD

  where ((                     Reports To != Zeroes                         ))


  Is Used In No Indexes
  Is Used In Rel - REPORT-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
--------------------------------------------------------------------------------
  SEVERITY          FILEFLD

  where  (                       Severity != Spaces                         )


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

  where ((                 Supervisor Emp != Zeroes                         ))


  Is Used In No Indexes
  Is Used In Rel - SUPER-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
--------------------------------------------------------------------------------
  USER2             FILEFLD

  where  (                          User2 != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - USER2
  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
--------------------------------------------------------------------------------
  USER3             FILEFLD

  where  (                          User3 != Spaces                         )


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

  where ((                   Wit Cntry Cd != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - WIT-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
--------------------------------------------------------------------------------
  WITNESS           FILEFLD

  where ((                        Witness != Zeroes                         ))


  Is Used In No Indexes
  Is Used In Rel - WITNESS
  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-COMP         FILEFLD

  where ((                        Wc 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