CM_ELEMENT_TBL (SQL View)	Index Back
Element Table This table stores information relating to an Element. These include the Satisfaction Method (Training, possession of Licence/Certificate, On the Job Training, Off the Job Training). TITLE is a one sentence description of the Element and DESCRIPTION can be used for a more detailed discussion of the Element including the criteria. Release 9 Job Profile Managment (JPM): Table became a view to JPM data. Ownership of table transferred from HR Core Objects to JPM.

CM_ELEMENT_TBL

(SQL View)

Element Table

This table stores information relating to an Element. These include the Satisfaction Method (Training, possession of Licence/Certificate, On the Job Training, Off the Job Training). TITLE is a one sentence description of the Element and DESCRIPTION can be used for a more detailed discussion of the Element including the criteria. 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) ,EFFDT ,EFF_STATUS ,%Substring(JPM_DESCR90,1,50) ,SATISFACTION_MTHD ,%Substring(JPM_TEXT254_1,1,35) FROM PS_JPM_CAT_ITEMS WHERE JPM_CAT_TYPE IN ('ELEMENT','NVQ ELEMENT')

Related Language Record: CM_ELEMENT_LNG

Parent Record Of CM_ELM_CRITERIA

# 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

5 SATISFACTION_MTHD Character(1) VARCHAR2(1) NOT NULL Satisfaction Method
D=Dispensation Given
F=Off the Job Training
L=Possess Licence/Certificate
O=On the Job Training
R=Recognition of Prior Learning
S=Supervisor Assessment
T=Attend Training Course
Default Value: T

6 TITLE Character(35) VARCHAR2(35) NOT NULL Title

#	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	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
5	SATISFACTION_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Satisfaction Method D=Dispensation Given F=Off the Job Training L=Possess Licence/Certificate O=On the Job Training R=Recognition of Prior Learning S=Supervisor Assessment T=Attend Training Course Default Value: T
6	TITLE	Character(35)	VARCHAR2(35) NOT NULL	Title