{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Vendor Instructions","Validation","Requirements"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Vendor Instructions","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,1,2,3],[5,1,5,3]]}
[]
[1,"Vendor"]
[null,"Using the instructions below, please review and edit the information requested on the tabs listed below.\n\nGeneral Instructions\nOnly update fields highlighted in YELLOW. All light blue cells are calculated fields and should be locked."]
[]
[null,"Column","Edit","Comment"]
[null,"Requirements Sheet"]
[null,"Columns A and B – Section and Sub","N","Based on the entry in Column D, Columns A and B indicate the section and sub-section for the requirement in question."]
[null,"Column C – ID","N","Based on the entry in Column D, Column C indicates the ID number for the requirement in question."]
[null,"Column D – Requirements Description","N","Details the requirement for the respective RFP."]
[null,"Column F – Vendor Response","Y","Based on the entry in Column D, indicate your response for the requirement in question."]
[null,"Column G – Vendor Message","Y","Use this field for additional comments based on the entry in Column F."]
[null,"Column H – Unit Price","DO NOT FILL OUT THIS FIELD AS PART OF THE INITIAL RFP SUBMITTAL. ","Based on the entries in Columns F and G, indicate the unit price for the requirement in question."]
[null,"Column I – Unit Quantity","DO NOT FILL OUT THIS FIELD AS PART OF THE INITIAL RFP SUBMITTAL. ","Based on the entries in Columns F and G, indicate the number of units needed for the requirement in question."]
[null,"Column J – Total Additional Cost","DO NOT FILL OUT THIS FIELD AS PART OF THE INITIAL RFP SUBMITTAL. ","Based on the entries in Columns H and I, the total additional cost for the requirement in question is calculated."]
[null,"Column K – Vendor Clarification","DO NOT FILL OUT THIS FIELD AS PART OF THE INITIAL RFP SUBMITTAL. ","Use this field for additional comments based on the requirement and entries in Columns F - J."]

{"sheet":"Validation","index":1,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[]
["Validation",null,"How CIS interface is provided","Value",null,null,null,"Section",null,null,"GPA Weight",null,"Vendor Response"]
[null,null,null,null,null,null,null,"Common Features",null,null,"Critical",null,"Make Selection"]
["Yes","Yes","Client Resp",2,"Client Responsibility to perform",null,null,"Desktop Administration Control Panel",null,null,"Required",null,"Yes-STD, in prod today"]
["No","No","Custom",3,"Custom Developed by vendor, fee charged",null,null,"Mobility",null,null,"Valued",null,"Yes-STD, in prod by 1/1/18"]
[null,null,"Not Required",1,"Not Required",null,null,"Integration",null,null,"Desired",null,"Optional, Req Premium Prod"]
[null,null,"Standard",4,"Standard",null,null,null,null,null,null,null,"Optional thru 3rd party"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Optional, Req Custom"]
["Timing",null,null,null,null,null,null,null,null,null,null,null,"No-but planned in future"]
[null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
["Annual",null,"Interfaces",null,null,null,null,null,null,null,null,null,"No-Not Planned in the future"]
["As Needed",null,null,null,null,"Must_Enter",null,null,null,null,"Responsibility"]
["Semi-Monthly",null,null,null,"Enter","Must_Enter",null,null,null,null,"Mine"]
["Daily",null,"DB Link",10,{"$f":"C14","v":"DB Link"},"Interface_Options",null,null,null,null,"Others"]
["Nightly",null,"EAI",16,{"$f":"C15","v":"EAI"},"Interface_Options",null,null,null,null,"Joint"]
["Monthly",null,"Integrated",20,"Integrated","Interface_Options"]
["Quarterly",null,"Out of Scope",0,"Out of Scope","Interface_Options"]
["Real Time",null,"Point To Point",1,"Point To Point","Interface_Options",null,null,null,null,"Evaluation"]
["Unknown",null,"Staging Table",6,"Staging Table","Interface_Options",null,null,null,null,"Yes"]
["Weekly",null,"XML",12,"XML","Interface_Options",null,null,null,null,"Yes With Changes"]
[null,null,"Enter",null,"N/A","N/A",null,null,null,null,"Not Needed"]
[null,null,null,null,null,null,null,null,null,null,"New"]
[null,null,null,"Allocate Method"]
[null,null,null,"Perc","Percent"]
[null,null,null,"Dol","Dollars"]
[]
[null,null,"Interface Direction"]
[null,null,"Input"]
[null,null,"Output"]
[null,null,"Both"]
[]
[null,null,"Interface Category"]
[null,null,"Auto"]
[null,null,"Future"]
[null,null,"Manual"]
[null,null,"N/A"]

{"sheet":"Requirements","index":2,"n_rows":421,"n_cols":7,"rows_kept":421,"cut":false,"hidden":false,"merged":[[0,7,0,8]]}
[]
["Section","Sub","ID","Requirement Description","Weight","Vendor Response","Vendor Message"]
["Common Features","User Interface","1.1.1","The system must be certified for use on Windows 7 ","Critical  ","Make Selection"]
["Common Features","User Interface","1.1.2","The system must support concurrent display of multiple windows and simple switching between these windows ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.3","The system must support the ability to scroll through data lists ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.4","The system must support common keystrokes for cutting, copying and pasting ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.5","The system must support drag and drop ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.6","The system must support the ability to use context sensitive / smart picklists to achieve consistent data input ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.7","The system must support the ability to cancel an operation and return to the previous screen ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.8","The system must support use of popup windows or similar for access to reference information ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.9","The system must use a separate popup window for any displayed documents ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.10","The system must provide mouseovers for help on screen items ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.11","The system must support full use of the mouse, including right click menus ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.12","The system must enable authorized users to define the positioning of fields in screen layouts and determine whether or not any user defined fields should be included ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.13","The system must enable the authorized users to modify existing field names on screen ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.14","The system must support the use of default file locations for functions such as import and save, based on individual user preferences ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.15","The system must ensure that printing is accomplished via the standard environment printer settings ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.16","Printer friendly pages must be available (i.e. Pages without menu options and cut down header and footer) ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.17","Mobile Device must have a Screensize must be at least 4 inches diagonal","Critical","Make Selection"]
["Common Features","User Interface","1.1.18","All applications of the system should provide online help that is, help via the client application, or the default operating system help capability (eg Windows help) ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.19","The system must automatically update all clients with the latest help file ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.20","The Help function of every application in the proposed solution must provide an overview of application functionality that serves as an introduction and a reference ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.21","The Help function of every application in the proposed solution must provide A wildcard text search ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.22","The Help function of every application in the proposed solution must provide Boolean characters search capabilities ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.23","The Help function of every application in the proposed solution must provide A back button that enables the user to return to previous help documents ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.24","The Help function of every application in the proposed solution must provide Hyperlinks between all related documents ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.25","The Help function of every application in the proposed solution must provideA table of contents that enables the user to view and use the structure of the help files ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.26","The Help function of every application in the proposed solution must provide A search by keywords feature that finds all files with the keywords ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.27","The Help function of every application in the proposed solution must provide Examples of the process for which the user is seeking assistance ","Valued","Make Selection"]
["Common Features","User Interface","1.1.28","The system must require a username and password for users to logon ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.29","The system must restrict external access to designated workstations using the following methods: Passwords sent over the network or internet must be encrypted ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.30","The system must restrict external access to designated workstations using the following methods: Each transaction undertaken in the client application must be supported with encryption commensurate with the nature of the transaction ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.31","The system must provide the following rules for logging out of the system: A user must be able to explicitly logout ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.32","The user must be automatically logged out of system when the client application is closed ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.33","The system must provide the following rules for logging out of the system: Logging out must occur after a predefined timeout ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.34","The system must provide the following rules for logging out of the system:The maximum number of records that a user group can retrieve in a search query from the database ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.35","The system must provide the following rules for logging out of the system:The maximum amount of time that the client can spend retrieving records from the database ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.36","The system must provide the following rules for logging out of the system:The fields/records returned by the search query ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.37","The system must provide the following rules for logging out of the system:The display parameters for a search query selection ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.38","The system must provide the following rules for logging out of the system:The ability to define a subset of fields for a summary report ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.39","The administrator must have the ability to configure the following functionality for users: Create, edit and delete user groups such as departments ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.40","The administrator must have the ability to configure the following functionality for users: Include groups of search queries as a menu option ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.41","The administrator must have the ability to configure the following functionality for users: Group queries into user defined areas (eg areas, business group, department) ","Required","Make Selection"]
["Common Features","User Interface","1.1.42","The administrator must have the ability to configure the following functionality for users: Customize the menus visible to each user via a GUI interface according to user, group or role information ","Required ","Make Selection"]
["Common Features","User Interface","1.1.43","The administrator must have the ability to configure the following functionality for users: Define which buttons are available to each user base on assigned user group ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.44","The administrator must have the ability to configure the following functionality for users:  Create, save and restore specific colour palettes for each user ","Valued ","Make Selection"]
["Common Features","User Interface","1.1.45","The administrator must have the ability to configure the following functionality for users:  Add icons to the toolbar for existing menu functions ","Valued ","Make Selection"]
["Common Features","User Interface","1.1.46","The administrator must have the ability to configure the following functionality for users: Define shortcuts for existing menu items ","Critical ","Make Selection"]
["Common Features","User Interface","1.1.47","The administrator must have the ability to configure the following functionality for users: Develop standard report templates ","Required ","Make Selection"]
["Common Features","Data Management","1.2.1","When entering data, the system must support rule checking and real time validation including display of field descriptions for confirmation or appropriate error / warning message where invalid ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.2","The system must have the ability to date and time stamp all data entry ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.3","The system must support simultaneous data entry by multiple users ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.4","The system must be able to put a process on 'hold' letting the user carry out an enquiry, then return to the original transaction ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.5","The system must provide batch and real time processing when appropriate ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.6","The database must possess version control of all committed data to facilitate rollback/rollforward ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.7","The system must carry out validation of data on individual fields and field dependencies ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.8","The system must provide user defined export of transactions/records to other software systems ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.9","The system must support retrospective changes to data (e.g. for a previous period) subject to strict security ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.10","The system must handle multiuser file access for reporting ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.11","All modules of the system must access a common database ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.12","The system must be able to prevent simultaneous update of the same record (i.e. record locking) ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.13","The system must display appropriate error messages when external data sources are unavailable ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.14","The system must disable functionality that is dependent on external data when the data is unavailable","Critical ","Make Selection"]
["Common Features","Data Management","1.2.15"," If any external data source systems becomes unavailable, the system must store transactions and logs in a temporary data file and process them when the system becomes available ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.16","The system must notify the user when the external data becomes available ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.17","The system must notify the user when all stored data transactions have been processed ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.18","The system must notify the user/system administrator of any incomplete transactions ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.19","The system needs to have an effective archiving tool plus ability to access archived data ","Valued","Make Selection"]
["Common Features","Data Management","1.2.20","The system must have the ability to create output files for archival purposes on a periodic basis, for example, monthly, and retrieve them easily ","Valued","Make Selection"]
["Common Features","Data Management","1.2.21","Where possible, the system must ensure invalid data is not accepted at time of field entry (i.e. validation at field entry not end of input screen) ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.22","Validation of data entry should be capable of being customised to meet the organization's data entry standards ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.23","The system must log all error messages in a log file, including: Type","Critical ","Make Selection"]
["Common Features","Data Management","1.2.24","The system must log all error messages in a log file, including: Date","Critical ","Make Selection"]
["Common Features","Data Management","1.2.25","The system must log all error messages in a log file, including: User","Critical ","Make Selection"]
["Common Features","Data Management","1.2.26","The system must log all error messages in a log file, including: Terminal ID / Name","Critical ","Make Selection"]
["Common Features","Data Management","1.2.27","The error log file must be available for viewing and printing ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.28","The system must provide meaningful error messages which facilitate the user to identify (generally via error number) and rectify errors or communicate errors to support staff ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.29","The system must be able to recover itself from a failed or interrupted system process, without loss of data or integrity ","Critical","Make Selection"]
["Common Features","Data Management","1.2.30","Where appropriate, the system must allow a user to retry the failed operation ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.31","The system must be able to resend aborted or incomplete transactions ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.32","The system must allow the setup and control of: Users","Critical ","Make Selection"]
["Common Features","Data Management","1.2.33","The system must allow the setup and control of: Groups of users","Critical ","Make Selection"]
["Common Features","Data Management","1.2.34","The system must allow the setup and control of: Roles","Critical ","Make Selection"]
["Common Features","Data Management","1.2.35","The system must ensure that user control is centralised and applied to all of its components i.e. the administrator should not have to create separate users for each of the system's components ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.36","The system must allow the Administrator to add, make inactive and reactivate users, user groups and departments ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.37","The system must allow a system administrator to perform the following tasks with respect to system users:  Create new users on the system ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.38","The system must allow a system administrator to perform the following tasks with respect to system users:  Assign access privileges to particular tables ","Valued","Make Selection"]
["Common Features","Data Management","1.2.39","The system must allow a system administrator to perform the following tasks with respect to system users:  Assign access privileges to particular search queries and reports ","Valued","Make Selection"]
["Common Features","Data Management","1.2.40","The system must allow a system administrator to perform the following tasks with respect to system users: Assign user privileges for all functions i.e. access, read, update, delete ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.41","The system must allow a system administrator to perform the following tasks with respect to system users: Assign user privileges for specific data within datasets i.e.. access, read, update, delete ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.42","The system must ensure that a user's access privilege also controls data accessible by screens, reports and report writers, not just online access ","Valued","Make Selection"]
["Common Features","Data Management","1.2.43","The systems must provide the following functions for maintenance of User Groups: Security setup by user group/ templates (to minimize maintenance) ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.44","The systems must provide the following functions for maintenance of User Groups:  Security setup by user, allocating to specific user group/ template ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.45","The system should provide the following user related reports:  Users by user group ","Required ","Make Selection"]
["Common Features","Data Management","1.2.46","The system should provide the following user related reports: Users by system function ","Required ","Make Selection"]
["Common Features","Data Management","1.2.47","The system should provide the following user related reports: Users by department ","Required ","Make Selection"]
["Common Features","Data Management","1.2.48","The system should provide the following user related reports: Users by security classification ","Required ","Make Selection"]
["Common Features","Data Management","1.2.49","The system should provide the following user related reports: User groups by system function ","Required","Make Selection"]
["Common Features","Data Management","1.2.50","The system should provide the following user related reports: User groups by department ","Required ","Make Selection"]
["Common Features","Data Management","1.2.51","The system should provide the following user related reports: User groups by security classification ","Required ","Make Selection"]
["Common Features","Data Management","1.2.52","The system should provide the following user related reports:  System functions by user ","Required","Make Selection"]
["Common Features","Data Management","1.2.53","The system should provide the following user related reports: System functions by user group ","Required","Make Selection"]
["Common Features","Data Management","1.2.54","The system should provide the following user related reports:  User by status (active/inactive) ","Required","Make Selection"]
["Common Features","Data Management","1.2.55","The system must ensure that it is not possible to circumvent security restrictions simply by accessing the database directly. ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.56","The system must ensure that there is automatic consistency between application security controls and database security controls ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.57","The system must require password entry for the browserbased client, where applicable ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.58","The system must ensure that users can only access the data to which they have assigned rights, including data in reports and search queries ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.59","The system must allow the system administrator to monitor and control mobile application usage. ","Required ","Make Selection"]
["Common Features","Data Management","1.2.60","The system must provide the following security controls:  Setup and modification of security components by the System Administrator. ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.61","The system must provide the following security controls:  Define the level of security and privileges for different types of external users (eg internet customers) ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.62","The system must identify each user as they logon ","Valued ","Make Selection"]
["Common Features","Data Management","1.2.63","The system must log security violations (i.e. unsuccessful logons) by showing date, time, terminal ID, user ID and password attempted. ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.64","The system must provide the following password security functions:  Encrypted password storage ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.65","The system must provide the following password security functions: Provide the user with the ability to change their password ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.66","The solution must ensure that any system upgrade is seamless to the end user ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.67","A system upgrade must be performed with no requirement for staff to physically visit the end user's PC / mobile device ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.68","The system must display to the user the current version information","Required","Make Selection"]
["Common Features","Data Management","1.2.69","System upgrades must not adversely affect existing functionality ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.70","The vendor must fully support the current and two previous releases of all components which are part of the system, or up to 5 years old, whichever is greater ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.71","Software upgrades must be backward compatible with previous versions of the software and data ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.72","The system must upgrade mobile devices when docked into the network ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.73","The system must provide an audit trail of all transaction additions, changes and deletions showing date, time, user id and network address e.g. IP address ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.74","The system must have the ability to display audit trails / Inquiries.","Critical ","Make Selection"]
["Common Features","Data Management","1.2.75","The system must create an audit trail (including the operator and time) of all changes to the security settings ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.76","The system should provide audit trails searchable by specified user or specified function ","Valued ","Make Selection"]
["Common Features","Data Management","1.2.77"," Data validation tools must allow for data validation upon entry ","Valued ","Make Selection"]
["Common Features","Data Management","1.2.78","The system must be able to time, date and user stamp all events involving users","Required ","Make Selection"]
["Common Features","Data Management","1.2.79","The administrator must be able to edit prompts and warnings associated with data edit, and also whether these prompts and warnings actually appear to the user ","Required ","Make Selection"]
["Common Features","Data Management","1.2.80","The system must have the ability to check current logins to the Application Server ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.81","The system must have the ability to terminate user sessions ","Valued","Make Selection"]
["Common Features","Data Management","1.2.82","The system must provide search queries and reports to enable the Administrator to view: # Number of users using the system ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.83","The system must provide search queries and reports to enable the Administrator to view: # Highest concurrent usage ","Valued","Make Selection"]
["Common Features","Data Management","1.2.84","The system must provide search queries and reports to enable the Administrator to view: # Number of users licensed ","Valued","Make Selection"]
["Common Features","Data Management","1.2.85","The system administrator must have the ability to create new webpages / forms to support user Inquiries, via wizards and templates ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.86","The system must provide a well structured configuration toolset with access to a comprehensive command set ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.87","The system must provide for user configuration and the ability to facilitate and automate work flow processes, including: Modification of templates ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.88","The creation and modification of reports ","Valued","Make Selection"]
["Common Features","Data Management","1.2.89","The system must provide standard configuration capabilities to create / modify: Dialogue objects ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.90","The system must provide standard configuration capabilities to create / modify: Menu objects ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.91","The system must provide standard configuration capabilities to create / modify: Button objects ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.92","The system must provide standard configuration capabilities to create / modify: Window objects ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.93","The system must provide standard configuration capabilities to create / modify: Mathematical functions ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.94","The system must provide standard configuration capabilities to create / modify: Logical functions ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.95","Time functions ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.96","The system must provide standard configuration capabilities to create / modify: Database functions ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.97","The system must provide standard configuration capabilities to create / modify:  File functions (export, save, open, import) ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.98","The system must provide standard configuration capabilities to create / modify: Printing functions ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.99","The system must have the ability to import data from various sources","Critical ","Make Selection"]
["Common Features","Data Management","1.2.100","The system must provide a scheduling tool for scheduling imports and exports","Critical ","Make Selection"]
["Common Features","Data Management","1.2.101","The system must produce an import/export log displaying any errors ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.102"," Data must be able to be extracted from the system via the following means:  As an ODBC and JDBC view of a user specified query ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.103"," Data must be able to be extracted from the system via the following means: Using Crystal reports to view and save information ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.104"," Data must be able to be extracted from the system via the following means: As CSV, Excel format ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.105"," Data must be able to be extracted from the system via the following means: As XML with the associated DTD and XSL files ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.106"," Data must be able to be extracted from the system via the following means: Microsoft SQL Server ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.107","The system must allow the user to specify work order attachments.","Required","Make Selection"]
["Common Features","Data Management","1.2.108","The system must allow data imported from other modules or software, to pass through the same validations as records input directly ","Valued","Make Selection"]
["Common Features","Data Management","1.2.109","The system must provide the functionality to perform batch imports ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.110","The system must allow a user to query data that has been imported and delete those records","Critical ","Make Selection"]
["Common Features","Data Management","1.2.111","Data must be able to be imported from a previous system by either direct load or via a specified format in commonly used platform, i.e.: CSV, XML, MS Access or Excel ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.112","The system must allow a user to specify input rules for each field imported ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.113","The system must provide for import of transactions/database records (data files) from other sources, and be subject to normal validation/edit processes ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.114","The system must allow for import of all data from spreadsheets, databases and other applications ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.115","The system must allow for import of data from the following file formats: CSV","Critical ","Make Selection"]
["Common Features","Data Management","1.2.116","The system must allow for import of data from the following file formats:  XML using DTD and XSL ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.117","The system must allow for import of data from the following file formats: MS SQL","Critical ","Make Selection"]
["Common Features","Data Management","1.2.118","The system must allow the user to specify the source and description of the data export ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.119","The system must allow for export of all data to csv, fixedwidth, xml or SQL Server","Critical ","Make Selection"]
["Common Features","Data Management","1.2.120","The system must be able to integrate with MS SQL Server and Oracle ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.121","All applications of the proposed solution must be Open Database Connectivity compliant (ODBC) ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.122","The system must be able to integrate with the following Office applications: MS Excel ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.123","The system must be able to integrate with the following Office applications: Crystal Reports ","Critical ","Make Selection"]
["Common Features","Data Management","1.2.124","The system must allow other [corporate systems] to extract information from it for presentation in the other corporate system, subject to a users permission ","Valued","Make Selection"]
["Common Features","Data Management","1.2.125","Timesheets for calendar and scheduling ","Valued","Make Selection"]
["Common Features","Workflow","1.3.1","The system must be able to attach the relevant workflow to an individual user or group of users (eg. multiple leave application workflows with differing approval paths) ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.2","The system must possess full workflow functionality between and within all modules ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.3","The system must provide workflow that is user tailorable ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.4","The system must allow each workflow process to consist of multiple actions ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.5","The system must allow multiple workflow processes to be configured ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.6","The system must cater for events and tasks that 'stop and start' the clock, where appropriate ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.7","The system must allow the administrator to define which fields in each workflow action can be editable (e.g. Action Performed and Date Performed are editable, but no notes can be added to the action) ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.8","The system must allow the administrator to configure the following action dropdown lists for users to select the next action in the workflow process: List of the next user / group to whom the action is to be sent ","Valued","Make Selection"]
["Common Features","Workflow","1.3.9","The system must allow the administrator to configure the following action dropdown lists for users to select the next action in the workflow process: List of the timeframe in which the next user / group should respond ","Valued","Make Selection"]
["Common Features","Workflow","1.3.10","The system must allow authorized users to see the progress of any object (e.g. work order completed) through a workflow ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.11","The system must allow the administrator to delegate:  All of a user's responsibilities to another user (including associated workflows) ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.12","The system must allow the administrator to delegate:  Work, crews, complex work and to distribute work amongst the crew members","Critical ","Make Selection"]
["Common Features","Workflow","1.3.13","The system must allow the administrator to specify a delegation end date ","Valued ","Make Selection"]
["Common Features","Workflow","1.3.14","The system must allow the administrator to modify an existing delegation ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.15","The system must present a list to the user / group of all current actions that need to be performed ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.16","The system must ensure that users are alerted to new tasks being allocated to them within the application itself ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.17","The system must receive visual and audible alerts for new tasks being allocated to them","Critical ","Make Selection"]
["Common Features","Workflow","1.3.18","The system must present the user with a popup when a new workflow action is assigned to them ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.19","The system must present a simple form to the user with the actions they need to perform with respect to a particular workflow ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.20","The system must allow the user to route the next workflow action using administrator defined dropdown lists ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.21","The system must allow the user to route the next workflow action using administrator defined dropdown lists ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.22","The system must allow the administrator to be able to define the workflow route for every outcome from an action (eg. if rejected, action is escalated to immediate supervisor) ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.23","The user must be able to initiate the workflow manually through both the desktop application and mobile device ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.24","The system must be able to automatically initiate the workflow as a result of user defined criteria being met (e.g. Alert user that work order has not been completed within allotted timeframe) ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.25","The users in the workflow process (and other users) that a notification of final approval is to be sent to, where applicable ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.26","The user or group of users allocated to and responsible for the action ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.27","The system must allow the following to be configured for each task or action in the workflow: When the action must be completed ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.28","The maximum duration of an action, after which escalation will occur ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.29","The actions that the user or group of users are permitted to perform, including: Reallocate/delegate ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.30","The actions that the user or group of users are permitted to perform, including: Hold","Critical ","Make Selection"]
["Common Features","Workflow","1.3.31","The actions that the user or group of users are permitted to perform, including: Approve","Critical ","Make Selection"]
["Common Features","Workflow","1.3.32","The actions that the user or group of users are permitted to perform, including: Reject","Critical ","Make Selection"]
["Common Features","Workflow","1.3.33","The actions that the user or group of users are permitted to perform, including: Escalate","Critical ","Make Selection"]
["Common Features","Workflow","1.3.34","The actions that the user or group of users are permitted to perform, including:  Whether the user or groups of users can add notes to the action taken ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.35","The actions that the user or group of users are permitted to perform, including:  The fields which will determine the next action to be taken in the workflow ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.36","The system must allow the configuration of escalations for all actions ","Valued","Make Selection"]
["Common Features","Workflow","1.3.37","The system must provide multiple levels of escalation for each defined action ","Valued","Make Selection"]
["Common Features","Workflow","1.3.38","The system must provide a graphical based tool to establish and modify workflow processes within system ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.39","The system must have a simple interface for the presentation of workflow actions to authorized users ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.40","The system must present the following to the user / group who needs to perform a workflow action: When the action must be completed ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.41","The previous workflow actions performed (subject to security), including who performed it and when it was performed ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.42","The system must present the user with the following filters on the workflow actions they need to perform: All outstanding actions ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.43","The system must present the user with the following filters on the workflow actions they need to perform: All actions submitted ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.44","The system must present the user with the following filters on the workflow actions they need to perform: All previous actions taken within a userdefined timeframe ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.45","The system must allow the user to sort all actions by: Date received ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.46","The system must allow the user to sort all actions by: Date due ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.47","The system must allow the user to sort all actions by: Originator ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.48","The system must allow the user to sort all actions by: Department (if applicable) ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.49","The system must allow the user to sort all actions by: Action type ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.50","The system must provide the following reports:  Number of workflow events ","Critical ","Make Selection"]
["Common Features","Workflow","1.3.51","The system must provide the following reports:  Description of current rules ","Valued","Make Selection"]
["Common Features","Workflow","1.3.52","The system must provide the following reports: Number of workflow events 'on hold' ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.1","The system must possess its own report writer ","Valued","Make Selection"]
["Common Features","Reports and Inquiries","1.4.2","The system must be able to be fit for use by Crystal Reports ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.3","The system must provide all of the functionality in this section for thin and thick clients ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.4","The system must be able to email relevant standard reports to nominated officers on a specified date ","Valued","Make Selection"]
["Common Features","Reports and Inquiries","1.4.5","The system must be able to store reports for future use ","Valued","Make Selection"]
["Common Features","Reports and Inquiries","1.4.6","The system must output reports in the following formats: PDF","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.7","The system must output reports in the following formats: MS Word","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.8","The system must output reports in the following formats: MS Excel","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.9","The system must output reports in the following formats:Text","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.10","Tool must be able to access all data in all modules, subject to security ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.11","The system must allow report specifications to be saved and copied ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.12","The system must perform mathematical and Boolean operations to derive additional information in reports ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.13","Where appropriate, the system must be able to present reports in a tabular format ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.14","The system must possess the following for all reports: To From date filters ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.15","The system must possess the following for all reports: Ascending sort for all report fields in the table ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.16","The system must possess the following for all reports: Descending sort for all report fields in the table ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.17","The system must allow authorized users to filter all applicable fields in new report ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.18","The system must allow authorized users to select which fields they require in a new report ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.19","The system must allow new reports to be sent to other users ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.20","The system must provide the user with a list of all reports to which the user has authorization ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.21","The system must enable reports to be personalised based upon the authorisation or security profile of the user who runs the report. ","Required ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.22","The system must provide drill down or around capabilities to navigate from summary statistics to specific details ","Valued","Make Selection"]
["Common Features","Reports and Inquiries","1.4.23","The system must provide search facilities with alpha/ numeric search on key fields ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.24","The system must provide wildcard and Boolean search capabilities ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.25","The system must enable the generation of adhoc queries or specially customised queries on any field or combination of fields in the database. ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.26","The system must have the facility for printing the output of any online enquiry without regenerating. ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.27","The system must limit users' access to those transactions/ records permitted by their security profile. ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.28","The system must enable standard Inquiries to be stored and made available to users. ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.29","The system must have the option to show summary Inquiries only i.e. totals and record counts without detail. ","Valued","Make Selection"]
["Common Features","Reports and Inquiries","1.4.30","The system must be able to query by key word search ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.31","The system must provide for user definable screen Inquiries ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.32","The fields/records returned by the query ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.33","The display parameters for a query selection ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.34","The administrator must be able to control the results of a predefined query executed by a user in the following ways: ","Critical ","Make Selection"]
["Common Features","Reports and Inquiries","1.4.35","The ability to insert a hyperlink field in the summary report that provides full record information ","Critical ","Make Selection"]
["Common Features","Documentation","1.5.1","The documentation must be: Complete and simple in presentation ","Critical ","Make Selection"]
["Common Features","Documentation","1.5.2","The documentation must be:  Capable of being tailored to the organization's needs ","Critical ","Make Selection"]
["Common Features","Documentation","1.5.3","The documentation must be: Customised as required by the organization prior to the commencement of education/ training ","Critical ","Make Selection"]
["Common Features","Documentation","1.5.4","The system must provide customizable end user documentation (i.e. user defined Procedures Manual) online and be capable of being printed ","Critical ","Make Selection"]
["Common Features","Documentation","1.5.5","Upgrades to documentation must be provided with application upgrades ","Critical ","Make Selection"]
["Common Features","Documentation","1.5.6","The vendor must supply complete documented database schemas ","Critical ","Make Selection"]
["Common Features","Documentation","1.5.7","The vendor must supply documented entity relationship diagrams clearly defining the relationships between all entities and attributes ","Critical ","Make Selection"]
["Common Features","Documentation","1.5.8","The vendor must supply a comprehensive documented data dictionary clearly defining all entities and attributes ","Critical ","Make Selection"]
["Common Features","Documentation","1.5.9","Upgrades to documentation must be provided with application upgrades ","Critical ","Make Selection"]
["Common Features","Documentation","1.5.10","The system must provide for application/ management 'tools' with user support documentation","Critical ","Make Selection"]
["Common Features","Meter Management","1.6.1","The system must support the process for receiving AMI meter exchange and module installation service orders from GPA systems","Critical","Make Selection"]
["Common Features","Meter Management","1.6.2","The Proponent software shall be able to list the minimum customer information that the Companies will need to supply to perform the work","Critical","Make Selection"]
["Common Features","Meter Management","1.6.3","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: ID of the installer","Critical","Make Selection"]
["Common Features","Meter Management","1.6.4","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: Date/time the order is completed","Critical","Make Selection"]
["Common Features","Meter Management","1.6.5","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: Read from the meter or module being set. The reading from the electric meter being installed is expected to be zero.","Critical","Make Selection"]
["Common Features","Meter Management","1.6.6","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: Meter number of the meter being installed","Critical","Make Selection"]
["Common Features","Meter Management","1.6.7","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: Serial number of the meter being installed","Critical","Make Selection"]
["Common Features","Meter Management","1.6.8","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: Media Access Control (MAC) address, if present, of the meter being installed","Critical","Make Selection"]
["Common Features","Meter Management","1.6.9","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: Module number of the module being installed and the meter number and serial number on which the module is being installed","Critical","Make Selection"]
["Common Features","Meter Management","1.6.10","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: Meter number of the meter being removed","Critical","Make Selection"]
["Common Features","Meter Management","1.6.11","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: Follow-up flags indicating that the Companies should investigate situations found at a premise such as incorrect data, safety issues, potential tamper, premise repairs required, date/time found, the Companies party reported to, and other situations found in the field by the Proponent","Critical","Make Selection"]
["Common Features","Meter Management","1.6.12","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: Comments section is to include the correct versus incorrect data found and note follow-up flag details","Critical","Make Selection"]
["Common Features","Meter Management","1.6.13","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: Billing Constant meter multiplier","Critical","Make Selection"]
["Common Features","Meter Management","1.6.14","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: Premise as-found condition (based on list to be provided by GPA)","Critical","Make Selection"]
["Common Features","Meter Management","1.6.15","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: Premise as-left condition (based on list to be provided by GPA)","Critical","Make Selection"]
["Common Features","Meter Management","1.6.16","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: Certification that locks and seals are in place","Critical","Make Selection"]
["Common Features","Meter Management","1.6.17","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: GPS coordinates (X, Y, Z)","Critical","Make Selection"]
["Common Features","Meter Management","1.6.18","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: Store a digital photograph of the as-found meter/index","Critical","Make Selection"]
["Common Features","Meter Management","1.6.19","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: Store digital photograph of the as-left meter/index","Critical","Make Selection"]
["Common Features","Meter Management","1.6.20","The Proponent  system shall have the ability to  capture and transfer the follwing data elements: Optionally store a digital photograph of the meter socket with the meter removed.","Critical","Make Selection"]
["Common Features","Meter Management","1.6.21","The Proponent shall be able to deliver raw GPS data in Latitude(Lat) & Longitude(Lon) in Decimal Degrees (xxx.xxxxxx).","Critical","Make Selection"]
["Common Features","Meter Management","1.6.22","The Proponent shall have Disaster Recovery capabilities","Critical","Make Selection"]
["Desktop Administration Control Panel","General Desktop Features","2.1.1","The system must be capable of delivering all modules of the application through a desktop environment ","Critical ","Make Selection"]
["Desktop Administration Control Panel","General Desktop Features","2.1.2","The design of the mobile client must generally mirror the desktop client layout and functionality to the extent that is practical ","Valued","Make Selection"]
["Desktop Administration Control Panel","General Desktop Features","2.1.3","The system must support customisation to the look (colour, component layout etc) of pages ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Work Order Management","2.2.1","The system must enable dispatch staff to view the status of work order via workflow status such as 'open, on hold, closed, diverted' ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Work Order Management","2.2.2","The system must allow the dispatch staff to redeploy work orders to other maintenance crews if the original crew assigned the work is not able to attend the job within an expected timeframe ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Work Order Management","2.2.3","The system must show all prioritised work orders in a structured fashion and display this to the Dispatch Staff to support work order management and dispatch capabilities ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Work Order Management","2.2.4","The system must provide a list of work orders that have not yet been dispatched ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Work Order Management","2.2.5","The system must provide a list of work orders that have been dispatched ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Dispatch","2.3.1","The system must enable administrator / dispatch staff to effectively dispatch work orders to maintenance staff ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Dispatch","2.3.2","The system must enable tracking of GPS locations and present the location of work crews to dispatch staff at any given time ","Required ","Make Selection"]
["Desktop Administration Control Panel","Dispatch","2.3.3","The system must be able to display on a cadastral map, the positions of all available crews that have the appropriate skills to action a specified type of work order ","Required ","Make Selection"]
["Desktop Administration Control Panel","Dispatch","2.3.4","The system must display which staff are attributed to which maintenance vehicles ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Dispatch","2.3.5","The system must provide (display) the following:  Staff and vehicle number with work orders allocated ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Dispatch","2.3.6","The system must provide (display) the following:  Staff and vehicle number and Job Locations ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Dispatch","2.3.7","The system must provide (display) the following: Time work order was dispatched ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Dispatch","2.3.8","The system must provide (display) the following:  Staff and vehicle number and associated job type ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Dispatch","2.3.9","The system must provide (display) the following:  Staff downtime such as leave and other breaks ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Dispatch","2.3.10","The system must provide (display) the following:  Staff calendar information ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Dispatch","2.3.11","The system must display which staff are currently using which maintenance truck (for OHS purposes) ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Dispatch","2.3.12","The system must be able to display non contactable vehicles and staff in communication black spots ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Business Rules","2.4.1","The system must support confined space entry business rules such as the need to enforce  3 people working at a confined space site. ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Business Rules","2.4.2","The system must provide alerts to nominated users when business rules are not being met ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Workflow Processes","2.5.1","The system must allow work orders be transferred to other work crews if nominated work crew cannot complete the work order within the allotted priority timeframe ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Workflow Processes","2.5.2","The system must allow maintenance crews to request a follow up work order to be generated ","Critical ","Make Selection"]
["Desktop Administration Control Panel","Workflow Processes","2.5.3","The system must allow for maintenance teams to queue lower priority work orders ","Critical ","Make Selection"]
["Mobility","General Mobility Features","3.1.1","The system must have a mobile user interface ","Critical ","Make Selection"]
["Mobility","General Mobility Features","3.1.2","The system must be able to download required asset information onto the following mobile computing devices via a cellular connection:  Ultra Mobile PCs ","Critical ","Make Selection"]
["Mobility","General Mobility Features","3.1.3","The system must be able to download required asset information onto the following mobile computing devices via a cellular connection:  Rugged Field Portable PCs ","Critical ","Make Selection"]
["Mobility","General Mobility Features","3.1.4","The system must be able to download required asset information onto the following mobile computing devices via a cellular connection: Tablet Computers ","Critical ","Make Selection"]
["Mobility","General Mobility Features","3.1.5","The system must be able to download required asset information onto the following mobile computing devices via a cellular connection:  PDAs ","Critical ","Make Selection"]
["Mobility","General Mobility Features","3.1.6","The system must be able to download required asset information onto the following mobile computing devices via a cellular connection:  Laptops ","Critical ","Make Selection"]
["Mobility","General Mobility Features","3.1.7","The system should support remote usage with laptops, tablet computers and hand held devices supporting the following operating systems:  Windows CE/Windows Mobile ","Critical ","Make Selection"]
["Mobility","General Mobility Features","3.1.8","Each screen must provide a 'home' key to enable users to return to the home screen ","Critical ","Make Selection"]
["Mobility","General Mobility Features","3.1.9","Navigation buttons must allow users to move backwards and forwards through screens ","Critical ","Make Selection"]
["Mobility","General Mobility Features","3.1.10","The system must provide a facility for the user to synchronise the field data with the main database ","Critical ","Make Selection"]
["Mobility","General Mobility Features","3.1.11","The system must have a facility to check field data before it's committed to the database ","Critical ","Make Selection"]
["Mobility","General Mobility Features","3.1.12","The system must be able to reimport the edited field data ","Critical ","Make Selection"]
["Mobility","General Mobility Features","3.1.13","The system must be able to update forms, checklists, activity data from mobile recording in the field ","Critical ","Make Selection"]
["Mobility","General Mobility Features","3.1.14","The system must have the ability to edit maps and data attributes in the field with GPS enabled mobile computing software ","Valued ","Make Selection"]
["Mobility","General Mobility Features","3.1.15","The system should connect to a variety of global positioning system software and hardware ","Critical ","Make Selection"]
["Mobility","General Mobility Features","3.1.16","The system must be able to publish mobile or hand held friendly pages ","Critical ","Make Selection"]
["Mobility","General Mobility Features","3.1.17","The system must provide an intuitive look & feel consistent with the handheld operating system ","Critical ","Make Selection"]
["Mobility","General Mobility Features","3.1.18","The system must support simple customizable drop down forms and menus to reduce free field text entry ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.1","The system must have the ability to electronically transmit work order details, work instructions and GIS map to a maintenance vehicle in the field ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.2","The system must be able to provide any updated work order request information to the field maintenance crews (e.g.: change in priority, change in location, etc.) ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.3","The system must have the ability to generate customised proformas, task lists and screens for field recording of maintenance activity and inspection details relating to the various assets ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.4","The system must be able to download required task lists and maintenance/inspection information on hand held devices, and allow the user to record/update activity and/or asset information in the field ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.5","The system must enable maintenance crews / supervisors to generate and edit work orders in the field ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.6","The system must enable the creation of follow up work orders to be generated based on notification from the field, to be created / authorised by the main office for future dispatch ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.7","The work order management mobile computing user interface must support ease of use and be simple to operate ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.8","Time stamping can be either automatically logged against system time or override when timestamp entry is not completed real time","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.9","The system must store incomplete work orders to be completed at a later date ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.10","The system must allow the user to toggle between open work orders ","Valued","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.11","The system must manage work statuses, using Open, Completed, Not Started ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.12","The highest priority work order must be displayed / flagged as soon as system user is logged on ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.13","The system must allow work orders to be attached to asset records ","Valued","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.14","The system must allow staff members to be attached / removed a maintenance vehicle ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.15","The system must have staff attached to maintenance vehicles as a mandatory requirement ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.16","The system must allow for work orders to be reprioritized in the field ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.17","The work order form must be configurable to include organization changes in requirements over time ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.18","The work order data entry form must include information such as, but not limited to:  ­Work Order Number ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.19","The work order data entry form must include information such as, but not limited to:  ­Asset ID ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.20","The work order data entry form must include information such as, but not limited to:  ­Group Project Number ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.21","The work order data entry form must include information such as, but not limited to:  ­Address / Location House Number and Street","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.22","The work order data entry form must include information such as, but not limited to:  Service Address Number","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.23","The work order data entry form must include information such as, but not limited to:  ­Person Initiating ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.24","The work order data entry form must include information such as, but not limited to:  ­Person / Maintenance Team assigned to ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.25","The work order data entry form must include information such as, but not limited to:  ­Initiated Date and Time ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.26","The work order data entry form must include information such as, but not limited to:  ­Scheduled date and time ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.27","The work order data entry form must include information such as, but not limited to:  ­Maintenance Type ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.28","The work order data entry form must include information such as, but not limited to:  ­Priority ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.29","The work order data entry form must include information such as, but not limited to:  ­Status ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.30","The work order data entry form must include information such as, but not limited to:  ­Time started on site ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.31","The work order data entry form must include information such as, but not limited to:  ­Time completed on site ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.32","The work order data entry form must include information such as, but not limited to:  ­Costs ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.33","The work order data entry form must include information such as, but not limited to:  ­Parts / Materials ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.34","The work order data entry form must include information such as, but not limited to:  ­Tools / Equipment ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.35","The work order data entry form must include information such as, but not limited to:  ­Follow up work order required ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.36","The work order data entry form must include information such as, but not limited to:  ­Comments ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.37","The work order data entry form must include information such as, but not limited to:  ­Actions ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.38","The work order data entry form must include information such as, but not limited to:  ­Authorisation ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.39","The work order data entry form must include information such as, but not limited to:  ­Asset Type ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.40","The work order data entry form must include information such as, but not limited to:  ­Water Supply Interruption ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.41","The work order data entry form must include information such as, but not limited to:  ­Fault Type ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.42","The work order data entry form must include information such as, but not limited to:  ­Excavation Details ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.43","The work order data entry form must include information such as, but not limited to:  ­Asset Details ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.44","The work order data entry form must include information such as, but not limited to:  ­Burst Details ","Critical ","Make Selection"]
["Mobility","Mobility Work Order Management","3.2.45","The work order data entry form must include information such as, but not limited to:  ­Shut down details ","Critical ","Make Selection"]
["Mobility","Inspections and Conditions","3.3.1","The system must have the ability to input asset inspection and condition assessment data on hand held devices and then allow it to be uploaded into the system. i.e.: 'enter it once principle' ","Critical ","Make Selection"]
["Mobility","Communications","3.4.1","The system should support the following communications protocols:  GPRS ","Critical ","Make Selection"]
["Mobility","Communications","3.4.2","The system should support the following communications protocols:  UMTS ","Valued ","Make Selection"]
["Mobility","Communications","3.4.3","The system should support the following communications protocols:  GSM ","Valued ","Make Selection"]
["Mobility","Communications","3.4.4","The system should support the following communications protocols:  Next G ","Critical ","Make Selection"]
["Mobility","Communications","3.4.5","The system should support the following communications protocols:  Wireless Broadband ","Critical ","Make Selection"]
["Mobility","Communications","3.4.6","The system must provide live connectivity to field maintenance crews, and data transfer must be live and synchronized ","Critical ","Make Selection"]
["Mobility","Communications","3.4.7","Where live connectivity is lost, the system must store information for later transferral when signal is later established ","Critical ","Make Selection"]
["Mobility","Communications","3.4.8","The system must ensure no loss of data occurs during communication drop outs ","Critical ","Make Selection"]
["Mobility","Synchronization","3.5.1","The system must be able to update forms, checklists, activity data from mobile recording in the field ","Critical ","Make Selection"]
["Mobility","Synchronization","3.5.2","The system must have a facility to check field data prior to commitment to the database ","Critical ","Make Selection"]
["Mobility","Synchronization","3.5.3","The system must provide a facility for the user to synchronize the field data with the main database ","Critical ","Make Selection"]
["Mobility","Mapping","3.6.1","The system must have the ability to edit GIS shape files in the field with GPS enabled mobile computing software ","Required ","Make Selection"]
["Mobility","Mapping","3.6.2","The system must allow network tracing capability in the field, so that maintenance staff know what customers are affected during random outages ","Required ","Make Selection"]
["Mobility","Mapping","3.6.3","The system must support the display of aerial photography and be seamless in displaying photography with cadastral data in ESRI platform, ArcSDE, TIFF and ECW file formats ","Critical ","Make Selection"]
["Mobility","Mapping","3.6.4","The system must allow the user to measure pipe lengths and attach this information to a work order ","Critical ","Make Selection"]
["Mobility","Mapping","3.6.5","The system must allow for work order aligned assets to be relocated / redrawn in the field, and this information to be transferred to corporate GIS for verification ","Critical ","Make Selection"]
["Mobility","Alerts and Messages","3.7.1","The system must provide appropriate alerts and messages to the field crews and supervisors, based on the type of asset maintenance or inspection activity ","Critical ","Make Selection"]
["Mobility","Alerts and Messages","3.7.2","The system must notify dispatch staff of a need to alert the authorities in the case of large scale emergencies ","Critical ","Make Selection"]
["Mobility","Alerts and Messages","3.7.3","The system must record injury incidents and send an alert to dispatch staff of an incident occurrence ","Critical ","Make Selection"]
["Mobility","Timesheets","3.8.1","The system must provide the capability to maintenance staff the capability to log timesheet information electronically onto the mobile computing device ","Critical ","Make Selection"]
["Mobility","Timesheets","3.8.2","The system must support the use of multiple units of measurement in the recording of timesheet information, e.g. days, hours, minutes, etc ","Critical ","Make Selection"]
["Mobility","Timesheets","3.8.3","The system must record staff start and finish times against each work order ","Critical ","Make Selection"]
["Mobility","Timesheets","3.8.4","The system must be capable of recording non work order related activities staff may be undertaking, such as meetings, training etc ","Critical ","Make Selection"]
["Mobility","Timesheets","3.8.5","The system must account for allowance based work ","Critical ","Make Selection"]
["Mobility","Timesheets","3.8.6","The system must allow each staff member to be linked to a work order on an individual basis to record individual staff time against the work order ","Critical ","Make Selection"]
["Mobility","GPS","3.9.1","The system must allow mobile computing interface and hardware to track GPS coordinates to ensure maintenance crew locations are available to the dispatch team with a minimum accuracy of 15 feet","Critical ","Make Selection"]
["Mobility","GPS","3.9.2","The system must provide 'shortest route' to maintenance crews travelling to and from maintenance sites ","Required ","Make Selection"]
["Mobility","Scheduling","3.10.1","The system must record scheduling information of each maintenance vehicle and individual staff associated with the vehicle ","Critical ","Make Selection"]
["Integration","ESRI GIS","4.1.1","The system must provide a mechanism to transfer new asset spatial data from mobile computing devices to the ESRI GIS environment ","Critical ","Make Selection"]
["Integration","ESRI GIS","4.1.2","The system must be able to upload corporate maps to mobile computing devices ","Critical ","Make Selection"]
["Integration","ESRI GIS","4.1.3","The system must have the capability to link spatial assets with work orders in the field, and transfer this information to nominated corporate systems ","Critical ","Make Selection"]
["Integration","ESRI GIS","4.1.4","The system must allow for spatial asset keys to be linked to work orders ","Critical ","Make Selection"]
["Integration","ESRI GIS","4.1.5","The system must be able to ensure the integrity of data between the GIS and mobile computing databases ","Critical ","Make Selection"]
["Integration","ESRI GIS","4.1.6","The system must allow for facilities information to be passed from the GIS.","Critical ","Make Selection"]
["Integration","Oracle’s Customer Care & Billing (CC&B) ","4.2.1","The system must provide a mechanism to transfer customer information to Oracle’s Customer Care & Billing (CC&B) Customer Information System. ","Critical","Make Selection"]
["Integration","Milsoft","4.3.1","The system must provide a mechanism to transfer information to the Milsoft  DisPatch Outage Management System.","Critical","Make Selection"]
["Integration","Enterprise Integration Framework","4.4.1","GPA will deploy an enterprise integration framework that will support implementation and management of best practices for integrating information and automation systems at a Smart Grid enabled electric utility. The system will be entirely compatible with GPA's enterprise integration framework.","Critical","Make Selection"]
["Integration","MDMS","4.5.1","The system must  be able to accept outage work tickets from the Smartworks MDMS","Critical","Make Selection"]
["Integration","MDMS","4.5.2","The system must  be able to send work order status or completion updates to the Smartworks MDMS","Critical","Make Selection"]