SCD_UPD_RM_LVW (SQL View)	Index Back
Scoring Models Update View This view provides the scoring models with their number of responses. SELECT B.SCD_DESCR45 ,A.SCD_RATIN_MODEL_ID ,A.SCD_RESP_CNT ,B.LANGUAGE_CD FROM PS_SCD_UPD_RM_VW A ,PS_SCD_RAT_MOD_LNG B ,PS_SCD_RM_VALS_LNG C WHERE A.SCD_RATIN_MODEL_ID = B.SCD_RATIN_MODEL_ID AND B.LANGUAGE_CD = C.LANGUAGE_CD

SCD_UPD_RM_LVW

(SQL View)

Scoring Models Update View

This view provides the scoring models with their number of responses. SELECT B.SCD_DESCR45 ,A.SCD_RATIN_MODEL_ID ,A.SCD_RESP_CNT ,B.LANGUAGE_CD FROM PS_SCD_UPD_RM_VW A ,PS_SCD_RAT_MOD_LNG B ,PS_SCD_RM_VALS_LNG C WHERE A.SCD_RATIN_MODEL_ID = B.SCD_RATIN_MODEL_ID AND B.LANGUAGE_CD = C.LANGUAGE_CD

SELECT SCD_DESCR45 , SCD_RATIN_MODEL_ID , LANGUAGE_CD FROM PS_SCD_RAT_MOD_LNG

Related Language Record for SCD_UPD_RM_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCD_DESCR45 Character(45) VARCHAR2(45) NOT NULL 45 Character Description

2 SCD_RATIN_MODEL_ID Character(10) VARCHAR2(10) NOT NULL Rating Model ID

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCD_DESCR45	Character(45)	VARCHAR2(45) NOT NULL	45 Character Description
2	SCD_RATIN_MODEL_ID	Character(10)	VARCHAR2(10) NOT NULL	Rating Model ID
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code