LM_PERSON_IDLANGUAGE_CDLM_LGPERSON_LVW(SQL View) |
Index Back |
|---|---|
Person Details ViewContains a Persons Detail fields for Use by Other Modules |
| SELECT A.LM_PERSON_ID , F.LANGUAGE_CD , C.FIRST_NAME , C.LAST_NAME , F.LM_ORG_DESCR , F.LM_ORG_SDESCR , E.LM_ORG_TYPE , ' ' , ' ' , D.LM_JOB_TITLE , A.LM_HR_EMPLID , C.LAST_NAME_SRCH , C.FIRST_NAME_SRCH FROM PS_LM_PERSON A , PS_LM_PERS_NAME_VW C , PS_LM_CURR_JOB_VW D , PS_LM_ORGANIZATION E , PS_LM_ORG_LANG F WHERE D.LM_PERSON_ID = A.LM_PERSON_ID AND %CurrentDateIn BETWEEN D.EFFDT AND D.LM_END_EFFDT AND D.LM_ACTIVE ='Y' AND C.LM_PERSON_ID = A.LM_PERSON_ID AND E.LM_ORGANIZATION_ID = D.LM_ORGANIZATION_ID AND D.EFFDT BETWEEN E.EFFDT AND E.LM_END_EFFDT AND E.EFF_STATUS = 'A' AND E.LM_ORGANIZATION_ID = F.LM_ORGANIZATION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 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_ORG_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Customer Description |
| 6 | LM_ORG_SDESCR | Character(10) | VARCHAR2(10) NOT NULL | Organization Short Description |
| 7 | LM_ORG_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Organization Type |
| 8 | LM_MGR_FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Manager First Name |
| 9 | LM_MGR_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Manager Last Name |
| 10 | LM_JOB_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 11 | LM_HR_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | EMPLID from the HR System |
| 12 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 13 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |