HRS_SCRQST_TAO (SQL Table)	Index Back
Screening question temp Stores job opening screening requirements related to questions and answers.

HRS_SCRQST_TAO

(SQL Table)

Screening question temp

Stores job opening screening requirements related to questions and answers.

Parent record: HRS_JO_SCR_SM_I

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 HRS_JO_SCR_SUMM_ID Number(15,0) DECIMAL(15) NOT NULL JO Screening Summary ID
Prompt Table: HRS_JO_SCR_SM_I

3 HRS_JO_SCR_SEQ Number(3,0) SMALLINT NOT NULL Job opening screening sequence
Prompt Table: HRS_JO_SCR_LV_I

4 HRS_QSTN_ID Number(15,0) DECIMAL(15) NOT NULL Question ID
Prompt Table: HRS_JO_QSTN_I

5 HRS_ANSWER_ID Number(15,0) DECIMAL(15) NOT NULL Answer ID

6 POINTS Signed Number(5,0) DECIMAL(4) NOT NULL Points

7 HRS_JO_SCR_REQD Character(1) VARCHAR2(1) NOT NULL Job Opening Screening Requirement Required
Y/N Table Edit
Default Value: N

8 HRS_JO_SCR_AUGMENT Character(1) VARCHAR2(1) NOT NULL Augmentation factor
Y/N Table Edit
Default Value: N

9 HRS_JO_SCR_SELECT Character(1) VARCHAR2(1) NOT NULL Selective factor
Y/N Table Edit
Default Value: N

10 CORRECT_ANSWER Character(1) VARCHAR2(1) NOT NULL Indicates which answer in a set associated to a question is the correct answer and is also used to indicate which answer an applicant has provided to a question. Used in the online questionairre transaction as part of the apply online process.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	HRS_JO_SCR_SUMM_ID	Number(15,0)	DECIMAL(15) NOT NULL	JO Screening Summary ID Prompt Table: HRS_JO_SCR_SM_I
3	HRS_JO_SCR_SEQ	Number(3,0)	SMALLINT NOT NULL	Job opening screening sequence Prompt Table: HRS_JO_SCR_LV_I
4	HRS_QSTN_ID	Number(15,0)	DECIMAL(15) NOT NULL	Question ID Prompt Table: HRS_JO_QSTN_I
5	HRS_ANSWER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Answer ID
6	POINTS	Signed Number(5,0)	DECIMAL(4) NOT NULL	Points
7	HRS_JO_SCR_REQD	Character(1)	VARCHAR2(1) NOT NULL	Job Opening Screening Requirement Required Y/N Table Edit Default Value: N
8	HRS_JO_SCR_AUGMENT	Character(1)	VARCHAR2(1) NOT NULL	Augmentation factor Y/N Table Edit Default Value: N
9	HRS_JO_SCR_SELECT	Character(1)	VARCHAR2(1) NOT NULL	Selective factor Y/N Table Edit Default Value: N
10	CORRECT_ANSWER	Character(1)	VARCHAR2(1) NOT NULL	Indicates which answer in a set associated to a question is the correct answer and is also used to indicate which answer an applicant has provided to a question. Used in the online questionairre transaction as part of the apply online process.