GVT_JCOD_FCT (SQL Table)	Index Back
Job Code Factors This table was created for HR Federal. It is used to define the classification factors and level for each factor.

GVT_JCOD_FCT

(SQL Table)

Job Code Factors

This table was created for HR Federal. It is used to define the classification factors and level for each factor.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: JOBCODE_TBL.EFFDT

3 GVT_CLS_FACTOR Character(2) VARCHAR2(2) NOT NULL Classification Factor
01=Knowledge Required
02=Supervisory Controls
03=Guidelines
04=Complexity
05=Scope and Effect
06=Personal Contacts
07=Purpose of Contacts
08=Physical Demands
09=Work Environment
10=Supervisory Difficulty&Scope
11=Supv Authority&Responsibility
12=Degree Supervision Exercised
13=Program Management
Prompt Table: GVT_CLS_FCTR_TB

4 GVT_CLS_LEVEL Character(1) VARCHAR2(1) NOT NULL Classification Factor Level
Prompt Table: GVT_CLS_LVL_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: JOBCODE_TBL.EFFDT
3	GVT_CLS_FACTOR	Character(2)	VARCHAR2(2) NOT NULL	Classification Factor 01=Knowledge Required 02=Supervisory Controls 03=Guidelines 04=Complexity 05=Scope and Effect 06=Personal Contacts 07=Purpose of Contacts 08=Physical Demands 09=Work Environment 10=Supervisory Difficulty&Scope 11=Supv Authority&Responsibility 12=Degree Supervision Exercised 13=Program Management Prompt Table: GVT_CLS_FCTR_TB
4	GVT_CLS_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Classification Factor Level Prompt Table: GVT_CLS_LVL_TBL