AuditAssignment
Name Data Type Size Comments
A link between a Person and a Audit
Active boolean Whether or not the item is currently available for use
ActualTime decimal (18,2) The amount of time actually recorded (for e.g. in Retain) for this Audit
BudgetTime decimal (18,2) The amount of time budgeted for this Audit
BudgetToActual decimal (18,2) Difference between Budget Time and Actual Time
BudgetToPlanned decimal (18,2) Difference between Budget Time and Planned Time
PlannedTime decimal (18,2) The amount of time already planned (for e.g. in Retain) for this Audit
PlannedToActual decimal (18,2) Difference between Planned Time and Actual Time
TimeSheetLineCount int16 Count of child Time Sheet Lines
Audit Audit M:1 Link to parent Audit
OfflineCheckOut OfflineCheckOut 1:1 Link to child check out which contains who/when item was checked out
Person Person M:1 Link to parent Person
Role Role M:1 Link to parent role
TimeSheetLines TimeSheetLine 1:M Link to child Time Sheet lines