LM_PERSON_IDN=Inactive
Y=Active
CWR=Contingent Worker
EMP=Employee
POI=Person Of Interest
LM_PERS_DTLS_VW(SQL View) |
Index Back |
|---|---|
Person DetailsPerson Details for Person Details Page |
| SELECT A.LM_PERSON_ID , B.LM_ACTIVE , B.LM_JOB_TITLE , B.LM_ORGANIZATION_ID , B.LM_LE_ID , B.LM_PER_ORG , A.LM_EXT_PERSON_FLG , B.LM_MANAGER_ID FROM PS_LM_PERSON A , PS_LM_CURR_JOB_VW B WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND %CurrentDateIn BETWEEN B.EFFDT AND B.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 |
| 2 | LM_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Active
N=Inactive Y=Active |
| 3 | LM_JOB_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 4 | LM_ORGANIZATION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Organization ID |
| 5 | LM_LE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Environment ID - System Generated number |
| 6 | 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 |
| 7 | LM_EXT_PERSON_FLG | Character(1) | VARCHAR2(1) NOT NULL | External Person Flag |
| 8 | LM_MANAGER_ID | Number(15,0) | DECIMAL(15) NOT NULL | Manager ID |