CM_ELM_CRITERIA (SQL View)	Index Back
Element criteria table This table stores criteria codes for which an element will be judged. Release 9 Job Profile Managment (JPM): Table became a view to JPM data. Ownership of table transferred from HR Core Objects to JPM.

CM_ELM_CRITERIA

(SQL View)

Element criteria table

This table stores criteria codes for which an element will be judged. Release 9 Job Profile Managment (JPM): Table became a view to JPM data. Ownership of table transferred from HR Core Objects to JPM.

SELECT %Substring(JPM_CAT_ITEM_ID,1,10) ,JPM_EFFDT ,%Substring(JPM_CAT_ITEM_ID2,1,7) FROM PS_JPM_CAT_I_RLAT WHERE JPM_CAT_TYPE IN ('ELEMENT', 'NVQ ELEMENT') AND JPM_CAT_TYPE2 = 'CRITERIA' AND JPM_CAT_RLAT_CD = 'P'

Parent record: CM_ELEMENT_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ELEMENT_CD Character(10) VARCHAR2(10) NOT NULL Element code

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

3 CRITERIA_CD Character(7) VARCHAR2(7) NOT NULL Criteria code
Prompt Table: CM_CRITERIA_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ELEMENT_CD	Character(10)	VARCHAR2(10) NOT NULL	Element code
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	CRITERIA_CD	Character(7)	VARCHAR2(7) NOT NULL	Criteria code Prompt Table: CM_CRITERIA_TBL