CM_CMP_NONCR_VW (SQL View)	Index Back
Non Course Target Competencies Used by the Manage Competencies Module for target competencies for courses that are not in the Course Table

CM_CMP_NONCR_VW

(SQL View)

Non Course Target Competencies

Used by the Manage Competencies Module for target competencies for courses that are not in the Course Table

SELECT COMPETENCY ,COURSE FROM PS_NON_CRSE_COMPS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
Prompt Table: COMPETENCY_TBL

2 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency Prompt Table: COMPETENCY_TBL
2	COURSE	Character(6)	VARCHAR2(6) NOT NULL	Course Code