Tables and Views

Tables and Views

Name Purpose
W5435DS Data Sheet Header. Stores the current version of Data Sheets.
W5435DSAttribs Data Sheet Attributes. Stores the current version of Attributes.
W5435DSVars Data Sheet Variables. Stores the current version of Variables.
W5435LOV Stores Attribute ‘lookup values’
W5435DSRev Data Sheet Header Revision. Stores historical revisions of Data Sheets.
W5435DSAttribsRev Data Sheet Attributes Revision. Stores historical revisions of Attributes.
W5435DSVarsRev Data Sheet Variables Revision. Stores historical revisions of Variables.
W5435LOVRev Stores revisioned Attribute ‘lookup values’
W5435DR Data Record Header
W5435DRAttribs Data Record Attributes
W5435DRVars Data Record Variables
W5435DRHx Data Record Header – History
W5435DRAttribsHx Data Record Attributes – History
W5435DRVarsHx Data Record Attributes – History
wvDSHdr SQL View of all Data Sheet Headers
wvDSDetail SQL View of all Data Sheet Attributes and Variables
wvDRHdr SQL View of all Data Records (open and history)
wvDRDetail SQL View of all Data Record Attributes and Variables (open and history)