CRSE_SESS_RATNG (SQL Table)	Index Back
Training Course Eval Ratings CRSE_SESS_RATNG is one of a group of records used to record data about specific sessions of a training course for the Training Administration application. Use CRSE_SESS_RATNG to record rating totals from student evaluations of the effectiveness of a specific course session. For example, you could set up ratings of Excellent, Good, Fair, and Poor. This record is a subordinate record to CRSE_SESS_RAREA, which identifies the rating areas such as Presentation, Content, and Materials. Used together, you can see complete evaluation results, i.e., the number of students who rated Presentation as Excellent, Good, Fair, or Poor. Weighted averages are also calculated rating area and by session. You can create multiple CRSE_SESS_RATNG records per course rating area, each with a unique rating code.

CRSE_SESS_RATNG

(SQL Table)

Training Course Eval Ratings

CRSE_SESS_RATNG is one of a group of records used to record data about specific sessions of a training course for the Training Administration application. Use CRSE_SESS_RATNG to record rating totals from student evaluations of the effectiveness of a specific course session. For example, you could set up ratings of Excellent, Good, Fair, and Poor. This record is a subordinate record to CRSE_SESS_RAREA, which identifies the rating areas such as Presentation, Content, and Materials. Used together, you can see complete evaluation results, i.e., the number of students who rated Presentation as Excellent, Good, Fair, or Poor. Weighted averages are also calculated rating area and by session. You can create multiple CRSE_SESS_RATNG records per course rating area, each with a unique rating code.

Parent record: CRSE_SESS_RAREA

# 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 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr
Prompt Table: CRSE_SESSN_TBL

3 RATING_AREA Character(2) VARCHAR2(2) NOT NULL Rating Area
CO=Content
FC=Facility
IN=Instructors
MA=Materials
PR=Presentation

4 COURSE_RATING Character(1) VARCHAR2(1) NOT NULL Rating
1=Excellent
2=Good
3=Fair
4=Poor

5 AREA_RATING_COUNT Number(3,0) SMALLINT NOT NULL Total Count

#	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	SESSION_NBR	Character(4)	VARCHAR2(4) NOT NULL	Course Session Nbr Prompt Table: CRSE_SESSN_TBL
3	RATING_AREA	Character(2)	VARCHAR2(2) NOT NULL	Rating Area CO=Content FC=Facility IN=Instructors MA=Materials PR=Presentation
4	COURSE_RATING	Character(1)	VARCHAR2(1) NOT NULL	Rating 1=Excellent 2=Good 3=Fair 4=Poor
5	AREA_RATING_COUNT	Number(3,0)	SMALLINT NOT NULL	Total Count