Chapter 22: Generating and Viewing Reports in Report Center
Report Center Reference
AdminStudio 9.5 User Guide
ADS-0950-UG00
1739
IssueText
This stores the detail information about the issue.
IssueType
This is an integer value which stores the type of the issue. An issue can be of various
types as follows:
User Created Issues
•
1
—Issue is only shared between Service Company users.
•
2
—General type of issue for Customers.
•
3
—General type of issue for Servicers.
•
7
—When user responds to any issue, a new issue is created of this issue type.
•
8
—
Critical Issue
: This will block the Workflow progress and requires special
permission to create or close it.
System Generated Issues
There are also some system generated issues. They are as follows:
•
4
—When Update History step is completed in Workflow.
•
5
—When Data submitted is rejected by the Service Company user.
•
6
—When any Workflow Step is rolled back.
Status
This column stores the status of the issue as integer values , they are as follows:
•
0
—New Created Issue which are not read.
•
1
—Issue is already read.
•
2
—Issue is already responded.
•
3
—Issue is closed.
ApplicationID
This column stores the ID of the Application for which the issue is created. This ID can be
used as join in
AMS_Application
table which will give information about the Application
for the issue.
CreatedBy
This column stores the ID for the User who has created the issue. This ID is
AMS_Person
table primary key; hence this ID can be used as join in
AMS_Person
table to get more information about the user who created the issue.
CreateDate
This column stores the date and time (format: MM/DD/YYYY HH:MM:SS AM/PM) when
the issue was created.
ReadBy
This column stores the ID for the User who has read the issue last (most current). This ID
is
AMS_Person
table primary key; hence this ID can be used as join in
AMS_Person
table to get more information about the user who read the issue.
Table 22-53 •
AMS_Issues Table Column Information (cont.)
Column
Description
Summary of Contents for ADMINSTUDIO 9.5
Page 1: ...AdminStudio 9 5 User Guide Version 9 5...
Page 50: ...Contents 50 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 52: ...52 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 156: ...156 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 440: ...440 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1090: ...1090 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1426: ...1426 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1686: ...1686 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1794: ...Chapter 24 AdminStudio Public API Reference 1794 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1842: ...Index 1842 ADS 0950 UG00 AdminStudio 9 5 User Guide...