HRS_EVAL_SCR_VW(SQL View) |
Index Back |
---|---|
Interview EvaluationsInterview Evaluation Record |
SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , A.HRS_RCM_INT_ID ,A.HRS_EVAL_ID , A.HRS_INT_EVL_CTG_ID , A.HRS_INT_EVL_RTG_ID ,B.INTVW_RATING FROM PS_HRS_EVAL_CATG A , PS_HRS_INT_RTG_TBL B WHERE A.HRS_INT_EVL_RTG_ID = B.HRS_INT_EVL_RTG_ID AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_HRS_INT_RTG_TBL C WHERE B.HRS_INT_EVL_RTG_ID = C.HRS_INT_EVL_RTG_ID AND C.EFFDT <= %CurrentDateIn ) AND B.EFF_STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | HRS_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Person Id
Prompt Table: HRS_APPLICANT_I |
2 | HRS_RCMNT_ID | Number(15,0) | DECIMAL(15) NOT NULL |
App Tracking Recruitment ID
Prompt Table: HRS_RCMNT |
3 | HRS_RCM_INT_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Recruitment Interview ID
Prompt Table: HRS_RCM_INT |
4 | HRS_EVAL_ID | Number(15,0) | DECIMAL(15) NOT NULL | Evaluation ID |
5 | HRS_INT_EVL_CTG_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Interview Category ID
Prompt Table: HRS_INT_CTG_TBL |
6 | HRS_INT_EVL_RTG_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Interview Rating
Prompt Table: HRS_INT_RTG_TBL |
7 | INTVW_RATING | Number(2,0) | SMALLINT NOT NULL | Interview Rating |