Chapter 22: Generating and Viewing Reports in Report Center
Report Center Reference
1736
ADS-0950-UG00
AdminStudio 9.5 User Guide
AMS_ApplicationItem Table
This table stores the information about each Data Group, Data Element, Workflow Phase and step that make an
Application Request. Information like who completed a Workflow Step, when was it completed, is the data has
been accepted by the Servicer, Total time spent on a step can be found in this table.
TemplateID
This column stores the Template ID of the Template that used to create the
Workflow of this Application Request. More Information about this Template can
be found from
AMS_Templates
table using this Template ID.
ApplicationEndDate
This column stores the actual Date and Time when this Application Request was
completed.
AppStatusID
This column is a foreign key from
AMS_ApplicationStatus
table and reflects
the status of the Application. Status of the Application can be Active or Inactive
by default and user can create additional statuses.
Table 22-49 •
AMS_ApplicationItem Table Column Information
Column
Description
ApplicationItemID
Primary key of this table
ApplicationID
This value in this column indicates the Application that this Item belongs to. User
can find further information about this application from
AMS_Application
table.
MajorMinorType
The value in this table indicates if the Item is a Workflow Phase (Major) or Workflow
Step (Minor). Value of 1 in this column indicates Workflow Phase and value of 2 in
this column indicates Workflow Step. In both the cases value in DataWFType will
remain 2.
DataWFType
The value of 1 in this column indicates that this Application Item is either a Data
Group or Data Element. If a value of 1 also exists in the MajorMinorType column,
then the Application Item is a Data Group. If a value of 2 exists in the
MajorMinorType column, then this Application Item is a Data Element.
CreateDate
This column indicates the Date and Time when this Application Item was created.
UpdatedBySubmit
This column contains the Person ID of the user who submitted a given Data Group
or data Element.
LastUpdateSubmit
This column contains the Date & Time of when a Data Group or Data Element was
submitted.
Table 22-48 •
AMS_Application 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...