HRS_JO_SCR_YN_I (SQL View)	Index Back
JO Qstn Scr Criteria Intfc Interface for job opening screening JPM YesNo Points for screening criteria.

HRS_JO_SCR_YN_I

(SQL View)

JO Qstn Scr Criteria Intfc

Interface for job opening screening JPM YesNo Points for screening criteria.

SELECT A.HRS_JO_SCR_SUMM_ID , A.HRS_JO_SCR_SEQ , A.JPM_PROFILE_ID , A.JPM_CAT_TYPE , A.JPM_CAT_ITEM_ID , A.JPM_CAT_ITEM_QUAL , A.JPM_CAT_ITEM_QUAL2 , A.FIELDNAME , A.YESNO_DROPDOWN , A.EFFDT , A.HRS_POINTS , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_JO_SCR_YNP A

Parent record: HRS_JO_SCR_LV_I

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 JPM_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.

4 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.

5 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.

6 JPM_CAT_ITEM_QUAL Character(12) VARCHAR2(12) NOT NULL Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).

7 JPM_CAT_ITEM_QUAL2 Character(12) VARCHAR2(12) NOT NULL Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).

8 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

9 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

10 EFFDT Date(10) DATE Effective Date
Default Value: %date

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

12 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime

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

14 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime

15 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_JO_SCR_SUMM_ID	Number(15,0)	DECIMAL(15) NOT NULL	JO Screening Summary ID Prompt Table: HRS_JO_SCR_SM_I
2	HRS_JO_SCR_SEQ	Number(3,0)	SMALLINT NOT NULL	Job opening screening sequence Prompt Table: HRS_JO_SCR_LV_I
3	JPM_PROFILE_ID	Character(12)	VARCHAR2(12) NOT NULL	The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
4	JPM_CAT_TYPE	Character(12)	VARCHAR2(12) NOT NULL	The name of the type of items that will be used in a Catalog and or in a Profile.
5	JPM_CAT_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
6	JPM_CAT_ITEM_QUAL	Character(12)	VARCHAR2(12) NOT NULL	Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).
7	JPM_CAT_ITEM_QUAL2	Character(12)	VARCHAR2(12) NOT NULL	Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).
8	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
9	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
10	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
11	POINTS	Signed Number(5,0)	DECIMAL(4) NOT NULL	Points
12	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
13	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
14	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
15	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id