HRS_SCR_QST_PTS(SQL View) |
Index Back |
|---|
| SELECT hrs_jo_scr_summ_id , hrs_jo_scr_seq ,HRS_QSTN_ID ,MAX(HRS_POINTS) FROM PS_HRS_JO_SCR_QSNP GROUP BY hrs_jo_scr_summ_id ,hrs_jo_scr_seq ,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. |