Coflyr · Backend model field catalog
StaffMember
HumanResources.StaffMembers.
29 mapped fields6 field groupsGenerated 2026-10-06
Every mapped scalar field appears once. Types and nullability come from the current EF model snapshot. Navigation properties and unmapped DTO fields are outside this page. Purpose text is inferred from names and should be checked against the feature workflow.
Identity and naming
4 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Id | Guid | Required | Stable identifier for this record. |
| 2 | CurrentLicenseNumber | string | Nullable | Records current license number for this staff member. |
| 3 | FirstName | string | Required | Records first name for this staff member. |
| 4 | LastName | string | Required | Records last name for this staff member. |
Relationships and references
6 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | ApplicationUserId | Guid? | Nullable | Selects the related application user record. |
| 2 | LegacyDepartmentIdDB: DepartmentId | Guid? | Nullable | Selects the related legacy department record. |
| 3 | LegacyDesignationIdDB: DesignationId | Guid? | Nullable | Selects the related legacy designation record. |
| 4 | LegacyMainScopePlanningQualificationIdDB: MainScopePlanningQualificationId | Guid? | Nullable | Selects the related legacy main scope planning qualification record. |
| 5 | LegacyMainSkillPlanningQualificationIdDB: MainSkillPlanningQualificationId | Guid? | Nullable | Selects the related legacy main skill planning qualification record. |
| 6 | LegacyOwnerBusinessPartnerIdDB: OwnerBusinessPartnerId | Guid? | Nullable | Selects the related legacy owner business partner record. |
Status and controls
3 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | IsCertifyingStaff | bool | Required | Indicates whether certifying staff applies to this staff member. |
| 2 | IsExternalUser | bool | Required | Indicates whether external user applies to this staff member. |
| 3 | LegacyStaffStatusDB: StaffStatus | int | Required | Tracks the legacy staff status of this staff member. |
Amounts and measurements
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | ProductivityPercent | decimal | Required | Stores the productivity percent used by this staff member. |
Audit and revision
2 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | SystemAuditId | Guid? | Nullable | Links to system audit history when this model stores the reference. |
| 2 | UpdateId | Guid? | Nullable | Links to the preceding revision or update record. |
Other fields
13 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Email | string | Nullable | Records email for this staff member. |
| 2 | FacilityCode | string | Nullable | Records facility code for this staff member. |
| 3 | HomebaseCode | string | Nullable | Records homebase code for this staff member. |
| 4 | JobCode | string | Nullable | Records job code for this staff member. |
| 5 | JobTitle | string | Nullable | Records job title for this staff member. |
| 6 | MaintenanceLevel | int? | Nullable | Records maintenance level for this staff member. |
| 7 | MobilePhone | string | Nullable | Records mobile phone for this staff member. |
| 8 | ResourceType | string | Nullable | Records resource type for this staff member. |
| 9 | ShiftGroupCode | string | Nullable | Records shift group code for this staff member. |
| 10 | StationCode | string | Nullable | Records station code for this staff member. |
| 11 | UserSign | string | Required | Records user sign for this staff member. |
| 12 | WorkGroupCode | string | Nullable | Records work group code for this staff member. |
| 13 | WorkplaceCode | string | Nullable | Records workplace code for this staff member. |