HRS_JO_SCR_ITMP (SQL Table)	Index Back
JO Comp Pts for Scr Criteria. Job opening competency points for screening criteria.

HRS_JO_SCR_ITMP

(SQL Table)

JO Comp Pts for Scr Criteria.

Job opening competency points for screening criteria.

# 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_SUMM

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

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 HRS_REVIEW_RATING Character(3) VARCHAR2(3) NOT NULL Review Rating
Prompt Table: HRS_RATING_I

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

11 JPM_ITEM_KEY_ID Number(12,0) DECIMAL(12) NOT NULL Unique identifier of an item within a profile. This is the primary key of profile items. It is a generic autoassigned value (a number). The unique key permits the addition of items that are not inheritently unique. They may have the same effective date, item type, item id, yet differ in a property or other value. The concept of key fields in a profile is a loose term as an object in a profile can have very different needs in identification.

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

13 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime

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

15 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime

16 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_SUMM
2	HRS_JO_SCR_SEQ	Number(3,0)	SMALLINT NOT NULL	Job opening screening sequence Prompt Table: HRS_JO_SCR_LVL
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	HRS_REVIEW_RATING	Character(3)	VARCHAR2(3) NOT NULL	Review Rating Prompt Table: HRS_RATING_I
10	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
11	JPM_ITEM_KEY_ID	Number(12,0)	DECIMAL(12) NOT NULL	Unique identifier of an item within a profile. This is the primary key of profile items. It is a generic autoassigned value (a number). The unique key permits the addition of items that are not inheritently unique. They may have the same effective date, item type, item id, yet differ in a property or other value. The concept of key fields in a profile is a loose term as an object in a profile can have very different needs in identification.
12	POINTS	Signed Number(5,0)	DECIMAL(4) NOT NULL	Points
13	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
14	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
15	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
16	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id