HRS_APPITM06LVW (SQL View)	Index Back
App Cont Items Lng no JPM Intg Related Language View Used if JPM Integration is off, gets all content items with field name = 'JPM_CATG_ITEM_ID' applicant regardless of sequence number. Used by Profile Match to derive which content items are included in the verity search collection.

HRS_APPITM06LVW

(SQL View)

App Cont Items Lng no JPM Intg

Related Language View Used if JPM Integration is off, gets all content items with field name = 'JPM_CATG_ITEM_ID' 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_TYPE = HRSCTCFG.JPM_JP_TYPE AND JPRIPRP.JPM_CAT_TYPE = HRSCTCFG.JPM_CAT_TYPE AND JPRIPRP.FIELDNAME = 'JPM_CAT_ITEM_ID' 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_APPITM06_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