Functions and Views for All Products > apt_v_note
  
Version 10.0.01
apt_v_note
The apt_v_note view contains the history information of a ticket created on an object.
Table 21 apt_v_note
Column Name
Data Type
Description
domain_id
NUMBER
Foreign key to apt_v_domain
modified_user
STRING
User who modified the note
note_date
DATE
Date the note was created
note_type
STRING
If it is an Object note or a Ticket note
object_id
NUMBER
Object ID - Job id or tape media id, etc.
object_type
NUMBER
Whether the object is Job or tape media, etc.
owner_user
STRING
If note is ticket note then it is the owner of the ticket
ticket_status
STRING
If note is ticket note then it is the status of the ticket
user_note
STRING
Text of the note