Coflyr · Backend model field catalog
StaffTimeBooking
HumanResources.StaffTimeBookings.
47 mapped fields8 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
9 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Id | Guid | Required | Stable identifier for this record. |
| 2 | EventNumber | string | Nullable | Records event number for this staff time booking. |
| 3 | ProjectNumber | string | Nullable | Records project number for this staff time booking. |
| 4 | TaskName | string | Nullable | Records task name for this staff time booking. |
| 5 | TechnicalQueryNumber | string | Nullable | Records technical query number for this staff time booking. |
| 6 | Title | string | Nullable | Records title for this staff time booking. |
| 7 | ToolPartNumber | string | Nullable | Records tool part number for this staff time booking. |
| 8 | ToolSerialNumber | string | Nullable | Records tool serial number for this staff time booking. |
| 9 | WorkpackageNumber | string | Nullable | Records workpackage number for this staff time booking. |
Relationships and references
5 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | CorrectsBookingId | Guid? | Nullable | Selects the related corrects booking record. |
| 2 | StaffMemberId | Guid | Required | Selects the related staff member record. |
| 3 | TaskCardId | Guid? | Nullable | Selects the related task card record. |
| 4 | WorkStepId | Guid? | Nullable | Selects the related work step record. |
| 5 | WorkorderId | Guid? | Nullable | Selects the related workorder record. |
Status and controls
4 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | BookingStatus | string | Required | Tracks the booking status of this staff time booking. |
| 2 | IsCorrection | bool | Required | Indicates whether correction applies to this staff time booking. |
| 3 | IsLicenseLocked | bool | Required | Indicates whether license locked applies to this staff time booking. |
| 4 | IsLiveBooking | bool | Required | Indicates whether live booking applies to this staff time booking. |
Dates and timing
2 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | EndDateTime | DateTime? | Nullable | Records the end date time for this staff time booking. |
| 2 | StartDateTime | DateTime | Required | Records the start date time for this staff time booking. |
Amounts and measurements
4 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | DurationHours | decimal? | Nullable | Records duration hours for this staff time booking. |
| 2 | EstimatedHours | decimal? | Nullable | Records estimated hours for this staff time booking. |
| 3 | ProductiveHours | decimal? | Nullable | Records productive hours for this staff time booking. |
| 4 | ProductivityPercent | decimal | Required | Stores the productivity percent used by this staff time booking. |
Descriptions and details
2 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | BookingDescription | string | Nullable | Records booking description for this staff time booking. |
| 2 | CorrectionReason | string | Nullable | Records correction reason for this staff time booking. |
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
19 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | AircraftRegistration | string | Nullable | Records aircraft registration for this staff time booking. |
| 2 | BookingCode | string | Nullable | Records booking code for this staff time booking. |
| 3 | BookingKind | string | Required | Records booking kind for this staff time booking. |
| 4 | ClassificationCode | string | Nullable | Records classification code for this staff time booking. |
| 5 | EventType | string | Nullable | Records event type for this staff time booking. |
| 6 | FinancialEntityCode | string | Nullable | Records financial entity code for this staff time booking. |
| 7 | IndirectJobCode | string | Nullable | Records indirect job code for this staff time booking. |
| 8 | LastMutatedBy | string | Nullable | Records last mutated by for this staff time booking. |
| 9 | LastMutationAt | DateTime? | Nullable | Records the last mutation at for this staff time booking. |
| 10 | LockState | string | Required | Records lock state for this staff time booking. |
| 11 | ScopeCode | string | Nullable | Records scope code for this staff time booking. |
| 12 | ShiftGroupCode | string | Nullable | Records shift group code for this staff time booking. |
| 13 | ShiftShortCode | string | Nullable | Records shift short code for this staff time booking. |
| 14 | SkillCode | string | Nullable | Records skill code for this staff time booking. |
| 15 | StationCode | string | Nullable | Records station code for this staff time booking. |
| 16 | SubDocument | string | Nullable | Records sub document for this staff time booking. |
| 17 | SuspendedByIndirectJobCode | string | Nullable | Records suspended by indirect job code for this staff time booking. |
| 18 | TypeOfWork | string | Nullable | Records type of work for this staff time booking. |
| 19 | WorkplaceCode | string | Nullable | Records workplace code for this staff time booking. |