LM_RTNG_MDL_VW (SQL View)	Index Back
Rating Model for Reviews This table groups different ratings together in order to form one rating model. An example could be school grades 'A' to 'F' as a rating model.

LM_RTNG_MDL_VW

(SQL View)

Rating Model for Reviews

This table groups different ratings together in order to form one rating model. An example could be school grades 'A' to 'F' as a rating model.

SELECT LM_RATING_MODEL , EFFDT , DESCR , EFF_STATUS , LM_END_EFFDT FROM PS_LM_RTNG_MDL_TBL A WHERE %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Used in Competency Sync messages

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

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

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

5 LM_END_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Used in Competency Sync messages
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
5	LM_END_EFFDT	Date(10)	DATE	The end effective date, automatically maintained, there's a doc on how this works, so read it