on 03-28-2013 4:22 AM
Hi,
We need to write a query to get RFX scores from the RFX document and populate to new field. Please let me know, RFX scores are stored in which table and how to collect it in a query...
Thanks in advance
Regards
Natarajan
Hi Natarajan,
Are you working on Sourcing 7.0? If yes, then I have a solution for the same.
RFx Scoring are stored in FCI_CS_SCORE_ATTR Table
Regards,
Vignesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Natarajan,
There are couple of different ways you can find the table name. You could go to the page you are interested in and then click on Reference Guide > click on Schema View and there you should see the table name. Sometimes the data you are looking to query can be in multiple tables and you would have to join to those tables. In those situations you could search for the standard out of the box queries and look at the sql to understand what the tables are and how they are joined. For example, if you are interested in tables related to collaborative scoring, you could look at the query definition associated with the Rfx Collaborative Scoring Progess Summary by Proposal and by Scorer report.
Regards,
Vikram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.