LM_PERSON_IDPrompt Table: LM_PERS_NAME_VW
N=Inactive
Y=Active
LM_PERS_DTL_VW1(SQL View) |
Index Back |
|---|---|
Person Details ViewContains a Persons Detail fields for Use by Other Modules |
| SELECT A.LM_PERSON_ID , A.LM_HR_EMPLID , D.FIRST_NAME , D.LAST_NAME , D.LM_NAME_DISPLAY , B.LM_ORGANIZATION_ID , E.LM_ORG_DESCR , E.LM_ORG_SDESCR , 0 , B.LM_JOB_TITLE , B.LM_JOBCODE_ID , B.LM_POSITION_NBR , B.BUSINESS_UNIT , B.LM_HIRE_DT , E.LM_ORG_TYPE , B.LM_ACTIVE FROM PS_LM_PERSON A , PS_LM_CURR_JOB_VW B , PS_LM_PERSON_NAME D , PS_LM_ORGANIZATION E WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND D.LM_PERSON_ID = A.LM_PERSON_ID AND D.LM_DISPLAY_FLAG = 'Y' AND %CurrentDateIn BETWEEN D.EFFDT AND D.LM_END_EFFDT AND E.LM_ORGANIZATION_ID = B.LM_ORGANIZATION_ID AND %CurrentDateIn BETWEEN E.EFFDT AND E.LM_END_EFFDT AND E.EFF_STATUS = 'A' AND ((D.LM_NAME_TYPE = 'PRF') OR (D.LM_NAME_TYPE = 'PRI' AND NOT EXISTS ( SELECT P.LM_NAME_TYPE FROM PS_LM_PERSON_NAME P WHERE P.LM_PERSON_ID = D.LM_PERSON_ID AND P.LM_NAME_TYPE = 'PRF' AND %CurrentDateIn BETWEEN P.EFFDT AND P.LM_END_EFFDT) )) |
| # | 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_PERS_NAME_VW |
| 2 | LM_HR_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | EMPLID from the HR System |
| 3 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name field |
| 4 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name Field |
| 5 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |
| 6 | LM_ORGANIZATION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Organization ID |
| 7 | LM_ORG_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Customer Description |
| 8 | LM_ORG_SDESCR | Character(10) | VARCHAR2(10) NOT NULL | Organization Short Description |
| 9 | LM_MANAGER_ID | Number(15,0) | DECIMAL(15) NOT NULL | Manager ID |
| 10 | LM_JOB_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 11 | LM_JOBCODE_ID | Number(15,0) | DECIMAL(15) NOT NULL | JobCode ID |
| 12 | LM_POSITION_NBR | Character(15) | VARCHAR2(15) NOT NULL | Position Number |
| 13 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 14 | LM_HIRE_DT | Date(10) | DATE | Hire Date |
| 15 | LM_ORG_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Organization Type |
| 16 | LM_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Active
N=Inactive Y=Active |