LM_MANAGER_IDPrompt Table: LM_PERSON
LM_MSS_TEAM_VW(SQL View) |
Index Back |
|---|---|
Person Manager ViewContains all the Active Internal People in the System and their Manager's Person ID |
| SELECT DISTINCT A.LM_MANAGER_ID , A.LM_PERSON_ID , A.LM_EMPL_RCD ,B.LM_NAME_DISPLAY ,A.LM_JOB_TITLE ,C.LM_ORG_DESCR ,C.LM_ORG_TYPE ,A.LM_JOB_TITLE ,D.LM_JOBCODE_ID FROM PS_LM_PERSON_ATTRB A , PS_LM_PERS_NAME_VW B , PS_LM_ORG_VW C , PS_LM_MULTI_JOB_VW D WHERE %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT AND A.LM_MANAGER_ID <> 0 AND A.LM_ACTIVE = 'Y' AND A.LM_PERSON_ID = B.LM_PERSON_ID AND A.LM_ORGANIZATION_ID = C.LM_ORGANIZATION_ID AND A.LM_PERSON_ID = D.LM_PERSON_ID AND (D.LM_JOB_INDICATOR='P' OR (D.LM_EMPL_RCD=( SELECT MIN(E.LM_EMPL_RCD) FROM PS_LM_MULTI_JOB_VW E WHERE E.LM_PERSON_ID=D.LM_PERSON_ID) AND NOT EXISTS ( SELECT 'X' FROM PS_LM_MULTI_JOB_VW F WHERE F.LM_PERSON_ID=D.LM_PERSON_ID AND F.LM_JOB_INDICATOR='P'))) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_MANAGER_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Manager ID |
| 2 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL |
ELM Person ID
Prompt Table: LM_PERSON |
| 3 | LM_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record umber |
| 4 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |
| 5 | LM_JOB_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 6 | LM_ORG_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Customer Description |
| 7 | LM_ORG_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Organization Type |
| 8 | LM_JOBCD_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Job Code Description |
| 9 | LM_JOBCODE_ID | Number(15,0) | DECIMAL(15) NOT NULL | JobCode ID |