HRS_JO_SCR_SUMM_IDHRS_JO_SCR_SEQCOMPETENCYHRS_JOSCR_CPM_I(SQL View) |
Index Back |
|---|
| SELECT B.HRS_JO_SCR_SUMM_ID , B.HRS_JO_SCR_SEQ , B.COMPETENCY , MAX(B.POINTS) POINTS FROM PS_HRS_JO_SCR_CM_I A , PS_HRS_JO_SCR_CP_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.COMPETENCY = B.COMPETENCY AND A.HRS_JO_SCR_AUGMENT <> 'Y' AND HRS_JO_SCR_SELECT <> 'Y' GROUP BY B.HRS_JO_SCR_SUMM_ID, B.HRS_JO_SCR_SEQ, B.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 |