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 Call1 = 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, Empty1 = 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 |