HRS_BIP_APITMVW (SQL View)	Index Back
Applicant Profile Items. Person Profile Content Items for a particular Applicant and Application

HRS_BIP_APITMVW

(SQL View)

Applicant Profile Items.

Person Profile Content Items for a particular Applicant and Application

SELECT A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , A.JPM_PROFILE_ID , A.JPM_CAT_TYPE , A.JPM_CAT_ITEM_ID , A.JPM_CAT_ITEM_QUAL , A.JPM_CAT_ITEM_QUAL2 FROM PS_HRS_APP_ITEMS A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id

2 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece

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

5 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_ITMS_V2

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

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).
Prompt Table: %EDITTABLE3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
2	HRS_PROFILE_SEQ	Number(3,0)	SMALLINT NOT NULL	Profile sequece
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. Prompt Table: JPM_CAT_TYPE_VW
5	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_ITMS_V2
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). Prompt Table: JPM_JP_QUAL_INS
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). Prompt Table: %EDITTABLE3