HRS_ITEM_SCORE

(SQL View)
Index Back

HRS Search Results

Clone of JPM_ITEM_SCORE used by profile match compare results page

SELECT ' ' ,0 ,0 , ' ' ,' ' ,0 FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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.
2 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
3 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
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_PCT_MATCH Number(3,0) SMALLINT NOT NULL Percentage of the content that match