HR_RW_HOME_VW(SQL View) |
Index Back |
|---|---|
HR_RW_HOME_VW |
| SELECT EMPLID ,EMPL_RCD ,HR_RW_TYPE ,HR_RW_LOC_TYPE ,STATE ,COUNTRY FROM PS_HR_RWORK_TBL R WHERE HR_RW_LOC_TYPE='H' AND (R.START_DATE=( SELECT MAX(START_DATE) FROM PS_HR_RWORK_TBL R1 WHERE R.EMPLID=R1.EMPLID AND R.EMPL_RCD=R1.EMPL_RCD AND R1.START_DATE <= %CurrentDateIn) ) AND (R.END_DATE IS NULL OR R.END_DATE >= %CurrentDateIn ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | HR_RW_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Remote Worker Type(Fully remote/Hybrid)
F=Fully Remote H=Hybrid |
| 4 | HR_RW_LOC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Remote Worker Location Type
H=Home O=Other W=Workplace |
| 5 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 6 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |