HRS_JOB_OPENING_IDPrompt Table: HRS_JO_I
HRS_QSTN_IDPrompt Table: HRS_QSTN_I
HRS_JO_EQST_NO1(SQL View) |
Index Back |
|---|---|
Non Open Ended Scrn questionsCandidate Experience version of job opening screening question requirements interface. Used for panel processor to eliminate fields required. |
| SELECT DISTINCT A.HRS_JOB_OPENING_ID , A.HRS_QSTN_ID FROM PS_HRS_JO_EMP_QSTN A , PS_HRS_QSTN_TBL B WHERE A.HRS_QSTN_ID = B.HRS_QSTN_ID |
| # | 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 |