NVQ_ELEMENT_VW (SQL View)	Index Back
NVQ Unit Element Detail This view tracks the progress of the employees' elements which are associated with an NVQ Unit. The NVQ Unit and Element data is stored in Profile Management.

NVQ_ELEMENT_VW

(SQL View)

NVQ Unit Element Detail

This view tracks the progress of the employees' elements which are associated with an NVQ Unit. The NVQ Unit and Element data is stored in Profile Management.

SELECT B.EMPLID ,%Substring(C.JPM_CAT_ITEM_ID,1,8) ,A.EFFDT ,%Substring(A.JPM_CAT_ITEM_ID,1,10) ,A.JPM_ITEM_KEY_ID ,A.JPM_PARENT_KEY_ID ,A.JPM_DATE_2 ,A.JPM_DATE_1 ,A.JPM_DATE_3 ,A.JPM_TEXT254_5 FROM PS_JPM_JP_ITEMS A , PS_JPM_PROFILE B , PS_JPM_JP_ITEMS C WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND A.JPM_PROFILE_ID = C.JPM_PROFILE_ID AND A.JPM_PARENT_KEY_ID = C.JPM_ITEM_KEY_ID AND B.JPM_JP_TYPE = ( SELECT JPM_PRI_PERS_TYPE FROM PS_JPM_JP_PRI_TYPE) AND A.JPM_CAT_TYPE = 'NVQ ELEMENT' AND C.JPM_CAT_TYPE = 'NVQ UNIT'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 ELEMENT_CD Character(10) VARCHAR2(10) NOT NULL Element code
Prompt Table: CM_ELEMENT_TBL

5 JPM_ITEM_KEY_ID Number(12,0) DECIMAL(12) NOT NULL Unique identifier of an item within a profile. This is the primary key of profile items. It is a generic autoassigned value (a number). The unique key permits the addition of items that are not inheritently unique. They may have the same effective date, item type, item id, yet differ in a property or other value. The concept of key fields in a profile is a loose term as an object in a profile can have very different needs in identification.

6 JPM_PARENT_KEY_ID Number(12,0) DECIMAL(12) NOT NULL This is the JPM_ITEM_KEY_ID of the item in the profile that is the parent or driving item of the item. Example- a sub competency may have the item key id of the competency as the parent key. It is used to link more than one item together in a profile where a relationship was established.

7 START_DT Date(10) DATE Start Date

8 EXP_DT Date(10) DATE Expected Completion Date

9 COMP_DT Date(10) DATE Completion Date

10 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	ELEMENT_CD	Character(10)	VARCHAR2(10) NOT NULL	Element code Prompt Table: CM_ELEMENT_TBL
5	JPM_ITEM_KEY_ID	Number(12,0)	DECIMAL(12) NOT NULL	Unique identifier of an item within a profile. This is the primary key of profile items. It is a generic autoassigned value (a number). The unique key permits the addition of items that are not inheritently unique. They may have the same effective date, item type, item id, yet differ in a property or other value. The concept of key fields in a profile is a loose term as an object in a profile can have very different needs in identification.
6	JPM_PARENT_KEY_ID	Number(12,0)	DECIMAL(12) NOT NULL	This is the JPM_ITEM_KEY_ID of the item in the profile that is the parent or driving item of the item. Example- a sub competency may have the item key id of the competency as the parent key. It is used to link more than one item together in a profile where a relationship was established.
7	START_DT	Date(10)	DATE	Start Date
8	EXP_DT	Date(10)	DATE	Expected Completion Date
9	COMP_DT	Date(10)	DATE	Completion Date
10	DESCRLONG	Long Character	CLOB	Long Description