Database Table "hyp_Tasks"

Table Description

The task card of Hyper.

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name English Title Data Type Text Length Editor Attributes json
Created On FixDT 0 Edit Read Only
Key Field
CreatedOn
Created By String 40 Edit Read Only CreatedBy
Subject String 700 Memo Mandatory Subject
Starting At FixDT 0 SelectEdit StartingAt
Deadline FixDT 0 SelectEdit Deadline
Status
Values List:
0 = Not Started
1 = In Progress
2 = Completed
3 = Waiting on someone else
4 = Declined
Status 0 Select Status
Priority
Values List:
0 = Low
1 = Normal
2 = High
Status 0 Select Priority
For User String 40 PopupList ForUser
Agency Status 0 Select Agency
Department / Category String 40 Select DepartmentCategory
Public Task
Values List:
0 = No
1 = For Agency
2 = For Department
3 = Everyone (all users)
4 = Allow Agency to help
5 = Allow Department to help
Status 0 Select PublicTask
Feedback / Notes String 300 Memo FeedbackNotes
Entity Number Integer 0 Edit Read Only EntityNumber
Entity Full Name String 105 PopupList Mandatory EntityFullName
Read At FixDT 0 Select Read Only ReadAt
Last Update FixDT 0 Select Read Only LastUpdate
Lock for Changes Bool 0 Select Hidden
Read Only
LockForChanges
Show on Calendar Bool 0 Select Hidden
Read Only
ShowOnCalendar
Link to Document Type
Values List:
0 = null, Empty
1 = Service
2 = Opportunity
3 = Meeting
Status 0 Select Read Only LinkToDocumentType
Link to Document Key Real 0 Edit Read Only LinkToDocumentKey
Jump to tables index