HRS_EVAL_SCR_VW

(SQL View)
Index Back

Interview Evaluations

Interview 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