Enclosure30_143038ScopingDocument_ThirteenPointExample.pdf
PDF 250 KB Posted
- Attached to
- Appian Platform and Product Support
- Solicitation number
- 2031JW25R00004
About this file
This document is a Scoping Worksheet for a software development project (Work Item Number 143038) focused on enhancing a Business Administration Console's product type management functionality. The primary objective is to enable Business Administrators to add new product types to a dropdown menu, specify review stage timeframes, and collect predefined product properties and certification information.
Key features include: allowing administrators to manage product types with capabilities to add, edit, and inactivate product types; setting specific timeframes for review stages like EIC Upload, Supervisory Office Review, Lead Expert Review, and Address Feedback; ensuring inactivated product types remain visible on existing product reviews; and integrating with the development team for implementing custom logic in future releases. The project involves multiple technical components such as creating new database tasks, constants, interfaces, process models, and record type modifications for the SPRT application.
View the file
Other files
Show all 39
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Scoping Worksheet
Work Item Number 143038
Description Business Administrators would have the ability to add a new a new product type to the dropdown menu using a function from the Business Admin Console, as well as specify a timeframe for each review stage (EIC, SO, LE, Address Feedback). A pre-determined default set of product properties (initiation) and certification (QA) information would be collected for these product types. This would allow Mid-Size to introduce a new product type immediately and begin tracking/reporting on the review process. The new product type would also be available for selection in any dashboard and report filters. Mid-Size would then reach out to the Dev team to implement any custom logic for the product type in the next release
Acceptance Criteria - Verify that the Manage Product Types action is only available to Business Administrators.
- Verify that the Manage Product Types action provides the ability to add a new product type.
- Verify that the following is editable for an existing product type:
- Total Processing timeframe
- EIC Upload timeframe
- Supervisory Office Review timeframe
- Lead Expert Review timeframe
- Address Feedback timeframe
- Verify that the Manage Product Types action provides the ability to inactivate an existing product type.
- Verify that inactivated product types are still visible on existing product reviews for that product type. In process reviews for that product type should still be able to be processed.
Developer Application Name SPRT
Information for Related Defects/Stories/Tasks
Include any Stories, Defects, or Tasks that are related to this item that have an impact on its development.
Number Summary Notes
Database Tasks
Tasks related to this work item.
Task ID Description of Work
145740 Soft Delete functionality in T_ProductTypeTimeframe
145517 Ref Tables Creation
145546 Link Table Creation
Objects
Constants
New Constants
Name Description
CTS_ENTITY_PRODUCT_TYPE_TIMEFRAME Data store entity for CTS_T_ProductTypeTimeframe
CTS_INT_REF_REVIEW_STAGE_CREATED Created stage
CTS_INT_REF_REVIEW_STAGE_SUPERVISOR
Y_OFFICE_REVIEW
Supervisory office review stage
CTS_INT_REF_REVIEW_STAGE_LEAD_EXPER
T_REVIEW
Lead expert review stage
CTS_INT_REF_REVIEW_STAGE_ADDRESS_FE
EDBACK
Address feedback stage
CTS_ENUM_BA_MANAGE_PRODUCT_TYPES
_LABEL
Label for business admin console action Manage Product types
CTS_ENUM_BA_MANAGE_PRODUCT_TYPES
_VALUE
Value for business admin console action Manage Product types
CTS_ENTITY_R_PROCESSING_DUE_DATE_KI
CKOFF_TYPE
Data store entity for CTS_T_Ref_ProcessingDueDateKickoffType
Updated Constants
Name Description
Expression Rules
This section includes Query Entity rules.
New Rules
Name Description
CTS_RULE_General_getProductTypeWithCe rtification
Array of product types that have certification questions
CTS_RULE_MANAGE_PROD_getTimeframeV alue
Gets value of individual timeframe cells in Manage Product Types action’s grid
CTS_QRY_R_ProcessingDueDateKickoffType Query entity to get data from CTS_T_Ref_ProcessingDueDateKickoffType
CTS_RULE_MANAGE_PROD_productTypeTi meframeSave
Conditional list of saves to execute based on state of values in Manage Product Types action
CTS_QRY_getProductTypeTimeframe Query entity to get data from CTS_T_ProductTypeTimeframe
Updated Rules
Name Start Version End Version Description of Work
CTS_ENUM_BUSINESS_ADMI
N_ACTION_LABELS
3 6 Updated array to include cons!CTS_ENUM_BA_MANAGE_PRODUCT_TYPES_LABEL
CTS_QRY_getProductType 2 4 Updated query entities to allow for retrieval of all, including inactive, product types
CTS_ENUM_BUSINESS_ADMI
N_ACTION_VALUES
4 9 Updated array to include cons!CTS_ENUM_BA_MANAGE_PRODUCT_TYPES_VALUE
Folders
List new folders and the type of folder Name Description
Interfaces
New Interfaces
Name Description
CTS_FRM_MANAGE_PROD_manageProduct Types
Main form for Manage Product Types action
CTS_GDRW_MANAGE_PROD_manageProdu ctTypes
Grid rows for editable grid of active product types
CTS_SCT_MANAGE_PROD_addEditProductT ypes
Additional section that conditionally shows when a product type is to be added or edited
CTS_SCT_MANAGE_PROD_manageProductT ypes
Main section that populates action’s form
Updated Interfaces
Name Start Version End Version Description of Work
CTS_SCT_supervisoryProdRev iewDetails
76 79 Made adjustments to conditional display of fields for new product types created in the Manage Product Types action
Process models
New Process Models
Model Name Location / Notes
Manage Product Types Main model for Manage Product Types action
CTS_WRITE_ProductTypeTimeframe Write model for CTS_T_ProductTypeTimeframe
CTS_DEL_ProductTypeTimeframe Delete model for CTS_T_ProductTypeTimeframe; writes to T_ProductTypeTimeframe but only writes ID and RowDeleteXXX audit fields
Updated Process Models
Use a new grid for each process model. Add the node that is new or modified, and then a bullet-point description of the work done. Add before-and-after screenshots if necessary.
Process Model Name
Node (and Type) Description of Work
Business Administration Console Added workflow for Manage Product Types functionality
Node (and Type) Description of Work
CTS_WRITE_ProductType Added null check workflow to handle case in Manage Product Types workflow where no new product types are created in the Manage
Product Types action
Original and Updated Process Model Screenshots
Record Types
Name New/Mod Description
Supervisory Product Review Mod Edit certifications dashboard visibility to hide with new product types
Other Related Files
Use this section to document new or modified:
• Documents
• Groups
• Query Rules
• Reports
• Anything else that doesn’t fit other categories Name Type Description of Work
CTS_T_ProductTypeTimeframe CDT T_ProductTypeTimeframe CDT
CTS_DEL_ProductTypeTimeframe CDT T_ProductTypeTimeframe; fields ID, RowDeleteDate, RowDeleteUsername; used for deleting timeframes entries
CTS_T_Ref_ProductType CDT Modified; added ProcessDueDateKickoffTypeID and ProcessingDaysTotal
CTS_T_Ref_ProcessingDueDateKickoffType CDT T_Ref_ProcessingDueDateKickoffType
Deployment Instructions
Add any Deployment Instructions related to this work item. Please note the document in which these instructions are located.
File details come from the government source that posted it. Updated .