HRS_JOUNEVAL_VW

(SQL View)
 Index Back

Unevaluated Answers

Open Ended Questions -- Unevaluated Answers

SELECT DISTINCT PTS.HRS_PERSON_ID , PTS.HRS_PROFILE_SEQ , PTS.HRS_JOB_OPENING_ID , PTS.EMPLID , PTS.HRS_QSTN_ID , JOT.EMPLID , ANS.HRS_REF_NUM_LONG , ANS.HRS_DELETE_REQ , PTS.HRS_OE_ANS_PTS , ANS.HRS_ROW_ADD_DTTM , ANS.HRS_ROW_ADD_OPRID , ANS.HRS_ROW_UPD_DTTM , ANS.HRS_ROW_UPD_OPRID FROM PS_HRS_APP_OPN_ANS ANS , PS_HRS_APP_OPN_PTS PTS , PS_HRS_JO_TEAM_I JOT WHERE ANS.HRS_PERSON_ID = PTS.HRS_PERSON_ID AND ANS.HRS_PROFILE_SEQ = PTS.HRS_PROFILE_SEQ AND ANS.HRS_JOB_OPENING_ID = PTS.HRS_JOB_OPENING_ID AND ANS.HRS_QSTN_ID = PTS.HRS_QSTN_ID AND PTS.HRS_EVALUATED_ANS <> 'Y' AND ANS.HRS_JOB_OPENING_ID = JOT.HRS_JOB_OPENING_ID

# 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_APP_NAME_I

2 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece

Prompt Table: HRS_APP_PROF_I

3 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: HRS_ACT_PERS_I

5 HRS_QSTN_ID Number(15,0) DECIMAL(15) NOT NULL Question ID

Prompt Table: HRS_QSTN_TBL

6 RECRUITER_ID Character(11) VARCHAR2(11) NOT NULL Recruiter ID

Prompt Table: HRS_ACT_RCTR_I

7 HRS_REF_NUM_LONG Character(30) VARCHAR2(30) NOT NULL reference number
8 HRS_DELETE_REQ Character(1) VARCHAR2(1) NOT NULL To indicate if the delete request has been made
9 HRS_OE_ANS_PTS Character(3) VARCHAR2(3) NOT NULL To indicate the score to be given by evaluator to an answer to open-ended question
10 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
11 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
12 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
13 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id