Scorecard Link to Rule

[Former Member]

The columns in yellow represent the Scorecard Name and Description that the rule is on.    I'm looking for the link between MMT_Rule and the Scorecard (Key Data Domain).

Anyone know how to link the Scorecard (Key Data Domain) to the Rules by their SQL Tables? Is there a view or universe that holds this information?

Any help is greatly appreciated.  We are creating a submission form for Rules/Scorecards and I need to this just to auto-file some form fields

[Former Member]

That looks GREAT!  Thank you!

[former_member655569]

Try this

           SELECT   K.KEY_DATA_DOMAIN_ID AS DATA_DOMAIN_ID,      

                           K.technical_name AS DATA_DOMAIN,     

                           R.RULE_ID   

             FROM        MMD_KEY_DATA_DOMAIN_WEIGHT W

   INNER JOIN        MMD_KEY_DATA_DOMAIN K ON W.key_data_domain_id = K.key_data_domain_id

   INNER JOIN        MMD_RULE R ON W.scorable_id = R.rule_id

   INNER JOIN        MMD_Profile_Project P ON K.project_id = P.data_group_id   

         WHERE         W.key_data_domain_score_type_cd = 'KDDR'

[Former Member]

One last Question...  What is the difference beween the MMD, MMt, MMB, and MMV Tables?

[former_member655569]

Sorry.. Have not explored them much..