Chapter 22: Generating and Viewing Reports in Report CenterReport Center Reference1736 ADS-0950-UG00 AdminStudio 9.5 User GuideAMS_ApplicationItem TableThis table stores the information about each Data Group, Data Element, Workflow Phase and step that make anApplication Request. Information like who completed a Workflow Step, when was it completed, is the data hasbeen 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 theWorkflow of this Application Request. More Information about this Template canbe found from AMS_Templates table using this Template ID.ApplicationEndDate This column stores the actual Date and Time when this Application Request wascompleted.AppStatusID This column is a foreign key from AMS_ApplicationStatus table and reflectsthe status of the Application. Status of the Application can be Active or Inactiveby default and user can create additional statuses.Table 22-49 • AMS_ApplicationItem Table Column InformationColumn DescriptionApplicationItemID Primary key of this tableApplicationID This value in this column indicates the Application that this Item belongs to. Usercan 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 WorkflowStep (Minor). Value of 1 in this column indicates Workflow Phase and value of 2 inthis column indicates Workflow Step. In both the cases value in DataWFType willremain 2.DataWFType The value of 1 in this column indicates that this Application Item is either a DataGroup 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 theMajorMinorType 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 Groupor data Element.LastUpdateSubmit This column contains the Date & Time of when a Data Group or Data Element wassubmitted.Table 22-48 • AMS_Application Table Column Information (cont.)Column Description
