psdi.app.safety

Interface SPWorkAssetSetRemote

    • Field Detail

      • SELECTHAZARD

        static final java.lang.String SELECTHAZARD
        Relationship to SafetyLexicon
        SafetyLexicon.tagoutid is null and SafetyLexicon.safetylexiconid not in ( select safetylexiconid from splexiconlink where spworkassetid= spworkasset.spworkassetid) and ( (SafetyLexicon.eqnum in ( select relatedequipment from sprelatedasset where (eqnum=spworkasset.workequipment or eqnum is null) and (location=spworkasset.worklocation or location is null) ) ) or (SafetyLexicon.location in ( select relatedlocation from sprelatedasset where (eqnum=spworkasset.workequipment or eqnum is null) and (location=spworkasset.worklocation or location is null) ) ) or ( ( (SafetyLexicon.eqnum=spworkasset.workequipment ) or (SafetyLexicon.location= spworkasset.worklocation ) ) and exists (select varvalue from maxvars where varname='SHOWWORKASSETHAZ' and varvalue=:YES) ) )
        The result set will contain zero or more objects.
        See Also:
        Constant Field Values
      • SAFETYPLAN

        static final java.lang.String SAFETYPLAN
        Relationship to SafetyPlan (safetyplan.safetyplanid = spworkasset.safetyplanid). The result set will contain one object.
        See Also:
        Constant Field Values
      • SPLEXICONLINK

        static final java.lang.String SPLEXICONLINK
        Relationship to SPLexiconLink (splexiconlink.spworkassetid = spworkasset.spworkassetid). The result set will contain zero or more objects.
        See Also:
        Constant Field Values
      • SPRELATEDASSET

        static final java.lang.String SPRELATEDASSET
        Relationship to SPRelatedAsset (sprelatedasset.eqnum = spworkasset.workequipment or sprelatedasset.location = spworkasset.worklocation). The result set will contain zero or one object.
        See Also:
        Constant Field Values