HRS_JOB_OPENING_IDPrompt Table: HRS_JO_I
HRS_QSTN_IDPrompt Table: HRS_QSTN_I
HRS_CE_JO_QS_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.HRS_JOB_OPENING_ID , A.HRS_QSTN_ID FROM PS_HRS_JO_QSTN A WHERE A.HRS_QSTN_ID IN ( SELECT HRS_QSTN_ID FROM PS_HRS_QSTN_TBL WHERE HRS_QSTN_TYPE <> '90') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_JOB_OPENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Job Opening Clone
Prompt Table: HRS_JO_I |
| 2 | HRS_QSTN_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Question ID
Prompt Table: HRS_QSTN_I |