LM_LRQ_ATVL_LVW (SQL View)	Index Back
Atrribute Value Leaning request Atrribute Value

LM_LRQ_ATVL_LVW

(SQL View)

Atrribute Value

Leaning request Atrribute Value

SELECT DISTINCT LM_LRQ_ATTR_ID ,LANGUAGE_CD , LM_LRQ_ATTR_CODE , LM_LRQ_ATTR_VALUE FROM PS_LM_LRQCR_FR_LNG A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_LM_LRQCR_FR_LNG B WHERE B.EFFDT <= %CurrentDateIn AND B.LM_LRQ_ATTR_ID = A.LM_LRQ_ATTR_ID AND B.LANGUAGE_CD=A.LANGUAGE_CD)

Related Language Record for LM_LRQ_AT_VL_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_LRQ_ATTR_ID Number(3,0) SMALLINT NOT NULL Learning Request ID

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

3 LM_LRQ_ATTR_CODE Character(25) VARCHAR2(25) NOT NULL Criteria

4 LM_LRQ_ATTR_VALUE Character(50) VARCHAR2(50) NOT NULL Learning Request Criteria Value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_LRQ_ATTR_ID	Number(3,0)	SMALLINT NOT NULL	Learning Request ID
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	LM_LRQ_ATTR_CODE	Character(25)	VARCHAR2(25) NOT NULL	Criteria
4	LM_LRQ_ATTR_VALUE	Character(50)	VARCHAR2(50) NOT NULL	Learning Request Criteria Value