LM_JOB_MGR_VW(SQL View) |
Index Back |
---|---|
Person's Job ManagerContains 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 |