LM_JOB_MGR_VW

(SQL View)
Index Back

Person's Job Manager

Contains all the Active Internal People in the System and their Manager's Person ID based on the job

SELECT LM_PERSON_ID , LM_EMPL_RCD , LM_MANAGER_ID FROM PS_LM_PERSON_ATTRB WHERE %CurrentDateIn BETWEEN EFFDT AND LM_END_EFFDT AND LM_MANAGER_ID<>0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

Prompt Table: LM_PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID