📊 Overview: 20 Fields 1 Indexes 10 One-to-Many Relations
🗨️ Master data table for employees and system users. Stores staff details, roles, permissions, and login credentials. Links to production activities, approvals, and audit trails.
Table ID: 42UUID: 34740841F2B0904CA92D155632F47E87Primary Key: 🔑 StaffIDGenerated: 🕐 2025-12-04T14:34:06Z Field Type Constraints Description Email String (255)🚫 Not Null - FirstName String (255)🚫 Not Null - LastName String (255)🚫 Not Null - PrintAs String (255)🚫 Not Null - FobID String (255)🚫 Not Null - AccountAD String (255)🚫 Not Null - SelfApprovalLimit Real🚫 Not Null - WorkRequestEmail String (255)- - Account4D String (255)🚫 Not Null - SharedAccount Boolean🚫 Not Null - Code String (255)🚫 Not Null - 🔑 StaffID Long Integer🔑 PK, ✨ Unique, ⚡ Auto, 🚫 Not Null - Stock Boolean🚫 Not Null - UserID String (255)🚫 Not Null - Archive Boolean🚫 Not Null - PO_Approval Boolean🚫 Not Null - Mobile String (255)🚫 Not Null - PasswordHash String (255)🚫 Not Null - PersonalEmail String (255)🚫 Not Null - MobileKeyfob String (255)- -
Field Type Kind Unique StaffIDKeywords regular ✨ Yes
Relation Name Source Table Source → Destination State Description StaffPermissionsSelectionStaffPermissions StaffID → StaffIDActive - DB_VariablesSelectionSettings StaffID → StaffIDActive - WorkRequestCommentsSelectionWorkRequestComments StaffID → StaffIDActive - RealTimeSensorExceptionsSelectionRealTimeSensorExceptions StaffID → StaffIDActive - ToolTemperatureTargetSelectionToolTemperatureTarget StaffID → StaffIDActive - PrintJobSelectionPrintJob StaffID → StaffIDActive - ShiftSummarySelectionShiftSummary StaffID → StaffIDActive - StatusUpdatedBoxLabelsSelectionBoxLabels StatusUpdatedStaffID → StaffIDActive - ToolNoticeSelectionToolNotice StaffID → StaffIDActive - DeactivatedToolNoticeSelectionToolNotice DeactivatedStaffID → StaffIDActive -
Staff - ORDA DataClass class for Staff tableStaffEntity - ORDA Entity class for Staff table Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:06Z