HRS_PERSON_IDHRS_LST_IDHRS_JOB_OPENING_IDHRS_PER_SVDJOBS(SQL View) |
Index Back |
|---|---|
search saved jobs by personCandidate gateway person has saved jobs , this will list them |
| SELECT A.hrs_jobbas_owner , A.HRS_LST_ID , B.HRS_JOB_OPENING_ID FROM PS_HRS_LIST A , PS_HRS_LIST_JOB B WHERE a.HRS_LST_TYPE = 'JOBS' AND a.HRS_LST_ID = b.HRS_LST_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | HRS_LST_ID |
Number(15,0) | DECIMAL(15) NOT NULL | List ID |
| 3 | HRS_JOB_OPENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |