LM_LRQ_AT_CD_VW (SQL View)	Index Back
Attribute code Leaning request Atrribute code

LM_LRQ_AT_CD_VW

(SQL View)

Attribute code

Leaning request Atrribute code

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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