LM_PERSON_IDCWR=Contingent Worker
EMP=Employee
POI=Person Of Interest
LM_PERS_ADM_VW(SQL View) |
Index Back |
|---|---|
Person Administrative SearchPerson Administrative Search |
| SELECT B.LM_PERSON_ID , B.LM_HR_EMPLID , B.FIRST_NAME , B.LAST_NAME , B.FIRST_NAME_SRCH , B.LAST_NAME_SRCH , B.NAME_AC , C.LM_ORGANIZATION_ID , C.LM_JOB_TITLE , D.LM_ORG_DESCR , D.LM_ORG_TYPE , B.LM_NAME_DISPLAY , B.LM_NAME_TYPE , C.LM_PER_ORG ,C.BUSINESS_UNIT FROM PS_LM_PERS_NAME_VW B , PS_LM_CURR_JOB_VW C , PS_LM_ORGANIZATION D WHERE B.LM_PERSON_ID = C.LM_PERSON_ID AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT AND C.LM_ACTIVE = 'Y' AND D.LM_ORGANIZATION_ID = C.LM_ORGANIZATION_ID AND %CurrentDateIn BETWEEN D.EFFDT AND D.LM_END_EFFDT AND D.EFF_STATUS = 'A' |
| # | 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 | 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 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 6 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 7 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 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_ORG_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Customer Description |
| 11 | LM_ORG_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Organization Type |
| 12 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |
| 13 | LM_NAME_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Name Type |
| 14 | LM_PER_ORG | Character(3) | VARCHAR2(3) NOT NULL |
Persons Organizational Relationship. Brought over from HCM.
CWR=Contingent Worker EMP=Employee POI=Person Of Interest |
| 15 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |