HRS_JO_QST_NO_I (SQL View)	Index Back
Non 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_NO_I

(SQL View)

Non Open Ended Scrn questions

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

SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_RQMT_SEQ , A.HRS_QSTN_ID , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_JO_QSTN_I A WHERE A.HRS_QSTN_ID IN ( SELECT HRS_QSTN_ID FROM PS_HRS_QSTN_TBL WHERE HRS_QSTN_TYPE <> '90')

# 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_JO_RQMT_SEQ Number(3,0) SMALLINT NOT NULL Job opening requirement sequence

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

4 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime

5 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id

6 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime

7 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator 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_JO_RQMT_SEQ	Number(3,0)	SMALLINT NOT NULL	Job opening requirement sequence
3	HRS_QSTN_ID	Number(15,0)	DECIMAL(15) NOT NULL	Question ID Prompt Table: HRS_QSTN_I
4	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
5	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
6	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
7	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id