LM_PREV_ORG_VW

(SQL View)
Index Back

Learner's Org Update DateTime


SELECT A.LM_PERSON_ID , MAX(B.LM_ROW_MAINT_DTTM) FROM PS_LM_LRNR_ORG_PRV A , PS_LM_PERSON_ATTRB B WHERE %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND (A.LM_MANAGER_ID = B.LM_PERSON_ID OR A.LM_PERSON_ID = B.LM_PERSON_ID) GROUP BY A.LM_PERSON_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
2 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime