CM_RATINGMDL_VW (SQL View)	Index Back
Rating Model View Selects for all Rating Models the current Review Ratings and Points. To be used as work-scroll in the Manage Competencies Inquiry panels.

CM_RATINGMDL_VW

(SQL View)

Rating Model View

Selects for all Rating Models the current Review Ratings and Points. To be used as work-scroll in the Manage Competencies Inquiry panels.

SELECT A.RATING_MODEL , B.REVIEW_POINTS , B.REVIEW_RATING FROM PS_RATING_MDL_TBL A , PS_REVW_RATING_TBL B WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_RATING_MDL_TBL WHERE RATING_MODEL = A.RATING_MODEL AND EFFDT <= %CurrentDateIn) AND A.RATING_MODEL = B.RATING_MODEL AND A.EFFDT = B.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model

2 REVIEW_POINTS Number(3,0) SMALLINT NOT NULL Review Points

3 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Rating Model
2	REVIEW_POINTS	Number(3,0)	SMALLINT NOT NULL	Review Points
3	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating