GVT_SF182_EVAL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: TRAINING.EMPLID Prompt Table: PERSON
2	COURSE_START_DT	Date(10)	DATE	Course Start Date Default Value: TRAINING.COURSE_START_DT
3	COURSE	Character(6)	VARCHAR2(6) NOT NULL	Course Code Default Value: TRAINING.COURSE Prompt Table: COURSE_TBL
4	SESSION_NBR	Character(4)	VARCHAR2(4) NOT NULL	Course Session Nbr Default Value: TRAINING.SESSION_NBR Prompt Table: CRSE_SESSN_TBL
5	COURSE_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Course Title Default Value: TRAINING.COURSE_TITLE
6	GVT_TRNG_REQNUM	Character(20)	VARCHAR2(20) NOT NULL	Training Request Number Default Value: TRAINING.GVT_TRNG_REQNUM Prompt Table: TRAINING
7	GVT_ACTDUTYHRS	Number(3,0)	SMALLINT NOT NULL	Duty Hours
8	GVT_ACTENDDT	Date(10)	DATE	Actual Course End Date
9	GVT_ACTNONDUTYHRS	Number(3,0)	SMALLINT NOT NULL	Actual Non-Duty Hours
10	GVT_ACTSTARTDT	Date(10)	DATE	Actual Course Start Date
11	GVT_ALLSESSATTEND	Character(1)	VARCHAR2(1) NOT NULL	All Sessions Attended Y/N Table Edit Default Value: Y
12	GVT_ALLSESSATTEXP	Character(200)	VARCHAR2(200) NOT NULL	All Sessions not Attended Expl
13	GVT_COURSECOMPLETE	Character(1)	VARCHAR2(1) NOT NULL	Course was Completed Y/N Table Edit Default Value: Y
14	GVT_DISCUSSWTHEMPL	Character(1)	VARCHAR2(1) NOT NULL	Discussed Course with Employee Y/N Table Edit Default Value: N
15	GVT_GRADESCORE	Character(4)	VARCHAR2(4) NOT NULL	Academic Grade/Score
16	GVT_QUESTION26	Character(1)	VARCHAR2(1) NOT NULL	Stated Objective Accomplished A=Yes B=Partially C=No
17	GVT_QUESTION27	Character(1)	VARCHAR2(1) NOT NULL	Coverage of Subject Matter A=Excellent B=Adequate C=Poor
18	GVT_QUESTION28	Character(1)	VARCHAR2(1) NOT NULL	Organization of Subject Matter A=Well Organized B=Adequate C=Poorly Organized
19	GVT_QUESTION29	Character(1)	VARCHAR2(1) NOT NULL	Suitability of Instr Materials A=Well Suited B=Adequate C=Poorly Suited
20	GVT_QUESTION30	Character(1)	VARCHAR2(1) NOT NULL	Level of Difficulty A=Too Advanced B=Appropriate C=Too Elementary
21	GVT_QUESTION31	Character(1)	VARCHAR2(1) NOT NULL	Length of Course A=Too Long B=Appropriate C=Too Short
22	GVT_QUESTION32	Character(1)	VARCHAR2(1) NOT NULL	Amt of Outside or Evening Work A=Too Much B=Appropriate C=Insufficient
23	GVT_QUESTION33	Character(1)	VARCHAR2(1) NOT NULL	Effectiveness of Instructors A=Excellent B=Good C=Poor
24	GVT_QUESTION34	Character(1)	VARCHAR2(1) NOT NULL	Appl of Subject Matter to Work A=Significant B=Adequate C=Insignificant
25	GVT_QUESTION35	Character(1)	VARCHAR2(1) NOT NULL	Facilities A=Excellent B=Good C=Poor
26	GVT_QUESTION36	Character(1)	VARCHAR2(1) NOT NULL	Recommendations to Colleagues A=Highly Recommend B=Recommend C=Not Recommend
27	GVT_QUESTION37	Character(1)	VARCHAR2(1) NOT NULL	Meet Career Development Plans A=Yes B=No C=Not Applicable
28	GVT_QUESTION38	Character(200)	VARCHAR2(200) NOT NULL	Comments on Strong Points
29	GVT_QUESTION39	Character(200)	VARCHAR2(200) NOT NULL	Comments on Weak Points
30	GVT_QUESTION40	Character(200)	VARCHAR2(200) NOT NULL	Were Your Objectives Met?
31	GVT_QUESTION41	Character(200)	VARCHAR2(200) NOT NULL	You Would Recommend Course to
32	GVT_QUESTION42	Character(200)	VARCHAR2(200) NOT NULL	Additional Comments
33	GVT_SUPADDCOMMENTS	Character(200)	VARCHAR2(200) NOT NULL	Supervisor Additional Comments
34	GVT_SUPERVISOR_DT	Date(10)	DATE	Date Completed by Supervisor
35	GVT_SUPROBJS	Character(200)	VARCHAR2(200) NOT NULL	What were Your Obj for Empl
36	GVT_SUPROBJSMEET	Character(200)	VARCHAR2(200) NOT NULL	Were Objs for Trng Achieved
37	GVT_TRAINEE_DT	Date(10)	DATE	Date Completed by Trainee
38	APPR_INSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Unique number for each runtime occurrence of a virtual approver process
39	APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval status flag used on appr_inst_log and derived records to track virtual approver status A=Approved D=Denied P=Pending Default Value: P