Database Table "hyp_Relationship"

Table Description

The Relationship table which includes the Phone calls and Emails.

Normal Storage

Archive Storage

Deleted Storage(Recycle)
Field Name English Title Data Type Text Length Editor Attributes json
File Number Integer 0 Edit Hidden
Read Only
Key Field		 FileNumber
When FixDT 0 Edit Read Only
Key Field		 When
Who String 40 Edit Read Only Who
What
Values List:
0 = Phone Call
1 = Meeting
2 = Incoming EMail
3 = Outgoing EMail
4 = User Notes
5 = System Note
6 = Not Arrived to a Meeting (deceive)
7 = Chat App		 Status 0 Select Read Only What
Abstract String 800 Memo Abstract
PhoneCall Result
Values List:
0 = null, Empty
1 = No Answer
2 = Left a Message
3 = Short Conversation
4 = Long Conversation		 Status 0 Select PhonecallResult
Next Phone call On FixDT 0 SelectEdit NextPhoneCallOn
Next Phone call By String 40 PopupList NextPhoneCallBy
Department / Category String 40 Select DepartmentCategory
Contact Person String 105 PopupList ContactPerson
Meeting Key Real 0 Edit Hidden
Read Only		 MeetingKey
Basic File Name String 32 Edit Hidden
Read Only		 BasicFileName
Link to Document Type
Values List:
0 = null, Empty
1 = Service
2 = Opportunity		 Status 0 Select Hidden
Read Only		 LinkToDocumentType
Link to Document Key Real 0 Edit Hidden
Read Only		 LinkToDocumentKey
Jump to tables index

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

Database Table "hyp_Service Ticket"

Table Description

The service tickets primary table of Hyper.

Normal Storage

Archive Storage

Deleted Storage(Recycle)
Field Name English Title Data Type Text Length Editor Attributes json
Ticket Number Integer 0 Edit Read Only
Key Field		 TicketNumber
Ticket Status
Values List:
0 = New
1 = In process
2 = Closed		 Status 0 Select TicketStatus
Priority
Values List:
0 = Low
1 = Normal
2 = High		 Status 0 Select Priority
Entity Number Integer 0 Edit Read Only EntityNumber
Entity Full Name String 105 PopupList Mandatory EntityFullName
About Order No. Real 0 PopupList AboutOrderNo
About a Person String 40 PopupList Mandatory AboutAPerson
Ticket Source
Values List:
0 = Manually
1 = Public Website
2 = Service Website
3 = Software Process
4 = Withdraw Request		 Status 0 Select TicketSource
Subject Category String 80 Edit SubjectCategory
Subject / Complain Message / Request String 800 Memo Mandatory SubjectComplain
Complainer Name Name 60 SelectEdit ComplainerName
Return to Phone Phone 20 Edit ReturnToPhone
Return to Email String 80 Edit ReturnToEmail
Withdraw Amount Money 0 Edit WithdrawAmount
Withdraw Currency String 5 Select WithdrawCurrency
Created On FixDT 0 Edit Read Only CreatedOn
Created By String 40 Edit Read Only CreatedBy
Handling Responsibility
Values List:
0 = Everyone (all users)
1 = For Agency
2 = For Department
3 = For Specific User
4 = Allow Agency to help
5 = Allow Department to help		 Status 0 Select HandlingResponsibility
Agency Status 0 Select Agency
Department / Category String 40 Select DepartmentCategory
For User String 40 PopupList ForUser
Work Process String 30 Select Spare Field WorkProcess
Last Step String 50 Edit Read Only LastStep
Next Step String 50 Edit Read Only NextStep
Next Step Deadline FixDT 0 SelectEdit Read Only NextStepDeadline
Handling Deadline FixDT 0 SelectEdit HandlingDeadline
Complainer Feedback String 200 TextMemo ComplainerFeedback
Closed On FixDT 0 Edit Read Only ClosedOn
Closed By String 40 Edit Read Only ClosedBy
Pink Status
Values List:
0 = New
1 = Waiting for Service Manager
2 = Waiting for Service Order
3 = Waiting for Field Service Technician
4 = Waiting for the Complainer to send documents
5 = Completed with Full Customer's Satisfaction
6 = Completed by Compromise with the Customer
7 = Completed Against the will of the Customer
8 = Declined
9 = Cancelled by		 Status 0 Select Spare Field PinkStatus
Old Doc Reference String 20 Edit Read Only OldDocReference
Old Software Name String 10 Edit Read Only OldSoftwareName
Jump to tables index

Database Table "hyp_Audio Recordings"

Table Description

This table contains the details of the recorded phone calls. This table also includes received data from the PBX as well as the details of the details of the user that executed the call.

Normal Storage

Archive Storage

Deleted Storage(Recycle)
Field Name English Title Data Type Text Length Editor Attributes json
File Number Integer 0 Edit Hidden
Read Only
Key Field		 FileNumber
When FixDT 0 Edit Read Only
Key Field		 When
Who String 40 Edit Read Only Who
What
Values List:
0 = Outgoing Call
1 = Incoming Call
2 = User Uploaded Audio File
3 = Outgoing Call - No Answer
4 = Incoming Call - No Answer
5 = Outgoing Call - Missing File
6 = Incoming Call - Missing File
7 = Internal Call
8 = Internal Call - Missing File		 Status 0 Select Read Only What
Data Fields from PBX String 450 TextMemo Read Only DataFieldsFromPbx
Basic File Name String 50 Edit Hidden
Read Only		 BasicFileName
Record Length String 10 Edit Read Only RecordLength
Record Length in Seconds Integer 0 Edit Hidden
Read Only		 RecordLengthInSeconds
Phone Number Phone 20 Edit Read Only PhoneNumber
Key Notes String 120 Edit KeyNotes
DID Phone Number Phone 20 Edit Read Only DidPhoneNumber
Call back Status
Values List:
0 = null, Empty
1 = Need to call back
2 = No Answer - Keep trying
3 = No Answer - Discard
4 = Discard by director orders
5 = Called back and had a conversation		 Status 0 Select CallBackStatus
Jump to tables index

Database Table "hyp_Relationship Meetings Log"

Table Description

Documentation of appointment coordination with an entity (customer / vendor / project). Each change, in front of each user, will be recorded in a separate line in this table.

Normal Storage

All Data Stored Here

Archive Storage

If entity record was moved to archive.

Deleted Storage(Recycle)

If entity record was deleted.
Field Name English Title Data Type Text Length Editor Attributes json
File Number Integer 0 Edit Hidden
Read Only
Key Field		 FileNumber
Key Real 0 Edit Hidden
Read Only		 Key
For User String 40 Select ForUser
Subject String 120 SelectEdit Subject
Status
Values List:
0 = Tentative
1 = Confirmed
2 = Cancelled		 Status 0 Select Status
Starts FixDT 0 SelectEdit Read Only Starts
Ends FixDT 0 SelectEdit Read Only Ends
Location String 120 Edit Location
Attendees List String 120 Edit Read Only AttendeesList
Number of Participants Integer 0 Edit NumberOfParticipants
UniqueID String 140 Edit Read Only Uniqueid
Sequence Integer 0 Edit Read Only Sequence
Update Time FixDT 0 Edit Read Only UpdateTime
Updated By String 40 Edit Read Only UpdatedBy
Jump to tables index