Please enable JavaScript.

Coggle requires JavaScript to display documents.

Operator task (Task Entity (Task Entity Status (Overdue (wan't…

- - - - wan't finished in right time(according schedule)
      - Might be set for both non-finished and finished task entities
      - recalculated for active task entities
      - stored as status for finished
    - - close to become overdue
      - recalculated for active task entities
      - not stored and not used for finished task entities
    - - not stored and not used for finished task entities
  - - - amount of time/units/events/etc. left until task entity becomes overdue
      - Values
        
        NULL (for calendar or no schedule)
        
        negative (for already overdue task entities).
        
        0 - task was finished immediately after all planned interval was passed
      - dbo.OM_TaskHistory.DueResult
      - for schedules calculated from db
    - - for schedules calculated from db
      - amount of time/units/events/etc. done on top of planned by schedule interval
      - Stored in negated form
      - dbo.OM_TaskHistory.DueResult
      - Overdue time
        
        timestamp when task entity was firstly noticed as overdue
        
        OM_TaskHistory.DueUpdated
- - - - Enabled=0
      - Disabled=1
      - Deleted=255
  - - - NoSchedule=1
      - PlannedProdTime=2
      - RealProdTime=3
      - ProducedAmount=4
      - MachinePulsesNumber=5
      - Year=6
      - Month=7
      - Week=8
      - Day=9
      - TeamChange=10
      - OrderStart=11
      - OrderEnd=12
      - RealTime=14
    - - cannot be calculated without db data
      - All scehdules except :
        
        Calendar
        
        RealTime
        
        NoSchedule
    - - Fixed Schedule
        
        due result of previous task entity affects to next task entity
        
        overdue results from previous task entity are used as already done for next task entity
        
        result of Previous task dbo.OM_TaskHistory.StartAt
        
        dbo.OM_Task.IsIntervalFixed = 1
      - Non-fixed Schedule
        
        StartAt = 0
        
        dbo.OM_Task.IsIntervalFixed = 0
  - - - dbo.OM_TaskCalendar
      - check overdue for Task template with calendar schedule (Year, Month, Week, Day)
      - N
        
        One
        
        Many
    - - check overdue for *Task template with order schedule (OrderStart, OrderEnd)
      - N
        
        Zero
        
        One
        
        Many
      - dbo.OM_TaskArticles
    - - for non-calendar schedules
      - amount of time/units/events/etc
      - OM_Task.Interval
      - OM_TaskHistory.Interval
  - - - start time of whole task entity sequence
    - - specifies time of deactivating or deleting of task template
- - - - Task entities becomes hidden from UI
    - - specifies start time of whole task entity sequence
    - - specifies time of deactivating or deleting of task template
    - - create new Task
      - old task template and creating a copy of task template with all new changes applied
      - system task template with id=0 that is added already in deleted status
  - - - created automatically when task template is created
      - StartTime set from Task template StartTime
        
        for all subsequent tasks it is set with timestamp when task entity was created
    - - automatically either only after previous OM is finished
      - immediately after latest active QC is noticed as overdue
      - Some task template and schema parameters are copied to entity
      - EndTime field for any task entity is set with timestamp when task entity was finished
    - - every minute
      - updates DueResult and DueUpdated
      - util task overdue
        
        DueResult=0
        
        or Task entity finished
      - first time when overdue was noticed will be used as overdue time
- - - - upper and lower limits(for numerical)
      - dbo.OM_Subtask.ToleranceMin, dbo.OM_Subtask.ToleranceMax
      - In/out of tolerance
        
        not stored in db
        
        status for entities with numerical result
        
        recalculated each time when data are taken