HRS_OWNER_IDSEARCH_NAMEHRS_JOB_OPENING_IDPrompt Table: HRS_JOB_OPENING
HRS_SRCH_PSTTIT(SQL View) |
Index Back |
|---|---|
Posting TitlesSearch Module Posting titles for associated job openings |
| SELECT B.HRS_OWNER_ID , B.SEARCH_NAME , B.HRS_JOB_OPENING_ID , A.POSTING_TITLE FROM PS_HRS_JO_I A , PS_HRS_SRCH_RSLTJO B WHERE B.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_OWNER_ID |
Character(11) | VARCHAR2(11) NOT NULL | Owner ID |
| 2 | SEARCH_NAME |
Character(20) | VARCHAR2(20) NOT NULL | Stored Search Name |
| 3 | HRS_JOB_OPENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Job Opening Clone
Prompt Table: HRS_JOB_OPENING |
| 4 | POSTING_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Job posting title |