RiskVision defines "views" in the underlying database tables in order to make references to certain objects, such as tickets, exception requests, and incidents, easier to specify in custom dashboards and reports.
Views are similar to tables in that tables have columns and rows, but views are references to more complicated relational tables in the database.
The following views are pre-defined:
aglrt_comments
| View Column Name | Data Type |
|---|---|
| comment_id | bigint(20) |
| associated_object_id | bigint(20) |
| Comment | text |
| Type | varchar(64) |
| Entered By | varchar(255) |
| EnteredOn | timestamp |
aglrt_attachments
| View Column Name | Data Type |
|---|---|
| attachment_id | bigint(20) |
| owning_object_id | bigint(20) |
| Caption | varchar(4000) |
| Description | varchar(4000) |
| Uploaded By | varchar(255) |
| Uploaded On | timestamp |
| Size | int(11) |
| Expires On | timestamp |
aglrt_exceptionrequestworkflow
| View Column Name | Data Type |
|---|---|
| exceptionrequest_id | bigint(20) |
| Stage Name | varchar(255) |
| Current | int(0) |
aglr_exception_request
| View Column Name | Data Type |
|---|---|
| exceptionrequest_id | bigint(20) |
| Compensatory Controls | bit(1) (1=include compensatory controls) |
| End Date | timestamp |
| Next Review | timestamp |
| Override Subcontrol Response Score | float |
| Reason for Exception | varchar(4000) |
| Start Date | timestamp |
| Start the Recurrence on | timestamp |
| Title | varchar(255) |
| and again at | timestamp |
aglrt_erworkflowowner
| View Column Name | Data Type |
|---|---|
| exceptionrequest_id | bigint(20) |
| Stage Name | varchar(255) |
| Owner | text (first + initial + last) |
aglrt_workflowhistory
| View Column Name | Data Type |
|---|---|
| payload_id | bigint(20) |
| Date | timestamp |
| Stage | varchar(255) |
| Action | varchar(255) |
| To Stage | varchar(255) |
| User | varchar(255) |
| Comment | varchar(4000) |
| target_user | varchar(4000) |
aglrt_changehistory
| View Column Name | Data Type |
|---|---|
| object_id | bigint(20) |
| Who | varchar(255) |
| When | timestamp |
| Change | text |
aglrt_ticketworkflow
| View Column Name | Data Type |
|---|---|
| ticket_id | bigint(20) |
| Stage Name | varchar(255) |
| Current | int(0) (stage name) |
aglr_ticket
| View Column Name | Data Type |
|---|---|
| ticket_id | bigint(20) |
| Category | varchar(255) |
| Description | text |
| Disposition | varchar(128) |
| End | timestamp |
| Exception Expiration Date | timestamp |
| Owner | varchar(255) |
| Planned End | timestamp |
| Planned Start | timestamp |
| Priority | varchar(32) |
| Progress | smallint(6) |
| Start | timestamp |
| Status | varchar(255) |
| Title | varchar(255) |
| Type | varchar(64) |
| Workflow | varchar(255) |
aglrt_ticketlinkedobjects
| View Column Name | Data Type |
|---|---|
| ticket_id | bigint(20) |
| object_id | bigint(20) |
| Type | varchar(128) |
| Name | varchar(255) |
| Owner | varchar(511) |
| Criticality | varchar(128) |
aglrt_ticketworkflowowner
| View Column Name | Data Type |
|---|---|
| ticket_id | bigint(20) |
| Stage Name | varchar(255) |
| Owner | text (first + initial + last) |
aglrt_workflowhistory
| View Column Name | Data Type |
|---|---|
| payload_id | bigint(20) |
| Date | timestamp |
| Stage | varchar(255) |
| Action | varchar(255) |
| To Stage | varchar(255) |
| User | varchar(255) |
| Comment | varchar(4000) |
| target_user | varchar(4000) |
aglr_incident_action
| View Column Name | Data Type |
|---|---|
| incidentaction_id | bigint(20) |
| Action Description | varchar(4000) |
| Action Summary | varchar(128) |
| Action Time | timestamp |
| Resolution | varchar(128) |
| Status | varchar(64) |
aglv_incidentowners
| View Column Name | Data Type |
|---|---|
| incident_id | bigint(20) |
| Stakeholder | text (first + initial + last) |
