cancel
Showing results for 
Search instead for 
Did you mean: 

How to get RFX scores

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

  •   Note: It will work only in sourcing 7. In Sourcing 9 we have a separate report called “RFX Collaborative Scoring”.

Regards,

Vignesh

Answers (1)

Answers (1)

0 Kudos

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