HRS_JO_SCRQ_TMP (SQL Table)	Index Back
Job Opening Screening Temp Rec Temporary record for job opening screening criteria setup for questions

HRS_JO_SCRQ_TMP

(SQL Table)

Job Opening Screening Temp Rec

Temporary record for job opening screening criteria setup for questions

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_JO_SCR_TYPE Character(2) VARCHAR2(2) NOT NULL Job opening screening criteria type
10=General Requirement
20=Accomplishment
30=Competency
40=Education & Experience
50=Screening Question

2 HRS_JO_SCR_RQMT Character(10) VARCHAR2(10) NOT NULL Screening Criteria Requirement

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

4 HRS_POINTS Signed Number(5,0) DECIMAL(4) NOT NULL Default points assigned to an answer.

5 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	HRS_JO_SCR_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Job opening screening criteria type 10=General Requirement 20=Accomplishment 30=Competency 40=Education & Experience 50=Screening Question
2	HRS_JO_SCR_RQMT	Character(10)	VARCHAR2(10) NOT NULL	Screening Criteria Requirement
3	HRS_ANSWER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Answer ID
4	HRS_POINTS	Signed Number(5,0)	DECIMAL(4) NOT NULL	Default points assigned to an answer.
5	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.