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

HRS_JO_SCYN_TMP

(SQL Table)

Job Opening Screening Temp Rec

Temporary record for job opening screening criteria setup for competencies

# 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
45=Employment Question
50=Screening Question

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

3 YESNO_DROPDOWN Character(1) VARCHAR2(1) NOT NULL This field is to be used on panels that require a drop-down list for a Yes/No choice, rather than a checkbox.
N=No
Y=Yes

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

#	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 45=Employment Question 50=Screening Question
2	HRS_JO_SCR_RQMT	Character(10)	VARCHAR2(10) NOT NULL	Screening Criteria Requirement
3	YESNO_DROPDOWN	Character(1)	VARCHAR2(1) NOT NULL	This field is to be used on panels that require a drop-down list for a Yes/No choice, rather than a checkbox. N=No Y=Yes
4	HRS_POINTS	Signed Number(5,0)	DECIMAL(4) NOT NULL	Default points assigned to an answer.