OPRIDLM_MANAGER_IDLM_PERSON_IDPrompt Table: LM_PERS_NAME_VW
LM_LPLN_ENR_LRN(SQL View) |
Index Back |
|---|---|
Learning Plan Enroll LearnersThis view is used whent the Learning Plan component is used for enrollment. |
| SELECT OPR.OPRID , 0 , ADM.LM_PERSON_ID , ADM.LM_HR_EMPLID , ADM.FIRST_NAME , ADM.LAST_NAME , ADM.LM_NAME_DISPLAY , ADM.LM_ORGANIZATION_ID , ADM.LM_JOB_TITLE , ADM.LM_JOBCODE_ID , ADM.LM_HIRE_DT , ADM.LM_ORG_TYPE FROM PS_LM_PERS_ADTL_VW ADM , PS_LM_OPRID_ID_VW OPR WHERE ADM.LM_PERSON_ID = OPR.LM_PERSON_ID AND NOT EXISTS ( SELECT 1 FROM PS_LM_MGR_SRCH_VW MGRX WHERE MGRX.LM_PERSON_ID = ADM.LM_PERSON_ID) UNION SELECT MGR.OPRID , MGR.LM_MANAGER_ID , MGR.LM_PERSON_ID , DTL.LM_HR_EMPLID , DTL.FIRST_NAME , DTL.LAST_NAME , DTL.LM_NAME_DISPLAY , DTL.LM_ORGANIZATION_ID , DTL.LM_JOB_TITLE , DTL.LM_JOBCODE_ID , DTL.LM_HIRE_DT , DTL.LM_ORG_TYPE FROM PS_LM_MGR_SRCH_VW MGR , PS_LM_PERS_DTL_VW DTL WHERE MGR.LM_PERSON_ID = DTL.LM_PERSON_ID AND DTL.LM_ACTIVE = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | LM_MANAGER_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Manager ID |
| 3 | LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
ELM Person ID
Prompt Table: LM_PERS_NAME_VW |
| 4 | LM_HR_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | EMPLID from the HR System |
| 5 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name field |
| 6 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name Field |
| 7 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |
| 8 | LM_ORGANIZATION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Organization ID |
| 9 | LM_JOB_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 10 | LM_JOBCODE_ID | Number(15,0) | DECIMAL(15) NOT NULL | JobCode ID |
| 11 | LM_HIRE_DT | Date(10) | DATE | Hire Date |
| 12 | LM_ORG_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Organization Type |