SCD_ADD_RM_VW

(SQL View)
 Index Back

Scoring Models Add View

This view is only to be used as the add search record for the component SCD_RATE_MODELS_FL. The SCD_RATINMODELS table can not be used because it has a sub-record which causes issues with pivot grid component search. SELECT B.SCD_DESCR45 ,B.SCD_RATIN_MODEL_ID ,( SELECT MAX(A.SCD_SEQ_NBR) FROM PS_SCD_RATMOD_VALS A WHERE A.SCD_RATIN_MODEL_ID = B.SCD_RATIN_MODEL_ID) FROM PS_SCD_RATINMODELS B

SELECT B.SCD_RATIN_MODEL_ID ,B.SCD_DESCR45 ,( SELECT MAX(A.SCD_SEQ_NBR) FROM PS_SCD_RATMOD_VALS A WHERE A.SCD_RATIN_MODEL_ID = B.SCD_RATIN_MODEL_ID) FROM PS_SCD_RATINMODELS B

  • Related Language Record: SCD_ADD_RM_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCD_RATIN_MODEL_ID Character(10) VARCHAR2(10) NOT NULL Rating Model ID
    2 SCD_DESCR45 Character(45) VARCHAR2(45) NOT NULL 45 Character Description
    3 SCD_RESP_CNT Number(3,0) SMALLINT NOT NULL Number of Ratings