COURSE_COMPS (SQL Table)	Index Back
Course Goal-Competency COURSE_COMPS store the competencies, and their associated proficiency levels, that are associated with a particular training course and whether or not the competency is granted to the employee upon completion of the training course.

COURSE_COMPS

(SQL Table)

Course Goal-Competency

COURSE_COMPS store the competencies, and their associated proficiency levels, that are associated with a particular training course and whether or not the competency is granted to the employee upon completion of the training course.

Parent record: COURSE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code
Prompt Table: COURSE_TBL

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

3 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency
Prompt Table: REVW_RATING_TBL

4 GRANT_TO_EE Character(1) VARCHAR2(1) NOT NULL Assign to EE after course
Y/N Table Edit
Default Value: Y

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COURSE	Character(6)	VARCHAR2(6) NOT NULL	Course Code Prompt Table: COURSE_TBL
2	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency Prompt Table: COMPETENCY_TBL
3	PROFICIENCY	Character(1)	VARCHAR2(1) NOT NULL	Proficiency Prompt Table: REVW_RATING_TBL
4	GRANT_TO_EE	Character(1)	VARCHAR2(1) NOT NULL	Assign to EE after course Y/N Table Edit Default Value: Y