JPM_ITEM_SCORE

(SQL View)
Index Back

JPM Search Results


SELECT ' ' , ' ' ,' ' ,0 FROM PS_PERSON

# 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 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.
3 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
4 JPM_PCT_MATCH Number(3,0) SMALLINT NOT NULL Score