User manual of Genric CQMS
Contents
1. User SAWN NS RNS SS RR SS Sumit Gupta 2 2 6 Customize User can customize the project by selecting the following options Set Project Background Select Project BlockCard mapping Set Project Logo Select Project Browse This customization reflects changes at project level styling on QMS Pages for setting the project backgrounds and logo 2 3 Applicant This is the entry point to project QMS Centralized Query Managment System af Pizza Hut Home Log out Copyright 2011 RMSI PVT LTD Clicking on the Project icon 1t will show the following module and respective project summary report in graph format Project Level statistical information block Before going to the QMS page for the project this part shows all the current information about the project though graphical illustrations RMSI 4 Delivering a world of solutions Project Summary Report No of Queries Query Status Levelwise Raiser ProjectLesd ProjectManager Client Raised PForvarded Holded Rejected PAnswered Query Type Wise Details Total Queries 3 E y an y s i 3 O o O o 2 O 0 Overlap or Gap In O Total Client Side Query Time Wise Details fin Days 6 19 0 15 g 0 11 3 o 0 02 o lt 0 04 0 0 00 0 00 Reiser ProjectLesd ProjectManager Cc _Foaresyded Recolied RMSI CA Delivering a world of solutions 2 3 1 Home 2 3 2 Query Management System 2 32. 3 Search Query amp Home d Query Management System Search Query Log Out 2 3 1 Home This is redirecting the user back to the QMS HUB 2 3 2 Query Management System a Raise Query Section If given rights this block appears to fire a new Query for the project that need to be answered or provided a solution This is the first level from where the query takes it flight and reaches the next level to be processed or answered A query can be Raised Forwarded Rejected Hold Answered at any level except Client and Raiser At raiser level query can be raised and at client level query can be Held Rejected or Answered as it s the final top most level RMSI A Delivering a world of solutions a sn 1 lt lt a Welcome Sanjay Mahara Raise Request submit b View Process Query Section This 1s the part to search a query or process the query based on the access level of the user Whole query cycle and detailed information could be viewed from this section RMSI Y Delivering a world of solutions Search panel Level Status Priority Query Type Quey D C View Full Query Lists Query Information and Action Box 2 Record s Found Query Information Block Query ld View Details Action Lewel Query Description Projecthlansger gt 3 View Details Action HA Forwarded Projechianager gt While working on below mentioned store we have found the observation and the same is attached View Details Action Fo
3. have default access to the qms until given rights e Sub Administrators Have project level admin rights e Users These are the various users with some roles based on their levels set who participate in QMS cycle based on the projects they are give rights to in QMS team e Client These are the highest level in the QMS These are the final levels for a QMS query to reach 1 2 Objective CQMS came into existence with an objective to have a consistent Projects Issue Recording and Resolving System across the company along with our Client as part of the initiative to have a consistent projects Issue recording system across the projects 1 3 Host To access this website following link can be used http cms rmsi com gencqms RMSI 4 Delivering a world of solutions 1 4 Login page This is the first page through which a user can login and subsequently access the other pages of CQMS website as per the assigned rights User will use their ADS login id and password to access the site Depending upon the authorization level the user will be given access to CQMS website GQMS CENTRAL QUERY MANAGMENT SYSTEM Login Username Password CI Remember Me Change Password RMS ey Delivering a world of solutions Section 2 2 1 Home Page After logging into the CQMS the following module available in home page e Administrator e Applicant QMS HUB Home This serves as the entry point for the whol
4. Answer e Levels User can assign the new level of the projects and re arrange the levels in the sequence that one wants them to be 1 e from top to bottom Rosi Delivering a world of solutions New Project Level project Levels with same description will not be created submit Refresh Level Delete Ralser Delete ProjectLead Delete ProjectManager Delete Client Delete Select Level Re Order Levels Raiser ProjectLead ProjectManager Client Arrange the levels in the sequence that your want them to be e from top to bottom e User Rights This section is used to provide add the project level QMS Team details All the QMS users or the Clients added to the list can now participate in the QMS based on their levels and rights To Note After Administrators only the project level sub administrators can provide or fill in these details RMSI 4 Delivering a world of solutions Employee Name Client Name Employee Code E Mail 1D Chain singh rmsi com Roles Raise Forward Hold L Reject L answer Submit Refresh e Query Type User can add the query type here by selecting the project It should be short and duplicate not allowed New Querv Tvpe Project BlockCard mapping Query Type Description Should be short and Duplicate Query types will not be entered Submit Query Type Delete Input Issues Delete Specification Delete Mains Delete Services Delete Fittings Delete RMSI CA De
5. Attatchments 1 Observation Slip Pizzahut 04032012 lldoc By 1 Kesavarapu Ganga Subrahmanyam Upload File fe Click here to Attatch file selected Since all the queries have unique query ids so they can be tracked easily On clicking the View Details for a query a pop up appears that shows a query s completes cycle and all the suggestion and descriptions logged by various QMS users at their end levels including the attachments RMSI 4 Delivering a world of solutions Query Information and 2 Record s Found Query Information Block View Details Lewel Query Description Projecthlansger gt View Details Action MA Forwarded Projecthlanager gt While working on below mentioned store we have found the cheervation and the same is attached here View Details Action Forwarded for your quick reference NPC DINPCI NPC004387 Take Action Query History Windows Internet Explorer http cms msi com Pgencams QMSPOR TAL QueryHistory aspx Query Details QUERY QUERY UPDATED LEVEL STATUS ACTION D SUGGESTION ON STATUS DESCRIPTION ID ID LEVEL DESC DESC UPDATED BY While working on below mentioned store we have found the observation and the D5 Apr same is attached here for your quick 2012 reference WPC O3NPCI NPCO04367 We shall look forward for your confirmation to proceed further with this store Shall we remove the overlap area from 014434 store Kesavarapu ProjectLead Raise Ganga S
6. RMSI CA Delivering a world of solutions RMSI User manual of Genric COMS C Work in progress L Issued for review Approved Published O Chain Singh Sanjay Mahara Sunil Malhotra Approved By Sunil Malhotra RMSI CA Delivering a world of solutions Table of Contents A 3 LETRO TION Sarai ita 3 WFO CUB sii iii Ee aaea 3 E EA EE EOE E E ENINA ATE AA EA EAEE 3 LA LOCINPACE a E E E N 4 O E AEEA EA 5 Pk Oe P E o PA e CA 5 A 6 2Z2AMNCRENTE NEW PROJTEC Lt 6 Z 2 PANU iaa idiid 7 2 2 93 WORKUNITATTRIBU OS nn corrida 11 22 98 WORKUNIT DATA ini taiaa 14 22S PR FIN a 17 AA E E EE 18 LSA E E E Eo E E EE E o E A 19 S A A 21 ON a o e o 26 Rosi CA Delivering a world of solutions Section 1 1 1 Introduction Centralized Query Management System CQMS has been developed to build a communication link between the client and the project team to rectify and resolve any issue that they might be phasing during the any project cycle or development The idea behind creating and launching this website is to enable online update of issues and its response among the Issue Raiser Issue Solver and the Client This site is intended to reduce the manual work and expedite the processes involved therein Your feedback and suggestions on website will be of help to make it more robust e Administrators Have all the admin rights and can also set sub admins project level administrators for the respective projects But do not
7. The information for the work unit will be divided in the following kinds 1 The Unique ID Field 2 The description Field 3 Other Fields 4 The dependent Fields Which are reference to another work unit field and are rendered in the form of dropdowns and one need to select the item accordingly before adding the details RMSI A Delivering a world of solutions Workunit Data Addition Project BlockCard_mapping Workunit Data to be added for Refresh BLOCBLOCK CARD BLOCK CARD ID sd BLOCBLOCK CARD BLOCCANO NME O00 BLOCBLOCK_CARD TOWN ID BLOCBLOCK CARD DIVISION 1D y 1905 record s found y Last updated record unique id is 1861 Export Data to Excel BLOCK CARD ID BLOCKCARD NAME TOWN ID DIVISION _ID 1855 Ainsworth 143 146 Akron 1 pratdael v1 Akron 1548 pratdaet vl The total records count and the Last updated maximum key value is always present as notification for user reference Uploading Work Unit Data The user has to choose the project and then the work unit against which to upload the data Provide if the unique ids would be automatically generated or provided with in the sheet to be uploaded Next step is to upload the data in correct format as represented in the template RMSI A Delivering a world of solutions Workunit Data Addition Project BlockCard_mapping Workunit Data to be added for Division T Refresh Table Name Column Sub Attribute Value Workunit Tablename Add Ent
8. d defines the field which is the description column field of the work unit If one misses out to set any of the field as description then it could be set from the Set description If Missing block Once set it cannot be set again When not set for any work unit the user cannot see the work unit data although present in the database as description field would be missing or not set LINES Delivering a world of solutions Dependency Check While the creation some work units could be at parent level and some at child level I e some may be the master and some could serve as the process level work units The child tables work units are the once which have some field which are a reference to the field existing in another work unit so that mapping has to be declared in this section 1f the case 1s so for a work unit AB for A dependent to B means A has a field referenced to one field in B The Master at this point so for this one should mark the Is dependent to another work unit box as checked which will open a list of all the other work units existing or previously defined for the project Project Status Levels User Rights Query Type Workunit New Project Workunit Project BlockCard_mapping There should not be any space in workunit description name one can use underscorel_ Work Unit Name STS Type of Work Unit Is dependent on another work unit Dependent Work unit Generate Common Fields Subject S
9. e Password Password can type here e Host ID User can add host ID name e Server Name Type server name here This 1s the first step in creating the project and its environment by declaring the database and the server details This enables running of the pre designed SQI scripts in the targeted database This is the project initialization part to set up the required database objects to further create the physical project DB structure 2 2 2 Add Entity In this menu user can able to add the Entity Project details by updating the following options This is the second step to create the Physical Project Structure in the Database chosen while creating the project Everything that is being set from this section is reflecting the changes in the Database like adding the location details creating work units and attributes or adding data to the work units etc e Project User can add the location details by selecting the project and location from drop down box and click on submit button Rosi Delivering a world of solutions New Project Location submit Refresh Location Project Name NOIDA BlockCard_mapping HYDERABAD GORMS Consolidation HYDERABAD AMDB 3D HYDERABAD Pizza Hut e Status User can view the project status like Raise Forward Hold Reject Answer The project status is always same for every project it does not change New Project Status Project BlockCard mapping Refresh Raise Forward Hold Reject
10. e application where one could enter the admin and the QMS portal based on the rights granted to the user Query Management System provides access to the various projects for which the user is given rights to feed process the project cycle and view the statistical information about all the queries raised under the project and their status Power Administrators Sub Admin does not have rights to access the QMS only when a user 1s added to the project QMS user pool by the admin can enter the QMS Portal Centralized Query Managment System a APPLICANT Log out RMSI A Delivering a world of solutions 2 2 Administrator In administrator module there are the following options available 2 2 1 Create New Project 2 2 2 Add Entity 2 2 3 Workunit Attributes 2 2 4 Workunit Data 2 2 5 Add Admin 2 2 6 Customize 2 2 1 Create New Project In this menu user can create the project server information by typing selecting the following options Create New Project Use Existing Project Server Project Name Server Type Data Source User ID Data Source Password Host ID Server Name Rosi CA Delivering a world of solutions e Use Existing Project Server User can select the existing project server from drop down box e Project Name Type the project name here e Server Type database type here Like Oracle Sqlserver MySql MS Access Post Gre e Data Source User ID User name type here e Data Sourc
11. livering a world of solutions e Workunit User can give the work unit here by typing the work unit name and selecting the type of work unit from drop down box New Project Workunit Project BlockCard_ mapping There should not be any space in workunit description name one can use underscore _ Work Unit Name Po Type of Work Unit Dropdown List Is dependent on another work unit O Generate Common Fields Subject Suggestion Remarks Resolution Date and Attatchments by clicking on the Generate Auto Controls Button only when you are dong with workunite creation Generate Auto Controls Click on Genrate auto control when you created all work unit Submit Refresh Workunit Name Data Type Is Dependent Dependent Workunit Delete Division DropDown List Delete Town DropDown List Delete Block_card DropDown List i Delete 2 2 3 Work unit Attributes In this menu user can create the column and table name for the database e Project User can select the project from here to add the work unit details e Work unit This is the section where all the work units information is added i e what all work units exists within the project User can add the work unit from here Now on adding the work unit details one has to provide information if it s a dependent type or not These work units can be deleted only if there is no data inserted against them 1 e we have not reached the next level after this Once all the work units are registe
12. red logged for the project then 1s the time to click the Generate Auto Controls button Which creates the general required fields for all the QMS Projects like subjects suggestion and attachments etc which are always a part of a query e Attribute Name User can create the column name here It should not have any space or special character other than underscore This section creates all the work unit physical structure defined in the previous section Once we have passed though this part we cannot roll back RMSI Delivering a world of solutions So the creator of the work unit should have knowledge of the Project structure very clear and should know how one work unit is dependent and mapped to another and what field describes its behavior Workunit Attributes Project BlockCard_mapping Workunit attribute name should not have any space or special character other than underscore ls dependent on another work unit LJ lis this description column Define Column Dependency TABLE_NAME COLUMN_ NAME DATA TYPE BLOCDIVISION DIWISION_ID NUMBER BLOCDIVISION DIVISION _ NAME VARCHAR BLOCDIVISION TEST VARCHAR Description Field When first work unit attribute field is added one unique key field is also added along with it from a combination of work unit name and ID string so that 1t could be well recognized and it s the primary key for the work unit by default The description field can be only one for a work unit an
13. rwarded here for your quick reference NPC O3NPCI MPCO04367 Further Processing the Query To act upon a query the user with his level and role can process the query reaching out at his level Every query can be provided with Suggestion and Description Also attachments can be added if required For the level just below the client level one can target the project level clients which are required to answer a particular query specifically Client level is the final level where a query can reach through all the query process level defined RMSI A Delivering a world of solutions Query Information Block View Details Action Lewel Query Description Projecthlanager gt Wiew Details Action NA Forwarded Projecthianager gt While working on below mentioned store we have found the observation and the same is attached here View Details Action Forwarded for your quick reference HPC OSNPCI NPOO0D4387 Take Action Shall we remove the overlap area from 014434 store Enter Suggestions Enter Description While working on below mentioned store we have found the observation and the same is attached here for your quick reference NEC O3NPCI NPC004367 We shall look forward for your confirmation to proceed further with this Take Action Add Clients Add clients names if this query is suppose to target only those clients that you mention All the cient mail ids should me comms seperated Clients Added
14. ry ee 13 record s found eo Last updated record unique id is 12 Export Data to Excel DIWISHOM_ ID DIVTS POM BLAME TEST ALBION All ALLIANCE CASPER GILLETTE O Client Id O Auto Genrated Id z Download Excel nd Make Another Excel Same As Downloded Structure and Save as CSV Select Table Select Excel OWSE Upload RMS ey Delivering a world of solutions 2 2 5 Add Admin a Power Admin Admin user provides rights here by selecting the location and user name from drop down box and click on submit button Thus one power admin has rights to create new power and sub Admin at application and the project level respectively Provide User Access as Admin Location Select Ww User Select s Submit h X UserlD Admin Name NO2525 Sunil Malhotra Sanjay Mahara H00114 Gadde Narendra Kumar H00336 Bonthu Hari Babu H00395 Deevi Prabhu Kumar Mohammad Nasim Siddiqui Ravi Shankar Chidireddi H00147 Lakshmi Gullapalli H00898 Santosh Kumar Bashetty H00072 sagiraju Venkata Siva Nagaraju b Project Level Admin Rights Sub Admin Power administrators have rights to create project level administrators so that once created they can create add project level QMS details for the project However one sub admin cannot create another sub admin until he she is also a power administrator RMSI 4 Delivering a world of solutions Provide Project Wise Admin Location Project
15. ubrahmanyam While working on below mentioned store we have found the observation and the 05 Apr same is attached here for your quick 3 ProjeciManager Forward sagiraju Venkata 2012 reference NPC OSNPCI NPCOO4367 We i oe a Siva Nagaraju shall look forward for your confirmation to proceed further with this store Shall we remove the overlap area from 014434 store Attatchments 1 Observation Slip Pizzahut 04032012 ILdoc By 1 Kesavarapu Ganga Subrahmanyam Internet 2 3 3 Search Query This is the Master Query Search Section where all the project level queries could be searched for get information regarding their status and cycle process RMS ey Delivering a world of solutions Centralized Query Managment System g w Pizza Hut elcome Sanjay Mahara Search Panel Query Records Work_Type Select 2 Record s Found Store_Number Select Subject Level Select Status Select Priority Seled O3NPCI_Overlap Query Type Sele Section 3 3 1 Logout Logout page shall be as below Description Status Priority NA Forward Medium While working on below mentioned store we have found the observation and the same is attached here for your quick Medium reference NPC O3NPCI NPC004367 Res Date 10 Apr 2012 11 Apr 2012 Details View il View Details You Have Loged Out Login Again
16. uggestion Remarks Resolution Date and Attatchments by clicking on the Generate Auto Controls Button only when you are done with workunite creation Generate Auto Controls Click on Genrate auto control when you created all work unit ResolutionDate Refresh Submit Workunit Name Data Type Is Dependent Dependent Workunit Delete Division DropDown List Delete Town DropDown List Delete Block card DropDown List Delete RMSI CA Delivering a world of solutions 2 2 4 Work unit Data In this menu user can upload and download the work unit data in cvs format by selecting the following options Project User can select the project from here Work unit Data to be added for Work unit related data can either be added manually or by uploading the cvs file in the format suggested To know the format for the cvs one can download the template format from the interface and then upload the data in one go by uploading it via the sheet Notes Before uploading the data the user need to specify whether the unique key attributes will be provided from the sheet or the application should automatically update the unique key attributes to the database as each work unit DB Tables as one unique key which is automatically created while defining the work unit attributes Select the work unit data which you want to add Manual Adding While adding manually the unique key field is also provided along with other data
Download Pdf Manuals
Related Search