HCTS_RATNGM_LVW (SQL View)	Index Back
Career/Competencies Link Shows 'PSCM' ratings only

HCTS_RATNGM_LVW

(SQL View)

Career/Competencies Link

Shows 'PSCM' ratings only

SELECT RATING_MODEL ,LANGUAGE_CD ,DESCR FROM PS_RATING_MDL_LANG A WHERE %EffdtCheck(RATING_MDL_LANG B, A, %CurrentDateIn)

Related Language Record for HCTS_RATINGM_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Rating Model
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description