LM_PERS_REH_VW(SQL View) |
Index Back |
|---|---|
Person Rehire ViewPerson Rehire View |
| SELECT A.LM_PERSON_ID , A.LM_EMPL_RCD , A.EFFDT , A.LM_END_EFFDT , A.LM_LE_ID , A.LM_HIRE_DT , C.EFFDT , A.LM_ORGANIZATION_ID , A.LM_ACTIVE , A.LM_JOBCODE_ID , A.LM_JOB_TITLE , A.LM_POSITION_NBR , A.BUSINESS_UNIT , A.CURRENCY_CD , A.LM_EMPL_TYPE , A.LM_FULL_PART_TIME , A.LM_JOB_INDICATOR , A.LM_PO_ID , A.LM_TU_POOL_ID , A.LM_PER_ORG , A.LM_MANAGER_ID , A.LM_HR_COMPANY , A.LM_LOCATION_ID FROM PS_LM_CURR_JOB_VW A , PS_LM_JOBCODE_TBL B ,PS_LM_PERSON_JOB C WHERE %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT AND A.EFFDT BETWEEN B.EFFDT AND B.LM_END_EFFDT AND A.LM_JOBCODE_ID = B.LM_JOBCODE_ID AND A.LM_JOB_INDICATOR = 'P' AND A.LM_ACTIVE = 'Y' AND C.LM_ACTION='REH' AND A.LM_PERSON_ID=C.LM_PERSON_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 | LM_EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record umber
Default Value: 0 |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | LM_END_EFFDT | Date(10) | DATE | The end effective date, automatically maintained, there's a doc on how this works, so read it |
| 5 | LM_LE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Environment ID - System Generated number |
| 6 | LM_HIRE_DT | Date(10) | DATE | Hire Date |
| 7 | LM_REHIRE_DT | Date(10) | DATE | Rehire Date Field currently not used, reserved for future functionality |
| 8 | LM_ORGANIZATION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Organization ID |
| 9 | LM_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Active
N=Inactive Y=Active |
| 10 | LM_JOBCODE_ID | Number(15,0) | DECIMAL(15) NOT NULL | JobCode ID |
| 11 | LM_JOB_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 12 | LM_POSITION_NBR | Character(15) | VARCHAR2(15) NOT NULL | Position Number |
| 13 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 15 | LM_EMPL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly H=Hourly N=Not Applicable S=Salaried |
| 16 | LM_FULL_PART_TIME | Character(1) | VARCHAR2(1) NOT NULL |
Full Time/Part Time
F=Full-Time P=Part-Time |
| 17 | LM_JOB_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Primary Job Indicator
N=Not Applicable P=Primary Job S=Secondary Job |
| 18 | LM_PO_ID | Number(10,0) | DECIMAL(10) NOT NULL | Purchase Order Id. Unique key for purchase orders. |
| 19 | LM_TU_POOL_ID | Number(10,0) | DECIMAL(10) NOT NULL | Training Unit Pool No. Unique key for Training Unit Pool Record. |
| 20 | 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 |
| 21 | LM_MANAGER_ID | Number(15,0) | DECIMAL(15) NOT NULL | Manager ID |
| 22 | LM_HR_COMPANY | Character(3) | VARCHAR2(3) NOT NULL | HR's Company ID brought over during synchronization. |
| 23 | LM_LOCATION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Location Id |