LM_PERS_ORG_VW

(SQL View)
 Index Back

HR Persone department

This view returns HR info for a learner

SELECT B.LM_PERSON_ID , B.LM_EMPL_RCD , A.LM_HR_EMPLID , B.LM_ORGANIZATION_ID , C.LM_HR_DEPTID , C.LM_HR_SETID FROM PS_LM_PERSON A , PS_LM_PERSON_JOB B , PS_LM_ORGANIZATION C WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND B.LM_ACTIVE = 'Y' AND C.LM_ORGANIZATION_ID = B.LM_ORGANIZATION_ID AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT AND C.EFF_STATUS = 'A'

# 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_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record umber
3 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System
4 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID

Prompt Table: %EDITTABLE

5 LM_HR_DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: LM_DEPT_CF_VW

6 LM_HR_SETID Character(5) VARCHAR2(5) NOT NULL SetID