HRS_JO_SCR_SUMM_IDHRS_JO_SCR_SEQHRS_JOSCR_QSN_I(SQL View) |
Index Back |
|---|---|
JO Screening question max pts |
| SELECT B.HRS_JO_SCR_SUMM_ID , B.HRS_JO_SCR_SEQ , B.HRS_QSTN_ID , MAX(B.POINTS) HRS_POINTS FROM PS_HRS_JO_SCR_QSTN A , PS_HRS_JO_SCR_QT_I B WHERE A.HRS_JO_SCR_SUMM_ID = B.HRS_JO_SCR_SUMM_ID AND A.HRS_JO_SCR_SEQ = B.HRS_JO_SCR_SEQ AND A.HRS_QSTN_ID = B.HRS_QSTN_ID AND A.HRS_JO_SCR_AUGMENT <> 'Y' AND A.HRS_JO_SCR_SELECT <> 'Y' GROUP BY B.HRS_JO_SCR_SUMM_ID, B.HRS_JO_SCR_SEQ, B.HRS_QSTN_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_JO_SCR_SUMM_ID |
Number(15,0) | DECIMAL(15) NOT NULL | JO Screening Summary ID |
| 2 | HRS_JO_SCR_SEQ |
Number(3,0) | SMALLINT NOT NULL | Job opening screening sequence |
| 3 | HRS_QSTN_ID | Number(15,0) | DECIMAL(15) NOT NULL | Question ID |
| 4 | HRS_POINTS | Signed Number(5,0) | DECIMAL(4) NOT NULL | Default points assigned to an answer. |