SETID_JOBCODEJOBCODEEFFDTDefault Value: %date
N=No
Y=Yes
HR_RW_JOB_EL_VW(SQL View) |
Index Back |
|---|---|
Remote Worker Job EligibilityRemote Worker Job Eligibility |
| SELECT JCODE.SETID , JCODE.JOBCODE ,JCODE.EFFDT , JCODE.DESCR , CASE WHEN JCODE.AVAIL_TELEWORK ='Y' THEN 'Y' ELSE 'N' END FROM PS_JOBCODE_TBL JCODE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID_JOBCODE |
Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 2 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | JOBCODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Code Description |
| 5 | HR_RW_JOB_ELIGIBLE | Character(1) | VARCHAR2(1) NOT NULL |
Job Code Available for RemoteWork
N=No Y=Yes |