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

LM_LRQ_AT_VL_VW

(SQL View)

Atrribute Value

Leaning request Atrribute Value

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

Related Language Record: LM_LRQ_ATVL_LVW

# 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 LM_LRQ_ATTR_CODE Character(25) VARCHAR2(25) NOT NULL Criteria

3 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	LM_LRQ_ATTR_CODE	Character(25)	VARCHAR2(25) NOT NULL	Criteria
3	LM_LRQ_ATTR_VALUE	Character(50)	VARCHAR2(50) NOT NULL	Learning Request Criteria Value