NVQ_REVIEW (SQL View)	Index Back
NVQ Review NVQ Review view displays the review information for an NVQ which is stored in Profile Management, but is maintained in NVQ Tracking.

NVQ_REVIEW

(SQL View)

NVQ Review

NVQ Review view displays the review information for an NVQ which is stored in Profile Management, but is maintained in NVQ Tracking.

SELECT B.EMPLID ,%Substring(A.JPM_CAT_ITEM_ID,1,8) ,A.EFFDT ,A.MAJOR_CODE ,A.JPM_DATE_4 ,%Substring(A.JPM_CAT_ITEM_QUAL2,1,11) ,%Substring(A.JPM_CAT_ITEM_QUAL,1,3) ,A.JPM_ITEM_KEY_ID ,A.JPM_TEXT254_5 FROM PS_JPM_JP_ITEMS A , PS_JPM_PROFILE B WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND B.JPM_JP_TYPE = 'PERSON' AND A.JPM_CAT_TYPE = 'NVQ' AND A.JPM_CAT_ITEM_QUAL <> 'ENR' AND A.JPM_ITEM_KEY_ID = ( SELECT MAX(X.JPM_ITEM_KEY_ID) FROM PS_JPM_JP_ITEMS X WHERE A.JPM_PROFILE_ID = X.JPM_PROFILE_ID AND A.JPM_CAT_TYPE = X.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = X.JPM_CAT_ITEM_ID AND A.EFFDT = X.EFFDT)

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

3 DT_ISSUED Date(10) DATE Issue Date

4 MAJOR_CODE Character(10) VARCHAR2(10) NOT NULL Major Code

5 REVIEW_DT Date(10) DATE NOT NULL Review Date

6 NVQ_REVIEWER Character(11) VARCHAR2(11) NOT NULL Review ID
Prompt Table: PERSON_NAME

7 NVQ_REVIEW_TYP Character(3) VARCHAR2(3) NOT NULL Review Type
BRF=Brief Meeting
MET=Standard Meeting
REQ=Requested
REV=Official Review
Default Value: MET

8 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.

9 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	ACCOMPLISHMENT	Character(8)	VARCHAR2(8) NOT NULL	Accomplishment
3	DT_ISSUED	Date(10)	DATE	Issue Date
4	MAJOR_CODE	Character(10)	VARCHAR2(10) NOT NULL	Major Code
5	REVIEW_DT	Date(10)	DATE NOT NULL	Review Date
6	NVQ_REVIEWER	Character(11)	VARCHAR2(11) NOT NULL	Review ID Prompt Table: PERSON_NAME
7	NVQ_REVIEW_TYP	Character(3)	VARCHAR2(3) NOT NULL	Review Type BRF=Brief Meeting MET=Standard Meeting REQ=Requested REV=Official Review Default Value: MET
8	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.
9	DESCRLONG	Long Character	CLOB	Long Description