HRS_APPITM05LVW (SQL View)	Index Back
App Cont Items Lng w JPM Intgr Related Language View Used if JPM Integration is on, gets all searchable content items for applicant regardless of sequence number. Used by Profile Match to derive which content items are included in the verity search collection.

HRS_APPITM05LVW

(SQL View)

App Cont Items Lng w JPM Intgr

Related Language View Used if JPM Integration is on, gets all searchable content items for applicant regardless of sequence number. Used by Profile Match to derive which content items are included in the verity search collection.

SELECT DISTINCT APPITM.HRS_PERSON_ID , APPITM.JPM_CAT_TYPE , APPITM.JPM_CAT_ITEM_ID , APPITM.JPM_CAT_ITEM_QUAL , APPITM.JPM_CAT_ITEM_QUAL2 , JPMITML.LANGUAGE_CD , JPMITML.JPM_DESCR90 FROM PS_HRS_APP_ITEMS APPITM , PS_JPM_CAT_ITEMS_I JPMITM , PS_HRS_SCT_CFG_VW HRSCTCFG , PS_JPM_PRI_P_PRP_I JPRIPRP , PS_JPM_CAT_ITM_LNG JPMITML WHERE JPMITM.JPM_CAT_TYPE = APPITM.JPM_CAT_TYPE AND JPMITM.JPM_CAT_ITEM_ID = APPITM.JPM_CAT_ITEM_ID AND %EffdtCheck(JPM_CAT_ITEMS_I JPMITM1, JPMITM, %CurrentDateIn) AND JPMITM.EFF_STATUS = 'A' AND JPRIPRP.JPM_JP_SRCH_FLG = 'Y' AND JPRIPRP.JPM_JP_TYPE = HRSCTCFG.JPM_JP_TYPE AND JPRIPRP.JPM_CAT_TYPE = HRSCTCFG.JPM_CAT_TYPE AND APPITM.JPM_CAT_TYPE = JPRIPRP.JPM_CAT_TYPE AND JPMITML.JPM_CAT_TYPE = JPMITM.JPM_CAT_TYPE AND JPMITML.JPM_CAT_ITEM_ID = JPMITM.JPM_CAT_ITEM_ID

Related Language Record for HRS_APPITM05_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
Prompt Table: HRS_APPLICANT

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.
Prompt Table: JPM_CAT_ITEMS

4 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).

5 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).

6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

7 JPM_DESCR90 Character(90) VARCHAR2(90) NOT NULL jpm

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id Prompt Table: HRS_APPLICANT
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. Prompt Table: JPM_CAT_ITEMS
4	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).
5	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).
6	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
7	JPM_DESCR90	Character(90)	VARCHAR2(90) NOT NULL	jpm