HRS_SCR_CMP_PTS(SQL View) |
Index Back |
|---|
| SELECT hrs_jo_scr_summ_id , hrs_jo_scr_seq ,COMPETENCY ,MAX(POINTS) FROM PS_HRS_JO_SCR_CMPP GROUP BY hrs_jo_scr_summ_id ,hrs_jo_scr_seq ,competency |
| # | 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 | COMPETENCY | Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 4 | POINTS | Number(4,0) | SMALLINT NOT NULL | Points |