LM_POSMGR_VW(SQL View) |
Index Back |
|---|---|
ELM |
| SELECT d.lm_hr_emplid , a.lm_person_id , a.lm_position_nbr FROM PS_LM_PERSON_JOB a ,ps_lm_person d WHERE a.effdt=( SELECT MAX(effdt) FROM PS_LM_PERSON_JOB b WHERE a.lm_person_id=b.lm_person_id) AND a.lm_effseq=( SELECT MAX(lm_effseq) FROM PS_LM_PERSON_JOB c WHERE c.lm_person_id=a.lm_person_id AND a.effdt=c.effdt) AND a.lm_person_id=d.lm_person_id AND a.lm_active='Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_HR_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | EMPLID from the HR System |
| 2 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 3 | LM_POSITION_NBR | Character(15) | VARCHAR2(15) NOT NULL | Position Number |