NVQ_UNITS_REQ (SQL View)	Index Back
Units required for NVQ This UK specific table shows the units that make up an NVQ. Release 9 Job Profile Managment (JPM): Table became a view to JPM data. Ownership of table transferred from Human Resources to JPM.

NVQ_UNITS_REQ

(SQL View)

Units required for NVQ

This UK specific table shows the units that make up an NVQ. Release 9 Job Profile Managment (JPM): Table became a view to JPM data. Ownership of table transferred from Human Resources to JPM.

SELECT %Substring(A.JPM_CAT_ITEM_ID,1,8) ,%Substring(A.JPM_CAT_ITEM_ID2,1,8) ,1 ,JPM_MANDATORY FROM PS_JPM_CAT_I_RLAT A WHERE A.JPM_CAT_TYPE = 'NVQ' AND A.JPM_CAT_TYPE2 = 'NVQ UNIT' AND A.JPM_EFFDT = ( SELECT MAX(C.JPM_EFFDT) FROM PS_JPM_CAT_I_RLAT C WHERE C.JPM_CAT_TYPE = 'NVQ' AND C.JPM_CAT_TYPE2 = 'NVQ UNIT' AND C.JPM_CAT_TYPE = A.JPM_CAT_TYPE AND C.JPM_CAT_ITEM_ID = A.JPM_CAT_ITEM_ID AND C.JPM_CAT_ITEM_ID2 = A.JPM_CAT_ITEM_ID2 AND C.JPM_EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
Prompt Table: NVQ_COMP_SRCH

3 UNIT_NBR Number(2,0) SMALLINT NOT NULL Number

4 UNIT_OPTIONAL Character(1) VARCHAR2(1) NOT NULL Optional Unit Flag
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACCOMPLISHMENT	Character(8)	VARCHAR2(8) NOT NULL	Accomplishment
2	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency Prompt Table: NVQ_COMP_SRCH
3	UNIT_NBR	Number(2,0)	SMALLINT NOT NULL	Number
4	UNIT_OPTIONAL	Character(1)	VARCHAR2(1) NOT NULL	Optional Unit Flag Y/N Table Edit Default Value: N