HRS_JO_QST_OO_I (SQL View)	Index Back
Open Ended Scrn questions Candidate Experience version of job opening screening question requirements interface. Used for panel processor to eliminate fields required.

HRS_JO_QST_OO_I

(SQL View)

Open Ended Scrn questions

Candidate Experience version of job opening screening question requirements interface. Used for panel processor to eliminate fields required.

SELECT DISTINCT A.HRS_JOB_OPENING_ID , A.HRS_QSTN_ID , B.HRS_OPN_ENDED_QSTN , 'N' FROM PS_HRS_JO_QSTN A , PS_HRS_QSTN_TBL B WHERE A.HRS_QSTN_ID = B.HRS_QSTN_ID UNION SELECT DISTINCT A.HRS_JOB_OPENING_ID , A.HRS_QSTN_ID , B.HRS_OPN_ENDED_QSTN , 'Y' FROM PS_HRS_JO_EMP_QSTN A , PS_HRS_QSTN_TBL B WHERE A.HRS_QSTN_ID = B.HRS_QSTN_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
Prompt Table: HRS_JO_I

2 HRS_QSTN_ID Number(15,0) DECIMAL(15) NOT NULL Question ID
Prompt Table: HRS_QSTN_I

3 HRS_OPN_ENDED_QSTN Character(1) VARCHAR2(1) NOT NULL Open Ended Questions

4 HRS_EMPL_QUES Character(1) VARCHAR2(1) NOT NULL Question Type
N=No
Y=Yes

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_JOB_OPENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone Prompt Table: HRS_JO_I
2	HRS_QSTN_ID	Number(15,0)	DECIMAL(15) NOT NULL	Question ID Prompt Table: HRS_QSTN_I
3	HRS_OPN_ENDED_QSTN	Character(1)	VARCHAR2(1) NOT NULL	Open Ended Questions
4	HRS_EMPL_QUES	Character(1)	VARCHAR2(1) NOT NULL	Question Type N=No Y=Yes